📄 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" );
ob_start( );
setcookie( "ILOOK_AREA", $AREA, time( ) + 86400000 );
echo "<html>\r\n<head>\r\n<title></title>\r\n<script>\r\nfunction open_news(USER_ID)\r\n{\r\n URL=\"/general/ipanel/user_info.php?USER_ID=\"+USER_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"user\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction open_email(EMAIL_ID,BOX_ID)\r\n{\r\n URL=\"/general/email/inbox/read_email/read_email.php?BOX_ID=\"+BOX_ID + \"&EMAIL_ID=\"+EMAIL_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"email\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction open_notify(NOTIFY_ID)\r\n{\r\n URL=\"/general/notify/show/read_notify.php?NOTIFY_ID=\"+NOTIFY_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"open_notify\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction open_address(ADD_ID)\r\n{\r\n URL=\"/general/address/private/address/add_detail.php?ADD_ID=\"+ADD_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"open_notify\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction open_file(CONTENT_ID,SORT_ID)\r\n{\r\n URL=\"/general/file_folder/read.php?CONTENT_ID=\" + CONTENT_ID + \"&SORT_ID=\" + SORT_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"open_file\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction form_view(RUN_ID,FLOW_ID)\r\n{\r\n myleft=(screen.availWidth-800)/2;\r\n window.open(\"/general/workflow/list/print?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID + \"&SEARCH_CENTER_FLAG=\" + 1,\"\",\"status=0,toolbar=no,menubar=no,width=800,height=600,location=no,scrollbars=yes,resizable=yes,left=\"+myleft+\",top=50\");\r\n}\r\n\r\nfunction open_customer(CUSTOMER_ID)\r\n{\r\n URL=\"/general/sale_manage/crm/query/customer/showdetail.php?CUSTOMER_ID=\" + CUSTOMER_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"open_customer\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction open_online(ONLINE_ID)\r\n{\r\n URL=\"/general/training/train/problem/read.php?ONLINE_ID=\" + ONLINE_ID + \"&SEARCH_CENTER_FLAG=\" + 1;\r\n myleft=(screen.availWidth-650)/2;\r\n mytop=100\r\n mywidth=650;\r\n myheight=500;\r\n window.open(URL,\"open_online\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n</head>\r\n<body topmargin='0'>\r\n<br>\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $AREA == "undefined" )
{
$AREA = 1;
}
$KWORD = trim( $KWORD );
if ( $KWORD == "" )
{
$WHERE_EMPTY = " and 1=2 ";
}
else
{
$KWORD = str_replace( "<", "<", $KWORD );
$KWORD = str_replace( ">", ">", $KWORD );
}
$SHOW_COUNT = 15;
switch ( $AREA )
{
case 1 :
$query = "SELECT PRIV_NO from USER_PRIV where USER_PRIV=".$LOGIN_USER_PRIV;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRIV_NO = $ROW['PRIV_NO'];
}
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "SELECT SEX,USER_ID,USER_NAME,DEPT_ID,BIRTHDAY,USER.USER_PRIV,PRIV_NAME,TEL_NO_DEPT,EMAIL,OICQ_NO from USER,USER_PRIV where USER.USER_NAME like '%".$KWORD."%' and USER.USER_PRIV=USER_PRIV.USER_PRIV and USER_PRIV.PRIV_NO>{$PRIV_NO} and USER_PRIV.USER_PRIV!=1 ".$WHERE_EMPTY.( "order by PRIV_NO,USER_NO,USER_NAME limit 0,".$SHOW_COUNT );
}
else
{
$query = "SELECT SEX,USER_ID,USER_NAME,DEPT_ID,BIRTHDAY,USER.USER_PRIV,PRIV_NAME,TEL_NO_DEPT,EMAIL,OICQ_NO from USER,USER_PRIV where USER.USER_NAME like '%".$KWORD."%' and USER.USER_PRIV=USER_PRIV.USER_PRIV ".$WHERE_EMPTY.( " order by PRIV_NO,USER_NO,USER_NAME limit 0,".$SHOW_COUNT );
}
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$USER_COUNT;
$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'];
$EMAIL = $ROW['EMAIL'];
$OICQ_NO = $ROW['OICQ_NO'];
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 ( $EMAIL != "" )
{
$SHOW_STR .= "，电子邮件：".$EMAIL;
}
if ( $OICQ_NO != "" )
{
$SHOW_STR .= "，QQ：".$OICQ_NO;
}
echo "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_news('".$USER_ID.( "');\"><u>".$USER_NAME."</u></a> <br>" ).$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $USER_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 2 :
$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') ".$WHERE_EMPTY.( "order by SEND_TIME desc limit 0,".$SHOW_COUNT );
$cursor = exequery( $connection, $query );
$EMAIL_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$EMAIL_COUNT;
$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 "<table border='0' cellpadding='0' cellspacing='0' width='100%' class='small'>\r\n\t <tr>\r\n\t <td><a href=\"javascript:open_email('".$EMAIL_ID."','{$BOX_ID}');\"><u>邮件主题：{$SUBJECT}</u></a> <br>".$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $EMAIL_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 3 :
$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}%' ".$WHERE_EMPTY.( "order by BEGIN_DATE desc limit 0,".$SHOW_COUNT );
$cursor = exequery( $connection, $query );
$NOTIFY_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$NOTIFY_COUNT;
$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'];
$TO_ID = $ROW['TO_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$USER_ID = $ROW['USER_ID'];
$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'];
$AVATAR = $ROW['AVATAR'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
else
{
$FROM_NAME = $FROM_ID;
$AVATAR = "";
$DEPT_NAME = "用户已删除";
}
$TO_NAME = "";
if ( $TO_ID == "ALL_DEPT" )
{
$TO_NAME = "全体部门";
}
else
{
$TO_NAME = "";
$query1 = "select DEPT_NAME from DEPARTMENT where find_in_set(DEPT_ID,'".$TO_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TO_NAME .= $ROW['DEPT_NAME']."，";
}
}
$PRIV_NAME = "";
$query1 = "SELECT PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'".$PRIV_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRIV_NAME .= $ROW['PRIV_NAME']."，";
}
$USER_NAME = "";
$query1 = "SELECT USER_NAME from USER where find_in_set(USER_ID,'".$USER_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME .= $ROW['USER_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 ( $TO_NAME != "" )
{
$SHOW_STR .= "，发布范围（部门）：".$TO_NAME;
}
if ( $PRIV_NAME != "" )
{
$SHOW_STR .= "，发布范围（角色）：".$PRIV_NAME;
}
if ( $USER_NAME != "" )
{
$SHOW_STR .= "，发布范围（人员）：".$USER_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_notify('".$NOTIFY_ID."');\"><u>{$SUBJECT}</u></a> <br>".$SHOW_STR."<br></td>\r\n\t </tr>\r\n\t </table><br>";
}
if ( $NOTIFY_COUNT == 0 && $KWORD != "" )
{
echo "抱歉，没有找到与“".$KWORD."” 相关的内容";
}
if ( !( $KWORD == "" ) )
{
break;
}
echo "请输入查询条件";
break;
case 4 :
$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."%'".$WHERE_EMPTY;
$cursor = exequery( $connection, $query );
$ADD_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$GROUP_ID = $ROW['GROUP_ID'];
$USER_ID = $ROW['USER_ID'];
if ( $USER_ID != "" )
{
if ( $USER_ID != $LOGIN_USER_ID )
{
break;
}
}
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 ) )
{
$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 ) )
{
}
}
}
++$ADD_COUNT;
if ( $SHOW_COUNT < $USER_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" )
{
$SEX = "男";
}
else if ( $SEX == "1" )
{
$SEX = "女";
}
else
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -