list.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 767 行 · 第 1/2 页
PHP
767 行
echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
<a href="list.php?';
echo $urlstr;
echo '&CUR_PAGE=';
echo $PAGE_COUNT;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
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(\'';
echo $urlstr;
echo '\')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</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"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=PRODUCT_NAME&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">产品名称 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'PRODUCT_NAME')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRODUCT_NAME')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=SERVICE_NAME&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">服务名称 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'SERVICE_NAME')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SERVICE_NAME')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=PRICE&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">销售单价 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'PRICE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'PRICE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=AMT&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">数量 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'AMT')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'AMT')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=TOTAL_PRICE&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">总价 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'TOTAL_PRICE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'TOTAL_PRICE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=DATE&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">日期 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'DATE')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'DATE')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">客户名称 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
<td nowrap align="center"><a href="list.php?';
echo $urlstr;
echo '&ORDERFIELD=SELLER&ORDERSIGN=';
if (($ORDERSIGN == 'DOWN'))
{
echo 'UP';
}
if (($ORDERSIGN == 'UP'))
{
echo 'DOWN';
}
if (($ORDERSIGN == ''))
{
if (($ORDERTYPE == 'ASC'))
{
echo 'UP';
}
else
{
echo 'DOWN';
}
}
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '">销售员 ';
if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'SELLER')))
{
echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
}
if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SELLER')))
{
echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
}
echo '</a></td>
</tr>
';
$CUSTOMER_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$CUSTOMER_COUNT;
$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'];
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
$TYPE1 = $ROW['TYPE'];
$HISTORY_ID1 = $ROW['HISTORY_ID'];
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 $CUSTOMER_NAME1;
echo '</td>
<td nowrap align="center">';
echo $SELLER1;
echo '</td>
</tr>
';
}
}
echo '</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?