2. PHPRunner General questions
  3. Adding a Ticket System
This topic is locked

Adding a Ticket System

 		5/28/2008 9:11:33 AM
PHPRunner General questions
N
 nix386 author

So I was thinking about using PHPRunner to create a ticket system for a current project I have been working on (already using phprunner).

I thought this would be fairly easy until I tried to implement it as I seem to come undone when creating a threaded style blog on the view pages..

Any suggestions for creating a blog style ticket system in PHP Runner?
Using 4.1 btw....
N
 		nix386 author 5/29/2008

Anyone?!
A bit more detail maybe? I am going nuts trying to get my head around it.....
As mentioned I am trying to create a threaded style view for records where admin/users can post a responce to a created record.
simple example for viewing and editing the ticket record.
-----------------------------------------------------

-------------------record id------------------------

---Name : Name of Ticket

---User : UserName

---Date : DateTime

---Problem :

---Solution :

---Open/Closed

-----------------------------------------------------

-------------------responce-1---------------------

---Name : Name of Ticket

---User : UserName

---Date : DateTime

---Reply : Blah Blah Blah.........

-----------------------------------------------------

-----------------------------------------------------

-------------------responce-2---------------------

---Name : Name of Ticket

---User : UserName

---Date : DateTime

---Reply : Blah Blah Blah.........

-----------------------------------------------------

-----------------------------------------------------

-------------------responce-3---------------------

---Name : Name of Ticket

---User : UserName

---Date : DateTime

---Reply : Blah Blah Blah.........
J
 		Jane 5/29/2008

Hi,
you can create master-detail relationships between these two tables. Then add custom event on the view page of master table and print all detail records in this event.

Here is a sample event:

global $conn;

if (@$_REQUEST["editid1"])

{

//select records from detail table

$str = "select * from DetailTable where Name='".$_SESSION["DetailTable_masterkey1"]."'";

$rs = db_query($str,$conn);

while($data = db_fetch_array($rs))

{

//print selected records

echo "name: ".$data["name"];

echo "date: ".$data["date"];

echo "reply: ".$data["reply"];

}

}


Also you can add link to the add page of detail table in this event if needed.
N
 		nix386 author 5/29/2008

Thanks Jane, this might just do......now just wrestling with formatting the output to look right, it's adding the values but to the top of the view page which looks a little unusual. Is there a way to get the printed values into the context of the page i.e the view table?

Hi,

you can create master-detail relationships between these two tables. Then add custom event on the view page of master table and print all detail records in this event.

Here is a sample event:
Also you can add link to the add page of detail table in this event if needed.
J
 		Jane 5/29/2008

Hi,
just grag and drop your custom event to another place on the page.