Add "department" to edit ticket screen

holodoctor1

Hello!

I'm trying to add the department drop-down to the "edit ticket" screen. Copy/pasting the drop-down from the "view ticket" page gets it to show up, but changing it and pressing save doesn't do anything. Is there way to get the department to update on the edit ticket screen?

Thank you!

Rich_C

Hello!
I'm trying to add the department drop-down to the "edit ticket" screen. Copy/pasting the drop-down from the "view ticket" page gets it to show up, but changing it and pressing save doesn't do anything. Is there way to get the department to update on the edit ticket screen?
Thank you

I do not have a lot of time so I cannot post the code you will need but in the new ticket you will need to look for the posting or submit portion of the code and add the save back to the DB there. This should fix your issue.

If i recall correctly off the top of my head I believe the code your looking for is somewhere after

// Here we go or // hold on to your seats (it has a pretty funny comment above the code you need to add to)

holodoctor1

or submit portion of the code and add the save back to the DB there.

This is the step I'm confused about... is it located in class.ticket or something? Not sure how to connect the form to the database to allow a field to change something in the database... :-/ (i.e. change dept., click submit, database gets updated with new dept)

Thank you

holodoctor1

still having trouble

Hi there,

I'm still having trouble figuring out how to detect and "submit" a selection on a form. Any advice?

Thank you in advance!

holodoctor1

Maybe a little more data would help.

Here is what I'm putting on the "dept" screen (i.e. in editticket.inc.php):

<tr><td>Assigned To (NOT YET WORKING):</td>

<td>

<form action="tickets.php?id=<?=$id?>#assign" name="notes" method="post" enctype="multipart/form-data">

<input type="hidden" name="ticket_id" value="<?=$id?>">

<input type="hidden" name="a" value="update">

<select id="staffId" name="staffId">

<option value="0" selected="selected">-Select Staff Member.-</option>

<?

//TODO: make sure the user's group is also active....DO a join.

$sql=' SELECT staff_id,CONCAT_WS(", ",lastname,firstname) as name FROM '.STAFF_TABLE.

' WHERE isactive=1 AND onvacation=0 ';

if($ticket->isAssigned())

$sql.=' AND staff_id!='.db_input($ticket->getStaffId());

$depts= db_query($sql.' ORDER BY lastname,firstname ');

while (list($staffId,$staffName) = db_fetch_row($depts)){

$selected = ($info==$staffId)?'selected':''; ?>

<option value="<?=$staffId?>"<?=$selected?>><?=$staffName?></option>

<?

}?>

</select><font class='error'> *<?=$errors?></font></td></tr>

</td></tr>

Here is what is in the ticket.php file under 'update'

case 'update':

$page='editticket.inc.php';

if(!$ticket || !$thisuser->canEditTickets())

$errors='Perm. Denied. You are not allowed to edit tickets';

elseif($ticket->update($_POST,$errors)){

$msg='Ticket updated successfully';

$page='viewticket.inc.php';

}elseif(!$errors) {

$errors='Error(s) occured! Try again.';

}

break;

I've tried copy/pasteing what was under 'assign' in tickets.php, but it error'd out. (unsuprising).

I realize that in editticket.inc.php, everything is shooting back to 'update' in tickets.php which is the posting it to the database (upon pressing "update ticket") but I'm not able to add "assigned staff" to that screen and have both it past and the other data on the page post to the database.

Any help would be greatly appreciated!