Wykaz pracy studni

Za okres od: do:

'".date('Y-m')."-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 = date('Y-m-d H:i:s'); 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>='".$rep002Array[$i]['WLE_DATE_FROM']."' 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>='".$rep002Array[$i]['WLE_DATE_FROM']."')"); $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); echo" "; $bariera_woda+= (float) $valVm3; $calosc_woda += (float) $bariera_woda; } echo""; echo""; ?>

Lp.	Studnia	Agregat pompowy [pompa / silnik]	Data zabudowy	Data wybudowy	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."							".$bariera_woda."

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