src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java
@@ -99,7 +99,7 @@ // String approveID = today + formattedCount; SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); ApproveProcess approveProcess = new ApproveProcess(); String no = OrderUtils.countTodayByCreateTime(approveProcessMapper, "SP"); String no = OrderUtils.countTodayByCreateTime(approveProcessMapper, "","approve_id"); approveProcess.setApproveId(no); approveProcess.setApproveUser(approveProcessVO.getApproveUser()); approveProcess.setApproveUserName(sysUser.getNickName()); src/main/java/com/ruoyi/common/utils/OrderUtils.java
@@ -2,9 +2,6 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.common.utils.uuid.UUID; import org.apache.poi.ss.formula.functions.T; import org.springframework.stereotype.Component; import java.time.LocalDate; import java.time.LocalDateTime; @@ -12,7 +9,6 @@ import java.time.ZoneId; import java.time.format.DateTimeFormatter; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -24,82 +20,88 @@ /** * List<Integer> 转换为 Long[] 数组 * @param ids * @return * @param ids ids * @return Long[] */ public static Long[] listIntegerToLongArray(List<Integer> ids) { return ids.stream() // 处理null值:如果元素为null,转换为0L(可根据业务调整,比如抛异常) .map(id -> id != null ? id.longValue() : -1L) // 将Stream<Long>转换为Long[]数组 .toArray(Long[]::new); } /** * 判断目标id是否在逗号分隔的字符串中 * @param targetId * @param str * @return * @param targetId targetId * @param str source * @return boolean */ public boolean isStaffIdExist(Object targetId,String str) { // 空值校验,避免空指针 if (str == null || str.trim().isEmpty() || targetId == null) { return false; } // 按逗号分割成数组 String[] idArray = str.split(","); // 遍历数组判断是否包含目标id for (String id : idArray) { // 去除空格(防止字符串中有多余空格,如"1, 121") String cleanId = id.trim(); // 转换为数字并比较 try { if (cleanId.equals(String.valueOf(targetId))) { return true; } } catch (NumberFormatException e) { // 若存在非数字ID,直接返回false return false; } } return false; } /** * 查询当天(基于createTime字段)的记录数量 * @param mapper 实体类对应的BaseMapper * @param <T> 实体类泛型 * @return 当天记录数量 * 查询当天基于 create_time 的最新编号,并生成下一个编号 * @param mapper mapper * @param preFix 编号前缀 * @param code 编号字段 * @param <T> 实体类型 * @return 订单编号 */ public static <T> String countTodayByCreateTime(BaseMapper<T> mapper,String preFix) { // 获取当天开始时间(00:00:00) LocalDateTime todayStart = LocalDateTime.of( LocalDateTime.now().toLocalDate(), LocalTime.MIN ); // 获取当天结束时间(23:59:59.999) LocalDateTime todayEnd = LocalDateTime.of( LocalDateTime.now().toLocalDate(), LocalTime.MAX ); public static <T> String countTodayByCreateTime(BaseMapper<T> mapper,String preFix,String code) { LocalDate today = LocalDate.now(); LocalDateTime todayStart = today.atStartOfDay(); LocalDateTime tomorrowStart = today.plusDays(1).atStartOfDay(); String dateStr = today.format(DateTimeFormatter.BASIC_ISO_DATE); String codePrefix = preFix + dateStr; // 转换为Date类型(如果实体类中createTime是LocalDateTime可直接使用) Date startDate = Date.from(todayStart.atZone(ZoneId.systemDefault()).toInstant()); Date endDate = Date.from(todayEnd.atZone(ZoneId.systemDefault()).toInstant()); QueryWrapper<T> wrapper = new QueryWrapper<>(); wrapper.select(code) .ge("create_time", todayStart) .lt("create_time", tomorrowStart) .likeRight(code, codePrefix) .orderByDesc(code) .last("LIMIT 1"); // 构建查询条件 QueryWrapper<T> queryWrapper = new QueryWrapper<>(); queryWrapper.ge("create_time", startDate) // 大于等于当天开始 .lt("create_time", endDate); // 小于当天结束(避免毫秒精度问题) long nextSeq = 1; List<Map<String, Object>> records = mapper.selectMaps(wrapper); if (!records.isEmpty()) { Object lastCode = records.get(0).get(code); if (lastCode != null) { nextSeq = extractSequence(lastCode.toString(), codePrefix) + 1; } } // 执行查询 Long aLong = mapper.selectCount(queryWrapper); // 拼接订单编号 preFix + 时间(yyyyMMdd) + 订单数量(001) return preFix + LocalDate.now().format(DateTimeFormatter.ISO_LOCAL_DATE).replaceAll("-", "") + String.format("%03d", (aLong + 1)) + "-" + new Date().getTime(); return preFix + dateStr + String.format("%03d", nextSeq); } private static long extractSequence(String fullCode, String codePrefix) { if (!fullCode.startsWith(codePrefix)) { return 0; } String seqStr = fullCode.substring(codePrefix.length()).trim(); if (seqStr.isEmpty()) { return 0; } try { return Long.parseLong(seqStr); } catch (NumberFormatException e) { return 0; } } /** * 查询当天(基于createTime字段)的记录数量 @@ -108,29 +110,23 @@ * @return 当天记录数量 */ public static <T> String countAfterServiceTodayByCreateTime(BaseMapper<T> mapper,String preFix) { // 获取当天开始时间(00:00:00) LocalDateTime todayStart = LocalDateTime.of( LocalDateTime.now().toLocalDate(), LocalTime.MIN ); // 获取当天结束时间(23:59:59.999) LocalDateTime todayEnd = LocalDateTime.of( LocalDateTime.now().toLocalDate(), LocalTime.MAX ); // 转换为Date类型(如果实体类中createTime是LocalDateTime可直接使用) Date startDate = Date.from(todayStart.atZone(ZoneId.systemDefault()).toInstant()); Date endDate = Date.from(todayEnd.atZone(ZoneId.systemDefault()).toInstant()); // 构建查询条件 QueryWrapper<T> queryWrapper = new QueryWrapper<>(); queryWrapper.ge("create_time", startDate) // 大于等于当天开始 .lt("create_time", endDate); // 小于当天结束(避免毫秒精度问题) queryWrapper.ge("create_time", startDate) .lt("create_time", endDate); // 执行查询 Long aLong = mapper.selectCount(queryWrapper); // 拼接订单编号 preFix + 时间(yyyyMMdd) + 订单数量(001) return preFix + LocalDate.now().format(DateTimeFormatter.ISO_LOCAL_DATE).replaceAll("-", "") + String.format("%03d", (aLong + 1)); } } src/main/java/com/ruoyi/procurementrecord/service/impl/ProcurementRecordServiceImpl.java
@@ -535,7 +535,7 @@ Long aLong = customStorageMapper.selectCount(null); item.setInboundBatches(aLong.equals(0L) ? "第1批次(自定义入库)" : "第"+ (aLong + 1) + "批次(自定义入库)" ); item.setCreateBy(loginUser.getNickName()); item.setCode(OrderUtils.countTodayByCreateTime(customStorageMapper, "")); item.setCode(OrderUtils.countTodayByCreateTime(customStorageMapper, "", "code")); customStorageMapper.insert(item); }); return AjaxResult.success("自定义入库成功"); src/main/java/com/ruoyi/procurementrecord/service/impl/ReturnManagementServiceImpl.java
@@ -72,7 +72,7 @@ @Override public boolean addReturnManagementDto(ReturnManagementDto returnManagementDto) { String rt = OrderUtils.countTodayByCreateTime(returnManagementMapper, "RT"); String rt = OrderUtils.countTodayByCreateTime(returnManagementMapper, "RT","return_no"); returnManagementDto.setReturnNo(rt); save(returnManagementDto); for (ReturnSaleProduct returnSaleProduct : returnManagementDto.getReturnSaleProducts()) { src/main/java/com/ruoyi/projectManagement/controller/RolesController.java
@@ -35,7 +35,7 @@ @ApiOperation("新增") public AjaxResult add(@RequestBody RoleDto roleDto) { if (roleDto.getIsDefaultNo()) { roleDto.setNo(OrderUtils.countTodayByCreateTime(rolesMapper, "XMJS")); roleDto.setNo(OrderUtils.countTodayByCreateTime(rolesMapper, "XMJS","no")); } return AjaxResult.success(rolesservice.save(roleDto)); } src/main/java/com/ruoyi/purchase/controller/PurchaseReturnOrdersController.java
@@ -42,7 +42,7 @@ @PostMapping("/add") public AjaxResult add(@RequestBody PurchaseReturnOrderDto purchaseReturnOrderDto) throws Exception { if (purchaseReturnOrderDto.getIsDefaultNo()) { purchaseReturnOrderDto.setNo(OrderUtils.countTodayByCreateTime(purchaseReturnOrdersMapper, "CGTL")); purchaseReturnOrderDto.setNo(OrderUtils.countTodayByCreateTime(purchaseReturnOrdersMapper, "CGTL","no")); } return AjaxResult.success(purchaseReturnOrdersService.add(purchaseReturnOrderDto)); } src/main/java/com/ruoyi/purchase/dto/PurchaseReturnOrderDto.java
@@ -14,4 +14,6 @@ private String supplierName; private List<PurchaseReturnOrderProductsDto> purchaseReturnOrderProductsDtos; private Long[] deptIds; } src/main/java/com/ruoyi/purchase/mapper/PurchaseReturnOrdersMapper.java
@@ -2,6 +2,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.purchase.dto.PurchaseReturnOrderDto; import com.ruoyi.purchase.pojo.PurchaseReturnOrders; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.purchase.vo.PurchaseReturnOrderVo; @@ -18,5 +19,5 @@ */ @Mapper public interface PurchaseReturnOrdersMapper extends BaseMapper<PurchaseReturnOrders> { IPage<PurchaseReturnOrderVo> listPage(Page page, @Param("params") PurchaseReturnOrders purchaseReturnOrder); IPage<PurchaseReturnOrderVo> listPage(Page page, @Param("params") PurchaseReturnOrderDto purchaseReturnOrder); } src/main/java/com/ruoyi/sales/controller/PaymentShippingController.java
@@ -43,7 +43,7 @@ @ApiOperation("添加支付与发货信息") @Transactional(rollbackFor = Exception.class) public AjaxResult add(@RequestBody PaymentShipping paymentShipping) { String ord = OrderUtils.countTodayByCreateTime(paymentShippingMapper, "ORD"); String ord = OrderUtils.countTodayByCreateTime(paymentShippingMapper, "ORD","order_no"); paymentShipping.setOrderNo(ord); boolean save = paymentShippingService.save(paymentShipping); return save ? success() : error(); src/main/java/com/ruoyi/sales/controller/ShippingInfoController.java
@@ -74,7 +74,7 @@ @Log(title = "发货信息管理", businessType = BusinessType.INSERT) public AjaxResult add(@RequestBody ShippingInfoDto req) throws Exception { LoginUser loginUser = SecurityUtils.getLoginUser(); String sh = OrderUtils.countTodayByCreateTime(shippingInfoMapper, "SH"); String sh = OrderUtils.countTodayByCreateTime(shippingInfoMapper, "SH","shipping_no"); // 发货审批 ApproveProcessVO approveProcessVO = new ApproveProcessVO(); approveProcessVO.setApproveType(7); src/main/java/com/ruoyi/sales/service/impl/SalesQuotationServiceImpl.java
@@ -63,7 +63,7 @@ LoginUser loginUser = SecurityUtils.getLoginUser(); SalesQuotation salesQuotation = new SalesQuotation(); BeanUtils.copyProperties(salesQuotationDto, salesQuotation); String quotationNo = OrderUtils.countTodayByCreateTime(salesQuotationMapper, "QT"); String quotationNo = OrderUtils.countTodayByCreateTime(salesQuotationMapper, "QT","quotation_no"); salesQuotation.setQuotationNo(quotationNo); salesQuotation.setStatus("待审批"); salesQuotationMapper.insert(salesQuotation); src/main/java/com/ruoyi/stock/service/impl/StockInRecordServiceImpl.java
@@ -46,7 +46,7 @@ @Override @Transactional(rollbackFor = Exception.class) public int add(StockInRecordDto stockInRecordDto) { String no = OrderUtils.countTodayByCreateTime(stockInRecordMapper, "RK"); String no = OrderUtils.countTodayByCreateTime(stockInRecordMapper, "RK","inbound_batches"); stockInRecordDto.setInboundBatches(no); StockInRecord stockInRecord = new StockInRecord(); BeanUtils.copyProperties(stockInRecordDto, stockInRecord); src/main/java/com/ruoyi/stock/service/impl/StockOutRecordServiceImpl.java
@@ -51,7 +51,7 @@ @Override public int add(StockOutRecordDto stockOutRecordDto) { String no = OrderUtils.countTodayByCreateTime(stockOutRecordMapper, "CK"); String no = OrderUtils.countTodayByCreateTime(stockOutRecordMapper, "CK","outbound_batches"); stockOutRecordDto.setOutboundBatches(no); StockInRecord stockInRecord = new StockInRecord(); BeanUtils.copyProperties(stockOutRecordDto, stockInRecord);