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