| | |
| | | import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; |
| | | import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX; |
| | | import cn.iocoder.yudao.module.crm.controller.admin.receivable.vo.receivable.CrmReceivablePageReqVO; |
| | | import cn.iocoder.yudao.module.crm.dal.dataobject.contract.CrmContractDO; |
| | | import cn.iocoder.yudao.module.crm.dal.dataobject.receivable.CrmReceivableDO; |
| | | import cn.iocoder.yudao.module.crm.enums.common.CrmAuditStatusEnum; |
| | | import cn.iocoder.yudao.module.crm.enums.common.CrmBizTypeEnum; |
| | |
| | | default PageResult<CrmReceivableDO> selectPageByCustomerId(CrmReceivablePageReqVO reqVO) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<CrmReceivableDO>() |
| | | .eq(CrmReceivableDO::getCustomerId, reqVO.getCustomerId()) // 必须传递 |
| | | .eqIfPresent(CrmReceivableDO::getNo, reqVO.getNo()) |
| | | .likeIfPresent(CrmReceivableDO::getNo, reqVO.getNo()) |
| | | .eqIfPresent(CrmReceivableDO::getContractId, reqVO.getContractId()) |
| | | .eqIfPresent(CrmReceivableDO::getPlanId, reqVO.getPlanId()) |
| | | .orderByDesc(CrmReceivableDO::getId)); |
| | |
| | | CrmReceivableDO::getId, userId, pageReqVO.getSceneType()); |
| | | // 拼接自身的查询条件 |
| | | query.selectAll(CrmReceivableDO.class) |
| | | .eqIfPresent(CrmReceivableDO::getNo, pageReqVO.getNo()) |
| | | .likeIfPresent(CrmReceivableDO::getNo, pageReqVO.getNo()) |
| | | .eqIfPresent(CrmReceivableDO::getCustomerId, pageReqVO.getCustomerId()) |
| | | .eqIfPresent(CrmReceivableDO::getPlanId, pageReqVO.getPlanId()) |
| | | .eqIfPresent(CrmReceivableDO::getContractId, pageReqVO.getContractId()) |
| | | .eqIfPresent(CrmReceivableDO::getAuditStatus, pageReqVO.getAuditStatus()) |
| | |
| | | CrmPermissionUtils.appendPermissionCondition(query, CrmBizTypeEnum.CRM_RECEIVABLE.getType(), |
| | | CrmReceivableDO::getId, userId, CrmSceneTypeEnum.OWNER.getType()); |
| | | // 未审核 |
| | | query.eq(CrmContractDO::getAuditStatus, CrmAuditStatusEnum.PROCESS.getStatus()); |
| | | query.eq(CrmReceivableDO::getAuditStatus, CrmAuditStatusEnum.PROCESS.getStatus()); |
| | | return selectCount(query); |
| | | } |
| | | |