📄 stu_mng_task.php
字号:
<?php
session_start();
include "ItAssisFC/FLib.php";
Stu_is_login();
include "config.inc.php";
include "conn.inc.php";
$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
//删除作业
if(isset($_GET['action']) && $_GET['action']="del"){
$tid=$_GET['tid'];
$sid=$_SESSION['sid'];
$sql="select tid from task,s_c_t where tid=$tid and tid=tsk_id and stu_id=\"$sid\"";
$result=mysql_query($sql,$db) or die($sql."<br>".mysql_error());
if(mysql_num_rows($result)<=0) {echo "失败：你的权限不足。！";exit;}
$file_path=$_GET['file_path'];
$sql="DELETE FROM task WHERE tid=$tid and view is NULL";
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($file_path)) unlink($file_path);
}
?>
<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">
<script language="javascript" src="ItAssisJS/java.js"></script>
<style type="text/css">
body,td,th {font-size: 14px;}
</style>
</head>
<body>
<p align="center"> <a name="d"></a><img src="images/task_wodezuoye.jpg"></p>
<p align="center">[<A href="stu_upload_task.php" class="red"><strong>提交作业</strong></A>] [<a href="#累计得分">累计积分</a>] [<a href="javascript:popUpWindow('./ItAssisPublic/Help/stu_upload_task.swf',0,0,760,500)">动画帮助：如何交作业</a>]</p>
<form name="form1" method="post" action="">
<table width="740" border="1" align="center" cellspacing="0" bordercolor="#FFFFFF">
<tr bgcolor="#FFE3CE">
<td 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 width="130"><div align="center">课程</div></td>
<td width="110"><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>
<td width="77"><div align="center">权限</div></td>
</tr>
<?php
$sid=$_SESSION['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>";
if(!$array['view'] || ($array['value1']+$array['value2']+$array['value3']==0))//未批改作业或者0分作业可以删除
echo "<td><div align=center><a href=\"Javascript:if(confirm('你确认删除吗？作业删除后将不能恢复，请慎重！'))location('$del_url');\"><strong>删除</strong></a></div></td>";
else
if (!Task_is_expired($array['sub_time'],$now_time,$CFG_TASK_APPEAL_EXPIRE_DAYS))
echo "<td><div align=center><a href=stu_appeal_task.php?tid=".$array['tid'].">申诉</a></div></td>";
else
echo "<td> </div></td>";
echo "</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>
<td> </td>
</tr>
</table>
<p> </p>
<?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);
?>
<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 class=font_12>$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>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -