⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 mng_task_check.php

📁 在实际教学应用中
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<title>EasyTeacher信息技术课堂教学助手(ItAssis)教师端-作业评价</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="et.css" rel="stylesheet" type="text/css">
<script language="javascript" src="ItAssisJS/java.js"></script>
<style type="text/css">
body,td,th {font-size: 14px;}
.style1 {font-size: 12px}
</style>
</head>
<?php 	if(isset($_GET['per_page']))	$per_page=$_GET['per_page'];		else $per_page=5;?>
<body>
<table width="740"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" background="images/top_bg.jpg"><div align="left">&nbsp;&nbsp;位于：<strong class="red">作业评价</strong></div></td>
    <td width="100" background="images/top_bg.jpg"><div align="left">[<a href="#explain">说明</a>]</div></td>
  </tr>
</table>
<p>
  <?php 
	include "config.inc.php";
	include "conn.inc.php";
	include "ItAssisFC/FLib.php";
	$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);

	function List_task_table($db,$type){//作业列表
		if($type=="new"){
			$sql="	
				select grade,class,crs_id,count(grade) as num,title
				from stu,s_c_t left join course on crs_id=cid left join task on tsk_id=tid
				where view is null and sid=stu_id
				group by grade,class,title
				order BY grade,class,turn";	
				$task_title="学生作业列表";
		}else{
			$sql="	
			select grade,class,crs_id,count(grade) as num,title
			from stu,appeal,s_c_t left join course on crs_id=cid left join task on tsk_id=task.tid
			where did=\"N\" and appeal.tid=task.tid and sid=stu_id
			group by grade,class,title
			order BY grade,class,turn";	
			$task_title="作业申诉列表";
		}
		
		$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

		if(mysql_num_rows($result)>0){ 
			$grade=0;$class=0;$title="";
			$array=mysql_fetch_array($result);
			$grade=$array['grade'];$class=$array['class'];
			if(!$array['title']) $array['title']="<span class=red>已删除课程</span>";	
			
			echo "<table width=\"740\" bordercolor=\"#FFFFFF\" border=\"1\" cellspacing=\"0\" align=\"center\" bgcolor=\"#E9EEFE\">
					<tr><td colspan=\"2\">&nbsp;[<strong>$task_title</strong>]</td></tr>
					<tr bgcolor=\"#3399FF\"><td height=\"4\" colspan=\"2\"></td></tr>";

			echo "<tr><td width=\"10%\" ><div align=\"right\">".$array['grade']."(".$array['class'].")班</div></td><td width=\"90%\">";
			do{
				if(!$array['title']) $array['title']="<span class=red>已删除课程</span>";
				if($grade==$array['grade'] && $class==$array['class'])
					echo "〖<a href=".$_SERVER['PHP_SELF']."?check=$type&cid=".$array['crs_id']."&grade=".$array['grade']."&class=".$array['class']."&start_pos=0&title=".$array['title']." title=点击即可评价作业>".$array['title']."</a>〗(".$array['num']."份)&nbsp;";				
				else{
					echo "
						</td></tr>
						<tr>
						<td width=\"10%\"><div align=\"right\">".$array['grade']."(".$array['class'].")班</a></td>
						<td width=\"90%\">〖<a href=".$_SERVER['PHP_SELF']."?check=$type&cid=".$array['crs_id']."&grade=".$array['grade']."&class=".$array['class']."&start_pos=0&title=".$array['title']." title=点击即可评价作业>".$array['title']." </a>〗(".$array['num']."份)";
					$grade=$array['grade'];$class=$array['class'];
				}
			}while($array=mysql_fetch_array($result));
			echo "</td></tr></table><br>";
		}else
			echo "<p align=center>休息吧，今天没有学生交(申诉)作业。</p>";
	}//end of List_task_table

	function Show_bottom_msg(){
		echo '
		<p>
		<table width="740" align="center" border="0" cellspacing="0" cellpadding="0" #DEE3EF>
		  <tr>
			<td bgcolor="#F7F3F7"><p>&nbsp;说明： 
			  <UL>
				<LI>学生作业有两种：新提交作业 和 申诉作业。</LI>
				<LI><span class=red>关闭申诉功能</span>请在系统区［<A href="mng_system_config.php#作业评价" target=mainFrame>参数设定</A>］中设置。</LI>
			  </UL></td>
		  </tr>
		</table>';
	}

	//分课程显示待评价作业列表
	if(!isset($_POST['submit'])&&!isset($_GET['cid'])) {
		List_task_table($db,"new");
		List_task_table($db,"old");
		Show_bottom_msg();
		exit;
	}

	//作业评分______________________________________________________________
	if(isset($_POST['grade']))		$grade=$_POST['grade'];
	if(isset($_GET['grade'])) 		$grade=$_GET['grade'];
	if(isset($_POST['class'])) 		$class=$_POST['class'];
	if(isset($_GET['class'])) 		$class=$_GET['class'];
	if(isset($_POST['cid'])) 		$cid=$_POST['cid'];
	if(isset($_GET['cid'])) 		$cid=$_GET['cid'];
	if(isset($_GET['start_pos'])) 	$start_pos=$_GET['start_pos'];
	if(isset($_POST['start_pos']))	$start_pos=$_POST['start_pos'];
	if(isset($_GET['check'])) 		$check=$_GET['check'];
	if(isset($_POST['check']))		$check=$_POST['check'];
	if(isset($_GET['title'])) 		$title=$_GET['title'];
	if(isset($_POST['title']))		$title=$_POST['title'];

	if(isset($_POST['submit'])){
		$i=0;
		foreach($_POST["tid_lists"] as $tid){
			if( $check=="old" || isset($_POST["delete_lists"][$i]) && !$_POST["delete_lists"][$i] ){
				$sid=	$_POST["sid_lists"][$i];
				$value1=$_POST["value1"][$i];
				$value2=$_POST["value2"][$i];
				$value3=$_POST["value3"][$i];
				$good=	$_POST["good"][$i];
				$remark=$_POST["remark"][$i];

				if($check!="new"){//取得原来分数
					$sql="select value1,value2,value3 from task where tid=$tid";
					$result=mysql_query($sql,$db) or die("$sql<br>" . mysql_error());
					$array =mysql_fetch_array($result);
				}

				$sql="	
					update task
					set value1=$value1,value2=$value2,value3=$value3,remark=\"$remark\",view=1,good=\"$good\"
					where tid=$tid";
				mysql_query($sql,$db) or die("$sql<br>" . mysql_error());

				if($check!="new"){//重新调整分项得分
					$value1-=$array['value1'];
					$value2-=$array['value2'];
					$value3-=$array['value3'];

					$sql ="update appeal set did=\"Y\" where tid=\"$tid\"";
					mysql_query($sql,$db) or die("$sql<br>" . mysql_error());
				}

				$value1*=$CFG_TASK_STAR_PER_VALUE;
				$value2*=$CFG_TASK_STAR_PER_VALUE;
				$value3*=$CFG_TASK_STAR_PER_VALUE;
				
				$sql ="update stu set score=score+$value1+$value2+$value3 where sid=\"$sid\"";
				mysql_query($sql,$db) or die("$sql<br>" . mysql_error());
			}else{//教师处理申诉作业不能对作业删除，所以ELSE不用处理
				$sql="delete from task where tid=$tid";
				mysql_query($sql,$db) or die($sql."<br>".mysql_error());
				$sql="delete from s_c_t where tsk_id=$tid";
				mysql_query($sql,$db) or die($sql."<br>".mysql_error());
				$sql="delete from appeal where tid=$tid";
				mysql_query($sql,$db) or die($sql."<br>".mysql_error());

				if(file_exists($_POST["delete_lists"][$i])) 
					unlink($_POST["delete_lists"][$i]);
				else
					echo $_POST["delete_lists"][$i]." 文件不存在，删除无效。<br>";
			}//end if
			$i++;
		}//end foreach
	}//作业评分结束
?>
</p>
<form name="form1" method="POST" action="">
  <?php 
	//列表显示作业______________________________________________________________
	if($check=="new")
		$sql="
			select count(*) as num
			from stu,s_c_t left join task on tsk_id=tid
			where view is null and sid=stu_id and grade=$grade and class=$class and crs_id=$cid";
	else
		$sql ="
			select count(*) as num
			from stu,s_c_t left join task on tsk_id=task.tid left join appeal on task.tid=appeal.tid
			where did=\"N\" and stu_id=sid and grade=$grade and class=$class and crs_id=$cid";

	$result=mysql_query($sql,$db) or die("$sql<br>" . mysql_error());
	$array =mysql_fetch_array($result);

	$num=$array['num'];	
	if($num==0){ 
		List_task_table($db,"new");
		List_task_table($db,"old");
		Show_bottom_msg();
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -