JW/EMIS.Web/Scripts/Business/ScoreManage/SpecialityScoreByFinal.js

var isFirstLoadGradeYear = true;
var isFirstLoadClassmajor = true;
var isPageLoad = true;

function SpecialityScoreSumTable() {
    var collegeID = $("#CollegeDropdown").combobox("getValue");
    var standardID = $("#DictionaryStandard").combogridX("getValue");
    var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
    var yearID = $("#DictionarySchoolyear").combobox("getValue");
    var schoolyearNumID = $("#DictionarySchoolyearNum").combobox("getValue");
    var schoolcodeID = $("#DictionarySchoolcode").combobox("getValue");
    //var InSchoolStatus = $("#InSchoolStatusDictionaryDropDown").combobox("getValue");
    var courseTypeIDs = document.getElementsByName("CourseTypeID");
    var Credit = $("#IsCredit").is(':checked')
    var courseTypeIDList = "";
    for (i = 0; i < courseTypeIDs.length; i++) {
        if (courseTypeIDs[i].checked) {
            var courseType = courseTypeIDs[i].value;
            courseTypeIDList = courseTypeIDList + courseType + ',';
        }
    }

    $.postWithLoading(CMS_SystemConfig.VirtualDirectoryPath + '/SpecialityScoreSum/SpecialityScoreByScoreList', { collegeID: collegeID, standardID: standardID, classmajorID: classmajorID, yearID: yearID, schoolyearNumID: schoolyearNumID, schoolcodeID: schoolcodeID, CourseTypeID: courseTypeIDList },
    function (data) {
        $("#SpecialityScoreSumtable").find("tr.row").remove();
        if (data) {
            var d = [];
            var firstRow = [];
            var secondRow = [];
            var secondRow1 = [];
            var secondRow2 = [];
            var secondRow3 = [];
            var thirdRow = [];
            var forthRow = [];
            var detailRow = [];

            //生成第一、二、三行表头，学年和学期和课程
            //第一行（左上角）开头
            var containerWidth = $("#SpecialityScoreSumtable").width() - 210;
            firstRow.push("<div id='divConner' style='width: 208px; height: 292px; float: left;'><table cellpadding='0' cellspacing='0' style='width:208px'>");
            firstRow.push("<tr style='background-color:#f0f0f0;'>");
            firstRow.push("<td colspan='3' style='width: 206px; height: 20px;'>学期</td>");
            firstRow.push("</tr>");
            firstRow.push("<tr style='background-color:#f0f0f0'>");
            firstRow.push("<td width='28' height='228'>次序</td>");
            firstRow.push("<td width='114'>学号</td>");
            firstRow.push("<td width='60'>姓名</td>");
            firstRow.push("</tr>");
            firstRow.push("<tr style='background-color:#f0f0f0'>");
            firstRow.push("<td width='28' height='20'></td>");
            firstRow.push("<td width='114'></td>");
            firstRow.push("<td width='60'></td>");
            firstRow.push("</tr>");
            firstRow.push("<tr style='background-color:#f0f0f0'>");
            firstRow.push("<td width='28' height='20'></td>");
            firstRow.push("<td width='114'></td>");
            firstRow.push("<td width='60'></td>");
            firstRow.push("</tr>");
            firstRow.push("</table></div>");
            //第二行(右上角)开头（表头后补，因为长度未知，高度定292）
            secondRow.push("<tr style='background-color:#f0f0f0'>");
            secondRow1.push("<tr style='background-color:#f0f0f0'>");
            secondRow2.push("<tr style='background-color:#f0f0f0'>");
            secondRow3.push("<tr style='background-color:#f0f0f0'>");
            if (Credit) {
                secondRow.push("<td colspan='10' style='height: 20px; width: 398px;'>学分统计</td>");
                secondRow1.push("<td width='38'>总学分</td>");
                secondRow1.push("<td width='38'>必修学分</td>");
                secondRow1.push("<td width='38'>限选学分</td>");
                secondRow1.push("<td width='38'>通识教育</td>");
                secondRow1.push("<td width='38'>任选学分</td>");
                secondRow1.push("<td width='38'>方向选修</td>");
                secondRow1.push("<td width='38'>公共选修</td>");
                secondRow1.push("<td width='38'>实践环节</td>");
                secondRow1.push("<td width='38'>俱乐部（含校本）</td>");
                secondRow1.push("<td width='38'>平均分</td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow2.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
                secondRow3.push("<td width='38'></td>");
            }
            //第三行(左下角)开头
            thirdRow.push("<div id='divStudents' style='width: 208px; height: 300px; overflow-y: hidden; overflow-x: scroll; float: left;'><table border='0' cellpadding='0' cellspacing='0' style='width:208px'>");

            //第四行(右下角)（表头后补，因为长度未知）

            for (var i = 0; i < data.StudentList.length; i++) {
                var student = data.StudentList[i];
                var credit = data.SpecialityCreditView[i];
                var tmpThirdRow = [];
                tmpThirdRow.push("<tr>");
                tmpThirdRow.push("<td width='28'>" + (i + 1).toString() + "</td>");
                tmpThirdRow.push("<td width='114'>" + student.LoginID + "</td>");
                tmpThirdRow.push("<td width='60'>" + student.UserName + "</td>");
                tmpThirdRow.push("</tr>");

                thirdRow.push(tmpThirdRow.join(''));

                forthRow[i] = [];
                forthRow[i].push("<tr>");
                if (Credit && credit != null) {
                    forthRow[i].push("<td width='38'>" + credit.TotalCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.RequiredCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.OptionalCourseCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.GeneralEducationCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.FreeSelectionCourseCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.ElectiveCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.ElectivePublicCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.PractiseNotCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.ClubWithSchoolbasedCredit + "</td>");
                    forthRow[i].push("<td width='38'>" + credit.AvgScore + "</td>");
                }
                else if (Credit && credit == null) {
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                    forthRow[i].push("<td width='38'>0</td>");
                }
            }
            thirdRow.push("</table></div>");
            var totalWidth = 208;
            if (Credit) {
                totalWidth += 400;
            }
            //前三行明细
            for (var i = 0; i < data.SchoolyearNums.length; i++) {
                var schoolyearWidth = data.SchoolyearNums[i].CoursematerialNum * 30;
                totalWidth += schoolyearWidth + 2;
                var schoolyearNum = data.SchoolyearNums[i];
                for (var j = 0; j < schoolyearNum.SchoolCodeView.length; j++) {
                    var schoolcode = schoolyearNum.SchoolCodeView[j];
                    var schoolcodeWidth = schoolcode.CoursematerialList.length * 30;

                    secondRow.push("<td height='20' width='" + (schoolcodeWidth - 2).toString() + "' colspan='" + schoolcode.CoursematerialList.length + "'>" + schoolcode.Title + "</td>");

                    for (var k = 0; k < schoolcode.CoursematerialList.length; k++) {
                        var coursematerial = schoolcode.CoursematerialList[k];
                        if (coursematerial.Title.length <= 12) {
                            secondRow1.push("<td width='28' height='228' style='word-break: break-all;' title='" + coursematerial.Title + "'>" + coursematerial.Title.split('').join('<br/>') + "</td>");
                        } else {
                            var str = coursematerial.Title.substring(0, 12) + "...";
                            secondRow1.push("<td width='28' height='228' style='word-break: break-all;' title='" + coursematerial.Title + "'>" + str.split('').join('<br/>') + "</td>");
                        }
                        secondRow2.push("<td width='28' height='20' style='word-break: break-all;'>" + coursematerial.Tag + "</td>");
                        secondRow3.push("<td width='28' height='20' style='word-break: break-all;'>" + coursematerial.Credit + "</td>");
                        for (var l = 0; l < coursematerial.ScoreList.length; l++) {
                            var score = coursematerial.ScoreList[l];
                            var index = -1;
                            for (var m = 0; m < data.StudentList.length; m++) {
                                if (data.StudentList[m].UserID == score.UserID) {
                                    index = m;
                                }
                            }
                            if (index < 0) continue;

                            if (score.Score != null && score.Score != "") {
                                if (score.Score >= 60)
                                    forthRow[index].push("<td width='28' style='word-break: break-all;'>" + score.Score + "</td>");
                                else
                                    forthRow[index].push("<td width='28' style='color:red;word-break: break-all;'>" + score.Score + "</td>");
                            }
                            else if (score.Score == 0) {
                                forthRow[index].push("<td width='28' style='color:red;word-break: break-all;'>" + score.Score + "</td>");
                            }
                            else {
                                forthRow[index].push("<td width='28' style='color:red;word-break: break-all;'>&nbsp;</td>");
                            }
                        }
                    }
                }
            }
            secondRow.push("</tr>");
            secondRow1.push("</tr>");
            secondRow2.push("</tr>");
            secondRow3.push("</tr>");
            //扣除滚动条宽度
            containerWidth -= 16;
            d.push(firstRow.join(""));
            d.push("<div id='divLabels' style='overflow-x: hidden; overflow-y: scroll; width: " + containerWidth.toString() + "px; float: left;'><table cellpadding='0' cellspacing='0' style='width:" + totalWidth.toString() + "px;'>");
            d.push(secondRow.join(""));
            d.push(secondRow1.join(""));
            d.push(secondRow2.join(""));
            d.push(secondRow3.join(""));
            d.push("</table></div>");
            d.push(thirdRow.join(""));
            d.push("<div id='divScore' style='height: 300px; overflow-x: scroll; overflow-y: scroll;width: " + containerWidth.toString() + "px; float: left;'><table border='0' cellpadding='0' cellspacing='0' style='width:" + totalWidth.toString() + "px;'>");
            for (var i = 0; i < data.StudentList.length; i++) {
                d.push(forthRow[i].join(""));
                d.push("</tr>");
            }
            d.push("</table></div>");

            //            totalWidth = totalWidth + 16;
            //            d.push("<div style='height: 300px; overflow-x: auto; overflow-y: auto;width: " + totalWidth.toString() + "px;'><table cellpadding='0' cellspacing='0'>");
            //            //            for (var i = 0; i < data.StudentList.length; i++) {
            //            //                d.push(forthRow[i].join(""));
            //            //                d.push("</tr>");
            //            //            }
            //            d.push("</table></div>");
            $("#SpecialityScoreSumtable").html(d.join(""));

            resizeGrids();
            $("#divScore").scroll(scoreOnScroll);
        } else {
            $.messager.alert("系统提示", "对不起，未找到数据！");
        }
    });
}

function resizeGrids() {
    var scoreList = $("#divScore table tr");
    var studentsList = $("#divStudents table tr");
    var connerDiv = $("#divConner");
    var studentsDiv = $("#divStudents");
    var labelsDiv = $("#divLabels");
    var scoreDiv = $("#divScore");
    var scoreTable = $("#divScore table");
    var studentsTable = $("#divStudents table");
    var connerFirstRow = $("#divConner table tr:eq(0) td");
    var labelsFirstRow = $("#divLabels table tr:eq(0) td");
    var isIE = navigator.userAgent.indexOf("compatible") > -1 && navigator.userAgent.indexOf("MSIE") > -1 && navigator.userAgent.indexOf("Opera") <= -1;

    var labelsFirstRowHeight = labelsFirstRow.height();
    if (isIE) {
        labelsFirstRowHeight += 2;
    }
    connerFirstRow.height(labelsFirstRowHeight);
    connerDiv.height(labelsDiv.height());
    labelsDiv.height(labelsDiv.height());
//    if (isIE) {
//        studentsDiv.css("margin-top", (labelsFirstRowHeight - 16) + "px");
//    } else {
//        studentsDiv.css("margin-top", (labelsFirstRowHeight - 18) + "px");
//    }

    //studentsTable.height(scoreTable.height());
    //scoreTable.height(studentsTable.height());
    for (var i = 0; i < scoreList.length; i++) {
//        var studentRowOffset = $(studentsList[i]).find("td:eq(0)").offset();
//        var scoreRowOffset = $(scoreList[i]).find("td:eq(0)").offset();
//        $(studentsList[i]).find("td:eq(0)").offset({
//            top: scoreRowOffset.top,
//            left: studentRowOffset.left
        //        });
        if (!isIE) {
            $(studentsList[i]).find("td").height($(scoreList[i]).find("td:eq(0)").height());
            $(scoreList[i]).find("td:eq(0)").height($(studentsList[i]).find("td:eq(0)").height());
            $(studentsList[i]).height($(scoreList[i]).height());
            $(scoreList[i]).height($(studentsList[i]).height());
        } else {
            $(studentsList[i]).find("td:eq(0)").height($(scoreList[i]).find("td:eq(0)").height());
            //$(scoreList[i]).find("td:eq(0)").height($(studentsList[i]).find("td:eq(0)").height());
            $(studentsList[i]).height($(scoreList[i]).height());
            //$(scoreList[i]).height($(studentsList[i]).height());
            var studentsListOffset = $(studentsList[i]).offset();
            var scoreListOffset = $(scoreList[i]).offset();

            if (studentsListOffset.top > scoreListOffset.top) {
                $(scoreList[i]).find("td:eq(0)").css("padding-top", (1 + studentsListOffset.top - scoreListOffset.top) + "px");
            } else if (studentsListOffset.top < scoreListOffset.top) {
                $(studentsList[i]).find("td:eq(0)").css("padding-top", (1 + scoreListOffset.top - studentsListOffset.top) + "px");
            }
        }
    }
    
    resizeDiv();
}

function scoreOnScroll() {
    var scoreDiv = $("#divScore");
    var labelsDiv = $("#divLabels");
    var studentsDiv = $("#divStudents");

    studentsDiv.scrollTop(scoreDiv.scrollTop());
    labelsDiv.scrollLeft(scoreDiv.scrollLeft());
}

function switchPanel() {
    var showDivs = $("#formQuery div");

    if (showDivs.css("display") == "none") {
        showDivs.show();
        $("#divDownIcon").show();
        $("#divUpIcon").hide();
    } else {
        showDivs.hide();
        $("#divDownIcon").hide();
        $("#divUpIcon").show();
    }
    resizeDiv();
}

function resizeDiv() {
    var scoreDiv = $("#divScore");
    var labelsDiv = $("#divLabels");
    var studentsDiv = $("#divStudents");
    if (labelsDiv.length > 0) {
        var contentHeight = $(window).height() - $("#SpecialityScoreSumtable").offset().top - labelsDiv.height() - 2;
        scoreDiv.height(contentHeight);
        studentsDiv.height(contentHeight);
    }
}

//个人成绩报表（松山、工大、科大等）
function StudentScore_Report() {
    var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
    if (classmajorID == "") {
        $.messager.alert("系统提示", "请选择班级！");
        return;
    }
    var InSchoolStatus = $("#InSchoolStatusDictionaryDropDown").combobox("getValue");
    var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + '/SpecialityScoreSum/StudentScoreReport?MNU=' + mnu
    + "&ClassmajorID=" + classmajorID + "&InSchoolStatus=" + InSchoolStatus;
    $.popupTopWindow('学生成绩表', redirectTo, 1100, 550, null, null);
}

//个人成绩报表（广体等）
function StudentScore_NewReport() {
    var courseTypeIDs = document.getElementsByName("CourseTypeID");
    var courseTypeIDList = "";
    for (i = 0; i < courseTypeIDs.length; i++) {
        if (courseTypeIDs[i].checked) {
            var courseType = courseTypeIDs[i].value;
            courseTypeIDList = courseTypeIDList + courseType + ',';
        }
    }
    courseTypeIDList = courseTypeIDList.substring(0, courseTypeIDList.length - 1);
    var collegeID = $("#CollegeDropdown").combobox("getValue");
    var standardID = $("#DictionaryStandard").combogridX("getValue");

    var yearID = $("#DictionarySchoolyear").combobox("getValue");
    var schoolyearNumID = $("#DictionarySchoolyearNum").combobox("getValue");
    var schoolcodeID = $("#DictionarySchoolcode").combobox("getValue");
    var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
    //    if (classmajorID == "") {
    //        $.messager.alert("系统提示", "请选择班级！");
    //        return;
    //    }
    var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + '/SpecialityScoreSum/StudentScoreNewReport?MNU=' + mnu
    + "&CollegeID=" + collegeID + "&StandardID=" + standardID + "&YearID=" + yearID
    + "&SchoolyearNumID=" + schoolyearNumID + "&SchoolcodeID=" + schoolcodeID + "&ClassmajorID=" + classmajorID + "&CourseTypeID=" + courseTypeIDList;
    $.popupTopWindow('成绩报表', redirectTo, 1000, 550, null, null);
}

function QueryCollegeDropdownList(data) {
    if (((data.length && data.length > 0) || data)
        && $("#DictionarySchoolyear").length > 0 && $.data($("#DictionarySchoolyear")[0], "combobox")) {
        var url = CMS_SystemConfig.VirtualDirectoryPath + "/Common/SchoolYearDropDown?bindType=2";
        $("#DictionarySchoolyear").combobox("reload", url);
    }
}

function QueryYearDropdownList(data) {
    if (((data.length && data.length > 0) || data)
        && $("#DictionaryStandard").length > 0 && $.data($("#DictionaryStandard")[0], "combogridX")) {
        reloadStandard();
    }
}

function reloadStandard() {
    var url = CMS_SystemConfig.VirtualDirectoryPath + "/Facultymajor/BindStandardDropDownList?bindType=0";
    var collegeID = $("#CollegeDropdown").combobox("getValue");
    if (collegeID != nonSelect) url += "&collegeID=" + collegeID;
    $("#DictionaryStandard").combobox("reload", url);
}

function QueryStandardComboGrid(data) {
    if (((data.length && data.length > 0) || data)
        && $("#ClassmajorDropdown").length > 0 && $.data($("#ClassmajorDropdown")[0], "combobox")) {
        reloadClassmajor();
    }
}

//function reloadClassmajor() {
//    var url = CMS_SystemConfig.VirtualDirectoryPath + "/Classmajor/BindDropdownList?bindType=2";
//    var college = $("#CollegeDropdown").combobox("getValue");
//    var year = $("#DictionarySchoolyear").combobox("getValue");
//    var standard = $("#DictionaryStandard").combobox("getValue");
//    if (college != nonSelect) url += "&collegeID=" + college;
//    if (year != nonSelect) url += "&schoolYear=" + year;
//    if (standard != nonSelect) url += "&standardID=" + standard;

//    $("#ClassmajorDropdown").combobox("clear");
//    $("#ClassmajorDropdown").combobox("reload", url);
//}
//function QueryClassmajorDropdownList(data) {
//    if (((data.length && data.length > 0) || data)) {
//        if (isFirstLoadClassmajor) {
//            isFirstLoadClassmajor = false;
//        } else if (!isPageLoad) {
//            if (data.length > 0) {
//                $("#ClassmajorDropdown").combobox("setValue", data[0].Value);
//            } else {
//                $("#ClassmajorDropdown").combobox("clear");
//            }
//        }
//    }
//}
function reload() {
    //    var collegeID = $("#CollegeDropdown").combobox("getValue");
    var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
    //    var specialtyID = $("#DictionaryStandard").combogridX("getValue");
    //    var schoolyear = $("#DictionarySchoolyear").combobox("getValue");
    //    if (collegeID == "") {
    //        $.messager.alert("系统提示", "请选择" + EMIS_CollegeLabel + "！");
    //        return;
    //    }
    //    if (schoolyear == "-1") {
    //        $.messager.alert("系统提示", "请选择年级！");
    //        return;
    //    }
    //    if (specialtyID == "") {
    //        $.messager.alert("系统提示", "请选择专业！");
    //        return;
    //    } 
    //if (classmajorID == "") {
    //    $.messager.alert("系统提示", "请选择班级！");
    //    return;
    //}  
    SpecialityScoreSumTable();
}
function getExcel() {
    var collegeID = $("#CollegeDropdown").combobox("getValue");
    var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
    var specialtyID = $("#DictionaryStandard").combogridX("getValue");
    var schoolyear = $("#DictionarySchoolyear").combobox("getValue");
    var courseTypeIDs = document.getElementsByName("CourseTypeID");

    var Credit = $("#IsCredit").is(':checked')

    var courseTypeIDList = "";
    for (i = 0; i < courseTypeIDs.length; i++) {
        if (courseTypeIDs[i].checked) {
            var courseType = courseTypeIDs[i].value;
            courseTypeIDList = courseTypeIDList + courseType + ',';
        }
    }
    if (collegeID == "") {
        $.messager.alert("系统提示", "请选择" + EMIS_CollegeLabel + "！");
        return;
    }
    if (schoolyear == "-1") {
        $.messager.alert("系统提示", "请选择年级！");
        return;
    }
    if (specialtyID == "") {
        $.messager.alert("系统提示", "请选择专业！");
        return;
    }
    document.getElementById("formQuery").action = "GTExcel?CourseTypeIDs=" + courseTypeIDList + "&IsCredit=" + Credit;
    document.getElementById("formQuery").submit();
}
function queryStandard(data) {
    queryClass();

}
function queryClass() {
    var jsonString = "";
    var parameterString = "";
    //var campusID = $("#CampusDropdown").combogridX("getValue");
    var collegeID = $("#CollegeDropdown").combobox("getValue");
    var standardID = $("#DictionaryStandard").combogridX("getValue");
    var schoolyearID = $("#DictionarySchoolyear").combobox("getValue");
    if (schoolyearID != nonSelect) parameterString += "DictionaryGrade|*|" + schoolyearID + "|@|";
    //if (campusID != nonSelect) parameterString += "CampusDropdown|*|" + campusID + "|@|";
    if (collegeID != nonSelect) parameterString += "CollegeDropdown|*|" + collegeID + "|@|";
    if (standardID != nonSelect) parameterString += "DictionaryStandard|*|" + standardID + "|@|";
    if (parameterString != "") {
        jsonString = "({'QueryParamsDatas':'" + parameterString + "'})";
        $("#ClassmajorDropdown").combogridX("reload", eval(jsonString));
        $("#DictionaryStandard").combogridX("reload", eval(jsonString));
    } else {
        $("#ClassmajorDropdown").combogridX("reload");
        $("#DictionaryStandard").combogridX("reload", eval(jsonString));
    }
    //reload();
}