public function test() { $school_id = 1; $programs = Program::where('school_id', '=', $school_id)->get(); $json_programs = json_encode($programs); return response()->json($programs); }
public function vacations($vacation) { if ($vacation == 'winter') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Зима')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } elseif ($vacation == 'spring') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Весна')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } elseif ($vacation == 'summer') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Лето')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } elseif ($vacation == 'autumn') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Осень')->orderBy('programs.id', 'desc')->select('programs.id as id', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } elseif ($vacation == 'weekend') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Выходной')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } elseif ($vacation == 'festival') { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->where('vacations.season', '=', 'Фестиваль')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } else { $programs = Program::where('programs.active', '=', '1')->join('vacations', 'programs.id', '=', 'vacations.program_id')->orderBy('programs.id', 'desc')->select('programs.*', 'vacations.start_date as start_date', 'vacations.finish_date as finish_date')->get(); } $all_news = News::where('active', '=', '1')->get(); $monthes = array(1 => 'Января', 2 => 'Февраля', 3 => 'Марта', 4 => 'Апреля', 5 => 'Мая', 6 => 'Июня', 7 => 'Июля', 8 => 'Августа', 9 => 'Сентября', 10 => 'Октября', 11 => 'Ноября', 12 => 'Декабря'); if (Auth::check()) { $user = Auth::user()->name; } else { $user = '******'; } return view('index', ['programs' => $programs, 'monthes' => $monthes, 'all_news' => $all_news, 'user' => $user]); }
public function schoolClicked($id) { $schools = School::all(); $programs = Program::where('school_id', '=', $id)->get(); $books = Book::where('school_id', '=', $id)->get(); return view('home')->with('programs', $programs)->with('schools', $schools); }
/** * Inserts new entry into Client Table and * checks for validation on form submission * Authorization is checked for privilages * * @param CreateClientRequest $request * @return Response */ public function store(ClientRequest $request) { $input = $request->all(); $client = Client::create($input); $program = Program::where('id', '=', $request->input('programs'))->first(); $agent = Auth::user(); $client->program()->associate($program); $client->agent()->associate($agent); $client->save(); $temp = Temp::where('fname', '=', $request->fname)->where('lname', '=', $request->lname)->first(); if ($temp != null) { $temp->delete(); } $meal = new Meal(); $meal->date_fed = date('Y-m-d'); $meal->client()->associate($client); $meal->breakfast = 0; $meal->lunch = 0; $meal->dinner = 0; $meal->save(); return redirect('client'); }
public function ajaxGetPrograms(Request $request) { // if(Request::ajax()) { $school_id = $request->input('school_id'); $programs = Program::where('school_id', '=', $school_id)->orderBy('program_name')->get(); $programs_array = array(); foreach ($programs as $key => $value) { $programs_array[] = $value; } return response()->json($programs_array); // } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $programs = Program::where('user_id', '=', $this->user->id)->get(); return view('program.index')->with('programs', $programs); }
public function select_programs() { // $year = Input::get('year'); $season = Input::get('season'); $program = Input::get('program'); if ($program != "*" && $season != "*") { $programs = Program::where('programs.active', '=', 1)->leftJoin('vacations', 'programs.id', '=', 'vacations.program_id')->leftJoin('parts', 'vacations.id', '=', 'parts.vacation_id')->select('programs.*', 'vacations.start_date as vacation_start', 'vacations.finish_date as vacation_finish', 'parts.start_date as part_start', 'parts.finish_date as part_finish')->orderBy('vacations.start_date', 'desc')->where('programs.id', '=', $program)->where('programs.season', '=', $season)->get(); } elseif ($season != "*" && $program == "*") { $programs = Program::where('programs.active', '=', 1)->leftJoin('vacations', 'programs.id', '=', 'vacations.program_id')->leftJoin('parts', 'vacations.id', '=', 'parts.vacation_id')->select('programs.*', 'vacations.start_date as vacation_start', 'vacations.finish_date as vacation_finish', 'parts.start_date as part_start', 'parts.finish_date as part_finish')->orderBy('vacations.start_date', 'desc')->where('programs.season', '=', $season)->get(); } elseif ($season == "*" && $program != "*") { $programs = Program::where('programs.active', '=', 1)->leftJoin('vacations', 'programs.id', '=', 'vacations.program_id')->leftJoin('parts', 'vacations.id', '=', 'parts.vacation_id')->select('programs.*', 'vacations.start_date as vacation_start', 'vacations.finish_date as vacation_finish', 'parts.start_date as part_start', 'parts.finish_date as part_finish')->orderBy('vacations.start_date', 'desc')->where('programs.id', '=', $program)->get(); } else { $programs = Program::where('programs.active', '=', 1)->leftJoin('vacations', 'programs.id', '=', 'vacations.program_id')->leftJoin('parts', 'vacations.id', '=', 'parts.vacation_id')->select('programs.*', 'vacations.start_date as vacation_start', 'vacations.finish_date as vacation_finish', 'parts.start_date as part_start', 'parts.finish_date as part_finish')->orderBy('vacations.start_date', 'desc')->get(); } $all_news = News::where('active', '=', '1')->get(); $all_programs = Program::where('programs.active', '=', 1)->get(); if (Request::format() == 'json') { return $programs->toJson(); } else { return view('user.all_programs')->with('programs', $programs)->with('all_news', $all_news)->with('all_programs', $all_programs); } }