';
require_once("soap.php");
ini_set('soap.wsdl_cache_enabled',0);
ini_set('soap.wsdl_cache_ttl',0);
$cl = new SyndisConnector("http://172.22.64.101/SyndisSpm.wsdl"); //zmienić URL na inny - ten kieruje na moj komputer
$cl->__setLocation('http://172.22.64.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;
}
}
unset($recArray);
//$recArray = sqlGetResAsArray("select WLL_NAME as W_NAME,DRS_ID from seg_dev_resources,seg_wells where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_ID in (select DRD_DRS_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and DRD_DESCRIPTION=1318 and DRD_AUDIT_DATE>= DATE_ADD(now(), INTERVAL '-5' HOUR))");
$recArray = sqlGetResAsArray("select WLL_NAME as W_NAME,DRS_ID from seg_dev_resources,seg_wells where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_ID in (select DRD_DRS_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and DRD_DESCRIPTION=1318 and DRD_AUDIT_DATE>= DATE_ADD(now(), INTERVAL '-1' DAY))");
echo'
';
for ($std=0; $std';
unset($wellArray);
$wellArray = objectToArray($cl->GetPumpSwitchAndReasonsHistory($recArray[$std]['W_NAME'],date('Y-m').'-01T00:00:00Z'));
if (count($wellArray['probes'])>0 && $recArray[$std]['DRS_ID']>0)
{
for ($i=0; $i0 && $wellArray['probes'][$i]['reason']!=0 && $wellArray['probes'][$i]['reason']!=1318 && $zeroMeas[0]['DRD_DESCRIPTION']==1318)
{
echo 'Studnia: '.$recArray[$std]['W_NAME'];
echo'
';
mysql_query("UPDATE seg_dev_resources_det SET DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_AUDIT_USR='SYNDIS_UPDATE' WHERE DRD_ID=".$zeroMeas[0]['DRD_ID']);
//echo("UPDATE seg_dev_resources_det SET DRD_DESCRIPTION='".$wellArray['probes'][$i]['reason']."',DRD_AUDIT_USR='SYNDIS_UPDATE' WHERE DRD_ID=".$zeroMeas[0]['DRD_ID']);
//echo'
';
}
}
}
}
echo'
';
}
mysql_close($polacz);
echo 'finish processing ...
';
echo 'Finish: '.date("Y-m-d H:i:s").'
';
?>