/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
$tr = new TranslateClient('en', 'ar');
$countries = json_decode(File::get(__DIR__ . "/u_countries.json"), true);
Country::whereNotNull('id')->delete();
City::whereNotNull('id')->delete();
State::whereNotNull('id')->delete();
foreach ($countries as $country) {
$name = $tr->translate($country['name']);
//$country['name'];
$newCountry = Country::create(['name' => $name, 'iso_3166_2' => $country['iso_3166_2'], 'calling_code' => $country['calling_code']]);
}
$countries = Country::get();
foreach ($countries as $country) {
$new_cities = [];
$new_states = [];
$states = DB::connection('tests')->table('states')->select('states.*')->join('countries', function ($j) use($country) {
$j->on('countries.id', '=', 'states.country_id')->where('countries.sortname', '=', $country->iso_3166_2);
})->get();
foreach ($states as $state) {
$new_cities[] = ['id' => $state->id, 'name' => $tr->translate($state->name), 'country_id' => $country->id];
$cities = DB::connection('tests')->table('cities')->select('cities.*')->join('states', function ($j) use($state) {
$j->on('states.id', '=', 'cities.state_id')->where('states.id', '=', $state->id);
})->get();
foreach ($cities as $city) {
$new_states[] = ['id' => $city->id, 'name' => $tr->translate($city->name), 'city_id' => $state->id];
}
}
DB::table('lists_cities')->insert($new_cities);
DB::table('lists_states')->insert($new_states);
}
}
public function deleteBulk(Request $req, State $StateModel, City $city)
{
if (!$req->has('table_records')) {
return redirect()->route('states.index');
}
$ids = $req->input('table_records');
$StateModel->destroy($ids);
return redirect()->route('states.index', $city->id)->with('success', trans('lists::states.delete_bulk_success'));
}
public function index(Request $request, State $state)
{
$states = $state->orderBy('id', 'desc');
if ($request->has('city_id')) {
$states->where('city_id', $request->input('city_id'));
}
$states = $states->get();
return $states;
}
/**
* Register the service provider.
*
* @return void
*/
public function register()
{
//City
City::created(function ($city) {
UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_city', 'reference_id' => $city->id]);
});
City::updated(function ($city) {
UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_city', 'reference_id' => $city->id]);
});
City::deleted(function ($city) {
UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_city', 'reference_id' => $city->id]);
});
//Country
Country::created(function ($country) {
UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_country', 'reference_id' => $country->id]);
});
Country::updated(function ($country) {
UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_country', 'reference_id' => $country->id]);
});
Country::deleted(function ($country) {
UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_country', 'reference_id' => $country->id]);
});
//Region
Region::created(function ($region) {
UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_region', 'reference_id' => $region->id]);
});
Region::updated(function ($region) {
UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_region', 'reference_id' => $region->id]);
});
Region::deleted(function ($region) {
UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_region', 'reference_id' => $region->id]);
});
//State
State::created(function ($state) {
UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_state', 'reference_id' => $state->id]);
});
State::updated(function ($state) {
UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_state', 'reference_id' => $state->id]);
});
State::deleted(function ($state) {
UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Lists_state', 'reference_id' => $state->id]);
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
$countries = json_decode(File::get(__DIR__ . "/countries.json"), true);
$cities = ['OM' => [['name' => 'مسقط', 'states' => [['name' => 'الخوير']]], ['name' => 'البريمي'], ['name' => 'الباطنة شمال'], ['name' => 'الباطنة جنوب'], ['name' => 'الظاهرة'], ['name' => 'الداخلية '], ['name' => 'الشرقية شمال'], ['name' => 'الشرقية جنوب'], ['name' => 'الوسطى'], ['name' => 'ظفار'], ['name' => 'مسندم']]];
$permissions = [['name' => 'اضافة دول', 'slug' => 'create.countries', 'module' => 'lists'], ['name' => 'تعدل دول', 'slug' => 'edit.countries', 'module' => 'lists'], ['name' => 'حذف دول', 'slug' => 'delete.countries', 'module' => 'lists'], ['name' => 'مشاهدة الدولة', 'slug' => 'view.countries', 'module' => 'lists'], ['name' => 'اضافة مدن', 'slug' => 'create.cities', 'module' => 'lists'], ['name' => 'تعدل مدن', 'slug' => 'edit.cities', 'module' => 'lists'], ['name' => 'حذف مدن', 'slug' => 'delete.cities', 'module' => 'lists'], ['name' => 'مشاهدة المدن', 'slug' => 'view.cities', 'module' => 'lists'], ['name' => 'اضافة محافظة', 'slug' => 'create.states', 'module' => 'lists'], ['name' => 'تعدل محافظة', 'slug' => 'edit.states', 'module' => 'lists'], ['name' => 'حذف محافظة', 'slug' => 'delete.states', 'module' => 'lists'], ['name' => 'مشاهدة المحافظات', 'slug' => 'view.states', 'module' => 'lists']];
$slugs = array_map(function ($ar) {
return $ar['slug'];
}, $permissions);
Permission::whereIn('slug', $slugs)->delete();
Country::whereNotNull('id')->delete();
City::whereNotNull('id')->delete();
State::whereNotNull('id')->delete();
$users = User::all();
foreach ($permissions as $permission) {
$perm = Permission::create($permission);
foreach ($users as $user) {
$user->attachPermission($perm);
}
}
$tr = new TranslateClient('en', 'ar');
foreach ($countries as $country) {
$name = $country['name'];
//$tr->translate($country['name']);
$newCountry = Country::create(['name' => $name, 'calling_code' => $country['calling_code']]);
if (isset($cities[$country['iso_3166_2']])) {
foreach ($cities[$country['iso_3166_2']] as $city) {
$newCity = City::create(['name' => $city['name'], 'country_id' => $newCountry->id]);
if (isset($city['states'])) {
foreach ($city['states'] as $state) {
State::create(['name' => $state['name'], 'city_id' => $newCity->id]);
}
}
}
}
}
}
public function export(Request $request)
{
Excel::create('registrations', function ($excel) {
$excel->sheet('registrations', function ($sheet) {
$steps = RegistrationStep::pluck('name', 'id')->toArray();
$specialties = Specialty::pluck('name', 'id')->toArray();
$type = RegistrationType::pluck('title', 'id')->toArray();
$genders = config('registration.genders');
$countries = Country::pluck('name', 'id')->toArray();
$cities = City::pluck('name', 'id')->toArray();
$states = State::pluck('name', 'id')->toArray();
$years = AcademycycleYear::pluck('name', 'id')->toArray();
$registration_periods = RegistrationPeriod::pluck('name', 'id')->toArray();
$registrations = $this->prepQuery(request()->all())->get();
$sheet->loadView('registration::registrations.export', compact('registration_periods', 'registrations', 'steps', 'countries', 'years', 'specialties', 'type', 'genders', 'cities', 'states'));
})->download('xlsx');
});
}
public function index(Request $request)
{
$states = State::orderBy('name', 'asc')->selectRaw('id as value, name as text')->where('city_id', $request->input('city_id'))->get()->toArray();
return response()->json($states, 200, [], JSON_NUMERIC_CHECK);
}
