/** * Create a new user controller instance. * * @return void */ public function __construct() { $this->priviledge_user(); $this->_user = \Auth::user(); if (2 == $this->_user->role_id) { $this->_query_connect = "="; $this->_query_value = $this->_user->department_id; } $this->_schedule_masters = Master::orderBy('id', 'desc')->lists('name', 'id'); $this->_schedule_curriculums = Curriculum::all(); $this->_schedule_rooms = Room::orderBy('id', 'desc')->lists('name', 'id'); }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { $master = Master::find($this->masters); switch ($this->method()) { case 'GET': case 'DELETE': return []; case 'POST': return ['name' => 'required|max:254', 'description' => 'required', 'start_date' => 'required|date_format:Y-m-d', 'end_date' => 'required|date_format:Y-m-d|after:start_date']; case 'PUT': case 'PATCH': return ['name' => 'required|max:254', 'description' => 'required', 'start_date' => 'required|date_format:Y-m-d', 'end_date' => 'required|date_format:Y-m-d|after:start_date']; default: break; } }
/** * Show the application dashboard. * * @return \Illuminate\Http\Response */ public function index() { $_schedule_masters = Master::orderBy('id', 'desc')->lists('name', 'id'); $master_id = array_keys(head($_schedule_masters))[0]; $data_pie = DB::select('SELECT da.code, count(sc.id) total_class FROM ( SELECT isc.* FROM schedules isc GROUP BY isc.section_key ) sc INNER JOIN semesters se ON sc.semester_id = se.id INNER JOIN plans pl ON se.plan_id = pl.id INNER JOIN curriculums cu ON pl.curriculum_id = cu.id INNER JOIN courses co ON pl.course_id = co.id INNER JOIN departments da ON co.department_id = da.id WHERE sc.master_id = ' . $master_id . ' GROUP BY da.id'); $data_query = DB::select('SELECT count(sc.id) total FROM ( SELECT isc.* FROM schedules isc GROUP BY isc.room_id ) sc WHERE sc.master_id = ' . $master_id); $data_room = []; if ($data_query) { $data_room['used'] = $data_query[0]->total; $data_room['total'] = \App\Room::count(); } $data_query = DB::select('SELECT count(sc.id) total FROM ( SELECT isc.* FROM schedules isc WHERE not faculty_id is null GROUP BY isc.faculty_id ) sc WHERE sc.master_id = ' . $master_id); $data_faculty = []; if ($data_query) { $data_faculty['used'] = $data_query[0]->total; $data_faculty['total'] = \App\Faculty::count(); } $data_query = DB::select('SELECT count(sc.id) total FROM ( SELECT isc.* FROM schedules isc INNER JOIN semesters se ON isc.semester_id = se.id INNER JOIN plans pl ON se.plan_id = pl.id INNER JOIN curriculums cu ON pl.curriculum_id = cu.id INNER JOIN courses co ON pl.course_id = co.id GROUP BY co.id ) sc WHERE sc.master_id = ' . $master_id); $data_course = []; if ($data_query) { $data_course['used'] = $data_query[0]->total; $data_course['total'] = \App\Course::count(); } $data_query = DB::select('SELECT count(sc.id) total FROM ( SELECT isc.* FROM schedules isc WHERE faculty_id is null OR room_id is null GROUP BY isc.key ) sc WHERE sc.master_id = ' . $master_id); $data_unallocated = []; if ($data_query) { $data_unallocated['used'] = $data_query[0]->total; $data_query = DB::select('SELECT count(sc.id) total FROM ( SELECT isc.* FROM schedules isc GROUP BY isc.key ) sc WHERE sc.master_id = ' . $master_id); $data_unallocated['total'] = $data_query[0]->total; } return view('dashboard.index', compact('data_pie', 'data_room', 'data_faculty', 'data_course', 'data_unallocated')); }
public function playersList($name) { $players = Master::where('nameLast', 'like', $name . '%')->orderBy('nameLast', 'asc')->orderBy('nameFirst', 'asc')->get(); $records = threeColumns($players); return view('players.list')->with(['name' => strtoupper($name), 'recordsCol1' => $records['recordsCol1'], 'recordsCol2' => $records['recordsCol2'], 'recordsCol3' => $records['recordsCol3']]); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { Master::destroy($id); return redirect('/masters'); }