package com.yeejoin.amos.boot.module.jxiop.biz.amosprojectmapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yeejoin.amos.boot.module.jxiop.biz.entity.PrivilegeCompany;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PrivilegeCompanyMapper extends BaseMapper<PrivilegeCompany> {

    @Select("select SEQUENCE_NBR as sequenceNbr,ORG_CODE as orgCode,COMPANY_NAME as companyName ,LEVEL as level from privilege_company where COMPANY_TYPE = 'region' and IS_DELETED = 0  ")
   public List<PrivilegeCompany> getAreaCompany();
}
