0 && $_POST['subEquipSave']==$lab_ButtonName_Save) { //sprawdza, czy nie istenie juĹĽ takie urzÄ…dzenie z takim samym numerem seryjnym if (sqlValue("select count(1) from seg_dev_resources where DRS_DEV_TYPE=14 and DRS_SN_NUMBER='".$_POST['inEquipSN']."'")==0) { $query = "INSERT INTO seg_dev_resources SET DRS_DEV_ID=".$_POST['inEquipID'].",DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='EQUIPMENTS'), DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."'"; if (strlen($_POST['inEquipSN'])>0) $query .=" ,DRS_SN_NUMBER='".$_POST['inEquipSN']."'"; if (strlen($_POST['inEquipBuyDate'])>0) $query .=" ,DRS_BUY_DATE='".$_POST['inEquipBuyDate']."'"; if (strlen($_POST['inEquipDevRes'])>0) $query .=" ,DRS_RESOURCES_DIC_ID=".$_POST['inEquipDevRes']; if (strlen($_POST['inEquipAtt'])>0) $query .=" ,DRS_DEV_ATTENTION='".$_POST['inEquipAtt']."'"; $query .=",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()"; mysql_query($query); $maxDRSid = sqlValue("select max(DRS_ID) from seg_dev_resources"); if (strlen($_POST['inEquipEST'])>0) 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='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_VALUE='".$_POST['inEquipEST']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); if (strlen($_POST['inEquipSCOPE'])>0) 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='DEV_RESOURCES_DETAIL' and DIC_NAME='SCOPE'),DRD_VALUE='".$_POST['inEquipSCOPE']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); //dla sondy SGP-21 if (strlen($_POST['inSCOPE_PP'])>0) 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='DEV_RESOURCES_DETAIL' and DIC_NAME='SGP_21_PP'),DRD_VALUE='".$_POST['inSCOPE_PP']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); if (strlen($_POST['inSCOPE_HH'])>0) 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='DEV_RESOURCES_DETAIL' and DIC_NAME='SGP_21_HH'),DRD_VALUE='".$_POST['inSCOPE_HH']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); if (strlen($_POST['inWire'])>0) 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='DEV_RESOURCES_DETAIL' and DIC_NAME='SG_P_21_WIRE'),DRD_VALUE='".$_POST['inWire']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()"); mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=$maxDRSid"); echo"

$lab_Field_site803_013

"; unset($maxDRSid); } else echo"

Urządzenie nie zostało zapisane w systemie, gdyż istnieje już inne o takim samym numerze seryjnym: ".$_POST['inEquipSN'].". Spróbuj ponownie.

"; } // usuwanie istniejÄ…cego urzÄ…dzenia if ($_GET['dev']>0 && $_GET['act']=="del") { //sprawdza, czy urzÄ…dzenie nie jest powiÄ…zane z jakimĹ› obiektem if (sqlValue("select count(1) from seg_dev_equipments_rel where SDE_DRS_EQU_ID=".$_GET['dev'])==0) { mysql_query("DELETE FROM seg_dev_resources WHERE DRS_ID=".$_GET['dev']); mysql_query("DELETE FROM seg_dev_resources_his WHERE DRS_ID=".$_GET['dev']); echo"

Urządzenie zostało pomyślnie usunięte z systemu.

"; } else echo"

Brak możliwości usunięcia urządzenia, gdyż jest ono powiązane z innym obiektem.

"; } ?>

"; $cnt=1; if ($_GET['eq']>0 && $_GET['eq']==$sql_1) { echo" "; } } ?>

Ilość

$sql_3

$sql_4

$sql_2

"; $wynik1 = mysql_query("select DRS_ID,SDE_DRS_DEV_ID,DRS_SN_NUMBER,DRS_RESOURCES_DIC_ID from seg_dev_resources left join seg_dev_equipments_rel on DRS_ID=SDE_DRS_EQU_ID where DRS_DEV_TYPE=14 and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' and DRS_DEV_ID=".$_GET['eq']." order by DRS_SN_NUMBER"); if($wynik1)while ($r1 = mysql_fetch_array($wynik1)) { $obNAME=null;$dID2=null; $sW1 = $r1["DRS_ID"]; $sW2 = $r1["SDE_DRS_DEV_ID"]; $sW3 = $r1["DRS_SN_NUMBER"]; $sW4 = $r1["DRS_RESOURCES_DIC_ID"]; $sW4=setDicName($sW4); $wynik2 = mysql_query("select DRS_DEV_ID,DRS_DEV_TYPE from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$sW1); if($wynik2)while ($r2 = mysql_fetch_array($wynik2)) { $dID2 = $r2["DRS_DEV_ID"]; $dTP2 = $r2["DRS_DEV_TYPE"]; if ($dTP2==12) $obNAME = sqlStringValue("select WLL_NAME from seg_wells where WLL_ID=".$dID2,"WLL_NAME"); else $obNAME = sqlStringValue("select SRP_NAME from seg_reservoirs_piezometers where SRP_ID=".$dID2,"SRP_NAME"); } $bgcol=null; if (strlen($obNAME)==0) { $obNAME="Brak powiązanego obiektu"; $bgcol = "background-color: rgba(255, 255, 0, 0.05);"; } echo" "; $cnt++; } echo"

Lp.	Nazwa	Nr seryjny	Przypisany do	Status
$cnt	$sql_3	$sW3	".$obNAME."	$sW4

"; ?>