excavation_report.php File Reference


Variables

 $dcmPage = new DcmmsPage(_("Excavation Report"))
 $form = new HTML_QuickForm("ExcavationForm")
 $strQuery
 $arrArea
 $selArea
 $selAreaFilter
 $grpArea
 $intAdministrativeArea = $arrAdministrativeArea['AdministrativeArea']
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)

Variable Documentation

$arrArea
 

Initial value:

 array_merge(array(0 => _('All Areas')), 
  $dcmPage->postgis->db->getAssoc($strQuery))

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

$form = new HTML_QuickForm("ExcavationForm")
 

Todo:
subtype HTML_QuickForm

$grpArea
 

Initial value:

 new HTML_QuickForm_Group('AdministrativeAreaGroup', 
  _('Administrative Area:'), array($selArea, $selAreaFilter))

$intAdministrativeArea = $arrAdministrativeArea['AdministrativeArea']
 

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

$selArea
 

Initial value:

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

$selAreaFilter
 

Initial value:

 new HTML_QuickForm_SelectFilter('AdministrativeAreaFilter',
  _('Administrative Area Filter:'),array(),'AdministrativeAreaGroup[AdministrativeArea]')

$strQuery
 

Initial value:

 'select Workorder.ID as WorkorderID, Workorder.LocationDescription,'.
    'MaterialSubtype.Description as Type,'.
    'Material.Unit as Quantity, MaterialSubtype.Unit as Unit from '.
    'Workorder, Maintenance, Material, MaterialSubtype '.
    'where '.
    (($intAdministrativeArea == 0)?'':("Workorder.AdministrativeArea = '".
    $intAdministrativeArea."' and ")).
    " Maintenance.CompletionDate ".
    "> '".$form->exportValue('StartDate')."' and Maintenance.CompletionDate < '".
    $form->exportValue('EndDate')."' and Workorder.ID = Maintenance.ID and ".
    'Maintenance.ID = Material.MaintenanceOID and Material.Subtype = '.
    'MaterialSubtype.Subtype and Material.Subtype > 100 order by Workorder.ID'

$strQuery
 

Initial value:

 "select CodedValue,".
  $dcmPage->postgis->localize('Name', 'AdministrativeArea').
  " from AdministrativeArea"

Generated on Sat Jul 1 21:19:25 2006 for DCMMS by  doxygen 1.4.6-NO