统计状态过滤

ZQN

2024-06-27 55fefdfac9a281cc57a1b3bad1fd061eec4b066d

 project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java

@@ -1,9 +1,12 @@
package com.project.enforce.mapper;

import com.project.enforce.domain.EnforceOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.project.enforce.domain.EnforceOrder;
import com.project.enforce.domain.bo.queryBo.EnforceOrderQueryBo;
import com.project.enforce.domain.bo.queryBo.OrderCheckedQueryBo;
import com.project.enforce.domain.vo.EnforceOrderVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@@ -17,4 +20,12 @@

    List<EnforceOrderVo> selectCheckList(EnforceOrderQueryBo bo);

    List<EnforceOrderVo> selectCheckedList(OrderCheckedQueryBo bo);


    List<EnforceOrderVo> selectScanList(@Param("companyCode") String companyCode,@Param("userId") Long userId);

    @Select("SELECT COUNT(DISTINCT company_id) FROM enforce_order where check_status>=2")
    Integer getDistinctCompanyNum();

}