baofeng/src/main/java/com/template/mapper/CompaniesMapper.java

package com.template.mapper;

import com.template.model.Companies;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

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

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2024-06-18
 */
@Component
@Mapper
public interface CompaniesMapper extends BaseMapper<Companies> {

    @Select("SELECT p.* ,\n" +
            "(SELECT COUNT(1)  from companies cc where cc.postion_id=p.id ) tcount \n" +
            "from\n" +
            "postions p ")
    List<Map<String, Object>> getAllCount();

}