softspm/kopalnia_2014
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
kopalnia_2014/sites/site306inf.php
T
debian 6ed3153f36 Initial commit
2026-09-03 11:24:19 +02:00

231 lines
9.2 KiB
PHP
Raw Permalink Blame History

<?php
if (!empty($_SESSION['site306']))
{
?>
<?php
//aktualizacja danych o fakturze
if ($_POST['inSesId']>0 && $_POST['subCableUpdate']==$lab_ButtonName_Update)
{
mysql_query("update seg_equipments_stock SET SES_DESCRIPTION='".$_POST['inCableAtt']."',SES_VALUE='".$_POST['inCablePis']."',SES_PARAM1='".$_POST['inCableEST']."',SES_INVOICE_NO='".$_POST['inCableInv']."',SES_INVOICE_DATE='".$_POST['inCableBuyDate']."',SES_AUDIT_CU='".$_SESSION['user']."',SES_AUDIT_CD=now() where SES_ID=".$_POST['inSesId']);
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
unset($maxDRSid);
}
?>
<?php
$eqArray = sqlGetResAsArray("select EQU_ID,EQU_NAME,MCF_NAME,EQU_DESCRIPTION from seg_equipments left join seg_manufacturers on MCF_NAME=EQU_MCF_ID where EQU_ID=".$_GET['eq']);
$stockArray = sqlGetResAsArray("select sum(SES_VALUE) ILE,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' and SDE_DRS_EQU_ID=SES_EQU_ID) USED from seg_equipments_stock where SES_PARAM3='".$_SESSION['syndis_eq_stock']."' and SES_EQU_ID=".$_GET['eq']);
?>
<div class="tag50_left">
<div class="head_tag"><?php echo $eqArray[0]['EQU_NAME'] ;?></div>
<div class="tag">
<TABLE class="desc_val">
<TR>
<TD class="desc_equipment"><?php echo $lab_Field_site306_004; ?></TD>
<TD CLASS="desc_value"><?php echo $eqArray[0]['EQU_NAME']; ?></TD>
</TR>
<TR>
<TD class="desc_equipment"><?php echo $lab_Field_site206_002; ?></TD>
<TD CLASS="desc_value"><?php echo $eqArray[0]['MCF_NAME']; ?></TD>
</TR>
<TR>
<TD class="desc_equipment"><?php echo $lab_Field_site306_006; ?></TD>
<TD CLASS="desc_value"><?php echo $stockArray[0]['ILE']; ?></TD>
</TR>
<TR>
<TD class="desc_equipment"><?php echo $lab_Field_site306_005; ?></TD>
<TD CLASS="desc_value"><?php echo (int) ($stockArray[0]['ILE'] - $stockArray[0]['USED']); ?></TD>
</TR>
<TR>
<TD class="desc_equipment"><?php echo $lab_Field_site310_031; ?></TD>
<TD CLASS="desc_value"><?php echo $eqArray[0]['EQU_DESCRIPTION']; ?></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=".$_GET['eq'])>0)
{
echo"
<TR>
<TD class='desc_equipment'>$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=".$_GET['eq']);
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>
</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=".$_GET['eq']);
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_206inf_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="tag100">
<div class="head_tag"><?php echo $lab_Tag_site307_001 ;?></div>
<div class="tag_center">
<table WIDTH="100%" class="tag">
<TR>
<TD class="label">Lp.</TD>
<TD class="label"><?php echo $lab_Field_site307_002 ;?></TD>
<TD class="label"><?php echo $lab_Field_site306_003 ;?></TD>
<TD class="label"><?php echo $lab_Field_site303_013 ;?></TD>
<TD class="label"><?php echo $lab_Field_site206_003 ;?></TD>
<TD class="label"><?php echo $lab_Field_site302_003 ;?></TD>
<TD class="label"><?php echo $lab_Field_site307_005 ;?></TD>
</TR>
<?php
$invDetArray = sqlGetResAsArray("select SES_ID,SES_INVOICE_NO,SES_VALUE,SES_PARAM1,SES_DESCRIPTION,SES_INVOICE_DATE,SES_AUDIT_CU from seg_equipments_stock where SES_EQU_ID=".$_GET['eq']." and SES_PARAM3='".$_SESSION['syndis_eq_stock']."' order by SES_INVOICE_DATE desc");
for ($i=0; $i<count($invDetArray); $i++)
{
if (!empty($_SESSION['site306_edit']))
echo "<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='./?pg=site306E&param=".$_GET['eq'].",".$invDetArray[$i]['SES_ID']."'".chr(34).">";
else
echo "<tr>";
echo"
<TD class='field_right'>".($i+1)."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_INVOICE_NO']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_VALUE']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_PARAM1']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_DESCRIPTION']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_INVOICE_DATE']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SES_AUDIT_CU']."</TD>
</TR>
";
}
?>
</table>
</div>
</div>
<div class="tag100">
<div class="head_tag"><?php echo $lab_Tag_site307_002 ;?></div>
<div class="tag_center">
<table WIDTH="100%" class="tag">
<TR>
<td class='label'>Lp.</td>
<td class='label'><?php echo $lab_Field_site810_003; ?></td>
<td class='label'><?php echo $lab_Field_site306_009; ?></td>
<td class='label'><?php echo $lab_Field_site306_003; ?></td>
</TR>
<?php
$invDetArray = sqlGetResAsArray("select WLL_BARIERA,WLL_NAME,sum(SDE_VALUE) SUMA from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID and DRS_DEV_TYPE=12 left join seg_wells on WLL_ID=DRS_DEV_ID where SDE_TYPE=13 and SDE_DRS_EQU_ID=".$_GET['eq']." and SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' group by SDE_DRS_DEV_ID");
for ($i=0; $i<count($invDetArray); $i++)
{
echo"
<TR>
<TD class='field_right'>".($i+1)."</TD>
<TD class='field_center'>".$invDetArray[$i]['WLL_BARIERA']."</TD>
<TD class='field_center'>".$invDetArray[$i]['WLL_NAME']."</TD>
<TD class='field_center'>".$invDetArray[$i]['SUMA']."</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">
<div class="tag_buttons">
<?php echo "<a href=./?pg=site306>"; ?><INPUT class="btn btn-info btn-sm" TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Back; ?>"></A>
</div>
</div>
<?php
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>
Reference in New Issue View Git Blame Copy Permalink