123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461 |
- <templet>
- <version>1.0</version>
- <procedure _name="target">
- <parameters>
- <ref_parameter>
- <name>scopeFilter</name>
- <ref>resource/params.scopeFilter</ref>
- </ref_parameter>
- <parameter>
- <name>sys</name>
- <description>选择的系统类型,不传递时过滤条件不生效</description>
- <format></format>
- </parameter>
- </parameters>
- <elements>
- <json_do>
- <name>data_bak</name>
- <description>不使用</description>
- <condition>false</condition>
- <json>[
- {
- "name": "液体管道",
- "code": "liquid",
- "type": "liquid",
- "children": [
- {
- "name": "给排水系统",
- "code": "water",
- "type": "liquid",
- "children": [
- {
- "name": "生活给水",
- "code": "water_1",
- "type": "liquid"
- },
- {
- "name": "生活热水给水",
- "code": "water_2",
- "type": "liquid"
- },
- {
- "name": "直饮水给水",
- "code": "water_3",
- "type": "liquid"
- },
- {
- "name": "中水给水",
- "code": "water_4",
- "type": "liquid"
- },
- {
- "name": "其他公共给水(水景、喷灌、泳池等)",
- "code": "water_5",
- "type": "liquid"
- },
- {
- "name": "污水排水",
- "code": "water_6",
- "type": "liquid"
- },
- {
- "name": "雨水收集",
- "code": "water_7",
- "type": "liquid"
- }
- ]
- },
- {
- "name": "空调系统",
- "code": "ac",
- "type": "liquid",
- "children": [
- {
- "name": "冷冻水",
- "code": "ac_1",
- "type": "liquid"
- },
- {
- "name": "冷却水",
- "code": "ac_2",
- "type": "liquid"
- },
- {
- "name": "采暖热水",
- "code": "ac_3",
- "type": "liquid"
- },
- {
- "name": "采暖蒸汽",
- "code": "ac_4",
- "type": "liquid"
- },
- {
- "name": "制冷剂",
- "code": "ac_5",
- "type": "liquid"
- },
- {
- "name": "吸收剂",
- "code": "ac_6",
- "type": "liquid"
- },
- {
- "name": "乙二醇",
- "code": "ac_7",
- "type": "liquid"
- }
- ]
- },
- {
- "name": "消防系统",
- "code": "fire",
- "type": "liquid",
- "children": [
- {
- "name": "消防给水",
- "code": "fire_1",
- "type": "liquid"
- },
- {
- "name": "液体灭火剂",
- "code": "fire_2",
- "type": "liquid"
- }
- ]
- },
- {
- "name": "特殊",
- "code": "sp",
- "type": "liquid",
- "children": [
- {
- "name": "燃油",
- "code": "sp_1",
- "type": "liquid"
- },
- {
- "name": "液化天然气",
- "code": "sp_2",
- "type": "liquid"
- }
- ]
- },
- {
- "name": "其他液体管道",
- "code": "liquid_other",
- "type": "liquid"
- }
- ]
- },
- {
- "name": "气体管道",
- "code": "air",
- "type": "air",
- "children": [
- {
- "name": "普通空调系统用风管",
- "code": "pk",
- "type": "air",
- "children": [
- {
- "name": "送风",
- "code": "pk_1",
- "type": "air"
- },
- {
- "name": "回风",
- "code": "pk_2",
- "type": "air"
- },
- {
- "name": "排风",
- "code": "pk_3",
- "type": "air"
- },
- {
- "name": "新风",
- "code": "pk_4",
- "type": "air"
- },
- {
- "name": "加压送风",
- "code": "pk_5",
- "type": "air"
- },
- {
- "name": "厨房排油烟",
- "code": "pk_6",
- "type": "air"
- }
- ]
- },
- {
- "name": "防排烟系统用风管",
- "code": "py",
- "type": "air",
- "children": [
- {
- "name": "消防补风",
- "code": "py_1",
- "type": "air"
- },
- {
- "name": "排烟",
- "code": "py_2",
- "type": "air"
- }
- ]
- },
- {
- "name": "含酸碱排风系统用风管",
- "code": "pf",
- "type": "air"
- },
- {
- "name": "燃气系统送燃气",
- "code": "gas",
- "type": "air"
- },
- {
- "name": "气体灭火剂管",
- "code": "gea",
- "type": "air"
- },
- {
- "name": "人防风管",
- "code": "ad",
- "type": "air"
- },
- {
- "name": "其他气体管道",
- "code": "air_other",
- "type": "air"
- }
- ]
- }
- ]</json>
- </json_do>
- <json_do>
- <name>data</name>
- <json>[
- {
- "name": "中央供冷系统",
- "code": "ACCC",
- "type": "sys",
- "children": [
- {
- "name": "冷冻水供水管",
- "code": "accc_pipe_01",
- "type": "pipe"
- },
- {
- "name": "冷冻水回水管",
- "code": "accc_pipe_02",
- "type": "pipe"
- },
- {
- "name": "补水管",
- "code": "accc_pipe_03",
- "type": "pipe"
- },
- {
- "name": "软化水管",
- "code": "accc_pipe_04",
- "type": "pipe"
- }
- ]
- },
- {
- "name": "空调末端系统",
- "code": "ACAT",
- "type": "sys",
- "children": [
- {
- "name": "冷冻水供水管",
- "code": "acat_pipe_01",
- "type": "pipe"
- },
- {
- "name": "冷冻水回水管",
- "code": "acat_pipe_02",
- "type": "pipe"
- },
- {
- "name": "冷凝水管",
- "code": "acat_pipe_03",
- "type": "pipe"
- }
- ]
- },
- {
- "name": "消防系统",
- "code": "FFFS",
- "type": "sys",
- "children": [
- {
- "name": "消火栓管",
- "code": "fffs_pipe_01",
- "type": "pipe"
- },
- {
- "name": "喷淋管",
- "code": "fffs_pipe_02",
- "type": "pipe"
- },
- {
- "name": "气体灭火管",
- "code": "fffs_pipe_03",
- "type": "pipe"
- }
- ]
- },
- {
- "name": "生活给水系统",
- "code": "WSDW",
- "type": "sys",
- "children": [
- {
- "name": "给水管",
- "code": "wsdw_pipe_01",
- "type": "pipe"
- },
- {
- "name": "废水管",
- "code": "wsdw_pipe_02",
- "type": "pipe"
- }
- ]
- },
- {
- "name": "强电系统",
- "code": "SE",
- "type": "sys",
- "children": [
- {
- "name": "强电桥架",
- "code": "se_pipe_01",
- "type": "pipe"
- },
- {
- "name": "强电线槽",
- "code": "se_pipe_02",
- "type": "pipe"
- }
- ]
- },
- {
- "name": "弱电系统",
- "code": "WE",
- "type": "sys",
- "children": [
- {
- "name": "弱电桥架",
- "code": "we_pipe_01",
- "type": "pipe"
- },
- {
- "name": "弱电线槽",
- "code": "we_pipe_02",
- "type": "pipe"
- }
- ]
- }
- ]</json>
- </json_do>
- <table_query>
- <name>pipe</name>
- <description>管线范围</description>
- <condition>scopeFilter</condition>
- <dataSource>poc</dataSource>
- <table>pipe_scope</table>
- <fields1>
- <bogda_item>
- <bogda_item>sys</bogda_item>
- <bogda_null/>
- </bogda_item>
- <bogda_item>
- <bogda_item>code</bogda_item>
- <bogda_null/>
- </bogda_item>
- <bogda_item>
- <bogda_item>id</bogda_item>
- <bogda_null/>
- </bogda_item>
- </fields1>
- </table_query>
- <variable>
- <name>filterData</name>
- <assignment>if(
- scopeFilter,
- Ext.treeFilter(data, 'children', pipe.get(id, pipe.code==this.code || pipe.sys==this.code)!=null)
- )</assignment>
- </variable>
- <json_query>
- <name>list</name>
- <json>if(scopeFilter, filterData, data)</json>
- </json_query>
- </elements>
- <output>
- <variable>
- <comment_id>1</comment_id>
- <name>rtn</name>
- <assignment>list.list(Str.isBlank(sys) ? true : list.code==sys)</assignment>
- </variable>
- </output>
- </procedure>
- <comments>
- <next_id>2</next_id>
- <list>
- <comment>
- <id>0</id>
- <items>
- <comment_item>
- <content>查询管道类型树</content>
- <update_time>2021-6-8 19:1</update_time>
- </comment_item>
- </items>
- </comment>
- <comment>
- <id>1</id>
- <items>
- <comment_item>
- <content>返回数据示例:
- [
- {
- "name": "中央供热系统",
- "code": "ACCH",
- "children": [
- {
- "name": "热水管",
- "code": "acch_water01"
- },
- {
- "name": "供热补水管",
- "code": "acch_water02"
- }
- ]
- },
- {
- "name": "中央供冷系统",
- "code": "ACCC",
- "children": [
- {
- "name": "冷冻水管",
- "code": "accc_water01"
- },
- {
- "name": "空调补水管",
- "code": "accc_water02"
- }
- ]
- }
- ]</content>
- <update_time>2021-6-9 10:45</update_time>
- </comment_item>
- </items>
- </comment>
- </list>
- </comments>
- <comment_id>0</comment_id>
- </templet>
|