📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
echo "<html>\r\n<head>\r\n<title>供应商联系人管理 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script>\r\n function set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index.php?PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\n function delete_linkman(LINKMAN_ID)\r\n{\r\n msg='确认要删除该联系人？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&LINKMAN_ID=\" + LINKMAN_ID;\r\n window.location=URL;\r\n }\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 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?PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE =";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
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\nfunction mobile_sms(MOBIL_NO_STR)\r\n {\r\n URL=\"/general/mobile_sms/new/?TO_ID1=\"+MOBIL_NO_STR;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"mobile_sms\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n \r\n function show_detail(LINKMAN_ID)\r\n {\r\n URL=\"showdetail.php?LINKMAN_ID=\"+LINKMAN_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\n function excel_export()\r\n{\r\n document.form1.action=\"export.php\";\r\n document.form1.submit();\r\n document.form1.action=\"index.php\"; //有用？\r\n} \r\n</script>\r\n</head>\r\n<body class=\"bodycolor\">\r\n<div align=\"left\">\r\n<fieldset style=\"width:95%;padding-bottom:5px;\">\r\n\t <legend class=\"small\" align=left>\r\n <b> 查 询 </b>\r\n </legend>\r\n<table cellspacing=\"1\" class=\"small\" align=\"left\" cellpadding=\"3\">\r\n <form action=\"index.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\"> 供应商名称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n <td nowrap class=\"TableData\">供应商编码： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_CODE\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n\r\n <td nowrap class=\"TableData\">供应商简称： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PROVIDER_SHORT\" class=\"SmallInput\" size=\"15\" maxlength=\"100\"> \r\n </td>\r\n\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\"> 联系人姓名： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"LINKMAN_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n </td>\r\n <td nowrap class=\"TableData\">地址： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"ADD_HOME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" >\r\n </td>\r\n <td nowrap class=\"TableData\">性别： </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"SEX\" class=\"SmallSelect\">\r\n \t<option value=\"\" ></option>\r\n <option value=\"0\" ";
if ( $SEX == "0" )
{
echo "selected";
}
echo ">男</option>\r\n <option value=\"1\" ";
if ( $SEX == "1" )
{
echo "selected";
}
echo ">女</option>\r\n </select> \r\n <input type=\"checkbox\" name=\"MAIN_LINKMAN\" id=\"MAIN_LINKMAN\" value=\"1\"><label for=\"MAIN_LINKMAN\">主联系人</label>\r\n <input value=\"查询\" type=\"submit\" class=\"SmallButton\" title=\"模糊查询\" name=\"button\">\r\n \t\t <input type=\"button\" value=\"导出\" class=\"SmallButton\" title=\"导出供应商联系人信息\" name=\"button\" onClick=\"excel_export()\"> \r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\r\n";
if ( $PROVIDER_NAME != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
else
{
$WHERE_STR .= " and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
}
if ( $PROVIDER_NAME != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
else
{
$WHERE_STR .= " and b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
}
if ( $PROVIDER_CODE != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
else
{
$WHERE_STR .= " and b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
}
if ( $PROVIDER_SHORT != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
else
{
$WHERE_STR .= " and b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
}
if ( $LINKMAN_NAME != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
else
{
$WHERE_STR .= " and a.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
}
}
if ( $ADD_HOME != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.ADD_HOME like '%".$ADD_HOME."%'";
}
else
{
$WHERE_STR .= " and a.ADD_HOME like '%".$ADD_HOME."%'";
}
}
if ( $SEX != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.SEX='".$SEX."'";
}
else
{
$WHERE_STR .= " and a.SEX='".$SEX."'";
}
}
if ( $MAIN_LINKMAN != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
}
else
{
$WHERE_STR .= " and a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
}
}
if ( $ORDERFIELD != "" )
{
if ( $ORDERSIGN == "DOWN" )
{
$ORDERTYPE = "ASC";
}
if ( $ORDERSIGN == "UP" )
{
$ORDERTYPE = "DESC";
}
$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$query = "SELECT count(*) FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ";
$query .= $WHERE_STR;
$cursor = exequery( $connection, $query );
$LINKMAN_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINKMAN_COUNT = $ROW[0];
}
$query = "SELECT a.MOBILE FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ".$WHERE_STR.$OREDERBY;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$MOBILE1 = $ROW['MOBILE'];
if ( $MOBILE1 != "" )
{
$MOBIL_NO_STR .= $MOBILE1.",";
}
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil( $LINKMAN_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT MAIN_LINKMAN,a.LINKMAN_ID,b.PROVIDER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.PROVIDER_NAME FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
if ( $offest < 0 )
{
$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $LINKMAN_COUNT == 0 )
{
message( "<br>提示", "没有符合条件的联系人" );
echo "<br>\r\n\r\n";
exit( );
}
echo "\r\n<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&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
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 "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
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 "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
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 "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&MAIN_LINKMAN=";
echo $MAIN_LINKMAN;
echo "&PROVIDER_CODE=";
echo $PROVIDER_CODE;
echo "&PROVIDER_SHORT=";
echo $PROVIDER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -