list.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

echo "<?";
echo "\r\ninclude_once(\"inc/auth.php\");\r\ninclude_once(\"inc/function_page_01.php\");\r\n\r\nif (\$_REQUEST[\"cur_page\"] == '')\r\n    \$cur_page = 1;\r\nelse\r\n    \$cur_page = \$_REQUEST[\"cur_page\"];\r\n\r\n\$connection=OpenConnection();\r\n\r\n if(\$CUSTOMER_ID!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where CUSTOMER_ID='\".\$CUSTOMER_ID.\"'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and CUSTOMER_ID='\".\$CUSTOMER_ID.\"'\";\r\n  \r\n if(\$LINKMAN_NAME!";
echo "=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where LINKMAN_NAME like '%\".\$LINKMAN_NAME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and LINKMAN_NAME like '%\".\$LINKMAN_NAME.\"%'\";\r\n\t\t \r\n if(\$BIRTHDAY!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where BIRTHDAY like '%\".\$BIRTHDAY.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and BIRTHDAY like '%\".\$BIRTHDAY.\"%'\";\r\n\t\t \r\n if(\$POST_PRIV!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" ";
echo "where POST_PRIV like '%\".\$POST_PRIV.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and POST_PRIV like '%\".\$POST_PRIV.\"%'\";\r\n\r\n if(\$HOBBY!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where HOBBY like '%\".\$HOBBY.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and HOBBY like '%\".\$HOBBY.\"%'\";\r\n\r\n if(\$ADD_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where ADD_HOME like '%\".\$ADD_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and ADD_HOME ";
echo "like '%\".\$ADD_HOME.\"%'\";\r\n\t\t \r\n if(\$POSTALCODE_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where POSTALCODE_HOME like '%\".\$POSTALCODE_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and POSTALCODE_HOME like '%\".\$POSTALCODE_HOME.\"%'\";\r\n\t\t \r\n if(\$TEL_NO_WORK!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where TEL_NO_WORK like '%\".\$TEL_NO_WORK.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and TEL_NO_WORK like '%\".\$TEL_N";
echo "O_WORK.\"%'\";\r\n\t\t \r\n if(\$TEL_NO_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where TEL_NO_HOME like '%\".\$TEL_NO_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and TEL_NO_HOME like '%\".\$TEL_NO_HOME.\"%'\";\r\n\r\n if(\$MOBILE!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where MOBILE like '%\".\$MOBILE.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and MOBILE like '%\".\$MOBILE.\"%'\";\r\n\t\t \r\n if(\$EMAIL!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t";
echo " \$WHERE_STR.=\" where EMAIL like '%\".\$EMAIL.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and EMAIL like '%\".\$EMAIL.\"%'\";\r\n\t\t \r\n if(\$OICQ!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where OICQ like '%\".\$OICQ.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and OICQ like '%\".\$OICQ.\"%'\";\r\n\r\n if(\$ICQ!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where ICQ like '%\".\$ICQ.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and ICQ like '%\".\$ICQ.\"%'\";\r\n\r\n";
echo " if(\$WHERE_STR!=\"\")\r\n\t \$query=\"SELECT * from LINKMAN \".\$WHERE_STR.\" and CUSTOMER_ID=\".\$_REQUEST['CUSTOMER_ID2'];\r\n else\r\n\t \$query=\"SELECT * from LINKMAN where CUSTOMER_ID=\".\$_REQUEST['CUSTOMER_ID2'];\r\n\r\n\tswitch(\$_REQUEST['order']){\r\n\t\tcase 'linkman_name':\r\n\t\t\t\$query\t.= \" order by LINKMAN_NAME\";\r\n\t\t\tbreak;\r\n\t\tcase 'sex':\r\n\t\t\t\$query\t.= \" order by SEX\";\r\n\t\t\tbreak;\r\n\t\tcase 'birthday':\r\n\t\t\t\$query\t.= \" ";
echo "order by BIRTHDAY\";\r\n\t\t\tbreak;\r\n\t\tcase 'tel_no_work':\r\n\t\t\t\$query\t.= \" order by TEL_NO_WORK\";\r\n\t\t\tbreak;\r\n\t\tcase 'mobile':\r\n\t\t\t\$query\t.= \" order by MOBILE\";\r\n\t\t\tbreak;\r\n\t\tcase 'email':\r\n\t\t\t\$query\t.= \" order by EMAIL\";\r\n\t\t\tbreak;\r\n\t\tdefault:\r\n\t\t\t\$query\t.= \" order by LINKMAN_ID\";\r\n\t\t\tbreak;\r\n\t}\r\n\r\n\t\$query\t.= \$_REQUEST['sens']?' DESC':' ASC';\r\n\t\$query\t= page(\$query, 15);\r\n\t\$cursor\t= exequery(\$connecti";
echo "on, \$query);\r\n  while(\$ROW=mysql_fetch_array(\$cursor))\r\n  {\r\n    \$LINKMAN_ID\t\t= \$ROW[\"LINKMAN_ID\"];\r\n    \$CUSTOMER_ID1\t= \$ROW[\"CUSTOMER_ID\"];\r\n    \$LINKMAN_NAME1\t= \$ROW[\"LINKMAN_NAME\"];\r\n    \$SEX1\t\t\t= \$ROW[\"SEX\"];\r\n    \$BIRTHDAY1\t\t= \$ROW[\"BIRTHDAY\"];\r\n    \$POST_PRIV1\t\t= \$ROW[\"POST_PRIV\"];\r\n    \$HOBBY1\t\t\t= \$ROW[\"HOBBY\"];\r\n    \$ADD_HOME1\t\t= \$ROW[\"ADD_HOME\"];\r\n    \$POSTALCODE_HOME1\t= \$ROW[\"POSTALCODE";
echo "_HOME\"];\r\n    \$TEL_NO_WORK1\t= \$ROW[\"TEL_NO_WORK\"];\r\n    \$TEL_NO_HOME1\t= \$ROW[\"TEL_NO_HOME\"];\r\n    \$MOBILE1\t\t= \$ROW[\"MOBILE\"];\r\n    \$EMAIL1\t\t\t= \$ROW[\"EMAIL\"];\r\n    \$OICQ1\t\t\t= \$ROW[\"OICQ\"];\r\n    \$ICQ1\t\t\t= \$ROW[\"ICQ\"];\r\n\t\$mostly_linkman\t= \$ROW[\"MOSTLY_LINKMAN\"];\r\n\t\t\t\r\n\t\$query2\t\t= \"SELECT * from customer where CUSTOMER_ID=\$CUSTOMER_ID1\";\r\n\t\$cursor2\t= exequery(\$connection, \$query2);\r\n\tif(\$ROW2 = mysql_";
echo "fetch_array(\$cursor2))\r\n\t{\r\n\t\t\$old_customer_name\t= \$ROW2[\"CUSTOMER_NAME\"];\r\n\t\t\$manage_user\t= \$ROW2[\"MANAGE_USER\"];\r\n\t\t\$customer_id\t= \$ROW2[\"CUSTOMER_ID\"];\r\n\t\t\$manage_user\t= \$ROW2[\"MANAGE_USER\"];\r\n\t\t\$purview\t\t= \$ROW2[\"PURVIEW\"];\r\n\t\t\$purview_dept\t= \$ROW2[\"PURVIEW_DEPT\"];\r\n\t\t\$purview_role\t= \$ROW2[\"PURVIEW_ROLE\"];\r\n\t\t\$purview_user\t= \$ROW2[\"PURVIEW_USER\"];\r\n\t}\r\n\r\n\t//查询客户经理\r\n\t\$query3\t= \"select USE";
echo "R_ID from USER where USER_ID='\".\$manage_user.\"'\";\r\n\t\$cursor3= exequery(\$connection, \$query3);\r\n\tif(\$row3 = mysql_fetch_row(\$cursor3))\r\n\t\t\$user_id\t= \$row3[0];\r\n\r\n\tswitch(\$purview){\r\n\t\t//默认\r\n\t\tcase '1':\r\n\t\t\t\$purview_ses\t= default_validate();\r\n\t\t\tbreak;\r\n\t\t//公开\r\n\t\tcase '2':\r\n\t\t\t\$purview_ses\t= \"<a href=\\\"#\\\" onclick=\\\"customer_detail('\".\$customer_id.\"');\\\">\".\$customer_name.\"</a>\";\r\n\t\t\tbreak;\r\n\t\tcase";
echo " '3':\r\n\t\t\t\$dept_validate\t= dept_validate();\t//部门验证\r\n\t\t\t\$role_validate\t= role_validate();\t//角色验证\r\n\t\t\t\$user_validate\t= user_validate();\t//人员验证\r\n\r\n\t\t\tif((\$dept_validate || \$role_validate || \$user_validate) === false){\r\n\t\t\t\t\$purview_ses\t= default_validate();\r\n\t\t\t}else{\r\n\t\t\t\t\$purview_ses\t= \"<a href=\\\"#\\\" onclick=\\\"customer_detail('\".\$customer_id.\"');\\\">\".\$customer_name.\"</a>\";\r\n\t\t\t}\r\n\t\t\tbreak";
echo ";\r\n\t}\r\n\r\n\tif (\$manage_user == \$_SESSION['LOGIN_USER_ID']){\r\n\t\t\$purview_ses\t= \"<a href=\\\"#\\\" onclick=\\\"customer_detail('\".\$customer_id.\"');\\\">\".\$customer_name.\"</a>\";\r\n\t}\r\n\t//无权限查看则不显示记录\r\n\tif(\$purview_ses == false)\r\n\t\tcontinue;\r\n\r\n\t\$str_LINKMAN_ID\t.= \$LINKMAN_ID . ',';\r\n  }\r\n  \$str_LINKMAN_ID\t= substr(\$str_LINKMAN_ID, 0, -1);\r\n   \$str_LINKMAN_ID\t= \$str_LINKMAN_ID==\"\"?0:\$str_LINKMAN_ID;\r\n?>";
echo "\r\n\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 Language=\"JavaScript\">\r\nfunction linkman_detail(linkman_id)\r\n{\r\n\tURL=\"detail.php?linkman_id=\"+linkman_id;\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\twindow.open(URL,\"\",\"height=550,width=450,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction customer_detail(customer_id)\r\n{\r\n\tvar url\t= \"../../customer/detail.php?CUSTOMER_ID=\"+customer_i";
echo "d;\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\twindow.open(url,\"\",\"height=400,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=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  <tr class=\"tablehead1\">\r\n    <td>\r\n\t<img src=\"/images/notify_new.gif\" align=\"absmiddle\">联系";
echo "人查询结果 \r\n    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td>\r\n\t<BUTTON class=btn onClick=\"window.close();\" 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    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n";
echo "<?";
echo "\r\n//-----------先组织SQL语句-----------\r\n if(\$CUSTOMER_ID!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where CUSTOMER_ID='\".\$CUSTOMER_ID.\"'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and CUSTOMER_ID='\".\$CUSTOMER_ID.\"'\";\r\n  \r\n if(\$LINKMAN_NAME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where LINKMAN_NAME like '%\".\$LINKMAN_NAME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and LINKMAN_NAME like '%\".\$LINKMAN_NAME.\"%'\";\r\n\t\t \r\n ";
echo "if(\$BIRTHDAY!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where BIRTHDAY like '%\".\$BIRTHDAY.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and BIRTHDAY like '%\".\$BIRTHDAY.\"%'\";\r\n\t\t \r\n if(\$POST_PRIV!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where POST_PRIV like '%\".\$POST_PRIV.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and POST_PRIV like '%\".\$POST_PRIV.\"%'\";\r\n\r\n if(\$HOBBY!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where";
echo " HOBBY like '%\".\$HOBBY.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and HOBBY like '%\".\$HOBBY.\"%'\";\r\n\r\n if(\$ADD_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where ADD_HOME like '%\".\$ADD_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and ADD_HOME like '%\".\$ADD_HOME.\"%'\";\r\n\t\t \r\n if(\$POSTALCODE_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where POSTALCODE_HOME like '%\".\$POSTALCODE_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_ST";
echo "R.=\" and POSTALCODE_HOME like '%\".\$POSTALCODE_HOME.\"%'\";\r\n\t\t \r\n if(\$TEL_NO_WORK!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where TEL_NO_WORK like '%\".\$TEL_NO_WORK.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and TEL_NO_WORK like '%\".\$TEL_NO_WORK.\"%'\";\r\n\t\t \r\n if(\$TEL_NO_HOME!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where TEL_NO_HOME like '%\".\$TEL_NO_HOME.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and TEL_NO_HOME lik";
echo "e '%\".\$TEL_NO_HOME.\"%'\";\r\n\r\n if(\$MOBILE!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where MOBILE like '%\".\$MOBILE.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and MOBILE like '%\".\$MOBILE.\"%'\";\r\n\t\t \r\n if(\$EMAIL!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where EMAIL like '%\".\$EMAIL.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and EMAIL like '%\".\$EMAIL.\"%'\";\r\n\t\t \r\n if(\$OICQ!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" wher";
echo "e OICQ like '%\".\$OICQ.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and OICQ like '%\".\$OICQ.\"%'\";\r\n\r\n if(\$ICQ!=\"\")\r\n\t if(\$WHERE_STR==\"\")\r\n\t\t \$WHERE_STR.=\" where ICQ like '%\".\$ICQ.\"%'\";\r\n\t else\r\n\t\t \$WHERE_STR.=\" and ICQ like '%\".\$ICQ.\"%'\";\r\n\r\n if(\$WHERE_STR!=\"\")\r\n\t \$query=\"SELECT * from LINKMAN \".\$WHERE_STR.\" and LINKMAN_ID IN(\".\$str_LINKMAN_ID.\")\";\r\n else\r\n\t \$query=\"SELECT * from LINKMAN WHERE LINKMAN_ID IN(\".\$";
echo "str_LINKMAN_ID.\")\";\r\n\r\n\tswitch(\$_REQUEST['order']){\r\n\t\tcase 'linkman_name':\r\n\t\t\t\$query\t.= \" order by LINKMAN_NAME\";\r\n\t\t\tbreak;\r\n\t\tcase 'sex':\r\n\t\t\t\$query\t.= \" order by SEX\";\r\n\t\t\tbreak;\r\n\t\tcase 'birthday':\r\n\t\t\t\$query\t.= \" order by BIRTHDAY\";\r\n\t\t\tbreak;\r\n\t\tcase 'tel_no_work':\r\n\t\t\t\$query\t.= \" order by TEL_NO_WORK\";\r\n\t\t\tbreak;\r\n\t\tcase 'mobile':\r\n\t\t\t\$query\t.= \" order by MOBILE\";\r\n\t\t\tbreak;\r\n\t\tcase 'emai";
echo "l':\r\n\t\t\t\$query\t.= \" order by EMAIL\";\r\n\t\t\tbreak;\r\n\t\tdefault:\r\n\t\t\t\$query\t.= \" order by LINKMAN_ID\";\r\n\t\t\tbreak;\r\n\t}\r\n\r\n\t\$query\t.= \$_REQUEST['sens']?' DESC':' ASC';\r\n\t\$query\t= page(\$query, 15);\r\n\t\$cursor\t= exequery(\$connection, \$query);\r\n\r\n\t\$sens\t= \$_REQUEST['sens']?0:1;\r\n\t\$sensimg= \$_REQUEST['sens']?'arrow_up.gif':'arrow_down.gif';\r\n\t\$sensimg= '/images/'.\$sensimg;\r\n\t\$sufurl\t= \$_SERVER['PHP_SELF'].\"?s";
echo "ens=\".\$sens;\r\n?>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n  <tr class=\"TableHeader\">\r\n\t  <td width=\"3%\" align=\"center\" style=\"color:#FF0000;\" title=\"联系人状态\">!</td>\r\n      <td nowrap=\"nowrap\"><a href=\"";
echo "<?=";
echo "\$sufurl?>&order=linkman_name&cur_page=";
echo "<?=";
echo "\$cur_page?>&CUSTOMER_ID2=";
echo "<?=";
echo "\$CUSTOMER_ID2?>\">姓名";
echo "<?";
echo " if(\$_REQUEST['order'] == 'linkman_name') echo \"<img src='\".\$sensimg.\"' border='0'>\";?></a></td>\r\n      <td nowrap=\"nowrap\"><a href=\"";
echo "<?=";
echo "\$sufurl?>&order=sex&cur_page=";
echo "<?=";
echo "\$cur_page?>&CUSTOMER_ID2=";
echo "<?=";
echo "\$CUSTOMER_ID2?>\">性别";
echo "<?";
echo " if(\$_REQUEST['order'] == 'sex') echo \"<img src='\".\$sensimg.\"' border='0'>\";?></a></td>\r\n      <td><a href=\"";
echo "<?=";
echo "\$sufurl?>&order=birthday&cur_page=";
echo "<?=";
echo "\$cur_page?>&CUSTOMER_ID2=";
echo "<?=";
echo "\$CUSTOMER_ID2?>\">生日";
echo "<?";
echo " if(\$_REQUEST['order'] == 'birthday') echo \"<img src='\".\$sensimg.\"' border='0'>\";?></a></td>\r\n      <td>所属客户</td>\r\n      <td nowrap=\"nowrap\"><a href=\"";
echo "<?=";
echo "\$sufurl?>&order=tel_no_work&cur_page=";
echo "<?=";
echo "\$cur_page?>&CUSTOMER_ID2=";
echo "<?=";
echo "\$CUSTOMER_ID2?>\">工作电话";
echo "<?";
echo " if(\$_REQUEST['order'] == 'tel_no_work') echo \"<img src='\".\$sensimg.\"' border='0'>\";?></a></td>\r\n      <td nowrap=\"nowrap\"><a href=\"";
echo "<?=";
echo "\$sufurl?>&order=mobile&cur_page=";
echo "<?=";