PHP Department::where方法代码示例

 public function departmentView($department_code, $filter)
 {
     $ticketFilter = new TicketFilter($department_code, $filter);
     $tickets = $ticketFilter->departmentViewFilter();
     $department = \App\Department::where('department_code', $department_code)->first();
     return view('helpdeskviews.department', compact('department', 'tickets', 'filter'));
 }

 public function search(Request $request)
 {
     $results = array();
     $term = $request->get('term');
     $goals = Goal::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
     $objectives = Objective::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
     $actions = Action::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
     $tasks = Task::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get();
     $teams = Team::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get();
     $departments = Department::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get();
     $users = User::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get()->all();
     foreach (User::where('email', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get() as $matching_user_email) {
         if (in_array($matching_user_email, $users)) {
             continue;
         }
         $users[] = $matching_user_email;
     }
     $notes = Note::where('content', 'like', '%' . $term . '%')->orderBy('content', 'asc')->get();
     $types = [$goals, $objectives, $actions, $tasks, $teams, $departments, $users, $notes];
     foreach ($types as $type) {
         foreach ($type as $result) {
             $results[] = $result;
         }
     }
     return view('search.show')->with('results', $results)->with('term', $term);
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  Request  $request
  * @param  int  $id
  * @return Response
  */
 public function update(DepartmentRequest $request)
 {
     $dept = Department::where('id', $request['deptID'])->first();
     $dept->name = $request['name'];
     $dept->save();
     \Session::flash('success', $request['name'] . ' has been successfully updated!');
     return redirect()->back();
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $this->data['user'] = User::where('deleted_at', null)->count();
     $this->data['user_disabled'] = User::where('deleted_at', !null)->count();
     $this->data['department'] = Department::where('enabled', 1)->count();
     $this->data['position'] = Position::where('enabled', 1)->count();
     return view('pages.admin.dashboard', $this->data);
 }

 /**
  * @param Request $request
  * @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
  */
 public function getCourse(Request $request)
 {
     if ($request->ajax()) {
         $department = Department::where('name', $request->input('name'))->first();
         $courses = $department->courses->pluck('name');
         return response($courses);
     }
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  Request  $request
  * @param  int  $id
  * @return Response
  */
 public function update(DepartmentRequest $request)
 {
     $dept = Department::where('id', $request['deptID'])->first();
     $dept->name = $request['name'];
     $dept->updated_by = \Auth::user()->id;
     $dept->save();
     \Session::flash('success', 'well done! Role ' . $request['name'] . ' has been successfully added!');
     return redirect()->back();
 }

 public function fuzzyQuery(Request $request)
 {
     $this->validate($request, ['keyword' => 'required|max:255']);
     $keyword = $request->get('keyword');
     $hospitals = Hospital::where('hospital_name', 'like', "%{$keyword}%")->orwhere('city', 'like', "%{$keyword}%")->orwhere('hospital_level', 'like', "%{$keyword}%")->orwhere('description', 'like', "%{$keyword}%")->get();
     $departments = Department::where('department_name', 'like', "%{$keyword}%")->orwhere('department_description', 'like', "%{$keyword}%")->get();
     $doctors = Doctor::where('doctor_name', 'like', "%{$keyword}%")->orwhere('doctor_level', 'like', "%{$keyword}%")->orwhere('doctor_description', 'like', "%{$keyword}%")->get();
     $response = ['hospitals' => $hospitals, 'department' => $departments, 'doctors' => $doctors];
     return json_encode($response);
 }

 /**
  * Display the specified resource.
  * @param Request $request
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function show(Request $request, $id)
 {
     if ($request->ajax()) {
         $department = Department::where('code', $id)->first();
         $teachers = $department->teachers->pluck('name', 'id');
         $courses = $department->courses()->whereNull('isAssigned')->orWhere('isAssigned', '')->pluck('code');
         // get the code of unassigned courses in department
         return response([$courses, $teachers]);
     }
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(saveCourseRequest $request)
 {
     $course = new Course($request->except(['department', 'semester']));
     $department = Department::where('code', $request->input('department'))->first();
     $semester = Semester::find($request->input('semester'));
     $course->department()->associate($department);
     $course->semester()->associate($semester);
     $course->save();
     $request->session()->flash('status', 'Course was saved successful!');
     return back();
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     $this->validate($request, ['name' => 'required|string']);
     $duplicate = Department::where('name', $request->name)->first();
     if ($duplicate) {
         return response()->json(true);
     }
     $department = new Department();
     $department->name = $request->name;
     $department->save();
 }

 public static function search($query)
 {
     if (empty($query)) {
         return Collection::make();
     }
     return Department::where('name', 'like', '%' . $query . '%')->orderBy('name', 'asc')->take(5)->get(array('id', 'name'))->map(function ($department) {
         $department->label = $department->name;
         $department->type = 'department';
         $department->url = route('departments.show', $department->id);
         return $department;
     });
 }

 public function filter()
 {
     $city_id = Input::get('city');
     $departments = Department::orderBy('city_id')->get();
     if (isset($city_id)) {
         if ($city_id == 0) {
             $departments = Department::orderBy('city_id')->get();
         } else {
             $departments = Department::where('city_id', $city_id)->get();
         }
     }
     return View::make('department.all', ['category' => 1, 'departments' => $departments, 'selectedCity' => $city_id]);
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request $request
  * @return \Illuminate\Http\Response
  */
 public function store(saveTeacherRequest $request)
 {
     $request->merge(array('remaining_credit' => $request->input('assigned_credit')));
     // Set remaining credit equal to assigned credit
     $teacher = new Teacher($request->except(['department', 'designation']));
     $department = Department::where('name', $request->input('department'))->first();
     $designation = Designation::where('name', $request->input('designation'))->first();
     $teacher->department()->associate($department);
     $teacher->designation()->associate($designation);
     $teacher->save();
     $teacher_request = new UserRequestHandle('Teacher', $request->input('email'));
     $teacher_request->save();
     $request->session()->flash('status', 'Teacher was saved successful!');
     return back();
 }

 public function index(Request $request)
 {
     if ($request->get('department')) {
         $services = \App\Service::filterByDepartment($request->get('department'))->get();
         $departments = \App\Department::where('id', $request->get('department'))->get();
     } elseif ($request->get('domain')) {
         $domain = \App\Domain::findOrfail($request->get('domain'));
         $services = $domain->services()->get();
         $departments = $domain->departments()->get();
     } else {
         $services = $this->services;
         $departments = \App\Department::all();
     }
     return view('services.index', ['services' => $services, 'departments' => $departments]);
 }

 /**
  * Store a newly created resource in storage.
  * @param RegisterStudentRequest $request
  * @return \Illuminate\Http\RedirectResponse
  */
 public function store(RegisterStudentRequest $request)
 {
     $student = new Student($request->except(['department_code']));
     $date = strtotime($request->input('current_date'));
     $student->current_date = date('d/m/Y', $date);
     // Changed string date to Date format
     $department = Department::where('code', $request->input('department_code'))->first();
     $student->registration_no = $department->name . '-' . date('Y', $date) . '-' . sprintf("%03d", $department->students->count() + 1);
     // Create Student registration no.
     $student->department()->associate($department);
     $student->save();
     $student_request = new UserRequestHandle('Student', $request->input('email'));
     $student_request->save();
     $request->session()->flash('status', 'Student registration was successful!');
     return back();
 }