From 4c33acfe648e9b008f91c5e2cf446550e6b0174d Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期二, 22 七月 2025 17:35:57 +0800
Subject: [PATCH] 1.正式库导出优化 2.销售导出 3.设备使用状态优化 4.定时任务优化
---
main-business/src/main/java/com/ruoyi/business/service/impl/EquipmentUsageRecordServiceImpl.java | 102 +++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 98 insertions(+), 4 deletions(-)
diff --git a/main-business/src/main/java/com/ruoyi/business/service/impl/EquipmentUsageRecordServiceImpl.java b/main-business/src/main/java/com/ruoyi/business/service/impl/EquipmentUsageRecordServiceImpl.java
index a1d8661..fde6bd6 100644
--- a/main-business/src/main/java/com/ruoyi/business/service/impl/EquipmentUsageRecordServiceImpl.java
+++ b/main-business/src/main/java/com/ruoyi/business/service/impl/EquipmentUsageRecordServiceImpl.java
@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.basic.entity.Supply;
+import com.ruoyi.basic.mapper.CoalInfoMapper;
import com.ruoyi.business.dto.EquipmentManagementDto;
import com.ruoyi.business.dto.EquipmentUsageRecordDto;
import com.ruoyi.business.entity.EquipmentManagement;
@@ -12,10 +13,14 @@
import com.ruoyi.business.mapper.EquipmentUsageRecordMapper;
import com.ruoyi.business.service.EquipmentUsageRecordService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.utils.bean.BeanUtils;
+import com.ruoyi.system.mapper.SysUserMapper;
import org.springframework.stereotype.Service;
import lombok.RequiredArgsConstructor;
+import org.springframework.transaction.annotation.Transactional;
+import java.time.LocalDate;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -37,7 +42,9 @@
private final EquipmentUsageRecordMapper equipmentUsageRecordMapper;
- private final EquipmentManagementMapper equipmentManagementMapper;
+ private final EquipmentManagementMapper equipmentManagementMapper;
+
+ private final SysUserMapper sysUserMapper;
@Override
public IPage<EquipmentUsageRecordDto> selectUsageRecordList(Page<EquipmentUsageRecord> page, EquipmentUsageRecordDto equipmentUsageRecordDto) {
@@ -46,7 +53,8 @@
BeanUtils.copyProperties(entityPage, dtoPage);
List<Long> eqIds = entityPage.getRecords().stream().map(EquipmentUsageRecord::getEquipmentId).toList();
- //鎵归噺鏌ヨ
+ List<Long> userIds = entityPage.getRecords().stream().map(EquipmentUsageRecord::getUserId).toList();
+ //鎵归噺鏌ヨ璁惧
Map<Long, EquipmentManagement> equipmentManagementMap;
if (!eqIds.isEmpty()) {
List<EquipmentManagement> infos = equipmentManagementMapper.selectList(new LambdaQueryWrapper<EquipmentManagement>().in(EquipmentManagement::getId, eqIds));
@@ -54,30 +62,116 @@
} else {
equipmentManagementMap = new HashMap<>();
}
+ //浜哄憳鏌ヨ
+ Map<Long, SysUser> userMap;
+ if (!userIds.isEmpty()) {
+ List<SysUser> sysUsers = sysUserMapper.selectList(userIds);
+ userMap = sysUsers.stream().collect(Collectors.toMap(SysUser::getUserId, Function.identity()));
+ } else {
+ userMap = new HashMap<>();
+ }
//鍖归厤鏁版嵁
List<EquipmentUsageRecordDto> dtoRecords = entityPage.getRecords().stream().map(entity -> {
EquipmentUsageRecordDto dto = new EquipmentUsageRecordDto();
BeanUtils.copyProperties(entity, dto);
-
EquipmentManagement equipment = equipmentManagementMap.get(entity.getEquipmentId());
if (equipment != null) {
dto.setEquipmentNo(equipment.getEquipmentNo());
dto.setEquipmentName(equipment.getEquipmentName());
}
+ SysUser sysUser = userMap.get(entity.getUserId());
+ if (sysUser != null) {
+ dto.setUserName(sysUser.getNickName());
+ }
return dto;
}).toList();
-
dtoPage.setRecords(dtoRecords);
return dtoPage;
}
@Override
+ @Transactional(rollbackFor = Exception.class)
public int addOrEditUsageRecord(EquipmentUsageRecordDto equipmentUsageRecordDto) {
+ // 鍙傛暟鏍￠獙
+ if (equipmentUsageRecordDto == null) {
+ throw new IllegalArgumentException("璁惧浣跨敤璁板綍鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ // 澶嶅埗灞炴�у埌瀹炰綋瀵硅薄
EquipmentUsageRecord equipmentUsageRecord = new EquipmentUsageRecord();
BeanUtils.copyProperties(equipmentUsageRecordDto, equipmentUsageRecord);
+
+ // 鑾峰彇璁惧ID鍜岄鐢ㄦ暟閲�
+ Long equipmentId = equipmentUsageRecordDto.getEquipmentId();
+ Integer newUsageQuantity = equipmentUsageRecordDto.getUsageQuantity();
+
+ // 鏌ヨ璁惧淇℃伅
+ EquipmentManagement equipment = equipmentManagementMapper.selectById(equipmentId);
+ if (equipment == null) {
+ throw new RuntimeException("璁惧涓嶅瓨鍦�");
+ }
+
+ // 鏂板璁板綍閫昏緫
if (Objects.isNull(equipmentUsageRecordDto.getId())) {
+ // 妫�鏌ュ簱瀛樻槸鍚﹀厖瓒�
+ if (equipment.getQuantity() < newUsageQuantity) {
+ throw new RuntimeException("搴撳瓨涓嶈冻锛屽綋鍓嶅簱瀛橈細" + equipment.getQuantity());
+ }
+
+ // 鎵ｅ噺搴撳瓨
+ equipment.setQuantity(equipment.getQuantity() - newUsageQuantity);
+ equipmentManagementMapper.updateById(equipment);
+
+ // 璁剧疆浣跨敤寮�濮嬫椂闂翠负褰撳墠鏃堕棿
+ equipmentUsageRecord.setUsageStartTime(LocalDate.now());
return equipmentUsageRecordMapper.insert(equipmentUsageRecord);
} else {
+ // 缂栬緫璁板綍閫昏緫
+ EquipmentUsageRecord originalRecord = equipmentUsageRecordMapper.selectById(equipmentUsageRecordDto.getId());
+ if (originalRecord == null) {
+ throw new RuntimeException("棰嗙敤璁板綍涓嶅瓨鍦�");
+ }
+
+ // 澶勭悊褰掕繕閫昏緫
+ if (equipmentUsageRecordDto.getEquipmentStatus() == 2) {
+ // 妫�鏌ュ綊杩樻暟閲忔槸鍚﹀悎娉�
+ if (newUsageQuantity > originalRecord.getUsageQuantity()) {
+ throw new RuntimeException("褰掕繕鏁伴噺涓嶈兘瓒呰繃鍘熼鐢ㄦ暟閲�");
+ }
+
+ // 璁＄畻瀹為檯褰掕繕鏁伴噺锛堝師棰嗙敤鏁伴噺 - 鏂伴鐢ㄦ暟閲忥級
+ int returnedQuantity = originalRecord.getUsageQuantity() - newUsageQuantity;
+
+ // 鎭㈠閮ㄥ垎搴撳瓨
+ equipment.setQuantity(equipment.getQuantity() + returnedQuantity);
+ equipmentManagementMapper.updateById(equipment);
+
+ // 濡傛灉鍏ㄩ儴褰掕繕锛岃缃綊杩樻椂闂�
+ if (newUsageQuantity == 0) {
+ equipmentUsageRecord.setUsageEndTime(LocalDate.now());
+ }
+ return equipmentUsageRecordMapper.updateById(equipmentUsageRecord);
+ }
+
+ // 澶勭悊鏅�氱紪杈戦�昏緫锛堥潪褰掕繕鐘舵�侊級
+ if (!newUsageQuantity.equals(originalRecord.getUsageQuantity())) {
+ // 璁＄畻搴撳瓨鍙樺寲閲忥紙鏃ф暟閲� - 鏂版暟閲忥級
+ int quantityDelta = originalRecord.getUsageQuantity() - newUsageQuantity;
+
+ // 妫�鏌ヨ皟鏁村悗搴撳瓨鏄惁鍏呰冻
+ int newInventory = equipment.getQuantity() + quantityDelta;
+ if (newInventory < 0) {
+ throw new RuntimeException("搴撳瓨涓嶈冻锛岃皟鏁村悗搴撳瓨灏嗕负锛�" + newInventory);
+ }
+
+ // 璋冩暣搴撳瓨
+ equipment.setQuantity(newInventory);
+ if (equipmentManagementMapper.updateById(equipment) == 0) {
+ throw new RuntimeException("搴撳瓨鏇存柊澶辫触锛屽彲鑳藉凡琚叾浠栨搷浣滀慨鏀�");
+ }
+ }
+
+ // 鏇存柊棰嗙敤璁板綍
return equipmentUsageRecordMapper.updateById(equipmentUsageRecord);
}
}
--
Gitblit v1.9.3