A method and system for counting the total turnover time of a work order system based on external parameters

Abstract

The present invention provides a method and system for counting the total system circulation time of a work order based on external parameters, and relates to the field of telecommunication business support technology, including: clarifying the signs of activities entering and exiting the system, the signs of entering the system include the sign of creating a work order and the sign of modifying a work order; when the activity enters the system for the first time and again, the sign of creating a work order and the sign of modifying the work order are recorded respectively, and the system time is recorded at the same time; when the activity exits the system, the sign of exiting the system is recorded, and the system time is recorded at the same time; according to the activity ID, all the corresponding signs of entering and exiting the system and the corresponding recorded system time are taken out from the work order flow table; time parameters are introduced, and the total circulation time of the work order in the system is calculated according to the time parameters and the system time corresponding to the signs of entering and exiting the system. The present invention makes it more convenient to calculate the total circulation time of the work order in the system by introducing the time parameters.

Description

Technical Field

[0001] The present invention relates to the field of telecommunication business support technology, and in particular to a method and system for counting total work order system flow time based on external parameters. Background Art

[0002] In the telecommunications business system, it is necessary to count the labor efficiency of the marketing work order process. That is, in the marketing work order process, the time from the time the work order enters the system to the time it leaves the system is counted. If the work order leaves the system, is reallocated to the system, and then leaves the system again, the time spent in this process should also be counted as labor time.

[0003] The labor efficiency of the marketing work order process is generally calculated by first calculating the average scheduling time of the work order, that is: the average scheduling time of the mobile network work order = the cumulative time that the mobile network work order stays in the middle platform scheduling (dispatching) link / the total number of mobile network work orders that are scheduled (dispatched) by the middle platform.

[0004] At present, if a work order enters the middle platform scheduling (dispatch) multiple times, the time it stays in the scheduling (dispatch) link will be accumulated and calculated each time. The calculation process needs to subtract the time the work order leaves the system from the time the work order enters the system each time, which has a high calculation complexity. Summary of the invention

[0005] In view of the above problems, the present invention provides a method and system for calculating the total circulation time of a work order system based on external parameters. By introducing time parameters, the calculation of the circulation time of a work order in the system is more convenient.

[0006] To achieve the above object, the present invention provides a method for calculating the total turnover time of a work order system based on external parameters, comprising:

[0007] Clearly define the signs for activities entering and exiting the system. The signs for entering the system include the sign for creating a work order and the sign for modifying a work order.

[0008] When an activity enters the system for the first time and again, the creation ticket flag and modification ticket flag are recorded respectively, and the system time is also recorded;

[0009] When the activity exits the system, the system flag is recorded and the system time is recorded;

[0010] According to the activity ID, retrieve all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table;

[0011] A time parameter is introduced, and the total circulation time of the work order in the system is calculated according to the time parameter and the system time recorded corresponding to each mark of entering and exiting the system.

[0012] As a further improvement of the present invention, each of the activities corresponds to a work order in the system.

[0013] As a further improvement of the present invention, the work order creation flag is creatOrder, the work order modification flag is orderModify, and the system exit mark is waitOrderTake.

[0014] As a further improvement of the present invention, the method of extracting all corresponding system in-and-out flags and the corresponding recorded system time in the work order flow table according to the activity ID includes:

[0015] First, retrieve the work order flow with the required activity ID and the system entry and exit flag waitOrderTake from the work order flow table;

[0016] According to the system time recorded in the work order flow, extract all the work order flows in and out of the system corresponding to the activity ID before the system time in the work order flow table;

[0017] According to the retrieved work order flow, the mark of each entry and exit of the activity in the system and the recorded system time are obtained.

[0018] As a further improvement of the present invention, the time parameter is introduced, and the total circulation time of the work order in the system is calculated according to the system time recorded corresponding to the time parameter and each mark of entering and leaving the system; including:

[0019] Arrange the work order flow records entering and leaving the system of all the activity IDs in a row from top to bottom in the order of the system time, and each row of the work order flow records includes the system time;

[0020] The time intervals between the odd-numbered rows and the even-numbered rows and the time parameter are calculated respectively, the time interval of the odd-numbered rows = the time parameter - the system time of the row, and the time interval of the even-numbered rows = the system time of the row - the time parameter;

[0021] The calculated odd-numbered row time interval and the calculated even-numbered row time interval are added together to obtain the total circulation time of the activity ID in the system.

