/** * Convert type ID into something meaningful for human */ public static function type_return($type_id, $user_id, $beer_id, $text = null, $place_id = null, $img_id = null) { switch ($type_id) { //User had this drink case '101': return "had this drink!"; break; //User like this //User like this case '102': return "like this"; break; //User want this //User want this case '103': return "want this"; break; //Image posted //Image posted case '200': $data = BeerImg::getImage($img_id); return " uploaded " . "<img src=\"{$data->path}\" class=\"img-responsive\">"; break; //Check-in //Check-in case '300': $data = Places::userBeerPlace($user_id, $beer_id, $place_id); return "check in " . GlobalUrl::place_url($data) . " having " . $data->beer; break; } }
public static function place(Request $request) { $fb_place_id = substr(strrchr($request->name, "-"), 1); $place_info = \App\Places::where('place_id', $fb_place_id)->first(); $drink_here = DB::table('checkin')->groupBy('checkin.beer_id')->where('checkin.place_id', $fb_place_id)->join('places', 'checkin.place_id', '=', 'places.place_id')->join('beers', 'beers.id', '=', 'checkin.beer_id')->take(5)->get(); $been_here = Places::userCheckin($fb_place_id); $img_here = Places::imagesCheckin($fb_place_id); $page_title = "Beerhit!"; $page_descs = "what hit you?"; return view('places.place', compact('page_title', 'page_descs', 'place_info', 'drink_here', 'been_here', 'img_here')); }
public static function checkin_callback() { if (isset(\Auth::user()->id)) { //All the vars $user_id = \Auth::user()->id; $beer_id = Input::get('beer_id'); $fb_place_id = Input::get('fb_place_id'); $image_unique_id = 0; /* * If there is any images * */ if (Input::file('image')) { $image_unique_id = date('Ymdhis') . rand(0, 9999); $beer_meta = new BeerImg(); $beer_meta->beer_id = $beer_id; $beer_meta->description = Input::get('description'); $beer_name = Input::get('name'); $imageName = "beerhit.com_" . strtolower($beer_name) . $beer_meta->beer_id . $image_unique_id . '.' . Input::file('image')->getClientOriginalExtension(); $path = public_path('/images/catalog/' . $imageName); $img = ImageManagerStatic::make(Input::file('image')); // resize the image to a width of 960 // and constrain aspect ratio (auto width) $img->resize(960, null, function ($constraint) { $constraint->aspectRatio(); $constraint->upsize(); }); $img->save($path); //Save image information to database $beer_meta->img_id = $image_unique_id; $beer_meta->filename = $imageName; $beer_meta->path = '/images/catalog/' . $imageName; $beer_meta->user_id = \Auth::user()->id; $beer_meta->place_id = $fb_place_id; $beer_meta->save(); } $checkin = new Checkin(); $checkin->user_id = $user_id; $checkin->place_id = $fb_place_id; $checkin->beer_id = $beer_id; $checkin->source = 1; //we are using facebook, 1 for now $checkin->save(); $place = ['place_id' => Input::get('fb_place_id'), 'name' => Input::get('location'), 'category' => Input::get('fb_category'), 'street' => Input::get('fb_address'), 'city' => Input::get('fb_city'), 'state' => Input::get('fb_state'), 'zip' => Input::get('fb_zip'), 'latitude' => Input::get('fb_lat'), 'longitude' => Input::get('fb_lng')]; $place_meta = Places::updateOrCreate(['place_id' => Input::get('fb_place_id')])->update($place); //Log information \UserBeerHelper::userLog($user_id, $beer_id, 300, $fb_place_id, $image_unique_id); return redirect("profile/" . \Auth::user()->username); } else { return "err - user not login"; } }
public static function checkin_callback() { if (isset(\Auth::user()->id)) { $checkin = new Checkin(); $checkin->user_id = \Auth::user()->id; $checkin->place_id = Input::get('fb_place_id'); $checkin->beer_id = Input::get('beer_id'); $checkin->source = 1; //we are using facebook, 1 for now $checkin->save(); $place = ['place_id' => Input::get('fb_place_id'), 'name' => Input::get('location'), 'category' => Input::get('fb_category'), 'street' => Input::get('fb_address'), 'city' => Input::get('fb_city'), 'state' => Input::get('fb_state'), 'zip' => Input::get('fb_zip'), 'country' => Input::get('fb_country'), 'latitude' => Input::get('fb_lat'), 'longitude' => Input::get('fb_lng')]; $place_meta = Places::updateOrCreate(['place_id' => Input::get('fb_place_id')])->update($place); } else { return "err - user not login"; } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $request_params = $request->all(); $rules = array('establecimiento' => 'required|max:150|min:2', 'nombre_partido' => 'required|max:50|min:2', 'nombre_provincia' => 'required|max:50|min:2', 'nombre_pais' => 'required|max:50|min:4'); $messages = array('required' => 'El :attribute es requerido.', 'max' => 'El :attribute debe poseer un maximo de :max caracteres.', 'min' => 'El :attribute debe poseer un minimo de :min caracteres.'); $validator = Validator::make($request_params, $rules, $messages); if ($validator->passes()) { $place = Places::find($id); $place->establecimiento = $request_params['establecimiento']; $place->calle = $request_params['calle']; $place->tipo = $request_params['tipo']; $place->altura = $request_params['altura']; $place->piso_dpto = $request_params['piso_dpto']; $place->observacion = $request_params['observacion']; $place->cruce = $request_params['cruce']; $place->latitude = $request_params['latitude']; $place->longitude = $request_params['longitude']; $place->confidence = $request_params['confidence']; $place->barrio_localidad = $request_params['barrio_localidad']; $place->idPais = $request_params['idPais']; $place->idProvincia = $request_params['idProvincia']; $place->idPartido = $request_params['idPartido']; $place->prueba = $request_params['prueba']; $place->responsable_testeo = $request_params['responsable_testeo']; $place->ubicacion_testeo = $request_params['ubicacion_testeo']; $place->horario_testeo = $request_params['horario_testeo']; $place->mail_testeo = $request_params['mail_testeo']; $place->tel_testeo = $request_params['tel_testeo']; $place->web_testeo = $request_params['web_testeo']; $place->observaciones_testeo = $request_params['observaciones_testeo']; $place->condones = $request_params['condones']; $place->responsable_distrib = $request_params['responsable_distrib']; $place->ubicacion_distrib = $request_params['ubicacion_distrib']; $place->horario_distrib = $request_params['horario_distrib']; $place->mail_distrib = $request_params['mail_distrib']; $place->tel_distrib = $request_params['tel_distrib']; $place->web_distrib = $request_params['web_distrib']; $place->comentarios_distrib = $request_params['comentarios_distrib']; $place->infectologia = $request_params['infectologia']; $place->responsable_infectologia = $request_params['responsable_infectologia']; $place->ubicacion_infectologia = $request_params['ubicacion_infectologia']; $place->horario_infectologia = $request_params['horario_infectologia']; $place->mail_infectologia = $request_params['mail_infectologia']; $place->tel_infectologia = $request_params['tel_infectologia']; $place->web_infectologia = $request_params['web_infectologia']; $place->comentarios_infectologia = $request_params['comentarios_infectologia']; $place->vacunatorio = $request_params['vacunatorio']; $place->responsable_vac = $request_params['responsable_vac']; $place->ubicacion_vac = $request_params['ubicacion_vac']; $place->horario_vac = $request_params['horario_vac']; $place->mail_vac = $request_params['mail_vac']; $place->tel_vac = $request_params['tel_vac']; $place->web_vac = $request_params['web_vac']; $place->comentarios_vac = $request_params['comentarios_vac']; //Updating localidad if (isset($request_params['otro_partido'])) { if ($request_params['otro_partido'] != '') { $localidad_tmp = DB::table('partido')->where('partido.idPais', $place->idPais)->where('partido.idProvincia', $place->idProvincia)->where('nombre_partido', '=', $request_params['otro_partido'])->select()->get(); if (count($localidad_tmp) === 0) { $localidad = new Partido(); $localidad->nombre_partido = $request_params['otro_partido']; $localidad->idProvincia = $place->idProvincia; $localidad->idPais = $place->idPais; $localidad->habilitado = true; $localidad->updated_at = date("Y-m-d H:i:s"); $localidad->created_at = date("Y-m-d H:i:s"); $localidad->save(); $place->idPartido = $localidad->id; } else { $place->idPartido = $localidad_tmp[0]->id; } } } $place->updated_at = date("Y-m-d H:i:s"); $place->save(); } return $validator->messages(); }
public function posAdd(Request $request) { $datosNuevos = $request->session()->get('datosNuevos'); $cantidadNuevos = $request->session()->get('cantidadNuevos'); // $datosNuevos = unserialize($TMPdatosNuevos); $datosRepetidos = $request->session()->get('datosRepetidos'); $cantidadRepetidos = $request->session()->get('cantidadRepetidos'); // $datosRepetidos = unserialize($TMPdatosRepetidos); $datosDescartados = $request->session()->get('datosDescartados'); $cantidadDescartados = $request->session()->get('cantidadDescartados'); // $datosDescartados = unserialize($TMPdatosDescartados); $datosUnificar = $request->session()->get('datosUnificar'); $cantidadUnificar = $request->session()->get('cantidadUnificar'); // $datosUnificar = unserialize($TMPdatosUnificar); $datosIncompletos = $request->session()->get('datosIncompletos'); $cantidadIncompletos = $request->session()->get('cantidadIncompletos'); // dd(session()->get('datosNuevos') != null); if (session()->get('datosNuevos') != null) { foreach ($datosNuevos as $book) { //agrego nuevo $existePais = DB::table('pais')->where('pais.nombre_pais', 'like', '%' . $book['pais'] . '%')->first(); $existeProvincia = DB::table('provincia')->join('pais', 'pais.id', '=', 'provincia.idPais')->where('pais.nombre_pais', 'like', '%' . $book['pais'] . '%')->where('provincia.nombre_provincia', 'like', '%' . $book['provincia_region'] . '%')->first(); $existePartido = DB::table('partido')->join('provincia', 'provincia.id', '=', 'partido.idProvincia')->join('pais', 'pais.id', '=', 'partido.idPais')->where('pais.nombre_pais', 'like', '%' . $book['pais'] . '%')->where('provincia.nombre_provincia', 'like', '%' . $book['provincia_region'] . '%')->where('partido.nombre_partido', 'like', '%' . $book['partido_comuna'] . '%')->first(); $finalIdPais = 0; $finalIdProvincia = 0; $finalIdPartido = 0; if ($existePais) { $finalIdPais = $existePais->id; } if ($existeProvincia) { $finalIdProvincia = $existeProvincia->id; } if ($existePartido) { $finalIdPartido = $existePartido->id; } //normalizacion $book['vacunatorio'] = $this->parseToImport($book['vacunatorio']); $book['infectologia'] = $this->parseToImport($book['infectologia']); $book['condones'] = $this->parseToImport($book['condones']); $book['prueba'] = $this->parseToImport($book['prueba']); $book['mac'] = $this->parseToImport($book['mac']); if (!$existePais) { //PAIS $pais = new Pais(); $pais->nombre_pais = $book['pais']; $pais->save(); $finalIdPais = $pais->id; } //del existe pais if (!$existeProvincia) { //CASO 2, no existe la provincia en la BD //PROVINCIA $provincia = new Provincia(); $provincia->nombre_provincia = $book['provincia_region']; $provincia->idPais = $finalIdPais; $provincia->save(); $finalIdProvincia = $provincia->id; } //del provincia if (!$existePartido) { //CASO 3, no existe partido en la BD //PARTIDO $partido = new Partido(); $partido->nombre_partido = $book['partido_comuna']; $partido->idPais = $finalIdPais; $partido->idProvincia = $finalIdProvincia; $partido->save(); $finalIdPartido = $partido->id; } //PLACES //aca $places = new Places(); $places->idPais = $finalIdPais; $places->idProvincia = $finalIdProvincia; $places->idPartido = $finalIdPartido; $places->establecimiento = $book['establecimiento']; $places->tipo = $book['tipo']; $places->calle = $book['calle']; $places->altura = $book['altura']; $places->piso_dpto = $book['piso_dpto']; $places->cruce = $book['cruce']; $places->barrio_localidad = $book['barrio_localidad']; $places->aprobado = $book['aprobado']; $places->observacion = $book['observacion']; $places->formattedAddress = $book['formattedAddress']; $places->latitude = $book['latitude']; $places->longitude = $book['longitude']; $places->habilitado = $book['habilitado']; $places->vacunatorio = $book['vacunatorio']; $places->infectologia = $book['infectologia']; $places->condones = $book['condones']; $places->prueba = $book['prueba']; $places->tel_testeo = $book['tel_testeo']; $places->mail_testeo = $book['mail_testeo']; $places->horario_testeo = $book['horario_testeo']; $places->responsable_testeo = $book['responsable_testeo']; $places->web_testeo = $book['web_testeo']; $places->ubicacion_testeo = $book['ubicacion_testeo']; $places->observaciones_testeo = $book['observaciones_testeo']; $places->tel_distrib = $book['tel_distrib']; $places->mail_distrib = $book['mail_distrib']; $places->horario_distrib = $book['horario_distrib']; $places->responsable_distrib = $book['responsable_distrib']; $places->web_distrib = $book['web_distrib']; $places->ubicacion_distrib = $book['ubicacion_distrib']; $places->comentarios_distrib = $book['comentarios_distrib']; $places->tel_infectologia = $book['tel_infectologia']; $places->mail_infectologia = $book['mail_infectologia']; $places->horario_infectologia = $book['horario_infectologia']; $places->responsable_infectologia = $book['responsable_infectologia']; $places->web_infectologia = $book['web_infectologia']; $places->ubicacion_infectologia = $book['ubicacion_infectologia']; $places->comentarios_infectologia = $book['comentarios_infectologia']; $places->tel_vac = $book['tel_vac']; $places->mail_vac = $book['mail_vac']; $places->horario_vac = $book['horario_vac']; $places->responsable_vac = $book['responsable_vac']; $places->web_vac = $book['web_vac']; $places->ubicacion_vac = $book['ubicacion_vac']; //posible problema $places->comentarios_vac = $book['comentarios_vac']; $places->mac = $book['mac']; $places->save(); } } return view('panel.importer.results', compact('datosNuevos', 'cantidadNuevos', 'datosRepetidos', 'cantidadRepetidos', 'datosDescartados', 'cantidadDescartados', 'datosIncompletos', 'cantidadIncompletos', 'datosUnificar', 'cantidadUnificar')); }
public function userPost_callback() { if (isset(\Auth::user()->id)) { //All the vars $user_id = \Auth::user()->id; $beer_id = Input::get('beer_id'); $fb_place_id = Input::get('fb_place_id'); $image_unique_id = 0; if (Input::file('image')) { BeerImg::uploadBeerImg_callback(Input::get(), Input::file('image')); } if (!empty($ratingComment)) { //Preparing data to be added $beer_meta = \App\BeerRating::Add(Input::get()); $overall = \App\BeerRating::overallCalc(Input::get()); //Calculate overall scores $beer_meta->overall = round($overall, 1); $beer_meta->save(); //Increment votes tally DB::table('beers')->where('id', Input::get('beer_id'))->increment('votes'); DB::table('beers')->where('id', Input::get('beer_id'))->update(array('scores' => $overall)); } if (!empty($fb_place_id)) { $checkin = new Checkin(); $checkin->user_id = $user_id; $checkin->place_id = $fb_place_id; $checkin->beer_id = $beer_id; $checkin->source = 1; //we are using facebook, 1 for now $checkin->save(); $place = ['place_id' => Input::get('fb_place_id'), 'name' => Input::get('location'), 'category' => Input::get('fb_category'), 'street' => Input::get('fb_address'), 'city' => Input::get('fb_city'), 'state' => Input::get('fb_state'), 'zip' => Input::get('fb_zip'), 'latitude' => Input::get('fb_lat'), 'longitude' => Input::get('fb_lng')]; $place_meta = Places::updateOrCreate(['place_id' => Input::get('fb_place_id')])->update($place); //Log information \UserBeerHelper::userLog($user_id, $beer_id, 300, $fb_place_id, $image_unique_id); } return redirect("profile/" . \Auth::user()->username); } else { return "err - user not login"; } }