📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
 

function GETALLDATE( $CODE, $GETVALUE )
{
	global $connection;
	$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
	$connection = openconnection( );
	$cursor = exequery( $connection, $query );
	echo "<option value= ></option>";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$CODE_NO = $ROW['CODE_NO'];
		$CODE_NAME = $ROW['CODE_NAME'];
		if ( $CODE_NO == $GETVALUE )
		{
			echo "<option value=".$CODE_NO."  selected>".$CODE_NAME."</option>";
		}
		else
		{
			echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";
		}
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$PAGE_SIZE = 10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$MANAGER_ID = $ROW['MANAGER_ID'];
	$MANAGERS = $ROW['MANAGERS'];
	$DELETE_FLAG = $ROW['DELETE_FLAG'];
}
echo "<html>\r\n<head>\r\n<title>客户快速搜索 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\n  function delete_customer(CUSTOMER_ID)\r\n{\r\n msg='确认要删除该客户报价么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CP_ID=\" + CUSTOMER_ID;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\nfunction ad_query()\r\n{\r\n  URL=\"ad_query\";\r\n  window.location=URL;\r\n}\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      document.all(\"allbox\").checked=false;\r\n}\r\nfunction set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\n\r\nfunction show_detail(CP_ID)\r\n  {\r\n    URL=\"showdetail.php?CP_ID=\"+CP_ID;\r\n    myleft=(screen.availWidth-650)/2;\r\n    window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n  }\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"email_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"email_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"email_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"email_select\").checked=true;\r\n   else\r\n      document.all(\"email_select\").checked=false;\r\n }\r\n}\r\nfunction delete_mail()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"email_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"email_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(i==0)\r\n  {\r\n      el=document.all(\"email_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一个客户。\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要删除所选客户？';\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&delete_str=\"+delete_str;\r\n    window.location=URL;\r\n  }\r\n}\r\n\r\nfunction excel_import()\r\n{\r\n  URL=\"../imp_exp/\";\r\n  window.location=URL;\r\n}\r\n\r\nfunction excel_export()\r\n{\r\n  URL=\"../excel\";\r\n  window.location=URL;\r\n}\r\n\r\n</script>\r\n</head>\r\n";
if ( $CUSTOMER_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
	}
}
if ( $CUSTOMER_CODE != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
	}
	else
	{
		$WHERE_STR .= " and CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
	}
}
if ( $CUSTOMER_SHORT != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
	}
	else
	{
		$WHERE_STR .= " and CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
	}
}
if ( !is_number( $PRICE1 ) )
{
	$PRICE1 = "";
}
if ( !is_number( $PRICE2 ) )
{
	$PRICE2 = "";
}
if ( $PRICE1 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRICE>=".$PRICE1;
	}
	else
	{
		$WHERE_STR .= " and PRICE>=".$PRICE1;
	}
}
if ( $PRICE2 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRICE<=".$PRICE2;
	}
	else
	{
		$WHERE_STR .= " and PRICE<=".$PRICE2;
	}
}
if ( $CUSTOMER_AREA != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where CUSTOMER_AREA= '".$CUSTOMER_AREA."'";
	}
	else
	{
		$WHERE_STR .= " and CUSTOMER_AREA= '".$CUSTOMER_AREA."'";
	}
}
if ( $PRODUCT_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
	}
}
if ( $PRODUCT_TYPE != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
	}
	else
	{
		$WHERE_STR .= " and PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
	}
}
if ( $PRODUCT_MODE != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRODUCT_MODE ='".$PRODUCT_MODE."'";
	}
	else
	{
		$WHERE_STR .= " and PRODUCT_MODE ='".$PRODUCT_MODE."'";
	}
}
if ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT = 0;
$query = "SELECT count(*) from CUSTOMER_PRODUCT a \r\n        LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n        LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID\r\n         ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$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 CP_ID,CUSTOMER_NAME,CUSTOMER_CODE,b.TEL_NO,PRODUCT_NAME,PRODUCT_CODE,MEASURE_UNIT,PRICE,REMARK,SEND_DATE from CUSTOMER_PRODUCT a\r\n        LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID\r\n        LEFT OUTER JOIN PRODUCT c ON a.PRODUCT_ID=c.PRODUCT_ID\r\n         ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
$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 "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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 "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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 "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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 "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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 border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n";
if ( $DELETE_FLAG == 0 || find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
	echo "       <td nowrap align=\"center\">选择</td>\r\n";
}
echo "       <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&ORDERFIELD=CUSTOMER_CODE&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_CODE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_CODE" )
{
	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 "&CUSTOMER_CODE=";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_AREA=";
echo $CUSTOMER_AREA;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
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";
	}
12 下一页
⌨️ 快捷键说明

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