📄 mng_analyse_score_detail.php
字号:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>EasyTeacher信息技术课堂教学助手(ItAssis)教师端-学生得分明细表</title>
<link href="et.css" rel="stylesheet" type="text/css">
<style type="text/css">
body,td,th {font-size: 14px;}
</style>
</head>
<body>
<?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);
?>
<h3 align="center"><a name="d"></a><?php echo "<span class=red>".$_GET['sid']."</span>";?>得分一览表</h3>
<p align="center"> ［<a href="#课堂作业得分明细表">课堂作业得分明细表</a>］ ［<a href="#课堂表现得分明细表">课堂表现得分明细表</a>］ ［<a href="#累计得分">累计得分</a>］ ［<a href="#说明">说明</a>］</p>
<form name="form1" method="post" action="">
<table width="740" border="1" align="center" cellspacing="0" bordercolor="#FFFFFF">
<tr bgcolor="#FFE3CE">
<td width="140" background="images/bg.jpg"> 课堂作业得分明细</td>
<td colspan="5" bgcolor="#FFFFFF">每个<img src="images/task_smail.gif" align="absbottom"><span class="red"><?php echo $CFG_TASK_STAR_PER_VALUE ?></span>分</td>
</tr>
<tr bgcolor="#FFE3CE">
<td><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="213"><div align="center">评语(<img src="images/task_finger.gif" width="20" height="20" align="absbottom">表示<span class="red">优秀作业)</span></div></td>
</tr>
<?php
$sid=$_GET['sid'];
$sql="SELECT task.*,cid,title";
$sql.=" FROM task,s_c_t LEFT JOIN course ON crs_id=cid";
$sql.=" WHERE s_c_t.stu_id=\"$sid\" and tsk_id=tid";
$sql.=" ORDER BY view,turn DESC";
$result = mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$sum_v1=0;$sum_v2=0;$sum_v3=0;$now_time=time();$change_tr_bg=true;
$image_face="images/task_smail.gif";
$image_finger="images/task_finger.gif";
while($array=mysql_fetch_array($result)){
$remark_msg=" ";
$file_dir="$CFG_TASK_DIR/".$array['cid'];
$file_name=$array['nfname'];
$file_path=$file_dir."/".$file_name;
$file_size=number_format($array['size']/1024, 1, '.', '');
$file_time=Split_datatime($array['sub_time']);
$file_download_name=$array['title']."_".$sid."_".$file_time;
if(!$array['title']) $array['title']="<span class=red>课程已删除</span>";
if(!$array['ofname']) $array['ofname']="无标题";
if(strlen($array['ofname'])>10){
$file_msg=pathinfo($array['ofname']);
$array['ofname']=substr($array['ofname'],0,8)."...".strtolower($file_msg['extension']);
}
$sum_v1+=$array['value1']*$CFG_TASK_STAR_PER_VALUE;;
$sum_v2+=$array['value2']*$CFG_TASK_STAR_PER_VALUE;;
$sum_v3+=$array['value3']*$CFG_TASK_STAR_PER_VALUE;;
for($i=0,$value1_msg="";$i<$array['value1'];$i++) $value1_msg.="<img src=$image_face>";
for($i=0,$value2_msg="";$i<$array['value2'];$i++) $value2_msg.="<img src=$image_face>";
for($i=0,$value3_msg="";$i<$array['value3'];$i++) $value3_msg.="<img src=$image_face>";
if(!$array['view']) $remark_msg="<p align=center><span class=red><strong>作业已交,等待批改</strong></span></p>";
if($array['good']=="Y") $remark_msg="<img src=$image_finger><br>";
if($array['value1']+$array['value2']+$array['value3']==0 && $array['view'])
$remark_msg.="<span class=blue><strong>作业不符合要求<br>请把作业下载并修改完毕后重新提交</strong></span>";
$remark_msg.=$array['remark'];
$del_url="stu_mng_task.php?action=del&file_path=$file_path&tid=".$array['tid'];
($change_tr_bg=!$change_tr_bg)?$tr_bg="#FFF5EE":$tr_bg="#FFECDF";
if($array['good']=="Y")$tr_bg="#FED6D3";
echo "
<tr bgcolor=$tr_bg>
<td><div align=center>".$array['title']."</div></td>
<td><div align=center><span class=red><a href=$file_path title=\"提示：点击可以直接打开作业\n提交时间:{$file_time}\n文件大小:{$file_size}K\" target=_blank>".$array['ofname']."</span></a><p><a href=\"download.php?file_dir=$file_dir&file_name=$file_name&file_download_name=$file_download_name\"><img src=\"images/download_task.jpg\" border=0></a></p></div></td>
<td><div align=center>$value1_msg</div></td>
<td><div align=center>$value2_msg</div></td>
<td><div align=center>$value3_msg</div></td>
<td>$remark_msg</td>
</tr>";
}
?>
<tr bgcolor=#99CCFF>
<td colspan=2 bgcolor="#99CCFF"><div align="center">课堂作业得分统计</div></td>
<td><div align="center"><?php echo $sum_v1; ?>分</div></td>
<td><div align="center"><?php echo $sum_v2; ?>分</div></td>
<td><div align="center"><?php echo $sum_v3; ?>分</div></td>
<td> </td>
</tr>
</table>
<p align="center">
<?php
$sql="select * from express_dic order by ename";
$result = mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$exp_nums=mysql_num_rows($result);
?>
</p>
<p><strong> </strong></p>
<table width="740" border="1" align="center" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="130" height="20" background="images/bg.jpg"><div align="center">课堂表现得分明细</div></td>
<td colspan="<?php echo $exp_nums ?>"><img src="images/express_smile.gif" width="20" height="20" align="absbottom">为加分因素<img src="images/express_cry.gif" width="20" height="20" align="absbottom">为减分因素</td>
</tr>
<tr bgcolor="#FFE3CE">
<td width="130" rowspan="2"><div align="center">课程</div></td>
<td width="600" colspan="<?php echo $exp_nums;?>"><div align="center">课堂表现得分情况</div></td>
</tr>
<?php
$image_smile="<img src=\"images/express_smile.gif\" align=\"absmiddle\">";
$image_cry="<img src=\"images/express_cry.gif\" align=\"absmiddle\">";
echo "<tr bgcolor=#DEE3EF>";
$i=0;
while($array=mysql_fetch_array($result)){
$width=80/$exp_nums;
echo "<td width=$width% bgcolor=#FFECDF><div align=center class=font_12>{$array['ename']}<br><span class=\"red\">{$array['evalue']}分/次</span></td>";
$expid_array[$i++]=$array['expid'];
$expid_array2[$i++]=$array['expid'];
$sum_exp[$array['expid']]=0;
$count_exp_time[$array['expid']]=0;
$exp_msg[$array['expid']]="";
}
echo "</tr>";
$sql="
select time,cid,title,expid,ename,evalue
from express left join course on crs_id=cid left join express_dic on exp_id=expid
where stu_id=\"$sid\"
order by cid desc,ename";
$result=mysql_query($sql,$db) or die($sql."<br>".mysql_error());
$array=mysql_fetch_array($result);$next=false;
while($array){
if($next)
foreach(array_keys($exp_msg) as $expid) $exp_msg[$expid]="";
foreach($expid_array as $e){//逐个查找课堂表现
reset($expid_array2);
while($expid =current($expid_array2)){ //逐个查找课堂表现积分
if($expid==$array['expid']){
if($array['evalue']<=0)
$image_msg=$image_cry;
else
$image_msg=$image_smile;
$time=Split_datatime($array['time']);
$exp_msg[$expid].="<label title=$time>$image_msg</label>";
$sum_exp[$expid]+=$array['evalue'];
$count_exp_time[$expid]++;
break;
}
$expid=next($expid_array2);
}//end while
$cid=$array['cid'];$title=$array['title'];
$array=mysql_fetch_array($result);
if($cid!=$array['cid']){//打印行内容
echo "<tr bgcolor=#FFECDF><td><div align=center>$title</div></td>";
foreach($exp_msg as $msg) echo "<td><div align=center>".$msg." </div></td>";
echo "</tr>";
$next=true;
break;
}else
$next=false;
}//end foreach
}//循环1结束
if(!isset($sum_exp)) {
$sum_exp["未设置表现"]=0;
$count_exp_time["未设置表现"]=0;
}
echo "</tr><tr bgcolor=#99CCFF><td><div align=center>课堂表现得分统计</td>";
foreach(array_keys($sum_exp) as $expid)
echo "<td><div align=center>$sum_exp[$expid]分(计{$count_exp_time[$expid]}次)</div></td>";
echo "</tr>";
$sum_v=$sum_v1+$sum_v2+$sum_v3;
$sum_exp=array_sum($sum_exp);
?>
</table>
<p><strong> 累计得分<a name="累计得分" id="累计得分"></a></strong></p>
<p> 最后得分[<span class="red"><?php echo $sum_v+$sum_exp;?>分</span>]=作业得分[<span class="red"><?php echo $sum_v;?>分</span>]+表现得分[<span class="red"><?php echo $sum_exp;?>分</span>]</p>
</form>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F7F3F7"><p> 说明<a name="说明"></a>：</p>
<ul>
<li class="explain_hight">每课一定要交作业，不然没有相应课程没有得分。作业可以补交。</li>
<li class="explain_hight"> 需要批改的作业不要删除，不然老师看不到你的作业，当然不能打分。</li>
<li class="explain_hight">不合格的作业补交时必须先将以前作业删除后才能重新提交。</li>
</ul></td>
</tr>
</table>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -