DC Maintenance Management System

Update of /cvsroot/dcmms/dcmms/admin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3714/admin

Modified Files:
	analysis.php 
Log Message:
	* dcmms.nsi: production systems should not have the 
	initialize_webtest.php file
	* doc/development/dcmms_development_guide.xml: Added tip how to increase
	heap memory for jEdit
	* script/test/build.xml: Added checks for analysis.php
	* script/update_dcmms_ddl.sql:
	* script/create_dcmms_ddl.sql: Updated density calculation functions
	to use subtype; improved calculation
	* admin/analysis.php: Silenced index handling functions; Call
	density calculation functions correctly. Fixes bug #1229632
	* AUTHORS: Added Sammer
	* doc/administration/dcmms_administration_guide.xml: Mentioning Sammer,
	improved PostgreSQL and PostGIS installation instructions; updated
	requirements

Index: analysis.php
===================================================================
RCS file: /cvsroot/dcmms/dcmms/admin/analysis.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** analysis.php	13 Apr 2005 09:45:07 -0000	1.10
--- analysis.php	2 Jul 2005 06:00:36 -0000	1.11
***************
*** 96,121 ****
  if($form->validate()) {
    $strQuery = "drop index maintenance_gist;";
!   pg_query($strQuery);
    $strQuery = "drop index pressurizedmain_gist;";
!   pg_query($strQuery);
    $strQuery = "drop index gravitymain_gist;";
!   pg_query($strQuery);
    $strQuery = "create index maintenance_gist on maintenance using".
     " gist(shape GIST_GEOMETRY_OPS); vacuum analyze maintenance;";
!    pg_query($strQuery);
!    $strQuery = "create index gravitymain_gist on gravitymain using".
!    " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze gravitymain;";
!    pg_query($strQuery);
!    $strQuery = "create index pressurizedmain_gist on pressurizedmain using".
!    " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze pressurizedmain;";
!   pg_query($strQuery);
    $strQuery = "select ".$form->exportValue("analysis")."(".
!     $form->exportValue("resolution_x").",".$form->exportValue("resolution_y");
!     if ($form->exportValue("WorkorderType")!= 0){
!     $strQuery = $strQuery.",".$form->exportValue("WorkorderType").")";
!     } else {
!     $strQuery = $strQuery.")";
!     }
!   print_r($strQuery);
    $objResult = pg_query($strQuery);
    if(($objResult)&&(pg_num_rows($objResult) == 1)) {
--- 96,116 ----
  if($form->validate()) {
    $strQuery = "drop index maintenance_gist;";
!   @pg_query($strQuery);
    $strQuery = "drop index pressurizedmain_gist;";
!   @pg_query($strQuery);
    $strQuery = "drop index gravitymain_gist;";
!   @pg_query($strQuery);
    $strQuery = "create index maintenance_gist on maintenance using".
     " gist(shape GIST_GEOMETRY_OPS); vacuum analyze maintenance;";
!   @pg_query($strQuery);
!   $strQuery = "create index gravitymain_gist on gravitymain using".
!     " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze gravitymain;";
!   @pg_query($strQuery);
!   $strQuery = "create index pressurizedmain_gist on pressurizedmain using".
!     " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze pressurizedmain;";
!   @pg_query($strQuery);
    $strQuery = "select ".$form->exportValue("analysis")."(".
!     $form->exportValue("resolution_x").",".$form->exportValue("resolution_y").
!     ','.$form->exportValue("WorkorderType").")";
    $objResult = pg_query($strQuery);
    if(($objResult)&&(pg_num_rows($objResult) == 1)) {