resource_report.php File Reference


Variables

 $dcmPage = new DcmmsPage(_('Resource Report'))
 $form = new HTML_QuickForm('ResourceReportForm')
 $strQuery
 $selArea
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)
 $strQuery
 $objTable = new DbTable($dcmPage->postgis->db, $strQuery)

Variable Documentation

$dcmPage = new DcmmsPage(_('Resource Report'))
 

$form = new HTML_QuickForm('ResourceReportForm')
 

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

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

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

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

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

$selArea
 

Initial value:

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

$strQuery
 

Initial value:

 "select sum(material.unit*materialcost.cost) as Price from 
    material,materialsubtype,workorder,materialcost where 
    workorder.id = material.maintenanceoid and
    material.subtype = materialsubtype.subtype and
    material.subtype = materialcost.subtype ".
   "and workorder.receiveddate > '".$form->exportValue('StartDate').
   "' and workorder.receiveddate < '".$form->exportValue('EndDate')."'"
Calculate cost.

$strQuery
 

Initial value:

 "select costcenter.endescription as costcenter,".
    "materialsubtype.description".
    " as type,sum(material.unit) as totalCount,materialsubtype.unit as unit ".
    "from material,costcenter,workorder, MaterialSubtype  where ".
    "material.costcenter = costcenter.costcenter and material.subtype =". 
    "materialsubtype.subtype and workorder.id = material.maintenanceoid ".
    "and workorder.receiveddate > '".$form->exportValue('StartDate').
    "' and workorder.receiveddate < '".$form->exportValue('EndDate')."'".
    " and material.subtype > 100 ".$strWhere.
    " group by costcenter.endescription, materialsubtype.description,".
    "materialsubtype.unit order by costcenter,totalcount"
Excavation information.

$strQuery
 

Initial value:

 "select costcenter.endescription as costcenter,".
    "staffsubtype.description".
    " as type,sum(staff.unit) as totalCount,staffsubtype.unit as unit from ".
    "staff,costcenter,workorder, StaffSubtype  where 
    staff.costcenter = costcenter.costcenter ".
    "and staff.subtype = staffsubtype.subtype and ".
    "workorder.id = staff.maintenanceoid ".
    "and workorder.receiveddate > '".$form->exportValue('StartDate').
    "' and workorder.receiveddate < '".$form->exportValue('EndDate')."'".$strWhere.
    " group by costcenter.endescription, staffsubtype.description,".
    "staffsubtype.unit order by costcenter,totalcount"

$strQuery
 

Initial value:

 "select costcenter.endescription as costcenter,
    equipmentsubtype.description as type
    ,sum(equipment.unit) as totalCount,equipmentsubtype.unit as unit from 
    equipment,costcenter, EquipmentSubtype,
    workorder where equipment.costcenter = costcenter.costcenter and 
    equipment.subtype = equipmentsubtype.subtype and workorder.id = 
    equipment.maintenanceoid ".
    "and workorder.receiveddate > '".$form->exportValue('StartDate').
    "' and workorder.receiveddate < '".$form->exportValue('EndDate')."'".
    $strWhere.
    " group by costcenter.endescription,
    equipmentsubtype.description,equipmentsubtype.unit order by totalcount"

$strQuery
 

Initial value:

 "select costcenter.endescription as costcenter,
    materialsubtype.description as type,diameterdomain.description as diameter,
    sum(material.unit) as totalcount, materialsubtype.unit as quantity,
    sum(material.unit)*materialcost.cost as price from 
    costcenter,materialsubtype,workorder, DiameterDomain, Material
    left outer join MaterialCost on
    MaterialCost.Subtype = Material.Subtype
    where 
    workorder.id = material.maintenanceoid and
    material.costcenter = costcenter.costcenter and 
    material.subtype = materialsubtype.subtype
    and material.diameter=diameterdomain.codedvalue ".
   "and workorder.receiveddate > '".$form->exportValue('StartDate').
   "' and workorder.receiveddate < '".$form->exportValue('EndDate').'\''.
   $strWhere. 
   " group by 
   costcenter.endescription,material.subtype,materialsubtype.description,
   diameterdomain.description,materialsubtype.unit,materialcost.cost
   order by costcenter,diameter"

$strQuery
 

Initial value:

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

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