/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create(Request $request)
{
$animals = Animal::where('idUser', Auth::id())->where('id', $request->id)->get();
$vaccines = VaccinationControl::where('vaccination_controls.idUser', Auth::id())->where('vaccination_controls.animalName', $request->id)->join('vaccines', 'vaccines.id', '=', 'vaccination_controls.vaccineName')->join('diseases', 'diseases.id', '=', 'vaccination_controls.diseaseName')->select('vaccines.nameV', 'diseases.name', 'vaccination_controls.dateApplication', 'vaccination_controls.dose')->get();
$injecctions = InjecctionControl::where('injecction_controls.idUser', Auth::id())->where('injecction_controls.animalName', $request->id)->join('injections', 'injections.id', '=', 'injecction_controls.injectionName')->join('diseases', 'diseases.id', '=', 'injecction_controls.diseaseName')->select('injections.name', 'diseases.name', 'injecction_controls.dateApplication', 'injecction_controls.dose')->get();
$animal = Animal::where('id', $request->id)->get();
return view('reports.show', compact('animals', 'vaccines', 'injecctions', 'animal'));
}
public function ejecutar_vacunas(Request $request)
{
$rules = array('dateApplication' => 'required', 'boosterInjection' => 'required', 'dose' => 'required', 'responsible' => 'required');
$this->validate($request, $rules);
$dateA = Input::get('dateApplication');
$dateApplication = date(microtime(substr($dateA, 6, 4) . "-" . substr($dateA, 3, 2) . "-" . substr($dateA, 0, 2) . " " . substr($dateA, 10, 6)) * 10000);
$boosterI = Input::get('boosterInjection');
$boosterInjection = date(microtime(substr($dateA, 6, 4) . "-" . substr($dateA, 3, 2) . "-" . substr($dateA, 0, 2) . " " . substr($dateA, 10, 6)) * 10000);
$price = Vaccine::where('id', $request->vaccineName)->pluck('price_ml');
$vc = new VaccinationControl();
$vc->idUser = Auth::id();
$vc->animalName = $request->animalName;
$vc->diseaseName = $request->animalName;
$vc->vaccineName = $request->vaccineName;
$vc->dateApplication = $request->dateApplication;
$vc->dose = $request->dose;
$vc->value = $request->dose * $price;
$vc->responsible = $request->responsible;
$vc->boosterInjection = $request->boosterInjection;
$vc->save();
$event = new Calendar();
$event->idUser = Auth::id();
$event->title = 'Vacunacion';
$event->body = 'Programada';
$event->url = 'http://localhost:8000/vaccinationControl';
$event->class = 'Preventivo';
$event->start = $dateApplication;
$event->end = $boosterInjection;
$event->save();
return redirect()->route('animal.index');
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show()
{
$reports = VaccinationControl::all();
return view('vaccinationControls.show', compact('reports'));
/*
$dateApplication_Q=\DB::table('vaccination_controls')
->select('vaccination_controls.dateApplication')
->get();
$dateApplication=json_decode(json_encode($dateApplication_Q), true);
$dose_Q= \DB::table('vaccination_controls')
->select('vaccination_controls.dose')
->get();
$dose=json_decode(json_encode($dose_Q), true);
$boosterInjection_Q= \DB::table('vaccination_controls')
->select('vaccination_controls.boosterInjection')
->get();
$boosterInjection=json_decode(json_encode($boosterInjection_Q), true);
$disease_Q=\DB::table('diseases')
->join('vaccination_controls','idDisease','=','diseases.id')
->select('diseases.name')
->get();
$disease=json_decode(json_encode($disease_Q), true);
$animal_Q=\DB::table('animals')
->join('vaccination_controls','idAnimal','=','animals.id')
->select('animals.nombre')
->get();
$animal=json_decode(json_encode($animal_Q), true);
$vaccine_Q=\DB::table('vaccines')
->join('vaccination_controls','idVaccine','=','vaccines.id')
->select('vaccines.name')
->get();
$vaccine=json_decode(json_encode($vaccine_Q), true);
//dd($dateApplication);
$reports=collect(["dateApplication"=>$dateApplication_Q]);*/
//dd($reports);
}
