102 lines
3.5 KiB
PHP
102 lines
3.5 KiB
PHP
<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=utf-8">
|
|
|
|
<?php session_start();
|
|
error_reporting(E_ALL);
|
|
echo 'starting ...<br>';
|
|
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 ...<br>';
|
|
echo 'Start: '.date("Y-m-d H:i:s").'<br>';
|
|
|
|
$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'<br/><br/>';
|
|
|
|
|
|
|
|
|
|
for ($std=0; $std<count($recArray); $std++)
|
|
{
|
|
// echo 'Studnia: '.$recArray[$std]['W_NAME'];
|
|
// echo'<br/>';
|
|
|
|
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; $i<count($wellArray['probes']); $i++)
|
|
{
|
|
// jeśli wyłącz
|
|
if ($wellArray['probes'][$i]['value'] == 0)
|
|
{
|
|
unset($zeroMeas);
|
|
$zeroMeas = sqlGetResAsArray("select * from seg_dev_resources_det where DRD_DRS_ID=".$recArray[$std]['DRS_ID']." and DRD_RESOURCES_DETAIL=507 and DRD_VALUE='OFF' and (DRD_DESCRIPTION=1318 or DRD_DESCRIPTION=0) and DRD_AUDIT_DATE='".convertData($wellArray['probes'][$i]['date'])."'");
|
|
|
|
if (count($zeroMeas)>0 && $wellArray['probes'][$i]['reason']!=0 && $wellArray['probes'][$i]['reason']!=1318 && $zeroMeas[0]['DRD_DESCRIPTION']==1318)
|
|
{
|
|
echo 'Studnia: '.$recArray[$std]['W_NAME'];
|
|
echo'<br/>';
|
|
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'<br/>';
|
|
}
|
|
}
|
|
}
|
|
}
|
|
echo'<br/>';
|
|
}
|
|
|
|
mysql_close($polacz);
|
|
echo 'finish processing ...<br>';
|
|
echo 'Finish: '.date("Y-m-d H:i:s").'<br>';
|
|
|
|
?>
|