Tree (group by field relations)
xtt->MERGE( IV_BLOCK_NAME = ‘R’ IS_BLOCK =
{"TITLE"=>"Title", "T"=>[{"DIR"=>"R:", "PAR_DIR"=>"", "LEVEL"=>0, "SUM"=>11248005.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\my", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>597144.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\my\\_rels", "PAR_DIR"=>"R:\\my", "LEVEL"=>2, "SUM"=>597144.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>3625607.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\REPORT\\docProps", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>502146.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>2663061.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\REPORT\\xl\\drawings", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>227675.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\REPORT\\xl\\drawings\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl\\drawings", "LEVEL"=>4, "SUM"=>227675.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl\\media", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>771720.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl\\printerSettings", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>303138.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl\\theme", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>44522.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl\\worksheets", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>947679.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\REPORT\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl\\worksheets", "LEVEL"=>4, "SUM"=>947679.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\xl\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>368327.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\REPORT\\_rels", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>460400.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>2430242.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\TEMPLATE\\docProps", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>552585.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE\\xl", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>1329976.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\TEMPLATE\\xl\\printerSettings", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>215971.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE\\xl\\theme", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>226094.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE\\xl\\worksheets", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>249030.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\TEMPLATE\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\TEMPLATE\\xl\\worksheets", "LEVEL"=>4, "SUM"=>249030.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE\\xl\\_rels", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>638881.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\TEMPLATE\\_rels", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>547681.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>4595012.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\fin", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>2233406.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\fin\\docProps", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>40618.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>2073153.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>68966.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings", "LEVEL"=>5, "SUM"=>68966.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\media", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>51860.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\printerSettings", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>545187.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\theme", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>406185.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>457355.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets", "LEVEL"=>5, "SUM"=>457355.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\xl\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>543600.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\fin\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>119635.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\gif", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>52246.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>2309360.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\template\\docProps", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>768695.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\FormParameters", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>272798.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\xl", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>1022341.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\template\\xl\\printerSettings", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>97818.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\xl\\theme", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>29555.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>7112.0, "HAS_CHILDREN"=>"X"}, {"DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets", "LEVEL"=>5, "SUM"=>7112.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\xl\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>887856.0, "HAS_CHILDREN"=>""}, {"DIR"=>"R:\\ZXLWB\\template\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>245526.0, "HAS_CHILDREN"=>""}], "C"=>[{"LEVEL"=>0, "SUB_NODES"=>[{"NAME"=>"R:\\my", "ATTR"=>{"LEVEL"=>1, "SUB_NODES"=>[{"NAME"=>"R:\\my\\_rels", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\my\\_rels", "PAR_DIR"=>"R:\\my", "LEVEL"=>2, "SUM"=>597144.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\my", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>597144.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\REPORT", "ATTR"=>{"LEVEL"=>1, "SUB_NODES"=>[{"NAME"=>"R:\\REPORT\\docProps", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\docProps", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>502146.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\REPORT\\xl", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[{"NAME"=>"R:\\REPORT\\xl\\drawings", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[{"NAME"=>"R:\\REPORT\\xl\\drawings\\_rels", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\drawings\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl\\drawings", "LEVEL"=>4, "SUM"=>227675.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\drawings", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>227675.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\REPORT\\xl\\media", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\media", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>771720.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\REPORT\\xl\\printerSettings", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\printerSettings", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>303138.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\REPORT\\xl\\theme", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\theme", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>44522.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\REPORT\\xl\\worksheets", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[{"NAME"=>"R:\\REPORT\\xl\\worksheets\\_rels", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl\\worksheets", "LEVEL"=>4, "SUM"=>947679.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\worksheets", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>947679.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\REPORT\\xl\\_rels", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\xl\\_rels", "PAR_DIR"=>"R:\\REPORT\\xl", "LEVEL"=>3, "SUM"=>368327.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\REPORT\\xl", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>2663061.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\REPORT\\_rels", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\REPORT\\_rels", "PAR_DIR"=>"R:\\REPORT", "LEVEL"=>2, "SUM"=>460400.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\REPORT", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>3625607.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\TEMPLATE", "ATTR"=>{"LEVEL"=>1, "SUB_NODES"=>[{"NAME"=>"R:\\TEMPLATE\\docProps", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\docProps", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>552585.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\TEMPLATE\\xl", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[{"NAME"=>"R:\\TEMPLATE\\xl\\printerSettings", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl\\printerSettings", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>215971.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\TEMPLATE\\xl\\theme", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl\\theme", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>226094.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\TEMPLATE\\xl\\worksheets", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[{"NAME"=>"R:\\TEMPLATE\\xl\\worksheets\\_rels", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\TEMPLATE\\xl\\worksheets", "LEVEL"=>4, "SUM"=>249030.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl\\worksheets", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>249030.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\TEMPLATE\\xl\\_rels", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl\\_rels", "PAR_DIR"=>"R:\\TEMPLATE\\xl", "LEVEL"=>3, "SUM"=>638881.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\xl", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>1329976.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\TEMPLATE\\_rels", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\TEMPLATE\\_rels", "PAR_DIR"=>"R:\\TEMPLATE", "LEVEL"=>2, "SUM"=>547681.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\TEMPLATE", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>2430242.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB", "ATTR"=>{"LEVEL"=>1, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\fin", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\fin\\docProps", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\docProps", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>40618.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\fin\\xl\\drawings", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\fin\\xl\\drawings\\_rels", "ATTR"=>{"LEVEL"=>5, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings", "LEVEL"=>5, "SUM"=>68966.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\drawings", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>68966.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl\\media", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\media", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>51860.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl\\printerSettings", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\printerSettings", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>545187.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl\\theme", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\theme", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>406185.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl\\worksheets", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\fin\\xl\\worksheets\\_rels", "ATTR"=>{"LEVEL"=>5, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets", "LEVEL"=>5, "SUM"=>457355.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\worksheets", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>457355.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\fin\\xl\\_rels", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin\\xl", "LEVEL"=>4, "SUM"=>543600.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\xl", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>2073153.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\fin\\_rels", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\fin", "LEVEL"=>3, "SUM"=>119635.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\fin", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>2233406.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\gif", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\gif", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>52246.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\template", "ATTR"=>{"LEVEL"=>2, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\template\\docProps", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\docProps", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>768695.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\template\\FormParameters", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\FormParameters", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>272798.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\template\\xl", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\template\\xl\\printerSettings", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl\\printerSettings", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>97818.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\template\\xl\\theme", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl\\theme", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>29555.0, "HAS_CHILDREN"=>""}}}, {"NAME"=>"R:\\ZXLWB\\template\\xl\\worksheets", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[{"NAME"=>"R:\\ZXLWB\\template\\xl\\worksheets\\_rels", "ATTR"=>{"LEVEL"=>5, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets", "LEVEL"=>5, "SUM"=>7112.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl\\worksheets", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>7112.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\template\\xl\\_rels", "ATTR"=>{"LEVEL"=>4, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template\\xl", "LEVEL"=>4, "SUM"=>887856.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\xl", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>1022341.0, "HAS_CHILDREN"=>"X"}}}, {"NAME"=>"R:\\ZXLWB\\template\\_rels", "ATTR"=>{"LEVEL"=>3, "SUB_NODES"=>[], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template\\_rels", "PAR_DIR"=>"R:\\ZXLWB\\template", "LEVEL"=>3, "SUM"=>245526.0, "HAS_CHILDREN"=>""}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB\\template", "PAR_DIR"=>"R:\\ZXLWB", "LEVEL"=>2, "SUM"=>2309360.0, "HAS_CHILDREN"=>"X"}}}], "DATA"=>{"DIR"=>"R:\\ZXLWB", "PAR_DIR"=>"R:", "LEVEL"=>1, "SUM"=>4595012.0, "HAS_CHILDREN"=>"X"}}}], "DATA"=>{"DIR"=>"R:", "PAR_DIR"=>"", "LEVEL"=>0, "SUM"=>11248005.0, "HAS_CHILDREN"=>"X"}}]}
).
Возможно, деревья основанные на подитогах более распространены, но в SAP есть некоторые другие иерархические данные, такие как СПП-элементы или организационные единицы HR.
Для такого рода данных, когда количество подуровней неизвестно заранее и существует только отношение «родительский - дочерний», вы можете возпользоваться методом «TREE_CREATE_RELAT».
Метод TREE_CREATE_RELAT
Иерархия папок
BEGIN OF ts_tree_06,
" Folders hierarchy
dir TYPE string,
par_dir TYPE string,
" Empty field. Filled in on_prepare_tree_06
level TYPE i,
END OF ts_tree_06,
tt_tree_06 TYPE STANDARD TABLE OF ts_tree_06 WITH DEFAULT KEY,
" Document structure
BEGIN OF ts_root,
title TYPE string,
t TYPE REF TO data, " <-- Table of trees (better to use general REF TO)
END OF ts_root.
После заполнения таблицы lt_folders (dir & par_dir) просто передаем имена полей методу TREE_CREATE_RELAT
.
GET REFERENCE OF lt_folders INTO lr_table.
ls_root-t = zcl_xtt_replace_block=>tree_create_relat(
it_table = lr_table " from 7.5 REF #(lt_folders)
iv_node_key = 'DIR'
iv_relat_key = 'PAR_DIR' ).
Все промежуточные итоги также заполняются обработчиком prepare_tree
. Для демонстрационной цели в примере заполняется только поле LEVEL
.
METHOD on_prepare_tree_06.
FIELD-SYMBOLS:
<ls_data> TYPE ts_tree_06.
" Cast to specefic data
ASSIGN ir_data->* TO <ls_data>.
<ls_data>-level = ir_tree->level.
ENDMETHOD.
Уровень группировки также будет скопирован в нижестоящие элементы