0) ensureHoleCardExists($_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"
$lab_UpdateRecordNotification_001
"; 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"
$lab_UpdateRecordNotification_001
"; 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"
$lab_UpdateRecordNotification_001
"; 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"
$lab_SaveRecordNotification_001
"; 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"
$lab_DeleteRecordNotification_001
"; 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"
$lab_SaveRecordNotification_001
"; 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"
$lab_UpdateRecordNotification_001
"; 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"
$lab_DeleteRecordNotification_001
"; 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"
$lab_SaveRecordNotification_001
"; } // ============================================================== //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"
$lab_UpdateRecordNotification_001
"; } // ============================================================== //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"
$lab_DeleteRecordNotification_001
"; } // ============================================================== //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"
$lab_SaveRecordNotification_001
"; } // ============================================================== //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"
$lab_UpdateRecordNotification_001
"; } // ============================================================== //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"
$lab_DeleteRecordNotification_001
"; } // ============================================================== // 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"
$lab_UpdateRecordNotification_001
"; 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']."
"; // 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$lab_UpdateRecordNotification_001"; } else { echo"
Błędna operacja!
Nowa rzędna jest większa od poprzedniej.
"; } unset($_SESSION['site310_tab4']); unset($_SESSION['site310_tab6']); unset($_SESSION['site310_tab6_LS']); unset($_SESSION['site310_array']); } echo"
"; /* if(empty($_GET['ohh'])) $arrID=0; else $arrID = $_GET['ohh']; // echo "OLD: ".$_SESSION['site310_tab6'][$arrID]['OHH_ID']."
"; 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']."
"; 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"
$lab_DeleteRecordNotification_001
"; unset($_SESSION['site310_tab4']); unset($_SESSION['site310_tab6']); unset($_SESSION['site310_tab6_LS']); unset($_SESSION['site310_array']); } // ============================================================== ?>
&tab=1' style='text-decoration: none;' role='button'> &tab=2' style='text-decoration: none;' role='button'> &tab=3' style='text-decoration: none;' role='button'> &tab=4' style='text-decoration: none;' role='button'> &tab=5' style='text-decoration: none;' role='button'> &tab=6' style='text-decoration: none;' role='button'>
Q1 [m3/min] S1 [m] T1 [s]
Q2 [m3/min] S2 [m] T2 [s]
Q3 [m3/min] S3 [m] T3 [s]
Q4 [m3/min] S4 [m] T4 [s]
Q5 [m3/min] S5 [m] T5 [s]
Qe [m3/min]
Se [m]
"; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) { echo" "; } echo""; } ?>
".$_SESSION['site310_tab3'][$i]['HCL_FROM']." ".$_SESSION['site310_tab3'][$i]['HCL_TO']." ".$_SESSION['site310_tab3'][$i]['HCL_DESC']."    
"; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) { echo" "; } echo""; } ?>
".$_SESSION['site310_tab4'][$i]['COL_NAME']." ".$_SESSION['site310_tab4'][$i]['COL_HORYZONT']." ".$_SESSION['site310_tab4'][$i]['COL_DIAMETER']." ".round(getFloatValue($_SESSION['site310_tab4'][$i]['COL_DEPTH'])-getSciecie($_GET['dev']),2)." ".$_SESSION['site310_tab4'][$i]['COL_DESC']."    
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' '; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) echo''; echo' '; for($i=0; $i "; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) { echo" "; } echo" "; } echo'
'.$lab_Field_site310_047.' '.$lab_Field_site310_029.' '.$lab_Field_site310_030.' '.$lab_Field_site310_046.'
".$_SESSION['site310F_tab4'][$i]['CLF_NAME']." ".round(getFloatValue($_SESSION['site310F_tab4'][$i]['CLF_FROM'])-getSciecie($_GET['dev']),2)." ".round(getFloatValue($_SESSION['site310F_tab4'][$i]['CLF_TO'])-getSciecie($_GET['dev']),2)." ".$_SESSION['site310F_tab4'][$i]['CLF_DESC']."    
'; echo"
"; $_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' '; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) echo''; echo' '; for($i=0; $i "; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) { echo" "; } echo" "; } echo'
'.$lab_Field_site310_048.' '.$lab_Field_site310_029.' '.$lab_Field_site310_030.' '.$lab_Field_site310_046.'
".$_SESSION['site310O_tab4'][$i]['CLO_NAME']." ".round(getFloatValue($_SESSION['site310O_tab4'][$i]['CLO_FROM'])-getSciecie($_GET['dev']),2)." ".round(getFloatValue($_SESSION['site310O_tab4'][$i]['CLO_TO'])-getSciecie($_GET['dev']),2)." ".$_SESSION['site310O_tab4'][$i]['CLO_DESC']."    
'; } ?>
',$_SESSION['site310_array'][0]['OHC_UWAGI']);?>
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" "; if (!empty($_SESSION['site310_edit']) && empty($_SESSION['310_direct'])) { echo""; } echo""; } ?>
".$_SESSION['site310_tab6'][$i]['OHH_DATE']." ".getFloatValue($_SESSION['site310_tab6'][$i]['OHH_RZEDNA'])." ".getFloatValue($_SESSION['site310_tab6'][$i]['OHH_ZASYP']).""; if ($i==0) { echo"    "; } echo"
'.$lab_Field_site310_043.' '; ?>
[m]
[m]