ser->isAdmin()) // gerald
$sql.='AND (open.staff_id=0 OR open.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->getId()).') '; // gerald
$s... ->isAdmin()) // gerald
$sql.='AND (overdue.staff_id=0 OR overdue.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->get... JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id='.db_input($thisuser->getId());
if(!$thisuser->isAdmin()){
$sql.=' WHERE ticket.dept_id IN('.implode(',',$thisuser->getDepts()).') OR ticket.staff_id='.db_input($thisuser->getId());
}
</code>
Wenn m
