Written by This is the MOD for the much requested “Allow user to select department”…
Open $TICKETS_HOME/open.php
Remove
$_POST['deptId']=
(only this, not the rest of the line)
Open $TICKETS_HOME/include/client/open.inc.php
Before the Subject
insert the following:
<td align="left"><b>Department:</b></td>
<td>
<select name="deptId">
<option value="" selected >Select Department</option>
<?
$services= db_query('SELECT dept_id,dept_name FROM '.DEPT_TABLE.' ORDER BY dept_name');
while (list($deptId,$dept) = db_fetch_row($services)){
$selected = ($info['deptId']==$deptId)?'selected':''; ?>
<option value="<?=$deptId?>"<?=$selected?>><?=$dept?></option>
<?
}?>
</select>
<font class="error"><b>*</b> <?=$errors['deptId']?></font>
</td>
</tr>
Superb….. 😉 was trying to get this fixed from a very long time…
At Last.. Got it fixed… thank you so much….
Regional marine construction company for Gulf Coast and inland waters
Many Thanks…you saved my day
Hi,
why now the client can see the private department as well?
can i make the private dept. private?
tahnks
Ahhh, yea — I don’t use private departments so I never thought about it. I’ll update the code to check for only public depts and then reply here again so you know.
Hi Scott
Hi Peeps
I have not tried every MySql tool to assist me to get better reporting or more detailed reporting for osticket but no luck.
I would like to ask if there is anyone who has created there own reporting script to suite there business needs , if yes please respond to this thread or contact me on jason.kleinhans[at]gmail[dot]com
what i would like to see is the following in my reports:
Tickets per department: let me give an example , tickets per deparment must not give me just figures i need detail. it must show me
TicketID | Department | Helptopic | Subject | ticket count , for the month , year , day and week.
and so i need the same for Tickets Per Staff , Tickets Per Client , Tickets Per HelpTopic
the detail will differ from report to report for the Ticket per Helptopic i need to know how many Networking or Application tickets did we receive per month , day , week and year and within this reports i need to have the staff list who worked on the ticket and when it was created and when it was closed