public function autocompleteBySettlementName() { $settlement = htmlentities(Input::get('settlement'), ENT_QUOTES, 'UTF-8', false); $name = htmlentities(Input::get('query'), ENT_QUOTES, 'UTF-8', false); $settlement = Settlement::where('name', 'LIKE', "{$settlement}%")->orWhere('name_en', 'LIKE', "{$settlement}%")->first(); if (!$settlement) { return ['results' => [], 'more' => false]; } $result = Office::where('city_id', $settlement->id)->whereNested(function ($query) use($name) { $query->where('name', 'LIKE', "%{$name}%")->orWhere('name_en', 'LIKE', "%{$name}%"); })->get(['id', 'bg' === App::getLocale() ? 'name' : 'name_en AS name']); return ['results' => $result, 'more' => false]; }
public function autocomplete() { $name = htmlentities(Input::get('query'), ENT_QUOTES, 'UTF-8', false); if (self::MIN_AUTOCOMPLETE_LENGTH > mb_strlen($name)) { return ['results' => [], 'more' => false]; } $settlements = Settlement::where('name', 'LIKE', "%{$name}%")->orWhere('name_en', 'LIKE', "%{$name}%")->get(['id', 'type', 'name', 'name_en', 'post_code']); $result = []; foreach ($settlements as $settlement) { $entry = ['id' => $settlement->id, 'name' => $settlement->formatted]; $entry['ref'] = $settlement->reference; $entry['post_code'] = $settlement->post_code; $result[] = (object) $entry; } return ['results' => $result, 'more' => false]; }
/** * Execute the console command. * * @return mixed * @codeCoverageIgnore */ public function handle() { $time = time(); DB::connection('econt')->disableQueryLog(); $this->comment(PHP_EOL . 'Starting...'); $this->comment(PHP_EOL . 'Importing zones and settlements... Please wait.'); Zone::whereRaw(1)->delete(); Settlement::whereRaw(1)->delete(); foreach (App::make('Econt')->zones() as $zone) { (new Zone())->import($zone); $zone_id = Arr::has($zone, 'id') ? Arr::get($zone, 'id') : 0; foreach (App::make('Econt')->settlements($zone_id) as $settlement) { if (!is_array($settlement)) { continue; } (new Settlement())->import($settlement); } } $this->comment(PHP_EOL . 'Zones and settlements imported successfully.'); $this->comment(PHP_EOL . 'Importing regions... Please wait.'); Region::whereRaw(1)->delete(); foreach (App::make('Econt')->regions() as $region) { (new Region())->import($region); } $this->comment(PHP_EOL . 'Regions imported successfully.' . PHP_EOL); $this->comment(PHP_EOL . 'Importing neighbourhoods... Please wait.'); Neighbourhood::whereRaw(1)->delete(); foreach (App::make('Econt')->neighbourhoods() as $region) { (new Neighbourhood())->import($region); } $this->comment(PHP_EOL . 'Neighbourhoods imported successfully.' . PHP_EOL); $this->comment(PHP_EOL . 'Importing streets... Please wait.'); Street::whereRaw(1)->delete(); foreach (App::make('Econt')->streets() as $region) { (new Street())->import($region); } $this->comment(PHP_EOL . 'Streets imported successfully.' . PHP_EOL); $this->comment(PHP_EOL . 'Importing offices... Please wait.'); Office::whereRaw(1)->delete(); foreach (App::make('Econt')->offices() as $region) { (new Office())->import($region); } $this->comment(PHP_EOL . 'Offices imported successfully.' . PHP_EOL); $this->comment(PHP_EOL . sprintf('Finished in %f minutes.', (time() - $time) / 60)); }
protected function _receiver() { $settlement = Settlement::find((int) Input::get('receiver.settlement')); $receiver = new Receiver(); $receiver->name = Input::get('receiver.name'); $receiver->city = $settlement->name; $receiver->post_code = $settlement->post_code; $receiver->phone_num = Input::get('receiver.phone'); switch (Input::get('receiver.pickup')) { case 'address': $receiver->street = Street::find((int) Input::get('receiver.street'))->name; $receiver->street_num = Input::get('receiver.street_num'); $receiver->street_vh = Input::get('receiver.street_vh'); $receiver->street_et = Input::get('receiver.street_et'); $receiver->street_ap = Input::get('receiver.street_ap'); $receiver->street_other = Input::get('receiver.street_other'); break; case 'office': $receiver->office_code = Office::find((int) Input::get('receiver.office'))->code; break; } return $receiver; }