[ MOD ] Staff Time Sheet / Tracking

[masino_sinaga]

Hi Beeman,

Thanks for the question.

In order to give the explanation accordingly with the related thread, I will answer your question on my thread above. Please be kind. Thanks.

Sincerely,
Masino Sinaga

[sroscher]

Is it possible to have this MOD for internal notes also? Staff often reports job steps as internal note because the customer shouldn't get involved at any step (as it would be we send ticket replies).

###EDIT###
The issue is still actual. My edit yesterday was because of a different topic - I just mistakenly posted it here. So, help is needed!

[jacobIdesign]

This is exactly what I was looking for. I love osTicket, and I love my invoicing system, but I was getting tired of keeping the times I worked on a ticket in my Project manager...

Real quick, what exactly needs to be added to the DB? Is there a SQL Query I can run instead?

[maarkp]

A long modification but still great with great stuff................

Sales tracking sales tracking software Sales lead tracking software

[bigbubc]

Really appreciate you sharing this MOD it will help us greatly. Thanks again!

[stefen]

could you please clarify what needs to be added to the db? "Table - ticket_response @ ticket_note" which table is this? both the ticket_response AND ticket_note? I'm confused.

[drozenski]

Sorry for the late reply to questions. Been busy here at work.

What i was saying for the DB stuff was this

Table - ticket_response @ ticket_note
Field - time_spent
Type - INT
Length / Value = 11
Null = No
Default = 0


You need to add a new field to two Tables.
The "ticket_response" table and the "ticket_note table"

The new field must have the following structure

Field Name: time_spent
Type: INT
Length / Value = 11
Null = No
Default = 0

[TopExpert]

Great Mod just what I was looking for.

I was wanting to know if you cold tell me what to modify in view.php so that users can see the time spent on their job as well

thanks

AB

[modman]

Hi,

I may have missed this somehow, but how can I send the total time spent so far on the ticket to the user when I respond to the ticket?

I want it to be added to the email response that is sent. Is that possible?

Thank you for your help!!

[conarw]

Thanks for the mod, it works great and is almost perfectly what i need.

Is it possible to have this mod also input the total time spent on this ticket into the dbtable "_ticket"

I extract the data from that table for monthly reports and tracking