public function main() { $data = ['pageName' => 'main']; $data['novelCnt'] = Novel::where('state', '=', 'detect')->count(); $data['chapterCnt'] = Chapter::where('state', '=', 'detected')->count(); $data['mailCnt'] = Mail::where('state', '=', 'ready')->count(); return view('index', $data); }
public function mySent($role, $school, $id, $user) { if ($role == 2) { $mails = Mail::where('user_id', $user->id)->where('trash_sender', 0)->where('client_id', $id)->where('from', $role)->where('school_id', $school->id)->get(); } else { $mails = Mail::where('user_id', $user->id)->where('trash_sender', 0)->where('admin_id', $id)->where('from', $role)->where('school_id', $school->id)->get(); } return $mails; }
/** * Collection of all message either send or received by this user * * @return mixed */ public function allMessages() { return Mail::where('sender_id', $this->id)->orWhere('receiver_id', $this->id); }
public function adminMailsByStatus($status) { $mails = Mail::where('status', $status)->orderBy('updated_at', 'DESC')->get(); return view('admin.adminMails')->with('mails', $mails)->with('status', $status); }
public function yourMail() { $mails = Mail::where('user_id', Auth::user()->id)->orderBy('updated_at', 'DESC')->get(); return view('user.yourMail')->with('mails', $mails); }