package com.artfess.examine.dao;

import com.alibaba.fastjson.JSONObject;
import com.artfess.examine.model.ExamPosSys;
import com.artfess.examine.vo.PositionVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 人员类别专业岗位中间表 Mapper 接口
 *
 * @company 阿特菲斯信息技术有限公司
 * @author min.wu
 * @since 2022-11-08
 */
public interface ExamPosSysDao extends BaseMapper<ExamPosSys> {

    List<PositionVo> getPositionInfo(@Param("id") String id);

    List<PositionVo> findByBindPos(@Param("idList") List<String> idList);

    String getOrgId(@Param("positionId") String positionId);

    String findByOrgName(@Param("orgName") String orgName);

    Long getOrgCount();

    Long getUserCount();

    Long getJlyCount();

    Long getSysCount();

    Long getSubjectCount();

}