public void edit(HttpServletRequest request, HttpServletResponse response) throws Exception { pre(request, response); Long id = ServletRequestUtils.getLongParameter(request, "id", -1); if (id != -1) { Stockout so = new Stockout(this.db).findByPk(id); log.debug("so list=" + so); so.setOffName(offname); request.setAttribute("so", so); Staff report_staff = so.getReportStaff(); if (report_staff != null) { request.setAttribute("staff_name", report_staff.getFullName()); request.setAttribute("report_to_posname", report_staff.getReport_to_posname()); } Staff transfer_staff = so.getTransferByStaff(); if (transfer_staff != null) request.setAttribute("staff_name2", transfer_staff.getFullName()); EdOffice office_to = so.getOfficeTo(); // log.debug(so.toString()); if (office_to != null) request.setAttribute("offname_to", office_to.getOffname()); this.setStockoutItemList(request, so); } String reset = ServletRequestUtils.getStringParameter(request, "reset", ""); if (!"".equals(reset)) { this.tranLogSave(TRAN_LOG_MSG_RESET); } String display = ServletRequestUtils.getStringParameter(request, "display", ""); if (!"".equals(display)) { this.tranLogSave(TRAN_LOG_MSG_DISPLAY); } Unit unit = new Unit(this.db); String uSql = "select u.unit_code, u.thname, du.group_id "; uSql += " from unit u"; uSql += " inner join duty_unit du on du.unit_code=u.unit_code "; uSql += " where du.used_for in ('A','S') "; uSql += " and to_date(sysdate) between to_date(du.begin_date) and to_date(nvl(du.end_date,sysdate)) "; uSql += " order by u.thname"; log.debug("Transfer Unit List " + uSql); List<Map<String, Object>> unitlist = unit.findBySql(uSql); if (request.getParameter("SaveMsg") != null) request.setAttribute("SaveMsg", "1"); forward(JSP_FORM_PAGE, request, response); }
public void create(HttpServletRequest request, HttpServletResponse response) throws Exception { // HttpSession session = request.getSession(); // UserSession us = (UserSession)session.getValue(Constants.USER_SESSION); pre(request, response); Stockout so = new Stockout(this.db); String job_no = so.genJobNo(String.valueOf(offcode)); so.setJob_no(job_no); so.setOffName(offname); so.setStockout_date(new Date()); so.setTransfer_by(uData.getIdCard()); request.setAttribute("so", so); request.setAttribute("staff_name2", uData.getFullName()); this.tranLogSave(TRAN_LOG_MSG_CREATE); forward(JSP_FORM_PAGE, request, response); }
/** * Business Logic for get data from request to model * * @param request * @param stock_out */ protected boolean processUpdate(HttpServletRequest request) { Long id = ServletRequestUtils.getLongParameter(request, "id", -1); // String job_no = ServletRequestUtils.getStringParameter(request, "job_no", ""); String stockout_code1 = ServletRequestUtils.getStringParameter(request, "stockout_code1", ""); String stockout_code2 = ServletRequestUtils.getStringParameter(request, "stockout_code2", ""); String stockout_date = ServletRequestUtils.getStringParameter(request, "stockout_date", ""); String subject = ServletRequestUtils.getStringParameter(request, "subject", ""); String subject_type = ServletRequestUtils.getStringParameter(request, "subject_type", ""); String report_to_staff = ServletRequestUtils.getStringParameter(request, "report_to_staff", ""); String report_to_posname = ServletRequestUtils.getStringParameter(request, "report_to_posname", ""); String offcode_to = ServletRequestUtils.getStringParameter(request, "offcode_to", ""); String transfer_by = ServletRequestUtils.getStringParameter(request, "transfer_by", ""); Long legislation_id = ServletRequestUtils.getLongParameter(request, "legislation_id", -1); String remarks = ServletRequestUtils.getStringParameter(request, "remarks", ""); String group_id = ServletRequestUtils.getStringParameter(request, "product_group_id", ""); Stockout stock_out = new Stockout(this.db); boolean id_exist = false; if (id != -1) { // if id not equals -1 then process update try { stock_out = stock_out.findByPk(id); id_exist = true; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); log.error("Fail on Load Stockout:" + e.getMessage()); } } // stock_out.setJob_no(job_no); stock_out.setStockout_code(stockout_code1 + "/" + stockout_code2); stock_out.setStockout_date(DateUtil.getDateFromString(stockout_date)); stock_out.setSubject(subject); stock_out.setSubject_type(subject_type); if (legislation_id != -1) stock_out.setLegislation_id(legislation_id); stock_out.setReport_to_staff(report_to_staff); stock_out.setReport_to_posname(report_to_posname); if (!"".equals(offcode_to)) stock_out.setOffcode_to(offcode_to); if (!"".equals(transfer_by)) stock_out.setTransfer_by(transfer_by); stock_out.setRemarks(remarks); // set optional field stock_out.setStockout_type("5"); stock_out.setGroup_id(group_id); if (id_exist) { try { stock_out.setUpdate_by(update_by); stock_out.setUpdate_on(update_on); stock_out = stock_out.update(); updateChildExhibit(request, stock_out); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); log.error("Fail on Update Stockout:" + e.getMessage()); } } else { try { stock_out.setJob_no( new RunningKey(db).getRunningKey("STOCKOUT", "STOCKOUT_TYPE", "5", offcode)); stock_out.setCreate_by(create_by); stock_out.setCreate_on(create_on); stock_out.setOffcode(offcode); stock_out = stock_out.create(); updateChildExhibit(request, stock_out); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); log.error("Fail on Create Stockout:" + e.getMessage()); } } re_id = (stock_out.getId() == null) ? -1 : stock_out.getId(); return id_exist; }