package com.sinata.modular.mall.dao;
|
|
import com.sinata.modular.mall.model.MallClassifyTwo;
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* <p>
|
* 商品二级分类 Mapper 接口
|
* </p>
|
*
|
* @author goku
|
* @since 2023-03-11
|
*/
|
public interface MallClassifyTwoMapper extends BaseMapper<MallClassifyTwo> {
|
|
|
@Select("select " +
|
" CONCAT( one.classify_name, '-', two.classify_name) " +
|
" FROM mall_classify_two two " +
|
" JOIN mall_classify_one one ON one.id = two.parent_classify_id " +
|
" WHERE two.id = #{id} ")
|
public String getHierarchyName(String id);
|
|
}
|
