📄 list2.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<script>
</script>
<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());
$WHERE_STR.=" where a.TRANS_FLAG='2'";
if($PRO_ID!=" " and $PRO_ID!="")
$WHERE_STR.=" and a.PRO_ID='$PRO_ID '";
if($PRO_NAME!=" " and $PRO_NAME!="")
$WHERE_STR.=" and b.PRO_NAME like '%".$PRO_NAME."%'";
if($FROM_DATE!=" " and $FROM_DATE!="")
$WHERE_STR.=" and a.TRANS_DATE>='$FROM_DATE'";
if($TO_DATE!=" " and $TO_DATE!="")
$WHERE_STR.=" and a.TRANS_DATE<='$TO_DATE'";
if($BORROWER!=" " and $BORROWER!="")
$WHERE_STR.=" and a.BORROWER='$BORROWER'";
$query="SELECT count(distinct a.PRO_ID) FROM `OFFICE_TRANSHISTORY` a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID".$WHERE_STR;
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$VOTE_COUNT=$ROW[0];
if($VOTE_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 借用</span><br>
</td>
</tr>
</table>
<br>
<?
Message("","无满足条件!!!");
exit;
}
$PER_PAGE=5;
$PAGES=5;
$PAGE_COUNT=ceil($VOTE_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
$CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
$CUR_PAGE=$PAGE_COUNT;
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3">借用(<?=$VOTE_COUNT?>条)</span><br>
</td>
<td align="right" valign="bottom" class="small1">
<a class="A1" href="list2.php?CUR_PAGE=1&PRO_ID=<?=$PRO_ID?>&PRO_NAME=<?=$PRO_NAME?>&FROM_DATE=<?=$FROM_DATE?>&TO_DATE=<?=$TO_DATE?>"><<</a>
<a class="A1" href="list2.php?CUR_PAGE=<?=$PAGE_COUNT?>&PRO_ID=<?=$PRO_ID?>&PRO_NAME=<?=$PRO_NAME?>&FROM_DATE=<?=$FROM_DATE?>&TO_DATE=<?=$TO_DATE?>">>></a>
<?
if($CUR_PAGE%$PAGES==0)
$J=$PAGES;
else
$J=$CUR_PAGE%$PAGES;
if($CUR_PAGE-1>=1)
{
?>
<a class="A1" href="list2.php?CUR_PAGE=<?=$CUR_PAGE-1?>&PRO_ID=<?=$PRO_ID?>&PRO_NAME=<?=$PRO_NAME?>&FROM_DATE=<?=$FROM_DATE?>&TO_DATE=<?=$TO_DATE?>"><</a>
<?
}
else
{
?>
<
<?
}
if($CUR_PAGE+1<= $PAGE_COUNT)
{
?>
<a class="A1" href="list2.php?CUR_PAGE=<?=$CUR_PAGE+1?>&PRO_ID=<?=$PRO_ID?>&PRO_NAME=<?=$PRO_NAME?>&FROM_DATE=<?=$FROM_DATE?>&TO_DATE=<?=$TO_DATE?>">></a>
<?
}
else
{
?>
>
<?
}
?>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="60%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">办公用品ID</td>
<td nowrap align="center">办公用品名称</td>
<td nowrap align="center">借用总量</td>
</tr>
<?
//============================ 显示汇总查询 =======================================
$query="SELECT a.PRO_ID as PROID, b.PRO_NAME as PRONAME,sum(TRANS_QTY) as TOTALQTY ,b.PRO_UNIT as PROUNIT FROM `OFFICE_TRANSHISTORY` a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID".$WHERE_STR." GROUP BY a.PRO_ID, b.PRO_NAME";
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$VOTE_COUNT++;
if($VOTE_COUNT<$CUR_PAGE*$PER_PAGE-$PER_PAGE+1)
continue;
if($VOTE_COUNT>$CUR_PAGE*$PER_PAGE)
break;
$PROID=$ROW["PROID"];
$PRONAME=$ROW["PRONAME"];
$TOTALQTY=$ROW["TOTALQTY"]*(-1);
$PROUNIT=$ROW["PROUNIT"];
$TOTALPRICE=$ROW["TOTALPRICE"];
$PRICE=round($TOTALPRICE/$TOTALQTY,2);
if($VOTE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>" style="cursor:hand" onclick="td_detail('<?=$PROID?>');" title="单击查看借用明细">
<td nowrap align="center"><?=$PROID?></td>
<td align="center"><?=$PRONAME?></td>
<td nowrap align="center"><?=$TOTALQTY?><?=$PROUNIT?></td>
</tr>
<tr class="TableData" id=<?=$PROID?> style="display:none" onDblClick="td_close('<?=$PROID?>');" title="双击关闭子窗口">
<td align="left" colspan=5>
<br>
<table border="0" cellspacing="1" width="30%" class="small" bgcolor="#000000" cellpadding="3">
<tr 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>
</tr>
<?
//============================显示明细查询=======================================
$WHERE_STR1="";
$WHERE_STR1.=" where a.TRANS_FLAG='2' and a.PRO_ID='$PROID'";
if($FROM_DATE!=" " and $FROM_DATE!="")
$WHERE_STR1.=" and a.TRANS_DATE>='$FROM_DATE'";
if($TO_DATE!=" " and $TO_DATE!="")
$WHERE_STR1.=" and a.TRANS_DATE<='$TO_DATE'";
if($BORROWER!=" " and $BORROWER!="")
$WHERE_STR1.=" and a.BORROWER='$BORROWER'";
$query1="SELECT a.PRO_ID, b.PRO_NAME ,a.TRANS_QTY ,b.PRO_UNIT,a.TRANS_DATE,a.OPERATOR,a.BORROWER FROM `OFFICE_TRANSHISTORY` a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID".$WHERE_STR1;
$cursor1= exequery($connection,$query1);
$DETAIL_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$DETAIL_COUNT++;
$DETAIL_PROID=$ROW["PRO_ID"];
$DETAIL_PRONAME=$ROW["PRO_NAME"];
$DETAIL_TRANSQTY=$ROW["TRANS_QTY"]*(-1);
$DETAIL_PROUNIT=$ROW["PRO_UNIT"];
$DETAIL_PRICE=$ROW["PRICE"];
$DETAIL_USER=$ROW["OPERATOR"];
$DETAIL_BORROWER=$ROW["BORROWER"];
$DETAIL_DATE=$ROW["TRANS_DATE"];
$TOK=strtok($DETAIL_USER,",");
$query1="select USER_NAME from USER where USER_ID='$TOK'";
$cursor2= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor2))
$DETAIL_USERNAME=$ROW["USER_NAME"];
$TOK=strtok($DETAIL_BORROWER,",");
$query1="SELECT `USER_ID` , `USER_NAME` , PRIV_NAME, DEPT_NAME,a.DEPT_ID as DEPT_ID FROM `USER` a LEFT OUTER JOIN DEPARTMENT b ON a.DEPT_ID = b.DEPT_ID LEFT OUTER JOIN USER_PRIV c ON a.USER_PRIV = c.USER_PRIV where a.USER_ID='$TOK'";
$cursor2= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor2))
{
$DETAIL_BORROWERNAME=$ROW["USER_NAME"];
$DETAIL_BORROWERDEPT=$ROW["DEPT_NAME"];
$DETAIL_BORROWERDEPTID=$ROW["DEPT_ID"];
}
if($DETAIL_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="TableData" onclick="show('<?=$DETAIL_PROID?>','<?=$DETAIL_DATE?>','<?=$DETAIL_BORROWERDEPTID?>');" title="单击查看归还">
<td nowrap align="center"><?=$DETAIL_BORROWERNAME?></td>
<td nowrap align="center"><?=$DETAIL_BORROWERDEPT?></td>
<td nowrap align="center"><?=$DETAIL_TRANSQTY?><?=$DETAIL_PROUNIT?></td>
<td nowrap align="center"><?=$DETAIL_USERNAME?></td>
<td nowrap align="center"><?=$DETAIL_DATE?></td>
</tr>
<?
}
?>
</table>
</td>
</tr>
<?
}
?>
<tr>
<td class="TableControl" colspan="3" align="center">
<a href="javascript:noreturn('<?=$PRO_ID?>','<?=$PRO_NAME?>','<?=$FROM_DATE?>','<?=$TO_DATE?>','<?=$BORROWER?>');">查看未归还的办公用品</a>
</td>
</tr>
</table>
</body>
</html>
<script Language="JavaScript">
function td_detail(I)
{
if(document.all(I).style.display=="none")
{document.all(I).style.display=""; document.all(I).style.cursor="hand";
}
else
document.all(I).style.display="none";
}
function td_close(I)
{
document.all(I).style.display="none";
}
function show(PRO_ID,DATE,DEP_ID)
{
URL="show_return.php?PRO_ID="+PRO_ID+"&DATE="+DATE+"&DEP_ID="+DEP_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_vote","height=500,width=700,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function noreturn(PRO_ID,PRO_NAME,FROM_DATE,TO_DATE,BORROWER)
{
URL="noreturn.php?PRO_ID="+PRO_ID+"&PRO_NAME="+PRO_NAME+"&FROM_DATE="+FROM_DATE+"&TO_DATE="+TO_DATE+"&BORROWER="+BORROWER ;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_vote","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -