PHP Ad::count方法代码示例

 public function inUse()
 {
     $count = Ad::count(['org_id' => $this->org_id, 'category' => ['$elemMatch' => ['$eq' => Utils::mongoObjectId($this->_id)]]]);
     if ($count === 0) {
         return false;
     } else {
         return true;
     }
 }

 /**
  * @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]);
 }

 /**
  * @before _secure
  */
 public function campaigns()
 {
     $this->seo(array("title" => "Campaigns"));
     $view = $this->getActionView();
     $start = RM::get("start", strftime("%Y-%m-%d", strtotime('-7 day')));
     $end = RM::get("end", strftime("%Y-%m-%d", strtotime('now')));
     $limit = RM::get("limit", 20);
     $page = RM::get("page", 1);
     $query = ["user_id" => $this->user->id];
     $ads = \Ad::all($query, ['title', 'image', 'category', '_id', 'live', 'created'], 'created', 'desc', $limit, $page);
     $count = \Ad::count($query);
     $in = Db::convertType(array_keys($ads));
     $query["created"] = Db::dateQuery($start, $end);
     $records = Db::query('Click', ['adid' => ['$in' => $in], 'is_bot' => false, 'created' => $query["created"]], ['adid']);
     $view->set("ads", $ads);
     $view->set("start", $start);
     $view->set("end", $end);
     $view->set(['count' => $count, 'page' => $page, 'limit' => $limit, 'dateQuery' => $query['created'], 'clicks' => Click::classify($records, 'adid')]);
 }

 public function run()
 {
     $model = new Ad();
     //条件
     $criteria = new CDbCriteria();
     $title = trim(Yii::app()->request->getParam('title'));
     $position_id = intval(Yii::app()->request->getParam('position_id'));
     $title && $criteria->addColumnCondition(array('title' => $title));
     $position_id && $criteria->addColumnCondition(array('position_id', $position_id));
     $criteria->order = 't.id ASC';
     $count = $model->count($criteria);
     //分页
     $pages = new CPagination($count);
     $pages->pageSize = 10;
     $pages->applyLimit($criteria);
     //查询
     $result = $model->findAll($criteria);
     $this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages));
 }

 /**
  * 广告管理
  *
  */
 public function actionIndex()
 {
     $model = new Ad();
     $criteria = new CDbCriteria();
     $condition = '1';
     $title = $this->_request->getParam('title');
     $position_id = $this->_request->getParam('positionID');
     $position_id && ($condition .= ' AND position_id =' . $position_id);
     $title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
     $criteria->condition = $condition;
     $count = $model->count($criteria);
     $pages = new CPagination($count);
     $pages->pageSize = 13;
     $pageParams = $this->buildCondition($_GET, array('title'));
     $pages->params = is_array($pageParams) ? $pageParams : array();
     $criteria->limit = $pages->pageSize;
     $criteria->offset = $pages->currentPage * $pages->pageSize;
     $result = $model->findAll($criteria);
     $this->render('ad_index', array('datalist' => $result, 'pagebar' => $pages));
 }

        $or_filter .= " OR id LIKE '{$gs_description}'";
    }
    if ($or_filter != '') {
        $filter .= " AND (1=2 {$or_filter})";
    }
    if ($g_category != "any" && $g_category != '0') {
        $filter .= " AND (category=(SELECT r.id FROM category r WHERE r.slug='{$g_category}' LIMIT 1) OR category IN (SELECT r.id FROM category r WHERE r.parent=(SELECT s.id FROM category s WHERE s.slug='{$g_category}' LIMIT 1)))";
    }
    if ($g_region != "any" && $g_region != '0') {
        $filter .= " AND (region=(SELECT r.id FROM region r WHERE r.slug='{$g_region}' LIMIT 1) OR region IN (SELECT r.id FROM region r WHERE r.parent=(SELECT s.id FROM region s WHERE s.slug='{$g_region}' LIMIT 1)))";
    }
    if ($g_min_price != "") {
        $filter .= " AND ar>={$g_min_price}";
    }
    if ($g_max_price != "") {
        $filter .= " AND ar<={$g_max_price}";
    }
    if ($g_id > 0) {
        $filter .= " AND id='{$g_id}'";
    }
}
$rpp = 15;
//row per page
$tct = Ad::count(array(), $filter);
//total count
$pager_options = array('mode' => 'Sliding', 'perPage' => $rpp, 'delta' => 2, 'totalItems' => $tct);
$pager = @Pager::factory($pager_options);
list($from, $to) = $pager->getOffsetByPageId();
$ads = Ad::get_all(array(), $filter, $from - 1 . ", {$rpp}");
$curr_page = "home";
include "./templates/ad-list.php";

 /**
  * 广告管理
  *
  */
 public function actionAd()
 {
     parent::_acl('ad_index');
     $model = new Ad();
     $criteria = new CDbCriteria();
     $condition = '1';
     $title = $this->_gets->getParam('title');
     $title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
     $criteria->condition = $condition;
     //$criteria->params = '';
     $criteria->order = 't.id DESC';
     $count = $model->count($criteria);
     $pages = new CPagination($count);
     $pages->pageSize = 13;
     $pageParams = XUtils::buildCondition($_GET, array('title'));
     $pages->params = is_array($pageParams) ? $pageParams : array();
     $criteria->limit = $pages->pageSize;
     $criteria->offset = $pages->currentPage * $pages->pageSize;
     $result = $model->findAll($criteria);
     $this->render('ad_index', array('datalist' => $result, 'pagebar' => $pages));
 }

