=cdt($maxDate)) $dateTo = $maxDate; else $dateTo = $_POST['post_dt_to']; echo'

Okres rozliczeniowy od: '.$_POST['post_dt_from'].' do: '.$dateTo.'

'; 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;$i0) { 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($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'

Przerywam i wychodzę!


'; break; } } } $newVm3_2021 = round($newVm3_2021,0); $newWater = $newVm3_2021/($newTime/3600); 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($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""; echo""; echo'
Lp. Studnia Agregat pompowy
[pompa / silnik]		 Moc silnika
[kW]		 Czas pracy
[godz:min]		 Ilość wypompowanej wody
[m3]		 Wydajność średnia
[m3/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($newTime/3600,0)." ".$newVm3_2021." ".round($newWater/60,3)." ".$valHst0." ".$valHd." ".$valTw." ".$valClor." ".setDicName($rep002Array[$i]['WLL_CAT_DIC_ID'])."
Razem bariera: ".$bariera." ".round(getFloatValue($bariera_woda),0)."
Razem wszystkie studnie: ".round(getFloatValue($calosc_woda),0)."
'; } // ================================================================================================================================== // 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; $i0) $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''; } } // ================================================================================================================================== // 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;$i10 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 Zrzut [m3/min] [m3/h] '; // 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" SYSTEM "; // 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 ".$mainArray01[$i01]['WWD_NAME']." ".$mainArray01[$i01]['Q_MIN']." ".($mainArray01[$i01]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     SYSTEM ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN'] * 60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN'] * 60)." "; // 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 ".$rivArray[$r]['WWD_NAME']." ".$rivArray[$r]['Q_MIN']." ".($rivArray[$r]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     ".$parent." ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN'] * 60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN'] * 60)." "; // 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 ".$rivArray[$r]['WWD_NAME']." ".$rivArray[$r]['Q_MIN']." ".($rivArray[$r]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     ".$parent." ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN'] * 60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN'] * 60)." "; // 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 ".$rivArray[$r]['WWD_NAME']." ".$rivArray[$r]['Q_MIN']." ".($rivArray[$r]['Q_MIN']*60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     ".$parent." ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN']*60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN'] * 60)." "; // 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 ".$rivArray[$r]['WWD_NAME']." ".$rivArray[$r]['Q_MIN']." ".($rivArray[$r]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow*60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     ".$parent." ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN'] * 60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN']*60)." "; // 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 ".$rivArray[$r]['WWD_NAME']." ".$rivArray[$r]['Q_MIN']." ".($rivArray[$r]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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 ".$tmpArray[$i]['WWD_NAME']." — — — ⟩     ".$parent." ".$tmpArray[$i]['Q_MIN']." ".($tmpArray[$i]['Q_MIN']*60)." "; // 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 ".$wellArray[$w]['WLL_BARIERA']." ".$wellArray[$w]['WLL_NAME']." ".$wellArray[$w]['Q_MIN']." ".($wellArray[$w]['Q_MIN'] * 60)." "; // 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" Łącznie ".$licz_roow." ".($licz_roow * 60)." "; // 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''; 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' '; $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'; if ($bariera!=$wellFullArray[$i]['WLL_BARIERA']) { echo" "; $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'
'; 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" "; $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" "; echo'
Bariera Ilość studni z agregatem Ilość studni wyłączonych Moc znamionowa [kW] Moc pobierana [kW] Wydajność Q [m3/min]
".$bariera." ".$licznik." ".($licznik-$ile_pracuje)." ".$moc_znamionowa." ".$moc_pobierana." ".$wydajnosc."
".$bariera." ".$licznik." ".($licznik-$ile_pracuje)." ".$moc_znamionowa." ".$moc_pobierana." ".$wydajnosc."
Razem ".$licznik_sum." ".$ile_pracuje_sum." ".$moc_znamionowa_sum." ".$moc_pobierana_sum." ".$wydajnosc_sum."
'; 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'


Wykaz studni wyłączonych z zabudowanymi agregatami

'; for($i=0; $i "; $res[]=array( 'bariera' => $wellOff[$i]['bariera'], 'studnia' => $wellOff[$i]['studnia'], 'pompa' => $wellOff[$i]['pompa'], 'silnik' => $wellOff[$i]['silnik'], 'powod' => $wellOff[$i]['powod'] ); } echo'
Lp. Bariera Studnia Typ pompy Typ silnika Powód wyłączenia
".($i+1)." ".$wellOff[$i]['bariera']." ".$wellOff[$i]['studnia']." ".$wellOff[$i]['pompa']." ".$wellOff[$i]['silnik']." ".$wellOff[$i]['powod']."
'; 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' '; for ($i=0; $i"; $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" "; $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"; $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" "; $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'
Studnia Typ pompy Numer pompy Typ silnika Numer silnika Postój od Postój do Powód wyłączenia Kategoria
Bariera: ".$rep005Array_01[$i]['WLL_BARIERA']."
".$lp.". ".$rep005Array_01[$i]['WLL_NAME']." ".$rep005Array_01[$i]['WLE_PUMP_NAME']." ".$rep005Array_01[$i]['WLE_PUMP_NO']." ".$rep005Array_01[$i]['WLE_ENG_NAME']." ".$rep005Array_01[$i]['WLE_ENG_NO']." ".$rep005Array_02[0]['WST_DATE']." ".$rep005Array_ON[0]['DRD_AUDIT_DATE']." ".setDicName($rep005Array_OFF[0]['DRD_DESCRIPTION'])." ".setDicName($rep005Array_01[$i]['WLL_CAT_DIC_ID'])."
Bariera: ".$rep005Array_01[$i1]['WLL_BARIERA']."
".$lp.". ".$rep005Array_01[$i1]['WLL_NAME']." ".$rep005Array_01[$i1]['WLE_PUMP_NAME']." ".$rep005Array_01[$i1]['WLE_PUMP_NO']." ".$rep005Array_01[$i1]['WLE_ENG_NAME']." ".$rep005Array_01[$i1]['WLE_ENG_NO']." ".$rep005Array_02[0]['DRD_AUDIT_DATE']." ".$rep005Array_03[0]['DRD_AUDIT_DATE']." ".setDicName($rep005Array_02[0]['DRD_DESCRIPTION'])." ".setDicName($rep005Array_01[$i1]['WLL_CAT_DIC_ID'])."
'; 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' '; for($i=0; $i0) $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" "; $_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'
Bariera Nazwa Gł. rurki [m] Rzędna aktualna [m npm] Poziom wodonośny HST [m] Data pomiaru Status Typ Kategoria
".($i+1)." ".$rep006Array[$i]['SRP_BARIERA']." ".$rep006Array[$i]['SRP_NAME']." ".getGlebokoscAct($rep006Array[$i]['DRS_ID'])." ".$rep006Array[$i]['OHC_RZEDNA_TERENU_ACT']." ".$rep006Array[$i]['OHC_POZIOM_WODONOS']." ".$reArray[0]['DRD_VALUE']." ".substr($reArray[0]['DRD_AUDIT_DATE'],0,10)." ".setDicName($rep006Array[$i]['DRS_RESOURCES_DIC_ID'])." ".$_POST['post_typ']." ".setDicName($rep006Array[$i]['SRP_MCF_ID'])."
'; } // ================================================================================================================================== // 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' '; $licznik=1; $bariera = ""; for($i=0; $i0)"); 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""; $bariera=$rep007_his_Array_01[$i]['WLL_BARIERA']; } echo" "; $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'
Studnia Agregat pompowy Moc Pe [kW] Czas pracy [h] Jednostkowe zużycie energii [Wh/m3/m] HST0 [m] HD [m] Wydajność Q [m3/min] Ciśnienie p1 [m] Ciśnienie p2 [m] Temp. wody [oC] Stężenie chlorków Cl [mg/l] Kategoria SPM
Bariera: ".$rep007_his_Array_01[$i]['WLL_BARIERA']."
".$licznik." ".$rep007_his_Array_01[$i]['WLL_NAME']." ".$rep007_his_Array_01[$i]['WLE_PUMP_NAME']." / ".$rep007_his_Array_01[$i]['WLE_ENG_NAME']." ".$wellParamArray[0]['RHD_PE_VAL']." ".$wellParamArray[0]['RHD_WORK_TIME_VAL']." ".$engVal[0]['UEC_ENG_VAL']." ".$hstVal[0]['MIR_HST_VAL']." ".$wellParamArray[0]['RHD_HD_VAL']." ".round($wellParamArray[0]['RHD_Q_VAL']/60,3)." ".$wellParamArray[0]['RHD_P1_VAL']." ".$wellParamArray[0]['RHD_P2_VAL']." ".$wellParamArray[0]['RHD_WTEMP_VAL']." ".$clVal[0]['CLO_CLO_VAL']." ".setDicName($rep007_his_Array_01[$i]['WLL_CAT_DIC_ID'])."
'; } // ================================================================================================================================== // 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' '; //$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; $i8) { //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" "; 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; $i8) { 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" "; 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'
Lp. Pompa Numer Silnik Numer Data zabudowy Głębokość zabudowy [m] Średnica rurociągu [mm] Ostatnie zw. statyczne [m] Ostatnie zw. dynamiczne [m] Czas pracy [h] Ilość wypompowanej wody [m3] Średnia wydajność [m3/min] Rzędna położenia studni [m n.p.m.] Data wybudowy Powód wymiany
".($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']."
".($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']."
'; } // ================================================================================================================================== // 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' '; for($i=0; $i0 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" "; 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'
Lp Typ pompy Numer pompy Typ silnika Numer silnika Studnia Gł.zab.[m] Średnica rurociągu
[mm]		 Średnica DST
[mm]		 Hst [m] Hd [m] Q ostatnie
[m³/min]		 Q średnie
[m³/min]		 Data uruchomienia Czas pracy [h] Kategoria
".($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'])."
'; // } // ================================================================================================================================== // 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' '; for($i=0; $i0) $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" "; 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'
Bariera Studnia Typ pompy Numer pompy Typ silnika Numer silnika Głębokość LP [m] Data uruchomienia Data zatopienia Powód
".$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']."
'; } // ================================================================================================================================== // 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' '; $bariera = ""; for($i=0; $i"; $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" "; 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'
Lp Studnia Typ obiektu Data przyjęcia Współrzędne Rzędna wiercenia [m n.p.m.] Rzędna aktualna [m n.p.m.] Głębokość aktualna [m] Lokalizacja Uwagi Kategoria
Bariera: ".$rep011_his_Array_01[$i]['WLL_BARIERA']."
".($i+1)." ".$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'])."
'; } // ================================================================================================================================== // 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' '; $bariera = ""; for($i=0; $i"; $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" "; 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'
Lp Piezometr Typ obiektu Data przyjęcia Współrzędne Rzędna wiercenia [m n.p.m.] Rzędna aktualna [m n.p.m.] Głębokość aktualna [m] Lokalizacja Uwagi Sterowanie
Bariera: ".$rep012_his_Array_01[$i]['SRP_BARIERA']."
".($i+1)." ".$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'])."
'; } // ================================================================================================================================== // 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' '; $licznik=1; for($i=0; $i8) { 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" "; 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; $i8) { 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" "; 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'
Studnia Nr wymiany Typ pompy Numer pompy Typ silnika Numer silnika Moc [kW] Data zabudowy Data wybudowy Czas pracy [h] Powód wymiany Głębokość zabudowy [m] Średnica rurociągu [mm] Kategoria
".$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'])."
".$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']." ".setDicName($rep013_his_Array_01[$i]['WLL_CAT_DIC_ID'])."
'; } // ================================================================================================================================== // 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' '; $bariera=""; for($i=0; $i"; $bariera=$rep014_his_Array_01[$i]['WLL_BARIERA']; } echo" "; 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'
Lp. Studnia Typ pompy Numer pompy Typ silnika Numer silnika Gł.zab. Lp [m] Data uruchomienia Data wypięcia Powód wypięcia Kategoria
Bariera: ".$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'])."
'; } // ================================================================================================================================== // 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' '; unset($tempTb); unset($calbeArray); unset($cableCounter); for ($i=0; $i "; 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'
Lp. Bariera Studnia Typ silnika Numer silnika Napięcie [V] Wydana - ZLECENIA w SoftSPM Zabudowana Kategoria
Data zlecenia Typ kabla Długość [m] Data zabudowy Długość [m] Ciezar [kg]
".($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]."
'; echo'

Podsumowanie

'; echo' '; //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 '; 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' '; fwrite($myfile1, $typName."|" .$typVal."|" .$typDlZabVal."|" .$typCiZabVal."\r\n"); fclose($myfile1); echo'
Typ kabla Suma [m] (Długość - zlecenie) Suma [m] (Długość - zabudowa) Suma [kg] (Ciężar - zabudowa)
'.$typName.' '.$typVal.' '.$typDlZabVal.' '.$typCiZabVal.'
'.$typName.' '.$typVal.' '.$typDlZabVal.' '.$typCiZabVal.'
'; } // ================================================================================================================================== // 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' '; unset($sumsArray); for ($i=0; $i "; 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'
Bariera Średnica kol. tłocznego [mm] Suma długość kol. tłocznych [m]
".$rep016_his_Array_01[$i]['WLL_BARIERA']." ".$rep016_his_Array_01[$i]['WLE_DR']." ".$rep016_his_Array_01[$i]['WLE_ZP']."
'; echo'

'; echo' '; for ($i=0; $i "; 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'
RAZEM Średnica kol. tłocznego [mm] Suma długość kol. tłocznych [m]
".$rep016_his_Array_02[$i]['WLE_DR']." ".$rep016_his_Array_02[$i]['ZP']."
'; 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' '; for ($i=0; $i "; 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'
Lp. Data HST0 [m] HST [m] HD [m] Q [m3/min] p1 [m] p2 [m] I [A] U [V] Pe [kW] cos(φ) Czas pracy [h] Ilość wody [m3]
".($i+1)." ".$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']."
'; } // ================================================================================================================================== // 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' '; 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 "; 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'
Nazwa Średnica [mm] Długość [m] / Ciśnienie [bar] Producent Całkowita ilość Dostępna ilość
".$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)."
'; echo"

"; for ($i=0; $iLista powiązanych obiektów: ".$tmp307Array[$i]['EQU_NAME'].""; 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' '; fwrite($myfile,"#GOODS#|Lp.|Nazwa|Przypisany do|Ilość\r\n"); for ($j=0; $j "; fwrite($myfile,"#G#|".($j+1)."|" .$tmp307SubArray[$j]['EQU_NAME']."|" .$obNAME."|" .$tmp307SubArray[$j]['SDE_VALUE']."\r\n"); } echo'
Lp. Nazwa Przypisany do Ilość
".($j+1)." ".$tmp307SubArray[$j]['EQU_NAME']." ".$obNAME." ".$tmp307SubArray[$j]['SDE_VALUE']."
'; echo"

"; } 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' '; fwrite($myfile,"#HEAD#|Nazwa|Producent|Ilość\r\n"); for ($i=0; $i "; fwrite($myfile, date('Y-m-d')."|" .$tmp308Array[$i]['EQU_NAME']."|" .$tmp308Array[$i]['MCF_NAME']."|" .$tmp308Array[$i]['ILOSC']."\r\n"); } echo'
Nazwa Producent Ilość
".$tmp308Array[$i]['EQU_NAME']." ".$tmp308Array[$i]['MCF_NAME']." ".$tmp308Array[$i]['ILOSC']."
'; echo"

"; for ($i=0; $iLista powiązanych obiektów: ".$tmp308Array[$i]['EQU_NAME'].""; 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' '; fwrite($myfile,"#GOODS#|Lp.|Nazwa|Nr seryjny|Przypisany do|Status\r\n"); for ($j=0; $j "; 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'
Lp. Nazwa Nr seryjny Przypisany do Status
".($j+1)." ".$tmp308Array[$i]['EQU_NAME']." ".$tmp308SubArray[$j]['DRS_SN_NUMBER']." ".$obNAME." ".setDicName($tmp308SubArray[$j]['DRS_RESOURCES_DIC_ID'])."
'; echo"

"; } 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: '.$lasUpPup[0]['PAK'].', zaczytane dnia '.$lasUpPup[0]['PAD'].'
'; $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: '.$lasUpEng[0]['EAK'].', zaczytane dnia '.$lasUpEng[0]['EAD'].'
'; 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: '.$lasUpCab[0]['CAK'].', zaczytane dnia '.$lasUpCab[0]['CAD'].'

'; } else { echo'Pliki ze Stacji Prób zostały wgrane na serwer i czekają na synchronizację:
'; unset($lasUpPup); $lasUpPup = sqlGetResAsArray("select max(stp_stapo_data_akt) PAK from stp_stapo"); echo'Dane dla stanów pomp do synchronizacji z: '.$lasUpPup[0]['PAK'].'
'; $lasUpEng = sqlGetResAsArray("select max(stp_stamot_data_akt) EAK from stp_stamot"); echo'Dane dla stanów silników do synchronizacji z: '.$lasUpEng[0]['EAK'].'
'; 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: '.$lasUpCab[0]['CAK'].'

'; } echo' '; for ($i=0; $i "; } echo'
Lp. Data plików DATA Data synchronizacji
".($i+1)." ".$rep023Array[$i]['SPU_UPLOAD_SP_FILE']." ".$rep023Array[$i]['SPU_MADE_DB_PROC']."
'; } // ================================================================================================================================== mysql_close($con); ?>