根据入库单号生成容器码 su单号 + 0000 4位流水号
private String generatorBinCode(String suCode) {
if (StringUtils.isEmpty(suCode)) {
return null;
}
synchronized (suCode.intern()) {
long value = ksBinMapper.binCodeSuffixMax(suCode) + 1;
return suCode + String.format("%04d", value);
}
}
<select id="binCodeSuffixMax" resultType="long">
select ifnull((select substr(ks_bin_code, -4) from ks_bin where left (ks_bin_code, length (ks_bin_code) - 4) = #{suCode} order by ks_bin_code desc limit 1), 0);
</select>