⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
	$CUSTOMER_COUNT = $ROW[0];
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil( $CUSTOMER_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
	$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT CUSTOMER_ID,CUSTOMER_NAME,TEL_NO,FAX_NO, SELLER,a.EMAIL as EMAIL,b.CODE_NAME as SELLMODE, c.CODE_NAME as KIND,d.USER_NAME as SELLER,d.USER_ID as SELLERID,e.CODE_NAME as CUSTOMER_AREA,a.CREATDATE as CREATDATE,f.USER_NAME as CREATOR,a.CREATOR as CREATORID,a.LOCKED as  LOCKED from CUSTOMER a\r\n         LEFT OUTER JOIN SYS_CODE b\r\n         ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n         LEFT OUTER JOIN SYS_CODE c\r\n         ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n         LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = 'AREA'\r\n         LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID\r\n         LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
if ( $offest < 0 )
{
	$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
	message( "<br>提示", "没有符合条件的客户" );
	exit( );
}
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr>\r\n    <td align=\"left\">\r\n        <a href=\"index.php?CUR_PAGE=1&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n        <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>\r\n        <a href=\"index.php?CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n        <a href=\"index.php?CUR_PAGE=";
echo $PAGE_COUNT;
echo "&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
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>\r\n\r\n      到\r\n      <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\"  class=\"SmallInput\">\r\n      页\r\n      <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onClick=\"set_page()\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n    </td>\r\n    <td align=\"right\">\r\n      ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页&nbsp;共&nbsp;";
echo $CUSTOMER_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n<table class=\"TableList\" width=\"95%\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\" ";
if ( $SCOPE == "2" )
{
	echo "style=display:none";
}
echo ">选择</td>\r\n      <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
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 "\">客户名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
echo "&ORDERFIELD=KIND&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 "\">客户类别&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "KIND" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "KIND" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
echo "&ORDERFIELD=CUSTOMER_AREA&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 "\">地区&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CUSTOMER_AREA" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_AREA" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&SCOPE=";
echo $SCOPE;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&SOURCE=";
echo $SOURCE;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&ATTRIBUTE=";
echo $ATTRIBUTE;
echo "&ENTERTYPE=";
echo $ENTERTYPE;
echo "&TEL_NO=";
echo $TEL_NO;
echo "&AREACODE=";
echo $AREACODE;
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -