WO2016206550A1 - Electronic worksheet processing method and device - Google Patents

Abstract

Disclosed are an electronic worksheet processing method and device. The processing method comprises: acquiring the period of validity of a specified electronic worksheet (S102); judging whether the current time is within the period of validity of the specified electronic worksheet, and obtaining a judgement result (S104); and in the case that the judgement result is negative, storing the specified electronic worksheet in an expired electronic worksheet list (S106). The method solves the problems in the related art which are caused by worksheets waiting to be executed but not being executed for a long time that are kept in a system for a long time, thus ensuring the validity of worksheets in a to-be-executed worksheet list and the efficiency of the system in the processes of operation and maintenance.

Description

Electronic work order processing method and device Technical field

The present invention relates to the field of communications, and in particular to an electronic work order processing method and apparatus.

Background technique

Various types of telecom operators generally provide services to users, such as broadband services, voice services, and Internet Protocol Television (IPTV) services. In the process of providing services, we will describe them in detail as customers. A collection of data that provides business content is called a work order. In the earlier era, because the systems were not connected to each other, the data exchange was difficult, and the construction environment was relatively poor. The paper work orders were generated. Compared with the electronic work orders, due to physical objects, the management cycle was long, the process was slow, and the efficiency was low. However, the subsequent system uses a variety of electronic work order real-time interfaces, which doubles the efficiency. Compared with paper work orders, the number of electronic work orders processed per day increases exponentially (the work order below is the default electronic work order). ).

In the traditional work order processing system, there are two types of work orders:

Pending execution: refers to the state before the work order is received from other systems, until the first execution, the work order in this state is in the cache state, and is also the initial state of a work order;

Executed: When the device is installed, the work order is sent to the device after execution. According to the execution result, it is divided into two branches: execution success and execution failure.

The existing processing technology is designed based on the ideal situation. The work order issued from the A system to the B system should be processed within a fixed period, from the pending execution to the executed state, but the processing is not timely, the A system If the error is unsuccessful, the work order will remain in the system. As a result, the query and the statistics of the work order will be slowed down, and the work order will not be effectively monitored. The normal service operation and maintenance of the carrier cannot be supported.

There are two kinds of processing in the related art, one is to directly stay in the list of work orders to be executed, and the result is that the system queries the pending work orders more and more slowly, and when it is serious, the installation equipment queries the work orders timeout, and the equipment cannot be installed. The related services in the device are activated, which affects the operation and maintenance process of the operator. Compared with this processing technology, it can effectively improve the installation success rate of the device and ensure the normal operation and maintenance of the operator.

Another technique is to delete work orders directly from time to time. This technology is simple and rude, and it is not able to provide the Bureau with means of sustainable improvement. For example, the Bureau needs to query the most recent type of overdue work orders, and instructs the senders of the work orders to rectify, or Instructing the construction party to speed up the construction progress, it is impossible to provide relevant supporting data.

In view of the problems caused by the long-term unexecuted work orders that are to be executed and remain in the system for a long time, an effective solution has not been proposed.

Summary of the invention

The present invention provides an electronic work order processing method and apparatus for solving at least the problems caused by the long-term unexecuted work orders remaining in the system to be executed in the related art.

According to an aspect of the present invention, an electronic work order processing method is provided, including: obtaining an expiration date of a specified electronic work order; determining whether a current time belongs to an expiration date of the specified electronic work order, and obtaining a judgment result; If not, save the specified electronic work order to the list of expired electronic work orders.

Optionally, before obtaining the validity period of the specified electronic work order, the method includes: obtaining an electronic work order list to be executed, wherein the electronic work order list to be executed saves an electronic work order to be executed; and the electronic work order list to be executed Find the specified electronic work order.

Optionally, after saving the specified electronic work order to the list of the expired electronic work orders, the method includes: cleaning the electronic work orders saved in the list of the expired electronic work orders.

Optionally, after saving the specified electronic work order to the expired electronic work order list, the method includes: querying the electronic work order saved in the expired electronic work order list according to the specified query condition.

Optionally, determining whether the current time belongs to the validity period of the specified electronic work order comprises: determining, according to the specified period, whether the current time belongs to an expiration date of the specified electronic work order.

According to another aspect of the present invention, an electronic work order processing apparatus is provided, including: a first acquisition module configured to acquire an expiration date of a specified electronic work order; and a determination module configured to determine whether the current time belongs to the designated electronic The validity period of the work order is obtained, and the saving module is configured to save the specified electronic work order to the list of the expired electronic work orders if the determination result is negative.

Optionally, the device further includes: a second obtaining module, configured to obtain a list of electronic work orders to be executed, wherein the electronic work order list to be executed saves an electronic work order to be executed; the search module is set to be The specified electronic work order is searched in the to-be-executed electronic work order list.

Optionally, the device further includes: a cleaning module, configured to clean the electronic work order saved in the list of the expired electronic work orders.

Optionally, the device further includes: a query module, configured to query the electronic work order saved in the list of the expired electronic work orders according to the specified query condition.

Optionally, the determining module is further configured to determine, according to the specified period, whether the current time belongs to an expiration date of the specified electronic work order.

Another embodiment of the present invention provides a computer storage medium storing execution instructions for performing the method in the above embodiments.

According to the present invention, the validity period of the specified electronic work order is obtained; whether the current time belongs to the validity period of the designated electronic work order, and the judgment result is obtained; if the judgment result is negative, the designated electronic work order is saved to the expired electronic work order list. in. It solves the problems caused by long-term unreserved work orders in the related technology and remains in the system, which ensures the validity of the work orders in the list of work orders to be executed and the efficiency of the system in the operation and maintenance process.

DRAWINGS

The drawings described herein are intended to provide a further understanding of the invention, and are intended to be a part of the invention. In the drawing:

1 is a flow chart of an electronic work order processing method according to an embodiment of the present invention;

2 is a block diagram showing the structure of an electronic work order processing apparatus according to an embodiment of the present invention;

3 is a structural block diagram (1) of an electronic work order processing apparatus according to an embodiment of the present invention;

4 is a structural block diagram (2) of an electronic work order processing apparatus according to an embodiment of the present invention;

FIG. 5 is a structural block diagram (3) of an electronic work order processing apparatus according to an embodiment of the present invention; FIG.

6 is an overall structural diagram of an ultra-expected execution work order processing system according to an embodiment of the present invention;

7 is a structural diagram of a policy module according to an embodiment of the present invention;

8 is a structural diagram of an overtime work order processing module according to an embodiment of the present invention;

9 is a structural diagram of an overtime work order query statistic module according to an embodiment of the present invention;

10 is a flow chart of an overdue work order system in accordance with an embodiment of the present invention.

detailed description

The invention will be described in detail below with reference to the drawings in conjunction with the embodiments. It should be noted that the embodiments in the present application and the features in the embodiments may be combined with each other without conflict.

It is to be understood that the terms "first", "second" and the like in the specification and claims of the present invention are used to distinguish similar objects, and are not necessarily used to describe a particular order or order.

In this embodiment, an electronic work order processing method is provided. FIG. 1 is a flowchart of an electronic work order processing method according to an embodiment of the present invention. As shown in FIG. 1 , the flow includes the following steps:

Step S102, obtaining an expiration date of the specified electronic work order;

Step S104, determining whether the current time belongs to the validity period of the specified electronic work order, and obtaining the determination result;

In step S106, if the determination result is no, the designated electronic work order is saved in the expired electronic work order list.

Through the above steps, the status of the electronic work order is judged according to the validity period of the electronic work order, and when the electronic work order is determined to be an unprocessed electronic work order, the expired unprocessed electronic work order is saved to the expired electronic work order list. In order to facilitate the subsequent processing of the unprocessed electronic work orders, compared with the related art, the electronic work orders that are overdue and unprocessed will remain in the list of work orders to be executed to obtain the irregular delete work orders. The above steps solve the problems caused by the long-term unworked work orders that are to be executed in the related art and remain in the system, thereby ensuring the work orders in the work order list to be executed. Effectiveness and efficiency of the system in the operation and maintenance process.

In the above step S102, the expiration date of the specified electronic work order is acquired. In an optional embodiment, before, the electronic work order list to be executed is obtained, wherein the electronic work order list to be executed stores the electronic work to be executed. Single, find the specified electronic work order from the list of electronic work orders to be executed. Thereby, the validity period of the specified electronic work order can be further obtained.

The purpose of finding an electronic work order that is out of date is to ensure the efficiency of the system in the operation and maintenance process. In an optional embodiment, after the specified electronic work order is saved in the list of the expired electronic work order, the overdue is cleared. An electronic work order saved in the electronic work order list.

In order to analyze the invalid work order, in an optional embodiment, after the designated electronic work order is saved in the list of the expired electronic work orders, the electronic work order saved in the list of the expired electronic work orders is queried according to the specified query conditions.

The calling cycle may be set to determine the state of the electronic work order according to the cycle. In an optional embodiment, it is determined whether the current time belongs to the validity period of the specified electronic work order according to the specified period.

Through the description of the above embodiments, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, by hardware, but in many cases, the former is A better implementation. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a cell phone, a computer, a server, or a network device, etc.) to perform the methods described in various embodiments of the present invention.

In the embodiment, an electronic work order processing device is further provided, which is used to implement the above-mentioned embodiments and preferred embodiments, and has not been described again. As used below, the term "module" may implement a combination of software and/or hardware of a predetermined function. Although the apparatus described in the following embodiments is preferably implemented in software, hardware, or a combination of software and hardware, is also possible and contemplated.

2 is a structural block diagram of an electronic work order processing apparatus according to an embodiment of the present invention. As shown in FIG. 2, the apparatus includes: a first acquisition module 22 configured to acquire an expiration date of a specified electronic work order; and a determination module 24 configured to Determining whether the current time belongs to the validity period of the specified electronic work order, and obtaining the judgment result; the saving module 26 is configured to save the designated electronic work order to the list of the expired electronic work orders if the determination result is negative.

3 is a structural block diagram (1) of an electronic work order processing apparatus according to an embodiment of the present invention. As shown in FIG. 3, the apparatus includes, in addition to all the modules shown in FIG. 2, a second acquisition module 32, which is configured. To obtain an electronic work order list to be executed, wherein the electronic work order list to be executed is saved in the electronic work order list to be executed; the searching module 34 is configured to search the specified electronic work order from the electronic work order list to be executed.

4 is a structural block diagram (2) of an electronic work order processing apparatus according to an embodiment of the present invention. As shown in FIG. 4, the apparatus further includes: a cleaning module 42 configured to clean the electronic workers saved in the list of the expired electronic work orders. single.

5 is a structural block diagram (3) of an electronic work order processing apparatus according to an embodiment of the present invention, as shown in FIG. The method includes: the query module 52 is configured to query the electronic work order saved in the list of the expired electronic work orders according to the specified query condition.

Optionally, the determining module 24 is further configured to determine, according to the specified period, whether the current time belongs to an expiration date of the specified electronic work order.

It should be noted that each of the above modules may be implemented by software or hardware. For the latter, the foregoing may be implemented by, but not limited to, the foregoing modules are all located in the same processor; or, the modules are located in multiple In the processor.

Embodiments of the present invention also provide a storage medium. Optionally, in the embodiment, the foregoing storage medium may be configured to store program code for performing the following steps:

S1, obtaining the validity period of the specified electronic work order;

S2, determining whether the current time belongs to the validity period of the specified electronic work order, and obtaining the judgment result;

S3. If the judgment result is no, the designated electronic work order is saved in the list of the expired electronic work orders.

Optionally, in the embodiment, the foregoing storage medium may include, but is not limited to, a USB flash drive, a Read-Only Memory (ROM), and a Random Access Memory (RAM). A variety of media that can store program code, such as a hard disk, a disk, or an optical disk.

Optionally, in the embodiment, the processor executes the above S1, S2, and S3 according to the stored program code in the storage medium.

For example, the specific examples in this embodiment may refer to the examples described in the foregoing embodiments and the optional embodiments, and details are not described herein again.

According to the foregoing description, when the work order to be executed has not been executed for a long time, an “overdue unexecuted” status should be added to indicate that the work order has exceeded the validity period and needs to be cleaned up and archived; therefore, from the point of view of the work order being executed It can be divided into three states: to be executed, executed, and not overdue; through the management of overdue unexecuted work orders, timely cleaning of overdue work orders can be realized, and the system can efficiently query and process effective work orders. Thereby achieving the purpose of protecting the system.

In order to achieve the above object, the present invention provides an expired work order management system, which relates to a method for processing all the electronic work orders processed by the overdue electronic work order, that is, cleaning the long-term unexecuted electronic work orders, including but not It is limited to related systems of various operators to support the opening of remote terminal equipment services, such as terminal management systems (ITMS, RMS) of domestic operators, and electronic operation and maintenance order processing systems of various operators. The system includes:

1. Policy module: set to trigger management of scheduled work orders, including how long to execute, start execution time;

2. The overdue work order processing module (completes the functions of the first obtaining module 22, the judging module 24 and the saving module 26): includes the definition of the overdue work order, and how to process the processing of the overdue work order;

