'; ?> ='".$_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_".$rap_timestmp."_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_".$rap_timestmp."_1"); for($i=0; $i Zrzut [m³/min] [m³/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_".$rap_timestmp."_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']; } echo''; if (count($mainArray01)) mysql_query("INSERT INTO softspm.rep_zrzut_wody SET RZW_KRASOWKA='".$mainArray01[0]['Q_MIN']."',RZW_DEPARTMENT='".$_POST['dep']."',RZW_AUDIT_USR='JOB',RZW_AUDIT_DATE='".$_POST['post_date']."'"); else mysql_query("INSERT INTO softspm.rep_zrzut_wody SET RZW_WIDAWKA='".$mainArray01[0]['Q_MIN']."',RZW_KRASOWKA='".$mainArray01[1]['Q_MIN']."',RZW_DEPARTMENT='".$_POST['dep']."',RZW_AUDIT_USR='JOB',RZW_AUDIT_DATE='".$_POST['post_date']."'"); //mysql_query("UPDATE softspm.rep_zrzut_wody SET RZW_KRASOWKA=RZW_WIDAWKA, RZW_WIDAWKA=NULL WHERE RZW_ID IN(SELECT RZW_ID from softspm.rep_zrzut_wody WHERE RZW_WIDAWKA>0 AND (RZW_KRASOWKA=0 OR RZW_KRASOWKA IS NULL))"); mysql_query("drop temporary table if exists softspm_rep.rap_".$rap_timestmp."_1"); mysql_query("drop temporary table if exists softspm_rep.rap_".$rap_timestmp."_2"); // ================================================================================================================================== mysql_close($con); ?>