Guest User

Untitled

a guest
Jan 19th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. public static function get_inbox_messages_max_ids($login_user, $searchKey = "", $take = 20, $skip = 0, $sort_by = "") {
  2.  
  3. $messages = Message::hasSearch($searchKey)
  4. ->select(DB::raw('Max(id) as id'),'message_from', 'message_to', 'is_read', 'created_at', 'message_content','post_id','media_file','file_type')
  5. ->where(function($sql) use($login_user) {
  6. $sql->where('message_to', '=', $login_user);
  7. $sql->orWhere('message_from', '=', $login_user);
  8. })
  9. ->where(function($sql) use($login_user) {
  10. $sql->where('delete_one', '<>', $login_user);
  11. $sql->orWhere('delete_two', '<>', $login_user);
  12. })->groupBy(DB::raw('GREATEST(messages.message_to, messages.message_from), LEAST(messages.message_to, messages.message_from) '))
  13. ->orderBy('id', 'DESC')->take($take)->skip($skip)->get();
  14. return (!empty($messages) && count($messages) > 0) ? $messages->toArray() : array();
  15. }
Add Comment
Please, Sign In to add comment