search.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 810 行 · 第 1/2 页

PHP
810 行
字号
12
<?
  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;
      }
      else
      {
        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>
<head>
<title></title>
';
  echo '<s';
  echo 'cript>
function open_news(USER_ID)
{
 URL="/general/ipanel/user_info.php?USER_ID="+USER_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 window.open(URL,"user","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
function open_email(EM';
  echo 'AIL_ID,BOX_ID)
{
 URL="/general/email/inbox/read_email/read_email.php?BOX_ID="+BOX_ID + "&EMAIL_ID="+EMAIL_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 window.open(URL,"email","height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
fun';
  echo 'ction open_notify(NOTIFY_ID)
{
 URL="/general/notify/show/read_notify.php?NOTIFY_ID="+NOTIFY_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 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");
}
function op';
  echo 'en_address(ADD_ID)
{
 URL="/general/address/private/address/add_detail.php?ADD_ID="+ADD_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 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");
}
function open_fi';
  echo 'le(CONTENT_ID,SORT_ID)
{
 URL="/general/file_folder/read.php?CONTENT_ID=" + CONTENT_ID + "&SORT_ID=" + SORT_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 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");
}
';
  echo '
function form_view(RUN_ID,FLOW_ID)
{
  myleft=(screen.availWidth-800)/2;
  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");
}
function open_customer(CUSTOMER_ID)
{
 URL="/general/sale_manage/crm/query/custome';
  echo 'r/showdetail.php?CUSTOMER_ID=" + CUSTOMER_ID + "&SEARCH_CENTER_FLAG=" + 1;
 myleft=(screen.availWidth-650)/2;
 mytop=100
 mywidth=650;
 myheight=500;
 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");
}
</script>
</head>
<body topmargin=\'0\'>
<br>
';
  $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 ('<', '&lt', $KWORD);
    $KWORD = str_replace ('>', '&gt', $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');
      }
      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');
      }
      $cursor = exequery ($connection, $query);
      $USER_COUNT = 0;
      while ($ROW = mysql_fetch_array ($cursor))
      {
        ++$USER_COUNT;
        if (($SHOW_COUNT < $USER_COUNT))
        {
          continue;
        }
        else
        {
          $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\'>
	              <tr>
	               <td><a href="javascript:open_news(\''.$USER_ID).(((''.'\');"><u>').$USER_NAME).'</u></a> <br>')).$SHOW_STR).'<br></td>
	              </tr>
	             </table><br>');
          continue;
        }
      }
      if ((($USER_COUNT == 0) AND ($KWORD != '')))
      {
        echo (('抱歉，没有找到与“'.$KWORD).'” 相关的内容');
      }
      if (($KWORD == ''))
      {
        echo '请输入查询条件';
        break;
      }
      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');
      $cursor = exequery ($connection, $query);
      $EMAIL_COUNT = 0;
      while ($ROW = mysql_fetch_array ($cursor))
      {
        ++$EMAIL_COUNT;
        if (($SHOW_COUNT < $USER_COUNT))
        {
          continue;
        }
        else
        {
          $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\'>
	              <tr>
	               <td><a href="javascript:open_email(\'').$EMAIL_ID).'\',\'').$BOX_ID).'\');"><u>邮件主题：').$SUBJECT).'</u></a> <br>').$SHOW_STR).'<br></td>
	              </tr>
	             </table><br>');
          continue;
        }
      }
      if ((($EMAIL_COUNT == 0) AND ($KWORD != '')))
      {
        echo (('抱歉，没有找到与“'.$KWORD).'” 相关的内容');
      }
      if (($KWORD == ''))
      {
        echo '请输入查询条件';
        break;
      }
      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\') and PUBLISH=\'1\' and SUBJECT like \'%').$KWORD).'%\' ').$WHERE_EMPTY).'order by BEGIN_DATE desc');
      $cursor = exequery ($connection, $query);
      $NOTIFY_COUNT = 0;
      while ($ROW = mysql_fetch_array ($cursor))
      {
        ++$NOTIFY_COUNT;
        if (($SHOW_COUNT < $USER_COUNT))
        {
          continue;
        }
        else
        {
          $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 = '';
            $TOK = strtok ($TO_ID, ',');
            while (($TOK != ''))
            {
              if (($TO_NAME != ''))
              {
                ($TO_NAME .= '，');
              }
              $query1 = (((''.'select DEPT_NAME from DEPARTMENT where DEPT_ID=\'').$TOK).'\'');
              $cursor1 = exequery ($connection, $query1);
              if ($ROW = mysql_fetch_array ($cursor1))
              {
                ($TO_NAME .= $ROW['DEPT_NAME']);
              }
              $TOK = strtok (',');
            }
          }
          $PRIV_NAME = '';
          $TOK = strtok ($PRIV_ID, ',');
          while (($TOK != ''))
          {
            $query1 = (((''.'SELECT PRIV_NAME from USER_PRIV where USER_PRIV=\'').$TOK).'\'');
            $cursor1 = exequery ($connection, $query1);
            if ($ROW = mysql_fetch_array ($cursor1))
            {
              ($PRIV_NAME .= ($ROW['PRIV_NAME'].'，'));
            }
            $TOK = strtok (',');
          }
          $USER_NAME = '';
          $TOK = strtok ($USER_ID, ',');
          while (($TOK != ''))
          {
            $query1 = (((''.'SELECT USER_NAME from USER where USER_ID=\'').$TOK).'\'');
            $cursor1 = exequery ($connection, $query1);
            if ($ROW = mysql_fetch_array ($cursor1))
            {
              ($USER_NAME .= ($ROW['USER_NAME'].'，'));
            }
            $TOK = strtok (',');
          }
          $TYPE_NAME = '';
          $query1 = (((''.'select CODE_NAME from SYS_CODE where PARENT_NO=\'NOTIFY\' and CODE_NO=\'').$TYPE_ID).'\'');
          $cursor1 = exequery ($connection, $query1);
          if ($ROW = mysql_fetch_array ($cursor1))
          {
            $TYPE_NAME = $ROW['CODE_NAME'];
          }
          $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\'>
	              <tr>
	               <td><a href="javascript:open_notify(\'').$NOTIFY_ID).'\');"><u>').$SUBJECT).'</u></a> <br>').$SHOW_STR).'<br></td>
	              </tr>
	             </table><br>');
          continue;
        }
      }
      if ((($NOTIFY_COUNT == 0) AND ($KWORD != '')))
      {
        echo (('抱歉，没有找到与“'.$KWORD).'” 相关的内容');
12

search.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 search.php 源码文件，采用 PHP 编程语言编写，共 810 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?