[MOD] Editable ticket fields!!!

webPragmatist

Hello!

Once again another MOD brought to you by yours truly :)

NOTE: I am in no way responsible for you flubbing up your data using this MOD or if someone hacks into your system and deletes all your fields. This script does check that you are staff but I don't understand the permissions enough (and at this point don't care) to say it's absolutely positively as secure as can be.

As always I included a few lines above/below so you can find where to insert the lines.

And the moment you have been waiting for:

/scp/ajax_editticket.php (Added)

See attachments.

/scp/js/ajax_editticket.js (Added)

See attachments.

/images/icons/ticket_edit.gif

blank

/include/staff/header.inc.php (~Line 17)

<script type="text/javascript" src="js/autolock.js" charset="utf-8"></script>

<?}?>

Addition by webPragmatist (Editable Ticket Fields)

<? if ((basename($_SERVER) == 'tickets.php') && (is_numeric($_GET))) { ?>

<script type="text/javascript" src="js/ajax_editticket.js" charset="utf-8"></script>

<?}?>

/include/staff/viewticket.inc.php (~Line 54)

<td width=50% valign="top">

<table align="center" class="ticketinfo" cellspacing="1" cellpadding="3" width="100%" border=0>

<tr>

<th>Name:</th>

<td><input type="text" name="name" size="30" value="<?=Format:($ticket->getName())?>" id="name" /><a href="javascript(<?=$id?>,'name')"><img src="../images/icons/ticket_edit.gif" /></a></td>

</tr>

<tr>

<th>Email:</th>

<td><input type="text" name="email" size="30" value="<?=$ticket->getEmail()?>" id="email" /><a href="javascript(<?=$id?>,'email')"><img src="../images/icons/ticket_edit.gif" /></a></td>

</tr>

<tr>

<th>Phone:</th>

<td><input type="text" name="phone" size="30" value="<?=$ticket->getPhone()?>" id="phone" /><a href="javascript(<?=$id?>,'phone')"><img src="../images/icons/ticket_edit.gif" /></a></td>

</tr>

<tr>

<th>Source:</th>

<td><?=$ticket->getSource()?>  <?=$ticket->getIP()?></td>

</tr>

</table>

[ajax_editticket.js.txt](https://forum.osticket.com/assets/files/migrated/0/e3f9075d11fb6144f3af820359b7ce9.txt)

[ajax_editticket.php.txt](https://forum.osticket.com/assets/files/migrated/0/e186061538bbd03459929797449eafb.txt)

SLMHC

you bastard! ;)

edit: I am feeling some man love for you now. ;)

________

(DragStar)

webPragmatist

you bastard! ;)

I'm betting right about now you don't feel the same way

SLMHC

I'm betting right about now you don't feel the same way

I am going to install this MOD on Monday. We'll see then if the man love I professed above persists.

________

(herbalaire vaporizer)

jpowers40828

I installed the mod, it says it updates the section, but doesn't change anything.

webPragmatist

I installed the mod, it says it updates the section, but doesn't change anything.

Well, the system sort of sucks because it doesn't have a callback (I'm lazy and it really is a hack) so let's try this to troubleshoot.

1) Login as staff/admin.

2) Visit https://tickets.yoursite.com/scp/ajax_editticket.php?id=354&field=name&value=NBX(https://tickets.yoursite.com/scp/ajax_editticket.php?id=354&field=name&value=NBX) (where id is the ticket id, field is the field name, and value is the value you wish to store in the field.)

3) Go back to your SCP and check if the ticket has been updated with that info.

If not come back check all the installation stuff above once more and then come back and report your findings :)

nekket

This is a very cool feature - thank you!

One issue: When I change the phone number and the number starts with "0" - the "0" is getting removed when I open the ticket again. Why?

webPragmatist

This is a very
moved when I open the ticket again. Why?

Glad to hear that the MOD is working for you. It sounds like the number may be stored as an integer in the DB. I'll check this and make a MOD for that too.

nekket

Glad to hear that the MOD is working for you. It sounds like the number may be stored as an integer in the DB. I'll check this and make a MOD for that too.

Thank you - that's very kind!

jpowers40828

I used the link you gave and modified it so the ticket id was an existing ticket number, and left the field=name&value=NBX, however it did not change the name.

webPragmatist

I used the link you gave and modified it so the ticket id was an existing ticket number, and left the field=name&value=NBX, however it did not change the name.

I've updated the ajax_editticket.php in the original post. The problem was the comment on top wasn't closed properly (I added the comment for the post and didn't test it like a dummy).

Thank you - that's very kind

Put my comment on top of ajax_editticket.php back fool! :

I have fixed the casting as a string. The db_output function in osTicket converts it to a numeric type thus cropping the leading zeros.

All you need to do is update ajax_editticket.php. :

jpowers40828

Sweet, I just closed the comment on the file I had (there was no link in the original post for the file anymore), uploaded it and it works like a charm. Thank you for your hard work on this.

Tyson Edwards

Perhaps I have missed something, but I can't seem to find your copy of ajax_editticket.php anywhere in this thread... I can see people referencing it several times though.

Has this file been removed for some reason?

~Tyson

webPragmatist

Perhaps I have missed something, but I can't seem to find your copy of ajax_editticket.php anywhere in this thread... I can see people referencing it several times though.
Has this file been removed for some reason?
~Tyson

Sorry about that. I guess I forgot to hit "Save Changes" last time I updated the file.

nekket

I've updated the ajax_editticket.php in the original post. The problem was the comment on top wasn't closed properly (I added the comment for the post and didn't test it like a dummy).
Put my comment on top of ajax_editticket.php back fool! :

It's working now! :) Thank you!

chris

Thanks!

Thanks, this is exactly what we needed here! I made a edit icon that fits better if anyone would like it blank

snowmand03

add subject line to this code?

Hi folks,

awesome work on this script. I am really new to this, but would it be possible to add the subject line to this. we are using osticket for a website and want to be able to modify the ticket from "user speak" to "tech speak" i.e. "i cant login" to "user not in database" (just an example)

would it simple enough to add the subject field to this code?

Thanks again,

dave

Corey

Hi folks,
awesome work on this script. I am really new to this, but would it be possible to add the subject line to this. we are using osticket for a website and want to be able to modify the ticket from "user speak" to "tech speak" i.e. "i cant login" to "user not in database" (just an example)
would it simple enough to add the subject field to this code?
Thanks again,
dave

Yes. The files /include/staff/viewticket.inc.php and /scp/ajax_editticket.php would need to be edited slightly.

/scp/ajax_editticket.php

switch ($_GET)

{        case "name":
                $field = 'name';
                break;
        case "email":
                $field = 'email';
                break;
        case "phone":
                $field = 'phone';
                break;
        case "subject":
                $field = 'subject';
                break;

}

/include/staff/viewticket.inc.php

<tr><td colspan=2 class="msg">Subject: <input type="text" name="subject" size="30" value="<?=Format:($ticket->getSubject())?>" id="subject" /><a href="javascript(<?=$id?>,'subject')"><img src="../images/icons/ticket_edit.gif" /></a></td></tr>

linxjp

Thanks! This is exactly the additional functionality we were looking for. I've also added the subject mod listed near the end of this thread. Works great!

Alex

this mod RULES!!!!! Thank you so much for posting this. It's really going to enhance this already amazing ticketing system. Thank you!