/**
* @before _secure
*/
public function campaigns()
{
$this->seo(array("title" => "Campaigns"));
$view = $this->getActionView();
$limit = RM::get("limit", 20);
$page = RM::get("page", 1);
$category = RM::get("category", []);
$keyword = RM::get("keyword", '');
$query = ["live = ?" => true, "org_id = ?" => $this->org->_id];
$query["meta.private"] = ['$ne' => true];
$today = date('Y-m-d');
if (count($category) > 0) {
// if you want AND query instead of OR query then replace '$in' --> '$all'
$query["category"] = ['$in' => Ad::setCategories($category)];
}
if ($keyword) {
$query["title"] = Utils::mongoRegex($keyword);
}
switch (RM::get("action")) {
case 'trending':
$ads = \Ad::all($query, [], 'modified', 'desc');
$fields = Shared\Services\User::fields('Ad');
$ids = array_keys($ads);
$ads = Ad::objectArr($ads, $fields);
$limit = $count = 30;
$clickCol = Registry::get("MongoDB")->clicks;
$results = $clickCol->aggregate([['$match' => ['adid' => ['$in' => Db::convertType($ids, 'id')], 'is_bot' => false, 'created' => Db::dateQuery(RM::get("start", $today), RM::get("end", $today))]], ['$project' => ['adid' => 1, '_id' => 1]], ['$group' => ['_id' => '$adid', 'count' => ['$sum' => 1]]], ['$sort' => ['count' => -1]], ['$limit' => $limit]]);
$ans = [];
foreach ($results as $r) {
$a = (object) $r;
$key = Utils::getMongoID($a->_id);
$ans[$key] = $ads[$key];
}
$ads = $ans;
break;
default:
$count = \Ad::count($query);
$ads = \Ad::all($query, [], 'modified', 'desc', $limit, $page);
break;
}
//private campaigns
$query["meta.private"] = true;
$query["meta.access"] = ['$in' => [$this->user->id]];
$pads = \Ad::all($query, [], 'modified', 'desc');
$categories = \Category::all(["org_id = ?" => $this->org->_id], ['name', '_id']);
$user = $this->user;
$model = null;
$rate = null;
if (array_key_exists("campaign", $user->meta)) {
$model = $user->meta["campaign"]["model"];
$rate = $user->meta["campaign"]["rate"];
}
$view->set(['limit' => $limit, 'page' => $page, 'count' => $count, 'ads' => $ads, 'model' => $model, 'rate' => $rate, 'categories' => $categories, 'coverage' => $category, 'tdomains' => \Shared\Services\User::trackingLinks($this->user, $this->org), 'keyword' => $keyword, 'pads' => $pads]);
}
protected function _reports($table)
{
$view = $this->getActionView();
$fields = Shared\Services\User::fields($table);
$table = "\\{$table}";
$ads = \Ad::all(['org_id' => $this->org->_id], ['_id', 'title'], 'created', 'desc');
$affs = \User::all(['org_id' => $this->org->_id, 'type = ?' => 'publisher'], ['_id', 'name']);
$adIds = array_keys($ads);
$pIds = array_keys($affs);
$searchData = $this->_searchQuery($fields, $adIds, $pIds);
$query = $searchData['query'];
$searching = $searchData['searching'];
$adIds = Db::convertType($adIds);
$pIds = Db::convertType($pIds);
$query['adid'] = ['$in' => $adIds];
$query['pid'] = ['$in' => $pIds];
$query['created'] = Db::dateQuery($this->start, $this->end);
$records = $table::all($query, [], 'created', 'desc', $this->limit, $this->page);
$count = $table::count($query);
$view->set(['clicks' => $records, 'fields' => $fields, 'count' => $count, 'ads' => $ads, 'query' => $searching, 'affs' => $affs]);
}
