static function active($asObject = true, $offset, $limit, $sortField = "created", $sortOrder = "asc", $show = eZOrder::SHOW_NORMAL)
{
if ($sortField == "user_name") {
$db = eZDB::instance();
$db_params = array();
$db_params["offset"] = (int) $offset;
$db_params["limit"] = (int) $limit;
$sortOrder = $db->escapeString($sortOrder);
$query = "SELECT ezorder.*\n FROM\n ezorder,\n ezcontentobject\n WHERE\n " . eZOrder::getShowOrdersQuery($show, "ezorder") . " AND\n ezorder.is_temporary = '0' AND\n ezcontentobject.id = ezorder.user_id\n ORDER BY ezcontentobject.name {$sortOrder}";
$orderArray = $db->arrayQuery($query, $db_params);
if ($asObject) {
$retOrders = array();
foreach ($orderArray as $order) {
$order = new eZOrder($order);
$retOrders[] = $order;
}
return $retOrders;
} else {
return $orderArray;
}
} else {
$where['is_temporary'] = 0;
if ($show != eZOrder::SHOW_ALL) {
$where['is_archived'] = $show;
}
return eZPersistentObject::fetchObjectList(eZOrder::definition(), null, $where, array($sortField => $sortOrder), array('offset' => $offset, 'length' => $limit), $asObject);
}
}
