[phpBT-dev] CVS: phpbt query.php,1.76,1.77 include.php,1.118,1.119

[Jirka P. <fi...@us...>]

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

Modified Files:
	query.php include.php 
Log Message:
Added some fields needed for [to be] closed in version tracking and database tracking. I think it's really hard to understand what file have to be changed, when doing something like this, so please check it for my mistakes. I've tested it a bit, but it have to be tested harder. Let me know.


Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.76
retrieving revision 1.77
diff -u -r1.76 -r1.77
--- query.php	8 Jun 2002 20:28:30 -0000	1.76
+++ query.php	12 Jun 2002 11:39:11 -0000	1.77
@@ -176,47 +176,56 @@
 		$QUERY;
 
 	$query_db_fields = array(
-		'bug_id' => 'bug_id',
-  	'title' => 'title',
-  	'description' => 'description',
-  	'url' => 'url',
-  	'severity_name' => 'severity.severity_name',
-  	'priority' => 'priority',
-  	'status_name' => 'status.status_name',
-  	'resolution_name' => 'resolution_name',
-  	'reporter' => 'reporter.login as reporter',
-  	'owner' => 'owner.login as owner',
-  	'created_date' => 'b.created_date',
-  	'lastmodifier' => 'lastmodifier.login as lastmodifier',
-  	'last_modified_date' => 'b.last_modified_date',
-  	'project_name' => 'project.project_name',
-  	'version_name' => 'version.version_name',
-  	'component_name' => 'component.component_name',
-  	'os_name' => 'os.os_name',
-  	'browser_string' => 'browser_string',
-  	'close_date' => 'close_date'
+	    'bug_id' => 'bug_id',
+  	    'title' => 'title',
+	    'description' => 'description',
+	    'url' => 'url',
+	    'severity_name' => 'severity.severity_name',
+	    'priority' => 'priority',
+	    'status_name' => 'status.status_name',
+	    'resolution_name' => 'resolution_name',
+	    'reporter' => 'reporter.login as reporter',
+	    'owner' => 'owner.login as owner',
+	    'created_date' => 'b.created_date',
+	    'lastmodifier' => 'lastmodifier.login as lastmodifier',
+	    'last_modified_date' => 'b.last_modified_date',
+	    'project_name' => 'project.project_name',
+	    'version_name' => 'version.version_name',
+	    'to_be_closed_in_version_name' => 'version2.version_name as v2',
+	    'closed_in_version_name' => 'version3.version_name as v3',
+	    'database_provider' => TBL_DATABASE.'.database_name',
+	    'database_version' => TBL_DATABASE.'.database_version',
+	    'component_name' => 'component.component_name',
+	    'os_name' => 'os.os_name',
+	    'browser_string' => 'browser_string',
+	    'close_date' => 'close_date'
   	);
 
 	$db_headers = array(
-		'bug_id' => 'bug_id',
-		'title' => 'title',
-		'description' => 'description',
-		'url' => 'url',
-		'severity_name' => 'severity.sort_order',
-		'priority' => 'b.priority',
-		'status_name' => 'status.sort_order',
-		'owner' => 'owner',
-		'reporter' => 'reporter',
-		'lastmodifier' => 'last_modifier',
-		'created_date' => 'b.created_date',
-		'last_modified_date' => 'b.last_modified_date',
-		'project_name' => 'project_name',
-		'component_name' => 'component_name',
-		'version_name' => 'version_name',
-		'os_name' => 'os_name',
-		'browser_string' => 'browser_string',
-		'resolution_name' => 'resolution.sort_order',
-		'close_date' => 'close_date');
+	    'bug_id' => 'bug_id',
+	    'title' => 'title',
+	    'description' => 'description',
+	    'url' => 'url',
+	    'severity_name' => 'severity.sort_order',
+	    'priority' => 'b.priority',
+	    'status_name' => 'status.sort_order',
+	    'owner' => 'owner',
+	    'reporter' => 'reporter',
+	    'lastmodifier' => 'last_modifier',
+	    'created_date' => 'b.created_date',
+	    'last_modified_date' => 'b.last_modified_date',
+	    'project_name' => 'project_name',
+	    'component_name' => 'component_name',
+	    'version_name' => 'version_name',
+	    'os_name' => 'os_name',
+	    'to_be_closed_in_version_name' => 'v2',
+	    'closed_in_version_name' => 'v3',
+	    'database_provider' => TBL_DATABASE.'.database_name',
+	    'database_version' => TBL_DATABASE.'.database_version',
+	    'browser_string' => 'browser_string',
+	    'resolution_name' => 'resolution.sort_order',
+	    'close_date' => 'close_date'
+	);
 
 	extract($_gv);
 	if (!isset($page)) {

Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.118
retrieving revision 1.119
diff -u -r1.118 -r1.119
--- include.php	19 May 2002 16:59:16 -0000	1.118
+++ include.php	12 Jun 2002 11:39:11 -0000	1.119
@@ -77,6 +77,10 @@
   'priority' => 'Priority',
   'status_name' => 'Status',
   'resolution_name' => 'Resolution',
+  'closed_in_version_name' => 'Closed in Version',
+  'to_be_closed_in_version_name' => 'To be Closed in Version',
+  'database_version' => 'Database Version',
+  'database_provider' => 'Database Provider',
   'reporter' => 'Reporter',
   'owner' => 'Owner',
   'created_date' => 'Created Date',