[MOD] Export Ticket as PDF: Page 3

[MOD] Export Ticket as PDF

mathesonian

Is this only meant to only display the first message? Thats all I see when it pulls up.

Also, I was playing around with the tutorials on http://www.fpdf.org(http://www.fpdf.org)

and was trying to make it have a header and footer as shown here

http://www.fpdf.org/en/tutorial/tuto2.htm(http://www.fpdf.org/en/tutorial/tuto2.htm)

When I add the following to the pdf.php it doesn't seem to do anything.

class PDF extends FPDF

{// Page header
function Header()
{    // Logo
    $this->Image('logo.png',10,6,30);
    // Arial bold 15
    $this->SetFont('Arial','B',15);
    // Move to the right
    $this->Cell(80);
    // Title
    $this->Cell(30,10,'Title',1,0,'C');
    // Line break
    $this->Ln(20);
}// Page footer
function Footer()
{    // Position at 1.5 cm from bottom
    $this->SetY(-15);
    // Arial italic 8
    $this->SetFont('Arial','I',8);
    // Page number
    $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}

}

realn3rd

Yes, it shows only the first message. But I'm working on a new version of the mod which shows all messages an notices.

TheAudioPimp

have a look at fpdi, it can pull a pdf as a template, very useful.... but still we await the messages and replies code..

cheers

mathesonian

Will do, thanks for the tip!

Can't wait to see the finished result

realn3rd

New version out!!!

I finished the new version. If you already use the mod, you only need to replace the pdf.inc.pdf from the updated download-link in the first post in this thread. I includeded more and better comments in the pdf.inc.php. They are now in german & english.

Please let me know if you are satisfied with this new version!!

TheAudioPimp

Hi ive got this working, but it only does it like this:

Message

Response

If there are any user messages after a response these are not displayed only the admin messages are displayed after the initial one.

When a Staff member logs a call the message automatically becomes "Ticket Created by Admin" and then a response below is added with a description of the ticket problem

When a client logs a call the message becomes a description of the ticket problem

Is there anyway to make the admin write the first logging of the call to the message instead of to the response and then creating the message as "ticket Created by Admin"

That way we could just use the first message, which is all is needed for an overview of the ticket if this PDF was to be use for taking to clients desks or sites

Thanks

realn3rd

You're welcome to help me. I have problems with programming loops.

TheAudioPimp

hi, i dont know enough in PHP to do anything i just follow guides or cut and paste trial and error...

mathesonian

I'll take a crack at it tonight. I'm not great with php but maybe I can help figure it out.

realn3rd

I'm also not really a developer, but it's easy to work with the FPDF-class. There is a good documentation (fpdf.org)

TheAudioPimp

Any help from anyone would be great!...

TheAudioPimp

Anyone got this fully functioning so it displays the ticket thread information from both the admin and users in the right order ?

TheAudioPimp

Did anyone ever get this going listing the Messages properly?

DerNeo

Im getting errors:
FPDF error: Some data has already been output, can't send PDF file (output started at /home/public_html/support/include/staff/pdf.inc.php)

delete the first blank line in and any space in pdf.php

------

<?php

--------script must be start clear

<?php

TheAudioPimp

delete the first blank line in and any space in pdf.php
------
<?php
--------script must be start clear
<?php

I have it working now thanks, but it doesn't display Messages and Responses correctly:

Messages are Users replys to a ticket

Responses are Staff replys to a ticket

I was my PDF to output just either the users 1st message only or the Staffs 1st message (Which is actually the second) as the Logged by admin is the first ie

When a Staff member logs a call the message automatically becomes "Ticket Created by Admin" and then a response below is added with a description of the ticket problem

When a client logs a call the message becomes a description of the ticket problem

I just want either the Users first Message or the Staffs 2nd Response (As the first response when logging a tciket by staff is "Ticket Created by Admin"

My PDF code for this message section is:

// Fetch Message from DB

$sql='SELECT msg.msg_id,msg.created,msg.message,count(attach_id) as attachments FROM '.TICKET_MESSAGE_TABLE.' msg '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON msg.ticket_id=attach.ticket_id AND msg.msg_id=attach.ref_id AND ref_type='M' ".

' WHERE msg.ticket_id='.db_input($id).

' GROUP BY msg.msg_id ORDER BY created';

$msgres =db_query($sql);

while ($msg_row = db_fetch_array($msgres)) {

$message_row=$msg_row;

$message = str_replace("\n\r", "$pdf->Ln", $message_row);

$message = str_replace('„', '"', $message_row);

$message = str_replace('•', '-->', $message_row);

$message = str_replace('€', ' Euro', $message_row);

$message = str_replace('„', '"', $message_row);

$pdf->drawTextBox(utf8_decode($message), 174,'L', 'T',1);

$pdf->Setx(18);

$pdf->drawTextBox("", 174,1, 'L', 'T',0);

//$pdf->MultiCell( 174, 5, utf8_decode($message) , '1', 'J', 0);

//$pdf->MultiCell( 174, 1, "" , '0', 'J', 0);

// get answers for messages

$sql='SELECT resp.*,count(attach_id) as attachments FROM '.TICKET_RESPONSE_TABLE.' resp '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON resp.ticket_id=attach.ticket_id AND resp.response_id=attach.ref_id AND ref_type='R' ".

' WHERE resp.ticket_id='.db_input($id).

' GROUP BY resp.response_id ORDER BY created';

$resp =db_query($sql);

while ($resp_row = db_fetch_array($resp)) {

$respID=$resp_row;

$response=$resp_row;

$pdf->Setx(18);

$pdf->drawTextBox(utf8_decode($response), 174, 'L', 'T',1);

Thanks

TheAudioPimp

Actually just tested this and it does the following:

User Logged Ticket - Creates 1 message DB Entry with the message description

Staff Logged Ticket - Creates 1 message DB Entry with "Ticked Created by Admin" and

Creates 1 response DB Entry with the message description

So i need my PDF code to read the first user message if ticket was logged by USER, or the first Staff Response if logged by a Staff Member (ignoring the first message which is "Ticket Created By Admin")

So need PHP code to check for User Message and if it finds one check it is first if it is, display it unless it contains "ticket created by admin" and if it does contain this, ignore it then use the first Staff response.

Can anyone help me with this.....?

TheAudioPimp

Ok, I managed to get this kinda working, except for one bit.

When a staff member logs a ticket, the Message "Logged by Admin" is created along with the Response which details the problem> When I print to PDF it works it ignores the "logged by admin" and prints the Response only as per what i want

When a User logs a ticket, the message is created (No responses) but when printing to PDF it wont print the PDF, it just gives a blank screen, but as soon as there is a Staff response to the original ticket message reply it works.... it will print the first message only as per what I want..... its like it need both a Message and a Response...

Here is my Code.... what am missing/wrong with?

Top code

<?

// Fetch Message from DB

$sql='SELECT msg.msg_id,msg.created,msg.message,count(attach_id) as attachments FROM '.TICKET_MESSAGE_TABLE.' msg '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON msg.ticket_id=attach.ticket_id AND msg.msg_id=attach.ref_id AND ref_type='M' ".

' WHERE msg.ticket_id='.db_input($id).

' GROUP BY msg.msg_id ORDER BY created';

$msgres =db_query($sql);

while ($msg_row = db_fetch_array($msgres)) {

$message_row=$msg_row;

// get answers for messages

$sql='SELECT resp.*,count(attach_id) as attachments FROM '.TICKET_RESPONSE_TABLE.' resp '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON resp.ticket_id=attach.ticket_id AND resp.response_id=attach.ref_id AND ref_type='R' ".

' WHERE resp.ticket_id='.db_input($id).

' GROUP BY resp.response_id ORDER BY created';

$resp =db_query($sql);

while ($resp_row = db_fetch_array($resp)) {

$respID=$resp_row;

$response=$resp_row;

?>

Actual code to print the message or response

if ($message_row == 'Ticket created by Admin')

$pdf->drawTextBox(utf8_decode($response), 174,70, 'L', 'T',0);

else

$pdf->drawTextBox(utf8_decode($message_row), 174,70, 'L', 'T',0);

TheAudioPimp

Sorted it, needed to add } to the end of the SQL Queries

Also had to add DESC to the Group code as it was displaying the latest message instead of the first.

hope this helps someone out.

« Previous Page