public function getMovies(Request $request) { date_default_timezone_set('Europe/Moscow'); if ($request->input('city_id') == null) { $city = $request->user()->city_id; } else { $city = $request->input('city_id'); } $cities = Cities::orderBy('city')->get(); $cityList = []; foreach ($cities as $key => $value) { $cityList[$value->id] = $value->city; } $cinemas = Cinemas::where("city_id", $city)->orderBy("title")->get(); $cinemasIds = array_pluck($cinemas, "id"); $seances = \App\Seances::whereIn("cinema_id", $cinemasIds)->where("start_time", '>', date("Y-m-d H:i:s"))->groupBy("movie_id")->with('getMovie')->get(); $movies = []; foreach ($seances as $item) { $movie = $item->getMovie->getAttributes(); $poster = json_decode($item->getMovie->poster)->name; $movie['poster'] = $poster; //Helper::getPosterLink($poster); $movies[] = $movie; } return view()->make('search.movies_filter', array('movies' => $movies, 'cityList' => $cityList, 'city' => $city)); }
public static function store(array $city) { $city = array_only($city, array('id', 'title', 'alias')); $city['city'] = $city['title']; unset($city['title']); $cities = Cities::firstOrNew($city); $cities->save(); }
public function post(Request $request) { $validation = Validator::make($request->all(), ['state' => 'required']); $cities = ""; if (!$validation->fails()) { $cities = Cities::where('uf', $request->state)->get(); } return json_encode($cities); }
public function editProfile(Request $request) { $user = User::find($request->user()->id); $cities = Cities::orderBy('city')->get(); $cityList = []; foreach ($cities as $key => $value) { $cityList[$value->id] = $value->city; } return view()->make('user.edit', array('user' => $user, 'cityList' => $cityList)); }
public function getAddress() { $page = 'meu-endereco'; //WEBSITE SETTINGS $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); //STATES $statesConsult = \App\Exceptions\Handler::readFile("states.json"); $states = ['' => 'Estado']; foreach ($statesConsult as $state) { $states[$state['name']] = $state['name']; } //CITIES $citiesConsult = Cities::where('uf', '=', '' . Auth::getUser()->state . '')->get(); $cities = ['' => 'Cidade']; foreach ($citiesConsult as $city) { $cities[$city['name']] = $city['name']; } $pages = Pages::where('slug', '=', $page)->first(); return view('website.profile.address')->with(compact('page', 'websiteSettings', 'pages', 'states', 'cities')); }
public static function getStaticValues($type) { $file = public_path("upload/Tmp" . $type . ".json.gz"); if ($type == "Cities") { $link = "https://api.kinohod.ru/api/data/1/eed7c723-0b90-3fc9-a3bc-bf235e907b35/cities.json.gz"; } else { $link = "https://api.kinohod.ru/api/data/1/eed7c723-0b90-3fc9-a3bc-bf235e907b35/genres.json.gz"; } file_put_contents($file, fopen($link, 'r')); $fp = gzopen($file, "r"); if ($fp != false) { $contents = gzread($fp, 50000000); $jsonArray = json_decode($contents, true); foreach ($jsonArray as $key => $value) { $type == "Cities" ? Cities::store($value) : Genres::store($value); } gzclose($fp); unlink($file); } else { echo "404 not found"; } }
public function addToCalendar(Request $request, $dialog, $id) { $client = new Google_Client(); $client->setScopes(SCOPES); $client->setAuthConfigFile(CLIENT_SECRET_PATH); //$client->setAccessType('offline'); $client->setRedirectUri('http://' . $_SERVER['HTTP_HOST'] . '/google_calendar_callback'); // $credentialsPath = $this->expandHomeDirectory(CREDENTIALS_PATH); $request->session()->put('dialog', $dialog); $request->session()->put('seance', $id); // Request authorization from the user. if ($request->session()->get('access_token')) { $accessToken = $request->session()->get('access_token'); $client->setAccessToken($accessToken); // Refresh the token if it's expired. if ($client->isAccessTokenExpired()) { $client->refreshToken(Session::find($request->session()->getId())); } } else { // Request authorization from the user. $authUrl = $client->createAuthUrl(); return Response::make('', 302)->header('Location', filter_var($authUrl, FILTER_SANITIZE_URL)); } $d = Messages::where('dialog_num', $dialog)->first(); $user = User::where('id', $d->user_id_received == $request->user()->id ? $d->user_id_sent : $d->user_id_received)->first(); $seance = Seances::where('id', $id)->with('getCinema')->with('getMovie')->first(); $service = new Google_Service_Calendar($client); $start_date = new DateTime($seance->start_time); $start_date->sub(new DateInterval('PT3H')); $end_date = new DateTime($seance->start_time); $end_date->add(new DateInterval('PT' . $seance->getMovie->duration . 'M')); $end_date->sub(new DateInterval('PT3H')); $event = new Google_Service_Calendar_Event(array('summary' => 'Поход в кино', 'location' => Cities::find($seance->getCinema->city_id)->first()->city . ", " . $seance->getCinema->address, 'description' => $seance->getMovie->title, 'start' => array('dateTime' => $start_date->format('Y-m-d\\TH:i:sP'), 'timeZone' => 'Europe/Moscow'), 'end' => array('dateTime' => $end_date->format('Y-m-d\\TH:i:sP'), 'timeZone' => 'Europe/Moscow'), 'recurrence' => array('RRULE:FREQ=DAILY;COUNT=1'), 'attendees' => array(array('email' => $user->email)), 'reminders' => array('useDefault' => FALSE, 'overrides' => array(array('method' => 'email', 'minutes' => 24 * 60), array('method' => 'popup', 'minutes' => 10))))); $calendarId = 'primary'; $event = $service->events->insert($calendarId, $event); return Response::make('', 302)->header('Location', filter_var($event->htmlLink, FILTER_SANITIZE_URL)); }
public function getEditStore($id) { $store = MerchantStore::with(['Address', 'tags', 'Merchant'])->where('id', $id)->first(); $tags = Tag::all(); $cities = Cities::all(); $areas = Areas::all(); $states = States::all(); $countries = Countries::all(); $output = ['store' => $store, 'tags' => $tags, 'areas' => $areas, 'cities' => $cities, 'states' => $states, 'countries' => $countries]; return view('admin.storeEdit', $output); }
public function allElementsV2() { $output = ['tags' => Tag::get(), 'cities' => Cities::with('Areas')->get(), 'states' => States::get(), 'countries' => Countries::get(), 'appElements' => AppElement::find(1)]; return response()->json(['response_code' => 'RES_STS', 'messages' => 'States', 'data' => $output]); }
public function getCities() { return response()->json(['response_code' => 'RES_CTY', 'messages' => 'Cities', 'data' => Cities::get()]); }