Work order processing method and device
By determining the work ticket task information and target table, analyzing and generating target work tickets, and combining status and verification information for circulation and verification, the problem of cumbersome and low efficiency of work ticket generation operation process is solved, and efficient and accurate work ticket generation and circulation.
Patent Information
- Application Number
- CN202411390994.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-30
- Publication Date
- 2025-01-17
AI Technical Summary
When generating multiple work orders, the prior art causes cumbersome operational processes and low efficiency, especially when multiple work orders correspond to the same task type, multiple generation operations need to be repeated, resulting in low efficiency.
By determining the task information of the work order task task, including row data templates, table information and verification information, obtaining the target table and analyzing the work order records, generating the target work order, and performing the flow verification process based on the status information and verification information, simplifying the generation of work orders The operation process supports batch generation.
It has achieved simplified the operation process of work order generation, improved the efficiency of work order generation, and ensured the accuracy and compliance of work orders during the circulation process.
Smart Images
Figure CN119323407A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a work order processing method and device. Background Art
[0002] A work order usually refers to a file that includes operation events, operation procedures, etc. Work orders are used to track the execution of tasks and ensure that related work can proceed in an orderly manner. When multiple work orders need to be generated, even if the multiple work orders to be generated correspond to the same task type, the relevant personnel have to repeat the work order generation operation multiple times. The operation process of generating work orders is cumbersome and the work order generation efficiency is low. Summary of the invention
[0003] In view of this, an embodiment of the present invention provides a work order processing method and device, which can simplify the operation process of generating a work order and improve the efficiency of generating a work order.
[0004] In a first aspect, an embodiment of the present invention provides a work order processing method, including:
[0005] Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information;
[0006] According to the table information, a target table is obtained; wherein the target table includes: at least one row of work order records;
[0007] For each work order record, parse the work order data corresponding to the work order record; generate the target work order corresponding to the work order record based on the work order data and row data template;
[0008] Based on the status information and verification information of each target work order, each target work order is subjected to flow verification processing.
[0009] Optionally, parse the work order data corresponding to the work order record, including:
[0010] Parse the header of the target table to obtain multiple table fields, and determine a first mapping relationship between the table fields and the column numbers;
[0011] Parse the work order record to obtain multiple work order field values of the work order record, and determine a second mapping relationship between the work order field value and the column sequence number;
[0012] Generate multiple key-value pairs according to the first mapping relationship and the second mapping relationship; wherein the key-value pairs include: a table field and its corresponding work order field value;
[0013] Combine multiple key-value pairs to generate the work order data corresponding to the work order record.
[0014] Optionally, a target work order corresponding to the work order record is generated according to the work order data and the row data template, including:
[0015] Obtain multiple key-value pairs corresponding to the work order data; wherein the key-value pairs include: table fields and their corresponding work order field values;
[0016] Get multiple replacement identifiers in the row data template;
[0017] For each replacement identifier, determine the target table field corresponding to the replacement identifier; determine the target key-value pair corresponding to the target table field; replace the replacement identifier in the row data template with the target field value in the target key-value pair;
[0018] The row data template after replacement processing is determined as the target work order corresponding to the work order record.
[0019] Optionally, after obtaining the target table according to the table information, the following steps are further included:
[0020] Verify the data format of the target table;
[0021] In response to the target table failing the data format verification, a warning message for the target table is generated.
[0022] Optionally, after generating a target work order corresponding to the work order record according to the work order data and the row data template, the following further includes:
[0023] Receive a preview instruction for the work order record, and display the target work order corresponding to the work order record;
[0024] In response to receiving a modification instruction for the work order record, displaying the work order record; receiving an edit instruction for the work order record, and modifying the work order record according to the edit instruction;
[0025] In response to receiving a confirmation instruction for a work order record, it is determined that the status information representation of the target work order is to be confirmed.
[0026] Optionally, according to the status information and verification information of each target work order, a flow verification process is performed on each target work order, including:
[0027] In response to the status information of the target work order indicating that confirmation is pending, determining a follow-up rule in the verification information;
[0028] In response to the target work order not meeting the follow-up rule, determining a follow-up person of the target work order, and sending a follow-up reminder message to the follow-up person;
[0029] In response to the target work order meeting the follow-up rule, determining that the status information of the target work order indicates confirmation of follow-up.
[0030] Optionally, after generating a target work order corresponding to the work order record according to the work order data and the row data template, the following further includes:
[0031] In response to the status information representation of the target work order, confirm the follow-up, determine the processor of the target work order, and send a processing reminder message to the processor;
[0032] Receive processing requests from processors for target work orders;
[0033] According to the processing request, information processing is performed on the target work order, and it is determined that the status information representation of the target work order has been completed.
[0034] Optionally, according to the status information and verification information of each target work order, a flow verification process is performed on each target work order, including:
[0035] In response to the status information indicating that the target work order has been completed, determining a check rule corresponding to the verification information;
[0036] In response to the target work order meeting the inspection rule, determining that the status information of the target work order indicates that it has passed the inspection;
[0037] In response to the target work order failing to pass the inspection rule, a return reminder message is sent to a handler of the target work order, and it is determined that the status information of the target work order represents a return.
[0038] In a second aspect, an embodiment of the present invention provides a work order processing device, including:
[0039] The information determination module is used to determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information;
[0040] The table acquisition module is used to acquire a target table according to the table information; wherein the target table includes: at least one row of work order records;
[0041] The work order generation module is used to parse the work order data corresponding to each work order record; generate the target work order corresponding to the work order record according to the work order data and the row data template;
[0042] The flow verification module is used to perform flow verification processing on each target work order based on the status information and verification information of each target work order.
[0043] In a third aspect, an embodiment of the present invention provides an electronic device, including:
[0044] one or more processors;
[0045] The storage device is used to store one or more programs. When the one or more programs are executed by one or more processors, the one or more processors implement the method of any of the above embodiments.
[0046] In a fourth aspect, an embodiment of the present invention provides a computer-readable medium having a computer program stored thereon, and when the program is executed by a processor, the method of any of the above embodiments is implemented.
[0047] In a fifth aspect, an embodiment of the present invention provides a computer program product, including a computer program, which implements the method of any of the above embodiments when the computer program is executed by a processor.
[0048] An embodiment of the above invention has the following advantages or beneficial effects: setting a work order task and its corresponding target table. The task information of the work order task includes: a row data template. The row data template is set according to the display style of the work order. The target table includes: at least one row of work order records. The work order record is used to save the relevant information for generating the work order. According to the work order data and the row data template corresponding to each work order record, the target work order corresponding to each work order record is generated. It is possible to generate multiple work orders in batches, simplify the operation process of generating work orders, and improve the efficiency of generating work orders.
[0049] In addition, work order tasks also correspond to verification information. By verifying the information, the accuracy and compliance of the target work order during the circulation process can be guaranteed.
[0050] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.
[0052] Figure 1 It is a schematic diagram of a process of a work order processing method provided by an embodiment of the present invention;
[0053] Figure 2 is a schematic diagram of a process of a work order processing method provided by another embodiment of the present invention;
[0054] Figure 3 is a schematic diagram of a process of a work order processing method provided by another embodiment of the present invention;
[0055] Figure 4 It is a structural schematic diagram of a work order system provided by an embodiment of the present invention;
[0056] Figure 5 It is a structural schematic diagram of a work order processing device provided by an embodiment of the present invention;
[0057] Figure 6 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION
[0058] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.
[0059] It should be noted that the acquisition, storage, use, and processing of data in the technical solutions of the embodiments of the present invention are in compliance with the relevant provisions of national laws and regulations.
[0060] Figure 1 FIG. 1 is a schematic diagram of a work order processing method provided by an embodiment of the present invention. Figure 1 As shown, the method includes:
[0061] Step 101: Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information.
[0062] Work order tasks correspond to work order types. Users can batch generate multiple work orders corresponding to the same work order type by constructing work order tasks. The work order type can be set according to needs. The work order type can be: warehouse sorting work order, cross-team collaboration work order, questionnaire work order, etc.
[0063] Work orders of the same task type all have the same display style. Row data templates can be generated based on work orders of the task type. Row data templates include multiple replacement identifiers. Replace the personalized information in the work order corresponding to the work order type with the replacement identifier to generate a row data template corresponding to the work order type. Personalized information is information that has different values in different work orders of the same work order type.
[0064] Each replacement identifier included in the row data template is replaced with the work order information corresponding to the work order record, that is, the work order corresponding to the work order record is generated.
[0065] Verification information is used to verify the flow of work orders. Verification information may include: data format verification rules, follow-up rules, inspection rules, etc.
[0066] Step 102: Obtain a target table according to the table information; wherein the target table includes: at least one row of work order records.
[0067] The table information may include: table name, table address, etc. The target table is used to store the work order information of at least one work order corresponding to the same work order type. The target table includes: a table header and at least one row of work order records. The table header is used to parse to obtain multiple table fields. The table fields can be set according to requirements. The table fields may include: row unique key, work order follow-up person, work order processor, work order checker, processing content, limited date, etc. Among them, the row unique key is used to identify each work order record.
[0068] The work order record is used to save the relevant information of the generated work order. Each work order record generates its corresponding work order independently. By parsing the work order record, multiple work order field values of the work order record can be obtained. The work order field values can correspond to the table fields to obtain the personalized information corresponding to the work order record.
[0069] Step 103: For each work order record, parse the work order data corresponding to the work order record; and generate a target work order corresponding to the work order record according to the work order data and the row data template.
[0070] Parse the work order record to obtain the work order data. Replace the identifier replacement in the row data template with the corresponding value in the work order data to generate the target work order corresponding to the work order record. Each work order record generates an independent work order.
[0071] Step 104: Perform flow verification processing on each target work order based on the status information and verification information of each target work order.
[0072] Status information can represent pending confirmation, confirmation follow-up, completed, passed inspection, returned, etc. The status information and verification information of the work order can ensure the accuracy and compliance of the target work order during the circulation process.
[0073] In the scheme of the embodiment of the present invention, a work order task and its corresponding target table are set. The task information of the work order task includes: a row data template. The target table includes: at least one row of work order records. According to the work order data and the row data template corresponding to each work order record, a target work order corresponding to each work order record is generated. It is possible to generate multiple work orders in batches, simplify the operation process of generating work orders, and improve the efficiency of generating work orders.
[0074] In the scheme of the embodiment of the present invention, parsing the work order data corresponding to the work order record includes: parsing the header of the target table to obtain multiple table fields, and determining a first mapping relationship between the table fields and the column numbers; parsing the work order record to obtain multiple work order field values of the work order record, and determining a second mapping relationship between the work order field values and the column numbers; generating multiple key-value pairs based on the first mapping relationship and the second mapping relationship; wherein the key-value pairs include: table fields and their corresponding work order field values; and combining multiple key-value pairs to generate the work order data corresponding to the work order record.
[0075] Generate a target work order corresponding to the work order record according to the work order data and the row data template, including: obtaining multiple key-value pairs corresponding to the work order data; wherein the key-value pairs include: table fields and their corresponding work order field values; obtaining multiple replacement identifiers in the row data template; for each replacement identifier, determining the target table field corresponding to the replacement identifier; determining the target key-value pair corresponding to the target table field; replacing the replacement identifier in the row data template with the target field value in the target key-value pair; and determining the replaced row data template as the target work order corresponding to the work order record.
[0076] For example, the target table has 4 columns, namely 1, 2, 3 and 4. Parse the header in column 1, and the table field obtained is the row unique key. Parse the header in column 2, and the table field obtained is the work order follower. Parse the header in column 3, and the table field obtained is the work order handler. Parse the header in column 4, and the table field obtained is the work order inspector. It can be determined that the first mapping relationship includes: the row unique key corresponds to column 1, the work order follower corresponds to column 2, the work order handler corresponds to column 3, and the work order inspector corresponds to column 4.
[0077] The target table includes the first work order record. Parse the first work order record in column 1 to obtain ID1. Parse the first work order record in column 2 to obtain follow-up person 1. Parse the first work order record in column 3 to obtain handler 1. Parse the first work order record in column 4 to obtain inspector 1. It can be determined that the second mapping relationship includes: ID1 corresponds to column 1, follow-up person 1 corresponds to column 2, handler 1 corresponds to column 3, and inspector 1 corresponds to column 4.
[0078] According to the first mapping relationship and the second mapping relationship, the key-value pairs obtained include: the row unique key corresponds to ID1, the work order follower corresponds to follower 1, the work order processor corresponds to processor 1, and the work order inspector corresponds to inspector 1. It can be seen that ID1 is used to uniquely identify the first work order record, follower 1 is the work order follower in the work order corresponding to the first work order record, processor 1 is the work order processor in the work order corresponding to the first work order record, and inspector 1 is the work order inspector in the work order corresponding to the first work order record.
[0079] The row data template includes three replacement identifiers, namely identifier 1, identifier 2 and identifier 3. Different identifiers correspond to different table fields. Among them, identifier 1 corresponds to the work order follower, identifier 2 corresponds to the work order processor, and identifier 3 corresponds to the work order checker. When generating the target work order corresponding to the first work order record, replace identifier 1 in the row data template with follower 1, identifier 2 with processor 1, and identifier 3 with checker 1 to generate the target work order corresponding to the first work order record.
[0080] In the scheme of the embodiment of the present invention, the rows and columns of the target table are similar to the rows and columns of the database. The column sequence number is set for the target table, and the work order record data is parsed row by row to obtain the personalized content in the target table. The column sequence number is matched with the parsed row data, and the cell data of a row and a column in the target table can be accurately obtained.
[0081] Use custom row data templates to create personalized work orders in batches. The row data template is combined with the table row data to generate personalized work order data. The template engine uses the row data template with replacement identifiers to output text without replacement identifiers based on the work order data parsed by the work order records. Since each row of work order records is different, the template engine converts different work order records into personalized text, and then creates work orders according to the work order records to form personalized work orders.
[0082] It should be noted that the column number can be set according to the file type and specific requirements of the target table. For example, the column number can also be column A, column B, column C, etc.
[0083] Figure 2 FIG. 1 is a schematic diagram of a work order processing method provided by another embodiment of the present invention. Figure 2 As shown, the method includes:
[0084] Step 201: Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information.
[0085] Step 202: Obtain a target table according to the table information; wherein the target table includes: at least one row of work order records.
[0086] Step 203: Perform data format verification on the target table.
[0087] Data format verification can be performed through data format verification rules. Data format verification rules may include: whether the table header is configured, whether there is a work order record, whether the row unique key of each row of the work order record is empty, whether the row unique key of each row of the work order record is repeated, whether the work order processor, follow-up person or checker of each row of the work order record is empty, etc.
[0088] If the target table fails the data format check, step 204 is executed. If the target table passes the data format check, step 205 is executed.
[0089] Step 204: Generate warning information for the target table, receive edits for the target table; receive edit instructions for the target table, and modify the target table according to the edit instructions.
[0090] The user can modify the target table online through the edit command. The user can also preview the content in the target table through the preview command to confirm whether the content in the target table is correct. In addition, after the warning information for the target table is generated, the ignore command sent by the user can also be received, and step 205 is executed.
[0091] After the work order record is modified according to the editing instruction, the target table may be directly parsed to execute step 205 , or the data format of the modified target table may be checked to execute step 203 .
[0092] Step 205: For each work order record, parse the work order data corresponding to the work order record; and generate a target work order corresponding to the work order record according to the work order data and the row data template.
[0093] Step 206: Perform flow verification processing on each target work order based on the status information and verification information of each target work order.
[0094] In the solution of the embodiment of the present invention, before parsing the target table, the data format of the target table is checked, which, on the one hand, ensures that the subsequent parsing process can be executed smoothly, and on the other hand, makes the data in the generated target work order have higher accuracy.
[0095] Figure 3 FIG. 1 is a schematic diagram of a work order processing method provided by another embodiment of the present invention. Figure 3 As shown, the method includes:
[0096] Step 301: Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information.
[0097] Step 302: Obtain a target table according to the table information; wherein the target table includes: at least one row of work order records.
[0098] Step 303: for each work order record, parse the work order data corresponding to the work order record; and generate a target work order corresponding to the work order record according to the work order data and the row data template.
[0099] Step 304: Receive a preview instruction for the work order record, and display the target work order corresponding to the work order record.
[0100] If a modification instruction for the work order record is received, the user needs to modify the work order record, and step 305 is executed. If a confirmation instruction for the work order record is received, the work order record does not need to be modified, and step 307 is executed.
[0101] Step 305: receiving a modification instruction for the work order record and displaying the work order record; receiving an edit instruction for the work order record and modifying the work order record according to the edit instruction.
[0102] Users can modify work order records online through modification instructions.
[0103] Step 306: parse the work order data corresponding to the modified work order record; generate a target work order corresponding to the work order record according to the work order data and the row data template.
[0104] After generating a target work order corresponding to the work order record according to the work order data and the row data template, step 304 may be re-executed so that the user can preview the target work order corresponding to the modified work order record.
[0105] It should be noted that the process from step 304 to step 306 may be repeated multiple times until a confirmation instruction for the work order record is received.
[0106] Step 307: receiving a confirmation instruction for the work order record, and determining that the status information representation of the target work order is to be confirmed.
[0107] Step 308: Perform flow verification processing on the target work order based on the status information and verification information of the target work order.
[0108] In the solution of the embodiment of the present invention, after generating the target work order corresponding to the work order record, the user can preview the target work order and adjust the work order record online until a work order that meets the business needs is generated. Using the solution of the embodiment of the present invention, the user can efficiently and conveniently generate various required work orders and flexibly adjust the work order according to the business.
[0109] In one embodiment of the present invention, a flow verification process is performed on each target work order based on the status information and verification information of each target work order, including: in response to the status information of the target work order indicating that it is pending confirmation, determining the follow-up rules in the verification information; in response to the target work order not meeting the follow-up rules, determining the follower of the target work order and sending a follow-up reminder message to the follower; in response to the target work order meeting the follow-up rules, determining that the status information of the target work order indicates confirmation of follow-up.
[0110] Follow-up rules can be set according to business needs. The rules may include: whether the follow-up person confirms the follow-up, whether the direct leader confirms the follow-up, whether the department confirms the follow-up, etc. If the target work order does not meet the follow-up rules, the follow-up person is urged to follow up quickly. By following up and verifying each target work order, it is ensured that the target work order can be steadily executed according to the preset process.
[0111] In one embodiment of the present invention, after generating a target work order corresponding to the work order record based on the work order data and the row data template, it also includes: confirming follow-up in response to the status information representation of the target work order, determining the handler of the target work order, and sending a processing reminder message to the handler; receiving the handler's processing request for the target work order; performing information processing on the target work order based on the processing request, and determining that the status information representation of the target work order has been completed.
[0112] After the status information representation of the target work order is confirmed and followed up, the processor can perform corresponding business processing on the work order and fill in the relevant information into the target work order or target form to complete the processor's flow processing of the target work order.
[0113] In one embodiment of the present invention, a flow verification process is performed on each target work order based on the status information and verification information of each target work order, including: in response to the status information representation of the target work order being completed, determining the inspection rules corresponding to the verification information; in response to the target work order complying with the inspection rules, determining that the status information representation of the target work order has passed the inspection; in response to the target work order failing the inspection rules, sending a return reminder message to the person who handled the target work order, and determining that the status information representation of the target work order is returned.
[0114] After the status information representation of the target work order has been completed, determine the inspection rules corresponding to the verification information. The inspection rules can be set according to business needs, and the inspection rules may include: whether the XX information is empty, whether the XX date is within the preset range, etc. If the target work order meets the inspection rules, determine that the status information representation of the target work order has passed the inspection. If the target work order does not pass the inspection rules, send a return reminder message to the processor of the target work order, and determine that the status information representation of the target work order is returned. The processor performs subsequent business processing on the target work order based on the return reminder message.
[0115] After the target work order is generated, different work order verification processes can be executed according to the verification information of the target task. Whether it is checking the content filled in the target table, calling the interface to check the response data, or sending a notification message first and then asynchronously calling the interface to check the response data, etc., the configured verification information will be used to generate a rule expression for verification. If the verification passes, the work order approval process is triggered. If the verification fails, the work order is returned and the processor reprocesses it.
[0116] Figure 4 FIG. 1 is a schematic diagram of a work order system provided by an embodiment of the present invention. Figure 4As shown in the figure, business scenarios correspond to relevant scenarios where the work order system can be applied, such as application health management, confirming application responsible persons, etc. The batch processing system is the function of the work order system, such as batch processing tasks, table parsing, etc. The technical dependency is the external system or component that the work order system depends on. The technical dependency part includes: database, MQ (message queue, Message queue), etc.
[0117] based on Figure 4 The work order system shown in the figure, the embodiment of the present invention also provides a work order processing method, the method comprising the following steps:
[0118] Step 1. The operator collects and organizes the data and fills it into the target table. Configure the header for the target table according to certain rules. The header must contain the row unique key. The header can also include fields such as work order follow-up person, work order processor, and work order inspector. In actual scenarios, the required fields in the header can be adjusted as appropriate. Usually, the first column of the header is the row unique key. The program identifies the header row from the target table by identifying the identification character corresponding to the row unique key.
[0119] In the target table, each work order record is placed under the header row. The naming of the header is as follows: fieldCode=appCode. The program reads the content of the header and intercepts the data after "fieldCode=" as the table field. The table field is used to associate all work order records and generate the corresponding work order data. The subsequent template engine and rule engine will reference the table field as the basis for data filling and logical judgment.
[0120] Step 2: The operator creates a new work order task and maintains the task information of the work order task, including: task name, description, row data template, target table address, verification information, etc.
[0121] Step 3. After creating a work order task, the user can import the target table with one click on the page. The data format of the target table will be verified during import, and any abnormalities will be fed back to the operator. After verification, the contents of the target table will be stored row by row.
[0122] Step 4: The operator previews each work order in the system. If there is any abnormal information, the target table can be modified online and re-imported. During the preview, the information in the work order is generated by the row data template combined with the parsed data of the work order record through the template engine conversion.
[0123] Step 5. After the preview content is correct, batch create work orders on the page. The information in the work order is text content converted by the template engine. After the work order is generated, the system returns the row unique key of the generated work order. The work order information corresponding to the row unique key is stored in the database. The status information of the target work order in the database is: pending confirmation. The work order system will also send an MQ message. After the program listens to the MQ message, it determines the follow-up method of the work order task. If the follow-up method is automatic follow-up, the review interface of the work order system is called, the current work order enters the pending confirmation stage, and the follow-up rules are used to verify the current work order. If the follow-up method of the target task is manual confirmation follow-up, the follow-up person needs to manually approve it in the work order.
[0124] Step 6: By monitoring the MQ message of the work order system, it is learned that the work order has been confirmed for follow-up, and the status information of the target work order in the database is modified to: confirmed for follow-up.
[0125] Step 7: The work order system sends a processing reminder message to the processor. The processor processes the data according to the description and requirements of the work order task and feeds back the information to the target table.
[0126] Step 8. By monitoring the MQ message of the work order system, it is learned that the work order has been processed. Modify the status information of the target work order in the database to: Completed. Determine the inspection method of the work order task. If the inspection method is manual inspection, wait for the inspector to manually process it. If the inspection method is automatic inspection and passes, call the approval interface of the work order system. The rule engine checks the rule expression corresponding to the check rule to check whether the corresponding work order record in the target table meets the expected requirements. If it does not meet the expected requirements, call the rollback interface of the work order system and return the rollback reason so that the processor can process it again.
[0127] Step 9: Monitor the MQ message of the work order system to detect whether the work order is closed normally or rolled back, and update the status information of the target work order in the database as: passed the inspection or rolled back.
[0128] The solution of the embodiment of the present invention provides functions such as flexible work order generation and work order processing, reduces the time of manual input, and improves work efficiency. The solution of the embodiment of the present invention supports the work order system to pull the content of the online form and parse it line by line, and batch create personalized work orders according to the user-defined line record template, and supports manual batch urging and automatic verification.
[0129] Figure 5 FIG. 1 is a schematic diagram of a work order processing device provided by an embodiment of the present invention. Figure 5 As shown, the device comprises:
[0130] The information determination module 501 is used to determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information;
[0131] The table acquisition module 502 is used to acquire a target table according to the table information; wherein the target table includes: at least one row of work order records;
[0132] The work order generation module 503 is used to parse the work order data corresponding to each work order record; and generate a target work order corresponding to the work order record according to the work order data and the row data template;
[0133] The flow verification module 504 is used to perform flow verification processing on each target work order according to the status information and verification information of each target work order.
[0134] Optionally, the work order generation module 503 is specifically used for:
[0135] Parse the header of the target table to obtain multiple table fields, and determine a first mapping relationship between the table fields and the column numbers;
[0136] Parse the work order record to obtain multiple work order field values of the work order record, and determine a second mapping relationship between the work order field value and the column sequence number;
[0137] Generate multiple key-value pairs according to the first mapping relationship and the second mapping relationship; wherein the key-value pairs include: a table field and its corresponding work order field value;
[0138] Combine multiple key-value pairs to generate the work order data corresponding to the work order record.
[0139] Optionally, the work order generation module 503 is specifically used for:
[0140] Obtain multiple key-value pairs corresponding to the work order data; wherein the key-value pairs include: table fields and their corresponding work order field values;
[0141] Get multiple replacement identifiers in the row data template;
[0142] For each replacement identifier, determine the target table field corresponding to the replacement identifier; determine the target key-value pair corresponding to the target table field; replace the replacement identifier in the row data template with the target field value in the target key-value pair;
[0143] The row data template after replacement processing is determined as the target work order corresponding to the work order record.
[0144] Optionally, the work order generating module 503 is further used for:
[0145] Verify the data format of the target table;
[0146] In response to the target table failing the data format verification, a warning message for the target table is generated.
[0147] Optionally, the work order generating module 503 is further used for:
[0148] Receive a preview instruction for the work order record, and display the target work order corresponding to the work order record;
[0149] In response to receiving a modification instruction for the work order record, displaying the work order record; receiving an edit instruction for the work order record, and modifying the work order record according to the edit instruction;
[0150] In response to receiving a confirmation instruction for a work order record, it is determined that the status information representation of the target work order is to be confirmed.
[0151] Optionally, the circulation verification module 504 is specifically used for:
[0152] In response to the status information of the target work order indicating that confirmation is pending, determining a follow-up rule in the verification information;
[0153] In response to the target work order not meeting the follow-up rule, determining a follow-up person of the target work order, and sending a follow-up reminder message to the follow-up person;
[0154] In response to the target work order meeting the follow-up rule, determining that the status information of the target work order indicates confirmation of follow-up.
[0155] Optionally, the circulation verification module 504 is further used to:
[0156] In response to the status information representation of the target work order, confirm the follow-up, determine the processor of the target work order, and send a processing reminder message to the processor;
[0157] Receive processing requests from processors for target work orders;
[0158] According to the processing request, information processing is performed on the target work order, and it is determined that the status information representation of the target work order has been completed.
[0159] Optionally, the circulation verification module 504 is specifically used for:
[0160] In response to the status information indicating that the target work order has been completed, determining a check rule corresponding to the verification information;
[0161] In response to the target work order meeting the inspection rule, determining that the status information of the target work order indicates that it has passed the inspection;
[0162] In response to the target work order failing to pass the inspection rule, a return reminder message is sent to a handler of the target work order, and it is determined that the status information of the target work order represents a return.
[0163] An embodiment of the present invention provides an electronic device, including:
[0164] one or more processors;
[0165] The storage device is used to store one or more programs. When the one or more programs are executed by one or more processors, the one or more processors implement the method of any of the above embodiments.
[0166] An embodiment of the present invention provides a computer program product, including a computer program. When the computer program is executed by a processor, the method of any of the above embodiments is implemented.
[0167] Reference below Figure 6 , which shows a schematic diagram of the structure of a computer system 600 of a terminal device suitable for implementing an embodiment of the present invention. Figure 6 The terminal device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0168] like Figure 6 As shown, the computer system 600 includes a central processing unit (CPU) 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage part 608 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the system 600 are also stored. The CPU 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.
[0169] The following components are connected to the I / O interface 605: an input section 606 including a keyboard, a mouse, etc.; an output section 607 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 608 including a hard disk, etc.; and a communication section 609 including a network interface card such as a LAN card, a modem, etc. The communication section 609 performs communication processing via a network such as the Internet. A drive 60 is also connected to the I / O interface 605 as needed. A removable medium 61, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 60 as needed, so that a computer program read therefrom is installed into the storage section 608 as needed.
[0170] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 609, and / or installed from the removable medium 61. When the computer program is executed by the central processing unit (CPU) 601, the above-mentioned functions defined in the system of the present invention are executed.
[0171] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.
[0172] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0173] The modules involved in the embodiments of the present invention may be implemented by software or hardware. The modules described may also be arranged in a processor, for example, they may be described as: a task receiving module, a service splitting module, a data splitting module, a control module and a result determination module. The names of these modules do not constitute a limitation on the modules themselves in certain circumstances, for example, the task receiving module may also be described as "a module for receiving a target task and determining a plurality of processing services and target data corresponding to the target task".
[0174] As another aspect, the present invention further provides a computer-readable medium, which may be included in the device described in the above embodiment; or may exist independently without being assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device includes:
[0175] Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information;
[0176] According to the table information, a target table is obtained; wherein the target table includes: at least one row of work order records;
[0177] For each work order record, parse the work order data corresponding to the work order record; generate the target work order corresponding to the work order record based on the work order data and row data template;
[0178] Based on the status information and verification information of each target work order, each target work order is subjected to flow verification processing.
[0179] According to the technical solution of the embodiment of the present invention, a work order task and its corresponding target table are set. The task information of the work order task includes: a row data template. The row data template is set according to the display style of the work order. The target table includes: at least one row of work order records. The work order record is used to save the relevant information of the generated work order. According to the work order data and the row data template corresponding to each work order record, the target work order corresponding to each work order record is generated. It is possible to generate multiple work orders in batches, simplify the operation process of generating work orders, and improve the generation efficiency of work orders.
[0180] In addition, work order tasks also correspond to verification information. By verifying the information, the accuracy and compliance of the target work order during the circulation process can be guaranteed.
[0181] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.
Claims
1. A work order processing method, characterized in that: include: Determine the task information of the work order task; wherein the task information includes: row data template, table information and verification information; According to the table information, a target table is obtained; wherein the target table includes: at least one row of work order records; For each of the work order records, parsing the work order data corresponding to the work order record; generating a target work order corresponding to the work order record according to the work order data and the row data template; According to the status information of each target work order and the verification information, a flow verification process is performed on each target work order.
2. The method according to claim 1, characterized in that: The parsing of the work order data corresponding to the work order record includes: Parsing the header of the target table to obtain a plurality of table fields, and determining a first mapping relationship between the table fields and column numbers; Parsing the work order record to obtain multiple work order field values of the work order record, and determining a second mapping relationship between the work order field values and column numbers; Generate a plurality of key-value pairs according to the first mapping relationship and the second mapping relationship; wherein the key-value pairs include: a table field and its corresponding work order field value; The multiple key-value pairs are combined to generate work order data corresponding to the work order record.
3. The method according to claim 1, characterized in that Generating a target work order corresponding to the work order record according to the work order data and the row data template includes: Acquire multiple key-value pairs corresponding to the work order data; wherein the key-value pairs include: table fields and their corresponding work order field values; Obtaining multiple replacement identifiers in the row data template; For each replacement identifier, determine the target table field corresponding to the replacement identifier; determine the target key-value pair corresponding to the target table field; replace the replacement identifier in the row data template with the target field value in the target key-value pair; The row data template after replacement processing is determined as the target work order corresponding to the work order record.
4. The method according to claim 1, characterized in that After obtaining the target table according to the table information, the method further includes: Performing data format verification on the target table; In response to the target table failing the data format check, a warning message for the target table is generated.
5. The method according to claim 1, characterized in that: After generating a target work order corresponding to the work order record according to the work order data and the row data template, the method further includes: receiving a preview instruction for the work order record, and displaying a target work order corresponding to the work order record; In response to receiving a modification instruction for the work order record, displaying the work order record; receiving an edit instruction for the work order record, and modifying the work order record according to the edit instruction; In response to receiving a confirmation instruction for the work order record, determining that the status information representation of the target work order is to be confirmed.
6. The method according to claim 1, characterized in that: The process of performing flow verification on each target work order according to the status information and the verification information of each target work order includes: In response to the status information of the target work order indicating that confirmation is pending, determining a follow-up rule in the verification information; In response to the target work order not meeting the follow-up rule, determining a follow-up person for the target work order, and sending a follow-up reminder message to the follow-up person; In response to the target work order meeting the follow-up rule, determining that the status information of the target work order indicates confirmation of follow-up.
7. The method according to claim 1, characterized in that: After generating a target work order corresponding to the work order record according to the work order data and the row data template, the method further includes: In response to the status information representation of the target work order confirming the follow-up, determining the processor of the target work order, and sending a processing reminder message to the processor; receiving a processing request from the processor for the target work order; According to the processing request, information processing is performed on the target work order, and it is determined that the status information representation of the target work order has been completed.
8. The method according to claim 1, characterized in that: The process of performing flow verification on each target work order according to the status information and the verification information of each target work order includes: In response to the status information of the target work order indicating completion, determining a check rule corresponding to the verification information; In response to the target work order complying with the inspection rule, determining that the status information representation of the target work order passes the inspection; In response to the target work order failing to pass the inspection rule, a return reminder message is sent to a handler of the target work order, and it is determined that the status information of the target work order represents a return.
9. A work order processing device, characterized in that: include: An information determination module is used to determine the task information of the work order task; wherein the task information includes: a row data template, table information and verification information; A table acquisition module, used to acquire a target table according to the table information; wherein the target table includes: at least one row of work order records; A work order generation module, for parsing the work order data corresponding to each work order record; and generating a target work order corresponding to the work order record according to the work order data and the row data template; The flow verification module is used to perform flow verification processing on each target work order according to the status information of each target work order and the verification information.
10. An electronic device, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 8.
11. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 8 is implemented.
12. A computer program product, comprising a computer program, which, when executed by a processor, implements the method according to any one of claims 1 to 8.