/** * Store a newly created resource in storage. * @param Request $request * @return Response */ public function update(Request $request) { $message = StudentMessage::where('student_id', $this->student->id)->where('id', $request->input('id'))->first(); $message->seen = 1; $message->save(); return response()->json(true); }
public function index(Request $request) { $messages = StudentMessage::with('student', 'sender')->orderBy('id', 'desc'); if (request('message')) { $messages->where('email', 'like', "%" . request('message') . "%"); $messages->orWhere('sms', 'like', "%" . request('message') . "%"); } if (request('created_at')) { $messages->whereDate('created_at', '=', request('created_at')); } if (request('student_id')) { $messages->where('student_id', request('student_id')); } $per_page = request('per_page') ? request('per_page') : 50; $messages = $messages->paginate($per_page); $messages->appends($request->except("page")); return view('students::messages.index', compact('messages')); }
private function getMessages() { $messages = StudentMessage::where('student_id', $this->student->id)->where('email_sent', 1)->where('email', '!=', '')->where('semester_id', $this->semester->id)->get(); return $messages; }