📄 new.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/check_type.php" );
if ( $PARENT_ID != "" && $PARENT_ID != "0" )
{
$query = "SELECT * from VOTE_TITLE where VOTE_ID='".$PARENT_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TO_ID = $ROW['TO_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$COPY_TO_ID = $ROW['USER_ID'];
$TYPE = $ROW['TYPE'];
$MAX_NUM = $ROW['MAX_NUM'];
$MIN_NUM = $ROW['MIN_NUM'];
$ANONYMITY = $ROW['ANONYMITY'];
$VIEW_PRIV = $ROW['VIEW_PRIV'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
if ( $BEGIN_DATE == "0000-00-00" )
{
$BEGIN_DATE = "";
}
if ( $END_DATE == "0000-00-00" )
{
$END_DATE = "";
}
if ( $TO_ID == "ALL_DEPT" )
{
$TO_NAME = "全体部门";
}
else
{
$TO_NAME = "";
$TOK = strtok( $TO_ID, "," );
while ( $TOK != "" )
{
$query1 = "select DEPT_NAME from DEPARTMENT where DEPT_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TO_NAME .= $ROW['DEPT_NAME'].",";
}
$TOK = strtok( "," );
}
}
$PRIV_NAME = "";
$query1 = "select PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'".$PRIV_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRIV_NAME .= $ROW['PRIV_NAME'].",";
}
$COPY_TO_NAME = "";
$query1 = "select USER_NAME from USER where find_in_set(USER_ID,'".$COPY_TO_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$COPY_TO_NAME .= $ROW['USER_NAME'].",";
}
}
}
if ( $VOTE_ID != "" )
{
$query = "SELECT * from VOTE_TITLE where VOTE_ID='".$VOTE_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TO_ID = $ROW['TO_ID'];
$PARENT_ID = $ROW['PARENT_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$COPY_TO_ID = $ROW['USER_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$MAX_NUM = $ROW['MAX_NUM'];
$MIN_NUM = $ROW['MIN_NUM'];
$ANONYMITY = $ROW['ANONYMITY'];
$VIEW_PRIV = $ROW['VIEW_PRIV'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$PUBLISH = $ROW['PUBLISH'];
$VOTE_NO = $ROW['VOTE_NO'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $BEGIN_DATE == "0000-00-00" )
{
$BEGIN_DATE = "";
}
if ( $END_DATE == "0000-00-00" )
{
$END_DATE = "";
}
if ( $TO_ID == "ALL_DEPT" )
{
$TO_NAME = "全体部门";
}
else
{
$TO_NAME = "";
$TOK = strtok( $TO_ID, "," );
while ( $TOK != "" )
{
$query1 = "select DEPT_NAME from DEPARTMENT where DEPT_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$TO_NAME .= $ROW['DEPT_NAME'].",";
}
$TOK = strtok( "," );
}
}
$PRIV_NAME = "";
$query1 = "select PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'".$PRIV_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRIV_NAME .= $ROW['PRIV_NAME'].",";
}
$COPY_TO_NAME = "";
$query1 = "select USER_NAME from USER where find_in_set(USER_ID,'".$COPY_TO_ID."')";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$COPY_TO_NAME .= $ROW['USER_NAME'].",";
}
}
}
echo "\r\n<html>\r\n<head>\r\n<title>投票管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"/inc/js/module.js\"></script>\r\n<script src=\"/inc/js/utility.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script Language=\"JavaScript\">\r\nvar upload_limit=";
echo $UPLOAD_LIMIT;
echo ",limit_type=\"";
echo strtolower( $UPLOAD_LIMIT_TYPE );
echo "\";\r\nfunction CheckForm(flag)\r\n{\r\n";
if ( $PARENT_ID == "" || $PARENT_ID == "0" )
{
echo " if(document.form1.TO_ID.value==\"\" && document.form1.PRIV_ID.value==\"\" && document.form1.COPY_TO_ID.value==\"\")\r\n { alert(\"请至少指定一种发布范围！\");\r\n return (false);\r\n }\r\n";
}
echo " if(document.form1.SUBJECT.value==\"\")\r\n { alert(\"投票的标题不能为空！\");\r\n return (false);\r\n }\r\n \r\n if(document.form1.TYPE.value==\"1\")\r\n {\r\n if (document.getElementById(\"MIN_NUM\").value>document.getElementById(\"MAX_NUM\").value)\r\n\t {\r\n\t alert(\"多选类型中，最少允许选择项应小于最多允许选择项！\");\r\n return (false);\r\n\t }\r\n }\r\n \r\n if (flag==\"0\")\r\n {\r\n if(document.form1.PUBLISH.value==\"\")\r\n document.form1.PUBLISH.value=\"0\";\r\n\t document.form1.OP.value=\"3\";\r\n }\r\n\t \r\n if (flag==\"1\")\r\n document.form1.PUBLISH.value=\"1\";\r\n\r\n document.form1.submit();\r\n}\r\n\r\nfunction upload_attach()\r\n{\r\n if (document.form1.PUBLISH.value==\"\")\r\n document.form1.PUBLISH.value=\"0\";\r\n \r\n ";
if ( $PARENT_ID == "" || $PARENT_ID == "0" )
{
echo " if(document.form1.TO_ID.value==\"\" && document.form1.PRIV_ID.value==\"\" && document.form1.COPY_TO_ID.value==\"\")\r\n { \r\n\t alert(\"请至少指定一种发布范围！\");\r\n return;\r\n }\r\n ";
}
echo " if(document.form1.SUBJECT.value==\"\")\r\n { \r\n alert(\"投票的标题不能为空！\");\r\n return;\r\n }\r\n \r\n document.form1.OP.value=\"0\";\r\n document.form1.submit();\r\n \r\n}\r\n\r\nfunction change_type()\r\n{\r\n if(document.form1.TYPE.value==\"1\")\r\n document.getElementById(\"MAX_NUM_DESC\").style.display=\"\";\r\n else\r\n document.getElementById(\"MAX_NUM_DESC\").style.display=\"none\";\r\n}\r\n\r\nfunction delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n msg=\"确定要删除文件 '\"+ ATTACHMENT_NAME +\"' 吗?\";\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_attach.php?VOTE_ID=";
echo $VOTE_ID;
echo "&ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+URLSpecialChars(ATTACHMENT_NAME);\r\n window.location=URL;\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"javascript:form1.SUBJECT.focus();\">\r\n";
if ( $MAX_NUM == "" )
{
$MAX_NUM = 0;
}
if ( $MIN_NUM == "" )
{
$MIN_NUM = 0;
}
echo "<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> ";
if ( $VOTE_ID != "" )
{
echo "修改";
}
else
{
echo "新建";
}
echo "投票</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<form enctype=\"multipart/form-data\" action=\"add.php\" method=\"post\" name=\"form1\">\r\n<table class=\"TableBlock\" width=\"70%\" align=\"center\">\r\n";
if ( $PARENT_ID == "" || $PARENT_ID == "0" )
{
echo " <tr>\r\n <td nowrap class=\"TableData\">发布范围（部门）：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"";
echo $TO_ID;
echo "\">\r\n <textarea cols=40 name=\"TO_NAME\" rows=2 class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $TO_NAME;
echo "</textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectDept('7')\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser()\">清空</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">发布范围（角色）：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"PRIV_ID\" value=\"";
echo $PRIV_ID;
echo "\">\r\n <textarea cols=40 name=\"PRIV_NAME\" rows=2 class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $PRIV_NAME;
echo "</textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectPriv('7')\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('PRIV_ID', 'PRIV_NAME')\">清空</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">发布范围（人员）：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"COPY_TO_ID\" value=\"";
echo $COPY_TO_ID;
echo "\">\r\n <textarea cols=40 name=\"COPY_TO_NAME\" rows=2 class=\"BigStatic\" wrap=\"yes\" readonly>";
echo $COPY_TO_NAME;
echo "</textarea>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUser('7','COPY_TO_ID', 'COPY_TO_NAME')\">添加</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('COPY_TO_ID', 'COPY_TO_NAME')\">清空</a>\r\n </td>\r\n </tr>\r\n";
}
echo " <tr>\r\n <td nowrap class=\"TableData\"> 标题：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"SUBJECT\" size=\"40\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $SUBJECT;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">投票描述：</td>\r\n <td class=\"TableData\">\r\n <textarea name=\"CONTENT\" class=\"BigInput\" cols=\"50\" rows=\"3\">";
echo $CONTENT;
echo "</textarea>\r\n </td>\r\n </tr>\r\n";
if ( $PARENT_ID )
{
echo " <tr>\r\n <td nowrap class=\"TableData\"> 排序号：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"VOTE_NO\" size=\"10\" maxlength=\"20\" class=\"BigInput\" value=\"";
echo $VOTE_NO;
echo "\">\r\n </td>\r\n </tr>\r\n";
}
echo " <tr>\r\n <td nowrap class=\"TableData\"> 类型：</td>\r\n <td class=\"TableData\">\r\n <select name=\"TYPE\" class=\"BigSelect\" onChange=\"change_type();\">\r\n <option value=\"0\" ";
if ( $TYPE == "0" )
{
echo "selected";
}
echo ">单选</option>\r\n <option value=\"1\" ";
if ( $TYPE == "1" )
{
echo "selected";
}
echo ">多选</option>\r\n <option value=\"2\" ";
if ( $TYPE == "2" )
{
echo "selected";
}
echo ">文本输入</option>\r\n </select>\r\n <span id=\"MAX_NUM_DESC\" style=\"display:";
if ( $TYPE != "1" )
{
echo "none";
}
echo "\">最多允许选择 <input type=\"input\" name=\"MAX_NUM\" value=\"";
echo $MAX_NUM;
echo "\" size=\"2\" class=\"SmallInput\"> 项， 最少允许选择 <input type=\"input\" name=\"MIN_NUM\" value=\"";
echo $MIN_NUM;
echo "\" size=\"2\" class=\"SmallInput\"> 项，0则不限制</span>\r\n </td>\r\n </tr>\r\n";
if ( $PARENT_ID == "" || $PARENT_ID == "0" )
{
echo " <tr>\r\n <td nowrap class=\"TableData\"> 查看投票结果：</td>\r\n <td class=\"TableData\">\r\n <select name=\"VIEW_PRIV\" class=\"BigSelect\">\r\n <option value=\"0\" ";
if ( $VIEW_PRIV == "0" )
{
echo "selected";
}
echo ">投票后允许查看</option>\r\n <option value=\"1\" ";
if ( $VIEW_PRIV == "1" )
{
echo "selected";
}
echo ">投票前允许查看</option>\r\n <option value=\"2\" ";
if ( $VIEW_PRIV == "2" )
{
echo "selected";
}
echo ">不允许查看</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 匿名投票：</td>\r\n <td class=\"TableData\">\r\n <input type=\"checkbox\" name=\"ANONYMITY\" id=\"ANONYMITY\" ";
if ( $ANONYMITY == "1" )
{
echo "checked";
}
echo "><label for=\"ANONYMITY\">允许匿名投票</label>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\"> 有效期：</td>\r\n <td class=\"TableData\">\r\n 生效日期：<input type=\"text\" name=\"BEGIN_DATE\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"";
echo $BEGIN_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.BEGIN_DATE');\">\r\n 为空为立即生效<br>\r\n 终止日期：<input type=\"text\" name=\"END_DATE\" size=\"10\" maxlength=\"10\" class=\"BigInput\" value=\"";
echo $END_DATE;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.END_DATE');\">\r\n 为空为手动终止\r\n </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td nowrap>附件文档：</td>\r\n <td nowrap>";
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 1, 1 );
echo "</td>\r\n </tr>\r\n <tr height=\"25\">\r\n <td nowrap class=\"TableData\">附件选择：</td>\r\n <td class=\"TableData\">\r\n <script>ShowAddFile();</script>\r\n <script>\$(\"ATTACHMENT_upload_div\").innerHTML='<a href=\"javascript:upload_attach();\">上传附件</a>'</script>\r\n </td>\r\n </tr>\r\n ";
if ( $VOTE_ID != "" )
{
echo " <tr>\r\n <td nowrap class=\"TableData\"> 短消息提醒：</td>\r\n <td class=\"TableData\">\r\n";
echo sms_remind( 11 );
echo " </td>\r\n </tr>\r\n";
}
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"hidden\" name=\"VOTE_ID\" value=\"";
echo $VOTE_ID;
echo "\">\r\n <input type=\"hidden\" name=\"start\" value=\"";
echo $start;
echo "\">\r\n <input type=\"hidden\" name=\"PARENT_ID\" value=\"";
echo $PARENT_ID;
echo "\">\r\n <input type=\"hidden\" name=\"PUBLISH\" value=\"";
echo $PUBLISH;
echo "\">\r\n <input type=\"hidden\" name=\"OP\" value=\"\">\r\n <input type=\"hidden\" name=\"ATTACHMENT_ID_OLD\" value=\"";
echo $ATTACHMENT_ID;
echo "\">\r\n <input type=\"hidden\" name=\"ATTACHMENT_NAME_OLD\" value=\"";
echo $ATTACHMENT_NAME;
echo "\">\r\n";
if ( $VOTE_ID != "" && ( $PARENT_ID == "" || $PARENT_ID == "0" ) && $PUBLISH != "1" )
{
echo " <input type=\"button\" value=\"发布\" class=\"BigButton\" onClick=\"CheckForm('1');\"> \r\n";
}
echo " <input type=\"button\" value=\"保存\" class=\"BigButton\" onClick=\"CheckForm('0');\"> \r\n <input type=\"reset\" value=\"重填\" class=\"BigButton\"> \r\n";
if ( $VOTE_ID != "" && ( $PARENT_ID == "" || $PARENT_ID == "0" ) )
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index1.php?start=";
echo $start;
echo "'\">\r\n";
}
if ( $PARENT_ID != "" && $PARENT_ID != "0" )
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='vote.php?PARENT_ID=";
echo $PARENT_ID;
echo "&start=";
echo $start;
echo "'\">\r\n";
}
echo " </td>\r\n </tr>\r\n </table>\r\n</form>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -