public boolean sendTestEmailInfo(String emailType, String name, String bookTable, String toEmail)
throws Exception {
boolean flag = false;
if (ToolsOfString.isNull(toEmail)) return flag;
toAddr = toEmail;
if (getMailTemplate(emailType)) {
String[] replace = {"studName", name, "bookList", bookTable};
flag = replaceAndSend(replace);
}
return flag;
}
// ========================= private function start here =====================
private boolean getMailTemplate(String mailType) throws Exception {
EmailDAOImpl eMailDao = new EmailDAOImpl();
Email eMailBean = eMailDao.getEmail(conn, mailType);
if (eMailBean != null) {
content = ToolsOfString.chkNullString(eMailBean.getEmContent());
sender = ToolsOfString.chkNullString(eMailBean.getEmSender());
subject = ToolsOfString.chkNullString(eMailBean.getEmSubject());
if (ToolsOfString.isNull(cc)) cc = ToolsOfString.chkNullString(eMailBean.getEmCc());
bcc = ToolsOfString.chkNullString(eMailBean.getEmBcc());
return true;
}
return false;
}
/**
* The doPost method of the servlet. <br>
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
Connection conn = null;
try {
// 使用連接池獲取連接
DataSource ds = (DataSource) getServletConfig().getServletContext().getAttribute("dbpool");
conn = ds.getConnection();
conn.setAutoCommit(false);
String userId = request.getSession().getAttribute("userId").toString();
String curIntake = request.getSession().getAttribute("curIntake").toString();
String isbn = null;
if (request.getParameter("isbn") != null && !request.getParameter("isbn").equals("")) {
isbn = request.getParameter("isbn").trim();
}
String fromDate = null;
if (request.getParameter("fromDate") != null
&& !request.getParameter("fromDate").equals("")) {
fromDate = request.getParameter("fromDate");
}
String toDate = null;
if (request.getParameter("toDate") != null && !request.getParameter("toDate").equals("")) {
toDate = request.getParameter("toDate");
}
BookDAOImpl bookDAOImpl = new BookDAOImpl();
OrderDetailDAOImpl orderDetailDAOImpl = new OrderDetailDAOImpl();
BookPurchasingDAOImpl bookPurchasingDAOImpl = new BookPurchasingDAOImpl();
String type = null;
if (request.getParameter("type") != null && !request.getParameter("type").equals("")) {
type = request.getParameter("type");
}
// add
String changetype = null;
changetype = request.getParameter("changetype");
// add
if (type != null && type.equals("changeBook")) {
List list = null;
if (request.getSession().getAttribute("list") != null) {
list = (List) request.getSession().getAttribute("list");
}
String sId = request.getParameter("sId");
String[] id = sId.split(";");
String remarks = request.getParameter("remarks");
if (!ToolsOfString.isNull(remarks)) {
remarks = new String(remarks.getBytes("ISO-8859-1"), "UTF-8");
}
if (changetype.equals("S")) {
int confrimQty = 0;
// 該Isbn值為要更新的Isbn
// List<OrDetail> changeIsbnlist = orderDetailDAOImpl.getChangeBookList(conn, curIntake,
// isbn, confrimQty);
List<OrDetail> changeIsbnlist =
orderDetailDAOImpl.getChangeNoActindBookList(conn, curIntake, isbn, confrimQty);
List<OrDetail> updateList = new ArrayList();
List<OrDetail> unUpdateList = new ArrayList<OrDetail>();
boolean updateFlag = true;
if (list != null && !list.isEmpty()) {
for (int i = 0; i < list.size(); i++) {
for (int j = 0; j < id.length; j++) {
Integer doId = Integer.parseInt(id[j]);
if (doId == i) {
OrDetail od = (OrDetail) list.get(i);
boolean flag = true;
if (changeIsbnlist != null && !changeIsbnlist.isEmpty()) {
for (OrDetail orDetail : changeIsbnlist) {
// 若同一個訂單內含有要更換的isbn就不再更新 remove by xfke
/*if (od.getOrderSeqNo() == orDetail .getOrderSeqNo()) {
unUpdateList.add(orDetail);
flag = false;
break;
}*/
// 若同一個訂單內含有要更換的ISBN，則被更換的ISBN改為 actind='N'，要更換的ISBN改為actind='Y'
if (od.getOrderSeqNo() == orDetail.getOrderSeqNo()) {
od.setActInd("N");
od.setUpdUid(userId);
orDetail.setActInd("Y");
orDetail.setUpdUid(userId);
if (orderDetailDAOImpl.updateOrderDetailInfo(conn, od)
&& orderDetailDAOImpl.updateOrderDetailInfo(conn, orDetail)) {
updateFlag = true;
// 并不是真正的置換，只是修改兩個記錄的actind
unUpdateList.add(orDetail);
} else {
updateFlag = false;
}
flag = false;
break;
}
}
}
if (flag) {
od.setUpdDate(new Date());
od.setUpdUid(userId);
od.setActInd("Y");
updateList.add(od);
}
}
}
}
}
request.setAttribute("unUpdateList", unUpdateList);
if (updateList != null && !updateList.isEmpty()) {
for (OrDetail od : updateList) {
try {
if (orderDetailDAOImpl.changeOrDetailIsbn(conn, od, isbn, remarks) == false) {
updateFlag = false;
break;
}
} catch (Exception e) {
conn.rollback();
request.setAttribute("msg", e.getMessage());
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
}
} else if (unUpdateList == null || unUpdateList.isEmpty()) {
request.setAttribute("msg", "沒有可以置換的圖書記錄！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
if (updateFlag) {
conn.commit();
request.setAttribute("msg", "圖書置換成功！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
} else {
conn.rollback();
request.setAttribute("msg", "圖書置換失敗！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
} else if (changetype.equals("P")) {
// List<BookPurchasingBean> changeIsbnlist =
// bookPurchasingDAOImpl.getBookPurchasingBeanByIsbn(conn, isbn, curIntake, null, null,
// true);
List<BookPurchasingBean> updateList = new ArrayList<BookPurchasingBean>();
List<BookPurchasingBean> unUpdateList = new ArrayList<BookPurchasingBean>();
if (list != null && !list.isEmpty()) {
for (int i = 0; i < list.size(); i++) {
for (int j = 0; j < id.length; j++) {
Integer doId = Integer.parseInt(id[j]);
if (doId == i) {
BookPurchasingBean od = (BookPurchasingBean) list.get(i);
if (od.getBookPurchase().getQuantity() == od.getBookPurchase().getLeave()) {
// NEW ISBN
od.getBook().setIsbn(isbn);
od.setChangeRemarks(remarks);
od.getBookPurchase().setUpdDate(new Date());
od.getBookPurchase().setUpdUid(userId);
updateList.add(od);
} else {
unUpdateList.add(od);
}
}
}
}
}
request.setAttribute("unUpdateList", unUpdateList);
if (updateList != null && !updateList.isEmpty()) {
boolean updateFlag = true;
for (BookPurchasingBean bPurchasingBean : updateList) {
try {
if (bookPurchasingDAOImpl.changeIsbnList(conn, bPurchasingBean) == false) {
updateFlag = false;
break;
}
} catch (Exception e) {
conn.rollback();
request.setAttribute("msg", e.getMessage());
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
}
if (updateFlag) {
conn.commit();
request.setAttribute("msg", "圖書置換成功！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
} else {
conn.rollback();
request.setAttribute("msg", "圖書置換失敗！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
} else {
request.setAttribute("msg", "沒有可以置換的圖書記錄！");
request.setAttribute("type", "changeBook");
request.setAttribute("changetype", changetype);
request.getRequestDispatcher("msg.jsp").forward(request, response);
}
}
} else if (type != null && type.equals("checkChangeIsbn")) {
Book book = bookDAOImpl.getBookByPK(conn, isbn);
if (book != null && book.getIsbn() != null) {
out.print("Y");
} else {
out.print("N");
}
} else {
request.getSession().removeAttribute("list");
int confrimQty = 1;
// add rainbow
request.setAttribute("changetype", changetype);
if (changetype.equals("S")) {
List list =
orderDetailDAOImpl.getChangeBookList(
conn, curIntake, isbn, fromDate, toDate, confrimQty);
request.setAttribute("list", list);
request.getSession().setAttribute("list", list);
} else {
List list =
bookPurchasingDAOImpl.getBookPurchasingBeanByIsbn(
conn, isbn, curIntake, fromDate, toDate, true);
request.setAttribute("list", list);
request.getSession().setAttribute("list", list);
}
// add rainbow
request.setAttribute("isbn", isbn);
request.setAttribute("fromDate", fromDate);
request.setAttribute("toDate", toDate);
request.getRequestDispatcher("changeBookResult.jsp").forward(request, response);
}
} catch (Exception e) {
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
// throw new ServletException (e);
} finally {
try {
if (conn != null && !conn.isClosed()) conn.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
}
}
private boolean sendMail() {
if (ToolsOfString.isNull(toAddr)) return false;
return super.send(subject, content, toAddr, toName, sender, cc, bcc);
}