98 lines
4.4 KiB
PHP
98 lines
4.4 KiB
PHP
<?php
|
|
|
|
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");
|
|
?>
|
|
|
|
<?php
|
|
//studnie
|
|
echo "STUDNIE:<br/>";
|
|
unset($wellArray);
|
|
$wellArray = sqlGetResAsArray("select DRS_ID,WLL_NAME from seg_wells,seg_dev_resources where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12");
|
|
for($i=0; $i<count($wellArray); $i++)
|
|
{
|
|
//select OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=2839
|
|
unset($hcArray);
|
|
$hcArray = sqlGetResAsArray("select OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
$rzDIV = 0;
|
|
|
|
//Sprawdza, czy rzędna się zmianiła
|
|
$rzDIV = (float) round(($hcArray[0]['OHC_RZEDNA_TEREN'] - $hcArray[0]['OHC_RZEDNA_TERENU_ACT']),2);
|
|
if ($rzDIV>0)
|
|
{
|
|
echo"Aktualizauje studnie: ".$wellArray[$i]['WLL_NAME']."<br/>";
|
|
$newGleb = (float) ($hcArray[0]['OHC_GLEB_OSTAT'] - $rzDIV);
|
|
// wstawia głębokość
|
|
mysql_query("delete from seg_dev_resources_det where DRD_RESOURCES_DETAIL=110 and DRD_DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['DRS_ID'].",DRD_RESOURCES_DETAIL=110,DRD_VALUE='".$newGleb."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='reczna aktualizacja',DRD_AUDIT_DATE=now()");
|
|
|
|
// aktualizacja kolumn
|
|
//update seg_object_columns set COL_DEPTH=(COL_DEPTH-10) where COL_DRS_ID=2839
|
|
mysql_query("update seg_object_columns set COL_DEPTH=(COL_DEPTH-".$rzDIV.") where COL_DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
|
|
// aktualizacja filtrów
|
|
//update seg_object_column_filters set where CLF_FROM=(CLF_FROM-10),CLF_TO=(CLF_TO-10) CLF_DRS_ID=3034
|
|
mysql_query("update seg_object_column_filters set CLF_FROM=(CLF_FROM-".$rzDIV."),CLF_TO=(CLF_TO-".$rzDIV.") where CLF_DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
|
|
//aktualizacja obsybki
|
|
//update seg_object_column_fillings set CLO_FROM=(CLO_FROM-10), CLO_TO=(CLO_TO-10) where CLO_DRS_ID=6744
|
|
mysql_query("update seg_object_column_fillings set CLO_FROM=(CLO_FROM-".$rzDIV."), CLO_TO=(CLO_TO-".$rzDIV.") where CLO_DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
}
|
|
|
|
}
|
|
|
|
|
|
echo "<br/><br/><br/>";
|
|
|
|
|
|
//piezometry
|
|
echo "PIEZOMETRY:<br/>";
|
|
|
|
unset($piezoArray);
|
|
$piezoArray = sqlGetResAsArray("select DRS_ID,SRP_NAME from seg_reservoirs_piezometers,seg_dev_resources where DRS_DEV_ID=SRP_ID and DRS_DEV_TYPE=601");
|
|
for($i=0; $i<count($piezoArray); $i++)
|
|
{
|
|
//select OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=2839
|
|
unset($hcArray);
|
|
$hcArray = sqlGetResAsArray("select OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=".$piezoArray[$i]['DRS_ID']);
|
|
$rzDIV = 0;
|
|
|
|
//Sprawdza, czy rzędna się zmianiła
|
|
$rzDIV = (float) round(($hcArray[0]['OHC_RZEDNA_TEREN'] - $hcArray[0]['OHC_RZEDNA_TERENU_ACT']),2);
|
|
if ($rzDIV>0)
|
|
{
|
|
echo"Aktualizauje studnie: ".$piezoArray[$i]['SRP_NAME']."<br/>";
|
|
$newGleb = (float) ($hcArray[0]['OHC_GLEB_OSTAT'] - $rzDIV);
|
|
|
|
// wstawia głębokość
|
|
mysql_query("delete from seg_dev_resources_det where DRD_RESOURCES_DETAIL=609 and DRD_DRS_ID=".$piezoArray[$i]['DRS_ID']);
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$piezoArray[$i]['DRS_ID'].",DRD_RESOURCES_DETAIL=609,DRD_VALUE='".$newGleb."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='reczna aktualizacja',DRD_AUDIT_DATE=now()");
|
|
|
|
// aktualizacja kolumn
|
|
//update seg_object_columns set COL_DEPTH=(COL_DEPTH-10) where COL_DRS_ID=2839
|
|
mysql_query("update seg_object_columns set COL_DEPTH=(COL_DEPTH-".$rzDIV.") where COL_DRS_ID=".$piezoArray[$i]['DRS_ID']);
|
|
|
|
// aktualizacja filtrów
|
|
//update seg_object_column_filters set where CLF_FROM=(CLF_FROM-10),CLF_TO=(CLF_TO-10) CLF_DRS_ID=3034
|
|
mysql_query("update seg_object_column_filters set CLF_FROM=(CLF_FROM-".$rzDIV."),CLF_TO=(CLF_TO-".$rzDIV.") where CLF_DRS_ID=".$piezoArray[$i]['DRS_ID']);
|
|
|
|
//aktualizacja obsybki
|
|
//update seg_object_column_fillings set CLO_FROM=(CLO_FROM-10), CLO_TO=(CLO_TO-10) where CLO_DRS_ID=6744
|
|
mysql_query("update seg_object_column_fillings set CLO_FROM=(CLO_FROM-".$rzDIV."), CLO_TO=(CLO_TO-".$rzDIV.") where CLO_DRS_ID=".$piezoArray[$i]['DRS_ID']);
|
|
}
|
|
}
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
mysql_close($polacz);
|
|
|
|
?>
|