55 lines
3.3 KiB
PHP
55 lines
3.3 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site301_edit']))
|
|
{
|
|
?>
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site306_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_site207_002 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site207_003 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_002 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site306_001 ;?></TD>
|
|
|
|
|
|
</TR>
|
|
|
|
<?php
|
|
// $wynik = mysql_query("select SES_ID,SES_EQU_ID,EQU_NAME,MCF_NAME,SES_STOCK,SES_PARAM1,EQU_PARAM_01,EQU_PARAM_02 from seg_equipments_stock left join seg_equipments on SES_EQU_ID=EQU_ID left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_STOCK>0 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']."%') and SES_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='ARMATURE')");
|
|
//$wynik = mysql_query("select SES_ID,SES_EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME,sum(SES_VALUE) TOT_VAL,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' and SDE_DRS_EQU_ID=SES_EQU_ID) TOT_STOCK from seg_equipments_stock,seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_EQU_ID=EQU_ID and SES_PARAM3='".$_SESSION['syndis_eq_stock']."' and SES_TYPE=15 GROUP BY SES_EQU_ID order by EQU_NAME");
|
|
unset($tmp307Array);
|
|
$tmp307Array = sqlGetResAsArray("select SES_EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME,sum(SES_VALUE) TOT_VAL,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' and SDE_DRS_EQU_ID=SES_EQU_ID) TOT_STOCK from seg_equipments_stock,seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_EQU_ID=EQU_ID and SES_PARAM3='".$_SESSION['syndis_eq_stock']."' and SES_TYPE=15 GROUP BY SES_EQU_ID order by EQU_NAME");
|
|
|
|
for ($i=0; $i<count($tmp307Array); $i++)
|
|
{
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site301infArum¶m=".$_GET['dev'].",".$tmp307Array[$i]['SES_EQU_ID']."'".chr(34).">
|
|
<TD class='field_left'>".$tmp307Array[$i]['EQU_NAME']."$sql_2</TD>
|
|
<TD class='field_center'".$tmp307Array[$i]['EQU_PARAM_01'].">$sql_6</TD>
|
|
<TD class='field_center'>".$tmp307Array[$i]['EQU_PARAM_02']."$sql_7</TD>
|
|
<TD class='field_left'>".$tmp307Array[$i]['MCF_NAME']."$sql_3</TD>
|
|
<TD class='field_center'>".round($tmp307Array[$i]['TOT_VAL'] - $tmp307Array[$i]['TOT_STOCK'],2)."$sql_4</TD>
|
|
</TR>";
|
|
}
|
|
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<div class="tag_buttons">
|
|
<a href='?pg=site301inf&dev=<?php echo $_GET['dev']; ?>'><INPUT class='btn btn-info btn-sm' TYPE='BUTTON' VALUE='<?php echo $lab_ButtonName_Cancel; ?>'></A>
|
|
</div>
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|