Adding a New Field to tickets

Frink09

There have been a lot of questions about how to add a new field to the ticket and rightly so, the more info a user can provide the better. For our purposes we wanted to add a Company field so we knew exactly who we were dealing with.

We added the field successfully and this thread explains the process. As a favor, can someone help us with adding that new field to the "tickets.inc.php" page?!?! It would be greatly appreciated. We'd like to be able to see Company in that table as a column where you see the ticket id, date, department, priority etc.

To add a new field there are 6 places you have to go to accomplish your goal.

MySQL Database: manually add a field to ost_Ticket

support/include/class.ticket.php

support/include/client/open.inc.php

support/include/client/viewticket.inc.php

include/staff/viewticket.inc.php

include/staff/newticket.inc.php

2.) class.ticket.php

Add your variable here:

class Ticket{

var $id;

var $extid;

var $email;

var $status;

var $created;

var $updated;

var $priority;

and here: like so ($this->newvar=$row;)

if(($res=db_query($sql)) && db_num_rows($res)):

$row=db_fetch_array($res);

$this->id =$row;

$this->extid =$row;

$this->email =$row;

$this->fullname =$row;

and here:

//GET

function getId(){

return $this->id;

}

function getExtId(){

return $this->extid;

}

function getEmail(){

return $this->email;

}

function getNewvar(){

return $this->newvar;

}

and here:

function create($var,&$errors,$origin,$autorespond=true,$alertstaff=true) {

global $cfg,$thisclient,$_FILES;

$id=0;

$fields=array();

$fields = array('type'=>'string', 'required'=>1, 'error'=>'newvar required');

and finally:

$extId=Ticket:();

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

',ticketID='.db_input($extId).

',dept_id='.db_input($deptId).

',priority_id='.db_input($priorityId).

',email='.db_input($var).

',name='.db_input(Format:($var)).

',newvar='.db_input(Format:($var)).

3.) open.inc.php Copy info from other the other fields, just make sure the new field php scripts are different.

4.) viewticket.inc.php Repeat Step 3

5.) staff/viewticket.inc.php Repeat Step 4

6.) staff/newticket.inc.php Repeat Step 5

micro3d

This is a gold mine right here. Just what I was looking for!!

unix4linux

Frink09,

This is exactly what I am looking for to add a new field for the form. I must say I am having a lot of trouble following step3 and above since I don't know exactly what to add and where in the file is a good place to add it. I broke the pages by adding stuff from step 2. Would you be able to explain what I really need to do in step 3?

Thanks a bunch,

micro3d

My line numbers might be a little off as I have other mods but...

class.ticket.php Step 1: approx line 27

class.ticket.php Step 2: approx line 62

class.ticket.php Step 3: approx line 111

class.ticket.php Step 4: approx line 820

class.ticket.php Step 5: approx line 913

3.) open.inc.php Copy info from other the other fields, just make sure the new field php scripts are different.

Say you were adding a confirm email address field, just copy:

$fields = array('type'=>'email', 'required'=>1, 'error'=>'Valid email required');

Paste, then change it to:

$fields = array('type'=>'confirm_email', 'required'=>1, 'error'=>'Email addresses must match');

I changed the elements so they would have different names.

***NOTE:

the 'type' refers to the type of data on the form. confirm_email is not a default type. Here is a list of the types supported for validation by default.

'integer':

'int':

'double':

'text':

'string':

'array':

'radio':

'date':

'time':

'phone':

'fax':

'email':

'url':

'password':

'username':

'zipcode'

Hope this helps you apply the mod.

Also I have not followed these steps yet, I plan on adding fields later today or tomorrow. I will follow up with success or failure.

unix4linux

micro3d,

Thanks a bunch for this. I will try it out very soon and post my outcome. Thanks again for this.

Knossos

This was the biggest problem we had with osticket, thanks!

Frink09

Glad to be of help. Sorry I didn't respond sooner, got distracted with other things. With the help of another user we were able to insert our Company Field as a column in the Staff Tickets area.

bgalvez

Problema al crear nuevo ticket

Estimados,

Segui las instrucciones paso a paso para poder agregar mas opciones al formulario (field) pero encontre un error.

Al tratar de crear un nuevo ticket sin estar autenticado, funciona bien-

Pero, al tratar de crear un nuevo ticket estando autenticado no se despliega la página completamente.

He buscado en el ćodigo cual puede ser ewl problema y no pude encontrar nada.

Alguine me puede ayudar?

Best regards

Saludos

BAGG

micro3d

Google Translation

Estimates,

Segui the directions step by step to add more options to form (field) but I found a mistake.

In trying to create a new ticket without being authenticated, works well -

But in trying to create a new ticket not be authenticated unfolds page completely.

He looked at ćodigo which can be EWL problem and I could not find anything.

Alguin can help me?

I think he is saying on the client side it works fine but on the Staff Ticket creation side it is broken.

As for a fix... I'd guess you would need to add your new fields to the staff\newticket.inc.php just the same as you did for client\open.inc.php

Im going to make time right now to do this mod so I can actually come up with some real ideas.

bgalvez

Hi,

status is:

User not autenticated: good creted new ticket, not problem

User autenticated: problem in create new ticket (show page incomplete)

Staff: good, not problem.

best regards.

BAGG

micro3d

I was able to successfully add a new field to my ticket. I tested it in the client side and the staff side(w/o mod) and it works great!

/* Add New Fields Modification

* Author: James Williams

* osTicket v1.6 RC4

* Date: 07-22-08

* Ref: http://www.osticket.com/forums/showthread.php?t=873(http://www.osticket.com/forums/showthread.php?t=873)

DB Table: ost_ticket

Field Type Collation Attributes Null

location text latin1_general_ci No

+ADD include\client\open.inc.php between subject and intersection

<tr>

<th valign="top">Location, Address, or Intersection:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="location" cols="35" rows="3" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>