$lab_SaveRecordNotification_001"; } // Aktualizacja zbiornika if (!empty($_POST['inRePieName']) && $_POST['subRePieUpdate']==$lab_ButtonName_Update ) { mysql_query("update seg_reservoirs_piezometers SET SRP_MCF_ID=".$_POST['inRePieNManufID'].",SRP_NAME='".$_POST['inRePieName']."',SRP_TYPE_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='PIEZOMETER'),SRP_LATITUDE='".getFloatValue($_POST['inRePieLat'])."',SRP_LONGITUDE='".getFloatValue($_POST['inRePieLong'])."' where SRP_ID=".$_POST['sprid']); mysql_query("update seg_dev_resources SET DRS_SN_NUMBER='".$_POST['inRePieSN']."',DRS_BUY_DATE='".$_POST['inRePieBuyDate']."',DRS_STATUS_DIC_ID=".$_POST['inRePieStatus'].",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_POST['dev']); //poziomy wody - położenie mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMaxAcc'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MAX_ACCEPTABLE'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMaxWar'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MAX_WARNING'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMinWar'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MIN_WARNING'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMinAcc'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MIN_ACCEPTABLE'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); // środek trwały mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".$_POST['inRePieAsset']."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); // głębokość mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DEPTH'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); // średnica mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DIAMETER'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); echo"
$lab_UpdateRecordNotification_001
"; } // zamiana piezometru w studnię if (!empty($_GET['piezo2stu'])) { //piezo2stu=2840,a78482ce76496fcf49085f2190e675b4,piezo2stu unset($piezo2stuArray); $piezo2stuArray = explode(',',$_GET['piezo2stu']); if ($piezo2stuArray[1]==md5($piezo2stuArray[0]) && $piezo2stuArray[2]=='piezo2stu') { unset($piezoArray); $piezoArray = sqlGetResAsArray("select * from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and DRS_ID=".$piezo2stuArray[0]); // zakłada nową studnie if (sqlValue("select count(*) from seg_wells where WLL_NAME='".$piezoArray[0]['SRP_NAME']."'")==0) { mysql_query("INSERT INTO seg_wells SET WLL_SWI_ID=".$piezoArray[0]['SRP_SWI_ID'].",WLL_BARIERA='".$piezoArray[0]['SRP_BARIERA']."',WLL_NAME='".$piezoArray[0]['SRP_NAME']."',WLL_CAT_DIC_ID=20,WLL_LATITUDE='".$piezoArray[0]['SRP_LATITUDE']."',WLL_LONGITUDE='".$piezoArray[0]['SRP_LONGITUDE']."',WLL_PP_SCOPE='500'"); $newID = getMaxIDfromMySqlTable('seg_wells'); mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$newID.",DRS_DEV_TYPE=12,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=902,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$piezo2stuArray[0]); } else // aktualizuje istniejącą { unset($curWell); $curWell = sqlGetResAsArray("select WLL_ID from seg_wells where WLL_NAME='".$piezoArray[0]['SRP_NAME']."'"); mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$curWell[0]['WLL_ID'].",DRS_DEV_TYPE=12,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=902,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$piezo2stuArray[0]); unset($curWell); } echo"
Piezometr został pomyślnie przekształcony w studnię.
"; } unset($piezo2stuArray); } if (!$_POST['sr_status']) $_POST['sr_status']=3; ?>
Piezometr: status:
 
"; else echo""; ?> Pokaż wszystkie
$r["DRS_ID"], 'name' => $r["SRP_NAME"], 'bariera' => $r["SRP_BARIERA"], 'rodzaj' => $r["SRP_SYS_TYPE"], 'status' => setDicName($r["DRS_STATUS_DIC_ID"]), 'typ' => setDicName($r["DRS_RESOURCES_DIC_ID"]), 'ster' => setDicName($r["SRP_MCF_ID"]) ); } unset($_SESSION['site309_array']); $_SESSION['site309_array']=$res; } $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site309_array'])) $stop=count($_SESSION['site309_array']); for($i=$start;$i<$stop;$i++) { echo" "; } ?>
Lp. Sterowanie
".($i+1).". ".$_SESSION['site309_array'][$i]['name']." ".$_SESSION['site309_array'][$i]['bariera']." ".$_SESSION['site309_array'][$i]['rodzaj']." ".$_SESSION['site309_array'][$i]['status']." ".$_SESSION['site309_array'][$i]['typ']." ".$_SESSION['site309_array'][$i]['ster']."
Wyników: 20) echo pagination_grid('?pg=site309', $_GET['pgn'], count($_SESSION['site309_array'])); ?>    
"; ?>