sfunctions.php

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

			if ( !$barwidth )
			{
				$barwidth = 1;
			}
			if ( $countarray[$k] )
			{
				if ( $admin )
				{
					$answertext[$k] = preg_replace( "/<!--javascript:([^\\-]+)-->/", "<A HREF=\"javascript:\$1\">".$phpQlang['TextfieldResultsLink']."</A>", $answertext[$k] );
				}
				else
				{
					$answertext[$k] = preg_replace( "/<!--javascript:([^\\-]+)-->/", "<A HREF=\"javascript:\$1\"  STYLE=\"".$masurvey['ResultsAnswer']."\"><NOBR>".$phpQlang['TextfieldResultsLink']."</NOBR></A>", $answertext[$k] );
				}
			}
			$contents .= $answertext[$k];
			$contents .= "<TR class=TableLine2>{$leftborderr}";
			if ( $admin )
			{
				$contents .= "<TD  ALIGN=right>".$countarray[$k]."&nbsp;({$percent}%)&nbsp;</TD>";
				$contents .= "<TD  WIDTH={$barsize}><IMG SRC=\"admin/images/bar.gif\" WIDTH={$barwidth} HEIGHT=8 ALT=\"\"></TD>";
			}
			else
			{
				$contents .= "<TD ALIGN=right STYLE=\"".$masurvey['ResultsStats']."\" class=TableLine2>".$countarray[$k]."&nbsp;({$percent}%)&nbsp;</TD>";
				$contents .= "<TD STYLE=\"".$masurvey['ResultsStats']."\" WIDTH={$barsize}><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0><TR><TD STYLE=\"".$masurvey['ResultsGraph']."\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH={$barwidth} HEIGHT=1 ALT=\"\"></TD></TR></TABLE></TD>";
			}
			$contents .= "{$rightborderr}</TR>\n";
			break;
		}
	case "textfield" :
	case "textarea" :
		$validanswer = array( );
		if ( $stattype == "u" || $stattype == "v" )
		{
			$cletter = $stattype == "u" ? "n" : "y";
			$query = "SELECT COUNT(*) as num FROM phpQAnswer,phpQUser WHERE phpQAnswer.SID = \"".protectmysql( $sid )."\" and phpQAnswer.QID = \"".protectmysql( $qid )."\" and phpQAnswer.UID=phpQUser.UID and phpQAnswer.Answer != '' AND phpQUser.EmailConfirm = \"{$cletter}\"";
		}
		else
		{
			$query = "SELECT COUNT(*) as num FROM phpQAnswer WHERE SID = \"".protectmysql( $sid )."\" and QID = \"".protectmysql( $qid )."\" and Answer != ''";
		}
		$mqtnum = mysql_query( $query );
		$matnum = mysql_fetch_array( $mqtnum );
		$totalcount = $matnum['num'];
		$qclause = "";
		if ( $stattype == "u" || $stattype == "v" )
		{
			$cletter = $stattype == "u" ? "n" : "y";
			$qclause = " AND phpQUser.EmailConfirm=\"{$cletter}\"";
		}
		$qstring = "select phpQAnswer.Answer, phpQUser.UID, phpQUser.Email, phpQUser.IPAddr, date_format(phpQUser.CompleteDate, '".$phpQlang['MySQLDateFormat']."') as FDate FROM phpQAnswer,phpQUser WHERE phpQAnswer.SID = \"".protectmysql( $sid )."\" and phpQAnswer.QID = \"".protectmysql( $qid )."\" and phpQAnswer.UID=phpQUser.UID and phpQAnswer.Answer != ''{$qclause} ORDER BY phpQUser.CompleteDate DESC LIMIT {$textfieldlimit}";
		$mqtanswer = mysql_query( $qstring );
		$i = 0;
		for ( ;	$i < mysql_num_rows( $mqtanswer );	++$i	)
		{
			$matanswer = mysql_fetch_array( $mqtanswer );
			if ( $i % 2 == 1 )
			{
				$TableLine = "TableLine1";
			}
			else
			{
				$TableLine = "TableLine2";
			}
			$contents .= "<TR class=".$TableLine.">{$leftborderr}";
			if ( $admin )
			{
				$contents .= "<TD WIDTH=100%>";
			}
			else
			{
				$contents .= "<TD WIDTH=100% STYLE=\"padding-left: 5px; padding-right: 5px; ".$masurvey['ResultsStats']."\">";
			}
			$contents .= ( "<B>".( $i + 1 ) ).".</B>&nbsp;".protecthtml( $matanswer['Answer'] )."</TD>{$rightborderr}</TR>\n";
		}
		if ( !$totalcount )
		{
			if ( $admin )
			{
				$contents .= "<TR class=TableLine1>{$leftbordera}<TD  WIDTH=100%>".$phpQlang['NoResults']."</TD>{$rightbordera}</TR>";
			}
			else
			{
				$contents .= "<TR>{$leftbordera}<TD WIDTH=100% STYLE=\"padding-left: 5px; padding-right: 5px; ".$masurvey['ResultsAnswer']."\">".$phpQlang['NoResults']."</TD>{$rightbordera}</TR>";
			}
		}
		if ( !( $textfieldlimit < $totalcount ) )
		{
			break;
		}
		$style = $admin ? "color: #FFFFFF;" : $masurvey['ResultsBorder'];
		$class = $admin ? " CLASS=link" : "";
		$seemore = "&nbsp;&nbsp;<A HREF=\"javascript:ViewText({$sid},{$qid},'{$stattype}','{$admin}')\"{$class} STYLE=\"{$style}\"><B>".$phpQlang['SeeMoreLink']."</B></A>&nbsp;&nbsp;";
	}
	$contents .= "<TR class=TableLine1>";
	$contents .= "<TD></TD>";
	$contents .= "<TD ALIGN=right HEIGHT=17 COLSPAN={$tcolspan} ><NOBR><B>".$phpQlang['Total'].":</B> {$totalcount}&nbsp;&nbsp;{$seemore}</NOBR></TD></TR>";
	$contents .= "<TR><TD ALIGN=right HEIGHT=17 COLSPAN={$tcolspan} ><NOBR><B>".$phpQlang['Total'].":</B> {$totalcount}&nbsp;&nbsp;{$seemore}</NOBR></TD></TR>";
	$contents .= "</TABLE>\n";
	return $contents;
}

function tableofcontents( $masurvey, $stattype, $view, $admin )
{
	global $phpQlang;
	$sid = $masurvey['SID'];
	$tablewidth = $masurvey['ResultsWidth'] ? $masurvey['ResultsWidth'] : 500;
	$tablewidth = $admin ? 500 : $tablewidth;
	$class = $admin ? " CLASS=link" : "";
	$fa = $admin ? "&fa=1" : "";
	$qcount = 1;
	$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'];
	}
	$contents = "<TABLE CELLPADDING=3 CELLSPACING=1 BORDER=0 WIDTH=100%>\n";
	$contents .= "<TR><TD COLSPAN=3 class=TableHeader>\n";
	$contents .= $view != "n" && $_REQUEST['view'] != 1 ? "<A HREF=\"stats.php?sid={$sid}&st={$stattype}&vw=n{$fa}\"{$class}><B>".$phpQlang['TableofContents']."</B></A>" : "";
	$contents .= $view != "a" ? " <A HREF=\"stats.php?sid={$sid}&st={$stattype}&vw=a{$fa}\"{$class}><B>".$phpQlang['ViewAllQuestions']."</B></A>" : "";
	$contents .= "(共有".$responsect."人参与投票)</TD></TR>\n";
	$reqstyle = $admin ? " STYLE=\"color: red;\"" : "";
	if ( $view == "n" )
	{
		$mqquestion = mysql_query( "select * from phpQQuestion where SID = \"".protectmysql( $sid )."\" and Type != 'htmlcontent' order by SortOrder" );
		$QUEST_COUNT == 0;
		while ( $maquestion = mysql_fetch_array( $mqquestion ) )
		{
			if ( $maquestion['Type'] != "pagebreak" )
			{
				if ( $QUEST_COUNT % 2 == 1 )
				{
					$TableLine = "TableLine1";
				}
				else
				{
					$TableLine = "TableLine2";
				}
				++$QUEST_COUNT;
				$qloc = "stats.php?sid={$sid}&st={$stattype}&vw=q".$maquestion['QID'].$fa;
				$contents .= "<TR CLASS=".$TableLine."><TD VALIGN=top>";
				$contents .= $QUEST_COUNT.".";
				$contents .= "</TD>";
				$contents .= "<TD WIDTH=100%><A HREF=\"{$qloc}\"{$class}>".$maquestion['Question']."</A></TD></TR>\n";
				++$qcount;
			}
		}
	}
	$contents .= "</TABLE>\n";
	return $contents;
}

function printsubmit( $masurvey, $qcount, $cq, $sid, $stattype, $view, $admin )
{
	global $phpQlang;
	$buttonsubmit = getbutton( $masurvey, "next" );
	$fa = $admin ? "<INPUT TYPE=hidden NAME=fa VALUE=1>" : "";
	$contents = "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\n";
	$contents .= "<FORM ACTION=\"stats.php\">\n";
	$contents .= "<TR><TD ALIGN=center>{$buttonsubmit}</TD></TR>\n";
	$contents .= "<INPUT TYPE=hidden NAME=sid VALUE=\"{$sid}\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=st VALUE=\"{$stattype}\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=vw VALUE=\"{$view}\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=cq VALUE=\"{$cq}\">\n";
	$contents .= $fa;
	$contents .= "<INPUT TYPE=hidden NAME=qcount VALUE=\"{$qcount}\">\n";
	$contents .= "</FORM>\n";
	$contents .= "</TABLE>\n";
	return $contents;
}

function getbutton( $masurvey, $buttontext )
{
	global $phpQlang;
	switch ( $buttontext )
	{
	case "submit" :
		$index = "Submit";
		$text = "Submit";
		break;
	case "next" :
		$index = "Next";
		$text = "Next";
		break;
	case "results" :
		$index = "Result";
		$text = "ShowResults";
	}
	$buttonalt = $masurvey[$index."ImageText"] ? protecthtml( $masurvey[$index."ImageText"] ) : "";
	if ( $masurvey[$index."ImageSrc"] )
	{
		$buttonsrc = protecthtml( $masurvey[$index."ImageSrc"] );
		$buttonwidth = 0 < $masurvey[$index."ImageWidth"] ? "WIDTH=".protecthtml( $masurvey[$index."ImageWidth"] ) : "";
		$buttonheight = 0 < $masurvey[$index."ImageHeight"] ? "HEIGHT=".protecthtml( $masurvey[$index."ImageHeight"] ) : "";
		$button = "<INPUT TYPE=\"image\" NAME=\"{$buttontext}\" SRC=\"{$buttonsrc}\" {$buttonwidth} {$buttonheight} BORDER=0 ALT=\"{$buttonalt}\" VALUE=\"1\">";
	}
	else
	{
		$buttonwidth = 0 < $masurvey[$index."ImageWidth"] ? "width: ".protecthtml( $masurvey[$index."ImageWidth"] )."px;" : "";
		$buttonheight = 0 < $masurvey[$index."ImageHeight"] ? "height: ".protecthtml( $masurvey[$index."ImageHeight"] )."px;" : "";
		$bstyle = $buttonwidth || $buttonheight ? "style=\"{$buttonwidth} {$buttonheight}\"" : "";
		$button = "<INPUT TYPE=submit NAME=\"{$buttontext}\" VALUE=\"{$buttonalt}\" {$bstyle}>";
	}
	return $button;
}

function printborder( $admin, $tablewidth )
{
	$tablewidth = $admin ? 100 : $tablewidth;
	$border = $admin ? "<TD BACKGROUND=\"admin/images/border.gif\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD>" : "<TD><HR SIZE=1 NOSHADE></TD>";
	$contents = "<BR>\n";
	$contents .= "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=".$tablewidth."%>\n";
	$contents .= "<TR>{$border}</TR>\n";
	$contents .= "</TABLE>\n";
	$contents .= "<BR>\n";
	return $contents;
}

function printborder2( $admin )
{
	$border = $admin ? "<TD BACKGROUND=\"admin/images/border.gif\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD>" : "<TD><HR SIZE=1 NOSHADE></TD>";
	$contents .= "<TR><TD COLSPAN=3>\n";
	$contents .= "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\n";
	$contents .= "<TR>{$border}</TR>\n";
	$contents .= "</TABLE>\n";
	$contents .= "</TD></TR>\n";
	return $contents;
}

function grabtlimit( )
{
	global $phpQAdmin;
	return $phpQAdmin['TextareaLimit'] ? $phpQAdmin['TextareaLimit'] : 10;
}

?>