250 lines
11 KiB
PHP
250 lines
11 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site401']))
|
|
{
|
|
?>
|
|
<script>
|
|
$(function() {$("#data_01").datepicker({changeMonth: true,changeYear: true});});
|
|
$(function() {$("#data_02").datepicker({changeMonth: true,changeYear: true});});
|
|
</script>
|
|
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn'])
|
|
{
|
|
$_GET['pgn']=1;
|
|
//delSearchSessionData();
|
|
}
|
|
?>
|
|
|
|
<?php
|
|
// pamięta z na jaką stronę ma przenieść, klikając - Cofnij
|
|
if (!empty($_GET['site'])) $_SESSION['site401ahis_site']=$_GET['site'];
|
|
?>
|
|
|
|
|
|
<?php
|
|
// wybieranie dat z poszczególnych agregatów
|
|
if (!empty($_GET['df']))
|
|
{
|
|
$_SESSION['site401ahis_from'] = $_GET['df'];
|
|
if (strlen($_GET['dt'])>0) $_SESSION['site401ahis_to']=$_GET['dt'];
|
|
else $_SESSION['site401ahis_to']=date('Y-m-d');
|
|
}
|
|
|
|
|
|
if (empty($_POST['inDateFrom']) && empty($_SESSION['site401ahis_from'])) $_SESSION['site401ahis_from'] = date('Y-m')."-01";
|
|
else if (!empty($_POST['inDateFrom'])) $_SESSION['site401ahis_from']=$_POST['inDateFrom'];
|
|
|
|
if (empty($_POST['inDateTo']) && empty($_SESSION['site401ahis_to'])) $_SESSION['site401ahis_to'] = date('Y-m-d');
|
|
else if (!empty($_POST['inDateTo'])) $_SESSION['site401ahis_to']=$_POST['inDateTo'];
|
|
|
|
if ($_POST['sub_search']=='Pokaż' || !empty($_GET['df']))
|
|
echo"<div id='loader-wrapper'><div id='loader'></div></div>";
|
|
|
|
?>
|
|
|
|
<form action="?pg=site401ahis&pgn=1" method="post">
|
|
<div class="tag100">
|
|
<table>
|
|
<tr>
|
|
<td>Wyświetl dane za okres od:</td>
|
|
<td style="width: 5px;"></td>
|
|
<td><INPUT STYLE='text-align: right' TYPE='TEXT' id='data_01' NAME='inDateFrom' value='<?php echo $_SESSION['site401ahis_from']; ?>' SIZE='10'></td>
|
|
<td style="width: 15px;"></td>
|
|
<td>do:</td>
|
|
<td style="width: 5px;"></td>
|
|
<td><INPUT STYLE='text-align: right' TYPE='TEXT' id='data_02' NAME='inDateTo' value='<?php echo $_SESSION['site401ahis_to']; ?>' SIZE='10'></td>
|
|
<td style="width: 20px;"></td>
|
|
<td><input type="submit" name="sub_search" value="Pokaż" class="btn btn-default btn-sm" onclick="makeRequest('?pg=site401ahis')"></td>
|
|
</tr>
|
|
<tr><td> </td></tr>
|
|
</table>
|
|
</div>
|
|
</form>
|
|
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag">Wymiany agregatów - <?php echo $_SESSION['well_details']['wellName']; ?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Nr</TD>
|
|
<TD class="label">Typ pompy</TD>
|
|
<TD class="label">Nr pompy</TD>
|
|
<TD class="label">Typ silnika</TD>
|
|
<TD class="label">Nr silnika</TD>
|
|
<TD class="label">Data zab.</TD>
|
|
<TD class="label">Data wyb.</TD>
|
|
<TD class="label">L<sub>S</sub> [m]</TD>
|
|
<TD class="label">D<sub>R</sub> [mm]</TD>
|
|
<TD class="label">Powód</TD>
|
|
</TR>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
$wynik = mysql_query("select WLE_ID,WLE_NR_EXCHANGE,WLE_PUMP_NAME,WLE_PUMP_NO,WLE_ENG_NAME,WLE_ENG_NO,WLE_DATE_FROM,WLE_DATE_TO,WLE_ZP,WLE_DR,WLE_REASON from seg_wells_exchanged where WLE_WLL_ID=".$_SESSION['well_details']['wellID']." order by WLE_NR_EXCHANGE desc ");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sqID = $r["WLE_ID"];
|
|
$sqNR_EXCHANGE = $r["WLE_NR_EXCHANGE"];
|
|
$sqPUMP_NAME = $r["WLE_PUMP_NAME"];
|
|
$sqPUMP_NO = $r["WLE_PUMP_NO"];
|
|
$sqENG_NAME = $r["WLE_ENG_NAME"];
|
|
$sqENG_NO = $r["WLE_ENG_NO"];
|
|
$sqDATE_FROM = $r["WLE_DATE_FROM"];
|
|
$sqDATE_TO = $r["WLE_DATE_TO"];
|
|
$sqZP = $r["WLE_ZP"];
|
|
$sqDR = $r["WLE_DR"];
|
|
$sqREASON = $r["WLE_REASON"];
|
|
|
|
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site401ahis&df=".substr($sqDATE_FROM,0,10)."&dt=".substr($sqDATE_TO,0,10)."'; makeRequest('?pg=site401ahis');".chr(34).">
|
|
<TD class='field_left'>$sqNR_EXCHANGE</TD>
|
|
<TD class='field_left'>$sqPUMP_NAME</TD>
|
|
<TD class='field_left'>$sqPUMP_NO</TD>
|
|
<TD class='field_left'>$sqENG_NAME</TD>
|
|
<TD class='field_left'>$sqENG_NO</TD>
|
|
<TD class='field_left'>$sqDATE_FROM</TD>
|
|
<TD class='field_left'>$sqDATE_TO</TD>
|
|
<TD class='field_left'>$sqZP</TD>
|
|
<TD class='field_left'>$sqDR</TD>
|
|
<TD class='field_left'>$sqREASON</TD>
|
|
</TR>
|
|
|
|
|
|
";
|
|
|
|
|
|
}
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<?php
|
|
|
|
if ($_POST['sub_search']=='Pokaż' || !empty($_GET['df']))
|
|
{
|
|
if (strlen($_POST['inDateTo'])>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"
|
|
<div class='head_tag'>Dane historyczne [od ".$_SESSION['site401ahis_from']." do ".$_SESSION['site401ahis_to']."]</div>
|
|
<div class='tag'>
|
|
<table WIDTH='100%' class='tag'>
|
|
<TR>
|
|
<TD class='label'>Lp.</TD>
|
|
<TD class='label'>Data</TD>
|
|
<TD class='label'>H<sub>ST</sub> [m]</TD>
|
|
<TD class='label'>H<sub>D</sub> [m]</TD>
|
|
<TD class='label'>Q [m<sup>3</sup>/min] </TD>
|
|
<TD class='label'>p<sub>1</sub> [m]</TD>
|
|
<TD class='label'>p<sub>2</sub> [m]</TD>
|
|
<TD class='label'>I [A]</TD>
|
|
<TD class='label'>U [V]</TD>
|
|
<TD class='label'>P<sub>e</sub> [kW]</TD>
|
|
<TD class='label'>cos(φ)</TD>
|
|
<TD class='label'>Czas pracy [h]</TD>
|
|
</TR>";
|
|
|
|
$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"
|
|
<tr>
|
|
<TD class='field_left'>".($i+1).".</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_date']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_hst']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_hd']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_q']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_p1']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_p2']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_I']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_U']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_PE']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_cos']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401ahis_array'][$i]['his_work_time']."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
echo"
|
|
</table>";
|
|
?>
|
|
|
|
<table style="width:100%; background-color: #f5f5f5">
|
|
<tr>
|
|
<td style="width: 25%; text-align: left;"><span class="resume">Wyników: <?php echo count($_SESSION['site401ahis_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site401ahis_array'])>20)
|
|
echo pagination_grid('?pg=site401ahis', $_GET['pgn'], count($_SESSION['site401ahis_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
<a href="./export/site401ahis_xls.php" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site401ahis_pdf.php" title="Export do PDF"><img src="./images/pdf_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site401ahis_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
|
|
<?php
|
|
echo"
|
|
</div>
|
|
";
|
|
}
|
|
?>
|
|
</div>
|
|
|
|
<div class="tag100">
|
|
<div class="tag_buttons">
|
|
<a href='?pg=<?php echo $_SESSION['site401ahis_site']; ?>&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class="btn btn-info btn-sm" TYPE='BUTTON' VALUE='Powrót'></A>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|