historylist.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 209 行
PHP
209 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$PAGE_SIZE = 2;
echo '<s';
echo 'cript>
function set_page()
{
PAGE_START=PAGE_NUM.value;
location="historylist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '&CUR_PAGE="+PAGE_START;
}
function delete_history(HISTORY_ID)
{
msg=\'确认要删除该销售记录？\';
if(window.confirm(msg))
{
URL="sale_history/delete.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '&HISTORY_ID=" + HISTORY_ID;
parent.location=URL;
}
}
</script>
<html>
<head>
<title>销售记录快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
$CUSTOMER_COUNT = 0;
$query = (((''.'SELECT count(*) from SALE_HISTORY a
LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID where a.CUSTOMER_ID=\'').$CUSTOMER_ID).'\' and a.CONTRACT_ID=\'-1\' and a.LINE_ID=\'-1\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CUSTOMER_COUNT = $ROW[0];
}
$PER_PAGE = 5;
$PAGE_COUNT = ceil (($CUSTOMER_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = (((''.'SELECT a.HISTORY_ID as HISTORY_ID,c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE,a.SALESMAN as SALESMAN,a.CREATOR as CREATOR
from SALE_HISTORY a
LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE=\'PRO\'
LEFT OUTER JOIN SERVICE d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE=\'SER\'
LEFT OUTER JOIN USER e ON a.SALESMAN=e.USER_ID
where a.CUSTOMER_ID=\'').$CUSTOMER_ID).'\' and a.CONTRACT_ID=\'-1\' and a.LINE_ID=\'-1\'');
$offest = (($CUR_PAGE - 1) * 5);
$query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
$cursor1 = exequery ($connection, $query1);
if (($CUSTOMER_COUNT == 0))
{
message ('<br>提示', '没有销售记录');
echo ' <div align="center">
<input type="button" value="新建销售记录" onClick="parent.location=\'sale_history?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\';" title="新建销售记录">
</div>
';
exit ();
}
else
{
echo '<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="historylist.php?CUR_PAGE=1&CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="historylist.php?CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '&CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
<a href="historylist.php?CUR_PAGE=';
echo ($CUR_PAGE + 1);
echo '&CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
<a href="historylist.php?CUR_PAGE=';
echo $PAGE_COUNT;
echo '&CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '"><img src=\'/images/last02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'末页\' style="cursor:hand"></a>
到
<input type="text" name="PAGE_NUM" size="3" maxlength="4" class="SmallInput">
页
<img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
<input type="image" name="Submit" s';
echo 'rc="/images/new.gif" onClick="parent.location=\'sale_history?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\';" title="新建销售记录">
</td>
<td align="right">
';
echo $CUR_PAGE;
echo '/';
echo $PAGE_COUNT;
echo '页 共 ';
echo $CUSTOMER_COUNT;
echo ' 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" 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>
<td nowrap align="';
echo 'center">日期</td>
<td nowrap align="center">销售员</td>
<td nowrap align="center">操作</td>
</tr>
';
$CUSTOMER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$CUSTOMER_COUNT;
$SIGN = '';
$HISTORY_ID1 = $ROW['HISTORY_ID'];
$PRODUCT_NAME1 = $ROW['PRODUCT_NAME'];
$SERVICE_NAME1 = $ROW['SERVICE_NAME'];
$PRICE1 = $ROW['PRICE'];
$AMT1 = $ROW['AMT'];
$TOTAL_PRICE1 = $ROW['TOTAL_PRICE'];
$CREAT_DATE = $ROW['DATE'];
$SELLER1 = $ROW['SELLER'];
$TYPE1 = $ROW['TYPE'];
$HISTORY_ID1 = $ROW['HISTORY_ID'];
$SALESMAN = $ROW['SALESMAN'];
$CREATOR = $ROW['CREATOR'];
if ((($SALESMAN == $LOGIN_USER_ID) OR ($CREATOR == $LOGIN_USER_ID)))
{
$SIGN = '1';
}
if ((($CUSTOMER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $PRODUCT_NAME1;
echo '</td>
<td nowrap align="center">';
echo $SERVICE_NAME1;
echo '</td>
<td nowrap align="center">';
echo $PRICE1;
echo '</td>
<td nowrap align="center">';
echo $AMT1;
echo '</td>
<td nowrap align="center">';
echo $TOTAL_PRICE1;
echo '</td>
<td nowrap align="center">';
echo $CREAT_DATE;
echo '</td>
<td nowrap align="center">';
echo $SELLER1;
echo '</td>
<td nowrap align="center">
';
if (($SIGN != '1'))
{
echo ' 无
';
}
else
{
echo ' <a href="sale_history/edit.php?HISTORY_ID=';
echo $HISTORY_ID1;
echo '" target=_parent> 编辑</a>
<a href="javascript:delete_history(';
echo $HISTORY_ID1;
echo ');"> 删除 </a>
';
}
echo ' </td>
</tr>
';
}
}
echo '</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?