<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>';

//$scriptDate = date("Y-m-d H:i:s");

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 insert_new_record($devID, $dicID, $value,$insertDate,$bar,$dep,$pname)
{

    $insertDate = str_replace(array('T','Z'), array(' ',''),$insertDate);
    $insertDateValue = (float) str_replace(array('-',':',' '),array('','',''),$insertDate);

    $lastMasureDate = sqlStringValue("select getLastMeasureDate(".$dicID.",".$devID.") MT","MT");
    $lastMasureDateValue = (float) str_replace(array('-',':',' '),array('','',''),$lastMasureDate);

    // sprawdza, czy ostatni pomiar jest późniejszy od nowego z SYNDIS
    if ($insertDateValue>$lastMasureDateValue)
    {
        $value = round($value,2);
            mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=".$dicID.",DRD_VALUE='".round($value,2)."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".$insertDate."'");


        echo "wstawił<br/><br/>";
    }

    // wpisuje dane - jako do exportu do SEGAP
    mysql_query("INSERT INTO seg_piezometers_segap SET DRD_DRS_ID=".$devID.",SRP_BARIERA='".$bar."',SRP_NAME='".$pname."',DRD_RESOURCES_DETAIL=".$dicID.",DRD_VALUE='".round($value,2)."',DRS_DEPARTMENT='".$dep."',DRD_AUDIT_DATE='".$insertDate."'");


    //echo"INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$devID.",DRD_RESOURCES_DETAIL=".$dicID.",DRD_VALUE='".$value."',DRD_EXPORT_SEGAP='0',DRD_AUDIT_USR='SYNDIS',DRD_AUDIT_DATE='".$insertDate."'";
    //echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_ID=".$dicID, "DIC_POL_LANG")." [$dicID]: ".$value;
    //echo"</br>";
}

mysql_query("truncate table seg_piezometers_segap");

$wynik = mysql_query("select SOI_NAME from rep_soap_objects_import where SOI_OBJECT='PIEZO'");
if($wynik)while ($r = mysql_fetch_array($wynik))
{
    $pName=$r["SOI_NAME"];
    $pz = $cl->GetPiezometerDataAsArray($pName);

    
    echo $pName."</br>";
    //print_r($wl);

    //$devID=null;
    //$devID = sqlStringValue("select DRS_ID from seg_reservoirs_piezometers left join seg_dev_resources on SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 where SRP_NAME='".$pName."'","DRS_ID");

    $piezoArray=null;
    unset($piezoArray);
    $piezoArray = sqlGetResAsArray("select DRS_ID,DRS_DEPARTMENT,SRP_BARIERA from seg_reservoirs_piezometers left join seg_dev_resources on SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 where SRP_NAME='".$pName."'");

    if ($piezoArray[0]['DRS_ID']>0 && $pz["staticWaterTable"]["flag"] == "CORRECT")
    {
        if ($pz["staticWaterTable"]["value"]>0)
        {
            //echo "</br>";
            //zwirciadło statyczne
            insert_new_record($piezoArray[0]['DRS_ID'], 210, $pz["staticWaterTable"]["value"],$pz["staticWaterTable"]["date"],$piezoArray[0]['SRP_BARIERA'],$piezoArray[0]['DRS_DEPARTMENT'],$pName);

        }

    }
    else
    {
        echo"Dane InCorrect </br>";
    }
}


mysql_close($polacz);

echo 'finish processing ...<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
 */


?>