adm-poc-backend/bogda/CLMT/job/close_problem.clmt

<templet>
	<version>1.0</version>
	<procedure _name="target">
		<parameters>
			<parameter>
				<name>problemId</name>
				<description>问题id</description>
				<type>5</type>
				<format></format>
				<validate>
					<v_required _name="v1">
					</v_required>
				</validate>
			</parameter>
			<ref_parameter>
				<name>spaceId</name>
				<ref>resource/params.spaceId</ref>
			</ref_parameter>
		</parameters>
		<elements>
			<table_operation>
				<name>problem</name>
				<description>关闭问题</description>
				<dataSource>poc</dataSource>
				<mode>2</mode>
				<table>space_problem</table>
				<fields>
					<field_data>
						<field>id</field>
						<data>=problemId</data>
						<restrict>0</restrict>
					</field_data>
					<field_data>
						<field>state</field>
						<data>='0'</data>
					</field_data>
				</fields>
			</table_operation>
			<table_query>
				<name>query</name>
				<dataSource>poc</dataSource>
				<customFields>count(1) p_count</customFields>
				<table>space_problem</table>
				<fields1>
					<bogda_item>
						<bogda_item>spaceId</bogda_item>
						<bogda_null/>
					</bogda_item>
				</fields1>
				<fieldsWhere>
					<spaceId>=spaceId</spaceId>
					<state>='1'</state>
				</fieldsWhere>
			</table_query>
			<table_operation>
				<name>job</name>
				<description>修改空间状态</description>
				<condition>query.p_count==0</condition>
				<dataSource>poc</dataSource>
				<mode>2</mode>
				<table>job</table>
				<fields>
					<field_data>
						<field>space_id</field>
						<data>=spaceId</data>
						<restrict>0</restrict>
					</field_data>
					<field_data>
						<field>status</field>
						<data>='01'</data>
					</field_data>
				</fields>
			</table_operation>
		</elements>
		<output>
			<variable>
				<name>rtn</name>
				<assignment>{code:1}</assignment>
			</variable>
		</output>
	</procedure>
	<comments>
		<next_id>1</next_id>
		<list>
			<comment>
				<id>0</id>
				<items>
					<comment_item>
						<content>关闭空间核查问题</content>
						<update_time>2021-6-10 18:29</update_time>
					</comment_item>
				</items>
			</comment>
		</list>
	</comments>
	<comment_id>0</comment_id>
</templet>