<?php

require_once '../bootstrap.php';
// require_once '../views/partials/header.php';
if (!Auth::checkUser()) {
    header("Location: /auth.login.php");
    exit;
}
$limit = 6;
$count = Ad::count();
$numPages = ceil($count / $limit);
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$offset = ($page - 1) * 4;
$nextPage = $page + 1;
$prevPage = $page - 1;
$errors = [];
$items = Ad::paginate($limit, $offset);
?>
<html>
<head>
	<title>WoW Lister</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">	
<link rel="stylesheet" href="/css/main.css">

	<style>

	body {
		background-image: url("/img/auction.jpg");
		background-attachment: fixed;
	}

<?php

require_once 'ads.index.php';
require_once '../bootstrap.php';
$ads = [];
$ads = Ad::all();
if (Input::has('id') && Input::get('id') >= 0) {
    $id = Input::get('id');
} else {
    $id = 0;
}
$idUp = $id + 1;
$idDown = $id - 1;
$lastId = Ad::count() - 1;
?>

<html>
<head>
    <title>Instrument Exchange</title>
    <!-- Bootstrap styling -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
    <!-- Custom styling for site -->
    <link rel="stylesheet" type="text/css" href="../css/main.css">
</head>
<body>
    <? include "../views/partials/navbar.php"; ?>


    <div class="container">

        <div class="row listing-wrapper">

    $d = (int) $_GET['d'];
    if ($d > 0) {
        Ad::delete($d);
    }
}
if (isset($_GET['o'])) {
    $o = (int) $_GET['o'];
    $r = (int) $_GET['r'];
    if ($r != 0) {
        $r = 1;
    }
    $a['sponsored'] = $r;
    $a['sponsoredon'] = $r = 0 ? '' : date('Y-m-d', time());
    Ad::update($o, $a);
}
$tct = Ad::count();
//total count
$rpp = 10;
//row per page
$pager_options = array('mode' => 'Sliding', 'perPage' => $rpp, 'delta' => 2, 'totalItems' => $tct, 'excludeVars' => array('o', 'r', 'd', 't', 'e'));
$pager = @Pager::factory($pager_options);
list($from, $to) = $pager->getOffsetByPageId();
$ads = Ad::get_all(array(), '', $from - 1 . ", {$rpp}");
include "page-header.php";
?>

<div id="wrapper">
	
	<?php 
include "page-left.php";
?>

 /**
  * Returns the count of the user's favourite ads 
  *
  * @param 	int 	$user_id	The user's id.
  * @return 	int					Count of the favourite ads.
  */
 public static function count($user_id)
 {
     global $db;
     $filter = sprintf("active=1 AND id IN (SELECT f.ad_id FROM " . static::$table_name . " f WHERE f.user_id=%d)", $user_id);
     return Ad::count(array(), $filter);
 }

