'; require_once("soap.php"); $cl = new SyndisConnector("http://172.21.11.101/SyndisSpm.wsdl"); //zmienić URL na inny - ten kieruje na moj komputer //$cl->__setLocation('http://172.20.43.10:3615/'); $cl->__setLocation('http://172.21.11.101:3615/'); echo 'connected ...
'; echo 'Start: '.date("Y-m-d H:i:s").'
'; $scriptDate = date("Y-m-d H:i:s"); require_once("func.php"); require_once("dbaccess.php"); $polacz = mysql_connect($db_host, $db_user, $db_user_pass) or die ('cannot connect to db'); mysql_select_db($db_name); mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER_SET utf8_general_ci"); function update_new_record($devID, $dicID, $value,$insertDate) { $insertDate = str_replace(array('T','Z'), array(' ',''),$insertDate); $value = round($value,2); $drdID = sqlValue("select SQL_NO_CACHE max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=".$dicID." and DRD_DRS_ID=".$devID); if ($drdID>0) { mysql_query("UPDATE seg_dev_resources_det SET DRD_VALUE='".round($value,2)."',DRD_AUDIT_DATE='".$insertDate."',DRD_AUDIT_USR='SYNDIS' WHERE DRD_ID=".$drdID); // echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_ID=".$dicID, "DIC_POL_LANG")." [$dicID]: ".$value; } //echo"
"; } function isNewestData($devID,$dicID,$insertDate) { $res = false; $insertDate = str_replace(array('T','Z'), array(' ',''),$insertDate); $insertDateValue = (float) str_replace(array('-',':',' '),array('','',''),$insertDate); $lastMasureDate = sqlStringValue("select getLastMeasureDate(".$dicID.",".$devID.") MT","MT"); $lastMasureDateValue = (float) str_replace(array('-',':',' '),array('','',''),$lastMasureDate); if ($insertDateValue>$lastMasureDateValue) $res=true; return $res; } function convertData($insertDate) { unset($res); $res = str_replace(array('T','Z'), array(' ',''),$insertDate); return $res; } // pobieramy tablice studni $well_array=null; $wynik = mysql_query("select DISTINCT DRD_OBJECT_NAME from seg_dev_major_data left join seg_wells on DRD_OBJECT_NAME=WLL_NAME where DRD_OBJECT_TYPE='WELL' and DMD_WORK_STATUS='1' and WLL_HH_SCOPE>0 and WLL_CAT_DIC_ID in (18,19)"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $well_array[] = $r["DRD_OBJECT_NAME"]; } mysql_query("truncate table rep_soap_syndis_update5min_data"); //print_r($cl->GetWellsDataAsArray(array('G52','G54'))); //Pobieranie danych dla wszystkich studni $wl = $cl->GetWellsDataAsArray($well_array); for($i=0; $i"; $devID=null; $wellID=null; $vpp=null; $vhh=null; $onOffStatus=null; $wynik_W = mysql_query("select DRS_ID,WLL_ID,WLL_PP_SCOPE,WLL_HH_SCOPE,WLL_CAT_DIC_ID from seg_wells left join seg_dev_resources on WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 where WLL_NAME='".$wl["wells"][$i]["well"]["id"]."'"); if($wynik_W)while ($r_W = mysql_fetch_array($wynik_W)) { $devID = $r_W["DRS_ID"]; $wellID = $r_W["WLL_ID"]; $vpp=$r_W["WLL_PP_SCOPE"]; if ($vpp==0) $vpp=500; $vhh=$r_W["WLL_HH_SCOPE"]; $wellType = $r_W["WLL_CAT_DIC_ID"]; } //sprawdza stan załączenia pompy if (sqlStringValue("select getLastValue(507,".$devID.") ONF", "ONF")=='ON' && $wl["wells"][$i]["pumpOnOff"]["value"]==0) { //INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=1234,DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE=now(); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".$scriptDate."'"); } //sprawdza stan załączenia pompy elseif (sqlStringValue("select getLastValue(507,".$devID.") ONF", "ONF")=='OFF' && $wl["wells"][$i]["pumpOnOff"]["value"]==1) { //INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=1234,DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE=now(); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=507,DRD_VALUE='ON',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".$scriptDate."'"); } $ppValue = (float) $wl["wells"][$i]["pressureInPistonBody"]["value"]; $ppValue = (float) ($ppValue - (($wl["wells"][$i]["barometricPressuremA"]["value"]*10)/98)); $ppFlag = $wl["wells"][$i]["pressureInPistonBody"]["flag"]; unset($lpValue); $lpValue = (float) sqlStringValue("select getLastValue(240,".$devID.") HHV", "HHV"); $hhValue = (float) $lpValue - ($wl["wells"][$i]["dynamicWaterTable"]["value"]); $hhFlag = $wl["wells"][$i]["dynamicWaterTable"]["flag"]; // ============================================================================== //rejestruje dane bez względu na ich jakość - prezentacja informacji w SYNDIS //INSERT INTO rep_soap_syndis_quality_data SET SQD_DRS_ID=111,SQD_OBJECT_NAME='111',SQD_NAME='111',SQD_VAL_Q=111,SQD_FLG_Q='111',SQD_VAL_P1=111,SQD_FLG_P1='111',SQD_VAL_P2=111,SQD_FLG_P2='111',SQD_VAL_PE=111,SQD_FLG_PE='111',SQD_VAL_PP=111,SQD_FLG_PP='111',SQD_VAL_HH=111,SQD_FLG_HH='111',SQD_VAL_HD=111,SQD_FLG_HD='111',SQD_VAL_ONOFF=111,SQD_FLG_ONOFF='111',SQD_AUDIT_CD=now(); if (sqlValue("select count(*) from rep_soap_syndis_quality_data where SQD_DRS_ID=".$devID)==0) { mysql_query(" INSERT INTO rep_soap_syndis_quality_data SET SQD_DRS_ID=".$devID.", SQD_OBJECT_NAME='".$wl["wells"][$i]["well"]["id"]."', SQD_VAL_Q=".($wl["wells"][$i]["pumpEfficiency"]["value"] * 60).", SQD_FLG_Q='".$wl["wells"][$i]["pumpEfficiency"]["flag"]."', SQD_VAL_P1=".$wl["wells"][$i]["pressureBeforeThrottle"]["value"].", SQD_FLG_P1='".$wl["wells"][$i]["pressureBeforeThrottle"]["flag"]."', SQD_VAL_P2=".$wl["wells"][$i]["pressureAfterThrottle"]["value"].", SQD_FLG_P2='".$wl["wells"][$i]["pressureAfterThrottle"]["flag"]."', SQD_VAL_PE=".$wl["wells"][$i]["activePower"]["value"].", SQD_FLG_PE='".$wl["wells"][$i]["activePower"]["flag"]."', SQD_VAL_PP=".$ppValue.", SQD_FLG_PP='".$ppFlag."', SQD_VAL_HH=".$hhValue.", SQD_FLG_HH='".$hhFlag."', SQD_VAL_HD=".$wl["wells"][$i]["dynamicWaterTable"]["value"].", SQD_FLG_HD='".$wl["wells"][$i]["dynamicWaterTable"]["flag"]."', SQD_VAL_ONOFF=".$wl["wells"][$i]["pumpOnOff"]["value"].", SQD_FLG_ONOFF='".$wl["wells"][$i]["pumpOnOff"]["flag"]."', SQD_AUDIT_CD='".$scriptDate."' "); } else { mysql_query(" update rep_soap_syndis_quality_data SET SQD_OBJECT_NAME='".$wl["wells"][$i]["well"]["id"]."', SQD_VAL_Q=".($wl["wells"][$i]["pumpEfficiency"]["value"] * 60).", SQD_FLG_Q='".$wl["wells"][$i]["pumpEfficiency"]["flag"]."', SQD_VAL_P1=".$wl["wells"][$i]["pressureBeforeThrottle"]["value"].", SQD_FLG_P1='".$wl["wells"][$i]["pressureBeforeThrottle"]["flag"]."', SQD_VAL_P2=".$wl["wells"][$i]["pressureAfterThrottle"]["value"].", SQD_FLG_P2='".$wl["wells"][$i]["pressureAfterThrottle"]["flag"]."', SQD_VAL_PE=".$wl["wells"][$i]["activePower"]["value"].", SQD_FLG_PE='".$wl["wells"][$i]["activePower"]["flag"]."', SQD_VAL_PP=".$ppValue.", SQD_FLG_PP='".$ppFlag."', SQD_VAL_HH=".$hhValue.", SQD_FLG_HH='".$hhFlag."', SQD_VAL_HD=".$wl["wells"][$i]["dynamicWaterTable"]["value"].", SQD_FLG_HD='".$wl["wells"][$i]["dynamicWaterTable"]["flag"]."', SQD_VAL_ONOFF=".$wl["wells"][$i]["pumpOnOff"]["value"].", SQD_FLG_ONOFF='".$wl["wells"][$i]["pumpOnOff"]["flag"]."', SQD_AUDIT_CD='".$scriptDate."' where SQD_DRS_ID=".$devID ); } // ============================================================================== if ($devID>0) { $measureQuery = "INSERT INTO rep_soap_syndis_update5min_data SET "; $measureQuery .= "SUD_DRS_ID=".$devID.",SUD_OBJECT_NAME='".$wl["wells"][$i]["well"]["id"]."',SUD_OBJECT_TYPE=".$wellType.","; //prąd fazy L1 zasilania pompy $measureQuery .= "SUD_ID_L1=270,SUD_VAL_L1=".$wl["wells"][$i]["currentL1"]["value"].",SUD_FLG_L1='".$wl["wells"][$i]["currentL1"]["flag"]."',SUD_DATE_L1='".convertData($wl["wells"][$i]["currentL1"]["date"])."',"; //prąd fazy L2 zasilania pompy $measureQuery .= "SUD_ID_L2=710,SUD_VAL_L2=".$wl["wells"][$i]["currentL2"]["value"].",SUD_FLG_L2='".$wl["wells"][$i]["currentL2"]["flag"]."',SUD_DATE_L2='".convertData($wl["wells"][$i]["currentL2"]["date"])."',"; //prąd fazy L3 zasilania pompy $measureQuery .= "SUD_ID_L3=711,SUD_VAL_L3=".$wl["wells"][$i]["currentL3"]["value"].",SUD_FLG_L3='".$wl["wells"][$i]["currentL3"]["flag"]."',SUD_DATE_L3='".convertData($wl["wells"][$i]["currentL3"]["date"])."',"; //[voltageL12] => U L12 [V] - napięcie międzyfazowe L1-L2 $measureQuery .= "SUD_ID_UL12=275,SUD_VAL_UL12=".$wl["wells"][$i]["voltageL12"]["value"].",SUD_FLG_UL12='".$wl["wells"][$i]["voltageL12"]["flag"]."',SUD_DATE_UL12='".convertData($wl["wells"][$i]["voltageL12"]["date"])."',"; //[voltageL23] => U L23 [V] - napięcie międzyfazowe L2-L3 $measureQuery .= "SUD_ID_UL23=712,SUD_VAL_UL23=".$wl["wells"][$i]["voltageL23"]["value"].",SUD_FLG_UL23='".$wl["wells"][$i]["voltageL23"]["flag"]."',SUD_DATE_UL23='".convertData($wl["wells"][$i]["voltageL23"]["date"])."',"; //[throttlePosition] => Położenie przepustnicy [*] if ($wellType==19) $measureQuery .= "SUD_ID_TRP=730,SUD_VAL_TRP=".$wl["wells"][$i]["throttlePosition"]["value"].",SUD_FLG_TRP='".$wl["wells"][$i]["throttlePosition"]["flag"]."',SUD_DATE_TRP='".convertData($wl["wells"][$i]["throttlePosition"]["date"])."',"; else { $tmpDivP1P2=0; $tmpDivP1P2 = (float) ($wl["wells"][$i]["pressureAfterThrottle"]["value"] / $wl["wells"][$i]["pressureBeforeThrottle"]["value"]); if ($tmpDivP1P2>0.93) $measureQuery .= "SUD_ID_TRP=730,SUD_VAL_TRP=100,SUD_FLG_TRP='".$wl["wells"][$i]["throttlePosition"]["flag"]."',SUD_DATE_TRP='".convertData($wl["wells"][$i]["throttlePosition"]["date"])."',"; else $measureQuery .= "SUD_ID_TRP=730,SUD_VAL_TRP=50,SUD_FLG_TRP='".$wl["wells"][$i]["throttlePosition"]["flag"]."',SUD_DATE_TRP='".convertData($wl["wells"][$i]["throttlePosition"]["date"])."',"; } //[waterTemperature] => Tw [*C] $measureQuery .= "SUD_ID_TW=245,SUD_VAL_TW=".$wl["wells"][$i]["waterTemperature"]["value"].",SUD_FLG_TW='".$wl["wells"][$i]["waterTemperature"]["flag"]."',SUD_DATE_TW='".convertData($wl["wells"][$i]["waterTemperature"]["date"])."',"; //[activePower] => P [kW] $measureQuery .= "SUD_ID_PE=260,SUD_VAL_PE=".$wl["wells"][$i]["activePower"]["value"].",SUD_FLG_PE='".$wl["wells"][$i]["activePower"]["flag"]."',SUD_DATE_PE='".convertData($wl["wells"][$i]["activePower"]["date"])."',"; //[cos] => cos(FI) $measureQuery .= "SUD_ID_CFI=280,SUD_VAL_CFI=".$wl["wells"][$i]["cos"]["value"].",SUD_FLG_CFI='".$wl["wells"][$i]["cos"]["flag"]."',SUD_DATE_CFI='".convertData($wl["wells"][$i]["cos"]["date"])."',"; //[activeEnergy] => E [kWh] $measureQuery .= "SUD_ID_KWH=265,SUD_VAL_KWH=".$wl["wells"][$i]["activeEnergy"]["value"].",SUD_FLG_KWH='".$wl["wells"][$i]["activeEnergy"]["flag"]."',SUD_DATE_KWH='".convertData($wl["wells"][$i]["activeEnergy"]["date"])."',"; //[pumpedWaterAmount] => V [m3] $measureQuery .= "SUD_ID_VM3=230,SUD_VAL_VM3=".$wl["wells"][$i]["pumpedWaterAmount"]["value"].",SUD_FLG_VM3='".$wl["wells"][$i]["pumpedWaterAmount"]["flag"]."',SUD_DATE_VM3='".convertData($wl["wells"][$i]["pumpedWaterAmount"]["date"])."',"; //[ClInPumpedWater] => ch [mg/l] $measureQuery .= "SUD_ID_CHL=719,SUD_VAL_CHL=".$wl["wells"][$i]["ClInPumpedWater"]["value"].",SUD_FLG_CHL='".$wl["wells"][$i]["ClInPumpedWater"]["flag"]."',SUD_DATE_CHL='".convertData($wl["wells"][$i]["ClInPumpedWater"]["date"])."',"; //[energyConsumption] => Jednostkowe zużycie energii [kWh/m3/m] $measureQuery .= "SUD_ID_ECM=721,SUD_VAL_ECM=".$wl["wells"][$i]["energyConsumption"]["value"].",SUD_FLG_ECM='".$wl["wells"][$i]["energyConsumption"]["flag"]."',SUD_DATE_ECM='".convertData($wl["wells"][$i]["energyConsumption"]["date"])."',"; //[pumpRuntime] => t [h] $measureQuery .= "SUD_ID_RUTM=290,SUD_VAL_RUTM=".$wl["wells"][$i]["pumpRuntime"]["value"].",SUD_FLG_RUTM='".$wl["wells"][$i]["pumpRuntime"]["flag"]."',SUD_DATE_RUTM='".convertData($wl["wells"][$i]["pumpRuntime"]["date"])."',"; //[dynamicWaterTable] => HD [m] $measureQuery .= "SUD_ID_HD=205,SUD_VAL_HD=".$wl["wells"][$i]["dynamicWaterTable"]["value"].",SUD_FLG_HD='".$wl["wells"][$i]["dynamicWaterTable"]["flag"]."',SUD_DATE_HD='".convertData($wl["wells"][$i]["dynamicWaterTable"]["date"])."',"; //[staticWaterTable] => HST [m] $measureQuery .= "SUD_ID_HST=210,SUD_VAL_HST=".$wl["wells"][$i]["staticWaterTable"]["value"].",SUD_FLG_HST='".$wl["wells"][$i]["staticWaterTable"]["flag"]."',SUD_DATE_HST='".convertData($wl["wells"][$i]["staticWaterTable"]["date"])."',"; //[pressureBeforeThrottle] => p1 [kPa] $measureQuery .= "SUD_ID_P1=215,SUD_VAL_P1=".$wl["wells"][$i]["pressureBeforeThrottle"]["value"].",SUD_FLG_P1='".$wl["wells"][$i]["pressureBeforeThrottle"]["flag"]."',SUD_DATE_P1='".convertData($wl["wells"][$i]["pressureBeforeThrottle"]["date"])."',"; //[pressureAfterThrottle] => p2 [kPa] $measureQuery .= "SUD_ID_P2=220,SUD_VAL_P2=".$wl["wells"][$i]["pressureAfterThrottle"]["value"].",SUD_FLG_P2='".$wl["wells"][$i]["pressureAfterThrottle"]["flag"]."',SUD_DATE_P2='".convertData($wl["wells"][$i]["pressureAfterThrottle"]["date"])."',"; //[barometricPressuremA] => Ciśnienie barometryczne pB[mA] - zakres 4-20 $measureQuery .= "SUD_ID_PB=225,SUD_VAL_PB=".($wl["wells"][$i]["barometricPressuremA"]["value"] * 10).",SUD_FLG_PB='".$wl["wells"][$i]["barometricPressuremA"]["flag"]."',SUD_DATE_PB='".convertData($wl["wells"][$i]["barometricPressuremA"]["date"])."',"; //[pumpEfficiency] => Q [m3/min] $measureQuery .= "SUD_ID_Q=200,SUD_VAL_Q=".($wl["wells"][$i]["pumpEfficiency"]["value"] * 60).",SUD_FLG_Q='".$wl["wells"][$i]["pumpEfficiency"]["flag"]."',SUD_DATE_Q='".convertData($wl["wells"][$i]["pumpEfficiency"]["date"])."',"; //[currentDiagnosticsOperationState] => Działanie/niedziałanie [1/0] diagnostyki prądowej $measureQuery .= "SUD_ID_DIAG=708,SUD_VAL_DIAG=".$wl["wells"][$i]["currentDiagnosticsOperationState"]["value"].",SUD_FLG_DIAG='".$wl["wells"][$i]["currentDiagnosticsOperationState"]["flag"]."',SUD_DATE_DIAG='".convertData($wl["wells"][$i]["currentDiagnosticsOperationState"]["date"])."',"; // PP $measureQuery .= "SUD_ID_PP=401,SUD_VAL_PP=".$ppValue.",SUD_FLG_PP='".$ppFlag."',SUD_DATE_PP='".convertData($wl["wells"][$i]["pressureInPistonBody"]["date"])."',"; // HH $measureQuery .= "SUD_ID_HH=402,SUD_VAL_HH=".$hhValue.",SUD_FLG_HH='".$hhFlag."',SUD_DATE_HH='".convertData($wl["wells"][$i]["dynamicWaterTable"]["date"])."',"; // ON OFF $measureQuery .= "SUD_ID_ONOFF=507,SUD_VAL_ONOFF=".$wl["wells"][$i]["pumpOnOff"]["value"].",SUD_FLG_ONOFF='".$wl["wells"][$i]["pumpOnOff"]["flag"]."',SUD_DATE_ONOFF='".convertData($wl["wells"][$i]["pumpOnOff"]["date"])."',"; // end query $measureQuery .= "SUD_AUDIT_CD=now()"; // wpisuje do tabeli z rekordami. //echo $measureQuery."

