package com.yeejoin.amos.boot.module.jg.api.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yeejoin.amos.boot.module.jg.api.dto.JgUseRegistrationManageDto;
import com.yeejoin.amos.boot.module.jg.api.entity.JgUseRegistrationManage;
import com.yeejoin.amos.boot.module.jg.api.vo.SortVo;
import com.yeejoin.amos.boot.module.jg.api.vo.tableDataExportVo.CertificateVo;
import com.yeejoin.amos.boot.module.ymt.api.entity.IdxBizJgProjectContraption;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;


/**
 *  Mapper 接口
 *
 * @author system_generator
 * @date 2024-07-03
 */
public interface JgUseRegistrationManageMapper extends BaseMapper<JgUseRegistrationManage> {

    List<JgUseRegistrationManageDto> queryByUseUnitCreditCode(@Param("dto") JgUseRegistrationManageDto dto);


    Page<JgUseRegistrationManageDto> queryForPage(@Param("page") Page<JgUseRegistrationManageDto> page,
                                                  @Param("dto") JgUseRegistrationManageDto dto,
                                                  @Param("sort") SortVo sortMap);

    Page<JgUseRegistrationManageDto> queryForPageForJG(@Param("page") Page<JgUseRegistrationManageDto> page,
                                                  @Param("dto") JgUseRegistrationManageDto dto,
                                                  @Param("sort") SortVo sortMap, @Param("orgCode") String orgCode);



    Long countCertificateByReginCode(String orgCode);

    Page<JgUseRegistrationManageDto> getRecords(@Param("page") Page<JgUseRegistrationManageDto> page,
                                                @Param("dto") JgUseRegistrationManageDto dto,
                                                @Param("orgCode") String orgCode);

    List<CertificateVo> queryCertificateInIds(@Param("ids") List<String> ids);

    List<Map<String, String>> initUseRegistrationCodeIntoRedis(@Param("year") String year);

    List<Map<String, String>> initVehicleUseRegCodeIntoRedis(@Param("year") String year);

    Page<IdxBizJgProjectContraption> queryForUnitByProjectContraptionPage(@Param("page") Page<IdxBizJgProjectContraption> page,
                                                                          @Param("dto") Map<String, String> params,
                                                                          @Param("sort") SortVo sortMap);

    JgUseRegistrationManage getLatestJgUseRegistrationManage(@Param("useUnitCreditCode")String useUnitCreditCode, @Param("equDefineCode")String equDefineCode);

    Integer checkUseRegCertInBusiness(@Param("useRegistrationCode")String useRegistrationCode);

    Page<JgUseRegistrationManageDto> queryUseRegistrationManagePage(@Param("page") Page<JgUseRegistrationManageDto> page, @Param("dto") JgUseRegistrationManageDto dto, @Param("sort") SortVo sortMap);
}
