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'))))); }