1) { $polynomial = new zc_math_polynomial($tbArray); $polynomial->calculate_coefficients(); $resVal = $polynomial->get_y($inParam); } else $resVal=0; return round($resVal,2); } function getPolyPe($dataArray,$inParam) { unset($resVal);unset($tbArray); for($i=0; $i1) { $polynomial = new zc_math_polynomial($tbArray); $polynomial->calculate_coefficients(); $resVal = $polynomial->get_y($inParam); } else $resVal=0; return round($resVal,2); } echo"START: ".date('Y-m-d H:i:m')."
"; $listWellArray = sqlGetResAsArray("select DRS_ID,WLL_ID,WLL_NAME,getLastValue(507,DRS_ID) W_STAT,WLL_CAT_DIC_ID,RWL_PUP_DRS_ID,RWL_ENG_DRS_ID from seg_dev_resources,seg_well_pump_eng_rel left join seg_wells on RWL_WLL_ID=WLL_ID where DRS_DEV_ID=RWL_WLL_ID and DRS_DEV_TYPE=12"); for ($i=0; $i0) { $wynik = mysql_query("select TSD_VAL_04,TSD_VAL_08,TSD_VAL_14 from tst_tests left join tst_test_details on TSD_TST_ID=TST_ID where TST_ID=".$tstID." order by TSD_MSR_STEP"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $probaArray[] = array( 'q' => (float) $r["TSD_VAL_04"], 'h' => (float) $r["TSD_VAL_08"], 'p' => (float) $r["TSD_VAL_14"] ); } $podSP = (float) getPolyHp($probaArray,$qualDataArray[0]['SQD_VAL_Q']); $mocSP = (float) getPolyPe($probaArray,$qualDataArray[0]['SQD_VAL_Q']); } if (!empty($qualDataArray) && ( $qualDataArray[0]['SQD_FLG_Q']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_P1']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_P2']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_PP']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_HH']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_HD']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_I']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_U']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_CF']!='CORRECT' // || $qualDataArray[0]['SQD_FLG_PE']!='CORRECT' || $qualDataArray[0]['SQD_VAL_Q']<=0 // || (($qualDataArray[0]['SQD_VAL_P2']-1.5)>$qualDataArray[0]['SQD_VAL_P1']) // || $qualDataArray[0]['SQD_VAL_PP']<=0 // || $qualDataArray[0]['SQD_VAL_HH']<=0 // || $qualDataArray[0]['SQD_VAL_HD']<=0 // || $qualDataArray[0]['SQD_VAL_I']<=0 // || $qualDataArray[0]['SQD_VAL_U']<=0 // || $qualDataArray[0]['SQD_VAL_CF']<=0 // || $qualDataArray[0]['SQD_VAL_CF']>=1 // || $qualDataArray[0]['SQD_VAL_PE']<=0 )) { $ocena = "NN"; } // elseif ($tstID>0 && $podSP>0 && $mocSP>0 && ($qualDataArray[0]['SQD_VAL_PE'] < (0.83*$mocSP) || $qualDataArray[0]['SQD_VAL_PE'] > (1.25*$mocSP) || ($qualDataArray[0]['SQD_VAL_PP'] - $qualDataArray[0]['SQD_VAL_HH']) > (1.08*$podSP))) // { // $ocena = "NN"; // } else { if ($qParam>0 && $PEparam>0) { $resETA = ($qParam*($resHD+$P2param))/(367*$PEparam); $RedYellowParam = setRedYellowLimes($pupArray[0]['PUP_Q_N']); $YellowGreenParam = setYellowGreenLimes($pupArray[0]['PUP_Q_N']); if ($resETA<=$RedYellowParam) $ocena = "R"; elseif ($RedYellowParam<$resETA && $resETA<=$YellowGreenParam) $ocena = "Y"; elseif ($resETA>$YellowGreenParam) $ocena = "G"; } else $ocena = "NN"; } } else $ocena = "NN"; } else $ocena = "NN"; //jeśli istnieje - aktualizuje if (sqlValue("select count(*) from rep_soap_well_energy where SWE_DRS_ID=".$listWellArray[$i]['DRS_ID'])>0) { mysql_query("UPDATE rep_soap_well_energy SET SWE_VALUE='".$ocena."',SWE_WORK_STATUS='".$listWellArray[$i]['W_STAT']."',SWE_AUDIT_USR='cron',SWE_AUDIT_DATE=now() WHERE SWE_DRS_ID=".$listWellArray[$i]['DRS_ID']); } //dodaje nowy else { mysql_query("insert into rep_soap_well_energy SET SWE_DRS_ID=".$listWellArray[$i]['DRS_ID'].",SWE_WELL_ID=".$listWellArray[$i]['WLL_ID'].",SWE_NAME='".$listWellArray[$i]['WLL_NAME']."',SWE_VALUE='".$ocena."',SWE_WORK_STATUS='".$listWellArray[$i]['W_STAT']."',SWE_AUDIT_USR='cron',SWE_AUDIT_DATE=now()"); } } echo"Zaktualizowano: ".count($listWellArray)."
"; echo"STOP: ".date('Y-m-d H:i:m')."
"; unset($listWellArray); //rep_soap_well_energy mysql_close($polacz); ?>