for
write(client.fullname)
query = database.cursor("select distinct weekday(today) from user where 1=1"); if (! query.next()) redirect("db_down.html"); weekday = query[0]; start_date = "today - "+query[0]; query.close(); db_value_list = ""; date_value_list = ""; for (i = 0; i < 7; i++) { query = database.cursor("select sum(hours) from hours where user_id="+ client.id+" and date = "+start_date+" + "+i); if (query.next()) if (query[0]) { writeln("
"); db_value_list += query[0]+" "; } else { writeln("
"); db_value_list += 0+" "; } else { writeln("
"); db_value_list += 0+" "; } query.close(); query = database.cursor("select distinct month("+start_date+"+"+i+ ") as mon, day("+start_date+"+"+i+") as day, year("+start_date+"+"+i+ ") as yr from user where 1=1"); if (! query.next()) redirect("db_down.html"); writeln("
"); date_value_list += query.mon+"/"+query.day+"/"+query.yr+" "; query.close(); }
The above graph shows hours listed below plus hours previously saved.
(Click SAVE to record your entries below)
Date
Project
Type of Work
Hours
Description
for (var i = 0; i < 5; i++) { writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeSelectOptions(client.active_project_list,client.defproject); writeln("
"); writeln("
"); writeSelectOptions(project.category_list,client.defcategory); writeln("
"); writeln("
"); writeln("
"); for (var j = 0; j < 16; j++) { writeln("
"+j); } writeln("
"); writeln("
"); writeln("
"); writeln("
"); for (var j = 0; j < 100; j+= 25) { writeln("
."+j); } writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeln("
"); writeln("
"); }
writeln("
"); dcp = 0; dbcp = 0; for (i = 0; i < 7; i++) { new_cp = db_value_list.indexOf(" ",dbcp); db_val = db_value_list.substring(dbcp,new_cp); writeln("
"); dbcp = new_cp+1; new_cp = date_value_list.indexOf(" ",dcp); date_val = date_value_list.substring(dcp,new_cp); writeln("
"); dcp = new_cp+1; }
Last 7 days
Last 14 days
Month to date
From:
To: