/**
* Displays a list of tickets
*
* @return void
*/
public function displayTask()
{
$obj = new Tables\Ticket($this->database);
// Get filters
$this->view->total = 0;
$this->view->rows = array();
$this->view->filters = array('limit' => Request::getState($this->_option . '.' . $this->_controller . '.limit', 'limit', Config::get('list_limit'), 'int'), 'start' => Request::getState($this->_option . '.' . $this->_controller . '.limitstart', 'limitstart', 0, 'int'), 'show' => Request::getState($this->_option . '.' . $this->_controller . '.show', 'show', 0, 'int'), 'search' => '', 'sort' => 'id', 'sortdir' => 'DESC');
// Get query list
$sf = new Tables\QueryFolder($this->database);
$this->view->folders = $sf->find('list', array('user_id' => User::get('id'), 'sort' => 'ordering', 'sort_Dir' => 'asc'));
// Does the user have any folders?
if (!count($this->view->folders)) {
// Get all the default folders
$this->view->folders = $sf->cloneCore(User::get('id'));
}
$sq = new Tables\Query($this->database);
$queries = $sq->getRecords(array('user_id' => User::get('id'), 'sort' => 'ordering', 'sort_Dir' => 'asc'));
foreach ($queries as $query) {
$filters = $this->view->filters;
if ($query->id != $this->view->filters['show']) {
$filters['search'] = '';
}
$query->query = $sq->getQuery($query->conditions);
// Get a record count
$query->count = $obj->getCount($query->query, $filters);
foreach ($this->view->folders as $k => $v) {
if (!isset($this->view->folders[$k]->queries)) {
$this->view->folders[$k]->queries = array();
}
if ($query->folder_id == $v->id) {
$this->view->folders[$k]->queries[] = $query;
}
}
if ($query->id == $this->view->filters['show']) {
// Search
$this->view->filters['search'] = urldecode(Request::getState($this->_option . '.' . $this->_controller . '.search', 'search', ''));
// Set the total for the pagination
$this->view->total = $this->view->filters['search'] ? $obj->getCount($query->query, $this->view->filters) : $query->count;
// Incoming sort
$this->view->filters['sort'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sort', 'filter_order', $query->sort));
$this->view->filters['sortdir'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sortdir', 'filter_order_Dir', $query->sort_dir));
// Get the records
$this->view->rows = $obj->getRecords($query->query, $this->view->filters);
}
}
if (!$this->view->filters['show']) {
// Jump back to the beginning of the folders list
// and try to find the first query available
// to make it the current "active" query
reset($this->view->folders);
foreach ($this->view->folders as $folder) {
if (!empty($folder->queries)) {
$query = $folder->queries[0];
$this->view->filters['show'] = $query->id;
break;
} else {
// for no custom queries.
$query = new Tables\Query($this->database);
$query->count = 0;
}
}
//$folder = reset($this->view->folders);
//$query = $folder->queries[0];
// Search
$this->view->filters['search'] = urldecode(Request::getState($this->_option . '.' . $this->_controller . '.search', 'search', ''));
// Set the total for the pagination
$this->view->total = $this->view->filters['search'] ? $obj->getCount($query->query, $this->view->filters) : $query->count;
// Incoming sort
$this->view->filters['sort'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sort', 'filter_order', $query->sort));
$this->view->filters['sortdir'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sortdir', 'filter_order_Dir', $query->sort_dir));
// Get the records
$this->view->rows = $obj->getRecords($query->query, $this->view->filters);
}
$watching = new Tables\Watching($this->database);
$this->view->watch = array('open' => $watching->count(array('user_id' => User::get('id'), 'open' => 1)), 'closed' => $watching->count(array('user_id' => User::get('id'), 'open' => 0)));
if ($this->view->filters['show'] < 0) {
if (!isset($this->view->filters['sort']) || !$this->view->filters['sort']) {
$this->view->filters['sort'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sort', 'filter_order', 'created'));
}
if (!isset($this->view->filters['sortdir']) || !$this->view->filters['sortdir']) {
$this->view->filters['sortdir'] = trim(Request::getState($this->_option . '.' . $this->_controller . '.sortdir', 'filter_order_Dir', 'DESC'));
}
$records = $watching->find(array('user_id' => User::get('id'), 'open' => $this->view->filters['show'] == -1 ? 1 : 0));
if (count($records)) {
$ids = array();
foreach ($records as $record) {
$ids[] = $record->ticket_id;
}
$this->view->rows = $obj->getRecords("(f.id IN ('" . implode("','", $ids) . "'))", $this->view->filters);
}
}
// Set any errors
foreach ($this->getErrors() as $error) {
$this->view->setError($error);
}
// Output the HTML
$this->view->display();
}
