📄 submit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_sms2.php");
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$connection=OpenConnection();
$MANAGER=$SECRET_TO_ID;
$PARTICIPATOR=$COPY_TO_ID;
//----------- 合法性校验 ---------
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='index.php?TO_ID=<?=$TO_ID?>&TO_NAME=<?=$TO_NAME?>&NAME=<?=$NAME?>&BEGIN_DATE=<?=$BEGIN_DATE?>&END_DATE=<?=$END_DATE?>&CONTENT=<?=$CONTENT?>&TYPE=<?=$TYPE?>&MANAGER=<?=$MANAGER?>&PARTICIPATOR=<?=$PARTICIPATOR?>&ATTACHMENT=<?=$ATTACHMENT?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME?>&ATTACHMENT_COMMENT=<?=$ATTACHMENT_COMMENT?>&REMARK=<?=$REMARK?>'">
</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='index.php?TO_ID=<?=$TO_ID?>&TO_NAME=<?=$TO_NAME?>&NAME=<?=$NAME?>&BEGIN_DATE=<?=$BEGIN_DATE?>&END_DATE=<?=$END_DATE?>&CONTENT=<?=$CONTENT?>&TYPE=<?=$TYPE?>&MANAGER=<?=$MANAGER?>&PARTICIPATOR=<?=$PARTICIPATOR?>&ATTACHMENT=<?=$ATTACHMENT?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME?>&ATTACHMENT_COMMENT=<?=$ATTACHMENT_COMMENT?>&REMARK=<?=$REMARK?>'">
</div>
<?
exit;
}
}
$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='index.php?TO_ID=<?=$TO_ID?>&TO_NAME=<?=$TO_NAME?>&NAME=<?=$NAME?>&BEGIN_DATE=<?=$BEGIN_DATE?>&END_DATE=<?=$END_DATE?>&CONTENT=<?=$CONTENT?>&TYPE=<?=$TYPE?>&MANAGER=<?=$MANAGER?>&PARTICIPATOR=<?=$PARTICIPATOR?>&ATTACHMENT=<?=$ATTACHMENT?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID?>&ATTACHMENT_NAME=<?=$ATTACHMENT_NAME?>&ATTACHMENT_COMMENT=<?=$ATTACHMENT_COMMENT?>&REMARK=<?=$REMARK?>'">
</div>
<?
exit;
}
$END_DATE="$END_DATE";
}
else
$END_DATE="null";
if($ATTACHMENT_NAME!="")
{
$ATTACHMENT_ID=upload($ATTACHMENT,$ATTACHMENT_NAME);
$ATTACHMENT_ID=$ATTACHMENT_ID_OLD.$ATTACHMENT_ID.",";
$ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD.$ATTACHMENT_NAME."*";
}
else
{
$ATTACHMENT_ID=$ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME=$ATTACHMENT_NAME_OLD;
}
//------------------- 保存 -----------------------
if($PLAN_ID=="")
$query="INSERT INTO WORK_PLAN (NAME,CONTENT,BEGIN_DATE,END_DATE,TYPE,TO_ID,MANAGER,PARTICIPATOR,CREATOR,CREATE_DATE,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_COMMENT,REMARK,TO_PERSON_ID) VALUES ('$NAME','$CONTENT','$BEGIN_DATE','$END_DATE','$TYPE','$TO_ID','$MANAGER','$PARTICIPATOR','$CREATOR','$CREATE_DATE','$ATTACHMENT_ID','$ATTACHMENT_NAME','$ATTACHMENT_COMMENT','$REMARK','$TO_ID3')";
else
$query="update WORK_PLAN set NAME='$NAME',CONTENT='$CONTENT',BEGIN_DATE='$BEGIN_DATE',END_DATE='$END_DATE',TYPE='$TYPE',TO_ID='$TO_ID',MANAGER='$MANAGER',PARTICIPATOR='$PARTICIPATOR',CREATOR='$LOGIN_USER_ID',CREATE_DATE='$CUR_DATE',ATTACHMENT_ID='$ATTACHMENT_ID',ATTACHMENT_NAME='$ATTACHMENT_NAME',ATTACHMENT_COMMENT='$ATTACHMENT_COMMENT',REMARK='$REMARK',TO_PERSON_ID='$TO_ID3' where PLAN_ID=$PLAN_ID";
exequery($connection,$query);
//echo $query;
if($SMS_REMIND=="on" || $SMS2_REMIND=="on")
{
$query="select * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$USER_NAME=$ROW["USER_NAME"];
$SMS_CONTENT=$USER_NAME."发布新的工作计划，请注意查看。";
$TO_ID_STR=$COPY_TO_ID;
//SECRET_TO_ID
$MY_ARRAY=explode(",",$SECRET_TO_ID);
$ARRAY_COUNT=sizeof($MY_ARRAY);
if($MY_ARRAY[$ARRAY_COUNT-1]=="")
$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
if(!find_id($TO_ID_STR,$MY_ARRAY[$I]))
$TO_ID_STR.=$MY_ARRAY[$I].",";
//TO_ID3
$MY_ARRAY=explode(",",$TO_ID3);
$ARRAY_COUNT=sizeof($MY_ARRAY);
if($MY_ARRAY[$ARRAY_COUNT-1]=="")
$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
if(!find_id($TO_ID_STR,$MY_ARRAY[$I]))
$TO_ID_STR.=$MY_ARRAY[$I].",";
$query="select * from USER where find_in_set(DEPT_ID,'$TO_ID') and not find_in_set(USER_ID,'$TO_ID_STR')";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$TO_ID_STR.=$USER_ID.",";
}
}
if($SMS_REMIND=="on")
send_sms("",$LOGIN_USER_ID,$TO_ID_STR,12,$SMS_CONTENT);
if($SMS2_REMIND=="on")
send_mobile_sms_user("",$LOGIN_USER_ID,$TO_ID_STR,$SMS_CONTENT,12);
if($OP==1)
{
if($PLAN_ID=="")
{
$query="select * from WORK_PLAN where NAME='$NAME' and CONTENT='$CONTENT' and BEGIN_DATE='$BEGIN_DATE' and END_DATE='$END_DATE' and TYPE='$TYPE' and TO_ID='$TO_ID' and MANAGER='$MANAGER' and PARTICIPATOR='$PARTICIPATOR' and CREATOR='$CREATOR' and CREATE_DATE='$CREATE_DATE' and ATTACHMENT_ID='$ATTACHMENT_ID' and ATTACHMENT_NAME='$ATTACHMENT_NAME' and ATTACHMENT_COMMENT='$ATTACHMENT_COMMENT' and REMARK='$REMARK'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$PLAN_ID=$ROW["PLAN_ID"];
}
header("location: index.php?PLAN_ID=$PLAN_ID");
}
else
header("location: ../");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -