";
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";
$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 "
";
//piezometry
echo "PIEZOMETRY:
";
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";
$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']);
}
}
?>