0)
{
// sprawdza i dodaje studnię do dodaje studnię do tabeli seg_wells
if (sqlValue("select count(*) from seg_wells where WLL_NAME='".$_POST['inWellName']."'")==0)
{
$ujName = sqlStringValue("select SWI_NAME from seg_water_intakes where SWI_ID=".$_POST['inWellBariera'],"SWI_NAME");
mysql_query("INSERT INTO seg_wells SET WLL_NAME='".$_POST['inWellName']."',WLL_SWI_ID=".$_POST['inWellBariera'].",WLL_BARIERA='".$ujName."',WLL_CAT_DIC_ID=".$_POST['inWellCategory'].",WLL_LATITUDE='".getFloatValue($_POST['inWellLat'])."',WLL_LONGITUDE='".getFloatValue($_POST['inWellLong'])."'");
$maxWELLid = sqlValue("select max(WLL_ID) from seg_wells");
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=$maxWELLid,DRS_DEV_TYPE=12,DRS_AVAILABLE_DATE=now(),DRS_BUY_DATE=now(),DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=".$_POST['inWellStatus'].",DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()");
$maxDRSid = sqlValue("select max(DRS_ID) from seg_dev_resources");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='DST'),DRD_VALUE='".getFloatValue($_POST['inWellDiame'])."',DRD_AUDIT_DATE=now(),DRD_AUDIT_USR='".$_SESSION['user']."'");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LS'),DRD_VALUE='".getFloatValue($_POST['inWellDepth'])."',DRD_AUDIT_DATE=now(),DRD_AUDIT_USR='".$_SESSION['user']."'");
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LF'),DRD_VALUE='".$_POST['inWellFilter']."',DRD_AUDIT_DATE=now(),DRD_AUDIT_USR='".$_SESSION['user']."'");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LZ'),DRD_VALUE='".getFloatValue($_POST['inWellZas'])."',DRD_AUDIT_DATE=now(),DRD_AUDIT_USR='".$_SESSION['user']."'");
mysql_query("INSERT INTO seg_object_hole_cards SET OHC_DRS_ID=".$maxDRSid.",OHC_UJ='".$ujName."',OHC_NAME='".$_POST['inWellName']."',OHC_DATA_ODDANIA='".$_POST['inWellAVdate']."',OHC_GLEB_ODWIER='".$_POST['inWellDepth']."',OHC_GLEB_OSTAT='".$_POST['inWellDepth']."',OHC_DL_GEOGR='".getFloatValue($_POST['inWellLat'])."',OHC_SZER_GEOGR='".getFloatValue($_POST['inWellLong'])."',OHC_PLC='".$_SESSION['syndis_eq_stock']."'");
mysql_query("INSERT INTO seg_object_hole_cards_his SET OHH_DRS_ID=".$maxDRSid.",OHH_UJ='".$ujName."',OHH_NAME='".$_POST['inWellName']."',OHH_ZASYP='".$_POST['inWellZas']."',OHH_PLC='".$_SESSION['syndis_eq_stock']."'");
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=$maxDRSid");
echo"$lab_SaveRecordNotification_001
";
$_GET['dev'] = $maxDRSid;
unset($maxWELLid);
unset($maxDRSid);
echo"
";
}
else
{
echo "Błąd zapisu. Studnia ".$_POST['inWellName']." istnieje już w systemie. Spróbuj ponownie.
";
echo'';
}
}
//zabudowa agregatu
if ($_SESSION['doubleFormProtection']=='once' && $_POST['inWellDrsID']>0 && $_POST['inPupDrsID']>0 && $_POST['inEngDrsID']>0 && $_POST['subBuildInSave']==$lab_ButtonName_Save)
{
$chechWellID = (int) sqlStringValue("select WLL_ID from seg_wells,seg_dev_resources where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and DRS_ID=".$_POST['inWellDrsID']." limit 1", "WLL_ID");
if ($_SESSION['well_details']['wellID'] == $chechWellID)
{
mysql_query("INSERT INTO seg_well_pump_eng_rel SET RWL_WLL_ID=".$_SESSION['well_details']['wellID'].",RWL_PUP_DRS_ID=".$_POST['inPupDrsID'].",RWL_ENG_DRS_ID=".$_POST['inEngDrsID']);
if (sqlValue("select count(*) from seg_well_pump_eng_rel where RWL_WLL_ID=".$_SESSION['well_details']['wellID']." and RWL_PUP_DRS_ID=".$_POST['inPupDrsID']." and RWL_ENG_DRS_ID=".$_POST['inEngDrsID'])>0)
{
//studnia
mysql_query("UPDATE seg_dev_resources SET DRS_AVAILABLE_DATE='".$_POST['inBuildDate']."',DRS_RESOURCES_DIC_ID=901 WHERE DRS_ID=".$_POST['inWellDrsID']);
//pompa
mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=7,DRS_RESOURCES_DIC_ID=3 WHERE DRS_ID=".$_POST['inPupDrsID']);
//silnik
mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=7,DRS_RESOURCES_DIC_ID=3 WHERE DRS_ID=".$_POST['inEngDrsID']);
//wpis do historii agregatów
$nr_exch = sqlValue("select case when max(WLE_NR_EXCHANGE)>0 then max(WLE_NR_EXCHANGE)+1 else 1 end as nr from seg_wells_exchanged where WLE_WLL_ID=".$_SESSION['well_details']['wellID']);
mysql_query("INSERT INTO seg_wells_exchanged SET WLE_WLL_ID=".$_SESSION['well_details']['wellID'].",WLE_NR_EXCHANGE=".$nr_exch.",WLE_PUMP_NAME='".$_POST['inPupName']."',WLE_PUMP_NO='".$_POST['inPupNo']."',WLE_ENG_NAME='".$_POST['inEngName']."',WLE_ENG_NO='".$_POST['inEngNo']."',WLE_DATE_FROM='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00',WLE_ZP='".getFloatValue($_POST['inWellLS'])."',WLE_DR='".getFloatValue($_POST['inWellDR'])."';");
//usuwanie blokady ze zleceń
mysql_query("UPDATE seg_order_new_agg_params SET ONA_PUMP_DRS_ID=null,ONA_ENG_DRS_ID=null WHERE ONA_ORD_ID=".$_POST['inOrdID']);
// aktualizacja statusu zlecenia
mysql_query("UPDATE seg_orders SET ORD_STATUS_DIC_ID=853,ORD_FINISH_USR='".$_SESSION['user']."',ORD_FINISH_DATE=now() WHERE ORD_ID=".$_POST['inOrdID']);
//aktualizauje głębokość zabudowy pompy, średnicę rurociągu oraz głębokość zasypu
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['inWellDrsID'].",DRD_RESOURCES_DETAIL=235,DRD_VALUE='".$_POST['inWellDR']."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['inWellDrsID'].",DRD_RESOURCES_DETAIL=240,DRD_VALUE='".$_POST['inWellLS']."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['inWellDrsID'].",DRD_RESOURCES_DETAIL=130,DRD_VALUE='".$_POST['inWellLZ']."',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'");
//dodaje wpis do karty otworów
mysql_query("INSERT INTO seg_object_hole_cards_his SET OHH_DRS_ID=".$_POST['inWellDrsID'].",OHH_UJ='".$_SESSION['well_details']['well_Uj']."',OHH_NAME='".$_SESSION['well_details']['wellName']."',OHH_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00',OHH_ZASYP='".getFloatValue($_POST['inWellLZ'])."',OHH_PLC='".$_SESSION['syndis_eq_stock']."'");
//dodaje POSTÓW - domyślnie przyjmując status "Oczekująca na uruchomienie"
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['inWellDrsID'].",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='1509',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'");
//buduje tabelę agregatów
//mysql_query("truncate table rep_aggregate_departments");
//mysql_query("insert into rep_aggregate_departments select null,PUP_ID,PUP_DRS_ID,PUP_NAME,PUP_SN_NO,PUP_Q_N,PUP_H_P,PUP_DEPARTMENT,ENG_ID,DRS_ID,ENG_NAME,ENG_SN_NO,ENG_VOLTAGE,ENG_POWER,DRS_DEPARTMENT,ECB_TYP,ECB_DLUGOSC,ECB_OZNAK_01,ECB_OZNAK_02 from (select PUP_ID,DRS_ID PUP_DRS_ID,PUP_NAME,DRS_SN_NUMBER PUP_SN_NO,DRS_DEPARTMENT PUP_DEPARTMENT,PUP_Q_N,PUP_H_P,(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER)) ENG_ID,(select ENG_NAME from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_NAME,(select ENG_VOLTAGE from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_VOLTAGE,(select ENG_POWER from seg_engines where ENG_ID=(select TST_ENG_ID from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER))) ENG_POWER,(select TST_ENG_SN_NO from tst_tests where TST_ID=(select max(TST_ID) from tst_tests where TST_PUP_ID=PUP_ID and TST_PUP_SN_NO=DRS_SN_NUMBER)) ENG_SN_NO from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID where DRS_RESOURCES_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES' and DIC_NAME='RESERVE') and DRS_STATUS_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_STATUS' and DIC_NAME='AVAILABLE')and DRS_DEV_TYPE=10) tb1 left join seg_dev_resources on DRS_DEV_TYPE=11 and DRS_DEV_ID=tb1.ENG_ID and tb1.ENG_SN_NO=DRS_SN_NUMBER left join seg_engine_cables on ECB_ENG_NAME=ENG_NAME and ECB_ENG_NO=ENG_SN_NO");
echo"$lab_Field_site301_024
";
}
}
else
{
echo"UWAGA!
Problem z zabudową agregatu w studni – zostały wykryte inne aktywne okna systemu SoftSPM. W celu uniknięcia błędów - zamknij je i spróbuj ponownie – począwszy od wyszukania studni w Menu Stan » Stan studni.
Jeśli problem powtórzy się ponownie – skontaktuj się z administratorem.
";
echo'';
}
//blokada przez podwujnym zapisem zabudowania
unset($_SESSION['doubleFormProtection']);
}
if(!empty($_POST['dev'])) $_GET['dev'] = $_POST['dev'];
if (!empty($_POST['indevID'])) $_GET['dev']=$_POST['indevID'];
//aktualizauje dane
if (!empty($_POST['inWellName']) && $_POST['subWellUpdate']==$lab_ButtonName_Update)
{
$ujName = sqlStringValue("select SWI_NAME from seg_water_intakes where SWI_ID=".$_POST['inWellBariera'],"SWI_NAME");
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='DST'),DRD_VALUE='".$_POST['inWellDiame']."',DRD_AUDIT_USR='admin',DRD_AUDIT_DATE=now()");
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LS'),DRD_VALUE='".$_POST['inWellDepth']."',DRD_AUDIT_USR='admin',DRD_AUDIT_DATE=now()");
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LF'),DRD_VALUE='".$_POST['inWellFilter']."',DRD_AUDIT_USR='admin',DRD_AUDIT_DATE=now()");
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LZ'),DRD_VALUE='".$_POST['inWellZas']."',DRD_AUDIT_USR='admin',DRD_AUDIT_DATE=now()");
//mysql_query("UPDATE seg_wells SET WLL_NAME='".$_POST['inWellName']."',WLL_CAT_DIC_ID=".$_POST['inWellCategory'].",WLL_P1_SCOPE='".$_POST['inP1']."',WLL_P2_SCOPE='".$_POST['inP2']."',WLL_PP_SCOPE='".$_POST['inPP']."',WLL_HH_SCOPE='".$_POST['inHH']."',WLL_Q_SCOPE='".$_POST['inQ']."' WHERE WLL_ID=".$_POST['inWellID']);
mysql_query("UPDATE seg_wells SET WLL_NAME='".$_POST['inWellName']."',WLL_SWI_ID=".$_POST['inWellBariera'].",WLL_BARIERA='".$ujName."',WLL_CAT_DIC_ID=".$_POST['inWellCategory'].",WLL_PP_SCOPE='".$_POST['inPP']."',WLL_HH_SCOPE='".$_POST['inHH']."',WLL_SYS_TYPE='".$_POST['inWellSysType']."',WLL_STAT_DESC='".$_POST['inWellDesc']."' WHERE WLL_ID=".$_POST['inWellID']);
mysql_query("UPDATE seg_dev_resources SET DRS_AVAILABLE_DATE='".$_POST['inWellAVdate']."',DRS_RESOURCES_DIC_ID=".$_POST['inWellStatus01']." WHERE DRS_ID=".$_GET['dev']);
mysql_query("UPDATE seg_object_hole_cards SET OHC_NAME='".$_POST['inWellName']."',OHC_UJ='".$ujName."',OHC_DL_GEOGR='".$_POST['inWellDlGeo']."',OHC_SZER_GEOGR='".$_POST['inWellSzGeo']."' where OHC_DRS_ID=".$_GET['dev']);
mysql_query("UPDATE seg_wells_exchanged SET WLE_DATE_FROM='".$_POST['inWellAVdate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00' WHERE WLE_ID=".$_POST['inWLE_ID']);
echo"$lab_UpdateRecordNotification_001
";
}
// aktualizacja odprowadzenia wody
if ($_POST['subSite301tree']==$lab_ButtonName_Save && $_GET['dev']>0 && $_POST['inCheck']>0)
{
mysql_query("DELETE FROM seg_well_water_drainage WHERE WLD_DRS_ID=".$_GET['dev']);
mysql_query("INSERT INTO seg_well_water_drainage SET WLD_DRS_ID=".$_GET['dev'].",WLD_WLL_ID=".$_SESSION['well_details']['wellID'].",WLD_WWD_ID=".$_POST['inCheck'].",WLD_AUDIT_CU='".$_SESSION['user']."',WLD_AUDIT_CD=now()");
echo"$lab_UpdateRecordNotification_001
";
}
//dodaje opomiarowanie
//=========================================================
if ($_GET['up']>0 && $_GET['acc']=='add' && sqlValue("select count(1) from seg_dev_equipments_rel where SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_DRS_EQU_ID=".$_GET['up']." and SDE_TYPE=14")==0)
{
mysql_query("INSERT INTO seg_dev_equipments_rel SET SDE_TYPE=14,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_PARAM3='".$_SESSION['syndis_eq_stock']."',SDE_DRS_EQU_ID=".$_GET['up']);
mysql_query("INSERT INTO seg_dev_equipments_rel_his SET SDE_TYPE=14,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_PARAM3='".$_SESSION['syndis_eq_stock']."',SDE_DRS_EQU_ID=".$_GET['up'].",SDE_AUDIT_CU='".$_SESSION['user']."',SDE_AUDIT_CD=now()");
mysql_query("UPDATE seg_dev_resources SET DRS_RESOURCES_DIC_ID=3 WHERE DRS_ID=".$_GET['up']);
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_GET['up']);
//aktualizuje zakresy pomiarowe dla PP i HH w kontekście przypisywanej sondy
// ====================================================================
if(strstr(sqlStringValue("select EQU_NAME from seg_dev_equipments_rel left join seg_dev_resources on SDE_DRS_EQU_ID=DRS_ID and DRS_DEV_TYPE=14 left join seg_equipments on DRS_DEV_ID=EQU_ID where SDE_TYPE=14 and SDE_DRS_EQU_ID=".$_GET['up'],"EQU_NAME"),"SGP"))
mysql_query("UPDATE seg_wells SET WLL_PP_SCOPE='".getLastValueFromDevResourceDetail("DEV_RESOURCES_DETAIL","SGP_21_PP",$_GET['up'])."',WLL_HH_SCOPE='".getLastValueFromDevResourceDetail("DEV_RESOURCES_DETAIL","SGP_21_HH",$_GET['up'])."' WHERE WLL_ID=".$_SESSION['well_details']['wellID']);
// ====================================================================
}
//usuwa opomiarowanie
if ($_GET['up']>0 && $_GET['acc']=='del' && $_GET['tp']==14)
{
mysql_query("DELETE FROM seg_dev_equipments_rel WHERE SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_TYPE=14 and SDE_DRS_EQU_ID=".$_GET['up']);
mysql_query("UPDATE seg_dev_equipments_rel_his SET SDE_AUDIT_DU='".$_SESSION['user']."',SDE_AUDIT_DD=now() WHERE SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_TYPE=14 and SDE_DRS_EQU_ID=".$_GET['up']);
mysql_query("UPDATE seg_dev_resources SET DRS_RESOURCES_DIC_ID=2 WHERE DRS_ID=".$_GET['up']);
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_GET['up']);
}
//=========================================================
//dodawanie kabla
//=========================================================
if ($_POST['subKableSave']==$lab_ButtonName_Save && $_POST['inKabValue']>0 && $_POST['up']>0)
{
mysql_query("INSERT INTO seg_dev_equipments_rel SET SDE_PARAM3='".$_SESSION['syndis_eq_stock']."', SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_POST['up'].",SDE_VALUE='".$_POST['inKabValue']."',SDE_TYPE='13'");
mysql_query("INSERT INTO seg_dev_equipments_rel_his SET SDE_PARAM3='".$_SESSION['syndis_eq_stock']."', SDE_TYPE=13,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_POST['up'].",SDE_VALUE='".$_POST['inKabValue']."',SDE_AUDIT_CU='".$_SESSION['user']."',SDE_AUDIT_CD=now()");
//mysql_query("UPDATE seg_equipments_stock SET SES_STOCK=(SES_STOCK-".$_POST['inKabValue'].") WHERE SES_EQU_ID=".$_POST['up']);
}
//usuwa kabel
if ($delArray[3]>0 && $delArray[1]=='del' && $delArray[2]==13)
{
mysql_query("delete from seg_dev_equipments_rel where SDE_ID=".$delArray[3]);
mysql_query("delete from seg_dev_equipments_rel_his where SDE_ID=".$delArray[3]);
}
//=========================================================
//dodawanie orurowania
//=========================================================
if ($_POST['subRuSave']==$lab_ButtonName_Save && $_POST['inRuValue']>0 && $_POST['eq']>0)
{
mysql_query("INSERT INTO seg_dev_equipments_rel SET SDE_PARAM3='".$_SESSION['syndis_eq_stock']."', SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_POST['eq'].",SDE_VALUE='".$_POST['inRuValue']."',SDE_TYPE='15'");
mysql_query("INSERT INTO seg_dev_equipments_rel_his SET SDE_PARAM3='".$_SESSION['syndis_eq_stock']."', SDE_TYPE=15,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_POST['eq'].",SDE_VALUE='".$_POST['inRuValue']."',SDE_AUDIT_CU='".$_SESSION['user']."',SDE_AUDIT_CD=now()");
//$sesID = sqlValue("select SES_ID from seg_equipments_stock where SES_STOCK>0 and SES_EQU_ID=".$_POST['up']." and (SES_PARAM3 like '%".$_SESSION['eq_stock_param3_1']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_2']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_3']."%') limit 1");
//mysql_query("UPDATE seg_equipments_stock SET SES_STOCK=(SES_STOCK-".$_POST['inRuValue'].") WHERE SES_ID=".$sesID);
}
//usuwa orurowanie
if ($delArray[3]>0 && $delArray[1]=='del' && $delArray[2]==15)
{
//mysql_query("delete from seg_dev_equipments_rel where SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_DRS_EQU_ID=".$_GET['up']);
mysql_query("delete from seg_dev_equipments_rel where SDE_ID=".$delArray[3]);
mysql_query("delete from seg_dev_equipments_rel_his where SDE_ID=".$delArray[3]);
//mysql_query("UPDATE seg_dev_equipments_rel_his SET SDE_AUDIT_DU='".$_SESSION['user']."',SDE_AUDIT_DD=now() WHERE SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_TYPE=15 and SDE_DRS_EQU_ID=".$_GET['up']);
//$sesID = sqlValue("select SES_ID from seg_equipments_stock where SES_VALUE>SES_STOCK and SES_EQU_ID=".$_GET['up']." and (SES_PARAM3 like '%".$_SESSION['eq_stock_param3_1']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_2']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_3']."%') limit 1");
//mysql_query("UPDATE seg_equipments_stock SET SES_STOCK=(SES_STOCK+".$_GET['val'].") WHERE SES_ID=".$sesID);
}
//=========================================================
//aktualizacja kabeli i orurowania
if ($delArray[2]>0 && $delArray[1]=='edit' && $_POST['subUpdate']==$lab_ButtonName_Update && getFloatValue($_POST['inValue'])>0)
{
//mysql_query("delete from seg_dev_equipments_rel where SDE_ID=".$delArray[3]);
//mysql_query("delete from seg_dev_equipments_rel_his where SDE_ID=".$delArray[3]);
mysql_query("UPDATE seg_dev_equipments_rel SET SDE_VALUE='".getFloatValue($_POST['inValue'])."' WHERE SDE_ID=".$delArray[2]);
echo"$lab_UpdateRecordNotification_001
";
}
//=========================================================
?>
$r["DRS_ID"],
'wellID' => $r["WLL_ID"],
'wellName' => $r["WLL_NAME"],
'wellSN' => $r["DRS_SN_NUMBER"],
'wellDate' => $r["DRS_AVAILABLE_DATE"],
'well_PPscp'=> $r["WLL_PP_SCOPE"],
'well_HHscp'=> $r["WLL_HH_SCOPE"],
'well_UjID' => $r["WLL_SWI_ID"],
'well_Uj' => $r["WLL_BARIERA"],
'well_SysType'=> $r["WLL_SYS_TYPE"],
'well_Desc' => $r["WLL_STAT_DESC"],
'well_DlGeo'=> $r["OHC_DL_GEOGR"],
'well_SzGeo'=> $r["OHC_SZER_GEOGR"],
'well_TypeID'=> $r["WLL_CAT_DIC_ID"],
'pumpDrsID' => $r["RWL_PUP_DRS_ID"],
'pumpID' => $r["PUP_ID"],
'pumpName' => $r["PUP_NAME"],
'pumpSN' => $r["PUP_NO"],
'engDrsID' => $r["RWL_ENG_DRS_ID"],
'engID' => $r["ENG_ID"],
'engName' => $r["ENG_NAME"],
'engSN' => $r["ENG_NO"],
'statusID' => $r["DRS_STATUS_DIC_ID"],
'resID' => $r["DRS_RESOURCES_DIC_ID"],
);
}
if ($_SESSION['lang']=='polish')
$imgSPM = "./images/".sqlStringValue("select DIC_NAME from sys_dictionaries where DIC_ID=".$_SESSION['well_details']['well_TypeID'],"DIC_NAME")."_polish.png";
else
$imgSPM = "./images/".sqlStringValue("select DIC_NAME from sys_dictionaries where DIC_ID=".$_SESSION['well_details']['well_TypeID'],"DIC_NAME")."_english.png";
?>
|
|
120 order by DIC_ID");
if($result)while ($r = mysql_fetch_array($result))
{
$var_DIC_ID = $r["DIC_ID"];
$var_DIC_NAME = $r["DIC_NAME"];
if ($var_DIC_ID==110) $pVal = getGlebokoscAct($_SESSION['well_details']['devID']);
else $pVal = getFloatValue(getLastValueFromDevResourceDetail('WELL_TECHNICAL_PARAMETERS',$var_DIC_NAME,$_SESSION['well_details']['devID']));
echo"
| ".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='$var_DIC_NAME'",$decFieldLang)." |
".$pVal." |
";
}
echo"
| ".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='LPM'",$decFieldLang)." |
".str_replace('.',',',round(str_replace(',','.',getLastValueFromDevResourceDetail('WELL_PARAMETERS','LPM',$_SESSION['well_details']['devID'])),2))." |
| ".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='DR'",$decFieldLang)." |
".str_replace('.',',',round(str_replace(',','.',getLastValueFromDevResourceDetail('WELL_PARAMETERS','DR',$_SESSION['well_details']['devID'])),2))." |
";
?>
Zakresy pomiarowe dla powiązanych urządzeń
| Zakres ciśnienia pp [m] |
|
| Zakres dla sondy pomiaru zwierciadła wody HH [m] |
|
Powiązane urządzenia pomiarowe
| Urządzenie |
Numer seryjny |
"; ?>
$var_02 |
$var_03 | ";
if (!empty($_SESSION['site301_edit'])) echo"
 | ";
echo"
";
}
?>
 | "; ?>
Kabel PGE
| Zlecenie |
|
| Stacja Prób - RAMB |
|
Kable
| Rodzaj |
Długość [m] |
"; ?>
| $var_02 |
$var_03 | ";
if (!empty($_SESSION['site301_edit']))
echo"
| ";
echo"
";
}
?>
| "; ?>
Rury i armatura
| Rodzaj |
Ilość sztuk |
"; ?>
| $var_02 |
$var_03 | ";
if (!empty($_SESSION['site301_edit']))
echo"
| ";
echo"
";
}
?>
| "; ?>
|
|
";
?>