[MOD] Age of Tickets (Minutes, Hours, or Days): Page 4

[MOD] Age of Tickets (Minutes, Hours, or Days)

miszjieha

is that any possible that i can store the timeopen inside my database (ticket_table) ?

pls help..

scottro

is that any possible that i can store the timeopen inside my database (ticket_table) ?
pls help..

Well...you could. But you have to code it so that its updated every time someone views the tickets page or something similar, otherwise its not going to know that it needs to update every minute or so. You could also run a cron but that seems silly.

You would need to add in a new column in your ost_ticket table and then update it. It would be a fair amount of work. Might be easier to just re-reference the code I supplied for this MOD.

mouseware

Very Nice!

Awesome mod, thanks!

miszjieha

Well...you could. But you have to code it so that its updated every time someone views the tickets page or something similar, otherwise its not going to know that it needs to update every minute or so. You could also run a cron but that seems silly.
You would need to add in a new column in your ost_ticket table and then update it. It would be a fair amount of work. Might be easier to just re-reference the code I supplied for this MOD.

my boss want the staff to put some note if the ticket haven't close more than a week (compulsory)..so i plan to used timeopen as the condition..but the problem is i need to edit (eg/tickets.php and editicket.php) i have don a lot of thing but it's still not working..

did u got any idea to solve my problem...

thanks..

scottro

my boss want the staff to put some note if the ticket haven't close more than a week (compulsory)

Why not just use the "Overdue" feature?

Admin Panel > Settings > Ticket Grace Period

Then set the hours to one week (604800)

miszjieha

Why not just use the "Overdue" feature?
Admin Panel > Settings > Ticket Grace Period
Then set the hours to one week (604800)

oh thanks...i never take a look at that setting...:)

Glein

problem with the colums

hello. great mod but i have 1 problem. when i have implemented the mod the colums are all wrong i dont know what i have done wrong. probably somthing i have missed, can u help ? i have attached a screenshot and the php script. if u would u can just re work the script or tell me what wrong would be really helpfull

[tickets.inc.zip](https://forum.osticket.com/assets/files/migrated/1/9b7cb8bd3d8738eea9bd697357e983f.zip)

scottro

For starters your "Ticket" th is missing the opening tag, it only has the , thats why its not showing up within your table but as plain text outside of the table. You have more problems than that though. You also have two Subject headers. Fix those and then post a pic again and I'll see what else needs fixing from there ;)

int3grate

Scott,

Do you still have the latest version of this mod available somewhere? I tried clicking on the Sudo bash links in your posts but they are all dead. Thanks!

scottro

Scott,
Do you still have the latest version of this mod available somewhere? I tried clicking on the Sudo bash links in your posts but they are all dead. Thanks

Is this what you are looking for?

http://sudobash.net/?p=165(http://sudobash.net/?p=165)

Sorry, all the previous links in this article were from when my site was hosted elsewhere.

int3grate

Is this what you are looking for?
http://sudobash.net/?p=165(http://sudobash.net/?p=165)
Sorry, all the previous links in this article were from when my site was hosted elsewhere.

Yes! Thanks much.

namit

Great job implemented and very happy with this!

scottro

Great job implemented and very happy with this

Awesome! Thanks for the feedback :)

ukracer

Awesome! Thanks for the feedback :)

Hi you are doing a sterling job keeping OS ticket fresh with no main development going on.

Could I ask how hard it is to add something like a column that shows which tickets have recieved a reply since a user last logged in.

WE have 3 people who reply to tickets and some tickets can only be dealt with by one person. I regularly have to open all tickets to see if any have been updated.

God its hard work.

Thanks in advance.

scottro

I don't have anything at present but I do have plans to rework my tooltips MOD, that may help you there.

wabashky

Not trying to thread jack, but i thought of this as well...more along the lines of having that whole line be bold so to show as its new or unread (like in outlook). the problem is this would be different for each user right? Does osticket track when logins happen?

Hi you are doing a sterling job keeping OS ticket fresh with no main development going on.
Could I ask how hard it is to add something like a column that shows which tickets have recieved a reply since a user last logged in.
WE have 3 people who reply to tickets and some tickets can only be dealt with by one person. I regularly have to open all tickets to see if any have been updated.
God its hard work.
Thanks in advance.

ukracer

Not trying to thread jack, but i thought of this as well...more along the lines of having that whole line be bold so to show as its new or unread (like in outlook). the problem is this would be different for each user right? Does osticket track when logins happen?

That sounds like a great idea even just making it bold to show its been replied to since last accessed . I have upwards of 30 tickest open and reading the damn things every hour or so is a PITA.

kremori

Advice pls

When my tickets reach 35 days, they all halt at 35 and even if some tickets are 50 days old the AGE still remains 35.

Anyone knows why

scottro

When my tickets reach 35 days, they all halt at 35 and even if some tickets are 50 days old the AGE still remains 35.
Anyone knows why

You are using old code. Please use the updated code here:

http://sudobash.net/?p=165(http://sudobash.net/?p=165)

graphics

worked perfectly.... thanks!

« Previous Page Next Page »