📄 show_reader.php
字号:
<?php
function ParseItemName( $ITEM_NAME, $ITEM_ID, $COUNT = 1 )
{
global $SURVEY_ID;
$POS = strpos( $ITEM_NAME, "{" );
if ( $POS === FALSE )
{
return $ITEM_NAME;
}
if ( substr( $ITEM_NAME, $POS, 6 ) == "{text}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"javascript:survey_data(".$SURVEY_ID.",'INPUT_ITEM_".$ITEM_ID."_".$COUNT++."')\" style=\"text-decoration: underline;\">？？？</a>".parseitemname( substr( $ITEM_NAME, $POS + 6 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 8 ) == "{number}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"javascript:survey_data(".$SURVEY_ID.",'INPUT_ITEM_".$ITEM_ID."_".$COUNT++."')\" style=\"text-decoration: underline;\">？？？</a>".parseitemname( substr( $ITEM_NAME, $POS + 8 ), $ITEM_ID, $COUNT );
}
if ( substr( $ITEM_NAME, $POS, 10 ) == "{textarea}" )
{
return substr( $ITEM_NAME, 0, $POS )."<a href=\"javascript:survey_data(".$SURVEY_ID.",'INPUT_ITEM_".$ITEM_ID."_".$COUNT++."')\" style=\"text-decoration: underline;\">？？？</a>".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 ) == "<a hre" )
{
$ITEM_NAME1 = substr( $ITEM_NAME, $POS + 6 );
$POS1 = strpos( $ITEM_NAME1, "<" );
if ( substr( $ITEM_NAME1, $POS1, 4 ) == "</a>" )
{
$POS1 += 4;
}
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" );
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</head>\r\n<script>\r\nfunction survey_data(survey_id, item_pos)\r\n{\r\n URL=\"survey_data.php?SURVEY_ID=\"+survey_id+\"#\"+item_pos;\r\n myleft=(screen.availWidth-300)/2;\r\n window.open(URL,\"survey_data\",\"height=300,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=250,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID=".$SURVEY_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$ANONYMITY = $ROW['ANONYMITY'];
$READERS = $ROW['READERS'];
$CONTENT = $ROW['CONTENT'];
$CONTENT = str_replace( "\n", "<br>", $CONTENT );
$TO_ID = $ROW['TO_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$USER_ID = $ROW['USER_ID'];
$TOK = strtok( $READERS, "," );
$USER_NAME1 = "";
$COUNT1 = 0;
while ( $TOK != "" )
{
if ( $USER_NAME1 != "" )
{
$USER_NAME1 .= "，";
}
$query1 = "SELECT * from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
++$COUNT1;
$USER_NAME1 .= $ROW1['USER_NAME'];
}
$TOK = strtok( "," );
}
if ( $TO_ID != "" )
{
if ( $TO_ID == "ALL_DEPT" )
{
$query1 = "SELECT * from USER where NOT_LOGIN='0'";
$cursor1 = exequery( $connection, $query1 );
$COUNT2 = 0;
$USER_NAME2 = "";
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
if ( !find_id( $READERS, $ROW1['USER_ID'] ) )
{
++$COUNT2;
$USER_NAME2 .= $ROW1['USER_NAME']."，";
}
}
}
else
{
$COUNT2 = 0;
$USER_NAME2 = "";
$TOK = strtok( $TO_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT * from USER where DEPT_ID='".$TOK."' and NOT_LOGIN='0'";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
if ( !find_id( $READERS, $ROW1['USER_ID'] ) )
{
$USER_ID2 .= $ROW1['USER_ID'].",";
++$COUNT2;
$USER_NAME2 .= $ROW1['USER_NAME']."，";
}
}
$TOK = strtok( "," );
}
}
}
}
if ( $PRIV_ID != "" && $TO_ID != "ALL_DEPT" )
{
$COUNT3 = 0;
$USER_NAME3 = "";
$TOK = strtok( $PRIV_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT * from USER where USER_PRIV='".$TOK."' and NOT_LOGIN='0'";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
if ( !find_id( $READERS, $ROW1['USER_ID'] ) )
{
if ( find_id( $USER_ID2, $ROW1['USER_ID'] ) )
{
break;
}
}
else
{
continue;
}
++$COUNT3;
$USER_ID3 .= $ROW1['USER_ID'].",";
$USER_NAME3 .= $ROW1['USER_NAME']."，";
}
$TOK = strtok( "," );
}
}
if ( $USER_ID != "" && $TO_ID != "ALL_DEPT" )
{
$COUNT4 = 0;
$USER_NAME4 = "";
$TOK = strtok( $USER_ID, "," );
while ( $TOK != "" )
{
$query1 = "SELECT * from USER where USER_ID='".$TOK."' and NOT_LOGIN='0'";
$cursor1 = exequery( $connection, $query1 );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
if ( !find_id( $READERS, $ROW1['USER_ID'] ) )
{
if ( !find_id( $USER_ID2, $ROW1['USER_ID'] ) )
{
if ( find_id( $USER_ID3, $ROW1['USER_ID'] ) )
{
break;
if ( find_id( $USER_ID3, $ROW1['USER_ID'] ) )
{
break;
}
}
}
}
else
{
continue;
}
++$COUNT4;
$USER_ID4 .= $ROW1['USER_ID'].",";
$USER_NAME4 .= $ROW1['USER_NAME']."，";
}
$TOK = strtok( "," );
}
}
$USER_NAME_STR = $USER_NAME2.$USER_NAME3.$USER_NAME4;
$USER_NAME_STR = csubstr( $USER_NAME_STR, 1, strlen( $USER_NAME_STR ) - 2 );
$TOTAL_COUNT = $COUNT2 + $COUNT3 + $COUNT4;
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/training.gif\" align=\"absmiddle\"><span class=\"big3\"> 调查结果 - ";
echo $SUBJECT;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<table width=\"95%\" align=\"center\" class=\"TableBlock\">\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 );
$ITEM_COUNT = 0;
$EXCEL_OUT = "";
while ( $ROW2 = mysql_fetch_array( $cursor2 ) )
{
++$ITEM_COUNT;
$SURVEY_ID = $ROW2['SURVEY_ID'];
$TYPE = $ROW2['TYPE'];
$SUBJECT = $ITEM_COUNT."、".$ROW2['SUBJECT'];
$SUBJECT = str_replace( ",", "，", $SUBJECT );
$EXCEL_OUT .= $SUBJECT."\n";
if ( $ITEM_COUNT == 1 && $CONTENT != "" )
{
echo " <tr class=\"TableHeader\">\r\n <td colspan=\"4\" align=\"center\">调查描述</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td colspan=\"4\">";
echo $CONTENT;
echo "</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableHeader\">\r\n <td colspan=\"4\">";
echo $SUBJECT;
echo "</td>\r\n </tr>\r\n";
if ( $TYPE == 0 || $TYPE == 1 )
{
$query = "SELECT sum(SURVEY_COUNT),max(SURVEY_COUNT) from TRAIN_SURVEY_ITEM where SURVEY_ID=".$SURVEY_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUM_COUNT = $ROW[0];
$MAX_COUNT = $ROW[1];
}
if ( $SUM_COUNT == 0 )
{
$SUM_COUNT = 1;
}
$query = "SELECT * from TRAIN_SURVEY_ITEM where SURVEY_ID=".$SURVEY_ID." order by ITEM_ID";
$cursor = exequery( $connection, $query );
$NO = 65;
do
{
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = chr( $NO++ )."、".$ROW['ITEM_NAME'];
$SURVEY_COUNT = $ROW['SURVEY_COUNT'];
$SURVEY_USER = $ROW['SURVEY_USER'];
$ITEM_NAME = parseitemname( $ITEM_NAME, $ITEM_ID );
$ITEM_NAME2 = parseitemname2( $ITEM_NAME, $ITEM_ID );
$ITEM_NAME2 = str_replace( ",", "，", $ITEM_NAME2 );
$SURVEY_USER_NAME = "";
if ( $ANONYMITY == "0" )
{
$query = "SELECT * from USER where find_in_set(USER_ID,'".$SURVEY_USER."')";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$SURVEY_USER_NAME .= $ROW1['USER_NAME']."，";
}
$SURVEY_USER_NAME = substr( $SURVEY_USER_NAME, 0, -2 );
}
$EXCEL_OUT .= " ".$ITEM_NAME2.",".round( $SURVEY_COUNT * 100 / $SUM_COUNT )."%,".$SURVEY_COUNT."票\n";
echo " <tr class=\"TableData\">\r\n <td> ";
echo $ITEM_NAME;
echo "</td>\r\n <td width=\"240\">\r\n <table height=\"10\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr height=\"10\">\r\n <td width=\"10\" background=\"/images/vote_bg.gif\"></td>\r\n <td width=\"";
echo $SURVEY_COUNT * 200 / $MAX_COUNT;
echo "\" background=\"/images/vote_bg.gif\"></td>\r\n <td width=\"30\">";
echo round( $SURVEY_COUNT * 100 / $SUM_COUNT );
echo "%</td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td align=\"right\">";
echo $SURVEY_COUNT;
echo "票</td>\r\n <td style=\"cursor:hand\" text=\"";
echo $SURVEY_USER_NAME;
echo "\" title=\"点击显示所有投票人\" onclick=\"this.innerHTML=this.text;\">";
echo csubstr( $SURVEY_USER_NAME, 0, 30 ).( 30 < strlen( $SURVEY_USER_NAME ) ? "..." : "" );
echo "</td>\r\n </tr>\r\n";
}
} while ( 1 );
}
else
{
echo " <tr class=\"TableData\">\r\n <td colspan=\"4\">\r\n";
$query = "SELECT * from TRAIN_SURVEY_DATA where ITEM_ID='".$SURVEY_ID."' and FIELD_NAME='0'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$FIELD_DATA = $ROW['FIELD_DATA'];
$USER_NAME = "";
if ( $ANONYMITY == 0 )
{
$query = "SELECT * from USER where USER_ID='".$USER_ID."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW1['USER_NAME'];
}
}
$FIELD_DATA = htmlspecialchars( $FIELD_DATA );
$FIELD_DATA = nl2br( $FIELD_DATA );
if ( $USER_NAME != "" )
{
echo "<li>【".$USER_NAME."】";
}
echo $FIELD_DATA."</li><br>";
$FIELD_DATA = str_replace( ",", "，", $FIELD_DATA );
$EXCEL_OUT .= " ".$USER_NAME.",".$FIELD_DATA."\n";
}
echo " </td>\r\n </tr>\r\n";
}
}
echo "</table>\r\n";
if ( $FLAG == "1" )
{
$EXCEL_OUT .= "已参与调查的人员\n";
$EXCEL_OUT .= " ".$USER_NAME1.",".$COUNT1."\n";
$EXCEL_OUT .= "未参与调查的人员\n";
$EXCEL_OUT .= " ".$USER_NAME_STR.",".$TOTAL_COUNT."\n";
echo "<table class=\"TableBlock\" width=\"95%\" align=\"center\">\r\n <tr class=\"TableHeader\">\r\n <td>已参与调查的人员</td>\r\n <td width=\"8%\" align=\"center\">人数</td> \r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>\r\n";
if ( $USER_NAME1 == "" )
{
echo "无";
}
else
{
echo $USER_NAME1;
}
echo " </td>\r\n <td width=\"8%\" align=\"center\"><b>";
echo $COUNT1;
echo "</b></td>\r\n </tr>\r\n <tr class=\"TableHeader\">\r\n <td colspan=\"2\">未参与调查的人员</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>\r\n";
if ( $USER_NAME_STR == "" )
{
echo "无";
}
else
{
echo $USER_NAME_STR;
}
echo " \t\r\n </td>\r\n <td width=\"8%\" align=\"center\"><b>";
echo $TOTAL_COUNT;
echo "</b></td>\r\n </tr>\r\n</table>\r\n";
}
session_start( );
$MY_EXCEL_OUT = $EXCEL_OUT;
if ( !session_is_registered( "MY_EXCEL_OUT" ) )
{
session_register( "MY_EXCEL_OUT" );
}
echo "<br>\r\n<div align=\"center\">\r\n";
if ( $FLAG == "1" )
{
echo " <input type=\"button\" class=\"BigButton\" value=\"导出\" onclick=\"location='export.php'\" title=\"导出调查结果\"> \r\n";
}
echo " <input type=\"button\" class=\"BigButton\" value=\"关闭\" onclick=\"window.close();\">\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -