Ticket Classification

drozenski

Has any on done something like this?

Have a drop down list that is populated with a bunch of options.

> Server

> Phone

> Hardware

> network

> Printing

> User error

When closing a ticket the staff has to choose one that best fits the ticket. This will put that into the database so it's much easier to look up tickets based on a central "classification" so to say.

I've tried making this myself with little success.

Anything out their?

masino_sinaga

How did you populate that list?

I mean, does that list being derived from another table (perhaps you create a new table such as ost_classsification), or that list being defined as "enum" value in the ost_ticket table, just like enum value in the status field that contains of: 'open', 'closed' ?

In addition, that would be better if you post your code/modification you made so far, so that we will continue/complement it as well as possible.

Sincerely,

Masino Sinaga

drozenski

Here is what i have, i dont know why it wont work. I dont get any errors when i click submit.

<form name="user_status" method="POST">

<select name="Usr_Status">

<option value="active">Active</option>

<option value="inactive">Inactive</option>

<?php

$usr_status = isset($_POST) ? $_POST : 'active';

$sql='INSERT INTO '.TICKET_MESSAGE_TABLE.' SET created=NOW() '.

',user_status='.db_input($usr_status).

$qry = mysql_query($sql);

?>

<input class="button" type="submit" value="user_status">

</form>

Im going to add more options after i get it working. Can any one help me with my code and point out any issues?

Thanks

masino_sinaga

Of course that code will not work at all! :

You cannot use such code if you want to manipulate your data that derived from a form and save it to database.

If you use such code:

<form name="user_status" method="POST">

then you should decide what is the destination file that will proceed the update or insert into SQL statement as the form action.

For example, you should use like this:

<form name="user_status" action="tickets.php" method="POST">

Besides that, you should put that SQL statement in class.ticket.php for this purpose and easier for you to maintain your code.

You can follow the existing code technique and its approach that used by osTicket.

Sincerely,

Masino Sinaga

webster

I need something like this aswell. Would make finding tickets and sorting them by issue so much easier.

Drozenski please let me know if you figure this out. It would be a huge help!

Thanks

- Ryan

royale

I need something like this aswell. Would make finding tickets and sorting them by issue so much easier.
Drozenski please let me know if you figure this out. It would be a huge help!
Thanks
- Ryan

Im interested too