//新班级人数 $ClassNumber = returnClassNumber($ClassCode); //现有情况只排一个班级时 if ($rs_a[0]['班级'] != "") { $OneClassNumber = returnClassNumber($rs_a[0]['班级']); $CheckNumber = $OneClassNumber + $ClassNumber; if ($CheckNumber > $ClassroomNumber) { //将要排进去该班的人数超过该教室最大的容纳数量 print "<font color=red><B>教室({$fixedClassroom})座位数:{$ClassroomNumber},己经安装班级人数:{$OneClassNumber},将要安排班级人数:{$ClassNumber},合起来为:{$CheckNumber},超过该教室的最大容纳值:{$ClassroomNumber},故排课失败,如果执行本次操作,请在教室管理里面重新调高教室({$fixedClassroom})的座位数({$ClassroomNumber}),以满足排课条件要求.排课中断</B></font>"; exit; } } //现有情况有两个班级时 if ($rs_a[1]['班级'] != "") { $OneClassNumber = returnClassNumber($rs_a[0]['班级']); $TwoClassNumber = returnClassNumber($rs_a[1]['班级']); $CheckNumber = $OneClassNumber + $TwoClassNumber + $ClassNumber; if ($CheckNumber > $ClassroomNumber) { //将要排进去该班的人数超过该教室最大的容纳数量 print "<font color=red><B>教室({$fixedClassroom})座位数:{$ClassroomNumber},己经安装班级人数:" . $OneClassNumber . "和{$TwoClassNumber},将要安排班级人数:{$ClassNumber},合起来为:{$CheckNumber},超过该教室的最大容纳值:{$ClassroomNumber},故排课失败,如果执行本次操作,请在教室管理里面重新调高教室({$fixedClassroom})的座位数({$ClassroomNumber}),以满足排课条件要求.排课中断</B></font>"; exit; } } //print $ClassroomNumber; //print $ClassNumber;exit; //形成己排课程的课时安排计划 //处理:按班排课中可以将同一个教室安排2门及以上不同的课程 //判断条件:教室,课程,时间,一个教室在同一时间,只允许上同一门课程 $sql = "select `课程` as NUM from edu_schedule where `学期`='{$CurXueQi}' and `教室`='{$fixedClassroom}' and `课程`!='{$CourseName}' and `星期`='{$Week}' and `节次`='{$JieCi}' {$DanShuangZhouSQL}"; $rs = $db->Execute($sql); //print $sql.";<BR>";
function 修正教学日记里面的班级人数信息() { global $db, $CurXueQi; $sql = "select distinct 班级 from edu_teacherkaoqinmingxi where 学期='{$CurXueQi}'"; // where 执行状态='0' $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $NewArray = array(); for ($i = 0; $i < sizeof($rs_a); $i++) { $班级 = $rs_a[$i]['班级']; $班级人数 = returnClassNumber($班级); $sql = "update edu_teacherkaoqinmingxi set 班级人数='{$班级人数}' where 班级='{$班级}'"; $db->Execute($sql); $sql = "update edu_teacherkaoqinmingxi set 实到人数='{$班级人数}' where 班级='{$班级}' and 实到人数>'{$班级人数}'"; $db->Execute($sql); global $SHOWTEXT; if ($SHOWTEXT) { print "<BR>修正教学日记里面的班级人数信息:" . $sql . "<BR>"; } } }
$周学时 = $Element['周学时']; $课程性质 = $Element['课程性质']; $课程类别 = $Element['课程类别']; $考核 = $Element['考核']; $学分 = $Element['学分']; $总学时 = $Element['总学时']; $讲课学时 = $Element['讲课学时']; $实验学时 = $Element['实验学时']; $上机学时 = $Element['上机学时']; $起止周 = $Element['起止周']; $开课学院 = $Element['开课学院']; $备注 = $Element['备注']; for($ii=0;$ii<sizeof($班级名称Array);$ii++) { $班级名称 = $班级名称Array[$ii]['班级名称']; $班级代码 = $班级名称Array[$ii]['班级代码']; $班级人数 = returnClassNumber($班级名称); //print_R($Element); $sql = "INSERT INTO `edu_planexec` ( `级别` , `专业代码` , `专业名称` , `班级代码`, `班级名称` , `班级人数` , `开课教师` , `开课学期` , `课程代码` , `课程名称` , `周学时` , `学分` , `课程性质` , `课程类别` , `考核` , `总学时` , `讲课学时` , `实验学时` , `上机学时` , `起止周` , `开课学院` , `备注` ) VALUES ( '$级别', '$专业代码', '$专业名称', '$班级代码', '$班级名称', '$班级人数', '$开课教师', '$开课学期', '$课程代码', '$课程名称', '$周学时', '$学分', '$课程性质', '$课程类别', '$考核', '$总学时', '$讲课学时', '$实验学时', '$上机学时', '$起止周', '$开课学院', '$备注' );"; //$db->debug = 1; $rs = $db->Execute($sql); $EOF = $rs->EOF; if($EOF) { $EOF_Right += 1; } else { $EOF_Error += 1; }
function 同步教学计划里面的班级人数信息($学期名称) { global $db, $CurXueQi; $sql = "select distinct 班级名称 from edu_planexec where 开课学期='{$学期名称}'"; //print "<BR>同步教学计划里面的班级人数信息:".$sql."<BR>"; $rs = $db->Execute($sql); $rs_a = $rs->GetArray(); $NewArray = array(); for ($i = 0; $i < sizeof($rs_a); $i++) { $班级 = $rs_a[$i]['班级名称']; $班级人数 = returnClassNumber($班级); $sql = "update edu_planexec set 班级人数='{$班级人数}' where 班级名称='{$班级}'"; $db->Execute($sql); global $SHOWTEXT; if ($SHOWTEXT) { print "<BR>同步教学计划里面的班级人数信息:" . $sql . "<BR>"; } } }
/* $_POST['实验学时'] = $_POST['周学时']-$_POST['讲课学时']-$_POST['上机学时']; if($_POST['实验学时']<0) { page_css("讲课学时与上机学时之和不能超过周学时"); print_infor("讲课学时与上机学时之和不能超过周学时","","location='?ss=ss&专业代码=".$_GET['专业代码']."&专业名称=".$_GET['专业名称']."&学期=".$_GET['学期']."&NJ=".$_GET['NJ']."&开课学期=".$_GET['开课学期']."&所属专业=".$_GET['所属专业']."'");exit; } */ //print_R($_POST);exit; //$_POST['课程类别'] = "必修课"; $_POST['教师用户名'] = $_POST['开课教师_ID']; $_POST['级别'] = returntablefield("edu_banjidata","班级名称",$_POST['班级名称'],"入学年份"); $_POST['专业代码'] = returntablefield("edu_banjidata","班级名称",$_POST['班级名称'],"所属专业"); $_POST['专业名称'] = returntablefield("edu_zhuanye","专业代码",$_POST['专业代码'],"专业名称"); $_POST['班级代码'] = returntablefield("edu_banjidata","班级名称",$_POST['班级名称'],"班级代码"); $_POST['班级人数'] = returnClassNumber($_POST['班级名称']); //$_POST['实验学时'] = $_POST['周学时']-$_POST['讲课学时']-$_POST['上机学时']-$_POST['体育学时']; //if($_POST['实验学时']<0) { //page_css("讲课学时、上机学时、实验学时、体育学时之和不能超过周学时"); //print_R($_POST); //print_infor("讲课学时、上机学时、实验学时、体育学时之和不能超过周学时","","location='?ss=ss&action=init_default&专业代码=".$_POST['专业代码']."&专业名称=".$_POST['专业名称']."&学期=".$_POST['开课学期']."&NJ=".$_POST['级别']."&开课学期=".$_POST['开课学期']."&所属专业=".$_POST['专业代码']."'");成绩计算方法来源exit; //} $_POST['课程名称'] = TRIM($_POST['课程名称']); $_POST['课程代码'] = TRIM($_POST['课程代码']); $课程信息 = returntablefield("edu_course","课程代码",$_POST['课程代码'],"学分,总学时,课程类别,修习类别,课程类型,教研室,讲课学时,上机学时,实验学时,体育学时"); $_POST['总学时'] = $课程信息['总学时']; $_POST['学分'] = $课程信息['学分'];