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));
}