include "{$docroot}/db-ad-review.php";
include "{$docroot}/db-favourite.php";
include "{$docroot}/db-user-review.php";
include "{$docroot}/db-report.php";
$db = new db();
if (!$db->connect()) {
    exit(mysql_error());
}
$categories = Category::get_tree();
$regions = Region::get_tree();
$statics = StaticContent::get_all(array(), 'id>6');
//counters
$today = date("Y-m-d", time());
$ct_fresh = Ad::count(array('active' => 1), "lastmodified>='{$today}'");
$ct_all = Ad::count(array('active' => 1));
$ct_expirys = Ad::count(array('active' => 1, "DATEDIFF(expiry,'{$today}')" => 0));
//menu and breadcumb
$menu = User::get_menu();
$current_script_name = basename($_SERVER['SCRIPT_NAME']);
if (strpos($current_script_name, '-') > 0) {
    $current_page = explode('-', $current_script_name, 2);
    if (isset($current_page[2])) {
        $current_page[1] .= '-' . $current_page[2];
    }
    //php 5.3.5 bug?? workaround
    $subpage_name = explode('.', $current_page[1]);
    $subpage_name = str_replace('-', ' ', $subpage_name[0]);
    if ($current_page[0] == 'static') {
        $current_page[0] = 'static content';
    }
    $current_group_page = array('name' => ucwords($current_page[0]), 'script' => $menu[ucwords($current_page[0])][reset(array_keys($menu[ucwords($current_page[0])]))]);

 /**
  * @before _secure
  */
 public function manage()
 {
     $this->seo(['title' => 'Campaign: List', 'description' => 'Manage campaigns']);
     $view = $this->getActionView();
     $campaigns = [];
     $page = RM::get("page", 1);
     $limit = RM::get("limit", 10);
     $property = RM::get("property");
     $value = RM::get("value");
     switch (RM::get("sort")) {
         case 'trending':
             $start = RM::get("start", date("Y-m-d", strtotime('now')));
             $end = RM::get("end", date("Y-m-d", strtotime('now')));
             $q = ['start' => $start, 'end' => $end];
             $view->set($q);
             // Only find the ads for this organizations
             $allAds = \Ad::all(['org_id' => $this->org->_id], ['_id']);
             $in = Db::convertType(array_keys($allAds));
             $clickCol = Db::collection('Click');
             $match = ['created' => Db::dateQuery($start, $end), 'is_bot' => false, 'adid' => ['$in' => $in]];
             $records = $clickCol->aggregate([['$match' => $match], ['$project' => ['adid' => 1, '_id' => 0]], ['$group' => ['_id' => '$adid', 'count' => ['$sum' => 1]]], ['$sort' => ['count' => -1]], ['$limit' => (int) $limit]]);
             foreach ($records as $r) {
                 $arr = Utils::toArray($r);
                 $id = Utils::getMongoID($arr['_id']);
                 $campaigns[] = Ad::first(["id = ?" => $id]);
             }
             $count = $limit;
             break;
         default:
             $query = ["org_id = ?" => $this->org->id];
             if (in_array($property, ["user_id", "live", "id"])) {
                 $query[$property] = $value;
             } else {
                 if (in_array($property, ["url", "title"])) {
                     $query[$property] = Utils::mongoRegex(preg_quote($value));
                 }
             }
             $campaigns = \Ad::all($query, [], 'created', 'desc', $limit, $page);
             $count = \Ad::count($query);
             break;
     }
     $categories = \Category::all(['org_id' => $this->org->_id], ['_id', 'name']);
     $active = \Ad::count(["org_id = ?" => $this->org->id, "live = ?" => 1]);
     $inactive = \Ad::count(["org_id = ?" => $this->org->id, "live = ?" => 0]);
     $view->set("campaigns", $campaigns)->set("count", $count)->set("active", $active)->set("inactive", $inactive)->set("limit", $limit)->set("page", $page)->set("property", $property)->set("value", $value)->set("categories", $categories);
 }

            $type = 10;
            break;
    }
} else {
    $type = 'all';
}
if (Input::has('page')) {
    $page = Input::get('page');
} else {
    $page = 1;
}
$items_per_page = 4;
if (isset($catString)) {
    $totalListings = Ad::countPerCat($type);
} else {
    $totalListings = Ad::count();
}
$lastPage = ceil($totalListings / $items_per_page);
if ($page > $lastPage) {
    $page = $lastPage;
}
if ($page < 1) {
    $page = 1;
}
$offset = ($page - 1) * $items_per_page;
if (isset($type) && $type != 'all') {
    $ads = Ad::pagerWithCat($offset, $items_per_page, $type);
} else {
    $ads = Ad::pager($offset, $items_per_page);
}
// var_dump($ads);