public function checkAgency($code) { $rs = Agency::where('code', '=', $code)->count(); if (isset($rs)) { return $rs >= 1 ? false : true; } }
public function getDelete($id) { $users = Agency::where('id', '=', $id)->get(); foreach ($users as $user) { $user_id = $user->staff_id; } $userdelete = User::find($user_id); $userdelete->delete(); $agencystaff = Agency::find($id); $agencystaff->delete(); return Redirect::to('dashboard/agencies'); }
public function listActivities() { $c_u_result = User::where(DB::raw('date(created_at)'), Carbon::today())->get(); $u_u_result = User::where(DB::raw('date(updated_at)'), Carbon::today())->where(DB::raw('date(created_at)'), '<', DB::raw('date(updated_at)'))->get(); $c_a_result = Agency::where(DB::raw('date(created_at)'), Carbon::today())->get(); $u_a_result = Agency::where(DB::raw('date(updated_at)'), Carbon::today())->where(DB::raw('date(created_at)'), '<', DB::raw('date(updated_at)'))->get(); //retrive report activities $c_r_result = Report::where(DB::raw('date(Reports.created_at)'), Carbon::today())->where('isDeleted', 0)->leftjoin('ReportStatusType', 'ReportStatusType.reportStatusTypeId', '=', 'Reports.status')->leftjoin('ReportType', 'ReportType.ReportTypeId', '=', 'Reports.ReportType')->lists('reportName', 'reportedBy', 'location', 'reportStatusTypeName', 'reportTypeName', 'Reports.created_at', 'Reports.updated_at'); $u_r_result = Report::where(DB::raw('date(Reports.updated_at)'), Carbon::today())->where(DB::raw('date(Reports.created_at)'), '<', DB::raw('date(Reports.updated_at)'))->where('isDeleted', 0)->leftjoin('ReportStatusType', 'ReportStatusType.reportStatusTypeId', '=', 'Reports.status')->leftjoin('ReportType', 'ReportType.ReportTypeId', '=', 'Reports.ReportType')->lists('reportName', 'reportedBy', 'location', 'reportStatusTypeName', 'reportTypeName', 'Reports.created_at', 'Reports.updated_at'); $d_r_result = Report::where(DB::raw('date(Reports.deleted_at)'), Carbon::today())->where('isDeleted', 1)->leftjoin('ReportStatusType', 'ReportStatusType.reportStatusTypeId', '=', 'Reports.status')->leftjoin('ReportType', 'ReportType.ReportTypeId', '=', 'Reports.ReportType')->lists('reportName', 'reportedBy', 'location', 'reportStatusTypeName', 'reportTypeName', 'Reports.created_at', 'Reports.updated_at'); $result = array('users_created' => $c_u_result, 'users_updated' => $u_u_result, 'agencies_created' => $c_a_result, 'agencies_updated' => $u_a_result, 'reports_created' => $c_r_result, 'reports_updated' => $u_r_result, 'reports_deleted' => $d_r_result); return Response::json($result)->setCallback(Input::get('callback')); }
public function getReply() { $id = Request::segment(3); $inbox_id = Request::segment(4); $profiles = Agency::where('staff_id', '=', $id)->get(); $allTeamsMember = array(); foreach ($profiles as $profile) { if ($profile->user_id != Sentry::getUser()->id) { $allTeamsMember[$profile->user_id] = $profile->name; } } // DB::table('inbox') // ->where('to_user', Sentry::getUser()->id) // ->where('id', $inbox_id) // ->update(array('notification' => 0)); return View::make('message.reply')->with('teams', $allTeamsMember); }
/** * [agencyDel description] * @param [type] $agency_id [description] * @return [type] [description] */ public function agencyDel($agency_id) { Agency::where('id', '=', $agency_id)->delete(); return Redirect::to('agency')->with('success', 'ชื่อข้อมูลหน่วยงานรหัส = ' . $agency_id . ' ลบทิ้งสำเร็จ'); }
public function postProfile() { $fields = array('name' => Input::get('name'), 'phone' => Input::get('phone'), 'cell' => Input::get('cell'), 'address' => Input::get('address'), 'country' => Input::get('country')); $id = Sentry::getUser()->id; DB::table('registration')->where('user_id', '=', $id)->update($fields); $proimg = Input::file('photo'); if ($proimg) { $fieldsimg = array('photo' => $this->ImageCrop('photo', 'photos', '200', '200', '')); DB::table('registration')->where('user_id', '=', $id)->update($fieldsimg); } $fieldsname = array('email' => Input::get('email')); DB::table('users')->where('id', '=', Sentry::getUser()->id)->update($fieldsname); $fieldsstaff = array('email' => Input::get('email'), 'name' => Input::get('name'), 'phone' => Input::get('phone'), 'cell' => Input::get('cell'), 'address' => Input::get('address'), 'country' => Input::get('country')); Agency::where('staff_id', '=', Sentry::getUser()->id)->update($fieldsstaff); return Redirect::to('viewprofile'); }