/**
* 處理確定加選學生低修高選課內容之方法
*
* @param mapping org.apache.struts.action.ActionMapping object
* @param form org.apache.struts.action.ActionForm object
* @param request javax.servlet.http.HttpServletRequest object
* @param response javax.servlet.http.HttpServletResponse object
* @return org.apache.struts.action.ActionForward object
* @exception java.lang.Exception
*/
public ActionForward addHigherCourse(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
MemberManager mm = (MemberManager) getBean(MEMBER_MANAGER_BEAN_NAME);
CourseManager cm = (CourseManager) getBean(COURSE_MANAGER_BEAN_NAME);
ActionMessages messages = new ActionMessages();
Seld seld = (Seld) request.getSession(false).getAttribute("seldInfoForOnline");
try {
Student student = mm.findStudentByNo(seld.getStudentNo());
cm.txAddSelectedSeld(seld, student, "1", true);
String idno = getUserCredential(request.getSession(false)).getMember().getIdno();
cm.txSaveAdcdHistory(seld.getDtimeOid(), student.getStudentNo().toUpperCase(), idno, "A");
messages.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("Message.CreateSuccessful"));
saveMessages(request, messages);
Toolket.resetCheckboxCookie(response, SELD_LIST_NAME);
return list(mapping, form, request, response);
} catch (SeldException se) {
ActionMessages errors = new ActionMessages();
errors.add(
ActionMessages.GLOBAL_MESSAGE, new ActionMessage("Course.errorN1", se.getMessage()));
saveErrors(request, errors);
if (se.getMessage().indexOf("衝堂") != StringUtils.INDEX_NOT_FOUND) {
// 目前會拒絕衝堂課程進行加選
Dtime dtime = cm.findDtimeBy(seld.getDtimeOid());
Csno csno = cm.findCourseInfoByCscode(dtime.getCscode());
request.setAttribute("csnoInfo", csno);
request.setAttribute("classInfo", Toolket.getClassFullName(dtime.getDepartClass()));
setContentPage(request.getSession(false), "course/ConflictList.jsp");
return list(mapping, form, request, response);
} else return list(mapping, form, request, response);
}
}
/**
* 處理確定加選學生選課內容之方法
*
* @param mapping org.apache.struts.action.ActionMapping object
* @param form org.apache.struts.action.ActionForm object
* @param request javax.servlet.http.HttpServletRequest object
* @param response javax.servlet.http.HttpServletResponse object
* @return org.apache.struts.action.ActionForward object
* @exception java.lang.Exception
*/
public ActionForward add(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
CourseManager cm = (CourseManager) getBean(COURSE_MANAGER_BEAN_NAME);
HttpSession session = request.getSession(false);
DynaActionForm aForm = (DynaActionForm) form;
Seld seld = processSeldByForm(aForm);
session.setAttribute("seldInfoForOnline", seld);
Dtime dtime = cm.findDtimeBy(seld.getDtimeOid());
ActionMessages messages = validateInputForUpdate(aForm, Toolket.getBundle(request));
if (!messages.isEmpty()) {
saveErrors(request, messages);
return mapping.findForward(IConstants.ACTION_MAIN_NAME);
} else {
try {
// 會以紙本作業完成加選,無需考慮衝堂問題
// 選課人數上線於前端JavaScript判斷
// 跨選設定不允許須阻擋並顯示訊息
// 會顯示衝堂訊息
MemberManager mm = (MemberManager) getBean(MEMBER_MANAGER_BEAN_NAME);
ScoreManager sm = (ScoreManager) getBean(IConstants.SCORE_MANAGER_BEAN_NAME);
Student student = mm.findStudentByNo(seld.getStudentNo());
ScoreHist scoreHist = new ScoreHist(student.getStudentNo());
List<ScoreHist> scoreHistList = sm.findScoreHistBy(scoreHist);
String[] cscodeHist = new String[0];
Float[] scoreList = new Float[0];
float passScore = Toolket.getPassScoreByDepartClass(student.getDepartClass());
for (ScoreHist hist : scoreHistList) {
cscodeHist = (String[]) ArrayUtils.add(cscodeHist, hist.getCscode().toUpperCase());
// 抵免要給分數,不然就會被當做無修課記錄而被加選成功
if ("6".equals(hist.getEvgrType()))
scoreList =
(Float[])
ArrayUtils.add(
scoreList, hist.getScore() != null ? hist.getScore() : passScore);
else scoreList = (Float[]) ArrayUtils.add(scoreList, hist.getScore());
}
int ind = 0, startIndex = 0;
boolean isHist = false;
do {
ind = ArrayUtils.indexOf(cscodeHist, seld.getCscode().toUpperCase(), startIndex);
startIndex = ind + 1;
// 判斷是否選過且及格
isHist =
ind != StringUtils.INDEX_NOT_FOUND
&& scoreList[ind] != null
&& scoreList[ind] >= passScore;
} while (!isHist && ind != StringUtils.INDEX_NOT_FOUND);
// 特殊班級(跨校生等)無條件加選
String[] specialDepartClass = {"1152A", "1220", "122A", "122B", "2220"};
String[] addGrade = {"42", "52"}; // 2技學生年級要+2
int stuGrade =
ArrayUtils.contains(specialDepartClass, student.getDepartClass())
? 9
: Integer.parseInt(StringUtils.substring(student.getDepartClass(), 4, 5));
stuGrade =
ArrayUtils.contains(addGrade, StringUtils.substring(student.getDepartClass(), 1, 3))
? stuGrade + 2
: stuGrade;
int dtimeGrade = Integer.parseInt(StringUtils.substring(dtime.getDepartClass(), 4, 5));
if (isHist) {
messages.add(
ActionMessages.GLOBAL_MESSAGE,
new ActionMessage("Course.errorN1", "歷年資料查詢到已修過該科目，請確認，謝謝!!"));
saveErrors(request, messages);
} else if (stuGrade >= dtimeGrade) {
// 判斷學生年級與課程所開班級年級
cm.txAddSelectedSeld(seld, student, "1", true);
String idno = getUserCredential(request.getSession(false)).getMember().getIdno();
cm.txSaveAdcdHistory(seld.getDtimeOid(), student.getStudentNo().toUpperCase(), idno, "A");
if (ind != StringUtils.INDEX_NOT_FOUND)
messages.add(
ActionMessages.GLOBAL_MESSAGE,
new ActionMessage("Course.errorN1", "該科目於歷年資料有查詢到，但該科目未及格，所以加選成功。"));
else
messages.add(
ActionMessages.GLOBAL_MESSAGE, new ActionMessage("Message.CreateSuccessful"));
saveMessages(request, messages);
} else {
messages.add(
ActionMessages.GLOBAL_MESSAGE,
new ActionMessage(
"Course.messageN1",
"注意：學生低修高年級課程，加選作業尚未完成！<br/>"
+ " 按下[再次確定]鍵後課程才會加入學生選課資料中。"));
saveErrors(request, messages);
setContentPage(request.getSession(false), "course/OnlineAddHigherCourse.jsp");
return mapping.findForward(IConstants.ACTION_MAIN_NAME);
}
Toolket.resetCheckboxCookie(response, SELD_LIST_NAME);
return list(mapping, form, request, response);
} catch (SeldException se) {
ActionMessages errors = new ActionMessages();
errors.add(
ActionMessages.GLOBAL_MESSAGE, new ActionMessage("Course.errorN1", se.getMessage()));
saveErrors(request, errors);
if (se.getMessage().indexOf("衝堂") != StringUtils.INDEX_NOT_FOUND) {
// 目前會拒絕衝堂課程進行加選
dtime = cm.findDtimeBy(seld.getDtimeOid());
Csno csno = cm.findCourseInfoByCscode(dtime.getCscode());
request.setAttribute("csnoInfo", csno);
request.setAttribute("classInfo", Toolket.getClassFullName(dtime.getDepartClass()));
setContentPage(request.getSession(false), "course/ConflictList.jsp");
return list(mapping, form, request, response);
} else return list(mapping, form, request, response);
}
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
WebApplicationContext ctx =
WebApplicationContextUtils.getRequiredWebApplicationContext(this.getServletContext());
CourseManager manager = (CourseManager) ctx.getBean("courseManager");
HttpSession session = request.getSession(false);
boolean b = false;
if (request.getParameter("count") != null) {
b = true;
}
List students = (List) session.getAttribute("students");
ByteArrayOutputStream ba = new ByteArrayOutputStream();
try {
Document document = new Document(PageSize.A6.rotate(), 5, 5, 5, 5);
PdfWriter writer = PdfWriter.getInstance(document, ba);
document.open();
Image image = null;
Clazz clazz;
Student stmd;
String SchoolName;
String DeptName;
StringBuilder StudentNo;
Map map;
Map StmdCardNum;
// writer = PdfWriter.getInstance(document, ba);
PdfContentByte cb = writer.getDirectContent();
BaseFont bf = BaseFont.createFont("/kaiu.ttf", "Identity-H", BaseFont.EMBEDDED);
for (int i = 0; i < students.size(); i++) {
stmd =
(Student)
manager
.hqlGetBy(
"FROM Student WHERE studentNo='"
+ ((Map) students.get(i)).get("student_no")
+ "'")
.get(0);
clazz =
(Clazz)
manager.hqlGetBy("FROM Clazz WHERE ClassNo='" + stmd.getDepartClass() + "'").get(0);
map =
manager.ezGetMap(
"SELECT * FROM dept WHERE no='" + clazz.getClassNo().substring(0, 4) + "'");
try { // 系所名
DeptName = map.get("fname").toString();
} catch (Exception e) {
DeptName = "";
}
try { // 部制名
SchoolName = map.get("school_name").toString();
} catch (Exception e) {
SchoolName = "";
}
StudentNo = new StringBuilder(stmd.getStudentNo());
// List list=manager.hqlGetBy("FROM StdImage WHERE studentNo='"+StudentNo+"'");
/*
if(b&&manager.testOnlineServer()){//寫入補發記錄
try{
//真實學號
manager.executeSql("INSERT INTO StmdCardNum (student_no, card_num)VALUES('"+stmd.getStudentNo()+"', 1)");
}catch(Exception e){
manager.executeSql("UPDATE StmdCardNum SET card_num=card_num+1 WHERE student_no='"+stmd.getStudentNo()+"'");
}
StudentNo.append(manager.ezGetString("SELECT card_num FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'"));
sendMailToLib(stmd, StudentNo.toString(), request);
}else{
//檢查是否已發卡
StmdCardNum=manager.ezGetMap("SELECT * FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'");
if(StmdCardNum!=null){
StudentNo.append(manager.ezGetString("SELECT card_num FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'"));
}
}
*/
StmdCardNum = manager.ezGetMap("SELECT * FROM StmdCardNum WHERE student_no='");
// 學號不滿8碼補空白, 未來改為9碼時？
if (StudentNo.length() <= 8) {
for (int j = StudentNo.length(); j < 8; j++) {
StudentNo.append(" ");
}
}
// 照片
try {
image = getImage(StudentNo.toString());
} catch (Exception e) {
continue;
}
if (image == null) continue;
image.scaleAbsolute(54.94f, 74.37f);
image.setAbsolutePosition(18, 166);
// 條碼
Barcode39 code39 = new Barcode39();
code39.setCode(StudentNo.toString());
code39.setBarHeight(20);
code39.setX(0.95f);
code39.setStartStopText(false);
code39.setGuardBars(false);
code39.setExtended(false);
code39.setChecksumText(false);
code39.setSize(-1f);
Image imageCode39 = code39.createImageWithBarcode(cb, null, null);
imageCode39.setAbsolutePosition(83.15f, 152);
cb.setColorStroke(Color.white);
cb.rectangle(18, 150, 54.94f, 9); // 30
cb.setLineWidth(10);
cb.stroke();
cb.closePath();
cb.closePathEoFillStroke();
cb.closePathFillStroke();
cb.closePathStroke();
// 文字
cb.beginText(); // 部制
cb.setFontAndSize(bf, 10);
cb.showTextAligned(PdfContentByte.ALIGN_LEFT, SchoolName, 118, 229, 0);
cb.endText();
cb.beginText(); // 科系
cb.setFontAndSize(bf, 10);
if (DeptName.length() >= 9) {
cb.setFontAndSize(bf, 8);
}
if (DeptName.length() >= 14) {
cb.setFontAndSize(bf, 6);
}
cb.showTextAligned(PdfContentByte.ALIGN_LEFT, DeptName, 118, 215, 0);
cb.endText();
cb.beginText(); // 學號
cb.setFontAndSize(bf, 10);
cb.showTextAligned(PdfContentByte.ALIGN_LEFT, stmd.getStudentNo(), 118, 201, 0);
cb.endText();
cb.beginText(); // 姓名
cb.setFontAndSize(bf, 10);
cb.showTextAligned(PdfContentByte.ALIGN_LEFT, stmd.getStudentName(), 118, 187, 0);
cb.endText();
document.add(image);
document.add(imageCode39);
document.newPage();
// bf=null;
}
document.close();
writer.close();
response.setHeader(
"Content-Disposition", "attachment;filename=EmplCard" + Math.random() * 10 + ".pdf");
response.setContentLength(ba.size());
response.flushBuffer();
ServletOutputStream out = response.getOutputStream();
ba.writeTo(out);
ba.close();
out.flush();
} catch (Exception e) {
e.printStackTrace();
try {
Document document = new Document(PageSize.A6.rotate(), 5, 5, 5, 5);
PdfWriter writer = PdfWriter.getInstance(document, ba);
document.open();
PdfContentByte cb = writer.getDirectContent();
BaseFont bf = BaseFont.createFont("/kaiu.ttf", "Identity-H", BaseFont.EMBEDDED);
cb.beginText(); // 部制
cb.setFontAndSize(bf, 10);
cb.showTextAligned(PdfContentByte.ALIGN_LEFT, "讀取資料有誤:" + e, 120, 226, 0);
cb.endText();
// document.add(cb );
document.close();
document = null;
} catch (DocumentException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
response.setContentType("text/html; charset=UTF-8");
response.setContentType("application/pdf");
response.setHeader("Content-disposition", "attachment;filename=TechTimetable.pdf");
response.setContentLength(ba.size());
ServletOutputStream out = response.getOutputStream();
ba.writeTo(out);
out.flush();
}
}