public function refresh() { $count = Message::where('id_receive', \Auth::user()->id)->where('read', NULL)->count(); if ($count) { return $count; } }
/** * Despliega el listado de mensajes nuevos * * @return \Illuminate\Http\Response */ public function index() { /* Selecciona los mensajes que no han sido vistos del mas reciente al mas antiguo*/ $messages = Message::where('seen', '=', 'false')->latest()->get(); /* retorna vista con los mensajes que no han sido vistos */ return view('adminmessages.index')->with('messages', $messages); }
public function getConversation($id) { $_messages = Message::where(['conversation_id' => $id])->orderBy('updated_at', 'desc')->get(); $_conversation = Conversation::find($id); $messages = collect(); foreach ($_messages as $_message) { $sender = User::find($_message->author_id); $message = array(); $message['author_id'] = $_message->author_id; $message['body'] = $_message->body; $message['author_name'] = $sender->name; $message['author_surname'] = $sender->surname; $message['timestamp'] = $sender->updated_at; $messages->push($message); } $conversation_name = ""; if ($_conversation->title == "") { $conversation_name = ConversationsController::getUsersString($id); $_conversation->save(); } else { $conversation_name = $_conversation->title; } $user = User::find(Auth::id()); $unreadNotifications = $user->notifications()->unread()->get()->count(); $notifications = $user->notifications()->get(); return view('conversations.conversation')->with(['messages' => $messages, 'conversation_name' => $conversation_name, 'id' => $id, 'new_notifications_count' => $user->notifications()->unread()->not_type('message')->get()->count(), 'notifications' => $user->notifications()->not_type('message')->get(), 'new_messagesNotifications_count' => $user->notifications()->unread()->type('message')->get()->count(), 'messagesNotifications' => $user->notifications()->type('message')->get()]); }
/** * Display a listing of the resource. * * @return Response */ public function index() { if (!Auth::check()) { return Redirect::to('/login'); } $messages = Message::where('receiver_id', Auth::user()->id)->orderBy('created_at', 'desc')->get(); return view('inbox', ['messages' => $messages]); }
public function show(Request $request, $user) { $messages = Message::where(['from' => Auth::user()->id, 'to' => $user])->orWhere(['to' => Auth::user()->id, 'from' => $user])->orderBy('id', 'DESC')->paginate(30); $messages = $this->sortMessages($messages); $data['messages'] = $messages; $data['receiver'] = $user; return view('messages.show', $data); }
public function show($id) { (new Message())->readOpenMessage($id); $messages = Message::where('dialog_id', $id)->orderBy('created_at', 'desc')->get(); $user_id = Dialog::where('total', $id)->where('user_id', '!=', \Auth::user()->id)->first()->user_id; $sender = User::find($user_id); return view('show', ['messages' => $messages, 'sender' => $sender, 'id' => $id]); }
/** * Despliega la interfaz para el dashboard * * @return \Illuminate\Http\Response */ public function dashboard() { /* Selecciona todos los mensajes de la tabla messages que no han sido vistos */ $newMgs = Message::where('seen', '=', 'false')->get(); /* Obtiene el número de mensajes que no han sido vistos */ $quantity = count($newMgs); /* retorno la vista del dashboard, con el número de mensajes nuevos */ return view('pages.dashboard')->with('quantity', $quantity); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function getSend(User $user) { $this->authorize('sendMessage', $user); $readMessages = Message::where('receiver_id', \Auth::user()->id)->where('user_id', $user->id)->where('type', false)->orderBy('created_at', 'desc')->get(); foreach ($readMessages as $message) { $message->is_read = true; $message->save(); } $messages = Message::where('receiver_id', \Auth::user()->id)->where('user_id', $user->id)->where('type', false)->orderBy('created_at', 'desc')->paginate(3); return view('message.send', compact('user', 'messages')); }
public function searchTickets() { //str replace to fix an edge case - a user wants to search for a literal % $query = str_replace('%', '\\%', Input::get('query')); //collect tickets from various places matched by the search $tickets = Ticket::where('subject', 'like', "%{$query}%")->get()->merge(Message::where('text', 'like', "%{$query}%")->get()->map(function ($message) { return $message->ticket; }))->unique()->filter(function ($ticket) { return Gate::allows('view-ticket', $ticket); }); return view("helpdesk/searchResults", compact('tickets')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // get all the message for this user $logged_user_id = Auth::user()->id; $messages = Message::where('receiver_user_id', $logged_user_id)->get(); $query = "SELECT m.id, m.sender_user_id, m.receiver_user_id, m.message_content, m.created_at, u.name "; $query .= "FROM message m, users u "; $query .= "WHERE receiver_user_id = " . $logged_user_id . " and u.id = m.sender_user_id "; $query .= "ORDER BY created_at DESC "; $messages = DB::select(DB::raw($query)); // load the view and pass the jobs return View::make('messaging.index')->with('messages', $messages); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $book = Book::findorFail($id); $message = Message::where('book_id', '=', $id)->take(10)->get(); if (!Auth::check()) { $user_id = 1; } else { $user_id = Auth::user()->id; } if (is_null($book)) { abort(404); } return view('books.show', compact('book', 'user_id', 'message')); }
/** * Add/Edit the message. * * @param number $id * @return number */ public function save($id) { $person = Request::input('person'); $text = Request::input('message'); if ($id == 0) { $message = new Message(); $message->person = $person; $message->message = $text; return (int) $message->save(); } else { return (int) Message::where('id', $id)->update(array('message' => $text)); } return 0; }
private function hasNewMessages() { $messages = Message::where(['to' => Auth::user()->id, 'read' => 0])->get(); if ($messages->count() <= 0) { return false; } else { foreach ($messages as $message) { $message->update(['read' => 1]); $u = $message->user()->first(); $avatar = $u->getProfilePictureUrl(); $data[] = array_merge($message->toArray(), ['user' => $u->toArray(), 'xhr' => route('message', $u['id']), 'avatar_url' => $avatar]); } $this->messages = $data; return true; } }
/** * Bootstrap any application services. * * @return void */ public function boot() { \Carbon\Carbon::setLocale('zh'); //默认'en' View()->composer('*', function ($view) { $navMessages = Message::where(['isread' => 0])->get(); $type0 = Message::where(['isread' => 0, 'type' => 0])->count(); $type1 = Message::where(['isread' => 0, 'type' => 1])->count(); $type2 = Message::where(['isread' => 0, 'type' => 2])->count(); $type3 = Message::where(['isread' => 0, 'type' => 3])->count(); view()->share('navMessages', $navMessages); view()->share('type0', $type0); view()->share('type1', $type1); view()->share('type2', $type2); view()->share('type3', $type3); }); }
public function __construct() { /*Licznik zmian, który zmienia się po 24h od dodania zmiany*/ $date = Carbon::now(); $date->modify('-24 hours'); $formatted_date = $date->format('Y-m-d H:i:s'); $countchange = Change::where('created_at', '>', $formatted_date)->count(); /*Licznik graczy Online na serwerze*/ $countonline = Player::where('online', '=', 1)->count(); /*Licznik niedoczytanych wiadomości prywatnych*/ $notread1 = Message::where('to_user_id', \Auth::id())->where('read', 0)->count(); if (\Auth::check()) { Cache::remember('users', 5, function () { return User::where('id', \Auth::id())->update(['last_activity' => Carbon::now()]); }); } /*Licznik i skrypt usuwający i nadający banicję za 4 ostrzeżenia na stronie*/ $countcautions = Caution::where('user_id', \Auth::id())->count(); if (!\Auth::guest() && $countcautions == 4) { $user = User::where('id', \Auth::id())->first(); $g = array(4); $user->update(['banned' => 'Zbanowany za 4 ostrzeżenia na stronie']); $user->group()->sync($g); } $deleteCaution = Caution::where('user_id', \Auth::id())->where('created_at', '<=', Carbon::now()->subDays(14)); $deleteCaution->delete(); $section = Section::lists('name', 'id'); $lives = Live::latest('created_at')->take(5)->get(); if (!\Auth::guest()) { $notifications = \Auth::user()->notification()->latest('created_at')->take(10)->get(); View::share('notifications', $notifications); } View::share('countchange', $countchange); View::share('countonline', $countonline); View::share('notread1', $notread1); View::share('section', $section); View::share('lives', $lives); $this->middleware('banned', ['except' => ['auth']]); }
/** * Define your route model bindings, pattern filters, etc. * * @param \Illuminate\Routing\Router $router * @return void */ public function boot(Router $router) { parent::boot($router); $router->bind('articles', function ($slug) { return \Route::currentRouteName() == "articles.edit" ? \App\Article::findOrFail($slug) : \App\Article::published()->findOrFail($slug); }); $router->bind('news', function ($id) { return \Route::currentRouteName() == "news.edit" ? \App\News::findOrFail($id) : \App\News::published()->findOrFail($id); }); $router->bind('tags', function ($name) { return \App\Tag::where('name', $name)->firstOrFail(); }); $router->bind('users', function ($id) { return \App\User::where('id', $id)->firstOrFail(); }); $router->bind('messages', function ($id) { return \App\Message::where('id', $id)->firstOrFail(); }); $router->bind('registrants', function ($id) { return \App\Registrant::where('id', $id)->firstOrFail(); }); $router->model('image', Image::class); }
public function GetLastMessages($nb = -1, $idPrevious = 0) { if ($nb <= 0) { if ($idPrevious > 0) { $messages = Message::where('id', '<', $idPrevious)->orderBy('id', 'desc')->get(); } else { $messages = Message::orderBy('id', 'desc')->get(); } } else { if ($idPrevious > 0) { $messages = Message::where('id', '<', $idPrevious)->orderBy('id', 'desc')->take($nb)->get(); } else { $messages = Message::orderBy('id', 'desc')->take($nb)->get(); } } $last = true; if (count($messages) > 0) { $lol = $messages[count($messages) - 1]; if (Message::where('id', '<', $lol->id)->count() > 0) { $last = false; } } return view('front.minichat.messages', array('messages' => $messages, 'isLast' => $last)); }
public function delMessage(Request $request) { $r = Message::where('id', $request->get('id'))->delete(); if ($r) { $this->succeed(true); } else { $this->fail(true); } }
/** * Return a list of messages that have been accepted * */ public function acceptedMessages(Request $request) { $per_page = $request->has('per_page') ? $request->get('per_page') : 10; $before_time = $request->has('before') ? $request->get('before') : Carbon::now()->format('Y-m-d H:i:s'); $messages = Message::where('accepted', 1)->where('created_at', '<', $before_time)->orderBy('created_at', 'desc')->simplePaginate($per_page); $messages->appends(['per_page' => $per_page]); return response()->json(["data" => $messages]); }
public function sent() { $sentMessages = Message::where('sender', \Auth::user()->id)->get(); $dataView = ['sentMessages' => $sentMessages]; return view('mr.inbox.sent', $dataView); }
/** * Collection of all message either send or received by this user * * @return mixed */ public function allMessages() { return Message::where('sender_id', $this->id)->orWhere('receiver_id', $this->id); }
/** * Bootstrap any application services. * * @return void */ public function boot() { if (\Schema::hasTable('positions')) { $positions = Position::all(); $selectPositions = array(); $selectPositions[0] = "Select / All"; foreach ($positions as $position) { $selectPositions[$position->slug] = $position->name; } \View::share('selectPositions', $selectPositions); } if (\Schema::hasTable('cases_priorities')) { $priorities = CasePriority::all(); $selectPriorities = array(); $selectPriorities[0] = "Select / All"; foreach ($priorities as $priority) { $selectPriorities[$priority->slug] = $priority->name; } \View::share('selectPriorities', $selectPriorities); } if (\Schema::hasTable('titles')) { $titles = Title::all(); $selectTitles = array(); $selectTitles[0] = "Select / All"; foreach ($titles as $title) { $selectTitles[$title->slug] = $title->name; } \View::share('selectTitles', $selectTitles); } if (\Schema::hasTable('languages')) { $languages = Language::all(); $selectLanguages = array(); $selectLanguages[0] = "Select / All"; foreach ($languages as $language) { $selectLanguages[$language->slug] = $language->name; } \View::share('selectLanguages', $selectLanguages); } if (\Schema::hasTable('departments')) { $departments = Department::all(); $selectDepartments = array(); $selectDepartments[0] = "Select / All"; foreach ($departments as $department) { $selectDepartments[$department->slug] = $department->name; } \View::share('selectDepartments', $selectDepartments); } if (\Schema::hasTable('users_roles')) { $roles = UserRole::all(); $selectRoles = array(); $selectRoles[0] = "Select / All"; foreach ($roles as $role) { $selectRoles[$role->slug] = $role->name; } \View::share('selectRoles', $selectRoles); } if (\Schema::hasTable('provinces')) { $provinces = Province::all(); $selectProvinces = array(); $selectProvinces[0] = "Select / All"; foreach ($provinces as $Province) { $selectProvinces[$Province->slug] = $Province->name; } \View::share('selectProvinces', $selectProvinces); } if (\Schema::hasTable('districts')) { $districts = District::all(); $selectDistrict = array(); $selectDistricts[0] = "Select / All"; foreach ($districts as $district) { $selectDistricts[$district->slug] = $district->name; } \View::share('selectDistricts', $selectDistricts); } if (\Schema::hasTable('municipalities')) { $municipalities = Municipality::all(); $selectMunicipalities = array(); $selectMunicipalities[0] = "Select / All"; foreach ($municipalities as $municipality) { $selectMunicipalities[$municipality->slug] = $municipality->name; } \View::share('selectMunicipalities', $selectMunicipalities); } if (\Schema::hasTable('wards')) { $wards = Ward::all(); $selectWards = array(); $selectWards[0] = "Select / All"; foreach ($wards as $ward) { $selectWards[$ward->slug] = $ward->name; } \View::share('selectWards', $selectWards); } if (\Schema::hasTable('categories')) { $categories = Category::all(); $selectCategories = array(); $selectCategories[0] = "Select / All"; foreach ($categories as $category) { $selectCategories[$category->slug] = $category->name; } \View::share('selectCategories', $selectCategories); } if (\Schema::hasTable('sub_categories')) { $subCategories = SubCategory::all(); $selectSubCategories = array(); $selectSubCategories[0] = "Select / All"; foreach ($subCategories as $subCategory) { $selectSubCategories[$subCategory->slug] = $subCategory->name; } \View::share('selectSubCategories', $selectSubCategories); } if (\Schema::hasTable('sub_sub_categories')) { $subSubCategories = SubSubCategory::all(); $selectSubSubCategories = array(); $selectSubSubCategories[0] = "Select / All"; foreach ($subSubCategories as $subSubCategory) { $selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name; } \View::share('selectSubSubCategories', $selectSubSubCategories); } if (\Schema::hasTable('relationships')) { $relationships = Relationship::all(); $selectRelationships = array(); $selectRelationships[0] = "Select / All"; foreach ($relationships as $relationship) { $selectRelationships[$relationship->id] = $relationship->name; } \View::share('selectRelationships', $selectRelationships); } if (\Schema::hasTable('cases')) { $cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`first_name`, ' ', `surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get(); $reporters = array(); $reporters[0] = "Select / All"; foreach ($cases as $case) { $reporters[$case->reporterName] = $case->reporterName; } \View::share('selectReporters', $reporters); } View()->composer('master', function ($view) { $view->with('addressBookNumber', addressbook::all()); if (\Auth::check()) { $number = addressbook::where('user', '=', \Auth::user()->id)->get(); $view->with('addressBookNumber', $number); $allUsers = User::where('id', '<>', \Auth::user()->id)->get(); $view->with('loggedInUsers', $allUsers); $noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('message_type', '=', 0)->get(); $view->with('noPrivateMessages', $noPrivateMessages); $noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('message_type', '=', 0)->get(); $view->with('noInboxMessages', $noInboxMessages); $noDepartments = Department::all(); $view->with('noDepartments', $noDepartments); $noUsers = User::all(); $view->with('noUsers', $noUsers); $noRoles = UserRole::all(); $view->with('noRoles', $noRoles); $noPositions = Position::all(); $view->with('noPositions', $noPositions); $noRelationships = Relationship::all(); $view->with('noRelationships', $noRelationships); $noProvinces = Province::all(); $view->with('noProvinces', $noProvinces); $noCaseStatuses = CaseStatus::all(); $view->with('noCaseStatuses', $noCaseStatuses); $userRole = UserRole::where('id', '=', \Auth::user()->role)->first(); $view->with('systemRole', $userRole); $noCasesPriorities = CasePriority::all(); $view->with('noCasesPriorities', $noCasesPriorities); } }); }
public function getMessages() { $messages = Message::where('user_id', Auth::user()->id)->where('archived', 0)->orderBy('created_at', 'DESC')->get(); return json_encode($messages); }
public function messages($school, $subject) { return Message::where('school_id', $school->id)->where('subject', $subject->id)->orderBy('created_at', 'DESC')->get(); }
/** * Bootstrap any application services. * * @return void */ public function boot() { if (\Schema::hasTable('positions')) { $positions = Position::orderBy('name', 'ASC')->get(); $selectPositions = array(); $selectPositions[0] = "Select / All"; foreach ($positions as $position) { $selectPositions[$position->slug] = $position->name; } \View::share('selectPositions', $selectPositions); } if (\Schema::hasTable('departments')) { $departments = Department::orderBy('name', 'ASC')->get(); $selectDepartments = array(); $selectDepartments[0] = "Select / All"; foreach ($departments as $department) { $selectDepartments[$department->slug] = $department->name; } \View::share('selectDepartments', $selectDepartments); } if (\Schema::hasTable('provinces')) { $provinces = Province::all(); $selectProvinces = array(); $selectProvinces[0] = "Select / All"; foreach ($provinces as $Province) { $selectProvinces[$Province->slug] = $Province->name; } \View::share('selectProvinces', $selectProvinces); } if (\Schema::hasTable('districts')) { $districts = District::all(); $selectDistrict = array(); $selectDistricts[0] = "Select / All"; foreach ($districts as $district) { $selectDistricts[$district->slug] = $district->name; } \View::share('selectDistricts', $selectDistricts); } if (\Schema::hasTable('municipalities')) { $municipalities = Municipality::all(); $selectMunicipalities = array(); $selectMunicipalities[0] = "Select / All"; foreach ($municipalities as $municipality) { $selectMunicipalities[$municipality->slug] = $municipality->name; } \View::share('selectMunicipalities', $selectMunicipalities); } if (\Schema::hasTable('categories')) { $categories = Category::all(); $selectCategories = array(); $selectCategories[0] = "Select / All"; foreach ($categories as $category) { $selectCategories[$category->slug] = $category->name; } \View::share('selectCategories', $selectCategories); } if (\Schema::hasTable('sub-categories')) { $subCategories = SubCategory::all(); $selectSubCategories = array(); $selectSubCategories[0] = "Select / All"; foreach ($subCategories as $subCategory) { $selectSubCategories[$subCategory->slug] = $subCategory->name; } \View::share('selectSubCategories', $selectSubCategories); } if (\Schema::hasTable('sub-sub-categories')) { $subSubCategories = SubSubCategory::all(); $selectSubSubCategories = array(); $selectSubSubCategories[0] = "Select / All"; foreach ($subSubCategories as $subSubCategory) { $selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name; } \View::share('selectSubSubCategories', $selectSubSubCategories); } if (\Schema::hasTable('relationships')) { $relationships = Relationship::all(); $selectRelationships = array(); $selectRelationships[0] = "Select / All"; foreach ($relationships as $relationship) { $selectRelationships[$relationship->id] = $relationship->name; } \View::share('selectRelationships', $selectRelationships); } if (\Schema::hasTable('cases')) { $cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get(); $reporters = array(); $reporters[0] = "Select / All"; foreach ($cases as $case) { $reporters[$case->reporterName] = $case->reporterName; } \View::share('selectReporters', $reporters); } View()->composer('master', function ($view) { $view->with('addressBookNumber', addressbook::all()); if (\Auth::check()) { $number = addressbook::where('user', '=', \Auth::user()->id)->get(); $view->with('addressBookNumber', $number); $allUsers = User::where('id', '<>', \Auth::user()->id)->get(); $view->with('loggedInUsers', $allUsers); $noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('online', '=', 0)->get(); $view->with('noPrivateMessages', $noPrivateMessages); $noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->get(); $view->with('noInboxMessages', $noInboxMessages); } }); }
public function historyWithUser($userId) { return Message::where('sender_id', $this->id)->where('recipient_id', $userId)->orWhere('sender_id', $userId)->where('recipient_id', $this->id)->get(); }
public function getJsonMessageListData() { $data = Message::where('deleted_at', null)->get(); return response($data); }
/** * 获取category */ public function category() { $category = Category::get(); $n = count($category); for ($i = 0; $i < $n; ++$i) { $category[$i]->messages_num = Message::where('category', $category[$i]->id)->count(); } return $category; }
$html .= "<div class='media-body'>"; $html .= "<span class='t-overflow p-t-5'>{$user->name} {$user->surname} {$availability}</span>"; $html .= "</div>"; $html .= "</div>"; } return $html; }); /* |-------------------------------------------------------------------------- | CASE MESSAGE ROUTING |-------------------------------------------------------------------------- | */ Route::post('addCaseMessage', ['middleware' => 'auth', 'uses' => 'MessageController@store']); Route::get('/getOfflineMessage', function () { $offlineMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->orderBy('created_at', 'desc')->take(5)->get(); $html = ""; foreach ($offlineMessages as $message) { $user = User::where('id', '=', $message->from)->first(); $read = $message->read == 0 ? "<span class='label label-danger'>New</span>" : ""; $html .= "<div class='media'>"; $html .= "<div class='pull-left'>"; $html .= "<a href='#' onClick='chatStart(this)'> <img class='pull-left' src='img/profile-pics/7.png' width='30' alt=''></a>"; $html .= "</div>"; $html .= "<div class='media-body'>"; $html .= "<small class='text-muted'>{$user->name} {$user->surname} - {$message->created_at}</small> {$read}<br>"; $html .= "<a class='t-overflow' href='message-detail/{$message->id}'>{$message->message} .Ref:Case ID {$message->caseId}</a>"; $html .= "</div>"; $html .= "</div>"; } return $html;
public function indexPage($page) { return App\Message::where('user_id', '=', Auth::id())->orderBy('id', 'desc')->skip(10 * ($page - 1))->take(10)->get(); }