CN117707500A - Method, system, equipment and storage medium for generating and running business application - Google Patents

Method, system, equipment and storage medium for generating and running business application Download PDF

Info

Publication number
CN117707500A
CN117707500A CN202311744002.7A CN202311744002A CN117707500A CN 117707500 A CN117707500 A CN 117707500A CN 202311744002 A CN202311744002 A CN 202311744002A CN 117707500 A CN117707500 A CN 117707500A
Authority
CN
China
Prior art keywords
service
cell
target
application
current
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202311744002.7A
Other languages
Chinese (zh)
Inventor
韩竹
李卓
高超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Yijing Network Technology Co ltd
Original Assignee
Shanghai Yijing Network Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Yijing Network Technology Co ltd filed Critical Shanghai Yijing Network Technology Co ltd
Priority to CN202311744002.7A priority Critical patent/CN117707500A/en
Publication of CN117707500A publication Critical patent/CN117707500A/en
Pending legal-status Critical Current

Links

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application relates to a method, a system, a device and a storage medium for generating and operating a business application, which belong to the technical field of computers, and the method comprises the following steps: responding to an application building instruction of a target service application, and displaying an application building page; under the condition that an application building operation acting on an application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records the running information of a target service application; generating an operation inlet of a target business application corresponding to a target excel document; at the moment, the creation of the service application can be realized by creating a target excel document, the service application can be created without the need of users to fully know the code knowledge, and the problems of high construction difficulty and low efficiency of the service application by using a relational database and a server side code construction in the traditional service application generation method can be solved; the generation difficulty of service application is reduced, and the generation efficiency is improved.

Description

Method, system, equipment and storage medium for generating and running business application
Technical Field
The application relates to a method, a system, a device and a storage medium for generating and operating business applications, and belongs to the technical field of computers.
Background
With the development of information technology, the demand of enterprise management platforms is increasing. A variety of business applications for online processing of business services can be run in a conventional enterprise management platform. However, the service application originally set by the enterprise management platform may not meet the use requirement of the user, and at this time, a new service application needs to be added in the enterprise management platform. Such as: and newly adding leave approval business application or reimbursement business application in the enterprise management platform.
The conventional business application creating method generally adopts a relational database and a server-side program language (such as Java, C#, and the like) to develop new business applications in an enterprise management platform.
However, this approach requires a specialized IT team to perform system development and maintenance, which can lead to a problem of long development cycle of business applications and difficult upgrade iterations.
Disclosure of Invention
The application provides a method, a system, a device and a storage medium for generating service applications, which can solve the problems of great difficulty and low efficiency in developing service applications by using a relational database and a server-side program language; the excel document has the advantages of simple interface, convenient use, powerful formula function and the like, and even if a common user who does not know programming language can edit the excel document, so that business application can be created, the user requirement of creating the business application in the platform can be timely met, and the creation efficiency of the business application is improved. The application provides the following technical scheme:
In a first aspect, a method for generating a service application is provided, where the method includes:
responding to an application building instruction of a target service application, and displaying an application building page;
under the condition that an application building operation acting on the application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records the running information of the target service application;
and generating an operation inlet of the target business application corresponding to the target excel document.
Optionally, the operation information is recorded in the target excel document according to a preset rule, and the preset rule is matched with an analysis rule of analyzing the target excel document by an operation platform of the service application.
Optionally, the operation information includes first table contents recorded according to the preset rule, where the first table contents are used to generate a service page of the target service application; the first table content includes:
at least one item of static information, wherein the static information is used for generating a static display field in the service page; the method comprises the steps of,
and the input area information is used for generating an input area of the business data corresponding to the static information in the business page.
Optionally, the operation information further includes a second table content recorded according to the preset rule, where the second table content is used to indicate operation logic of each task stage.
Optionally, the second table content includes at least one of the following cell types:
the platform input type is used for enabling an operation platform to which the target business application belongs to acquire target data and filling the target data into a first cell corresponding to the platform input type;
the platform automatic type is used for enabling the operation platform to execute tasks corresponding to the platform automatic type according to cell values of the second cells corresponding to the platform automatic type;
and the platform configuration type is used for the operation platform to configure the editing authority of the service page according to the cell value of the third cell corresponding to the platform configuration type.
Optionally, the first cell corresponding to the platform input type includes: at least one of a task state cell, a create node cell, a process node cell, and a view node cell;
the platform automatic corresponding second cell includes: at least one of a sending cell, a transcription cell, a header cell, and an error prompt cell.
Optionally, the cells of at least one cell type have a logical operation formula built based on an original computing function of the excel engine.
Optionally, the application building page includes an excel template uploading control; in response to this, the control unit,
the obtaining the target excel document indicated by the application building operation includes:
responding to a first application building operation acting on the excel template uploading control, and displaying a local document selection window;
and generating the target excel document based on the excel document determined in the local document selection window.
Optionally, the generating the target excel document based on the excel document determined by the local document selection window includes:
displaying the excel document determined based on the local document selection window;
and receiving modification operation on the excel document to obtain the target excel document.
Optionally, the application building page includes an excel document production control; in response to this, the control unit,
the obtaining the target excel document indicated by the application building operation includes:
responding to a second application building operation acting on the excel document production control, and displaying a blank excel document;
and generating the target excel document based on the input operation of the blank excel document.
In a second aspect, there is provided a method for running a service application, the method comprising:
displaying an operation inlet of a target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document;
responding to the received service creation operation acting on the operation inlet, and generating and displaying a first service page of the target service application based on a target excel document corresponding to the target service application;
and receiving service data of the current service through the first service page, and generating a service data table corresponding to the current service according to the service data.
Optionally, the operation information is recorded in the target excel document according to a preset rule; in response to this, the control unit,
the generating and displaying the first service page of the target service application based on the target excel document corresponding to the target service application includes:
analyzing the target excel document according to an analysis rule matched with the preset rule;
generating the first business page based on the parsed information;
and displaying the first service page.
Optionally, the target excel document includes a first table content, where the first table content includes at least one item of static information and input area information corresponding to the static information; in response to this, the control unit,
the generating the first service page based on the parsed information includes:
and generating a static display field corresponding to the static information obtained by analysis and an input area indicated by the input area information in the service page.
Optionally, the parsing the target excel document according to the parsing rule matched with the preset rule includes:
analyzing whether the second table content exists according to the analysis rule;
and if the second table contents exist, operating the operation logic of the current service in each task stage based on the second table contents obtained through analysis.
Optionally, the running logic for running the current service in each task stage based on the second table content obtained by parsing includes:
under the condition that the second table content is analyzed to have a first cell corresponding to the platform input type, acquiring target data corresponding to the platform input type and filling the target data into the first cell;
reading a cell value of a second cell when the second cell corresponding to the second table content existence platform automatic type is analyzed; executing the tasks corresponding to the platform automation type according to the cell values of the second cells;
Reading a cell value of a third cell corresponding to the platform configuration type in the case that the second table content is analyzed; and configuring the editing authority of the first business page according to the cell value of the third cell.
Optionally, the platform automatic type corresponding second cell includes: at least one of a sending cell, a copy cell, a title cell, and an error prompting cell; in response to this, the control unit,
and executing the tasks corresponding to the platform automation type according to the cell values of the second cells, wherein the tasks comprise:
under the condition that the cell value of the sending cell is read, sending a service processing message to a processing node indicated by the cell value of the sending cell;
under the condition that the cell value of the copy cell is read, sending a service check message to a check node indicated by the cell value of the copy cell;
displaying a task title of the current task on the first service page based on the cell value of the title cell under the condition that the cell value of the title cell is read;
and displaying error information indicated by the cell value of the error cell on the first service page under the condition that the cell value of the error cell is read.
Optionally, cells of at least one cell type in the second table content have a logic operation formula built based on an original calculation function of an excel engine; in response to this, the control unit,
the operation logic of the current service in each task stage is operated based on the second table content obtained by analysis, and the operation logic comprises the following steps:
and calling the excel engine to run the logic operation formula under the condition that the second table content has the logic operation formula so as to calculate the cell value corresponding to the at least one cell type.
Optionally, the platform automatic type corresponding second cell includes: transmitting cells and/or copying cells; the sending unit cell and the copying unit cell are both related to a task state unit cell and a processing node unit cell in a first unit cell corresponding to the platform input type; the task state cell correlates the user operation received by the service page;
the sending unit cell is provided with a first searching formula built based on a searching function in the excel engine and a sending judging formula built based on the judging function, the first searching formula is associated with the processing node unit cell and is used for searching a processing node corresponding to the next task stage corresponding to the current processing node in third table content; the third table content is used for recording node association relations among all nodes; the transmission judgment formula is associated with the task state cell;
The copying unit cell is provided with a second searching formula built based on a searching function in the excel engine and a copying judging formula built based on the judging function, wherein the second searching formula is associated with the processing node unit cell and is used for searching a copying node corresponding to the next task stage corresponding to the current processing node in the third table content; the transcription judgment formula is associated with the task state cell;
correspondingly, the executing the platform automatic corresponding task according to the cell value of the second cell comprises the following steps:
invoking the excel engine to operate the first search formula to obtain a processing node corresponding to the next task stage, and operating the sending judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated and completed, and filling the processing node corresponding to the next task stage into the sending cell;
transmitting the service processing message to the processing node corresponding to the next task stage under the condition that the cell value of the transmitting cell is the processing node corresponding to the next task stage;
calling the excel engine to operate the second search formula to obtain a copy node corresponding to the next task stage, and operating the copy judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the copy node corresponding to the next task stage into the copy cell;
And sending the service checking message to the copy node corresponding to the next task stage under the condition that the cell value of the copy cell is the copy node corresponding to the next task stage.
Optionally, after receiving the service data of the current service through the first service page and generating the service data table corresponding to the current service according to the service data, the method further includes:
receiving a notification message sent by a processing node corresponding to the subsequent task stage; the notification message is sent based on the second table content when the processing node corresponding to the subsequent task stage indicates that the corresponding task stage is completed in the parsed second table content in the service data table; the notification message is used for indicating the processing result of the current task stage;
and under the condition that a triggering operation acting on the notification message is received, analyzing the service data table corresponding to the current service to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
Optionally, the parsing the target excel document according to the parsing rule matched with the preset rule includes:
Analyzing the table areas corresponding to different cell types according to the analysis rule to obtain cell values of the table areas so as to enable an operation platform of the target service application to execute tasks corresponding to the cell types; wherein, the table areas corresponding to different cell types are different;
and/or the number of the groups of groups,
analyzing named cells corresponding to different cell types according to the analysis rule to obtain cell values of the named cells so as to enable an operation platform of the target service application to execute tasks corresponding to the cell types; the naming modes of the named cells corresponding to different cell types are different.
Optionally, after receiving the service data of the current service through the first service page and generating the service data table corresponding to the current service according to the service data, the method further includes:
and analyzing the service data table based on the service data and/or the interaction operation acting on the first service page so as to run the current service.
In a third aspect, a method for running a service application is provided, where the method includes:
receiving a service message sent by a target service application for a current service; wherein the current service is created upon receiving a service creation operation acting on a running portal of the target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document; the service message comprises a service processing message or a service checking message, wherein the service processing message is used for indicating a current node to process the current service, and the service checking message is used for indicating the current node to check the current service;
Responding to triggering operation acted on the service message, and generating and displaying a second service page of the current service based on a service data table corresponding to the current service; the service data table is generated according to the service data after receiving the service data of the current service through the first service page; the first business page is generated based on the target excel document.
Optionally, after the generating and displaying the second service page of the current service based on the service data table corresponding to the current service in response to the triggering operation acting on the service message, the method further includes:
updating the service data table based on the service data under the condition that the service data is received through the second service page;
and/or the number of the groups of groups,
and under the condition that the interactive operation acting on the second service page is received, analyzing a service data table corresponding to the current service so as to operate the current service.
Optionally, the parsing the service data table corresponding to the current service to operate the current service includes:
sending a notification message to a processing node corresponding to a task stage before the current task stage based on the second table content under the condition that the analyzed second table content in the service data table indicates that the current service is completed in the current task stage; the notification message is used for indicating the processing result of the current task stage.
In a fourth aspect, a service application running system is provided, where the system includes at least two application usage ends, where the at least two application usage ends include a service request end and at least one service processing end;
the service request end is configured to: displaying an operation inlet of a target service application; responding to the received service creation operation acting on the operation inlet, and generating and displaying a first service page of the target service application based on the first table content of the target excel document corresponding to the target service application; receiving service data of a current service through the first service page, generating a service data table corresponding to the current service according to the service data, and sending service information based on a processing node and/or a viewing node indicated by second table content of the target excel document;
the service processing end is configured to: receiving a service message sent by a target service application for a current service; and responding to the triggering operation acted on the service message, and generating and displaying a second service page of the current service based on the service data table corresponding to the current service.
Optionally, the service processing end is further configured to: updating the service data table based on the service data under the condition that the service data is received through the second service page; sending a notification message to a processing node corresponding to a task stage before a current task stage based on second table contents under the condition that the updated second table contents in the service data table indicate that the current service is completed in the current task stage; the notification message is used for indicating the processing result of the current task stage;
The service request end is further used for: receiving the notification message; and under the condition that a triggering operation acting on the notification message is received, analyzing the service data table corresponding to the current service to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
Optionally, the service processing end is further configured to: when the updated second table content in the service data table indicates that the current service is completed in the current task stage and a processing node corresponding to the next task stage exists, sending a service processing message to the processing node indicated by the second table content;
the service processing end used by the processing node corresponding to the next task stage is used for executing the service message sent by the receiving target service application for the current service; and generating and displaying a second service page' of the current service based on a service data table corresponding to the current service in response to a triggering operation acting on the service message, wherein the service message comprises the service processing message.
In a fifth aspect, a device for generating a service application, the device includes:
The page display module is used for responding to the application construction instruction of the target business application and displaying an application construction page;
the document acquisition module is used for acquiring a target excel document indicated by the application construction operation under the condition that the application construction operation acting on the application construction page is received, wherein the target excel document records the running information of the target service application;
and the application generation module is used for generating an operation inlet of the target business application corresponding to the target excel document.
In a sixth aspect, an apparatus for running a service application, the apparatus includes:
the entry display module is used for displaying the running entry of the target business application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document;
the page display module is used for responding to the received service creation operation acting on the operation inlet, generating and displaying a first service page of the target service application based on a target excel document corresponding to the target service application;
the data acquisition module is used for receiving service data of the current service through the first service page and generating a service data table corresponding to the current service according to the service data.
Optionally, the operation information is recorded in the target excel document according to a preset rule; accordingly, the page display module includes:
the document analysis unit is used for analyzing the target excel document according to analysis rules matched with the preset rules;
the page generation unit is used for generating the first service page based on the parsed information;
and the page display unit is used for displaying the first service page.
Optionally, the document parsing unit is further configured to:
analyzing whether the second table content exists according to the analysis rule;
and if the second table contents exist, operating the operation logic of the current service in each task stage based on the second table contents obtained through analysis.
Optionally, the running logic for running the current service in each task stage based on the second table content obtained by parsing includes:
under the condition that the second table content is analyzed to have a first cell corresponding to the platform input type, acquiring target data corresponding to the platform input type and filling the target data into the first cell;
reading a cell value of a second cell when the second cell corresponding to the second table content existence platform automatic type is analyzed; executing the tasks corresponding to the platform automation type according to the cell values of the second cells;
Reading a cell value of a third cell corresponding to the configuration type of the second table content storage platform under the condition that the third cell is analyzed; and configuring the editing authority of the first business page according to the cell value of the third cell.
Optionally, the platform automatic type corresponding second cell includes: at least one of a sending cell, a copy cell, a title cell, and an error prompting cell; in response to this, the control unit,
and executing the tasks corresponding to the platform automation type according to the cell values of the second cells, wherein the tasks comprise:
under the condition that the cell value of the sending cell is read, sending a service processing message to a processing node indicated by the cell value of the sending cell;
under the condition that the cell value of the copy cell is read, sending a service check message to a check node indicated by the cell value of the copy cell;
displaying a task title of the current task on the first service page based on the cell value of the title cell under the condition that the cell value of the title cell is read;
and displaying error information indicated by the cell value of the error cell on the first service page under the condition that the cell value of the error cell is read.
Optionally, cells of at least one cell type in the second table content have a logic operation formula built based on an original calculation function of an excel engine; in response to this, the control unit,
the operation logic of the current service in each task stage is operated based on the second table content obtained by analysis, and the operation logic comprises the following steps:
and calling the excel engine to run the logic operation formula under the condition that the second table content has the logic operation formula so as to calculate the cell value corresponding to the at least one cell type.
Optionally, the platform automatic type corresponding second cell includes: transmitting cells and/or copying cells; the sending unit cell and the copying unit cell are both related to a task state unit cell and a processing node unit cell in a first unit cell corresponding to the platform input type; the task state cell correlates the user operation received by the service page;
the sending unit cell is provided with a first searching formula built based on a searching function in the excel engine and a sending judging formula built based on the judging function, the first searching formula is associated with the processing node unit cell and is used for searching a processing node corresponding to the next task stage corresponding to the current processing node in third table content; the third table content is used for recording node association relations among all nodes; the transmission judgment formula is associated with the task state cell;
The copying unit cell is provided with a second searching formula built based on a searching function in the excel engine and a copying judging formula built based on the judging function, wherein the second searching formula is associated with the processing node unit cell and is used for searching a copying node corresponding to the next task stage corresponding to the current processing node in the third table content; the transcription judgment formula is associated with the task state cell;
correspondingly, the executing the platform automatic corresponding task according to the cell value of the second cell comprises the following steps:
invoking the excel engine to operate the first search formula to obtain a processing node corresponding to the next task stage, and operating the sending judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated and completed, and filling the processing node corresponding to the next task stage into the sending cell;
transmitting the service processing message to the processing node corresponding to the next task stage under the condition that the cell value of the transmitting cell is the processing node corresponding to the next task stage;
calling the excel engine to operate the second search formula to obtain a copy node corresponding to the next task stage, and operating the copy judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the copy node corresponding to the next task stage into the copy cell;
And sending the service checking message to the copy node corresponding to the next task stage under the condition that the cell value of the copy cell is the copy node corresponding to the next task stage.
Optionally, after receiving the service data of the current service through the first service page and generating the service data table corresponding to the current service according to the service data, the apparatus further includes:
the message receiving module is used for receiving notification messages sent by the processing nodes corresponding to the subsequent task stages; the notification message is sent based on the second table content when the processing node corresponding to the subsequent task stage indicates that the corresponding task stage is completed in the parsed second table content in the service data table; the notification message is used for indicating the processing result of the current task stage;
and the message display module is used for analyzing the service data table corresponding to the current service under the condition of receiving the triggering operation acted on the notification message so as to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
A seventh aspect is a service application running apparatus, wherein the apparatus includes:
the message receiving module is used for receiving a service message sent by the target service application for the current service; wherein the current service is created upon receiving a service creation operation acting on a running portal of the target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document; the service message comprises a service processing message or a service checking message, wherein the service processing message is used for indicating a current node to process the current service, and the service checking message is used for indicating the current node to check the current service;
the page display module is used for responding to the triggering operation acted on the service message, and generating and displaying a second service page of the current service based on the service data table corresponding to the current service; the service data table is generated according to the service data after receiving the service data of the current service through the first service page; the first business page is generated based on the target excel document.
Optionally, after the second service page of the current service is generated and displayed based on the service data table corresponding to the current service in response to the triggering operation acting on the service message, the apparatus further includes:
a data updating module, configured to update the service data table based on the service data when service data is received through the second service page;
and/or the number of the groups of groups,
and the service running module is used for analyzing the service data table corresponding to the current service under the condition of receiving the interactive operation acting on the second service page so as to run the current service.
Optionally, the service running module is further configured to:
sending a notification message to a processing node corresponding to a task stage before the current task stage based on the second table content under the condition that the analyzed second table content in the service data table indicates that the current service is completed in the current task stage; the notification message is used for indicating the processing result of the current task stage.
In an eighth aspect, a computer device is provided, the computer device comprising a processor and a memory; the memory stores a program that is loaded and executed by the processor to implement the method for generating a service application according to the first aspect, or implement the method for operating a service application according to the second aspect, or implement the method for operating a service application according to the third aspect.
A ninth aspect provides a computer-readable storage medium having stored therein a program that is loaded and executed by the processor to implement the method of generating a business application according to the first aspect, or to implement the method of operating a business application according to the second aspect, or to implement the method of operating a business application according to the third aspect.
The beneficial effects of this application lie in: displaying an application building page by responding to an application building instruction of a target service application; under the condition that an application building operation acting on an application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records the running information of a target service application; generating an operation inlet of a target business application corresponding to a target excel document; at this time, the creation of the service application can be realized by creating a target excel document, and the service application can be created without the need of users to fully know the code knowledge, so that the problems of high construction difficulty and low efficiency of the service application caused by the need of constructing by using a relational database and a server code in the traditional service application generation method can be solved; the generation difficulty of the service application is reduced, and the generation efficiency of the service application is improved.
The foregoing description is only an overview of the technical solutions of the present application, and in order to make the technical means of the present application more clearly understood, it can be implemented according to the content of the specification, and the following detailed description of the preferred embodiments of the present application will be given with reference to the accompanying drawings.
Drawings
FIG. 1 is a schematic system architecture of an operation platform according to one embodiment of the present application;
FIG. 2 is a flow chart of a method for generating a business application provided by one embodiment of the present application;
FIG. 3 is a schematic diagram of a first table content corresponding to a leave-request service application according to an embodiment of the present disclosure;
FIG. 4 is a flow chart of a method of operating a business application provided by one embodiment of the present application;
FIG. 5 is a flow chart of a method of operating a business application provided in another embodiment of the present application;
FIG. 6 is a flow chart of a method of operation of a business application provided in accordance with yet another embodiment of the present application;
FIG. 7 is a schematic diagram of contents of a third table corresponding to a leave-request service application according to an embodiment of the present application;
FIG. 8 is a schematic diagram of a leave service application according to one embodiment of the present disclosure;
FIG. 9 is a flowchart of a method for operating a leave service application provided in one embodiment of the present application;
FIG. 10 is a flow chart of a reimbursement service provided by one embodiment of the present application;
FIG. 11 is a schematic diagram of a budget form in a first form content corresponding to a reimbursement business application provided in one embodiment of the present application;
FIG. 12 is a schematic diagram of a reimbursement form in a first form content corresponding to a reimbursement service application provided in one embodiment of the present application;
FIG. 13 is a schematic diagram of second table contents corresponding to a reimbursement business application provided in one embodiment of the present application;
FIG. 14 is a flow chart of a method of operation of a reimbursement business application provided in one embodiment of the present application;
FIG. 15 is a schematic diagram of a reimbursement page corresponding to a reimbursement business application provided in one embodiment of the present application;
FIG. 16 is a block diagram of a business application generation apparatus provided by one embodiment of the present application;
FIG. 17 is a block diagram of an operating device for a business application provided in one embodiment of the present application;
FIG. 18 is a block diagram of an operating device for a business application provided in another embodiment of the present application;
FIG. 19 is a block diagram of a computer device provided in one embodiment of the present application.
Detailed Description
The detailed description of the present application is further described in detail below with reference to the drawings and examples. The following examples are illustrative of the present application, but are not intended to limit the scope of the present application.
In order to more clearly understand the various embodiments provided herein, a number of terms referred to herein are first described below.
Business application: in this application, the service application is integrated in a certain operation platform, that is, the operation platform may run one or more service applications, different service applications may complete different services, and the service may include one or at least two task phases. Such as: the service application is a leave-on service application, and is used for completing a leave-on service, and the leave-on service comprises two stages, namely: a request phase and an approval phase. And, for example: the service application is a data filling service application, and is used for completing a data filling service for filling data by multiple persons, wherein the data filling service comprises a stage, namely, a data filling stage, and the service types completed by the service application are not listed one by one.
excel document: refers to a form file edited using an excel tool. Alternatively, the format of the excel document may be xlsx format or xls format, and the format of the excel document is not limited in this embodiment. In the application, the creation of a new business application can be realized by creating an excel document.
Worksheet: one form in an excel document, one excel document may contain one or at least two worksheets. Such as: in the application, 3 worksheets can be set through an excel document, and the worksheets are respectively: business table, employee information table and information calculation table. The service table is used for displaying and inputting service data; the employee information table comprises employee information and is used for defining an enterprise internal organization structure; and the information calculation table is used for setting the running logic of the business application.
The unit cell: the basic data cells in an excel document can uniquely identify a cell in each worksheet by its row and column number. The cells may include a variety of data types such as text, numbers, dates, etc., and the specific data types may be set by the user as desired.
Naming a cell: a cell having a designation that is used to indicate the meaning or use of the cell. Optionally, the running logic of the service application is set by naming a cell in the present application.
Database: for storing structured data in the system, such as employee information, business data, etc. The structured data may be stored in a relational database in the present application.
The following describes an operation platform to which the service application belongs in the present application. Alternatively, the operation platform may be an enterprise management platform, or may be another platform supporting operation of multiple business applications, which is not limited by the type of operation platform in this embodiment. FIG. 1 is a schematic platform architecture of an operation platform according to an embodiment of the present application, as shown in FIG. 1, where the operation platform at least includes: a client 110 and a server 120.
The user terminal 110 is configured to provide an interactive interface between the operation platform and a user, for example: the user terminal 110 is a user interface through which user operations are received.
Illustratively, in the present application, the client 110 includes at least two types, respectively: an application creation end 111 and an application use end 112. The application creation end 111 is configured to create a target service application, and the application use end 112 is configured to execute a task using the target service application after the creation of the target service application.
Optionally, the application user end 112 may be further divided into: a service request terminal 1121 and/or a service processing terminal 1122. Wherein, the service request end 1121 is configured to create a new service (i.e. the current service in the following) by using the target service application; the service processing end 1122 is configured to process the new service by using a target service application, for example: approval, review, etc.
Alternatively, the service request terminal 1121 and the service processing terminal 1122 may be implemented in the same device, that is, a certain device may operate with both the service request terminal 1121 and the service processing terminal 1122; alternatively, the service request terminal 1121 and the service processing terminal 1122 may be implemented in different devices, and the implementation manner of the service request terminal 1121 and the service processing terminal 1122 is not limited in this embodiment.
The server 120 is communicatively connected to the client 110 to provide a background service based on a user operation received by the client 110, and to run a target business application.
Optionally, the server 120 is implemented by at least one server, so as to provide the background service.
Based on the above operation platform, the method for generating the service application provided by the application is described below. The embodiment is described by taking the generation method as an example executed by the operation platform, and specifically may be executed by the application creation terminal 111 and the service terminal 120.
Fig. 2 is a flow chart of the generation of a business application provided by one embodiment of the present application. The method at least comprises the following steps:
step 201, in response to an application building instruction of a target business application, displaying an application building page.
The target business application refers to a newly added business application in the operation platform, namely, a business application which is not originally provided in the operation platform. Optionally, the target service application may complete the same service as the original service application in the operation platform, or may complete a service different from the original service application in the operation platform, and the application type of the target service application is not limited in this embodiment.
The application construction instruction is used for indicating construction of a new target business application. In one example, a user interface provided by an operating platform includes an application build control that, upon receiving an action on the application build control, generates an application build instruction. In other embodiments, the application building instruction may also be an operation instruction for starting the operation platform or a remote control instruction sent by other devices, and the embodiment is not limited to the obtaining manner of the application building instruction.
The application building page is an interactive interface for building a target service application between the operation platform and the user. Optionally, the application build page includes at least one page control associated with an application build operation to receive the application build operation.
Step 202, under the condition that an application building operation acting on an application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records running information of a target service application.
In one example, the application build page includes an excel template upload control. Correspondingly, acquiring the target excel document indicated by the application building operation comprises the following steps: responding to a first application building operation acting on an excel template uploading control, and displaying a local document selection window; and generating a target excel document based on the excel document determined in the local document selection window.
At this time, the page control in the application build page includes an excel template uploading control, and the application build operation includes a first application build operation acting on the excel template uploading control. Uploading the local excel document to the operation platform through the excel template uploading control to obtain the target excel document.
The operation type of the first application building operation may be a single click operation, a long press operation, or a double click operation, which is not limited in this embodiment.
Alternatively, the running platform may directly take the excel document selected locally as the target excel document. Or, after receiving the modification operation of the excel document, obtaining the target excel document; at this time, generating a target excel document based on the excel document determined by the local document selection window includes: displaying an excel document determined based on the local document selection window; and receiving modification operation on the excel document to obtain the target excel document.
The modification operation may be at least one of adding content in the excel document, deleting content in the excel document, and changing content in the excel document, and the specific operation type of the modification operation is not limited in this embodiment. In the method for acquiring the target excel document, a user can acquire the target excel document by modifying the local excel document without manufacturing a target excel document again, so that the acquisition efficiency of the target excel document can be improved.
In another example, the application build page includes an excel document production control. Correspondingly, acquiring the target excel document indicated by the application building operation comprises the following steps: responding to a second application building operation acting on an excel document making control, and displaying a blank excel document; and generating a target excel document based on the input operation of the blank excel document.
At this time, the page control in the application build page includes an excel document production control, and the application build operation includes a second application build operation acting on the excel document production control. Uploading the local excel document to the operation platform through the excel template uploading control to obtain the target excel document.
The operation type of the second application building operation may be the same as or different from the operation type of the first application building operation, and the operation type of the second application building operation may be a single click operation, a long press operation, or a double click operation, which is not limited in this embodiment.
In this embodiment, the operation information is recorded in the target excel document according to a preset rule, where the preset rule is matched with an analysis rule of analyzing the target excel document by the operation platform of the service application. Therefore, after the operation platform obtains the target excel document, the matched analysis rule can be used for analyzing the table content in the target excel document, and the operation of the target business application is realized.
Optionally, the parsing rule is a rule (or default rule) fixedly set in the operation platform, and correspondingly, the preset rule is a fixed rule matched with the parsing rule. Alternatively, the preset rule may be set by the user, and accordingly, the parsing rule of the operation platform is configured to be matched with the preset rule, that is, the preset rule is variable, and the parsing rule is changed according to the change of the preset rule.
In this embodiment, the running information includes a first table content recorded according to a preset rule, where the first table content is used to generate a service page of the target service application. Specifically, the first table content includes: at least one item of static information, wherein the static information is used for generating a static display field in a business page; and input area information corresponding to the static information, wherein the input area information is used for generating an input area of service data corresponding to the static information in the service page.
Wherein the input area information includes, but is not limited to: attribute information of the input area, and/or data within the input area.
Such as: taking the example that the target excel document is used for creating the leave-request service application, the content of a first table in the target excel document is shown in the following table I; the first column is static information, and the second column is data of an input area corresponding to the static information.
Table one:
invitation card Invitation card
Name of name
Staff numbering
Department(s)
Position of job
Leave-on work handover
Invitation card category
By reason of
Start date
End date
In other embodiments, each static information is configured to layout the service page in a table form in the service page, and the implementation manner of the first table content is not limited in this embodiment. Such as: referring to the first table contents shown in fig. 3, each static information and the corresponding input area have been arranged and laid out in the first table contents.
Optionally, the first table content is a specific table area in the target excel document or a specific worksheet in the target excel document, and the implementation manner of the first table content is not limited in this embodiment.
Optionally, the first table contents include a plurality of different first table contents for recording service data of different process branches in the same task. Such as: the task is a budget reimbursement application task, the task comprises two flow branches of a budget filling flow and a reimbursement filling flow, each flow branch comprises at least one task stage, and at the moment, different streams Cheng Fenzhi correspond to different first form contents, namely, the budget filling flow corresponds to one first form content; the reimbursement filling flow corresponds to the other first form content.
Optionally, the operation information further includes a second table content recorded according to a preset rule, where the second table content is used to indicate operation logic of each task stage. Wherein the operating logic includes, but is not limited to: the manner in which the target business application runs in a single task phase, and/or the manner in which flows between different task phases. In one example, the second table content includes at least one of the following cell types:
1. and the platform input type is used for enabling the operation platform to which the target business application belongs to acquire target data and filling the target data into the first cell corresponding to the platform input type.
The first unit cell corresponding to the platform input type comprises: at least one of a task state cell, a create node cell, a process node cell, and a view node cell.
The task state cell is used for indicating whether the current business being processed by the target business application is processed in the current task stage or not. In other words, the cell value of the task state cell may indicate whether the current task phase is in process or completed.
The creation node cell is used to indicate which node the current traffic being processed by the target traffic application is created by.
The processing node cell is used to indicate which node the current traffic being processed by the target traffic application should be processed by at the current task stage.
The view node cell is used to indicate which node the current traffic being processed by the target traffic application is being viewed by.
2. And the platform automatic type is used for enabling the operation platform to execute tasks corresponding to the platform automatic type according to the cell values of the second cells corresponding to the platform automatic type.
The platform automatic type corresponding second cell includes: at least one of a sending cell, a transcription cell, a header cell, and an error prompt cell.
The sending unit is used for indicating the processing node of the next task stage of the current service.
The copy unit is used for indicating a copy node of a next task stage of the current service, unlike the processing node, the copy node only needs to know that the current service reaches the next task stage and does not need to process the next task stage, and the processing node is a node which really needs to process the next task stage.
The header cell is used to indicate a service header of the current service.
The error prompt unit is used for indicating whether the current task has errors.
3. The platform configuration type is used for the operation platform to configure the editing authority of the service page according to the cell value of the third cell corresponding to the platform configuration type. Optionally, editing rights include, but are not limited to: editable and uneditable.
In one example, cells of at least one cell type in the second table content have a logical operation formula built based on an original computing function of the excel engine. In this way, each cell value may automatically send a data change based on interactions between the business page and the user, thereby automatically running the target business application.
Alternatively, the second table content may be a worksheet independent of the first table content, or may be a different table area located in the same worksheet as the first table content, or there may be an overlap between the table area of the first table content and the table area of the second table content (e.g., at least a portion of the second table content is interspersed with the first table content, or at least a portion of the first table content is interspersed with the second table content), which is not limited by the table position of the second table content in this embodiment.
Optionally, in the case that the logical operation formula needs to find the node association relationship, the target excel document also has a third table content recorded with the node association relationship. Such as: the node association relationship is an enterprise architecture relationship, that is, the direct lead and/or department lead of a certain employee can be obtained by searching the node association relationship.
Alternatively, the third table content may be a separate worksheet from the second table content and/or the first table content, or may be located in a different table region of the same worksheet as the first table content and/or the second table content; or the table area of the third table content overlaps with the table area of the first table content and/or the second table content (for example, at least part of the third table content is interspersed in the first table content, or at least part of the third table content is interspersed in the second table content, or at least part of the second table content or the first table content is interspersed in the third table content), the table position of the third table content is not limited in this embodiment.
And 203, generating an operation inlet of the target business application corresponding to the target excel document.
The operation entrance is used for enabling the user to start the target business application. In order to improve the use efficiency of the target service applications, the operation inlets of different target service applications are different, and the operation inlet of each target service application is different from the operation inlet of the original service application in the operation platform.
Optionally, the operation portal includes, but is not limited to: at least one of the icon and the application name of the target service application, the implementation of the running portal is not limited in this embodiment.
Optionally, after the operation portal is generated, the operation portal is displayed in a display page of the operation platform, so as to be convenient for a user to use.
In summary, in the method for generating a service application provided in the embodiment, an application building page is displayed by responding to an application building instruction of a target service application; under the condition that an application building operation acting on an application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records the running information of a target service application; generating an operation inlet of a target business application corresponding to a target excel document; at this time, the creation of the service application can be realized by creating a target excel document, and the service application can be created without the need of users to fully know the code knowledge, so that the problems of high construction difficulty and low efficiency of the service application caused by the need of constructing by using a relational database and a server code in the traditional service application generation method can be solved; the generation difficulty of the service application is reduced, and the generation efficiency of the service application is improved.
After the target business application is generated, the user can process the business through the target business application. The following describes a method for operating the service application provided in the present application. The embodiment is described by taking the generation method as an example executed by the operation platform, and specifically may be executed by the service request end 1121 and the service end 120.
Fig. 4 is a flow chart of the generation of a business application provided by one embodiment of the present application. The method at least comprises the following steps:
step 401, displaying the running entry of the target business application.
The operation entrance is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document.
In one example, after the service request terminal starts the operation platform, a user page of the operation platform displays an operation entry of the target service application.
In step 402, in response to receiving a service creation operation acting on the operation portal, a first service page of the target service application is generated and displayed based on a target excel document corresponding to the target service application.
In this embodiment, the operation information is recorded in the target excel document according to a preset rule. Correspondingly, generating and displaying a first service page of the target service application based on a target excel document corresponding to the target service application, including: analyzing the target excel document according to an analysis rule matched with a preset rule; generating a first business page based on the parsed information; and displaying the first business page.
In one example, the preset rule has a corresponding table area for each cell type, where the table areas corresponding to different cell types are different.
Correspondingly, parsing the target excel document according to the parsing rule matched with the preset rule includes: and analyzing the table areas corresponding to the different cell types according to the analysis rule to obtain cell values of the table areas so as to enable the operation platform of the target service application to execute tasks corresponding to the cell types.
Such as: and if the table area corresponding to the first table content is an independent first worksheet, the analysis rule of the operation platform is to analyze the first worksheet to acquire the first table content.
And, for example: and if the table area corresponding to the first cell in the second table content is from the ith row to the jth row and from the xth column to the yth column, the analysis rule of the operation platform is to analyze the table area from the ith row to the jth row and from the xth column to the yth column, so as to obtain the cell value of the first cell. Wherein i, j, x, y is a positive integer.
In another example, the preset rule has a corresponding cell name for each cell type. The naming modes of the named cells corresponding to different cell types are different.
Correspondingly, parsing the target excel document according to the parsing rule matched with the preset rule includes: and analyzing the named cells corresponding to the different cell types according to the analysis rule to obtain cell values of the named cells so as to enable the operation platform of the target service application to execute tasks corresponding to the cell types.
Such as: the first cell is a named cell, and the task state cell is named: whether the workbench is in the creation; creating a naming of node cells as: the workbench inputs a worksheet creator; the processing node cells are named: the workbench inputs a current responsible person; the name of the check node cell is: the workbench inputs the current user. At this time, the operation platform reads the cell named as "whether the workbench input_is being created" according to the matched analysis rule, and obtains the task state indicated by the task state cell.
And the operation platform reads the unit cell named as 'workbench input_work order creator' according to the matched analysis rule to obtain the creation node of the current task. And the operation platform reads the cell named as 'workbench input_current responsible person' according to the matched analysis rule to obtain the processing node of the current task. And the operation platform reads the cell named as 'workbench input_current responsible person' according to the matched analysis rule to obtain the check node of the current task.
And, for example: the second cell is a named cell, and the sending cell is named: the workbench automatically sends; the name of the copy cell is: automatic bench-based copy; title cell naming is: automatic header of workbench; the naming of the error prompt cell is: a workstation auto-handoff error, a workstation auto-archive error, a workstation auto-delete error, etc.
And the operation platform reads the unit cell named as 'automatic workbench sending' according to the matched analysis rule to obtain the processing node of the next task stage. And the operation platform reads the unit lattice named as 'workbench automatic_copy' according to the matched analysis rule to obtain the copy node of the next task stage of the current task. And the operation platform reads the cell named as 'workbench automatic_title' according to the matched analysis rule to obtain the task title of the current task. The operation platform reads the unit cell named as 'automatic workbench-error handover' according to the matched analysis rule to obtain the error information when the task flows; reading a cell named as 'automatic workbench-archiving error', and obtaining error information when a task is archived; and reading a cell named as 'automatic workbench_deleting error', and obtaining error information when the task is deleted.
In other embodiments, the preset rule of the target excel document recording the operation information and the analysis rule of the operation platform analyzing the target excel document may be other manners, as long as it can be ensured that different types of cells can be analyzed by the operation platform.
In this embodiment, the target excel document includes a first table content, where the first table content includes at least one item of static information and input area information corresponding to the static information; correspondingly, generating a first service page based on the parsed information includes: and generating a static display field corresponding to the static information obtained by analysis and an input area indicated by the input area information in the service page.
From the above, it is known that the target excel document of some target business applications may also include the second table content. Based on the above, the parsing target excel document according to the parsing rule matched with the preset rule, further includes: analyzing whether the second table content exists according to the analysis rule; and if the second table contents exist, operating the operation logic of the current service in each task stage based on the second table contents obtained through analysis.
In one example, the second table content is an independent second worksheet, at which point parsing whether the second table content exists according to parsing rules includes: determining whether a second worksheet exists; if so, determining that the second table content exists; if not, it is determined that the second table content does not exist.
Or in other embodiments, if the second table content is located in the same worksheet as the first table content, the operation platform may determine whether the table area corresponding to the second table content is empty, and if not, determine that the second table content exists; if the second table content is empty, the second table content is determined to be not present. The present embodiment is not limited in the manner of determining whether the second table contents exist.
Operating logic of the current service in each task stage based on the parsed second table content includes, but is not limited to, at least one of the following:
first case: and under the condition that the first cell corresponding to the platform input type exists in the second table content, acquiring target data corresponding to the platform input type and filling the target data into the first cell.
The cell value of the first cell corresponding to the platform input type is obtained based on the target data acquired by the operation platform. At this time, it is necessary to obtain the cell value of the first cell after the target data is acquired.
The target data to be acquired by the first cells of different types are different. Such as: the first cell includes at least one of a task state cell, a create node cell, a process node cell, and a view node cell. Correspondingly, the target data acquired by the task state cell indicates the running state of the current task in the current task stage, and at this time, the target data corresponding to the input type of the acquisition platform is filled into the first cell, which comprises the following steps: and filling the running state of the current task stage into the task state cell.
The target data acquired by the creating node cell indicates the creating node of the current task, and at this time, the target data corresponding to the input type of the acquiring platform is filled into the first cell, which comprises the following steps: and filling the running state of the creation node of the current task into the creation node cell.
The target data acquired by the processing node cells indicate the processing node of the current task in the current task stage, and at this time, the target data corresponding to the input type of the acquisition platform is filled into the first cell, which comprises the following steps: and filling the processing nodes of the current task stage into the processing node cells.
The target data acquired by the check node cell indicates the check node currently being checked by the current task, and at this time, the target data corresponding to the input type of the acquisition platform is filled in the first cell, which comprises the following steps: and filling the check node cell with the check node currently being checked.
Second case: reading a cell value of a second cell under the condition that the second cell corresponding to the second table content existence platform is analyzed; executing tasks corresponding to the platform automation according to the cell values of the second cells;
wherein the platform automatic corresponding second cell includes: at least one of a sending cell, a transcription cell, a header cell, and an error prompt cell. Correspondingly, executing the tasks corresponding to the platform automation type according to the cell values of the second cells, including: under the condition that the cell value of the sending cell is read, sending a service processing message to a processing node indicated by the cell value of the sending cell; under the condition that the cell value of the copy cell is read, sending a service check message to a check node indicated by the cell value of the copy cell; under the condition that the cell value of the title cell is read, displaying a task title of the current task on the first service page based on the cell value of the title cell; and displaying error information indicated by the cell values of the error cells on the first service page under the condition that the cell values of the error cells are read.
Optionally, the error cells may be subdivided into multiple types to indicate different types of error information, such as: the error cell comprises a handover error cell for indicating error information when the task flows; an archiving error cell for indicating error information when a task is archived; and deleting the error cell, which is used for indicating the error information and the like when the task is deleted, the error information indicated by the error cell is not limited in the embodiment.
Third case: reading a cell value of a third cell under the condition that the second table content is analyzed to have the third cell corresponding to the configuration type of the storage platform; and configuring the editing authority of the first business page according to the cell value of the third cell.
The editing authority of the first service page comprises the following steps: the authority of the service data is input in the input box. Generally, input boxes that can be edited by different roles are different in different task phases, such as: in the leave request stage, the applicant is not allowed to edit an input box for inputting approval comments; during the leave approval phase, the approver is not allowed to edit the input box for entering leave data. Based on this, by setting the third cell, setting different editing rights at different task stages can be achieved.
In this embodiment, cells of at least one cell type in the second table content have a logic operation formula built based on an original calculation function of the excel engine. Accordingly, running logic of the current service in each task stage is run based on the second table content obtained by analysis, and the running logic comprises the following steps: and calling an excel engine to run the logic operation formula under the condition that the second table content has the logic operation formula so as to calculate the cell value corresponding to at least one cell type.
Alternatively, the operating logic includes, but is not limited to: at least one of a task title of a current task, editing rights of each task phase, task error cues, and flow logic between different task phases. The following describes a specific manner of implementing the operation logic by the operation logic operation formula.
1. And acquiring a task title of the current task, wherein the second cell comprises a title cell.
Optionally, the title cell is associated with at least one first cell to obtain the task title based on the cell value of the first cell. Such as: the title cell is associated with the creation node cell, and at the moment, the task title comprises information for creating the node; and, for example: the title cell is associated with a task state cell, at which time the task title includes information of the current task phase.
In this application, associating one cell with another cell (e.g., associating the header cell with the first cell above) means that the cell value of the cell needs to be calculated based on the cell value of the other cell. That is, the cell value of another cell changes, and the cell value of that cell changes.
In one example, the title cell has a title judgment formula built based on a judgment function in an excel engine. At this time, executing the task corresponding to the platform automation type according to the cell value of the second cell, including: and calling an excel engine to run a title judgment formula, and displaying a task title output by the title judgment formula in a service page.
Such as: the title judgment formula is: =if (reimbursement table | H15< > "no fill is required, CONCATENATE (budget table | B2," - ", budget table | C4," - ", budget table | E14," element "), CONCATENATE (reimbursement table | B2," - ", reimbursement table | C4," - ", reimbursement amount aggregate," element ")). Wherein IF is a judging function and CONCATENATE is a connecting function.
The meaning of the title judgment formula is as follows: if the H15 cell in the reimbursement form is not equal to 'no filling', returning to the B2 cell value in the budget form to connect to 'the C4 cell value in the reconnection budget form to connect to' the E14 cell value in the reconnection budget form to connect to 'the element'; otherwise, returning the B2 cell value connection up "-" reconnection up "reimbursement" connection up "-" reconnection in reimbursement table the C4 cell value in the reimbursement table is connected with "-" the value of the sum of the reimbursement amounts is connected with "element".
In yet another example, the title cell has a title generation formula built based on a connection function in an excel engine. At this time, executing the task corresponding to the platform automation type according to the cell value of the second cell, including: and calling an excel engine to run a title generation formula, and displaying a task title generated by the title generation formula in a service page.
Such as: the title generation formula is: =concat (workbench input_work order creator, "-leave order"). Wherein CONCAT is a connection function.
The meaning of the title generation formula is: the cell value of "table input_work order creator" is connected to "-ask for the false order".
When the operation platform reads that the title cell is not empty, the cell value of the title cell is read as a task title.
2. Editing rights for each task phase. At this time, the second table contents include a third cell. The third cell is associated with at least one first cell.
The third cell has a right judgment formula built based on a judgment function in the excel engine. At this time, configuring the editing authority of the first service page according to the cell value of the third cell includes: and calling an excel engine to run a permission judging formula, and opening the editing permission of the input area indicated by the cell area output by the permission judging formula on the service page, or disabling the editing permission of the input area indicated by the cell area output by the permission judging formula on the service page.
Such as: the authority judgment formula is as follows: =if (whether table input_in creation=1, "business table | C4, business table | E4, business table | G4, business table | I4, business table | D5, business table | H5, business table | C6, business table | C11, business table | G11", "business table | C12")
The meaning of the right judgment formula is as follows: the current task phase is to open the creator to fill out the region while in creation and to open the approver region while not in creation.
The meaning of the right judgment formula is as follows: the current task phase is to open the creator to fill out the area while creating, i.e. "business form-! C4, business table-! E4, business table-! G4, business table-! I4, business table-! D5, business table-! H5, business table-! C6, business table-! C11, business table-! G11). When not currently in creation, open reviewer area, i.e. "business form-! And C12 ").
3. Task error prompting. At this time, the second cells in the second table contents include error prompt cells. The error hint cells include, but are not limited to, at least one of handover error cells, archive error cells, and delete error cells. Each error indication cell is associated with at least one first cell.
In one example, the error hint cell has an error judgment formula built based on a judgment function in an excel engine. At this time, executing the task corresponding to the platform automation type according to the cell value of the second cell, including: calling an excel engine operation error judgment formula; and outputting error information output by the error judgment formula on the service page when the output of the error judgment formula is not null.
Such as: the error judgment formula in the handover error cell in the error prompt cell is: =if (reimbursement table | h15= "no need to fill in", IF (AND (budget table | E14< <reimbursementtable | E15, reimbursement table | B1< "))," budget amount is not consistent with the actual reimbursement amount, please confirm ",").
The meaning of the error judgment formula is as follows: if the value of the H15 cell in the reimbursement form is 'no need to be filled' (no need to fill the budget form), returning a null value; otherwise, if the value of the E14 cell in the budget table is not equal to the value of the E15 cell in the reimbursement table (the budget table filling amount is not consistent with the reimbursement table filling amount) and the B1 cell in the reimbursement table is not empty (the reimbursement table has filled content and is not in a unfilled state), returning a 'budget amount is not consistent with the actual reimbursement amount, requesting confirmation'; otherwise, returning a null value. When the operation platform recognizes that the cell value of the handover error cell is not empty, the user is restricted from handover to the next stage, and error reporting prompt is performed according to the content in the cell.
And, for example: the error judgment formula in the archiving error cell is: =if (reimbursement table | c21< > "consent", "only payer allowed archiving task", ").
The meaning of the error judgment formula is as follows: if the value of the C21 cell in the reimbursement form is not equal to "agree", return "only payer allowed archiving task"; otherwise, returning a null value. When the running platform recognizes that the cell value of the archiving error cell is not empty, the user archiving task is limited, and error reporting prompt is carried out according to the cell value in the archiving error cell.
4. Flow logic between different task phases. In this embodiment, taking the example that the second cell corresponding to the platform automation type includes a sending cell and/or a copy cell. The sending unit cell and the copying unit cell are both related to the task state unit cell and the processing node unit cell in the first unit cell corresponding to the platform input type; and the task state cell is associated with the user operation received by the service page.
The sending unit cell is provided with a first searching formula built based on a searching function in the excel engine and a sending judging formula built based on a judging function, wherein the first searching formula is associated with the processing node unit cell and is used for searching a processing node corresponding to the next task stage corresponding to the current processing node in the third table content; the third table content is used for recording node association relations among the nodes; the transmit decision formula is associated with a task state cell.
The copying unit cell is provided with a second searching formula built based on a searching function in the excel engine and a copying judging formula built based on a judging function, wherein the second searching formula is associated with the processing node unit cell and is used for searching a copying node corresponding to the next task stage corresponding to the current processing node in the third table content; the transcription decision formula is associated with a task state cell.
Correspondingly, executing the tasks corresponding to the platform automation type according to the cell values of the second cells, including: calling an excel engine to operate a first search formula to obtain a processing node corresponding to the next task stage, and operating a transmission judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the processing node corresponding to the next task stage into the transmission cell; transmitting a service processing message to a processing node corresponding to the next task stage under the condition that the cell value of the transmitting cell is the processing node corresponding to the next task stage;
calling an excel engine to operate a second search formula to obtain a copy node corresponding to the next task stage, and operating a copy judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the copy node corresponding to the next task stage into the copy cell; and sending a service check message to the copy node corresponding to the next task stage under the condition that the cell value of the copy cell is the copy node corresponding to the next task stage.
In one example, the lookup function is VLOOKUP. Such as: the first search formula or the second search formula is: VLOOKUP (workstation input_worksheet creator, employee information table | a1:c6,3, false), meaning of the lookup formula is: and calculating a department manager of the work order creator according to the staff information table and the worksheet.
Step 403, receiving service data of the current service through the first service page, and generating a service data table corresponding to the current service according to the service data.
The service data office table corresponding to the current service refers to a data table generated after service data is filled into a target excel document. That is, each service corresponds to a service data table that includes a first table content, a second table content (if any), and a third table content (if any) in the target excel document.
Optionally, after receiving the service data of the current service through the first service page and generating the service data table corresponding to the current service according to the service data, the method further includes: and analyzing the service data table based on the service data and/or the interaction operation acting on the first service page so as to run the current service.
Because the values of the cells in the service data table may change each time the service data and/or the interactive operation are received, the state of the service can be timely analyzed by analyzing the service data table, and the current service can be timely operated.
Wherein the interaction includes, but is not limited to: task creation operations, and/or cancellation operations, etc., the present embodiment does not limit the operation type of the interactive operation.
In this embodiment, since the service data representation is generated based on the target excel file, the manner of analyzing the service data table is the same as the manner of analyzing the target excel file, and the relevant analysis content only needs to replace the target excel file in the description with the service data table, which is not described herein.
In summary, the method for operating a service application provided in this embodiment displays an operation entry of a target service application; generating and displaying a first service page of a target service application based on a target excel document corresponding to the target service application in response to receiving a service creation operation acting on a running portal; receiving service data of a current service through a first service page, and generating a service data table corresponding to the current service according to the service data; the operation platform can automatically operate the target business application only by the target excel document to finish the current business, and the problems of high construction difficulty and low efficiency of the business application caused by the need of constructing by using a relational database and a server code in the traditional business application generation method can be solved; the generation difficulty of the service application is reduced, and the generation efficiency of the service application is improved.
In addition, by naming the cells to parse the target excel document, the user can understand the target excel document more easily than by using column letters and row numbers to reference the cells, and the readability of the running logic formula can be improved. Meanwhile, the named cells can be hooked with the positions of the cells, so that the naming is still effective even if the positions are changed, and the flexibility of editing the document is improved.
Optionally, based on the above embodiment, in a case that the current service processed by the target service application needs to be processed by the service processing end, the service processing end needs to run the target service application. The following describes a method for operating a service application according to another embodiment of the present application. The embodiment is described by taking the generation method as an example executed by the operation platform, and specifically may be executed by the service processing end 1121 and the service end 120.
Fig. 5 is a flow chart of the generation of a business application provided by one embodiment of the present application. The method at least comprises the following steps:
in step 501, a service message sent by a target service application for a current service is received.
Wherein the current service is created upon receiving a service creation operation acting on a running portal of the target service application.
The operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document; the service message includes a service processing message or a service viewing message, where the service processing message is used to instruct the current node to process the current service, and the service viewing message is used to instruct the current node to view the current service.
Step 502, responding to the triggering operation acted on the service message, and generating and displaying a second service page of the current service based on the service data table corresponding to the current service; the service data table is generated according to the service data after receiving the service data of the current service through the first service page; the first business page is generated based on the target excel document.
According to the above embodiment, the service data table is updated in real time based on the target excel document, and thus includes the first table content, the second table content (if any), and the third table content (if any) in the target excel document, and the second service page is obtained by parsing the first table content in the service data table. Specifically, the description is consistent with the description related to the first business page generated by parsing the first table content in the target excel document in the above embodiment, but the target excel document is replaced by the business data table, and the first business page is replaced by the second business page.
Optionally, if the service processing end 1121 needs to input data in the second service page to process the current service, after step 502, the method further includes: updating a service data table based on the service data in case the service data is received through the second service page; and/or under the condition of receiving the interactive operation acting on the second service page, analyzing the service data table corresponding to the current service so as to operate the current service.
The method for updating the service data table based on the service data and analyzing the related description of the service data table to run the current service is described in detail in the above embodiment, and only the target excel document needs to be replaced by the service data table, which is not described herein.
Optionally, parsing the service data table corresponding to the current service to operate the current service includes: under the condition that the second table content in the analyzed service data table indicates that the current service is completed in the current task stage, sending a notification message to a processing node corresponding to the task stage before the current task stage based on the second table content; the notification message is used to indicate the processing result of the current task stage.
Such as: the processing result includes that the leave request is not passed or that the leave request is passed.
Accordingly, after the above step 403, the service request end 1121 may further perform the following steps: receiving a notification message sent by a processing node corresponding to the subsequent task stage; and under the condition that the triggering operation acted on the notification message is received, analyzing a service data table corresponding to the current service to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
The notification message is sent based on the second table content when the processing node corresponding to the subsequent task stage indicates that the corresponding task stage is completed in the second table content in the parsed service data table; the notification message is used to indicate the processing result of the current task stage.
The method of analyzing the service data table corresponding to the current service to display the third service page corresponding to the current service is consistent with the related description of generating the first service page by analyzing the first table content in the target excel document in the above embodiment, and only the target excel document is replaced by the service data table, and the first service page is replaced by the third service page.
In order to more clearly understand the interaction flow between the service request end and the service use end in the above embodiment, the following describes the flow in detail. Referring to the operation system of the business application shown in fig. 6, the operation process of the system at least comprises the following steps:
step 601, a service request end displays an operation inlet of a target service application; generating and displaying a first business page of a target business application based on first table contents of a target excel document corresponding to the target business application in response to receiving a business creation operation acting on a running portal; and receiving service data of the current service through the first service page, generating a service data table corresponding to the current service according to the service data, and sending service information based on the processing node and/or the check node indicated by the second table content of the target excel document.
Step 602, a service processing end receives a service message sent by a target service application for a current service; and responding to the triggering operation acted on the service message, and generating and displaying a second service page of the current service based on the service data table corresponding to the current service.
Step 603, the service processing end updates the service data table based on the service data under the condition that the service data is received through the second service page; and sending a notification message to a processing node corresponding to a task stage before the current task stage based on the second table content under the condition that the second table content in the updated service data table indicates that the current service is completed in the current task stage.
Step 604, the service request end receives the notification message; and under the condition that the triggering operation acted on the notification message is received, analyzing a service data table corresponding to the current service to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
Optionally, the service processing end sends a service processing message to a processing node indicated by the second table content when the second table content in the updated service data table indicates that the current service is completed in the current task stage and a processing node corresponding to the next task stage exists; so that the service processing end used by the processing node corresponding to the next task stage executes step 603 again, where the service message includes a service processing message.
Based on the above embodiments, the following are several specific examples of implementation of the target service application of the present application.
1. The target business application is a leave-on approval application. At this time, the target excel document includes a first table content (refer to the ask list work table in fig. 3), a second table content, and a third table content.
According to the first form content, the input area required to be filled by the staff applying for the leave at the service request end comprises: business data of 9 static fields, namely a name, an employee number, a department, a job position, a leave job handover, a leave category, an event, a start date and an end date.
The input area that the business processing end, i.e. the approver needs to fill in, comprises business data of the static field of 'leading approval'.
The third table content is described with enterprise internal information, and is specifically shown in fig. 7. The second table content is provided with operation logic of the leave-request service, and particularly, reference is made to fig. 8. As can be seen from fig. 8, the first cells of the second table content include task status cells, processing node cells and creating node cells, in this example, each first cell is taken as a named cell, the named cell of each first cell is shown in the following table two, and according to the table two, the cell value of each first cell is automatically acquired by the operation platform and filled in the corresponding cell position.
And (II) table:
the second cells in the second table content include: a sending cell, a transcription cell, and a header cell. In this example, each second cell is taken as a named cell, and the named cell of each second cell is shown in the following table three, and according to the table three, the cell value of each second cell is calculated by using a corresponding formula and is filled in the corresponding cell position for the operation platform to read to execute the corresponding task.
Table three:
taking a third cell in the second table content as a named cell, the named cell of the third cell is shown in the following table four, and according to the table four, the cell value of each third cell is calculated by using a corresponding formula and is filled in the corresponding cell position, so that the operation platform configures the editing authority of the input area in the service page according to the cell value of the third cell.
Table four:
when the target service application is started (may be started through a running entry or may be started through the service message or the notification message), a service page is generated based on the first table content shown in fig. 7, so that a user may perform a user operation on the service page, for example: operations of inputting business data and/or interactive operations of clicking interactive controls on business pages, etc., such as: click on interactive controls on the business page such as submit, confirm, cancel, etc.
After each time the operation platform receives the user operation, the operation platform updates the first table content, the second table content and the third table content based on the user operation, and analyzes the first table content, the second table content and the third table content again to obtain the latest unit grid value; and then, the execution of the service is advanced according to the updated cell value.
Specifically, based on the table contents, a leave-on procedure is specifically described below, referring to the parts (a) and (b) in fig. 9, and the procedure at least includes the following steps:
step 91, a service request terminal receives a service creation operation serving as an operation entry, and reads a target excel document corresponding to the leave-request service application;
step 92, the service request end analyzes the target excel document to generate a first leave page according to the first form content, configures the editing authority of an input frame to be filled by a creator in the first leave page to be editable according to a third cell in the second form content, generates a service title of the first leave page according to a title cell in the second form content, reads the task state of the current task to automatically fill in a named cell 'whether a workbench input_is created', reads the current user account to fill in the named cell 'workbench input_current user', and reads the user account to fill in the named cell 'workbench input_work order creator' of the creation node;
The input boxes required to be filled by the creator are input boxes corresponding to 9 static fields, namely a name, an employee number, a department, a job position, a leave job handover, a leave category, an event date and an end date. Optionally, the value of the input box corresponding to each static field is initialized to be null.
The value of "table input_not under creation" of the named cell is initialized to 1 to indicate that the current task is in the running state under creation.
Step 93, the service request end displays the first leave page to receive leave data through the editable input box in the first leave page.
Step 94, the service request terminal fills the received leave-request data into the cell area corresponding to the input frame in the first table content to update the target excel document to generate a service data table;
step 95, the service request end receives a leave-request submitting operation applied to the first leave-request page, and updates the cell value of the task state cell in the service data table to 0 based on the leave-request submitting operation; the named cell "table auto send" updates the cell value with the cell value based on the task state cell.
Step 96, the service request end sends a service processing message to the processing node of the next task stage under the condition that the processing node of the next task stage is in the "automatic workbench_send" of the named cell;
step 97, the service processing end receives and displays the service processing message;
step 98, the service processing end receives the triggering operation acting on the service processing information, reads and analyzes the service data table corresponding to the current leave-out service, so as to generate a second leave-out page according to the first table content in the service data table, configures the editing authority of an input frame to be filled by an approver in the leave-out page according to a third cell in the second table content to be editable, generates a service title of the first leave-out page according to a title cell in the second table content, reads whether a task state of the current task is automatically filled into a named cell 'work table input_is in creation', reads a current user account to be filled into a named cell 'work table input_current user', and reads a user account to be filled into a created node to be filled into a named cell 'work table input_work table creator';
step 99, the service processing end displays the second leave page to receive approval data through the editable input box in the second leave page.
Step 910, the service processing end fills the received approval data into the cell area corresponding to the input frame in the first table content to update the service data table corresponding to the current leave-request service;
step 911, the service processing end receives the approval completion operation applied to the second leave page, analyzes the service data table again, and when the analysis shows that the named cell "automatic workbench_send" does not have the processing node of the next task stage, the current leave service is completed, and sends a notification message to the service request end to notify the leave approval result;
step 912, the service request terminal receives and displays the notification message;
step 913, the service request end receives the triggering operation acting on the notification message, reads and analyzes the service data table corresponding to the current leave service, and generates a third leave page according to the first table content;
step 914, the service request terminal displays a third leave page, where the third leave page includes a leave approval result.
The above description is given by taking the case that the leave-out approval process includes one approval node as an example, and in actual implementation, the approval nodes may be plural, and the specific process is consistent with 97-911, which is not described herein.
According to the above flow, the whole leave-on approval flow can be realized only by analyzing the target excel document and generating the service data table based on the target excel document, and the development efficiency of the target service application can be improved without using codes to redevelop the application.
2. The target business application is a budget reimbursement approval application. Referring to fig. 10, the process requirement of the user application for approval provided in this embodiment at least includes the following steps:
step 1001, applicant initiates a reimbursement application;
step 1002, applicants fill in whether a budget walking process is needed; if necessary, go to step 1003; if not, go to step 1005;
step 1005 is executed if the budget process is default to be executed, and if the applicant is modified to be not executed;
step 1003, applicants fill in budget forms;
step 1004, the approver approves the budget form and designates a single person after the approval passes;
step 1005, the applicant fills out a reimbursement form;
step 1006, the approver approves the reimbursement form;
step 1007, the approver rechecks the reimbursement form after passing the approval;
step 1008, the rechecker rechecks the payer to pay after passing the recheck;
In step 1009, the payer completes the archiving of the current reimbursement service after payment.
In the flow, the responsible person in each stage can only fill in the part responsible by himself, and has no right to modify the cells of other people; task titles need to contain commit time, commit person, and current status (budget/reimbursement); when a person submits an application, the person needs to copy a manager of a department; only agreeing from the approver, rechecking and payment responsible person, the next-stage handover is allowed; if the user fills in the budget table, the corresponding cell in the reimbursement table has a prompt, and whether the contents of the budget table and the reimbursement table are consistent or not needs to be checked, if not, the user is forbidden to transfer to the next stage; archiving is only allowed after the final payer has completed the payment.
Based on the business process requirements described above, the target excel document includes first table content including the budget form shown in FIG. 11 and the reimbursement form shown in FIG. 12.
As can be seen from the budget form, the input area that the employee applying for the budget needs to fill in includes: the service data of 9 static fields, namely ' sales person ', ' department director ', ' date ', ' reimbursement major ', ' abstract ', ' amount ', ' request reason and purchase link ', and ' reimbursement amount ', are summed up '.
The business processing end comprises an approver, and an input area required to be filled by the approver comprises business data of 2 static fields, namely 'approval' and 'appointed next person'.
As can be seen from the reimbursement form, the input area that the staff applying for reimbursement of the fee needs to fill in includes: the business data of 10 static fields of "sales person", "department director", "date", "reimbursement major", "abstract", "amount", "contract and invoice attachment", "reimbursement amount total" and "whether to fill in budget form".
The business processing terminals comprise approvers, recheckers and payers, and the input areas to be filled in by each business processing terminal comprise business data of 2 static fields, namely 'approval' and 'approval opinion'.
The target excel document also comprises a second table content, and the second table content is provided with operation logic of budget application service and reimbursement application service in an operation mode so as to meet the flow requirements. Specifically, the second table contents are shown with reference to fig. 13. As can be seen from fig. 13, the first cells of the second table content include task status cells, processing node cells and creating node cells, in this example, each first cell is taken as a named cell, the named cell of each first cell is shown in the following table five, and according to the table five, the cell value of each first cell is automatically acquired by the operation platform and is filled in the corresponding cell position.
Table five:
the second cells in the second table content include: a sending cell, a copying cell, an error prompting cell and a title cell.
The title cell is a named cell "workbench automatic_title", and the title named cell has a title generation formula: =if (reimbursement table | H15< > "no fill required", CONCATENATE (budget table | B2, "-", budget table | C4, "-", budget table | E14, "element"), CONCATENATE (reimbursement table | B2, "-", reimbursement table | C4, "-", reimbursement amount total, "element")).
That is, if the H15 cell in the reimbursement form is not equal to "no fill," the B2 cell value in the budget table is returned to connect to "-" to connect to the C4 cell value in the budget table "-" to connect to the E14 cell value in the budget table to connect to "element"; otherwise, returning the B2 cell value connection up "-" reconnection up "reimbursement" connection up "-" reconnection in reimbursement table the C4 cell value in the reimbursement table is connected with "-" the value of the sum of the reimbursement amounts is connected with "element".
When the running platform recognizes that the cell value of the named cell "workstation auto_title" is not empty, the cell value is read as the task title.
The sending unit cell is named unit cell 'automatic workbench sending', the sending unit cell is provided with a sending judgment formula and is related to a responsible person unit cell of the next task stage of each task stage, and the responsible person unit cell of the next task stage is provided with a first searching formula so as to search for a responsible person of the next stage in the content of the third table.
At the same time, the second table content also has a third cell to indicate the allowed edit area of each task stage.
The person in charge of each task stage refers to the following table six:
table six:
the operation platform defaults the first task stage to be the submitting stage and opens the allowed editing area of the current task stage for it. When the system recognizes that the mark entering the next task stage is true and no new mark of the next task stage exists, the responsible person unit cell of the next task stage is read, and the responsible person for handing over the task to the next task stage is started.
For the copy cell, when the current stage is the submitting stage, the department manager of the submitting person is default to be copied.
The handover error cell among the error hint cells has an error judgment formula: =if (reimbursement table | h15= "no need to fill in", IF (AND (budget table | E14< <reimbursementtable | E15, reimbursement table | B1< "))," budget amount is not consistent with the actual reimbursement amount, please confirm ",").
That is, if the value of the H15 cell in the reimbursement form is "no fill" (no budget form need be filled), a null value is returned; otherwise, if the value of the E14 cell in the budget table is not equal to the value of the E15 cell in the reimbursement table (the budget table filling amount is not consistent with the reimbursement table filling amount) and the B1 cell in the reimbursement table is not empty (the reimbursement table has filled content and is not in a unfilled state), returning a 'budget amount is not consistent with the actual reimbursement amount, requesting confirmation'; otherwise, returning a null value.
When the operation platform recognizes that the cell value of the handover error cell is not empty, the user is restricted from handover to the next task stage, and error reporting prompt is performed according to the content in the cell.
The archive error cell in the error prompt cell has an error judgment formula: =if (reimbursement table | c21< > "consent", "only payer allowed archiving task", "). That is, if the value of the C21 cell in the reimbursement form is not equal to "consent", then "only payer permitted archiving task" is returned; otherwise, returning a null value.
When the operation platform recognizes that the cell for filing limitation is not empty, the user filing task is limited, and error reporting prompt is carried out according to the content in the cell.
Based on the above table contents, a reimbursement flow is specifically described below, referring to (a), (b) and (c) in fig. 14, and the flow includes at least the following steps:
step 141, receiving a service creation operation serving as an operation entry by a service request terminal, and reading a target excel document corresponding to a reimbursement service application;
step 142, the service request end analyzes the target excel document to generate a first reimbursement page corresponding to the budget application form according to the first form content, configures the editing authority of an input frame which needs to be filled by the budget applicant in the first reimbursement page according to a third cell in the second form content as editable, generates a service title of the first reimbursement page according to a title cell in the second form content, reads whether a task state of a current task is automatically filled in a named cell 'work table input_is created', reads a current user account filling named cell 'work table input_current user', and reads a user account filling named cell 'work table input_work sheet creator' of a creation node;
the value of "table input_not under creation" of the named cell is initialized to 1 to indicate that the current task is in the running state under creation.
In step 143, the service request end displays the first reimbursement page to receive the budget data through the editable input box in the first reimbursement page.
Step 144, the service request terminal fills the received budget data into the cell area corresponding to the input frame in the budget application form, so as to update the target excel document to generate the service data table corresponding to the current reimbursement service.
Step 145, the service request end receives the submitting operation used for the first reimbursement page, and analyzes the service data table based on the submitting operation, so as to fill the approval responsible person into the sending unit cell and fill the department manager of the reimbursement applicant into the copying unit cell according to the second table content; and displaying a first reimbursement page corresponding to the updated service data table.
The first cancellation page corresponding to the updated service data table is shown with reference to fig. 15.
Step 146, the service request end receives a determining operation acting on the first reimbursement page, and sends a service processing message to the processing node of the next task stage indicated by the sending unit lattice, and sends a service viewing message to the viewing node of the next task stage indicated by the copying unit lattice;
step 147, the service processing end receives and displays the service processing message in the task list;
At this time, the service processing end is the processing node of the next task stage indicated by the sending unit cell, that is, the service processing end used by the approver.
Step 148, the service processing end receives the triggering operation acting on the service processing message, reads and analyzes the service data table corresponding to the current reimbursement service, so as to generate a second reimbursement page according to the first table content in the service data table, configures the editing authority of an input frame to be filled by an approver in the reimbursement page according to a third cell in the second table content to be editable, generates a service title of the first reimbursement page according to a title cell in the second table content, reads whether a task state of the current task is automatically filled into a named cell 'work table input_is in creation', reads a current user account to be filled into a named cell 'work table input_work table creator';
in step 149, the service processing end displays the second reimbursement page to receive approval data through the editable input box in the second reimbursement page.
Step 1410, the service processing end fills the received approval data into the cell area corresponding to the input frame in the first table content, so as to update the service data table corresponding to the current reimbursement service;
Step 1411, the service processing end receives the approval completion operation applied to the second reimbursement page, analyzes the service data table again, analyzes the processing node of the next task stage of the sending unit cell, and sends the service processing message to the processing node of the next task stage;
since the reimbursement applicant needs to fill in the data in the reimbursement form, at this time, the processing node in the next task stage is the service request end used by the reimbursement applicant.
Step 1412, the service request terminal receives and displays the service processing message;
step 1413, the service request end receives the trigger operation acted on the service processing message, reads and analyzes the service data table corresponding to the current reimbursement service, so as to generate a first reimbursement page corresponding to the reimbursement form according to the first form content, configure the editing authority of an input frame which needs to be filled by the budget applicant in the first reimbursement page to be editable according to a third cell in the second form content, generate the service title of the first reimbursement page according to a title cell in the second form content, read the task state of the current task to automatically fill in a named cell 'whether a workbench input_is created', read the current user account to fill in the named cell 'workbench input_current user', read the user account of the creation node to fill in the named cell 'workbench input_work order creator';
In step 1414, the service request end displays a first reimbursement page corresponding to the reimbursement form, so as to receive reimbursement data through an editable input box in the first reimbursement page.
Step 1415, the service request terminal fills the received reimbursement data into the cell area corresponding to the input frame in the budget application form, so as to reimburse the service data form corresponding to the service currently;
step 1416, the service request terminal receives the submitting operation applied to the first reimbursement page, and analyzes the service data table based on the submitting operation, so as to determine whether the final amount of the filled reimbursement table is consistent with the budget table according to the error prompting unit cell in the second table content, and fill the approval responsible person into the sending unit cell; to update the service data table;
in step 1417, the service request end outputs a handover error prompt through the first reimbursement page when the final amount of the reimbursement table is inconsistent with the budget table, and the process ends.
Step 1418, the service request end sends a service processing message to the processing node of the next task stage indicated by the sending unit cell under the condition that the final amount of the reimbursement table is consistent with the budget table; then, the service processing end used by the processing node corresponding to each task stage sequentially executes the circulation flow described in the step 147-1411; until the corresponding service processing end of the payer executes step 1410, execute step 1419;
In step 1419, the service processing end receives the archiving operation applied to the second page, stores the service data table corresponding to the current reimbursement task, and ends the flow.
Optionally, in the above flow, after the processing of each processing node is completed, a notification message may be sent to the processing node corresponding to each previous task stage to notify the processing result; alternatively, a notification message may be sent only to the applicant to notify the processing result.
According to the above flow, the whole reimbursement and approval flow can be realized only by analyzing the target excel document and generating the service data table based on the target excel document, and the development efficiency of the target service application can be improved without using codes to redevelop the application.
Fig. 16 is a block diagram of a generating apparatus of a service application provided in an embodiment of the present application. The device at least comprises the following modules: a page display module 1610, a document acquisition module 1620, and an application generation module 1630.
A page display module 1610, configured to display an application setup page in response to an application setup instruction of a target service application;
the document acquisition module 1620 is configured to acquire a target excel document indicated by the application construction operation under the condition that an application construction operation acting on the application construction page is received, where the target excel document records running information of the target service application;
And the application generating module 1630 is configured to generate an operation entry of the target service application corresponding to the target excel document.
For relevant details reference is made to the method embodiments described above.
It should be noted that: in the generating device of the service application provided in the above embodiment, when the generating of the service application is performed, only the division of the functional modules is used for illustration, in practical application, the above-mentioned functional allocation may be completed by different functional modules according to needs, that is, the internal structure of the generating device of the service application is divided into different functional modules to complete all or part of the functions described above. In addition, the generating device of the service application and the generating method embodiment of the service application provided in the foregoing embodiments belong to the same concept, and specific implementation processes of the generating device of the service application are detailed in the method embodiment, which is not described herein again.
Fig. 17 is a block diagram of an operation device of a service application according to an embodiment of the present application. The device at least comprises the following modules: an entry display module 1710, a page display module 1720, and a data acquisition module 1730.
An entry display module 1710 for displaying an operation entry of the target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document;
A page display module 1720, configured to generate and display, in response to receiving a service creation operation acting on the operation portal, a first service page of the target service application based on a target excel document corresponding to the target service application;
the data obtaining module 1730 is configured to receive service data of a current service through the first service page, and generate a service data table corresponding to the current service according to the service data.
Optionally, the operation information is recorded in the target excel document according to a preset rule; accordingly, the page display module includes:
the document analysis unit is used for analyzing the target excel document according to analysis rules matched with the preset rules;
the page generation unit is used for generating the first service page based on the parsed information;
and the page display unit is used for displaying the first service page.
Optionally, the document parsing unit is further configured to:
analyzing whether the second table content exists according to the analysis rule;
and if the second table contents exist, operating the operation logic of the current service in each task stage based on the second table contents obtained through analysis.
Optionally, the running logic for running the current service in each task stage based on the second table content obtained by parsing includes:
under the condition that the second table content is analyzed to have a first cell corresponding to the platform input type, acquiring target data corresponding to the platform input type and filling the target data into the first cell;
reading a cell value of a second cell when the second cell corresponding to the second table content existence platform automatic type is analyzed; executing the tasks corresponding to the platform automation type according to the cell values of the second cells;
reading a cell value of a third cell corresponding to the configuration type of the second table content storage platform under the condition that the third cell is analyzed; and configuring the editing authority of the first business page according to the cell value of the third cell.
Optionally, the platform automatic type corresponding second cell includes: at least one of a sending cell, a copy cell, a title cell, and an error prompting cell; in response to this, the control unit,
and executing the tasks corresponding to the platform automation type according to the cell values of the second cells, wherein the tasks comprise:
Under the condition that the cell value of the sending cell is read, sending a service processing message to a processing node indicated by the cell value of the sending cell;
under the condition that the cell value of the copy cell is read, sending a service check message to a check node indicated by the cell value of the copy cell;
displaying a task title of the current task on the first service page based on the cell value of the title cell under the condition that the cell value of the title cell is read;
and displaying error information indicated by the cell value of the error cell on the first service page under the condition that the cell value of the error cell is read.
Optionally, cells of at least one cell type in the second table content have a logic operation formula built based on an original calculation function of an excel engine; in response to this, the control unit,
the operation logic of the current service in each task stage is operated based on the second table content obtained by analysis, and the operation logic comprises the following steps:
and calling the excel engine to run the logic operation formula under the condition that the second table content has the logic operation formula so as to calculate the cell value corresponding to the at least one cell type.
Optionally, the platform automatic type corresponding second cell includes: transmitting cells and/or copying cells; the sending unit cell and the copying unit cell are both related to a task state unit cell and a processing node unit cell in a first unit cell corresponding to the platform input type; the task state cell correlates the user operation received by the service page;
the sending unit cell is provided with a first searching formula built based on a searching function in the excel engine and a sending judging formula built based on the judging function, the first searching formula is associated with the processing node unit cell and is used for searching a processing node corresponding to the next task stage corresponding to the current processing node in third table content; the third table content is used for recording node association relations among all nodes; the transmission judgment formula is associated with the task state cell;
the copying unit cell is provided with a second searching formula built based on a searching function in the excel engine and a copying judging formula built based on the judging function, wherein the second searching formula is associated with the processing node unit cell and is used for searching a copying node corresponding to the next task stage corresponding to the current processing node in the third table content; the transcription judgment formula is associated with the task state cell;
Correspondingly, the executing the platform automatic corresponding task according to the cell value of the second cell comprises the following steps:
invoking the excel engine to operate the first search formula to obtain a processing node corresponding to the next task stage, and operating the sending judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated and completed, and filling the processing node corresponding to the next task stage into the sending cell;
transmitting the service processing message to the processing node corresponding to the next task stage under the condition that the cell value of the transmitting cell is the processing node corresponding to the next task stage;
calling the excel engine to operate the second search formula to obtain a copy node corresponding to the next task stage, and operating the copy judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the copy node corresponding to the next task stage into the copy cell;
and sending the service checking message to the copy node corresponding to the next task stage under the condition that the cell value of the copy cell is the copy node corresponding to the next task stage.
Optionally, after receiving the service data of the current service through the first service page and generating the service data table corresponding to the current service according to the service data, the apparatus further includes:
the message receiving module is used for receiving notification messages sent by the processing nodes corresponding to the subsequent task stages; the notification message is sent based on the second table content when the processing node corresponding to the subsequent task stage indicates that the corresponding task stage is completed in the parsed second table content in the service data table; the notification message is used for indicating the processing result of the current task stage;
and the message display module is used for analyzing the service data table corresponding to the current service under the condition of receiving the triggering operation acted on the notification message so as to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
For relevant details reference is made to the method embodiments described above.
Fig. 18 is a block diagram of an operation device of a service application provided in an embodiment of the present application. The device at least comprises the following modules: a message receiving module 1810 and a page display module 1820.
A message receiving module 1810, configured to receive a service message sent by a target service application for a current service; wherein the current service is created upon receiving a service creation operation acting on a running portal of the target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document; the service message comprises a service processing message or a service checking message, wherein the service processing message is used for indicating a current node to process the current service, and the service checking message is used for indicating the current node to check the current service;
the page display module 1820 is configured to generate and display a second service page of the current service based on the service data table corresponding to the current service in response to a triggering operation acting on the service message; the service data table is generated according to the service data after receiving the service data of the current service through the first service page; the first business page is generated based on the target excel document.
Optionally, after the second service page of the current service is generated and displayed based on the service data table corresponding to the current service in response to the triggering operation acting on the service message, the apparatus further includes:
A data updating module, configured to update the service data table based on the service data when service data is received through the second service page;
and/or the number of the groups of groups,
and the service running module is used for analyzing the service data table corresponding to the current service under the condition of receiving the interactive operation acting on the second service page so as to run the current service.
Optionally, the service running module is further configured to:
sending a notification message to a processing node corresponding to a task stage before the current task stage based on the second table content under the condition that the analyzed second table content in the service data table indicates that the current service is completed in the current task stage; the notification message is used for indicating the processing result of the current task stage.
For relevant details reference is made to the method embodiments described above.
It should be noted that: in the operation device of the service application provided in the above embodiment, only the division of the above functional modules is used for illustrating the operation of the service application, and in practical application, the above functional allocation may be performed by different functional modules according to needs, that is, the internal structure of the operation device of the service application is divided into different functional modules to complete all or part of the functions described above. In addition, the operation device of the service application and the operation method embodiment of the service application provided in the foregoing embodiments belong to the same concept, and specific implementation processes of the operation device and the operation method embodiment of the service application are detailed in the method embodiment, which is not repeated herein.
FIG. 19 is a block diagram of a computer device provided in one embodiment of the present application. The computer device is configured to run the above-described operating platform, and includes at least a processor 1901 and a memory 1902.
The processor 1901 may include one or more processing cores, such as: 4 core processors, 19 core processors, etc. The processor 1901 may be implemented in at least one hardware form of DSP (Digital Signal Processing ), FPGA (Field-Programmable Gate Array, field programmable gate array), PLA (Programmable Logic Array ). The processor 1901 may also include a main processor, which is a processor for processing data in the awake state, also called a CPU (Central Processing Unit ), and a coprocessor; a coprocessor is a low-power processor for processing data in a standby state. In some embodiments, the processor 1901 may incorporate a GPU (Graphics Processing Unit, image processor) for rendering and rendering content required for display by the display screen. In some embodiments, the processor 1901 may also include an AI (Artificial Intelligence ) processor for processing computing operations related to machine learning.
Memory 1902 may include one or more computer-readable storage media, which may be non-transitory. Memory 1902 may also include high-speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in memory 1902 is used to store at least one instruction for execution by processor 1901 to implement the methods of generating or running business applications provided by the method embodiments in the present application.
In some embodiments, the computer device may further optionally include: a peripheral interface and at least one peripheral. The processor 1901, memory 1902, and peripheral interfaces may be connected by a bus or signal line. The individual peripheral devices may be connected to the peripheral device interface via buses, signal lines or circuit boards. Illustratively, peripheral devices include, but are not limited to: radio frequency circuitry, touch display screens, audio circuitry, and power supplies, among others.
Of course, the computer device may also include fewer or more components, as the present embodiment is not limited in this regard.
Optionally, the application further provides a computer readable storage medium, where a program is stored, where the program is loaded and executed by a processor to implement a method for generating or running a service application according to the above method embodiment.
Optionally, the application further provides a computer product, which includes a computer readable storage medium, where a program is stored, and the program is loaded and executed by a processor to implement a method for generating or running a service application of the above method embodiment.
The technical features of the above-described embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above-described embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples merely represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the claims appended hereto.

Claims (19)

1. A method for generating a business application, the method comprising:
responding to an application building instruction of a target service application, and displaying an application building page;
under the condition that an application building operation acting on the application building page is received, acquiring a target excel document indicated by the application building operation, wherein the target excel document records the running information of the target service application;
and generating an operation inlet of the target business application corresponding to the target excel document.
2. The method of claim 1, wherein the operation information is recorded in the target excel document according to a preset rule, and the preset rule is matched with an analysis rule of analyzing the target excel document by an operation platform of the service application.
3. The method of claim 2, wherein the running information includes a first table content recorded according to the preset rule, the first table content being used to generate a service page of the target service application; the first table content includes:
at least one item of static information, wherein the static information is used for generating a static display field in the service page; the method comprises the steps of,
And the input area information is used for generating an input area of the business data corresponding to the static information in the business page.
4. A method according to claim 3, wherein the run information further comprises second table contents recorded according to the preset rule, the second table contents indicating run logic of each task stage.
5. The method of claim 4, wherein the second table contents include at least one of the following cell types:
the platform input type is used for enabling an operation platform to which the target business application belongs to acquire target data and filling the target data into a first cell corresponding to the platform input type;
the platform automatic type is used for enabling the operation platform to execute tasks corresponding to the platform automatic type according to cell values of the second cells corresponding to the platform automatic type;
and the platform configuration type is used for the operation platform to configure the editing authority of the service page according to the cell value of the third cell corresponding to the platform configuration type.
6. The method of claim 5, wherein cells of at least one cell type have a logical formula built based on an excel engine's native computational function.
7. A method for operating a business application, the method comprising:
displaying an operation inlet of a target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document;
responding to the received service creation operation acting on the operation inlet, and generating and displaying a first service page of the target service application based on a target excel document corresponding to the target service application;
and receiving service data of the current service through the first service page, and generating a service data table corresponding to the current service according to the service data.
8. The method of claim 7, wherein the operation information is recorded in the target excel document according to a preset rule; in response to this, the control unit,
the generating and displaying the first service page of the target service application based on the target excel document corresponding to the target service application includes:
analyzing the target excel document according to an analysis rule matched with the preset rule;
generating the first business page based on the parsed information;
And displaying the first service page.
9. The method of claim 8, wherein parsing the target excel document according to parsing rules that match the preset rules comprises:
analyzing whether the second table content exists according to the analysis rule;
and if the second table contents exist, operating the operation logic of the current service in each task stage based on the second table contents obtained through analysis.
10. The method of claim 9, wherein the running logic for running the current service at each task stage based on the parsed second table contents comprises:
under the condition that the second table content is analyzed to have a first cell corresponding to the platform input type, acquiring target data corresponding to the platform input type and filling the target data into the first cell;
reading a cell value of a second cell when the second cell corresponding to the second table content existence platform automatic type is analyzed; executing the tasks corresponding to the platform automation type according to the cell values of the second cells;
reading a cell value of a third cell corresponding to the platform configuration type in the case that the second table content is analyzed; and configuring the editing authority of the first business page according to the cell value of the third cell.
11. The method of claim 10, wherein cells of at least one cell type in the second table content have a logical operation formula built based on an excel engine's native computational function; in response to this, the control unit,
the operation logic of the current service in each task stage is operated based on the second table content obtained by analysis, and the operation logic comprises the following steps:
and calling the excel engine to run the logic operation formula under the condition that the second table content has the logic operation formula so as to calculate the cell value corresponding to the at least one cell type.
12. The method of claim 11, wherein the platform-automated corresponding second cell comprises: transmitting cells and/or copying cells; the sending unit cell and the copying unit cell are both related to a task state unit cell and a processing node unit cell in a first unit cell corresponding to the platform input type; the task state cell correlates the user operation received by the service page;
the sending unit cell is provided with a first searching formula built based on a searching function in the excel engine and a sending judging formula built based on the judging function, the first searching formula is associated with the processing node unit cell and is used for searching a processing node corresponding to the next task stage corresponding to the current processing node in third table content; the third table content is used for recording node association relations among all nodes; the transmission judgment formula is associated with the task state cell;
The copying unit cell is provided with a second searching formula built based on a searching function in the excel engine and a copying judging formula built based on the judging function, wherein the second searching formula is associated with the processing node unit cell and is used for searching a copying node corresponding to the next task stage corresponding to the current processing node in the third table content; the transcription judgment formula is associated with the task state cell;
correspondingly, the executing the platform automatic corresponding task according to the cell value of the second cell comprises the following steps:
invoking the excel engine to operate the first search formula to obtain a processing node corresponding to the next task stage, and operating the sending judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated and completed, and filling the processing node corresponding to the next task stage into the sending cell;
transmitting the service processing message to the processing node corresponding to the next task stage under the condition that the cell value of the transmitting cell is the processing node corresponding to the next task stage;
calling the excel engine to operate the second search formula to obtain a copy node corresponding to the next task stage, and operating the copy judgment formula to judge that the cell value of the task state cell indicates that the current task stage is operated, and filling the copy node corresponding to the next task stage into the copy cell;
And sending the service checking message to the copy node corresponding to the next task stage under the condition that the cell value of the copy cell is the copy node corresponding to the next task stage.
13. The method of claim 7, wherein after receiving service data of a current service through the first service page and generating a service data table corresponding to the current service according to the service data, further comprises:
receiving a notification message sent by a processing node corresponding to the subsequent task stage; the notification message is sent based on the second table content when the processing node corresponding to the subsequent task stage indicates that the corresponding task stage is completed in the parsed second table content in the service data table; the notification message is used for indicating the processing result of the current task stage;
and under the condition that a triggering operation acting on the notification message is received, analyzing the service data table corresponding to the current service to display a third service page corresponding to the current service, wherein the third service page at least comprises detailed message content of the notification message.
14. A method for operating a business application, the method comprising:
receiving a service message sent by a target service application for a current service; wherein the current service is created upon receiving a service creation operation acting on a running portal of the target service application; the operation inlet is generated after a target excel document of the target service application is acquired, and the operation information of the target service application is recorded in the target excel document; the service message comprises a service processing message or a service checking message, wherein the service processing message is used for indicating a current node to process the current service, and the service checking message is used for indicating the current node to check the current service;
responding to triggering operation acted on the service message, and generating and displaying a second service page of the current service based on a service data table corresponding to the current service; the service data table is generated according to the service data after receiving the service data of the current service through the first service page; the first business page is generated based on the target excel document.
15. The method according to claim 14, wherein after generating and displaying the second service page of the current service based on the service data table corresponding to the current service in response to the triggering operation acting on the service message, further comprises:
Updating the service data table based on the service data under the condition that the service data is received through the second service page;
and/or the number of the groups of groups,
and under the condition that the interactive operation acting on the second service page is received, analyzing a service data table corresponding to the current service so as to operate the current service.
16. The method of claim 15, wherein the parsing the service data table corresponding to the current service to run the current service comprises:
sending a notification message to a processing node corresponding to a task stage before the current task stage based on the second table content under the condition that the analyzed second table content in the service data table indicates that the current service is completed in the current task stage; the notification message is used for indicating the processing result of the current task stage.
17. A service application running system, characterized in that the system comprises at least two application use ends, wherein the at least two application use ends comprise a service request end and at least one service processing end;
the service request end is configured to: displaying an operation inlet of a target service application; responding to the received service creation operation acting on the operation inlet, and generating and displaying a first service page of the target service application based on the first table content of the target excel document corresponding to the target service application; receiving service data of a current service through the first service page, generating a service data table corresponding to the current service according to the service data, and sending service information based on a processing node and/or a viewing node indicated by second table content of the target excel document;
The service processing end is configured to: receiving a service message sent by a target service application for a current service; and responding to the triggering operation acted on the service message, and generating and displaying a second service page of the current service based on the service data table corresponding to the current service.
18. A computer device, the computer device comprising a processor and a memory; the memory has stored therein a program that is loaded and executed by the processor to realize the business application generation method according to any one of claims 1 to 6; or, implementing a method of operating a business application according to any one of claims 7 to 13; alternatively, a method of operating a business application according to any of claims 14 to 16 is implemented.
19. A computer-readable storage medium, characterized in that the storage medium has stored therein a program which, when executed by a processor, is adapted to carry out the method of generating a business application according to any one of claims 1 to 6; or, implementing a method of operating a business application according to any one of claims 7 to 13; alternatively, a method of operating a business application according to any of claims 14 to 16 is implemented.
CN202311744002.7A 2023-12-18 2023-12-18 Method, system, equipment and storage medium for generating and running business application Pending CN117707500A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311744002.7A CN117707500A (en) 2023-12-18 2023-12-18 Method, system, equipment and storage medium for generating and running business application

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311744002.7A CN117707500A (en) 2023-12-18 2023-12-18 Method, system, equipment and storage medium for generating and running business application

Publications (1)

Publication Number Publication Date
CN117707500A true CN117707500A (en) 2024-03-15

Family

ID=90158588

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311744002.7A Pending CN117707500A (en) 2023-12-18 2023-12-18 Method, system, equipment and storage medium for generating and running business application

Country Status (1)

Country Link
CN (1) CN117707500A (en)

Similar Documents

Publication Publication Date Title
Tang et al. BIM assisted Building Automation System information exchange using BACnet and IFC
Arayici et al. Interoperability specification development for integrated BIM use in performance based design
CN112668295B (en) Management system and method based on custom form and active workflow
US9384174B1 (en) Automated system for assisting the architectural process
CN110543303B (en) Visual service platform
Lee et al. Rules and validation processes for interoperable BIM data exchange
US11580096B2 (en) System for uploading information into a metadata repository
US7512451B2 (en) System and method for interactive process management
Lee et al. NESIS: a neutral schema for a web-based simulation model exchange service across heterogeneous simulation software
CN102915488A (en) Online intelligent design system of engineering project and method of system
Alzraiee Cost estimate system using structured query language in BIM
Bihani et al. Concept for AutomationML-based interoperability between multiple independent engineering tools without semantic harmonization: Experiences with AutomationML
WO2021228118A1 (en) Central air conditioner intelligent design method, system and device
Zeb et al. An ontology-supported asset information integrator system in infrastructure management
Burggräf et al. How to Improve Collaboration Efficiency in the Built Environment of Factories by Using an Integrated Factory Modelling Concept–An Expert Study
US20060010081A1 (en) Automated system for assisting the architectural process
CN117707500A (en) Method, system, equipment and storage medium for generating and running business application
CN102779092B (en) Quote check system and quote inspection method
Shentu et al. Mechanism design of data management system for nuclear power
Michie Integration and Co-ordination of Building Services and its Relationship with project Management
CN111914417A (en) Plan and budget simulation analysis system
CN116932540B (en) Substation engineering data management method, device, computer equipment and storage medium
Kambe et al. A Method for Analyzing and Visualizing Intermodule Relations to Support the Reuse‐Based Embedded Software Development
CN114037399A (en) Construction method and system of insurance industry salary management platform
Ding et al. Component-based records: A novel method to record transaction design work

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination