288 lines
12 KiB
PHP
288 lines
12 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site308']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
if(!empty($_POST['dev'])) $_GET['dev'] = $_POST['dev'];
|
|
|
|
//Aktualizacja danych
|
|
// ========================================================================================================
|
|
if ($_POST['dev']>0 && $_POST['subEquipSave']==$lab_ButtonName_Update)
|
|
{
|
|
$query = "update seg_dev_resources SET DRS_AUDIT_DATE=now()";
|
|
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']."' where DRS_ID=".$_POST['dev'];
|
|
mysql_query($query);
|
|
|
|
if (strlen($_POST['inEquipEST'])>0)
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",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=".$_POST['dev'].",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
|
|
// ===================================================================
|
|
//sprawdza, czy jest przypisana studnia do sondy
|
|
if (strlen($_POST['inSCOPE_PP'])>0 || strlen($_POST['inSCOPE_HH'])>0)
|
|
$tpmWellID = sqlStringValue("select DRS_DEV_ID from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$_POST['dev'],"DRS_DEV_ID");
|
|
|
|
if (strlen($_POST['inSCOPE_PP'])>0)
|
|
{
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",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()");
|
|
mysql_query("UPDATE seg_wells SET WLL_PP_SCOPE='".$_POST['inSCOPE_PP']."' WHERE WLL_ID=".$tpmWellID);
|
|
|
|
}
|
|
if (strlen($_POST['inSCOPE_HH'])>0)
|
|
{
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",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()");
|
|
mysql_query("UPDATE seg_wells SET WLL_HH_SCOPE='".$_POST['inSCOPE_HH']."' WHERE WLL_ID=".$tpmWellID);
|
|
}
|
|
|
|
if (strlen($_POST['inWire'])>0)
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",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=".$_POST['dev']);
|
|
}
|
|
// ========================================================================================================
|
|
|
|
|
|
|
|
|
|
$wynik = mysql_query("select DRS_ID,EQU_ID,DRS_SN_NUMBER,DRS_BUY_DATE,EQU_NAME,MCF_NAME,EQU_DESCRIPTION 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_ID=".$_GET['dev']);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_1 = $r["EQU_ID"];
|
|
$sql_2 = $r["EQU_NAME"];
|
|
$sql_3 = $r["EQU_DESCRIPTION"]; $sql_3= str_replace(".", ",", $sql_3);
|
|
$sql_4 = $r["MCF_NAME"];
|
|
$sql_DRSid = $r["DRS_ID"];
|
|
$sql_SNo = $r["DRS_SN_NUMBER"];
|
|
$sql_BuyDate = $r["DRS_BUY_DATE"];
|
|
}
|
|
?>
|
|
|
|
|
|
<div class="tag50_left">
|
|
<div class="head_tag"><?php echo $lab_Tag_site208_002 ;?></div>
|
|
<div class="tag">
|
|
<TABLE class="desc_val">
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site802_001; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $sql_2; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site206_002; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $sql_4; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site206_003; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo str_replace(chr(13), "<br/>", $sql_3); ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site303_001; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $sql_SNo; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site303_013; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','ASSET',$sql_DRSid); ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo $lab_Field_site303_002; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $sql_BuyDate; ?></TD>
|
|
</TR>
|
|
|
|
|
|
<?php
|
|
if (strstr($sql_2,"SGP"))
|
|
{
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_equipment'>".$lab_Field_site303_015."</TD>
|
|
<TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SGP_21_PP',$sql_DRSid)."</TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class='desc_equipment'>".$lab_Field_site303_016."</TD>
|
|
<TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SGP_21_HH',$sql_DRSid)."</TD>
|
|
</TR>
|
|
";
|
|
|
|
}
|
|
else
|
|
{
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_equipment'>".$lab_Field_site303_014."</TD>
|
|
<TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SCOPE',$sql_DRSid)."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
|
|
|
|
if (strstr($sql_2,"SGP") || strstr($sql_2,"SG") || strstr($sql_2,"PA"))
|
|
{
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_equipment'>".$lab_Field_site303_017."</TD>
|
|
<TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SG_P_21_WIRE',$sql_DRSid)."</TD>
|
|
</TR>
|
|
";
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
?>
|
|
|
|
|
|
<?php
|
|
if (sqlValue("select count(1) from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('application') and EQF_EQU_ID=$sql_1")>0)
|
|
{
|
|
echo"
|
|
<TR>
|
|
<TD class='desc'>$lab_Field_site206_004</TD>
|
|
<TD CLASS='desc_value'>";
|
|
$wynik = mysql_query("select EQF_ID,SUBSTRING_INDEX(EQF_FILE_NAME, '.', -1) ICO,EQF_FILE_NAME from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('application') and EQF_EQU_ID=$sql_1");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$eq_1 = $r["EQF_ID"];
|
|
$vICO = $r["ICO"];
|
|
$eq_2 = $r["EQF_FILE_NAME"];
|
|
|
|
if ($vICO=='pdf') $icoFile = './images/pdf_ico.png';
|
|
else if ($vICO=='doc' || $vICO=='docx') $icoFile = './images/word_ico.png';
|
|
else if ($vICO=='xls' || $vICO=='xlsx') $icoFile = './images/excel_ico.png';
|
|
else if ($vICO=='ppt' || $vICO=='pptx' || $vICO=='pps' || $vICO=='ppsx') $icoFile = './images/ppoint_ico.png';
|
|
else if ($vICO=='jpg' || $vICO=='png' || $vICO=='bmp' || $vICO=='jpeg' || $vICO=='gif' || $vICO=='jfif' || $vICO=='tiff' || $vICO=='dib') $icoFile = './images/photo_ico.png';
|
|
else if ($vICO=='mpg' || $vICO=='divx' || $vICO=='avi' || $vICO=='mp3' || $vICO=='mp4' || $vICO=='mov') $icoFile = './images/divx_ico.png';
|
|
else $icoFile = './images/file_ico.png';
|
|
|
|
echo"<img src=$icoFile><a class='knowledge' href='./sites/eqdocgeneratefromdb.php?fno=$eq_1' target='_blank'>$eq_2</a><br/>";
|
|
}
|
|
|
|
|
|
|
|
|
|
echo"</TD>
|
|
</TR>
|
|
|
|
|
|
";
|
|
|
|
}
|
|
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<?php
|
|
$wynik = mysql_query("select DRS_DEV_ID,DRS_DEV_TYPE,SDE_DRS_DEV_ID from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$sql_DRSid);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$obID = $r["DRS_DEV_ID"];
|
|
$obTYPE = $r["DRS_DEV_TYPE"];
|
|
$obDrsIS = $r["SDE_DRS_DEV_ID"];
|
|
|
|
}
|
|
|
|
if ($obTYPE==12)
|
|
$obNAME = sqlStringValue("select WLL_NAME from seg_wells where WLL_ID=".$obID,"WLL_NAME");
|
|
else
|
|
$obNAME = sqlStringValue("select SRP_NAME from seg_reservoirs_piezometers where SRP_ID=".$obID,"SRP_NAME");
|
|
|
|
if (strlen($obNAME)==0) $obNAME="Brak powiązanego obiektu";
|
|
|
|
?>
|
|
|
|
|
|
<div class="head_tag"> <?php echo $lab_Tag_site308_005 ;?></div>
|
|
<div class="tag">
|
|
<TABLE class="desc_val">
|
|
<TR>
|
|
<TD class="desc_equipment"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_ID=".$obTYPE,"DIC_POL_LANG"); ?></TD>
|
|
|
|
<?php
|
|
if ($obTYPE==12)
|
|
echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site401mark&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
|
|
else if ($obTYPE==600)
|
|
echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site402inf&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
|
|
else if ($obTYPE==601)
|
|
echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site404inf&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
|
|
else
|
|
echo"<td CLASS='desc_value'>$obNAME</td>";
|
|
?>
|
|
|
|
|
|
|
|
</TR>
|
|
</TABLE>
|
|
</div>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<div class="tag50_right">
|
|
|
|
<div class="head_tag"><?php echo $lab_Field_site206_005 ;?></div>
|
|
<div class="tag_center">
|
|
|
|
<?php
|
|
$wynik = mysql_query("select EQF_FILE_TYPE,EQF_FILE from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('image') and EQF_EQU_ID=$sql_1");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$param_1 = $r["EQF_FILE_TYPE"];
|
|
$param_2 = $r["EQF_FILE"];
|
|
|
|
$im = imagecreatefromstring($param_2);
|
|
$fileName="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_chart_308inf_01.png";
|
|
imagePNG( $im,$fileName);
|
|
list($width, $height) = getimagesize($fileName);
|
|
if ($width>450)
|
|
echo"<img src='$fileName' width='450'>";
|
|
else
|
|
echo"<img src='$fileName'>";
|
|
|
|
//$imgData = base64_encode($param_2);
|
|
//$src = 'data: $param_1;base64,'.$imgData;
|
|
//echo"<img src='$src' >";
|
|
}
|
|
?>
|
|
</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">
|
|
<div class="tag_buttons">
|
|
<?php echo "<a href=?pg=site308>"; ?><INPUT class='btn btn-info btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Back; ?>"></A>
|
|
|
|
<?php if (!empty($_SESSION['site308_edit'])) { ?>
|
|
<a href="?pg=site308&dev=<?php echo $_GET['dev']; ?>&act=del" onclick="return confirm('Jesteś pewien, że chcesz usunąć?');"><INPUT class='btn btn-danger btn-sm' TYPE='BUTTON' VALUE='<?php echo$lab_ButtonName_Delete; ?>'></a>
|
|
<?php echo "<a href=?pg=site308E&eq=".$_GET['dev'].">"; ?><INPUT class='btn btn-success btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Modify; ?>"></A>
|
|
<?php } ?>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|