📄 detail.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>产品详细资料 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT oj.*, oa.* FROM officeitem_joinstoreroom as oj, officeitem_appellation as oa WHERE oj.APPELLATION_ID=oa.APPELLATION_ID AND oj.STOREROOM_ID=".$_REQUEST['storeroom_id'];
$cursor = exequery( $connection, $query );
if ( $row = mysql_fetch_array( $cursor ) )
{
$storeroom_id = $row['STOREROOM_ID'];
$join_date = $row['JOIN_DATE'];
$provider_id = $row['PROVIDER_ID'];
$bill = $row['BILL'];
$appellation_id = $row['APPELLATION_ID'];
$price = $row['PRICE'];
$join_amount = $row['JOIN_AMOUNT'];
$money = $row['MONEY'];
$storeroom_stockpile = $row['STOREROOM_STOCKPILE'];
$operator = $row['OPERATOR'];
$join_appellation = $row['JOIN_APPELLATION'];
$join_appellation_sort = $row['JOIN_APPELLATION_SORT'];
$date = explode( " ", $join_date );
$query2 = "\r\n\t\tSELECT oa.APPELLATION, os.SORT, oa.SPEC \r\n\t\tFROM officeitem_appellation as oa, officeitem_sort as os \r\n\t\tWHERE oa.APPELLATION_ID=".$appellation_id." && os.SORT_ID=oa.SORT_ID\r\n\t\t";
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_row( $cursor2 ) )
{
$appellation = $row2[0];
$sort = $row2[1];
$spec = $row2[2];
}
$query3 = "SELECT USER_NAME FROM user WHERE USER_ID='".$operator."'";
$cursor3 = exequery( $connection, $query3 );
if ( $row3 = mysql_fetch_row( $cursor3 ) )
{
$user_name = $row3[0];
}
$sqlp = "SELECT * FROM provider WHERE PROVIDER_ID=".$provider_id;
$rsp = exequery( $connection, $sqlp );
$rowp = mysql_fetch_array( $rsp );
$PROVIDER_NAME = $rowp['PROVIDER_NAME'];
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/menu/notify_new.gif\" align=\"absmiddle\">入库单详情</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><BUTTON class=btn onclick=\"javascript:window.close()\" title=\"关闭窗口\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></t";
echo "d> <td>";
echo "<s";
echo "pan id=\"showallid\">关闭窗口</span></td></tr></table></BUTTON></td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\" align=\"center\" >\r\n <form name=\"form1\">\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">类别：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $sort;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableLine2\">名称：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $appellation;
echo " \r\n </td>\r\n </tr>\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">规格：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $spec;
echo " \r\n </td>\r\n </tr>\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">数量：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $join_amount;
echo " \r\n </td>\r\n </tr>\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">单价：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $price;
echo " \r\n </td>\r\n </tr>\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">金额：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $money;
echo " \r\n </td>\r\n </tr>\r\n <tr >\r\n <td width=\"120\" class=\"TableLine2\">操作员：</td>\r\n <td class=\"TableLine1\">\r\n ";
echo $user_name;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"120\" class=\"TableLine2\">入库时间：</td>\r\n <td class=\"TableLine1\" >\r\n ";
echo $date[0];
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"120\" class=\"TableLine2\">入库单据号：</td>\r\n <td class=\"TableLine1\" >\r\n ";
echo $bill;
echo " \r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"120\" class=\"TableLine2\">供应商：</td>\r\n <td class=\"TableLine1\" >\r\n ";
echo $PROVIDER_NAME;
echo " \r\n </td>\r\n </tr>\r\n\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -