public function getListResponse(KalturaFilterPager $pager, KalturaDetachedResponseProfile $responseProfile = null) { $c = new Criteria(); $entryDistributionFilter = $this->toObject(); $entryDistributionFilter->attachToCriteria($c); $count = EntryDistributionPeer::doCount($c); $pager->attachToCriteria($c); $list = EntryDistributionPeer::doSelect($c); $response = new KalturaEntryDistributionListResponse(); $response->objects = KalturaEntryDistributionArray::fromDbArray($list, $responseProfile); $response->totalCount = $count; return $response; }
protected function executeSphinx($index, $wheres, $orderBy, $limit, $maxMatches, $setLimit) { $sql = "SELECT entry_distribution_id FROM {$index} {$wheres} {$orderBy} LIMIT {$limit} OPTION max_matches={$maxMatches}"; //debug query //echo $sql."\n"; die; $pdo = DbManager::getSphinxConnection(); $stmt = $pdo->query($sql); if (!$stmt) { KalturaLog::err("Invalid sphinx query [{$sql}]"); return; } $ids = $stmt->fetchAll(PDO::FETCH_COLUMN, 2); KalturaLog::debug("Found " . count($ids) . " ids"); foreach ($this->keyToRemove as $key) { KalturaLog::debug("Removing key [{$key}] from criteria"); $this->remove($key); } $this->addAnd(EntryDistributionPeer::ID, $ids, Criteria::IN); $this->recordsCount = 0; if (!$this->doCount) { return; } if ($setLimit) { $this->setOffset(0); $sql = "show meta"; $stmt = $pdo->query($sql); $meta = $stmt->fetchAll(PDO::FETCH_NAMED); if (count($meta)) { foreach ($meta as $metaItem) { KalturaLog::debug("Sphinx query " . $metaItem['Variable_name'] . ': ' . $metaItem['Value']); if ($metaItem['Variable_name'] == 'total_found') { $this->recordsCount = (int) $metaItem['Value']; } } } } else { $c = clone $this; $c->setLimit(null); $c->setOffset(null); $this->recordsCount = EntryDistributionPeer::doCount($c); } }
public static function doCountOnPeer(Criteria $c) { return EntryDistributionPeer::doCount($c); }
protected function doCountOnPeer(Criteria $c) { return EntryDistributionPeer::doCount($c); }
/** * List all distribution providers * * @action list * @param KalturaEntryDistributionFilter $filter * @param KalturaFilterPager $pager * @return KalturaEntryDistributionListResponse */ function listAction(KalturaEntryDistributionFilter $filter = null, KalturaFilterPager $pager = null) { if (!$filter) { $filter = new KalturaEntryDistributionFilter(); } $c = new Criteria(); $entryDistributionFilter = new EntryDistributionFilter(); $filter->toObject($entryDistributionFilter); $entryDistributionFilter->attachToCriteria($c); $count = EntryDistributionPeer::doCount($c); if ($pager) { $pager->attachToCriteria($c); } $list = EntryDistributionPeer::doSelect($c); $response = new KalturaEntryDistributionListResponse(); $response->objects = KalturaEntryDistributionArray::fromDbArray($list); $response->totalCount = $count; return $response; }