[0022] The present invention also provides a system for counting the total flow time of a work order system based on external parameters, comprising: a preset mark module, a mark recording module, a work order flow extraction module and a flow time calculation module;

[0023] The preset mark module is used to:

[0024] Clearly define the signs for activities entering and exiting the system. The signs for entering the system include the sign for creating a work order and the sign for modifying a work order.

[0025] The flag recording module is used to:

[0026] When an activity enters the system for the first time and again, the creation ticket flag and modification ticket flag are recorded respectively, and the system time is also recorded;

[0027] When the activity exits the system, the system flag is recorded and the system time is recorded;

[0028] The work order flow extraction module is used to:

[0029] According to the activity ID, retrieve all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table;

[0030] The flow time calculation module is used to:

[0031] A time parameter is introduced, and the total circulation time of the work order in the system is calculated according to the time parameter and the system time recorded corresponding to each mark of entering and exiting the system.

[0032] As a further improvement of the present invention, each of the activities corresponds to a work order in the system.

[0033] As a further improvement of the present invention, the work order creation flag is creatOrder, the work order modification flag is orderModify, and the system exit mark is waitOrderTake.

[0034] As a further improvement of the present invention, the method of extracting all corresponding system in-and-out flags and the corresponding recorded system time in the work order flow table according to the activity ID includes:

[0035] First, retrieve the work order flow with the required activity ID and the system entry and exit flag waitOrderTake from the work order flow table;

[0036] According to the system time recorded in the work order flow, extract all the work order flows in and out of the system corresponding to the activity ID before the system time in the work order flow table;

[0037] According to the retrieved work order flow, the mark of each entry and exit of the activity in the system and the recorded system time are obtained.

[0038] As a further improvement of the present invention, the time parameter is introduced, and the total circulation time of the work order in the system is calculated according to the system time recorded corresponding to the time parameter and each mark of entering and leaving the system; including:

[0039] Arrange the work order flow records entering and leaving the system of all the activity IDs in a row from top to bottom in the order of the system time, and each row of the work order flow records includes the system time;

[0040] The time intervals between the odd-numbered rows and the even-numbered rows and the time parameter are calculated respectively, the time interval of the odd-numbered rows = the time parameter - the system time of the row, and the time interval of the even-numbered rows = the system time of the row - the time parameter;

[0041] The calculated odd-numbered row time interval and the calculated even-numbered row time interval are added together to obtain the total circulation time of the activity ID in the system.

[0042] Compared with the prior art, the present invention has the following beneficial effects:

[0043] The present invention introduces time parameters and performs preset management on the signs of activities entering and exiting the system. When calculating the system time, it is only necessary to take out the work order flow records of all activities entering and exiting the system. The time parameters can be directly inserted without changing the existing format of the flow records, and the total flow time of each work order in the system can be calculated. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 A flow chart of a method for counting the total flow time of a work order system based on external parameters disclosed in an embodiment of the present invention;

[0045] Figure 2 A schematic diagram of a system for counting the total flow time of a work order system based on external parameters disclosed in an embodiment of the present invention;

[0046] Figure 3 A calculation process for the total work order flow time disclosed in an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0048] The present invention is further described in detail below in conjunction with the accompanying drawings:

[0049] Example:

[0050] like Figure 1 As shown, the present invention provides a method for counting the total flow time of a work order system based on external parameters, comprising:

[0051] S1. Clearly define the signs for activities to enter and exit the system. The signs for entering the system include the create work order sign and the modify work order sign.

[0052] in,

[0053] Each activity corresponds to a work order in the system.

[0054] S2. When the activity enters the system for the first time and again, the creation work order flag and modification work order flag are recorded respectively, and the system time is recorded at the same time;

[0055] in,

[0056] The flag for creating a work order is creatOrder, and the flag for modifying a work order is orderModify;

[0057] S3. When the activity exits the system, the system flag is recorded and the system time is recorded at the same time;

[0058] in,

[0059] The exit system is marked as waitOrderTake.

[0060] S4. According to the activity ID, retrieve all corresponding system entry and exit marks and corresponding recorded system time in the work order flow table;

[0061] Among them, include:

[0062] First, retrieve the work order flow with the required activity ID and the system entry and exit flag waitOrderTake from the work order flow table;

[0063] According to the system time recorded in the work order flow, retrieve all the work order flows in and out of the system with the corresponding activity ID before the system time in the work order flow table;

[0064] Based on the retrieved work order flow, obtain the sign of each entry and exit of the activity in the system and the recorded system time.

[0065] Furthermore, if the number of work order flows found is greater than two, they are sorted in ascending order according to the time value, and activities with only one record are discarded.

[0066] S5. Introduce a time parameter, and calculate the total circulation time of the work order in the system according to the time parameter and the system time recorded corresponding to each entry and exit mark.

[0067] Among them, include:

[0068] Arrange the work order flow in and out of the system for all activity IDs in order of system time from top to bottom. Each line of work order flow includes the system time.

[0069] The time intervals between odd-numbered rows and even-numbered rows and the time parameter are calculated respectively. The time interval between odd-numbered rows = time parameter - the system time of the row, and the time interval between even-numbered rows = the system time of the row - the time parameter.

[0070] The calculated time intervals of odd-numbered rows and even-numbered rows are added together to obtain the total circulation time of the activity ID in the system.

[0071] like Figure 2 As shown, the present invention also provides a system for a method of counting the total flow time of a work order system based on external parameters, comprising: a preset mark module, a mark recording module, a work order flow extraction module and a flow time calculation module;

[0072] Preset logo module for:

[0073] Clearly define the signs for activities entering and exiting the system. The signs for entering the system include the sign for creating a work order and the sign for modifying a work order.

[0074] Among them, each activity corresponds to a work order in the system.

[0075] Flags recording module for:

[0076] When an activity enters the system for the first time and again, the creation ticket flag and modification ticket flag are recorded respectively, and the system time is also recorded;

[0077] When the activity exits the system, the system flag is recorded and the system time is recorded;

[0078] in,

[0079] The creation flag of a work order is creatOrder, the modification flag of a work order is orderModify, and the exit flag is waitOrderTake.

[0080] The work order flow extraction module is used to:

[0081] According to the activity ID, retrieve all corresponding system entry and exit signs and corresponding recorded system time in the work order flow table;

[0082] Among them, include:

[0083] First, retrieve the work order flow with the required activity ID and the system entry and exit flag waitOrderTake from the work order flow table;

[0084] According to the system time recorded in the work order flow, retrieve all the work order flows in and out of the system with the corresponding activity ID before the system time in the work order flow table;

[0085] Based on the retrieved work order flow, obtain the sign of each entry and exit of the activity in the system and the recorded system time.

[0086] The flow time calculation module is used to:

[0087] Introduce time parameters, and calculate the total circulation time of the work order in the system according to the time parameters and the system time recorded corresponding to the signs entering and leaving the system;

[0088] Among them, include:

[0089] Arrange the work order flow in and out of the system for all activity IDs in order of system time from top to bottom. Each line of work order flow includes the system time.

[0090] The time intervals between odd-numbered rows and even-numbered rows and the time parameter are calculated respectively. The time interval between odd-numbered rows = time parameter - the system time of the row, and the time interval between even-numbered rows = the system time of the row - the time parameter.

[0091] The calculated time intervals of odd-numbered rows and even-numbered rows are added together to obtain the total circulation time of the activity ID in the system.

[0092] Example:

[0093] like Figure 3 The following is the calculation process of the total work order flow time; taking activity ACT0001 as an example, it includes:

[0094] Step 1. Get the record of the last time ACT0001 exited the system from the work order flow table.

[0095]

[0096]

[0097] Step 2: Based on the time and activity ID in the record of ACT0001's last exit from the system, retrieve all system entry and exit records of ACT0001 before that time in the work order flow table.

[0098] Event ID step Entry and exit signs time ACT0001 2 waitOrderTake 10:50 ACT0001 4 waitOrderTake 11:40 ACT0001 1 createOrder 9:50 ACT0001 3 orderModify 11:20

[0099] Step 3: Arrange the retrieved data of ACT0001 in ascending chronological order.

[0100] Event ID step Entry and exit signs time ACT0001 1 createOrder 9:50 ACT0001 2 waitOrderTake 10:50 ACT0001 3 orderModify 11:20 ACT0001 4 waitOrderTake 11:40

[0101] Step 4: Introduce external parameters: the time interval of odd-numbered rows = time parameter - the system time of the row; the time interval of even-numbered rows = the system time of the row - time parameter.

[0102] Event ID step Entry and exit signs time Parameter time Difference(min) Remark ACT0001 1 createOrder 9:50 12:00 130 Odd rows ACT0001 2 waitOrderTake 10:50 12:00 -70 Even rows ACT0001 3 orderModify 11:20 12:00 40 Odd rows ACT0001 4 waitOrderTake 11:40 12:00 -20 Even rows total 80

[0103] The parameter time can be selected to use the current system time or any other time.

[0104] Step 5: Sum up all the differences of activity ACT0001 and obtain that the circulation time of activity ACT0001 in the system is 80 minutes.

[0105] The method of the present invention conveniently calculates the time of the work order process operation in a certain submodule, avoiding the tediousness of changing the vertical data into a horizontal table; for the statistical entry and exit interval problems that appear in different business scenarios or sub-systems, statistics and promotion support applications can be performed.

[0106] Advantages of the present invention:

[0107] By introducing time parameters and presetting the signs of activities entering and leaving the system, when calculating the system time, you only need to take out the work order flow of all activities entering and leaving the system. You don't need to change the existing format of the flow and can directly insert the time parameters to calculate the total flow time of each work order in the system.

[0108] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for calculating the total turnover time of a work order system based on external parameters, characterized in that: include: Clearly define the signs for activities entering and exiting the system. The signs for entering the system include the sign for creating a work order and the sign for modifying a work order. When the activity enters the system for the first time and again, the creation work order flag and the modification work order flag are recorded respectively, and the system time is recorded at the same time; When the activity exits the system, the system flag is recorded and the system time is recorded; According to the activity ID, retrieve all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table; Introduce a time parameter, where the time parameter is a pre-selected time; arrange all the work order flows entering and leaving the system of the activity ID in rows from top to bottom in the order of the system time, and each row of the work order flow includes the system time; calculate the time intervals with the time parameter for odd and even rows respectively, the time interval for odd rows = time parameter - system time of the row, and the time interval for even rows = system time of the row - time parameter; add the calculated time intervals for odd rows and even rows to obtain the total circulation time of the activity ID in the system.

2. The method according to claim 1, characterized in that: Each of the activities corresponds to a work order in the system.

3. The method according to claim 1, characterized in that: The create work order flag is creatOrder, the modify work order flag is orderModify, and the exit system flag is waitOrderTake.

4. The method according to claim 1, characterized in that: The method of extracting all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table according to the activity ID includes: First, retrieve the work order flow with the required activity ID and the last system exit flag of waitOrderTake from the work order flow table; According to the system time recorded in the work order flow, extract all the work order flows in and out of the system corresponding to the activity ID before the system time in the work order flow table; According to the retrieved work order flow, the mark of each entry and exit of the activity in the system and the recorded system time are obtained.

5. A system for implementing the method for counting the total turnover time of a work order system as described in claims 1 to 4, characterized in that: It includes: preset mark module, mark recording module, work order flow extraction module and flow time calculation module; The preset mark module is used to: Clearly define the signs for activities entering and exiting the system. The signs for entering the system include the sign for creating a work order and the sign for modifying a work order. The flag recording module is used to: When the activity enters the system for the first time and again, the creation work order flag and the modification work order flag are recorded respectively, and the system time is recorded at the same time; When the activity exits the system, the system flag is recorded and the system time is recorded; The work order flow extraction module is used to: According to the activity ID, retrieve all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table; The flow time calculation module is used to: Introduce a time parameter, where the time parameter is a pre-selected time; arrange all the work order flows entering and leaving the system of the activity ID in rows from top to bottom in the order of the system time, and each row of the work order flow includes the system time; calculate the time intervals with the time parameter for odd and even rows respectively, the time interval for odd rows = time parameter - system time of the row, and the time interval for even rows = system time of the row - time parameter; add the calculated time intervals for odd rows and even rows to obtain the total circulation time of the activity ID in the system.

6. The system according to claim 5, characterized in that: Each of the activities corresponds to a work order in the system.

7. The system according to claim 5, characterized in that: The create work order flag is creatOrder, the modify work order flag is orderModify, and the exit system flag is waitOrderTake.

8. The system according to claim 5, characterized in that: The method of extracting all corresponding system entry and exit marks and the corresponding recorded system time in the work order flow table according to the activity ID includes: First, retrieve the work order flow with the required activity ID and the last system exit flag of waitOrderTake from the work order flow table; According to the system time recorded in the work order flow, extract all the work order flows in and out of the system corresponding to the activity ID before the system time in the work order flow table; According to the retrieved work order flow, the mark of each entry and exit of the activity in the system and the recorded system time are obtained.

Images