📄 record.php
字号:
}
echo ">\r\n\r\n <td nowrap class=\"TableData\">单价：</td>\r\n <td class=\"TableData\">\r\n";
if ( $PRICE == "" )
{
echo " \t<input type=\"text\" name=\"PRICE\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"0.0\">\r\n";
}
else
{
echo " <input type=\"text\" name=\"PRICE\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"";
echo $PRICE;
echo "\">\r\n\r\n";
}
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">办公用品类别：</td>\r\n <td class=\"TableData\">\r\n <select name=\"OFFICE_PROTYPE\" class=\"BigSelect\" onChange=\"getProduct()\">\r\n <option value=\"-1\">请选择类别</option>\r\n";
$query = "SELECT CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO='OFFICE_PROTYPE' order by CODE_NAME";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$CODENAME = $ROW['CODE_NAME'];
$CODENO = $ROW['CODE_NO'];
echo " <option value=\"";
echo $CODE_NO;
echo "\" ";
if ( $CODENO == $OFFICE_PROTYPE )
{
echo "selected";
}
echo ">";
echo $CODENAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n \t<tr>\r\n <td nowrap class=\"TableData\">办公用品：</td>\r\n <td class=\"TableData\">\r\n <select name=\"PRO_ID\" class=\"BigSelect\">\r\n <option value=\"-1\">---请选择---</option>\r\n";
if ( $LOGIN_USER_PRIV != 1 )
{
$query = "SELECT * from OFFICE_PRODUCTS where (PRO_MANAGER='".$LOGIN_USER_ID."' or find_in_set('{$LOGIN_DEPT_ID}',PRO_DEPT)) or (PRO_MANAGER='' and PRO_DEPT='') or PRO_DEPT='ALL_DEPT'";
}
else
{
$query = "SELECT * from OFFICE_PRODUCTS";
}
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$PROID = $ROW['PRO_ID'];
$PRONAME = $ROW['PRO_NAME'];
$PROSTOCK = $ROW['PRO_STOCK'];
$PROUNIT = $ROW['PRO_UNIT'];
echo " <option value=\"";
echo $PROID;
echo "\" ";
if ( $PROID == $PRO_ID )
{
echo "selected";
}
echo ">";
echo $PRONAME;
echo "/库存";
echo $PROSTOCK;
echo $PROUNIT;
echo "</option>\r\n";
}
echo " </select> \r\n\t\t <input type=\"button\" name=\"SelectPro\" title=\"模糊选择\" value=\"模糊选择\" class=\"SmallButton\" onClick=\"LoadWindow2()\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">数量：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"TRANS_QTY\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"";
echo $TRANS_QTY;
echo "\">\r\n </td>\r\n </tr>\r\n\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">备注：</td>\r\n <td class=\"TableData\">\r\n <textarea name=\"REMARK\" cols=\"45\" rows=\"5\" class=\"BigInput\">";
echo $REMARK;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"hidden\" name=\"TRANS_ID\" value=\"";
echo $TRANS_ID;
echo "\">\r\n <input type=\"button\" value=\"确认\" class=\"BigButton\" onClick=\"CheckForm();\"> \r\n";
if ( $TRANS_ID != "" )
{
echo " <input type=\"button\" value=\"取消\" class=\"BigButton\" onClick=\"location='record.php'\">\r\n";
}
echo " </td>\r\n </tfoot>\r\n </table>\r\n</form>\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from OFFICE_TRANSHISTORY where OPERATOR='".$LOGIN_USER_ID."' and TRANS_DATE='{$CUR_DATE}' order by TRANS_ID desc";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$TRANS_ID = $ROW['TRANS_ID'];
$PRO_ID = $ROW['PRO_ID'];
$BORROWER = $ROW['BORROWER'];
$TRANS_FLAG = $ROW['TRANS_FLAG'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$PRICE = $ROW['PRICE'];
$TRANS_DATE = $ROW['TRANS_DATE'];
$OPERATOR = $ROW['OPERATOR'];
$query1 = "select PRO_NAME,PRO_STOCK,PRO_PRICE from OFFICE_PRODUCTS where PRO_ID='".$PRO_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRO_NAME = $ROW['PRO_NAME'];
$PRO_STOCK = $ROW['PRO_STOCK'];
$PRO_PRICE = $ROW['PRO_PRICE'];
}
$query1 = "select USER_NAME from USER where USER_ID='".$LOGIN_USER_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$OPERATOR_NAME = $ROW['USER_NAME'];
}
if ( $TRANS_FLAG == "0" )
{
$TRANS_NAME = "采购入库";
$BORROWER_NAME = "";
}
if ( $TRANS_FLAG == "1" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "领用";
$TOK = strtok( $BORROWER, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
$PRICE = $PRO_PRICE;
}
if ( $TRANS_FLAG == "2" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "借用";
$TOK = strtok( $BORROWER, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
$PRICE = $PRO_PRICE;
}
if ( $TRANS_FLAG == "3" )
{
$TRANS_NAME = "归还";
$TOK = strtok( $BORROWER, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
$PRICE = $PRO_PRICE;
}
if ( $TRANS_FLAG == "4" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "报废";
$BORROWER_NAME = "";
$PRICE = $PRO_PRICE;
}
if ( $VOTE_COUNT == 1 )
{
echo " <table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n </table>\r\n <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" WIDTH=\"22\" HEIGHT=\"22\" align=\"absmiddle\"><span class=\"big3\"> 今日操作查看</span>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n <table width=\"95%\" class=\"TableList\">\r\n <tr class=\"TableHeader\">\r\n \t <td nowrap align=\"center\">办公用品名称</td>\r\n <td nowrap align=\"center\">登记类型</td>\r\n <td nowrap align=\"center\">领用/借用/归还人</td>\r\n <td nowrap align=\"center\">数量</td>\r\n <td nowrap align=\"center\">当前库存</td>\r\n <td nowrap align=\"center\">单价</td>\r\n <td nowrap align=\"center\">操作日期</td>\r\n <td nowrap align=\"center\">操作员</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
}
if ( $VOTE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
echo $PRO_NAME;
echo "</td>\r\n <td align=\"center\">";
echo $TRANS_NAME;
echo "</td>\r\n <td align=\"center\">";
echo $BORROWER_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TRANS_QTY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PRO_STOCK;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PRICE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TRANS_DATE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $OPERATOR_NAME;
echo "</td>\r\n\r\n <td nowrap align=\"center\"> \r\n <a href=\"record.php?TRANS_ID=";
echo $TRANS_ID;
echo "\">修改</a>\r\n \r\n <a href=\"javascript:delete_vote('";
echo $TRANS_ID;
echo "');\"> 放弃操作</a>\r\n </td>\r\n </tr>\r\n";
}
if ( 0 < $VOTE_COUNT )
{
echo "</table>\r\n";
}
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -