package jnpf.dmsMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.dmsEntity.print.DmsPrintOperationLogEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface DmsPrintOperationLogMapper extends BaseMapper<DmsPrintOperationLogEntity> {
|
@Select("SELECT NULLIF(btrim(f_full_name), '') FROM public.base_module "
|
+ "WHERE f_id = #{menuId} AND (f_delete_mark IS NULL OR f_delete_mark <> 1) LIMIT 1")
|
String selectMenuNameById(@Param("menuId") String menuId);
|
|
@Select("WITH RECURSIVE ancestors AS ("
|
+ " SELECT f_id, f_parent_id, f_system_id, f_category, f_type,"
|
+ " f_is_parent_biz_module, f_full_name, 0 AS depth FROM public.base_module"
|
+ " WHERE f_id = #{menuId} AND f_enabled_mark = 1"
|
+ " AND (f_delete_mark IS NULL OR f_delete_mark <> 1)"
|
+ " UNION ALL"
|
+ " SELECT parent.f_id, parent.f_parent_id, parent.f_system_id, parent.f_category,"
|
+ " parent.f_type, parent.f_is_parent_biz_module, parent.f_full_name, child.depth + 1"
|
+ " FROM ancestors child JOIN public.base_module parent ON parent.f_id = child.f_parent_id"
|
+ " AND parent.f_system_id = child.f_system_id AND parent.f_category = child.f_category"
|
+ " WHERE child.depth < 32 AND parent.f_enabled_mark = 1"
|
+ " AND (parent.f_delete_mark IS NULL OR parent.f_delete_mark <> 1)"
|
+ ") SELECT LEFT(NULLIF(btrim(f_full_name), ''), 200) FROM ancestors"
|
+ " WHERE depth > 0 AND f_type = 1 AND f_is_parent_biz_module = 1"
|
+ " AND f_id = #{parentId} AND depth = (SELECT MIN(depth) FROM ancestors"
|
+ " WHERE depth > 0 AND f_type = 1 AND f_is_parent_biz_module = 1) LIMIT 1")
|
String selectParentBizModuleName(@Param("menuId") String menuId,
|
@Param("parentId") String parentId);
|
}
|
