📄 search.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>公告通知查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function open_notify(NOTIFY_ID)
{
 URL="../show/read_notify.php?NOTIFY_ID="+NOTIFY_ID;
 myleft=(screen.availWidth-650)/2;
 window.open(URL,"read_notify","height=500,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
function show_reader(NOTIFY_ID)
{
 URL="show_reader.php?NOTIFY_ID="+NOTIFY_ID;
 myleft=(screen.availWidth';
  echo '-500)/2;
 window.open(URL,"read_notify","height=350,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function delete_notify(NOTIFY_ID,start)
{
 msg=\'确认要删除该项公告通知么？\';
 if(window.confirm(msg))
 {
  URL="delete.php?NOTIFY_ID=" + NOTIFY_ID + "&start=" + start;
  window.location=URL;
 }
}
</script>
</head>
<body clas';
  echo 's="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($SEND_TIME_MIN != ''))
  {
    $TIME_OK = is_date ($SEND_TIME_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $SEND_TIME_MIN = ($SEND_TIME_MIN.' 00:00:00');
  }
  if (($SEND_TIME_MAX != ''))
  {
    $TIME_OK = is_date ($SEND_TIME_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $SEND_TIME_MAX = ($SEND_TIME_MAX.' 23:59:59');
  }
  $CONDITION_STR = '';
  if (($SUBJECT != ''))
  {
    ($CONDITION_STR .= ((' and SUBJECT like \'%'.$SUBJECT).'%\''));
  }
  if (($CONTENT != ''))
  {
    ($CONDITION_STR .= ((' and CONTENT like \'%'.$CONTENT).'%\''));
  }
  if (($SEND_TIME_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and SEND_TIME>=\'').$SEND_TIME_MIN).'\''));
  }
  if (($SEND_TIME_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and SEND_TIME<=\'').$SEND_TIME_MAX).'\''));
  }
  if (($FORMAT != ''))
  {
    ($CONDITION_STR .= (((''.' and FORMAT=\'').$FORMAT).'\''));
  }
  if (($TYPE_ID != ''))
  {
    ($CONDITION_STR .= (((''.' and TYPE_ID=\'').$TYPE_ID).'\''));
  }
  if (($PUBLISH != ''))
  {
    ($CONDITION_STR .= (((''.' and PUBLISH=\'').$PUBLISH).'\''));
  }
  if (($TO_ID != ''))
  {
    ($CONDITION_STR .= (((''.' and find_in_set(FROM_ID,\'').$TO_ID).'\')'));
  }
  if (($STAT != ''))
  {
    if (($STAT == 1))
    {
      ($CONDITION_STR .= (((''.' and BEGIN_DATE>\'').$CUR_DATE).'\''));
    }
    else
    {
      if (($STAT == 2))
      {
        ($CONDITION_STR .= (((((''.' and BEGIN_DATE<=\'').$CUR_DATE).'\' and (END_DATE=\'0000-00-00\' or END_DATE>=\'').$CUR_DATE).'\')'));
      }
      else
      {
        if (($STAT == 3))
        {
          ($CONDITION_STR .= (((''.' and END_DATE!=\'0000-00-00\' and END_DATE<=\'').$CUR_DATE).'\''));
        }
      }
    }
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" width="24" height="24" align="absMiddle">';
  echo '<s';
  echo 'pan class="big3"> 公告通知查询结果</span><br>
    </td>
  </tr>
</table>
';
  if (($LOGIN_USER_PRIV != '1'))
  {
    $query = (((''.'SELECT * from NOTIFY where FROM_ID=\'').$LOGIN_USER_ID).'\'');
  }
  else
  {
    $query = 'SELECT * from NOTIFY where 1=1';
  }
  ($query .= ($CONDITION_STR.' order by TOP desc, SEND_TIME desc'));
  $cursor = exequery ($connection, $query);
  $NOTIFY_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$NOTIFY_COUNT;
    $NOTIFY_ID = $ROW['NOTIFY_ID'];
    $FROM_ID = $ROW['FROM_ID'];
    $TO_ID = $ROW['TO_ID'];
    $SUBJECT = $ROW['SUBJECT'];
    $READERS = $ROW['READERS'];
    $FORMAT = $ROW['FORMAT'];
    $TOP = $ROW['TOP'];
    $PRIV_ID = $ROW['PRIV_ID'];
    $USER_ID = $ROW['USER_ID'];
    $TYPE_ID = $ROW['TYPE_ID'];
    $SUBJECT = htmlspecialchars ($SUBJECT);
    $SEND_TIME = $ROW['SEND_TIME'];
    $BEGIN_DATE = $ROW['BEGIN_DATE'];
    $END_DATE = $ROW['END_DATE'];
    $BEGIN_DATE = strtok ($BEGIN_DATE, ' ');
    $END_DATE = strtok ($END_DATE, ' ');
    if (($END_DATE == '0000-00-00'))
    {
      $END_DATE = '';
    }
    $query1 = (((''.'select USER_NAME,DEPT_ID from USER where USER_ID=\'').$FROM_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_NAME = $ROW['USER_NAME'];
      $DEPT_ID = $ROW['DEPT_ID'];
    }
    $DEPT_NAME = dept_long_name ($DEPT_ID);
    $TYPE_NAME = get_code_name ($TYPE_ID, 'NOTIFY');
    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 (',');
    }
    $TO_NAME_TITLE = '';
    $TO_NAME_STR = '';
    $TO_NAME = substr ($TO_NAME, 0, -2);
    $PRIV_NAME = substr ($PRIV_NAME, 0, -2);
    $USER_NAME = substr ($USER_NAME, 0, -2);
    if (($TO_NAME != ''))
    {
      ($TO_NAME_TITLE .= ('部门：'.$TO_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>部门：</b></font>'.csubstr (strip_tags ($TO_NAME), 0, 20)).((20 < strlen ($TO_NAME)) ? '...' : '')).'<br>'));
    }
    if (($PRIV_NAME != ''))
    {
      $PRIV_NAME = substr ($PRIV_NAME, 0, -2);
      if (($TO_NAME_TITLE != ''))
      {
        ($TO_NAME_TITLE .= '
');
      }
      ($TO_NAME_TITLE .= ('角色：'.$PRIV_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>角色：</b></font>'.csubstr (strip_tags ($PRIV_NAME), 0, 20)).((20 < strlen ($PRIV_NAME)) ? '...' : '')).'<br>'));
    }
    if (($USER_NAME != ''))
    {
      $USER_NAME = substr ($USER_NAME, 0, -2);
      if (($TO_NAME_TITLE != ''))
      {
        ($TO_NAME_TITLE .= '
');
      }
      ($TO_NAME_TITLE .= ('人员：'.$USER_NAME));
      ($TO_NAME_STR .= ((('<font color=#0000FF><b>人员：</b></font>'.csubstr (strip_tags ($USER_NAME), 0, 20)).((20 < strlen ($USER_NAME)) ? '...' : '')).'<br>'));
    }
    if ((compare_date ($CUR_DATE, $BEGIN_DATE) < 0))
    {
      $NOTIFY_STATUS = 1;
      $NOTIFY_STATUS_STR = '待生效';
    }
    else
    {
      $NOTIFY_STATUS = 2;
      $NOTIFY_STATUS_STR = '<font color=\'#00AA00\'><b>生效</span>';
    }
    if (($END_DATE != ''))
    {
      if ((0 < compare_date ($CUR_DATE, $END_DATE)))
      {
        $NOTIFY_STATUS = 3;
        $NOTIFY_STATUS_STR = '<font color=\'#FF0000\'><b>终止</span>';
      }
    }
    if (($NOTIFY_COUNT == 1))
    {
      echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">发送人</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center">发送范围</td>
      <td nowrap align="center">标题</td>
      <td nowrap align="center">创建时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></t';
      echo 'd>
      <td nowrap align="center">生效日期</td>
      <td nowrap align="center">终止日期</td>
      <td nowrap align="center">当前状态</td>
      <td nowrap align="center">操作</td>
    </tr>
';
    }
    if ((($NOTIFY_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo ' <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center"><u title="部门：';
    echo $DEPT_NAME;
    echo '" style="cursor:hand">';
    echo $FROM_NAME;
    echo '</u></td>
      <td nowrap align="center">';
    echo $TYPE_NAME;
    echo '</td>
      <td style="cursor:hand" title="';
    echo $TO_NAME_TITLE;
    echo '">';
    echo $TO_NAME_STR;
    echo '</td>
      <td>
      <a href="javascript:open_notify(\'';
    echo $NOTIFY_ID;
    echo '\');">';
    if (($TOP == '1'))
    {
      echo '<font color=#FF0000><b>重要：</b></font>';
    }
    echo $SUBJECT;
    echo '</a>
      </td>
      <td align="center">';
    echo $SEND_TIME;
    echo '</a></td>
      <td nowrap align="center">';
    echo $BEGIN_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $END_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $NOTIFY_STATUS_STR;
    echo '</td>
      <td nowrap align="center">
      <a href="modify.php?NOTIFY_ID=';
    echo $NOTIFY_ID;
    echo '"> 修改</a>
      <a href="javascript:delete_notify(\'';
    echo $NOTIFY_ID;
    echo '\',\'';
    echo $start;
    echo '\');"> 删除</a>
      ';
    if (($NOTIFY_STATUS == 1))
    {
      echo '      <a href="manage.php?NOTIFY_ID=';
      echo $NOTIFY_ID;
      echo '&OPERATION=1"> 立即生效</a>
      ';
    }
    else
    {
      if (($NOTIFY_STATUS == 2))
      {
        echo '      <a href="manage.php?NOTIFY_ID=';
        echo $NOTIFY_ID;
        echo '&OPERATION=2"> 终止</a>
      ';
      }
      else
      {
        if (($NOTIFY_STATUS == 3))
        {
          echo '      <a href="manage.php?NOTIFY_ID=';
          echo $NOTIFY_ID;
          echo '&OPERATION=3"> 生效</a>
      ';
        }
      }
    }
    echo '      <br>
      <a href="javascript:show_reader(\'';
    echo $NOTIFY_ID;
    echo '\');"> 查阅情况</a>
      </td>
    </tr>
';
  }
  if (($NOTIFY_COUNT == 0))
  {
    message ('', '无符合条件的公告通知');
    button_back ();
    exit ();
  }
  else
  {
    echo '</table>
';
    button_back ();
  }
  echo '</body>
</html>
';
?>
⌨️ 快捷键说明

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