[MOD] Ticket Preview (Javascript Tooltip): Page 4

[MOD] Ticket Preview (Javascript Tooltip)

scottro

maybe we continu this on the right thread?
i can send you the php's in pm if you want?
it has to be a stupid, simple thing but i cannot figure it out..

I sent you a PM

freddyvangeel

so i tried to be smart, using a bit of your code...

but it didn't work out..

i have made a print.php to make the customer (and ourself) a printout of the ticket data, and THE FIRST message of the ticket thread.

i have allmost everything right, but the last part; all the thread is parsed, while i only want the first, initial part.

i'll share the print.php here, so maybe you can help me?

thanks again,

freddy

[print.txt](https://forum.osticket.com/assets/files/migrated/7/a5a8415e6a22b7d31ab203e10b4bcb8.txt)

ozkr

is this still alive?

i want to try this mod but i cant download it.

can you share it plz?

tomt

Does this help :

http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview(http://archlinux.me/sudobash/2010/10/26/osticket-javascript-tooltip-ticket-preview)

tomt

OK, that doesn't help as the files are still missing.

How about this, not as pretty, but works and can be customised...

BACKUP EVERYTHING BEFORE YOU START

Download this

(http://www.walterzorn.de/en/tooltip/tooltip_e.htm)

and extract wz_tooltip.js to root/js on your OSticket installation.

( you'll need to create the folder js )

Using the file include\staff\tickets.inc.php

ADD as the very first line: ( before the <?php )

<script type="text/javascript" language="javascript" src="../js/wz_tooltip.js"></script>

FIND <td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>

href="tickets.php?id=<?=$row?>"><?=$subject?></a> and comment it out like this :

<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>

href="tickets.php?id=<?=$row?>"><?=$subject?></a>

ADD the following:

<?

$ticket_id=$row;

$sql_message = mysql_query("SELECT UNIX_TIMESTAMP(created) FROM ost_ticket_message WHERE ticket_id=$ticket_id ORDER BY created DESC LIMIT 1");

$message_created_row = mysql_fetch_array($sql_message);

$message_created = $message_created_row;

$sql_response = mysql_query("SELECT UNIX_TIMESTAMP(created) FROM ost_ticket_response WHERE ticket_id=$ticket_id ORDER BY created DESC LIMIT 1");

$response_created_row = mysql_fetch_array($sql_response);

$response_created = $response_created_row;

if( $response_created < $message_created ):

$title = mysql_query("SELECT message FROM ost_ticket_message WHERE ticket_id=$ticket_id AND created=FROM_UNIXTIME($message_created) LIMIT 1");

$lookup = message;

else:

$title = mysql_query("SELECT response FROM ost_ticket_response WHERE ticket_id=$ticket_id AND created=FROM_UNIXTIME($response_created) LIMIT 1");

$lookup = response;

endif;

while ($TITLE = mysql_fetch_assoc($title)) {

$MESSAGE=$TITLE;

}

$MESSAGE = str_replace("'","`",$MESSAGE);

$MESSAGE = preg_replace("/[^A-Za-z0-9/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","<br/>",$MESSAGE);

$MESSAGE = str_replace("", "", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

?>

<td>

 <span class="hotspot" onmouseover="Tip('<div align=\'left\' class=\'message\'><?=$MESSAGE?>...</div>')" onmouseout="UnTip()">
 <a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" <?}?> href="tickets.php?id=<?=$row?>"><?=$subject?></a></span>

That should be it !!

Colour and layout can be changed by editing wz_tooltip.js, you can also add balloon tips following the example on the tooltip web site.

Hope this helps :)

tomt

I'll be adding this to my online demo later.. if anyone wants to see it :)

tomt

This is now live. Full details :

http://osticket.com/forums/showthread.php?t=6836(http://osticket.com/forums/showthread.php?t=6836)

tomt

Anyone tried my variation ?

What do you think ?

ozkr

Anyone tried my variation ?
What do you think ?

i just implement it and work fine.

i change the way you call the js. for security i put the js file into the scp/js folder and mod the

Thanks!

ozkr

i just realized that in 4 tickets the tooltip does not work instead it show all the client response plus ...')" onmouseout="UnTip()">

the client or staff rewsponse are something like this:

Monitor Samsung LED 20" S20A300N SN: V8CGH9NB600955 ST: 111622196

Solo Monitor Benq LED Gl930 18.5"

SN: ETCSA02422SL0

FALLA: SE APAGA DESPUES DE UNOS MINUTOS

INCLUYE: EN USO, SIN CAJA , CON LEVE RAYADURAS,CON BASE, SIN CABLES

can you fix it plz?

tomt

Is this my version or the original version ?

If It's mine, can you post the code from include\staff\tickets.inc.php

Thanks

scottro

Hi
Is this my version or the original version ?
If It's mine, can you post the code from include\staff\tickets.inc.php
Thanks

This is my own original version - I'm no longer maintaining it though as when I moved websites I accidentally deleted the files for this.

tomt

i just realized that in 4 tickets the tooltip does not work instead it show all the client response plus ...')" onmouseout="UnTip()">
the client or staff rewsponse are something like this:
or
can you fix it plz?

Try replacing :

$MESSAGE = str_replace("'","`",$MESSAGE);

$MESSAGE = preg_replace("/[^A-Za-z0-9/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","<br/>",$MESSAGE);

$MESSAGE = str_replace("", "", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

WITH:

$MESSAGE = str_replace("'","`",$MESSAGE);

$MESSAGE = str_replace(chr(34),"”",$MESSAGE);

$MESSAGE = preg_replace("/[^A-Za-z0-9/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","<br/>",$MESSAGE);

$MESSAGE = str_replace("", "", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

this replaces the normal quotation marks your using for monitor sizes

Monitor Samsung LED 20"

With right double quotation marks

Monitor Samsung LED 20”

Hope this helps :)

ozkr

$MESSAGE = str_replace("'","`",$MESSAGE);

$MESSAGE = str_replace(chr(34),"”",$MESSAGE);

$MESSAGE = preg_replace("/[^A-Za-z0-9/", ' ', $MESSAGE);

$MESSAGE = str_replace("\r\n","
",$MESSAGE);

$MESSAGE = str_replace("", "", $MESSAGE);

$MESSAGE = substr($MESSAGE,0,300);

i change this part:

$MESSAGE = str_replace(chr(34),"”",$MESSAGE);

to:

$MESSAGE = str_replace(chr(34),"´´",$MESSAGE);

thanks.

« Previous Page