📄 add.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_sms1.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">
';
  if (($BEGIN_DATE != ''))
  {
    $TIME_OK = is_date ($BEGIN_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '生效日期格式不对，应形如 1999-1-2');
      echo '
<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location=\'new.php?VOTE_ID=';
      echo $VOTE_ID;
      echo '&start=';
      echo $start;
      echo '\'">
</div>
';
      exit ();
    }
  }
  if (($END_DATE != ''))
  {
    $TIME_OK = is_date ($END_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '终止日期格式不对，应形如 1999-1-2');
      echo '
<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location=\'new.php?VOTE_ID=';
      echo $VOTE_ID;
      echo '&start=';
      echo $start;
      echo '\'">
</div>
';
      exit ();
    }
  }
  $MAX_NUM = intval ($MAX_NUM);
  $CUR_DATE = date ('Y-m-d', time ());
  if (($BEGIN_DATE == ''))
  {
    $BEGIN_DATE = $CUR_DATE;
  }
  if (($END_DATE != ''))
  {
    if ((compare_date ($BEGIN_DATE, $END_DATE) == 1))
    {
      message ('错误', '生效日期不能晚于终止日期');
      echo '
<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location=\'new.php?VOTE_ID=';
      echo $VOTE_ID;
      echo '&start=';
      echo $start;
      echo '\'">
</div>
';
      exit ();
    }
  }
  else
  {
    $END_DATE = '0000-00-00';
  }
  $SEND_TIME = date ('Y-m-d H:i:s', time ());
  if (($ANONYMITY == 'on'))
  {
    $ANONYMITY = '1';
  }
  else
  {
    $ANONYMITY = '0';
  }
  if (($VOTE_ID == ''))
  {
    $query = (((((((((((((((((((((((((((((((((''.'insert into VOTE_TITLE(FROM_ID,PARENT_ID,TO_ID,PRIV_ID,USER_ID,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,END_DATE,TYPE,MAX_NUM,ANONYMITY,VIEW_PRIV,PUBLISH,VOTE_NO) values (\'').$LOGIN_USER_ID).'\',\'').$PARENT_ID).'\',\'').$TO_ID).'\',\'').$PRIV_ID).'\',\'').$COPY_TO_ID).'\',\'').$SUBJECT).'\',\'').$CONTENT).'\',\'').$SEND_TIME).'\',\'').$BEGIN_DATE).'\',\'').$END_DATE).'\',\'').$TYPE).'\',').$MAX_NUM).',\'').$ANONYMITY).'\',\'').$VIEW_PRIV).'\',\'').$PUBLISH).'\',\'').$VOTE_NO).'\')');
  }
  else
  {
    $query = ((((((((((((((((((((((((((((((((((''.'update VOTE_TITLE set FROM_ID=\'').$LOGIN_USER_ID).'\',PARENT_ID=\'').$PARENT_ID).'\',TO_ID=\'').$TO_ID).'\',PRIV_ID=\'').$PRIV_ID).'\',USER_ID=\'').$COPY_TO_ID).'\',SUBJECT=\'').$SUBJECT).'\',CONTENT=\'').$CONTENT).'\',SEND_TIME=\'').$SEND_TIME).'\',BEGIN_DATE=\'').$BEGIN_DATE).'\',END_DATE=\'').$END_DATE).'\',TYPE=\'').$TYPE).'\',MAX_NUM=').$MAX_NUM).',ANONYMITY=\'').$ANONYMITY).'\',VIEW_PRIV=\'').$VIEW_PRIV).'\',PUBLISH=\'').$PUBLISH).'\',VOTE_NO=\'').$VOTE_NO).'\' where VOTE_ID=').$VOTE_ID);
  }
  exequery ($connection, $query);
  if (($VOTE_ID == ''))
  {
    $VOTE_ID = mysql_insert_id ();
  }
  if ((($SMS_REMIND == 'on') AND ($PUBLISH == '1')))
  {
    $SMS_CONTENT = ('请查看投票！
标题：'.csubstr ($SUBJECT, 0, 100));
    if ((compare_date ($BEGIN_DATE, $CUR_DATE) != 0))
    {
      $SEND_TIME = $BEGIN_DATE;
    }
    if (($TO_ID == 'ALL_DEPT'))
    {
      $query = 'select USER_ID from USER';
    }
    else
    {
      $query = (((((((''.'select USER_ID from USER where find_in_set(USER_PRIV,\'').$PRIV_ID).'\') or find_in_set(USER_ID,\'').$COPY_TO_ID).'\') or find_in_set(DEPT_ID,\'').$TO_ID).'\')');
    }
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ($USER_ID_STR .= ($ROW['USER_ID'].','));
    }
    $REMIND_URL = ('1:vote/show/read_vote.php?VOTE_ID='.$VOTE_ID);
    send_sms ($SEND_TIME, $LOGIN_USER_ID, $USER_ID_STR, '11', $SMS_CONTENT, $REMIND_URL);
  }
  if ((($SMS2_REMIND == 'on') AND ($PUBLISH == '1')))
  {
    $query_name = (((''.'select USER_NAME from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
    $cursor_name = exequery ($connection, $query_name);
    if ($ROW = mysql_fetch_array ($cursor_name))
    {
      $USER_NAME = $ROW['USER_NAME'];
    }
    $SMS_CONTENT = ((('OA投票,来自'.$USER_NAME).':').csubstr ($SUBJECT, 0, 100));
    send_mobile_sms_user ($SEND_TIME, $LOGIN_USER_ID, $USER_ID_STR, $SMS_CONTENT, 11);
  }
  if ((($PARENT_ID != '') AND ($PARENT_ID != '0')))
  {
    header (((((''.'location: vote.php?PARENT_ID=').$PARENT_ID).'&start=').$start));
  }
  else
  {
    echo '<s';
    echo 'cript>
parent.location="index.php";
</script>
';
  }
  echo '</body>
</html>
';
?>
⌨️ 快捷键说明

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