📄 new.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $PARENT_ID != "" && $PARENT_ID != "0" )
{
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_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'];
$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 * 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 * 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 * 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 ( $SURVEY_ID != "" )
{
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$SURVEY_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'];
$ANONYMITY = $ROW['ANONYMITY'];
$VIEW_PRIV = $ROW['VIEW_PRIV'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$PUBLISH = $ROW['PUBLISH'];
$ORDER_NO = $ROW['ORDER_NO'];
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 * 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 * 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 * 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\"><script src=\"/inc/js/module.js\"></script>\r\n\r\n<script Language=\"JavaScript\">\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 document.form1.PUBLISH.value=flag;\r\n\r\n document.form1.submit();\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\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;
}
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 ( $SURVEY_ID != "" )
{
echo "修改";
}
else
{
echo "新建";
}
echo "培训调查</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableBlock\" width=\"70%\" align=\"center\">\r\n <form enctype=\"multipart/form-data\" action=\"add.php\" method=\"post\" name=\"form1\">\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()\">添加</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()\">添加</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('','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=\"ORDER_NO\" maxlength=\"20\" size=\"8\"class=\"BigInput\" value=\"";
echo $ORDER_NO;
echo "\"> \t\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=\"SUBJECT\" class=\"BigInput\" cols=\"50\" rows=\"3\">";
echo $SUBJECT;
echo "</textarea>\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 <tr>\r\n <td nowrap class=\"TableData\"> 邮件内容：</td>\r\n <td class=\"TableData\" colspan=\"1\">\r\n <textarea name=\"EMAIL_CONTENT1\" class=\"BigInput\" cols=\"50\" rows=\"3\"></textarea>\r\n </td>\r\n </tr> \r\n <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=\"4\" 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";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( 0 <= compare_date( $CUR_DATE, $BEGIN_DATE ) && $BEGIN_DATE != "" )
{
$TEMP_STR = " onclick='this.checked=!this.checked'";
}
echo " \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 $TEMP_STR;
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>\r\n <td nowrap class=\"TableData\"> 提醒员工：</td>\r\n <td class=\"TableData\">\r\n";
echo sms_remind( 32 );
echo " <input type=\"checkbox\" name=\"MAIL_REMIND\" id=\"MAIL_REMIND\"><label for=\"MAIL_REMIND\">使用邮件</label>\r\n </td>\r\n </tr>\r\n";
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"hidden\" name=\"SURVEY_ID\" value=\"";
echo $SURVEY_ID;
echo "\">\r\n <input type=\"hidden\" name=\"CUR_PAGE\" value=\"";
echo $CUR_PAGE;
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";
if ( $SURVEY_ID != "" && ( $PARENT_ID == "" || $PARENT_ID == "0" ) )
{
echo " <input type=\"button\" value=\"发布\" class=\"BigButton\" onclick=\"CheckForm('1');\"> \r\n";
}
echo " <input type=\"button\" value=\"保存\" class=\"BigButton\" onclick=\"CheckForm('0');\"> \r\n";
if ( $SURVEY_ID != "" && ( $PARENT_ID == "" || $PARENT_ID == "0" ) )
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index1.php?CUR_PAGE=";
echo $CUR_PAGE;
echo "'\">\r\n";
}
if ( $PARENT_ID != "" && $PARENT_ID != "0" )
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='survey.php?PARENT_ID=";
echo $PARENT_ID;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
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 + -