Пример #1
0
 function export(Request $request)
 {
     $regions = $request->get('regions');
     $daysCount = $request->get('day_count');
     $date = Carbon::createFromTimestamp(time() - $daysCount * 86400);
     $offers = Offer::query()->where('created_at', '>', $date)->get();
     echo '<ul>';
     /** @var \Illuminate\Bus\Dispatcher $dispatcher */
     $dispatcher = app('Illuminate\\Bus\\Dispatcher');
     foreach ($offers as $offer) {
         /** @var Offer $offer */
         if ($location = $offer->location and in_array($location->region, $regions, true)) {
             $dispatcher->dispatch((new \App\Jobs\ExportOffer($offer))->onQueue('export_offers'));
             echo "<li>created export job for <a href='/offer/'{$offer->id}'>{$offer->id}</a></li>";
         }
     }
     echo '</ul><p>done</p>';
 }
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $this->enableInfo = $this->option('info');
     $cache = [];
     $bar = $this->enableInfo ? null : ($bar = $this->output->createProgressBar(Offer::count()));
     $offers = Offer::query()->chunk(100, function (Collection $offers) use($bar, &$cache) {
         $this->info("Got {$offers->count()} offers");
         foreach ($offers as $offer) {
             if ($bar) {
                 $bar->advance();
             }
             foreach ($offer->details as $key => $value) {
                 if (array_key_exists($key, $cache)) {
                     if (array_key_exists($value, $cache[$key])) {
                         $this->info("{$key}:{$value} exists in cache");
                         continue;
                     }
                 } else {
                     $cache[$key] = [];
                 }
                 $detailsParameter = DetailsParameter::firstOrCreate(['parameter' => $key]);
                 try {
                     $detailsValue = $detailsParameter->detailsValues()->firstOrCreate(['value' => $value]);
                     if ($detailsValue->wasRecentlyCreated) {
                         array_push($cache[$key], $value);
                         $this->info("Added {$key}:{$value}");
                     }
                 } catch (QueryException $e) {
                     if (23000 !== intval($e->getCode())) {
                         throw $e;
                     } else {
                         $this->info("Skipped {$key}:{$value}");
                     }
                 }
             }
         }
     });
 }
Пример #3
0
 function index()
 {
     return view('offers')->with(['offers' => Offer::query()->latest()->paginate('40')]);
 }