softspm/kopalnia_2014
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
kopalnia_2014/reports/ajax_gen_reports.php
T
debian 6ed3153f36 Initial commit
2026-09-03 11:24:19 +02:00

3786 lines
170 KiB
PHP
Raw Permalink Blame History

<?php session_start();?>
<?php
require_once'../func.php';
require_once'../dbaccess.php';
$con = 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");
function cdt($inDate)
{
unset($out);
$out = (float) str_replace(array('-',' ',':'), array('','',''), $inDate);
return $out;
}
function quarter($dateIn, $tbName)
{
unset($outParam); unset($fix);
if (substr($dateIn, 0,4)!=date('Y'))
{
// jeśli data jest sprzed 2014 roku
if (substr($dateIn, 0,4)<2014)
$dateIn = str_replace(substr($dateIn, 0,4), 2014, $dateIn);
if (substr($dateIn, 5,2)=='01' || substr($dateIn, 5,2)=='02' || substr($dateIn, 5,2)=='03') $fix='q1';
elseif (substr($dateIn, 5,2)=='04' || substr($dateIn, 5,2)=='05' || substr($dateIn, 5,2)=='06') $fix='q2';
elseif (substr($dateIn, 5,2)=='07' || substr($dateIn, 5,2)=='08' || substr($dateIn, 5,2)=='09') $fix='q3';
elseif (substr($dateIn, 5,2)=='10' || substr($dateIn, 5,2)=='11' || substr($dateIn, 5,2)=='12') $fix='q4';
$outParam = "softspm_his.".$tbName."_".substr($dateIn, 0,4)."_".$fix;
}
else
$outParam = $tbName;
return $outParam;
}
?>
<?php
// Raport nr 2
// ==================================================================================================================================
if ($_POST['post_action']=='rep002' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_dt_from']) && !empty($_POST['post_dt_to']))
{
$hst0startDate = $_POST['post_dt_from'].' 00:00:00';
$maxDate = sqlStringValue("select CONCAT(max(AVG_DATE),' 23:59:59') AVG_DATE from softspm_rep.rep_002_avg_efficiency", "AVG_DATE");
if (cdt($_POST['post_dt_to'])>=cdt($maxDate))
$dateTo = $maxDate;
else
$dateTo = $_POST['post_dt_to'];
echo'
<h3>Okres rozliczeniowy od: <i style="color: #B22222;">'.$_POST['post_dt_from'].'</i> do: <i style="color: #B22222;">'.$dateTo.'</i></h3>
<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/> [godz:min]</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>
';
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>='".$_POST['post_dt_from']."') and WLE_DATE_FROM<='".$dateTo."' and DRS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
//$rep002Array = sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' and WLE_DATE_FROM<='".$dateTo."' and (WLE_DATE_TO>='".$_POST['post_dt_from']."' or WLE_DATE_TO is null) group by WLL_BARIERA,WLL_NAME order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
unset($isTransmisionArray);
$isTransmisionArray[]=0;
$wynik = mysql_query("select SQD_DRS_ID from softspm_rep.syndis_quality_data where SQD_FLG_Q<>'CORRECT'");
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$isTransmisionArray[]=$r["SQD_DRS_ID"];
}
unset($res);
unset($_SESSION['rap002_array']);
$bariera = "";
$licznik_bariera=0;
$bariera_woda=0;
$calosc_woda=0;
unset($isTransmisionBreak); $isTransmisionBreak=false;
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: #F4F4F4;'><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($valHd);unset($valTw);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 = $dateTo;
// sprawdza dla zwierciadła statyczniego warunek na daty
unset($hst0Date);
if (cdt($rep002Array[$i]['WLE_DATE_FROM'])>cdt($_POST['post_dt_from']))
$hst0Date = $rep002Array[$i]['WLE_DATE_FROM'];
else {
$hst0Date = $_POST['post_dt_from'];
//2016-12-02
$hst0startDate = $_POST['post_dt_from'];
}
unset($isTransmisionColor); $isTransmisionColor="";
if (array_search($rep002Array[$i]['DRS_ID'],$isTransmisionArray)>0)
{
$isTransmisionColor="style='background-color: #ffff00;'";
$isTransmisionBreak=true;
}
if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8)
{
//sprawdza, czy wybudowa nie jest starsza od daty końcowej.
if (cdt($rep002Array[$i]['WLE_DATE_TO'])>=cdt($dateTo))
$rep002Array[$i]['WLE_DATE_TO'] = $dateTo;
//2016-12-15
$newTime=0;
//$newTime=liczenie_czasu_mc($rep002Array[$i]['DRS_ID'], $hst0Date, $rep002Array[$i]['WLE_DATE_TO']);
$newTime=fCzas($rep002Array[$i]['DRS_ID'], $hst0Date, $rep002Array[$i]['WLE_DATE_TO']);
$newWater=0;
if($newTime>0)
{
//$newWater=sqlStringValue("select AVG(RHD_Q_VAL) RHD_Q_VAL from softspm_rep.".$tbaName." where RHD_Q_VAL>0 and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_DATE>='".$hst0Date."' and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."'", "RHD_Q_VAL");
//if (empty($newWater) || $newWater<=0)
// $newWater=sqlStringValue("select RHD_Q_VAL from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_Q_VAL>0 and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "RHD_Q_VAL");
$newWater=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE>=SUBSTRING('".$hst0Date."',1,10) and AVG_DATE<=SUBSTRING('".$rep002Array[$i]['WLE_DATE_TO']."',1,10)", "AVG_Q_VAL");
//$valHd=sqlStringValue("select DMM_HD_VAL from softspm_rep.rep_002_avg_dyn_mirror where DMM_ID=(select max(DMM_ID) from softspm_rep.rep_002_avg_dyn_mirror where DMM_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DMM_DATE>='".$hst0startDate."' and DMM_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "DMM_HD_VAL");
$valHd=sqlStringValue("select DMM_HD_VAL from softspm_rep.rep_002_avg_dyn_mirror where DMM_ID=(select max(DMM_ID) from softspm_rep.rep_002_avg_dyn_mirror where DMM_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DMM_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "DMM_HD_VAL");
$valTw=sqlStringValue("select WTP_WT_VAL from softspm_rep.rep_002_avg_water_temp where WTP_ID=(select max(WTP_ID) from softspm_rep.rep_002_avg_water_temp where WTP_DRS_ID=".$rep002Array[$i]['DRS_ID']." and WTP_DATE>='".$hst0startDate."' and WTP_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "WTP_WT_VAL");
$valClor=sqlStringValue("select CLO_CLO_VAL from softspm_rep.rep_002_avg_chlorine where CLO_ID=(select max(CLO_ID) from softspm_rep.rep_002_avg_chlorine where CLO_DRS_ID=".$rep002Array[$i]['DRS_ID']." and CLO_DATE>='".$hst0startDate."' and CLO_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "CLO_CLO_VAL");
if ($valHd>0) $valHd = round($valHd,1);
}
// $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']."')");
//2016-12-02 ($hst0startDate)
//$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>='".$hst0startDate."' and DRD_AUDIT_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')");
$valHst0=sqlStringValue("select MIR_HST_VAL from softspm_rep.rep_002_avg_mirror where MIR_ID=(select max(MIR_ID) from softspm_rep.rep_002_avg_mirror where MIR_DRS_ID=".$rep002Array[$i]['DRS_ID']." and MIR_DATE>='".$hst0startDate."' and MIR_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')", "MIR_HST_VAL");
if ($valHst0>0) $valHst0 = round($valHst0,1);
/*
$valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.".$tbaName." where RHD_ID=(select MAX(RHD_ID) from softspm_rep.".$tbaName." 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)");
if (empty($valHdTw[0]['RHD_WTEMP_VAL']) || $valHdTw[0]['RHD_WTEMP_VAL']<=0)
{
unset($valTw);
$valTw = sqlGetResAsArray("select RHD_WTEMP_VAL from softspm_rep.".$tbaName." where RHD_ID=(select MAX(RHD_ID) from softspm_rep.".$tbaName." 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_WTEMP_VAL>0)");
$valHdTw[0]['RHD_WTEMP_VAL'] = $valTw[0]['RHD_WTEMP_VAL'];
}
*/
// $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']."')");
}
else
{
//2016-12-15
$newTime=0;
//$newTime=liczenie_czasu_mc($rep002Array[$i]['DRS_ID'], $hst0Date, $dateTo);
$newTime=fCzas($rep002Array[$i]['DRS_ID'], $hst0Date, $dateTo);
$newWater=0;
if($newTime>0)
{
//$newWater=sqlStringValue("select AVG(RHD_Q_VAL) RHD_Q_VAL from softspm_rep.".$tbaName." where RHD_Q_VAL>0 and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_DATE>='".$hst0Date."' and RHD_DATE<='".$dateTo."'", "RHD_Q_VAL");
//if (empty($newWater) || $newWater<=0)
// $newWater=sqlStringValue("select RHD_Q_VAL from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_Q_VAL>0 and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_DATE<='".$dateTo."')", "RHD_Q_VAL");
$newWater=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE>=SUBSTRING('".$hst0Date."',1,10) and AVG_DATE<=SUBSTRING('".$dateTo."',1,10)", "AVG_Q_VAL");
//$valHd=sqlStringValue("select DMM_HD_VAL from softspm_rep.rep_002_avg_dyn_mirror where DMM_ID=(select max(DMM_ID) from softspm_rep.rep_002_avg_dyn_mirror where DMM_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DMM_DATE>='".$hst0startDate."' and DMM_DATE<='".$dateTo."')", "DMM_HD_VAL");
$valHd=sqlStringValue("select DMM_HD_VAL from softspm_rep.rep_002_avg_dyn_mirror where DMM_ID=(select max(DMM_ID) from softspm_rep.rep_002_avg_dyn_mirror where DMM_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DMM_DATE<='".$dateTo."')", "DMM_HD_VAL");
$valTw=sqlStringValue("select WTP_WT_VAL from softspm_rep.rep_002_avg_water_temp where WTP_ID=(select max(WTP_ID) from softspm_rep.rep_002_avg_water_temp where WTP_DRS_ID=".$rep002Array[$i]['DRS_ID']." and WTP_DATE>='".$hst0startDate."' and WTP_DATE<='".$dateTo."')", "WTP_WT_VAL");
$valClor=sqlStringValue("select CLO_CLO_VAL from softspm_rep.rep_002_avg_chlorine where CLO_ID=(select max(CLO_ID) from softspm_rep.rep_002_avg_chlorine where CLO_DRS_ID=".$rep002Array[$i]['DRS_ID']." and CLO_DATE>='".$hst0startDate."' and CLO_DATE<='".$dateTo."')", "CLO_CLO_VAL");
if ($valHd>0) $valHd = round($valHd,1);
}
// $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<='".$dateTo."')");
//2016-12-02 ($hst0startDate)
//$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>='".$hst0startDate."' and DRD_AUDIT_DATE<='".$dateTo."')");
$valHst0=sqlStringValue("select MIR_HST_VAL from softspm_rep.rep_002_avg_mirror where MIR_ID=(select max(MIR_ID) from softspm_rep.rep_002_avg_mirror where MIR_DRS_ID=".$rep002Array[$i]['DRS_ID']." and MIR_DATE>='".$hst0startDate."' and MIR_DATE<='".$dateTo."')", "MIR_HST_VAL");
if ($valHst0>0) $valHst0 = round($valHst0,1);
/*
$valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.".$tbaName." where RHD_ID=(select MAX(RHD_ID) from softspm_rep.".$tbaName." where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$dateTo."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_HD_VAL>0)");
if (empty($valHdTw[0]['RHD_WTEMP_VAL']) || $valHdTw[0]['RHD_WTEMP_VAL']<=0)
{
unset($valTw);
$valTw = sqlGetResAsArray("select RHD_WTEMP_VAL from softspm_rep.".$tbaName." where RHD_ID=(select MAX(RHD_ID) from softspm_rep.".$tbaName." where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$dateTo."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_WTEMP_VAL>0)");
$valHdTw[0]['RHD_WTEMP_VAL'] = $valTw[0]['RHD_WTEMP_VAL'];
}
*/
//$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<='".$dateTo."')");
}
//$valTime = (float) round(($maxTime - $minTime)/3600,2);
//$valVm3 = (float) ($maxVpup - $minVpup);
//unset($qSred);
//if ($valTime>0)
//$qSred = (float) round(($valVm3/$valTime),3);
unset($qSred);
if ($newTime>0)
{
$valVm3 = (float) round(($newTime/3600)*$newWater,3);
$valVm3 = round($valVm3,0);
}
//2021-10-03
// oblicza różnice 2 dat
$roznica = floor(abs((strtotime($dateTo) - strtotime($hst0Date)))/86400);
//2022-08-25
// poprawka na studnie, które kończą/są wybodowywane w ciągu okresy rozliczeniowego
if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8 && (strtotime($dateTo)-strtotime($rep002Array[$i]['WLE_DATE_TO']))>0 )
$roznica = floor(abs((strtotime($rep002Array[$i]['WLE_DATE_TO']) - strtotime($hst0Date)))/86400);
$date = strtotime($hst0Date); // your date
$newW2021=0;
$newT2021=0;
$newVm3_2021=0;
$newV2021=0;
$newWater = 0;
//jeśli jed w zakresie do jednej doby
$newW2021=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE>=SUBSTRING('".$hst0Date."',1,10) and AVG_DATE<=SUBSTRING('".$hst0Date."',1,10)", "AVG_Q_VAL");
$newT2021=fCzas($rep002Array[$i]['DRS_ID'], $hst0Date, substr($hst0Date, 0,10).' 23:59:59');
if( ($newT2021/3600)<=24 )
{
if ($newT2021>0 && $newW2021<=0)
{
$newW2021=sqlStringValue("select AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_ID=(select max(AVG_ID) from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE<=SUBSTRING('".$hst0Date."',1,10))", "AVG_Q_VAL");
}
$newVm3_2021 = (float) round(($newT2021/3600)*$newW2021,3);
}
if ($roznica>0)
{
for($cntD=1; $cntD<=$roznica; $cntD++)
{
$newDate = date('Y-m-d', strtotime("+1 day", $date)); // day after original date
$newW2021=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE>=SUBSTRING('".$newDate."',1,10) and AVG_DATE<=SUBSTRING('".$newDate."',1,10)", "AVG_Q_VAL");
$newT2021=fCzas($rep002Array[$i]['DRS_ID'], $newDate.' 00:00:00', $newDate.' 23:59:59');
// sprawdza, czy aby na pewno nie ma wydajności
if ($newT2021>0 && $newW2021<=0)
{
$newW2021=sqlStringValue("select AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_ID=(select max(AVG_ID) from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep002Array[$i]['DRS_ID']." and AVG_DATE<=SUBSTRING('".$newDate."',1,10))", "AVG_Q_VAL");
}
$newV2021 = (float) round(($newT2021/3600)*$newW2021,3);
$newVm3_2021 += $newV2021;
$date=strtotime($newDate);
if (($newT2021/3600)>24) $roznica--;
// 2021-10-31 w przypadku zmiany agregatu sprawdza, czy data wybudowy nie jest mniejsza niż kolejny liczony dzień.
if(strlen($rep002Array[$i]['WLE_DATE_TO'])>8 && cdt($newDate)>=cdt(substr($rep002Array[$i]['WLE_DATE_TO'], 0,10)) )
{
//echo'<h1>Przerywam i wychodzę! </h1><br/>';
break;
}
}
}
$newVm3_2021 = round($newVm3_2021,0);
$newWater = $newVm3_2021/($newTime/3600);
echo"
<tr ".$isTransmisionColor.">
<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($newTime/3600,0)."</td>
<td>".$newVm3_2021."</td>
<td>".round($newWater/60,3)."</td>
<td>".$valHst0."</td>
<td>".$valHd."</td>
<td>".$valTw."</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($newTime/3600,0),
'il_wody' => $newVm3_2021,
'srednia_q' => round($newWater/60,3),
'hst0' => $valHst0,
'hd' => $valHd,
'temp_wody' => $valTw,
'chlorki' => $valClor,
'date_from' => $_POST['post_dt_from'],
'date_to' => $dateTo
);
//$bariera_woda+= (float) $valVm3;
//$calosc_woda += (float) $valVm3;
$bariera_woda+= (float) $newVm3_2021;
$calosc_woda += (float) $newVm3_2021;
}
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>";
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 2 - save to archiwum
// ==================================================================================================================================
if ($_POST['post_action']=='save_rep2' && $_POST['done']=='create')
{
if (!empty($_SESSION['rap002_array']) && count($_SESSION['rap002_array'])>0)
{
$rapName = date('Ymd_His')."_".$_SESSION['user']."_rap002";
$genDate = date('Y-m-d H:i:s');
for($i=0; $i<count($_SESSION['rap002_array']); $i++)
{
unset($query);
$query = "INSERT INTO softspm_rep.rep_002_history_saved SET
DHS_DRS_ID=".$_SESSION['rap002_array'][$i]['id'].",
DHS_REPORT_NAME='".$rapName."',
DHS_AUDIT_CU='".$_SESSION['user']."',
DHS_AUDIT_CD='".$genDate."',
DHS_AUDIT_DEP='".$_SESSION['syndis_eq_stock']."',
DHS_BARIERA='".$_SESSION['rap002_array'][$i]['bariera']."',
DHS_WELL='".$_SESSION['rap002_array'][$i]['studnia']."',
DHS_AGREGAT='".$_SESSION['rap002_array'][$i]['agregat']."'";
if ($_SESSION['rap002_array'][$i]['moc']>0) $query.=",DHS_P_VAL=".$_SESSION['rap002_array'][$i]['moc'];
if ($_SESSION['rap002_array'][$i]['czas_pracy']>0) $query.=",DHS_WORK_TIME_VAL=".$_SESSION['rap002_array'][$i]['czas_pracy'];
if ($_SESSION['rap002_array'][$i]['il_wody']>0) $query.=",DHS_VM3_VAL=".$_SESSION['rap002_array'][$i]['il_wody'];
if ($_SESSION['rap002_array'][$i]['srednia_q']>0) $query.=",DHS_QS_VAL=".$_SESSION['rap002_array'][$i]['srednia_q'];
if ($_SESSION['rap002_array'][$i]['hst0']>0) $query.=",DHS_HST0_VAL=".$_SESSION['rap002_array'][$i]['hst0'];
if ($_SESSION['rap002_array'][$i]['hd']>0) $query.=",DHS_HD_VAL=".$_SESSION['rap002_array'][$i]['hd'];
if ($_SESSION['rap002_array'][$i]['temp_wody']>0) $query.=",DHS_WTEMP_VAL=".$_SESSION['rap002_array'][$i]['temp_wody'];
if ($_SESSION['rap002_array'][$i]['chlorki']>0) $query.=",DHS_CL_VAL=".$_SESSION['rap002_array'][$i]['chlorki'];
$query.=",DHS_DATE_FROM='".$_SESSION['rap002_array'][$i]['date_from']."',DHS_DATE_TO='".$_SESSION['rap002_array'][$i]['date_to']."'";
mysql_query($query);
}
echo'<script>sweetAlert("Zapisano!", "Wygenerowany raport został zapisany i jest dostępny w archiwum.", "success");</script>';
}
}
// ==================================================================================================================================
// Raport nr 3
// ==================================================================================================================================
if ($_POST['post_action']=='rep003' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
/*
if (substr($_POST['post_date'],5,2)=='01') $tbaName = "rep_002_data_styc";
elseif (substr($_POST['post_date'],5,2)=='02') $tbaName = "rep_002_data_luty";
elseif (substr($_POST['post_date'],5,2)=='03') $tbaName = "rep_002_data_marz";
elseif (substr($_POST['post_date'],5,2)=='04') $tbaName = "rep_002_data_kwie";
elseif (substr($_POST['post_date'],5,2)=='05') $tbaName = "rep_002_data_maj";
elseif (substr($_POST['post_date'],5,2)=='06') $tbaName = "rep_002_data_czer";
elseif (substr($_POST['post_date'],5,2)=='07') $tbaName = "rep_002_data_lipi";
elseif (substr($_POST['post_date'],5,2)=='08') $tbaName = "rep_002_data_sier";
elseif (substr($_POST['post_date'],5,2)=='09') $tbaName = "rep_002_data_wrze";
elseif (substr($_POST['post_date'],5,2)=='10') $tbaName = "rep_002_data_pazd";
elseif (substr($_POST['post_date'],5,2)=='11') $tbaName = "rep_002_data_list";
elseif (substr($_POST['post_date'],5,2)=='12') $tbaName = "rep_002_data_grud";
else $tbaName = "rep_002_data_lipi";
*/
$tbaName = getTableNameFrom_everyday_his($_POST['post_date']);
//2018-04-03
// warunke na nowe agregaty
// Przygotowanie danych
// ==================================== ==================================== ==================================== ====================================
mysql_query("drop temporary table if exists softspm_rep.rap_".session_id()."_1");
mysql_query("CREATE temporary TABLE softspm_rep.rap_".session_id()."_1 (WLL_ID int(11) DEFAULT NULL,DRS_ID int(11) unsigned NOT NULL DEFAULT '0',WLL_BARIERA varchar(32) DEFAULT NULL,WLL_NAME varchar(255) DEFAULT NULL,WWD_ID int(11) DEFAULT NULL,WWD_PARENT_ID int(11) DEFAULT NULL,WWD_NAME varchar(255) DEFAULT NULL,WLL_CAT_DIC_ID int(11) DEFAULT NULL,Q_H float(9,2) DEFAULT NULL,Q_MIN float(9,3) DEFAULT NULL,DRS_DEPARTMENT varchar(255) DEFAULT NULL,WLL_AUDIT_CD datetime DEFAULT NULL,PRIMARY KEY (DRS_ID)) ENGINE=InnoDB DEFAULT CHARSET=utf8");
mysql_query("drop temporary table if exists softspm_rep.rap_".session_id()."_2");
mysql_query("CREATE temporary TABLE softspm_rep.rap_".session_id()."_2 (WLL_ID int(11) DEFAULT NULL,DRS_ID int(11) unsigned NOT NULL DEFAULT '0',WLL_BARIERA varchar(32) DEFAULT NULL,WLL_NAME varchar(255) DEFAULT NULL,WLL_CAT_DIC_ID int(11) DEFAULT NULL,WI1_ID int(11) DEFAULT NULL,PT1_ID int(11) DEFAULT NULL,WI2_ID int(11) DEFAULT NULL,PT2_ID int(11) DEFAULT NULL,WI3_ID int(11) DEFAULT NULL,PT3_ID int(11) DEFAULT NULL,WI4_ID int(11) DEFAULT NULL,PT4_ID int(11) DEFAULT NULL,WI5_ID int(11) DEFAULT NULL,PT5_ID int(11) DEFAULT NULL,WI6_ID int(11) DEFAULT NULL,PT6_ID int(11) DEFAULT NULL,Q_H float(9,2) DEFAULT NULL,Q_MIN float(9,3) DEFAULT NULL,DRS_DEPARTMENT varchar(255) DEFAULT NULL,WLL_AUDIT_CD datetime DEFAULT NULL,PRIMARY KEY (DRS_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8");
unset($rep003Array_01);
//$rep003Array_01 = sqlGetResAsArray("select DRS_ID,WLL_ID,WLL_BARIERA,WLL_NAME,WLL_CAT_DIC_ID,WWD_ID,WWD_PARENT_ID,WWD_NAME,DRS_DEPARTMENT from seg_wells_exchanged,seg_wells left join seg_dev_resources on DRS_DEV_ID=WLL_ID left join seg_well_water_drainage on WLD_DRS_ID=DRS_ID left join seg_water_drainage on WLD_WWD_ID=WWD_ID where WLE_WLL_ID=WLL_ID and DRS_DEV_TYPE=12 and (WLE_DATE_TO is null or WLE_DATE_TO>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_DEPARTMENT='".$_POST['dep']."' and getValueInDate(507, DRS_ID, '".$_POST['post_date']."')='ON' order by WLL_BARIERA,WLL_NAME");
$rep003Array_01 = sqlGetResAsArray("select DRS_ID,(select WLL_ID from seg_dev_resources tb1, seg_wells tb2 where tb1.DRS_DEV_ID=tb2.WLL_ID and tb1.DRS_DEV_TYPE=12 and tb1.DRS_ID=tb3.DRS_ID limit 1) WLL_ID,(select WLL_BARIERA from seg_dev_resources tb1, seg_wells tb2 where tb1.DRS_DEV_ID=tb2.WLL_ID and tb1.DRS_DEV_TYPE=12 and tb1.DRS_ID=tb3.DRS_ID limit 1) WLL_BARIERA,(select WLL_NAME from seg_dev_resources tb1, seg_wells tb2 where tb1.DRS_DEV_ID=tb2.WLL_ID and tb1.DRS_DEV_TYPE=12 and tb1.DRS_ID=tb3.DRS_ID limit 1) WLL_NAME,(select WLL_CAT_DIC_ID from seg_dev_resources tb1, seg_wells tb2 where tb1.DRS_DEV_ID=tb2.WLL_ID and tb1.DRS_DEV_TYPE=12 and tb1.DRS_ID=tb3.DRS_ID limit 1) WLL_CAT_DIC_ID,WWD_ID,WWD_PARENT_ID,WWD_NAME,DRS_DEPARTMENT from seg_dev_resources tb3,seg_well_water_drainage left join seg_water_drainage on WLD_WWD_ID=WWD_ID where WLD_DRS_ID=tb3.DRS_ID and tb3.DRS_DEPARTMENT='".$_POST['dep']."' and getWellStatusOnOff(tb3.DRS_ID, '".$_POST['post_date']."')='ON' order by WWD_PARENT_ID,WLL_BARIERA,WLL_NAME");
for($i1=0;$i1<count($rep003Array_01);$i1++)
{
// $rep003Array_01[$i1]['WLL_ID']
unset($rep003Array_02);
$rep003Array_02 = sqlGetResAsArray("select RHD_Q_VAL, round(RHD_Q_VAL/60,3) Q_MIN from ".$tbaName." where RHD_ID=(select max(RHD_ID) from ".$tbaName." where RHD_DRS_ID=".$rep003Array_01[$i1]['DRS_ID']." and RHD_Q_VAL>0 and RHD_DATE<='".$_POST['post_date']."')");
if ($rep003Array_02[0]['RHD_Q_VAL']>0)
{
unset($wwd_id);
if ($rep003Array_01[$i1]['WWD_ID']>0 ) $wwd_id = ",WWD_ID=".$rep003Array_01[$i1]['WWD_ID'];
unset($wwd_parent_id);
if ($rep003Array_01[$i1]['WWD_PARENT_ID']>0 ) $wwd_parent_id = ",WWD_PARENT_ID=".$rep003Array_01[$i1]['WWD_PARENT_ID'];
mysql_query("INSERT INTO softspm_rep.rap_".session_id()."_1 SET WLL_ID=".$rep003Array_01[$i1]['WLL_ID'].",DRS_ID=".$rep003Array_01[$i1]['DRS_ID'].",WLL_BARIERA='".$rep003Array_01[$i1]['WLL_BARIERA']."',WLL_NAME='".$rep003Array_01[$i1]['WLL_NAME']."'".$wwd_id.$wwd_parent_id.",WWD_NAME='".$rep003Array_01[$i1]['WWD_NAME']."',WLL_CAT_DIC_ID=".$rep003Array_01[$i1]['WLL_CAT_DIC_ID'].",Q_H=".$rep003Array_02[0]['RHD_Q_VAL'].",Q_MIN=".$rep003Array_02[0]['Q_MIN'].",DRS_DEPARTMENT='".$_POST['dep']."',WLL_AUDIT_CD=now()");
}
}
unset($tbArray);
$tbArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_1");
for($i=0; $i<count($tbArray); $i++)
{
unset($tb);
$tb = findTreeLevel($tbArray[$i]['WWD_ID']);
unset($query);
$query = "INSERT INTO softspm_rep.rap_".session_id()."_2 SET WLL_ID=".$tbArray[$i]['WLL_ID'].",DRS_ID=".$tbArray[$i]['DRS_ID'].",WLL_BARIERA='".$tbArray[$i]['WLL_BARIERA']."',WLL_NAME='".$tbArray[$i]['WLL_NAME']."',WLL_CAT_DIC_ID=".$tbArray[$i]['WLL_CAT_DIC_ID'];
if ($tb[0]['id']>0) $query .= ",WI1_ID=".$tb[0]['id'];
if ($tb[0]['par']>0) $query .= ",PT1_ID=".$tb[0]['par'];
if ($tb[1]['id']>0) $query .= ",WI2_ID=".$tb[1]['id'];
if ($tb[1]['par']>0) $query .= ",PT2_ID=".$tb[1]['par'];
if ($tb[2]['id']>0) $query .= ",WI3_ID=".$tb[2]['id'];
if ($tb[2]['par']>0) $query .= ",PT3_ID=".$tb[2]['par'];
if ($tb[3]['id']>0) $query .= ",WI4_ID=".$tb[3]['id'];
if ($tb[3]['par']>0) $query .= ",PT4_ID=".$tb[3]['par'];
if ($tb[4]['id']>0) $query .= ",WI5_ID=".$tb[4]['id'];
if ($tb[4]['par']>0) $query .= ",PT5_ID=".$tb[4]['par'];
if ($tb[5]['id']>0) $query .= ",WI6_ID=".$tb[5]['id'];
if ($tb[5]['par']>0) $query .= ",PT6_ID=".$tb[5]['par'];
$query .=",Q_H=".$tbArray[$i]['Q_H'].",Q_MIN=".$tbArray[$i]['Q_MIN'].",DRS_DEPARTMENT='".$tbArray[$i]['DRS_DEPARTMENT']."',WLL_AUDIT_CD=now()";
mysql_query($query);
}
// ==================================== ==================================== ==================================== ====================================
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th style="width: 20%">Zrzut</th>
<th style="width: 30%"></th>
<th>[m<sup>3</sup>/min]</th>
<th>[m<sup>3</sup>/h]</th>
</tr>
</thead>
';
// dopisuje do tablicy
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'red',
'col_1' => 'Grupa',
'col_2' => 'Bariera',
'col_3' => 'Studnia',
'col_4' => '',
'col_5' => '',
'col_6' => 'Zrzut [m3/min]',
'col_7' => 'Zrzut [m3/h]'
);
// =====================================================
// System
// ========================================================== *** ========================================================== //
echo"
<tr style='font-weight: bolder; background-color: #FF0000; color: #ffffff;'>
<td></td>
<td style='width: 15%;'>SYSTEM</td>
<td></td>
<td></td>
</tr>
";
// dopisuje do tablicy
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => 'SYSTEM',
'col_3' => '',
'col_4' => '----->',
'col_5' => 'SYSTEM',
'col_6' => '',
'col_7' => ''
);
// =====================================================
$roow=0; $licz_roow=0; $licznik=0;
unset($mainArray01);
$mainArray01 = sqlGetResAsArray("select WI1_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI1_ID=WWD_ID group by WI1_ID");
for($i01=0; $i01<count($mainArray01); $i01++)
{
echo"
<tr>
<td></td>
<td style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>".$mainArray01[$i01]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>".$mainArray01[$i01]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>".($mainArray01[$i01]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => '',
'col_2' => '',
'col_3' => $mainArray01[$i01]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $mainArray01[$i01]['Q_MIN'],
'col_7' => ($mainArray01[$i01]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += $mainArray01[$i01]['Q_MIN'];
}
if (count($mainArray01)>0)
{
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 30px;'><tr>
";
// dopisuje do tablicy
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 1
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI1_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI1_ID=WWD_ID group by WI1_ID");
for($i=0; $i<count($tmpArray); $i++)
{
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; SYSTEM</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => 'SYSTEM',
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI1_ID=".$tmpArray[$i]['WI1_ID']." and PT1_ID is null and PT2_ID is null order by WI1_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI1_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
// Pompownie
unset($rivArray);
$rivArray = sqlGetResAsArray("select WI2_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI2_ID=WWD_ID where WI1_ID=".$tmpArray[$i]['WI1_ID']." and PT1_ID is null and PT2_ID is not null group by WI2_ID order by WWD_NAME");
for($r=0; $r<count($rivArray); $r++)
{
echo"
<tr>
<td></td>
<td style='background-color: #FFEBCD;'>".$rivArray[$r]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".$rivArray[$r]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".($rivArray[$r]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy pompownie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI1_ID'],
'col_2' => '',
'col_3' => $rivArray[$r]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $rivArray[$r]['Q_MIN'],
'col_7' => ($rivArray[$r]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $rivArray[$r]['Q_MIN'];
}
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 2
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI2_ID,sum(Q_MIN) Q_MIN,WWD_NAME,WWD_PARENT_ID from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI2_ID=WWD_ID where PT2_ID is not null group by WI2_ID order by WWD_PARENT_ID,WWD_NAME");
for($i=0; $i<count($tmpArray); $i++)
{
$parent = sqlStringValue("select WWD_NAME from seg_water_drainage where WWD_ID=".$tmpArray[$i]['WWD_PARENT_ID'], "WWD_NAME");
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; ".$parent."</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => $parent,
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI2_ID=".$tmpArray[$i]['WI2_ID']." and PT2_ID is not null and PT3_ID is null order by WI2_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI2_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
// Pompownie
unset($rivArray);
$rivArray = sqlGetResAsArray("select WI3_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI3_ID=WWD_ID where WI2_ID=".$tmpArray[$i]['WI2_ID']." and PT3_ID is not null group by WI3_ID order by WWD_NAME");
for($r=0; $r<count($rivArray); $r++)
{
echo"
<tr>
<td></td>
<td style='background-color: #FFEBCD;'>".$rivArray[$r]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".$rivArray[$r]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".($rivArray[$r]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy pompownie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI2_ID'],
'col_2' => '',
'col_3' => $rivArray[$r]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $rivArray[$r]['Q_MIN'],
'col_7' => ($rivArray[$r]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $rivArray[$r]['Q_MIN'];
}
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 3
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI3_ID,sum(Q_MIN) Q_MIN,WWD_NAME,WWD_PARENT_ID from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI3_ID=WWD_ID where PT3_ID is not null group by WI3_ID order by WWD_PARENT_ID,WWD_NAME");
for($i=0; $i<count($tmpArray); $i++)
{
$parent = sqlStringValue("select WWD_NAME from seg_water_drainage where WWD_ID=".$tmpArray[$i]['WWD_PARENT_ID'], "WWD_NAME");
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; ".$parent."</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => $parent,
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI3_ID=".$tmpArray[$i]['WI3_ID']." and PT3_ID is not null and PT4_ID is null order by WI3_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI3_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
// Pompownie
unset($rivArray);
$rivArray = sqlGetResAsArray("select WI4_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI4_ID=WWD_ID where WI3_ID=".$tmpArray[$i]['WI3_ID']." and PT4_ID is not null group by WI4_ID order by WWD_NAME");
for($r=0; $r<count($rivArray); $r++)
{
echo"
<tr>
<td></td>
<td style='background-color: #FFEBCD;'>".$rivArray[$r]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".$rivArray[$r]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".($rivArray[$r]['Q_MIN']*60)."</td>
</tr>
";
// dopisuje do tablicy pompownie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI3_ID'],
'col_2' => '',
'col_3' => $rivArray[$r]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $rivArray[$r]['Q_MIN'],
'col_7' => ($rivArray[$r]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $rivArray[$r]['Q_MIN'];
}
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 4
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI4_ID,sum(Q_MIN) Q_MIN,WWD_NAME,WWD_PARENT_ID from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI4_ID=WWD_ID where PT4_ID is not null group by WI4_ID order by WWD_PARENT_ID,WWD_NAME");
for($i=0; $i<count($tmpArray); $i++)
{
$parent = sqlStringValue("select WWD_NAME from seg_water_drainage where WWD_ID=".$tmpArray[$i]['WWD_PARENT_ID'], "WWD_NAME");
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; ".$parent."</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN']*60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => $parent,
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI4_ID=".$tmpArray[$i]['WI4_ID']." and PT4_ID is not null and PT5_ID is null order by WI4_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI4_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
// Pompownie
unset($rivArray);
$rivArray = sqlGetResAsArray("select WI5_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI5_ID=WWD_ID where WI4_ID=".$tmpArray[$i]['WI4_ID']." and PT5_ID is not null group by WI5_ID order by WWD_NAME");
for($r=0; $r<count($rivArray); $r++)
{
echo"
<tr>
<td></td>
<td style='background-color: #FFEBCD;'>".$rivArray[$r]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".$rivArray[$r]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".($rivArray[$r]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy pompownie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI4_ID'],
'col_2' => '',
'col_3' => $rivArray[$r]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $rivArray[$r]['Q_MIN'],
'col_7' => ($rivArray[$r]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $rivArray[$r]['Q_MIN'];
}
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow*60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 5
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI5_ID,sum(Q_MIN) Q_MIN,WWD_NAME,WWD_PARENT_ID from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI5_ID=WWD_ID where PT5_ID is not null group by WI5_ID order by WWD_PARENT_ID,WWD_NAME");
for($i=0; $i<count($tmpArray); $i++)
{
$parent = sqlStringValue("select WWD_NAME from seg_water_drainage where WWD_ID=".$tmpArray[$i]['WWD_PARENT_ID'], "WWD_NAME");
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; ".$parent."</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => $parent,
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI5_ID=".$tmpArray[$i]['WI5_ID']." and PT5_ID is not null and PT6_ID is null order by WI5_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN']*60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI5_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
// Pompownie
unset($rivArray);
$rivArray = sqlGetResAsArray("select WI6_ID,sum(Q_MIN) Q_MIN,WWD_NAME from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI6_ID=WWD_ID where WI5_ID=".$tmpArray[$i]['WI5_ID']." and PT6_ID is not null group by WI6_ID order by WWD_NAME");
for($r=0; $r<count($rivArray); $r++)
{
echo"
<tr>
<td></td>
<td style='background-color: #FFEBCD;'>".$rivArray[$r]['WWD_NAME']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".$rivArray[$r]['Q_MIN']."</td>
<td style='font-weight: bolder; background-color: #ADD8E6;'>".($rivArray[$r]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy pompownie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI5_ID'],
'col_2' => '',
'col_3' => $rivArray[$r]['WWD_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $rivArray[$r]['Q_MIN'],
'col_7' => ($rivArray[$r]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $rivArray[$r]['Q_MIN'];
}
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
// poziom 6
// ========================================================== *** ========================================================== //
unset($tmpArray);
$tmpArray = sqlGetResAsArray("select WI6_ID,sum(Q_MIN) Q_MIN,WWD_NAME,WWD_PARENT_ID from softspm_rep.rap_".session_id()."_2 left join seg_water_drainage on WI6_ID=WWD_ID where PT6_ID is not null group by WI6_ID order by WWD_PARENT_ID,WWD_NAME");
for($i=0; $i<count($tmpArray); $i++)
{
$parent = sqlStringValue("select WWD_NAME from seg_water_drainage where WWD_ID=".$tmpArray[$i]['WWD_PARENT_ID'], "WWD_NAME");
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td style='width: 15%;'>".$tmpArray[$i]['WWD_NAME']."</td>
<td>&mdash; &mdash; &mdash; &rang; &nbsp;&nbsp;&nbsp; ".$parent."</td>
<td>".$tmpArray[$i]['Q_MIN']."</td>
<td>".($tmpArray[$i]['Q_MIN']*60)."</td>
</tr>
";
// dopisuje do tablicy nagłówek
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => 'Grupa:',
'col_2' => $tmpArray[$i]['WWD_NAME'],
'col_3' => '',
'col_4' => '----->',
'col_5' => $parent,
'col_6' => '',
'col_7' => ''
);
// =====================================================
$licz_roow=0;
//Studnie
unset($wellArray);
$wellArray = sqlGetResAsArray("select * from softspm_rep.rap_".session_id()."_2 where WI6_ID=".$tmpArray[$i]['WI6_ID']." and PT6_ID is not null order by WI6_ID,WLL_BARIERA,WLL_NAME");
for($w=0; $w<count($wellArray); $w++)
{
echo"
<tr>
<td>".$wellArray[$w]['WLL_BARIERA']."</td>
<td>".$wellArray[$w]['WLL_NAME']."</td>
<td>".$wellArray[$w]['Q_MIN']."</td>
<td>".($wellArray[$w]['Q_MIN'] * 60)."</td>
</tr>
";
// dopisuje do tablicy studnie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => '',
'col_1' => $tmpArray[$i]['WI6_ID'],
'col_2' => $wellArray[$w]['WLL_BARIERA'],
'col_3' => $wellArray[$w]['WLL_NAME'],
'col_4' => '',
'col_5' => '',
'col_6' => $wellArray[$w]['Q_MIN'],
'col_7' => ($wellArray[$w]['Q_MIN'] * 60)
);
// =====================================================
$licz_roow += (float) $wellArray[$w]['Q_MIN'];
}
//Pompowni brak - koniec drzewa
echo"
<tr style='font-weight: bolder; background-color: #0000CD; color: #ffffff;'>
<td style='text-align: right;'>Łącznie</td>
<td></td>
<td>".$licz_roow."</td>
<td>".($licz_roow * 60)."</td>
</tr><tr style='height: 20px;'><tr>
";
// dopisuje do tablicy podsumowanie
// =====================================================
$_SESSION['rap003_array'][] = array(
'znacznik' => 'blue',
'col_1' => 'Razem grupa:',
'col_2' => '',
'col_3' => '',
'col_4' => '',
'col_5' => '',
'col_6' => $licz_roow,
'col_7' => ($licz_roow * 60)
);
// =====================================================
}
// ========================================================== *** ========================================================== //
// ========================================================== *** ========================================================== //
echo'</table>';
mysql_query("drop temporary table if exists softspm_rep.rap_".session_id()."_1");
mysql_query("drop temporary table if exists softspm_rep.rap_".session_id()."_2");
}
// ==================================================================================================================================
// Raport nr 4
// ==================================================================================================================================
if ($_POST['post_action']=='rep004' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
$tbaName = getTableNameFrom_everyday_his($_POST['post_date']);
unset($wellFullArray);
$wellFullArray = sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' and WLE_DATE_FROM<='".$_POST['post_date']."' and (WLE_DATE_TO>='".$_POST['post_date']."' or WLE_DATE_TO is null) group by WLL_BARIERA,WLL_NAME order by WLL_BARIERA");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Bariera</th>
<th>Ilość studni z agregatem</th>
<th>Ilość studni wyłączonych</th>
<th>Moc znamionowa [kW]</th>
<th>Moc pobierana [kW]</th>
<th>Wydajność Q [m<sup>3</sup>/min]</th>
</tr>
</thead>
';
$bariera=$wellFullArray[0]['WLL_BARIERA'];
$licznik=0; $licznik_sum=0;
$ile_pracuje=0; $ile_pracuje_sum=0;
$moc_znamionowa=0; $moc_znamionowa_sum=0;
$moc_pobierana=0; $moc_pobierana_sum=0;
$wydajnosc=0; $wydajnosc_sum = 0;
unset($wellOff);
unset($res);
for($i=0; $i<count($wellFullArray); $i++)
{
//echo $wellFullArray[$i]['WLL_BARIERA'];
//echo'<br>';
if ($bariera!=$wellFullArray[$i]['WLL_BARIERA'])
{
echo"
<tr>
<td>".$bariera."</td>
<td>".$licznik."</td>
<td>".($licznik-$ile_pracuje)."</td>
<td>".$moc_znamionowa."</td>
<td>".$moc_pobierana."</td>
<td>".$wydajnosc."</td>
</tr>
";
$res[]=array(
'bariera' => $bariera,
'ile' => $licznik,
'wylaczone' => ($licznik-$ile_pracuje),
'moc_zn' => $moc_znamionowa,
'moc_pob' => $moc_pobierana,
'q' => $wydajnosc
);
$licznik_sum += $licznik;
$ile_pracuje_sum += $licznik-$ile_pracuje;
$moc_znamionowa_sum += $moc_znamionowa;
$moc_pobierana_sum += $moc_pobierana;
$wydajnosc_sum += $wydajnosc;
$bariera=$wellFullArray[$i]['WLL_BARIERA'];
$licznik=0;
$ile_pracuje=0;
$moc_znamionowa=0;
$moc_pobierana=0;
$wydajnosc=0;
}
unset($wellOnOffStatus);
$wellOnOffStatus = sqlGetResAsArray("select * from softspm_rep.rep_002_avg_pump_working where WST_ID=(select max(WST_ID) from softspm_rep.rep_002_avg_pump_working where WST_DRS_ID=".$wellFullArray[$i]['DRS_ID']." and WST_DATE<='".$_POST['post_date']."')");
//echo("select * from softspm_rep.rep_002_avg_pump_working where WST_ID=(select max(WST_ID) from softspm_rep.rep_002_avg_pump_working where WST_DRS_ID=".$wellFullArray[$i]['DRS_ID']." and WST_DATE<='".$_POST['post_date']."')");
//echo'<br>';
unset($powerEngineArray);
$powerEngineArray = sqlGetResAsArray("select * from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and DRS_DEV_ID=ENG_ID and ENG_NAME='".$wellFullArray[$i]['WLE_ENG_NAME']."' and DRS_SN_NUMBER='".$wellFullArray[$i]['WLE_ENG_NO']."'");
$moc_znamionowa += $powerEngineArray[0]['ENG_POWER'];
// dorobić tablice dla niepracujących
if ($wellOnOffStatus[0]['WST_STATUS_VAL']=='ON')
{
unset($peqValArrays);
$peqValArrays = sqlGetResAsArray("select * from ".$tbaName." where RHD_ID=(select max(RHD_ID) from ".$tbaName." where RHD_DRS_ID=".$wellFullArray[$i]['DRS_ID']." and RHD_DATE<='".$_POST['post_date']."' and RHD_PE_VAL>0 && RHD_Q_VAL>0)");
if (count($peqValArrays)<=0)
{
unset($peqValArrays);
$peqValArrays = sqlGetResAsArray("select * from ".$tbaName." where RHD_ID=(select max(RHD_ID) from ".$tbaName." where RHD_DRS_ID=".$wellFullArray[$i]['DRS_ID']." and RHD_DATE<='".$_POST['post_date']."' and RHD_Q_VAL>0)");
}
$moc_pobierana += $peqValArrays[0]['RHD_PE_VAL'];
$wydajnosc += round($peqValArrays[0]['RHD_Q_VAL']/60,3);
$ile_pracuje++;
}
else
{
$wellOff[] = array(
'id' => $wellFullArray[$i]['DRS_ID'],
'bariera' => $wellFullArray[$i]['WLL_BARIERA'],
'studnia' => $wellFullArray[$i]['WLL_NAME'],
'pompa' => $wellFullArray[$i]['WLE_PUMP_NAME'],
'silnik' => $wellFullArray[$i]['WLE_ENG_NAME'],
'powod' => setDicName($wellOnOffStatus[0]['WST_DESCRIPTION'])
);
}
$licznik++;
}
echo"
<tr>
<td>".$bariera."</td>
<td>".$licznik."</td>
<td>".($licznik-$ile_pracuje)."</td>
<td>".$moc_znamionowa."</td>
<td>".$moc_pobierana."</td>
<td>".$wydajnosc."</td>
</tr>
";
$res[]=array(
'bariera' => $bariera,
'ile' => $licznik,
'wylaczone' => ($licznik-$ile_pracuje),
'moc_zn' => $moc_znamionowa,
'moc_pob' => $moc_pobierana,
'q' => $wydajnosc
);
$licznik_sum += $licznik;
$ile_pracuje_sum += $licznik-$ile_pracuje;
$moc_znamionowa_sum += $moc_znamionowa;
$moc_pobierana_sum += $moc_pobierana;
$wydajnosc_sum += $wydajnosc;
echo"
<tr style='font-weight: bolder; background-color: #B22222; color: #ffffff;'>
<td>Razem</td>
<td>".$licznik_sum."</td>
<td>".$ile_pracuje_sum."</td>
<td>".$moc_znamionowa_sum."</td>
<td>".$moc_pobierana_sum."</td>
<td>".$wydajnosc_sum."</td>
</tr>
";
echo'</table>';
unset($_SESSION['rap004_array_01']);
$_SESSION['rap004_array_01']=$res;
unset($res);
$res[]=array(
'bariera' => $rep004Array_02[$i1]['WLL_BARIERA'],
'studnia' => $rep004Array_02[$i1]['WLL_NAME'],
'pompa' => $rep004Array_02[$i1]['PUP_NAME'],
'silnik' => $rep004Array_02[$i1]['ENG_NAME'],
'powod' => setDicName($rep004Array_OffReason[0]['DRD_DESCRIPTION'])
);
echo'
<br/><br/><br/>
<h4>Wykaz studni wyłączonych z zabudowanymi agregatami</h4>
<table class="table table-bordered">
<thead>
<tr>
<th>Lp.</th>
<th>Bariera</th>
<th>Studnia</th>
<th>Typ pompy</th>
<th>Typ silnika</th>
<th>Powód wyłączenia</th>
</tr>
</thead>
';
for($i=0; $i<count($wellOff); $i++)
{
echo"
<tr>
<td>".($i+1)."</td>
<td>".$wellOff[$i]['bariera']."</td>
<td>".$wellOff[$i]['studnia']."</td>
<td>".$wellOff[$i]['pompa']."</td>
<td>".$wellOff[$i]['silnik']."</td>
<td>".$wellOff[$i]['powod']."</td>
</tr>
";
$res[]=array(
'bariera' => $wellOff[$i]['bariera'],
'studnia' => $wellOff[$i]['studnia'],
'pompa' => $wellOff[$i]['pompa'],
'silnik' => $wellOff[$i]['silnik'],
'powod' => $wellOff[$i]['powod']
);
}
echo'</table>';
unset($_SESSION['rap004_array_02']);
$_SESSION['rap004_array_02']=$res;
}
// ==================================================================================================================================
// Raport nr 5
// ==================================================================================================================================
if ($_POST['post_action']=='rep005' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
$_SESSION['rep005_date'] = $_POST['post_date'];
unset($res);
$lp=1;
$bariera = "";
unset($rep005Array_01);
//$rep005Array_01 = 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_FROM<='".$_POST['post_date']." 00:00:00' and WLE_DATE_TO>='".$_POST['post_date']." 23:59:59') or (WLE_DATE_FROM<='".$_SESSION['rep005_date']." 00:00:00' and WLE_DATE_TO is null)) and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO ");
//$rep005Array_01 = 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,(select DIC_POL_LANG from sys_dictionaries where DIC_ID=(select DRD_DESCRIPTION from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_DRS_ID=DRS_ID and DRD_RESOURCES_DETAIL=507) limit 1)) POWOD 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>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_DEPARTMENT='".$_POST['dep']."' and (getValueInDate(507, DRS_ID, '".$_POST['post_date']."')='OFF' or getValueInDate(507, DRS_ID, '".$_POST['post_date']."') is null) order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
//$rep005Array_01 = sqlGetResAsArray("select * 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 DRS_DEPARTMENT='".$_POST['dep']."' and (WLE_DATE_TO is null or WLE_DATE_TO>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_ID not in (select WST_DRS_ID from softspm_rep.rep_002_avg_pump_working where WST_ID in (select max(WST_ID) from softspm_rep.rep_002_avg_pump_working where WST_DATE<='".$_POST['post_date']."' group by WST_DRS_ID) and WST_STATUS_VAL='ON') order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
$rep005Array_01 = sqlGetResAsArray("select * 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 DRS_DEPARTMENT='".$_POST['dep']."' and (WLE_DATE_TO is null or WLE_DATE_TO>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th></th>
<th>Studnia</th>
<th>Typ pompy</th>
<th>Numer pompy</th>
<th>Typ silnika</th>
<th>Numer silnika</th>
<th>Postój od</th>
<th>Postój do</th>
<th>Powód wyłączenia</th>
<th>Kategoria</th>
</tr>
</thead>
';
for ($i=0; $i<count($rep005Array_01); $i++)
{
unset($rep005Array_02);
$rep005Array_02 = sqlGetResAsArray("select WST_STATUS_VAL,WST_DATE from softspm_rep.rep_002_avg_pump_working where WST_ID=(select max(WST_ID) from softspm_rep.rep_002_avg_pump_working where WST_DATE<='".$_POST['post_date']."' and WST_DRS_ID=".$rep005Array_01[$i]['DRS_ID'].")");
if ($rep005Array_02[0]['WST_STATUS_VAL'] != 'ON')
{
if ($bariera!=$rep005Array_01[$i]['WLL_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='10'>Bariera: ".$rep005Array_01[$i]['WLL_BARIERA']."</td></tr>";
$bariera=$rep005Array_01[$i]['WLL_BARIERA'];
}
// powód wyłączenia
unset($drdID); $drdID=0; unset($rep005Array_OFF);
$drdID = sqlStringValue("select max(DRD_ID) DRD_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and DRD_DRS_ID=".$rep005Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE<='".$_POST['post_date']."'", "DRD_ID");
if ($drdID>0)
$rep005Array_OFF = sqlGetResAsArray("select * from seg_dev_resources_det where DRD_ID=".$drdID);
else {
$drdID = sqlStringValue("select max(DRD_ID) DRD_ID from seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and DRD_DRS_ID=".$rep005Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE<='".$_POST['post_date']."'", "DRD_ID");
if ($drdID>0)
$rep005Array_OFF = sqlGetResAsArray("select * from seg_dev_resources_det_his where DRD_ID=".$drdID);
}
// data włączenia (postój do)
unset($drdID); $drdID=0; unset($rep005Array_ON);
$drdID = sqlStringValue("select min(DRD_ID) DRD_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='ON' and DRD_DRS_ID=".$rep005Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$_POST['post_date']."'", "DRD_ID");
if ($drdID>0)
$rep005Array_ON = sqlGetResAsArray("select * from seg_dev_resources_det where DRD_ID=".$drdID);
else {
$drdID = sqlStringValue("select min(DRD_ID) DRD_ID from seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='ON' and DRD_DRS_ID=".$rep005Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$_POST['post_date']."'", "DRD_ID");
if ($drdID>0)
$rep005Array_ON = sqlGetResAsArray("select * from seg_dev_resources_det_his where DRD_ID=".$drdID);
}
echo"
<tr>
<td>".$lp.".</td>
<td>".$rep005Array_01[$i]['WLL_NAME']."</td>
<td>".$rep005Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep005Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep005Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep005Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$rep005Array_02[0]['WST_DATE']."</td>
<td>".$rep005Array_ON[0]['DRD_AUDIT_DATE']."</td>
<td>".setDicName($rep005Array_OFF[0]['DRD_DESCRIPTION'])."</td>
<td>".setDicName($rep005Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
</tr>
";
$lp++;
$res[]=array(
'data' => $_SESSION['rep005_date'],
'bariera' => $rep005Array_01[$i]['WLL_BARIERA'],
'studnia' => $rep005Array_01[$i]['WLL_NAME'],
'pompa' => $rep005Array_01[$i]['WLE_PUMP_NAME'],
'pompa_no' => $rep005Array_01[$i]['WLE_PUMP_NO'],
'silnik' => $rep005Array_01[$i]['WLE_ENG_NAME'],
'silnik_no' => $rep005Array_01[$i]['WLE_ENG_NO'],
'data_od' => $rep005Array_02[0]['WST_DATE'],
'data_do' => $rep005Array_ON[0]['DRD_AUDIT_DATE'],
'powod' => setDicName($rep005Array_OFF[0]['DRD_DESCRIPTION'])
);
}
}
/*
for($i1=0;$i1<count($rep005Array_01);$i1++)
{
unset($rep005Array_02);
$rep005Array_02 = sqlGetResAsArray("
select * from (
select DRD_VALUE,DRD_AUDIT_DATE,DRD_DESCRIPTION from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']."
union
select DRD_VALUE,DRD_AUDIT_DATE,DRD_DESCRIPTION from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']."
) tb1 where DRD_AUDIT_DATE=
(
select max(DRD_AUDIT_DATE) from (
select DRD_AUDIT_DATE from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']." and DRD_AUDIT_DATE<='".$_POST['post_date']."'
union
select DRD_AUDIT_DATE from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']." and DRD_AUDIT_DATE<='".$_POST['post_date']."'
) tb2)
");
if ($rep005Array_02[0]['DRD_VALUE']!='ON')
{
if ($bariera!=$rep005Array_01[$i1]['WLL_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='10'>Bariera: ".$rep005Array_01[$i1]['WLL_BARIERA']."</td></tr>";
$bariera=$rep005Array_01[$i1]['WLL_BARIERA'];
}
unset($rep005Array_03);
$rep005Array_03 = sqlGetResAsArray("
select * from (
select DRD_VALUE,DRD_AUDIT_DATE,DRD_DESCRIPTION from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']."
union
select DRD_VALUE,DRD_AUDIT_DATE,DRD_DESCRIPTION from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']."
) tb1 where DRD_AUDIT_DATE=
(
select min(DRD_AUDIT_DATE) from (
select DRD_AUDIT_DATE from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='ON' and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']." and DRD_AUDIT_DATE>='".$_POST['post_date']."'
union
select DRD_AUDIT_DATE from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='ON' and DRD_DRS_ID=".$rep005Array_01[$i1]['DRS_ID']." and DRD_AUDIT_DATE>='".$_POST['post_date']."'
) tb2)
");
echo"
<tr>
<td>".$lp.".</td>
<td>".$rep005Array_01[$i1]['WLL_NAME']."</td>
<td>".$rep005Array_01[$i1]['WLE_PUMP_NAME']."</td>
<td>".$rep005Array_01[$i1]['WLE_PUMP_NO']."</td>
<td>".$rep005Array_01[$i1]['WLE_ENG_NAME']."</td>
<td>".$rep005Array_01[$i1]['WLE_ENG_NO']."</td>
<td>".$rep005Array_02[0]['DRD_AUDIT_DATE']."</td>
<td>".$rep005Array_03[0]['DRD_AUDIT_DATE']."</td>
<td>".setDicName($rep005Array_02[0]['DRD_DESCRIPTION'])."</td>
<td>".setDicName($rep005Array_01[$i1]['WLL_CAT_DIC_ID'])."</td>
</tr>
";
$lp++;
$res[]=array(
'data' => $_SESSION['rep005_date'],
'bariera' => $rep005Array_01[$i1]['WLL_BARIERA'],
'studnia' => $rep005Array_01[$i1]['WLL_NAME'],
'pompa' => $rep005Array_01[$i1]['WLE_PUMP_NAME'],
'pompa_no' => $rep005Array_01[$i1]['WLE_PUMP_NO'],
'silnik' => $rep005Array_01[$i1]['WLE_ENG_NAME'],
'silnik_no' => $rep005Array_01[$i1]['WLE_ENG_NO'],
'data_od' => $rep005Array_02[0]['DRD_AUDIT_DATE'],
'data_do' => $rep005Array_03[0]['DRD_AUDIT_DATE'],
'powod' => setDicName($rep005Array_02[0]['DRD_DESCRIPTION'])
);
}
}
*/
echo'</table>';
unset($_SESSION['rep005_array']);
$_SESSION['rep005_array']=$res;
//
}
// ==================================================================================================================================
// Raport nr 6
// ==================================================================================================================================
if ($_POST['post_action']=='rep006' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']) && !empty($_POST['post_typ']))
{
unset($_SESSION['rep006Array']);
unset($rep006Array);
//$rep006Array = sqlGetResAsArray("select SRP_ID,DRS_ID,SRP_BARIERA,SRP_NAME,DRS_RESOURCES_DIC_ID,(select OHC_POZIOM_WODONOS from seg_object_hole_cards where OHC_DRS_ID=DRS_ID limit 1) POZIOM_WOD,(select DIC_POL_LANG from sys_dictionaries where DIC_ID=SRP_MCF_ID limit 1) SPM from seg_reservoirs_piezometers,seg_dev_resources where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=601 and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and DRS_STATUS_DIC_ID=3 and SRP_SYS_TYPE='".$_POST['post_typ']."' order by SRP_BARIERA,SRP_NAME");
$rep006Array = sqlGetResAsArray("select * from seg_reservoirs_piezometers,seg_dev_resources left join seg_object_hole_cards on DRS_ID=OHC_DRS_ID where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=SRP_TYPE_DIC_ID and DRS_DEV_TYPE=601 and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and SRP_SYS_TYPE='".$_POST['post_typ']."' and OHC_DATA_ODDANIA<='".$_POST['post_date']."' and (OHC_ZDJECIE_EXPL_DATE>='".$_POST['post_date']."' or OHC_ZDJECIE_EXPL_DATE is null) order by SRP_BARIERA,SRP_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th></th>
<th>Bariera</th>
<th>Nazwa</th>
<th>Gł. rurki [m]</th>
<th>Rzędna aktualna [m npm]</th>
<th>Poziom wodonośny</th>
<th>HST [m]</th>
<th>Data pomiaru</th>
<th>Status</th>
<th>Typ</th>
<th>Kategoria</th>
</tr>
</thead>
';
for($i=0; $i<count($rep006Array); $i++)
{
$hisType = sqlGetResAsArray("select * from seg_dev_resources_his where DRS_ID=".$rep006Array[$i]['DRS_ID']." and DRS_AUDIT_DATE=(select max(DRS_AUDIT_DATE) from seg_dev_resources_his where DRS_ID=".$rep006Array[$i]['DRS_ID']." and DRS_AUDIT_DATE<='".$_POST['post_date']." 23:59:59')");
if ($hisType[0]['DRS_RESOURCES_DIC_ID']>0) $rep006Array[$i]['DRS_RESOURCES_DIC_ID'] = $hisType[0]['DRS_RESOURCES_DIC_ID'];
unset($reArray);
$reArray = getHistoricalDataFrom_softspm_his(210,$rep006Array[$i]['DRS_ID'],$_POST['post_date']);
if (empty($reArray[0]['DRD_VALUE']) || $reArray[0]['DRD_VALUE']<=0) unset($reArray);
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep006Array[$i]['SRP_BARIERA']."</td>
<td>".$rep006Array[$i]['SRP_NAME']."</td>
<td>".getGlebokoscAct($rep006Array[$i]['DRS_ID'])."</td>
<td>".$rep006Array[$i]['OHC_RZEDNA_TERENU_ACT']."</td>
<td>".$rep006Array[$i]['OHC_POZIOM_WODONOS']."</td>
<td>".$reArray[0]['DRD_VALUE']."</td>
<td>".substr($reArray[0]['DRD_AUDIT_DATE'],0,10)."</td>
<td>".setDicName($rep006Array[$i]['DRS_RESOURCES_DIC_ID'])."</td>
<td>".$_POST['post_typ']."</td>
<td>".setDicName($rep006Array[$i]['SRP_MCF_ID'])."</td>
<tr>
";
$_SESSION['rep006Array'][] = array(
'typ' => $_POST['post_typ'],
'date' => $_POST['post_date'],
'bariera' => $rep006Array[$i]['SRP_BARIERA'],
'piezometr' => $rep006Array[$i]['SRP_NAME'],
'glebokosc' => getGlebokoscAct($rep006Array[$i]['DRS_ID']),
'rzedna' => $rep006Array[$i]['OHC_RZEDNA_TERENU_ACT'],
'poziom' => $rep006Array[$i]['OHC_POZIOM_WODONOS'],
'hst' => $reArray[0]['DRD_VALUE'],
'data' => substr($reArray[0]['DRD_AUDIT_DATE'],0,10),
'status' => setDicName($rep006Array[$i]['DRS_RESOURCES_DIC_ID'])
);
}
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 7
// ==================================================================================================================================
if ($_POST['post_action']=='rep007' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
/*
if (substr($_POST['post_date'],5,2)=='01') $tbaName = "rep_002_data_styc";
elseif (substr($_POST['post_date'],5,2)=='02') $tbaName = "rep_002_data_luty";
elseif (substr($_POST['post_date'],5,2)=='03') $tbaName = "rep_002_data_marz";
elseif (substr($_POST['post_date'],5,2)=='04') $tbaName = "rep_002_data_kwie";
elseif (substr($_POST['post_date'],5,2)=='05') $tbaName = "rep_002_data_maj";
elseif (substr($_POST['post_date'],5,2)=='06') $tbaName = "rep_002_data_czer";
elseif (substr($_POST['post_date'],5,2)=='07') $tbaName = "rep_002_data_lipi";
elseif (substr($_POST['post_date'],5,2)=='08') $tbaName = "rep_002_data_sier";
elseif (substr($_POST['post_date'],5,2)=='09') $tbaName = "rep_002_data_wrze";
elseif (substr($_POST['post_date'],5,2)=='10') $tbaName = "rep_002_data_pazd";
elseif (substr($_POST['post_date'],5,2)=='11') $tbaName = "rep_002_data_list";
elseif (substr($_POST['post_date'],5,2)=='12') $tbaName = "rep_002_data_grud";
else $tbaName = "rep_002_data_lipi";
*/
$tbaName = getTableNameFrom_everyday_his($_POST['post_date']);
unset($_SESSION['rep007Array']);
unset($rep007_his_Array_01);
$rep007_his_Array_01 = sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' and WLE_DATE_FROM<='".$_POST['post_date']."' and (WLE_DATE_TO>='".$_POST['post_date']."' or WLE_DATE_TO is null) group by WLL_BARIERA,WLL_NAME order by WLL_BARIERA,WLL_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th></th>
<th>Studnia</th>
<th>Agregat pompowy</th>
<th>Moc Pe [kW]</th>
<th>Czas pracy [h]</th>
<th>Jednostkowe zużycie energii [Wh/m<sup>3</sup>/m]</th>
<th>HST<sub>0</sub> [m]</th>
<th>HD [m]</th>
<th>Wydajność Q [m<sup>3</sup>/min]</th>
<th>Ciśnienie p<sub>1</sub> [m]</th>
<th>Ciśnienie p<sub>2</sub> [m]</th>
<th>Temp. wody [<sup>o</sup>C]</th>
<th>Stężenie chlorków Cl [mg/l]</th>
<th>Kategoria SPM</th>
</tr>
</thead>
';
$licznik=1;
$bariera = "";
for($i=0; $i<count($rep007_his_Array_01); $i++)
{
unset($wellOnOffStatus);
$wellOnOffStatus = sqlGetResAsArray("select * from softspm_rep.rep_002_avg_pump_working where WST_ID=(select max(WST_ID) from softspm_rep.rep_002_avg_pump_working where WST_DRS_ID=".$rep007_his_Array_01[$i]['DRS_ID']." and WST_DATE<='".$_POST['post_date']."')");
if ($wellOnOffStatus[0]['WST_STATUS_VAL']=='ON')
{
unset($wellParamArray);
$wellParamArray = sqlGetResAsArray("select * from ".$tbaName." where RHD_ID=(select max(RHD_ID) from ".$tbaName." where RHD_DRS_ID=".$rep007_his_Array_01[$i]['DRS_ID']." and RHD_DATE<='".$_POST['post_date']."' and RHD_Q_VAL>0)");
unset($hstVal);
$hstVal = sqlGetResAsArray("select MIR_HST_VAL from softspm_rep.rep_002_avg_mirror where MIR_ID=(select max(MIR_ID) from softspm_rep.rep_002_avg_mirror where MIR_DATE<'".$_POST['post_date']."' and MIR_DRS_ID=".$rep007_his_Array_01[$i]['DRS_ID'].")");
unset($engVal);
$engVal = sqlGetResAsArray("select UEC_ENG_VAL from softspm_rep.rep_002_avg_energy where UEC_ID=(select max(UEC_ID) from softspm_rep.rep_002_avg_energy where UEC_DRS_ID=".$rep007_his_Array_01[$i]['DRS_ID']." and UEC_DATE<=SUBSTRING('".$_POST['post_date']."',1,10))");
unset($clVal);
$clVal = sqlGetResAsArray("select CLO_CLO_VAL from softspm_rep.rep_002_avg_chlorine where CLO_ID=(select max(CLO_ID) from softspm_rep.rep_002_avg_chlorine where CLO_DATE<='".$_POST['post_date']."' and CLO_DRS_ID=".$rep007_his_Array_01[$i]['DRS_ID'].")");
if ($bariera!=$rep007_his_Array_01[$i]['WLL_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='14'>Bariera: ".$rep007_his_Array_01[$i]['WLL_BARIERA']."</td></tr>";
$bariera=$rep007_his_Array_01[$i]['WLL_BARIERA'];
}
echo"
<tr>
<td>".$licznik."</td>
<td>".$rep007_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep007_his_Array_01[$i]['WLE_PUMP_NAME']." / ".$rep007_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$wellParamArray[0]['RHD_PE_VAL']."</td>
<td>".$wellParamArray[0]['RHD_WORK_TIME_VAL']."</td>
<td>".$engVal[0]['UEC_ENG_VAL']."</td>
<td>".$hstVal[0]['MIR_HST_VAL']."</td>
<td>".$wellParamArray[0]['RHD_HD_VAL']."</td>
<td>".round($wellParamArray[0]['RHD_Q_VAL']/60,3)."</td>
<td>".$wellParamArray[0]['RHD_P1_VAL']."</td>
<td>".$wellParamArray[0]['RHD_P2_VAL']."</td>
<td>".$wellParamArray[0]['RHD_WTEMP_VAL']."</td>
<td>".$clVal[0]['CLO_CLO_VAL']."</td>
<td>".setDicName($rep007_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
$licznik++;
$_SESSION['rep007Array'][] = array(
'date' => $_POST['post_date'],
'bariera' => $rep007_his_Array_01[$i]['WLL_BARIERA'],
'well' => $rep007_his_Array_01[$i]['WLL_NAME'],
'agregat' => $rep007_his_Array_01[$i]['WLE_PUMP_NAME']." / ".$rep007_his_Array_01[$i]['WLE_ENG_NAME'],
'moc' => $wellParamArray[0]['RHD_PE_VAL'],
'czas' => $wellParamArray[0]['RHD_WORK_TIME_VAL'],
'jzu' => $engVal[0]['UEC_ENG_VAL'],
'hst' => $hstVal[0]['MIR_HST_VAL'],
'hd' => $wellParamArray[0]['RHD_HD_VAL'],
'q' => round($wellParamArray[0]['RHD_Q_VAL']/60,3),
'p1' => $wellParamArray[0]['RHD_P1_VAL'],
'p2' => $wellParamArray[0]['RHD_P2_VAL'],
'temp' => $wellParamArray[0]['RHD_WTEMP_VAL'],
'clor' => $clVal[0]['CLO_CLO_VAL']
);
}
}
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 8
// ==================================================================================================================================
if ($_POST['post_action']=='rep008' && $_POST['done']=='create' && $_POST['well']>0)
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists( $filename)) unlink($filename);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
//
unset($rep008_his_Array_01);
$rep008_his_Array_01 = sqlGetResAsArray("select DRS_ID,WLE_ID,WLL_BARIERA,WLL_NAME,WLL_CAT_DIC_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_dev_resources,seg_wells left join seg_wells_exchanged on WLE_WLL_ID=WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_ID=".$_POST['well']." order by WLE_NR_EXCHANGE");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Pompa</th>
<th>Numer</th>
<th>Silnik</th>
<th>Numer</th>
<th>Data zabudowy</th>
<th>Głębokość zabudowy [m]</th>
<th>Średnica rurociągu [mm]</th>
<th>Ostatnie zw. statyczne [m]</th>
<th>Ostatnie zw. dynamiczne [m]</th>
<th>Czas pracy [h]</th>
<th>Ilość wypompowanej wody [m<sup>3</sup>]</th>
<th>Średnia wydajność [m<sup>3</sup>/min]</th>
<th>Rzędna położenia studni [m n.p.m.]</th>
<th>Data wybudowy</th>
<th>Powód wymiany</th>
</tr>
</thead>
';
//$rep008_his_Array_01[0]['DRS_ID']
//$rep008_his_Array_01[0]['WLE_DATE_FROM']
//$rep008_his_Array_01[0]['WLE_DATE_TO']
for($i=0; $i<count($rep008_his_Array_01); $i++)
{
// jeśli jest wybodowany agregat
if (!empty($rep008_his_Array_01[$i]['WLE_DATE_TO']) || strlen($rep008_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
//2017-01
unset($tbName_f);unset($tbName_t);
$tbName_f = quarter($rep008_his_Array_01[$i]['WLE_DATE_FROM'],"rep_his_data_everyday");
$tbName_t = quarter($rep008_his_Array_01[$i]['WLE_DATE_TO'],"rep_his_data_everyday");
unset($rep008_HST0);
$rep008_HST0 = sqlGetResAsArray("select * from ".$tbName_f." where RHD_ID=(select max(RHD_ID) from ".$tbName_f." where RHD_HST0_VAL>0 and RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE<=DATE_ADD('".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."',INTERVAL 10 DAY))");
unset($rep008_Mes);
$rep008_Mes = sqlGetResAsArray("select * from ".$tbName_t." where RHD_ID=(select max(RHD_ID) from ".$tbName_t." where RHD_HD_VAL>0 and RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
unset($rep008_qAVG);
$rep008_qAVG = sqlGetResAsArray("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and AVG_DATE BETWEEN '".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and '".$rep008_his_Array_01[$i]['WLE_DATE_TO']."'");
unset($rep008_RZ);
$rep008_RZ = sqlGetResAsArray("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_RZEDNA>0 and OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
}
else
{
$rep008_his_Array_01[$i]['WLE_DATE_TO'] = date('Y-m-d H:i:s');
unset($tbName_f);unset($tbName_t);
$tbName_f = quarter($rep008_his_Array_01[$i]['WLE_DATE_FROM'],"rep_his_data_everyday");
$tbName_t = quarter($rep008_his_Array_01[$i]['WLE_DATE_TO'],"rep_his_data_everyday");
unset($rep008_HST0);
$rep008_HST0 = sqlGetResAsArray("select * from ".$tbName_f." where RHD_ID=(select max(RHD_ID) from ".$tbName_f." where RHD_HST0_VAL>0 and RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE<=DATE_ADD('".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."',INTERVAL 10 DAY))");
unset($rep008_Mes);
$rep008_Mes = sqlGetResAsArray("select * from ".$tbName_t." where RHD_ID=(select max(RHD_ID) from ".$tbName_t." where RHD_HD_VAL>0 and RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
unset($rep008_qAVG);
$rep008_qAVG = sqlGetResAsArray("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and AVG_DATE BETWEEN '".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and '".$rep008_his_Array_01[$i]['WLE_DATE_TO']."'");
unset($rep008_RZ);
$rep008_RZ = sqlGetResAsArray("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_RZEDNA>0 and OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
unset($rep008_his_Array_01[$i]['WLE_DATE_TO']);
}
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep008_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DR']."</td>
<td>".$rep008_HST0[0]['RHD_HST0_VAL']."</td>
<td>".$rep008_Mes[0]['RHD_HD_VAL']."</td>
<td>".$rep008_Mes[0]['RHD_SPM_WT']."</td>
<td>".$rep008_Mes[0]['RHD_SPM_PW']."</td>
<td>".round($rep008_qAVG[0]['AVG_Q_VAL']/60,3)."</td>
<td>".$rep008_RZ[0]['OHH_RZEDNA']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DATE_TO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_REASON']."</td>
<tr>
";
fwrite($myfile,
$rep008_his_Array_01[0]['WLL_NAME']."|"
.($i+1)."|"
.$rep008_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep008_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep008_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep008_his_Array_01[$i]['WLE_ENG_NO']."|"
.$rep008_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$rep008_his_Array_01[$i]['WLE_ZP']."|"
.$rep008_his_Array_01[$i]['WLE_DR']."|"
.$rep008_HST0[0]['RHD_HST0_VAL']."|"
.$rep008_Mes[0]['RHD_HD_VAL']."|"
.$rep008_Mes[0]['RHD_SPM_WT']."|"
.$rep008_Mes[0]['RHD_SPM_PW']."|"
.round($rep008_qAVG[0]['AVG_Q_VAL']/60,3)."|"
.$rep008_RZ[0]['OHH_RZEDNA']."|"
.$rep008_his_Array_01[$i]['WLE_DATE_TO']."|"
.$rep008_his_Array_01[$i]['WLE_REASON']."\r\n");
}
fclose($myfile);
/*
*
-- hst00
select * from softspm_his.rep_his_data_everyday_2017_q3 where RHD_ID=(select max(RHD_ID) from softspm_his.rep_his_data_everyday_2017_q3 where RHD_HST0_VAL>0 and RHD_DRS_ID=26822 and RHD_DATE<=DATE_ADD('2017-07-28 09:00:00',INTERVAL 10 DAY))
-- pomiary
select * from softspm_his.rep_his_data_everyday_2017_q3 where RHD_ID=(select max(RHD_ID) from softspm_his.rep_his_data_everyday_2017_q3 where RHD_HD_VAL>0 and RHD_DRS_ID=26822 and RHD_DATE<='2017-08-09 16:00:00')
-- srednia wydajność
select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=26822 and AVG_DATE BETWEEN '2017-07-28 09:00:00' and '2017-08-09 16:00:00'
--rzędna
select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_RZEDNA>0 and OHH_DRS_ID=26822 and `OHH_DATE`<='2017-08-09 16:00:00')
*
*/
/*
for($i=0; $i<count($rep008_his_Array_01); $i++)
{
unset($czas);unset($woda);unset($srednia);unset($hd);
unset($hst);unset($rzedna);
//dla SPM inne
if ($rep008_his_Array_01[$i]['WLL_CAT_DIC_ID']==20)
{
unset($rep008_his_Array_02);
if (strlen($rep008_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
if (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20150101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2014 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2014 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20150101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20160101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2015 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2015 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20160101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20170101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2016 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2016 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20170101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20180101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2017 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2017 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20180101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20190101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2018 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2018 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20190101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20200101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2019 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2019 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
else
{
$hst = sqlStringValue("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=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
if (empty($hst) || $hst<=0)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_his where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
}
unset($dathisArray);
$roznica = (strtotime(date("Y-m-d")) - strtotime($rep008_his_Array_01[$i]['WLE_DATE_TO'])) / (60*60*24);
if ($roznica>180)
$dathisArray = sqlGetResAsArray("select * from softspm_his.rep_his_data_everyday_his where RHD_ID=(select max(RHD_ID) from softspm_his.rep_his_data_everyday_his where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and RHD_DATE<'".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
else
$dathisArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and RHD_DATE<'".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
$hd = $dathisArray[0]['RHD_HD_VAL'];
$czas = (float) sqlStringValue("select SDC_VALUE from seg_dev_counters where SDC_ID=(select max(SDC_ID) from seg_dev_counters where SDC_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and SDC_TYPE_DIC_ID=290 and SDC_MEASURE_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')", "SDC_VALUE");
$woda = (float) sqlStringValue("select SDC_VALUE from seg_dev_counters where SDC_ID=(select max(SDC_ID) from seg_dev_counters where SDC_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and SDC_TYPE_DIC_ID=230 and SDC_MEASURE_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')", "SDC_VALUE");
if ($czas>0 && $woda>0)
$srednia = round(($woda/$czas)/60,3);
else
{
$czas = "";
$woda = "";
$srednia = "";
}
$rzedna = sqlStringValue("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_RZEDNA>0 and OHH_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')", "OHH_RZEDNA");
}
else
{
if (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20150101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2014 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2014 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20150101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20160101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2015 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2015 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20160101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20170101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2016 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2016 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20170101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20180101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2017 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2017 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20180101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20190101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2018 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2018 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20190101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20200101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2019 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2019 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
else
{
$hst = sqlStringValue("select DRD_VALUE from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
if (empty($hst) || $hst<=0)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_his where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
}
unset($dathisArray);
$dathisArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID'].")");
$hd = $dathisArray[0]['RHD_HD_VAL'];
$czas = (float) round(sqlStringValue("select getWellWorkingTimeInDate(".$rep008_his_Array_01[$i]['DRS_ID'].",now()) SDC_VALUE", "SDC_VALUE")/3600,2);
$woda = (float) sqlStringValue("select getWellPumpedWaterInDate(".$rep008_his_Array_01[$i]['DRS_ID'].",now()) SDC_VALUE", "SDC_VALUE");
if ($czas>0 && $woda>0)
$srednia = round(($woda/$czas)/60,3);
else
{
$czas = "";
$woda = "";
$srednia = "";
}
$rzedna = sqlStringValue("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_RZEDNA>0)", "OHH_RZEDNA");
}
}
// dla SPM Base oraz Opt
else
{
unset($rep008_his_Array_02);
if (strlen($rep008_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
if (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20150101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2014 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2014 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20150101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20160101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2015 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2015 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20160101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20170101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2016 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2016 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20170101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20180101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2017 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2017 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20180101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20190101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2018 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2018 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20190101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20200101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2019 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2019 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
else
{
$hst = sqlStringValue("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=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
if (empty($hst) || $hst<=0)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_his where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
}
unset($dathisArray);
$roznica = (strtotime(date("Y-m-d")) - strtotime($rep008_his_Array_01[$i]['WLE_DATE_TO'])) / (60*60*24);
if ($roznica>180)
$dathisArray = sqlGetResAsArray("select * from softspm_his.rep_his_data_everyday_his where RHD_ID=(select max(RHD_ID) from softspm_his.rep_his_data_everyday_his where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and RHD_DATE<'".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
else
$dathisArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and RHD_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and RHD_DATE<'".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')");
$hd = $dathisArray[0]['RHD_HD_VAL'];
$czas = $dathisArray[0]['RHD_WORK_TIME_VAL'];
$woda = $dathisArray[0]['RHD_VM3_VAL'];
//if ($czas>0 && $woda>0)
// $srednia = round($woda/$czas,3);
//else $srednia = round($dathisArray[0]['RHD_Q_VAL']/60,2);
$srednia = round($dathisArray[0]['RHD_Q_VAL']/60,3);
$rzedna = sqlStringValue("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_RZEDNA>0 and OHH_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')", "OHH_RZEDNA");
}
else
{
if (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20150101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2014 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2014 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20150101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20160101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2015 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2015 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20160101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20170101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2016 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2016 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20170101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20180101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2017 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2017 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20180101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20190101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2018 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2018 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
elseif (cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])>20190101000000 && cdt($rep008_his_Array_01[$i]['WLE_DATE_TO'])<20200101000000)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_2019 where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_2019 where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
else
{
$hst = sqlStringValue("select DRD_VALUE from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."')","DRD_VALUE");
if (empty($hst) || $hst<=0)
$hst = sqlStringValue("select DRD_VALUE from softspm_his.seg_dev_resources_det_his where DRD_ID=(select max(DRD_ID) from softspm_his.seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep008_his_Array_01[$i]['WLE_DATE_TO']."')","DRD_VALUE");
}
unset($dathisArray);
$dathisArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID'].")");
$hd = $dathisArray[0]['RHD_HD_VAL'];
$czas = $dathisArray[0]['RHD_WORK_TIME_VAL'];
$woda = $dathisArray[0]['RHD_VM3_VAL'];
//if ($czas>0 && $woda>0)
// $srednia = round($woda/$czas,3);
//else $srednia = round($dathisArray[0]['RHD_Q_VAL']/60,3);
$srednia = round($dathisArray[0]['RHD_Q_VAL']/60,3);
$rzedna = sqlStringValue("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID']." and OHH_RZEDNA>0)", "OHH_RZEDNA");
}
}
if (empty($rzedna) || $rzedna<=0)
$rzedna = sqlStringValue("select OHC_RZEDNA_TEREN from seg_object_hole_cards where OHC_DRS_ID=".$rep008_his_Array_01[$i]['DRS_ID'], "OHC_RZEDNA_TEREN");
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep008_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DR']."</td>
<td>".$hst."</td>
<td>".$hd."</td>
<td>".$czas."</td>
<td>".$woda."</td>
<td>".$srednia."</td>
<td>".$rzedna."</td>
<td>".$rep008_his_Array_01[$i]['WLE_DATE_TO']."</td>
<td>".$rep008_his_Array_01[$i]['WLE_REASON']."</td>
<tr>
";
fwrite($myfile,
$rep008_his_Array_01[0]['WLL_NAME']."|"
.($i+1)."|"
.$rep008_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep008_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep008_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep008_his_Array_01[$i]['WLE_ENG_NO']."|"
.$rep008_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$rep008_his_Array_01[$i]['WLE_ZP']."|"
.$rep008_his_Array_01[$i]['WLE_DR']."|"
.$hst."|"
.$hd."|"
.$czas."|"
.$woda."|"
.$srednia."|"
.$rzedna."|"
.$rep008_his_Array_01[$i]['WLE_DATE_TO']."|"
.$rep008_his_Array_01[$i]['WLE_REASON']."\r\n");
}
fclose($myfile);
*/
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 9
// ==================================================================================================================================
if ($_POST['post_action']=='rep009' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists( $filename)) unlink($filename);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
/*
if (substr($_POST['post_date'],5,2)=='01') $tbaName = "rep_002_data_styc";
elseif (substr($_POST['post_date'],5,2)=='02') $tbaName = "rep_002_data_luty";
elseif (substr($_POST['post_date'],5,2)=='03') $tbaName = "rep_002_data_marz";
elseif (substr($_POST['post_date'],5,2)=='04') $tbaName = "rep_002_data_kwie";
elseif (substr($_POST['post_date'],5,2)=='05') $tbaName = "rep_002_data_maj";
elseif (substr($_POST['post_date'],5,2)=='06') $tbaName = "rep_002_data_czer";
elseif (substr($_POST['post_date'],5,2)=='07') $tbaName = "rep_002_data_lipi";
elseif (substr($_POST['post_date'],5,2)=='08') $tbaName = "rep_002_data_sier";
elseif (substr($_POST['post_date'],5,2)=='09') $tbaName = "rep_002_data_wrze";
elseif (substr($_POST['post_date'],5,2)=='10') $tbaName = "rep_002_data_pazd";
elseif (substr($_POST['post_date'],5,2)=='11') $tbaName = "rep_002_data_list";
elseif (substr($_POST['post_date'],5,2)=='12') $tbaName = "rep_002_data_grud";
else $tbaName = "rep_002_data_lipi";
*/
$tbaName = getTableNameFrom_everyday_his($_POST['post_date']);
unset($rep009_his_Array_01);
//$rep009_his_Array_01 = sqlGetResAsArray("select * from (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_ZP,WLE_DR,(select PUP_Q_N from seg_pumps,seg_dev_resources where DRS_DEV_ID=PUP_ID and DRS_DEV_TYPE=10 and PUP_NAME=WLE_PUMP_NAME and DRS_SN_NUMBER=WLE_PUMP_NO limit 1) PUP_Q_N 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>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_DEPARTMENT='".$_POST['dep']."') tb order by WLE_PUMP_NAME,PUP_Q_N");
$rep009_his_Array_01 = sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' and WLE_DATE_FROM<='".$_POST['post_date']."' and (WLE_DATE_TO>='".$_POST['post_date']."' or WLE_DATE_TO is null) group by WLL_BARIERA,WLL_NAME order by WLE_PUMP_NAME,WLE_PUMP_NO");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp</th>
<th>Typ pompy</th>
<th>Numer pompy</th>
<th>Typ silnika</th>
<th>Numer silnika</th>
<th>Studnia</th>
<th>Gł.zab.[m]</th>
<th>Średnica rurociągu<br/>[mm]</th>
<th>Średnica D<sub>ST</sub><br/>[mm]</th>
<th>Hst [m]</th>
<th>Hd [m]</th>
<th>Q ostatnie <br/>[m³/min]</th>
<th>Q średnie <br/>[m³/min]</th>
<th>Data uruchomienia</th>
<th>Czas pracy [h]</th>
<th>Kategoria</th>
</tr>
</thead>
';
for($i=0; $i<count($rep009_his_Array_01); $i++)
{
unset($valDetArray);
$valDetArray = sqlGetResAsArray("select * from ".$tbaName." where RHD_ID=(select max(RHD_ID) from ".$tbaName." where RHD_DATE<='".$_POST['post_date']."' and RHD_Q_VAL>0 and RHD_DRS_ID=".$rep009_his_Array_01[$i]['DRS_ID'].")");
unset($qSredVal);
$qSredVal = sqlStringValue("select AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DATE>='".$rep009_his_Array_01[$i]['WLE_DATE_FROM']."' and AVG_DATE<='".$_POST['post_date']."' and AVG_DRS_ID=".$rep009_his_Array_01[$i]['DRS_ID'], "AVG_Q_VAL");
unset($hstVal);
$hstVal = sqlStringValue("select MIR_HST_VAL from softspm_rep.rep_002_avg_mirror where MIR_ID=(select max(MIR_ID) from softspm_rep.rep_002_avg_mirror where MIR_DATE<'".$_POST['post_date']."' and MIR_DRS_ID=".$rep009_his_Array_01[$i]['DRS_ID'].")", "MIR_HST_VAL");
unset($wellTime);
$wellTime=fCzas($rep009_his_Array_01[$i]['DRS_ID'], $rep009_his_Array_01[$i]['WLE_DATE_FROM'], $_POST['post_date']);
$wellTime = round($wellTime/3600,0);
//20230728
unset($rep009DSTArray);
$rep009DSTArray = sqlGetResAsArray("SELECT * FROM seg_dev_resources_det WHERE DRD_ID=(SELECT max(DRD_ID) FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=100 AND DRD_DRS_ID=".$rep009_his_Array_01[$i]['DRS_ID'].")");
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep009_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep009_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep009_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep009_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$rep009_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep009_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep009_his_Array_01[$i]['WLE_DR']."</td>
<td>".$rep009DSTArray[0]['DRD_VALUE']."</td>
<td>".$hstVal."</td>
<td>".$valDetArray[0]['RHD_HD_VAL']."</td>
<td>".round($valDetArray[0]['RHD_Q_VAL']/60,3)."</td>
<td>".round($qSredVal/60,3)."</td>
<td>".$rep009_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$wellTime."</td>
<td>".setDicName($rep009_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date']."|"
.($i+1)."|"
.$rep009_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep009_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep009_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep009_his_Array_01[$i]['WLE_ENG_NO']."|"
.$rep009_his_Array_01[$i]['WLL_NAME']."|"
.$rep009_his_Array_01[$i]['WLE_ZP']."|"
.$rep009_his_Array_01[$i]['WLE_DR']."|"
.$rep009DSTArray[0]['DRD_VALUE']."|"
.$hstVal."|"
.$valDetArray[0]['RHD_HD_VAL']."|"
.round($valDetArray[0]['RHD_Q_VAL']/60,3)."|"
.round($qSredVal/60,3)."|"
.$rep009_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$wellTime."|"
.setDicName($rep009_his_Array_01[$i]['WLL_CAT_DIC_ID'])."\r\n");
}
fclose($myfile);
echo'</table>';
//
}
// ==================================================================================================================================
// Raport nr 10
// ==================================================================================================================================
if ($_POST['post_action']=='rep010' && $_POST['done']=='create' && !empty($_POST['post_date']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) unlink($filename);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep010Array_01);
// $rep010Array_01 = 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_ZP 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>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_DEPARTMENT='".$_POST['dep']."' and (getValueInDate(507, DRS_ID, '".$_POST['post_date']."')='OFF' or getValueInDate(507, DRS_ID, '".$_POST['post_date']."') is null) order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO");
//$rep010Array_01 = sqlGetResAsArray("select * from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and PUP_ID=DRS_DEV_ID and DRS_DEV_ATTENTION=1401 and DRS_DEPARTMENT='".$_POST['dep']."' order by DRS_DEV_TYPE,DRS_SN_NUMBER");
$rep010Array_01 = sqlGetResAsArray("select RWS_WLL_ID,RWS_DRS_ID,WLL_BARIERA,WLL_NAME,RWS_PUP_DRS_ID,RWS_ENG_DRS_ID,(select PUP_NAME from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and DRS_ID=RWS_PUP_DRS_ID limit 1) PUP_NAME,(select DRS_SN_NUMBER from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and DRS_ID=RWS_PUP_DRS_ID limit 1) PUP_SN_NUMBER,(select ENG_NAME from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and DRS_DEV_ID=ENG_ID and DRS_ID=RWS_ENG_DRS_ID limit 1) ENG_NAME,(select DRS_SN_NUMBER from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and DRS_DEV_ID=ENG_ID and DRS_ID=RWS_ENG_DRS_ID limit 1) ENG_SN_NUMBER,RWS_DESC from seg_wells,seg_wellsink_pump_eng_rel left join seg_dev_resources on DRS_ID=RWS_DRS_ID where WLL_ID=RWS_WLL_ID and RWS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA,WLL_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Bariera</th>
<th>Studnia</th>
<th>Typ pompy</th>
<th>Numer pompy</th>
<th>Typ silnika</th>
<th>Numer silnika</th>
<th>Głębokość LP [m]</th>
<th>Data uruchomienia</th>
<th>Data zatopienia</th>
<th>Powód</th>
</tr>
</thead>
';
for($i=0; $i<count($rep010Array_01); $i++)
{
unset($rep010Array_02);
//$rep010Array_02 = sqlGetResAsArray("select DRD_AUDIT_DATE,DRD_DESCRIPTION from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and DRD_DRS_ID=".$rep010Array_01[$i]['DRS_ID'].")");
//$rep010Array_02 = sqlGetResAsArray("select * from seg_wells_exchanged,seg_wells where WLL_ID=WLE_WLL_ID and WLE_PUMP_NAME='".$rep010Array_01[$i]['PUP_NAME']."' and WLE_PUMP_NO='".$rep010Array_01[$i]['DRS_SN_NUMBER']."' and WLE_DATE_FROM=(select max(WLE_DATE_FROM) from seg_wells_exchanged where WLE_PUMP_NAME='".$rep010Array_01[$i]['PUP_NAME']."' and WLE_PUMP_NO='".$rep010Array_01[$i]['DRS_SN_NUMBER']."')");
if ($rep010Array_01[$i]['RWS_PUP_DRS_ID']>0) $subQuery_01 = "and WLE_PUMP_NAME='".$rep010Array_01[$i]['PUP_NAME']."' and WLE_PUMP_NO='".$rep010Array_01[$i]['PUP_SN_NUMBER']."'";
else unset($subQuery_01);
if ($rep010Array_01[$i]['RWS_ENG_DRS_ID']>0) $subQuery_02 = "and WLE_ENG_NAME='".$rep010Array_01[$i]['ENG_NAME']."' and WLE_ENG_NO='".$rep010Array_01[$i]['ENG_SN_NUMBER']."'";
else unset($subQuery_02);
$rep010Array_02 = sqlGetResAsArray("select * from seg_wells_exchanged where WLE_ID=(select max(WLE_ID) from seg_wells_exchanged where WLE_WLL_ID=".$rep010Array_01[$i]['RWS_WLL_ID']." ".$subQuery_01." ".$subQuery_02.")");
echo"
<tr>
<td>".$rep010Array_01[$i]['WLL_BARIERA']."</td>
<td>".$rep010Array_01[$i]['WLL_NAME']."</td>
<td>".$rep010Array_01[$i]['PUP_NAME']."</td>
<td>".$rep010Array_01[$i]['PUP_SN_NUMBER']."</td>
<td>".$rep010Array_01[$i]['ENG_NAME']."</td>
<td>".$rep010Array_01[$i]['ENG_SN_NUMBER']."</td>
<td>".$rep010Array_02[0]['WLE_ZP']."</td>
<td>".$rep010Array_02[0]['WLE_DATE_FROM']."</td>
<td>".$rep010Array_02[0]['WLE_DATE_TO']."</td>
<td>".$rep010Array_01[$i]['RWS_DESC']."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date']."|"
.($i+1)."|"
.$rep010Array_01[$i]['WLL_BARIERA']."|"
.$rep010Array_01[$i]['WLL_NAME']."|"
.$rep010Array_01[$i]['PUP_NAME']."|"
.$rep010Array_01[$i]['PUP_SN_NUMBER']."|"
.$rep010Array_01[$i]['ENG_NAME']."|"
.$rep010Array_01[$i]['ENG_SN_NUMBER']."|"
.$rep010Array_02[0]['WLE_ZP']."|"
.$rep010Array_02[0]['WLE_DATE_FROM']."|"
.$rep010Array_02[0]['WLE_DATE_TO']."|"
.$rep010Array_01[$i]['RWS_DESC']."\r\n");
}
fclose($myfile);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 11
// ==================================================================================================================================
if ($_POST['post_action']=='rep011' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_date']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) {
unlink($filename);
}
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep011_his_Array_01);
$rep011_his_Array_01 = sqlGetResAsArray("select DRS_ID,DRS_BUY_DATE,DRS_AVAILABLE_DATE,DRS_CASSATION_DATE,WLL_ID,WLL_BARIERA,WLL_NAME,WLL_CAT_DIC_ID,WLL_SYS_TYPE,WLL_STAT_DESC,OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT,OHC_DL_GEOGR,OHC_SZER_GEOGR,OHC_DATA_ODDANIA from seg_wells ,seg_dev_resources left join seg_object_hole_cards on OHC_DRS_ID=DRS_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_STATUS_DIC_ID=3 and DRS_DEPARTMENT='".$_POST['dep']."' and DRS_BUY_DATE<='".$_POST['post_date']."' order by WLL_BARIERA,WLL_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp</th>
<th>Studnia</th>
<th>Typ obiektu</th>
<th>Data przyjęcia</th>
<th colspan=2>Współrzędne</th>
<th>Rzędna wiercenia [m n.p.m.]</th>
<th>Rzędna aktualna [m n.p.m.]</th>
<th>Głębokość aktualna [m]</th>
<th>Lokalizacja</th>
<th>Uwagi</th>
<th>Kategoria</th>
</tr>
</thead>
';
$bariera = "";
for($i=0; $i<count($rep011_his_Array_01); $i++)
{
if ($bariera!=$rep011_his_Array_01[$i]['WLL_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='13'>Bariera: ".$rep011_his_Array_01[$i]['WLL_BARIERA']."</td></tr>";
$bariera=$rep011_his_Array_01[$i]['WLL_BARIERA'];
}
unset($gleb);
$gleb = (float) ($rep011_his_Array_01[$i]['OHC_GLEB_OSTAT'] - ($rep011_his_Array_01[$i]['OHC_RZEDNA_TEREN'] - $rep011_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']));
unset($local);
$local = sqlStringValue("select OHH_ZMIAN_UMIEJ_LOCAL from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where LENGTH(OHH_ZMIAN_UMIEJ_LOCAL)>0 and OHH_DRS_ID=".$rep011_his_Array_01[$i]['DRS_ID'].")", "OHH_ZMIAN_UMIEJ_LOCAL");
unset($reason);
$reason = sqlStringValue("select OHH_ZMIAN_UMIEJ_REASON from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where LENGTH(OHH_ZMIAN_UMIEJ_REASON)>0 and OHH_DRS_ID=".$rep011_his_Array_01[$i]['DRS_ID'].")", "OHH_ZMIAN_UMIEJ_REASON");
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep011_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep011_his_Array_01[$i]['WLL_SYS_TYPE']."</td>
<td>".$rep011_his_Array_01[$i]['OHC_DATA_ODDANIA']."</td>
<td>".$rep011_his_Array_01[$i]['OHC_DL_GEOGR']."</td>
<td>".$rep011_his_Array_01[$i]['OHC_SZER_GEOGR']."</td>
<td>".$rep011_his_Array_01[$i]['OHC_RZEDNA_TEREN']."</td>
<td>".$rep011_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']."</td>
<td>".$gleb."</td>
<td>".$local."</td>
<td>".$reason."</td>
<td>".setDicName($rep011_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date']."|"
.($i+1)."|"
.$rep011_his_Array_01[$i]['WLL_BARIERA']."|"
.$rep011_his_Array_01[$i]['WLL_NAME']."|"
.$rep011_his_Array_01[$i]['WLL_SYS_TYPE']."|"
.$rep011_his_Array_01[$i]['OHC_DATA_ODDANIA']."|"
.$rep011_his_Array_01[$i]['OHC_DL_GEOGR']."|"
.$rep011_his_Array_01[$i]['OHC_SZER_GEOGR']."|"
.$rep011_his_Array_01[$i]['OHC_RZEDNA_TEREN']."|"
.$rep011_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']."|"
.$gleb."|"
.$local."|"
.$reason."|"
.setDicName($rep011_his_Array_01[$i]['WLL_CAT_DIC_ID'])."\r\n");
}
fclose($myfile);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 12
// ==================================================================================================================================
if ($_POST['post_action']=='rep012' && $_POST['done']=='create' && !empty($_POST['dep']) && !empty($_POST['post_typ']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) {
unlink($filename);
}
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep012_his_Array_01);
//$rep012_his_Array_01 = sqlGetResAsArray("select DRS_ID,DRS_BUY_DATE,DRS_AVAILABLE_DATE,DRS_CASSATION_DATE,SRP_ID,SRP_BARIERA,SRP_NAME,SRP_MCF_ID,SRP_SYS_TYPE,SRP_STAT_DESC,OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT,OHC_DL_GEOGR,OHC_SZER_GEOGR,OHC_DATA_ODDANIA,OHC_ZDJECIE_EXPL_DATE from seg_reservoirs_piezometers,seg_dev_resources left join seg_object_hole_cards on OHC_DRS_ID=DRS_ID where DRS_DEV_TYPE=601 and DRS_DEV_ID=SRP_ID and DRS_STATUS_DIC_ID=3 and DRS_DEPARTMENT='".$_POST['dep']."' and SRP_SYS_TYPE='".$_POST['post_typ']."' order by SRP_BARIERA,SRP_NAME");
$rep012_his_Array_01 = sqlGetResAsArray("select * from seg_reservoirs_piezometers,seg_dev_resources left join seg_object_hole_cards on DRS_ID=OHC_DRS_ID where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=SRP_TYPE_DIC_ID and DRS_DEV_TYPE=601 and DRS_DEPARTMENT='".$_POST['dep']."' and SRP_SYS_TYPE='".$_POST['post_typ']."' and OHC_DATA_ODDANIA<=now() and OHC_ZDJECIE_EXPL_DATE is null order by SRP_BARIERA,SRP_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp</th>
<th>Piezometr</th>
<th>Typ obiektu</th>
<th>Data przyjęcia</th>
<th colspan=2>Współrzędne</th>
<th>Rzędna wiercenia [m n.p.m.]</th>
<th>Rzędna aktualna [m n.p.m.]</th>
<th>Głębokość aktualna [m]</th>
<th>Lokalizacja</th>
<th>Uwagi</th>
<th>Sterowanie</th>
</tr>
</thead>
';
$bariera = "";
for($i=0; $i<count($rep012_his_Array_01); $i++)
{
if ($bariera!=$rep012_his_Array_01[$i]['SRP_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='13'>Bariera: ".$rep012_his_Array_01[$i]['SRP_BARIERA']."</td></tr>";
$bariera=$rep012_his_Array_01[$i]['SRP_BARIERA'];
}
unset($gleb);
$gleb = (float) ($rep012_his_Array_01[$i]['OHC_GLEB_OSTAT'] - ($rep012_his_Array_01[$i]['OHC_RZEDNA_TEREN'] - $rep012_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']));
unset($local);
$local = sqlStringValue("select OHH_ZMIAN_UMIEJ_LOCAL from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where LENGTH(OHH_ZMIAN_UMIEJ_LOCAL)>0 and OHH_DRS_ID=".$rep012_his_Array_01[$i]['DRS_ID'].")", "OHH_ZMIAN_UMIEJ_LOCAL");
unset($reason);
$reason = sqlStringValue("select OHH_ZMIAN_UMIEJ_REASON from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where LENGTH(OHH_ZMIAN_UMIEJ_REASON)>0 and OHH_DRS_ID=".$rep012_his_Array_01[$i]['DRS_ID'].")", "OHH_ZMIAN_UMIEJ_REASON");
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep012_his_Array_01[$i]['SRP_NAME']."</td>
<td>".$rep012_his_Array_01[$i]['SRP_SYS_TYPE']."</td>
<td>".$rep012_his_Array_01[$i]['OHC_DATA_ODDANIA']."</td>
<td>".$rep012_his_Array_01[$i]['OHC_DL_GEOGR']."</td>
<td>".$rep012_his_Array_01[$i]['OHC_SZER_GEOGR']."</td>
<td>".$rep012_his_Array_01[$i]['OHC_RZEDNA_TEREN']."</td>
<td>".$rep012_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']."</td>
<td>".$gleb."</td>
<td>".$local."</td>
<td>".$reason."</td>
<td>".setDicName($rep012_his_Array_01[$i]['SRP_MCF_ID'])."</td>
<tr>
";
fwrite($myfile,
($i+1)."|"
.$rep012_his_Array_01[$i]['SRP_BARIERA']."|"
.$rep012_his_Array_01[$i]['SRP_NAME']."|"
.$rep012_his_Array_01[$i]['SRP_SYS_TYPE']."|"
.$rep012_his_Array_01[$i]['OHC_DATA_ODDANIA']."|"
.$rep012_his_Array_01[$i]['OHC_DL_GEOGR']."|"
.$rep012_his_Array_01[$i]['OHC_SZER_GEOGR']."|"
.$rep012_his_Array_01[$i]['OHC_RZEDNA_TEREN']."|"
.$rep012_his_Array_01[$i]['OHC_RZEDNA_TERENU_ACT']."|"
.$gleb."|"
.$local."|"
.$reason."|"
.setDicName($rep012_his_Array_01[$i]['SRP_MCF_ID'])."\r\n");
}
fclose($myfile);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 13
// ==================================================================================================================================
if ($_POST['post_action']=='rep013' && $_POST['done']=='create' && !empty($_POST['dep']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) {
unlink($filename);
}
if (file_exists( $filename)) unlink($filename);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep013_his_Array_01);
$rep013_his_Array_01 = sqlGetResAsArray("select DRS_ID,WLL_ID,WLL_BARIERA,WLL_NAME,WLL_CAT_DIC_ID,WLE_NR_EXCHANGE,WLE_PUMP_NAME,WLE_PUMP_NO,WLE_ENG_NAME,WLE_ENG_NO,WLE_DATE_FROM,WLE_DATE_TO,WLE_REASON,WLE_ZP,WLE_DR from seg_wells_exchanged,seg_wells left join seg_dev_resources on WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 where WLE_WLL_ID=WLL_ID and ((WLE_DATE_TO>='".$_POST['post_date_f']." 00:00:00' and WLE_DATE_TO<='".$_POST['post_date_t']." 23:59:59') or (WLE_DATE_FROM>='".$_POST['post_date_f']." 00:00:00' and WLE_DATE_FROM<='".$_POST['post_date_t']." 23:59:59')) and DRS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA,WLL_NAME,WLE_NR_EXCHANGE desc");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Studnia</th>
<th>Nr wymiany</th>
<th>Typ pompy</th>
<th>Numer pompy</th>
<th>Typ silnika</th>
<th>Numer silnika</th>
<th>Moc [kW]</th>
<th>Data zabudowy</th>
<th>Data wybudowy</th>
<th>Czas pracy [h]</th>
<th>Powód wymiany</th>
<th>Głębokość zabudowy [m]</th>
<th>Średnica rurociągu [mm]</th>
<th>Kategoria</th>
</tr>
</thead>
';
$licznik=1;
for($i=0; $i<count($rep013_his_Array_01); $i++)
{
if (strlen($rep013_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
unset($tbName_t);
$tbName_t = quarter($rep013_his_Array_01[$i]['WLE_DATE_TO'],"rep_his_data_everyday");
unset($mesArray);
$mesArray = sqlGetResAsArray("select * from ".$tbName_t." where RHD_ID=(select max(RHD_ID) from ".$tbName_t." where RHD_Q_VAL>0 and RHD_DRS_ID=".$rep013_his_Array_01[$i]['DRS_ID']." and RHD_DATE<='".$rep013_his_Array_01[$i]['WLE_DATE_TO']."')");
if (count($mesArray)<=0)
{
unset($czas);
$mesArray[0]['RHD_SPM_WT']=round(fCzas($rep013_his_Array_01[$i]['DRS_ID'], $rep013_his_Array_01[$i]['WLE_DATE_FROM'], $rep013_his_Array_01[$i]['WLE_DATE_TO'])/3600,0);
}
unset($powVal);
$powVal = sqlGetResAsArray("select * from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and DRS_DEV_ID=ENG_ID and ENG_NAME='".$rep013_his_Array_01[$i]['WLE_ENG_NAME']."' and DRS_SN_NUMBER='".$rep013_his_Array_01[$i]['WLE_ENG_NO']."'");
echo"
<tr>
<td>".$rep013_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_NR_EXCHANGE']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$powVal[0]['ENG_POWER']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DATE_TO']."</td>
<td>".$mesArray[0]['RHD_SPM_WT']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_REASON']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DR']."</td>
<td>".setDicName($rep013_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date_f']."|"
.$_POST['post_date_t']."|"
.$licznik."|"
.$rep013_his_Array_01[$i]['WLL_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_NR_EXCHANGE']."|"
.$rep013_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep013_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_ENG_NO']."|"
.$powVal[0]['ENG_POWER']."|"
.$rep013_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$rep013_his_Array_01[$i]['WLE_DATE_TO']."|"
.$mesArray[0]['RHD_SPM_WT']."|"
.$rep013_his_Array_01[$i]['WLE_REASON']."|"
.$rep013_his_Array_01[$i]['WLE_ZP']."|"
.$rep013_his_Array_01[$i]['WLE_DR']."|"
.setDicName($rep013_his_Array_01[$i]['WLL_CAT_DIC_ID'])."\r\n");
$licznik++;
}
}
fclose($myfile);
// unset($tbName_f);unset($tbName_t);
// $tbName_f = quarter($rep008_his_Array_01[$i]['WLE_DATE_FROM'],"rep_his_data_everyday");
/*
for($i=0; $i<count($rep013_his_Array_01); $i++)
{
unset($tmpArray);unset($moc);unset($czas);
// jeśli jest SPM inne
if ($rep013_his_Array_01[$i]['WLL_CAT_DIC_ID']==20)
{
if (strlen($rep013_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
unset($czas);
$czas=fCzas($rep013_his_Array_01[$i]['DRS_ID'], $rep013_his_Array_01[$i]['WLE_DATE_FROM'], $rep013_his_Array_01[$i]['WLE_DATE_TO']);
$czas = round($czas/3600,0);
}
else
{
unset($czas);
$czas=fCzas($rep013_his_Array_01[$i]['DRS_ID'], $rep013_his_Array_01[$i]['WLE_DATE_FROM'], $_POST['post_date_t'].' '.date('H:i:s'));
$czas = round($czas/3600,0);
}
$moc = sqlStringValue("select ENG_POWER from seg_dev_resources,seg_engines where ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 and ENG_NAME='".$rep013_his_Array_01[$i]['WLE_ENG_NAME']."' and DRS_SN_NUMBER='".$rep013_his_Array_01[$i]['WLE_ENG_NO']."' limit 1", "ENG_POWER");
}
else
{
if (strlen($rep013_his_Array_01[$i]['WLE_DATE_TO'])>8)
{
$tmpArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep013_his_Array_01[$i]['DRS_ID']." and RHD_DATE<='".$rep013_his_Array_01[$i]['WLE_DATE_TO']."' and RHD_Q_VAL>0 and RHD_WORK_TIME_VAL>0)");
$moc = $tmpArray[0]['RHD_PE_VAL'];
$czas = round($tmpArray[0]['RHD_WORK_TIME_VAL'],0);
}
else
{
$tmpArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$rep013_his_Array_01[$i]['DRS_ID']." and RHD_Q_VAL>0 and RHD_WORK_TIME_VAL>0)");
$moc = $tmpArray[0]['RHD_PE_VAL'];
$czas = round($tmpArray[0]['RHD_WORK_TIME_VAL'],0);
}
}
echo"
<tr>
<td>".$rep013_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_NR_EXCHANGE']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$moc."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DATE_TO']."</td>
<td>".$czas."</td>
<td>".$rep013_his_Array_01[$i]['WLE_REASON']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep013_his_Array_01[$i]['WLE_DR']."</td>
<td>".setDicName($rep013_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date_f']."|"
.$_POST['post_date_t']."|"
.($i+1)."|"
.$rep013_his_Array_01[$i]['WLL_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_NR_EXCHANGE']."|"
.$rep013_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep013_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep013_his_Array_01[$i]['WLE_ENG_NO']."|"
.$moc."|"
.$rep013_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$rep013_his_Array_01[$i]['WLE_DATE_TO']."|"
.$czas."|"
.$rep013_his_Array_01[$i]['WLE_REASON']."|"
.$rep013_his_Array_01[$i]['WLE_ZP']."|"
.$rep013_his_Array_01[$i]['WLE_DR']."\r\n");
}
fclose($myfile);
*/
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 14
// ==================================================================================================================================
if ($_POST['post_action']=='rep014' && $_POST['done']=='create' && !empty($_POST['post_date']))
{
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) {
unlink($filename);
}
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep014_his_Array_01);
$rep014_his_Array_01 = 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,WLE_ZP,WLE_DR,WLE_REASON 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>='".$_POST['post_date']."') and WLE_DATE_FROM<='".$_POST['post_date']."' and DRS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA,WLL_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Studnia</th>
<th>Typ pompy</th>
<th>Numer pompy</th>
<th>Typ silnika</th>
<th>Numer silnika</th>
<th>Gł.zab. L<sub>p</sub> [m]</th>
<th>Data uruchomienia</th>
<th>Data wypięcia</th>
<th>Powód wypięcia</th>
<th>Kategoria</th>
</tr>
</thead>
';
$bariera="";
for($i=0; $i<count($rep014_his_Array_01); $i++)
{
if ($bariera!=$rep014_his_Array_01[$i]['WLL_BARIERA'])
{
echo"<tr style='font-weight: bolder; background-color: #F4F4F4;'><td colspan='11'>Bariera: ".$rep014_his_Array_01[$i]['WLL_BARIERA']."</td></tr>";
$bariera=$rep014_his_Array_01[$i]['WLL_BARIERA'];
}
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep014_his_Array_01[$i]['WLL_NAME']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_PUMP_NAME']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_PUMP_NO']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_ENG_NAME']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_ENG_NO']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_ZP']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_DATE_FROM']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_DATE_TO']."</td>
<td>".$rep014_his_Array_01[$i]['WLE_REASON']."</td>
<td>".setDicName($rep014_his_Array_01[$i]['WLL_CAT_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,
$_POST['post_date']."|"
.$rep014_his_Array_01[$i]['WLL_BARIERA']."|"
.($i+1)."|"
.$rep014_his_Array_01[$i]['WLL_NAME']."|"
.$rep014_his_Array_01[$i]['WLE_PUMP_NAME']."|"
.$rep014_his_Array_01[$i]['WLE_PUMP_NO']."|"
.$rep014_his_Array_01[$i]['WLE_ENG_NAME']."|"
.$rep014_his_Array_01[$i]['WLE_ENG_NO']."|"
.$rep014_his_Array_01[$i]['WLE_ZP']."|"
.$rep014_his_Array_01[$i]['WLE_DATE_FROM']."|"
.$rep014_his_Array_01[$i]['WLE_DATE_TO']."|"
.$rep014_his_Array_01[$i]['WLE_REASON']."|"
.setDicName($rep014_his_Array_01[$i]['WLL_CAT_DIC_ID'])."\r\n");
}
fclose($myfile);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 15
// ==================================================================================================================================
if ($_POST['post_action']=='rep015' && $_POST['done']=='create' && !empty($_POST['dep']))
{
//lista rekrdów
$filename="../charts/".base64_decode($_POST['file']);
if (file_exists($filename)) unlink ($filename);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
//plik na podsumowanie
$filename1=$filename.'_sum';
if (file_exists($filename1)) unlink ($filename1);
$myfile1 = fopen($filename1, "a+") or die("Unable to open file!");
unset($rep015_his_Array_01);
$rep015_his_Array_01= sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' and WLE_DATE_FROM<=now() and (WLE_DATE_TO>=now() or WLE_DATE_TO is null) group by WLL_BARIERA,WLL_NAME order by WLL_BARIERA");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th style="vertical-align: middle;" rowspan=2>Lp.</th>
<th style="vertical-align: middle;" rowspan=2>Bariera</th>
<th style="vertical-align: middle;" rowspan=2>Studnia</th>
<th style="vertical-align: middle;" rowspan=2>Typ silnika</th>
<th style="vertical-align: middle;" rowspan=2>Numer silnika</th>
<th style="vertical-align: middle;" rowspan=2>Napięcie [V]</th>
<th style="vertical-align: middle; text-align: center;" colspan=3>Wydana - ZLECENIA w SoftSPM</th>
<th style="vertical-align: middle; text-align: center;" colspan=3>Zabudowana</th>
<th style="vertical-align: middle;" rowspan=2>Kategoria</th>
</tr>
<tr>
<th>Data zlecenia</th>
<th>Typ kabla</th>
<th>Długość [m]</th>
<th>Data zabudowy</th>
<th>Długość [m]</th>
<th>Ciezar [kg]</th>
</tr>
</thead>
';
unset($tempTb);
unset($calbeArray);
unset($cableCounter);
for ($i=0; $i<count($rep015_his_Array_01); $i++)
{
unset($rep15Stany);
$rep15Stany= sqlGetResAsArray("select * from softspm_rep.rep_015_stany where PUP_TYPE='".$rep015_his_Array_01[$i]['WLE_PUMP_NAME']."' and PUP_NO='".$rep015_his_Array_01[$i]['WLE_PUMP_NO']."' and ENG_TYPE='".$rep015_his_Array_01[$i]['WLE_ENG_NAME']."' and ENG_NO='".$rep015_his_Array_01[$i]['WLE_ENG_NO']."'");
unset($rep15Data);
$rep15Data = sqlGetResAsArray("select * from softspm_rep.rep_015_data where stp_stamot_typ_m='".$rep015_his_Array_01[$i]['WLE_ENG_NAME']."' and stp_stamot_nr_m='".$rep015_his_Array_01[$i]['WLE_ENG_NO']."'");
unset($dataZlecenie);
$dataZlecenie = sqlGetResAsArray("select * from seg_orders,seg_order_new_agg_params where ORD_ID=ONA_ORD_ID and ONA_ORD_ID =(select max(ORD_ID) from seg_orders,seg_order_new_agg_params where ORD_ID=ONA_ORD_ID and ORD_OBJ_NAME='".$rep015_his_Array_01[$i]['WLL_NAME']."')");
if (empty($rep15Stany[0]['CBL_TYPE'])) $rep15Stany[0]['CBL_TYPE'] = substr($dataZlecenie[0]['ONA_CABLE'], 0, strpos($dataZlecenie[0]['ONA_CABLE'],'/'));
unset($il_1_tmp);
$il_1_tmp = substr($dataZlecenie[0]['ONA_CABLE'], strpos($dataZlecenie[0]['ONA_CABLE'],'/'), strpos($dataZlecenie[0]['ONA_CABLE'],'(')-strpos($dataZlecenie[0]['ONA_CABLE'],'/'));
$il_1_tmp = (double) str_replace(array(' ','/','-',','), array('','','','.'), $il_1_tmp);
$calbeArray[] = array(
date('Y-m-d'),
($i+1),
$rep015_his_Array_01[$i]['WLL_BARIERA'],
$rep015_his_Array_01[$i]['WLL_NAME'],
$rep015_his_Array_01[$i]['WLE_ENG_NAME'],
$rep015_his_Array_01[$i]['WLE_ENG_NO'],
$rep15Stany[0]['ENG_VOLTAGE'],
//$rep15Data[0]['dl_date'],
$dataZlecenie[0]['ORD_AUDIT_DATE'],
$rep15Stany[0]['CBL_TYPE'],
$dataZlecenie[0]['ONA_CABLE'],
$rep015_his_Array_01[$i]['WLE_DATE_FROM'],
$rep15Data[0]['dl_ilosc'],
$rep15Data[0]['dl_ciezar'],
//$rep15Data[0]['dl_date'],
setDicName($rep015_his_Array_01[$i]['WLL_CAT_DIC_ID']),
$il_1_tmp
);
}
unset($resArray);
$resArray = sortmddata($calbeArray,8,'ASC','str');
for($i=0; $i<count($resArray); $i++)
{
echo"
<tr>
<td>".($i+1)."</td>
<td>".$resArray[$i][2]."</td>
<td>".$resArray[$i][3]."</td>
<td>".$resArray[$i][4]."</td>
<td>".$resArray[$i][5]."</td>
<td>".$resArray[$i][6]."</td>
<td>".$resArray[$i][7]."</td>
<td>".$resArray[$i][8]."</td>
<td>".$resArray[$i][9]."</td>
<td>".$resArray[$i][10]."</td>
<td>".$resArray[$i][11]."</td>
<td>".$resArray[$i][12]."</td>
<td>".$resArray[$i][13]."</td>
<tr>
";
fwrite($myfile,
$resArray[$i][0]."|"
.($i+1)."|"
.$resArray[$i][2]."|"
.$resArray[$i][3]."|"
.$resArray[$i][4]."|"
.$resArray[$i][5]."|"
.$resArray[$i][6]."|"
.$resArray[$i][7]."|"
.$resArray[$i][8]."|"
.$resArray[$i][9]."|"
.$resArray[$i][10]."|"
.$resArray[$i][11]."|"
.$resArray[$i][12]."|"
.$resArray[$i][13]."|"
.$resArray[$i][14]."\r\n");
}
fclose($myfile);
echo'</table>';
echo'</br></br><h3>Podsumowanie</h3><table class="table table-bordered" >';
echo'
<thead>
<tr>
<th style="vertical-align: middle;">Typ kabla</th>
<th style="vertical-align: middle;">Suma [m] (Długość - zlecenie)</th>
<th style="vertical-align: middle;">Suma [m] (Długość - zabudowa)</th>
<th style="vertical-align: middle;">Suma [kg] (Ciężar - zabudowa)</th>
</tr>
</thead>
';
//print_r($resArray);
$typVal=0;
$typ=str_replace(array(' ',',','.'), array('','',''), $resArray[0][8]);
$typName = $resArray[0][8];
$typVal=$resArray[0][14];
$typDlZabVal=$resArray[0][11];
$typCiZabVal=$resArray[0][12];
for($i=1; $i<count($resArray); $i++)
{
$newType = str_replace(array(' ',',','.'), array('','',''), $resArray[$i][8]);
if ($typ!=$newType)
{
echo'
<tr>
<td>'.$typName.'</td>
<td>'.$typVal.'</td>
<td>'.$typDlZabVal.'</td>
<td>'.$typCiZabVal.'</td>
</tr>
';
fwrite($myfile1,
$typName."|"
.$typVal."|"
.$typDlZabVal."|"
.$typCiZabVal."\r\n");
$typVal=0;
$typDlZabVal=0;
$typCiZabVal=0;
$typ=$newType;
$typName = $resArray[$i][8];
$typVal+=$resArray[$i][14];
$typDlZabVal+=$resArray[$i][11];
$typCiZabVal+=$resArray[$i][12];
}
else
{
$typVal+=$resArray[$i][14];
$typDlZabVal+=$resArray[$i][11];
$typCiZabVal+=$resArray[$i][12];
}
}
echo'
<tr>
<td>'.$typName.'</td>
<td>'.$typVal.'</td>
<td>'.$typDlZabVal.'</td>
<td>'.$typCiZabVal.'</td>
</tr>
';
fwrite($myfile1,
$typName."|"
.$typVal."|"
.$typDlZabVal."|"
.$typCiZabVal."\r\n");
fclose($myfile1);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 16
// ==================================================================================================================================
if ($_POST['post_action']=='rep016' && $_POST['done']=='create' && !empty($_POST['dep']))
{
$filename="../charts/".base64_decode($_POST['file']);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep016_his_Array_01);
$rep016_his_Array_01 = sqlGetResAsArray("select mn1.WLL_BARIERA,mn2.WLE_DR,round(sum(mn2.WLE_ZP),2) WLE_ZP from (select DRS_ID,WLL_ID,WLL_BARIERA,WLL_NAME from seg_well_pump_eng_rel,seg_wells left join seg_dev_resources on DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID where WLL_ID=RWL_WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA) mn1,(select * from seg_wells_exchanged,(select WLE_WLL_ID ID,max(WLE_NR_EXCHANGE) NR_EXCHANGE from seg_wells_exchanged GROUP by WLE_WLL_ID) tb where WLE_WLL_ID=ID and WLE_NR_EXCHANGE=NR_EXCHANGE and WLE_DR>0 and WLE_ZP>0) mn2 where mn1.WLL_ID=mn2.ID group by mn1.WLL_BARIERA,mn2.WLE_DR order by mn1.WLL_BARIERA,mn2.WLE_DR");
unset($rep016_his_Array_02);
$rep016_his_Array_02 = sqlGetResAsArray("select WLE_DR, sum(WLE_ZP) ZP from (select mn1.WLL_BARIERA,mn2.WLE_DR,round(sum(mn2.WLE_ZP),2) WLE_ZP from (select DRS_ID,WLL_ID,WLL_BARIERA,WLL_NAME from seg_well_pump_eng_rel,seg_wells left join seg_dev_resources on DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID where WLL_ID=RWL_WLL_ID and DRS_DEPARTMENT='".$_POST['dep']."' order by WLL_BARIERA) mn1,(select * from seg_wells_exchanged,(select WLE_WLL_ID ID,max(WLE_NR_EXCHANGE) NR_EXCHANGE from seg_wells_exchanged GROUP by WLE_WLL_ID) tb where WLE_WLL_ID=ID and WLE_NR_EXCHANGE=NR_EXCHANGE and WLE_DR>0 and WLE_ZP>0) mn2 where mn1.WLL_ID=mn2.ID group by mn1.WLL_BARIERA,mn2.WLE_DR order by mn1.WLL_BARIERA,mn2.WLE_DR) tb group by WLE_DR order by ZP");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Bariera</th>
<th>Średnica kol. tłocznego [mm]</th>
<th>Suma długość kol. tłocznych [m]</th>
</tr>
</thead>
';
unset($sumsArray);
for ($i=0; $i<count($rep016_his_Array_01); $i++)
{
echo"
<tr>
<td>".$rep016_his_Array_01[$i]['WLL_BARIERA']."</td>
<td>".$rep016_his_Array_01[$i]['WLE_DR']."</td>
<td>".$rep016_his_Array_01[$i]['WLE_ZP']."</td>
<tr>
";
fwrite($myfile,
date('Y-m-d')."|"
.($i+1)."|"
.$rep016_his_Array_01[$i]['WLL_BARIERA']."|"
.$rep016_his_Array_01[$i]['WLE_DR']."|"
.$rep016_his_Array_01[$i]['WLE_ZP']."\r\n");
}
echo'</table>';
echo'<br/><br/>';
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>RAZEM</th>
<th>Średnica kol. tłocznego [mm]</th>
<th>Suma długość kol. tłocznych [m]</th>
</tr>
</thead>
';
for ($i=0; $i<count($rep016_his_Array_02); $i++)
{
echo"
<tr>
<td></td>
<td>".$rep016_his_Array_02[$i]['WLE_DR']."</td>
<td>".$rep016_his_Array_02[$i]['ZP']."</td>
<tr>
";
fwrite($myfile,
date('Y-m-d')."|"
."RAZEM"."|"
.$rep016_his_Array_02[$i]['WLL_BARIERA']."|"
.$rep016_his_Array_02[$i]['WLE_DR']."|"
.$rep016_his_Array_02[$i]['ZP']."\r\n");
}
echo'</table>';
fclose($myfile);
}
// ==================================================================================================================================
//Raporty EXTRA
// Raport nr 17 - historia agregatów (pomiarów) dla studni
// ==================================================================================================================================
if ($_POST['post_action']=='rep017' && $_POST['done']=='create' && $_POST['well']>0 && !empty($_POST['date_f']) && !empty($_POST['date_t']))
{
$filename="../charts/".base64_decode($_POST['file']);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($rep017Array); unset($wellName);
//$rep017Array = sqlGetResAsArray("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>='".$_POST['date_f']." 00:00:00' and RHD_DATE<='".$_POST['date_t']." 23:59:59' and RHD_DRS_ID=".$_POST['well']." 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>='".$_POST['date_f']." 00:00:00' and RHD_DATE<='".$_POST['date_t']." 23:59:59' and RHD_DRS_ID=".$_POST['well'].") tb order by RHD_DATE desc");
$rep017Array = sqlGetResAsArray("select * from (".getQuery_everyday_his($_POST['date_f'].' 00:00:00',$_POST['date_t'].' 23:59:59'," where RHD_DRS_ID=".$_POST['well']." and RHD_DATE>='".$_POST['date_f']." 00:00:00' && RHD_DATE<='".$_POST['date_t']." 23:59:59'").") tb order by RHD_DATE desc");
$wellName = sqlStringValue("select WLL_NAME from seg_dev_resources,seg_wells where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_ID=".$_POST['well'], WLL_NAME);
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Data</th>
<th>HST0 [m]</th>
<th>HST [m]</th>
<th>HD [m]</th>
<th>Q [m3/min]</th>
<th>p1 [m]</th>
<th>p2 [m]</th>
<th>I [A]</th>
<th>U [V]</th>
<th>Pe [kW]</th>
<th>cos(φ)</th>
<th>Czas pracy [h]</th>
<th>Ilość wody [m3]</th>
</tr>
</thead>
';
for ($i=0; $i<count($rep017Array); $i++)
{
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep017Array[$i]['RHD_DATE']."</td>
<td>".$rep017Array[$i]['RHD_HST0_VAL']."</td>
<td>".$rep017Array[$i]['RHD_HST_VAL']."</td>
<td>".$rep017Array[$i]['RHD_HD_VAL']."</td>
<td>".round($rep017Array[$i]['RHD_Q_VAL']/60,3)."</td>
<td>".$rep017Array[$i]['RHD_P1_VAL']."</td>
<td>".$rep017Array[$i]['RHD_P2_VAL']."</td>
<td>".$rep017Array[$i]['RHD_I_VAL']."</td>
<td>".$rep017Array[$i]['RHD_U_VAL']."</td>
<td>".$rep017Array[$i]['RHD_PE_VAL']."</td>
<td>".$rep017Array[$i]['RHD_COS_VAL']."</td>
<td>".$rep017Array[$i]['RHD_WORK_TIME_VAL']."</td>
<td>".$rep017Array[$i]['RHD_VM3_VAL']."</td>
<tr>
";
fwrite($myfile,
$wellName."|"
.$_POST['well']."|"
.$_POST['date_f']." 00:00:00|"
.$_POST['date_t']." 23:59:59|"
.$rep017Array[$i]['RHD_DATE']."|"
.$rep017Array[$i]['RHD_HST0_VAL']."|"
.$rep017Array[$i]['RHD_HST_VAL']."|"
.$rep017Array[$i]['RHD_HD_VAL']."|"
.round($rep017Array[$i]['RHD_Q_VAL']/60,3)."|"
.$rep017Array[$i]['RHD_P1_VAL']."|"
.$rep017Array[$i]['RHD_P2_VAL']."|"
.$rep017Array[$i]['RHD_I_VAL']."|"
.$rep017Array[$i]['RHD_U_VAL']."|"
.$rep017Array[$i]['RHD_PE_VAL']."|"
.$rep017Array[$i]['RHD_COS_VAL']."|"
.$rep017Array[$i]['RHD_WORK_TIME_VAL']."|"
.$rep017Array[$i]['RHD_VM3_VAL']."\r\n");
}
fclose($myfile);
echo'</table>';
}
// ==================================================================================================================================
// Raport nr 21
// ==================================================================================================================================
if ($_POST['post_action']=='rep021' && $_POST['done']=='create' && !empty($_POST['dep']))
{
$filename="../charts/".base64_decode($_POST['file']);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($tmp307Array);
$tmp307Array = sqlGetResAsArray("select SES_EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME,sum(SES_VALUE) TOT_VAL,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_POST['dep']."' and SDE_DRS_EQU_ID=SES_EQU_ID) TOT_STOCK from seg_equipments_stock,seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_EQU_ID=EQU_ID and SES_PARAM3='".$_POST['dep']."' and SES_TYPE=15 GROUP BY SES_EQU_ID order by EQU_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Nazwa</th>
<th>Średnica [mm]</th>
<th>Długość [m] / Ciśnienie [bar]</th>
<th>Producent</th>
<th>Całkowita ilość</th>
<th>Dostępna ilość</th>
</tr>
</thead>
';
fwrite($myfile,"#HEAD#|Nazwa|Średnica [mm]|Długość [m] / Ciśnienie [bar]|Producent|Całkowita ilość|Dostępna ilość\r\n");
for ($i=0; $i<count($tmp307Array); $i++)
{
echo"
<tr>
<td>".$tmp307Array[$i]['EQU_NAME']."</td>
<td>".$tmp307Array[$i]['EQU_PARAM_01']."</td>
<td>".$tmp307Array[$i]['EQU_PARAM_02']."</td>
<td>".$tmp307Array[$i]['MCF_NAME']."</td>
<td>".$tmp307Array[$i]['TOT_VAL']."</td>
<td>".round($tmp307Array[$i]['TOT_VAL']-$tmp307Array[$i]['TOT_STOCK'], 2)."</td>
<tr>
";
fwrite($myfile,
date('Y-m-d')."|"
.$tmp307Array[$i]['EQU_NAME']."|"
.$tmp307Array[$i]['EQU_PARAM_01']."|"
.$tmp307Array[$i]['EQU_PARAM_02']."|"
.$tmp307Array[$i]['MCF_NAME']."|"
.$tmp307Array[$i]['TOT_VAL']."|"
.round($tmp307Array[$i]['TOT_VAL']-$tmp307Array[$i]['TOT_STOCK'], 2)."\r\n");
}
echo'</table>';
echo"<br/><br/>";
for ($i=0; $i<count($tmp307Array); $i++)
{
echo"<h5>Lista powiązanych obiektów: <b>".$tmp307Array[$i]['EQU_NAME']."</b></h5>";
fwrite($myfile,"#GOODS_HEAD#|".$i."|Lista powiązanych obiektów: ".$tmp307Array[$i]['EQU_NAME']."\r\n");
unset($tmp307SubArray);
$tmp307SubArray = sqlGetResAsArray("select EQU_ID,EQU_NAME,DRS_DEV_TYPE,DRS_DEV_ID,SDE_DRS_DEV_ID,SDE_VALUE from seg_dev_equipments_rel left join seg_dev_resources on SDE_DRS_DEV_ID=DRS_ID left join seg_equipments on EQU_ID=SDE_DRS_EQU_ID where SDE_DRS_EQU_ID=".$tmp307Array[$i]['SES_EQU_ID']." and SDE_PARAM3 = '".$_POST['dep']."'");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Nazwa</th>
<th>Przypisany do</th>
<th>Ilość</th>
</tr>
</thead>
';
fwrite($myfile,"#GOODS#|Lp.|Nazwa|Przypisany do|Ilość\r\n");
for ($j=0; $j<count($tmp307SubArray); $j++)
{
if ($tmp307SubArray[$j]['DRS_DEV_TYPE']==12)
$obNAME = sqlStringValue("select WLL_NAME from seg_wells where WLL_ID=".$tmp307SubArray[$j]['DRS_DEV_ID'],"WLL_NAME");
else
$obNAME = sqlStringValue("select SRP_NAME from seg_reservoirs_piezometers where SRP_ID=".$tmp307SubArray[$j]['DRS_DEV_ID'],"SRP_NAME");
if (strlen($obNAME)==0) $obNAME="Brak powiązanego obiektu";
echo"
<tr>
<td>".($j+1)."</td>
<td>".$tmp307SubArray[$j]['EQU_NAME']."</td>
<td>".$obNAME."</td>
<td>".$tmp307SubArray[$j]['SDE_VALUE']."</td>
<tr>
";
fwrite($myfile,"#G#|".($j+1)."|"
.$tmp307SubArray[$j]['EQU_NAME']."|"
.$obNAME."|"
.$tmp307SubArray[$j]['SDE_VALUE']."\r\n");
}
echo'</table>';
echo"<br/><br/>";
}
fclose($myfile);
}
// ==================================================================================================================================
// Raport nr 22
// ==================================================================================================================================
if ($_POST['post_action']=='rep022' && $_POST['done']=='create' && !empty($_POST['dep']))
{
$filename="../charts/".base64_decode($_POST['file']);
$myfile = fopen($filename, "a+") or die("Unable to open file!");
unset($tmp308Array);
$tmp308Array = sqlGetResAsArray("select EQU_ID,count(EQU_ID) ILOSC,EQU_NAME,MCF_NAME from seg_dev_resources left join seg_equipments on DRS_DEV_ID=EQU_ID left join seg_manufacturers on EQU_MCF_ID=MCF_ID where DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='EQUIPMENTS') and DRS_DEPARTMENT = '".$_POST['dep']."' group by EQU_ID,EQU_NAME,MCF_NAME order by EQU_NAME");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Nazwa</th>
<th>Producent</th>
<th>Ilość</th>
</tr>
</thead>
';
fwrite($myfile,"#HEAD#|Nazwa|Producent|Ilość\r\n");
for ($i=0; $i<count($tmp308Array); $i++)
{
echo"
<tr>
<td>".$tmp308Array[$i]['EQU_NAME']."</td>
<td>".$tmp308Array[$i]['MCF_NAME']."</td>
<td>".$tmp308Array[$i]['ILOSC']."</td>
<tr>
";
fwrite($myfile,
date('Y-m-d')."|"
.$tmp308Array[$i]['EQU_NAME']."|"
.$tmp308Array[$i]['MCF_NAME']."|"
.$tmp308Array[$i]['ILOSC']."\r\n");
}
echo'</table>';
echo"<br/><br/>";
for ($i=0; $i<count($tmp308Array); $i++)
{
echo"<h5>Lista powiązanych obiektów: <b>".$tmp308Array[$i]['EQU_NAME']."</b></h5>";
fwrite($myfile,"#GOODS_HEAD#|".$i."|Lista powiązanych obiektów: ".$tmp308Array[$i]['EQU_NAME']."\r\n");
unset($tmp308SubArray);
$tmp308SubArray = sqlGetResAsArray("select DRS_ID,SDE_DRS_DEV_ID,DRS_SN_NUMBER,DRS_RESOURCES_DIC_ID from seg_dev_resources left join seg_dev_equipments_rel on DRS_ID=SDE_DRS_EQU_ID where DRS_DEV_TYPE=14 and DRS_DEPARTMENT = '".$_POST['dep']."' and DRS_DEV_ID=".$tmp308Array[$i]['EQU_ID']." order by DRS_SN_NUMBER");
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Nazwa</th>
<th>Nr seryjny</th>
<th>Przypisany do</th>
<th>Status</th>
</tr>
</thead>
';
fwrite($myfile,"#GOODS#|Lp.|Nazwa|Nr seryjny|Przypisany do|Status\r\n");
for ($j=0; $j<count($tmp308SubArray); $j++)
{
$obNAME=null;$dID2=null;
$wynik2 = mysql_query("select DRS_DEV_ID,DRS_DEV_TYPE from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$tmp308SubArray[$j]['DRS_ID']);
if($wynik2)while ($r2 = mysql_fetch_array($wynik2))
{
$dID2 = $r2["DRS_DEV_ID"];
$dTP2 = $r2["DRS_DEV_TYPE"];
if ($dTP2==12)
$obNAME = sqlStringValue("select WLL_NAME from seg_wells where WLL_ID=".$dID2,"WLL_NAME");
else
$obNAME = sqlStringValue("select SRP_NAME from seg_reservoirs_piezometers where SRP_ID=".$dID2,"SRP_NAME");
}
if (strlen($obNAME)==0)
$obNAME="Brak powiązanego obiektu";
echo"
<tr>
<td>".($j+1)."</td>
<td>".$tmp308Array[$i]['EQU_NAME']."</td>
<td>".$tmp308SubArray[$j]['DRS_SN_NUMBER']."</td>
<td>".$obNAME."</td>
<td>".setDicName($tmp308SubArray[$j]['DRS_RESOURCES_DIC_ID'])."</td>
<tr>
";
fwrite($myfile,"#G#|".($j+1)."|"
.$tmp308Array[$i]['EQU_NAME']."|"
.$tmp308SubArray[$j]['DRS_SN_NUMBER']."|"
.$obNAME."|"
.setDicName($tmp308SubArray[$j]['DRS_RESOURCES_DIC_ID'])."\r\n");
}
echo'</table>';
echo"<br/><br/>";
}
fclose($myfile);
}
// ==================================================================================================================================
// Raport nr 23 - Raport synchronizacji danych ze Stacją Prób
// ==================================================================================================================================
if ($_POST['post_action']=='rep023' && $_POST['done']=='create')
{
unset($rep023Array);
$rep023Array = sqlGetResAsArray("select * from sys_stacja_prob_upload_logs order by SPU_UPLOAD_SP_FILE desc limit 31");
unset($isWaiting);
if (sqlValue("select count(*) from sys_stacja_prob_upload_logs where SPU_MADE_DB_PROC is null")==0)
{
unset($lasUpPup);
$lasUpPup = sqlGetResAsArray("select max(stp_stapo_data_akt) PAK, SUBSTRING(max(stp_stapo_audit_date),1,10) PAD from stp_stapo");
echo'Stany pomp z: <b>'.$lasUpPup[0]['PAK'].'</b>, zaczytane dnia '.$lasUpPup[0]['PAD'].'<br/>';
$lasUpEng = sqlGetResAsArray("select max(stp_stamot_data_akt) EAK, SUBSTRING(max(stp_stamot_audit_date),1,10) EAD from stp_stamot");
echo'Stany silników z: <b>'.$lasUpEng[0]['EAK'].'</b>, zaczytane dnia '.$lasUpEng[0]['EAD'].'<br/>';
unset($lasUpCab);
$lasUpCab = sqlGetResAsArray("select (case when max(stp_stakabel_g_data_przy)>=max(stp_stakabel_g_data_roz) then SUBSTRING(max(stp_stakabel_g_data_przy),1,10) else SUBSTRING(max(stp_stakabel_g_data_roz),1,10) end) CAK, SUBSTRING(max(stp_stakabel_g_audit_date),1,10) CAD from stp_stakabel_g");
echo'Stany kabli z: <b>'.$lasUpCab[0]['CAK'].'</b>, zaczytane dnia '.$lasUpCab[0]['CAD'].'<br/><br/>';
}
else
{
echo'Pliki ze Stacji Prób zostały wgrane na serwer i czekają na synchronizację:<br/>';
unset($lasUpPup);
$lasUpPup = sqlGetResAsArray("select max(stp_stapo_data_akt) PAK from stp_stapo");
echo'Dane dla stanów pomp do synchronizacji z: <b>'.$lasUpPup[0]['PAK'].'</b><br/>';
$lasUpEng = sqlGetResAsArray("select max(stp_stamot_data_akt) EAK from stp_stamot");
echo'Dane dla stanów silników do synchronizacji z: <b>'.$lasUpEng[0]['EAK'].'</b><br/>';
unset($lasUpCab);
$lasUpCab = sqlGetResAsArray("select (case when max(stp_stakabel_g_data_przy)>=max(stp_stakabel_g_data_roz) then SUBSTRING(max(stp_stakabel_g_data_przy),1,10) else SUBSTRING(max(stp_stakabel_g_data_roz),1,10) end) CAK, SUBSTRING(max(stp_stakabel_g_audit_date),1,10) CAD from stp_stakabel_g");
echo'Dane dla kabli do synchronizacji z: <b>'.$lasUpCab[0]['CAK'].'</b><br/><br/>';
}
echo'
<table class="table table-bordered" >
<thead>
<tr>
<th>Lp.</th>
<th>Data plików DATA</th>
<th>Data synchronizacji</th>
</tr>
</thead>
';
for ($i=0; $i<count($rep023Array); $i++)
{
echo"
<tr>
<td>".($i+1)."</td>
<td>".$rep023Array[$i]['SPU_UPLOAD_SP_FILE']."</td>
<td>".$rep023Array[$i]['SPU_MADE_DB_PROC']."</td>
<tr>
";
}
echo'</table>';
}
// ==================================================================================================================================
mysql_close($con);
?>
Reference in New Issue View Git Blame Copy Permalink