📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>产品详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$query = "SELECT * from PRODUCT where PRODUCT_ID=$PRODUCT_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
$PRODUCT_TYPE1=$ROW["PRODUCT_TYPE"];
$PRODUCT_MODE1=$ROW["PRODUCT_MODE"];
$PRODUCT_CODE1=$ROW["PRODUCT_CODE"];
$MEASURE_UNIT1=$ROW["MEASURE_UNIT"];
$PRODUCT_LOWSTOCK1=$ROW["PRODUCT_LOWSTOCK"];
$COST_PRICE1=$ROW["COST_PRICE"];
$STANDARD_PRICE1=$ROW["STANDARD_PRICE"];
$PROVIDER_ID1=$ROW["PROVIDER_ID"];
$PRODUCT_DESC1=$ROW["PRODUCT_DESC"];
$MEMO11=$ROW["MEMO"];
$MEMO12=$ROW["MEMO1"];
$PHOTO=$ROW["PHOTO"];
}
$query="SELECT PROVIDER_NAME from PROVIDER where PROVIDER_ID='$PROVIDER_ID1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/product.gif" align="absmiddle"><span class="big3">产品详细信息</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="400" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="update.php" enctype="multipart/form-data" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
产品基本信息
</td>
</tr>
<tr>
<td class="TableData">供应商：</td>
<td class="TableData"><?=$PROVIDER_NAME1?></td>
<td class="TableData" width="100">产品编码： </td>
<td class="TableData"><?=$PRODUCT_CODE1?></td>
</tr>
<tr>
<td class="TableData" width="100">产品名称： </td>
<td class="TableData"><?=$PRODUCT_NAME1?> </td>
<td nowrap class="TableData">产品类别：</td>
<td class="TableData">
<?
GETALLDATE("PRODUCT_MODE",$PRODUCT_MODE1);
?>
</td>
</tr>
<tr>
<td nowrap class="TableData">产品型号：</td>
<td nowrap class="TableData"><?=$PRODUCT_TYPE1?></td>
<td nowrap class="TableData">计量单位：</td>
<td nowrap class="TableData"><?=$MEASURE_UNIT1?></td>
</tr>
<tr>
<td nowrap class="TableData">成本价：</td>
<td nowrap class="TableData"><?=$COST_PRICE1?></td>
<td nowrap class="TableData">出售价： </td>
<td nowrap class="TableData"><?=$STANDARD_PRICE1?></td>
</tr>
<tr>
<td nowrap class="TableData">警戒库存： </td>
<td nowrap class="TableData" colspan="3"><?=$PRODUCT_LOWSTOCK1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">产品描述： </td>
<td nowrap class="TableData" colspan="3"><?=$PRODUCT_DESC1?></td>
</tr>
<?
if($PHOTO!="")
{
?>
<tr>
<td nowrap class="TableData" align="center" colspan="4">
<img src='/inc/product_pic.php?PHOTO=<?=$PHOTO?>' width='100' border=1>
</td>
</tr>
<?
}
?>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
备注
</td>
</tr>
<tr>
<td nowrap class="TableData" width="100">备注1：</td>
<td nowrap class="TableData" colspan="3"><?=$MEMO11?></td>
</tr>
<tr>
<td nowrap class="TableData" width="100">备注2：</td>
<td nowrap class="TableData" colspan="3"><?=$MEMO12?></td>
</tr>
<tr>
<td class="TableData" colspan="4">
<?=get_field_table(get_field_text("LINKMAN", $LINKMAN_ID))?>
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</td>
</tr>
</form>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE' and CODE_NO='$GETVALUE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
echo $ROW["CODE_NAME"];
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -