';
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 ...
';
function objectToArray($d) {
if (is_object($d)) {
$d = get_object_vars($d);
}
if (is_array($d)) {
return array_map(__FUNCTION__, $d);
}
else {
return $d;
}
}
function sqlQuery($query)
{
mysqli_query($GLOBALS['dbconn'],$query);
}
function sqlGetResAsArray($query)
{
$res=null;
$res = array();
if(!$results = mysqli_query($GLOBALS['dbconn'],$query)){
echo mysqli_error($GLOBALS['dbconn']);
return false;
}
for($i=0; $row=mysqli_fetch_assoc($results); $i++)
$res[$i]=$row;
return $res;
}
// ========================================================== //
function convertData($insertDate)
{
unset($res);
//re-contruct to format
$res = date('Y-m-d H:i:s', strtotime($insertDate));
return $res;
}
$scriptDate = date("Y-m-d H:i:s");
// wykonuje tylko dla godziny ZERO
$curHur = (int) date('H');
if ($curHur<1)
{
// ========================================================================================================================================================== //
$GLOBALS['dbconn'] = mysqli_connect("172.22.64.101", "root", "Mikronika123") or die ('cannot connect to db');
mysqli_select_db($GLOBALS['dbconn'],"softspm");
sqlQuery("SET NAMES utf8");
sqlQuery("SET CHARACTER_SET utf8_general_ci");
unset($piezoArray);
$piezoArray = sqlGetResAsArray("select SRP_NAME from seg_reservoirs_piezometers,seg_dev_resources where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=601 and DRS_RESOURCES_DIC_ID=941 and DRS_STATUS_DIC_ID=3 and SRP_MCF_ID=1500");
unset($piezoWater);
foreach ($piezoArray as $tb)
$piezoWater[] = $tb['SRP_NAME'];
unset($pz);
$pz = $cl->GetPiezometersDataAsArray($piezoWater);
for ($i=0; $i0)
{
unset($pzIdArray);
$pzIdArray = sqlGetResAsArray("select DRS_ID from seg_reservoirs_piezometers,seg_dev_resources where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=601 and SRP_NAME='".$pz["piezometers"][$i]['piezometer']['id']."'");
/*
echo'ID: '.$pz["piezometers"][$i]['piezometer']['id'].'
';
echo'VAL: '.$pz["piezometers"][$i]['staticWaterTable']['value'].'
';
echo'DATE: '.$pz["piezometers"][$i]['staticWaterTable']['date'].'
';
echo'FLAG: '.$pz["piezometers"][$i]['staticWaterTable']['flag'].'
';
*/
sqlQuery("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$pzIdArray[0]['DRS_ID'].",DRD_RESOURCES_DETAIL=210,DRD_VALUE='".round($pz["piezometers"][$i]['staticWaterTable']['value'],2)."',DRD_DESCRIPTION='SYNDIS morning',DRD_EXPORT_SEGAP='0',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".date('Y-m-d')."'");
//echo'
';
//echo'
';
}
}
mysqli_close($GLOBALS['dbconn']);
// ========================================================================================================================================================== //
}
echo 'finish processing ...
';
?>