'; 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"); date_default_timezone_set('Europe/Warsaw'); 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 convertData($insertDate) { unset($res); //re-contruct to format $res = date('Y-m-d H:i:s', strtotime($insertDate)); return $res; } function objectToArray($d) { if (is_object($d)) { // Gets the properties of the given object // with get_object_vars function $d = get_object_vars($d); } if (is_array($d)) { /* * Return array converted to object * Using __FUNCTION__ (Magic constant) * for recursive call */ return array_map(__FUNCTION__, $d); } else { // Return array return $d; } } //mysql_query("TRUNCATE table a_getpumpswitchhistory_ins"); if (!$_SESSION['last_well']) $_SESSION['last_well']=1; unset($recArray); //$recArray = sqlGetResAsArray("select * from rep_onoff_proccessing where W_STATUS=0 limit 1"); $recArray = sqlGetResAsArray("select WLL_NAME as W_NAME from seg_wells,seg_well_pump_eng_rel left join seg_dev_resources on (DRS_DEV_TYPE=12 and DRS_DEV_ID=RWL_WLL_ID) where RWL_WLL_ID=WLL_ID and WLL_CAT_DIC_ID in (18,19) and DRS_ID in (select distinct DRD_DRS_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and (DRD_DESCRIPTION is null or DRD_DESCRIPTION=0) and DRD_AUDIT_USR='SYNDIS') and DRS_ID not in (".$_SESSION['last_well'].") limit 1"); echo("select WLL_NAME as W_NAME from seg_wells,seg_well_pump_eng_rel left join seg_dev_resources on (DRS_DEV_TYPE=12 and DRS_DEV_ID=RWL_WLL_ID) where RWL_WLL_ID=WLL_ID and WLL_CAT_DIC_ID in (18,19) and DRS_ID in (select distinct DRD_DRS_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and (DRD_DESCRIPTION is null or DRD_DESCRIPTION=0) and DRD_AUDIT_USR='SYNDIS') and DRS_ID not in (".$_SESSION['last_well'].") limit 1"); echo'

'; unset($wellArray); unset($devID); $devID=0; //$recArray[0]['W_NAME'] = '117G-1'; //unset($lasArrayOnOff); //$lasArrayOnOff = sqlGetResAsArray("select * from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=27229 and DRD_AUDIT_USR='SYNDIS')"); $getCurMonth = (int) date('m'); if ($getCurMonth>3 && $getCurMonth<11) $offset = 2 * 60 * 60; else $offset = 60 * 60; //echo $offset; //echo'

'; //$utcDate = date('Y-m-d\TH:i:s\Z', strtotime($lasArrayOnOff[0]['DRD_AUDIT_DATE'])- $offset); //echo $utcDate; echo 'LAST: '.$_SESSION['last_well']; echo'
'; echo'Studnia: '.$recArray[0]['W_NAME']; echo'

'; if (!empty($recArray[0]['W_NAME'])) { // $wellArray = objectToArray($cl->GetPumpSwitchAndReasonsHistory($_GET['w'],date('Y-m').'-01T00:00:00Z')); // $wellArray = objectToArray($cl->GetPumpSwitchAndReasonsHistory($recArray[0]['W_NAME'],$utcDate)); $wellArray = objectToArray($cl->GetPumpSwitchAndReasonsHistory($recArray[0]['W_NAME'],'2014-12-01T00:00:00Z')); $devID = sqlStringValue("select DRS_ID from seg_wells,seg_dev_resources where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and WLL_CAT_DIC_ID in (18,19) and WLL_NAME='".$recArray[0]['W_NAME']."'", "DRS_ID"); $_SESSION['last_well'] = $_SESSION['last_well'] . ','.$devID; if (count($wellArray['probes'])>0 && $devID>0) { for ($i=0; $i0) { echo"Pomiar[".$i."] dla stuID=".$devID."
"; //echo $wellArray['probes'][$i]['value']." ".$wellArray['probes'][$i]['date']." convert>".convertData($wellArray['probes'][$i]['date'])." ".$wellArray['probes'][$i]['flag']." ".$wellArray['probes'][$i]['reason']."
"; //echo"
"; echo("UPDATE ".$tbUpName." SET DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_AUDIT_USR='mujobs_28557' WHERE DRD_ID=".$zeroMeas[0]['DRD_ID']); mysql_query("UPDATE ".$tbUpName." SET DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_AUDIT_USR='mujobs_28557' WHERE DRD_ID=".$zeroMeas[0]['DRD_ID']); } //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".convertData($wellArray['probes'][$i]['date'])."'"); //echo("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".convertData($wellArray['probes'][$i]['date'])."'"); echo'
'; } } echo'
'; } } //mysql_query("UPDATE rep_onoff_proccessing SET W_STATUS=1 WHERE W_ID=".$recArray[0]['W_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
 */


?>