| | |
|---|
| | | 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.utils.SecurityUtils; |
|---|
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
|---|
| | | import com.ruoyi.framework.security.LoginUser; |
|---|
| | | import com.ruoyi.procurementrecord.dto.ProcurementPageDto; |
|---|
| | | import com.ruoyi.procurementrecord.dto.ProcurementRecordOutAdd; |
|---|
| | | import com.ruoyi.procurementrecord.dto.ProcurementRecordOutPageDto; |
|---|
| | | import com.ruoyi.procurementrecord.dto.ProcurementUpdateDto; |
|---|
| | | import com.ruoyi.procurementrecord.mapper.ProcurementRecordOutMapper; |
|---|
| | | import com.ruoyi.procurementrecord.pojo.ProcurementRecord; |
|---|
| | | import com.ruoyi.procurementrecord.pojo.ProcurementRecordOut; |
|---|
| | | import com.ruoyi.procurementrecord.pojo.ProcurementRecordStorage; |
|---|
| | | import com.ruoyi.procurementrecord.service.ProcurementRecordOutService; |
|---|
| | | import com.ruoyi.project.system.domain.SysUser; |
|---|
| | | import com.ruoyi.project.system.mapper.SysUserMapper; |
|---|
| | | import lombok.RequiredArgsConstructor; |
|---|
| | | import lombok.extern.slf4j.Slf4j; |
|---|
| | | import org.apache.commons.lang3.StringUtils; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | import org.springframework.util.CollectionUtils; |
|---|
| | | |
|---|
| | | import javax.servlet.http.HttpServletResponse; |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.text.DateFormat; |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.time.LocalDateTime; |
|---|
| | | import java.time.LocalTime; |
|---|
| | | import java.time.format.DateTimeFormatter; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.stream.Collectors; |
|---|
| | | |
|---|
| | |
|---|
| | | if(sysUser == null){ |
|---|
| | | throw new RuntimeException("出库人不存在"); |
|---|
| | | } |
|---|
| | | // 查询时间范围为当天数量 |
|---|
| | | LocalDate now = LocalDate.now(); |
|---|
| | | DateTimeFormatter dateFormat = DateTimeFormatter.ofPattern("yyyyMMdd"); |
|---|
| | | LambdaQueryWrapper<ProcurementRecordOut> procurementRecordOutLambdaQueryWrapper = new LambdaQueryWrapper<>(); |
|---|
| | | procurementRecordOutLambdaQueryWrapper.ge(ProcurementRecordOut::getCreateTime, now) // 大于等于当天 |
|---|
| | | .lt(ProcurementRecordOut::getCreateTime, now.plusDays(1)); // 小于明天 |
|---|
| | | Long aLong1 = procurementRecordOutMapper.selectCount(procurementRecordOutLambdaQueryWrapper); |
|---|
| | | // 2. 定义日期格式（必须与字符串格式完全匹配） |
|---|
| | | DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
|---|
| | | LocalDateTime localDateTime = null; |
|---|
| | | // 3. 转换：String → LocalDate → LocalDateTime（补充0点时间） |
|---|
| | | if(StringUtils.isNotEmpty(procurementRecordOutAdd.getTime())){ |
|---|
| | | LocalDate localDate = LocalDate.parse(procurementRecordOutAdd.getTime(), formatter); |
|---|
| | | // 获取当前时分秒 |
|---|
| | | LocalTime localTime = LocalTime.now(); |
|---|
| | | localDateTime = localDate.atTime(localTime);} |
|---|
| | | // 查询采购出库数量 |
|---|
| | | LambdaQueryWrapper<ProcurementRecordOut> procurementRecordLambdaQueryWrapper = new LambdaQueryWrapper<>(); |
|---|
| | | procurementRecordLambdaQueryWrapper.eq(ProcurementRecordOut::getProcurementRecordStorageId, procurementRecordOutAdd.getId()); |
|---|
| | | Long aLong = procurementRecordOutMapper.selectCount(procurementRecordLambdaQueryWrapper); |
|---|
| | | ProcurementRecordOut.ProcurementRecordOutBuilder procurementRecordOut = ProcurementRecordOut.builder() |
|---|
| | | .procurementRecordStorageId(procurementRecordOutAdd.getId()) |
|---|
| | | .code("LS" + dateFormat.format(now) + String.format("%03d", aLong1 + 1)) |
|---|
| | | .salesLedgerProductId(procurementRecordOutAdd.getSalesLedgerProductId()) |
|---|
| | | .inboundBatches(aLong.equals(0L) ? "第1批次" : "第"+ (aLong + 1) + "批次") |
|---|
| | | .inboundNum(new BigDecimal(procurementRecordOutAdd.getQuantity())) |
|---|
| | | .createDate(LocalDateTime.now()) |
|---|
| | | .userId(procurementRecordOutAdd.getUserId()) |
|---|
| | | .type(procurementRecordOutAdd.getType()) |
|---|
| | | .createTime(localDateTime == null ? LocalDateTime.now() : localDateTime) |
|---|
| | | .createUser(Long.valueOf(procurementRecordOutAdd.getUserId())) |
|---|
| | | .createBy(sysUser.getNickName()) |
|---|
| | | .tenantId(sysUser.getTenantId()); |
|---|
| | | .updateUser(Long.valueOf(procurementRecordOutAdd.getUserId())) |
|---|
| | | .updateTime(LocalDateTime.now()); |
|---|
| | | this.save(procurementRecordOut.build()); |
|---|
| | | return 0; |
|---|
| | | } |
|---|
| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void export(HttpServletResponse response) { |
|---|
| | | List<ProcurementRecordOutPageDto> list =procurementRecordOutMapper.list(); |
|---|
| | | List<ProcurementRecordOutPageDto> list = procurementRecordOutMapper.list(); |
|---|
| | | ExcelUtil<ProcurementRecordOutPageDto> util = new ExcelUtil<>(ProcurementRecordOutPageDto.class); |
|---|
| | | util.exportExcel(response, list, "出库台账"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public IPage<ProcurementRecordOutPageDto> listPageByProduct(Page page, ProcurementRecordOutPageDto procurementDto) { |
|---|
| | | return procurementRecordOutMapper.listPageByProduct(page, procurementDto); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public IPage<ProcurementRecordOutPageDto> listPageByCustom(Page page, ProcurementRecordOutPageDto procurementDto) { |
|---|
| | | return procurementRecordOutMapper.listPageByCustom(page, procurementDto); |
|---|
| | | } |
|---|
| | | } |
|---|
