[MOD] Allow user to select department

scottro

This is the MOD for the much requested "Allow user to select department"...

blank

Open $TICKETS_HOME/open.php

Remove $_POST= (only this, not the rest of the line)

Open $TICKETS_HOME/include/client/open.inc.php

Before the Subject insert the following:

<tr>

<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)?'selected':''; ?>

<option value="<?=$deptId?>"<?=$selected?>><?=$dept?></option>

<?

}?>

</select>

 <font class="error"><b>*</b> <?=$errors?></font>

</td>

</tr>

I have tested this on my own system and it seems to work fine. Assigning a Help Topic will not assign the dept however. If the user does not select a dept then it will default to the 'Support' dept.

Please let me know if you run into any issues.

vasco.leiria

Being able to change department

Thx for this script. I have another problem now. I need to be able to change the department that might be incorrect.

I made this changes so far:

editticket.inc.php

added in line 15

'deptId'=>$ticket->getDeptId(),

added after the email

<tr>

<td align="left"><b>Department:</b></td>

<td>

<select name="deptId">

<option value="" selected >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)?'selected':''; ?>

<option value="<?=$deptId?>"<?=$selected?>><?=$dept?></option>

<?

}?>

</select>

 <font class="error"><b>*</b> <?=$errors?></font>

</td>

</tr>

Everything seems ok but.. it doesn't update the database.. what am I missing?

Thx for the help