⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 add.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>

<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");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?VOTE_ID=<?=$VOTE_ID?>&CUR_PAGE=<?=$CUR_PAGE?>'">
</div>

<?
    exit;
  }
}

if($END_DATE!="")
{
  $TIME_OK=is_date($END_DATE);

  if(!$TIME_OK)
  { Message("错误","终止日期格式不对,应形如 1999-1-2");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?VOTE_ID=<?=$VOTE_ID?>&CUR_PAGE=<?=$CUR_PAGE?>'">
</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("错误","生效日期不能晚于终止日期");
?>

<br>
<div align="center">
 <input type="button" value="返回" class="BigButton" onClick="location='new.php?VOTE_ID=<?=$VOTE_ID?>&CUR_PAGE=<?=$CUR_PAGE?>'">
</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,TO_ID,PRIV_ID,USER_ID,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,END_DATE,TYPE,MAX_NUM,ANONYMITY,VIEW_PRIV) values ('$LOGIN_USER_ID','$TO_ID','$PRIV_ID','$COPY_TO_ID','$SUBJECT','$CONTENT','$SEND_TIME','$BEGIN_DATE','$END_DATE','$TYPE',$MAX_NUM,'$ANONYMITY','$VIEW_PRIV')";
else
   $query="update VOTE_TITLE set FROM_ID='$LOGIN_USER_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' where VOTE_ID=$VOTE_ID";
exequery($connection,$query);

//------- 短信提醒 --------
if($SMS_REMIND=="on")
{
  $SMS_CONTENT="请查看投票!\n标题:".csubstr($SUBJECT,0,100);

  if(compare_date($BEGIN_DATE,$CUR_DATE)!=0)
     $SEND_TIME=$BEGIN_DATE;

  if($TO_ID=="ALL_DEPT")
     $query="select * from USER";
  else
     $query="select * 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"].",";
  
  
  send_sms($SEND_TIME,$LOGIN_USER_ID,$USER_ID_STR,"11",$SMS_CONTENT);
}

if($SMS2_REMIND=="on")
{
   $query_name="select * 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);
}
?>

<script>
parent.location="index.php";
</script>
</body>
</html>

⌨️ 快捷键说明

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