PHP PartnerPeer::doCount方法代码示例

 public function execute()
 {
     $this->forceSystemAuthentication();
     $start = microtime(true);
     $limit = 7;
     // new partners
     $c = new Criteria();
     $this->partner_count = PartnerPeer::doCount($c);
     // count before setting the limit
     $c->setLimit($limit);
     $c->addDescendingOrderByColumn(PartnerPeer::CREATED_AT);
     $newest_partners = PartnerPeer::doSelect($c);
     //		$new_partners_ids = self::getIds( $new_partners );
     // fetch stats for these partners
     // TODO - if new - what statistics could it have ??
     //		fdb::populateObjects( $newest_partners , new PartnerStatsPeer() , "id" , "partnerStats" , false ,"partnerId");
     $exclude = $this->getP("exclude");
     if ($exclude) {
         self::addToExceludeList($exclude);
     }
     $exclude_list = self::getExceludeList();
     // most viewed
     $c = new Criteria();
     $c->add(PartnerStatsPeer::PARTNER_ID, $exclude_list, Criteria::NOT_IN);
     $c->setLimit($limit);
     $c->addDescendingOrderByColumn(PartnerStatsPeer::VIEWS);
     $stats_most_views = PartnerStatsPeer::doSelect($c);
     $most_views = self::getPartnerListFromStats($stats_most_views);
     // most entries
     $c = new Criteria();
     $c->add(PartnerStatsPeer::PARTNER_ID, $exclude_list, Criteria::NOT_IN);
     $c->setLimit($limit);
     $c->addDescendingOrderByColumn(PartnerStatsPeer::ENTRIES);
     $stats_most_entries = PartnerStatsPeer::doSelect($c);
     $most_entries = self::getPartnerListFromStats($stats_most_entries);
     $end = microtime(true);
     $this->newest_partners = $newest_partners;
     $this->most_views = $most_views;
     $this->most_entries = $most_entries;
     $this->bench = $end - $start;
 }

 /**
  * Returns the number of related Partner objects.
  *
  * @param      Criteria $criteria
  * @param      boolean $distinct
  * @param      PropelPDO $con
  * @return     int Count of related Partner objects.
  * @throws     PropelException
  */
 public function countPartners(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(kuserPeer::DATABASE_NAME);
     } else {
         $criteria = clone $criteria;
     }
     if ($distinct) {
         $criteria->setDistinct();
     }
     $count = null;
     if ($this->collPartners === null) {
         if ($this->isNew()) {
             $count = 0;
         } else {
             $criteria->add(PartnerPeer::ANONYMOUS_KUSER_ID, $this->id);
             $count = PartnerPeer::doCount($criteria, false, $con);
         }
     } else {
         // criteria has no effect for a new object
         if (!$this->isNew()) {
             // the following code is to determine if a new query is
             // called for.  If the criteria is the same as the last
             // one, just return count of the collection.
             $criteria->add(PartnerPeer::ANONYMOUS_KUSER_ID, $this->id);
             if (!isset($this->lastPartnerCriteria) || !$this->lastPartnerCriteria->equals($criteria)) {
                 $count = PartnerPeer::doCount($criteria, false, $con);
             } else {
                 $count = count($this->collPartners);
             }
         } else {
             $count = count($this->collPartners);
         }
     }
     return $count;
 }

 /**
  * @action list
  * @param KalturaPartnerFilter $filter
  * @param KalturaFilterPager $pager
  * @return KalturaPartnerListResponse
  */
 public function listAction(KalturaPartnerFilter $filter = null, KalturaFilterPager $pager = null)
 {
     if (is_null($filter)) {
         $filter = new KalturaPartnerFilter();
     }
     if (is_null($pager)) {
         $pager = new KalturaFilterPager();
     }
     $partnerFilter = new partnerFilter();
     $filter->toObject($partnerFilter);
     $partnerFilter->set('_gt_id', 0);
     $c = new Criteria();
     $partnerFilter->attachToCriteria($c);
     $totalCount = PartnerPeer::doCount($c);
     $pager->attachToCriteria($c);
     $list = PartnerPeer::doSelect($c);
     $newList = KalturaPartnerArray::fromPartnerArray($list);
     $response = new KalturaPartnerListResponse();
     $response->totalCount = $totalCount;
     $response->objects = $newList;
     return $response;
 }

 /**
  * Count partner's existing sub-publishers (count includes the partner itself).
  * 
  * @action count
  * @param KalturaPartnerFilter $filter
  * @return int
  */
 public function countAction(KalturaPartnerFilter $filter = null)
 {
     if (!$filter) {
         $filter = new KalturaPartnerFilter();
     }
     $dbFilter = new partnerFilter();
     $filter->toObject($dbFilter);
     $c = PartnerPeer::getDefaultCriteria();
     $dbFilter->attachToCriteria($c);
     return PartnerPeer::doCount($c);
 }

 /**
  * Function which calulates partner usage of a group of a VAR's sub-publishers
  * 
  * @action getPartnerUsage
  * @param KalturaPartnerFilter $partnerFilter
  * @param KalturaReportInputFilter $usageFilter
  * @param KalturaFilterPager $pager
  * @return KalturaPartnerUsageListResponse
  * @throws KalturaVarConsoleErrors::MAX_SUB_PUBLISHERS_EXCEEDED
  */
 public function getPartnerUsageAction(KalturaPartnerFilter $partnerFilter = null, KalturaReportInputFilter $usageFilter = null, KalturaFilterPager $pager = null)
 {
     if (is_null($partnerFilter)) {
         $partnerFilter = new KalturaPartnerFilter();
     }
     if (is_null($usageFilter)) {
         $usageFilter = new KalturaReportInputFilter();
         $usageFilter->fromDate = time() - 60 * 60 * 24 * 30;
         // last 30 days
         $usageFilter->toDate = time();
     } else {
         //The first time the filter is sent, it it sent with 0 as fromDate
         if (!$usageFilter->fromDate) {
             $usageFilter->fromDate = time() - 60 * 60 * 24 * 30;
         }
         if (!$usageFilter->interval) {
             $usageFilter->interval = KalturaReportInterval::MONTHS;
         }
     }
     if (is_null($pager)) {
         $pager = new KalturaFilterPager();
     }
     //Create a propel filter for the partner
     $partnerFilterDb = new partnerFilter();
     $partnerFilter->toObject($partnerFilterDb);
     //add filter to criteria
     $c = PartnerPeer::getDefaultCriteria();
     $partnerFilterDb->attachToCriteria($c);
     $partnersCount = PartnerPeer::doCount($c);
     if ($partnersCount > self::MAX_SUB_PUBLISHERS) {
         throw new KalturaAPIException(KalturaVarConsoleErrors::MAX_SUB_PUBLISHERS_EXCEEDED);
     }
     $partners = PartnerPeer::doSelect($c);
     $partnerIds = array();
     foreach ($partners as &$partner) {
         $partnerIds[] = $partner->getId();
     }
     // add pager to criteria
     $pager->attachToCriteria($c);
     $c->addAscendingOrderByColumn(PartnerPeer::ID);
     // select partners
     $items = array();
     $inputFilter = new reportsInputFilter();
     $inputFilter->from_date = $usageFilter->fromDate;
     $inputFilter->to_date = $usageFilter->toDate;
     $inputFilter->from_day = date("Ymd", $usageFilter->fromDate);
     $inputFilter->to_day = date("Ymd", $usageFilter->toDate);
     $inputFilter->timeZoneOffset = $usageFilter->timeZoneOffset;
     $inputFilter->interval = $usageFilter->interval;
     if (!count($partnerIds)) {
         $total = new KalturaVarPartnerUsageTotalItem();
         // no partners fit the filter - don't fetch data
         $totalCount = 0;
         // the items are set to an empty KalturaSystemPartnerUsageArray
     } else {
         $totalCount = 0;
         $orderBy = ($inputFilter->interval == reportInterval::MONTHS ? "+month_id" : "+date_id") . ",+partner_id";
         list($reportHeader, $reportData, $totalCount) = myReportsMgr::getTable(null, myReportsMgr::REPORT_TYPE_VAR_USAGE, $inputFilter, $pager->pageSize, $pager->pageIndex, $orderBy, implode(",", $partnerIds));
         foreach ($reportData as $line) {
             $item = new KalturaVarPartnerUsageItem();
             $item->fromString($reportHeader, $line);
             if ($item) {
                 $items[] = $item;
             }
         }
         list($reportHeader, $reportData) = myReportsMgr::getTotal(null, myReportsMgr::REPORT_TYPE_PARTNER_USAGE, $inputFilter, implode(",", $partnerIds));
         $total = new KalturaVarPartnerUsageTotalItem();
         $total->fromString($reportHeader, $reportData);
         list($peakStoragereportHeader, $peakStoragereportData) = myReportsMgr::getTotal(null, myReportsMgr::REPORT_TYPE_PEAK_STORAGE, $inputFilter, implode(",", $partnerIds));
         if ($peakStoragereportData[0]) {
             $total->peakStorage = ceil(@$peakStoragereportData[0]);
         }
     }
     $response = new KalturaPartnerUsageListResponse();
     //Sort according to dateId and partnerId
     uasort($items, array($this, 'sortByDate'));
     $response->total = $total;
     $response->totalCount = $totalCount;
     $response->objects = $items;
     return $response;
 }