meter_warehouse_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 WarehouseMeter.SerialNumber, ".
    "WarehouseMeterSubtype.Description as Type, WarehouseMeter.Manufacturer, ".
    "LifecycleStatus.Description as Status, ".
    "WarehouseMeter.NetworkOID as Location ".
    "from WarehouseMeter, WarehouseMeterSubtype, LifecycleStatus ".
    "where WarehouseMeter.LifecycleStatus = LifecycleStatus.CodedValue and ".
    "WarehouseMeter.Subtype = WarehouseMeterSubtype.Subtype and ".
    "(WarehouseMeter.NetworkOID in (select FacilityID from meter where ".
    "OperationalArea in (select OperationalArea from UserOperationalArea
    where ".
    "username = '".$_SESSION["UserName"]."')) or WarehouseMeter.NetworkOID is null)",
    $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