maintenance_by_team_report.php File Reference

Variables
	$dcmPage = new DcmmsPage(_("Maintenance by Team"))
	$form = new HTML_QuickForm("QuantityForm")
	$numAdministrativeArea = $form->exportValue("administrativearea")
	$strWhere = ""
	$strQuery
	$objTable = new DbTable($dcmPage->postgis->db, $strQuery)
	$numRowCount = $objTable->getRowCount()

---

Variable Documentation

$dcmPage = new DcmmsPage(_("Maintenance by Team"))

Todo: Use PEAR DB.

$form = new HTML_QuickForm("QuantityForm")

$numAdministrativeArea = $form->exportValue("administrativearea")

Add where clause if necessary.

$numRowCount = $objTable->getRowCount()

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

$strQuery

Initial value: 'select dcmmstranslation(\''.$_SESSION['language'] .'\',team.description)as team , Workorder.ID' .' from Team, Workorder left outer join Maintenance on Maintenance.ID = Workorder.ID where (Maintenance.Status = 2) and ' ."(workorder.receiveddate between '".$form->exportValue("start_timestamp")."'" ." and '".$form->exportValue("end_timestamp")."')" ."and (team.codedvalue=maintenance.team) order by description" Create the Quantity table.

$strWhere = ""

---