// 业务员申请退单列表 public void listserordercb() { String ddzt = StringUtil.toStr(this.getPara("ddzt")); String zfzt = StringUtil.toStr(this.getPara("zfzt")); String sjqrzt = StringUtil.toStr(this.getPara("sjqrzt")); String sfjd = StringUtil.toStr(this.getPara("sfjd")); SysUser abuser = this.getSessionAttr("abuser"); StringBuffer sb = new StringBuffer(); sb.append("select * from ("); sb.append("select ao.*, aoc.id cbid, aoc.cb_status from ("); sb.append("select * from ab_order where qdrid='" + abuser.getStr("id") + "' and ddzt<>'0' "); sb.append("AND TIMESTAMPDIFF(HOUR,xdsj,CURRENT_TIMESTAMP) > 1 "); sb.append("AND TIMESTAMPDIFF(HOUR,xdsj,CURRENT_TIMESTAMP) < 24 "); if (ddzt.length() > 0) { sb.append(" and ddzt='" + ddzt + "'"); } if (zfzt.length() > 0) { sb.append(" and zfzt='" + zfzt + "'"); } if (sjqrzt.length() > 0) { sb.append(" and sjqrzt='" + sjqrzt + "'"); } if (sfjd.length() > 0) { sb.append(" and sfjd='" + sfjd + "'"); } sb.append(") ao left join ab_order_chargeback aoc on aoc.order_id = ao.id"); sb.append(") a where cbid is null"); sb.append(" order by xdsj desc"); PageUtil listpage = DbPage.paginate(this.getParaToInt("curPage", 1), 14, sb.toString()); this.keepPara(); this.setAttr("listpage", listpage); this.render("/ab/mer/listmerordercb.html"); }
/*申请客服介入*/ public void applycbJudge() { SysUser abuser = this.getSessionAttr("abuser"); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String str_date = df.format(new Date()); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String cbid = this.getPara("cbid"); String inputRandomCode = this.getPara("captchaCode"); String content = this.getPara("content"); Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY); // 验证验证码 if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) { this.renderJson("1"); } // 验证content else if (StringUtil.isNull(content) || content.length() > 100) { this.renderJson("2"); } // 更新退单记录 else { AbOrderChargeback cb = AbOrderChargeback.dao.findById(cbid); cb.set(AbOrderChargeback.JUDGE_ID, abuser.get(SysUser.ID)); cb.set(AbOrderChargeback.JUDGE_DESC, content); cb.set(AbOrderChargeback.JUDGE_TIME, DateUtil.getCurrentDate()); cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE5); cb.set(AbOrderChargeback.STATUS, CommonStaticData.CB_STATUS2); cb.update(); String userid = abuser.getStr("id"); String roleid = abuser.getStr("role_id"); Record record = new Record(); record.set("id", StringUtil.getUuid32()); record.set("user_id", userid); record.set("role_id", roleid); record.set("mes_title", "退单消息"); record.set("mes_type", "0"); record.set("isread", "0"); record.set("text", "您已申请了客服介入!"); record.set("send_date", str_date); Db.save("message", record); this.renderJson("0"); } } }
@Before(AccessAbInterceptor.class) public void listorder() { SysUser abuser = this.getSessionAttr("abuser"); String sql = "select * from ab_order where xdrid='" + abuser.getStr("id") + "' order by xdsj desc"; PageUtil listpage = DbPage.paginate(this.getParaToInt("curPage", 1), 14, sql); this.setAttr("listpage", listpage); this.render("/ab/user/listorder.html"); }
/*用户退单列表*/ public void listcbforuser() { SysUser abuser = this.getSessionAttr("abuser"); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String sn = this.getPara("sn"); String name = this.getPara("mname"); String status = this.getPara("status"); PageUtil listpage = DbPage.paginate( this.getParaToInt("curPage", 1), 14, CommonSQL.findChargeBackForUser(abuser.getStr(SysUser.ID), sn, name, status)); this.setAttr("listpage", listpage); this.render("/ab/user/listorderchargeback.html"); } }
/*退单处理显示*/ public void showcb() { SysUser abuser = this.getSessionAttr("abuser"); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String cbid = this.getPara("id"); List<Record> list = Db.find(CommonSQL.getChargebackById(cbid)); CommonProcess.createChargebackImageFile(list); // 查询补充说明 List<Record> items = Db.find(CommonSQL.getChargebackItemByCbid(cbid)); CommonProcess.createImageFile(items); this.setAttr("items", items); this.setAttr("role", abuser.getStr(SysUser.ROLE_ID)); this.setAttr("cb", list.get(0)); this.render("/ab/user/listcbdetail.html"); } }
@Before(AccessAbInterceptor.class) public void list_order_cxtj() { SysUser abuser = this.getSessionAttr("abuser"); String kssj = StringUtil.toStr(this.getPara("kssj")); String jzsj = StringUtil.toStr(this.getPara("jzsj")); String ddzt = StringUtil.toStr(this.getPara("ddzt")); String queryType = StringUtil.toStr(this.getPara("queryType")); // String lastDate = StringUtil.toStr(this.getPara("lastDate")); if (queryType.equals("")) { queryType = "dayQuery"; setAttr("queryType", queryType); } Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.DATE, -1); // 得到前一天 Date date = calendar.getTime(); DateFormat df = new SimpleDateFormat("yyyy-MM-dd"); String str_lastDate = df.format(date); String sql = "select ao.*,tc.style style,tc.min_price min_price,tc.max_price max_price,tc.pay_type from ab_order ao left join ab_tc_express_order tc on tc.sn=ao.sn where qdrid='" + abuser.getStr("id") + "' "; if ("day".equals(queryType)) { // 日报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 59:59:59'"; } else if ("week".equals(queryType)) { // 周报表 sql += " and qdsj>='" + DateUtil.format(DateUtil.getMondayOfWeek(), "yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getSundayOfWeek(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("month".equals(queryType)) { // 月报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM") + "-01 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getLastDayOfMonth(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("dayQuery".equals(queryType)) { if (kssj.length() > 0) { sql += " and qdsj>='" + kssj + " 00:00:00'"; } if (jzsj.length() > 0) { sql += " and qdsj<='" + jzsj + " 59:59:59'"; } } else if ("monthWeekQuery".equals(queryType)) { String query_year_begin = getPara("query_year_begin"); String query_month_begin = getPara("query_month_begin"); String query_year_end = getPara("query_year_end"); String query_month_end = getPara("query_month_end"); sql += " and qdsj>='" + query_year_begin + "-" + query_month_begin + "-01 00:00:00'"; sql += " and qdsj<='" + query_year_end + "-" + query_month_end + "-31 59:59:59'"; } if (!ddzt.equals("-1") && !ddzt.equals("")) { sql += " and ddzt='" + ddzt + "' "; } sql += " order by xdsj desc"; PageUtil listpage = DbPage.paginate(this.getParaToInt("curPage", 1), 14, sql); sql = "SELECT qdrid,qdrname,COUNT(id) cnt,SUM(ddzje) je,SUBSTR(qdsj,1,10) rq FROM ab_order WHERE qdrid='" + abuser.getStr("id") + "' "; List<Record> listtj = null; if ("day".equals(queryType)) { // 日报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 59:59:59'"; } else if ("week".equals(queryType)) { // 周报表 sql += " and qdsj>='" + DateUtil.format(DateUtil.getMondayOfWeek(), "yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getSundayOfWeek(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("month".equals(queryType)) { // 月报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM") + "-01 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getLastDayOfMonth(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("dayQuery".equals(queryType)) { if (kssj.length() > 0) { sql += " and qdsj>='" + kssj + " 00:00:00'"; } if (jzsj.length() > 0) { sql += " and qdsj<='" + jzsj + " 59:59:59'"; } } else if ("monthWeekQuery".equals(queryType)) { String query_year_begin = getPara("query_year_begin"); String query_month_begin = getPara("query_month_begin"); String query_year_end = getPara("query_year_end"); String query_month_end = getPara("query_month_end"); sql += " and qdsj>='" + query_year_begin + "-" + query_month_begin + "-01 00:00:00'"; sql += " and qdsj<='" + query_year_end + "-" + query_month_end + "-31 59:59:59'"; } if (!ddzt.equals("-1") && !ddzt.equals("")) { sql += " and ddzt='" + ddzt + "' "; } sql += " GROUP BY SUBSTR(qdsj,1,10)"; listtj = Db.find(sql); Record r = null; sql = "SELECT COUNT(id) totleorder,IFNULL(SUM(ddzje),0) totalmoney FROM ab_order WHERE qdrid='" + abuser.getStr("id") + "'"; if ("day".equals(queryType)) { // 日报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.getCurrentDate("yyyy-MM-dd") + " 59:59:59'"; } else if ("week".equals(queryType)) { // 周报表 sql += " and qdsj>='" + DateUtil.format(DateUtil.getMondayOfWeek(), "yyyy-MM-dd") + " 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getSundayOfWeek(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("month".equals(queryType)) { // 月报表 sql += " and qdsj>='" + DateUtil.getCurrentDate("yyyy-MM") + "-01 00:00:00'"; sql += " and qdsj<='" + DateUtil.format(DateUtil.getLastDayOfMonth(), "yyyy-MM-dd") + " 59:59:59'"; } else if ("dayQuery".equals(queryType)) { if (kssj.length() > 0) { sql += " and qdsj>='" + kssj + " 00:00:00'"; } if (jzsj.length() > 0) { sql += " and qdsj<='" + jzsj + " 59:59:59'"; } } else if ("monthWeekQuery".equals(queryType)) { String query_year_begin = getPara("query_year_begin"); String query_month_begin = getPara("query_month_begin"); String query_year_end = getPara("query_year_end"); String query_month_end = getPara("query_month_end"); sql += " and qdsj>='" + query_year_begin + "-" + query_month_begin + "-01 00:00:00'"; sql += " and qdsj<='" + query_year_end + "-" + query_month_end + "-31 59:59:59'"; } if (!ddzt.equals("-1")) { sql += " and ddzt='" + ddzt + "' "; } r = Db.findFirst(sql); this.keepPara(); this.setAttr("r", r); this.setAttr("listtj", listtj); this.setAttr("listpage", listpage); this.render("/ab/ywy/list_order_cxtj.html"); }
/** 提现数据处理 */ public void txAction() { String uid = this.getPara("uid"); String WIDtotal_fee = StringUtil.toStr(this.getPara("WIDtotal_fee")); // 提现金额 String WIDout_trade_no = StringUtil.toStr(this.getPara("WIDout_trade_no")); // 交易流水号 String zffs = StringUtil.toStr(this.getPara("zzfs")); // 提现方式 String zfbzh = StringUtil.toStr(this.getPara("zfbzh")); // 支付宝账号 String yhkid = StringUtil.toStr(this.getPara("yhkid")); // 提现银行卡id String yhknum = StringUtil.toStr(this.getPara("yhknum")); // 提现银行卡卡号 String zfpwd = StringUtil.toStr(this.getPara("zfpwd")); // 支付密码 SysUser user = SysUser.dao.findById(uid); Map<String, Object> result = new HashMap<String, Object>(); try { if (Db.findFirst( "select count(*) ctn from sys_user_zfpwd where userid='" + user.getStr("loginid") + "' and zfpwd='" + zfpwd + "'") .getLong("ctn") == 0) { result.put("msg", "支付密码错误!"); result.put("result", RESULT_FAIL); } else if (user.getBigDecimal("zhye").subtract(new BigDecimal(WIDtotal_fee)).doubleValue() < 0) { // 账户余额不足以提现 result.put("result", RESULT_FAIL); result.put("msg", "账户余额不足!"); } else { user.set( "zhye", user.getBigDecimal("zhye") .subtract(new BigDecimal(WIDtotal_fee))); // 现将金额扣除,后期提现失败,提现金额退换 user.update(); this.setSessionAttr("abuser", user); if ("0".equals(zffs)) { // 支付宝提现 SysCzTx cztx = new SysCzTx(); cztx.set("id", StringUtil.getUuid32()); cztx.set("tradeno", WIDout_trade_no); cztx.set("type", 1); // 0-充值 1-提现 2-付款 cztx.set("result", 0); // 0-等待 1-成功 2-失败 cztx.set("totalfee", WIDtotal_fee); cztx.set("userid", user.getStr("id")); cztx.set("mc", user.getStr("mc")); cztx.set("time", DateUtil.getCurrentDate()); cztx.set("zfbaddress", zfbzh); cztx.set("txtype", 0); // 提现种类 0-支付宝 1-银行卡 cztx.save(); } else { // 银行卡提现 SysCzTx cztx = new SysCzTx(); cztx.set("id", StringUtil.getUuid32()); cztx.set("tradeno", WIDout_trade_no); cztx.set("type", 1); // 0-充值 1-提现 2-付款 cztx.set("result", 0); // 0-等待 1-成功 2-失败 cztx.set("totalfee", WIDtotal_fee); cztx.set("userid", user.getStr("id")); cztx.set("mc", user.getStr("mc")); cztx.set("txtype", 1); // 提现种类 0-支付宝 1-银行卡 cztx.set("txyhkid", yhkid); cztx.set("txyhknum", yhknum); cztx.set("time", DateUtil.getCurrentDate()); cztx.save(); } result.put("msg", "提现申请已经提交,约7个工作日内到账,请您耐心等待!"); result.put("result", RESULT_SUCCESS); } } catch (Exception e) { result.put("result", RESULT_FAIL); result.put("msg", "系统错误,请稍后重试!"); e.printStackTrace(); RestLogUtils.writeToLocal(RestLogUtils.getStackTrace(e), true); } this.renderJson(result); }
/** 申请退单 */ public void addchargeback() { SysUser abuser = this.getSessionAttr("abuser"); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String inputRandomCode = this.getPara("backCaptchaCode"); String orderId = this.getPara("orderid"); String content = this.getPara("applyBackContent"); String img_url = this.getPara("apyimg"); Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY); // 验证验证码 if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) { this.renderJson("1"); } // 验证content else if (StringUtil.isNull(content) || content.length() > 100) { this.renderJson("2"); } // 判断是否已经申请退单 else if (AbOrderChargeback.dao.findFirst( "select * from ab_order_chargeback where order_id = '" + orderId + "'") != null) { this.renderJson("3"); } // 插入退单记录 else { abuser = SysUser.dao.findById(abuser.get("id")); AbOrder order = AbOrder.dao.findById(orderId); AbOrderChargeback cb = new AbOrderChargeback(); cb.set(AbOrderChargeback.ID, StringUtil.getUuid32()); cb.set(AbOrderChargeback.MER_ID, order.getStr(AbOrder.MID)); cb.set(AbOrderChargeback.XDR_ID, order.getStr(AbOrder.XDRID)); cb.set(AbOrderChargeback.QDR_ID, order.getStr(AbOrder.QDRID)); cb.set(AbOrderChargeback.ORDER_ID, orderId); cb.set(AbOrderChargeback.APPLY_ID, abuser.get(SysUser.ID)); cb.set(AbOrderChargeback.APPLY_DESC, content); cb.set(AbOrderChargeback.APPLY_TIME, DateUtil.getCurrentDate()); cb.set(AbOrderChargeback.STATUS, CommonStaticData.CB_STATUS1); // 申请人类型 1 用户 2商户 3业务员 if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) { cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE1); cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER); } else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) { cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE2); cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT); } else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) { cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE8); cb.set(AbOrderChargeback.APPLY_TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE); } if (!StringUtil.isNull(img_url)) { FileInputStream file = null; try { file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url); } catch (FileNotFoundException e) { e.printStackTrace(); } cb.set(AbOrderChargeback.APPLY_IMG_URL, img_url); cb.set(AbOrderChargeback.APPLY_IMG, file); } cb.save(); String sn = order.getStr("sn"); String userid = abuser.getStr("id"); String roleid = abuser.getStr("role_id"); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String str_date = df.format(new Date()); Record record = new Record(); record.set("id", StringUtil.getUuid32()); record.set("user_id", userid); record.set("role_id", roleid); record.set("mes_title", "退单消息"); record.set("mes_type", "0"); record.set("isread", "0"); record.set("text", "申请退单成功!订单号:" + sn); record.set("send_date", str_date); Db.save("message", record); this.renderJson("0"); } } }
/*商户回复 1同意退单,2申诉*/ public void addcbReponse() { SysUser abuser = this.getSessionAttr("abuser"); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String str_date = df.format(new Date()); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String cbid = this.getPara("cbid"); String agree = this.getPara("agree"); String inputRandomCode = this.getPara("captchaCode"); String content = this.getPara("content"); Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY); // 验证验证码 if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) { this.renderJson("1"); } // 验证content else if (StringUtil.isNull(content) || content.length() > 100) { this.renderJson("2"); } // 更新退单记录 else { AbOrderChargeback cb = AbOrderChargeback.dao.findById(cbid); cb.set(AbOrderChargeback.REP_DESC, content); cb.set(AbOrderChargeback.REP_TIME, DateUtil.getCurrentDate()); SysUser mer = SysUser.dao.findById(abuser.getStr(SysUser.ID)); SysUser user = SysUser.dao.findById(cb.getStr(AbOrderChargeback.XDR_ID)); // 同意 if (agree.equals("1")) { // 更新退单状态 cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE6); cb.set(AbOrderChargeback.STATUS, CommonStaticData.CB_STATUS3); // 金额 AbOrder order = AbOrder.dao.findById(cb.getStr(AbOrderChargeback.ORDER_ID)); BigDecimal money = order.getBigDecimal(AbOrder.DDZJE); // 更新订单状态 order.set(AbOrder.DDZT, "5"); order.update(); // 商户余额金额减少 BigDecimal merye = mer.getBigDecimal(SysUser.ZHYE); mer.set(SysUser.ZHYE, merye.subtract(money)); mer.update(); // 用户余额增加 BigDecimal userye = mer.getBigDecimal(SysUser.ZHYE); user.set(SysUser.ZHYE, userye.add(money)); // 判断是否已经支付,如果已经支付,则扣除积分 if ("1".equals(order.getStr(AbOrder.ZFZT))) { int jf = user.getInt(SysUser.JIFEN); int mjf = money.setScale(0, BigDecimal.ROUND_HALF_UP).intValue(); user.set(SysUser.JIFEN, jf - mjf); } user.update(); String sn = order.getStr("sn"); String userid = user.getStr("id"); String roleid = user.getStr("role_id"); Record record = new Record(); record.set("id", StringUtil.getUuid32()); record.set("user_id", userid); record.set("role_id", roleid); record.set("mes_title", "退单消息"); record.set("mes_type", "0"); record.set("isread", "0"); record.set("text", "商户同意退单!订单号:" + sn); record.set("send_date", str_date); Db.save("message", record); } else { cb.set(AbOrderChargeback.CB_STATUS, CommonStaticData.CB_TYPE3); String userid = user.getStr("id"); String roleid = user.getStr("role_id"); Record record = new Record(); record.set("id", StringUtil.getUuid32()); record.set("user_id", userid); record.set("role_id", roleid); record.set("mes_title", "退单消息"); record.set("mes_type", "0"); record.set("isread", "0"); record.set("text", "商户已提起申诉!"); record.set("send_date", str_date); Db.save("message", record); } cb.update(); this.renderJson("0"); } } }
/*用户,商户增加补充证据*/ public void addcomplement() { SysUser abuser = this.getSessionAttr("abuser"); if (abuser == null || abuser.get("id") == null) { redirect("/ab/login"); } else { String cbid = this.getPara("cbid"); String inputRandomCode = this.getPara("comCaptchaCode"); String content = this.getPara("comContent"); String img_url = this.getPara("apyimg"); Object objMd5RandomCode = this.getSessionAttr(CaptchaRender.DEFAULT_CAPTCHA_MD5_CODE_KEY); // 验证验证码 if (!CaptchaRender.validate(objMd5RandomCode.toString(), inputRandomCode)) { this.renderJson("1"); } // 验证content else if (StringUtil.isNull(content) || content.length() > 100) { this.renderJson("2"); } // 插入退单补充记录 else { abuser = SysUser.dao.findById(abuser.get("id")); AbOrderChargebackItem aoci = new AbOrderChargebackItem(); aoci.set(AbOrderChargebackItem.ID, StringUtil.getUuid32()); aoci.set(AbOrderChargebackItem.CBID, cbid); aoci.set(AbOrderChargebackItem.UID, abuser.getStr(SysUser.ID)); if (CommonStaticData.USER_TYPE_MEMBER.equals(abuser.get(SysUser.ROLE_ID))) { aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MEMBER); } else if (CommonStaticData.USER_TYPE_MERCHANT.equals(abuser.get(SysUser.ROLE_ID))) { aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_MERCHANT); } else if (CommonStaticData.USER_TYPE_SERVICE.equals(abuser.get(SysUser.ROLE_ID))) { aoci.set(AbOrderChargebackItem.TYPE, CommonStaticData.CB_APPLYTYPE_SERVICE); } aoci.set(AbOrderChargebackItem.CONTENT, content); aoci.set(AbOrderChargebackItem.DATETIME, DateUtil.getCurrentDate()); if (img_url != null) { FileInputStream file = null; try { file = new FileInputStream(PathKit.getWebRootPath() + "\\upload\\" + img_url); } catch (FileNotFoundException e) { e.printStackTrace(); } aoci.set(AbOrderChargebackItem.IMG_URL, img_url); aoci.set(AbOrderChargebackItem.IMAGE, file); } aoci.save(); String userid = abuser.getStr("id"); String roleid = abuser.getStr("role_id"); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String str_date = df.format(new Date()); Record record = new Record(); record.set("id", StringUtil.getUuid32()); record.set("user_id", userid); record.set("role_id", roleid); record.set("mes_title", "退单消息"); record.set("mes_type", "0"); record.set("isread", "0"); record.set("text", "证据已补充!"); record.set("send_date", str_date); Db.save("message", record); this.renderJson("0"); } } }