Wymiany agregatów -
| Nr |
Typ pompy |
Nr pompy |
Typ silnika |
Nr silnika |
Data zab. |
Data wyb. |
LS [m] |
DR [mm] |
Powód |
$sqNR_EXCHANGE |
$sqPUMP_NAME |
$sqPUMP_NO |
$sqENG_NAME |
$sqENG_NO |
$sqDATE_FROM |
$sqDATE_TO |
$sqZP |
$sqDR |
$sqREASON |
";
}
?>
6) $query="select RHD_DATE,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 from rep_his_data_everyday where RHD_DATE>='".$_POST['inDateFrom']." 00:00:00' and RHD_DATE<='".$_POST['inDateTo']." 23:59:59' and RHD_DRS_ID=".$_SESSION['well_details']['devID']." order by RHD_DATE desc";
else $query="select RHD_DATE,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 from rep_his_data_everyday where RHD_DATE>='".$_POST['inDateFrom']." 00:00:00' and RHD_DATE<='".$_SESSION['site401ahis_to']." 23:59:59' and RHD_DRS_ID=".$_SESSION['well_details']['devID']." order by RHD_DATE desc";
$res=null;
$wynik = mysql_query($query);
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$res[]=array(
'his_date' => $r["RHD_DATE"],
'his_hst' => $r["RHD_HST_VAL"],
'his_hd' => $r["RHD_HD_VAL"],
'his_q' => round($r["RHD_Q_VAL"]/60,2),
'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"]
);
}
unset($_SESSION['site401ahis_array']);
$_SESSION['site401ahis_array']=$res;
}
if (!empty($_SESSION['site401ahis_array']))
{
echo"
Dane historyczne [od ".$_SESSION['site401ahis_from']." do ".$_SESSION['site401ahis_to']."]
| Lp. |
Data |
HST [m] |
HD [m] |
Q [m3/min] |
p1 [m] |
p2 [m] |
I [A] |
U [V] |
Pe [kW] |
cos(φ) |
Czas pracy [h] |
";
$start=($_GET['pgn']-1)*20;
$stop = $_GET['pgn']*20;
if ($stop>count($_SESSION['site401ahis_array'])) $stop=count($_SESSION['site401ahis_array']);
for($i=$start;$i<$stop;$i++)
{
echo"
| ".($i+1).". |
".$_SESSION['site401ahis_array'][$i]['his_date']." |
".$_SESSION['site401ahis_array'][$i]['his_hst']." |
".$_SESSION['site401ahis_array'][$i]['his_hd']." |
".$_SESSION['site401ahis_array'][$i]['his_q']." |
".$_SESSION['site401ahis_array'][$i]['his_p1']." |
".$_SESSION['site401ahis_array'][$i]['his_p2']." |
".$_SESSION['site401ahis_array'][$i]['his_I']." |
".$_SESSION['site401ahis_array'][$i]['his_U']." |
".$_SESSION['site401ahis_array'][$i]['his_PE']." |
".$_SESSION['site401ahis_array'][$i]['his_cos']." |
".$_SESSION['site401ahis_array'][$i]['his_work_time']." |
";
}
echo"
";
?>
| Wyników: |
20)
echo pagination_grid('?pg=site401ahis', $_GET['pgn'], count($_SESSION['site401ahis_array']));
?>
|
|
";
}
?>