New file |
| | |
| | | package com.by4cloud.platformx.device.dto; |
| | | |
| | | import lombok.Data; |
| | | |
| | | @Data |
| | | public class DeviceRepairQueryDTO { |
| | | |
| | | private String deviceName; |
| | | |
| | | private String serialNo; |
| | | |
| | | } |
New file |
| | |
| | | package com.by4cloud.platformx.device.entity.vo; |
| | | |
| | | import com.baomidou.mybatisplus.extension.p6spy.P6SpyLogger; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | public class DeviceRepairPageVo { |
| | | |
| | | private Long id; |
| | | |
| | | private String deviceName; |
| | | |
| | | private String deviceCode; |
| | | |
| | | private String serialNo; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date repairEndDate; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date repairStartDate; |
| | | |
| | | private String status; |
| | | |
| | | } |
New file |
| | |
| | | package com.by4cloud.platformx.device.entity.vo; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | public class DeviceScrapPageVo { |
| | | |
| | | private Long id; |
| | | |
| | | private String deviceName; |
| | | |
| | | private String deviceCode; |
| | | |
| | | private String serialNo; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | private Date scrapDate; |
| | | |
| | | private String status; |
| | | |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.controller; |
| | | |
| | | import cn.hutool.core.util.StrUtil; |
| | | import cn.hutool.core.util.ArrayUtil; |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.common.log.annotation.SysLog; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceInventory; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | import com.by4cloud.platformx.device.service.DeviceRepairService; |
| | |
| | | /** |
| | | * 分页查询 |
| | | * @param page 分页对象 |
| | | * @param deviceRepair 设备维修 |
| | | * @param queryDTO 设备维修 |
| | | * @return |
| | | */ |
| | | @Operation(summary = "分页查询" , description = "分页查询" ) |
| | | @GetMapping("/page" ) |
| | | @PreAuthorize("@pms.hasPermission('device_deviceRepair_view')" ) |
| | | public R getDeviceRepairPage(@ParameterObject Page page, @ParameterObject DeviceRepair deviceRepair) { |
| | | LambdaQueryWrapper<DeviceRepair> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.eq(StrUtil.isNotBlank(deviceRepair.getSerialNo()),DeviceRepair::getSerialNo,deviceRepair.getSerialNo()); |
| | | wrapper.orderByDesc(DeviceRepair::getCreateTime); |
| | | return R.ok(deviceRepairService.page(page, wrapper)); |
| | | public R getDeviceRepairPage(@ParameterObject Page page, DeviceRepairQueryDTO queryDTO) { |
| | | return R.ok(deviceRepairService.pageNew(page, queryDTO)); |
| | | } |
| | | |
| | | |
| | |
| | | |
| | | import cn.hutool.core.util.ArrayUtil; |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.common.log.annotation.SysLog; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceScrap; |
| | | import com.by4cloud.platformx.device.service.DeviceScrapService; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | | /** |
| | | * 设备报废 |
| | |
| | | /** |
| | | * 分页查询 |
| | | * @param page 分页对象 |
| | | * @param deviceScrap 设备报废 |
| | | * @param queryDTO 设备报废 |
| | | * @return |
| | | */ |
| | | @Operation(summary = "分页查询" , description = "分页查询" ) |
| | | @GetMapping("/page" ) |
| | | @PreAuthorize("@pms.hasPermission('device_deviceScrap_view')" ) |
| | | public R getDeviceScrapPage(@ParameterObject Page page, @ParameterObject DeviceScrap deviceScrap) { |
| | | LambdaQueryWrapper<DeviceScrap> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.orderByDesc(DeviceScrap::getCreateTime); |
| | | return R.ok(deviceScrapService.page(page, wrapper)); |
| | | public R getDeviceScrapPage(@ParameterObject Page page, @ParameterObject DeviceRepairQueryDTO queryDTO) { |
| | | return R.ok(deviceScrapService.pageNew(page, queryDTO)); |
| | | } |
| | | |
| | | |
| | |
| | | @PreAuthorize("@pms.hasPermission('device_purchaseWinningLetter_add')" ) |
| | | public R save(@RequestBody PurchaseWinningLetterEntity purchaseWinningLetter) { |
| | | purchaseWinningLetter.setWinningCode(maxSizeService.nextNo(MaxSizeContant.WINNING_CODE)); |
| | | return R.ok(purchaseWinningLetterService.save(purchaseWinningLetter)); |
| | | return purchaseWinningLetterService.saveNew(purchaseWinningLetter); |
| | | } |
| | | |
| | | /** |
| | |
| | | package com.by4cloud.platformx.device.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.common.data.datascope.PlatformxBaseMapper; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | import com.by4cloud.platformx.device.entity.vo.DeviceRepairPageVo; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | @Mapper |
| | | public interface DeviceRepairMapper extends PlatformxBaseMapper<DeviceRepair> { |
| | | |
| | | |
| | | IPage<DeviceRepairPageVo> pageNew(Page page,@Param("queryDTO") DeviceRepairQueryDTO queryDTO); |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.common.data.datascope.PlatformxBaseMapper; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceScrap; |
| | | import com.by4cloud.platformx.device.entity.vo.DeviceScrapPageVo; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | @Mapper |
| | | public interface DeviceScrapMapper extends PlatformxBaseMapper<DeviceScrap> { |
| | | |
| | | |
| | | IPage<DeviceScrapPageVo> pageNew(Page page, @Param("queryDTO") DeviceRepairQueryDTO queryDTO); |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | |
| | | public interface DeviceRepairService extends IService<DeviceRepair> { |
| | |
| | | R approved(Long id); |
| | | |
| | | R complete(Long id); |
| | | |
| | | IPage pageNew(Page page, DeviceRepairQueryDTO queryDTO); |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceScrap; |
| | | |
| | | public interface DeviceScrapService extends IService<DeviceScrap> { |
| | | |
| | | R approved(Long id); |
| | | |
| | | IPage pageNew(Page page, DeviceRepairQueryDTO queryDTO); |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.entity.PurchaseWinningLetterEntity; |
| | | |
| | | public interface PurchaseWinningLetterService extends IService<PurchaseWinningLetterEntity> { |
| | | |
| | | R saveNew(PurchaseWinningLetterEntity purchaseWinningLetter); |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service.impl; |
| | | |
| | | 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.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceInventory; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | import com.by4cloud.platformx.device.mapper.DeviceInventoryMapper; |
| | |
| | | inventoryMapper.updateById(inventory); |
| | | return R.ok(); |
| | | } |
| | | |
| | | @Override |
| | | public IPage pageNew(Page page, DeviceRepairQueryDTO queryDTO) { |
| | | return baseMapper.pageNew(page,queryDTO); |
| | | } |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service.impl; |
| | | |
| | | 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.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.dto.DeviceRepairQueryDTO; |
| | | import com.by4cloud.platformx.device.entity.DeviceInventory; |
| | | import com.by4cloud.platformx.device.entity.DeviceRepair; |
| | | import com.by4cloud.platformx.device.entity.DeviceScrap; |
| | |
| | | return R.ok(); |
| | | } |
| | | |
| | | @Override |
| | | public IPage pageNew(Page page, DeviceRepairQueryDTO queryDTO) { |
| | | return baseMapper.pageNew(page,queryDTO); |
| | | } |
| | | |
| | | } |
| | |
| | | package com.by4cloud.platformx.device.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | | import com.by4cloud.platformx.device.entity.PurchaseTendrOrderEntity; |
| | | import com.by4cloud.platformx.device.entity.PurchaseWinningLetterEntity; |
| | | import com.by4cloud.platformx.device.mapper.PurchaseTendrOrderMapper; |
| | | import com.by4cloud.platformx.device.mapper.PurchaseWinningLetterMapper; |
| | | import com.by4cloud.platformx.device.service.PurchaseWinningLetterService; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.stereotype.Service; |
| | | /** |
| | | * 中标通知书 |
| | |
| | | * @date 2025-03-24 17:13:08 |
| | | */ |
| | | @Service |
| | | @AllArgsConstructor |
| | | public class PurchaseWinningLetterServiceImpl extends ServiceImpl<PurchaseWinningLetterMapper, PurchaseWinningLetterEntity> implements PurchaseWinningLetterService { |
| | | |
| | | private final PurchaseTendrOrderMapper orderMapper; |
| | | |
| | | @Override |
| | | public R saveNew(PurchaseWinningLetterEntity purchaseWinningLetter) { |
| | | baseMapper.insert(purchaseWinningLetter); |
| | | QueryWrapper<PurchaseTendrOrderEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("purchase_plan_code",purchaseWinningLetter.getPurchasePlanCode()); |
| | | PurchaseTendrOrderEntity orderEntity = orderMapper.selectOne(queryWrapper); |
| | | if (orderEntity!=null){ |
| | | orderEntity.setStatus("2"); |
| | | orderMapper.updateById(orderEntity); |
| | | } |
| | | return R.ok(); |
| | | } |
| | | } |
| | |
| | | <resultMap id="deviceRepairMap" type="com.by4cloud.platformx.device.entity.DeviceScrap"> |
| | | <id property="id" column="id"/> |
| | | <result property="compId" column="comp_id"/> |
| | | <result property="deviceCoder" column="device_coder"/> |
| | | <result property="deviceCode" column="device_code"/> |
| | | <result property="deviceId" column="device_id"/> |
| | | <result property="inventoryId" column="inventory_id"/> |
| | | <result property="repairEndDate" column="repair_end_date"/> |
| | |
| | | <result property="updateTime" column="update_time"/> |
| | | <result property="delFlag" column="del_flag"/> |
| | | </resultMap> |
| | | <select id="pageNew" resultType="com.by4cloud.platformx.device.entity.vo.DeviceRepairPageVo"> |
| | | select |
| | | dr.id, |
| | | d.name deviceName, |
| | | d.`number` deviceCode, |
| | | dr.serial_no, |
| | | dr.repair_start_date, |
| | | dr.repair_end_date, |
| | | dr.status |
| | | from |
| | | device_repair dr |
| | | join device d on |
| | | dr.device_id = d.id |
| | | where |
| | | dr.del_flag='0' |
| | | <if test="queryDTO.deviceName != null and queryDTO.deviceName !=''"> |
| | | and d.name like CONCAT('%', #{queryDTO.deviceName}, '%') |
| | | </if> |
| | | <if test="queryDTO.serialNo != null and queryDTO.serialNo !=''"> |
| | | and dr.serial_no like CONCAT('%', #{queryDTO.serialNo}, '%') |
| | | </if> |
| | | </select> |
| | | </mapper> |
| | |
| | | <result property="updateTime" column="update_time"/> |
| | | <result property="delFlag" column="del_flag"/> |
| | | </resultMap> |
| | | <select id="pageNew" resultType="com.by4cloud.platformx.device.entity.vo.DeviceScrapPageVo"> |
| | | select |
| | | ds.id, |
| | | d.name deviceName, |
| | | d.`number` deviceCode, |
| | | ds.serial_no, |
| | | ds.scrap_date , |
| | | ds.status |
| | | from |
| | | device_scrap ds |
| | | join device d on |
| | | ds.device_id = d.id |
| | | where |
| | | ds.del_flag='0' |
| | | <if test="queryDTO.deviceName != null and queryDTO.deviceName !=''"> |
| | | and d.name like CONCAT('%', #{queryDTO.deviceName}, '%') |
| | | </if> |
| | | <if test="queryDTO.serialNo != null and queryDTO.serialNo !=''"> |
| | | and ds.serial_no like CONCAT('%', #{queryDTO.serialNo}, '%') |
| | | </if> |
| | | </select> |
| | | </mapper> |
| | |
| | | ifw.id, |
| | | d.name deviceName, |
| | | dc.name className, |
| | | d.create_time , |
| | | ifw.create_time , |
| | | ifw.operate_type, |
| | | di.serial_no |
| | | from |