package cn.iocoder.yudao.module.aftersales.dal.mysql.compensation; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.aftersales.controller.admin.compensation.vo.AfterSaleCompensationPageReqVO; import cn.iocoder.yudao.module.aftersales.dal.dataobject.compensation.AfterSaleCompensationDO; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import org.apache.ibatis.annotations.Mapper; import java.time.LocalDateTime; /** * 售后赔付/服务补偿单 Mapper */ @Mapper public interface AfterSaleCompensationMapper extends BaseMapperX { default AfterSaleCompensationDO selectByCompensationNo(String compensationNo) { return selectOne(AfterSaleCompensationDO::getCompensationNo, compensationNo); } /** * 提交审批:置为审批中,并清空上一轮审核结果 * * 用 UpdateWrapper 而非 updateById:MyBatis-Plus 默认的字段更新策略会忽略 null, * 直接 updateById 无法把审核不通过后残留的审核人、审核时间、审核意见真正清空。 * * @param id 赔付单编号 * @param status 目标状态(审批中) * @return 影响行数 */ default int submitAndResetAuditInfo(Long id, Integer status) { return update(null, new LambdaUpdateWrapper() .eq(AfterSaleCompensationDO::getId, id) .set(AfterSaleCompensationDO::getAuditStatus, status) .set(AfterSaleCompensationDO::getReviewerId, null) .set(AfterSaleCompensationDO::getReviewerName, null) .set(AfterSaleCompensationDO::getReviewTime, null) .set(AfterSaleCompensationDO::getReviewRemark, null)); } /** * 审核:写入审核结果、审核人与审核意见 * * reviewRemark 允许为 null(审核通过时意见可选),故同样使用 UpdateWrapper 直写。 * * @param id 赔付单编号 * @param status 目标状态(审核通过 / 审核不通过) * @param reviewerId 审核人编号 * @param reviewerName 审核人姓名 * @param reviewRemark 审核意见 * @return 影响行数 */ default int auditCompensation(Long id, Integer status, Long reviewerId, String reviewerName, String reviewRemark) { return update(null, new LambdaUpdateWrapper() .eq(AfterSaleCompensationDO::getId, id) .set(AfterSaleCompensationDO::getAuditStatus, status) .set(AfterSaleCompensationDO::getReviewerId, reviewerId) .set(AfterSaleCompensationDO::getReviewerName, reviewerName) .set(AfterSaleCompensationDO::getReviewTime, LocalDateTime.now()) .set(AfterSaleCompensationDO::getReviewRemark, reviewRemark)); } default PageResult selectPage(AfterSaleCompensationPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(AfterSaleCompensationDO::getCompensationNo, reqVO.getCompensationNo()) .eqIfPresent(AfterSaleCompensationDO::getCompensationType, reqVO.getCompensationType()) .eqIfPresent(AfterSaleCompensationDO::getTicketId, reqVO.getTicketId()) .eqIfPresent(AfterSaleCompensationDO::getCustomerId, reqVO.getCustomerId()) .eqIfPresent(AfterSaleCompensationDO::getAuditStatus, reqVO.getAuditStatus()) .orderByDesc(AfterSaleCompensationDO::getId)); } }