/* $Log: do_report.html,v $ Revision 1.16 1996/08/22 03:07:53 kimberly change button label Revision 1.15 1996/08/22 00:50:37 kimberly add return buttons Revision 1.14 1996/08/21 17:53:54 kimberly rename index.html to index.html; break long lines; add comments Revision 1.13 1996/08/09 02:04:53 kimberly change version number Revision 1.12 1996/08/09 00:00:58 kimberly close heading Revision 1.11 1996/08/08 18:52:53 kimberly add run another report link Revision 1.10 1996/08/08 01:13:49 kimberly layout and copy stuff Revision 1.9 1996/08/02 02:19:51 kimberly changes for flattened directory s structure Revision 1.8 1996/08/01 18:22:24 kimberly look up item name in do_reports to prevent getting nulls from hidden fields not being set properly when the back button is used Revision 1.7 1996/07/31 22:01:21 kimberly prevent blank screen from user typing in URL when on correct prevPage Revision 1.6 1996/07/31 17:53:32 kimberly use writeln to make generated HTML easier to read Revision 1.5 1996/07/31 02:06:44 curtis Removed writeButtonBar() from all pages. We're using frames now. Revision 1.4 1996/07/27 01:37:10 kimberly minor fixes for beta Revision 1.3 1996/07/25 23:38:48 kimberly change project to project_id in query for project summary report Revision 1.2 1996/07/23 18:53:02 kimberly Add Log tag */
date_range = parseReportDateRange(); if (request.date_range_type == "select_range") client.date_range_label = "

for the "+request.date_range_select+"

"; else if (request.date_range_type == "user_range") client.date_range_label = "

for "+request.from_date+" through "+ request.to_date+"

"; if (!(request.do_detail == "yes")) { writeln("

"+request.summary+" Summary Report

"); writeln("

"); writeln(client.date_range_label); writeTableHeader(request.summary,(request.summary != "Project")) if (request.summary == "Employee") writeReport("select id,fullname,firstname,lastname from user order by "+ "lastname,firstname", "select sum(hours),billable from "+ "hours,project where project_id=project.id and user_id=", date_range,true); if (request.summary == "Group") writeReport("select id,name from group order by name", "select sum(hours),billable from hours,project,group_people "+ "where project_id=project.id and hours.user_id=group_people.user_id "+ "and group_id=",date_range,true); if (request.summary == "Project") writeReport("select id,name from project order by name", "select sum(hours),billable from hours,project where "+ "project_id=project.id and project_id=",date_range,false); if (request.summary == "Category") writeReport("select id,name from category order by name", "select sum(hours),billable from hours,project,category where "+ "project_id=project.id and category_id=category.id and category_id=", date_range,true); writeln(""); } else if (request.do_detail == "yes") { item = request[request.detail]; if (request.detail == "Employee") query = database.cursor("select fullname from user where id="+item); else query = database.cursor("select name from "+request.detail.toLowerCase()+ " where id="+item); if (! query.next()) redirect("db_down.html"); item_name = query[0] + " "; query.close(); group_by = request[request.detail+"_by"]; if (group_by == "All") group_by = "All Entries"; multi_hrs_col = (! (request.detail == "Project" || group_by == "Project" || group_by == "Date")); writeln("

"+request.detail+" Detail Report

"); writeln(client.date_range_label); writeln("

"); writeln("

"+item_name+"

"); if (group_by != "All Entries") writeTableHeader(group_by, multi_hrs_col); if (request.detail == "Employee") { from_add = ""; where_add = " hours.user_id="+item+" and "; } if (request.detail == "Group") { from_add = ",group_people "; where_add = "hours.user_id=group_people.user_id and group_id="+item+" and "; } if (request.detail == "Project") { from_add = ""; where_add = "project_id="+item+" and "; } if (request.detail == "Category") { from_add = ""; where_add = " category_id="+item+" and "; } if (group_by == "Employee") { if (request.detail == "Group") writeReport("select id,fullname,firstname,lastname from "+ "user,group_people where active='Y' and id=group_people.user_id "+ "and group_id="+item+" order by lastname,firstname", "select sum(hours),billable from hours,project"+from_add+ " where project_id=project.id and "+where_add+" hours.user_id=", date_range,multi_hrs_col); else writeReport("select id,fullname,firstname,lastname from user order by "+ "lastname,firstname", "select sum(hours),billable from hours,project"+ from_add+" where project_id=project.id and "+where_add+ " hours.user_id=",date_range,multi_hrs_col); } if (group_by == "Group") writeReport("select id,name from group order by name", "select sum(hours),billable from hours,project,group_people"+from_add+ " where project_id=project.id and hours.user_id=group_people.user_id"+ " and "+where_add+" group_id=",date_range,multi_hrs_col); if (group_by == "Project") writeReport("select id,name from project order by name", "select sum(hours),billable from hours,project"+from_add+ " where project_id=project.id and "+where_add+" project_id=", date_range,false); if (group_by == "Category") writeReport("select id,name from category order by name", "select sum(hours),billable from hours,project"+from_add+ " where project_id=project.id and "+where_add+" category_id=", date_range,multi_hrs_col); if (group_by == "Date") writeDateReport(from_add,where_add,date_range); if (group_by == "All Entries") writeAllEntriesReport(item,date_range); if (group_by != "All Entries") writeln(""); }

if (request.prevPage == "reports.html submit") writeln(""); if (request.prevPage == "multi_entry.html submit") writeln("");