report.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 230 行
PHP
230 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<html>
<head>
<title>
';
if (($TRANS_FLAG == 0))
{
echo '采购物品报表';
}
if (($TRANS_FLAG == 4))
{
echo '报废物品报表';
}
echo '</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'tyle type="text/css">
.small { font-size: 9pt;}
</style>
</head>
<body>
<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">
';
echo '<s';
echo 'pan class="big5">
';
if (($TRANS_FLAG == 0))
{
echo '采购物品报表';
}
if (($TRANS_FLAG == 4))
{
echo '报废物品报表';
}
echo ' </span>
</td>
<td align="right">
<input type="button" class="SmallButton" value="关闭" onclick="window.close();"> <input type="button" class="SmallButton" value="打印" onclick="window.print();">
</td>
</tr>
</table>
<br>
<div align="center">
';
$CUR_DATE = date ('Y-m-d', time ());
($WHERE_STR .= (((''.' where a.TRANS_FLAG=\'').$TRANS_FLAG).'\''));
if (($FROM_DATE != ''))
{
($WHERE_STR .= (((''.' and a.TRANS_DATE>=\'').$FROM_DATE).'\''));
}
if (($TO_DATE != ''))
{
($WHERE_STR .= (((''.' and a.TRANS_DATE<=\'').$TO_DATE).'\''));
}
if (($PRO_ID != ''))
{
($WHERE_STR .= (((''.' and a.PRO_ID=\'').$PRO_ID).'\''));
}
if (($OFFICE_PROTYPE != ''))
{
($WHERE_STR .= (((''.' and b.OFFICE_PROTYPE=\'').$OFFICE_PROTYPE).'\''));
}
$query1 = 'select DEPT_ID from DEPARTMENT';
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
if ((is_dept_priv ($DEPT_ID) == 1))
{
$TO_ID = (($TO_ID.$DEPT_ID).',');
continue;
}
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where c.DEPT_ID in (').$TO_ID).')'));
}
else
{
($WHERE_STR .= (((''.' and c.DEPT_ID in (').$TO_ID).')'));
}
$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,b.PRO_PRICE as PRO_PRICE,a.PRICE as TRANS_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
LEFT OUTER JOIN USER c ON a.OPERATOR = c.USER_ID
'.$WHERE_STR).' order by b.PRO_NAME,a.TRANS_DATE DESC');
$cursor = exequery ($connection, $query);
$cursor2 = exequery ($connection, $query);
$VOTE_COUNT = 0;
$ROW1 = mysql_fetch_array ($cursor2);
$SET_PRONMAE = $ROW1['PRO_NAME'];
$TOTAL_SUM1 = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$ROW1 = mysql_fetch_array ($cursor2);
$SET_PRONMAE = $ROW1['PRO_NAME'];
++$VOTE_COUNT;
$FLAG = 0;
$PROID = $ROW['PRO_ID'];
$PRONAME = $ROW['PRO_NAME'];
if (($SET_PRONMAE != $PRONAME))
{
$FLAG = 1;
}
$PRO_UNIT = $ROW['PRO_UNIT'];
$BORROWER = $ROW['BORROWER'];
$TRANSFLAG = $ROW['TRANS_FLAG'];
$REMARK = $ROW['REMARK'];
if (($TRANS_FLAG == 0))
{
$TRANS_QTY = $ROW['TRANS_QTY'];
}
if (($TRANS_FLAG == 4))
{
$TRANS_QTY = ($ROW['TRANS_QTY'] * -1);
}
if (($TRANS_FLAG == 0))
{
$PRICE = $ROW['TRANS_PRICE'];
}
if (($TRANS_FLAG == 4))
{
$PRICE = $ROW['PRO_PRICE'];
}
$TOTAL_SUM = ($TOTAL_SUM + round (($TRANS_QTY * $PRICE), 2));
$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 == '4'))
{
$TRANS_NAME = '报废';
$BORROWER_NAME = '';
}
if (($VOTE_COUNT == 1))
{
echo ' <table bordercolor="#000000" width="95%" style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=2 bordercolor=\'#000000\' class="small" align="center">
';
}
if ((($VOTE_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr>
<td nowrap align="center">';
echo $PRONAME;
echo '</td>
<td align="center">';
echo $TRANS_NAME;
echo '</td>
<td nowrap align="center">';
echo $TRANS_QTY;
echo $PRO_UNIT;
echo '</td>
<td nowrap align="center">';
echo $PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_DATE;
echo '</td>
<td nowrap align="center">';
echo $OPERATOR_NAME;
echo '</td>
<td nowrap align="center">';
echo $REMARK;
echo '</td>
</tr>
';
if (($FLAG == 1))
{
echo ' <tr>
<td nowrap align="right" colspan="7"><b>合计：';
echo $TOTAL_SUM;
echo ' 元</b></td>
</tr>
';
$TOTAL_SUM1 = ($TOTAL_SUM1 + $TOTAL_SUM);
$TOTAL_SUM = 0;
continue;
}
}
if ((0 < $VOTE_COUNT))
{
echo ' <tr>
<td nowrap align="right" colspan="7"><b>共计：';
echo $TOTAL_SUM1;
echo ' 元</b></td>
</tr>
<thead bgcolor="#D3E5FA">
<td nowrap align="center"><b>办公用品名称</b></td>
<td nowrap align="center"><b>登记类型</b></td>
<td nowrap align="center"><b>数量</b></td>
<td nowrap align="center"><b>单价</b></td>
<td nowrap align="center"><b>操作日期</b></td>
<td nowrap align="center"><b>操作员</b></td>
<td nowrap align="center"><b>备注</b></td>
</thead>
</table>
';
echo '
';
}
else
{
message ('', '无操作记录！！');
}
echo '</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?