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….
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