package com.ruoyi.device.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.exception.ServiceException;
|
import com.ruoyi.common.utils.DateUtils;
|
import com.ruoyi.common.utils.SecurityUtils;
|
import com.ruoyi.common.utils.bean.BeanUtils;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.device.dto.DeviceLedgerDto;
|
import com.ruoyi.device.execl.DeviceLedgerExeclDto;
|
import com.ruoyi.device.mapper.DeviceLedgerMapper;
|
import com.ruoyi.device.pojo.DeviceLedger;
|
import com.ruoyi.basic.dto.StorageAttachmentDTO;
|
import com.ruoyi.basic.enums.RecordTypeEnum;
|
import com.ruoyi.basic.service.StorageAttachmentService;
|
import com.ruoyi.device.service.IDeviceLedgerService;
|
import com.ruoyi.framework.web.domain.AjaxResult;
|
import com.ruoyi.project.system.domain.SysUser;
|
import com.ruoyi.project.system.mapper.SysUserMapper;
|
import jakarta.servlet.http.HttpServletResponse;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.List;
|
|
@Service
|
@RequiredArgsConstructor
|
@Slf4j
|
public class DeviceLedgerServiceImpl extends ServiceImpl<DeviceLedgerMapper, DeviceLedger> implements IDeviceLedgerService {
|
|
private final DeviceLedgerMapper deviceLedgerMapper;
|
private final SysUserMapper sysUserMapper;
|
private final StorageAttachmentService storageAttachmentService;
|
|
@Override
|
public IPage<DeviceLedgerDto> queryPage(Page page, DeviceLedgerDto deviceLedger) {
|
|
return deviceLedgerMapper.queryPage(page, deviceLedger);
|
}
|
|
@Override
|
public List<DeviceLedgerDto> selectDeviceOptions(Long areaId) {
|
return deviceLedgerMapper.selectDeviceOptions(areaId);
|
}
|
|
@Override
|
public AjaxResult saveDeviceLedger(DeviceLedgerDto deviceLedgerDto) {
|
LambdaQueryWrapper<DeviceLedger> deviceLedgerLambdaQueryWrapper = new LambdaQueryWrapper<>();
|
deviceLedgerLambdaQueryWrapper.eq(DeviceLedger::getDeviceName,deviceLedgerDto.getDeviceName());
|
if (this.count(deviceLedgerLambdaQueryWrapper) > 0) {
|
return AjaxResult.error("设备名称已存在");
|
}
|
DeviceLedger deviceLedger = new DeviceLedger();
|
BeanUtils.copyProperties(deviceLedgerDto, deviceLedger);
|
boolean save = this.save(deviceLedger);
|
if (save){
|
if (deviceLedgerDto.getStorageBlobDTOs() != null) {
|
StorageAttachmentDTO attachmentDTO = new StorageAttachmentDTO();
|
attachmentDTO.setApplication("image");
|
attachmentDTO.setRecordType(RecordTypeEnum.DEVICE_LEDGER.getType());
|
attachmentDTO.setRecordId(deviceLedger.getId());
|
attachmentDTO.setStorageBlobDTOs(deviceLedgerDto.getStorageBlobDTOs());
|
storageAttachmentService.saveStorageAttachment(attachmentDTO);
|
}
|
return AjaxResult.success();
|
}
|
return AjaxResult.error();
|
}
|
|
@Override
|
public AjaxResult updateDeviceLedger(DeviceLedgerDto deviceLedgerDto) {
|
DeviceLedger deviceLedger = new DeviceLedger();
|
BeanUtils.copyProperties(deviceLedgerDto, deviceLedger);
|
if (this.updateById(deviceLedger)) {
|
if (deviceLedgerDto.getStorageBlobDTOs() != null) {
|
StorageAttachmentDTO attachmentDTO = new StorageAttachmentDTO();
|
attachmentDTO.setApplication("image");
|
attachmentDTO.setRecordType(RecordTypeEnum.DEVICE_LEDGER.getType());
|
attachmentDTO.setRecordId(deviceLedger.getId());
|
attachmentDTO.setStorageBlobDTOs(deviceLedgerDto.getStorageBlobDTOs());
|
storageAttachmentService.saveStorageAttachment(attachmentDTO);
|
}
|
return AjaxResult.success();
|
}
|
return AjaxResult.error();
|
}
|
|
@Override
|
public DeviceLedgerDto getDeviceLedgerDetail(Long id) {
|
DeviceLedger deviceLedger = this.getById(id);
|
if (deviceLedger != null) {
|
DeviceLedgerDto deviceLedgerDto = new DeviceLedgerDto();
|
BeanUtils.copyProperties(deviceLedger, deviceLedgerDto);
|
StorageAttachmentDTO dto = new StorageAttachmentDTO();
|
dto.setRecordType(RecordTypeEnum.DEVICE_LEDGER.getType());
|
dto.setRecordId(id);
|
dto.setApplication("image");
|
deviceLedgerDto.setStorageBlobVOs(storageAttachmentService.list(dto));
|
return deviceLedgerDto;
|
}
|
return null;
|
}
|
|
@Override
|
public void export(HttpServletResponse response, Long[] ids) {
|
|
if (ids == null || ids.length == 0) {
|
List<DeviceLedger> supplierManageList = this.list();
|
|
ArrayList<DeviceLedgerExeclDto> deviceLedgerExeclDtos = new ArrayList<>();
|
supplierManageList.stream().forEach(deviceLedger -> {
|
DeviceLedgerExeclDto deviceLedgerExeclDto = new DeviceLedgerExeclDto();
|
BeanUtils.copyProperties(deviceLedger,deviceLedgerExeclDto);
|
deviceLedgerExeclDto.setCreateUser(sysUserMapper.selectUserById(Long.valueOf(deviceLedger.getCreateUser().toString())).getUserName());
|
deviceLedgerExeclDtos.add(deviceLedgerExeclDto);
|
});
|
ExcelUtil<DeviceLedgerExeclDto> util = new ExcelUtil<DeviceLedgerExeclDto>(DeviceLedgerExeclDto.class);
|
util.exportExcel(response, deviceLedgerExeclDtos, "设备台账导出");
|
}else {
|
ArrayList<Long> arrayList = new ArrayList<>();
|
Arrays.stream(ids).map(arrayList::add);
|
List<DeviceLedger> supplierManageList = deviceLedgerMapper.selectBatchIds(arrayList);
|
ArrayList<DeviceLedgerExeclDto> deviceLedgerExeclDtos = new ArrayList<>();
|
supplierManageList.stream().forEach(deviceLedger -> {
|
DeviceLedgerExeclDto deviceLedgerExeclDto = new DeviceLedgerExeclDto();
|
BeanUtils.copyProperties(deviceLedger,deviceLedgerExeclDto);
|
deviceLedgerExeclDto.setCreateUser(sysUserMapper.selectUserById(Long.valueOf(deviceLedger.getCreateUser().toString())).getUserName());
|
deviceLedgerExeclDtos.add(deviceLedgerExeclDto);
|
});
|
ExcelUtil<DeviceLedgerExeclDto> util = new ExcelUtil<DeviceLedgerExeclDto>(DeviceLedgerExeclDto.class);
|
util.exportExcel(response, deviceLedgerExeclDtos, "设备台账导出");
|
}
|
|
}
|
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public Boolean importData(MultipartFile file) throws IOException {
|
ExcelUtil<DeviceLedgerExeclDto> util = new ExcelUtil<DeviceLedgerExeclDto>(DeviceLedgerExeclDto.class);
|
List<DeviceLedgerExeclDto> userList = util.importExcel(file.getInputStream());
|
if (userList == null || userList.isEmpty()) {
|
// 表头与模板不一致时解析不到任何数据，明确提示，避免前端只看到“导入成功”却没有任何数据
|
throw new ServiceException("未读取到可导入的数据，请确认文件表头与导入模板一致后重试");
|
}
|
int importCount = 0;
|
for (int i = 0; i < userList.size(); i++) {
|
DeviceLedgerExeclDto c = userList.get(i);
|
if (c == null) {
|
continue;
|
}
|
DeviceLedger deviceLedger;
|
try {
|
deviceLedger = buildDeviceLedger(c);
|
} catch (Exception e) {
|
throw new ServiceException("第" + (i + 2) + "行数据有误：" + e.getMessage());
|
}
|
try {
|
deviceLedgerMapper.insert(deviceLedger);
|
} catch (Exception e) {
|
throw new ServiceException("第" + (i + 2) + "行保存失败：" + e.getMessage());
|
}
|
importCount++;
|
}
|
if (importCount == 0) {
|
throw new ServiceException("未读取到可导入的数据，请确认文件表头与导入模板一致后重试");
|
}
|
return true;
|
}
|
|
/**
|
* 将导入行转换为设备台账实体
|
*/
|
private DeviceLedger buildDeviceLedger(DeviceLedgerExeclDto c) {
|
DeviceLedger deviceLedger = new DeviceLedger();
|
SysUser sysUser = sysUserMapper.selectUserByUserName(c.getCreateUser());
|
if (sysUser != null) {
|
deviceLedger.setCreateUser(sysUser.getUserId().intValue());
|
} else {
|
deviceLedger.setCreateUser(SecurityUtils.getUserId().intValue());
|
}
|
BeanUtils.copyProperties(c, deviceLedger);
|
// 数量：Excel 未填时按 1 台处理
|
if (deviceLedger.getNumber() == null) {
|
deviceLedger.setNumber(BigDecimal.ONE);
|
}
|
// 含税总价：Excel 未填时按 含税单价 × 数量 计算
|
if (deviceLedger.getTaxIncludingPriceTotal() == null && deviceLedger.getTaxIncludingPriceUnit() != null) {
|
deviceLedger.setTaxIncludingPriceTotal(deviceLedger.getTaxIncludingPriceUnit().multiply(deviceLedger.getNumber()));
|
}
|
deviceLedger.setPlanRuntimeTime(DateUtils.toLocalDate(c.getPlanRuntimeTime()));
|
// 不含税总价：含税总价与税率都有值时按税率折算，税率按百分数存储（13 表示 13%），与台账现有数据口径一致
|
if (deviceLedger.getTaxIncludingPriceTotal() != null && deviceLedger.getTaxRate() != null) {
|
BigDecimal rate = deviceLedger.getTaxRate().divide(new BigDecimal(100), 4, RoundingMode.HALF_UP);
|
deviceLedger.setUnTaxIncludingPriceTotal(deviceLedger.getTaxIncludingPriceTotal()
|
.divide(BigDecimal.ONE.add(rate), 2, RoundingMode.HALF_UP));
|
}
|
return deviceLedger;
|
}
|
}
|
