phphelpdesk-help

RE: [Phphelpdesk-help] Ticket # in receipts

[Tijl D. <tdu...@co...>]

 Hi, 

I did add the ticket ID , ... into the E-mail to the client but this a
little bit in a frantic way :) 

Because I did not seem to succeed in just putting the $t_id I made a new SQL
query which 
did a select on ticket id where timestamp, problem description , department
etc etc are the same 
as the respective values or the variables in the PHP code.

This is maybe not the most clean way to do it but when you want to make it
work quickly it is a good solution , 
We are using the system now already for one month in prodction and it always
gave correct results. 

Regards, 

Tijl




-----Original Message-----
From: Mitchell K. Smith
To: 'php...@li...'
Sent: 8-11-01 15:25
Subject: [Phphelpdesk-help] Ticket # in receipts

Has anyone been able to get the Ticket# to come through in the email
receipts to the client?
I have tried adding the $t_id variable in several places to no avail.



Mitchell K. Smith
Service and Information Systems Manager
ePlus Technology of PA
130 Futura Drive
Pottstown, PA  19464
610-495-7800 ext. 264
mk...@pa...



_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] Ticket # in receipts

[Matt G. <ma...@ma...>]

I think I found out how it works here.  The mysql command includes 
LAST_INSERT_ID() as what is to be placed into the t_id field of the 
event.  This is interpreted by mysql as a command to just replace 
LAST_INSERT_ID() with whatever was the last id of the last record added.  I 
don't believe this is a good idea, but I could be wrong.  Under heavy 
volume, two tickets could be entered near-simultaneously.  Unless the 
LAST_INSERT_ID() function is only for the user that is logged into mysql at 
that time for that session only.  So the code never knows what the ticket 
id is.  It just tells mysql to look up the last ticket id that mysql just 
created, and use that.  However I believe there is a way to find it.

Matt

At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] Ticket # in receipts

[Matt G. <ma...@ma...>]

I looked at the code in addjob.scp.php.  Here is what I noted.  First, the 
ticket is created, and inserted into the ticket table.  The ticket ID is 
not known by the code at this time.  However, I assume that the ticket ID 
must be known by the time the code inserts the event into the event 
table.  The reason is this: mysql will add a new ticket, and automatically 
increment the ticket ID.  When adding the event, mysql does not know which 
ticketID you are referring to.  So the code must determine the ticket ID, 
and assign it to the event when it inserts it into mysql.  That is the part 
that needs figured out.

Matt

At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help