📄 mng_analyse_task.php
字号:
<?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">
<style type="text/css">
body,td,th {font-size: 14px;}
</style>
<script language="javascript" src="ItAssisJS/java.js"></script>
</head>
<body>
<?php
include "config.inc.php";
include "conn.inc.php";
include "ItAssisFC/FLib.php";
include "ItAssisFC/CLib.php";
$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
if(isset($_GET['page']) ) $page=$_GET['page']; else $page=0;
if(isset($_GET['per_page']))$per_page=$_GET['per_page'];else $per_page=5;
//删除作业******************************************************
if(isset($_GET['file'])){
$tid=$_GET['tid'];
$sid=$_GET['sid'];
$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);
$value =$array['value1']*$CFG_TASK_STAR_PER_VALUE;
$value+=$array['value2']*$CFG_TASK_STAR_PER_VALUE;
$value+=$array['value3']*$CFG_TASK_STAR_PER_VALUE;
$sql="update stu set score=score-$value where sid=\"$sid\"";
mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$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());
if(is_file($_GET['file'])) unlink($_GET['file']);
echo "<p align=center><span class=red><strong>报告: {$sid}的作业：{$_GET['file']}已删除</strong></span>。</p>";
}
//构造OPTION信息
$sql="
select grade,class,count(*) as total
from stu
group by grade,class";
$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$g_c_item_msg="";
if(isset($_GET['g_c']) && $_GET['g_c']!="all"){
list($g,$c)=split(",",$_GET['g_c']);
$g_c_item_msg.="<option value=\"{$_GET['g_c']}\">$g($c)班</option>";
}
$g_c_item_msg.="<option value=\"all\">所有班级</option>";
while($array=mysql_fetch_array($result)){
$g=$array['grade'];
$c=$array['class'];
$g_c_item_msg.="<option value=\"$g,$c\">$g($c)班[{$array['total']}人]</option>";
}
$rsc_array=Read_course_List2($db);
$rsc_item_msg="";
if(isset($_GET['crs_id']))
$rsc_item_msg.="<option value=\"{$_GET['crs_id']}\">当前课程</option>";
$rsc_item_msg.="<option value=all>所有课程</option>";
while($array=array_shift($rsc_array)){
$cid=$array['cid'];$type=$array['type'];$title=$array['title'];
if($type==0) $rsc_item_msg.="<option value=$cid>〖教材〗$title</option>";
else if($type==1) $rsc_item_msg.="<option value=$cid> 〖章〗¶$title</option>";
else if($type==2) $rsc_item_msg.="<option value=$cid> 〖节〗¶¶$title</option>";
else if($type==3) $rsc_item_msg.="<option value=$cid> 【课程】¶¶¶$title</option>";
}
?>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" background="images/top_bg.jpg"><div align="left"> 位于：<a href="mng_analyse_score.php">学生积分分析</a><strong class="red"> </strong> <a href="mng_analyse_task.php" class="red"><strong>学生作业分析</strong></a> <a href="mng_analyse_express.php">学生表现分析</a></div></td>
<td width="100" background="images/top_bg.jpg"><div align="left">[<a href="#explain">说明</a>]</div></td>
</tr>
</table>
<form name="form1" method="GET" action="">
<table width="740" height="20" border="0" align="center" cellpadding="0" cellspacing="0" background="images/top_bg.jpg" bgcolor="#DEEBF7">
<tr>
<td width="620" height="20">
<input name="sid" type="text" id="sid" value="<?php if(isset($_GET['sid'])) echo urldecode($_GET['sid']);else echo "姓名";?>" size="8" maxlength="8">
<select name="g_c">
<?php echo $g_c_item_msg?>
</select>
<select name="crs_id">
<?php echo $rsc_item_msg ?>
</select>
<input name="imageField" type="image" src="images/search.gif" border="0">
<input name="search" type="hidden" id="search" value="1">
</td>
<td width="120"><input name="per_page" type="text" id="per_page" size="4" value="<?php echo $per_page; ?>">
个/页</td>
</tr>
</table>
</form>
<table width="740" border="2" align="center" cellspacing="0" bordercolor="#A5B2CE">
<tr bgcolor="#DEE3EF">
<td width="50" bgcolor="#DEE3EF"><div align="center">姓名</div></td>
<td width="60"><div align="center">班级</div></td>
<td width="120"><div align="center">课程</div></td>
<td width="100"><div align="center">作业</div></td>
<td width="60"><div align="center">技术得分</div></td>
<td width="60"><div align="center">美观得分</div></td>
<td width="60"><div align="center">创新得分</div></td>
<td width="40"><div align="center">优秀</div></td>
<td width="7%"><div align="center">操作</div></td>
</tr>
<?php
// 作业列表
if(isset($_GET['search'])){
if(isset($_GET['crs_id'])) $crs_id=$_GET['crs_id'];
if(trim($_GET['sid'])!="" && trim($_GET['sid'])!="姓名" ) $sid=trim($_GET['sid']);else $sid="姓名";
$record_from=$page*$per_page;
$sql="SELECT sid,pic,grade,class,task.*,crs_id,title";
$sql.=" FROM stu,task,s_c_t LEFT JOIN course ON crs_id=cid";
$sql.=" WHERE view=1 and tid=tsk_id and stu_id=sid";
if(isset($_GET['g_c'])){
if($_GET['g_c']!="all") list($g,$c)=split(",",$_GET['g_c']);
$g_c=$_GET['g_c'];
}
if($_GET['g_c']!="all")
$sql.=" and grade=$g and class=$c";
if($crs_id!="all")
$sql.=" and cid=$crs_id";
if($sid!="" && $sid!="姓名" )
$sql.=" and sid like \"%$sid%\"";
$result2 = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$num=mysql_num_rows($result2);
$sql.=" order by sid,turn desc,grade,class";
$sql.=" limit $record_from,$per_page";
$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$image_msg="";$now_time=time();
$base_url=$_SERVER['PHP_SELF']."?crs_id=all&g_c=$g_c";
while($array=mysql_fetch_array($result)){
$array['value1'] *=$CFG_TASK_STAR_PER_VALUE;
$array['value2'] *=$CFG_TASK_STAR_PER_VALUE;
$array['value3'] *=$CFG_TASK_STAR_PER_VALUE;
if(!$array['pic']) $array['pic']="none.jpg";
if(isset($_SESSION['image']) && $_SESSION['image']=="on")
$image_msg="<a href=$CFG_STU_PHOTO_DIR/".$array['pic']." target=_blank><img src=$CFG_STU_PHOTO_DIR/".$array['pic']." width=50 height=60 border=0 alt=点击看大图></a><br>";
if(!$array['title'])
$array['title']="<span class=red>已删除</span>";
if($array['good']=="Y") $array['good']="<span class=red>是<span>"; else $array['good']=" ";
$file="$CFG_TASK_DIR/".$array['crs_id']."/".$array['nfname'];
$file_size=number_format($array['size']/1024, 1, '.', '');
$file_time=Split_datatime($array['sub_time']);
$file_path="$CFG_TASK_DIR/".$array['crs_id']."/".$array['nfname'];
$del_url=$base_url."&tid={$array['tid']}&file=$file&sid={$array['sid']}";
echo "
<tr>
<td><div align=center>$image_msg{$array['sid']}</div></td>
<td><div align=center>".$array['grade']."(".$array['class'].")班</div></td>
<td><div align=center>".$array['title']."</div></td>
<td><div align=center><a href=$file_path title=\"大小:$file_size K 时间:$file_time\">".$array['ofname']."</a></div></td>
<td><div align=center>".$array['value1']."</div></td>
<td><div align=center>".$array['value2']."</div></td>
<td><div align=center>".$array['value3']."</div></td>
<td><div align=center>".$array['good']."</div></td>";
if(!Task_is_expired($array['sub_time'],$now_time,$CFG_TASK_APPEAL_EXPIRE_DAYS))
echo "<td><div align=center><a href=\"Javascript:if(confirm('你确认删除吗？'))location('$del_url');\" title=删除作业将影响学生积分>删除</a></td>";
else
echo "<td><div align=center><label title=已过作业申诉期> </label></td>";
echo " </tr>";
}
}// 作业列表
?>
</table>
<div align="center"><br>
<?php
if(isset($_GET['search'])){
$CC=new Page();
$CC->setCurrentpage($page);
$CC->setTotalpage($num/$per_page);
$CC->setStride(5);
echo "共<strong>".(floor($num/$per_page)+1)."</strong>页 ";
$CC->Pageprint("sid=$sid&g_c=$g_c&crs_id=$crs_id&search=1&per_page=$per_page");
}
?>
</div>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F7F3F7"><p><a name="explain"></a> 说明：
<ul>
<li class="explain_hight">默认搜索结果为所有作业 。 </li>
<li class="explain_hight">支持姓名模糊搜索。</li>
<li class="explain_hight"><span class="red">删除</span>作业<span class="red">影响</span>学生积分。</li>
<li class="explain_hight">超过作业<span class="red"><?php echo $CFG_TASK_APPEAL_EXPIRE_DAYS ?>天</span>的作业不能删除，需要删除请延长作业申诉时效。</li>
</ul></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -