[phpBT-dev] CVS: phpbt report.php,1.12,1.13

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4119

Modified Files:
	report.php 
Log Message:
DB conversion

Index: report.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/report.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- report.php	2001/08/14 13:19:39	1.12
+++ report.php	2001/08/17 02:56:22	1.13
@@ -31,10 +31,10 @@
 	$t->set_var('reporttitle', 'Bug resolutions');
 	
 	// Start off our query
-	$querystring = 'select Email as "Assigned To", sum(if(Resolution = "0",1,0)) as "Open"';
+	$querystring = 'select email as "Assigned To", sum(if(resolution_id = "0",1,0)) as "Open"';
 	$resfields = array('Assigned To','Open');
 	// Grab the resolutions from the database
-	$q->query("select Name, concat(', sum(if(Resolution = \"',ResolutionID,'\",1,0)) as \"',Resolution.Name,'\"') from Resolution");
+	$q->query("select resolution_name, concat(', sum(if(resolution_id = \"',resolution_id,'\",1,0)) as \"',resolution_name,'\"') from resolution");
 	while (list($fieldname, $countquery) = $q->grab()) {
 		$resfields[] = $fieldname;
 		$querystring .= $countquery;
@@ -42,12 +42,12 @@
 	$resfields[] = 'Total';
 	
 	if ($projectid && is_numeric($projectid)) {
-		$projectquery = "where Project = $projectid";
+		$projectquery = "where project_id = $projectid";
 	} else {
 		$projectquery = '';
 	}
 	
-	$q->query("$querystring, count(BugID) as Total from Bug b left join User u on AssignedTo = UserID $projectquery group by AssignedTo");
+	$q->query("$querystring, count(bug_id) as 'Total' from bug b left join user u on assigned_to = user_id $projectquery group by assigned_to");
 	if (!$q->num_rows()) {
 		$t->set_var('rows', 'No data to display');
 	} else {