Wykaz pracy studni

Za okres od: do:

'2016-09-01') and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' order by WLL_BARIERA,WLL_NAME,WLE_DATE_TO"); //print_r($rep001Array); ?> 0) { echo""; echo""; $bariera_woda=0; } echo""; $bariera=$rep002Array[$i]['WLL_BARIERA']; $licznik_bariera++; } unset($mocSilnika); $mocSilnika = sqlStringValue("select ENG_POWER from seg_engines,seg_dev_resources where DRS_DEV_ID=ENG_ID and DRS_DEV_TYPE=11 and ENG_NAME='".$rep002Array[$i]['WLE_ENG_NAME']."' and DRS_SN_NUMBER='".$rep002Array[$i]['WLE_ENG_NO']."'", "ENG_POWER"); //czas pracy unset($minTime);unset($maxTime);unset($valTime);unset($finDate); unset($valTime);unset($valHst0);unset($valHdTw);unset($valClor); unset($valVm3); unset($minVpup); unset($maxVpup); if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8) $finDate = $rep002Array[$i]['WLE_DATE_TO']; else $finDate = '2016-09-30 23:59:59'; // sprawdza dla zwierciadła statyczniego warunek na daty unset($hst0Date); if (cdt($rep002Array[$i]['WLE_DATE_FROM'])>cdt('2016-10-01 00:00:00')) $hst0Date = $rep002Array[$i]['WLE_DATE_FROM']; else $hst0Date = '2016-10-01 00:00:00'; if (strlen($rep002Array[$i]['WLE_DATE_TO'])>8) { //) $valTmVm = sqlGetResAsArray("select (max(RHD_WORK_TIME_VAL) - min(RHD_WORK_TIME_VAL)) WRTM, (max(RHD_VM3_VAL) - min(RHD_VM3_VAL)) VM3 from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']); $valHst0 = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$hst0Date."' and DRD_AUDIT_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')"); $valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.rep_002_data_wrze where RHD_ID=(select MAX(RHD_ID) from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_HD_VAL>0 and RHD_WTEMP_VAL>0)"); $valClor = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=719 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and DRD_AUDIT_DATE<='".$rep002Array[$i]['WLE_DATE_TO']."')"); $valTime = $valTmVm[0]['WRTM']; $valVm3 = $valTmVm[0]['VM3']; } else { $valTmVm = sqlGetResAsArray("select (max(RHD_WORK_TIME_VAL) - min(RHD_WORK_TIME_VAL)) WRTM, (max(RHD_VM3_VAL) - min(RHD_VM3_VAL)) VM3 from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']); $valHst0 = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=212 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$hst0Date."')"); $valHdTw = sqlGetResAsArray("select RHD_HD_VAL,RHD_WTEMP_VAL from softspm_rep.rep_002_data_wrze where RHD_ID=(select MAX(RHD_ID) from softspm_rep.rep_002_data_wrze where RHD_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."' and RHD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and RHD_HD_VAL>0 and RHD_WTEMP_VAL>0)"); $valClor = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID = (select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=719 and DRD_DRS_ID=".$rep002Array[$i]['DRS_ID']." and DRD_AUDIT_DATE>='".$rep002Array[$i]['WLE_DATE_FROM']."')"); $valTime = $valTmVm[0]['WRTM']; $valVm3 = $valTmVm[0]['VM3']; } unset($qSred); if ($valTime>0) $qSred = (float) ($valVm3/$valTime); if ($valClor[0]['DRD_VALUE']>0) $valClor=$valClor[0]['DRD_VALUE']; else $valClor=""; echo" "; $res[]=array( 'id' => $rep002Array[$i]['DRS_ID'], 'bariera' => $rep002Array[$i]['WLL_BARIERA'], 'studnia' => $rep002Array[$i]['WLL_NAME'], 'agregat' => $rep002Array[$i]['WLE_PUMP_NAME']." / ".$rep002Array[$i]['WLE_ENG_NAME'], 'moc' => round(getFloatValue($mocSilnika),1), 'czas_pracy' => round(getFloatValue($valTime),0), 'il_wody' => getFloatValue($valVm3), 'srednia_q' => round($qSred/60,3), 'hst0' => $valHst0[0]['DRD_VALUE'], 'hd' => $valHdTw[0]['RHD_HD_VAL'], 'temp_wody' => $valHdTw[0]['RHD_WTEMP_VAL'], 'chlorki' => $valClor ); $bariera_woda+= (float) $valVm3; $calosc_woda += (float) $valVm3; } unset($_SESSION['rap002_array']); $_SESSION['rap002_array']=$res; echo""; echo""; ?>

Lp.	Studnia	Agregat pompowy [pompa / silnik]	Moc silnika [kW]	Czas pracy [h]	Ilość wypompowanej wody [m³]	Wydajność średnia [m³/min]	Zwierciadło statyczne [m]	Zwierciadło dynamiczne [m]	Temperatura wody [^oC]	Stężenie chlorków	Kategoria
Razem bariera: ".$bariera."					".round(getFloatValue($bariera_woda),0)."

Bariera: ".$rep002Array[$i]['WLL_BARIERA']."
".($i+1).".	".$rep002Array[$i]['WLL_NAME']."	".$rep002Array[$i]['WLE_PUMP_NAME']." / ".$rep002Array[$i]['WLE_ENG_NAME']."	".round(getFloatValue($mocSilnika),1)."	".round(getFloatValue($valTime),0)."	".round(getFloatValue($valVm3),0)."	".round($qSred/60,3)."	".$valHst0[0]['DRD_VALUE']."	".$valHdTw[0]['RHD_HD_VAL']."	".$valHdTw[0]['RHD_WTEMP_VAL']."	".$valClor."	".setDicName($rep002Array[$i]['WLL_CAT_DIC_ID'])."
Razem bariera: ".$bariera."					".round(getFloatValue($bariera_woda),0)."
Razem wszystkie studnie:					".round(getFloatValue($calosc_woda),0)."