Wymiany agregatów -
| Nr |
Typ pompy |
Nr pompy |
Typ silnika |
Nr silnika |
Data zab. |
Data wyb. |
LP [m] |
DR [mm] |
Powód |
$sqNR_EXCHANGE |
$sqPUMP_NAME |
$sqPUMP_NO |
$sqENG_NAME |
$sqENG_NO |
$sqDATE_FROM |
$sqDATE_TO |
$sqZP |
$sqDR |
$sqREASON |
";
}
?>
180)
$query="select RHD_ID,RHD_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_WORK_TIME_VAL,RHD_VM3_VAL from (select RHD_ID,RHD_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_WORK_TIME_VAL,RHD_VM3_VAL from rep_his_data_everyday where RHD_DATE>='".$_SESSION['site401demand_from']." 00:00:00' and RHD_DATE<='".$_SESSION['site401demand_to']." 23:59:59' and RHD_DRS_ID=".$_SESSION['well_details']['devID']." union select RHD_ID,RHD_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_WORK_TIME_VAL,RHD_VM3_VAL from softspm_his.rep_his_data_everyday_his where RHD_DATE>='".$_SESSION['site401demand_from']." 00:00:00' and RHD_DATE<='".$_SESSION['site401demand_to']." 23:59:59' and RHD_DRS_ID=".$_SESSION['well_details']['devID'].") tb order by RHD_DATE desc limit ".(($_GET['pgn']-1)*20).",20";
else
$query="select RHD_ID,RHD_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_WORK_TIME_VAL,RHD_VM3_VAL from rep_his_data_everyday where RHD_DATE>='".$_SESSION['site401demand_from']." 00:00:00' and RHD_DATE<='".$_SESSION['site401demand_to']." 23:59:59' and RHD_DRS_ID=".$_SESSION['well_details']['devID']." order by RHD_DATE desc limit ".(($_GET['pgn']-1)*20).",20";
*/
//$tbaName = getTableNameFrom_everyday_his($_SESSION['site401demand_to']);
//$query="select * from ".$tbaName." where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_DATE>='".$_SESSION['site401demand_from']."' && RHD_DATE<='".$_SESSION['site401demand_to']."' order by RHD_DATE desc limit ".(($_GET['pgn']-1)*20).",20";
//$query="select * from (".getQuery_everyday_his($_SESSION['site401demand_from'],$_SESSION['site401demand_to']," where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_DATE>='".$_SESSION['site401demand_from']."' && RHD_DATE<='".$_SESSION['site401demand_to']."'").") tb order by RHD_DATE desc";
$query="SELECT * FROM rep_his_data_demand WHERE RHD_DRS_ID=".$_SESSION['well_details']['devID']." AND RHD_DATE>='".$_SESSION['site401demand_from']."' AND RHD_DATE<='".$_SESSION['site401demand_to']."' ORDER BY RHD_ID DESC";
$res=null;
$wynik = mysql_query($query);
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$res[]=array(
'his_id' => $r["RHD_ID"],
'his_date' => $r["RHD_DATE"],
'his_hd' => $r["RHD_HD_VAL"],
'his_q' => round($r["RHD_Q_VAL"]/60,3),
'his_p1' => $r["RHD_P1_VAL"],
'his_p2' => $r["RHD_P2_VAL"],
'his_I' => $r["RHD_I_VAL"],
'his_U' => $r["RHD_U_VAL"],
'his_PE' => $r["RHD_PE_VAL"],
'his_cos' => $r["RHD_COS_VAL"],
'his_work_time' => $r["RHD_WORK_TIME_VAL"],
'his_Vm3' => $r["RHD_VM3_VAL"]
);
}
unset($_SESSION['site401demand_array']);
$_SESSION['site401demand_array']=$res;
}
if (count($_SESSION['site401demand_array'])>0)
{
echo"
Dane z pomiarów na żądanie [od ".$_SESSION['site401demand_from']." do ".$_SESSION['site401demand_to']."]
| Lp. |
Data |
HD [m] |
Q [m3/min] |
p1 [m] |
p2 [m] |
I [A] |
U [V] |
Pe [kW] |
cos(φ) |
Czas pracy [h] |
Ilość wody [m3] |
";
$start=($_GET['pgn']-1)*20;
$stop = $_GET['pgn']*20;
if ($stop>count($_SESSION['site401demand_array'])) $stop=count($_SESSION['site401demand_array']);
for($i=$start;$i<$stop;$i++)
{
if ($_SESSION['site401demand_array'][$i]['his_q']<=0) $_SESSION['site401demand_array'][$i]['his_q']=null;
echo"
| ".($i+1).". |
".$_SESSION['site401demand_array'][$i]['his_date']." |
".$_SESSION['site401demand_array'][$i]['his_hd']." |
".$_SESSION['site401demand_array'][$i]['his_q']." |
".$_SESSION['site401demand_array'][$i]['his_p1']." |
".$_SESSION['site401demand_array'][$i]['his_p2']." |
".$_SESSION['site401demand_array'][$i]['his_I']." |
".$_SESSION['site401demand_array'][$i]['his_U']." |
".$_SESSION['site401demand_array'][$i]['his_PE']." |
".$_SESSION['site401demand_array'][$i]['his_cos']." |
".$_SESSION['site401demand_array'][$i]['his_work_time']." |
".$_SESSION['site401demand_array'][$i]['his_Vm3']." |
";
}
if (count($_SESSION['site401demand_array'])<=0)
{
echo"
| ".$lab_Field_site404_001." |
";
}
echo"
";
?>
| Wyników: |
20)
echo pagination_grid('./?pg=site401demand', $_GET['pgn'], count($_SESSION['site401demand_array']));
?>
|
|
";
}
?>