package com.nuvole.four.mapper;

import com.nuvole.four.domain.StoreIndustryManage;
import com.nuvole.four.domain.query.StoreIndustryManageQuery;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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

/**
 * @Description 行业管理Mapper
 * @Author dqh
 * @Date 2024-04-12 17:41:29
 */
@Mapper
public interface StoreIndustryManageMapper {
    int deleteByPrimaryKey(Long id);

    int insert(StoreIndustryManage record);

    int insertSelective(StoreIndustryManage record);

    StoreIndustryManage selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(StoreIndustryManage record);

    int updateByPrimaryKey(StoreIndustryManage record);

    /**
     * 查询列表
     *
     * @param query
     * @return 查询结果
     */
    List<StoreIndustryManage> selectList(StoreIndustryManageQuery query);

    /**
     * 方法描述: 查询max(sortNo)的序号信息
     * 返回 = max(sortNo) + 10
     *
     * @date  2024-04-12 18:17
     **/
    @Select("select (max(sort_no) + 10) sortNo from store_industry_manage")
    Integer getSort();

    /**
     * 方法描述:根据ID查询对应层级level；并自动+1得出下级level
     *
     * @date  2024-04-12 18:40
     **/
    @Select("select (`level` + 1) from store_industry_manage where id = #{id} ")
    Integer getLevel(Long id);

    /**
     * 方法描述:查询列表默认方法
     **/
    List<StoreIndustryManage> selectAll(Map map);

    /**
     * 方法描述:查询当前节点是否包含子节点
     *
     **/
    @Select("select count(1) from store_industry_manage where p_id = #{id} and deleted=0")
    int selectByPid(Long id);

    /**
     * 方法描述: 查询同级最大的code
     *
     * @date  2024-04-13 21:51
     **/
    @Select("select max(industry_code) from store_industry_manage where p_id = #{pid} and industry_code = #{industryCode}")
    String getMaxCode(@Param("pid") Long pid, @Param("industryCode") String industryCode);
}