/**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function store(Request $request)
 {
     $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($boosterI, 6, 4) . "-" . substr($boosterI, 3, 2) . "-" . substr($boosterI, 0, 2) . " " . substr($boosterI, 10, 6)) * 10000);
     //dd($request->diseaseName);
     $animalName = Animal::where('id', $request->animalName)->pluck('nombre');
     $diseaseName = Disease::where('id', $request->diseaseName)->pluck('name');
     $vaccineName = Vaccine::where('id', $request->vaccineName)->pluck('name');
     $vc = new VaccinationControl();
     $vc->idUser = Auth::id();
     $vc->animalName = $animalName;
     $vc->diseaseName = $diseaseName;
     $vc->vaccineName = $vaccineName;
     $vc->dateApplication = Input::get('dateApplication');
     $vc->dose = Input::get('dose');
     $vc->responsible = Input::get('responsible');
     $vc->boosterInjection = Input::get('boosterInjection');
     //dd($vc);
     $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('vaccinationControl.show');
 }
 /**
  * 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'));
 }
 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Request $request, $id)
 {
     $rules = ['animal' => 'required', 'id_raza' => ['required', 'not_in:0'], 'id_estado' => ['required', 'not_in:0']];
     $this->validate($request, $rules);
     $datos = $request->all();
     $animal = \App\Animal::find($id);
     $animal->animal = $datos['animal'];
     $animal->id_raza = $datos['id_raza'];
     $animal->descripcion = $datos['descripcion'];
     $animal->id_estado = $datos['id_estado'];
     $animal->save();
     $request->session()->flash('msj_success', 'Se ha actualizado correctamente el animal: ' . $datos['animal']);
     return redirect()->route('animales.index');
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $Request)
 {
     $Animal = new Animal();
     $Animal->idAnimal = $Request->codigo;
     $Animal->procedencia = $Request->procedencia;
     $Animal->codigo = $Request->codigo;
     $Animal->raza = $Request->raza;
     $Animal->sexo = $Request->sexo;
     $Animal->estado = $Request->estado;
     $Animal->fechaDestete = $Request->fechadestete;
     $Animal->pesoNacer = $Request->pesoNacer;
     $Animal->pesoDestete = $Request->pesoDestete;
     $Animal->fechaConsumo = $Request->fechaConsumo;
     $Animal->codigoParto = $Request->codParto;
     $Animal->fechaParto = $Request->fechaparto;
     $Animal->codigoMadre = $Request->codMadre;
     $Animal->Edad = $Request->edad;
     $Animal->razaMadre = $Request->razamadre;
     $Animal->razaPadre = $Request->razapadre;
     $Animal->tipoAnimal = $Request->tipoAnimal;
     $Animal->remember_token = $Request->_token;
     $Animal->save();
     return redirect('MenuPrincipal');
 }
 public function milk_production($id)
 {
     $animals = Animal::where('idUser', Auth::id())->get();
     return view('animals.milk_production', compact('animals'));
 }
 public function getFiltraranimal(Request $request)
 {
     if (!$request->ajax()) {
         abort(403);
     }
     $datos = array();
     $inputs = $request->all();
     if (empty($inputs['search'])) {
         $animales = \App\Animal::select(\DB::raw('SQL_CALC_FOUND_ROWS *'), 'id')->where('id', '>', 0)->take($inputs['limit'])->skip($inputs['offset'])->orderBy('created_at', 'ASC')->get();
     } else {
         $animales = \App\Animal::select(\DB::raw('SQL_CALC_FOUND_ROWS *'), 'id')->where('animal', 'LIKE', '%' . $inputs["search"] . '%')->take($inputs['limit'])->skip($inputs['offset'])->orderBy('created_at', 'ASC')->get();
     }
     $cantidad = \DB::select(\DB::raw("SELECT FOUND_ROWS() AS total;"));
     $cantidad = $cantidad[0]->total;
     $n = 1;
     foreach ($animales as $animal) {
         $url = '<a href="' . route('animales.edit', $animal->id) . '" class="btn btn-xs btn-success"><i class="fa fa-btn fa-edit"></i>Editar</a>';
         $datos[] = ['num' => $n++, 'animal' => $animal->animal, 'act' => $url];
     }
     return \Response::json(['total' => $cantidad, 'rows' => $datos]);
 }
 public function modificarAnimal(Animal $animal)
 {
     DB::table('animal')->where('idAnimal', $animal->getIdAnimal())->update(['Codigo' => $animal->getCodigo(), 'Nombre' => $animal->getNombre(), 'Sexo' => $animal->getSexo(), 'Esterilizacion' => $animal->getEsterilizacion(), 'FechaDeNacimiento' => $animal->getFechaNacimiento(), 'Estado' => $animal->getEstado(), 'Observacion' => $animal->getObservacion(), 'Color' => $animal->getColor(), 'Pedigree' => $animal->getPedigree(), 'NumPedigree' => $animal->getNumPedigree(), 'Cliente_idCliente' => $animal->getIdCliente(), 'Raza_idRaza' => $animal->getIdraza()]);
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return Response
  */
 public function destroy($id)
 {
     Animal::destroy($id);
     alert()->success('', 'Animal successfully deleted!');
     return redirect('animal');
 }