📄 list.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
if ( $_REQUEST['cur_page'] == "" )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
echo "\r\n<html>\r\n<head>\r\n<title>产品查询结果</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction del(product_id)\r\n{\r\n\tvar msg\t= \"你确认要删除所选记录吗?\";\r\n\tif(window.confirm(msg))\r\n\t{\r\n\t\tvar url\t= \"delete.php?product_id=\"+product_id+\"&cur_page=";
echo $cur_page;
echo "&del_r=list_r\";\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n\r\nfunction edt(product_id, provider_id)\r\n{\r\n\tvar url\t= \"edit.php?product_id=\"+product_id+\"&provider_id=\"+provider_id;\r\n\tlocation = url;\r\n}\r\n\r\nfunction product_detail(product_id)\r\n{\r\n\tvar url\t= \"detail.php?product_id=\"+product_id;\r\n\twindow.open(url, '', 'height=600,width=800,top=50, left=100,toolbar=no,menubar=no,scrollbars=no, resizable=yes,location=no, s";
echo "tatus=yes');\r\n}\r\n\r\nfunction detail(product_id)\r\n{\r\n\tURL=\"detail.php?product_id=\"+product_id;\r\n\twindow.open(URL,\"read_notify\",\"height=600,width=800,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=50,left=100,resizable=yes\");\r\n}\r\n\r\nfunction provider_detail(provider_id)\r\n{\r\n\tvar url\t= \"../../../provider/manage/detail.php?provider_id=\"+provider_id;\r\n\twindow.open(url, '', 'height=600,widt";
echo "h=800,top=50, left=100,toolbar=no,menubar=no,scrollbars=no, resizable=yes,location=no, status=yes'); \r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n\t<tr class=\"tablehead1\">\r\n\t\t<td><img src=\"/images/manage/news.gif\" align=\"absmiddle\">产品查询结果</td>\r\n\t</tr>\r\n\t<tr class=\"tablehead2\">\r\n\t\t<td><BUTTON class=btn onClick=\"javscrip";
echo "t:history.back();\" title=\"返回\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON></td>\r\n\t</tr>\r\n</table>\r\n<br>\r\n";
$connection = openconnection( );
$query = "SELECT pt.*, pr.PROVIDER_NAME, pr.PROVIDER_ID FROM product as pt, provider as pr where pt.PROVIDER_ID=pr.PROVIDER_ID";
$where_str = "";
if ( $_REQUEST['PRODUCT_NAME'] != "" )
{
	$where_str .= " and pt.PRODUCT_NAME like '%".$_REQUEST['PRODUCT_NAME']."%'";
}
if ( $_REQUEST['PRODUCT_TYPE'] != "" )
{
	$where_str .= " and pt.PRODUCT_TYPE like '%".$_REQUEST['PRODUCT_TYPE']."%'";
}
if ( $_REQUEST['MEASURE_UNIT'] != "" )
{
	$where_str .= " and pt.MEASURE_UNIT like '%".$_REQUEST['MEASURE_UNIT']."%'";
}
if ( $_REQUEST['COST_PRICE'] != "" )
{
	$where_str .= " and pt.COST_PRICE >= '".$_REQUEST['COST_PRICE']."'";
}
if ( $_REQUEST['STANDARD_PRICE'] != "" )
{
	$where_str .= " and pt.STANDARD_PRICE >= '".$_REQUEST['STANDARD_PRICE']."'";
}
if ( $_REQUEST['PRODUCT_DESC'] != "" )
{
	$where_str .= " and pt.PRODUCT_DESC like '%".$_REQUEST['PRODUCT_DESC']."%'";
}
if ( $_REQUEST['PROVIDER_ID'] != "" )
{
	$where_str .= " and pt.PROVIDER_ID=".$_REQUEST['PROVIDER_ID']."";
}
$query .= $where_str;
switch ( $_REQUEST['order'] )
{
case "product_name" :
	$query .= " order by pt.PRODUCT_NAME";
	break;
case "product_type" :
	$query .= " order by pt.PRODUCT_TYPE";
	break;
case "cost_price" :
	$query .= " order by pt.COST_PRICE";
	break;
case "standard_price" :
	$query .= " order by pt.STANDARD_PRICE";
	break;
case "provider_name" :
	$query .= " order by pr.PROVIDER_NAME";
	break;
default :
	$query .= " order by pt.PRODUCT_ID";
	break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$count = 0;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\" class=\"small\">\r\n";
while ( $row = mysql_fetch_array( $cursor ) )
{
	++$count;
	$product_id = $row['PRODUCT_ID'];
	$product_name = $row['PRODUCT_NAME'];
	$product_type = $row['PRODUCT_TYPE'];
	$measure_unit = $row['MEASURE_UNIT'];
	$cost_price = $row['COST_PRICE'];
	$standard_price = $row['STANDARD_PRICE'];
	$provider_id = $row['PROVIDER_ID'];
	$provider_name = $row['PROVIDER_NAME'];
	$product_desc = $row['PRODUCT_DESC'];
	$product_create_user = $row['PRODUCT_CREATE_USER'];
	if ( $count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	$length = 36;
	echo "<tr class=\"";
	echo $TableLine;
	echo "\">\r\n\t\t<td title=\"";
	echo $product_name;
	echo "\"><a href=\"#\" onclick=\"javascript:detail('";
	echo $product_id;
	echo "');\">";
	echo strlen( $product_name ) <= 20 ? $product_name : substr( $product_name, 0, 20 ).chr( 0 )."...";
	echo "</a></td>\r\n\t\t<td title=\"";
	echo $product_type;
	echo "\">";
	echo strlen( $product_type ) <= 20 ? $product_type : substr( $product_type, 0, 20 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title=\"";
	echo $cost_price;
	echo "\">";
	echo strlen( $cost_price ) <= 8 ? $cost_price : substr( $cost_price, 0, 8 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title=\"";
	echo $standard_price;
	echo "\">";
	echo strlen( $standard_price ) <= 8 ? $standard_price : substr( $standard_price, 0, 8 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title=\"";
	echo $provider_name;
	echo "\"><a href=\"#\" onclick=\"javascript:provider_detail('";
	echo $provider_id;
	echo "');\">";
	echo strlen( $provider_name ) <= 30 ? $provider_name : substr( $provider_name, 0, 30 ).chr( 0 )."...";
	echo "</a></td>\r\n\t\t<td nowrap><a href=\"#\" onclick=\"javascript:detail('";
	echo $product_id;
	echo "');\">详情 </a></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=product_name&cur_page=";
echo $cur_page;
echo "&PRODUCT_NAME=";
echo $_REQUEST['PRODUCT_NAME'];
echo "&PRODUCT_TYPE=";
echo $_REQUEST['PRODUCT_TYPE'];
echo "&MEASURE_UNIT=";
echo $_REQUEST['MEASURE_UNIT'];
echo "&COST_PRICE=";
echo $_REQUEST['COST_PRICE'];
echo "&STANDARD_PRICE=";
echo $_REQUEST['STANDARD_PRICE'];
echo "&PRODUCT_DESC=";
echo $_REQUEST['PRODUCT_DESC'];
echo "&PROVIDER_ID=";
echo $_REQUEST['PROVIDER_ID'];
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=product_type&cur_page=";
echo $cur_page;
echo "&PRODUCT_NAME=";
echo $_REQUEST['PRODUCT_NAME'];
echo "&PRODUCT_TYPE=";
echo $_REQUEST['PRODUCT_TYPE'];
echo "&MEASURE_UNIT=";
echo $_REQUEST['MEASURE_UNIT'];
echo "&COST_PRICE=";
echo $_REQUEST['COST_PRICE'];
echo "&STANDARD_PRICE=";
echo $_REQUEST['STANDARD_PRICE'];
echo "&PRODUCT_DESC=";
echo $_REQUEST['PRODUCT_DESC'];
echo "&PROVIDER_ID=";
echo $_REQUEST['PROVIDER_ID'];
echo "\">产品型号";
if ( $_REQUEST['order'] == "product_type" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=cost_price&cur_page=";
echo $cur_page;
echo "&PRODUCT_NAME=";
echo $_REQUEST['PRODUCT_NAME'];
echo "&PRODUCT_TYPE=";
echo $_REQUEST['PRODUCT_TYPE'];
echo "&MEASURE_UNIT=";
echo $_REQUEST['MEASURE_UNIT'];
echo "&COST_PRICE=";
echo $_REQUEST['COST_PRICE'];
echo "&STANDARD_PRICE=";
echo $_REQUEST['STANDARD_PRICE'];
echo "&PRODUCT_DESC=";
echo $_REQUEST['PRODUCT_DESC'];
echo "&PROVIDER_ID=";
echo $_REQUEST['PROVIDER_ID'];
echo "\">成本价";
if ( $_REQUEST['order'] == "cost_price" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=standard_price&cur_page=";
echo $cur_page;
echo "&PRODUCT_NAME=";
echo $_REQUEST['PRODUCT_NAME'];
echo "&PRODUCT_TYPE=";
echo $_REQUEST['PRODUCT_TYPE'];
echo "&MEASURE_UNIT=";
echo $_REQUEST['MEASURE_UNIT'];
echo "&COST_PRICE=";
echo $_REQUEST['COST_PRICE'];
echo "&STANDARD_PRICE=";
echo $_REQUEST['STANDARD_PRICE'];
echo "&PRODUCT_DESC=";
echo $_REQUEST['PRODUCT_DESC'];
echo "&PROVIDER_ID=";
echo $_REQUEST['PROVIDER_ID'];
echo "\">出售价";
if ( $_REQUEST['order'] == "standard_price" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=provider_name&cur_page=";
echo $cur_page;
echo "&PRODUCT_NAME=";
echo $_REQUEST['PRODUCT_NAME'];
echo "&PRODUCT_TYPE=";
echo $_REQUEST['PRODUCT_TYPE'];
echo "&MEASURE_UNIT=";
echo $_REQUEST['MEASURE_UNIT'];
echo "&COST_PRICE=";
echo $_REQUEST['COST_PRICE'];
echo "&STANDARD_PRICE=";
echo $_REQUEST['STANDARD_PRICE'];
echo "&PRODUCT_DESC=";
echo $_REQUEST['PRODUCT_DESC'];
echo "&PROVIDER_ID=";
echo $_REQUEST['PROVIDER_ID'];
echo "\">供应商";
if ( $_REQUEST['order'] == "provider_name" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>操作</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']."&PRODUCT_NAME=".$_REQUEST['PRODUCT_NAME']."&PRODUCT_TYPE=".$_REQUEST['PRODUCT_TYPE']."&MEASURE_UNIT=".$_REQUEST['MEASURE_UNIT']."&COST_PRICE=".$_REQUEST['COST_PRICE']."&STANDARD_PRICE=".$_REQUEST['STANDARD_PRICE']."&PRODUCT_DESC=".$_REQUEST['PRODUCT_DESC']."&PROVIDER_ID=".$_REQUEST['PROVIDER_ID']."" );
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>";
?>
⌨️ 快捷键说明

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