📄 list.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 LoadWindow1()\r\n{\r\n URL=\"/general/sale/sale_history/customer_select\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:400px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\nfunc";
echo "tion LoadWindow2()\r\n{\r\n URL=\"/general/sale/sale_history/product_select\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:400px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\nfunction td_calen";
echo "dar(fieldname)\r\n{\r\n myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n\r\nfunction del(provider_id)\r\n{\r\n\tva";
echo "r msg\t= \"你确认要删除所选记录吗?\";\r\n\tif(window.confirm(msg))\r\n\t{\r\n\t\tvar url\t= \"delete.php?PROVIDER_ID=\"+provider_id+\"&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&del_r=list_r&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
echo "&PAGE_START=";
echo $_REQUEST['PAGE_START'];
echo "\";\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n\r\nfunction edt(provider_id)\r\n{\r\n\tvar url\t= \"edit.php?provider_id=\"+provider_id+\"&edt_r=list_r&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
echo "&PAGE_START=";
echo $_REQUEST['PAGE_START'];
echo "\";\r\n\tlocation = url;\r\n}\r\n\r\nfunction product_detail(provider_id)\r\n{\r\n\tvar url\t= \"detail.php?provider_id=\"+provider_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<form action=\"list.php\" method=\"post\" name=\"form1\" > \r\n<table border=\"0\" width=";
echo "\"100%\" cellspacing=\"1\" cellpadding=\"0\" >\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/notify_new.gif\" align=\"absmiddle\">供应商基本信息查询结果</td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><BUTTON class=btn onClick=\"javscript: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 </tr>\r\n</table>\r\n<br>\r\n";
$connection = openconnection( );
$query = "SELECT PROVIDER_ID, PROVIDER_NAME, TEL_NO, PROVIDER_WWW, EMAIL, PROVIDER_CREATE_USER from provider";
$where_str = "";
if ( $_REQUEST['PROVIDER_NAME'] != "" )
{
$where_str .= " where PROVIDER_NAME like '%".$_REQUEST['PROVIDER_NAME']."%'";
}
if ( $_REQUEST['TEL_NO'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and TEL_NO like '%".$_REQUEST['TEL_NO']."%'";
}
else
{
$where_str .= " where TEL_NO like '%".$_REQUEST['TEL_NO']."%'";
}
}
if ( $_REQUEST['FAX_NO'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and FAX_NO like '%".$_REQUEST['FAX_NO']."%'";
}
else
{
$where_str .= " where FAX_NO like '%".$_REQUEST['FAX_NO']."%'";
}
}
if ( $_REQUEST['PROVIDER_WWW'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and PROVIDER_WWW like '%".$_REQUEST['PROVIDER_WWW']."%'";
}
else
{
$where_str .= " where PROVIDER_WWW like '%".$_REQUEST['PROVIDER_WWW']."%'";
}
}
if ( $_REQUEST['EMAIL'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and EMAIL like '%".$_REQUEST['EMAIL']."%'";
}
else
{
$where_str .= " where EMAIL like '%".$_REQUEST['EMAIL']."%'";
}
}
if ( $_REQUEST['PROVIDER_ADD'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and PROVIDER_ADD like '%".$_REQUEST['PROVIDER_ADD']."%'";
}
else
{
$where_str .= " where PROVIDER_ADD like '%".$_REQUEST['PROVIDER_ADD']."%'";
}
}
if ( $_REQUEST['POSTALCODE'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and POSTALCODE like '%".$_REQUEST['POSTALCODE']."%'";
}
else
{
$where_str .= " where POSTALCODE like '%".$_REQUEST['POSTALCODE']."%'";
}
}
if ( $_REQUEST['MEMO'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and MEMO like '%".$_REQUEST['MEMO']."%'";
}
else
{
$where_str .= " where MEMO like '%".$_REQUEST['MEMO']."%'";
}
}
if ( $_REQUEST['BANK'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and BANK like '%".$_REQUEST['BANK']."%'";
}
else
{
$where_str .= " where BANK like '%".$_REQUEST['BANK']."%'";
}
}
if ( $_REQUEST['ACCOUNT'] != "" )
{
if ( $where_str != "" )
{
$where_str .= " and ACCOUNT like '%".$_REQUEST['ACCOUNT']."%'";
}
else
{
$where_str .= " where ACCOUNT like '%".$_REQUEST['ACCOUNT']."%'";
}
}
$query .= $where_str;
switch ( $_REQUEST['order'] )
{
case "provider_name" :
$query .= " order by PROVIDER_NAME";
break;
case "tel_no" :
$query .= " order by TEL_NO";
break;
case "provider_www" :
$query .= " order by PROVIDER_WWW";
break;
case "email" :
$query .= " order by EMAIL";
break;
default :
$query .= " order by PROVIDER_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;
$provider_id = $row['PROVIDER_ID'];
$tel_no = $row['TEL_NO'];
$product_name = $row['PROVIDER_NAME'];
$provider_www = $row['PROVIDER_WWW'];
$email = $row['EMAIL'];
$create_user = $row['PROVIDER_CREATE_USER'];
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 = "";
}
if ( $count % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo "<tr class=\"";
echo $TableLine;
echo "\">\r\n\t\t<td width=\"30%\" title=\"";
echo $product_name;
echo "\"><a href=\"#\" onclick=\"product_detail('";
echo $provider_id;
echo "');\">";
echo strlen( $product_name ) <= 35 ? $product_name : substr( $product_name, 0, 35 ).chr( 0 )."...";
echo "</a></td>\r\n\t\t<td title='";
echo $tel_no;
echo "'>";
echo strlen( $tel_no ) <= 50 ? $tel_no : substr( $tel_no, 0, 50 ).chr( 0 )."...";
echo "</td>\r\n\t\t<td title='";
echo $provider_www;
echo "'>";
echo strlen( $provider_www ) <= 50 ? $provider_www : substr( $provider_www, 0, 50 ).chr( 0 )."...";
echo "</td>\r\n\t\t<td title='";
echo $email;
echo "'>";
echo strlen( $email ) <= 50 ? $email : substr( $email, 0, 50 ).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 $provider_id;
echo "');\">编辑 </a>\r\n\t\t";
$sqlpv = "SELECT COUNT(PRODUCT_ID) AS cnt FROM product WHERE PROVIDER_ID='".$provider_id."'";
$rspv = exequery( $connection, $sqlpv );
$rowpv = mysql_fetch_array( $rspv );
$sqlo = "SELECT COUNT(PROVIDER_ID) AS cnt FROM officeitem_joinstoreroom WHERE PROVIDER_ID='".$provider_id."'";
$rspo = exequery( $connection, $sqlo );
$rowpo = mysql_fetch_array( $rspo );
if ( !( 0 < $rowpv['cnt'] + $rowpo['cnt'] ) )
{
echo "\t\t<a href=\"javascript:del('";
echo $provider_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=product_name&cur_page=";
echo $cur_page;
echo "&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
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=tel_no&cur_page=";
echo $cur_page;
echo "&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
echo "\">电话";
if ( $_REQUEST['order'] == "tel_no" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=provider_www&cur_page=";
echo $cur_page;
echo "&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
echo "\">网址";
if ( $_REQUEST['order'] == "provider_www" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=email&cur_page=";
echo $cur_page;
echo "&PROVIDER_NAME=";
echo $_REQUEST['PROVIDER_NAME'];
echo "&TEL_NO=";
echo $_REQUEST['TEL_NO'];
echo "&FAX_NO=";
echo $_REQUEST['FAX_NO'];
echo "&PROVIDER_WWW=";
echo $_REQUEST['PROVIDER_WWW'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&PROVIDER_ADD=";
echo $_REQUEST['PROVIDER_ADD'];
echo "&POSTALCODE=";
echo $_REQUEST['POSTALCODE'];
echo "&MEMO=";
echo $_REQUEST['MEMO'];
echo "&BANK=";
echo $_REQUEST['BANK'];
echo "&ACCOUNT=";
echo $_REQUEST['ACCOUNT'];
echo "\">电子邮件";
if ( $_REQUEST['order'] == "email" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>创建人</td>\r\n\t\t<td width=\"9%\">操作</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']."&PROVIDER_NAME=".$_REQUEST['PROVIDER_NAME']."&TEL_NO=".$_REQUEST['TEL_NO']."&FAX_NO=".$_REQUEST['FAX_NO']."&PROVIDER_WWW=".$_REQUEST['PROVIDER_WWW']."&EMAIL=".$_REQUEST['EMAIL']."&PROVIDER_ADD=".$_REQUEST['PROVIDER_ADD']."&POSTALCODE=".$_REQUEST['POSTALCODE']."&MEMO=".$_REQUEST['MEMO']."&BANK=".$_REQUEST['BANK']."&ACCOUNT=".$_REQUEST['ACCOUNT']."" );
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 + -