📄 search_del.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">
</head>
<body class="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 (($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).'\''));
        }
      }
    }
  }
  if (($LOGIN_USER_PRIV != '1'))
  {
    $query = (((''.'select ATTACHMENT_ID,ATTACHMENT_NAME from NOTIFY where ATTACHMENT_NAME!=\'\' and FROM_ID=\'').$LOGIN_USER_ID).'\'');
  }
  else
  {
    $query = 'select ATTACHMENT_ID,ATTACHMENT_NAME from NOTIFY where ATTACHMENT_NAME!=\'\'';
  }
  ($query .= $CONDITION_STR);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
    $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
    delete_attach ($ATTACHMENT_ID, $ATTACHMENT_NAME);
  }
  if (($LOGIN_USER_PRIV != '1'))
  {
    $query = (((''.'delete from NOTIFY where FROM_ID=\'').$LOGIN_USER_ID).'\'');
  }
  else
  {
    $query = 'delete from NOTIFY where 1=1';
  }
  ($query .= $CONDITION_STR);
  exequery ($connection, $query);
  $NOTIFY_COUNT = mysql_affected_rows ();
  message ('', (('共删除'.$NOTIFY_COUNT).'条公告通知'));
  button_back ();
  add_log (15, (('查询删除'.$NOTIFY_COUNT).'公告通知'), $LOGIN_USER_ID);
  echo '</body>
</html>
';
?>
⌨️ 快捷键说明

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