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(); }
public function index() { $user = Auth::user(); $courses = Course::where('lecturer_id', '=', $user->id)->get(); foreach ($courses as $course) { $dept = Department::where('id', '=', $course->department_id)->firstOrFail(); $course['department_name'] = $dept->name; $questions = Question::where('course_id', '=', $course->id)->get(); if (count($questions) > 0) { $course->questions_set = true; } else { $course->questions_set = false; } } return view('que.index', compact('courses')); }
/** * @return mixed */ public function departmentViewFilter() { if ($this->filter === 'all') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->get(); } elseif ($this->filter === 'unassigned') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->where('user_id', null)->get(); } elseif ($this->filter === 'open') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->where('status', $this->filter)->get(); } elseif ($this->filter === 'close') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->where('status', $this->filter)->get(); } elseif ($this->filter === 'started') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->where('activity', $this->filter)->get(); } elseif ($this->filter === 'not_started') { $department = \App\Department::where('department_code', $this->department_code)->first(); $view = $department->tickets()->where('activity', $this->filter)->get(); } return $view; }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(UserRequest $request, User $user) { /* New User Table */ $user->name = $request['Fname']; $user->surname = $request['Sname']; $user->cellphone = $request['Cell1']; $user->username = $request['Email']; $user->email = $request['Cell1']; $position = Position::where('slug', '=', $request['Position'])->first(); $user->position = $position->id; $province = Province::where('slug', '=', $request['Province'])->first(); $user->province = $province->id; $district = District::where('slug', '=', $request['District'])->first(); $user->district = $district->id; $municipalityIds = array(); foreach ($request['Municipality'] as $municipalityName) { $municipality = Municipality::where('slug', '=', $municipalityName)->first(); $municipalityIds[] = $municipality->id; } $user->municipality = implode(",", $municipalityIds); $department = Department::where('slug', '=', $request['Department'])->first(); $user->department = $department->id; $password = rand(1000, 99999); $user->password = \Hash::make($password); $user->api_key = uniqid(); $user->status = 1; $user->role = 2; $user->save(); \Session::flash('success', $request['Fname'] . ' ' . $request['Sname'] . ' has been added successfully!'); $data = array('name' => $user->name, 'username' => $user->email, 'password' => $password); \Mail::send('emails.registrationConfirmation', $data, function ($message) use($user) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($user->username)->subject("Siyaleader User Registration Confirmation: " . $user->name); }); return redirect('list-users'); }
public function store(Report $report, Request $request) { \Log::info("Request " . $request); $category = \Input::get('category'); \Log::info('GET Category ' . $category); $sub_category = \Input::get('sub_category'); \Log::info('GET Sub Category ' . $sub_category); $sub_sub_category = \Input::get('sub_sub_category'); \Log::info('GET Sub Sub Category ' . $sub_sub_category); $sub_sub_category = empty($sub_sub_category) ? " " : $sub_sub_category; $description = \Input::get('description'); \Log::info('Get Description :' . $description); $description = empty($description) ? " " : $description; $gps_lat = \Input::get('gps_lat'); \Log::info('GPS Lat :' . $gps_lat); $gps_lng = \Input::get('gps_lng'); \Log::info('GPS Lng :' . $gps_lng); $user_email = \Input::get('user_email'); \Log::info('Email :' . $user_email); $priority = \Input::get('priorities'); $priority = empty($priority) ? "Normal" : $priority; \Log::info('Priority :' . $priority); $headers = apache_request_headers(); $response = array(); \Log::info("Request " . $request); if (count($_FILES) > 0) { $files = $_FILES['img']; $name = uniqid('img-' . date('Ymd') . '-'); $temp = explode(".", $files['name']); $name = $name . '.' . end($temp); if (file_exists("uploads/" . $name)) { echo $_FILES["img"]["name"] . "already exists. "; } else { $img_url = "uploads/" . $name; $target_file = "uploads/{$name}"; $resized_file = "uploads/{$name}"; $wmax = 600; $hmax = 480; $fileExt = 'jpg'; if (move_uploaded_file($_FILES["img"]["tmp_name"], $img_url)) { $this->ak_img_resize($target_file, $resized_file, $wmax, $hmax, $fileExt); } } } $img_url = isset($img_url) ? $img_url : "uploads/noimage.png"; if (isset($headers['api_key'])) { $userNew = UserNew::where('api_key', '=', $headers['api_key_new'])->first(); if (sizeof($userNew) > 0) { $objCat = DepartmentCategory::where('name', '=', $category)->first(); \Log::info('Category Object :' . $objCat); $department = Department::where('id', '=', $objCat->department)->first(); \Log::info('Department Object : ' . $department); $objSubCat = DepartmentSubCategory::where('name', '=', $sub_category)->first(); $SubCatName = sizeof($objSubCat) > 0 ? $objSubCat->name : ""; if (strlen($sub_sub_category) > 1) { $objSubSubCat = DepartmentSubSubCategory::where('name', '=', $sub_sub_category)->first(); $objSubSub = $objSubSubCat->id; } else { $objSubSubCat = 0; $objSubSub = 0; } $case = new CaseReport(); $case->description = $description; $case->user = $userNew->id; $case->reporter = $userNew->id; $case->department = $department->id; $case->category = $objCat->id; $case->sub_category = $objSubCat->id; $case->sub_sub_category = $objSubSub; $case->priority = $priority; $case->status = 'Pending'; $case->gps_lat = $gps_lat; $case->precinct = 5; $case->img_url = $img_url; $case->gps_lng = $gps_lng; $case->save(); $caseOwner = new CaseOwner(); $caseOwner->user = $userNew->id; $caseOwner->caseId = $case->id; $caseOwner->type = 0; $caseOwner->active = 1; $caseOwner->save(); $response["message"] = "Report created successfully"; $response['error'] = FALSE; $data = array('name' => $userNew->name, 'caseID' => $case->id, 'caseDesc' => $case->description); \Mail::send('emails.sms', $data, function ($message) use($userNew) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($userNew->username)->subject("Siyaleader Notification - New Case Reported:"); }); if (is_object($objSubSubCat)) { $firstRespondersObj = CaseResponder::where("sub_sub_category", '=', $objSubSubCat->id)->select('firstResponder')->first(); /*$secondRespondersObj = CaseResponder::where("sub_sub_category",'=',$objSubSubCat->id) ->select('secondResponder')->first(); $thirdRespondersObj = CaseResponder::where("sub_sub_category",'=',$objSubSubCat->id) ->select('thirdResponder')->first(); */ if (sizeof($firstRespondersObj) > 0) { $case->status = "Referred"; $case->referred_at = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString(); $case->save(); $firstResponders = explode(",", $firstRespondersObj->firstResponder); if ($firstRespondersObj->firstResponder > 0) { foreach ($firstResponders as $firstResponder) { $firstResponderUser = UserNew::find($firstResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $firstResponder; $caseOwner->caseId = $case->id; $caseOwner->type = 1; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $firstResponderUser->name, 'caseID' => $case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description); \Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); $cellphone = $firstResponderUser->email; \Mail::send('emails.caseEscalatedSMS', $data, function ($message) use($cellphone) { $message->from('*****@*****.**', 'Siyaleader'); $message->to('*****@*****.**')->subject("REFER: {$cellphone}"); }); } } } /* if (sizeof($secondRespondersObj) > 0) { $secondResponders = explode(",",$secondRespondersObj->secondResponder); if($secondRespondersObj->secondResponder > 0) { foreach ($secondResponders as $secondResponder) { $secondResponderUser = UserNew::find($secondResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $secondResponder ; $caseOwner->caseId = $case->id; $caseOwner->type = 2; $caseOwner->active = 1; $caseOwner->save(); $data = array( 'name' =>$secondResponderUser->name, 'caseID' =>$case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description, ); \Mail::send('emails.responder',$data, function($message) use ($secondResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } } */ /* if (sizeof($thirdRespondersObj) > 0) { $thirdResponders = explode(",",$thirdRespondersObj->thirdResponder); if($thirdRespondersObj->thirdResponder > 0) { foreach ($thirdResponders as $thirdResponder) { $thirdResponderUser = UserNew::find($thirdResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $thirdResponder ; $caseOwner->caseId = $case->id; $caseOwner->type = 3; $caseOwner->active = 1; $caseOwner->save(); $data = array( 'name' =>$thirdResponderUser->name, 'caseID' =>$case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description, ); \Mail::send('emails.responder',$data, function($message) use ($thirdResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } }*/ } if (sizeof($objSubCat) > 0 && $objSubSubCat == "") { $firstRespondersObj = CaseResponder::where("sub_category", '=', $objSubCat->id)->select('firstResponder')->first(); /* $secondRespondersObj = CaseResponder::where("sub_category",'=',$objSubCat->id) ->select('secondResponder')->first(); $thirdRespondersObj = CaseResponder::where("sub_category",'=',$objSubCat->id) ->select('thirdResponder')->first(); */ if (sizeof($firstRespondersObj) > 0) { $case->status = "Referred"; $case->referred_at = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString(); $case->save(); $firstResponders = explode(",", $firstRespondersObj->firstResponder); if ($firstRespondersObj->firstResponder > 0) { foreach ($firstResponders as $firstResponder) { $firstResponderUser = UserNew::find($firstResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $firstResponder; $caseOwner->caseId = $case->id; $caseOwner->type = 1; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $firstResponderUser->name, 'caseID' => $case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description); \Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); $cellphone = $firstResponderUser->cellphone; \Mail::send('emails.caseEscalatedSMS', $data, function ($message) use($cellphone) { $message->from('*****@*****.**', 'Siyaleader'); $message->to('*****@*****.**')->subject("REFER: {$cellphone}"); }); } } } /* if (sizeof($secondRespondersObj) > 0) { $secondResponders = explode(",",$secondRespondersObj->secondResponder); if($secondRespondersObj->secondResponder > 0) { foreach ($secondResponders as $secondResponder) { $secondResponderUser = UserNew::find($secondResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $secondResponder ; $caseOwner->caseId = $case->id; $caseOwner->type = 2; $caseOwner->active = 1; $caseOwner->save(); $data = array( 'name' =>$secondResponderUser->name, 'caseID' =>$case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description, ); \Mail::send('emails.responder',$data, function($message) use ($secondResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } }*/ /*if (sizeof($thirdRespondersObj) > 0) { $thirdResponders = explode(",",$thirdRespondersObj->thirdResponder); if($thirdRespondersObj->thirdResponder > 0) { foreach ($thirdResponders as $thirdResponder) { $thirdResponderUser = UserNew::find($thirdResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $thirdResponder ; $caseOwner->caseId = $case->id; $caseOwner->type = 3; $caseOwner->active = 1; $caseOwner->save(); $data = array( 'name' =>$thirdResponderUser->name, 'caseID' =>$case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description, ); \Mail::send('emails.responder',$data, function($message) use ($thirdResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } }*/ } return \Response::json($response, 201); } else { $response['message'] = 'Access Denied. Invalid Api key'; $response['error'] = TRUE; return \Response::json($response, 401); } } else { $response['message'] = 'Access Denied. Invalid Api key'; $response['error'] = TRUE; return \Response::json($response, 401); } }
if ($from == 'province') { $object = Province::where('slug', '=', $name)->first(); } if ($from == 'district') { $object = District::where('slug', '=', $name)->first(); } if ($from == 'municipality') { $object = Municipality::where('slug', '=', $name)->first(); } $listing = DB::table($to)->where($from, $object->id)->lists('name', 'slug'); return $listing; }); Route::get('/api/dropdownDepartment/{to}/{from}', function ($to, $from) { $name = Input::get('option'); if ($from == 'department') { $object = Department::where('slug', '=', $name)->first(); $listing = DB::table('categories')->where('department', '=', $object->id)->lists('name', 'slug'); } if ($from == 'category') { $object = Category::where('slug', '=', $name)->first(); $listing = DB::table('sub_categories')->where('category', '=', $object->id)->lists('name', 'slug'); } if ($from == 'sub_category') { $object = SubCategory::where('slug', '=', $name)->first(); $listing = DB::table('sub_sub_categories')->where('sub_category', '=', $object->id)->lists('name', 'slug'); } return $listing; }); Route::get('/api/dropdownCategory/{to}/{from}', function ($to, $from) { $name = Input::get('option'); if ($from == 'category') {
/** * Store a csv created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function import(Request $request) { if ($request->file('csv-file')->isValid()) { $csv_file = $request->file('csv-file'); if ("text/csv" == $csv_file->getClientMimeType()) { $dest_path = storage_path('temp'); $file_name = time() . '_' . str_replace(" ", "_", $csv_file->getClientOriginalName()); $csv_file->move($dest_path, $file_name); $fname = $dest_path . '/' . $file_name; $file = fopen($fname, "r"); $flash_message = []; $flash_error = 0; while (!feof($file)) { $tmp_data = fgetcsv($file); $item['department_id'] = !empty($tmp_data[0]) ? $tmp_data[0] : ''; $department = Department::where('code', '=', $item['department_id'])->first(); if ($department) { $item['department_id'] = $department->id; } $item['code'] = !empty($tmp_data[1]) ? $tmp_data[1] : ''; $item['name'] = !empty($tmp_data[2]) ? $tmp_data[2] : ''; $item['description'] = !empty($tmp_data[3]) ? $tmp_data[3] : ''; $v = Validator::make($item, ['department_id' => 'required|integer|min:1', 'code' => 'required|unique:courses|max:20', 'name' => 'required|max:254']); if (!$v->fails()) { Course::create($item); $flash_message['success'][] = '[' . $item['code'] . '] ' . $item['name']; } else { $flash_error++; $flash_message['error'] = $flash_error; } } \Session::flash('flash_message', $flash_message); fclose($file); chmod($fname, 0777); unlink($fname); } } return redirect('/courses'); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $this->AuthorizeAndRedirect('admin'); $student = User::findOrFail($id); $department = Department::where('id', '=', $student->department_id)->firstOrFail(); $student['department_name'] = $department->name; return view('student.show', compact('student')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $position = Position::where('active', 1)->get(); // if is Leader // if staff edit != dev or yourself => denied if (Gate::allows('check-leader')) { $staff = Staff::find($id)->level->role; if ($staff->name != "Developer" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $level = Level::where('role_id', 4)->get(); $department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first(); } } else { if (Gate::allows('check-admin')) { $staff = Staff::find($id)->level->role; if ($staff->name == "Developer" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $department = Department::where('active', 1)->get(); $level = Level::where(['role_id' => 2, 'active' => 1])->orWhere(['role_id' => 3, 'active' => 1])->get(); } } else { if (Gate::allows('check-manager')) { $staff = Staff::find($id)->level->role; if ($staff->name == "Manager" && $id != Auth::user()->id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $level = Level::where('role_id', 3)->orWhere('role_id', 4)->get(); if ($id == Auth::user()->id) { $department = ''; } $department = Department::where('active', 1)->get(); } } else { $staff_id = Auth::user()->id; if ($staff_id != $id) { return redirect()->route('admin.staff.index')->with('message', 'Access is denied'); } else { $position = Position::where('id', Auth::user()->position_id)->where('active', 1)->get(); $level = Level::where('id', Auth::user()->level_id)->where('active', 1)->get(); $department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first(); } } } } if ($id == Auth::user()->id) { $check_account = 1; } else { $check_account = 0; } $staff = Staff::find($id); return view('admin.staff.update', compact('id', 'staff', 'position', 'level', 'department', 'check_account')); }
@endsection @section('sidebar') @include('layouts.include.sidebar') @endsection @section('bodycontent') <div class = "span9"> {!! Form::open(array('action'=>'RoutineDisplayController@viewroomschedule', 'method'=>'post')) !!} <?php use App\Department; use App\User; use App\User_detail; $id = User::where('username', $username)->first()->id; $department = User_detail::where('id', $id)->first()->department; $roomtotal = Department::where('code', $department)->orderby('code')->first()->total_rooms; ?> <fieldset> <legend>Department: {{ $department }}</legend> <div class="control-group"> {!! Form::label('roomcode', 'Select Room:', array('class' => 'control-label')) !!} <div class="controls"> {!! Form::selectrange('selectroom',1, $roomtotal) !!} </div> <div class="controls"> {!! Form::hidden('teacherdepart', $department) !!} </div> </div> <div class="control-group"> <div class="controls"> {!! Form::submit('Check Routine', ['class'=>'btn btn-primary','value'=>'showroomschedule', 'name'=>'showroomschedule']) !!}
public function importEMP($destfile) { Excel::load($destfile, function ($reader) { $rules = ['number' => 'required|unique:employees', 'company_id' => 'required|exists:companies,id', 'department_id' => 'required|exists:departments,id', 'bank_account' => 'required|unique:employees']; $sheetsCount = $reader->getSheetCount(); for ($i = 0; $i < $sheetsCount; $i++) { $sheets = $reader->getSheet($i)->toArray(); $company_name = $reader->getSheet($i)->getTitle(); $dept['company_id'] = Company::where('name', $company_name)->value('id'); $sheetCount = count($sheets); for ($j = 6; $j < $sheetCount; $j++) { // Get Department ID; $dept['name'] = $sheets[$j][1]; $dept['costcenter'] = $sheets[$j][10]; $employee['company_id'] = $dept['company_id']; $employee['department_id'] = Department::where('name', $dept['name'])->where('company_id', $dept['company_id'])->where('costcenter', $dept['costcenter'])->value('id'); $employee['name'] = $sheets[$j][2]; $employee['number'] = $sheets[$j][3]; $employee['level_id'] = Level::where('credit', 400)->value('id'); $employee['category_id'] = Category::where('code', 1)->value('id'); $employee['status_id'] = Status::where('code', 1)->value('id'); $employee['telephone'] = $sheets[$j][4]; $employee['bank_account'] = $sheets[$j][8]; $emp_v = \Validator::make($employee, $rules); if ($emp_v->fails()) { } else { Employee::create($employee); } } } //END }); }
@include('layouts.adminalgo.algoclass') @include('layouts.adminalgo.insertionSort') @include('layouts.adminalgo.ASP_Algo') @include('layouts.adminalgo.algomain') <style> nu { color: #FF0000; } </style> <?php use App\Department; use App\Schedule; use App\Time_table; if (isset($_GET['depart'])) { $department = Department::where('code', $_GET['depart'])->first(); $weekdays = array('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday'); $scheduledata = Schedule::where('department_code', $department->code); if ($scheduledata->exists()) { echo "<h1>Department: " . $department->code . "</h1><br>"; } foreach ($weekdays as $a) { //echo "<h2>Routine for: ".strtoupper($a)."</h2><br>"; main_func($a, $department); } echo "<br><br>"; } else { echo "<h1> Hello " . $username . " </h1>"; $totalschedules = count(Schedule::all()); $totaltimetables = count(Time_table::all()); if ($totalschedules > 0 && $totaltimetables != $totalschedules) {
@section('bodycontent') <div class="span9"> {!! Form::open(array('class'=>'form-horizontal', 'action'=>'CourseDetailController@addclass', 'method'=>'post')) !!} @if ($errors->has()) <div class="alert alert-danger"> @foreach($errors->all() as $error) {{ $error }}<br> @endforeach </div> @endif <?php use App\Course; use App\Department; use App\Group; $courseinfo = Course::orderby('course_code')->lists('course_code', 'course_code'); $value = Department::where('code', $departcode)->orderby('code')->first()->code; $groupinfo = Group::where('department', $value)->orderby('group_code')->lists('group_code', 'group_code'); ?> <fieldset> <legend>Select Course</legend> <div class="control-group"> {!! Form::label('coursecode', 'Select Course:', array('class' => 'control-label')) !!} <div class="controls"> {!! Form::select('selectcoursecode', $courseinfo) !!} </div> </div> <div class="control-group"> {!! Form::label('classcode', 'Offer to:', array('class' => 'control-label')) !!} <div class="controls"> {!! Form::select('selectclass',$groupinfo, array('id' => 'selectclass')) !!} </div>
public function revertAssignedWork(RevertAssignedWorkRequest $request) { if ($request->revert == 1) { $work = Work::where('id', '=', $request->work_id)->first(); if ($work->created_by == $this->currentUser->getId()) { /** * İŞİ GERİ ÇEKİLİNCE */ $departmentWork = DepartmentWork::where('id', '=', $work->last_department_work_id)->first(); $departmentWithSenior = Department::where('id', '=', $departmentWork->department_id)->with('senior')->first(); $seniorUser = $departmentWithSenior->senior[0]; $username = $seniorUser->first_name . " " . $seniorUser->last_name; $username = mb_convert_case($username, MB_CASE_TITLE, 'utf-8'); CommonController::mailSendNotQueue('IS TAKIP SISTEMI', [$seniorUser->email], ['fullname' => $username, 'message' => 'Departmanınıza açılan "' . $work->title . '" başlıklı iş geri alınmıştır. Lütfen ' . $this->currentUser->first_name . ' ' . $this->currentUser->last_name . ' ile irtibata geçiniz. '], 'emails.work-mail-template'); CommonController::sendSms('RHPOZTFYAY', $seniorUser->phone, 'Departmanınızdaki "' . $work->title . '" başlıklı iş geri alınmıştır.Lütfen ' . $this->currentUser->first_name . ' ' . $this->currentUser->last_name . ' ile irtibata geçiniz.'); $work->last_department_work_id = null; $work->save(); } else { $workDepartment = DepartmentWork::where('id', '=', $work->last_department_work_id)->first(); $userWork = UserWork::where('id', '=', $workDepartment->last_user_work_id)->first(); $user = User::where('id', '=', $userWork->assigned_to)->first(); $username = $user->first_name . " " . $user->last_name; $username = mb_convert_case($username, MB_CASE_TITLE, 'utf-8'); CommonController::mailSendNotQueue('IS TAKIP SISTEMI', [$user->email], ['fullname' => $username, 'message' => 'Size acılan "' . $work->title . '" başlıklı iş geri alınmıştır. Lütfen departman lideriniz ile irtibata geçiniz. '], 'emails.work-mail-template'); CommonController::sendSms('RHPOZTFYAY', $user->phone, 'Size açılmış "' . $work->title . '" başlıklı iş geri alınmıştır. Lütfen departman lideri ile irtibata geçiniz.'); $workDepartment->last_user_work_id = null; $workDepartment->accepted = null; $workDepartment->save(); } return response()->json(['success' => true, 'messages' => 'İş Geri Alma İşlemi Başarılı', 'revert' => true, 'work_id' => $work->id]); } else { return response()->json(['success' => true, 'messages' => 'İş Geri Alma İşlemi Başarılı', 'revert' => false]); } }
<div class="bs-example"> <div class="panel panel-primary"> <div class="panel-heading" style="background: #009FD7;"><h4 class="panel-title">{{ $user->name }}</h4></div> <div class="panel-body"> <?php use App\Action; use App\Task; use App\Department; use App\Team; $user_stuff = array(); $user_stuff = array_merge($user_stuff, Action::where('lead', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Action::where('collaborators', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Task::where('lead', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Task::where('collaborators', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Department::where('name', 'like', '%' . $user->department . '%')->get()->all()); ?> <table class="table table-striped table-hover table-bordered table-responsive"> <tbody> @foreach($user_stuff as $item) <?php $result_class = str_replace("app\\", "", strtolower(get_class($item))); ?> <tr> <td><a href="/{{ $result_class }}s/show/{{ $item->id }}">{{ ucwords($result_class) }}: @if(!in_array($result_class, ["department", "team"])){{ $item->body }}@else{{ $item->name }}@endif</a></td> </tr> @endforeach </tbody> </table>
public function destroy($id) { $this->permissionSection(function () use($id) { DB::transaction(function () use($id) { $department = Department::where('id', '=', \Crypt::decrypt($id))->delete(); }); }, 'wts.department.delete'); return response()->json($this->deleteResponseMessage); }