Menampilkan Anggota Staf dari Departemen Aktif di Modifikasi Penugasan Tiket Bertumpuk osTicket v1.6 RC5

                                $sql=' SELECT staff_id,CONCAT_WS(", ",lastname,firstname) as name FROM '.STAFF_TABLE.
                                     ' WHERE isactive=1 AND onvacation=0 ';

                                $depts=$thisuser->getDepts();
                                if ($thisuser->isadmin()) {
                                	$where = 'WHERE isactive=1 AND onvacation=0 AND dept.dept_id=staff.dept_id ';
                                } else {
                                	$where = 'WHERE isactive=1 AND onvacation=0 AND dept.dept_id=staff.dept_id '.
		                                      'AND (staff.dept_id IN ('.implode(',',$depts).') OR staff.staff_id='.$thisuser->getId().') ';
                                }
                                $sql='SELECT staff.staff_id,CONCAT_WS(", ",staff.lastname,staff.firstname) as name '.
				       ' FROM '.DEPT_TABLE.' dept, '.STAFF_TABLE.' staff '.
                                       ' '.$where.' ';