Menu

#6 Billable hours for month

open
nobody
Simple Fix (4)
5
2004-05-12
2004-05-12
No

In 0.9.1 the mytasks page has a field "Completed
Billable Hours for thismonth" but the value that is
displayed is the
number of hours completed in total.

The fix to show just the hours worked this month is:

346c346
< $b_query = "SELECT DATE_FORMAT(enddate,'%M,
%Y'), hours FROM IPM_tasks WHERE person='$user_id' AND
status='0' AND billable='1'";
---
> $b_query = "SELECT DATE_FORMAT(enddate,'%M,
%Y') as enddate, hours FROM IPM_tasks WHERE
person='$user_id' AND status='0' AND billable='1'";
349,350c349,353
< echo "$b_total[enddate]";
<
$billable_total=$billable_total+$b_total[hours];
---
> #echo "$b_total[enddate]";
> if ( $b_total[enddate] ==
$thismonth )
> {
>
$billable_total=$billable_total+$b_total[hours];
> }

Discussion


Log in to post a comment.