/** * 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'); }