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);
}
}
