WF公务车新需求：申请单和派车单编号修改

1.需求：申请单改成YCSQD_日期_1 2 3累加，跨年后重新从1开始累加，派车单改成申请单编号_CCD

2.找到相关代码

原申请单编号生成代码：YCSQD_20170410_1、YCSQD_20170410_2、YCSQD_20170411_1、YCSQD_20170411_2

原代码：

@Overridepublic synchronized String getNextApplyId(){    String prefix = applyIdPrefix;    String date = null;    String oldId = null;        if (Util.isEmpty(applyIdPrefix)) {        prefix = com.jsecode.platform.util.SysConfig.getString("veh.use.apply.applyid.prefix");        applyIdPrefix = prefix;    }        String today = DateUtil.formatDate(new Date(), "yyyyMMdd");    Integer maxApplyId = null;         StringBuffer newId = new StringBuffer();    newId.append(prefix).append("_").append(today).append("_");        if (Util.isNotEmpty(maxApplyIdCache)) {        date = maxApplyIdCache[0].toString();        oldId = maxApplyIdCache[1].toString();                Integer in = null;        if (today.equals(date)) {            in = Integer.parseInt(oldId);            in ++;        } else {            in = 1;            maxApplyIdCache[0] = today;        }           maxApplyIdCache[1] = in;                maxApplyId = in;    } else {        date = today;                String sql = "select apply_id from (select apply_id from vd_veh_use_apply_info where apply_id like ? order by create_time desc) where rownum = 1";        SQLQuery query = this.getSession().createSQLQuery(sql);        query.setParameter(0, likeValue(newId.toString()));        oldId = (String) query.addScalar("apply_id", StandardBasicTypes.STRING).uniqueResult();                 Integer in = 1;        if (Util.isNotEmpty(oldId)) {            String sn = oldId.replace(newId, "");            try{                in = Integer.parseInt(sn);                in ++;            }catch(NumberFormatException e){            }        }                 maxApplyIdCache = new Object[]{ date, in };        maxApplyId = in;    }        newId.append(maxApplyId);    return newId.toString();}

修改后申请单编号：YCSQD_20170410_1、YCSQD_20170410_2、YCSQD_20170411_3、YCSQD_20170412_4、YCSQD_20180101_1

修改后的代码：

@Override  public synchronized String getNextApplyId() {      String prefix = applyIdPrefix;      String date = null;      String oldId = null;        if (Util.isEmpty(applyIdPrefix)) {          prefix = com.jsecode.platform.util.SysConfig.getString("veh.use.apply.applyid.prefix");          applyIdPrefix = prefix;      }        String today = DateUtil.formatDate(new Date(), "yyyyMMdd");      String todayYear = DateUtil.formatDate(new Date(), "yyyy");      // String today = "20180101";      // String todayYear = "2018";      Integer maxApplyId = null;        StringBuffer newId = new StringBuffer();      newId.append(prefix).append("_").append(today).append("_");      Integer in = null;  //内存中存在的申请单编号[20170412, 25]      if (Util.isNotEmpty(maxApplyIdCache)) {        //20170412        date = maxApplyIdCache[0].toString();        //2017        String dateYear = date.substring(0, 4);        //25         oldId = maxApplyIdCache[1].toString();            in = Integer.parseInt(oldId);          //说明已经跨年          if (!(todayYear.equals(dateYear))) {              in = 0;              maxApplyIdCache[0] = today;          }          //没有跨年，则累加          in++;          maxApplyIdCache[1] = in;            maxApplyId = in;        } else {          date = today;            String sql = "select apply_id from (select apply_id from vd_veh_use_apply_info where apply_id like ? order by create_time desc) where rownum = 1";          SQLQuery query = this.getSession().createSQLQuery(sql);          query.setParameter(0, likeValue(newId.toString()));          oldId = (String) query.addScalar("apply_id", StandardBasicTypes.STRING).uniqueResult();          //oldTd YCSQD_20170410_15          if (Util.isNotEmpty(oldId)) {              String[] o = oldId.split("_");              //年月日              String oYearMday = o[1];              //年              String oYear = oYearMday.substring(0, 4);              if (!(todayYear.equals(oYear))) {                  in = 0;              } else {                  String sn = oldId.replace(newId, "");                  try {                      in = Integer.parseInt(sn);                  } catch (NumberFormatException e) {                  }              }              in++;          } else {              //1.如果oldId没有值，就去数据库查出最新的一条申请单编号YCSQD_20170410_17              String a = queryApplyId();              String[] a1 = a.split("_");              String inYearMday = a1[1];//数据库中取出年月日20170410              //取出年2017              String year = inYearMday.substring(0, 4);              //2.如果系统的年份和数据库查出来的数据年份不一样，说明已经跨年了              if (!(todayYear.equals(year))) {                  in = 0;              } else {                  in = Integer.parseInt(a1[2]);              }              in++;            }            maxApplyIdCache = new Object[] { date, in };          maxApplyId = in;      }        newId.append(maxApplyId);      return newId.toString();  }    public String queryApplyId() {      HibernateParams params = new HibernateParams();      StringBuilder sb = new StringBuilder();      sb.append("select apply_id from(select t.apply_id,t.create_time from vd_veh_use_apply_info t order by create_time desc) where rownum = 1");      List list = findBySql(sb.toString());      if(Util.isEmpty(list)){          return null;      }else{          return (String) list.get(0);      }  }

原派车单编号：申请单编号_CCD1、申请单编号_CCD2

原代码

@Overridepublic synchronized String getNextAssignId(String applyId){String prefix = assignIdPrefix;if (Util.isEmpty(assignIdPrefix)) {prefix = com.jsecode.platform.util.SysConfig.getString("veh.use.apply.assignid.prefix");assignIdPrefix = prefix;}Integer maxAssignId = maxAssignIdCache.get(applyId);StringBuffer newid = new StringBuffer();newid.append(applyId).append("_").append(prefix);if (Util.isNotEmpty(maxAssignId)) {maxAssignId ++;} else {String sql = "select veh_assign_id from (select veh_assign_id from vd_veh_assign_list where apply_id = ? order by create_time desc) where rownum = 1";SQLQuery query = this.getSession().createSQLQuery(sql);query.setParameter(0, applyId);String oldId = (String) query.addScalar("veh_assign_id", StandardBasicTypes.STRING).uniqueResult(); Integer in = 1;if (Util.isNotEmpty(oldId)) {String sn = oldId.replace(newid, "");try{in = Integer.parseInt(sn);in ++;}catch(NumberFormatException e){}} maxAssignId = in;}maxAssignIdCache.put(applyId, maxAssignId);newid.append(maxAssignId);return newid.toString();}

修改后派车单编号：申请单编号_CCD

修改后的代码：

@Overridepublic synchronized String getNextAssignId(String applyId){String prefix = assignIdPrefix;if (Util.isEmpty(assignIdPrefix)) {prefix = com.jsecode.platform.util.SysConfig.getString("veh.use.apply.assignid.prefix");assignIdPrefix = prefix;}/*Integer maxAssignId = maxAssignIdCache.get(applyId);*/StringBuffer newid = new StringBuffer();newid.append(applyId).append("_").append(prefix);/*if (Util.isNotEmpty(maxAssignId)) {maxAssignId ++;} else {String sql = "select veh_assign_id from (select veh_assign_id from vd_veh_assign_list where apply_id = ? order by create_time desc) where rownum = 1";SQLQuery query = this.getSession().createSQLQuery(sql);query.setParameter(0, applyId);String oldId = (String) query.addScalar("veh_assign_id", StandardBasicTypes.STRING).uniqueResult(); Integer in = 1;if (Util.isNotEmpty(oldId)) {String sn = oldId.replace(newid, "");try{in = Integer.parseInt(sn);in ++;}catch(NumberFormatException e){}} maxAssignId = in;}maxAssignIdCache.put(applyId, maxAssignId);*//*newid.append(maxAssignId);*/return newid.toString();}

测试OK：