public function get_qb($field = null, $direction = 'ASC')
{
if (!is_null($field)) {
$this->_qb->add_order($field, $direction);
}
$this->_qb->add_order('priority', 'ASC');
$this->_qb->add_order('customer');
$this->_qb->add_order('project');
$this->_qb->add_order('title');
return $this->_qb;
}
public function get_objects()
{
$qb = new midcom_core_querybuilder($this->_real_class);
if (!empty($this->_orders)) {
//Reset offset/limit, otherwise sorting won't work properly
$limit = $this->_limit;
$offset = $this->_offset;
$this->_offset = 0;
$this->_limit = 0;
$qb->set_limit($limit);
$qb->set_offset($offset);
}
$this->execute();
$guids = $this->list_keys();
if (!empty($this->_orders)) {
$this->_offset = $offset;
$this->_limit = $limit;
}
if (sizeof($guids) == 0) {
return array();
}
$qb->hide_invisible = $this->hide_invisible;
$qb->add_constraint('guid', 'IN', array_keys($guids));
foreach ($this->_orders as $order) {
$qb->add_order($order['field'], $order['direction']);
}
return $qb->execute();
}
