0 and RHD_DATE>='".$_SESSION['site401mhis_inDate']." 00:00:00' and RHD_DATE<='".$_SESSION['site401mhis_inDate']." 23:59:59' order by RHD_DATE"); if($wynik)while ($r = mysql_fetch_array($wynik)) { if ($r["RHD_PP_VAL"]>0 && $r["RHD_Q_VAL"]>0) { $well_working_params[] = array( 'p1' => $r["RHD_P1_VAL"], 'p2' => $r["RHD_P2_VAL"], 'pp' => $r["RHD_PP_VAL"], 'hh' => $r["RHD_HH_VAL"], 'hd' => $r["RHD_HD_VAL"], 'Q' => $r["RHD_Q_VAL"], 'I' => $r["RHD_I_VAL"], 'U' => $r["RHD_U_VAL"], 'Pe' => $r["RHD_PE_VAL"], 'cos' => $r["RHD_COS_VAL"], 'dia' => $r["RHD_DGN_VAL"], 'date' => $r["RHD_DATE"], 'time' => $r["RHD_WORK_TIME_VAL"] ); } } unset($_SESSION['site401mhis_working_params']); $_SESSION['site401mhis_working_params']=$well_working_params; } //wyświetla info o agregacie dla danej daty $wynik = mysql_query("select WLE_PUMP_NAME,WLE_PUMP_NO,WLE_ENG_NAME,WLE_ENG_NO,WLE_DATE_FROM,WLE_DATE_TO,WLE_REASON from seg_wells_exchanged where WLE_WLL_ID=".$_SESSION['well_details']['wellID']." and WLE_DATE_FROM<'".$_SESSION['site401mhis_inDate']."' and (WLE_DATE_TO>'".$_SESSION['site401mhis_inDate']."' or WLE_DATE_TO is null)"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $_SESSION['site401mhis_exch_info'] = array( 'exch_pup' => $r["WLE_PUMP_NAME"], 'exch_pup_no' => $r["WLE_PUMP_NO"], 'exch_eng' => $r["WLE_ENG_NAME"], 'exch_eng_no' => $r["WLE_ENG_NO"], 'exch_date_from' => $r["WLE_DATE_FROM"], 'exch_date_to' => $r["WLE_DATE_TO"], 'exch_date_reason' => $r["WLE_REASON"], ); unset($testIDArray); $testIDArray = sqlGetResAsArray("select * from tst_tests where TST_ID=(select max(TST_ID) from seg_dev_resources,seg_pumps left join tst_tests on (TST_PUP_ID=PUP_ID and TST_PUP_SN_NO='".$r["WLE_PUMP_NO"]."' and TST_ENG_SN_NO='".$r["WLE_ENG_NO"]."' and TST_AUDIT_CD<='".$r["WLE_DATE_FROM"]."') where DRS_DEV_TYPE=10 and PUP_ID=DRS_DEV_ID and PUP_NAME='".$r["WLE_PUMP_NAME"]."' and DRS_SN_NUMBER='".$r["WLE_PUMP_NO"]."')"); } if (!empty($_SESSION['site401mhis_working_params']) && count($_SESSION['site401mhis_working_params'])<1) { /* $sugTime = sqlStringValue("select SUBSTRING(max(RHD_DATE),1,10) M_DATE from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_PP_VAL>0 and RHD_Q_VAL>0 and RHD_DATE like '".substr($_SESSION['site401mhis_inDate'],0,7)."%'","M_DATE"); if (strlen($sugTime)<10) $sugTime = sqlStringValue("select SUBSTRING(max(RHD_DATE),1,10) M_DATE from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_PP_VAL>0 and RHD_Q_VAL>0 and RHD_DATE like '".substr($_SESSION['site401mhis_inDate'],0,4)."%'","M_DATE"); if (strlen($sugTime)<10) $sugTime = sqlStringValue("select SUBSTRING(max(RHD_DATE),1,10) M_DATE from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_PP_VAL>0 and RHD_Q_VAL>0 and RHD_DATE like '".substr($_SESSION['site401mhis_inDate'],0,3)."%'","M_DATE"); if (strlen($sugTime)<10) $sugTime = sqlStringValue("select SUBSTRING(max(RHD_DATE),1,10) M_DATE from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID']." and RHD_PP_VAL>0 and RHD_Q_VAL>0 and RHD_DATE like '".substr($_SESSION['site401mhis_inDate'],0,2)."%'","M_DATE"); //jeśli nie znalazł to podstawia max datę if (strlen($sugTime)<10) $sugTime=sqlStringValue("select SUBSTRING(max(RHD_DATE),1,10) DT from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID'],"DT"); */ echo(''); //$_SESSION['site401mhis_inDate']=$sugTime; } if (!empty($_GET['p'])) $rowCount=$_GET['p']; else $rowCount=count($_SESSION['site401mhis_working_params'])-1; ?>
Studnia
Wybierz datę i godzinę
Data oceny ' SIZE='10'>
Godzina oceny ".substr($_SESSION['site401mhis_working_params'][$rowCount]['date'],11,8).""; ?>    
Data zabudowy
Data wybudowy
Powód wymiany
0) { if ($testIDArray[0]['TST_ID']>0) { $wynik = mysql_query("select TSD_VAL_04/60 TSD_VAL_04,TSD_VAL_08,TSD_VAL_14,TSD_VAL_18 from tst_tests left join tst_test_details on TSD_TST_ID=TST_ID where TST_ID=".$testIDArray[0]['TST_ID']." 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"] ); } $HPSparam = (float) getPolynomialHp_second($testArray,($_SESSION['site401mhis_working_params'][$rowCount]['Q'])/60); } // =============================================================== // $Evaluation4_q = wellEvaluation4_q($_SESSION['well_details']['QnVal'], $_SESSION['site401mhis_working_params'][$rowCount]['Q']); // =============================================================== // //$resHP = (setPumpHparameterForQ($_SESSION['well_details']['pumpID'],$_SESSION['site401mhis_working_params'][$rowCount]['Q'])-($_SESSION['site401mhis_working_params'][$rowCount]['pp']-$_SESSION['site401mhis_working_params'][$rowCount]['hh']))/($_SESSION['site401mhis_working_params'][$rowCount]['pp']-$_SESSION['site401mhis_working_params'][$rowCount]['hh']); //$Evaluation4_HfQ = wellEvaluation4_HfQ($resHP,$_SESSION['site401mhis_working_params'][$rowCount]['pp']); $Evaluation4_HfQ = wellEvaluation4_HfQ_new($HPSparam,$_SESSION['site401mhis_working_params'][$rowCount]['pp'],$_SESSION['site401mhis_working_params'][$rowCount]['hh']); // =============================================================== // $Evaluation4_Throt = wellEvaluation4_Throt($_SESSION['site401mhis_working_params'][$rowCount]['hd'],$_SESSION['site401mhis_working_params'][$rowCount]['p1'],$_SESSION['site401mhis_working_params'][$rowCount]['p2']); // =============================================================== // $Evaluation4_LineLoss = wellEvaluation4_LineLoss($_SESSION['site401mhis_working_params'][$rowCount]['p1'],$_SESSION['site401mhis_working_params'][$rowCount]['pp'],$_SESSION['well_details']['LpVal'],$_SESSION['well_details']['DrVal']); // =============================================================== // // =============================================================== // if (empty($_SESSION['site401mhis_working_params'][$rowCount]['Pe'])) $_SESSION['site401mhis_working_params'][$rowCount]['Pe']=1; $resETA = ($_SESSION['site401mhis_working_params'][$rowCount]['Q']*($_SESSION['site401mhis_working_params'][$rowCount]['hd']+$_SESSION['site401mhis_working_params'][$rowCount]['p2']))/(367*$_SESSION['site401mhis_working_params'][$rowCount]['Pe']); $RedYellowParam = setRedYellowLimes($_SESSION['well_details']['QnVal']); $YellowGreenParam = setYellowGreenLimes($_SESSION['well_details']['QnVal']); // =============================================================== // $fileName="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_chart_site401mhis_01.png"; if (file_exists( $fileName0)) unlink($fileName0); include("./pChart/pData.class.php"); include("./pChart/pDraw.class.php"); include("./pChart/pImage.class.php"); include("./pChart/pScatter.class.php"); //pumpImageStatus($fileName, $RedYellowParam, $YellowGreenParam, $resETA); pumpImageEnergy($fileName, $RedYellowParam, $YellowGreenParam, $resETA); if ($_SESSION['site401mhis_working_params'][$rowCount]['dia']==1) { $ramka = 'yellow_value'; $opis = 'Ostrzeżenie'; } elseif ($_SESSION['site401mhis_working_params'][$rowCount]['dia']==2) { $ramka = 'orange_value'; $opis = 'Działanie niepoprawne'; } else { $ramka = 'green_value'; $opis = 'Działanie poprawne'; } } ?>
Oceny pracy układu pompowego
Ocena energochłonności
Wskazanie
"; else echo""; echo" "; } ?>
Data HD [m] Q [m3/min] p1 [m] p2 [m] I [A] U [V] Pe [kW] cos(φ)
".$_SESSION['site401mhis_working_params'][$i]['date']." ".$_SESSION['site401mhis_working_params'][$i]['hd']." ".round($_SESSION['site401mhis_working_params'][$i]['Q']/60,3)." ".$_SESSION['site401mhis_working_params'][$i]['p1']." ".$_SESSION['site401mhis_working_params'][$i]['p2']." ".$_SESSION['site401mhis_working_params'][$i]['I']." ".$_SESSION['site401mhis_working_params'][$i]['U']." ".$_SESSION['site401mhis_working_params'][$i]['Pe']." ".$_SESSION['site401mhis_working_params'][$i]['cos']."
'>