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;
}
