meter_installation_report.php File Reference


Variables

 $bfpPage = new BmfoPage
 $result = dbx_query($rdbms, $query)
 $params ['totalItems'] = $result->data[0][0]
 $params ['perPage'] = 10
 $pager = Pager::factory($params)
 $data = $pager->getPageData()
 $links = $pager->getLinks(_("<< Back"), _("Next >>"))
 $query
 $result = dbx_query($rdbms, $query)

Variable Documentation

$bfpPage = new BmfoPage
 

$data = $pager->getPageData()
 

$links = $pager->getLinks(_("<< Back"), _("Next >>"))
 

$pager = Pager::factory($params)
 

$params['perPage'] = 10
 

$params['totalItems'] = $result->data[0][0]
 

$query
 

Initial value:

 limit_offset($rdbms, "select InstallationRecord.NetworkOID, ".
    "InstallationRecord.EquipmentOID as SerialNumber, ".
    "InstallationRecordSubtype.Description as Type,".
    to_char("InstallationRecord.RecordDate")." as RecordDate ".
    "from InstallationRecord, InstallationRecordSubtype ".
    "where InstallationRecord.Subtype = InstallationRecordSubtype.Subtype ".
    "and InstallationRecord.NetworkOID in (select FacilityID from meter ".
    "where OperationalArea in (select OperationalArea from
    UserOperationalArea where ".
     "username = '".$_SESSION["UserName"]."'))".
    "order by InstallationRecord.NetworkOID, InstallationRecord.RecordDate,".
    "InstallationRecord.Subtype desc ",
    $params['perPage'],$from-1)

$result = dbx_query($rdbms, $query)
 

$result = dbx_query($rdbms, $query)
 


Generated on Tue Sep 26 22:29:56 2006 for BMFO by  doxygen 1.4.6-NO