"; unset($wellArray); $wellArray = sqlGetResAsArray("select WLL_ID,WLL_NAME,DRS_ID,RHD_ID,RHD_DATE,RHD_Q_VAL,RHD_PE_VAL from seg_wells,seg_dev_resources left join rep_his_data_everyday on RHD_DRS_ID=DRS_ID where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and WLL_CAT_DIC_ID=20 and DRS_STATUS_DIC_ID=3 and RHD_Q_VAL>0 and (RHD_PE_VAL is null or RHD_PE_VAL<=0)"); for($i=0; $i'".$wellArray[$i]['RHD_DATE']."' or WLE_DATE_TO is null) limit 1"); $testID=0; $testID = (int) sqlStringValue("select max(stp_protokoly_nr) TID from stp_protokoly where stp_protokoly_pomp='".$agregatArray[0]['WLE_PUMP_NAME']."' and stp_protokoly_pomp_nr='".$agregatArray[0]['WLE_PUMP_NO']."' and stp_protokoly_sil='".$agregatArray[0]['WLE_ENG_NAME']."' and stp_protokoly_sil_nr='".$agregatArray[0]['WLE_ENG_NO']."'", "TID"); unset($testArray); if ($testID>0) { $wynik = mysql_query("select TSD_VAL_04,TSD_VAL_08,TSD_VAL_14,TSD_VAL_18 from tst_test_details where TSD_TST_ID=".$testID." order by TSD_MSR_STEP"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $testArray[] = array( 'q' => (float) $r["TSD_VAL_04"], 'h' => (float) $r["TSD_VAL_08"], 'p' => (float) $r["TSD_VAL_14"], 'n' => (float) $r["TSD_VAL_18"] ); } $peVal=0; $peVal = (float) getPolynomialPe($testArray,($wellArray[$i]['RHD_Q_VAL'])); //moc ze stacji echo "Studnia [".$wellArray[$i]['RHD_ID']."]: ".$wellArray[$i]['WLL_NAME'].", nr ptóby: ".$testID.", Moc: ".getFloatValue($peVal).", Data pomiaru: ".$wellArray[$i]['RHD_DATE']."
"; if ($peVal>0 && $wellArray[$i]['RHD_ID']>0) { mysql_query("UPDATE rep_his_data_everyday SET RHD_PE_VAL=".getFloatValue($peVal)." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']); } } } echo "

"; echo "Drugie podejście
"; unset($wellArray); $wellArray = sqlGetResAsArray("select WLL_ID,WLL_NAME,DRS_ID,RHD_ID,RHD_DATE,RHD_Q_VAL,RHD_PE_VAL from seg_wells,seg_dev_resources left join rep_his_data_everyday on RHD_DRS_ID=DRS_ID where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and WLL_CAT_DIC_ID=20 and DRS_STATUS_DIC_ID=3 and RHD_Q_VAL>0 and (RHD_PE_VAL is null or RHD_PE_VAL<=0)"); for($i=0; $i'".$wellArray[$i]['RHD_DATE']."' or WLE_DATE_TO is null) limit 1"); $testID=0; $testID = (int) sqlStringValue("select max(stp_protokoly_nr) TID from stp_protokoly where stp_protokoly_pomp='".$agregatArray[0]['WLE_PUMP_NAME']."' and stp_protokoly_pomp_nr='".$agregatArray[0]['WLE_PUMP_NO']."' and stp_protokoly_sil='".$agregatArray[0]['WLE_ENG_NAME']."' and stp_protokoly_sil_nr='".$agregatArray[0]['WLE_ENG_NO']."'", "TID"); unset($testArray); if ($testID>0) { $wynik = mysql_query("select round(REPLACE(stp_protdata_q,',','.'),2) TSD_VAL_04,round(REPLACE(stp_protdata_h,',','.'),2) TSD_VAL_08,round(REPLACE(stp_protdata_p1,',','.'),2) TSD_VAL_14,round(REPLACE(stp_protdata_pp,',','.')/REPLACE(stp_protdata_p1,',','.'),2) TSD_VAL_18 from stp_protdata where stp_protdata_nr_prot=".$testID." order by stp_protdata_q"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $testArray[] = array( 'q' => (float) $r["TSD_VAL_04"], 'h' => (float) $r["TSD_VAL_08"], 'p' => (float) $r["TSD_VAL_14"], 'n' => (float) $r["TSD_VAL_18"] ); } $peVal=0; $peVal = (float) getPolynomialPe($testArray,($wellArray[$i]['RHD_Q_VAL'])); //moc ze stacji echo "Studnia [".$wellArray[$i]['RHD_ID']."]: ".$wellArray[$i]['WLL_NAME'].", nr ptóby: ".$testID.", Moc: ".getFloatValue($peVal).", Data pomiaru: ".$wellArray[$i]['RHD_DATE']."
"; if ($peVal>0 && $wellArray[$i]['RHD_ID']>0) { mysql_query("UPDATE rep_his_data_everyday SET RHD_PE_VAL=".getFloatValue($peVal)." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']); } } } ?>