📄 care.php
字号:
<?php
include_once( "inc/auth.php" );
$YEAR = date( "Y" );
$MONTH = date( "m" );
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$MANAGER_ID = $ROW['MANAGER_ID'];
$MANAGERS = $ROW['MANAGERS'];
$DELETE_FLAG = $ROW['DELETE_FLAG'];
}
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\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(\"sms_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n {\r\n \tif(!document.all(\"sms_select\").item(i).disabled)\r\n \t document.all(\"sms_select\").item(i).checked=true;\r\n \telse\r\n \t document.all(\"sms_select\").item(i).checked=false;\r\n }\r\n else\r\n document.all(\"sms_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked && document.all(\"sms_select\").disabled==false)\r\n document.all(\"sms_select\").checked=true;\r\n else\r\n document.all(\"sms_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction Send_To()\r\n{\r\n TO_ID=\"\";\r\n for(i=0;i<document.all(\"sms_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"sms_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n TO_ID+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"sms_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n TO_ID+=val + \",\";\r\n }\r\n }\r\n\r\n if(TO_ID==\"\")\r\n {\r\n alert(\"请至少选择一个客户\");\r\n return;\r\n }\r\n URL=\"/general/mobile_sms/new/?TO_ID1=\" + TO_ID;\r\n window.location=URL;\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</script>\r\n</head>\r\n<body>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/address.gif\" align=\"absmiddle\"><span class=\"big3\"> 本月生日客户(";
echo $CUR_YEAR;
echo "年";
echo $CUR_MON;
echo "月)</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
$MONTH_BEGIN = $MONTH."-01";
$MONTH_END = $MONTH."-".date( "t", $DATE );
$query = "SELECT count(*) FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER='".$LOGIN_USER_ID."' and SUBSTRING(a.BIRTHDAY,6,5)>='{$MONTH_BEGIN}' and SUBSTRING(a.BIRTHDAY,6,5)<='{$MONTH_END}'";
$cursor = exequery( $connection, $query );
$LINKMAN_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINKMAN_COUNT = $ROW[0];
}
$query = "SELECT a.MOBILE FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER='".$LOGIN_USER_ID."' and a.BIRTHDAY>='{$MONTH_BEGIN}' and a.BIRTHDAY<='{$MONTH_END}'".$OREDERBY;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$MOBILE1 = $ROW['MOBILE'];
if ( $MOBILE1 != "" )
{
$MOBIL_NO_STR .= $MOBILE1.",";
}
}
$query1 = "SELECT a.LINKMAN_ID,b.CUSTOMER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.CUSTOMER_NAME FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` where a.SELLER='".$LOGIN_USER_ID."' and SUBSTRING(a.BIRTHDAY,6,5)>='{$MONTH_BEGIN}' and SUBSTRING(a.BIRTHDAY,6,5)<='{$MONTH_END}'".$OREDERBY;
$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\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n\r\n";
$LINKMAN_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$LINKMAN_COUNT;
$LINKMAN_ID1 = $ROW['LINKMAN_ID'];
$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
$LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
$SEX1 = $ROW['SEX'];
$TEL_NO_WORK1 = $ROW['TEL_NO_WORK'];
$EMAIL1 = $ROW['EMAIL'];
$OICQ1 = $ROW['OICQ'];
$ICQ1 = $ROW['ICQ'];
$MOBILE1 = $ROW['MOBILE'];
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
if ( $SEX1 == "0" )
{
$SEX_DESC = "男";
}
else
{
$SEX_DESC = "女";
}
if ( $LINKMAN_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
if ( $MOBILE1 == "" )
{
$MOBILE1 = "暂无手机号码";
}
echo "\r\n <tr class=\"";
echo $TableLine;
echo "\">\r\n\r\n";
if ( find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
echo "<td> <input type=\"checkbox\" name=\"sms_select\" value=\"";
echo $MOBILE1;
echo "\" ";
if ( $MOBILE1 == "暂无手机号码" )
{
echo " DISABLED";
}
echo " onClick=\"check_one(self);\"></td>\r\n";
}
echo " \t <td nowrap align=\"center\">";
echo $CUSTOMER_NAME1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $LINKMAN_NAME1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SEX_DESC;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $OICQ1;
echo "/";
echo $ICQ1;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TEL_NO_WORK1;
echo "</td>\r\n <td nowrap align=\"center\"><a href=\"/general/mobile_sms?TO_ID1=";
echo $MOBILE1;
echo "\">";
echo $MOBILE1;
echo "</a></td>\r\n <td nowrap align=\"center\">";
echo $EMAIL1;
echo "</td>\r\n </tr>\r\n";
}
if ( find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
echo " <tr class=\"TableControl\">\r\n <td colspan=\"9\">\r\n \t <input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n <label for=\"allbox_for\">全选</label> \r\n <input type=\"button\" name=\"send\" value=\"发送短信\" class=\"BigButton\" onclick=\"Send_To()\">\r\n </td>\r\n</tr>\r\n";
}
echo " <thead class=\"TableHeader\">\r\n";
if ( find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
echo " <td nowrap align=\"center\">选择</td>\r\n";
}
echo " <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE =";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
echo "&&ORDERFIELD=b.CUSTOMER_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
if ( $ORDERTYPE == "ASC" )
{
echo "UP";
}
else
{
echo "DOWN";
}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">客户名称 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "b.CUSTOMER_NAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "b.CUSTOMER_NAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE =";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
echo "&&ORDERFIELD=LINKMAN_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
if ( $ORDERTYPE == "ASC" )
{
echo "UP";
}
else
{
echo "DOWN";
}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">联系人姓名 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "LINKMAN_NAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "LINKMAN_NAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"index.php?CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&CUSTOMER_CODE =";
echo $CUSTOMER_CODE;
echo "&CUSTOMER_SHORT=";
echo $CUSTOMER_SHORT;
echo "&LINKMAN_NAME=";
echo $LINKMAN_NAME;
echo "&ADD_HOME=";
echo $ADD_HOME;
echo "&SEX=";
echo $SEX;
echo "&&ORDERFIELD=SEX&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
if ( $ORDERTYPE == "ASC" )
{
echo "UP";
}
else
{
echo "DOWN";
}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">性别 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SEX" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SEX" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\">QQ/MSN</td>\r\n <td nowrap align=\"center\">工作电话</td>\r\n <td nowrap align=\"center\">手机</td>\r\n <td nowrap align=\"center\">电子邮件</td>\r\n </thead>\r\n</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -