Office automation method based on visual arrangement and low-code development, storage medium and electronic equipment

Abstract

The invention discloses an office automation method based on visual arrangement and low-code development, which comprises the following steps: on the basis of an Activiti7 process engine, establishing a micro-service architecture and then generating a basic code and a database table, separating a process engine code from a business code, and embedding a BPMN process designer into a system framework; a business scene entity is split and modeled, a dynamic form database table structure is designed according to the business scene entity, form parameters are dynamically read based on vue, and all pages are assembled. According to the method, a micro-service architecture is established to generate a basic framework code and a database table, and a process engine code is separated from a service code, so that the expandability and efficiency of the system are improved; a BPMN process designer is embedded into a system framework, a native framework is optimized, compatibility transformation is carried out, rich parameter configurations including variables, UEL expressions and the like are supported after transformation, the applicability of the system is improved, a front-end page is rendered after splicing, and code-free development of a dynamic form can be achieved.

Description

Technical Field

[0001] The present invention relates to the field of enterprise informatization technology, and specifically to an office automation method, storage medium, and electronic device based on visual orchestration and low-code development. Background Art

[0002] Office automation, referred to as OA (Office Automation), is one of the important fields of computer application and one of the important means to realize electronic office. In recent years, office automation technology has developed rapidly, greatly improving the work efficiency and quality of users in task processing, document circulation, etc., and reducing unnecessary repetitive work. In response to the office automation needs in enterprise information construction, such as business process changes require modification of system code, increase system operation and maintenance costs, and reduce development efficiency, workflow technology has emerged to address such problems and has become the choice of more and more technical personnel. Workflow was originally focused on realizing process automation, that is, through the informatization and modeling of business processes, it is converted into formal descriptions such as activity nodes and execution roles, and then process rules are formulated according to different business processes, so as to realize the automatic reversal of tasks between activity nodes and execution roles.

[0003] After long-term exploration and development, researchers in different fields have defined and developed workflows based on different scenario requirements. In order to break through the barriers between different workflow software products, the members of the International Workflow Management Alliance have worked together to develop a series of standards in terms of architecture, application programming interface, and related terms of workflow management systems. This has enabled workflow technology to gradually form a relatively unified set of standards from the initial lack of unified standards. Workflows are mainly composed of four basic elements: entities, participants, process definitions, and workflow engines. Their applications are generally implemented in three stages: model establishment, model instance, and workflow execution. According to actual business rules, business processes are graphically defined through modeling tools, and business rules and processes are converted into standardized models that can be recognized and processed by computers. The workflow model is interpreted, and relevant attribute resources, control data, and related interfaces are provided for each activity node and action execution. The workflow model is instantiated through the workflow engine. Based on the newly created work tasks of the workflow, during the process operation, participants of different roles monitor and manage through interface parameters, execution status, and operations to complete the execution of the business process. At present, people tend to choose lightweight process engines, such as JBPM, Flowable, Camunda, Activiti, etc. They have their own advantages in terms of functions and performance, scalability, support for process visualization, version maintenance, open source data and stability. In terms of technical composition, there are differences in transaction management mechanism, distributed transaction mode, database support, design mode support, internal service communication, process format support, and integration interface. The realization of process visualization function in low-code platform often relies on process designer. The more mainstream process designers on the market are bpmn-js, flowable-modeler, mxGraph, etc. Technical personnel often select process designers from the aspects of integration, beautiful interface, and user experience. At present, the development of small office systems often chooses custom-designed process engines to drive task execution through node flow. Such systems often have poor maintainability and scalability, and the workload of developing new business scenarios is large. The system does not have the ability to respond quickly to changes in business processes. The development of medium and large office systems is usually based on process engine frameworks and process designers. The development of such systems often needs to focus on the performance of the process engine, the compatibility of the process designer, and the cost of later iterative maintenance.

[0004] How to lightweight the process engine, simplify the process designer, and organically integrate the two, reduce the coupling between business processes and business logic, improve the robustness and stability of the system, reduce the amount of code development, and provide users with dynamic form design through technical means, so as to achieve autonomous process orchestration, visual interface editing, and low-code development for multiple business scenarios is one of the key development directions of office automation software.

[0005] Therefore, there is an urgent need for an office automation method, storage medium, and electronic equipment based on visual orchestration and low-code development to solve the problems existing in traditional office automation technology, such as the strong coupling of business logic and process engine code, resulting in poor system stability. Summary of the invention

[0006] In view of the deficiencies in the prior art, the present invention provides an office automation method, storage medium, and electronic device based on visual orchestration and low-code development, so as to solve the problem of strong coupling between business logic and process engine code in traditional office automation technology, resulting in poor system stability.

[0007] To achieve the above object, the present invention adopts the following technical solutions:

[0008] An office automation method based on visual orchestration and low-code development, characterized in that it includes the following steps: based on the Activiti7 process engine, building a microservice architecture to generate basic code and database tables, separating the process engine code from the business code, and embedding the BPMN process designer into the system framework; business scenario entity splitting modeling, and designing a dynamic form database table structure based on this, dynamically reading form parameters based on vue, and assembling all pages.

[0009] To optimize the above technical solutions, the specific measures taken also include:

[0010] Furthermore, the method of generating basic code and database tables after building a microservice architecture based on the Activiti7 process engine includes the following steps: building a microservice architecture based on the Activiti7 process engine, adding the Maven dependency of Activiti7 in the SpringCloud microservice architecture, introducing the related dependency activiti-spring-boot-starter in the pom file of the project, modifying the application.yml file, adding the database table information generated by Activiti7, and manually enabling the database history configuration to store the database tables generated by Activiti7 in the MySQL database.

[0011] Furthermore, the separation of the process engine code from the business code includes the following steps: creating hboa-workflow service and hboa-activiti service in the microservice architecture, which are used for writing business code and process engine code respectively, and the two services are deployed separately without nesting each other.

[0012] Furthermore, embedding the BPMN process designer into the system framework includes the following steps: downloading the process designer plug-in in the development software, and creating a folder under the project for storing the BPMN file.

[0013] Furthermore, the process designer plug-in uses actiBPM.

[0014] Furthermore, the business scenario entities are split and modeled, and a dynamic form database table structure is designed accordingly, including the following steps: split and model the business scenario entities, analyze the form content required for common scenarios, design a general data model and a dynamic form database, and form a dynamic form drag-and-drop generation function; analyze the form elements required for common scenarios, split the form elements into four dimensions: field type, field name, field value, and multimedia file type, and design and store them in the database in the form of key-value pairs.

[0015] Furthermore, the common scenarios include key business process management, administrative management, personnel management, financial management and customer service.

[0016] Furthermore, the method of dynamically reading form parameters based on vue and assembling all pages includes the following steps: dynamically rendering form parameters, dynamically rendering the form according to a predefined data structure, defining the form data structure, traversing the data structure using the v-for instruction, rendering the form controls according to the field type, and binding the form data using the v-model instruction to render the dynamic form page; after submitting the form, agreeing on the task submission parameters in the form as: control id--__! ! type--__! ! name--__! ! whether it is a parameter--__! ! default value, passing the dynamic form parameters to the front end through the API interface through string concatenation, the front end rendering the task processing form according to the BPMN dynamic parameters, and setting the form key and task key of Activiti7 to the same value, obtaining the task key by obtaining the form key, and thus assembling all pages.

[0017] Furthermore, a computer-readable storage medium stores a computer program, characterized in that: the computer program enables a computer to execute an office automation method based on visual orchestration and low-code development as described above.

[0018] Furthermore, an electronic device is characterized in that it includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, an office automation method based on visual orchestration and low-code development as described above is implemented.

[0019] The beneficial effects of the present invention are:

[0020] Based on the Activiti7 process engine, the present invention builds a microservice architecture to generate basic framework code and database tables, separates the process engine code from the business code, and improves the scalability and efficiency of the system; at the same time, the BPMN process designer is embedded in the system framework, the native framework is optimized, and compatibility is transformed so that after the transformation, it supports rich parameter configuration including variables, UEL expressions, etc., adapts to complex office processes, and greatly improves the applicability of the system.

[0021] The present invention splits and models business scenario entities, designs a dynamic form database table structure based on this, dynamically reads form parameters based on Vue, and renders the front-end page after assembly, thus realizing code-free development of dynamic forms. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 A schematic diagram of a business process visualization orchestration process of an office automation method based on visualization orchestration and low-code development proposed by the present invention;

[0023] Figure 2 A schematic diagram of a business form dynamic generation process of an office automation method based on visual orchestration and low-code development proposed by the present invention;

[0024] Figure 3 This is a schematic diagram of the overall functional modules of an office automation method application based on visual orchestration and low-code development proposed by the present invention;

[0025] Figure 4 This is a schematic diagram of the overall business implementation process of an office automation method based on visual orchestration and low-code development proposed in the present invention. DETAILED DESCRIPTION

[0026] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0027] As attached Figure 1 and attached Figure 2 As shown, an office automation method based on visual orchestration and low-code development in an embodiment of the present invention includes the following steps:

[0028] Visual orchestration of business processes: Based on the Activiti7 process engine, the basic code and database tables are generated after the microservice architecture is built, the process engine code is separated from the business code, and the BPMN process designer is embedded in the system framework;

[0029] Dynamic generation of business forms: Business scenario entities are split and modeled, and the dynamic form database table structure is designed accordingly. Form parameters are dynamically read based on Vue and assembled to form the entire page.

[0030] Among them, the above-mentioned generation of basic code and database tables after building a microservice architecture based on the Activiti7 process engine includes the following steps: building a microservice architecture based on the Activiti7 process engine, adding the Maven dependency of Activiti7 to the SpringCloud microservice architecture, introducing the related dependency activiti-spring-boot-starter in the project's pom file, modifying the application.yml file, adding the database table information generated by Activiti7, and manually enabling the database history configuration to store the database tables generated by Activiti7 in the MySQL database.

[0031] Among them, the above-mentioned separation of process engine code from business code includes the following steps: creating hboa-workflow service and hboa-activiti service in the microservice architecture, which are used for writing business code and process engine code respectively. The two services are deployed separately and are not nested in each other, so as to reduce the impact of version release on system stability.

[0032] The above-mentioned embedding of the BPMN process designer into the system framework includes the following steps: downloading the process designer plug-in in the development software, creating a folder under the project to store the BPMN file, enabling users to draw business processes online, and reducing the dependence of new business scenarios on technical modeling. The above-mentioned process designer plug-in uses actiBPM.

[0033] Among them, the above-mentioned business scenario entities are split and modeled, and the dynamic form database table structure is designed accordingly, including the following steps: split and model the business scenario entities, analyze the form content required for common scenarios, design a general data model and a dynamic form database, and form a dynamic form drag-and-drop generation function; analyze the form elements required for common scenarios, split the form elements into four dimensions: field type, field name, field value, and multimedia file type, design and store them in the database in the form of key-value pairs, and realize low-code development of forms through dynamic configuration of four dimensions. Among them, the above-mentioned common scenarios include key business process management, administrative management, personnel management, financial management, and customer service.

[0034] Among them, the above-mentioned method of dynamically reading form parameters based on vue and assembling all pages includes the following steps: dynamically rendering form parameters, dynamically rendering the form according to a predefined data structure, defining the form data structure, using the v-for instruction to traverse the data structure, rendering the form control according to the field type, and using the v-model instruction to bind the form data to render the dynamic form page; after submitting the form, the task submission parameters in the form are agreed to be: control id--__! ! type--__! ! name--__! ! whether it is a parameter--__! ! default value, through string concatenation, passing the parameters of the dynamic form to the front end through the API interface, the front end renders the task processing form according to the BPMN dynamic parameters, and sets the form key and task key of Activiti7 to the same value, and obtains the task key by obtaining the form key, thereby solving the defect that Activiti7 cannot obtain the task key, and thus assembling all pages.

[0035] In another embodiment, the present invention proposes a computer-readable storage medium storing a computer program, wherein the computer program enables a computer to execute an office automation method based on visual orchestration and low-code development as described above.

[0036] In another embodiment, the present invention proposes an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, an office automation method based on visual orchestration and low-code development as described above is implemented.

[0037] The purpose of the present invention is to establish an office automation method based on visual arrangement and low-code development technology to solve the problems existing in office software development, such as strong coupling between business logic and process engine code, inability to arrange business processes independently, and high degree of customized development of business forms. The method requires that the process engine automatically drives the business process to be reversed according to the modeling rules through the visual modeling of the business process, and the business form is constructed by a low-code office automation method realized by low-code drag-and-drop. Therefore, the method includes two main modules: visual arrangement of business processes and dynamic generation of business forms.

[0038] The business process visualization orchestration module of the present invention is based on the Activiti7 process engine, builds a microservice architecture to generate basic framework code and database tables, separates the process engine code from the business code, and improves the scalability and efficiency of the system; at the same time, the BPMN process designer is embedded in the system framework, the native framework is optimized, and compatibility is transformed so that after the transformation, it supports rich parameter configuration including variables, UEL expressions, etc., adapts to complex office processes, and greatly improves the applicability of the system.

[0039] This method breaks away from the practice of strong coupling between process engine code and business rules in traditional small and medium-sized office systems. Traditional office automation systems often use changes in the status of task nodes in the database to drive the reversal of processes, and cannot provide visual orchestration of business rules. How to transform the process engine and organically combine it with the process designer has become a key issue. To address this problem, the present invention transforms the Activiti7.0 process engine, integrates it with the SpringCloud microservice architecture, decouples the process engine code from the business logic code, and integrates the BPMN2.0 visual modeling language to achieve visual modeling of business rules. This method has obvious beneficial effects, which are mainly manifested as follows:

[0040] (1) High development and iteration efficiency: By decoupling business logic from process engine code, the need for customized development of multiple business scenarios is reduced. The addition of new business scenarios and the modification of business rules no longer rely heavily on code adjustments by technical personnel. With the help of visual orchestration capabilities, business personnel can independently add or modify configurations, greatly improving system development and iteration efficiency.

[0041] (2) High system robustness and maintainability: Through microservice architecture transformation, the system's business logic and process engine no longer affect each other. The addition of new business scenarios does not affect the normal operation of existing business scenarios, and the system robustness is improved. In addition, the transformation and unification of the process engine standardizes the entire set of system codes, reduces the differences in program development, and improves the maintainability of the system.

[0042] (3) Good business experience: Traditional office systems either do not provide online orchestration functions, or the orchestration functions are relatively complex and the operability of business personnel is poor. This method provides business personnel with a simple operation page, and the BPMN file can be drawn online according to business rules and deployed online with one click to generate a new process definition.

[0043] The business form dynamic generation module of the present invention splits and models the business scenario entities, designs the dynamic form database table structure accordingly, and dynamically reads the form parameters based on vue, assembles and renders the front-end page, thereby realizing code-free development of dynamic forms.

[0044] This method splits and models the business scenario entities, and designs the dynamic form database table structure based on this. It dynamically reads form parameters based on Vue, and performs dynamic form rendering through rule design such as string concatenation. Compared with conventional page development technology, this method combines page configuration functions with database capabilities. Form modification and configuration no longer rely on code modification, and iterative maintenance efficiency is high. In addition, task node processing information is also autonomously configured in the process definition stage and supports online modification, and no longer consumes database resources. This method can effectively reduce the degree of customization of page development, improve development efficiency, reduce communication costs, and further realize low-code development and programmable design capabilities.

[0045] As attached Figure 3 As shown in FIG. 1 , the overall functional module of the present invention application includes: unified scheduling service, unified interface service, SS0 single sign-on, permission configuration and scheduled tasks. The overall business implementation flow chart of the present invention can be shown in FIG. Figure 4 shown.

[0046] The present invention realizes low-code development of office automation scenarios by transforming the workflow engine and process designer, and constructing the front-end form page by designing dynamic forms. The overall framework transformation solves the problems of high system coupling and low development and maintenance efficiency through the construction of microservice architecture. The present invention integrates Activiti7.0, BPMN2.0 and SpringCloud microservice architecture, and uses dynamic forms + vue technology for front-end integration and transformation, so as to realize the overall visual modeling of business processes, decouple business rules from logic codes, support dynamic generation of business forms, and dynamically obtain process node processing data, etc., and realizes the low-code development of office systems with autonomous arrangement and automatic reversal, which better solves the common pain points of office systems with high degree of customized development and high dependence on technical personnel, greatly improves the system development iteration efficiency and robustness, reduces the maintenance cost of office systems, and realizes office automation in a real sense.

[0047] Among them, the above-mentioned OA (Office Automation) is a comprehensive technology that has emerged through the development of management information systems based on the gradual automation of equipment and communications. It combines computer networks with modern offices. The above-mentioned BPMN (Business Process Modeling Notation): BPMN defines a business process diagram, which is used to create a graphical modeling of business process operations. Its main goal is to provide a set of markup languages ​​that are understood by all business users, and build a standardized bridge between business process design and process implementation. The above-mentioned UEL (Unified Expression Language): a part of the javaEE6 specification, generally uses ${} syntax expressions, and can dynamically read data in process variables or form variables through expressions, and perform arithmetic or logical operations, etc.

[0048] In the embodiments disclosed in the present application, the computer storage medium can be a tangible medium that can contain or store a program for use by or in conjunction with an instruction execution system, device or equipment. The computer storage medium can include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the above. More specific examples of computer storage media can include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the above.

[0049] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed in this application can be implemented in electronic hardware or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0050] The above are only preferred embodiments of the present invention, and the protection scope of the present invention is not limited to the above embodiments. All technical solutions under the concept of the present invention belong to the protection scope of the present invention. It should be pointed out that for ordinary technicians in this technical field, some improvements and modifications without departing from the principle of the present invention should be regarded as the protection scope of the present invention.

Claims

1. An office automation method based on visual orchestration and low-code development, characterized in that: The steps include: Based on the Activiti7 process engine, after building the microservice architecture, basic code and database tables are generated, the process engine code is separated from the business code, and the BPMN process designer is embedded in the system framework; The business scenario entity split model is designed, and the dynamic form database table structure is designed based on it. The form parameters are dynamically read based on Vue and assembled to form all the pages.

2. According to claim 1, an office automation method based on visual arrangement and low-code development is characterized in that: The method of generating basic code and database tables after building a microservice architecture based on the Activiti7 process engine includes the following steps: building a microservice architecture based on the Activiti7 process engine, adding the Maven dependency of Activiti7 in the SpringCloud microservice architecture, introducing the related dependency activiti-spring-boot-starter in the pom file of the project, modifying the application.yml file, adding the database table information generated by Activiti7, and manually enabling the database history configuration to store the database tables generated by Activiti7 in the MySQL database.

3. According to claim 1, an office automation method based on visual arrangement and low-code development is characterized in that: The separation of the process engine code from the business code includes the following steps: In the microservice architecture, hboa-workflow service and hboa-activiti service are created to write business code and process engine code respectively. The two services are deployed separately and are not nested.

4. According to claim 1, an office automation method based on visual arrangement and low-code development is characterized in that: The embedding of the BPMN process designer into the system framework includes the following steps: Download the process designer plug-in in the development software and create a folder under the project to store BPMN files.

5. According to claim 4, an office automation method based on visual arrangement and low-code development is characterized in that: The process designer plugin uses actiBPM.

6. The office automation method based on visual arrangement and low-code development according to claim 1 is characterized in that: The business scenario entity splitting model is designed based on which the dynamic form database table structure is designed, including the following steps: Split and model business scenario entities, analyze the form content required for common scenarios, design a general data model and a dynamic form database, and form a dynamic form drag-and-drop generation function; analyze the form elements required for common scenarios, split the form elements into four dimensions: field type, field name, field value, and multimedia file type, and design and store them in the database in the form of key-value pairs.

7. The office automation method based on visual arrangement and low-code development according to claim 6 is characterized in that: The common scenarios include key business process management, administrative management, personnel management, financial management and customer service.

8. The office automation method based on visual arrangement and low-code development according to claim 1 is characterized in that: The method of dynamically reading form parameters based on Vue and assembling all pages includes the following steps: Dynamically render form parameters, dynamically render the form according to the predefined data structure, define the form data structure, use the v-for instruction to traverse the data structure, render the form controls according to the field type, and use the v-model instruction to bind the form data to render the dynamic form page; after submitting the form, agree on the task submission parameters in the form as: control id--__! ! type--__! ! name--__! ! whether it is a parameter--__! ! default value, pass the dynamic form parameters to the front end through the API interface through string concatenation, the front end renders the task processing form according to the BPMN dynamic parameters, and sets the form key and task key of Activiti7 to the same value, obtains the task key by obtaining the form key, and assembles the entire page.

9. A computer-readable storage medium storing a computer program, characterized in that: The computer program enables the computer to execute an office automation method based on visual orchestration and low-code development as described in any one of claims 1 to 8.

10. An electronic device, characterized in that: include: A memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, an office automation method based on visual orchestration and low-code development as described in any one of claims 1 to 8 is implemented.

Images