3. The overdue work order query statistics module (equivalent to the above query module 52): includes querying various conditions for the overdue work orders that have been clarified, and various statistical functions to facilitate the combing and positioning of the business issue problems. ;

The above policy module includes a call to the overtime work order processing module, a call cycle, and a start time effective;

The above-mentioned overtime work order processing module is a core processing module of the system, and provides an operation of an overdue work order inquiry and an overtime work order cleaning;

The above-mentioned overtime work order query statistic module provides functions for providing various conditions for querying historical overdue work orders that have been cleaned, and performing work order statistics for each dimension (work order type, time, territory, operator);

The above policy module also includes definitions of the calling cycle and the calling time:

1. The calling cycle (generally in days): it is executed once every cycle;

2. The calling time (usually 2 to 3 in the morning, when the business runs at the minimum), the policy trigger time, when the policy is triggered, the validity of the work order will be processed;

The above-mentioned overtime work order module also includes a definition of the validity period:

1. Validity period (eg: 7 days): Calculated from the time when the work order is sent to the system. During the validity period, the work order can be executed when the equipment is installed. After the expiration date, it cannot be executed. For example, the work order is from 2015. -5-1 00:00:00 is issued, and the work orders can be executed before 2015-5-800:00:00;

And the definition of the process flow:

1. Find out the set of overtime work orders from the list of pending work orders according to the current time and validity period;

2. Modify the status of the overdue work order set to "overdue unexecuted";

3. Move the overdue work order set to the overdue work order list.

6 is an overall structural diagram of an ultra-expected execution work order processing system according to an embodiment of the present invention. As shown in FIG. 6, the system includes: a policy module 1, an overtime work order processing module 2, and an overtime work order query statistics module 3. The all the modules are all located in the software system, and the policy module 1 and the overdue work order query statistics module 3 have an interface with the user operation, which can be monitored and scheduled by the user at any time;

The above policy module 1 performs trigger management on the periodically executed overdue work order, including how long the execution is performed, and starts execution time;

The overtime work order processing module 2 is configured to receive the information reported by the policy module 1 and the overdue work order query statistic module 3, and then perform calculation and analysis to determine the execution action of the board; and provide the overdue period for the core processing module of the system. Inquiries of work orders and cleaning of overdue work orders;

The overdue work order query statistics module 3 is configured to collect the in-position state, the communication state, the running state, the input power, the power capacity, and the like of each power module, and is used by the overtime work order processing module 2. The functions provided include querying various conditions for the historical overtime work orders that have been cleaned, and counting the work orders for each dimension (work order type, time, territory, operator).

FIG. 7 is a structural diagram of a policy module according to an embodiment of the present invention. As shown in FIG. 7, the policy module 1 includes: execution cycle scheduling control 5, execution time scheduling control 6, and running state. Monitoring 7.

The execution cycle scheduling control 5 is configured to monitor whether the system task reaches the scheduling period;

The execution time scheduling control 6 is configured to monitor whether the system task reaches the scheduling time;

The above operation state monitoring 7 is set to monitor whether the state of the system is normal, and whether the relevant conditions of the scheduling task are met;

FIG. 8 is a structural diagram of an overtime work order processing module according to an embodiment of the present invention. As shown in FIG. 8, it is a further refinement of the overtime work order processing module 2. The method includes: a query module 8, a data update module 9, and a migration module 10.

The query module 8 is configured to query the work order to be executed that has expired according to the previous overdue setting and the current time.

The data update module 9 is configured to update the status of the queried overdue work order, and is marked as “overdue unexecuted” for use by the migration module 10.

The above-mentioned migration module 10 is configured to move the work order set that has been marked as “overdue unexecuted” to the system's overdue work order list for use by the above-mentioned overtime work order query statistics module 3.

FIG. 9 is a structural diagram of an overtime work order query statistic module according to an embodiment of the present invention. As shown in FIG. 9, it is a further refinement of the overtime work order query statistic module 3. The method includes an overtime work order inquiry module 11 and an overtime work order statistics module 12.

The above-mentioned overtime work order inquiry module 11 is configured to provide a query for various conditions for the historical overtime work order that has been cleared;

The overtime work order statistic module 12 is configured to perform work order statistics for each dimension (work order type, time, territory, operator);

FIG. 10 is a flowchart of an overtime work order system according to an embodiment of the present invention. As shown in FIG. 10, the specific processing steps are as follows:

Step S101: Creating a policy, determining an execution period and a specific execution time in the execution period, and also determining an expiration date of the work order to be executed;

Step S102: The policy starts to start work, and waits for the processing task to be executed;

Step S103: The policy determines whether the execution time has elapsed or not, and the processing flow is entered into the processing task;

Step S104: Query the overdue work order in the list of work orders to be executed according to the expiration date and the current time;

Step S105: determining whether the result is queried, or not ending the task, returning to step S102, and handing over the policy to continue waiting, and proceeding to the next step process;

Step S106: setting the status of the work order set queried in step S105 to “overdue execution is not performed”;

Step S107: moving the work order in the state of "out of date not executed" in S106 into the list of overdue work orders;

Step S108: The current processing task ends, and the process goes to step S102 to the policy module for processing, and continues to wait for the next execution cycle.

In summary, the method and device for processing the overdue electronic work order provided by the present invention realize effective maintenance of the work order to be executed in the system, and efficient management of the work order to be executed, and solve the work order to be executed in the system. More and more problems, The data provided is complete, and the work order has a complete life cycle in the system, which provides support for the operator's sustainable operation and maintenance; all the work orders entering the system are based on their life cycle and for each work order. A complete management process; ensure the validity of the work orders in the list of work orders to be executed, and the efficiency of the system in the operation and maintenance process. The query and statistics also provide the relevant data foundation for the analysis of the invalid work orders. .

It will be apparent to those skilled in the art that the various modules or steps of the present invention described above can be implemented by a general-purpose computing device that can be centralized on a single computing device or distributed across a network of multiple computing devices. Alternatively, they may be implemented by program code executable by the computing device such that they may be stored in the storage device by the computing device and, in some cases, may be different from the order herein. The steps shown or described are performed, or they are separately fabricated into individual integrated circuit modules, or a plurality of modules or steps thereof are fabricated as a single integrated circuit module. Thus, the invention is not limited to any specific combination of hardware and software.

The above description is only the preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes can be made to the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and scope of the present invention are intended to be included within the scope of the present invention.

Industrial applicability

As described above, the electronic work order processing method and apparatus provided by the embodiments of the present invention have the following beneficial effects: solving the problems caused by long-term unexecuted work orders in the related art and remaining in the system, thereby ensuring The validity of the work order in the list of work orders to be executed and the efficiency of the system in the operation and maintenance process.

Claims (10)

An electronic work order processing method comprising: Obtain the validity period of the specified electronic work order; Determining whether the current time belongs to the validity period of the specified electronic work order, and obtaining a judgment result; If the result of the determination is negative, the specified electronic work order is saved in the list of the expired electronic work orders. The method of claim 1 wherein obtaining the validity period of the specified electronic work order comprises: Obtaining an electronic work order list to be executed, wherein the electronic work order to be executed is saved in the electronic work order list to be executed; Finding the specified electronic work order from the list of electronic work orders to be executed. The method of claim 1 wherein after saving the specified electronic work order to the list of expired electronic work orders comprises: Clean the electronic work order saved in the list of the expired electronic work orders. The method of claim 1 wherein after saving the specified electronic work order to the list of expired electronic work orders comprises: The electronic work order saved in the list of the expired electronic work orders is queried according to the specified query condition. The method according to any one of claims 1 to 4, wherein determining whether the current time belongs to the validity period of the specified electronic work order comprises: Determining, according to the specified period, whether the current time belongs to the validity period of the specified electronic work order. An electronic work order processing device comprising: a first obtaining module, configured to obtain an expiration date of the specified electronic work order; The determining module is configured to determine whether the current time belongs to the validity period of the specified electronic work order, and obtain a judgment result; The saving module is configured to save the specified electronic work order to the overdue electronic work order list if the determination result is negative. The apparatus of claim 6 wherein said apparatus further comprises: a second obtaining module, configured to obtain an electronic work order list to be executed, where the electronic work order to be executed is saved in the electronic work order list to be executed; a lookup module configured to look up the specified electronic work order from the list of electronic work orders to be executed. The apparatus of claim 6 wherein said apparatus further comprises: The cleaning module is configured to clean the electronic work order saved in the list of the expired electronic work orders. The apparatus of claim 6 wherein said apparatus further comprises: The query module is configured to query the electronic work order saved in the list of the expired electronic work orders according to the specified query condition. The apparatus according to any one of claims 6 to 9, wherein the determination module is further arranged to determine, according to a specified period, whether the current time belongs to an expiration date of the specified electronic work order.

Images