/* * 提交款项支付 */ public String sub(HttpServletRequest request,HttpServletResponse response) throws Exception { Map map1 = dataBaseControl.getOneResultSet("select *from fi_payfor t where t.id = ?", new Object[]{request.getParameter("id")}); String type = ""+map1.get("type"); dataBaseControl.beginTransaction(); dataBaseControl.executeSql("update fi_payfor t set t.payforstate = '1' where t.id = ?", new Object[]{request.getParameter("id")}); if(!type.equals("1")) { List payforitemlist =dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ?", new Object[]{request.getParameter("id")}); for(int i = 0 ; i < payforitemlist.size();i++) { Map map = (Map)payforitemlist.get(i); Map iomap = (Map)dataBaseControl.getOneResultSet("select * from gm_materiel_inout t where t.id = ?", new Object[]{map.get("inout_id")}); Gm_materiel_inout gm_materiel_inout = new Gm_materiel_inout(); BeanUtils.populate(gm_materiel_inout, iomap); gm_materiel_inout.setIspay("1"); dataBaseControl.updateByBean(gm_materiel_inout); } } dataBaseControl.endTransaction(); return "/fi/fi_payfor/Fi_payfor!paysearchList.do"; }
public String searchById(HttpServletRequest request,HttpServletResponse response) throws Exception { Page page=search1(request,1,1); request.setAttribute("look", "1"); Map map1 = dataBaseControl.getOneResultSet("select t.* from fi_payfor t where t.id = ?", new Object[]{request.getParameter("id")}); String type = ""+map1.get("type"); request.setAttribute("accid", map1.get("id")); request.setAttribute("record", ((ArrayList)page.getThisPageElements()).get(0)); request.setAttribute("btnDisplay", "display:none"); String forward = ""; if(!type.equals("1")) //与材料相关 { List list = dataBaseControl.getOutResultSet("select t.*,c.prj_id,(select p.name from pr_project p where p.id=c.prj_id)pname,r.ration_apply_id,(select m.name from materiel m where m.id = t.materiel_id) maname,(select s.name from supplier s where s.id = t.gongys) gys from fi_payfor_item t,gm_purchase r,gm_purchase_item c where t.f_id = ? and t.purchase_item_id = c.id and c.purchase_id = r.id order by t.id ", new Object[]{request.getParameter("id")}); request.setAttribute("reslist", list); forward = "/fi/payfor/fi_payforpayDtl.jsp"; } else //与材料无关 { Map map2 = dataBaseControl.getOneResultSet("select t.*,s.name,s.id sid," + "(select b.name from hr_base_info b where t.p_id = b.id)pname " + "from fi_payfor t,supplier s where t.id = ? and t.note = s.id", new Object[]{request.getParameter("id")}); request.setAttribute("info", map2); List slist = dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? order by t.id", new Object[]{map2.get("id")}); request.setAttribute("slist", slist); forward = "/fi/payfor/nlfi_payforDtl.jsp"; } List splist = dataBaseControl.getOutResultSet("select t.*," + "(select b.name from hr_base_info b where b.id = t.audit_id)pname " + "from fi_payfor_audit t where t.apply_id = ? order by t.id ",new Object[]{request.getParameter("id")}); request.setAttribute("splist", splist); buildDDL(request); return forward; }
/* * 修改时删除子项 */ public String delete(HttpServletRequest request,HttpServletResponse response) throws Exception { Map map = dataBaseControl.getOneResultSet("select * from fi_payfor_item t where t.id = ? ", new Object[]{request.getParameter("id")}); Map payformap = dataBaseControl.getOneResultSet("select t.* from fi_payfor t where t.id = ?", new Object[]{map.get("f_id")}); String type = ""+payformap.get("type"); if(!type.equals("1")) { Map map1 = dataBaseControl.getOneResultSet("select * from gm_purchase_item t where t.id = ?", new Object[]{map.get("purchase_item_id")}); Gm_purchase_item gm_purchase_item =new Gm_purchase_item(); BeanUtils.populate(gm_purchase_item, map1); int hasnum = gm_purchase_item.getYfsl() - Integer.parseInt(map.get("num").toString()); gm_purchase_item.setYfsl(hasnum); dataBaseControl.updateByBean(gm_purchase_item); Map map2 = dataBaseControl.getOneResultSet("select * from gm_materiel_inout t where t.id = ?", new Object[]{map.get("inout_id")}); Gm_materiel_inout gm_materiel_inout = new Gm_materiel_inout(); BeanUtils.populate(gm_materiel_inout, map2); gm_materiel_inout.setIspay("0"); dataBaseControl.updateByBean(gm_materiel_inout); } dataBaseControl.executeSql("DELETE FROM fi_payfor_item WHERE ID in (?)", new Object[]{request.getParameter("id")}); List list= dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? ", new Object[]{map.get("f_id")}); String flag = "0"; if(list == null || list.isEmpty()) { dataBaseControl.executeSql("DELETE FROM fi_payfor WHERE ID in (?)", new Object[]{map.get("f_id")}); flag = "1"; } else { } return "/fi/fi_payfor/Fi_payfor!edit.do?id="+map.get("f_id")+"&flag="+flag+"&type="+request.getParameter("type"); }
/* * 作废 */ public String zuofei(HttpServletRequest request,HttpServletResponse response) throws Exception { String IsPostBack = request.getParameter("IsPostBack"); if(IsPostBack!=null && !IsPostBack.equals("")&&IsPostBack.equals("1")){ Map map = dataBaseControl.getOneResultSet("select * from fi_payfor t where t.id = ?", new Object[]{request.getParameter("payforid")}); Fi_payfor fi_payfor = new Fi_payfor(); BeanUtils.populate(fi_payfor, map); fi_payfor.setPayforstate("9"); fi_payfor.setZfreason(request.getParameter("zfreason")); dataBaseControl.updateByBean(fi_payfor); request.setAttribute("operationSign", "closeDG_refreshW();"); } else { Page page=search1(request,1,1); if(page.getTotalNumberOfElements()>0) { request.setAttribute("record", ((ArrayList)page.getThisPageElements()).get(0)); } request.setAttribute("btnDisplay", "display:none"); buildDDL(request); List list = dataBaseControl.getOutResultSet("select t.*,r.ration_apply_id,(select m.name from materiel m where m.id = t.materiel_id) maname,(select s.name from supplier s where s.id = t.gongys) gys from fi_payfor_item t,gm_purchase r,gm_purchase_item c where t.f_id = ? and t.purchase_item_id = c.id and c.purchase_id = r.id order by t.id ", new Object[]{request.getParameter("id")}); request.setAttribute("reslist", list); } request.setAttribute("IsPostBack", "1"); return "/fi/payfor/fi_payforpayDtl.jsp"; }
public String tongji(HttpServletRequest request,HttpServletResponse response) throws Exception { Map map = dataBaseControl.getOneResultSet("select * from fi_payfor_item t where t.id = ? ", new Object[]{request.getParameter("id")}); dataBaseControl.executeSql("DELETE FROM fi_payfor_item WHERE ID in (?)", new Object[]{request.getParameter("id")}); List list= dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? ", new Object[]{map.get("f_id")}); String flag = "0"; if(list == null || list.isEmpty()) { dataBaseControl.executeSql("DELETE FROM fi_payfor WHERE ID in (?)", new Object[]{map.get("f_id")}); flag = "1"; } else { } return "/fi/fi_payfor/Fi_payfor!edit.do?id="+map.get("f_id")+"&flag="+flag; }
//按恭元伟代码继续编码,实属无奈... //打印---仅与材料无关部分 public String print(HttpServletRequest request,HttpServletResponse response) throws Exception { String idString = request.getParameter("id"); String IsPostBack = request.getParameter("IsPostBack"); request.setAttribute("IsPostBack", "1"); if(IsPostBack!=null && !IsPostBack.equals("")&&IsPostBack.equals("1")){ int count = Integer.parseInt((dataBaseControl.getOneResultSet("select print from fi_payfor where id=?", new Object[]{idString})).get("print").toString()); count++; dataBaseControl.executeSql("update fi_payfor set print=? where id=?", new Object[]{count,idString}); request.setAttribute("operationSign", "closeDG_refreshW();"); } //获取类型,是否与材料有关 Map typeMap = dataBaseControl.getOneResultSet("select t.type from fi_payfor t where t.id = ?", new Object[]{idString}); String type = null; if(typeMap.size()!=0){ type= ""+typeMap.get("type"); } Map mainMap = null; List itemlist = null; if(type.equals("1")){ mainMap = dataBaseControl.getOneResultSet("select t.*,s.name,s.id sid," + "(select mb.branchname from mrbranch mb where mb.id=t.dept_id) dept_name," + "(select b.name from hr_base_info b where t.p_id = b.id) pname " + "from fi_payfor t,supplier s where t.id = ? and t.note = s.id", new Object[]{idString}); //明细清单 itemlist = dataBaseControl.getOutResultSet("select t.applyreason,t.fujnum,t.money from fi_payfor_item t where t.f_id = ? order by t.id", new Object[]{idString}); }else{ List mainList = dataBaseControl.getTopResultSet("select t.*," + "(select s.name from supplier s where s.id = gi.gongys) name," + "(select mb.branchname from mrbranch mb where mb.id=t.dept_id) dept_name, " + "(select b.name from hr_base_info b where t.p_id = b.id) pname " + "from fi_payfor t,fi_payfor_item pi,gm_purchase_item gi where t.id = ? " + "and t.id = pi.f_id and pi.purchase_item_id = gi.id", new Object[]{idString} ,1); if(mainList.size()!=0){ mainMap=(Map) mainList.get(0); } itemlist = dataBaseControl.getOutResultSet("select " + "(select m.name from materiel m where m.id = t.materiel_id) applyreason," + "t.fujnum,t.money from fi_payfor_item t where t.f_id = ? order by t.id", new Object[]{idString}); } //主表map request.setAttribute("main", mainMap); request.setAttribute("itemlist", itemlist); //审批意见 //部门经理 List dmList = dataBaseControl.getTopResultSet("select hb.name,t.opinion,t.audit_date from fi_payfor_audit t,hr_base_info hb,fi_payfor fp where fp.id=t.apply_id(+) and t.audit_id = hb.id(+) and hb.dept_id = fp.dept_id and fp.id=? order by t.id desc", new Object[]{idString}, 1); //会计 List cpaList = dataBaseControl.getTopResultSet("select hb.name,t.opinion,t.audit_date from fi_payfor_audit t,hr_base_info hb,fi_payfor fp where fp.id=t.apply_id(+) and t.audit_id=hb.id(+) and hb.dept_id=6 and hb.duty_id=1 and t.apply_id=? order by t.id desc", new Object[]{idString}, 1); //财务经理 List fmList = dataBaseControl.getTopResultSet("select hb.name,t.opinion,t.audit_date from fi_payfor_audit t,hr_base_info hb,fi_payfor fp where fp.id=t.apply_id(+) and t.audit_id=hb.id(+) and hb.dept_id=6 and hb.duty_id=2 and t.apply_id=? order by t.id desc", new Object[]{idString}, 1); //公司领导 List gmList = dataBaseControl.getTopResultSet("select hb.name,t.opinion,t.audit_date from fi_payfor_audit t,hr_base_info hb where t.audit_id=hb.id(+) and hb.duty_id!=1 and hb.duty_id!=2 and t.apply_id=? order by t.id desc", new Object[]{idString}, 1); Map dmMap = null; Map cpaMap = null; Map fmMap = null; Map gmMap = null; if(dmList.size()!=0){ dmMap = (Map) dmList.get(0); } if(cpaList.size()!=0){ cpaMap = (Map) cpaList.get(0); } if(fmList.size()!=0){ fmMap = (Map) fmList.get(0); } if(gmList.size()!=0){ gmMap = (Map) gmList.get(0); } request.setAttribute("dmMap", dmMap); request.setAttribute("fmMap", fmMap); request.setAttribute("gmMap", gmMap); request.setAttribute("cpaMap", cpaMap); buildDDL(request); return "/fi/payfor/print.jsp"; }
/* * 和材料无关的款项支付 */ public String addpayfor(HttpServletRequest request, HttpServletResponse response) throws Exception { String IsPostBack = request.getParameter("IsPostBack"); if(IsPostBack!=null && !IsPostBack.equals("")&&IsPostBack.equals("1")){ try { Long id = dataBaseControl.getSeq(Fi_payfor.class); dataBaseControl.beginTransaction(); double total = 0 ; Map user = (Map)request.getSession().getAttribute("user"); String ck1 = request.getParameter("ck1")==null?"0":request.getParameter("ck1"); String ck2 = request.getParameter("ck2")==null?"0":request.getParameter("ck2"); String ck3 = request.getParameter("ck3")==null?"0":request.getParameter("ck3"); String ck4 = request.getParameter("ck4")==null?"0":request.getParameter("ck4"); String ck5 = request.getParameter("ck5")==null?"0":request.getParameter("ck5"); if(ck1.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea1")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money1")==null||request.getParameter("money1").equals(""))?"0":request.getParameter("money1"))); fi_payfor_item.setFujnum(request.getParameter("fuj1")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money1")==null||request.getParameter("money1").equals(""))?"0":request.getParameter("money1")); fi_payfor_item.setGongys(new Integer(request.getParameter("gongys"))); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck2.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea2")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money2")==null||request.getParameter("money2").equals(""))?"0":request.getParameter("money2"))); fi_payfor_item.setFujnum(request.getParameter("fuj2")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money2")==null||request.getParameter("money2").equals(""))?"0":request.getParameter("money2")); fi_payfor_item.setGongys(new Integer(request.getParameter("gongys"))); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck3.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea3")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money3")==null||request.getParameter("money3").equals(""))?"0":request.getParameter("money3"))); fi_payfor_item.setFujnum(request.getParameter("fuj3")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money3")==null||request.getParameter("money3").equals(""))?"0":request.getParameter("money3")); fi_payfor_item.setGongys(new Integer(request.getParameter("gongys"))); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck4.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea4")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money4")==null||request.getParameter("money4").equals(""))?"0":request.getParameter("money4"))); fi_payfor_item.setFujnum(request.getParameter("fuj4")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money4")==null||request.getParameter("money4").equals(""))?"0":request.getParameter("money4")); fi_payfor_item.setGongys(new Integer(request.getParameter("gongys"))); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck5.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea5")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money5")==null||request.getParameter("money5").equals(""))?"0":request.getParameter("money5"))); fi_payfor_item.setFujnum(request.getParameter("fuj5")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money5")==null||request.getParameter("money5").equals(""))?"0":request.getParameter("money5")); fi_payfor_item.setGongys(new Integer(request.getParameter("gongys"))); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } Fi_payfor fi_payfor = new Fi_payfor(); fi_payfor.setP_id(new BigDecimal(user.get("base_info_id").toString())); fi_payfor.setDept_id(new BigDecimal(user.get("branchid").toString())); fi_payfor.setOdate(new java.sql.Date((new java.util.Date()).getTime())); fi_payfor.setPayforstate(request.getParameter("state")); fi_payfor.setMoney(new BigDecimal(total+"")); fi_payfor.setPaytype(request.getParameter("paytype")); fi_payfor.setNote(request.getParameter("note")); fi_payfor.setNote(request.getParameter("gongys")); fi_payfor.setBmoney(NumToRmb.toHanStr(total)); fi_payfor.setSk_id(new BigDecimal(request.getParameter("gongys"))); fi_payfor.setPjdtype(request.getParameter("pjdtype")); fi_payfor.setType("1"); dataBaseControl.insertByBean(fi_payfor, id); } catch (Exception e) { System.out.println(e); } finally{ dataBaseControl.endTransaction(); } request.setAttribute("operationSign", "closeDG_refreshW();"); String num = ""; String infor = "您有一条款项支付申请待审批"; List slist = dataBaseControl.getOutResultSet("select t.* from message t where t.rolename = 1 and t.dept = 3 ", null); if(slist!=null&&!slist.isEmpty()) { Map smap = (Map)slist.get(0); num = smap.get("num").toString(); } PHPRPC_Client client = new PHPRPC_Client(Constant.HTTPDRESS); Mas m = (Mas) client.useService(Mas.class); m.sendGFDZ(num,infor); }else{ Long id = dataBaseControl.getSeq(Fi_payfor.class); request.setAttribute("accid", id+1);//当插入数据之后id就+1了,所有查看的是id+1的那条数据 } buildDDL(request); request.setAttribute("editMod", "addpayfor"); request.setAttribute("IsPostBack", "1"); return "/fi/payfor/nfi_payforDtl.jsp"; }
/* * 提交修改后的款项支付 */ public String sub1(HttpServletRequest request, HttpServletResponse response) throws Exception { Map user = (Map)request.getSession().getAttribute("user"); Map map = dataBaseControl.getOneResultSet("select * from fi_payfor t where t.id = ?", new Object[]{request.getParameter("payforid")}); List itemlist = (List)dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? order by t.id", new Object[]{request.getParameter("payforid")}); Object[] checkbox = request.getParameterValues("checkbox"); Fi_payfor fi_payfor = new Fi_payfor(); BeanUtils.populate(fi_payfor, map); if(checkbox.length!=0) { dataBaseControl.beginTransaction(); float total = 0 ; for(int j = 0 ; j < itemlist.size();j++) { boolean flag = false; Map tmap = (Map)itemlist.get(j); String id = tmap.get("id").toString(); for(int i = 0 ; i < checkbox.length;i++) { String nid = checkbox[i].toString(); if(id.equals(nid)) //分配付款时仍然保留 { flag = true; } } if(flag)//分配付款保留的 { float money = 0; Map map1 = dataBaseControl.getOneResultSet("select * from fi_payfor_item t where t.id = ?", new Object[]{id}); Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); BeanUtils.populate(fi_payfor_item, map1); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); //fi_payfor_item.setNum(new Integer(request.getParameter("num"+checkbox[i].toString()).equals("")?"0":request.getParameter("num"+checkbox[i].toString()))); money = Float.valueOf(fi_payfor_item.getMoney()+"") ; total = total + money; fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); dataBaseControl.updateByBean(fi_payfor_item); } else//此次分配付款未勾选的,删除记录,并将其设置为"未付状态" { Map map1 = dataBaseControl.getOneResultSet("select * from gm_purchase_item t where t.id = ?", new Object[]{tmap.get("purchase_item_id")}); Gm_purchase_item gm_purchase_item =new Gm_purchase_item(); BeanUtils.populate(gm_purchase_item, map1); int hasnum = gm_purchase_item.getYfsl() - Integer.parseInt(tmap.get("num").toString()); gm_purchase_item.setYfsl(hasnum); dataBaseControl.updateByBean(gm_purchase_item); Map map2 = dataBaseControl.getOneResultSet("select * from gm_materiel_inout t where t.id = ?", new Object[]{tmap.get("inout_id")}); Gm_materiel_inout gm_materiel_inout = new Gm_materiel_inout(); BeanUtils.populate(gm_materiel_inout, map2); gm_materiel_inout.setIspay("0"); dataBaseControl.updateByBean(gm_materiel_inout); dataBaseControl.executeSql("DELETE FROM fi_payfor_item WHERE ID in (?)", new Object[]{tmap.get("id")}); } } fi_payfor.setOdate(new java.sql.Date((new java.util.Date()).getTime())); fi_payfor.setPayforstate(request.getParameter("opinionid")); fi_payfor.setMoney(new BigDecimal(map.get("money").toString())); fi_payfor.setPaytype(request.getParameter("paytype")); fi_payfor.setNote(request.getParameter("note")); fi_payfor.setBmoney(NumToRmb.toHanStr(Double.parseDouble(map.get("money").toString()))); dataBaseControl.updateByBean(fi_payfor); dataBaseControl.endTransaction(); request.setAttribute("operationSign", "closeDG_refreshW();"); ///////////////////////分配付款后的短信提醒(财务主管) String num=null; String infor=null; List slist = dataBaseControl.getOutResultSet("select t.* from message t where t.rolename = 2 ", null); if(slist!=null&&!slist.isEmpty()) { Map smap = (Map)slist.get(0); num = smap.get("num").toString(); infor = "您有一条款项支付申请待审批"; } PHPRPC_Client client = new PHPRPC_Client(Constant.HTTPDRESS); Mas m = (Mas) client.useService(Mas.class); m.sendGFDZ(num,infor); } return "/fi/payfor/fi_payforpayDtl.jsp"; }
/* * 修改款项支付 */ public String edit(HttpServletRequest request,HttpServletResponse response) throws Exception { String IsPostBack = request.getParameter("IsPostBack"); String forward = ""; request.setAttribute("type", request.getParameter("type")); if(IsPostBack!=null && !IsPostBack.equals("")&&IsPostBack.equals("1")){ String id = request.getParameter("id"); dataBaseControl.beginTransaction(); List slist = dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? order by t.id ", new Object[]{id}); double total = 0; for(int i = 0 ; i < slist.size();i++) { Map map = (Map)slist.get(i); Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); BeanUtils.populate(fi_payfor_item, map); fi_payfor_item.setApplyreason(request.getParameter("rea"+fi_payfor_item.getId())); fi_payfor_item.setMoney(new BigDecimal(request.getParameter("money"+fi_payfor_item.getId()))); fi_payfor_item.setFujnum(request.getParameter("fuj"+fi_payfor_item.getId())); total = total + Double.valueOf(request.getParameter("money"+fi_payfor_item.getId())); dataBaseControl.updateByBean(fi_payfor_item); } Map user = (Map)request.getSession().getAttribute("user"); String ck1 = request.getParameter("ck1")==null?"0":request.getParameter("ck1"); String ck2 = request.getParameter("ck2")==null?"0":request.getParameter("ck2"); String ck3 = request.getParameter("ck3")==null?"0":request.getParameter("ck3"); String ck4 = request.getParameter("ck4")==null?"0":request.getParameter("ck4"); String ck5 = request.getParameter("ck5")==null?"0":request.getParameter("ck5"); if(ck1.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea1")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money1")==null||request.getParameter("money1").equals(""))?"0":request.getParameter("money1"))); fi_payfor_item.setFujnum(request.getParameter("fuj1")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money1")==null||request.getParameter("money1").equals(""))?"0":request.getParameter("money1")); fi_payfor_item.setGongys(0); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck2.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea2")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money2")==null||request.getParameter("money2").equals(""))?"0":request.getParameter("money2"))); fi_payfor_item.setFujnum(request.getParameter("fuj2")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money2")==null||request.getParameter("money2").equals(""))?"0":request.getParameter("money2")); fi_payfor_item.setGongys(0); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck3.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea3")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money3")==null||request.getParameter("money3").equals(""))?"0":request.getParameter("money3"))); fi_payfor_item.setFujnum(request.getParameter("fuj3")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money3")==null||request.getParameter("money3").equals(""))?"0":request.getParameter("money3")); fi_payfor_item.setGongys(0); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck4.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea4")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money4")==null||request.getParameter("money4").equals(""))?"0":request.getParameter("money4"))); fi_payfor_item.setFujnum(request.getParameter("fuj4")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money4")==null||request.getParameter("money4").equals(""))?"0":request.getParameter("money4")); fi_payfor_item.setGongys(0); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } if(ck5.equals("1")) { Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); fi_payfor_item.setApplyreason(request.getParameter("rea5")); fi_payfor_item.setMoney(new BigDecimal((request.getParameter("money5")==null||request.getParameter("money5").equals(""))?"0":request.getParameter("money5"))); fi_payfor_item.setFujnum(request.getParameter("fuj5")); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setPurchase_item_id(new Integer(0)); fi_payfor_item.setMateriel_id(0); fi_payfor_item.setNum(new Integer(0)); fi_payfor_item.setPrice(new BigDecimal(0)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); total = total + Double.valueOf((request.getParameter("money5")==null||request.getParameter("money5").equals(""))?"0":request.getParameter("money5")); fi_payfor_item.setGongys(0); fi_payfor_item.setInout_id(0); dataBaseControl.insertByBean(fi_payfor_item); } Map map1 = dataBaseControl.getOneResultSet("select t.* from fi_payfor t where t.id = ?", new Object[]{id}); request.setAttribute("accid", map1.get("id")); Fi_payfor fi_payfor = new Fi_payfor(); BeanUtils.populate(fi_payfor, map1); fi_payfor.setPayforstate(request.getParameter("state")); fi_payfor.setMoney(new BigDecimal(total+"")); fi_payfor.setPaytype(request.getParameter("paytype")); fi_payfor.setPjdtype(request.getParameter("pjdtype")); fi_payfor.setBmoney(NumToRmb.toHanStr(total)); fi_payfor.setNote(request.getParameter("gongys")); dataBaseControl.updateByBean(fi_payfor); dataBaseControl.endTransaction(); forward = "/fi/payfor/nlfi_payforDtl.jsp"; request.setAttribute("operationSign", "closeDG_refreshW();"); } else { Map map1 = dataBaseControl.getOneResultSet("select t.* from fi_payfor t where t.id = ?", new Object[]{request.getParameter("id")}); String type = ""+map1.get("type"); request.setAttribute("accid", map1.get("id")); buildDDL(request); if(!type.equals("1")) //与材料相关 { Page page=search1(request,1,1); if(page.getTotalNumberOfElements()>0) { request.setAttribute("record", ((ArrayList)page.getThisPageElements()).get(0)); } request.setAttribute("btnDisplay", "display:none"); String flag = request.getParameter("flag")==null?"0":request.getParameter("flag"); if(flag.equals("1")) { request.setAttribute("operationSign", "closeDG_refreshW();"); } request.setAttribute("type", "modify"); List list = dataBaseControl.getOutResultSet("select t.*,c.prj_id,(select p.name from pr_project p where p.id=c.prj_id)pname,r.ration_apply_id,(select m.name from materiel m where m.id = t.materiel_id) maname,(select s.name from supplier s where s.id = t.gongys) gys from fi_payfor_item t,gm_purchase r,gm_purchase_item c where t.f_id = ? and t.purchase_item_id = c.id and c.purchase_id = r.id order by t.id", new Object[]{request.getParameter("id")}); request.setAttribute("reslist", list); request.setAttribute("ssize", list.size()); forward = "/fi/payfor/fi_payforpayDtl.jsp"; } else //与材料无关 { Map map2 = dataBaseControl.getOneResultSet("select t.*,s.name,s.id sid,(select b.name from hr_base_info b where t.p_id = b.id)pname from fi_payfor t,supplier s where t.id = ? and t.note = s.id", new Object[]{request.getParameter("id")}); request.setAttribute("info", map2); Map user = (Map)request.getSession().getAttribute("user"); request.setAttribute("applyid", user.get("base_info_id")); List slist = dataBaseControl.getOutResultSet("select * from fi_payfor_item t where t.f_id = ? order by t.id", new Object[]{map2.get("id")}); request.setAttribute("slist", slist); request.setAttribute("ssize", 5-slist.size()); forward = "/fi/payfor/nlfi_payforDtl.jsp"; } } List splist = dataBaseControl.getOutResultSet("select t.*,(select b.name from hr_base_info b where b.id = t.audit_id)pname from fi_payfor_audit t where t.apply_id = ? order by t.id ",new Object[]{request.getParameter("id")}); request.setAttribute("splist", splist); request.setAttribute("editMod", "edit"); request.setAttribute("IsPostBack", "1"); return forward; }
/* * 保存新增款项支付 */ public String save(HttpServletRequest request,HttpServletResponse response) throws Exception { Map user = (Map)request.getSession().getAttribute("user"); Object[] checkbox = request.getParameterValues("checkbox"); String[] danju = request.getParameterValues("danju"); String mapro=null; if(checkbox.length!=0) { Long id = dataBaseControl.getSeq(Fi_payfor.class); dataBaseControl.beginTransaction(); for(int i = 0 ; i < checkbox.length;i++) { float money = 0; Map iomap = (Map)dataBaseControl.getOneResultSet("select * from gm_materiel_inout t where t.id = ?", new Object[]{checkbox[i]}); Gm_materiel_inout inout = new Gm_materiel_inout(); BeanUtils.populate(inout, iomap); if(request.getParameter("opinionid").equals("1")) { inout.setIspay("1"); dataBaseControl.updateByBean(inout); } Map map = dataBaseControl.getOneResultSet("select * from gm_purchase_item t where t.id = ?", new Object[]{iomap.get("purchase_item_id")}); Fi_payfor_item fi_payfor_item = new Fi_payfor_item(); Gm_purchase_item purchase_item = new Gm_purchase_item(); BeanUtils.populate(purchase_item, map); mapro=map.get("prj_id").toString(); fi_payfor_item.setInout_id(new Integer(checkbox[i].toString())); fi_payfor_item.setPro_id(Integer.parseInt(map.get("prj_id").toString())); fi_payfor_item.setPurchase_item_id(new Integer(purchase_item.getId()+"")); fi_payfor_item.setOdate(new java.sql.Date((new java.util.Date()).getTime())); fi_payfor_item.setMateriel_id(purchase_item.getMateriel_id()); fi_payfor_item.setNum(new Integer(iomap.get("num").toString())); fi_payfor_item.setPrice(new BigDecimal(iomap.get("price").toString())); money =Float.valueOf(fi_payfor_item.getNum())*Float.valueOf(fi_payfor_item.getPrice().toString()); fi_payfor_item.setMoney(new BigDecimal(money)); fi_payfor_item.setPerson(new Integer(user.get("base_info_id").toString())); fi_payfor_item.setGongys(purchase_item.getGongys()); fi_payfor_item.setF_id(new Integer(id+"")); fi_payfor_item.setFujnum(danju[i]); dataBaseControl.insertByBean(fi_payfor_item); int hasnum = purchase_item.getYfsl(); hasnum = hasnum + new Integer(iomap.get("num").toString()); purchase_item.setYfsl(hasnum); dataBaseControl.updateByBean(purchase_item); } Fi_payfor fi_payfor = new Fi_payfor(); fi_payfor.setP_id(new BigDecimal(user.get("base_info_id").toString())); fi_payfor.setDept_id(new BigDecimal(user.get("branchid").toString())); fi_payfor.setOdate(new java.sql.Date((new java.util.Date()).getTime())); fi_payfor.setPayforstate(request.getParameter("opinionid")); fi_payfor.setMoney(new BigDecimal(request.getParameter("editTotal"))); fi_payfor.setPaytype(request.getParameter("paytype")); fi_payfor.setNote(request.getParameter("note")); fi_payfor.setBmoney(NumToRmb.toHanStr(Double.parseDouble(request.getParameter("editTotal")))); fi_payfor.setSk_id(new BigDecimal(sk_id)); fi_payfor.setPro_id(Integer.parseInt(mapro)); dataBaseControl.insertByBean(fi_payfor, id); dataBaseControl.endTransaction(); String num = ""; String infor = "您有一条款项支付申请待审批"; List slist = dataBaseControl.getOutResultSet("select t.* from message t where t.rolename = 1 and t.dept = 3 ", null); if(slist!=null&&!slist.isEmpty()) { Map smap = (Map)slist.get(0); num = smap.get("num").toString(); } PHPRPC_Client client = new PHPRPC_Client(Constant.HTTPDRESS); Mas m = (Mas) client.useService(Mas.class); m.sendGFDZ(num,infor); request.setAttribute("operationSign", "closeDG_refreshW();"); }else{ Long id = dataBaseControl.getSeq(Fi_payfor.class); request.setAttribute("accid", id); } return "/fi/payfor/fi_payforDtl.jsp"; }