[MOD] Auto Staff Time Sheet

masino_sinaga

Hi osTicket community,

This time, I have successfully created a new MOD that (similar with drozenski did). Please be kind, I created this one since I want to improve what drozenski did, also to answer one of the questions in that topic above that asking about the real-time between the ticket viewing until when the reply or internal note being sent.

The main difference between drozenski's MOD and mine is that: the one I created will automatically save the staff time to database, whereas the MOD that drozenski did will save the staff time manually by entering the time each time staff post a reply or post an internal note. In other word, now staff is unnecessary to enter their time duration manually when they send a reply or an internal note on the current ticket.

Besides that, mine uses seconds as the time value, whereas the drozenski used minutes as the time value that will be saved in database. However, the time spent format that I created will be displayed in a full date and time format, such as: A Day(s), B Hour(s), C Minute(s), D Second(s) instead of only the minutes value.

The reason why I modify it become the time format, is because we have to handle the possibility if the staff's time spent is less than one minute, then we have to display the time in seconds value. Right? :

Here is the screenshot:

blank

I will let you know the complete modification code within the next one day. So, stay tuned! Cheers!

Sincerely,

Masino Sinaga

ringo380

looking forward to this! will it integrate with the other mod or replace it entirely? in other words, do I need to backtrack in my files and remove the other mod entries for this mod to work?

masino_sinaga

some part have the same code, and some part have the different code

@[deleted]0,

Some part of my modification have the same code with drozenski, and some part have the different code. You also can compare first which part have the same code and which part do not, and then decide by yourself whether to integrate the new one to the old one, or you just start to implement my modification from the stratch. It's up to you whether to uninstall the old one or add the new part from me.

But I suggest you to uninstall the old one first, or alternatively, you may try my modification on a fresh osTicket installation.

Good luck.

Sincerely,

Masino Sinaga

masino_sinaga

Modification code

Here is the complete modification code:

(Add Auto Staff Time Sheet Feature into osTicket v1.6 RC5)

Have a nice try, and good luck.

Sincerely,

Masino Sinaga

masino_sinaga

Completely different

Hi,

Thanks for the question about this MOD and my earlier MOD about Duration Time in each message that (I have replied on the other thread). Well, it is completely different, indeed.

First of all, from the purpose of those two MODs, they are different one to each other. (The Duration Time MOD) that I created earlier had the purpose for displaying the time duration between one post with the following post. It meant that the duration time will be calculated from the date/time when the previous post being sent until when the following post being sent. In addition, that MOD also will calculate the duration time from when a ticket being opened until the current date/time when the open ticket being displayed. This is useful to measure and figure out how long the certain ticket being responsed by staff, especially between one post and the next post that following the previous one. This is also useful when you want to show off your helpesk performance to your customer by displaying this information underneath each message/response.

Meanwhile, this Auto Staff Time Sheet MOD that I created later had the purpose for displaying the date/time duration between when staff displaying a ticket until the date/time staff send a reply or an internal note. In other words, the second MOD was being made in order to calculate the staff's time sheet automatically. This is useful to figure out about the staff's performance to response a ticket, especially if you want to calculate, for example, the total of time sheet each staff for the certain period on their job. This is also useful if you want to evaluate your staff, whether you need or not to add additional staff based on the time sheet for each staff, some other time.

Secondly, if you compare the code between those two MODs, they used their own code separately. In other words, you don't have to worry to use them. They will not conflict between one to each other.

You are right, that it looks like they are similar as I used the same technique with the earlier MOD. But, as I mentioned above, they are actually different, indeed. I hope this makes sense.

Sincerely,

Masino Sinaga

beeman

Hi Masino,

I am not questioning the difference in functionality of the two MODs but rather how to integrate the two in one osTicket installation. For instance; in your "The Duration Time MOD" you replace the following code in \include\staff\viewticket.inc.php with;

$resp =db_query($sql);

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

$respID=$resp_row;

<?=Format:($resp_row)?> - <?=$resp_row?>

<?if($resp_row>0){ ?>

<?=$ticket->getAttachmentStr($respID,'R')?>

<?}?>

<?=Format:($resp_row)?>

<?}

$msgid =$msg_row;

}?>

with the following;

$resp =db_query($sql);

$j=1;

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

$i++;

$respID=$resp_row;

$dateend = $resp_row;

$lastdate = $dateend;

$datediff = new Duration($datebegin,$dateend);

$resultdiff=$datediff->Duration($datebegin,$dateend);

<?php echo "(#".$i.") "; echo Format:($resp_row)?> - <?php echo $resp_row?>

<?php if($resp_row>0){ ?>

<?php echo $ticket->getAttachmentStr($respID,'R')?>

<?php }?>

<?php echo Format:($resp_row); ?>

<?php echo "Duration: ".$resultdiff.""; ?>

<?php

$datebegin = $dateend;

$j++;

}

$msgid =$msg_row;

$i++;

}

$datediff = new Duration($firstdate,$lastdate);

$resultdiff=$datediff->Duration($firstdate,$lastdate);

<?php

$totalpost = $i-1;

if ($ticket->getStatus()=='open') {

echo "Total: ".$totalpost." post(s), Duration: ".$resultdiff."";

$lastdate = date("Y-m-d H"); //userdate(); //date("Y-m-d H");

$datediff = new Duration($firstdate,$lastdate);

$resultdiff=$datediff->Duration($firstdate,$lastdate);

echo "Ticket still opened, Total Duration: ".$resultdiff."";

} else {

echo "Total: ".$totalpost." post(s), Duration: ".$resultdiff."";

}

In your new Auto Staff Time Sheet MOD you require that under \include\staff\viewticket.inc.php the;

<?=Format:($resp_row)?> - <?=$resp_row?>

be replaced with;

<?=Format:($resp_row)?> - <?=$resp_row?>, Time Spent: <?php echo $timespentstaff; ?>

but that code does not exist any longer since it was modified by your earlier code for the "The Duration Time MOD".

Regards,

Beeman

masino_sinaga

Hi Beeman,

I see and understood with your point. :

As you see on my screenshot on my first post in this thread above, and also from the description I wrote about how you shoud implement this, I assume you implement this current MOD at the fresh installation of osTicket. So, from the screenshot above we should take a conclusin that this current MOD I implemented at the osTicket fresh installation (there is no other MOD except this current MOD we talk about).

The reason I take this assumption, since not everyone will use that another my MOD. Although I did not say it explicitly, please try to understand that each time a MOD being implemented, we should use that assumption above. It is also impossible if, somehow, I want to implement the certain MOD, then I have to handle all possibilities code that use or modified the same part of code.

Back to your feedback above, please try to adjust it by yourself this MOD if you want to implement it after you implement the previous one. Thanks.

Sincerely,

Masino Sinaga

royale

Great mod, works perfectly :) :)

I thought about a employee-rating/reporting function for the admin, to see how much time was spend on tickets (see example-picture). Maybe just a short, iterative SQL-query?

Maybe someone could help? :)

masino_sinaga

@[deleted],

Nice screenshot!

By the way, did you write the code to implement it, or is it only the static HTML code that you added at the bottom of that page?

If you wrote the code to display it, please share your code for us. :)

However, if it is only the static HTML code, then I will try to make it come true. Stay tuned!

Sincerely,

Masino Sinaga

royale

Thanks Masino, but unfortunately, its only static HTML code

Needless to say, that i would have shared it with you guys if i already realized this

masino_sinaga

@[deleted],

Thanks for your confirmation. No problem, I will try to implement it for all of you, osTicket community!

Sincerely,

Masino Sinaga

masino_sinaga

As I promised, you can now get the modification code about:

(Add Time Spent at the Bottom of Each Staff’s Page of osTicket v1.6 RC5)

The only row that I have not implemented, yet, is about for displaying the information of time spent from "this week". IMHO, "this week" has been represented by "Last 7 Days" row. Does it make sense for you?

Sincerely,

Masino Sinaga

royale

Hi Masino,

thanks for the great work, this mod works like a charm :)

I thought about the "This week" row because a manager in a company would like to know how much a employee worked from monday until today.

but its already perfect

masino_sinaga

@[deleted],

You're welcome.

Actually, you may create a function in order to know how many days that calculated from Monday until today of this week, then get the value that returned by the function and supply it to the SQL as well as I have created:

function DaysNumberStartedFromMondayUntilTodayThisWeek() {

$dayname = date('D');

switch ($dayname)

{

case 'Sun':

$days = 6;

break;

case 'Mon':

$days = 0;

break;

case 'Tue':

$days = 1;

break;

case 'Wed':

$days = 2;

break;

case 'Thu':

$days = 3;

break;

case 'Fri':

$days = 4;

break;

case 'Sat':

$days = 5;

break;

}

return $days;

}

Have a nice try! ;)

Sincerely,

Masino Sinaga

royale

Thanks, ill give it a try ;)

farrelldoc

Great mod, works perfectly :) :)
I thought about a employee-rating/reporting function for the admin, to see how much time was spend on tickets (see example-picture). Maybe just a short, iterative SQL-query?
Maybe someone could help? :)

What would be really great (sorry, no screenshot) is something we could submit to clients where you could separate the timesheet by department (view all time by department, which is how I have my clients organized) and also choose a date range so you don't submit duplicate timesheets. While I'm wishing, the report would also list the date of the time entry and be exportable to Excel, PDF, or both. :-)

Thanks for the great mod! I haven't installed it just yet, but it is definitely going to help!

shinshigumi

What would be really great (sorry, no screenshot) is something we could submit to clients where you could separate the timesheet by department (view all time by department, which is how I have my clients organized) and also choose a date range so you don't submit duplicate timesheets. While I'm wishing, the report would also list the date of the time entry and be exportable to Excel, PDF, or both. :-)
Thanks for the great mod! I haven't installed it just yet, but it is definitely going to help

This is what i'm looking for. called "audit trail". Thanks for this mod!

bigbubc

I used the MOD posted by: drozenski to add the ability to add time to our ticket with RC5 - worked fine for what we did. Once I upgraded to 1.6_ST I am getting errors. I am wondering if you have had a chance yet to try this with the latest update.

I now have a "test" ticket system (didn't before, dumb I know) and am about to attempt your modification - if you'd like I give you another post on my progress. Looks like your MOD will give our CIO better reporting that she is looking for as well.

shinshigumi

Helo sir I applied this mod and its working, but i have a problem whenever a staff starts posting and solving the issue the time starts in 8 hours already?

so basically whenever a staff posted a reply it will become 8+8 hours?

Thanks

champikasam

Hello Masino Sinaga,

Thank you very much for this modification. Is it very useful to me .... :)

@[deleted] : Please update your date.timezone php directive to reflect the timezone you have selected in osTicket settings (or wise-versa) :)