/** * Display the message history. * * @return \Illuminate\Http\Response */ public function showmessages() { $input = Request::all(); $conv1 = Conversation::where('id', Input::get('conversation_id'))->first(); $conv2 = Conversation::where('user1_id', '=', $conv1->user2_id)->where('user2_id', '=', $conv1->user1_id)->first(); $messages1 = Message::where('conversation_id', $conv1->id)->get(); $messages2 = Message::where('conversation_id', $conv2->id)->get(); $messages = $messages1->merge($messages2); $data['user1_id'] = $conv1->user1_id; $data['user2_id'] = $conv1->user2_id; $data['user1_accountname'] = $conv1->user1_accountname; $data['user2_accountname'] = $conv1->user2_accountname; $data['conversation_id'] = $conv1->id; $data['conversation2_id'] = $conv2->id; $data['messages'] = $messages->sortBy('created_at')->values(); return json_encode($data); }
public function getunseen() { $accountname = Input::get('accountname'); $conversations = Conversation::where('user1_accountname', $accountname)->get(); $unseen = 0; foreach ($conversations as $key => $conversation) { $unseen += $conversation->unseen; } return json_encode($unseen); }
public function index() { $userId = \Auth::user()->id; $conversation = Conversation::where('user_one', '=', $userId)->or()->where('user_two', '=', $userId)->orderBy('updated_at', 'DESC')->get(); return view('message.index', compact('conversation')); }