📄 index.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 search_click(){\r\n\tvar url\t= \"search.php\";\r\n\tlocation = url;\r\n}\r\n\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 "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&del_r=index_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, ";
echo "status=yes');\r\n}\r\n\r\nfunction detail(product_id)\r\n{\r\n\t/* 20077-7-4 sun 把product_id改成PRODUCT_ID*/\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=\"+pro";
echo "vider_id;\r\n\twindow.open(url, '', 'height=600,width=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/notify_new.gif\" align=\"absmiddle\">产品信息查看 \r\n\t\t</td>\r\n\t</tr>\r\n\t<tr class=\"";
echo "tablehead2\">\r\n\t\t<td><BUTTON class=btn onClick=\"search_click();\" 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>\r\n\t\t</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";
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";
	}
	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=\"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 "\">产品名称";
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 "\">产品型号";
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 "\">成本价";
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 "\">出售价";
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 "\">供应商";
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'] );
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 + -