adm-poc-backend/bogda/CLMT/query/space_rel.clmt

<templet>
	<version>1.0</version>
	<procedure _name="target">
		<parameters>
			<ref_parameter>
				<name>spaceId</name>
				<ref>resource/params.spaceId</ref>
			</ref_parameter>
		</parameters>
		<elements>
			<table_query>
				<name>rels</name>
				<dataSource>poc</dataSource>
				<table>relation</table>
			</table_query>
			<table_query>
				<name>pipe</name>
				<dataSource>poc</dataSource>
				<table>pipe</table>
				<fieldsWhere>
					<spaceId>=spaceId</spaceId>
					<state>='1'</state>
				</fieldsWhere>
			</table_query>
			<table_query>
				<name>eq</name>
				<dataSource>poc</dataSource>
				<table>device</table>
				<fieldsWhere>
					<spaceId>=spaceId</spaceId>
					<state>='1'</state>
				</fieldsWhere>
			</table_query>
			<table_query>
				<name>eq_rels</name>
				<description>设备间关系代码</description>
				<dataSource>poc</dataSource>
				<table>adm_relation</table>
				<fields1>
					<bogda_item>
						<bogda_item>code</bogda_item>
						<bogda_null/>
					</bogda_item>
				</fields1>
				<fieldsWhere>
					<type>='eq_eq'</type>
				</fieldsWhere>
			</table_query>
		</elements>
		<output>
			<variable>
				<comment_id>1</comment_id>
				<name>rtn</name>
				<description>空间下的关系数据</description>
				<assignment><![CDATA[{
	eq_sp_serve: rels.list(rels.right_node==spaceId),
	eq_eq: rels.list(eq.get(eq.id, eq.deviceId==rels.left_node)!=null && eq_rels.select(eq_rels.code).indexOf(rels.relation)>=0),
	eq_pipe_cnct: rels.list(eq.get(eq.id, eq.deviceId==rels.left_node)!=null && rels.relation=='eq_pipe_cnct'),
}]]></assignment>
			</variable>
		</output>
	</procedure>
	<comments>
		<next_id>2</next_id>
		<list>
			<comment>
				<id>0</id>
				<items>
					<comment_item>
						<content>查询某个空间下的全部关系</content>
						<update_time>2021-6-10 15:21</update_time>
					</comment_item>
				</items>
			</comment>
			<comment>
				<id>1</id>
				<items>
					<comment_item>
						<content>返回数据示例：
{
  "rtn": {
    "eq_sp_serve": [ //设备服务于空间
      {
        "id": 4,
        "left_node": "6dcbd6a1f7904f50bd6d73fe132a5ac3", //设备id
        "right_node": "Sp0002220011f170a7c74f8347589ea9863cfec65fab", //目标id
        "relation": "eq_sp_serve"
      }
    ],
    "eq_eq": [], //设备间关系
    "eq_pipe_cnct": [] //设备连接管道
  }
}</content>
						<update_time>2021-6-10 15:51</update_time>
					</comment_item>
				</items>
			</comment>
		</list>
	</comments>
	<comment_id>0</comment_id>
</templet>