(open.staff_id=0 OR open.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->getId()).') '; // gerald
$sql.='LEFT JOIN '.TICK... ue.staff_id=0 OR overdue.staff_id='.db_input($thisuser->getId()).' OR dept.manager_id='.db_input($thisuser->getId()).') '; // gerald
$sql.='LEFT JOIN '.TICK... sql.=' WHERE ticket.dept_id IN('.implode(',',$thisuser->getDepts()).') OR ticket.staff_id='.db_input($thisuser->getId());
}
</code>
Wenn man schon dabei ist, u