示例#1
0
 /**
  *  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;
     }
 }
示例#2
0
 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'));
 }
示例#3
0
 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";
     }
 }
示例#4
0
 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'));
 }
示例#7
0
 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";
     }
 }