detail.php
来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 212 行
PHP
212 行
<?
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">
<?
$CUR_DATE=date("Y-m-d",time());
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3"> 办公用品管理明细</span>
</td>
</tr>
</table>
<div align="center">
<?
//-----------合成SQL语句-----------
$CUR_DATE=date("Y-m-d",time());
$TRANS_FLAG=TRIM($TRANS_FLAG);
if($TRANS_FLAG!=-1)
if($WHERE_STR=="")
$WHERE_STR.=" where a.TRANS_FLAG='$TRANS_FLAG'";
else
$WHERE_STR.=" and a.TRANS_FLAG='$TRANS_FLAG'";
if($PRO_ID!=" " and $PRO_ID!="")
if($WHERE_STR=="")
$WHERE_STR.=" where a.PRO_ID='$PRO_ID'";
else
$WHERE_STR.=" and a.PRO_ID='$PRO_ID '";
if($PRO_NAME!=" " and $PRO_NAME!="")
if($WHERE_STR=="")
$WHERE_STR.=" where b.PRO_NAME like '%".$PRO_NAME."%'";
else
$WHERE_STR.=" and b.PRO_NAME like '%".$PRO_NAME."%'";
if($FROM_DATE!=" " and $FROM_DATE!="")
if($WHERE_STR=="")
$WHERE_STR.=" where a.TRANS_DATE>='$FROM_DATE'";
else
$WHERE_STR.=" and a.TRANS_DATE>='$FROM_DATE'";
if($TO_DATE!=" " and $TO_DATE!="")
if($WHERE_STR=="")
$WHERE_STR.=" where a.TRANS_DATE<='$TO_DATE'";
else
$WHERE_STR.=" and a.TRANS_DATE<='$TO_DATE'";
if($BORROWER!=" " and $BORROWER!="")
if($WHERE_STR=="")
$WHERE_STR.=" where a.BORROWER='$BORROWER'";
else
$WHERE_STR.=" and a.BORROWER='$BORROWER'";
//============================显示操作结果=======================================
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT a.PRO_ID, b.PRO_NAME,a.TRANS_FLAG ,a.TRANS_QTY,a.BORROWER,b.PRO_UNIT,a.PRICE,a.TRANS_DATE,a.OPERATOR,a.REMARK from OFFICE_TRANSHISTORY a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID".$WHERE_STR." order by a.TRANS_FLAG,a.TRANS_DATE DESC";
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$VOTE_COUNT++;
$PROID=$ROW["PRO_ID"];
$PRONAME=$ROW["PRO_NAME"];
$PRO_UNIT=$ROW["PRO_UNIT"];
$BORROWER=$ROW["BORROWER"];
$TRANSFLAG=$ROW["TRANS_FLAG"];
$REMARK=$ROW["REMARK"];
$TRANS_QTY=$ROW["TRANS_QTY"];
$PRICE =$ROW["PRICE"];
$TRANS_DATE=$ROW["TRANS_DATE"];
$OPERATOR=$ROW["OPERATOR"];
$query1="select USER_NAME from USER where USER_ID='$OPERATOR'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$OPERATOR_NAME=$ROW["USER_NAME"];
if ($TRANSFLAG=="0")
{
$TRANS_NAME="采购入库";
$BORROWER_NAME="";
}
if ($TRANSFLAG=="1")
{
$TRANS_NAME="领用";
$TRANS_QTY=$TRANS_QTY*(-1);
$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"];
}
if ($TRANSFLAG=="2")
{
$TRANSNAME="借用";
$TRANS_QTY=$TRANS_QTY*(-1);
$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"];
}
if ($TRANSFLAG=="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"];
}
if ($TRANSFLAG=="4")
{
$TRANS_NAME="报废";
$BORROWER_NAME="";
$TRANS_QTY=$TRANS_QTY*(-1);
}
if($VOTE_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
if($VOTE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRONAME?></td>
<td align="center"><?=$TRANS_NAME?></td>
<td align="center"><?=$BORROWER_NAME?></td>
<td nowrap align="center"><?=$TRANS_QTY?><?=$PRO_UNIT?></td>
<td nowrap align="center"><?=$PRICE?></td>
<td nowrap align="center"><?=$TRANS_DATE?></td>
<td nowrap align="center"><?=$OPERATOR_NAME?></td>
<td nowrap align="center"><?=$REMARK?></td>
</tr>
<?
}
if($VOTE_COUNT>0)
{
?>
<tr align="center" class="TableControl">
<td colspan="8" nowrap>
<input type="button" value="删除以上明细" class="BigButton" onClick="delete_all('<?=$TRANS_FLAG?>','<?=$PRO_ID?>','<?=$PRO_NAME?>','<?=$FROM_DATE?>','<?=$TO_DATE?>','<?=$BORROWER?>')">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</td>
</tr>
<thead class="TableHeader">
<td nowrap align="center">办公用品名称</td>
<td nowrap align="center">登记标示</td>
<td nowrap align="center">领用/借用/归还人</td>
<td nowrap align="center">数量</td>
<td nowrap align="center">单价</td>
<td nowrap align="center">操作日期</td>
<td nowrap align="center">操作员</td>
<td nowrap align="center">备注</td>
</thead>
</table>
<?
}
else
Message("","无操作记录！！");
?>
</div>
<script>
function delete_all(TRANS_FLAG,PRO_ID,PRO_NAME,FROM_DATE,TO_DATE,BORROWER)
{
msg='确认删除明细？';
if(window.confirm(msg))
{
URL="delete.php?TRANS_FLAG="+TRANS_FLAG+"&PRO_ID="+PRO_ID+"&PRO_NAME="+PRO_NAME+"&FROM_DATE"+FROM_DATE+"&TO_DATE="+TO_DATE+"&BORROWER="+BORROWER;
window.location=URL;
}
}
</script>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?