/** * Store a newly created resource in storage. * * @return Response */ public function store(CrearCampRequest $request) { $camp = new Camp($request->all()); if (!($request->punts == "")) { //dd($request->poligon); $centre = GoogleMapsController::calcularCentrePoligon($request->punts); $arraycoords = GoogleMapsController::stringToArray($request->punts); //es forma el string per a insertar en mysql el linestring. Entre punt i //punt s'inserta una ',' excepte l'ultim punt (no es guarda si acaba en ',') $string = 'GeomFromText(\'LINESTRING('; for ($i = 0; $i < count($arraycoords); $i++) { $string = $string . $arraycoords[$i] . ' '; $i++; if (!($i < count($arraycoords) - 1)) { $string = $string . $arraycoords[$i]; } else { $string = $string . $arraycoords[$i] . ','; } } $string = $string . ')\')'; $camp->poligon = DB::raw($string); $camp->centre = DB::raw('PointFromText(\'POINT(' . $centre[0] . ' ' . $centre[1] . ')\')'); } $camp->user_profile_id = UserProfile::perfilId(Auth::user()->id); $camp->save(); return redirect('home/camp/' . $camp->id); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { if (UserProfile::perfilId($this->auth->user()->id) === Cultiu::perfilId(app()->router->getCurrentRoute()->getParameter('cultiu'))) { return $next($request); } else { if ($request->ajax()) { return response('Unauthorized.', 401); } else { return new RedirectResponse(url('/home')); } } }
public function actualitzarEvents() { $camps = Camp::idCampsUsuari(UserProfile::perfilId(Auth::user()->id)); if (!is_null($camps)) { foreach ($camps as $item) { $resultatcultius[] = Cultiu::idCultiusCamp($item['id']); } foreach ($resultatcultius as $cultiuscamp) { if (isset($cultiuscamp)) { if (!is_null($cultiuscamp)) { foreach ($cultiuscamp as $item) { if (isset($item)) { if (!is_null($item)) { $cultius[] = $item; } } } } } } } //dd($cultius); if (!is_null($cultius)) { $events = Event::eventsUsuari($cultius); } //dd($events); foreach ($events as $event) { //dd($event['cultiu_id']); //$event->cultiu_id = //obtindre el registre del cultiu_id actual $key1 = array_search($event['id'], array_column($events, 'id')); //array multidimensional //obtindre el registre dins de $cultius on està el cultiu_id actual $key2 = array_search($event['cultiu_id'], array_column($cultius, 'id')); //array multidimensional //obtindre el registre dins de "camps del camp_id actual //$key3 = $cultius[$key2]['camp_id']; //dd($cultius[$key2]['camp_id']); $key3 = array_search($cultius[$key2]['camp_id'], array_column($camps, 'id')); //array multidimensional //dd($key3); //modificar a $events el id del cultiu pel nom del cultiu $events[$key1]['cultiu_nom'] = $cultius[$key2]['nom']; $events[$key1]['bancal_nom'] = $camps[$key3]['nom']; $events[$key1]['bancal_id'] = $camps[$key3]['id']; //$key = array_search($event['cultiu_id'], $cultius); //array unidimensional //dd($events[$key1]); } //dd($events); return view('homeevents')->with('dades', $events); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { // dd("hola"); // dd(app()->router->getCurrentRoute()->getParameter('perfil')); //dd($this->auth->user()->id); //dd(UserProfile::perfilId($this->auth->user()->id)); if (UserProfile::perfilId($this->auth->user()->id) === app()->router->getCurrentRoute()->getParameter('id')) { return $next($request); } else { if ($request->ajax()) { return response('Unauthorized.', 401); } else { dd("NO"); //return redirect()->guest('/'); return new RedirectResponse(url('/home')); } } }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { $cultiu = new Cultiu(); $array = ['user' => UserProfile::perfilId(\Auth::user()->id), 'camp' => \Input::get('id')]; return view('crear.cultiu', ['user' => UserProfile::perfilId(\Auth::user()->id), 'camp' => \Input::get('id'), 'cultiu' => $cultiu]); }
static function dibuixarMapa($id, $tipus) { $llistat = ""; $centre = ""; $coordenades = null; $items = null; switch ($tipus) { case 0: //usuari $info['poble'] = UserProfile::poblacio($id); $llistat = HomeController::llistarCamps($id); $items = Camp::campsUsuari($id); $ubicacio_centre = 'no_valor'; break; case 1: //camp $info = Camp::infoCamp($id); $ubicacio = Camp::coordenades($id); $llistat = CampController::llistarCultius($id); if (!is_null($ubicacio['ubicacio'])) { $coordenades[] = ['punts' => GoogleMapsController::formarPoligon($ubicacio['ubicacio']), 'color' => '#FF0000', 'info' => GoogleMapsController::crearInfowindow($id, UserProfile::perfilId(Auth::user()->id))]; $ubicacio_centre['y'] = $ubicacio['centrey']; $ubicacio_centre['x'] = $ubicacio['centrex']; $items = Camp::campsVeins($id); } else { $ubicacio_centre = 'no_valor'; } break; default: return false; break; } foreach ($items as $item) { if (!is_null($temp = Camp::coordenades($item->id))) { $coordenades[] = ['punts' => GoogleMapsController::formarPoligon($temp['ubicacio']), 'color' => GoogleMapsController::getColor($item->id, UserProfile::perfilId(Auth::user()->id)), 'info' => GoogleMapsController::crearInfowindow($item->id, UserProfile::perfilId(Auth::user()->id))]; } } $dades = ['ubicacio' => $info['poble'], 'ubicacio_centre' => $ubicacio_centre, 'info' => $info, 'id' => $id, 'cultius' => $llistat, 'coordenades' => $coordenades]; return $dades; }