analysis.php File Reference

Variables
	$dcmPage = new DcmmsAdminPage(_("Analysis"))
	$arrAnalysisTypes
	$arrAnalysisTables
	$strQuery
	$Result = pg_query($strQuery)
	$count = pg_num_rows($Result)
	$arrWorkorderSubtype [$row[0]] = $row[1]
	$form = new HTML_QuickForm("AnalysisForm")
	$selAnalysis
	$selWorkorderType
	$strQuery = "drop index pressurizedmain_gist;"
	$strQuery = "drop index gravitymain_gist;"
	$strQuery
	$strQuery
	$strQuery
	$strQuery
	$objResult = pg_query($strQuery)

---

Variable Documentation

$arrAnalysisTables

Initial value: array( "calculateMaintenanceDensity" => "MaintenanceDensity", "calculatePerPipeDensity" => "PerPipeDensity", "calculatePerConnectionDensity" => "PerConnectionDensity")

$arrAnalysisTypes

Initial value: array( "calculateMaintenanceDensity" => _("Maintenance Density"), "calculatePerPipeDensity" => _("Per-pipe Density"), "calculatePerConnectionDensity" => _("Per-connection Density"))

$arrWorkorderSubtype[$row[0]] = $row[1]

$count = pg_num_rows($Result)

$dcmPage = new DcmmsAdminPage(_("Analysis"))

Todo: use PEAR DB

$form = new HTML_QuickForm("AnalysisForm")

$objResult = pg_query($strQuery)

$Result = pg_query($strQuery)

$selAnalysis

Initial value: new HTML_QuickForm_select("analysis", _("Type:"), $arrAnalysisTypes)

$selWorkorderType

Initial value: new HTML_QuickForm_select("WorkorderType", _(" Workorder Type:"), $arrWorkorderSubtype)

$strQuery

Initial value: "select ".$form->exportValue("analysis")."(". $form->exportValue("resolution_x").",".$form->exportValue("resolution_y"). ','.$form->exportValue("WorkorderType").")"

$strQuery

Initial value: "create index pressurizedmain_gist on pressurizedmain using". " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze pressurizedmain;"

$strQuery

Initial value: "create index gravitymain_gist on gravitymain using". " gist(the_geom GIST_GEOMETRY_OPS); vacuum analyze gravitymain;"

$strQuery

Initial value: "create index maintenance_gist on maintenance using". " gist(shape GIST_GEOMETRY_OPS); vacuum analyze maintenance;"

$strQuery = "drop index gravitymain_gist;"

$strQuery = "drop index pressurizedmain_gist;"

$strQuery

Initial value: 'select 0, \'[Select One]\' union all select subtype, dcmmstranslation(\''.$_SESSION['language'].'\',description) from workordersubtype'

---