📄 read_survey.php
字号:
<?php
function ParseItemName( $ITEM_NAME, $ITEM_ID, $COUNT = 1 )
{
$POS = strpos( $ITEM_NAME, "{" );
if ( $POS === FALSE )
{
return $ITEM_NAME;
}
if ( substr( $ITEM_NAME, $POS, 6 ) == "{text}" )
{
return substr( $ITEM_NAME, 0, $POS )."<input name=VOTE_DATA_".$ITEM_ID."_".$COUNT++." type=text size=20 class=SmallInput>".parseitemname( substr( $ITEM_NAME, $POS + 6 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 8 ) == "{number}" )
{
return substr( $ITEM_NAME, 0, $POS )."<input name=VOTE_DATA_".$ITEM_ID."_".$COUNT++." type=text size=5 class=SmallInput number=true>".parseitemname( substr( $ITEM_NAME, $POS + 8 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 10 ) == "{textarea}" )
{
return substr( $ITEM_NAME, 0, $POS )."<textarea name=VOTE_DATA_".$ITEM_ID."_".$COUNT++." cols=45 rows=5 class=SmallInput></textarea>".parseitemname( substr( $ITEM_NAME, $POS + 10 ), $ITEM_ID, $COUNT );
}
return substr( $ITEM_NAME, 0, $POS + 1 ).parseitemname( substr( $ITEM_NAME, $POS + 1 ), $ITEM_ID );
}
function ParseItemName2( $ITEM_NAME, $ITEM_ID )
{
global $SURVEY_ID;
$POS = strpos( $ITEM_NAME, "<" );
if ( $POS === FALSE )
{
return $ITEM_NAME;
}
if ( substr( $ITEM_NAME, $POS, 6 ) == "<input" )
{
$ITEM_NAME1 = substr( $ITEM_NAME, $POS + 6 );
$POS1 = strpos( $ITEM_NAME1, ">" ) + 1;
return substr( $ITEM_NAME, 0, $POS )." 单行输入框 ".parseitemname2( substr( $ITEM_NAME1, $POS1 ), $ITEM_ID );
}
if ( substr( $ITEM_NAME, $POS, 9 ) == "<textarea" )
{
$ITEM_NAME1 = substr( $ITEM_NAME, $POS + 9 );
$POS1 = strpos( $ITEM_NAME1, "<" );
if ( substr( $ITEM_NAME1, $POS1, 11 ) == "</textarea>" )
{
$POS1 += 11;
}
return substr( $ITEM_NAME, 0, $POS )." 多行输入框 ".parseitemname2( substr( $ITEM_NAME1, $POS1 ), $ITEM_ID );
}
return substr( $ITEM_NAME, 0, $POS + 1 ).parseitemname2( substr( $ITEM_NAME1, $POS1 ), $ITEM_ID );
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$SURVEY_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FROM_ID = $ROW['FROM_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$ANONYMITY = $ROW['ANONYMITY'];
$VIEW_PRIV = $ROW['VIEW_PRIV'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$READERS = $ROW['READERS'];
if ( $END_DATE == "0000-00-00" )
{
$END_DATE = "";
}
$SUBJECT = htmlspecialchars( $SUBJECT );
$CONTENT = htmlspecialchars( $CONTENT );
$CONTENT1 = nl2br( $CONTENT );
$query1 = "SELECT * from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name( $DEPT_ID );
}
}
echo "<html>\r\n<head>\r\n<title>查看</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction IsNumber(str)\r\n{\r\n return str.match(/^[0-9]*\$/)!=null;\r\n}\r\n\r\nfunction CheckForm()\r\n{\r\n var voteArray=document.form1.SURVEY_IDS.value.split(\",\");\r\n for(i=0; i<voteArray.length;i++)\r\n {\r\n var obj=document.all(\"VOTE\"+voteArray[i]);\r\n if(!obj)\r\n continue;\r\n \r\n for(j=0;j< obj.length;j++)\r\n { \r\n \t if(obj.item(j).checked)\r\n \t break;\r\n }\r\n \r\n if(j==obj.length)\r\n {\r\n \t alert(\"请选择每个问题！\");\r\n return (false);\r\n }\r\n }\r\n \r\n for(i=0; i< document.form1.elements.length; i++)\r\n {\r\n if(document.form1.elements(i).name.substr(0,10)!=\"VOTE_DATA_\")\r\n continue;\r\n \r\n var name_array=document.form1.elements(i).name.split(\"_\");\r\n var item = document.getElementById(\"ITEM\"+name_array[2]);\r\n if(item && (item.type==\"radio\" || item.type==\"checkbox\") && !item.checked)\r\n continue;\r\n \r\n if(document.form1.elements(i).value==\"\")\r\n {\r\n alert(\"所有项目都必填！\");\r\n document.form1.elements(i).focus();\r\n return false;\r\n }\r\n \r\n if(document.form1.elements(i).number && !IsNumber(document.form1.elements(i).value))\r\n {\r\n alert(\"请输入数字！\");\r\n document.form1.elements(i).focus();\r\n return false;\r\n }\r\n }\r\n \r\n document.form1.submit();\r\n}\r\n\r\nfunction AddValue(survey_id,item_id,max_num)\r\n{\r\n var item_id_str=document.form1.ITEM_ID.value;\r\n if(document.all(\"ITEM\"+item_id).type==\"checkbox\" && max_num>0)\r\n {\r\n checked_count=0;\r\n for (i=0; i< document.all(\"VOTE\"+survey_id).length; i++)\r\n {\r\n if(document.all(\"VOTE\"+survey_id).item(i).checked)\r\n checked_count++;\r\n if(checked_count>max_num)\r\n {\r\n alert(\"最多只能选择\"+max_num+\"项！\");\r\n document.all(\"ITEM\"+item_id).checked=false;\r\n return;\r\n }\r\n }\r\n }\r\n else if(document.all(\"ITEM\"+item_id).type==\"radio\")\r\n {\r\n for (i=0; i< document.all(\"VOTE\"+survey_id).length; i++)\r\n {\r\n var radio_id = document.all(\"VOTE\"+survey_id).item(i).value;\r\n if(item_id_str.indexOf(radio_id+\",\")==0)\r\n \t item_id_str=item_id_str.replace(radio_id+\",\",\"\");\r\n else if(item_id_str.indexOf(\",\"+radio_id+\",\")>0)\r\n \t item_id_str=item_id_str.replace(\",\"+radio_id+\",\",\",\");\r\n }\r\n }\r\n \r\n if(item_id_str.indexOf(item_id+\",\")==0)\r\n \t item_id_str=item_id_str.replace(item_id+\",\",\"\");\r\n else if(item_id_str.indexOf(\",\"+item_id+\",\")>0)\r\n \t item_id_str=item_id_str.replace(\",\"+item_id+\",\",\",\");\r\n else\r\n item_id_str+=item_id+\",\";\r\n\r\n document.form1.ITEM_ID.value=item_id_str;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
if ( $FROM_ID == "" )
{
message( "", "尚未定义调查项" );
exit( );
}
echo "<script>\r\nfunction view_result()\r\n{\r\n";
if ( $VIEW_PRIV == "0" && !find_id( $READERS, $LOGIN_USER_ID ) )
{
echo "alert(\"填写后才能查看调查结果！\");";
}
else
{
echo "location=\"show_reader.php?SURVEY_ID=";
echo $SURVEY_ID;
echo "\";";
}
echo "}\r\n</script>\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big3\" align=\"center\">";
echo $SUBJECT;
echo "</td>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td align=\"right\" class=\"small1\">发布人：<u title=\"部门：";
echo $DEPT_NAME;
echo "\" style=\"cursor:hand\">";
echo $FROM_NAME;
echo "</u>\r\n";
if ( $END_DATE != "" )
{
echo " 有效期：";
echo $BEGIN_DATE;
echo "至";
echo $END_DATE;
}
else
{
echo " 发布日期：";
echo $BEGIN_DATE;
}
echo "</td>\r\n </tr>\r\n</table>\r\n <table class=\"TableBlock\" width=\"100%\" align=\"center\">\r\n<form name=\"form1\" method=\"post\" action=\"survey.php\">\r\n";
$query = "SELECT count(*) from TRAIN_SURVEY_ITEM where SURVEY_ID=".$SURVEY_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_COUNT = $ROW[0];
}
if ( 0 < $ITEM_COUNT )
{
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$SURVEY_ID." or PARENT_ID={$SURVEY_ID} order by ORDER_NO,SEND_TIME";
}
else
{
$query = "SELECT * from TRAIN_SURVEY_TITLE where PARENT_ID=".$SURVEY_ID." order by ORDER_NO,SEND_TIME";
}
$cursor2 = exequery( $connection, $query );
$EXCEL_OUT = "";
$ITEM_COUNT = 0;
while ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
++$ITEM_COUNT;
$SURVEY_ID1 = $ROW2['SURVEY_ID'];
$SUBJECT = $ITEM_COUNT."、".$ROW2['SUBJECT'];
$CONTENT = $ROW2['CONTENT'];
$TYPE = $ROW2['TYPE'];
$MAX_NUM = $ROW2['MAX_NUM'];
$SURVEY_IDS .= $SURVEY_ID1.",";
$SUBJECT = htmlspecialchars( $SUBJECT );
$CONTENT = htmlspecialchars( $CONTENT );
$CONTENT = nl2br( $CONTENT );
if ( $TYPE == "0" )
{
$TYPE_DESC = "radio";
}
else
{
$TYPE_DESC = "checkbox";
}
if ( $ITEM_COUNT == 1 && $CONTENT1 != "" )
{
echo " <tr class=\"TableHeader\">\r\n <td align=\"center\">调查描述</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>";
echo $CONTENT1;
echo "</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableHeader\">\r\n <td>";
echo $SUBJECT;
echo "</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>";
echo $CONTENT;
$EXCEL_OUT .= $SUBJECT."\n";
if ( $TYPE == "0" || $TYPE == "1" )
{
$query = "SELECT * from TRAIN_SURVEY_ITEM where SURVEY_ID=".$SURVEY_ID1." order by ITEM_ID";
$cursor = exequery( $connection, $query );
$NO = 65;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = chr( $NO++ )."、".$ROW['ITEM_NAME'];
$ITEM_NAME = parseitemname( $ITEM_NAME, $ITEM_ID );
$TEM_ITEM_NAME = parseitemname2( $ITEM_NAME, $ITEM_ID );
echo " <input name=\"VOTE";
echo $SURVEY_ID1;
echo "\" id=\"ITEM";
echo $ITEM_ID;
echo "\" type=\"";
echo $TYPE_DESC;
echo "\" value=\"";
echo $ITEM_ID;
echo "\" onclick=\"AddValue('";
echo $SURVEY_ID1;
echo "','";
echo $ITEM_ID;
echo "',";
echo $MAX_NUM;
echo ");\"><label for=\"ITEM";
echo $ITEM_ID;
echo "\"> ";
echo $ITEM_NAME;
echo "</label><br>\r\n";
$EXCEL_OUT .= " ".$CONTENT.",".$TEM_ITEM_NAME."\n";
}
}
else
{
echo " <textarea name=\"VOTE_DATA_";
echo $SURVEY_ID1;
echo "_0\" cols=\"45\" rows=\"5\"></textarea>\r\n";
}
echo " </td>\r\n </tr>\r\n";
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\">\r\n";
if ( !find_id( $READERS, $LOGIN_USER_ID ) )
{
echo " <input type=\"button\" value=\"提交\" class=\"BigButton\" onClick=\"CheckForm();\"> \r\n";
}
if ( $VIEW_PRIV != "2" )
{
echo " <input type=\"button\" value=\"查看结果\" class=\"BigButton\" onClick=\"view_result();\"> \r\n";
}
session_start( );
$MY_EXCEL_OUT = $EXCEL_OUT;
if ( !session_is_registered( "MY_EXCEL_OUT" ) )
{
session_register( "MY_EXCEL_OUT" );
}
echo " <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"javascript:window.close();\"> \r\n <input type=\"button\" class=\"BigButton\" value=\"导出\" onclick=\"location='export.php'\" title=\"导出调查问卷\">\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n <input name=\"ITEM_ID\" type=\"hidden\" value=\"\">\r\n <input name=\"SURVEY_ID\" type=\"hidden\" value=\"";
echo $SURVEY_ID;
echo "\">\r\n <input name=\"SURVEY_IDS\" type=\"hidden\" value=\"";
echo $SURVEY_IDS;
echo "\">\r\n <input name=\"ANONYMITY\" type=\"hidden\" value=\"";
echo $ANONYMITY;
echo "\">\r\n</form>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -