Files
2026-09-03 11:24:19 +02:00

1205 lines
64 KiB
PHP

<?php
if (!empty($_SESSION['site310']))
{
?>
<?php
// wczytuje dane z GET['param']
if (!empty($_GET['param']))
{
$paramArray = explode(',',$_GET['param']);
$_GET['tab'] = $paramArray[0];
$getAcction = $paramArray[1];
$getRecID = $paramArray[2];
unset($paramArray);
}
// Samonaprawa: obiekty bez nagłówka karty otworu (np. studnie z importu
// SYNDIS) nie zapisywały danych. Tworzymy brakujący nagłówek karty, aby
// edycja zakładek 1-6 działała. Idempotentne - dla istniejących kart no-op.
if ($_GET['dev']>0) ensureHoleCardExists($_GET['dev']);
?>
<?php
//aktualizacja tab1
// ==============================================================
if ($_GET['dev']>0 && $_POST['sub310tab1']==$lab_ButtonName_Update)
{
mysql_query("UPDATE seg_object_hole_cards SET OHC_WYKONAWCA='".$_POST['inHCWykonawca']."',OHC_ROK_WYKON='".$_POST['inHCRokWyk']."',OHC_ROZP_WIER_DATE='".$_POST['inHCRozpWier']."',OHC_ZAK_WIER_DATE='".$_POST['inHCZakWier']."',OHC_DATA_ODDANIA='".$_POST['inHCDataOdd']."',OHC_URZ_WIERT='".$_POST['inHCUrzWiert']."',OHC_SPOS_WIERC='".$_POST['inHCUSposWiert']."',OHC_GLEB_ODWIER='".getFloatValue($_POST['inHCGlOdw'])."',OHC_GLEB_OSTAT='".getFloatValue($_POST['inHCGlOstat'])."',OHC_DL_GEOGR='".getFloatValue($_POST['inHCDlGeog'])."',OHC_SZER_GEOGR='".getFloatValue($_POST['inHCSzGeog'])."',OHC_RZEDNA_TEREN='".getFloatValue($_POST['inHCRzTer'])."',OHC_RZEDNA_TERENU_ACT='".getFloatValue($_POST['inHCRzTer'])."',OHC_RZEDNA_KRYZY='".getFloatValue($_POST['inHCRzKryzy'])."',OHC_ZWIERC_NAWIERC='".getFloatValue($_POST['inHCZwNawier'])."',OHC_ZWIERC_USTAL='".getFloatValue($_POST['inHCZwUstal'])."',OHC_POZIOM_WODONOS='".$_POST['inHCPozWodo']."' WHERE OHC_DRS_ID=".$_GET['dev']);
if (strlen($_POST['inHCDataZdj'])>4)
mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE='".$_POST['inHCDataZdj']."' WHERE OHC_DRS_ID=".$_GET['dev']);
else
mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE=null WHERE OHC_DRS_ID=".$_GET['dev']);
$firstOHH_ID=sqlValue("select min(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev']);
if ($firstOHH_ID>0) mysql_query("update seg_object_hole_cards_his set OHH_RZEDNA='".$_POST['inHCRzTer']."' where OHH_ID=".$firstOHH_ID);
// gdy studnia
if (!empty($_SESSION['well_details']['wellName']))
mysql_query("UPDATE seg_wells SET WLL_LATITUDE='".getFloatValue($_POST['inHCDlGeog'])."',WLL_LONGITUDE='".getFloatValue($_POST['inHCSzGeog'])."' WHERE WLL_NAME='".$_SESSION['well_details']['wellName']."'");
// gdy piezometr
elseif (!empty($_SESSION['site309inf_array'][0]['SRP_NAME']))
mysql_query("UPDATE seg_reservoirs_piezometers SET SRP_LATITUDE='".getFloatValue($_POST['inHCDlGeog'])."',SRP_LONGITUDE='".getFloatValue($_POST['inHCSzGeog'])."' WHERE SRP_NAME='".$_SESSION['site309inf_array'][0]['SRP_NAME']."'");
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($_SESSION['site310_array']);
}
// ==============================================================
//aktualizacja tab2
// ==============================================================
if ($_GET['dev']>0 && $_POST['sub310tab2']==$lab_ButtonName_Update)
{
mysql_query("UPDATE seg_object_hole_cards SET OHC_Q1='".getFloatValue($_POST['inOHC_Q1'])."',OHC_S1='".getFloatValue($_POST['inOHC_S1'])."',OHC_T1='".getFloatValue($_POST['inOHC_T1'])."',OHC_Q2='".getFloatValue($_POST['inOHC_Q2'])."',OHC_S2='".getFloatValue($_POST['inOHC_S2'])."',OHC_T2='".getFloatValue($_POST['inOHC_T2'])."',OHC_Q3='".getFloatValue($_POST['inOHC_Q3'])."',OHC_S3='".getFloatValue($_POST['inOHC_S3'])."',OHC_T3='".getFloatValue($_POST['inOHC_T3'])."',OHC_Q4='".getFloatValue($_POST['inOHC_Q4'])."',OHC_S4='".getFloatValue($_POST['inOHC_S4'])."',OHC_T4='".getFloatValue($_POST['inOHC_T4'])."',OHC_Q5='".getFloatValue($_POST['inOHC_Q5'])."',OHC_S5='".getFloatValue($_POST['inOHC_S5'])."',OHC_T5='".getFloatValue($_POST['inOHC_T5'])."',OHC_QE='".getFloatValue($_POST['inOHC_QE'])."',OHC_SE='".getFloatValue($_POST['inOHC_SE'])."',OHC_WYD_JEDN='".getFloatValue($_POST['inOHC_WYD_JEDN'])."',OHC_WSP_SPR_HYDRO='".getFloatValue($_POST['inOHC_WSP_SPR_HYDRO'])."',OHC_POZ_WOD_NO='".$_POST['inOHC_POZ_WOD_NO']."',OHC_POZ_DATE_TO='".$_POST['inOHC_POZ_DATE_TO']."',OHC_POZ_Q_DOP='".getFloatValue($_POST['inOHC_POZ_Q_DOP'])."' WHERE OHC_DRS_ID=".$_GET['dev']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($_SESSION['site310_array']);
}
// ==============================================================
//aktualizacja + dodawanie tab3
// ==============================================================
if ($_GET['dev']>0 && $_GET['hcl']>0 && $_POST['sub310Etab3']==$lab_ButtonName_Update)
{
mysql_query("UPDATE seg_object_litolog SET HCL_FROM=".getFloatValue($_POST['inHCL_FROM']).",HCL_TO=".getFloatValue($_POST['inHCL_TO']).",HCL_DESC='".$_POST['inHCL_DESC']."',HCL_AUDIT_CU='".$_SESSION['user']."',HCL_AUDIT_CD=now() WHERE HCL_ID=".$_GET['hcl']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($_SESSION['site310_tab3']);
}
// dodawanie tab3
if ($_GET['dev']>0 && isset($_POST['inHCL_FROM']) && isset($_POST['inHCL_TO']) && $_POST['sub310Atab3']==$lab_ButtonName_Save)
{
mysql_query("INSERT INTO seg_object_litolog SET HCL_DRS_ID=".$_GET['dev'].",HCL_FROM=".getFloatValue($_POST['inHCL_FROM']).",HCL_TO=".getFloatValue($_POST['inHCL_TO']).",HCL_DESC='".$_POST['inHCL_DESC']."',HCL_AUDIT_CU='".$_SESSION['user']."',HCL_AUDIT_CD=now()");
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
unset($_SESSION['site310_tab3']);
}
//usuwanie tab3
if ($_GET['id']>0 && $_GET['tab']==3 && $_GET['acc']=='rem')
{
mysql_query("DELETE FROM seg_object_litolog WHERE HCL_ID=".$_GET['id']);
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
unset($_SESSION['site310_tab3']);
}
// ==============================================================
// tab4
//==================================================================================================================
// dodawanie nowej kolumny
// ==============================================================
if ($_GET['dev']>0 && $_POST['sub310tb4AC']==$lab_ButtonName_Save && isset($_POST['inCOL_DIAMETER']) && isset($_POST['inCOL_DEPTH']) && !empty($_POST['inCOL_NAME']))
{
//dodaje nowÄ… kolumne
mysql_query("INSERT INTO seg_object_columns SET COL_DRS_ID=".$_GET['dev'].",COL_NAME='".$_POST['inCOL_NAME']."',COL_HORYZONT='".$_POST['inCOL_HORYZONT']."',COL_DIAMETER=".getFloatValue($_POST['inCOL_DIAMETER']).",COL_DEPTH=".getFloatValue($_POST['inCOL_DEPTH']).",COL_DESC='".$_POST['inCOL_DESC']."',COL_AUDIT_CU='".$_SESSION['user']."',COL_AUDIT_CD=now()");
$newColID = sqlValue("select max(COL_ID) from seg_object_columns");
//aktualizauje średnice i głębokość
setDiameterAndDepth($_GET['dev'],$newColID);
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
unset($_SESSION['site310_tab4']);
unset($_SESSION['site310_tab6_LS']);
}
// ==============================================================
//edycja istniejÄ…cej kolumny
// ==============================================================
if ($_GET['dev']>0 && $_POST['inCOL_ID']>0 && $_POST['sub310tb4EC']==$lab_ButtonName_Update && !empty($_POST['inCOL_DIAMETER']) && !empty($_POST['inCOL_DEPTH']) && !empty($_POST['inCOL_NAME']))
{
// aktualizauje istniejÄ…cÄ… kolumnÄ™
mysql_query("update seg_object_columns SET COL_NAME='".$_POST['inCOL_NAME']."',COL_HORYZONT='".$_POST['inCOL_HORYZONT']."',COL_DIAMETER=".getFloatValue($_POST['inCOL_DIAMETER']).",COL_DEPTH=".getFloatValue($_POST['inCOL_DEPTH']).",COL_DESC='".$_POST['inCOL_DESC']."',COL_AUDIT_CU='".$_SESSION['user']."',COL_AUDIT_CD=now() where COL_ID=".$_POST['inCOL_ID']);
//aktualizauje średnice i głębokość
setDiameterAndDepth($_GET['dev'],$_POST['inCOL_ID']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($_SESSION['site310_tab4']);
unset($_SESSION['site310_tab6_LS']);
}
// ==============================================================
// usuwanie istniejÄ…cej kolumny
// ==============================================================
if ($_GET['dev']>0 && $_GET['tab']==4 && $getAcction=='del' && $getRecID>0)
{
// usuwa rekord z tabeli seg_object_columns
mysql_query("DELETE FROM seg_object_columns WHERE COL_ID=".$getRecID);
// usuwa rekord z tabeli seg_object_column_filters
mysql_query("DELETE FROM seg_object_column_filters WHERE CLF_COL_ID=".$getRecID);
// usuwa rekord z tabeli seg_object_column_fillings
mysql_query("DELETE FROM seg_object_column_fillings WHERE CLO_COL_ID=".$getRecID);
// usuwa wszystkie wpisy w seg_dev_resources_det dla danej kolumny
mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_DESCRIPTION='".$getRecID."'");
// aktualizauje głębokość i średnicę po usunięciu
setDiameterAndDepth($_GET['dev'],'Aktualizacja po usunięciu kolumny');
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
unset($_SESSION['site310_tab4']);
unset($_SESSION['site310_tab6_LS']);
}
// ==============================================================
//dodawanie filtra
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $_POST['sub310tb4AF']==$lab_ButtonName_Save && isset($_POST['inCLF_FROM']) && isset($_POST['inCLF_TO']) && !empty($_POST['inCLF_NAME']))
{
mysql_query("INSERT INTO seg_object_column_filters SET CLF_DRS_ID=".$_GET['dev'].",CLF_COL_ID=".$_GET['col'].",CLF_NAME='".$_POST['inCLF_NAME']."',CLF_FROM=".getFloatValue($_POST['inCLF_FROM']).",CLF_TO=".getFloatValue($_POST['inCLF_TO']).",CLF_DESC='".$_POST['inCLF_DESC']."',CLF_AUDIT_CU='".$_SESSION['user']."',CLF_AUDIT_CD=now()");
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
}
// ==============================================================
//edycja filtra
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $_POST['sub310tb4EF']==$lab_ButtonName_Update && isset($_POST['inCLF_FROM']) && isset($_POST['inCLF_TO']) && !empty($_POST['inCLF_NAME']))
{
mysql_query("update seg_object_column_filters SET CLF_DRS_ID=".$_GET['dev'].",CLF_COL_ID=".$_GET['col'].",CLF_NAME='".$_POST['inCLF_NAME']."',CLF_FROM=".getFloatValue($_POST['inCLF_FROM']).",CLF_TO=".getFloatValue($_POST['inCLF_TO']).",CLF_DESC='".$_POST['inCLF_DESC']."',CLF_AUDIT_CU='".$_SESSION['user']."',CLF_AUDIT_CD=now() where CLF_ID=".$_POST['inCLF_ID']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
}
// ==============================================================
//usuwanie filtra
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $getAcction=='delf' && $getRecID>0)
{
mysql_query("DELETE FROM seg_object_column_filters WHERE CLF_ID=".$getRecID);
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
}
// ==============================================================
//dodawanie obsypki
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $_POST['sub310tb4AO']==$lab_ButtonName_Save && isset($_POST['inCLO_FROM']) && isset($_POST['inCLO_TO']) && !empty($_POST['inCLO_NAME']))
{
mysql_query("INSERT INTO seg_object_column_fillings SET CLO_DRS_ID=".$_GET['dev'].",CLO_COL_ID=".$_GET['col'].",CLO_NAME='".$_POST['inCLO_NAME']."',CLO_FROM=".getFloatValue($_POST['inCLO_FROM']).",CLO_TO=".getFloatValue($_POST['inCLO_TO']).",CLO_DESC='".$_POST['inCLO_DESC']."',CLO_AUDIT_CU='".$_SESSION['user']."',CLO_AUDIT_CD=now()");
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
}
// ==============================================================
//edycja obsybki
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $_POST['sub310tb4EO']==$lab_ButtonName_Update && isset($_POST['inCLO_FROM']) && isset($_POST['inCLO_TO']) && !empty($_POST['inCLO_NAME']))
{
mysql_query("update seg_object_column_fillings SET CLO_DRS_ID=".$_GET['dev'].",CLO_COL_ID=".$_GET['col'].",CLO_NAME='".$_POST['inCLO_NAME']."',CLO_FROM=".getFloatValue($_POST['inCLO_FROM']).",CLO_TO=".getFloatValue($_POST['inCLO_TO']).",CLO_DESC='".$_POST['inCLO_DESC']."',CLO_AUDIT_CU='".$_SESSION['user']."',CLO_AUDIT_CD=now() where CLO_ID=".$_POST['inCLO_ID']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
}
// ==============================================================
//usuwanie obsybki
// ==============================================================
if ($_GET['dev']>0 && $_GET['col']>0 && $getAcction=='delo' && $getRecID>0)
{
mysql_query("DELETE FROM seg_object_column_fillings WHERE CLO_ID=".$getRecID);
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
}
// ==============================================================
// END tab4
//==================================================================================================================
//aktualizacja tab5
// ==============================================================
if ($_GET['dev']>0 && $_POST['sub310tab5']==$lab_ButtonName_Update)
{
mysql_query("UPDATE seg_object_hole_cards SET OHC_UWAGI='".$_POST['inOHC_UWAGI']."' WHERE OHC_DRS_ID=".$_GET['dev']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($_SESSION['site310_array']);
}
// ==============================================================
//aktualizacja + dodawanie tab6
// ==============================================================
if ($_GET['dev']>0 && ($_POST['sub310Etab6']==$lab_ButtonName_Update || $_POST['sub310Atab6']==$lab_ButtonName_Save) )
{
// echo "ohh: ".$_GET['ohh']."<br/>";
// echo getMaxIDfromMySqlTable("seg_dev_resources");
// numer rekordu pobranego z listy
unset($arrID);
if(empty($_GET['ohh'])) $arrID=0;
else $arrID = $_GET['ohh'];
//pobiera ostatnią wartośc dla rzędnej
unset($rzAct);unset($holeCardsArray);
$holeCardsArray = sqlGetResAsArray("select OHC_GLEB_ODWIER,OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=".$_GET['dev']);
$rzPier = getFloatValue($holeCardsArray[0]['OHC_RZEDNA_TEREN']);
$rzAct = getFloatValue($holeCardsArray[0]['OHC_RZEDNA_TERENU_ACT']);
$glebPier = getFloatValue($holeCardsArray[0]['OHC_GLEB_OSTAT']);
unset($rzNew);
$rzNew = getFloatValue($_POST['inOHH_RZEDNA']);
unset($zasNew);
$zasNew = getFloatValue($_POST['inOHH_ZASYP']);
//if ($rzNew>0)
if (!empty($rzNew))
{
//if ($rzNew<=$rzAct)
//sztuczny warunek
if ($rzNew<1000000)
{
// dodawanie nowej pozycji
// ============================================== ============================================== ==============================================
if ($_GET['add']=='new' && $_POST['sub310Atab6']==$lab_ButtonName_Save)
{
mysql_query("insert into seg_object_hole_cards_his select null,OHH_DRS_ID,OHH_UJ,OHH_NAME,'".$_POST['inOHH_DATE']."' DAT,'".$rzNew."' RZEDNA, '".$zasNew."' ZASYP,'".$_POST['inOHH_ZMIAN_UMIEJ_LOCAL']."','".$_POST['inOHH_ZMIAN_UMIEJ_REASON']."',OHH_PLC from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev'].")");
mysql_query("UPDATE seg_object_hole_cards SET OHC_RZEDNA_TERENU_ACT=".$rzNew." WHERE OHC_DRS_ID=".$_GET['dev']);
unset($actGlebokosc);
$actGlebokosc = (float) ($glebPier - ($rzPier-$rzNew));
mysql_query("delete from seg_dev_resources_det where DRD_RESOURCES_DETAIL in (110,130) and DRD_DRS_ID=".$_GET['dev']);
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=110,DRD_VALUE='".$actGlebokosc."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=130,DRD_VALUE='".$zasNew."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// obcina kolumny
/*
unset($columnArray);
$columnArray = sqlGetResAsArray("select COL_ID,COL_DEPTH from seg_object_columns where COL_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newVal = (float) (getFloatValue($columnArray[$i]['COL_DEPTH']) - ($rzAct-$rzNew));
if ($newVal<0) $newVal=0;
mysql_query("UPDATE seg_object_columns SET COL_DEPTH=".$newVal." WHERE COL_ID=".$columnArray[$i]['COL_ID']);
}
// //obcina filtry
unset($columnArray);
$columnArray = sqlGetResAsArray("select CLF_ID,CLF_FROM,CLF_TO from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newValFrom = (float) (getFloatValue($columnArray[$i]['CLF_FROM']) - ($rzAct-$rzNew));
$newValTo = (float) (getFloatValue($columnArray[$i]['CLF_TO']) - ($rzAct-$rzNew));
if ($newValFrom<0) $newValFrom=0;
if ($newValTo<0) $newValTo=0;
mysql_query("UPDATE seg_object_column_filters SET CLF_FROM=".$newValFrom.",CLF_TO=".$newValTo." WHERE CLF_ID=".$columnArray[$i]['CLF_ID']);
}
//obcina obsypę
unset($columnArray);
$columnArray = sqlGetResAsArray("select CLO_ID,CLO_FROM,CLO_TO from seg_object_column_fillings where CLO_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newValFrom = (float) (getFloatValue($columnArray[$i]['CLO_FROM']) - ($rzAct-$rzNew));
$newValTo = (float) (getFloatValue($columnArray[$i]['CLO_TO']) - ($rzAct-$rzNew));
if ($newValFrom<0) $newValFrom=0;
if ($newValTo<0) $newValTo=0;
mysql_query("UPDATE seg_object_column_fillings SET CLO_FROM=".$newValFrom.",CLO_TO=".$newValTo." WHERE CLO_ID=".$columnArray[$i]['CLO_ID']);
}
*/
}
// ============================================== ============================================== ==============================================
// aktualizacja
// ============================================== ============================================== ==============================================
elseif ($_POST['sub310Etab6']==$lab_ButtonName_Update)
{
mysql_query("UPDATE seg_object_hole_cards_his SET OHH_DATE='".$_POST['inOHH_DATE']."',OHH_RZEDNA='".$rzNew."',OHH_ZASYP='".$zasNew."',OHH_ZMIAN_UMIEJ_LOCAL='".$_POST['inOHH_ZMIAN_UMIEJ_LOCAL']."',OHH_ZMIAN_UMIEJ_REASON='".$_POST['inOHH_ZMIAN_UMIEJ_REASON']."' WHERE OHH_ID=".$_SESSION['site310_tab6'][$arrID]['OHH_ID']);
// jeśli jest aktualizowany ostatni
if ($arrID==0)
{
mysql_query("UPDATE seg_object_hole_cards SET OHC_RZEDNA_TERENU_ACT=".$rzNew." WHERE OHC_DRS_ID=".$_GET['dev']);
unset($actGlebokosc);
$actGlebokosc = (float) ($glebPier - ($rzPier-$rzNew));
mysql_query("delete from seg_dev_resources_det where DRD_RESOURCES_DETAIL in (110,130) and DRD_DRS_ID=".$_GET['dev']);
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=110,DRD_VALUE='".$actGlebokosc."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=130,DRD_VALUE='".$zasNew."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// obcina kolumny
/*
unset($columnArray);
$columnArray = sqlGetResAsArray("select COL_ID,COL_DEPTH from seg_object_columns where COL_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newVal = (float) (getFloatValue($columnArray[$i]['COL_DEPTH']) - ($rzAct-$rzNew));
if ($newVal<0) $newVal=0;
mysql_query("UPDATE seg_object_columns SET COL_DEPTH=".$newVal." WHERE COL_ID=".$columnArray[$i]['COL_ID']);
}
// //obcina filtry
unset($columnArray);
$columnArray = sqlGetResAsArray("select CLF_ID,CLF_FROM,CLF_TO from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newValFrom = (float) (getFloatValue($columnArray[$i]['CLF_FROM']) - ($rzAct-$rzNew));
$newValTo = (float) (getFloatValue($columnArray[$i]['CLF_TO']) - ($rzAct-$rzNew));
if ($newValFrom<0) $newValFrom=0;
if ($newValTo<0) $newValTo=0;
mysql_query("UPDATE seg_object_column_filters SET CLF_FROM=".$newValFrom.",CLF_TO=".$newValTo." WHERE CLF_ID=".$columnArray[$i]['CLF_ID']);
}
//obcina obsypę
unset($columnArray);
$columnArray = sqlGetResAsArray("select CLO_ID,CLO_FROM,CLO_TO from seg_object_column_fillings where CLO_DRS_ID=".$_GET['dev']);
for($i=0; $i<count($columnArray); $i++)
{
unset($newVal);
$newValFrom = (float) (getFloatValue($columnArray[$i]['CLO_FROM']) - ($rzAct-$rzNew));
$newValTo = (float) (getFloatValue($columnArray[$i]['CLO_TO']) - ($rzAct-$rzNew));
if ($newValFrom<0) $newValFrom=0;
if ($newValTo<0) $newValTo=0;
mysql_query("UPDATE seg_object_column_fillings SET CLO_FROM=".$newValFrom.",CLO_TO=".$newValTo." WHERE CLO_ID=".$columnArray[$i]['CLO_ID']);
}
*/
}
}
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
}
else
{
echo"<div class='actionERROR'>Błędna operacja!<br/>Nowa rzędna jest większa od poprzedniej.</div>";
}
unset($_SESSION['site310_tab4']);
unset($_SESSION['site310_tab6']);
unset($_SESSION['site310_tab6_LS']);
unset($_SESSION['site310_array']);
}
echo"<br/>";
/*
if(empty($_GET['ohh'])) $arrID=0;
else $arrID = $_GET['ohh'];
// echo "OLD: ".$_SESSION['site310_tab6'][$arrID]['OHH_ID']."<br/>";
if ($_GET['add']=='new' && $_POST['sub310Atab6']==$lab_ButtonName_Save)
{
mysql_query("insert into seg_object_hole_cards_his select null,OHH_DRS_ID,OHH_UJ,OHH_NAME,OHH_DATE,OHH_RZEDNA,OHH_ZASYP,OHH_ZMIAN_UMIEJ_LOCAL,OHH_ZMIAN_UMIEJ_REASON,OHH_PLC from seg_object_hole_cards_his where OHH_ID=(select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev'].")");
$_SESSION['site310_tab6'][$arrID]['OHH_ID'] = $_SESSION['site310_tab6'][$arrID]['OHH_ID'] = sqlValue("select max(OHH_ID) from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev']);
}
$rzAct = (float) round(str_replace(',','.',sqlValue("select getActRzedna(".$_GET['dev'].")")),2);
// echo "OLD: ".$_SESSION['site310_tab6'][$arrID]['OHH_ID']."<br/>";
mysql_query("UPDATE seg_object_hole_cards_his SET OHH_DATE='".$_POST['inOHH_DATE']."',OHH_RZEDNA='".getFloatValue($_POST['inOHH_RZEDNA'])."',OHH_ZASYP='".getFloatValue($_POST['inOHH_ZASYP'])."',OHH_ZMIAN_UMIEJ_LOCAL='".$_POST['inOHH_ZMIAN_UMIEJ_LOCAL']."',OHH_ZMIAN_UMIEJ_REASON='".$_POST['inOHH_ZMIAN_UMIEJ_REASON']."' WHERE OHH_ID=".$_SESSION['site310_tab6'][$arrID]['OHH_ID']);
// jeśli jest to ostatni wpis aktualizauje również rzędną aktualną.
if ($arrID==0)
{
$rzNew = getFloatValue($_POST['inOHH_RZEDNA']);
if($rzAct != $rzNew)
{
// aktualizauje informacje o nowych parametrach studni w konteoście nowej rzędnej
setNewWellConstructionParameters($_GET['dev'],$rzAct,$rzNew,"Zmiana rzędnej = ".($rzAct - $rzNew));
unset($_SESSION['site310_tab6_LS']);
// ================================================================================
}
// głębokość zasypu
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=130,DRD_VALUE='".getFloatValue($_POST['inOHH_ZASYP'])."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
//aktualizacja rzędnej
mysql_query("UPDATE seg_object_hole_cards SET OHC_RZEDNA_TERENU_ACT='".$rzNew."' WHERE OHC_DRS_ID=".$_GET['dev']);
unset($_SESSION['site310_array']);
//dorobić automatyczną zmianę filtrów przy zmianie rzędnej
}
*/
}
//usuwanie tab6
if ($_GET['id']>0 && $_GET['tab']==6 && $_GET['acc']=='rem')
{
mysql_query("DELETE FROM seg_object_hole_cards_his WHERE OHH_ID=".$_GET['id']);
unset($delTab6ArrayRZ);
$delTab6ArrayRZ = sqlGetResAsArray("select OHH_RZEDNA from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev']." and OHH_DATE=(select max(OHH_DATE) from seg_object_hole_cards_his WHERE OHH_RZEDNA<>0 and OHH_DRS_ID=".$_GET['dev'].") order by OHH_ID desc limit 1");
unset($delTab6ArrayZP);
$delTab6ArrayZP = sqlGetResAsArray("select OHH_ZASYP from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev']." and OHH_DATE=(select max(OHH_DATE) from seg_object_hole_cards_his WHERE OHH_ZASYP<>0 and OHH_DRS_ID=".$_GET['dev'].") order by OHH_ID desc limit 1");
// aktualizacja rzędnej oraz głębokości
mysql_query("UPDATE seg_object_hole_cards SET OHC_RZEDNA_TERENU_ACT=".getFloatValue($delTab6ArrayRZ[0]['OHH_RZEDNA'])." WHERE OHC_DRS_ID=".$_GET['dev']);
unset($delTab6Array1);
$delTab6Array1 = sqlGetResAsArray("select OHC_GLEB_OSTAT,OHC_RZEDNA_TEREN,OHC_RZEDNA_TERENU_ACT from seg_object_hole_cards where OHC_DRS_ID=".$_GET['dev']);
unset($actGlebokosc);
$actGlebokosc = (float) ($delTab6Array1[0]['OHC_GLEB_OSTAT'] - ($delTab6Array1[0]['OHC_RZEDNA_TEREN']-$delTab6Array1[0]['OHC_RZEDNA_TERENU_ACT']));
mysql_query("delete from seg_dev_resources_det where DRD_RESOURCES_DETAIL in (110,130) and DRD_DRS_ID=".$_GET['dev']);
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=110,DRD_VALUE='".$actGlebokosc."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=130,DRD_VALUE='".getFloatValue($delTab6ArrayZP[0]['OHH_ZASYP'])."',DRD_DESCRIPTION='Głębokość',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
unset($_SESSION['site310_tab4']);
unset($_SESSION['site310_tab6']);
unset($_SESSION['site310_tab6_LS']);
unset($_SESSION['site310_array']);
}
// ==============================================================
?>
<?php
if (empty($_SESSION['310_direct'])) $showModifyButton = true;
//pobiera informacje o nazwie oraz rozróżnia, czy to studnia czy piezometr
if (!empty($_SESSION['well_details']['wellName']))
{
$objectType = $lab_Field_site405_011;
$objectName = $_SESSION['well_details']['wellName'];
$objectWaterIntakes = $_SESSION['well_details']['well_Uj'];
if (!empty($_GET['direct']))
{
$_SESSION['310_direct']=$_GET['direct'];
$showModifyButton = false;
}
if (!empty($_SESSION['310_direct']))
$objectUrlHisBack = "./?pg=site".$_SESSION['310_direct']."inf&dev=".$_GET['dev'];
else
$objectUrlHisBack = "./?pg=site301inf&dev=".$_GET['dev'];
}
elseif (!empty($_SESSION['site309inf_array'][0]['SRP_NAME']) || !empty($_SESSION['site404inf_array'][0]['SRP_NAME']))
{
if (!empty($_SESSION['site404inf_array'][0]['SRP_NAME']))
{
$_SESSION['site309inf_array'][0]['SRP_NAME']= $_SESSION['site404inf_array'][0]['SRP_NAME'];
$_SESSION['site309inf_array'][0]["SRP_BARIERA"] = $_SESSION['site404inf_array'][0]['SRP_BARIERA'];
}
$objectType = $lab_Tag_site309_003;
$objectName = $_SESSION['site309inf_array'][0]['SRP_NAME'];
$objectWaterIntakes = $_SESSION['site309inf_array'][0]["SRP_BARIERA"];
if (!empty($_GET['direct']))
{
$_SESSION['310_direct']=$_GET['direct'];
$showModifyButton = false;
}
if (!empty($_SESSION['310_direct']))
$objectUrlHisBack = "./?pg=site".$_SESSION['310_direct']."inf&dev=".$_GET['dev'];
else
$objectUrlHisBack = "./?pg=site309inf&dev=".$_GET['dev'];
$lab_ButtonName_HoleCard_002 = 'Zalewanie';
}
?>
<?php
$decFieldLang = setDictionaryFieldLanguage($_SESSION['lang']);
if (empty($_GET['tab'])) $_GET['tab']=1;
// pobiera dane
//if(empty($_SESSION['site310_array']))
$_SESSION['site310_array'] = sqlGetResAsArray("select * from seg_object_hole_cards where OHC_DRS_ID=".$_GET['dev']);
//$_SESSION['site310_array'][0]['']
?>
<div class="tag100">
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=1' <?php if($_GET['tab']==1) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_001; ?></a>
<?php if ($_SESSION['site310_array'][0]['OHC_RZEDNA_TEREN']!=0 && $_SESSION['site310_array'][0]['OHC_GLEB_OSTAT']!=0): ?>
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=2' <?php if($_GET['tab']==2) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_002; ?></a>
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=3' <?php if($_GET['tab']==3) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_003; ?></a>
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=4' <?php if($_GET['tab']==4) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_004; ?></a>
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=5' <?php if($_GET['tab']==5) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_005; ?></a>
<a href='./?pg=site310&dev=<?php echo $_GET['dev'];?>&tab=6' <?php if($_GET['tab']==6) echo" class='btn btn-primary btn-sm'"; else echo" class='btn btn-default btn-sm'"; ?> style='text-decoration: none;' role='button'><?php echo $lab_ButtonName_HoleCard_006; ?></a>
<?php endif; ?>
</div>
<?php if ($_GET['tab']==1): ?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_ButtonName_HoleCard_001 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table class="desc_val">
<tr>
<td class="desc"><?php echo $lab_Field_site310_001;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_WYKONAWCA'];?></td>
</tr>
<tr>
<td class="desc"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_004; ?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_005;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_ROK_WYKON'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_006;?></td>
<td class="desc_value"><?php echo str_replace('0000-00-00','',$_SESSION['site310_array'][0]['OHC_ROZP_WIER_DATE']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_007;?></td>
<td class="desc_value"><?php echo str_replace('0000-00-00','',$_SESSION['site310_array'][0]['OHC_ZAK_WIER_DATE']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_008;?></td>
<td class="desc_value"><?php echo str_replace('0000-00-00','',$_SESSION['site310_array'][0]['OHC_DATA_ODDANIA']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_009;?></td>
<td class="desc_value"><?php echo str_replace('0000-00-00','',$_SESSION['site310_array'][0]['OHC_ZDJECIE_EXPL_DATE']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_010;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_URZ_WIERT'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_011;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_SPOS_WIERC'];?></td>
</tr>
<tr>
<td class="desc"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_012; ?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_002;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_DL_GEOGR'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_003;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_SZER_GEOGR'];?></td>
</tr>
<tr>
<td class="desc"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_013; ?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_014;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_RZEDNA_TEREN'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_015;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_RZEDNA_KRYZY'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_016;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_POZIOM_WODONOS'];?></td>
</tr>
<tr>
<td class="desc"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_017; ?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_018;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_GLEB_ODWIER'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_019;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_GLEB_OSTAT'];?></td>
</tr>
<tr>
<td class="desc"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_020; ?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_021;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_ZWIERC_NAWIERC'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_022;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_ZWIERC_USTAL'];?></td>
</tr>
</table>
</div>
</div>
<?php elseif ($_GET['tab']==2): ?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_ButtonName_HoleCard_002 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table class="desc_val">
<tr>
<td class="desc" style="width: 10%;">Q<sub>1</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_Q1'];?></td>
<td class="desc" style="width: 10%;">S<sub>1</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_S1'];?></td>
<td class="desc" style="width: 10%;">T<sub>1</sub> [s]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_T1'];?></td>
</tr>
<tr>
<td class="desc" style="width: 10%;">Q<sub>2</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_Q2'];?></td>
<td class="desc" style="width: 10%;">S<sub>2</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_S2'];?></td>
<td class="desc" style="width: 10%;">T<sub>2</sub> [s]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_T2'];?></td>
</tr>
<tr>
<td class="desc" style="width: 10%;">Q<sub>3</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_Q3'];?></td>
<td class="desc" style="width: 10%;">S<sub>3</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_S3'];?></td>
<td class="desc" style="width: 10%;">T<sub>3</sub> [s]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_T3'];?></td>
</tr>
<tr>
<td class="desc" style="width: 10%;">Q<sub>4</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_Q4'];?></td>
<td class="desc" style="width: 10%;">S<sub>4</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_S4'];?></td>
<td class="desc" style="width: 10%;">T<sub>4</sub> [s]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_T4'];?></td>
</tr>
<tr>
<td class="desc" style="width: 10%;">Q<sub>5</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_Q5'];?></td>
<td class="desc" style="width: 10%;">S<sub>5</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_S5'];?></td>
<td class="desc" style="width: 10%;">T<sub>5</sub> [s]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_T5'];?></td>
</tr>
</table>
<table class="desc_val">
<tr>
<td class="desc_equipment"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_023; ?></td>
</tr>
<tr>
<td class="desc_equipment">Q<sub>e</sub> [m<sup>3</sup>/min]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_QE'];?></td>
</tr>
<tr>
<td class="desc_equipment">S<sub>e</sub> [m]</td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_SE'];?></td>
</tr>
<tr>
<td class="desc_equipment"><?php echo $lab_Field_site310_024;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_WYD_JEDN'];?></td>
</tr>
<tr>
<td class="desc_equipment"><?php echo $lab_Field_site310_025;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_WSP_SPR_HYDRO'];?></td>
</tr>
<tr>
<td class="desc_equipment"></td>
<td class="desc_value" style="background-color:#EAEAEA; font-weight: bold;"><?php echo $lab_Field_site310_026; ?></td>
</tr>
<tr>
<td class="desc_equipment"><?php echo $lab_Field_site310_032;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_POZ_WOD_NO'];?></td>
</tr>
<tr>
<td class="desc_equipment"><?php echo $lab_Field_site310_027;?></td>
<td class="desc_value"><?php echo str_replace('0000-00-00','',$_SESSION['site310_array'][0]['OHC_POZ_DATE_TO']);?></td>
</tr>
<tr>
<td class="desc_equipment"><?php echo $lab_Field_site310_028;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_array'][0]['OHC_POZ_Q_DOP'];?></td>
</tr>
</table>
</div>
</div>
<?php elseif ($_GET['tab']==3): ?>
<?php
//ukrywa przycisk Modyfikuj
$showModifyButton = false;
if (empty($_SESSION['site310_tab3'])) $_SESSION['site310_tab3']=sqlGetResAsArray("select HCL_ID,HCL_FROM,HCL_TO,HCL_DESC from seg_object_litolog where HCL_DRS_ID=".$_GET['dev']." order by HCL_FROM");
?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_ButtonName_HoleCard_003 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table WIDTH="100%" class="tag">
<tr>
<td class="label"><?php echo $lab_Field_site310_029 ;?></td>
<td class="label"><?php echo $lab_Field_site310_030 ;?></td>
<td class="label"><?php echo $lab_Field_site310_031 ;?></td>
<?php if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])): ?>
<td class="label"><a href="./?pg=site310tb3A&dev=<?php echo $_GET['dev'];?>"><img src="./images/add_ico.png" title="<?php echo $lab_Field_site803_006;?>"></a></td>
<?php endif; ?>
</tr>
<?php
for($i=0; $i<count($_SESSION['site310_tab3']); $i++)
{
echo"
<tr>
<td class='field_left'>".$_SESSION['site310_tab3'][$i]['HCL_FROM']."</td>
<td class='field_left'>".$_SESSION['site310_tab3'][$i]['HCL_TO']."</td>
<td class='field_left'>".$_SESSION['site310_tab3'][$i]['HCL_DESC']."</td>
";
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
{
echo"
<td class='field_center' style='width: 10%;'>
<a href='./?pg=site310tb3&dev=".$_GET['dev']."&arr=".$i."'><img src='./images/edit.png' title='".$lab_ButtonName_Edit."' border='0'></a>
&nbsp;&nbsp;&nbsp;
<a href='./?pg=site310&dev=".$_GET['dev']."&tab=3&id=".$_SESSION['site310_tab3'][$i]['HCL_ID']."&acc=rem'><img src='./images/remove_ico.png' title='".$lab_ButtonName_Delete."' border='0' onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć?');".chr(34)."></a>
</td>";
}
echo"</tr>";
}
?>
</table>
</div>
</div>
<?php elseif ($_GET['tab']==4): ?>
<?php
//ukrywa przycisk Modyfikuj
$showModifyButton = false;
//if (empty($_SESSION['site310_tab4'])) $_SESSION['site310_tab4']=sqlGetResAsArray("select * from seg_object_columns where COL_DRS_ID=".$_GET['dev']." order by COL_ID");
$_SESSION['site310_tab4']=sqlGetResAsArray("select * from seg_object_columns where COL_DRS_ID=".$_GET['dev']." order by COL_ID");
?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_ButtonName_HoleCard_004 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table WIDTH="100%" class="tag">
<tr>
<td class="label"><?php echo $lab_Field_site310_045 ;?></td>
<td class="label"><?php echo $lab_Field_site310_050 ;?></td>
<td class="label"><?php echo $lab_Field_site203_011 ;?></td>
<td class="label"><?php echo $lab_Field_site302_007 ;?></td>
<td class="label"><?php echo $lab_Field_site310_046 ;?></td>
<?php if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])): ?>
<td class="label"><a href="./?pg=site310tb4C&dev=<?php echo $_GET['dev'];?>&param=4,add"><img src="./images/add_ico.png" title="<?php echo $lab_Field_site803_006;?>"></a></td>
<?php endif; ?>
</tr>
<?php
for($i=0; $i<count($_SESSION['site310_tab4']); $i++)
{
if ($_GET['col'] == $_SESSION['site310_tab4'][$i]['COL_ID'])
$checkStyle = 'background-color: #ffff00;';
else $checkStyle = '';
echo"
<tr style='cursor: pointer; ".$checkStyle."' onclick=".chr(34)."document.location.href='./?pg=site310&dev=".$_GET['dev']."&tab=4&col=".$_SESSION['site310_tab4'][$i]['COL_ID']."'".chr(34).">
<td class='field_left'>".$_SESSION['site310_tab4'][$i]['COL_NAME']."</td>
<td class='field_left'>".$_SESSION['site310_tab4'][$i]['COL_HORYZONT']."</td>
<td class='field_left'>".$_SESSION['site310_tab4'][$i]['COL_DIAMETER']."</td>
<td class='field_left'>".round(getFloatValue($_SESSION['site310_tab4'][$i]['COL_DEPTH'])-getSciecie($_GET['dev']),2)."</td>
<td class='field_left'>".$_SESSION['site310_tab4'][$i]['COL_DESC']."</td>
";
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
{
echo"
<td class='field_center' style='width: 10%;'>
<a href='./?pg=site310tb4C&dev=".$_GET['dev']."&param=4,edit,".$i."'><img src='./images/edit.png' title='".$lab_ButtonName_Edit."' border='0'></a>
&nbsp;&nbsp;&nbsp;
<a href='./?pg=site310&dev=".$_GET['dev']."&param=4,del,".$_SESSION['site310_tab4'][$i]['COL_ID']."'><img src='./images/remove_ico.png' title='".$lab_ButtonName_Delete."' border='0' onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć?');".chr(34)."></a>
</td>";
}
echo"</tr>";
}
?>
</table>
</div>
<?php
if ($_GET['col']>0)
{
$_SESSION['site310F_tab4'] = sqlGetResAsArray("select * from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev']." and CLF_COL_ID=".$_GET['col']." order by CLF_FROM");
echo'
<table WIDTH="100%" class="tag">
<tr>
<td class="label">'.$lab_Field_site310_047.'</td>
<td class="label">'.$lab_Field_site310_029.'</td>
<td class="label">'.$lab_Field_site310_030.'</td>
<td class="label">'.$lab_Field_site310_046.'</td>
';
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
echo'<td class="label"><a href="./?pg=site310tb4F&dev='.$_GET['dev'].'&param=4,add,'.$_GET['col'].'"><img src="./images/add_ico.png" title="'.$lab_Field_site803_006.'"></a></td>';
echo'
</tr>';
for($i=0; $i<count($_SESSION['site310F_tab4']); $i++)
{
echo"
<tr>
<td class='field_left'>".$_SESSION['site310F_tab4'][$i]['CLF_NAME']."</td>
<td class='field_right'>".round(getFloatValue($_SESSION['site310F_tab4'][$i]['CLF_FROM'])-getSciecie($_GET['dev']),2)."</td>
<td class='field_right'>".round(getFloatValue($_SESSION['site310F_tab4'][$i]['CLF_TO'])-getSciecie($_GET['dev']),2)."</td>
<td class='field_left'>".$_SESSION['site310F_tab4'][$i]['CLF_DESC']."</td>
";
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
{
echo"
<td class='field_center' style='width: 10%;'>
<a href='./?pg=site310tb4F&dev=".$_GET['dev']."&param=4,edit,".$_GET['col'].",".$i."'><img src='./images/edit.png' title='".$lab_ButtonName_Edit."' border='0'></a>
&nbsp;&nbsp;&nbsp;
<a href='./?pg=site310&dev=".$_GET['dev']."&col=".$_GET['col']."&param=4,delf,".$_SESSION['site310F_tab4'][$i]['CLF_ID']."'><img src='./images/remove_ico.png' title='".$lab_ButtonName_Delete."' border='0' onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć?');".chr(34)."></a>
</td>";
}
echo"
</tr>";
}
echo'</table>';
echo"<br/>";
$_SESSION['site310O_tab4'] = sqlGetResAsArray("select * from seg_object_column_fillings where CLO_DRS_ID=".$_GET['dev']." and CLO_COL_ID=".$_GET['col']." order by CLO_FROM");
echo'
<table WIDTH="100%" class="tag">
<tr>
<td class="label">'.$lab_Field_site310_048.'</td>
<td class="label">'.$lab_Field_site310_029.'</td>
<td class="label">'.$lab_Field_site310_030.'</td>
<td class="label">'.$lab_Field_site310_046.'</td>
';
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
echo'<td class="label"><a href="./?pg=site310tb4O&dev='.$_GET['dev'].'&param=4,add,'.$_GET['col'].'"><img src="./images/add_ico.png" title="'.$lab_Field_site803_006.'"></a></td>';
echo'
</tr>';
for($i=0; $i<count($_SESSION['site310O_tab4']); $i++)
{
echo"
<tr>
<td class='field_left'>".$_SESSION['site310O_tab4'][$i]['CLO_NAME']."</td>
<td class='field_right'>".round(getFloatValue($_SESSION['site310O_tab4'][$i]['CLO_FROM'])-getSciecie($_GET['dev']),2)."</td>
<td class='field_right'>".round(getFloatValue($_SESSION['site310O_tab4'][$i]['CLO_TO'])-getSciecie($_GET['dev']),2)."</td>
<td class='field_left'>".$_SESSION['site310O_tab4'][$i]['CLO_DESC']."</td>
";
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
{
echo"
<td class='field_center' style='width: 10%;'>
<a href='./?pg=site310tb4O&dev=".$_GET['dev']."&param=4,edit,".$_GET['col'].",".$i."'><img src='./images/edit.png' title='".$lab_ButtonName_Edit."' border='0'></a>
&nbsp;&nbsp;&nbsp;
<a href='./?pg=site310&dev=".$_GET['dev']."&col=".$_GET['col']."&param=4,delo,".$_SESSION['site310O_tab4'][$i]['CLO_ID']."'><img src='./images/remove_ico.png' title='".$lab_ButtonName_Delete."' border='0' onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć?');".chr(34)."></a>
</td>";
}
echo"
</tr>";
}
echo'</table>';
}
?>
</div>
<?php elseif ($_GET['tab']==5): ?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_ButtonName_HoleCard_005 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table style="width: 100%; height: 300px;">
<tr>
<td class="field_left" style="vertical-align:top;"><?php echo str_replace(chr(10),'<br/>',$_SESSION['site310_array'][0]['OHC_UWAGI']);?></td>
</tr>
</table>
</div>
</div>
<?php elseif ($_GET['tab']==6): ?>
<?php
//ukrywa przycisk Modyfikuj
$showModifyButton = false;
//2019-03-23
$_SESSION['site310_tab6_LS'] = getGlebokoscAct($_GET['dev']);
/*
if (empty($_SESSION['site310_tab6_LS']))
{
$_SESSION['site310_tab6_LS']= round(sqlValue("select getLastValue(110,".$_GET['dev'].")"),2);
}
*/
if(empty($_SESSION['site310_tab6']))
$_SESSION['site310_tab6'] = sqlGetResAsArray("select OHH_ID,OHH_DATE,OHH_RZEDNA,OHH_ZASYP,OHH_ZMIAN_UMIEJ_LOCAL,OHH_ZMIAN_UMIEJ_REASON from seg_object_hole_cards_his where OHH_DRS_ID=".$_GET['dev']." order by OHH_DATE desc,OHH_ID desc");
$arrayCount = count($_SESSION['site310_tab6'])-1;
if (empty($_GET['ohh'])) $_GET['ohh']=0;
$shIndex = $_GET['ohh'];
?>
<div class="tag100">
<div class="head_tag"><?php echo $lab_Field_site310_033 ;?></div>
<div class="tag">
<table style="padding-bottom: 10px;"><tr><td><?php echo $objectType;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectName;?></td><td style="padding-left: 100px;"><?php echo $lab_Field_site301_014;?></td><td style="padding-left: 5px; font-weight: bold;"><?php echo $objectWaterIntakes;?></td></tr></table>
<table WIDTH="100%" class="tag">
<tr>
<td class="label"><?php echo $lab_Field_site310_034 ;?></td>
<td class="label"><?php echo $lab_Field_site310_035 ;?></td>
<td class="label"><?php echo $lab_Field_site310_036 ;?></td>
<?php if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])): ?>
<td class="label"><a href="./?pg=site310tb6&dev=<?php echo $_GET['dev'];?>&add=new"><img src="./images/add_ico.png" title="<?php echo $lab_Field_site803_006;?>"></a></td>
<?php endif; ?>
</tr>
<?php
$showAll = false;
if ($arrayCount>5 && $_GET['sh']=='all')
$recCount = $arrayCount+1;
elseif ($arrayCount>5 && empty($_GET['sh']))
{
$recCount = 5;
$showAll = true;
}
else $recCount = $arrayCount+1;
for ($i=0; $i<$recCount; $i++)
{
if (($i==0 && empty($_GET['ohh'])) || $_GET['ohh'] == $i)
$checkStyle = 'background-color: #ffff00;';
else $checkStyle = '';
echo"
<tr style='cursor: pointer; ".$checkStyle."' onclick=".chr(34)."document.location.href='./?pg=site310&dev=".$_GET['dev']."&tab=6&sh=".$_GET['sh']."&ohh=".$i."'".chr(34).">
<td class='field_center'>".$_SESSION['site310_tab6'][$i]['OHH_DATE']."</td>
<td class='field_right'>".getFloatValue($_SESSION['site310_tab6'][$i]['OHH_RZEDNA'])."</td>
<td class='field_right'>".getFloatValue($_SESSION['site310_tab6'][$i]['OHH_ZASYP'])."</td>
";
if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct']))
{
echo"<td class='field_center' style='width: 10%;'>";
if ($i==0)
{
echo"
<a href='./?pg=site310tb6&dev=".$_GET['dev']."&arr=".$i."'><img src='./images/edit.png' title='".$lab_ButtonName_Edit."' border='0'></a>
&nbsp;&nbsp;&nbsp;";
}
echo"
<a href='./?pg=site310&dev=".$_GET['dev']."&tab=6&sh=".$_GET['sh']."&id=".$_SESSION['site310_tab6'][$i]['OHH_ID']."&acc=rem'><img src='./images/remove_ico.png' title='".$lab_ButtonName_Delete."' border='0' onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć?');".chr(34)."></a>
</td>";
}
echo"</tr>";
}
?>
</table>
<?php
if ($showAll)
echo'
<table>
<tr>
<td><a class="blue_under_table" href="./?pg=site310&dev='.$_GET['dev'].'&tab=6&sh=all">'.$lab_Field_site310_043.'</a></td>
</tr>
</table>
';
?>
</div>
<div class="head_tag"><?php echo $lab_Field_site310_037 ;?></div>
<div class="tag">
<table class="desc_val">
<tr>
<td class="desc"><?php echo $lab_Field_site310_038;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_tab6'][$shIndex]['OHH_DATE'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site403_002;?> [m]</td>
<td class="desc_value"><?php echo getStringFloatRound($_SESSION['site310_tab6_LS']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site403_004;?> [m]</td>
<td class="desc_value"><?php echo getStringFloatRound($_SESSION['site310_tab6'][$shIndex]['OHH_ZASYP']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_039;?></td>
<td class="desc_value"><?php echo getStringFloatRound($_SESSION['site310_array'][0]['OHC_RZEDNA_TEREN']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_044;?></td>
<td class="desc_value"><?php echo getStringFloatRound($_SESSION['site310_array'][0]['OHC_RZEDNA_TERENU_ACT']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_040;?></td>
<td class="desc_value"><?php echo getStringFloatRound($_SESSION['site310_tab6'][$shIndex]['OHH_RZEDNA']);?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_041;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_tab6'][$shIndex]['OHH_ZMIAN_UMIEJ_LOCAL'];?></td>
</tr>
<tr>
<td class="desc"><?php echo $lab_Field_site310_042;?></td>
<td class="desc_value"><?php echo $_SESSION['site310_tab6'][$shIndex]['OHH_ZMIAN_UMIEJ_REASON'];?></td>
</tr>
</table>
</div>
</div>
<?php endif; ?>
<?php
//buduje linki do edycji danych
if ($_GET['tab']==1) $urlLink = "./?pg=site310tb1&dev=".$_GET['dev'];
elseif ($_GET['tab']==2) $urlLink = "./?pg=site310tb2&dev=".$_GET['dev'];
elseif ($_GET['tab']==3) $urlLink = "./?pg=site310tb3&dev=".$_GET['dev'];
elseif ($_GET['tab']==4) $urlLink = "./?pg=site310tb4&dev=".$_GET['dev'];
elseif ($_GET['tab']==5) $urlLink = "./?pg=site310tb5&dev=".$_GET['dev'];
//elseif ($_GET['tab']==6) $urlLink = "/?pg=site310tb6&dev=".$_GET['dev'];
?>
<div class="tag50_left">
<div class="tag_buttons" style="text-align: left;">
<button type="button" class="btn btn-default btn-sm" onclick="window.print();">Drukuj</button>
</div>
</div>
<div class="tag50_right">
<div class="tag_buttons">
<a class="btn btn-info btn-sm" style="text-decoration: none;" href="<?php echo $objectUrlHisBack;?>" role="button"><?php echo $lab_ButtonName_Back; ?></a>
<?php if (!empty($_SESSION['site310_edit']) && $showModifyButton): ?>
<a class="btn btn-success btn-sm" style="text-decoration: none;" href="<?php echo $urlLink;?>" role="button"><?php echo $lab_ButtonName_Modify; ?></a>
<?php endif; ?>
</div>
</div>
<?php
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>