"; mysql_query($measureQuery); // wpisuje dane do tabeli major_data (logi + FastAccess) mysql_query("INSERT INTO seg_dev_major_data SET DRD_OBJECT_TYPE='WELL',DMD_DRS_ID=".$devID.",DRD_OBJECT_NAME='".$wl["wells"][$i]["well"]["id"]."',DRD_L1=".$wl["wells"][$i]["currentL1"]["value"].",DRD_L2=".$wl["wells"][$i]["currentL2"]["value"].",DRD_L3=".$wl["wells"][$i]["currentL3"]["value"].",DRD_U_L12=".$wl["wells"][$i]["voltageL12"]["value"].",DRD_U_L23=".$wl["wells"][$i]["voltageL23"]["value"].",DRD_THROTTLE=".$wl["wells"][$i]["throttlePosition"]["value"].",DRD_WATER_TEMP=".$wl["wells"][$i]["waterTemperature"]["value"].",DRD_POWER=".$wl["wells"][$i]["activePower"]["value"].",DRD_COS_FI=".$wl["wells"][$i]["cos"]["value"].",DRD_ENERGY=".$wl["wells"][$i]["activeEnergy"]["value"].",DRD_WATER_PUMPED=".$wl["wells"][$i]["pumpedWaterAmount"]["value"].",DRD_RUN_TIME=".$wl["wells"][$i]["pumpRuntime"]["value"].",DRD_HD=".$wl["wells"][$i]["dynamicWaterTable"]["value"].",DRD_P1=".$wl["wells"][$i]["pressureBeforeThrottle"]["value"].",DRD_P2=".$wl["wells"][$i]["pressureAfterThrottle"]["value"].",DRD_PB=".($wl["wells"][$i]["barometricPressuremA"]["value"] * 10).",DRD_Q=".($wl["wells"][$i]["pumpEfficiency"]["value"] * 60).",DRD_PP=".$pp_tmp.",DRD_HH=".$hh_tmp.",DRD_HST=".$wl["wells"][$i]["staticWaterTable"]["value"].",DMD_WORK_STATUS='".$wl["wells"][$i]["pumpOnOff"]["value"]."',DRD_AUDIT_CD='".$scriptDate."'"); // wpisuje dane do tabeli odnośnie energochłonności // ====================================================================== // $getEnergyValue=null; $qParam = $wl["wells"][$i]["pumpEfficiency"]["value"] * 60; $resHD = $wl["wells"][$i]["dynamicWaterTable"]["value"]; $P2param = $wl["wells"][$i]["pressureAfterThrottle"]["value"]; $PEparam = $wl["wells"][$i]["activePower"]["value"]; if (empty($PEparam)) $PEparam=1; $resETA = ($qParam*($resHD+$P2param))/(367*$PEparam); $RedYellowParam = setRedYellowLimes(sqlValue("select PUP_Q_N from seg_pumps where PUP_ID=(select DRS_DEV_ID from seg_dev_resources where DRS_ID=(select RWL_PUP_DRS_ID from seg_dev_resources left join seg_well_pump_eng_rel on RWL_WLL_ID=DRS_DEV_ID where DRS_ID=".$devID."))")); $YellowGreenParam = setYellowGreenLimes(sqlValue("select PUP_Q_N from seg_pumps where PUP_ID=(select DRS_DEV_ID from seg_dev_resources where DRS_ID=(select RWL_PUP_DRS_ID from seg_dev_resources left join seg_well_pump_eng_rel on RWL_WLL_ID=DRS_DEV_ID where DRS_ID=".$devID."))")); if ($resETA<=$RedYellowParam) $getEnergyValue = "R"; else if ($RedYellowParam<$resETA && $resETA<=$YellowGreenParam) $getEnergyValue = "Y"; else if ($resETA>$YellowGreenParam) $getEnergyValue = "G"; if ($wellType==20) $getEnergyValue = "NN"; //mysql_query("INSERT INTO rep_dev_details SET RDD_DRS_ID=".$devID.",RDD_RESOURCES_DETAIL=729,RDD_VALUE='".$getEnergyValue."',RDD_AUDIT_USR='SYNDIS',RDD_AUDIT_DATE='".$scriptDate."'"); if (sqlValue("select count(1) from rep_soap_well_energy where SWE_DRS_ID=".$devID)>0) mysql_query("UPDATE rep_soap_well_energy SET SWE_VALUE='".$getEnergyValue."',SWE_AUDIT_USR='SYNDIS',SWE_WORK_STATUS='".$wl["wells"][$i]["pumpOnOff"]["value"]."',SWE_AUDIT_DATE='".$scriptDate."' WHERE SWE_DRS_ID=".$devID); else mysql_query("INSERT INTO rep_soap_well_energy SET SWE_DRS_ID=".$devID.",SWE_WELL_ID=".$wellID.",SWE_NAME='".$wl["wells"][$i]["well"]["id"]."',SWE_VALUE='".$getEnergyValue."',SWE_AUDIT_USR='SYNDIS',SWE_WORK_STATUS='".$wl["wells"][$i]["pumpOnOff"]["value"]."',SWE_AUDIT_DATE='".$scriptDate."'"); // ====================================================================== // } // aktualizauje status pomiaru mysql_query("UPDATE rep_soap_well_energy SET SWE_WORK_STATUS='".$wl["wells"][$i]["currentL1"]["flag"]."' WHERE SWE_NAME='".$wl["wells"][$i]["well"]["id"]."'"); } mysql_close($polacz); echo 'finish processing ...
'; echo 'Finish: '.date("Y-m-d H:i:s").'
'; /** * *echo "
---------------------------------
";
 *print_r($cl->GetWellDataAsArray('PUMP23')); //Pobieranie danych jednej pompy - zwraca dane jako tablica
 *
 *echo "

---------------------------------
Indeksy piezometru
";
 *print_r($cl->GetPiezometerData('PIEZO23')); //Pobieranie danych jednego piezometru - zwraca dane jako obiekt
 *
 *echo "

---------------------------------
"; *var_dump($cl->GetPiezometerDataAsArray('PIEZO23')); //Pobieranie danych jednego piezometru - zwraca dane jako tablice * *echo "
---------------------------------
";
 *var_dump($cl->GetWellsDataAsArray(array('PUMP23','PUMP24'))); //retruns associate array
 *
 *echo "

---------------------------------
";
 *v8ar_dump($cl->GetPiezometersDataAsArray(array('PUMP23','PUMP24'))); //retruns associate array
 */


?>