adm-poc-backend/bogda/CLMT/bak/sys_pipe.clmt

<templet>
	<version>1.0</version>
	<procedure _name="target">
		<elements>
			<tables_query>
				<name>query</name>
				<description>查询管线范围</description>
				<dataSource>poc</dataSource>
				<customFields></customFields>
				<tables>
					<mtq_table>
						<table>main_scope</table>
						<fieldsWhere>
							<type>='pipe_sys'</type>
						</fieldsWhere>
					</mtq_table>
					<mtq_table>
						<table>pipe_scope</table>
						<fields>
							<bogda_item>
								<bogda_item>sys</bogda_item>
								<bogda_null/>
							</bogda_item>
							<bogda_item>
								<bogda_item>code</bogda_item>
								<bogda_item>pipeCode</bogda_item>
							</bogda_item>
							<bogda_item>
								<bogda_item>main</bogda_item>
								<bogda_null/>
							</bogda_item>
							<bogda_item>
								<bogda_item>branch</bogda_item>
								<bogda_null/>
							</bogda_item>
							<bogda_item>
								<bogda_item>other</bogda_item>
								<bogda_null/>
							</bogda_item>
						</fields>
					</mtq_table>
				</tables>
				<relations>
					<table_relation>
						<table1>main_scope</table1>
						<field1>code</field1>
						<table2>pipe_scope</table2>
						<field2>sys</field2>
					</table_relation>
				</relations>
			</tables_query>
			<json_query>
				<name>pipeQuery</name>
				<json>clmt('dict/types', null, 'pipe')</json>
			</json_query>
			<ref_res>
				<name>headers</name>
				<ref>resource/headers</ref>
			</ref_res>
			<http_do>
				<name>sysData</name>
				<http_req name="req">
					<url>http://47.93.22.124/datacenter/dict/category</url>
					<method>POST</method>
					<headersVar>headers</headersVar>
					<params>
						<property>
							<key>type</key>
							<value>majorSystem</value>
						</property>
					</params>
				</http_req>
			</http_do>
			<variable>
				<name>add</name>
				<assignment>query.addCol({
	sysName: get(treeNode(sysData.content, 'code', query.sys, false), 'name'),
	pipeName: pipeQuery.get(pipeQuery.name, pipeQuery.code==query.pipeCode)
})</assignment>
			</variable>
			<logic_grid>
				<name>grid</name>
				<l_grid name="grid">
					<rowCount>10</rowCount>
					<colCount>9</colCount>
					<rows>
						<l_row>
							<index>0</index>
						</l_row>
						<l_row>
							<index>1</index>
						</l_row>
						<l_row>
							<index>2</index>
						</l_row>
						<l_row>
							<index>3</index>
						</l_row>
						<l_row>
							<index>4</index>
						</l_row>
						<l_row>
							<index>5</index>
						</l_row>
						<l_row>
							<index>6</index>
						</l_row>
						<l_row>
							<index>7</index>
						</l_row>
						<l_row>
							<index>8</index>
						</l_row>
						<l_row>
							<index>9</index>
						</l_row>
					</rows>
					<columns>
						<l_col>
							<index>0</index>
						</l_col>
						<l_col>
							<index>1</index>
						</l_col>
						<l_col>
							<index>2</index>
						</l_col>
						<l_col>
							<index>3</index>
						</l_col>
						<l_col>
							<index>4</index>
						</l_col>
						<l_col>
							<index>5</index>
						</l_col>
						<l_col>
							<index>6</index>
						</l_col>
						<l_col>
							<index>7</index>
						</l_col>
						<l_col>
							<index>8</index>
						</l_col>
					</columns>
					<cells>
						<bogda_item>
							<l_cell>
								<l_replication _name="replication">
									<dataBind>=query.group(sys)</dataBind>
									<dimension>1</dimension>
								</l_replication>
								<rowIndex>0</rowIndex>
								<colIndex>0</colIndex>
								<props>
									<data>=query.sys</data>
									<data_id>sys</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>1</colIndex>
								<props>
									<data>=query.sysName</data>
									<data_id>sysName</data_id>
								</props>
							</l_cell>
							<l_cell>
								<l_replication _name="replication">
									<dataBind>=query.list()</dataBind>
									<dimension>1</dimension>
								</l_replication>
								<rowIndex>0</rowIndex>
								<colIndex>2</colIndex>
								<props>
									<data_id>children</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>3</colIndex>
								<props>
									<data>=query.pipeCode</data>
									<data_id>pipe_code</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>4</colIndex>
								<props>
									<data>=query.pipeName</data>
									<data_id>pipeName</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>5</colIndex>
								<props>
									<data>=query.main</data>
									<data_id>main</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>6</colIndex>
								<props>
									<data>=query.branch</data>
									<data_id>branch</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>7</colIndex>
								<props>
									<data>=query.other</data>
									<data_id>other</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>2</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>3</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>4</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>5</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>6</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>7</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>8</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>2</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>3</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>4</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>5</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>6</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>7</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>9</rowIndex>
								<colIndex>8</colIndex>
							</l_cell>
						</bogda_item>
					</cells>
				</l_grid>
				<output>
					<grid_out>
						<name>rtn</name>
						<content>region(A1,H1)</content>
					</grid_out>
				</output>
			</logic_grid>
		</elements>
		<output>
			<variable>
				<name>rtn</name>
				<description>交付范围内的系统-管线树</description>
				<assignment>grid.rtn</assignment>
			</variable>
		</output>
	</procedure>
	<comments>
		<next_id>1</next_id>
		<list>
			<comment>
				<id>0</id>
				<items>
					<comment_item>
						<content>查询交付范围内的系统-管线</content>
						<update_time>2021-6-8 16:13</update_time>
					</comment_item>
				</items>
			</comment>
		</list>
	</comments>
	<comment_id>0</comment_id>
</templet>