OA在线办公（php,mysql）

<?php /* [F SCHOOL OA] F 校园网络办公系统 2009 成绩统计系统 2008 This is a freeware Version: 2.2.1 Author: 浪子凡 (nbbufan@163.com) Powered By:【凡·工作室】 (www.microphp.cn) Last Modified: 2009/3/31 20:08 */ //权限设置 $sql="SELECT * FROM `$table_manage` where admin=$user_id limit 1"; $r=$db->query_first($sql); $limit=$r[groupid]; /************************************************************/ switch ($action){ //***************************************本班学生成绩列表***************************/ case 'listone': //记录数据的读取 $i=1; $class_style="td1"; $sql = "SELECT count(*) FROM $table_result where resultid=$id"; $result = $db->query_first($sql); $totalnum=$result[0]; $query="select $table_result.*,$table_student.name,$table_student.classid,$table_class.buildtime from $table_result LEFT JOIN $table_student ON $table_result.stnumber=$table_student.stnumber LEFT JOIN $table_class ON $table_student.classid=$table_class.classid where $table_result.resultid='$id' order by $table_result.id limit 0,$totalnum"; $result=$db->query($query); while($r=$db->fetch_array($result)){ $classid=substr($r[stnumber],0,6); //学科成绩信息按[班级][学号]存放:0总分1语文2数学3外语4科学5思政6历社7名次8姓名9序列号 $resultarr[$classid][$r[stnumber]]=array($r[cjsum],$r[yw],$r[sx],$r[wy],$r[kx],$r[sz],$r[ls],$i,$r[name],$r[id]); //班级输入时间 $classbuildtime[$classid]=$r[buildtime]; $i++; } $colid=0; //数据输出 foreach($resultarr as $key => $arr){ //班级id $classid=$key; //名次计数 $j=1; //班级 $class_id=substr($classid,4,2); if ($class_id<10)$class_id=substr($class_id,1,1); //毕业时间 $bytime=substr(date('Y',$classbuildtime[$classid]),0,2).substr($classid,0,2); //建立时间 $buildtime=mktime(0,0,0,7,6,$bytime-3); //现在时间 $nowtime=mktime(0,0,0,date("m"),date("d"),date("Y")); //时间差参数 $temptime=$nowtime-$buildtime; $temptime=round($temptime/2592000); //初一 if ($temptime>=0 ANd $temptime<=12) { $classname="初一($class_id)班"; } //初二 elseif ($temptime>12 AND $temptime<=24){ $classname="初二($class_id)班"; } //初三 elseif ($temptime>24 AND $temptime<=36){ $classname="初三($class_id)班"; } //已毕业 else{ $classname=$bytime."届($class_id)班"; } if ($colid==0){ $class_show.="<TD class=main_menu_title2 id=TabTitle1 onmousedown=javascript:ShowTabs1($colid); vAlign=bottom align=middle width=100 height=32><FONT color=#ff0000><STRONG>$classname</STRONG></FONT></TD>"; $table_show.="<TBODY id=Tabs1> <TR> <TD class=menu_tdbg vAlign=top align=left height=180> "; }else { $class_show.="<TD class=main_menu_title1 id=TabTitle1 onmousedown=javascript:ShowTabs1($colid); vAlign=bottom align=middle width=100 height=32><FONT color=#ff0000><STRONG>$classname</STRONG></FONT></TD>"; $table_show.="<TBODY id=Tabs1 style=\"DISPLAY: none\"> <TR> <TD class=menu_tdbg vAlign=top align=left height=180> "; }; $colid++; $table_show.=" <TABLE cellSpacing=2 cellPadding=1 width=100% align=center border=0 class=table1> <tbody id=stlist> <tr align=center> <td class=tr_head>序列号</td> <td width=15% height=24 class=tr_head>班级</td> <td class=tr_head>学号</td> <td class=tr_head>学生姓名</td> <td class=tr_head>语文</td> <td class=tr_head>数学</td> <td class=tr_head>外语</td> <td class=tr_head>科学</td> <td class=tr_head>思政</td> <td class=tr_head>历社</td> <td class=tr_head>总分</td> <td class=tr_head>操作</td> </tr>"; foreach ($arr as $key => $value){ //本班输出成绩信息 $table_show.=" <tr align=center id=list$value[9]> <td class=td1>$j</td> <td class=td1 width=15% height=24 >$classname</td> <td class=td1>$key</td> <td class=td1>$value[8]</td> <td class=td1>$value[1]</td> <td class=td1>$value[2]</td> <td class=td1>$value[3]</td> <td class=td1>$value[4]</td> <td class=td1>$value[5]</td> <td class=td1>$value[6]</td> <td class=td1>$value[0]</td> <td class=td1><a href=# onclick=popUp('editst','$value[9]')>修改</a></td> </tr> "; $j++; } $table_show.= " </tbody> </table> </TD> </TR> </TBODY>"; } ?> <? break; //******************************************班级排名统计***********************************/ case 'cout': //数据读取 $sql = "SELECT count(*),sum(yw),sum(sx),sum(wy),sum(kx),sum(sz),sum(ls) FROM $table_result where resultid=$id"; $r= $db->query_first($sql); $totalnum=$r[0]; $i=1; $query="select $table_result.*,$table_student.name,$table_class.buildtime from $table_result LEFT JOIN $table_student ON $table_result.stnumber=$table_student.stnumber LEFT JOIN $table_class ON $table_student.classid=$table_class.classid where $table_result.resultid='$id' order by cjsum DESC"; $result=$db->query($query); while($r=$db->fetch_array($result)){ $classid=substr($r[stnumber],0,6); $resultarr[$classid][$r[stnumber]]=array($r[cjsum],$r[yw],$r[sx],$r[wy],$r[kx],$r[sz],$r[ls],$i,$r[name]); $classbuildtime[$classid]=$r[buildtime]; $i++; } $colid=1; //数据输出 foreach($resultarr as $key => $arr){ //班级id $classid=$key; //名次计数 $j=1; //班级 $class_id=substr($classid,4,2); if ($class_id<10)$class_id=substr($class_id,1,1); //毕业时间 $bytime=substr(date('Y',$classbuildtime[$classid]),0,2).substr($classid,0,2); //建立时间 $buildtime=mktime(0,0,0,7,6,$bytime-3); //现在时间 $nowtime=mktime(0,0,0,date("m"),date("d"),date("Y")); //时间差参数 $temptime=$nowtime-$buildtime; $temptime=round($temptime/2592000); //初一 if ($temptime>=0 ANd $temptime<=12) { $classname="初一($class_id)班"; } //初二 elseif ($temptime>12 AND $temptime<=24){ $classname="初二($class_id)班"; } //初三 elseif ($temptime>24 AND $temptime<=36){ $classname="初三($class_id)班"; } //已毕业 else{ $classname=$bytime."届($class_id)班"; } if ($colid==0){ $class_show.="<TD class=main_menu_title2 id=TabTitle1 onmousedown=javascript:ShowTabs1($colid); vAlign=bottom align=middle width=100 height=32><FONT color=#ff0000><STRONG>$classname</STRONG></FONT></TD>"; $table_show.="<TBODY id=Tabs1> <TR> <TD class=menu_tdbg vAlign=top align=left height=180> "; }else { $class_show.="<TD class=main_menu_title1 id=TabTitle1 onmousedown=javascript:ShowTabs1($colid); vAlign