车辆申请审批.xml

自动化网络办公系统全部源码officeanywheresystem

<?xml version="1.0" encoding="gb2312"?> 
<workflow name="车辆申请审批" author="imafar" original_date="2001-5-1">
   <role name="审批人"/>
   <data name="申请编号" type="int">
   </data>
   <data name="申请人" type="datebase">
		<table>userinfo</table>
		<field1>userid</field1>
		<field2>name</field2>
		<expr>type=1 and disable=0</expr>
   </data>
   <data name="车名" type="database">
		<table>ZW_CLGL_car</table>
		<field1>carname</field1>
		<field2>carname</field2>
		<expr>carinfo='闲置'</expr>
   </data>
   <data name="开始时间" type="date">
   </data>
   <data name="预计结束时间" type="date">
   </data>
   <data name="用途" type="text">
   </data>
   <data name="目的" type="text">
   </data>
   <sequence>
 	  <alert type="storage" to="ZWGL_BGYP_LY" storage="insert into ZWGL_BGYP_LY (cp_id,sqr,sqsl,sqsj) values (${要申领的办公用品},${$creator},${数量})">
	  </alert>
      <task label="是否批准车辆申请？" role="审批人">
         <data name="审批" type="list">
			<option>是</option>
			<option>否</option>
         </data>
	   <data name="选择司机" type="database">
		<table>ZW_CLGL_DRIVER</table>
		<field1>driver_name</field1>
		<field2>driver_name</field2>
		<expr>driverinfo='闲置'</expr>
	   </data>
      </task>
	<if expr="${审批}='是'">
		<alert type="creator" to="申请人">
		车辆已经批准！
		</alert>
 	  <alert type="storage" to="ZW_CLGL_CLSQ" storage="update ZW_CLGL_CLSQ set passed='是' where id=${申请编号}">
	  </alert>
 	  <alert type="storage" to="ZW_CLGL_CLSQ" storage="update ZW_CLGL_CAR set carinfo='在用' where carname='${车名}'">
	  </alert>
 	  <alert type="storage" to="ZW_CLGL_CLSQ" storage="update ZW_CLGL_Driver set driverinfo='外出' where driver_name='${选择司机}'">
	  </alert>
	<elseif expr="${审批}='否'"/>
		<alert type="creator" to="申请人">
		车辆没有批准！
		</alert>
   	  <alert type="storage" to="ZW_CLGL_CLSQ" storage="delete ZW_CLGL_CLSQ where id=${申请编号}">
	  </alert>
    </if>
   </sequence>

</workflow>