📄 manage.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
?>
<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());
$END_DATE=date("Y-m-d",time()-24*60*60);
if($OPERATION==1)
$query="update VOTE_TITLE set BEGIN_DATE='$CUR_DATE' where VOTE_ID='$VOTE_ID'";
else if($OPERATION==9)
{
$query="select VOTE_ID from VOTE_TITLE where PARENT_ID='$VOTE_ID'";
$cursor= exequery($connection,$query);
if(!$ROW=mysql_fetch_array($cursor))
{
$flag_childvote="0";
}
$query="select ITEM_ID from VOTE_ITEM where VOTE_ID='$VOTE_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor)||$flag_childvote!="0")
{
$query="update VOTE_TITLE set PUBLISH='1' where VOTE_ID='$VOTE_ID'";
$query1 = "SELECT TO_ID,BEGIN_DATE,SEND_TIME,SUBJECT,PRIV_ID,USER_ID from VOTE_TITLE where VOTE_ID='$VOTE_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
{
$TO_ID=$ROW1["TO_ID"];
$BEGIN_DATE=$ROW1["BEGIN_DATE"];
$SEND_TIME=$ROW1["SEND_TIME"];
$SUBJECT=$ROW1["SUBJECT"];
$PRIV_ID=$ROW1["PRIV_ID"];
$USER_ID=$ROW1["USER_ID"];
}
//------- 短信提醒 --------
$query3="select * from SYS_PARA where PARA_NAME='SMS_REMIND'";
$cursor3=exequery($connection,$query3);
if($ROW3=mysql_fetch_array($cursor3))
$PARA_VALUE=$ROW3["PARA_VALUE"];
$SMS_REMIND=substr($PARA_VALUE,0,strpos($PARA_VALUE,"|"));
$SMS2_REMIND=substr($PARA_VALUE,strpos($PARA_VALUE,"|")+1);
if(find_id($SMS_REMIND,"11"))
{
$SMS_CONTENT="请查看投票！\n标题：".csubstr($SUBJECT,0,100);
if(compare_date($BEGIN_DATE,$CUR_DATE)!=0)
$SEND_TIME=$BEGIN_DATE;
if($TO_ID=="ALL_DEPT")
$query2="select USER_ID from USER";
else
$query2="select USER_ID from USER where find_in_set(USER_PRIV,'$PRIV_ID') or find_in_set(USER_ID,'$USER_ID') or find_in_set(DEPT_ID,'$TO_ID')";
$cursor2=exequery($connection,$query2);
while($ROW2=mysql_fetch_array($cursor2))
$USER_ID_STR.=$ROW2["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(find_id($SMS2_REMIND,"11"))
{
$query_name="select USER_NAME from USER where USER_ID='$LOGIN_USER_ID'";
$cursor_name=exequery($connection,$query_name);
if($ROW_NAME=mysql_fetch_array($cursor_name))
$USER_NAME=$ROW["ROW_NAME"];
if(compare_date($BEGIN_DATE,$CUR_DATE)!=0)
$SEND_TIME=$BEGIN_DATE;
if($TO_ID=="ALL_DEPT")
$query2="select USER_ID from USER";
else
$query2="select USER_ID from USER where find_in_set(USER_PRIV,'$PRIV_ID') or find_in_set(USER_ID,'$USER_ID') or find_in_set(DEPT_ID,'$TO_ID')";
$cursor2=exequery($connection,$query2);
while($ROW2=mysql_fetch_array($cursor2))
$USER_ID_STR.=$ROW2["USER_ID"].",";
$SMS_CONTENT="OA投票,来自".$USER_NAME.":".csubstr($SUBJECT,0,100);
send_mobile_sms_user($SEND_TIME,$LOGIN_USER_ID,$USER_ID_STR,$SMS_CONTENT,11);
}
}
else
{
$flag_publish="0";
}
}
else if($OPERATION==2)
$query="update VOTE_TITLE set END_DATE='$END_DATE' where VOTE_ID='$VOTE_ID'";
else
$query="update VOTE_TITLE set END_DATE='0000-00-00' where VOTE_ID='$VOTE_ID'";
if($LOGIN_USER_PRIV!="1")
$query.=" and FROM_ID='$LOGIN_USER_ID'";
exequery($connection,$query);
if ($flag_publish=="0"&&$flag_childvote=="0")
{
Message("提示","投票项目为空且无子投票时，无法发布！");
?>
<br><div align="center"><input type="button" value="添加投票项目" class="BigButton" onClick="location='item/index.php?VOTE_ID=<?=$VOTE_ID?>&start=<?=$start?>'"> <input type="button" value="添加子投票" class="BigButton" onClick="location='vote.php?PARENT_ID=<?=$VOTE_ID?>&start=<?=$start?>'"></div>
<?
}
else
{
header("location: index1.php?start=$start");
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -