package cn.iocoder.yudao.module.research.dal.mysql.application;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.research.dal.dataobject.application.ResearchApplicationMemberDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ResearchApplicationMemberMapper extends BaseMapperX<ResearchApplicationMemberDO> {

    default List<ResearchApplicationMemberDO> selectListByApplicationId(Long applicationId) {
        LambdaQueryWrapperX<ResearchApplicationMemberDO> query = new LambdaQueryWrapperX<>();
        query.eq(ResearchApplicationMemberDO::getApplicationId, applicationId);
        query.orderByAsc(ResearchApplicationMemberDO::getSortNo);
        query.orderByAsc(ResearchApplicationMemberDO::getId);
        return selectList(query);
    }

    default int deleteByApplicationId(Long applicationId) {
        return delete(ResearchApplicationMemberDO::getApplicationId, applicationId);
    }

}