TEMS -Time and Expense Management System News
Captures time & expense by project and account; generates invoice
Brought to you by:
kallolnandi
Major fixes related to authorizations and security were published in this version on March 5, 2012.
If you are using any prior version, you have to change a view of the database. Simply go to your database using PhpMyAdmin or any other way you would like, and execute the following command.
CREATE or Replace VIEW timesbyweekend AS select
users_id AS users_id,
weekenddate AS weekenddate,
sum(nonbillablehours) AS totalnonbillhrs,
sum(billablehours) AS totalbillhrs,
sum((billablehours + nonbillablehours)) AS totalhrs,
min(status) AS loweststatus,
users_id AS createby
from times
group by users_id,weekenddate;