CN112989781B - Form data automatic execution method, device, electronic equipment and storage medium - Google Patents
Form data automatic execution method, device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112989781B CN112989781B CN202110265882.4A CN202110265882A CN112989781B CN 112989781 B CN112989781 B CN 112989781B CN 202110265882 A CN202110265882 A CN 202110265882A CN 112989781 B CN112989781 B CN 112989781B
- Authority
- CN
- China
- Prior art keywords
- user
- data
- automation script
- data table
- filled
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000013515 script Methods 0.000 claims abstract description 121
- 238000004590 computer program Methods 0.000 claims description 5
- 238000000605 extraction Methods 0.000 claims description 2
- 238000012545 processing Methods 0.000 description 36
- 238000004891 communication Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Stored Programmes (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Human Computer Interaction (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Artificial Intelligence (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
Abstract
The application provides an automatic form data execution method, a device, electronic equipment and a storage medium, wherein the method comprises the following steps: providing a form interface to a user based on the form template; receiving field data filled in a form page by a user, and storing the field data in a user application data table; polling the user application data table to obtain form state data as the user application data table to be executed; inquiring a corresponding form template according to the user application data table; acquiring a corresponding automatic script identifier in the form template and a field data name list to be filled in by a user; extracting field data from the user application data table as parameters for executing an automation script; acquiring an automation script, bringing the parameters into the automation script, and executing the automation script; and updating the form state data of the user on the form page according to the execution result of the automation script. The method and the device provided by the application realize automatic execution of form data.
Description
Technical Field
The present application relates to the field of computer application technologies, and in particular, to a form data automatic execution method, an apparatus, an electronic device, and a storage medium.
Background
During the office process of a general employee in an enterprise, various technical faults are often encountered, or along with the development of the business and the office requirement, the employee needs to use various technical related authorities to complete the work. At this time, the staff can report the fault or apply for the relevant authority to the technician through various channels, and then the technician carries out fault processing manually or opens the authority required by the user, but the office flow has a plurality of problems:
1) Because the applicant is not aware of the technical field situation of the company technician, after submitting the report or application requirement, many situations often exist, and the related technician cannot be found to process the own requirement, thereby greatly increasing the communication cost of the report and application and easily delaying the work of the user.
2) When the problems are solved, the problems are often influenced by factors such as the degree of idleness, professional technical capacity, office area and the like of technicians, and the required processing results have errors or cannot be processed in time, so that the working efficiency of staff is influenced.
3) Some requirements are that the operation is performed after the approval by a specific staff, the staff needs to pay attention to the approval result at all times and then inform the technician to perform the operation, so that the communication cost is increased and the office efficiency of the staff is greatly reduced.
In order to avoid the problems of the demand application and the manual processing flow, a user is adopted to enter demand data in a system in a self-help mode, the data submitted by staff is automatically transferred to a corresponding automatic script to be executed and processed, and the processing result is fed back to the user or technical processing staff. Therefore, the whole demand application processing flow can be completed in the shortest time, the office efficiency and service feeling of staff are improved, the communication cost of the staff is reduced, and deviation of processing results caused by office idleness and professional technical capability is avoided.
Disclosure of Invention
In order to overcome the defects in the prior art, the application provides an automatic form data execution method, an automatic form data execution device, electronic equipment and a storage medium, which are used for providing demand application, approval demand, user demand processing and feedback processing results for users, realizing automatic circulation and forming a closed loop through technical means, and finally completing the user demands rapidly.
According to an aspect of the present application, there is provided a form data automatic execution method including:
providing a form interface for a user based on a form template, wherein the form template comprises a form identifier, a corresponding automation script identifier and a field data name list to be filled in by a user;
receiving field data filled in a form page by a user, and storing the field data into a user application data table, wherein the user application data table comprises corresponding form template identifiers, field data filled in by the user and form state data;
polling the user application data table to obtain form state data as the user application data table to be executed;
inquiring a corresponding form template according to the user application data table;
acquiring a corresponding automatic script identifier in the form template and a field data name list to be filled in by a user;
extracting field data filled by a user corresponding to each field data name in a field data name list filled by the user from the user application data table as parameters for executing an automation script;
acquiring an automation script according to the automation script identification, bringing the parameters into the automation script, and executing the automation script;
and updating the form state data of the user on the form page according to the execution result of the automation script.
In some embodiments of the present application, the acquiring an automation script according to the automation script identification, bringing the parameters into the automation script, and executing the automation script includes:
and acquiring service classes of the automation script according to the automation script identification by utilizing a Java reflection mechanism, carrying the parameters into the automation script, and executing the automation script.
In some embodiments of the present application, the user application data table further includes an approval status field, and the receiving field data filled in the form page by the user and storing the field data in the user application data table further includes:
approving field data filled in a form page by a user;
if the approval passes, saving the field data filled in the form page by the user to a user application data table, and setting the approval status field as the approval pass.
In some embodiments of the present application, the polling the user application data table to obtain the form status data as the user application data table to be executed includes:
and polling the user application data table to obtain the user application data table with the form state data to be executed and the approval state field set as approved.
In some embodiments of the present application, the user application data table further includes a failure message, and updating the form status data of the user on the form page according to the execution result of the automation script includes:
judging whether the automation script is executed successfully or not;
if yes, updating the form state data into the form state data which is successfully executed;
if not, updating the form state data into the execution failure, and filling the reasons of the execution failure into the failure message.
In some embodiments of the present application, after updating the form status data to be execution failure and filling the cause of the execution failure into the failure message, the method further includes:
the failure message is sent to the user and/or a technician associated with the automation script.
In some embodiments of the application, the form interface is provided for a user to apply for rights and/or equipment warranties.
According to still another aspect of the present application, there is also provided an automatic form data execution device including:
the system comprises a form template, a providing module and a user interface module, wherein the form template is used for providing a form interface for the user based on the form template, and comprises a form identifier, a corresponding automatic script identifier and a field data name list to be filled in;
the receiving module is used for receiving field data filled in a form page by a user and storing the field data into a user application data table, wherein the user application data table comprises corresponding form template identifiers, field data filled in by the user and form state data;
the polling module is used for polling the user application data table to acquire the form state data as the user application data table to be executed;
the query module is used for querying the corresponding form template according to the user application data table;
the acquisition module is used for acquiring the corresponding automatic script identification in the form template and a field data name list to be filled in by a user;
the extraction module is used for extracting the field data filled by the user corresponding to each field data name in the field data name list filled by the user from the user application data table as parameters for executing the automatic script;
the execution module is used for acquiring an automation script according to the automation script identification, bringing the parameters into the automation script and executing the automation script;
and the updating module is used for updating the form state data of the user on the form page according to the execution result of the automation script.
According to still another aspect of the present application, there is also provided an electronic apparatus including: a processor; a storage medium having stored thereon a computer program which, when executed by the processor, performs the steps of the form data automatic execution method described above.
According to still another aspect of the present application, there is also provided a storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the form data automatic execution method described above.
Compared with the prior art, the application has the advantages that:
1) Communication cost generated by staff in the process of office repair or authority application is reduced or even eliminated to the maximum extent; 2) The deviation of various processing results caused by technical capability or misoperation when technicians are required to process is avoided; 3) The method and the system can enable the demands of the users to be rapidly positioned to the solution, solve the demands of the users in the shortest time, avoid detour and improve the satisfaction degree of the user service.
The application arranges the demands of users into form templates for storage, develops corresponding automatic scripts for various forms, configures the relevance between each form and the automatic script in an expression mode, and the system falls down the database submitted by staff on the page form, correlates the data submitted by the users with the corresponding automatic script through timing tasks and executes the script, and the system records the processing result after the script is executed and finally feeds back to the users and the processing staff. The system uses a fixed flow, rapidly meets various requirements of users, ensures timeliness and accuracy, reduces error rate and lowers cost.
Drawings
The above and other features and advantages of the present application will become more apparent by describing in detail exemplary embodiments thereof with reference to the attached drawings.
Fig. 1 shows a flowchart of a form data automatic execution method according to an embodiment of the present application.
FIG. 2 is a flow chart showing a user application data table according to an embodiment of the present application further including an approval status field, wherein the flow chart is used for receiving field data filled in a form page by a user and storing the field data in the user application data table.
FIG. 3 illustrates a flow chart of updating form status data of the user on a form page according to the execution result of the automation script according to an embodiment of the present application.
Fig. 4 shows a block diagram of the form data automatic execution device according to the embodiment of the present application.
Fig. 5 schematically illustrates a computer-readable storage medium in an exemplary embodiment of the present disclosure.
Fig. 6 schematically illustrates a schematic diagram of an electronic device in an exemplary embodiment of the present disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. However, the exemplary embodiments may be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus a repetitive description thereof will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in software or in one or more hardware modules or integrated circuits or in different networks and/or processor devices and/or microcontroller devices.
In order to overcome the defects of the prior art, users put forward demand application, examine and approve demands, process the demands of the users and feed back processing results, automatic circulation is realized through technical means, a closed loop is formed, and finally the demands of the users are rapidly completed.
Referring first to fig. 1, fig. 1 shows a schematic diagram of a form data automatic execution method according to an embodiment of the present application. The form data automatic execution method comprises the following steps:
step S110: and providing a form interface for the user based on the form template, wherein the form template comprises a form identifier, a corresponding automation script identifier and a field data name list to be filled in by users.
In particular, in some implementations of the application, the user's needs may be categorized into various form templates and entered into the system. The main fields of the form template (FormType) may be set as follows:
the above is merely a field definition manner of a form template schematically illustrating the present application, and the present application is not limited thereto.
Further, step S110 may use java setup to develop web services to provide form pages to users based on form templates (FormType). Specifically, a form page template may be combined, and corresponding fields in the form template may be filled into the form page template, thereby providing the form page to the user. The present application may be implemented in many different ways, and will not be described in detail herein.
Step S120: and receiving field data filled in a form page by a user, and storing the field data in a user application data table, wherein the user application data table comprises corresponding form template identifiers, field data filled in by the user and form state data.
Specifically, a user application data table (RequestInfo) for storing data specifically submitted by a user and for associating form template parameters may be predefined.
The main fields of the user application data table (RequestInfo) can be seen in the following table:
the system can add logic for updating the AuditStatus field in the approval logic aiming at the condition that the user applies for approval. For approval rejection operations, the system may also add logic to notify the user.
Specifically, the java automation script service can be customized and developed in advance for each form template, the name of the java script class must be consistent with the name of the script configured in the script name field in the form template form, and the name of the parameter used for running the script must be consistent with the name of the parameter configured in the parameters in the form template form. Specific processing results and exception details are needed in each automation script processing logic, so that the integrity of the whole processing flow is ensured.
Step S130: and polling the user application data table to acquire form state data as the user application data table to be executed.
Specifically, step S130 may poll and acquire data in the user application data table, which does not obtain the processing result of the automation script, through the timing polling logic. The frequency of polling may be set as desired, for example, 1 minute/time, 30 seconds/time, 10 seconds/time, etc., and the application is not limited in this regard.
Step S140: and inquiring a corresponding form template according to the user application data table.
Specifically, step S140 may correlate the configuration of the query form template with the FormID data in the user application data table. Wherein, the association condition may be set as: requestinfo. Formid=formtype.
Step S150: and acquiring a corresponding automation script identifier in the form template and a field data name list filled in by a user.
Step S160: and extracting field data filled in by the user, which corresponds to each field data name in a field data name list filled in by the user, from the user application data table as parameters for executing the automation script.
Specifically, steps S150 to S160 extract the name of the corresponding automation script and the name list key1, key2 … of the corresponding parameters in the form template, and extract the data value1, value2 … corresponding to the parameter name from the RequestData of the user application data table as the parameters of script execution.
Step S170: and acquiring an automation script according to the automation script identification, carrying the parameters into the automation script, and executing the automation script.
Specifically, step S170 may utilize a Java reflection mechanism to obtain a service class of an automation script according to the automation script identifier, bring the parameter into the automation script, and execute the automation script.
Step S180: and updating the form state data of the user on the form page according to the execution result of the automation script.
Specifically, in step S180, the system drops the results of the execution of the automation script to a library, and feeds back the results to the user by mail or the like.
Further, in various embodiments of the present application, the form interface is provided for a user to apply for rights and/or equipment warranties.
In the form data automatic execution method provided by the application, 1) the communication cost of staff in the office repair or authority application process is reduced or even eliminated to the maximum extent; 2) The deviation of various processing results caused by technical capability or misoperation when technicians are required to process is avoided; 3) The method and the system can enable the demands of the users to be rapidly positioned to the solution, solve the demands of the users in the shortest time, avoid detour and improve the satisfaction degree of the user service. The application arranges the demands of users into form templates for storage, develops corresponding automatic scripts for various forms, configures the relevance between each form and the automatic script in an expression mode, and the system falls down the database submitted by staff on the page form, correlates the data submitted by the users with the corresponding automatic script through timing tasks and executes the script, and the system records the processing result after the script is executed and finally feeds back to the users and the processing staff. The system uses a fixed flow, rapidly meets various requirements of users, ensures timeliness and accuracy, reduces error rate and lowers cost.
Referring now to fig. 2, fig. 2 shows a flowchart of a user application data table according to an embodiment of the present application further including an approval status field, where the field data filled in by the user in the form page is received and saved to the user application data table. In this embodiment, the user application data table further includes an approval status field (e.g., audiostatus shown in the user application data table (RequestInfo)).
In step S120 in fig. 1, receiving field data filled in the form page by the user and storing the field data in the user application data table further includes:
step S121: and approving field data filled in the form page by the user.
Step S122: if the approval passes, saving the field data filled in the form page by the user to a user application data table, and setting the approval status field as the approval pass.
In some embodiments, if the approval is not passed, the field data filled in by the user in the form page may not be stored, and the user may be prompted to refill. In other variations, if the approval fails, the field data filled in by the user in the form page may also be stored, the approval status field may be set to be the approval fails, and the user may be prompted to refill. The present application may implement more variations, and will not be described in detail herein.
Specifically, the approval described herein may be either a manual approval or a systematic automated approval. In the manual approval scenario, step S121 corresponds to transmitting field data filled in by the user in the form page to the terminal of the auditor for auditing, and obtaining the approval result input by the auditor. In embodiments of system automatic approval, authority approval, field data format approval, and the like may be included. Further, in the embodiment of automatic system approval, the above-mentioned different types of approval may be performed according to preset rules. In some specific implementations, the automatic approval can also be implemented by adopting the execution of the custom script, so that the first approval and screening can be performed through the custom script, the data execution amount of the custom script for subsequently processing the data is reduced, the execution efficiency is improved, and the erroneous data is prevented from entering the execution step.
Correspondingly, the step S130 of polling the user application data table to obtain the form status data as the user application data table to be executed includes the following steps: and polling the user application data table to obtain the user application data table with the form state data to be executed and the approval state field set as approved.
Referring now to fig. 3, fig. 3 illustrates a flowchart of updating form status data of the user on a form page according to an execution result of the automation script according to an embodiment of the present application. In this embodiment, the user application data table further includes a failure Message (Message shown in the user application data table (RequestInfo)). In step S180 in fig. 1, updating the form status data of the user on the form page according to the execution result of the automation script includes:
step S181: judging whether the automation script is executed successfully or not;
if yes in step S181, step S182 is executed: updating the form state data to be successfully executed;
if step S181 determines no, step S183 is executed: and updating the form state data into execution failure, and filling the reasons of the execution failure into the failure message.
Further, in the above embodiment, the step S182 may further include the following steps: the failure message is sent to the user and/or technician associated with the automation script to facilitate further processing by the technician.
The method solves the problem that a plurality of IT application requirements of staff in the office process are not influenced by professional capability of technical staff any more, staff is not required to communicate and search for the processing requirements of IT technical staff, and users can quickly and self-help realize own requirements.
When a user applies for opening rights, only the rights related information of the application is submitted on the page, and the system can quickly find out the script of the opening rights and execute the script to obtain a feedback result. No communication work is needed in the process, so that the working efficiency of staff is greatly improved, and the labor cost is relatively greatly reduced.
The foregoing is merely illustrative of various implementations of the application, and the application is not limited thereto.
The application also provides an automatic form data executing device, and fig. 4 shows a schematic diagram of the automatic form data executing device according to the embodiment of the application. The form data automatic execution device 200 includes a providing module 210, a receiving module 220, a polling module 230, a querying module 240, an obtaining module 250, an extracting module 260, an executing module 270, and an updating module 280.
The providing module 210 is configured to provide a form interface to a user based on a form template, where the form template includes a form identifier, a corresponding automation script identifier, and a list of field data names to be filled in;
the receiving module 220 is configured to receive field data filled in a form page by a user, and store the field data in a user application data table, where the user application data table includes a corresponding form template identifier, field data filled in by the user, and form status data;
the polling module 230 is configured to poll the user application data table to obtain form status data as a user application data table to be executed;
the query module 240 is configured to query a corresponding form template according to the user application data table;
the obtaining module 250 is configured to obtain a corresponding automation script identifier in the form template and a field data name list to be filled in by a user;
the extracting module 260 is configured to extract, from the user application data table, field data filled in by the user corresponding to each field data name in the field data name list to be filled in by the user, as parameters for executing the automation script;
the execution module 270 is configured to obtain an automation script according to the automation script identifier, bring the parameters into the automation script, and execute the automation script;
the updating module 280 is configured to update the form status data of the user on the form page according to the execution result of the automation script.
In the form data automatic execution device provided by the application, 1) the communication cost of staff in the process of office repair or authority application is reduced or even eliminated to the maximum extent; 2) The deviation of various processing results caused by technical capability or misoperation when technicians are required to process is avoided; 3) The method and the system can enable the demands of the users to be rapidly positioned to the solution, solve the demands of the users in the shortest time, avoid detour and improve the satisfaction degree of the user service. The application arranges the demands of users into form templates for storage, develops corresponding automatic scripts for various forms, configures the relevance between each form and the automatic script in an expression mode, and the system falls down the database submitted by staff on the page form, correlates the data submitted by the users with the corresponding automatic script through timing tasks and executes the script, and the system records the processing result after the script is executed and finally feeds back to the users and the processing staff. The system uses a fixed flow, rapidly meets various requirements of users, ensures timeliness and accuracy, reduces error rate and lowers cost.
Fig. 4 is a schematic diagram only, and the form data automatic execution device provided by the application is capable of splitting, combining and adding modules without departing from the scope of the application. The form data automatic execution device provided by the application can be realized by any combination of software, hardware, firmware, plug-in units and the like, and the application is not limited to the above.
In an exemplary embodiment of the present disclosure, there is also provided a computer-readable storage medium having stored thereon a computer program which, when executed by, for example, a processor, can implement the steps of the form data automatic execution method described in any one of the above embodiments. In some possible embodiments, the aspects of the present application may also be implemented in the form of a program product comprising program code for causing a terminal device to carry out the steps according to the various exemplary embodiments of the application as described in the form data automatic execution method section of this specification, when said program product is run on the terminal device.
Referring to fig. 5, a program product 400 for implementing the above-described method according to an embodiment of the present application is described, which may employ a portable compact disc read-only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present application is not limited thereto, and in this document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium can be, for example, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium would include the following: an electrical connection having one or more wires, a portable disk, a hard disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
The computer readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, with readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A readable storage medium may also be any readable medium that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations of the present application may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the tenant computing device, partially on the tenant device, as a stand-alone software package, partially on the tenant computing device, partially on a remote computing device, or entirely on a remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the tenant computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected through the internet using an internet service provider).
In an exemplary embodiment of the present disclosure, an electronic device is also provided, which may include a processor, and a memory for storing executable instructions of the processor. Wherein the processor is configured to execute the steps of the form data automatic execution method in any of the above embodiments via execution of the executable instructions.
Those skilled in the art will appreciate that the various aspects of the application may be implemented as a system, method, or program product. Accordingly, aspects of the application may be embodied in the following forms, namely: an entirely hardware embodiment, an entirely software embodiment (including firmware, micro-code, etc.) or an embodiment combining hardware and software aspects may be referred to herein as a "circuit," module "or" system.
An electronic device 600 according to this embodiment of the application is described below with reference to fig. 6. The electronic device 600 shown in fig. 6 is merely an example, and should not be construed as limiting the functionality and scope of use of embodiments of the present application.
As shown in fig. 6, the electronic device 600 is in the form of a general purpose computing device. Components of electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different system components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program codes that can be executed by the processing unit 610, so that the processing unit 610 performs the steps according to various exemplary embodiments of the present application described in the above-described form data automatic execution method section of the present specification. For example, the processing unit 610 may perform the steps as shown in fig. 1 to 3.
The memory unit 620 may include readable media in the form of volatile memory units, such as Random Access Memory (RAM) 6201 and/or cache memory unit 6202, and may further include Read Only Memory (ROM) 6203.
The storage unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment.
Bus 630 may be a local bus representing one or more of several types of bus structures including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or using any of a variety of bus architectures.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), one or more devices that enable a tenant to interact with the electronic device 600, and/or any device (e.g., router, modem, etc.) that enables the electronic device 600 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 650. Also, electronic device 600 may communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet, through network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 over the bus 630. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with electronic device 600, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Accordingly, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a nonvolatile storage medium (may be a CD-ROM, a usb disk, a mobile hard disk, etc.) or on a network, and include several instructions to cause a computing device (may be a personal computer, a server, or a network device, etc.) to perform the form data automatic execution method according to the embodiments of the present disclosure.
Compared with the prior art, the application has the advantages that:
1) Communication cost generated by staff in the process of office repair or authority application is reduced or even eliminated to the maximum extent; 2) The deviation of various processing results caused by technical capability or misoperation when technicians are required to process is avoided; 3) The method and the system can enable the demands of the users to be rapidly positioned to the solution, solve the demands of the users in the shortest time, avoid detour and improve the satisfaction degree of the user service.
The application arranges the demands of users into form templates for storage, develops corresponding automatic scripts for various forms, configures the relevance between each form and the automatic script in an expression mode, and the system falls down the database submitted by staff on the page form, correlates the data submitted by the users with the corresponding automatic script through timing tasks and executes the script, and the system records the processing result after the script is executed and finally feeds back to the users and the processing staff. The system uses a fixed flow, rapidly meets various requirements of users, ensures timeliness and accuracy, reduces error rate and lowers cost.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (8)
1. An automatic form data execution method is characterized by comprising the following steps:
providing a form interface for a user based on a form template, wherein the form template comprises a form identifier, a corresponding automation script identifier and a field data name list to be filled in by a user;
receiving field data filled in a form page by a user, and storing the field data into a user application data table, wherein the user application data table comprises corresponding form template identifications, field data filled in by the user, form state data and approval state fields, and the method specifically comprises the following steps of: approving field data filled in a form page by a user; if the approval passes, saving field data filled in the form page by the user to a user application data table, and setting the approval status field as the approval pass;
polling a user application data table to obtain form state data as a user application data table to be executed, wherein the method specifically comprises the following steps: polling a user application data table to obtain the form state data as a user application data table to be executed and setting an approval state field as approval passing;
inquiring a corresponding form template according to the user application data table;
acquiring a corresponding automatic script identifier in the form template and a field data name list to be filled in by a user;
extracting field data filled by a user corresponding to each field data name in a field data name list filled by the user from the user application data table as parameters for executing an automation script;
acquiring an automation script according to the automation script identification, bringing the parameters into the automation script, and executing the automation script;
and updating the form state data of the user on the form page according to the execution result of the automation script.
2. The automatic form data execution method of claim 1, wherein the acquiring an automation script according to the automation script identification, bringing the parameters into the automation script, and executing the automation script comprises:
and acquiring service classes of the automation script according to the automation script identification by utilizing a Java reflection mechanism, carrying the parameters into the automation script, and executing the automation script.
3. The automatic form data execution method according to claim 1, wherein the user application data table further includes a failure message, and updating the form status data of the user on the form page according to the execution result of the automation script includes:
judging whether the automation script is executed successfully or not;
if yes, updating the form state data into the form state data which is successfully executed;
if not, updating the form state data into the execution failure, and filling the reasons of the execution failure into the failure message.
4. The automatic form data execution method according to claim 3, wherein after updating the form status data to the execution failure and filling the cause of the execution failure into the failure message, further comprising:
the failure message is sent to the user and/or a technician associated with the automation script.
5. The form data automatic execution method according to any one of claims 1 to 4, wherein the form interface is provided for a user to apply for rights and/or equipment warranty.
6. An automatic form data execution device, characterized by comprising:
the system comprises a form template, a providing module and a user interface module, wherein the form template is used for providing a form interface for the user based on the form template, and comprises a form identifier, a corresponding automatic script identifier and a field data name list to be filled in;
the receiving module is used for receiving field data filled in a form page by a user and storing the field data into a user application data table, wherein the user application data table comprises corresponding form template identifications, field data filled in by the user, form state data and approval state fields, and the receiving module specifically comprises: approving field data filled in a form page by a user; if the approval passes, saving field data filled in the form page by the user to a user application data table, and setting the approval status field as the approval pass;
the polling module is used for polling the user application data table to acquire the form state data as the user application data table to be executed, and specifically comprises the following steps: polling a user application data table to obtain the form state data as a user application data table to be executed and setting an approval state field as approval passing;
the query module is used for querying the corresponding form template according to the user application data table;
the acquisition module is used for acquiring the corresponding automatic script identification in the form template and a field data name list to be filled in by a user;
the extraction module is used for extracting the field data filled by the user corresponding to each field data name in the field data name list filled by the user from the user application data table as parameters for executing the automatic script;
the execution module is used for acquiring an automation script according to the automation script identification, bringing the parameters into the automation script and executing the automation script;
and the updating module is used for updating the form state data of the user on the form page according to the execution result of the automation script.
7. An electronic device, the electronic device comprising:
a processor;
a storage medium having stored thereon a computer program which, when executed by the processor, performs the form data automatic execution method according to any one of claims 1 to 5.
8. A storage medium having stored thereon a computer program which, when executed by a processor, performs the form data automatic execution method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110265882.4A CN112989781B (en) | 2021-03-11 | 2021-03-11 | Form data automatic execution method, device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110265882.4A CN112989781B (en) | 2021-03-11 | 2021-03-11 | Form data automatic execution method, device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112989781A CN112989781A (en) | 2021-06-18 |
| CN112989781B true CN112989781B (en) | 2023-11-24 |
Family
ID=76336373
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110265882.4A Active CN112989781B (en) | 2021-03-11 | 2021-03-11 | Form data automatic execution method, device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112989781B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023115397A1 (en) * | 2021-12-22 | 2023-06-29 | 华为技术有限公司 | Method and apparatus for generating automated script |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102460441A (en) * | 2009-06-15 | 2012-05-16 | 弗里塞恩公司 | Method and system for auditing transaction data from database operations |
| CN107423061A (en) * | 2017-07-12 | 2017-12-01 | 江苏速度信息科技股份有限公司 | A kind of list generation method based on ISON data |
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
| CN111966673A (en) * | 2020-08-18 | 2020-11-20 | 深圳市维度统计咨询股份有限公司 | Big data based data auditing method and device and storage medium |
| CN112036824A (en) * | 2020-08-27 | 2020-12-04 | 北京新橙科技有限公司 | Business approval method, system, storage medium and electronic equipment |
| CN112116325A (en) * | 2020-09-17 | 2020-12-22 | 云账户技术(天津)有限公司 | Examination and approval form control method and device, electronic equipment and readable storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11184414B2 (en) * | 2018-12-07 | 2021-11-23 | Slack Technologies, Llc | Reservation management for client-initiated polling requests in a communication system |
| US10942765B2 (en) * | 2019-01-15 | 2021-03-09 | Mastercard International Incorporated | Automated monitoring and auditing failed and recovered batch data tasks |
-
2021
- 2021-03-11 CN CN202110265882.4A patent/CN112989781B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102460441A (en) * | 2009-06-15 | 2012-05-16 | 弗里塞恩公司 | Method and system for auditing transaction data from database operations |
| CN107423061A (en) * | 2017-07-12 | 2017-12-01 | 江苏速度信息科技股份有限公司 | A kind of list generation method based on ISON data |
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
| CN111966673A (en) * | 2020-08-18 | 2020-11-20 | 深圳市维度统计咨询股份有限公司 | Big data based data auditing method and device and storage medium |
| CN112036824A (en) * | 2020-08-27 | 2020-12-04 | 北京新橙科技有限公司 | Business approval method, system, storage medium and electronic equipment |
| CN112116325A (en) * | 2020-09-17 | 2020-12-22 | 云账户技术(天津)有限公司 | Examination and approval form control method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112989781A (en) | 2021-06-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110018955B (en) | Generating automated test scripts by transforming manual test cases | |
| CN109582301B (en) | Service processing method, device, equipment and medium based on task scheduling system | |
| US11294661B2 (en) | Updating a code file | |
| US20180217921A1 (en) | System and method for generating and executing automated test cases | |
| CN103999047B (en) | repair delivery system | |
| CN108845940B (en) | Enterprise-level information system automatic function testing method and system | |
| CN108319575B (en) | Page component checking method, device, server and storage medium | |
| US20130054792A1 (en) | Cloud-based performance testing of functionality of an application prior to completion of development | |
| CN114981775B (en) | Cloud-based API metadata management method and system for integrated API management | |
| CN110837356B (en) | Data processing method and device | |
| CN109977012B (en) | Joint debugging test method, device, equipment and computer readable storage medium of system | |
| CN107665204B (en) | Method and device for providing form | |
| CN115658529A (en) | Automatic testing method for user page and related equipment | |
| CN113706022A (en) | Business process execution method and device, storage medium and electronic equipment | |
| CN112989781B (en) | Form data automatic execution method, device, electronic equipment and storage medium | |
| CN115630835A (en) | Activity-based workflow general parameter configuration method and system | |
| CN113656304B (en) | Testing method, device and storage medium of front-end application program | |
| WO2013054296A2 (en) | Enterprise resource planning system | |
| CN112988578A (en) | Automatic testing method and device | |
| EP3818445B1 (en) | Automated control of distributed computing devices | |
| CN115658127A (en) | Data processing method and device, electronic equipment and storage medium | |
| WO2023277802A2 (en) | Device and method for identifying errors in a software application | |
| KR100969877B1 (en) | Test automating system | |
| CN113360232A (en) | Task processing method and device, electronic equipment and storage medium | |
| CN110543424B (en) | Test method and device for electronic tax platform |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |