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();
}
}
