<?xml version="1.0" encoding="UTF-8"?><!-- $Author: hty $Date: 2018/5/29 11:41 $Revision: 1.0 --><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"needAccessControl="false"><bm:operations><bm:operationname="query"><bm:query-sql><![CDATA[ SELECT v.function_id, v.function_code, v.function_name, v.menu_id, v.parent_menu_id, (select function_name from sys_role_menu_v where menu_id = v.parent_menu_id) parent_function_name, (select function_name from sys_role_menu_v where menu_id = ( select parent_menu_id from sys_role_menu_v where menu_id = v.parent_menu_id)) grand_parent_function_name, (select nvl(sum(1),0) from sys_role_menu_v v1 where v1.parent_menu_id=v.menu_id) sub_menu_count FROM sys_role_menu_v v WHERE v.function_code = ${@function_code} and v.role_id = ${/session/@role_id} ORDER BY v.layout_sequence ]]></bm:query-sql></bm:operation></bm:operations></bm:model>