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

<templet>
	<version>1.0</version>
	<procedure _name="target">
		<elements>
			<ref_res>
				<name>headers</name>
				<ref>resource/headers</ref>
			</ref_res>
			<http_do>
				<name>data</name>
				<http_req name="req">
					<url>http://47.93.22.124/datacenter/object/building/query</url>
					<method>POST</method>
					<headersVar>headers</headersVar>
					<params>
						<property>
							<key>pageNumber</key>
							<value>1</value>
						</property>
						<property>
							<key>pageSize</key>
							<value>1000</value>
						</property>
						<property>
							<key>cascade</key>
							<value>=[{name:'floor',orders: "floorSequenceID asc"}]</value>
						</property>
					</params>
				</http_req>
			</http_do>
			<table_query>
				<name>job</name>
				<dataSource>poc</dataSource>
				<table>job</table>
			</table_query>
			<logic_grid>
				<name>grid</name>
				<l_grid name="grid">
					<rowCount>5</rowCount>
					<colCount>5</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>
					</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>
							<props>
								<width>179</width>
							</props>
						</l_col>
						<l_col>
							<index>4</index>
						</l_col>
					</columns>
					<cells>
						<bogda_item>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>0</colIndex>
								<props>
									<data>建筑</data>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>1</colIndex>
								<props>
									<data>楼层</data>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>2</colIndex>
								<props>
									<data>楼层id</data>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>3</colIndex>
								<props>
									<data>空间任务</data>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>0</rowIndex>
								<colIndex>4</colIndex>
								<props>
									<data>设备勘测任务</data>
								</props>
							</l_cell>
						</bogda_item>
						<bogda_item>
							<l_cell>
								<l_replication _name="replication">
									<dataBind>=data.content</dataBind>
									<dimension>1</dimension>
								</l_replication>
								<rowIndex>1</rowIndex>
								<colIndex>0</colIndex>
							</l_cell>
							<l_cell>
								<l_replication _name="replication">
									<dataBind>=A2.floor</dataBind>
									<dimension>1</dimension>
								</l_replication>
								<rowIndex>1</rowIndex>
								<colIndex>1</colIndex>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>2</colIndex>
								<props>
									<data>=get(B2, 'id')</data>
									<data_id>floorId</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>3</colIndex>
								<props>
									<data><![CDATA[=job.count(job.floor_id==C2 && ['00','01','02'].indexOf(job.status) >= 0)]]></data>
									<data_id>space</data_id>
								</props>
							</l_cell>
							<l_cell>
								<rowIndex>1</rowIndex>
								<colIndex>4</colIndex>
								<props>
									<data><![CDATA[=job.count(job.floor_id==C2 && job.status=='04')]]></data>
									<data_id>device</data_id>
								</props>
							</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>
						</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>
						</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>
						</bogda_item>
					</cells>
				</l_grid>
				<output>
					<grid_out>
						<name>rtn</name>
						<content>region(C2,E2)</content>
					</grid_out>
				</output>
			</logic_grid>
		</elements>
		<output>
			<variable>
				<name>rtn</name>
				<description>建筑-楼层树</description>
				<assignment>data.content</assignment>
			</variable>
			<variable>
				<name>job_count</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-7 12:12</update_time>
					</comment_item>
				</items>
			</comment>
		</list>
	</comments>
	<comment_id>0</comment_id>
</templet>