public function handleOfficesImport()
 {
     $file = Input::file('file');
     $folderPath = 'storage/offices/';
     $fileName = $file->getClientOriginalName();
     $file->move($folderPath, $fileName);
     $fileResults = Excel::load($folderPath . $fileName, function ($reader) {
     })->get();
     $officesFromFile = array();
     foreach ($fileResults as $fileResult) {
         foreach ($fileResult as $characteristicName => $characteristicValue) {
             if (isset($fileResult['Номер'])) {
                 $officesFromFile[$fileResult['Номер']][$characteristicName] = $characteristicValue;
             }
         }
     }
     $translator = new GoogleTranslater();
     foreach ($officesFromFile as $officeFromFile) {
         $city = City::with(array('region' => function ($query) use($officeFromFile) {
             $query->byTitle(trim($officeFromFile['Область']), 'ua');
         }))->byTitle(trim($officeFromFile['Город']), 'ua')->first();
         // create city if it doesn't exist
         if (!$city) {
             $region = Region::byTitle(trim($officeFromFile['Область']), 'ua')->first();
             // get geo coordinates from Google API
             $geoAddress = 'Україна, ' . $region->title . ' обл., м. ' . trim($officeFromFile['Город']);
             $geoResult = json_decode(file_get_contents('http://maps.googleapis.com/maps/api/geocode/json?' . http_build_query(array('address' => $geoAddress, 'sensor' => true))), true);
             $geoLatitude = $geoResult['results'][0]['geometry']['location']['lat'];
             $geoLongitude = $geoResult['results'][0]['geometry']['location']['lng'];
             // create city entity
             $city = City::create(array('id_region' => $region->id, 'title' => trim($officeFromFile['Город']), 'title_ru' => trim($officeFromFile['Город (рус)']), 'title_en' => $translator->translateText(trim($officeFromFile['Город']), "uk", "en"), 'latitude' => isset($geoLatitude) && $geoLatitude ? $geoLatitude : '', 'longitude' => isset($geoLongitude) && $geoLongitude ? $geoLongitude : '', 'is_active' => 1));
             if (!$city) {
                 return Response::json(array('status' => false));
             }
         }
         $officeData = array('id_city' => $city->id, 'number' => trim($officeFromFile['Номер']), 'address' => trim($officeFromFile['Адрес']), 'address_ru' => trim($officeFromFile['Адрес (рус)']), 'address_en' => $translator->translateText(trim($officeFromFile['Адрес']), "uk", "en") ?: '', 'title' => trim($officeFromFile['Название']), 'title_ru' => trim($officeFromFile['Название (рус)']), 'title_en' => $translator->translateText(trim($officeFromFile['Название']), "uk", "en") ?: '', 'description' => trim($officeFromFile['Описание']), 'description_ru' => trim($officeFromFile['Описание (рус)']), 'description_en' => $translator->translateText(trim($officeFromFile['Описание']), "uk", "en") ?: '', 'metro' => trim($officeFromFile['Станции метро']), 'metro_ru' => trim($officeFromFile['Станции метро (рус)']), 'metro_en' => $translator->translateText(trim($officeFromFile['Станции метро']), "uk", "en") ?: '', 'latitude' => trim($officeFromFile['Latitude']), 'longitude' => trim($officeFromFile['Longitude']), 'phones' => trim($officeFromFile['Телефоны']), 'director' => trim($officeFromFile['Директор']), 'director_ru' => trim($officeFromFile['Директор (рус)']), 'director_en' => $translator->translateText(trim($officeFromFile['Директор']), "uk", "en") ?: '', 'services' => trim($officeFromFile['Услуги']), 'services_ru' => trim($officeFromFile['Услуги (рус)']), 'services_en' => $translator->translateText(trim($officeFromFile['Услуги']), "uk", "en") ?: '', 'type' => str_replace(';', ',', trim($officeFromFile['Тип'])), 'atm_type' => str_replace(';', ',', trim($officeFromFile['Тип банкомата'])), 'atm_subtype' => str_replace(';', ',', trim($officeFromFile['Подтип банкомата'])), 'is_active' => trim($officeFromFile['Активность']) == 'Да' ? 1 : 0, 'schedule' => trim($officeFromFile['Режим работы']), 'schedule_ru' => $translator->translateText(trim($officeFromFile['Режим работы']), "uk", "ru") ?: '', 'schedule_en' => $translator->translateText(trim($officeFromFile['Режим работы']), "uk", "en") ?: '', 'schedule_operations' => trim($officeFromFile['Операционная касса']), 'schedule_operations_ru' => $translator->translateText(trim($officeFromFile['Операционная касса']), "uk", "ru") ?: '', 'schedule_operations_en' => $translator->translateText(trim($officeFromFile['Операционная касса']), "uk", "en") ?: '', 'schedule_operations_post' => trim($officeFromFile['Послеоперационная касса']), 'schedule_operations_post_ru' => $translator->translateText(trim($officeFromFile['Послеоперационная касса']), "uk", "ru") ?: '', 'schedule_operations_post_en' => $translator->translateText(trim($officeFromFile['Послеоперационная касса']), "uk", "en") ?: '');
         $existedOffice = Office::byNumber(trim($officeFromFile['Номер']))->first();
         if (!$existedOffice) {
             Office::create($officeData);
         } else {
             Office::where('number', trim($officeFromFile['Номер']))->update($officeData);
         }
     }
     return Response::json(array('status' => true));
 }
 public function run()
 {
     Office::truncate();
     Office::create(['id' => '1', 'officeName' => 'BAC']);
 }