choose.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" );
require( "../inc/cfunctions.php" );
$varnames = array( "action", "uid", "sid", "cs", "sortmethod", "sortdesc", "start" );
setvars( $varnames );
setlanguage( "", "ADMIN" );
$imgurl = $phpQImageDir;
if ( $action == "delete" && $uid && $sid )
{
	$qstring = "delete from phpQUser where UID = \"".protectmysql( $uid )."\" and SID = \"".protectmysql( $sid )."\"";
	$success = mysql_query( $qstring );
	$qstring = "delete from phpQAnswer where UID = \"".protectmysql( $uid )."\" and SID = \"".protectmysql( $sid )."\"";
	$success = mysql_query( $qstring ) ? $success : false;
	$message = $success ? sprintf( $phpQlang['DeleteResultSuccess'], $uid ) : sprintf( $phpQlang['DeleteResultError'], $uid );
}
$message = $message ? "<B>".$phpQlang['Status'].":</B> ".$message : "<IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\">";
$caslabel = $phpQlang['ChooseASurvey'];
$sslabel = $phpQlang['SelectSurvey'];
$contents = "\r\n<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<FORM NAME=chooseform ACTION=survey.php METHOD=POST>\r\n<TR>\r\n\t<TD>\r\n\t<TABLE>\r\n\t<TR>\r\n\t\t<TD>{$sslabel}:</TD>\r\n\t\t<TD><SELECT NAME=choosesurvey CLASS=huge ONCHANGE=\"ChangeSurvey()\">\r\n";
$mqsurvey = mysql_query( "select * from phpQSurvey order by AddDate desc, Name" );
while ( $masurvey = mysql_fetch_array( $mqsurvey ) )
{
	$surveylist[] = $masurvey;
}
if ( 0 < sizeof( $surveylist ) )
{
	$contents .= "<OPTION VALUE=0>".$phpQlang['NoSurveySelected'];
	$i = 0;
	for ( ;	$i < sizeof( $surveylist );	++$i	)
	{
		if ( $surveylist[$i]['SID'] == $cs )
		{
			$emailconfirm = substr( $surveylist[$i]['SurveyUsers'], 2, 1 ) ? true : false;
			$selected = "SELECTED";
		}
		else
		{
			$selected = "";
		}
		$svname = 50 < strlen( $surveylist[$i]['Name'] ) ? substr( $surveylist[$i]['Name'], 0, 50 )."..." : $surveylist[$i]['Name'];
		$text = substr( $surveylist[$i]['AddDate'], 0, 10 ).": {$svname}";
		$contents .= "<OPTION {$selected} VALUE=".$surveylist[$i]['SID'].">".protecthtml( $text );
	}
}
else
{
	$contents .= "<OPTION VALUE=0>".$phpQlang['NoSurveyInDatabase'];
}
$contents .= "\r\n\t\t\t</SELECT>\r\n\t\r\n";
if ( $emailconfirm )
{
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('a')\" VALUE=\"".$phpQlang['AllResults']."\" class=\"SmallButton\"> ";
}
else
{
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('a')\" VALUE=\"".$phpQlang['ViewResults']."\" class=\"SmallButton\"> ";
}
$contents .= "\r\n\t\t</TD>\r\n\t</TR>\r\n\t</TABLE>\r\n\t</TD>\r\n</TR>\r\n</FORM>\r\n</TABLE>\r\n";
if ( $cs )
{
	$sortmethod = $sortmethod ? $sortmethod : "date";
	$sortdesc = $sortdesc == "d" || $sortdesc == "a" ? $sortdesc : $sortmethod == "date" ? "d" : "a";
	$start = 0 < $start ? $start : 0;
	$limit = $phpQAdmin['SummaryLimit'] ? $phpQAdmin['SummaryLimit'] : 10;
	$summary = retrievesummary( $cs, summaryquestions( $cs ), $sortmethod, $sortdesc, $start, $limit );
	$dllabel = $phpQlang['DownloadResults'];
	if ( $emailconfirm )
	{
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('{$cs}', 'a')\" VALUE=\"".$phpQlang['AllResults']."\" class=\"SmallButton\"> ";
	}
	else
	{
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('{$cs}', 'a')\" VALUE=\"{$dllabel}\" class=\"SmallButton\"> ";
	}
	$helpalt = $phpQlang['?'];
	$summaryalt = $phpQlang['SurveySummary'];
	$fflabel = $phpQlang['FileFormat'];
	$csvlabel = $phpQlang['CSVName'];
	$xmllabel = $phpQlang['XMLName'];
	$xmlclabel = $phpQlang['XMLCName'];
	$sqllabel = $phpQlang['SQLName'];
	$pexlabel = $phpQlang['PEXName'];
	$phpqlabel = $phpQlang['PHPQName'];
	$contents .= "\r\n<BR>\r\n<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<TR><TD BACKGROUND=\"images/border.gif\"><IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD></TR>\r\n</TABLE>\r\n<BR>\r\n\r\n<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<FORM NAME=result>\r\n<TR>\r\n\t<TD>\r\n\t\t<TABLE>\r\n\t\t<TR>\r\n\t\t\t<TD> {$fflabel}:</TD>\r\n\t\t\t<TD></TD>\r\n\t\t\t<TD><SELECT NAME=chooseresult CLASS=huge>\r\n\t\t\t\t<OPTION VALUE=\"csv\">{$csvlabel}\r\n\t\t\t\t</SELECT>\r\n\t\t{$dlresults}</TD>\r\n\t\t</TR>\r\n\t\t</TABLE>\r\n\t</TD>\r\n</TR>\r\n</FORM>\r\n</TABLE>\r\n\r\n<BR>\r\n<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<TR><TD BACKGROUND=\"images/border.gif\"><IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD></TR>\r\n</TABLE>\r\n<BR>\r\n\r\n<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<TR>\r\n\t<TD>调查表摘要</TD>\r\n</TR>\r\n<TR>\r\n\t<TD ALIGN=center>{$summary}</TD>\r\n</TR>\r\n</TABLE>\r\n";
}
$contents .= "<BR>\r\n<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\r\n<TR><TD BACKGROUND=\"images/border.gif\"><IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD></TR>\r\n</TABLE>";
createpage( "choose", $phpQlang['AdminTitle']." :: ".$phpQlang['SurveyResultsTitle'], $contents, true, "jschoose.php" );
?>