public function search(Request $request) { if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Danhsach == 1) { $userid = Auth::user()->id; $query = $request->input('query'); $sents = Mymail::join('mail_user_sends', 'mails.id', '=', 'mail_user_sends.mail_id')->where('mail_user_sends.user_id', $userid)->whereNull('mails.deleted_at')->where('subject', 'like', "%{$query}%")->orWhere(function ($que) use($userid, $query) { $que->where('mail_user_sends.user_id', '=', $userid)->whereNull('mails.deleted_at')->where('message', 'like', "%{$query}%"); })->orderBy('mail_user_sends.created_at', 'desc')->paginate(10); return view('thudi.index')->with(array('menus' => $this->menus, 'sents' => $sents, 'rolechucnangs' => $this->rolechucnangs)); } else { return \Redirect::route('thudi.index')->with('message-error', 'Không có quyền truy cập'); } }
public static function getmailunread($userid) { $mails = Mymail::join('mail_users', 'mails.id', '=', 'mail_users.mail_id')->where('mail_users.user_id', $userid)->whereNull('mails.deleted_at')->whereNull('mail_users.readed')->select('mails.id', 'mails.subject', 'mails.message', 'mails.draf', 'mails.nguoigui_id', 'mails.created_at as ngaygui', 'mail_users.mail_id', 'mail_users.user_id', 'mail_users.readed')->orderBy('ngaygui', 'desc')->take(5)->get(); return $mails; }
public function search() { if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Danhsach == 1) { $userid = Auth::user()->id; $query = \Input::get('query'); $mails = Mymail::join('mail_users', 'mails.id', '=', 'mail_users.mail_id')->where('mail_users.user_id', $userid)->whereNull('mails.deleted_at')->where('subject', 'like', "%{$query}%")->orWhere(function ($que) use($userid, $query) { $que->where('mail_users.user_id', '=', $userid)->whereNull('mails.deleted_at')->where('message', 'like', "%{$query}%"); })->select('mails.id', 'mails.subject', 'mails.message', 'mails.draf', 'mails.nguoigui_id', 'mails.created_at as ngaygui', 'mail_users.mail_id', 'mail_users.user_id', 'mail_users.readed')->orderBy('ngaygui', 'desc')->paginate(10); $readed = Mymail::join('mail_users', 'mails.id', '=', 'mail_users.mail_id')->where('mail_users.user_id', $userid)->whereNull('mails.deleted_at')->whereNull('mail_users.readed')->count(); $sents = Mymail::where('nguoigui_id', $userid)->orderBy('created_at', 'desc')->paginate(10); $drafs = Mymail::where('nguoigui_id', $userid)->where('draf', 1)->orderBy('created_at')->paginate(10); return view('thuden.index')->with(array('menus' => $this->menus, 'mails' => $mails, 'readed' => $readed, 'sents' => $sents, 'drafs' => $drafs, 'rolechucnangs' => $this->rolechucnangs)); } else { return \Redirect::to('/')->with('message-error', 'Không có quyền truy cập'); } }
public function search() { $userid = Auth::user()->id; $query = \Input::get('query'); $mails = Mymail::join('mail_users', 'mails.id', '=', 'mail_users.mail_id')->where('mail_users.user_id', $userid)->whereNull('mails.deleted_at')->where('subject', 'like', "%{$query}%")->orWhere(function ($que) use($userid, $query) { $que->where('mail_users.user_id', '=', $userid)->whereNull('mails.deleted_at')->where('message', 'like', "%{$query}%"); })->select('mails.id', 'mails.subject', 'mails.message', 'mails.draf', 'mails.nguoigui_id', 'mails.created_at as ngaygui', 'mail_users.mail_id', 'mail_users.user_id', 'mail_users.readed')->orderBy('ngaygui', 'desc')->paginate(10); $readed = Mymail::join('mail_users', 'mails.id', '=', 'mail_users.mail_id')->where('mail_users.user_id', $userid)->whereNull('mails.deleted_at')->whereNull('mail_users.readed')->count(); $sents = Mymail::where('nguoigui_id', $userid)->orderBy('created_at', 'desc')->paginate(10); $drafs = Mymail::where('nguoigui_id', $userid)->where('draf', 1)->orderBy('created_at')->paginate(10); return view('emails.index')->with(array('menus' => $this->menus, 'mails' => $mails, 'readed' => $readed, 'sents' => $sents, 'drafs' => $drafs, 'rolechucnangs' => $this->rolechucnangs)); }