public function get(Request $request) { if ($request->session()->has('uid') == false) { return response()->json(['error' => 'Access denied'], 403, ['Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Credentials' => 'true']); } $messages = Messages::select(['messages.*', 'messages.id as mid', 'users.id as user_id', 'users.avatar as avatar', 'users.nickname as nickname'])->leftJoin('users', 'users.id', '=', 'messages.user_id')->orderBy('id', 'DESC')->limit(20)->skip($request->get('skip', 0))->get()->toArray(); $user = User::where('id', $request->session()->get('uid'))->first(); if (!$user) { exit; } $nickname = $user->nickname; foreach ($messages as $k => $m) { if ($m['nickname'] == $nickname) { $messages[$k]['position'] = 'right'; } else { $messages[$k]['position'] = 'left'; } $format = 'H:i:s'; $today = date('d'); $messageDay = date('d', strtotime($m['created_at'])); if ($today != $messageDay) { $format = $format . ' d.m.y'; } $messages[$k]['date'] = date($format, strtotime($m['created_at'])); } return response()->json($messages, 200, ['Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Credentials' => 'true']); }
public function get(Request $request) { $messages = Messages::select(['users.avatar', 'users.nickname', 'users.id as user_id', 'messages.message', 'messages.created_at'])->leftJoin('users', 'messages.user_id', '=', 'users.id')->orderBy('messages.id', 'DESC')->limit(30)->get()->toArray(); foreach ($messages as $key => $msg) { $messages[$key]['created_at'] = Helper::getGoodDate($msg['created_at']); } $this->user->last_seen = Carbon::now()->toDateTimeString(); $this->user->save(); return response()->json(array_reverse($messages)); }