//新班级人数
$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['学分'] = $课程信息['学分'];
