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