public static function browseId($model = 'Document', $sort, $criteria, $format = array(), $page = 1, $count = 0)
{
$conditions = $criteria[0];
$values = $criteria[1];
$joins = $criteria[2];
$joins_order = $criteria[3];
$joins_pager = $joins + $joins_order;
$module = c2cTools::model2module($model);
$mi = c2cTools::Model2Letter($model) . 'i';
// orderby
$sort = self::buildSortCriteria($model, $sort['orderby_params'], $sort['order_params'], $sort['npp'], $mi);
// $npp
$npp = $sort['npp'];
// $all
$all = false;
if (isset($joins['all'])) {
$all = $joins['all'];
}
// $field_list
$field_list = call_user_func(array($model, 'buildFieldsList'), false, $mi, $format, $sort);
// specific $conditions
if ($module == 'outings' && in_array('cond', $format)) {
$default_max_age = sfConfig::get('app_outings_recent_conditions_limit', '3W');
$conditions[] = "age(date) < interval '{$default_max_age}'";
}
// $order_by
$order_by = self::buildOrderby($field_list, $sort);
// $nb_id
$nb_id = 0;
if (isset($joins['nb_id'])) {
$nb_id = $joins['nb_id'];
}
// $pager_count
if ($nb_id > 0) {
$count = $nb_id;
}
if ($count > $npp) {
$pager_count = 0;
} else {
$pager_count = $count;
}
// $independant_count
$independant_count = !$pager_count && count($joins_pager) > count($joins);
// create pager
$pager = new c2cDoctrinePager($model, $npp, $pager_count, $independant_count);
$pager->setPage($page);
// independant count
if ($independant_count) {
$c = $pager->getCountQuery();
$c->select('m.id')->from("{$model} m");
$model::buildPagerConditions($c, $criteria);
}
// pager query
$q = $pager->getQuery();
$q->select(implode(',', $field_list))->from("{$model} m")->orderBy($order_by);
if (!$all || !empty($joins_order)) {
$criteria[2] = $joins_pager;
$model::buildPagerConditions($q, $criteria);
} else {
$pager->simplifyCounter();
}
// execute pager query
$pager->init();
$count = $pager->getNbResults();
if ($count == 0) {
return array('pager' => null, 'nb_results' => 0, 'ids' => null);
}
// get ids
$items = $pager->getResults('array');
$ids = array();
$where_ids = array();
foreach ($items as $item) {
$ids[] = $item['id'];
$where_ids[] = '?';
}
$where_ids = implode(', ', $where_ids);
$count_ids = count($ids);
if ($count_ids == 1) {
$where = ' = ' . $where_ids;
} else {
$where = ' IN ( ' . $where_ids . ' )';
}
return array('pager' => $pager, 'nb_results' => $count, 'ids' => $ids, 'where' => $where);
}
