surveyresult.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

$GLOBALS['inAdmin'] = 1;
require( "../inc/init.php" );
require( "../inc/mysql.php" );
require( "../inc/functions.php" );
require( "../inc/pfunctions.php" );
$varnames = array( "logoff", "phpQpasswd", "cs" );
setvars( $varnames );
setlanguage( "", "ADMIN" );
$imgurl = $phpQImageDir;
$overviewtitle = $phpQlang['OverviewTitle'];
$version = $PHPQVERSION;
$contents = "<TABLE CELLPADDING=3 CELLSPACING=1 BORDER=0 width=100% class=small>\r\n<tr class=TableHeader>\r\n<td width=5%>状态</td>\r\n<td width=60%>调查表名称</td>\r\n</tr>";
$scriptloc = "";
if ( $HTTP_HOST != "" )
{
	$scriptloc .= "http://{$HTTP_HOST}";
}
else if ( $HTTP_SERVER_VARS['HTTP_HOST'] != "" )
{
	$scriptloc .= "http://".$HTTP_SERVER_VARS['HTTP_HOST'];
}
$php_self = $PHP_SELF ? $PHP_SELF : $HTTP_SERVER_VARS['PHP_SELF'];
if ( !$php_self && $HTTP_SERVER_VARS['REQUEST_URI'] )
{
	$php_self = $HTTP_SERVER_VARS['REQUEST_URI'];
}
$scriptloc .= $php_self;
$scriptloc = preg_replace( "/(.*)\\/.*/", "\\1", $scriptloc );
$scriptloc = preg_replace( "/(.*)\\/.*/", "\\1", $scriptloc );
$qstring = "select *, ";
$qstring .= "date_format(StartDate, '".$phpQlang['MySQLDateFormat']."') as FStartDate, ";
$qstring .= "date_format(EndDate, '".$phpQlang['MySQLDateFormat']."') as FEndDate, ";
$qstring .= "(now() < StartDate) as Pending, (now() > EndDate) as Expired ";
$qstring .= "from phpQSurvey where ";
$qstring .= " ((InStr(DEPT_ID,'".$_SESSION['LOGIN_DEPT_ID']."') or DEPT_ID = 'ALL_DEPT')";
$qstring .= " or CREATOR = '".$_SESSION['LOGIN_USER_ID']."') and Active = 'y' and ";
$qstring .= " ((now() > StartDate and now() < EndDate) or";
$qstring .= " ( EndDate = '0000-00-00' )) order by AddDate DESC";
$mqsurvey = mysql_query( $qstring );
$FLOW_COUNT = 0;
while ( $masurvey = mysql_fetch_array( $mqsurvey ) )
{
	$mqresponse = mysql_query( "select count(*) as ct from phpQUser where SID = \"".protectmysql( $masurvey['SID'] )."\"" );
	$responsect = 0;
	if ( $maresponse = mysql_fetch_array( $mqresponse ) )
	{
		$responsect = $maresponse['ct'];
	}
	$responsemsg = $responsect == 1 ? $phpQlang['response'] : $phpQlang['responses'];
	$responsemsg = sprintf( $responsemsg, $responsect );
	$responseloc = "(<A HREF=\"../stats.php?sid=".$masurvey['SID']."&st=a&vw=a&fa=1&view=1\" CLASS=link>{$responsemsg}</A>)";
	$editloc = "<A HREF=\"survey.php?cs=".$masurvey['SID']."\" ";
	$editloc .= ">编辑</A>";
	$editsurveyloc = "<a href='#' onclick=\"EditSurvey('question.php?cs=".$masurvey['SID']."')\">设置调查项</a>";
	$previewloc = "<A HREF=\"".$scriptloc."/fillsurvey.php?sid=".$masurvey['SID']."&action=preview\" CLASS=link ";
	$previewloc .= "TARGET=_new >预览</A>";
	$deleteloc = "<a HREF='#' onclick=\"DeleteSurvey('survey.php?cs=".$masurvey['SID']."&action=delete&deleteid=".$masurvey['SID']."')\">删除</a>";
	$active = $masurvey['Active'] == "y" ? $phpQlang['Deactivate'] : $phpQlang['Activate'];
	$activate = $masurvey['Active'] == "y" ? "off" : "on";
	$activeloc = "<a href='#' ONCLICK=\"ActivateSurvey('".$activate."','survey.php?activateid=".$masurvey['SID']."&action=activate')\">{$active}</a>";
	$svname = 30 < strlen( $masurvey['Name'] ) ? substr( $masurvey['Name'], 0, 30 )."..." : $masurvey['Name'];
	$surveyloc = $scriptloc."/fillsurvey.php?sid=".$masurvey['SID'];
	if ( $masurvey['Active'] == "y" )
	{
		if ( $masurvey['Pending'] && substr( $masurvey['StartDate'], 0, 10 ) != "0000-00-00" )
		{
			$activeimg = "<IMG SRC=\"/images/email_close.gif\"  ALT=\"".$phpQlang['Pending']."\">";
			$activebtn = "<IMG SRC=\"{$imgurl}/buttonpending.gif\" WIDTH=13 HEIGHT=13 ALT=\"\">";
		}
		else if ( $masurvey['Expired'] && substr( $masurvey['EndDate'], 0, 10 ) != "0000-00-00" )
		{
			$activeimg = "<IMG SRC=\"/images/tablemanage.gif\"  ALT=\"".$phpQlang['Expired']."\" width=17 height=15>";
			$activebtn = "<IMG SRC=\"{$imgurl}/buttonpending.gif\" WIDTH=13 HEIGHT=13 ALT=\"\">";
		}
		else
		{
			$activeimg = "<IMG SRC=\"/images/email_close.gif\"  ALT=\"".$phpQlang['Active']."\">";
			$activebtn = "<IMG SRC=\"{$imgurl}/buttonactive.gif\" WIDTH=13 HEIGHT=13 ALT=\"\">";
		}
	}
	else
	{
		$activeimg = "<IMG SRC=\"/images/email_open.gif\"  ALT=\"".$phpQlang['NotActive']."\">";
		$activebtn = "<IMG SRC=\"{$imgurl}/buttondeactive.gif\" WIDTH=13 HEIGHT=13 ALT=\"\">";
	}
	$editorloc = "<A HREF=\"{$surveyloc}\" CLASS=link TARGET=_new>";
	$editorloc .= $svname."</A>";
	++$FLOW_COUNT;
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	$contents .= "<TR class=".$TableLine.">";
	$contents .= "<TD>{$activeimg}</TD>";
	$contents .= "<TD><NOBR>{$editorloc}</NOBR>{$responseloc}</TD>";
	$contents .= "</TR>";
	$sdtest = true;
	$edtest = true;
	if ( $masurvey['Active'] == "y" && ( $sdtest || $edtest ) )
	{
		$contents .= "<TR>";
		$contents .= "<TD></TD>";
		$contents .= "<TD><B><NOBR>".$phpQlang['ActiveDates']."</B>:</NOBR>";
		if ( $sdtest && !$edtest )
		{
			$contents .= "".sprintf( $phpQlang['StartsOn'], $masurvey['StartDate'] )."";
		}
		else if ( !$sdtest && $edtest )
		{
			$contents .= "".sprintf( $phpQlang['EndsOn'], $masurvey['EndDate'] )."";
		}
		else
		{
			$contents .= "".sprintf( $phpQlang['RunsBetween'], $masurvey['StartDate'], $masurvey['EndDate'] )."";
		}
		$contents .= "</TD></TR>";
	}
	if ( !( $masurvey['Active'] == "y" ) && !$masurvey['SurveyResults'] )
	{
		$statsloc = $scriptloc."/stats.php?sid=".$masurvey['SID'];
		$contents .= "<TR>";
		$contents .= "<TD COLSPAN=2 ALIGN=right><NOBR><B>".$phpQlang['PublicResults']."</B>:</NOBR></TD>";
		$contents .= "<TD><A HREF=\"{$statsloc}\" TARGET=_new CLASS=link>{$statsloc}</A></TD>";
		$contents .= "</TR>";
	}
}
$contents .= "\r\n\t</TABLE>\r\n\t\r\n";
createpage( "mainresult", $phpQlang['AdminTitle']." :: ".$phpQlang['OverviewTitle'], $contents, true, "" );
?>