ZQN
2024-08-14 5cbb2e7fc3d81ac895548179a7be9a65fa726c6d
project-enforce/src/main/java/com/project/enforce/mapper/EnforceOrderMapper.java
@@ -1,10 +1,13 @@
package com.project.enforce.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.project.common.vo.KeyVal;
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.EnforceDistinctVo;
import com.project.enforce.domain.vo.EnforceOrderVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@@ -18,7 +21,13 @@
    List<EnforceOrderVo> selectCheckList(EnforceOrderQueryBo bo);
    List<KeyVal> getMonthCount(Long deptId);
    List<EnforceOrderVo> selectCheckedList(OrderCheckedQueryBo bo);
    List<KeyVal> getDeptCount(String yearMonth);
    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();
    List<EnforceDistinctVo> selectDistinctCheckDeptIdAndCompanyId();
}