public function run()
{
CityRef::truncate();
$cities = [['az' => 'digər', 'ru' => 'Другой'], ['az' => 'Astara', 'ru' => 'Астара'], ['az' => 'Ağcabədi', 'ru' => 'Агджабеди'], ['az' => 'Ağdam', 'ru' => 'Агдам'], ['az' => 'Ağdaş', 'ru' => 'Агдаш'], ['az' => 'Ağdərə', 'ru' => 'Агдере'], ['az' => 'Ağstafa', 'ru' => 'Акстафа'], ['az' => 'Ağsu', 'ru' => 'Аксу'], ['az' => 'Bakı', 'ru' => 'Баку'], ['az' => 'Balakən', 'ru' => 'Белокан'], ['az' => 'Beyləqan', 'ru' => 'Бейлаган'], ['az' => 'Biləsuvar', 'ru' => 'Билесувар'], ['az' => 'Bərdə', 'ru' => 'Барда'], ['az' => 'Culfa', 'ru' => 'Джульфа'], ['az' => 'Cəbrayıl', 'ru' => 'Джабраил'], ['az' => 'Cəlilabad', 'ru' => 'Джалилабад'], ['az' => 'Daşkəsən', 'ru' => 'Дашкесан'], ['az' => 'Dəliməmmədli', 'ru' => 'Делимамедли'], ['az' => 'Füzuli', 'ru' => 'Физули'], ['az' => 'Goranboy', 'ru' => 'Гёранбой'], ['az' => 'Göygöl', 'ru' => 'Гёйгёль'], ['az' => 'Göytəpə', 'ru' => 'Гёйтепе'], ['az' => 'Göyçay', 'ru' => 'Гёйчай'], ['az' => 'Gədəbəy', 'ru' => 'Гедабек'], ['az' => 'Gəncə', 'ru' => 'Гянджа'], ['az' => 'Horadiz', 'ru' => 'Горадиз'], ['az' => 'İmişli', 'ru' => 'Имишли'], ['az' => 'İsmayıllı', 'ru' => 'Исмаиллы'], ['az' => 'Kürdəmir', 'ru' => 'Кюрдамир'], ['az' => 'Kəlbəcər', 'ru' => 'Кельбаджар'], ['az' => 'Laçın', 'ru' => 'Лачин'], ['az' => 'Lerik', 'ru' => 'Лерик'], ['az' => 'Liman', 'ru' => 'Лиман'], ['az' => 'Lənkəran', 'ru' => 'Ленкорань'], ['az' => 'Masallı', 'ru' => 'Масаллы'], ['az' => 'Mingəçevir', 'ru' => 'Мингечаур'], ['az' => 'Naftalan', 'ru' => 'Нафталан'], ['az' => 'Naxçıvan', 'ru' => 'Нихичевань'], ['az' => 'Neftçala', 'ru' => 'Нефтчала'], ['az' => 'Ordubad', 'ru' => 'Ордубад'], ['az' => 'Oğuz', 'ru' => 'Огуз'], ['az' => 'Qax', 'ru' => 'Кахи'], ['az' => 'Qazax', 'ru' => 'Казах'], ['az' => 'Qobustan', 'ru' => 'Гобустан'], ['az' => 'Quba', 'ru' => 'Губа'], ['az' => 'Qubadlı', 'ru' => 'Губадлы'], ['az' => 'Qusar', 'ru' => 'Гусар'], ['az' => 'Qəbələ', 'ru' => 'Габала'], ['az' => 'Saatlı', 'ru' => 'Саатлы'], ['az' => 'Sabirabad', 'ru' => 'Сабирабад'], ['az' => 'Salyan', 'ru' => 'Сальян'], ['az' => 'Samux', 'ru' => 'Самух'], ['az' => 'Siyəzən', 'ru' => 'Сиязань'], ['az' => 'Sumqayıt', 'ru' => 'Сумгаит'], ['az' => 'Tovuz', 'ru' => 'Товуз'], ['az' => 'Tərtər', 'ru' => 'Тер-Тер'], ['az' => 'Ucar', 'ru' => 'Уджар'], ['az' => 'Xankəndi', 'ru' => 'Ханкенди'], ['az' => 'Xaçmaz', 'ru' => 'Хачмаз'], ['az' => 'Xocalı', 'ru' => 'Ходжалы'], ['az' => 'Xocavənd', 'ru' => 'Ходжавенд'], ['az' => 'Xudat', 'ru' => 'Худат'], ['az' => 'Xırdalan', 'ru' => 'Хырдалан'], ['az' => 'Xızı', 'ru' => 'Хызы'], ['az' => 'Yardımlı', 'ru' => 'Ярдымлы'], ['az' => 'Yevlax', 'ru' => 'Евлах'], ['az' => 'Zaqatala', 'ru' => 'Загатала'], ['az' => 'Zəngilan', 'ru' => 'Зенгилан'], ['az' => 'Zərdab', 'ru' => 'Зардаб'], ['az' => 'Şabran', 'ru' => 'Шабран'], ['az' => 'Şahbuz', 'ru' => 'Шахбуз'], ['az' => 'Şamaxı', 'ru' => 'Шемаха'], ['az' => 'Şirvan', 'ru' => 'Ширван'], ['az' => 'Şuşa', 'ru' => 'Шуша'], ['az' => 'Şəki', 'ru' => 'Шеки'], ['az' => 'Şəmkir', 'ru' => 'Шамкир'], ['az' => 'Şərur', 'ru' => 'Шарур']];
foreach ($cities as $city) {
CityRef::create($city);
}
}
/**
* Update the specified resource in storage.
* PATCH /cityrefs/{id}
*
* @param int $id
* @return Response
*/
public function update($id)
{
$city = CityRef::find($id);
if (!$city) {
return $this->respondNotFound('City not found');
}
if ($city->fill(Input::all())) {
return $city;
}
return $this->respondServerError('Error updating city');
}
/**
* Display the specified resource.
* GET /admin/users/{id}
*
* @param int $id
* @return Response
*/
public function show($id)
{
$user = User::withTrashed()->find($id);
return View::make('admin.users.show', ['title' => $user->name, 'img' => $user->img_middle, 'id' => $user->id, 'user' => [['Имя', $user->name], ['Пол', $user->sex], ['День рождения', $user->birthday], ['Город', $this->returnIfPresent(CityRef::find($user->city), 'ru')], ['Телефон', $this->returnIfPresent($user->phone, 'number')], ['Почта', $user->email], ['О себе', $user->about]], 'actions' => $this->makeLinks($this->expandList([['show', 'Профиль'], ['cars', 'Список машин'], ['chats', 'Чаты'], ['blackList', 'Блокированные пользователи'], ['posts', 'Посты'], ['comments', 'Комментарии'], ['devices', 'Устройства'], ['images', 'Изображения']]), ['controller' => 'AdminUsersController', 'params' => [$user->id]]), 'statistics' => [['string' => 'отправленных сообщений', 'value' => $user->messages()->count()], ['string' => 'отправленных срочных вызовов', 'value' => $user->emergencies()->count()], ['string' => 'сделанных пользователем первых контактов', 'value' => 12], ['string' => 'постов', 'value' => $user->posts->count()], ['string' => 'полученныз пользователем комментариев', 'value' => $user->comments->count()], ['string' => 'полученных пользователем лайков', 'value' => $user->likes->count()], ['string' => 'отправленных жалоб', 'value' => $user->complaints()->count()], ['string' => 'жалоб на пользователя', 'value' => $user->complaintsToMe()->count()], ['string' => 'блокированных пользователем', 'value' => $user->blockedUsers()->count()], ['string' => 'пользователей заблокировавших данного пользователя', 'value' => $user->blockedMeUsers()->count()]]]);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$locales = ['ru', 'az'];
if ($this->option('with_categories')) {
$this->info("Compile categories is on");
MarkRef::with('models')->get()->each(function ($mark) {
$this->line("Looking for {$mark->name}");
$category = Generator::findOrCreate($mark->name);
if ($category) {
Generator::findOrCreate("Все о {$mark->name}", '', $category->id);
$mark->models->each(function ($model) use($mark, $category) {
$this->line("Looking on {$model->name}");
Generator::findOrCreate($mark->name . ' ' . $model->name, 'Все что касается этой модели.', $category->id);
});
}
});
}
$configDate = Carbon::now()->toDateTimeString();
$oldConfigDate = Config::get('database.refs-version');
foreach ($locales as $locale) {
$this->info('Compiling models');
$tempDate = Carbon::now();
$chunk = 200;
$this->line("Batch {$chunk}");
ModelRef::with('bodyTypes')->chunk($chunk, function ($models) use($oldConfigDate, $configDate, $locale) {
Cache::forget("models-{$oldConfigDate}-{$locale}-part{$models->last()->id}");
Cache::forever("models-{$configDate}-{$locale}-part{$models->last()->id}", $models->toArray());
$this->line("End of chunk {$models->last()->id}");
});
Cache::forget("models-{$oldConfigDate}-{$locale}");
Cache::forever("models-{$configDate}-{$locale}", ModelRef::all());
$this->info("Finished compiling models. {$tempDate->diffInSeconds(Carbon::now(), true)} seconds");
$this->info('Compiling marks');
$tempDate = Carbon::now();
Cache::forget("marks-{$oldConfigDate}-{$locale}");
Cache::forever("marks-{$configDate}-{$locale}", MarkRef::with('vehicleTypes')->get()->toArray());
$this->info("Finished compiling marks.{$tempDate->diffInSeconds(Carbon::now(), true)} seconds");
$this->info('Compiling vehicle types');
$tempDate = Carbon::now();
Cache::forget("vehicle-types-{$oldConfigDate}-{$locale}");
Cache::forever("vehicle-types-{$configDate}-{$locale}", VehicleTypeRef::all()->transform(function ($type) {
return ['id' => $type->id, 'name' => $type->ru];
})->toArray());
$this->info("Finished compiling vehicle types. {$tempDate->diffInSeconds(Carbon::now(), true)} seconds");
$this->line('Compiling cities');
$tempDate = Carbon::now();
Cache::forget("cities-{$oldConfigDate}-{$locale}");
Cache::forever("cities-{$configDate}-{$locale}", CityRef::all()->transform(function ($city) use($locale) {
return ['name' => $city->{$locale}, 'id' => $city->id];
})->toArray());
$this->info("Finished compiling cities. {$tempDate->diffInSeconds(Carbon::now(), true)} seconds");
$this->info('Compiling body types');
$tempDate = Carbon::now();
Cache::forget("body-types-{$oldConfigDate}-{$locale}");
Cache::forever("body-types-{$configDate}-{$locale}", BodyTypeRef::all()->transform(function ($type) use($locale) {
return ['id' => $type->id, 'name' => $type->{$locale}];
})->toArray());
$this->info("Finishing compiling body types. {$tempDate->diffInSeconds(Carbon::now(), true)} seconds");
}
Cache::forever('database.refs-version', $configDate);
}
public function all()
{
$this->locale = in_array(Request::header('Locale'), $this->avaibleLocales) ? Request::header('Locale') : $this->avaibleLocales[0];
$date = Input::has('date') ? Input::get('date') : null;
if (is_null($date)) {
$cities = CityRef::all();
$vehicles = VehicleTypeRef::all();
$bodyTypes = BodyTypeRef::all();
$marks = MarkRef::all();
$models = ModelRef::all();
} else {
$cities = CityRef::where('updated_at', '>=', $date)->get();
$vehicles = VehicleTypeRef::where('updated_at', '>=', $date)->get();
$marks = MarkRef::where('updated_at', '>=', $date)->get();
$bodyTypes = BodyTypeRef::where('updated_at', '>=', $date)->get();
$models = ModelRef::where('updated_at', '>=', $date)->get();
}
$response['vehicle-types'] = $this->transformVehicles($vehicles);
$response['body-types'] = $this->transformBodyTypes($bodyTypes);
$response['cities'] = $this->transformCities($cities);
$response['models'] = $models;
$response['marks'] = $marks;
$response['date'] = Carbon::now()->toDateTimeString();
return $this->respond($response);
}
