full_report.php File Reference

Variables
	$dcmPage = new DcmmsPage(_("Full Report"))
	$form = new HTML_QuickForm("FullReportForm")
	$strQuery
	$arrArea = $dcmPage->postgis->db->getAssoc($strQuery)
	$selArea
	$strQuery
	$arrNetwork = $dcmPage->postgis->db->getAssoc($strQuery)
	$selNetwork
	$strQuery
	$objTable = new DbTable($dcmPage->postgis->db, $strQuery)
	$arrQueries
	$arrLocalization
	$arrLocale = $arrLocalization[$strTable]

---

Variable Documentation

$arrArea = $dcmPage->postgis->db->getAssoc($strQuery)

$arrLocale = $arrLocalization[$strTable]

$arrLocalization

Initial value: array('Maintenance' => array(0, 2, 4, 5, 10), 'Staff' => array(1, 3), 'Material' => array(1, 4), 'Equipment' => array(1, 3), 'Broken Seal' => array())

$arrNetwork = $dcmPage->postgis->db->getAssoc($strQuery)

$arrQueries

Initial value: array("Maintenance" => "select Subtype as Type, Diameter1,". 'Material1,Diameter2,Material2,Cause,dcmmstranslation(\''. $_SESSION['language'].'\', Team) as Team, Depth,'. $dcmPage->postgis->formatTimestamp("StartDate"). " as StartDate, ".$dcmPage->postgis->formatTimestamp("CompletionDate"). " as CompletionDate,". "LeakLocation,Note, Status from MaintenanceView where ID=".$row[0], "Staff" => "select ID, Type, Value as Amount, Unit, CostCenter ". "from StaffView where MaintenanceOID=".$row[0], "Material" => "select ID, Type, Diameter, Value as Amount, Unit, ". "CostCenter from MaterialView where MaintenanceOID=".$row[0], "Equipment" => "select ID, Type, Value as Amount, Unit, CostCenter ". "from EquipmentView where MaintenanceOID=".$row[0], "Broken Seal" => "select ID, Reason, Responsible, SubscriberOID, ". "SerialNumber from Seal where MaintenanceOID=".$row[0] )

$dcmPage = new DcmmsPage(_("Full Report"))

Todo: Use dcmmstranslation() for WorkorderSubtype.Description.

$form = new HTML_QuickForm("FullReportForm")

$objTable = new DbTable($dcmPage->postgis->db, $strQuery)

$selArea

Initial value: new HTML_QuickForm_select("AdministrativeArea", _("Administrative Area:"), $arrArea)

$selNetwork

Initial value: new HTML_QuickForm_select("Network", _("Network Type:"), $arrNetwork)

$strQuery

Initial value: "select ID, Complainant, Subtype as Type, Telephone,". "LocationDescription, ". $dcmPage->postgis->formatTimestamp("ReceivedDate"). ' as ReceivedDate, Note, dcmmstranslation(\''.$_SESSION['language']. '\', AdministrativeArea) as AdministrativeArea,'. 'dcmmstranslation(\''.$_SESSION['language']. '\', Team) as Team, Network as NetworkType from WorkorderView where ID='.$row[0]

$strQuery

Initial value: "select 0, '[Select One]' union all select CodedValue,". "Description from NetworkDomain"

$strQuery

Initial value: "select 0, '[Select One]' union all select CodedValue,". $dcmPage->postgis->localize('Name', 'AdministrativeArea'). " from AdministrativeArea"

---