list.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

	$product_id = $row['PRODUCT_ID'];
	$product_name = $row['PRODUCT_NAME'];
	$date = $row['DATE'];
	$amt = $row['AMT'];
	$price = $row['PRICE'];
	$salesman = $row['SALESMAN'];
	$discount = $row['DISCOUNT'];
	$memo = $row['MEMO'];
	$create_user = $row['SALE_HISTORY_CREATE_USER'];
	$purview_dept = $row['PURVIEW_DEPT'];
	$purview_role = $row['PURVIEW_ROLE'];
	$purview_user = $row['PURVIEW_USER'];
	$createor = $row['CREATEOR'];
	$manage_user = $row['MANAGE_USER'];
	$purview = $row['PURVIEW'];
	$customer_name = strlen( $old_customer_name ) <= 35 ? $old_customer_name : substr( $old_customer_name, 0, 35 ).chr( 0 )."...";
	if ( $date == "0000-00-00" )
	{
		$date = "";
	}
	if ( $count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	switch ( $purview )
	{
	case "1" :
		$purview_ses = default_validate( );
		break;
	case "2" :
		$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
		break;
	case "3" :
		$dept_validate = dept_validate( );
		$role_validate = role_validate( );
		$user_validate = user_validate( );
		if ( ( $dept_validate || $role_validate || $user_validate ) === false )
		{
			$purview_ses = default_validate( );
		}
		else
		{
			$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
		}
	}
	if ( $manage_user == $_SESSION['LOGIN_USER_ID'] || $manage_user == "" )
	{
		$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
	}
	if ( $purview_ses == false )
	{
	}
	else
	{
		if ( $create_user != "" )
		{
			$sqlcu = "SELECT USER_NAME FROM user WHERE USER_ID='".$create_user."'";
			$rscu = exequery( $connection, $sqlcu );
			$rowcu = mysql_fetch_array( $rscu );
			$create_name = $rowcu['USER_NAME'];
		}
		else
		{
			$create_name = "";
		}
		echo "<tr class=\"";
		echo $TableLine;
		echo "\">\r\n\t\t<td title=\"";
		echo $customer_name;
		echo "\">";
		echo $purview_ses;
		echo "</td>\r\n\t\t<td title=\"";
		echo $product_name;
		echo "\"><a href=\"#\" onclick=\"product_detail('";
		echo $product_id;
		echo "');\">";
		echo strlen( $product_name ) <= 30 ? $product_name : substr( $product_name, 0, 30 ).chr( 0 )."...";
		echo "</a></td>\r\n\t\t<td>";
		echo $date;
		echo "</td>\r\n\t\t<td>";
		echo $amt;
		echo "</td>\r\n\t\t<td title=\"";
		echo $price;
		echo "\">";
		echo strlen( $price ) <= 10 ? $price : substr( $price, 0, 10 ).chr( 0 )."...";
		echo "</td>\r\n\t\t<td title=\"";
		echo $discount;
		echo "\">";
		echo strlen( $discount ) <= 10 ? $discount : substr( $discount, 0, 10 ).chr( 0 )."...";
		echo "</td>\r\n\t\t<td title=\"";
		echo $salesman;
		echo "\">";
		echo strlen( $salesman ) <= 8 ? $salesman : substr( $salesman, 0, 8 ).chr( 0 )."...";
		echo "</td>\r\n\t\t<td>";
		echo $create_name;
		echo "</td>\r\n\t\t<td>";
		if ( $create_user == $_SESSION['LOGIN_USER_ID'] || $create_user == "" )
		{
			echo "\t\t<a href=\"javascript:edt('";
			echo $history_id;
			echo "');\">编辑 </a>\r\n\t\t<a href=\"javascript:del('";
			echo $history_id;
			echo "');\">删除 </a>";
		}
		echo "</td>\r\n\t</tr>\r\n";
	}
}
echo "<center>";
if ( $count == 0 )
{
	message( "提示", "暂无记录" );
	exit( );
}
echo "</center>";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "\t<thead class=\"TableHeader\">\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=customer_name&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">所属客户";
if ( $_REQUEST['order'] == "customer_name" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=product_name&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">产品";
if ( $_REQUEST['order'] == "product_name" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=date&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">销售日期";
if ( $_REQUEST['order'] == "date" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=amt&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">数量";
if ( $_REQUEST['order'] == "amt" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=price&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">价格";
if ( $_REQUEST['order'] == "price" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=discount&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">折扣";
if ( $_REQUEST['order'] == "discount" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=salesman&cur_page=";
echo $cur_page;
echo "&CUSTOMER_NAME=";
echo $_REQUEST['CUSTOMER_NAME'];
echo "&PRODUCT_ID=";
echo $_REQUEST['PRODUCT_ID'];
echo "&DATE=";
echo $_REQUEST['DATE'];
echo "&DATE2=";
echo $_REQUEST['DATE2'];
echo "&AMT=";
echo $_REQUEST['AMT'];
echo "&AMT2=";
echo $_REQUEST['AMT2'];
echo "&PRICE=";
echo $_REQUEST['PRICE'];
echo "&PRICE2=";
echo $_REQUEST['PRICE2'];
echo "&DISCOUNT=";
echo $_REQUEST['DISCOUNT'];
echo "&DISCOUNT2=";
echo $_REQUEST['DISCOUNT2'];
echo "&SALESMAN=";
echo $_REQUEST['SALESMAN'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "\">销售员";
if ( $_REQUEST['order'] == "salesman" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>创建人</td>\r\n\t\t<td width=\"14%\">操作</td>\r\n\t</thead>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n\t<tr>\r\n\t\t<td class=\"TableLine1\" nowrap align=\"right\">";
disp( "sens=".$_REQUEST['sens']."&order=".$_REQUEST['order']."&CUSTOMER_NAME=".$_REQUEST['CUSTOMER_NAME']."&PRODUCT_ID=".$_REQUEST['PRODUCT_ID']."&DATE=".$_REQUEST['DATE']."&DATE2=".$_REQUEST['DATE2']."&AMT=".$_REQUEST['AMT']."&AMT2=".$_REQUEST['AMT2']."&PRICE=".$_REQUEST['PRICE']."&PRICE2=".$_REQUEST['PRICE2']."&DISCOUNT=".$_REQUEST['DISCOUNT']."&DISCOUNT2=".$_REQUEST['DISCOUNT2']."&SALESMAN=".$_REQUEST['SALESMAN']."&MEMO=".$_REQUEST['MEMO']."" );
echo "</td>\r\n\t</tr>\r\n</table>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</body>\r\n</html>\r\n";
?>