protected function _search_status()
{
gfatal();
$v = $this->__(array('s', 'e'));
$sql = 'SELECT *
FROM _tickets_status
WHERE status_alias = ?';
if (!($status = _fieldrow(sql_filter($sql, $v['s'])))) {
$this->_error('#E_COMPUTER_NO_STATUS');
}
global $user;
//if (_auth_get('ticket_view_all'))
if ($user->auth_groups() != -1) {
$build = 'SELECT t.*, mb.user_id, mb.user_active, mb.user_firstname, mb.user_lastname
FROM _tickets t, _members mb
WHERE t.ticket_contact = mb.user_id
AND t.ticket_status = ?
AND t.ticket_group IN (??)
AND t.ticket_deleted = 0
ORDER BY t.ticket_start DESC';
$build = sql_filter($build, $status['status_id'], $user->auth_groups());
} else {
$build = 'SELECT t.*, mb.user_id, mb.user_active, mb.user_firstname, mb.user_lastname
FROM _tickets t, _members mb
WHERE t.ticket_contact = mb.user_id
AND t.ticket_status = ?
AND t.ticket_contact = ?
AND t.ticket_deleted = 0
ORDER BY t.ticket_start DESC';
$build = sql_filter($build, $status['status_id'], $user->v('user_id'));
}
return redirect(_link($this->m(), array('x1' => 'search', 'q' => array_key(sql_cache($build), 'sid'), 'e' => $v['e'])));
}
private function _tab_function_computer($v, $uid)
{
global $user;
$sql = 'SELECT c.a_assoc, c.a_value, mb.user_firstname, mb.user_lastname
FROM _computer c, _computer_users cu, _members mb
WHERE c.a_assoc = cu.computer_id
AND cu.computer_uid = mb.user_id
AND mb.user_id = ?
GROUP BY c.a_assoc
ORDER BY mb.user_firstname, mb.user_lastname';
return v_style(array('V_URL' => _link('computer', array('x1' => 'search', 'q' => array_key(sql_cache(sql_filter($sql, $v['uid'])), 'sid')))));
}
