/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$ads = $this->getExpiredAds();
$expiredStatus = Adstatus::whereTitle('expired')->firstOrFail();
Ad::whereIn('id', $ads->lists('id')->toArray())->update(['adstatus_id' => $expiredStatus->id]);
foreach ($ads as $ad) {
event(new AdWasExpired($ad, 'ZEDx'));
}
}
protected function createAd($adtype, $data)
{
$geo = new Geolocation($data['geolocation_data']);
$adstatus = Adstatus::whereTitle('pending')->first();
$ad = new Ad();
$ad->user_id = $data['user_id'];
$ad->category_id = $data['category_id'];
$ad->adstatus()->associate($adstatus);
$ad->adtype()->associate($adtype);
$ad->save();
$ad->geolocation()->create($geo->get());
$ad->content()->create($data['content']);
if ($ad->adtype->can_add_pic) {
$this->syncAdPhotos($ad, $data);
}
if ($ad->adtype->can_add_video) {
$this->syncAdVideos($ad, $data);
}
$this->syncAdFields($ad, $data);
event(new AdWasCreated($ad, 'ZEDx'));
$this->validateAd($ad);
}
/**
* Display widget.
*
* @return Response
*/
public function run()
{
return view('widget_backend_zedx_latestads::index', ['config' => $this->config, 'ads' => Ad::with('content')->limit(5)->get()]);
}
/**
* Remove the specified resource from storage.
*
* @param Ad $ad
*
* @return Response
*/
protected function destroy(Ad $ad, $forceDelete)
{
$adstatus = Adstatus::whereTitle('trashed')->first();
$ad->adstatus()->associate($adstatus);
$ad->save();
event(new AdWillBeDeleted($ad, $this->admin, $forceDelete));
if ($forceDelete) {
$ad->forceDelete();
} else {
$ad->delete();
}
event(new AdWasDeleted($ad, $this->admin, $forceDelete));
}
/**
* Remove the specified resource from storage.
*
* @param Ad $ad
*
* @return Response
*/
public function destroy(Ad $ad)
{
$adstatus = Adstatus::whereTitle('trashed')->first();
$ad->adstatus()->associate($adstatus);
$ad->save();
event(new AdWillBeDeleted($ad, $this->user));
$ad->delete();
event(new AdWasDeleted($ad, $this->user));
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
*
* @return void
*/
public function boot(Router $router)
{
$router->bind('adWithTrashed', function ($id) {
return Ad::with('content')->withTrashed()->findOrFail($id);
});
$router->bind('ad', function ($id) {
return Ad::with('content')->findOrFail($id);
});
$router->bind('adCollection', function ($ids) {
$ids = explode(',', $ids);
return Ad::with('content')->withTrashed()->findMany($ids);
});
$router->bind('adstatus', function ($title) {
return Adstatus::whereTitle($title)->firstOrFail();
});
$router->bind('adValidated', function ($id) {
return Ad::with('content')->validate()->findOrFail($id);
});
$router->bind('adPreview', function ($id) {
if (Auth::guard('admin')->check()) {
return Ad::with('content')->withTrashed()->findOrFail($id);
}
if (Auth::guard('user')->check()) {
return Auth::user()->ads()->with('content')->findOrFail($id);
}
abort(404);
});
$router->bind('adtypeNotCustomized', function ($id) {
return Adtype::whereIsCustomized(0)->findOrFail($id);
});
$router->bind('adtypeCollection', function ($ids) {
$ids = explode(',', $ids);
return Adtype::findMany($ids);
});
$router->bind('templateCollection', function ($ids) {
$ids = explode(',', $ids);
return Template::findMany($ids);
});
$router->bind('encryptedOrderId', function ($enc) {
$orderId = Crypt::decrypt($enc);
return Order::findOrFail($orderId);
});
$router->bind('fieldCollection', function ($ids) {
$ids = explode(',', $ids);
return Field::findMany($ids);
});
$router->bind('subscriptionCollection', function ($ids) {
$ids = explode(',', $ids);
return Subscription::findMany($ids);
});
$router->bind('userCollection', function ($ids) {
$ids = explode(',', $ids);
return User::findMany($ids);
});
$router->bind('adUser', function ($id) {
if (Auth::check()) {
return Auth::user()->ads()->with('content')->findOrFail($id);
} else {
abort(404);
}
});
$router->bind('field', function ($id) {
return Field::with('search')->findOrFail($id);
});
$router->bind('visibleCategory', function ($id) {
return Category::visible()->findOrFail($id);
});
$router->bind('templateblock', function ($identifier) use($router) {
$page = $router->input('page');
return Templateblock::whereIdentifier($identifier)->whereTemplateId($page->template->id)->firstOrFail();
});
$router->bind('widgetnode', function ($id) use($router) {
$pageId = $router->input('page')->id;
$templateblockId = $router->input('templateblock')->id;
return Widgetnode::whereTemplateblockId($templateblockId)->wherePageId($pageId)->findOrFail($id);
});
$router->model('adtype', 'ZEDx\\Models\\Adtype');
$router->model('template', 'ZEDx\\Models\\Template');
$router->model('category', 'ZEDx\\Models\\Category');
$router->model('country', 'ZEDx\\Models\\Country');
$router->model('page', 'ZEDx\\Models\\Page');
$router->model('menu', 'ZEDx\\Models\\Menu');
$router->model('gateway', 'ZEDx\\Models\\Gateway');
$router->model('themepartial', 'ZEDx\\Models\\Themepartial');
$router->model('dashboardWidget', 'ZEDx\\Models\\Dashboardwidget');
$router->model('searchfield', 'ZEDx\\Models\\SearchField');
$router->model('selectfield', 'ZEDx\\Models\\SelectField');
$router->model('subscription', 'ZEDx\\Models\\Subscription');
$router->model('user', 'ZEDx\\Models\\User');
parent::boot($router);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function search($params)
{
$filters = (object) $this->getFilters($params);
$ads = Ad::where('adstatus_id', '=', 1);
if (!is_null($filters->user_status)) {
$ads = $ads->join('users', function ($join) use($filters) {
$join->on('ads.user_id', '=', 'users.id')->where('users.status', '=', $filters->user_status);
});
}
if ($category = Category::visible()->find($filters->category_id)) {
$categories = $category->getDescendantsAndSelf(['id'])->keyBy('id')->keys()->toArray();
$ads = $ads->whereIn('category_id', $categories);
}
$ads = $ads->join('adcontents', function ($join) {
$join->on('ads.id', '=', 'adcontents.ad_id')->on('ads.adstatus_id', '=', \DB::raw('1'));
});
/*
// Fulltext (valid only on MySql)
$ads = $query ? $ads->whereRaw('MATCH('.\DB::getTablePrefix().'adcontents.title,'.\DB::getTablePrefix().'adcontents.body) AGAINST(? IN BOOLEAN MODE)', [str_replace(' ', ' +', $query) . "*"]) : $ads;
*/
// Like (valid on all SGBD)
$ads = $filters->query ? $ads->where('adcontents.title', 'like', '%' . $filters->query . '%')->orWhere('adcontents.body', 'like', '%' . $filters->query . '%') : $ads;
if (is_numeric($filters->lat) && is_numeric($filters->lng) && is_numeric($filters->radius)) {
$ads = $ads->join('geolocations', 'ads.id', '=', 'geolocations.ad_id')->whereRaw('? >= (SELECT ((? - `location_lat`) * (? - `location_lat`)) + ((? - `location_lng`) * (? - `location_lng`)))', [pow($filters->radius, 2), $filters->lat, $filters->lat, $filters->lng, $filters->lng]);
}
$ads = $this->joinFields($ads, $filters->fields);
$ads = $ads->join('adtypes', 'ads.adtype_id', '=', 'adtypes.id')->orderBy('is_headline', 'desc')->orderBy($filters->order['field'], $filters->order['type'])->select('ads.*', 'adcontents.title', 'is_headline')->groupBy('ads.id')->paginate(20);
$fields = Collection::make($filters->fields);
return ['data' => compact('ads', 'query', 'category_id', 'lat', 'lng', 'radius', 'location', 'fields')];
}
