📄 search.php
字号:
{
$SEX = "男";
}
else if ( $SEX == "1" )
{
$SEX = "女";
}
else
{
$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 "<div class=\"module\"><a href=\"javascript:open_address('".$ADD_ID."','".$FLAG.( "');\" class=\"header\"><u>".$PSN_NAME."</u></a><div class=\"module_body\">" ).$SHOW_STR."</div></div>\n";
} while ( 1 );
case 5 :
do
{
$query = "SELECT SORT_ID,CONTENT_ID,SUBJECT,USER_ID,CONTENT,SEND_TIME,ATTACHMENT_NAME from FILE_CONTENT where (SUBJECT like '%".$KWORD."%') order by SEND_TIME desc";
$cursor = exequery( $connection, $query );
$SEARCH_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 ( !find_id( $USER_FUNC_ID_STR, 16 ) )
{
}
else
{
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 ) ) )
{
break;
}
$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 ( !find_id( $USER_FUNC_ID_STR, 16 ) )
{
}
else
{
if ( find_id( $SHARE_USER1, $LOGIN_USER_ID ) )
{
break;
}
}
}
else if ( !find_id( $USER_FUNC_ID_STR, 15 ) )
{
}
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 ) )
{
break;
}
}
}
}
++$SEARCH_COUNT;
if ( $SHOW_COUNT < $SEARCH_COUNT )
{
break;
}
$SHOW_STR = "";
if ( $SEND_TIME != "" )
{
$SHOW_STR = "发布时间：".$SEND_TIME;
}
if ( $ATTACHMENT_NAME != "" )
{
$SHOW_STR .= "，附件：".$ATTACHMENT_NAME;
}
if ( $CONTENT != "" )
{
$SHOW_STR .= "，文件内容：".$CONTENT;
}
echo "<div class=\"module\"><a href=\"javascript:open_file('".$CONTENT_ID."','".$SORT_ID.( "');\" class=\"header\"><u>".$SUBJECT."</u></a><div class=\"module_body\">" ).$SHOW_STR."</div></div>\n";
} while ( 1 );
case 6 :
do
{
$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";
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 ".$START.",".( $SHOW_COUNT + 1 );
$cursor = exequery( $connection, $query );
$SEARCH_COUNT = 0;
if ( !( $ROW = mysql_fetch_array( $cursor ) ) )
{
break;
}
++$SEARCH_COUNT;
if ( $SHOW_COUNT < $SEARCH_COUNT )
{
break;
}
$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 "<div class=\"module\"><a href=\"javascript:form_view('".$RUN_ID."','".$FLOW_ID.( "');\" class=\"header\"><u>".$RUN_NAME."</u></a><div class=\"module_body\">" ).$SHOW_STR."</div></div>\n";
} while ( 1 );
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."' or CREATOR='{$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,f.USER_NAME as CREATOR,a.CREATOR as CREATORID 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 LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID".$WHERE_STR.( " order by CREATDATE desc limit ".$START."," ).( $SHOW_COUNT + 1 );
$cursor = exequery( $connection, $query );
$SEARCH_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$SEARCH_COUNT;
if ( $SHOW_COUNT < $SEARCH_COUNT )
{
break;
}
$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 "<div class=\"module\"><a href=\"javascript:open_customer('".$CUSTOMER_ID."');\" class=\"header\"><u>客户名称：{$CUSTOMER_NAME}</u></a><div class=\"module_body\">".$SHOW_STR."</div></div>\n";
}
}
if ( $SEARCH_COUNT == 0 )
{
echo "<div class=small>没有找到与“".htmlspecialchars( $KWORD )."” 相关的内容</div>";
}
else
{
echo "<div align=\"center\">";
if ( 0 < $START )
{
echo "<a href=\"javascript:ilook('".$KWORD."','".( $START - $SHOW_COUNT )."');\" class=\"page\"><上一页</a> ";
}
if ( $SHOW_COUNT < $SEARCH_COUNT )
{
echo "<a href=\"javascript:ilook('".$KWORD."','".( $START + $SHOW_COUNT )."');\" class=\"page\">下一页></a>";
}
echo "</div>";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -