springboot集成uflo工作流引擎
1、依赖:springboot,uflo,mybatis-plus,nacos,springCloud
<dependencies>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${lombok.version}</version>
<scope>provided</scope>
</dependency>
<!--spring boot -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-starter-openfeign</artifactId>
</dependency>
<!--UFLO-->
<dependency>
<groupId>com.bstek.uflo</groupId>
<artifactId>uflo-console</artifactId>
<version>2.1.4</version>
</dependency>
<!--阿里巴巴 fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>${fastjson}</version>
</dependency>
<!--连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid}</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
<version>${mysql-connector-java}</version>
</dependency>
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus-boot-starter}</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>${mybatis-plus-generator}</version>
</dependency>
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>${velocity-engine-core}</version>
</dependency>
<dependency>
<groupId>com.loyo</groupId>
<artifactId>loyo-commons</artifactId>
<version>${loyo-commons}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
</dependency>
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>4.6.17</version>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-openfeign-core</artifactId>
</dependency>
</dependencies>
2、数据库连接信息配置：
spring: datasource: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/sys_uflo?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true username: root password: root
3、启动类配置
@ImportResource(locations = {"classpath:uflo-console-context.xml"})
4、添加UfloConfig配置
import org.hibernate.SessionFactory; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.orm.hibernate5.HibernateTransactionManager; import org.springframework.orm.hibernate5.LocalSessionFactoryBean; import javax.sql.DataSource; import java.beans.PropertyVetoException; import java.io.IOException; import java.util.Properties; @Configuration public class UfloConfig { @Bean("localSessionFactoryBean") public LocalSessionFactoryBean localSessionFactoryBean(DataSource dataSource) throws PropertyVetoException, IOException { LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setPackagesToScan("com.bstek.uflo.model*"); Properties prop = new Properties(); prop.put("hibernate.dialect","org.hibernate.dialect.MySQL5Dialect"); prop.put("hibernate.show_sql",false); prop.put("hibernate.hbm2ddl.auto","update"); prop.put("hibernate.jdbc.batch_size",100); sessionFactoryBean.setHibernateProperties(prop); return sessionFactoryBean; } @Bean("ufloTransactionManager") public HibernateTransactionManager ufloTransactionManager(SessionFactory sessionFactory){ HibernateTransactionManager hi = new HibernateTransactionManager(); hi.setSessionFactory(sessionFactory); return hi; } }
5、实现Uflo的EnvironmentProvider类
import com.bstek.uflo.env.EnvironmentProvider; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.orm.jpa.JpaTransactionManager; import org.springframework.stereotype.Component; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.annotation.EnableTransactionManagement; import javax.persistence.EntityManagerFactory; @Component @EnableTransactionManagement public class EnvironmentProviderImpl implements EnvironmentProvider { @Autowired private SessionFactory sessionFactory; @Autowired private EntityManagerFactory entityManagerFactory; public SessionFactory getSessionFactory() { return sessionFactory; } public PlatformTransactionManager getPlatformTransactionManager() { return new JpaTransactionManager(entityManagerFactory); } public String getCategoryId() { return null; } public String getLoginUser() { return "zhengyixin"; } }
6、配置uflo servletConfig
1 import com.bstek.uflo.console.UfloServlet; 2 import org.springframework.boot.web.servlet.ServletRegistrationBean; 3 import org.springframework.context.annotation.Bean; 4 import org.springframework.context.annotation.Configuration; 5 6 @Configuration 7 public class ServletConfig { 8 @Bean 9 public ServletRegistrationBean servletRegistration() { 10 return new ServletRegistrationBean(new UfloServlet(), "/uflo/*"); 11 } 12 13 14 }
7、导入数据表：
-- ---------------------------- -- Table structure for uflo_blob -- ---------------------------- DROP TABLE IF EXISTS `uflo_blob`; CREATE TABLE `uflo_blob` ( `ID_` bigint(20) NOT NULL, `BLOB_VALUE_` longblob NULL, `NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_blob -- ---------------------------- INSERT INTO `uflo_blob` VALUES (2, 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E3C75666C6F2D70726F63657373206E616D653D22E8AFB7E58187E6B581E7A88B22206B65793D226C65617665222073746172742D70726F636573732D75726C3D222F6C656176652F666F726D223E3C7374617274206E616D653D22E5BC80E5A78B2220783D2238352220793D22323239222077696474683D22343022206865696768743D2237302220206576656E742D68616E646C65722D6265616E3D2272656D6F746548616E646C6572222075726C3D222F6C656176652F65646974223E203C6465736372697074696F6E3E3C215B43444154415B687474703A2F2F31302E31372E3234312E33343A383038302F6C656176655D5D3E3C2F6465736372697074696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E588A4E696AD223E3C2F73657175656E63652D666C6F773E3C2F73746172743E3C6465636973696F6E206E616D653D22E588A4E696AD2220783D223236312220793D22323330222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B726F6C653D3D2731273F27E699AEE9809AE59198E5B7A5273A726F6C653D3D2732273F27E983A8E997A8E4B8BBE7AEA1273A27E585B6E4BB96277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E4B8BBE7AEA122206E616D653D22E699AEE9809AE59198E5B7A5223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E7BB8FE7908622206E616D653D22E983A8E997A8E4B8BBE7AEA1223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E6A0B822206E616D653D22E585B6E4BB96223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E983A8E997A8E4B8BBE7AEA12220783D223433352220793D22313534222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D22646570744C6561646572222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E7BB8FE79086223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D22E983A8E997A8E7BB8FE790862220783D223433342220793D22333238222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D22646570744D616E61676572222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E6A0B8223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D224852E5AEA1E6A0B82220783D223532342220793D22323239222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C61737369676E65652070726F76696465722D69643D226465707441737369676E656550726F766964657222206E616D653D22E4BABAE4BA8BE983A8222069643D2231323634383332313037383336393233393035222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E588A4E696ADE5A4A9E695B0223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C6465636973696F6E206E616D653D22E588A4E696ADE5A4A9E695B02220783D223636322220793D22323330222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B646179436F756E743E333F27E5A4A7E4BA8E33E5A4A9273A27E5B08FE4BA8EE7AD89E4BA8E33E5A4A9277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9FE6B581E7A88B3122206E616D653D22E5B08FE4BA8EE7AD89E4BA8E33E5A4A9223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E4BC9AE7ADBE22206E616D653D22E5A4A7E4BA8E33E5A4A9223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E983A8E997A8E4BC9AE7ADBE2220783D223832382220793D22323330222077696474683D22343022206865696768743D2237302220207461736B2D747970653D22436F756E7465727369676E222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D227573657244657074222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E8B4A2E58AA1E5AEA1E6A0B8223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C656E64206E616D653D22E7BB93E69D9FE6B581E7A88B312220783D223832352220793D22333238222077696474683D22343022206865696768743D2237302220207465726D696E6174653D2274727565223E3C2F656E643E3C7461736B206E616D653D22E8B4A2E58AA1E5AEA1E6A0B82220783D223933302220793D22323330222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D226465707441737369676E656550726F766964657222206E616D653D22E8B4A2E58AA1222069643D2231323634383332313334323938373837383431222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9FE6B581E7A88B31223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C2F75666C6F2D70726F636573733E, '请假流程.uflo.xml', 1); INSERT INTO `uflo_blob` VALUES (20, 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E3C75666C6F2D70726F63657373206E616D653D227074777322206B65793D2270747773223E3C7374617274206E616D653D22E5BC80E5A78B312220783D223133312220793D22323138222077696474683D22343022206865696768743D22373022203E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E4B8BBE7AEA1E5AEA1E689B9223E3C2F73657175656E63652D666C6F773E3C2F73746172743E3C7461736B206E616D653D22E4B8BBE7AEA1E5AEA1E689B92220783D223239352220793D22323233222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E99988E998B3222069643D2231323630333833313931373837373038343138222F3E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E7A791E995BF32222069643D2231323632393737333933383831303535323333222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB8FE79086E5AEA1E689B9223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D22E7BB8FE79086E5AEA1E689B92220783D223434362220793D22323237222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E8B584E8AEAFE983A8E7BB8FE79086222069643D2231323630333833323831373531333334393134222F3E3C636F6D706F6E656E742D617574686F7269747920636F6D706F6E656E743D2264697361677265652220617574686F726974793D2252656164416E645772697465222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E586B3E7AD96223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D224852E5AEA1E689B92220783D223731342220793D22323236222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E4BABAE4BA8B222069643D2231323630333833333233313139373535323635222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E698AFE590A6E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C6465636973696F6E206E616D653D22E586B3E7AD962220783D223538362220793D22323236222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B61677265653D3D313F27E5908CE6848F273A27E590A6E586B3277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E689B922206E616D653D22E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D223630352C3136312C3135332C3135303A2220747970653D226C696E652220746F3D22E5BC80E5A78B3122206E616D653D22E590A6E586B3223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C6465636973696F6E206E616D653D224852E698AFE590A6E5908CE6848F2220783D223731352220793D22333336222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B61677265653D3D313F27E5908CE6848F273A27E590A6E586B3277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D223835352C3335393A2220747970653D226C696E652220746F3D22E8B4A2E58AA1E5AEA1E689B922206E616D653D22E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D223331312C3335323A2220747970653D226C696E652220746F3D22E4B8BBE7AEA1E5AEA1E689B922206E616D653D22E590A6E586B3223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E8B4A2E58AA1E5AEA1E689B92220783D223833362220793D22323331222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E8B4A2E58AA1E4BABAE59198222069643D2231323635313230323030333433323234333231222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9F223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C656E64206E616D653D22E7BB93E69D9F2220783D223934322220793D22323238222077696474683D22343022206865696768743D2237302220207465726D696E6174653D2274727565223E3C2F656E643E3C2F75666C6F2D70726F636573733E, 'ptws.uflo.xml', 19); INSERT INTO `uflo_blob` VALUES (204, 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E3C75666C6F2D70726F63657373206E616D653D227074777322206B65793D2270747773223E3C7374617274206E616D653D22E5BC80E5A78B312220783D223133312220793D22323138222077696474683D22343022206865696768743D22373022203E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E4B8BBE7AEA1E5AEA1E689B9223E3C2F73657175656E63652D666C6F773E3C2F73746172743E3C7461736B206E616D653D22E4B8BBE7AEA1E5AEA1E689B92220783D223239352220793D22323233222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E99988E998B3222069643D2231323630333833313931373837373038343138222F3E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E7A791E995BF32222069643D2231323632393737333933383831303535323333222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB8FE79086E5AEA1E689B9223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D22E7BB8FE79086E5AEA1E689B92220783D223434362220793D22323237222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E8B584E8AEAFE983A8E7BB8FE79086222069643D2231323630333833323831373531333334393134222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E586B3E7AD96223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D224852E5AEA1E689B92220783D223731342220793D22323236222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E4BABAE4BA8B222069643D2231323630333833333233313139373535323635222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E698AFE590A6E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C6465636973696F6E206E616D653D22E586B3E7AD962220783D223538362220793D22323236222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B61677265653D3D313F27E5908CE6848F273A27E590A6E586B3277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E689B922206E616D653D22E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D223630352C3136312C3331372C3135343A2220747970653D226C696E652220746F3D22E4B8BBE7AEA1E5AEA1E689B922206E616D653D22E590A6E586B3223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C6465636973696F6E206E616D653D224852E698AFE590A6E5908CE6848F2220783D223731352220793D22333336222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B61677265653D3D313F27E5908CE6848F273A27E590A6E586B3277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D223835352C3335393A2220747970653D226C696E652220746F3D22E8B4A2E58AA1E5AEA1E689B922206E616D653D22E5908CE6848F223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D223331312C3335323A2220747970653D226C696E652220746F3D22E4B8BBE7AEA1E5AEA1E689B922206E616D653D22E590A6E586B3223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E8B4A2E58AA1E5AEA1E689B92220783D223833362220793D22323331222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D227573657241737369676E656550726F766964657222206E616D653D22E8B4A2E58AA1E4BABAE59198222069643D2231323635313230323030333433323234333231222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9F223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C656E64206E616D653D22E7BB93E69D9F2220783D223934322220793D22323238222077696474683D22343022206865696768743D2237302220207465726D696E6174653D2274727565223E3C2F656E643E3C2F75666C6F2D70726F636573733E, 'ptws.uflo.xml', 203); INSERT INTO `uflo_blob` VALUES (309, 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E3C75666C6F2D70726F63657373206E616D653D22E8AFB7E58187E6B581E7A88B22206B65793D226C65617665222073746172742D70726F636573732D75726C3D222F6C656176652F666F726D223E3C7374617274206E616D653D22E5BC80E5A78B2220783D2238352220793D22323239222077696474683D22343022206865696768743D2237302220206576656E742D68616E646C65722D6265616E3D2272656D6F746548616E646C6572222075726C3D222F6C656176652F65646974223E203C6465736372697074696F6E3E3C215B43444154415B687474703A2F2F31302E31372E3234312E33343A383038302F6C656176655D5D3E3C2F6465736372697074696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E588A4E696AD223E3C2F73657175656E63652D666C6F773E3C2F73746172743E3C6465636973696F6E206E616D653D22E588A4E696AD2220783D223236312220793D22323330222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B726F6C653D3D2731273F27E699AEE9809AE59198E5B7A5273A726F6C653D3D2732273F27E983A8E997A8E4B8BBE7AEA1273A27E585B6E4BB96277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E4B8BBE7AEA122206E616D653D22E699AEE9809AE59198E5B7A5223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E7BB8FE7908622206E616D653D22E983A8E997A8E4B8BBE7AEA1223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E6A0B822206E616D653D22E585B6E4BB96223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E983A8E997A8E4B8BBE7AEA12220783D223433352220793D22313534222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D22646570744C6561646572222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E7BB8FE79086223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D22E983A8E997A8E7BB8FE790862220783D223433342220793D22333238222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D22646570744D616E61676572222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D224852E5AEA1E6A0B8223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C7461736B206E616D653D224852E5AEA1E6A0B82220783D223532342220793D22323239222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2274727565223E3C61737369676E65652070726F76696465722D69643D226465707441737369676E656550726F766964657222206E616D653D22E4BABAE4BA8BE983A8222069643D2231323634383332313037383336393233393035222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E588A4E696ADE5A4A9E695B0223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C6465636973696F6E206E616D653D22E588A4E696ADE5A4A9E695B02220783D223636322220793D22323330222077696474683D22343022206865696768743D2237302220206465636973696F6E2D747970653D2245787072657373696F6E223E3C65787072657373696F6E3E3C215B43444154415B247B646179436F756E743E333F27E5A4A7E4BA8E33E5A4A9273A27E5B08FE4BA8EE7AD89E4BA8E33E5A4A9277D5D5D3E3C2F65787072657373696F6E3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9FE6B581E7A88B3122206E616D653D22E5B08FE4BA8EE7AD89E4BA8E33E5A4A9223E3C2F73657175656E63652D666C6F773E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E983A8E997A8E4BC9AE7ADBE22206E616D653D22E5A4A7E4BA8E33E5A4A9223E3C2F73657175656E63652D666C6F773E3C2F6465636973696F6E3E3C7461736B206E616D653D22E983A8E997A8E4BC9AE7ADBE2220783D223832382220793D22323330222077696474683D22343022206865696768743D2237302220207461736B2D747970653D22436F756E7465727369676E222061737369676E6D656E742D747970653D2248616E646C6572222061737369676E6D656E742D68616E646C65722D6265616E3D227573657244657074222061737369676E6D656E742D68616E646C65722D6265616E2D646573633D22756E646566696E65642220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E8B4A2E58AA1E5AEA1E6A0B8223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C656E64206E616D653D22E7BB93E69D9FE6B581E7A88B312220783D223832352220793D22333238222077696474683D22343022206865696768743D2237302220207465726D696E6174653D2274727565223E3C2F656E643E3C7461736B206E616D653D22E8B4A2E58AA1E5AEA1E6A0B82220783D223933302220793D22323330222077696474683D22343022206865696768743D2237302220207461736B2D747970653D224E6F726D616C222061737369676E6D656E742D747970653D2241737369676E65652220616C6C6F772D737065636966792D61737369676E65653D2266616C7365223E3C61737369676E65652070726F76696465722D69643D226465707441737369676E656550726F766964657222206E616D653D22E8B4A2E58AA1222069643D2231323634383332313334323938373837383431222F3E3C73657175656E63652D666C6F7720673D222220747970653D226C696E652220746F3D22E7BB93E69D9FE6B581E7A88B31223E3C2F73657175656E63652D666C6F773E3C2F7461736B3E3C2F75666C6F2D70726F636573733E, '请假流程.uflo.xml', 308); -- ---------------------------- -- Table structure for uflo_calendar -- ---------------------------- DROP TABLE IF EXISTS `uflo_calendar`; CREATE TABLE `uflo_calendar` ( `ID_` bigint(20) NOT NULL, `CATEGORY_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESC_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TYPE_` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_calendar_date -- ---------------------------- DROP TABLE IF EXISTS `uflo_calendar_date`; CREATE TABLE `uflo_calendar_date` ( `ID_` bigint(20) NOT NULL, `CALENDAR_DATE_` datetime(0) NULL DEFAULT NULL, `CALENDAR_ID_` bigint(20) NULL DEFAULT NULL, `DAY_OF_MONTH_` int(11) NULL DEFAULT NULL, `DAY_OF_WEEK_` int(11) NULL DEFAULT NULL, `MONTH_OF_YEAR_` int(11) NULL DEFAULT NULL, `NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RANGE_END_TIME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RANGE_START_TIME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_context_property -- ---------------------------- DROP TABLE IF EXISTS `uflo_context_property`; CREATE TABLE `uflo_context_property` ( `KEY_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `VALUE_` varchar(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`KEY_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_context_property -- ---------------------------- INSERT INTO `uflo_context_property` VALUES ('dbid', '300'); -- ---------------------------- -- Table structure for uflo_his_activity -- ---------------------------- DROP TABLE IF EXISTS `uflo_his_activity`; CREATE TABLE `uflo_his_activity` ( `ID_` bigint(20) NOT NULL, `DESCRIPTION_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NODE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `END_DATE_` datetime(0) NULL DEFAULT NULL, `HIS_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `LEAVE_FLOW_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `ROOT_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_his_activity -- ---------------------------- INSERT INTO `uflo_his_activity` VALUES (208, NULL, '开始1', 19, '2020-06-05 14:25:42', '2020-06-05 14:25:43', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (212, NULL, '主管审批', 19, '2020-06-05 14:25:43', '2020-06-05 14:26:14', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (216, NULL, '经理审批', 19, '2020-06-05 14:26:15', '2020-06-05 14:26:57', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (220, NULL, '决策', 19, '2020-06-05 14:26:57', '2020-06-05 14:26:57', 207, '否决', 206, 206); INSERT INTO `uflo_his_activity` VALUES (221, NULL, '开始1', 19, '2020-06-05 14:26:57', '2020-06-05 14:27:21', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (225, NULL, '主管审批', 19, '2020-06-05 14:27:21', '2020-06-05 14:27:47', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (229, NULL, '经理审批', 19, '2020-06-05 14:27:47', '2020-06-05 14:28:09', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (233, NULL, '决策', 19, '2020-06-05 14:28:09', '2020-06-05 14:28:09', 207, '同意', 206, 206); INSERT INTO `uflo_his_activity` VALUES (234, NULL, 'HR审批', 19, '2020-06-05 14:28:09', '2020-06-05 14:52:32', 207, NULL, 206, 206); INSERT INTO `uflo_his_activity` VALUES (238, NULL, 'HR是否同意', 19, '2020-06-05 14:52:32', '2020-06-05 14:52:32', 207, '同意', 206, 206); INSERT INTO `uflo_his_activity` VALUES (239, NULL, '财务审批', 19, '2020-06-05 14:52:32', NULL, 207, NULL, 206, 206); -- ---------------------------- -- Table structure for uflo_his_blob -- ---------------------------- DROP TABLE IF EXISTS `uflo_his_blob`; CREATE TABLE `uflo_his_blob` ( `ID_` bigint(20) NOT NULL, `BLOB_VALUE_` longblob NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_his_process_instance -- ---------------------------- DROP TABLE IF EXISTS `uflo_his_process_instance`; CREATE TABLE `uflo_his_process_instance` ( `ID_` bigint(20) NOT NULL, `BUSINESS_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `END_DATE_` datetime(0) NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `PROMOTER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SUBJECT_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TAG_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_his_process_instance -- ---------------------------- INSERT INTO `uflo_his_process_instance` VALUES (207, '520', '2020-06-05 14:25:42', NULL, 19, 206, '1', '测试各种流程回退', NULL); -- ---------------------------- -- Table structure for uflo_his_task -- ---------------------------- DROP TABLE IF EXISTS `uflo_his_task`; CREATE TABLE `uflo_his_task` ( `ID_` bigint(20) NOT NULL, `DESCRIPTION_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NODE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `ASSIGNEE_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `BUSINESS_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `DUEDATE_` datetime(0) NULL DEFAULT NULL, `END_DATE_` datetime(0) NULL DEFAULT NULL, `HIS_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `OPINION_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OWNER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `ROOT_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `STATE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SUBJECT_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TASK_ID_` bigint(20) NULL DEFAULT NULL, `TASK_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TYPE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `URL_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_his_task -- ---------------------------- INSERT INTO `uflo_his_task` VALUES (211, NULL, '开始1', 19, '1', '520', '2020-06-05 14:25:42', NULL, '2020-06-05 14:25:43', 207, '提交', '1', 206, 206, 'Completed', '测试各种流程回退', 209, '开始1', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (214, NULL, '主管审批', 19, '1260383191787708418', '520', '2020-06-05 14:25:43', NULL, '2020-06-05 14:26:14', 207, '同意', '1260383191787708418', 206, 206, 'Completed', '测试各种流程回退', 213, '主管审批', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (218, NULL, '经理审批', 19, '1260383281751334914', '520', '2020-06-05 14:26:15', NULL, '2020-06-05 14:26:57', 207, '否决', '1260383281751334914', 206, 206, 'Completed', '测试各种流程回退', 217, '经理审批', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (223, NULL, '开始1', 19, '1', '520', '2020-06-05 14:26:57', NULL, '2020-06-05 14:27:21', 207, '同意', '1', 206, 206, 'Completed', '测试各种流程回退', 222, '开始1', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (227, NULL, '主管审批', 19, '1260383191787708418', '520', '2020-06-05 14:27:21', NULL, '2020-06-05 14:27:47', 207, '同意', '1260383191787708418', 206, 206, 'Completed', '测试各种流程回退', 226, '主管审批', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (231, NULL, '经理审批', 19, '1260383281751334914', '520', '2020-06-05 14:27:47', NULL, '2020-06-05 14:28:09', 207, '同意', '1260383281751334914', 206, 206, 'Completed', '测试各种流程回退', 230, '经理审批', 'Normal', NULL); INSERT INTO `uflo_his_task` VALUES (236, NULL, 'HR审批', 19, '1260383323119755265', '520', '2020-06-05 14:28:09', NULL, '2020-06-05 14:52:32', 207, '同意', '1260383323119755265', 206, 206, 'Completed', '测试各种流程回退', 235, 'HR审批', 'Normal', NULL); -- ---------------------------- -- Table structure for uflo_his_variable -- ---------------------------- DROP TABLE IF EXISTS `uflo_his_variable`; CREATE TABLE `uflo_his_variable` ( `ID_` bigint(20) NOT NULL, `HIS_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `KEY_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TYPE_` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_job_heartbeat -- ---------------------------- DROP TABLE IF EXISTS `uflo_job_heartbeat`; CREATE TABLE `uflo_job_heartbeat` ( `ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DATE_` datetime(0) NULL DEFAULT NULL, `INSTANCE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_process -- ---------------------------- DROP TABLE IF EXISTS `uflo_process`; CREATE TABLE `uflo_process` ( `ID_` bigint(20) NOT NULL, `CATEGORY_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CATEGORY_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `DESCRIPTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `EFFECT_DATE_` datetime(0) NULL DEFAULT NULL, `KEY_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `START_PROCESS_URL_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VERSION_` int(11) NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_process -- ---------------------------- INSERT INTO `uflo_process` VALUES (1, NULL, NULL, '2020-06-05 10:33:45', NULL, NULL, 'leave', '请假流程', '/leave/form', 1); INSERT INTO `uflo_process` VALUES (19, NULL, NULL, '2020-06-05 13:27:18', NULL, NULL, 'ptws', 'ptws', NULL, 5); -- ---------------------------- -- Table structure for uflo_process_instance -- ---------------------------- DROP TABLE IF EXISTS `uflo_process_instance`; CREATE TABLE `uflo_process_instance` ( `ID_` bigint(20) NOT NULL, `BUSINESS_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `CURRENT_NODE_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CURRENT_TASK_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `HIS_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `PARALLEL_INSTANCE_COUNT_` int(11) NULL DEFAULT NULL, `PARENT_ID_` bigint(20) NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `PROMOTER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ROOT_ID_` bigint(20) NULL DEFAULT NULL, `STATE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SUBJECT_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TAG_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_process_instance -- ---------------------------- INSERT INTO `uflo_process_instance` VALUES (206, '520', '2020-06-05 14:25:42', '财务审批', '财务审批', 207, 0, 0, 19, '1', 206, 'Start', '测试各种流程回退', NULL); -- ---------------------------- -- Table structure for uflo_task -- ---------------------------- DROP TABLE IF EXISTS `uflo_task`; CREATE TABLE `uflo_task` ( `ID_` bigint(20) NOT NULL, `DESCRIPTION_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NODE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `ASSIGNEE_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `BUSINESS_ID_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COUNTERSIGN_COUNT_` int(11) NULL DEFAULT NULL, `CREATE_DATE_` datetime(0) NULL DEFAULT NULL, `DATE_UNIT_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DUE_ACTION_DATE_` datetime(0) NULL DEFAULT NULL, `DUEDATE_` datetime(0) NULL DEFAULT NULL, `END_DATE_` datetime(0) NULL DEFAULT NULL, `OPINION_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OWNER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREV_STATE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREV_TASK_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRIORITY_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `PROGRESS_` int(11) NULL DEFAULT NULL, `ROOT_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `STATE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SUBJECT_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TASK_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TYPE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `URL_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_task -- ---------------------------- INSERT INTO `uflo_task` VALUES (209, NULL, '开始1', 19, '1', '520', 0, '2020-06-05 14:25:42', NULL, NULL, NULL, '2020-06-05 14:25:43', '提交', '1', NULL, '开始1', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '开始1', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (213, NULL, '主管审批', 19, '1260383191787708418', '520', 0, '2020-06-05 14:25:43', NULL, NULL, NULL, '2020-06-05 14:26:14', '同意', '1260383191787708418', NULL, '开始1', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '主管审批', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (217, NULL, '经理审批', 19, '1260383281751334914', '520', 0, '2020-06-05 14:26:15', NULL, NULL, NULL, '2020-06-05 14:26:57', '否决', '1260383281751334914', NULL, '主管审批', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '经理审批', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (222, NULL, '开始1', 19, '1', '520', 0, '2020-06-05 14:26:57', NULL, NULL, NULL, '2020-06-05 14:27:21', '同意', '1', NULL, '经理审批', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '开始1', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (226, NULL, '主管审批', 19, '1260383191787708418', '520', 0, '2020-06-05 14:27:21', NULL, NULL, NULL, '2020-06-05 14:27:47', '同意', '1260383191787708418', NULL, '开始1', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '主管审批', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (230, NULL, '经理审批', 19, '1260383281751334914', '520', 0, '2020-06-05 14:27:47', NULL, NULL, NULL, '2020-06-05 14:28:09', '同意', '1260383281751334914', NULL, '主管审批', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', '经理审批', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (235, NULL, 'HR审批', 19, '1260383323119755265', '520', 0, '2020-06-05 14:28:09', NULL, NULL, NULL, '2020-06-05 14:52:32', '同意', '1260383323119755265', NULL, '经理审批', NULL, 206, 100, 206, 'Completed', '测试各种流程回退', 'HR审批', 'Normal', NULL); INSERT INTO `uflo_task` VALUES (240, NULL, '财务审批', 19, '1265120200343224321', '520', 0, '2020-06-05 14:52:32', NULL, NULL, NULL, NULL, NULL, '1265120200343224321', NULL, 'HR审批', NULL, 206, NULL, 206, 'Created', '测试各种流程回退', '财务审批', 'Normal', NULL); -- ---------------------------- -- Table structure for uflo_task_appointor -- ---------------------------- DROP TABLE IF EXISTS `uflo_task_appointor`; CREATE TABLE `uflo_task_appointor` ( `ID_` bigint(20) NOT NULL, `APPOINTOR_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `APPOINTOR_NODE_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OWNER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `TASK_NODE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_task_appointor -- ---------------------------- INSERT INTO `uflo_task_appointor` VALUES (210, '1', '开始1', '1260383191787708418', 206, '主管审批'); -- ---------------------------- -- Table structure for uflo_task_participator -- ---------------------------- DROP TABLE IF EXISTS `uflo_task_participator`; CREATE TABLE `uflo_task_participator` ( `ID_` bigint(20) NOT NULL, `TASK_ID_` bigint(20) NOT NULL, `USER_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `FKpqe63u3gnbwpjhvf8996md6ip`(`TASK_ID_`) USING BTREE, CONSTRAINT `FKpqe63u3gnbwpjhvf8996md6ip` FOREIGN KEY (`TASK_ID_`) REFERENCES `uflo_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_task_reminder -- ---------------------------- DROP TABLE IF EXISTS `uflo_task_reminder`; CREATE TABLE `uflo_task_reminder` ( `ID_` bigint(20) NOT NULL, `CRON_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_ID_` bigint(20) NULL DEFAULT NULL, `REMINDER_HANDLER_BEAN_` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `START_DATE_` datetime(0) NULL DEFAULT NULL, `TASK_ID_` bigint(20) NULL DEFAULT NULL, `TASK_NODE_NAME_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `REMINDER_TYPE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for uflo_variable -- ---------------------------- DROP TABLE IF EXISTS `uflo_variable`; CREATE TABLE `uflo_variable` ( `TYPE_` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ID_` bigint(20) NOT NULL, `KEY_` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `ROOT_PROCESS_INSTANCE_ID_` bigint(20) NULL DEFAULT NULL, `BLOB_ID_` bigint(20) NULL DEFAULT NULL, `BOOLEAN_VALUE_` bit(1) NULL DEFAULT NULL, `BYTE_VALUE_` tinyint(4) NULL DEFAULT NULL, `CHARACTER_VALUE_` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DATE_VALUE_` datetime(0) NULL DEFAULT NULL, `DOUBLE_VALUE_` double NULL DEFAULT NULL, `FLOAT_VALUE_` float NULL DEFAULT NULL, `INTEGER_VALUE_` int(11) NULL DEFAULT NULL, `LONG_VALUE_` bigint(20) NULL DEFAULT NULL, `SHORT_VALUE_` smallint(6) NULL DEFAULT NULL, `STRING_VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of uflo_variable -- ---------------------------- INSERT INTO `uflo_variable` VALUES ('Integer', 237, 'agree', 206, 206, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL); SET FOREIGN_KEY_CHECKS = 1;
8、最后启动项目，在浏览器输入地址：http://ip:port/context-path/uflo/designer,打开流程设计器
