📄 search.php
字号:
$SEX = "";
}
$SHOW_STR = "";
if ( $SEX != "" )
{
$SHOW_STR = "性别：".$SEX;
}
if ( $NICK_NAME != "" )
{
$SHOW_STR .= "，昵称：".$NICK_NAME;
}
if ( $DEPT_NAME != "" )
{
$SHOW_STR .= "，单位名称：".$DEPT_NAME;
}
if ( $TEL_NO_DEPT != "" )
{
$SHOW_STR .= "，单位电话：".$TEL_NO_DEPT;
}
if ( $TEL_NO_HOME != "" )
{
$SHOW_STR .= "，家庭电话：".$TEL_NO_HOME;
}
if ( $MOBIL_NO != "" )
{
$SHOW_STR .= "，手机：".$MOBIL_NO;
}
if ( $EMAIL != "" )
{
$SHOW_STR .= "，电子邮件：".$EMAIL;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_address('".$ADD_ID.( "');\"><u>".$PSN_NAME."</u></a> <br>" ).$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $ADD_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 5 :
$query = "SELECT SORT_ID,CONTENT_ID,SUBJECT,USER_ID,CONTENT,SEND_TIME,ATTACHMENT_NAME from FILE_CONTENT where (SUBJECT like '%".$KWORD."%') ".$WHERE_EMPTY."order by SEND_TIME desc";
$cursor = exequery( $connection, $query );
$FILE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$CONTENT_ID = $ROW['CONTENT_ID'];
$SUBJECT = $ROW['SUBJECT'];
$USER_ID1 = $ROW['USER_ID'];
$CONTENT = $ROW['CONTENT'];
$SEND_TIME = $ROW['SEND_TIME'];
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 300 );
$ATTACHMENT_NAME = str_replace( "*", "，", $ROW['ATTACHMENT_NAME'] );
if ( $USER_ID1 != "" )
{
if ( $USER_ID1 != $LOGIN_USER_ID )
{
break;
}
}
else
{
$query1 = "SELECT SORT_NAME,USER_ID,SORT_PARENT,SHARE_USER from FILE_SORT where SORT_ID='".$SORT_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$SORT_NAME = $ROW1['SORT_NAME'];
$USER_ID = $ROW1['USER_ID'];
$SORT_PARENT = $ROW1['SORT_PARENT'];
$SHARE_USER = $ROW1['SHARE_USER'];
$SHARE_USER1 = share_user_str( $SORT_PARENT ).$SHARE_USER;
if ( $SHARE_USER1 != "" )
{
if ( $SHARE_USER1 != "" )
{
break;
}
}
else
{
$ACCESS_PRIV = explode( "|", $USER_ID );
if ( $ACCESS_PRIV[0] != "ALL_DEPT" && !find_id( $ACCESS_PRIV[0], $LOGIN_DEPT_ID ) || !find_id( $ACCESS_PRIV[1], $LOGIN_USER_PRIV ) || !find_id( $ACCESS_PRIV[2], $LOGIN_USER_ID ) )
{
}
}
}
}
++$FILE_COUNT;
if ( $SHOW_COUNT < $FILE_COUNT )
{
break;
}
$SHOW_STR = "";
if ( $SEND_TIME != "" )
{
$SHOW_STR = "发布时间：".$SEND_TIME;
}
if ( $ATTACHMENT_NAME != "" )
{
$SHOW_STR .= "，附件：".$ATTACHMENT_NAME;
}
if ( $CONTENT != "" )
{
$SHOW_STR .= "，文件内容：".$CONTENT;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_file('".$CONTENT_ID."','".$SORT_ID.( "');\"><u>".$SUBJECT."</u></a> <br>" ).$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $FILE_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 6 :
$query = "SELECT FLOW_RUN.RUN_ID,FLOW_RUN.RUN_NAME,FLOW_TYPE.FLOW_ID,FLOW_RUN_PRCS.PRCS_TIME,FLOW_TYPE.FLOW_NAME,\r\n FLOW_TYPE.FLOW_TYPE,FLOW_TYPE.MANAGE_USER,FLOW_TYPE.QUERY_USER from FLOW_TYPE,FLOW_RUN,FLOW_RUN_PRCS \r\n WHERE (FLOW_RUN.RUN_ID='".$KWORD."' or FLOW_RUN.RUN_NAME like '%{$KWORD}%') and FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID".$WHERE_EMPTY;
if ( $LOGIN_USER_PRIV != 1 )
{
$query_my = $query.( " and FLOW_RUN_PRCS.USER_ID='".$LOGIN_USER_ID."'" );
$cursor = exequery( $connection, $query_my );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$MY_RUN_ID .= $ROW['RUN_ID'].",";
}
if ( $MY_RUN_ID != "" )
{
$MY_RUN_ID = substr( $MY_RUN_ID, 0, -1 );
}
else
{
$MY_RUN_ID = "0";
}
$query .= " and (FLOW_RUN.RUN_ID in ('".$MY_RUN_ID."') or FLOW_TYPE.MANAGE_USER like '%,{$LOGIN_USER_ID},%' or FLOW_TYPE.MANAGE_USER like '{$LOGIN_USER_ID},%' or FLOW_TYPE.QUERY_USER like '%,{$LOGIN_USER_ID},%' or FLOW_TYPE.QUERY_USER like '{$LOGIN_USER_ID},%')";
}
$query .= " and FLOW_RUN_PRCS.PRCS_ID=1 order by FLOW_RUN.RUN_ID desc limit 0,".$SHOW_COUNT;
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$FLOW_COUNT;
$RUN_ID = $ROW['RUN_ID'];
$RUN_NAME = $ROW['RUN_NAME'];
$PRCS_TIME = $ROW['PRCS_TIME'];
$FLOW_ID = $ROW['FLOW_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$MANAGE_USER = $ROW['MANAGE_USER'];
$QUERY_USER = $ROW['QUERY_USER'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$CONTENT = csubstr( strip_tags( $ROW['CONTENT'] ), 0, 300 );
$ATTACHMENT_NAME = str_replace( "*", "，", $ROW['ATTACHMENT_NAME'] );
$SHOW_STR = "";
if ( $RUN_ID != "" )
{
$SHOW_STR = "流水号：".$RUN_ID;
}
if ( $PRCS_TIME != "" )
{
$SHOW_STR .= "，开始时间：".$PRCS_TIME;
}
if ( $ATTACHMENT_NAME != "" )
{
$SHOW_STR .= "，公共附件：".$ATTACHMENT_NAME;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:form_view('".$RUN_ID."','".$FLOW_ID.( "');\"><u>".$RUN_NAME."</u></a> <br>" ).$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $FLOW_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 7 :
$query = "select MANAGER_ID,MANAGERS 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'];
}
$WHERE_STR = " where (SELLER='".$LOGIN_USER_ID."'";
$WHERE_STR .= " or ((find_in_set( '".$LOGIN_USER_ID."',SHAREUSER) and SHARE='1') or (SHAREUSER='' and SELLER!='{$LOGIN_USER_ID}' and SHARE='1'))";
if ( find_id( $MANAGERS, $LOGIN_USER_ID ) )
{
$query1 = "select DEPT_ID from DEPARTMENT";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
if ( is_dept_priv( $DEPT_ID ) == 1 )
{
$TO_ID = $TO_ID.$DEPT_ID.",";
}
}
$TO_ID = "'".str_replace( ",", "','", substr( $TO_ID, 0, -1 ) )."'";
$WHERE_STR .= " or d.DEPT_ID in (".$TO_ID.") and SELLER!='{$LOGIN_USER_ID}' ";
}
$WHERE_STR .= ") and (CUSTOMER_NAME like '%".$KWORD."%')";
$query = "SELECT CUSTOMER_ID,CUSTOMER_NAME,TEL_NO,FAX_NO, SELLER,a.EMAIL as EMAIL,b.CODE_NAME as SELLMODE, c.CODE_NAME as KIND,d.USER_NAME as SELLER,d.USER_ID as SELLERID,e.CODE_NAME as CUSTOMER_AREA,a.CREATDATE as CREATDATE from CUSTOMER a\r\n LEFT OUTER JOIN SYS_CODE b\r\n ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE c\r\n ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID \r\n ".$WHERE_STR.$WHERE_EMPTY.( " order by CREATDATE desc limit 0,".$SHOW_COUNT );
$cursor = exequery( $connection, $query );
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$CUSTOMER_COUNT;
$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
$CUSTOMER_AREA = $ROW['CUSTOMER_AREA'];
$CUSTOMER_NAME = strip_tags( $ROW['CUSTOMER_NAME'] );
$TEL_NO = $ROW['TEL_NO'];
$FAX_NO = $ROW['FAX_NO'];
$SELLER = $ROW['SELLER'];
$SELLMODE = $ROW['SELLMODE'];
$KIND = $ROW['KIND'];
$EMAIL = $ROW['EMAIL'];
$SELLER = $ROW['SELLER'];
$CREATOR = $ROW['CREATOR'];
$CREATDATE = $ROW['CREATDATE'];
$CREATORID = $ROW['CREATORID'];
$CONTENT = csubstr( strip_tags( $ROW['CONTENT'] ), 0, 300 );
$SHOW_STR = "";
if ( $KIND != "" )
{
$SHOW_STR = "客户类别：".$KIND;
}
if ( $CUSTOMER_AREA != "" )
{
$SHOW_STR .= "，地区：".$CUSTOMER_AREA;
}
if ( $SELLMODE != "" )
{
$SHOW_STR .= "，销售方式：".$SELLMODE;
}
if ( $TEL_NO != "" )
{
$SHOW_STR .= "，电话：".$TEL_NO;
}
if ( $SELLER != "" )
{
$SHOW_STR .= "，销售员：".$SELLER;
}
if ( $CREATOR != "" )
{
$SHOW_STR .= "，记录人：".$CREATOR;
}
if ( $CREATDATE != "" )
{
$SHOW_STR .= "，记录日期：".$CREATDATE;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_customer('".$CUSTOMER_ID."');\"><u>客户名称：{$CUSTOMER_NAME}</u></a> <br>".$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $CUSTOMER_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 8 :
$WHERE_STR .= " and PROBLEM like '%".$KWORD."%'";
$query = "SELECT TRAIN_ONLINE.*,TRAIN_COURSES.COURSE_NAME from TRAIN_ONLINE left join TRAIN_COURSES on TRAIN_COURSE=COURSE_ID WHERE PROBLEM_USER='".$LOGIN_USER_ID."' ".$WHERE_STR.$WHERE_EMPTY.( " order by PROBLEM_DATE desc limit 0,".$SHOW_COUNT );
$cursor = exequery( $connection, $query );
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$CUSTOMER_COUNT;
$ONLINE_ID = $ROW['ONLINE_ID'];
$TRAIN_COURSE = $ROW['COURSE_NAME'];
$PROBLEM = strip_tags( $ROW['PROBLEM'] );
$ANSWER_USER = $ROW['ANSWER_USER'];
$PROBLEM_DATE = $ROW['PROBLEM_DATE'];
$ANSWER_DATE = $ROW['ANSWER_DATE'];
$query1 = "SELECT USER_NAME from USER WHERE USER_ID='".$ANSWER_USER."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$ANSWER_USER = $ROW['USER_NAME'];
}
if ( $ANSWER_USER == "" )
{
$ANSWER_USER = "-";
$ANSWER_DATE = "-";
}
$SHOW_STR = "";
if ( $TRAIN_COURSE != "" )
{
$SHOW_STR = "咨询课程：".$TRAIN_COURSE;
}
if ( $PROBLEM_DATE != "" )
{
$SHOW_STR .= "，咨询日期：".$PROBLEM_DATE;
}
if ( $ANSWER_USER != "" )
{
$SHOW_STR .= "，解答者：".$ANSWER_USER;
}
if ( $ANSWER_DATE != "" )
{
$SHOW_STR .= "，解答日期：".$ANSWER_DATE;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_online('".$ONLINE_ID."');\"><u>问题：{$PROBLEM}</u></a> <br>".$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $CUSTOMER_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
}
echo "\r\n</body>\r\n<html>\r\n\t\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -