/admin/count.php

<?php



/**

 * @Alex Ai swallow13@163.com

 * @copyright 2009

 *text area's name is not needed.

 */

require_once("../include/auth_t.php");

require_once("../include/config.php");

include("../include/head.htm");

include("../include/class.phpmailer.php");



$pid = $_POST['pid'];

$arr_aid = $_SESSION['aid'];

$tiankong = $_SESSION['tk'];

$jianda = $_SESSION['jd'];

$whomark = $_SESSION['cname'];



foreach ($arr_aid as $u) {

	$i = 0;

	foreach ($tiankong as $v) {

		$max = mysql_result(mysql_query("SELECT `item_score` FROM `gb_items_warehouse` WHERE `item_id` = '$v';"),0);

		$tkn = 'tk-'.$u.'-'.$v;

			

		$fen = $_POST[$tkn];

		if ($fen > $max) {

			$fen = $max;

		}

		mysql_query("UPDATE `gb_sub_answ` SET `fen` = '$fen' WHERE `id` = '$u' AND `item_id` = '$v';");

		$i = $i + $fen;

	}

	$j = 0;

	foreach ($jianda as $w) {

		$max = mysql_result(mysql_query("SELECT `item_score` FROM `gb_items_warehouse` WHERE `item_id` = '$w';"),0);

		$jdn = 'jd-'.$u.'-'.$w;

		$fen = $_POST[$jdn];

		if ($fen > $max) {

			$fen = $max;

		}

		mysql_query("UPDATE `gb_sub_answ` SET `fen` = '$fen' WHERE `id` = '$u' AND `item_id` = '$w';");

		$j = $j + $fen;

	}

	mysql_query("UPDATE `gb_answ_score` SET `score3` = '$i' WHERE `id` = '$u';");

	mysql_query("UPDATE `gb_answ_score` SET `score4` = '$j' WHERE `id` = '$u';");

	$total = mysql_result(mysql_query("SELECT `total` FROM `gb_answ_score` WHERE `id` = '$u';"),0);

	$total = $total + $i + $j;

	mysql_query("UPDATE `gb_answ_score` SET `total` = '$total' WHERE `id` = '$u';");

	mysql_query("UPDATE `gb_answer_papers` SET `status` = '1',`whomarked` = '$whomark' WHERE `id` = '$u';");	

	

	$stu_id = mysql_result(mysql_query("SELECT `stu_id` FROM `gb_answer_papers` WHERE `id` = '$u';"),0);

	$qr = mysql_query("SELECT * FROM `gb_students_tb` WHERE `stu_id` = '$stu_id';");

	$pmail = mysql_result($qr,0,email);

	$mail = new PHPMailer();

	$mail->CharSet="utf-8";

	$mail->IsSMTP();

	$mail->Host="10.11.22.25";

	$mail->Port=25;

	$mail->From = $admin_email;

	$mail->FromName = "Admin";

	$mail->SMTPAuth = true;

	$mail->Username = "aai";

	$mail->Password = "ayzfp";

	$mail->Subject = "考试成绩通知书";

	$t = getdate($_SESSION['stamp']);

	$html = mysql_result($qr,0,cname)." 于 ".$t[year]."年".$t[mon]."月".$t[mday]."日进行的考试，得分为 ".$total." 分。<br /><br />查询地址：<br /><br /><a href=".$domain.">".$domain."</a>.";

	$mail->Body = $html;

	$mail->IsHTML(true);

	$mail->WordWrap = 50;

	$mail->AddReplyTo($admin_email);

	$mail->AddAddress($pmail);

	$mail->Send();

}

$title = mysql_result(mysql_query("SELECT `paper_title` FROM `gb_papers_warehouse` WHERE `paper_id` = '$pid';"),0);

echo "<p>试卷 ".$title." 批改完成！</p>";

echo "<p><a href=list_unmark_papers.php>继续批阅</a></p>";

unset($_SESSION['aid'],$_SESSION['tk'],$_SESSION['jd']);

mysql_close($con);

include_once("../include/daohang.htm");

?>

</body>

</html>