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