197 lines
9.3 KiB
PHP
197 lines
9.3 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site308']))
|
|
{
|
|
?>
|
|
|
|
<?php
|
|
//dodawanie nowego urzÄ…dzenia na stan.
|
|
if ($_POST['inEquipID']>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"<div class='actionOK'>$lab_Field_site803_013</div>";
|
|
unset($maxDRSid);
|
|
}
|
|
else
|
|
echo"<div class='actionERROR'>Urządzenie nie zostało zapisane w systemie, gdyż istnieje już inne o takim samym numerze seryjnym: ".$_POST['inEquipSN'].". <a style='color: #ffff00; text-decoration: none;' href='javascript:history.back()'>Spróbuj ponownie.</a></div>";
|
|
}
|
|
|
|
// 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"<div class='actionOK'>Urządzenie zostało pomyślnie usunięte z systemu.</div>";
|
|
|
|
}
|
|
else
|
|
echo"<div class='actionERROR'>Brak możliwości usunięcia urządzenia, gdyż jest ono powiązane z innym obiektem.</div>";
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site308_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label"><?php echo $lab_Field_site302_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_002 ;?></TD>
|
|
<TD class="label">Ilość</TD>
|
|
|
|
</TR>
|
|
|
|
<?php
|
|
$wynik = mysql_query("select EQU_ID,count(EQU_ID) ILOSC,EQU_NAME,MCF_NAME from seg_dev_resources left join seg_equipments on DRS_DEV_ID=EQU_ID left join seg_manufacturers on EQU_MCF_ID=MCF_ID where DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='EQUIPMENTS') and DRS_DEPARTMENT = '".$_SESSION['syndis_eq_stock']."' group by EQU_ID,EQU_NAME,MCF_NAME order by EQU_NAME");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_1 = $r["EQU_ID"];
|
|
$sql_2 = $r["ILOSC"];
|
|
$sql_3 = $r["EQU_NAME"];
|
|
$sql_4 = $r["MCF_NAME"];
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site308&eq=$sql_1'".chr(34).">
|
|
<TD class='field_left'>$sql_3</TD>
|
|
<TD class='field_center'>$sql_4</TD>
|
|
<TD class='field_center'>$sql_2</TD>
|
|
</TR>
|
|
";
|
|
|
|
|
|
$cnt=1;
|
|
if ($_GET['eq']>0 && $_GET['eq']==$sql_1)
|
|
{
|
|
echo"
|
|
<tr>
|
|
<td colspan='3' class='eq_details'>
|
|
<table WIDTH='100%' class='tag'>
|
|
<tr>
|
|
<td class='eq_label'>Lp.</td>
|
|
<td class='eq_label'>Nazwa</td>
|
|
<td class='eq_label'>Nr seryjny</td>
|
|
<td class='eq_label'>Przypisany do</td>
|
|
<td class='eq_label'>Status</td>
|
|
</tr>
|
|
|
|
|
|
";
|
|
|
|
$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"
|
|
<tr STYLE='cursor: pointer; ".$bgcol."' onclick=".chr(34)."document.location.href='?pg=site308inf&dev=$sW1'".chr(34).">
|
|
<td class='field_center'>$cnt</td>
|
|
<td class='field_left'>$sql_3</td>
|
|
<td class='field_left'>$sW3</td>
|
|
<td class='field_center'>".$obNAME."</td>
|
|
<td class='field_center'>$sW4</td>
|
|
</tr>
|
|
";
|
|
$cnt++;
|
|
}
|
|
|
|
echo"
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
";
|
|
}
|
|
|
|
}
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
|
|
<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">
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site308_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site308A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|
|
|
|
|