📄 add.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_sms1.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title>保存投票</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">

<?
//--------- 上传附件 ----------
if(count($_FILES)>1)
{
   $ATTACHMENTS=upload();

   $ATTACHMENT_ID=$ATTACHMENT_ID_OLD.$ATTACHMENTS["ID"];
   $ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD.$ATTACHMENTS["NAME"];
}
else
{
   $ATTACHMENT_ID=$ATTACHMENT_ID_OLD;
   $ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD;
}

$ATTACHMENT_ID.=copy_sel_attach($ATTACH_NAME,$ATTACH_DIR,$DISK_ID);
$ATTACHMENT_NAME.=$ATTACH_NAME;

//----------- 合法性校验 ---------
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?>&start=<?=$start?>'">
</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?>&start=<?=$start?>'">
</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?>&start=<?=$start?>'">
</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,MIN_NUM,ANONYMITY,VIEW_PRIV,PUBLISH,VOTE_NO,ATTACHMENT_ID,ATTACHMENT_NAME) values ('$LOGIN_USER_ID','$PARENT_ID','$TO_ID','$PRIV_ID','$COPY_TO_ID','$SUBJECT','$CONTENT','$SEND_TIME','$BEGIN_DATE','$END_DATE','$TYPE',$MAX_NUM,$MIN_NUM,'$ANONYMITY','$VIEW_PRIV','$PUBLISH','$VOTE_NO','$ATTACHMENT_ID','$ATTACHMENT_NAME')";
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,MIN_NUM=$MIN_NUM,ANONYMITY='$ANONYMITY',VIEW_PRIV='$VIEW_PRIV',PUBLISH='$PUBLISH',VOTE_NO='$VOTE_NO',ATTACHMENT_ID='$ATTACHMENT_ID',ATTACHMENT_NAME='$ATTACHMENT_NAME' where VOTE_ID='$VOTE_ID'";
exequery($connection,$query);

if($VOTE_ID=="")
   $VOTE_ID=mysql_insert_id();

//------- 短信提醒 --------
if($SMS_REMIND=="on"&&$PUBLISH=="1"&&$OP!="3"&&$OP!="0")
{
  $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 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"&&$PUBLISH=="1"&&$OP!="3"&&$OP!="0")
{
   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"].",";
   
   $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!="" && $PARENT_ID!="0")
{
	 header("location: vote.php?PARENT_ID=$PARENT_ID&start=$start");
}
else
{
   if($OP=="0")
   {
      header("location: new.php?VOTE_ID=$VOTE_ID&start=$start");
   }
   else
   {
      Message("提示","投票保存成功！");
	  ?>
	  <br><div align="center"><input type="button" value="添加投票项目" class="BigButton" onClick=location="item/index.php?VOTE_ID=<?=$VOTE_ID?>">&nbsp;&nbsp;<input type="button" value="添加子投票" class="BigButton" onClick=location="vote.php?PARENT_ID=<?=$VOTE_ID?>">&nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onClick=location="index1.php"></div>";
      <?
   }  
}
?>
</body>
</html>
⌨️ 快捷键说明

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