/**
* 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_injection(Request $requestI)
{
$rules = array('dateApplication' => 'required', 'boosterInjection' => 'required', 'dose' => 'required', 'responsible' => 'required');
$this->validate($requestI, $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 = Injection::where('id', $requestI->injectionName)->pluck('price_ml');
$ic = new InjecctionControl();
$ic->idUser = Auth::id();
$ic->animalName = $requestI->animalName;
$ic->diseaseName = $requestI->diseaseName;
$ic->injectionName = $requestI->injectionName;
$ic->dateApplication = $requestI->dateApplication;
$ic->dose = $requestI->dose;
$ic->value = $requestI->dose * $price;
$ic->responsible = $requestI->responsible;
$ic->boosterInjection = $requestI->boosterInjection;
$ic->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');
}
