📄 search.php
字号:
<?php
function share_user_str( $SORT_ID )
{
global $connection;
$query2 = "SELECT SHARE_USER,SORT_PARENT from FILE_SORT where SORT_ID='".$SORT_ID."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
$SHARE_USER = $ROW2['SHARE_USER'];
$SORT_PARENT = $ROW2['SORT_PARENT'];
if ( $SORT_PARENT == 0 )
{
return $SHARE_USER;
}
return $SHARE_USER .= share_user_str( $SORT_PARENT );
}
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
ob_end_clean( );
if ( $AREA == "undefined" || $AREA == "" )
{
$AREA = 1;
}
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$KWORD = trim( urldecode( $KWORD ) );
if ( $KWORD == "" )
{
echo "<div class=small>请输入搜索关键词</div>";
exit( );
}
$START = intval( $START ) < 0 ? 0 : intval( $START );
$SHOW_COUNT = 10;
switch ( $AREA )
{
case 1 :
do
{
$query = "SELECT NOT_VIEW_USER from USER where UID='".$LOGIN_UID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$NOT_VIEW_USER = $ROW['NOT_VIEW_USER'];
if ( $NOT_VIEW_USER == "1" )
{
break;
break;
}
}
else
{
$query = "SELECT SEX,USER_ID,USER_NAME,DEPT_ID,BIRTHDAY,USER.USER_PRIV,PRIV_NAME,TEL_NO_DEPT,TEL_NO_HOME,EMAIL,OICQ_NO,MOBIL_NO,MOBIL_NO_HIDDEN,REMARK from USER,USER_PRIV where DEPT_ID!=0 and (USER.USER_ID like '%".$KWORD."%' or USER.BYNAME like '%{$KWORD}%' or USER.USER_NAME like '%{$KWORD}%' or (MOBIL_NO like '%{$KWORD}%' and MOBIL_NO_HIDDEN='0') or TEL_NO_DEPT like '%{$KWORD}%' or TEL_NO_HOME like '%{$KWORD}%' or REMARK like '%{$KWORD}%') and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME 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;
}
$SEX = $ROW['SEX'];
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$BIRTHDAY = $ROW['BIRTHDAY'];
$USER_PRIV = $ROW['USER_PRIV'];
$PRIV_NAME = $ROW['PRIV_NAME'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$TEL_NO_HOME = $ROW['TEL_NO_HOME'];
$EMAIL = $ROW['EMAIL'];
$OICQ_NO = $ROW['OICQ_NO'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
$REMARK = $ROW['REMARK'];
if ( $SEX == 0 )
{
$SEX_DESC = "男";
}
else
{
$SEX_DESC = "女";
}
if ( $BIRTHDAY == "0000-00-00 00:00:00" )
{
$BIRTHDAY = "";
}
else
{
$BIRTHDAY = format_date( $BIRTHDAY, 0, 10 );
}
$DEPT_NAME = str_replace( "/", " - ", dept_long_name( $DEPT_ID ) );
$SHOW_STR = "";
if ( $SEX_DESC != "" )
{
$SHOW_STR = $SEX_DESC;
}
if ( $BIRTHDAY != "" )
{
$SHOW_STR .= "，生日：".$BIRTHDAY;
}
if ( $DEPT_NAME != "" )
{
$SHOW_STR .= "，所在部门：".$DEPT_NAME;
}
if ( $PRIV_NAME != "" )
{
$SHOW_STR .= "，角色：".$PRIV_NAME;
}
if ( $TEL_NO_DEPT != "" )
{
$SHOW_STR .= "，单位电话：".$TEL_NO_DEPT;
}
if ( $TEL_NO_HOME != "" )
{
$SHOW_STR .= "，家庭电话：".$TEL_NO_HOME;
}
if ( $EMAIL != "" )
{
$SHOW_STR .= "，电子邮件：".$EMAIL;
}
if ( $OICQ_NO != "" )
{
$SHOW_STR .= "，QQ：".$OICQ_NO;
}
if ( $MOBIL_NO_HIDDEN == "0" && $MOBIL_NO != "" )
{
$SHOW_STR .= "，手机：".$MOBIL_NO;
}
if ( $REMARK != "" )
{
$SHOW_STR .= "，备注：".$REMARK;
}
}
echo "<div class=\"module\"><a href=\"javascript:open_user('".$USER_ID.( "');\" class=\"header\"><u>".$USER_NAME."</u></a><div class=\"module_body\">" ).$SHOW_STR."</div></div>\n";
} while ( 1 );
case 2 :
do
{
$query = "SELECT EMAIL_BODY.SUBJECT,EMAIL.EMAIL_ID,EMAIL.BOX_ID,EMAIL_BODY.SEND_TIME,EMAIL_BODY.CONTENT from EMAIL,EMAIL_BODY where (SUBJECT like '%".$KWORD."%' or CONTENT like '%{$KWORD}%') and EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='{$LOGIN_USER_ID}' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2') order by SEND_TIME 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;
}
$SUBJECT = $ROW['SUBJECT'];
$EMAIL_ID = $ROW['EMAIL_ID'];
$BOX_ID = $ROW['BOX_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$CONTENT = csubstr( strip_tags( $ROW['CONTENT'] ), 0, 300 );
$SHOW_STR = "";
if ( $CONTENT != "" )
{
$SHOW_STR = $CONTENT;
}
if ( $SEND_TIME != "" )
{
$SHOW_STR .= "<br>邮件日期：".$SEND_TIME;
}
echo "<div class=\"module\"><a href=\"javascript:open_email('".$EMAIL_ID."','{$BOX_ID}');\" class=\"header\"><u>邮件主题：{$SUBJECT}</u></a><div class=\"module_body\">".$SHOW_STR."</div></div>\n";
} while ( 1 );
case 3 :
do
{
$query = "SELECT NOTIFY_ID,SUBJECT,CONTENT,FROM_ID,TYPE_ID,BEGIN_DATE,TO_ID,PRIV_ID,USER_ID from NOTIFY where (TO_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',TO_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) and BEGIN_DATE<='{$CUR_DATE}' and (END_DATE>='{$CUR_DATE}' or END_DATE='0000-00-00' or END_DATE is null) and PUBLISH='1' and SUBJECT like '%{$KWORD}%' order by BEGIN_DATE 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;
}
$NOTIFY_ID = $ROW['NOTIFY_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$FROM_ID = $ROW['FROM_ID'];
$TYPE_ID = $ROW['TYPE_ID'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$BEGIN_DATE = strtok( $BEGIN_DATE, " " );
$query1 = "SELECT USER_NAME,AVATAR,DEPT_ID from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
$FROM_NAME = "";
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
}
else
{
$FROM_NAME = "用户已删除";
}
$TYPE_NAME = get_code_name( $TYPE_ID, "NOTIFY" );
$CONTENT = csubstr( strip_tags( $CONTENT ), 0, 300 );
$SHOW_STR = "";
if ( $FROM_NAME != "" )
{
$SHOW_STR = "发布人：".$FROM_NAME;
}
if ( $TYPE_NAME != "" )
{
$SHOW_STR .= "，类型：".$TYPE_NAME;
}
if ( $BEGIN_DATE != "" )
{
$SHOW_STR .= "，发布时间：".$BEGIN_DATE;
}
if ( $CONTENT != "" )
{
$SHOW_STR .= "，内容：".$CONTENT;
}
echo "<div class=\"module\"><a href=\"javascript:open_notify('".$NOTIFY_ID."');\" class=\"header\"><u>{$SUBJECT}</u></a><div class=\"module_body\">".$SHOW_STR."</div></div>\n";
} while ( 1 );
case 4 :
do
{
$query = "SELECT GROUP_ID,USER_ID,ADD_ID,PSN_NAME,SEX,TEL_NO_DEPT,DEPT_NAME,TEL_NO_HOME,MOBIL_NO,EMAIL,NICK_NAME from ADDRESS where PSN_NAME like '%".$KWORD."%'";
$cursor = exequery( $connection, $query );
$SEARCH_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
do
{
$GROUP_ID = $ROW['GROUP_ID'];
$USER_ID = $ROW['USER_ID'];
if ( $USER_ID != "" )
{
if ( !find_id( $USER_FUNC_ID_STR, 10 ) )
{
}
else if ( !( $USER_ID != $LOGIN_USER_ID ) )
{
$FLAG = 1;
break;
}
}
else if ( !find_id( $USER_FUNC_ID_STR, 106 ) )
{
}
else
{
$query1 = "SELECT PRIV_DEPT,PRIV_ROLE,PRIV_USER from ADDRESS_GROUP where GROUP_ID = '".$GROUP_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( !( $ROW1 = mysql_fetch_array( $cursor1 ) ) )
{
break;
}
$PRIV_DEPT = $ROW1['PRIV_DEPT'];
$PRIV_ROLE = $ROW1['PRIV_ROLE'];
$PRIV_USER = $ROW1['PRIV_USER'];
if ( !( $PRIV_DEPT != "ALL_DEPT" ) && find_id( $PRIV_DEPT, $LOGIN_DEPT_ID ) || find_id( $PRIV_ROLL, $LOGIN_USER_PRIV ) || find_id( $PRIV_USER, $LOGIN_USER_ID ) )
{
break;
}
}
}
$FLAG = 0;
} while ( 0 );
++$SEARCH_COUNT;
if ( $SHOW_COUNT < $SEARCH_COUNT )
{
break;
}
$ADD_ID = $ROW['ADD_ID'];
$PSN_NAME = $ROW['PSN_NAME'];
$SEX = $ROW['SEX'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$TEL_NO_HOME = $ROW['TEL_NO_HOME'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$EMAIL = $ROW['EMAIL'];
$NICK_NAME = $ROW['NICK_NAME'];
if ( $MOBIL_NO != "" )
{
$MOBIL_NO_STR .= $MOBIL_NO.",";
}
if ( $SEX == "0" )
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -