Multiple formularies

bernoldi

Hello all,

I am implementing osTicket here and trying to mod it to attend better my needs.

The main idea is to have more than one formulary for my users as we have completely different requests.

This is what I am doing (sorry, never used php in my life. I just started because of osTicket):

On the “index.php” I have added a dropdown list that gets the information from the database and shows all the formularies available. The variable “$inc” holds the selection that will be requested for “open.php”.

Link style:

../open.php?formularySel=open-training.inc.php

"open.php" Gets the value:

$inc=$_GET;

It is working great, now I have an exclusive “open.inc.php” per formulary.

Searching on the forum, I found how to add new fields on the formulary and also worked perfectly.

Now my noob questions:

– Should I have one “class.ticket.php” per formulary or is there another way to work it?

– Working with more than one “open.inc.php”, are there any more file that I should modify (beyond class.ticket.php) adding the new formulary name?

Thank you in advance!

Ricardo

bernoldi

Hello again,

I just found the below topic that worked better than my reported approach.

(http://www.openscriptsolution.com/2009/09/29/different-open-ticket-pages-in-osticket-system-v1-6-rc5)

It is already working as expected, but I have a question. Each formulary has different questions and will become a mess if I try to store in the table "ticket". How to specify a different table to store the tickets, according to the "helptopic"?

Thanks!

Ricardo

bernoldi

To finish the topic I will post the solution I used, maybe it will be useful to somebody.

I just used a switch inside the class.ticket.php that checks the $helptopic variable.

open.ticket.php:

I have changed the code:

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

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

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

',topic_id='.db_input($topicId).

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

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

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

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

',helptopic='.db_input(Format:($topicDesc)).

',phone="'.db_input($var,false).'"'.

',phone_ext='.db_input($var?$var:'').

',ip_address='.db_input($ipaddress).

',source='.db_input($source);

Into this:

switch ($_REQUEST) {

case "`Form_1":

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

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

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

',topic_id='.db_input($topicId).

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

',ip_address='.db_input($ipaddress).

',source='.db_input($source).

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

',email='.db_input($var)

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

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

',supplier_name='.db_input($var);

break;

case "Form_2":

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

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

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

',topic_id='.db_input($topicId).

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

',ip_address='.db_input($ipaddress).

',source='.db_input($source).

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

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

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

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

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

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

',justification='.db_input($var);

break;

}

I also needed to insert into main.inc.php the new tables:

main.inc.php:

I have changed the code:

define('TICKET_TABLE',TABLE_PREFIX.'ticket');

Into this:

define('TICKET_form1',TABLE_PREFIX.'ticket_form1');

define('TICKET_form2',TABLE_PREFIX.'ticket_form2');

Cheers,

Ricardo