237 lines
9.5 KiB
PHP
237 lines
9.5 KiB
PHP
<?php session_start();
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="pl">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<link rel="shortcut icon" href="../images/SoftSPM.ico">
|
|
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
|
|
<title>Wykaz pracy studni</title>
|
|
|
|
<!-- Bootstrap -->
|
|
<link href="./bootstrap.min.css" rel="stylesheet">
|
|
|
|
</head>
|
|
<body>
|
|
<script src="./jquery.min.js"></script>
|
|
|
|
<?php
|
|
date_default_timezone_set('Europe/Warsaw');
|
|
require_once("../func.php");
|
|
require_once("../dbaccess.php");
|
|
$polacz = mysql_connect($db_host, $db_user, $db_user_pass) or die ('cannot connect to db');
|
|
mysql_select_db($db_name);
|
|
mysql_query("SET NAMES utf8");
|
|
mysql_query("SET CHARACTER_SET utf8_general_ci");
|
|
?>
|
|
|
|
|
|
<?php
|
|
function cdt($inDate)
|
|
{
|
|
unset($out);
|
|
$out = (float) str_replace(array('-',' '), array('',''), $inDate);
|
|
return $out;
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
|
|
<div class="panel panel-danger">
|
|
<div class="panel-heading">
|
|
<h3 class="panel-title">Wykaz pracy studni <?php echo $_SESSION['syndis_eq_stock'];?></h3>
|
|
</div>
|
|
<div class="panel-body">
|
|
Za okres od:<b> <?php echo sqlStringValue("select min(RHD_DATE) DT from softspm_rep.rep_002_data_wrze", "DT"); ?></b> do: <b><?php echo sqlStringValue("select max(RHD_DATE) DT from softspm_rep.rep_002_data_wrze", "DT");?> </b>
|
|
</div>
|
|
<div class="panel-footer">
|
|
<a class="btn btn-default" href="#" role="button" onclick="window.print();">Drukuj <span class="glyphicon glyphicon-print" aria-hidden="true"></span></a>
|
|
<a class="btn btn-success" href="./rep_002_xls.php" target="_blank" role="button">Eksport do Excel <span class="glyphicon glyphicon-file" aria-hidden="true"></span></a>
|
|
<a class="btn btn-danger" href="./rep_002_pdf.php" target="_blank" role="button">Eksport do PDF <span class="glyphicon glyphicon-file" aria-hidden="true"></span></a>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
|
|
<table class="table table-bordered">
|
|
<thead>
|
|
<tr>
|
|
<th>Lp.</th>
|
|
<th>Studnia</th>
|
|
<th>Agregat pompowy <br/> [pompa / silnik]</th>
|
|
<th>Moc silnika <br/> [kW]</th>
|
|
<th>Czas pracy <br/> [h]</th>
|
|
<th>Ilość wypompowanej wody <br/> [m<sup>3</sup>]</th>
|
|
<th>Wydajność średnia <br/> [m<sup>3</sup>/min]</th>
|
|
<th>Zwierciadło statyczne <br/> [m]</th>
|
|
<th>Zwierciadło dynamiczne <br/> [m]</th>
|
|
<th>Temperatura wody <br/> [<sup>o</sup>C]</th>
|
|
<th>Stężenie chlorków</th>
|
|
<th>Kategoria</th>
|
|
|
|
</tr>
|
|
</thead>
|
|
|
|
<?php
|
|
unset($rep002Array);
|
|
$rep002Array = sqlGetResAsArray("select DRS_ID,WLL_ID,WLL_NAME,WLL_BARIERA,WLL_CAT_DIC_ID,WLE_PUMP_NAME,WLE_PUMP_NO,WLE_ENG_NAME,WLE_ENG_NO,WLE_DATE_FROM,WLE_DATE_TO,DRS_DEPARTMENT from seg_wells_exchanged,seg_wells left join seg_dev_resources on DRS_DEV_ID=WLL_ID where WLE_WLL_ID=WLL_ID and DRS_DEV_TYPE=12 and (WLE_DATE_TO is null or WLE_DATE_TO>'2016-09-01') and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
|
|
|
|
|
|
//print_r($rep001Array);
|
|
?>
|
|
|
|
<?php
|
|
|
|
unset($res);
|
|
unset($_SESSION['rap002_array']);
|
|
|
|
$bariera = "";
|
|
$licznik_bariera=0;
|
|
$bariera_woda=0;
|
|
$calosc_woda=0;
|
|
|
|
for($i=0;$i<count($rep002Array);$i++)
|
|
{
|
|
if ($bariera!=$rep002Array[$i]['WLL_BARIERA'])
|
|
{
|
|
if ($licznik_bariera>0)
|
|
{
|
|
echo"<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
|
|
<td style='font-weight: bolder;' colspan='5'>Razem bariera: ".$bariera."</td>
|
|
<td style='font-weight: bolder;'>".round(getFloatValue($bariera_woda),0)."</td>
|
|
<td colspan='6'></td>
|
|
</tr>";
|
|
echo"<tr><td colspan='12'></td></tr>";
|
|
$bariera_woda=0;
|
|
}
|
|
|
|
echo"<tr style='font-weight: bolder; background-color: #DCDCDC;'><td colspan='14'>Bariera: ".$rep002Array[$i]['WLL_BARIERA']."</td></tr>";
|
|
$bariera=$rep002Array[$i]['WLL_BARIERA'];
|
|
$licznik_bariera++;
|
|
}
|
|
|
|
unset($mocSilnika);
|
|
$mocSilnika = sqlStringValue("select ENG_POWER from seg_engines,seg_dev_resources where DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 and ENG_NAME='".$rep002Array[$i]['WLE_ENG_NAME']."' and DRS_SN_NUMBER='".$rep002Array[$i]['WLE_ENG_NO']."'", "ENG_POWER");
|
|
|
|
//czas pracy
|
|
unset($minTime);unset($maxTime);unset($valTime);unset($finDate); unset($valTime);unset($valHst0);unset($valHdTw);unset($valClor); unset($valVm3); unset($minVpup); unset($maxVpup);
|
|
|
|
if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8)
|
|
$finDate = $rep002Array[$i]['WLE_DATE_TO'];
|
|
else $finDate = '2016-09-30 23:59:59';
|
|
|
|
// sprawdza dla zwierciadła statyczniego warunek na daty
|
|
unset($hst0Date);
|
|
if (cdt($rep002Array[$i]['WLE_DATE_FROM'])>cdt('2016-10-01 00:00:00'))
|
|
$hst0Date = $rep002Array[$i]['WLE_DATE_FROM'];
|
|
else $hst0Date = '2016-10-01 00:00:00';
|
|
|
|
|
|
|
|
if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8)
|
|
{
|
|
//)
|
|
$valTmVm = sqlGetResAsArray("select (max(RHD_WORK_TIME_VAL) - min(RHD_WORK_TIME_VAL)) WRTM, (max(RHD_VM3_VAL) - min(RHD_VM3_VAL)) VM3 from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']);
|
|
$valHst0 = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$hst0Date."' and DRD_AUDIT_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')");
|
|
$valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.rep_002_data_wrze where RHD_ID=(select MAX(RHD_ID) from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_HD_VAL>0 and RHD_WTEMP_VAL>0)");
|
|
$valClor = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=719 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')");
|
|
|
|
$valTime = $valTmVm[0]['WRTM'];
|
|
$valVm3 = $valTmVm[0]['VM3'];
|
|
|
|
}
|
|
else
|
|
{
|
|
$valTmVm = sqlGetResAsArray("select (max(RHD_WORK_TIME_VAL) - min(RHD_WORK_TIME_VAL)) WRTM, (max(RHD_VM3_VAL) - min(RHD_VM3_VAL)) VM3 from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']);
|
|
$valHst0 = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$hst0Date."')");
|
|
$valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.rep_002_data_wrze where RHD_ID=(select MAX(RHD_ID) from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_HD_VAL>0 and RHD_WTEMP_VAL>0)");
|
|
$valClor = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=719 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."')");
|
|
|
|
$valTime = $valTmVm[0]['WRTM'];
|
|
$valVm3 = $valTmVm[0]['VM3'];
|
|
}
|
|
|
|
|
|
|
|
unset($qSred);
|
|
if ($valTime>0)
|
|
$qSred = (float) ($valVm3/$valTime);
|
|
|
|
if ($valClor[0]['DRD_VALUE']>0) $valClor=$valClor[0]['DRD_VALUE'];
|
|
else $valClor="";
|
|
|
|
|
|
echo"
|
|
<tr>
|
|
<td>".($i+1).".</td>
|
|
<td>".$rep002Array[$i]['WLL_NAME']."</td>
|
|
<td>".$rep002Array[$i]['WLE_PUMP_NAME']." / ".$rep002Array[$i]['WLE_ENG_NAME']."</td>
|
|
|
|
<td>".round(getFloatValue($mocSilnika),1)."</td>
|
|
<td>".round(getFloatValue($valTime),0)."</td>
|
|
<td>".round(getFloatValue($valVm3),0)."</td>
|
|
<td>".round($qSred/60,3)."</td>
|
|
<td>".$valHst0[0]['DRD_VALUE']."</td>
|
|
<td>".$valHdTw[0]['RHD_HD_VAL']."</td>
|
|
<td>".$valHdTw[0]['RHD_WTEMP_VAL']."</td>
|
|
<td>".$valClor."</td>
|
|
<td>".setDicName($rep002Array[$i]['WLL_CAT_DIC_ID'])."</td>
|
|
|
|
</tr>
|
|
";
|
|
|
|
$res[]=array(
|
|
'id' => $rep002Array[$i]['DRS_ID'],
|
|
'bariera' => $rep002Array[$i]['WLL_BARIERA'],
|
|
'studnia' => $rep002Array[$i]['WLL_NAME'],
|
|
'agregat' => $rep002Array[$i]['WLE_PUMP_NAME']." / ".$rep002Array[$i]['WLE_ENG_NAME'],
|
|
'moc' => round(getFloatValue($mocSilnika),1),
|
|
'czas_pracy' => round(getFloatValue($valTime),0),
|
|
'il_wody' => getFloatValue($valVm3),
|
|
'srednia_q' => round($qSred/60,3),
|
|
'hst0' => $valHst0[0]['DRD_VALUE'],
|
|
'hd' => $valHdTw[0]['RHD_HD_VAL'],
|
|
'temp_wody' => $valHdTw[0]['RHD_WTEMP_VAL'],
|
|
'chlorki' => $valClor
|
|
);
|
|
|
|
|
|
|
|
$bariera_woda+= (float) $valVm3;
|
|
$calosc_woda += (float) $valVm3;
|
|
}
|
|
|
|
unset($_SESSION['rap002_array']);
|
|
$_SESSION['rap002_array']=$res;
|
|
|
|
echo"<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
|
|
<td style='font-weight: bolder;' colspan='5'>Razem bariera: ".$bariera."</td>
|
|
<td style='font-weight: bolder;'>".round(getFloatValue($bariera_woda),0)."</td>
|
|
<td colspan='6'></td>
|
|
</tr>";
|
|
|
|
|
|
echo"<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
|
|
<td style='font-weight: bolder;' colspan='5'>Razem wszystkie studnie:</td>
|
|
<td style='font-weight: bolder;'>".round(getFloatValue($calosc_woda),0)."</td>
|
|
<td colspan='6'></td>
|
|
</tr>";
|
|
|
|
|
|
?>
|
|
</table>
|
|
|
|
|
|
<?php
|
|
mysql_close($polacz);
|
|
|
|
?>
|
|
|
|
<script src="./bootstrap.min.js"></script>
|
|
</body>
|
|
</html>
|