104 lines
3.9 KiB
PHP
104 lines
3.9 KiB
PHP
|
|
<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=utf-8">
|
|
<?php
|
|
error_reporting(E_ALL);
|
|
echo 'starting ...<br>';
|
|
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 ...<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;
|
|
}
|
|
|
|
|
|
|
|
|
|
// pobieramy tablice studni
|
|
$well_array=null;
|
|
$wynik = mysql_query("select WLL_NAME from seg_dev_resources,seg_wells where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and DRS_STATUS_DIC_ID=3 and WLL_CAT_DIC_ID<>20 and getLastValue(507,DRS_ID)='OFF'");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$well_array[] = $r["WLL_NAME"];
|
|
}
|
|
//print_r($cl->GetWellsDataAsArray(array('G52','G54'))); //Pobieranie danych dla wszystkich studni
|
|
$wl = $cl->GetWellsDataAsArray($well_array);
|
|
|
|
|
|
|
|
for($i=0; $i<count($wl["wells"]); $i++)
|
|
{
|
|
echo "Name: ". $wl["wells"][$i]["well"]["id"]."<br/>";
|
|
|
|
$devID=null; $rowID=null;
|
|
|
|
$wynik_W = mysql_query("select DRS_ID,(select DRD_ID from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=DRS_ID and DRD_AUDIT_DATE=(select max(DRD_AUDIT_DATE) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=DRS_ID)) ROW_ID from seg_dev_resources,seg_wells where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and WLL_NAME='".$wl["wells"][$i]["well"]["id"]."'");
|
|
if($wynik_W)while ($r_W = mysql_fetch_array($wynik_W))
|
|
{
|
|
$devID = $r_W["DRS_ID"];
|
|
$rowID = $r_W["ROW_ID"];
|
|
}
|
|
|
|
echo "devID: ".$devID."<br/>";
|
|
echo "rowID: ".$rowID."<br/>";
|
|
|
|
|
|
//sprawdza stan załączenia pompy
|
|
if ($devID>0 && $rowID>0)
|
|
{
|
|
//2017-10-17 - dodanie parametru REASON [pumpOnOffReason]: $wl["wells"][$i]["pumpOnOffReason"]["value"]
|
|
mysql_query("UPDATE seg_dev_resources_det SET DRD_DESCRIPTION='".$wl["wells"][$i]["pumpOnOffReason"]["value"]."' WHERE DRD_ID=".$rowID);
|
|
// ==============================================================================================================================================================
|
|
|
|
echo("UPDATE seg_dev_resources_det SET DRD_DESCRIPTION='".$wl["wells"][$i]["pumpOnOffReason"]["value"]."' WHERE DRD_ID=".$rowID);
|
|
echo"<br/>";
|
|
|
|
echo"Zrobil UPDATE na :".$wl["wells"][$i]["well"]["id"]." [".$devID."] = ".$wl["wells"][$i]["pumpOnOffReason"]["value"]."<br/>";
|
|
}
|
|
|
|
echo"<br/>";
|
|
}
|
|
|
|
mysql_close($polacz);
|
|
echo 'finish processing ...<br>';
|
|
echo 'Finish: '.date("Y-m-d H:i:s").'<br>';
|
|
|
|
/**
|
|
*
|
|
*echo "</pre><br>---------------------------------<br><pre>";
|
|
*print_r($cl->GetWellDataAsArray('PUMP23')); //Pobieranie danych jednej pompy - zwraca dane jako tablica
|
|
*
|
|
*echo "</pre><br>---------------------------------<br>Indeksy piezometru<pre>";
|
|
*print_r($cl->GetPiezometerData('PIEZO23')); //Pobieranie danych jednego piezometru - zwraca dane jako obiekt
|
|
*
|
|
*echo "</pre><br>---------------------------------<br>";
|
|
*var_dump($cl->GetPiezometerDataAsArray('PIEZO23')); //Pobieranie danych jednego piezometru - zwraca dane jako tablice
|
|
*
|
|
*echo "</pre><br>---------------------------------<br><pre>";
|
|
*var_dump($cl->GetWellsDataAsArray(array('PUMP23','PUMP24'))); //retruns associate array
|
|
*
|
|
*echo "</pre><br>---------------------------------<br><pre>";
|
|
*v8ar_dump($cl->GetPiezometersDataAsArray(array('PUMP23','PUMP24'))); //retruns associate array
|
|
*/
|
|
|
|
|
|
?>
|