meter_history.php File Reference


Variables

 $bfpPage = new BmfoPage
 $strLocationDescription
lt
 Back
 $arrQueries
 $arrPages
 $query
 $result = dbx_query($rdbms, $query)
 $count = 0
 $count = $count+1

Variable Documentation

$arrPages
 

Initial value:

 array("OperationsRecord"=>"meter_data_correction.php", 
         "EstimationRecord" => "estimation_data_correction.php",
         "InstallationRecord" => "meter_installation.php")

$arrQueries
 

Initial value:

 array("InstallationRecord" =>
        "select InstallationRecordSubtype.Description as Subtype,".
        "InstallationRecord.EquipmentOID, InstallationRecord.ID, ".
        to_char("InstallationRecord.RecordDate")." as RecordDate from ".
        "InstallationRecord, InstallationRecordSubtype where ".
        "NetworkOID='".$_SESSION["FacilityID"]."' and InstallationRecord.Subtype=".
        "InstallationRecordSubtype.Subtype order by ".
        "InstallationRecord.RecordDate desc, InstallationRecord.Subtype desc",
        
        "EstimationRecord" => "select EstimationRecordSubtype.Description as Subtype,".
         "EstimationRecord.ID, ".to_char("EstimationRecord.StartDate")." as StartDate,".
         to_char("EstimationRecord.RecordDate")." as EndDate,".
         "EstimationRecord.Value, EstimationRecordStatus.Description as Status".
         " from EstimationRecord, EstimationRecordSubtype, ".
         "EstimationRecordStatus where ".
         "EstimationRecord.NetworkOID='".
         $_SESSION["FacilityID"]."' and EstimationRecord.Subtype = ".
         "EstimationRecordSubtype.Subtype and EstimationRecord.Status = ".
         "EstimationRecordStatus.CodedValue order by RecordDate desc",
         
         "OperationsRecord" => "select OperationsRecordSubtype.Description as Subtype,".
         " OperationsRecord.ID,".to_char("OperationsRecord.RecordDate").
         " as RecordDate, OperationsRecordStatus.Description as Status,".
         "OperationsRecord.Value from OperationsRecord, OperationsRecordSubtype,".
         "OperationsRecordStatus ".
         "where OperationsRecord.NetworkOID='".$_SESSION["FacilityID"]."' and ".
         "OperationsRecord.Subtype = OperationsRecordSubtype.Subtype and ".
         "OperationsRecord.Status = OperationsRecordStatus.CodedValue ".
         "order by RecordDate desc, OperationsRecord.Subtype desc")

$bfpPage = new BmfoPage
 

$count = $count+1
 

$count = 0
 

$query
 

Initial value:

 limit_offset($rdbms, $arrQueries[$_REQUEST["table"]], 
         $params['perPage'], $from-1)

$result = dbx_query($rdbms, $query)
 

$strLocationDescription
 

Initial value:

 
          $bmfometer->getLocationDescription($_SESSION["language"])

Back
 

& lt
 


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