Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static function get_inbox_messages_max_ids($login_user, $searchKey = "", $take = 20, $skip = 0, $sort_by = "") {
- $messages = Message::hasSearch($searchKey)
- ->select(DB::raw('Max(id) as id'),'message_from', 'message_to', 'is_read', 'created_at', 'message_content','post_id','media_file','file_type')
- ->where(function($sql) use($login_user) {
- $sql->where('message_to', '=', $login_user);
- $sql->orWhere('message_from', '=', $login_user);
- })
- ->where(function($sql) use($login_user) {
- $sql->where('delete_one', '<>', $login_user);
- $sql->orWhere('delete_two', '<>', $login_user);
- })->groupBy(DB::raw('GREATEST(messages.message_to, messages.message_from), LEAST(messages.message_to, messages.message_from) '))
- ->orderBy('id', 'DESC')->take($take)->skip($skip)->get();
- return (!empty($messages) && count($messages) > 0) ? $messages->toArray() : array();
- }
Add Comment
Please, Sign In to add comment