CN112712331A - Approval data query method and device, computer equipment and storage medium - Google Patents
Approval data query method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN112712331A CN112712331A CN202011495655.2A CN202011495655A CN112712331A CN 112712331 A CN112712331 A CN 112712331A CN 202011495655 A CN202011495655 A CN 202011495655A CN 112712331 A CN112712331 A CN 112712331A
- Authority
- CN
- China
- Prior art keywords
- approval
- time
- processing
- events
- event
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000012545 processing Methods 0.000 claims abstract description 134
- 238000004364 calculation method Methods 0.000 claims abstract description 9
- 230000002159 abnormal effect Effects 0.000 claims description 16
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012935 Averaging Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides an approval data query method and device, computer equipment and a storage medium, relates to the technical field of data processing, and is used for improving the accuracy of the calculation of the average approval time. The method mainly comprises the following steps: receiving an approval data query request, wherein the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event; acquiring an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events; acquiring an approval time list corresponding to each approval event in an approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event; determining the data attribute of each approval time in the approval time list; and calculating the average time of the processing of the examination and approval objects and/or the average time of the processing of the examination and approval events according to the examination and approval time of the normal data, and outputting the average time of the processing of the examination and approval objects and/or the average time of the processing of the examination and approval events.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to an approval data query method and apparatus, a computer device, and a storage medium.
Background
The business systems used in various fields generally have approval processes, such as a leave approval process, a financial reimbursement approval process and the like, and the approval process work is a management or service behavior which is comprehensively coordinated and relates to multiple aspects of work.
At present, which approval object or approval type takes more time can be determined by inquiring the average approval time, and then the corresponding approval object is notified to process the approval event. However, the conventional average time for approval is obtained by averaging the approval times of all the approval events, and the approval events contain abnormal data of special cases, so that the calculation accuracy of the conventional average time for approval is not high, and the conventional average time for approval has little guiding significance on the approval events.
Disclosure of Invention
The embodiment of the application provides an approval data query method and device, computer equipment and a storage medium, which are used for improving the accuracy of the calculation of the average approval time.
The embodiment of the invention provides an approval data query method, which comprises the following steps:
receiving an approval data query request, wherein the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event;
acquiring an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events;
acquiring an approval time list corresponding to each approval event in the approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event;
determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data, and outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
The embodiment of the invention provides an examination and approval data query device, which comprises:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring an approval event list of a preset time period, and the approval event list comprises a plurality of approval events;
the acquisition module is further configured to acquire an approval time list corresponding to each approval event in the approval event list, where the approval event list includes approval times for processing the approval events by each approval object in the corresponding approval events;
the determining module is used for determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
the calculation module is used for calculating the average time of the processing of the examination and approval object and/or the average time of the processing of the examination and approval event according to the examination and approval time of the normal data;
and the output module is used for outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the above mentioned approval data query method when executing the computer program.
A computer-readable storage medium, in which a computer program is stored, which, when executed by a processor, implements the above-mentioned approval data query method.
The invention provides an examination and approval data query method, an examination and approval data query device, computer equipment and a storage medium, wherein an examination and approval data query request is received, an examination and approval event list of a preset time period is obtained, and the examination and approval event list comprises a plurality of examination and approval events; acquiring an approval time list corresponding to each approval event in an approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event; determining the data attribute of each approval time in the approval time list; and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data. Compared with the abnormal data containing special conditions in the current approval events, the method obtains the approval time lists respectively corresponding to the approval events in the approval event lists, then determines the approval time of the normal constant data in the approval time lists, and finally calculates the average time of the approval object processing and/or the average time of the approval event processing according to the approval time of the normal data, thereby improving the accuracy of the calculation of the approval average time.
Drawings
FIG. 1 is a flowchart of an approval data query method according to a first embodiment of the present application;
FIG. 2 is a diagram illustrating statistics of approval durations of approval events in an embodiment of the present application;
FIG. 3 is a flowchart of an approval data query method according to a second embodiment of the present application;
FIG. 4 is a block diagram of an approval data query apparatus according to an embodiment of the present application;
fig. 5 is a schematic diagram of a computer device according to an embodiment of the present application.
Detailed Description
In order to better understand the technical solutions described above, the technical solutions of the embodiments of the present application are described in detail below with reference to the drawings and the specific embodiments, and it should be understood that the specific features of the embodiments and the embodiments of the present application are detailed descriptions of the technical solutions of the embodiments of the present application, and are not limitations of the technical solutions of the present application, and the technical features of the embodiments and the embodiments of the present application may be combined with each other without conflict.
First embodiment
Referring to fig. 1, a method for inquiring approval data according to a first embodiment of the present invention is shown, the method specifically includes steps S10-S50:
step S10, receiving an approval data query request, where the request includes an average time of processing an approval object and/or an average time of processing an approval event that requests to query.
The method comprises multiple types of approval events, each approval event needs one or more approval objects to approve, each approval object corresponds to approval processing time when approving the approval event, the approval time is determined according to the time when the approval object receives the approval event and the time for processing the approval event, different approval objects have different rights, and the specific approval object is an approver or a user with a specific right. For example, if the time when the approval object a receives the approval event 1 is 12:30 at 11/16/2020, and the time when the approval object a processes the approval event 1 is 12:50 at 11/16/2020, the approval processing time for the approval object a to the approval event 1 is 20 minutes.
The average time for processing the approval events by the approval objects is the average time for processing the approval events by each approval object, for example, the average time for processing the approval events by the approval object a is 2 hours, and the average time for processing the approval events by the approval object B is 3 hours. Here, the average time of the process to be approved is obtained by accumulating and averaging the times of all the approval events processed corresponding to the subject of approval. For example, if there is one approval object a that processes approval events of approval event 1, approval event 2, and approval event 2, respectively, and if it takes 1 hour to process approval event 1, 2 hours to process approval event 2, and 1 hour to process approval event 3, the average time for processing the approval events by the approval object a is 2 hours.
The average time for processing the approval events is the average time for processing some type of approval events, for example, for the approval events of labor cooperation type, the average time for processing is 40 hours; for the approval event of the engineering change class, the average time of the processing is 35 hours. It should be noted that the average time of the processing of the approval event is the accumulated average value of the processing times of all the objects in the corresponding type of approval event. For example, for an approval event of the labor cooperation class (including an approval event 1 and an approval event 2), wherein 3 approval objects are required to be approved, namely an approval person a, an approval person B and an approval person C, if the processing time of the approval person a is 1 hour, the processing time of the approval person B is 1 hour and the processing time of the approval person C is 2 hours for the approval event 1, and the processing time of the approval person a is 2 hours, the processing time of the approval person B is 2 hours and the processing time of the approval person C is 2 hours for the approval event 2, the average time of the approval event of the labor cooperation class is finally calculated to be 5 hours.
It should be noted that, in this embodiment, in addition to requesting the average time of processing of the query and approval object and/or the average time of processing of the approval event, the maximum time and the minimum time of processing of the query and approval object and the maximum time and the minimum time of processing of the query and approval event may also be requested, that is, the processing time of the query and approval object and the processing time of the approval event may be sorted from large to small or from small to large in this embodiment of the present invention, which is not specifically limited in this embodiment.
And step S20, acquiring an approval event list of the preset time period.
The preset time period may be about one week, about one month, or about three months, and the embodiment of the present invention is not limited specifically. The approval event list comprises a plurality of approval events, and a specific approval event list can be represented as E ═ E {1，e2，...,en}，eiFor a particular approval event, n is the number of approval events.
Step S30, obtaining an approval time list corresponding to each approval event in the approval event list.
And the examination and approval event list comprises the examination and approval time for processing the examination and approval event by each examination and approval object in the corresponding examination and approval event. For any approval event eiObtaining an approval event eiTime list T ofi＝{Ti1，Ti2，...，TimM is a processing approval event eiThe number of approved objects.
For example, an approval event columnThe table is E ═ E1，e2，...,enFor the approval events e in the approval event list2The corresponding approval time list is T2＝{T21，T22，...，T2mWhere m needs to handle an approval event e2The number of approved objects. If m is 5, then e is said to be an approval event25 approval objects are needed for processing, namely, the approval time list is T2＝{T21，T22，T23，T24，T25In which T is21Processing an approval event e for the 1 st object of approval2Required approval time, T22Processing an approval event e for the 2 nd object of approval2Required approval time, T23Processing an approval event e for the 3 rd approval object2Required approval time, T24Processing an approval event e for the 4 th approval object2Required approval time, T25Processing an approval event e for the 5 th approval object2Required approval time.
And step S40, determining the data attribute of each approval time in the approval time list.
It should be noted that, because the approval objects have uncertainty in the working time in daily work, if a special condition is met, a very small number of approval events have very long stay time at a certain approval object, which obviously exceeds the normal approval stay time range, belong to abnormal data under the special condition, are not included in the examination statistical range, and need to be identified and screened. Therefore, in this embodiment, it is further required to determine the data attribute of each approval time in the approval time list, that is, to discriminate the abnormal or normal approval time in the approval time list. Specifically, the data attribute is abnormal data or normal data.
Step S50, calculating the average time of the approval target process and/or the average time of the approval event process according to the approval time of the normal data, and outputting the average time of the approval target process and/or the average time of the approval event process.
In the embodiment of the invention, after the data attribute of each approval time in the approval time list is determined, the average time of the approval object processing and/or the average time of the approval event processing are/is calculated according to the approval time of normal data, and then the average time of the approval object processing and/or the average time of the approval event processing are/is output.
Specifically, calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data includes:
if the average time of the processing of the approval object is requested to be inquired, accumulating and summing the approval time of the normal data according to the approval event to obtain the total approval time of the approval object, and determining the average time of the processing of the approval object according to the ratio of the total approval time of the approval object to the number of the approval objects corresponding to the normal data;
and if the average time of the processing of the approval events is requested to be inquired, accumulating and summing the approval time of the normal data in the approval events of all types according to the approval objects to obtain the total approval time of all the approval events, and determining the average time of the processing of the approval events according to the ratio of the total approval time of the approval events to the number of the approval events.
The average time of the approval event processing may be the average time of all approval objects for the approval event processing, or the average time of a certain approval object for the approval event processing. For example, if there are an approval object a and an approval object B, the average time for the approval object a to process the approval events may be calculated, for example, the average time for the approval object a to process the C-class approval events is calculated, and the average time is obtained by summing and averaging the times of all the C-class approval events processed by the approval object a; the average time of the approval objects a and B for processing the approval events can also be calculated, for example, the average time of the approval objects a and B for processing the D-class approval events is calculated, and the average time is obtained by summarizing and averaging the time of all the D-class approval events processed by the approval objects a and B.
Specifically, the output average time of the approval target process and/or the presentation manner of the average time of the approval event process may be a bar graph, a line graph, an area graph, and the like, which is not specifically limited in this embodiment.
As shown in fig. 2, statistics of the approval duration are performed for each approval event according to the approval target. And integrating all types of approval events, summarizing the approval stay time of the approval process of the inspected object (the name of the corresponding person in the figure is) to obtain a statistical histogram, counting the persons by the histogram, classifying according to the approval types, and sequencing according to the type of one approval event corresponding to one histogram. The duration calculation method is the sum of the durations of all the approval processes of the type staying at the examination object. The single examination and approval process stay time calculation method is to subtract the time of the examination and approval passing/refusing/returning of the examination object by the time of the examination and approval process reaching the examination object.
The invention provides an approval data query method, which comprises the steps of receiving an approval data query request, and obtaining an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events; acquiring an approval time list corresponding to each approval event in an approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event; determining the data attribute of each approval time in the approval time list; and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data. Compared with the abnormal data containing special conditions in the current approval events, the method obtains the approval time lists respectively corresponding to the approval events in the approval event lists, then determines the approval time of the normal constant data in the approval time lists, and finally calculates the average time of the approval object processing and/or the average time of the approval event processing according to the approval time of the normal data, thereby improving the accuracy of the calculation of the approval average time.
Second embodiment
As shown in fig. 3, the method for inquiring approval data according to the second embodiment of the present invention, where determining the data attribute of each approval time in the approval time list includes:
step S401, averagely dividing the approval time into K time intervals according to the approval time in the approval time column.
Specifically, the examination and approval events are averagely divided into K time intervals by a formula Tmin + (j-1) (Tmax-Tmin)/K < ═ Tj < Tmin + j (Tmax-Tmin)/K, wherein K is preferably 5, j is 1 to K, Tmax is the maximum value of examination and approval time of the examination and approval object, and Tmin is the minimum value of examination and approval time of the examination and approval object.
For example, taking quarterly approval data of an approval object as an example, taking the maximum value and the minimum value of approval time of the approval object to obtain a numerical range Tmin and Tmax, and taking a five-equal time interval before Tmin and Tmax:
a first section T1, Tmin < ═ T1< Tmin + (Tmax-Tmin)/5
A second interval T2 Tmin + (Tmax-Tmin)/5< ═ T2< Tmin +2 (Tmax-Tmin)/5
A third interval T3 Tmin +2 (Tmax-Tmin)/5< ═ T3< Tmin +3 (Tmax-Tmin)/5
A fourth interval T4 Tmin +3 (Tmax-Tmin)/5< ═ T4< Tmin +4 (Tmax-Tmin)/5
A fifth section T5 Tmin +4 (Tmax-Tmin)/5 (T5) (Tmax)
It should be noted that the number K of the divided time intervals may be specifically determined according to the numerical range Tmin and Tmax, that is, the larger the difference between Tmin and Tmax is, the larger the number K of the time intervals may be set; the smaller the difference between Tmin and Tmax is, the smaller the number K of time intervals can be set, and the embodiment of the present invention is not particularly limited.
Step S402, counting the number Z of examination and approval events in each time intervalk。
In particular, the approval event list may be denoted as E ═ E1，e2，...,en}，eiFor a particular approval event, n is the number of approval events. For any approval event eiObtaining an approval event eiTime list T ofi＝{Ti1，Ti2，...，TimM is a processing approval event eiThe number of approved objects.
Will TiMapping to K intervals to obtain e in K intervalsiThe number of processing times Z ═ Z1，z2，......，zkIn which z is1Number of approval events, z, representing the first interval2Number of approval events, z, representing second intervalkRepresenting the number of approval events for the K-th interval.
Step S403, according to the total amount of the examination and approval events and the number Z of the examination and approval events in each time intervalkAnd determining the data attribute of each approval time in the approval time list.
Specifically, the total number of the approval events and the number Z of the approval events in each time intervalkDetermining data attributes of each approval time in the approval time list, wherein the data attributes comprise:
step S4031, calculating the number Z of examination and approval events in each time intervalkA ratio to the total number of approval events.
Step S4032, if the ratio of the current time interval is greater than a preset value, determining that all the approval times in the current time interval are normal data.
In particular, if ZkTotal number of approval events>X, then all approval times within the kth time interval are non-exceptional times. X is a preset number, and X is a% (preferably a ═ 5) when m is 20 or more, and X is b% (preferably b ═ 10) when m is less than 20.
Step S4033, if the ratio of the current time interval is smaller than or equal to the preset value and the ratios of the previous time interval and the next time interval are both greater than the preset value, it is determined that all the approval times in the current time interval are normal data.
If Z iskTotal number of approval events<X, and z(k+1)Total number of approval events>X, and z(k-1)Total number of approval events>And determining that all approval times in the kth time interval are normal data.
For example, the approval time is divided into 5 time intervals on average, and the number of approval events Z in each time interval is obtainedkCalculating the number of approval events Z1And number of approval events Z2Respectively accounting for the total amount of the approval events to obtain P1 and P5, if P1<＝X、P5<X, all approval times within the first interval T1 and the fifth interval T5 are abnormal data.
If the interval less than or equal to X is the middle interval, the data is not considered as a few abnormal data, for example, the T3 interval is less than or equal to X, and both T2 and T4 are greater than X, the approval time of the T3 interval is not considered as abnormal data.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
In an embodiment, an approval data query device is provided, and the approval data query device corresponds to the approval data query method in the above embodiments one to one. As shown in fig. 4, the detail of each functional module of the approval data query device is as follows:
the system comprises an acquisition module 10, a processing module and a display module, wherein the acquisition module is used for acquiring an approval event list of a preset time period, and the approval event list comprises a plurality of approval events;
the obtaining module 10 is further configured to obtain an approval time list corresponding to each approval event in the approval event list, where the approval event list includes approval times for processing the approval events by each approval object in the corresponding approval events;
a determining module 20, configured to determine a data attribute of each approval time in the approval time list, where the data attribute is abnormal data or normal data;
a calculating module 30, configured to calculate, according to the approval time of the normal data, an average time for processing the approval object and/or an average time for processing the approval event;
and the output module 40 is configured to output the average time of the processing of the approval object and/or the average time of the processing of the approval event.
Specifically, the determining module 20 includes:
the dividing unit 21 is configured to averagely divide the approval time into K time intervals according to the approval time in the approval time column;
a statistical unit 22 for counting the number Z of approval events in each of the time intervalsk；
A determining unit 23, configured to determine the total number of the approval events and the number Z of the approval events in each of the time intervalskAnd determining the data attribute of each approval time in the approval time list.
Further, the determining unit 23 is further configured to:
calculating the number Z of examination and approval events in each time intervalkA ratio to the total number of approval events;
if the ratio of the current time interval is larger than a preset value, determining that all the approval times in the current time interval are normal data;
and if the ratio of the current time interval is less than or equal to the preset value and the ratios of the previous time interval and the next time interval are both greater than the preset value, determining that all the approval times in the current time interval are normal data.
Specifically, the preset value is determined according to the total number of the event numbers.
Specifically, the calculating module 30 includes:
if the average time of the processing of the approval object is requested to be inquired, accumulating and summing the approval time of the normal data according to the approval event to obtain the total approval time of the approval object, and determining the average time of the processing of the approval object according to the ratio of the total approval time of the approval object to the number of the approval objects corresponding to the normal data;
and if the average time of the processing of the approval events is requested to be inquired, accumulating and summing the approval time of the normal data in the approval events of all types according to the approval objects to obtain the total approval time of all the approval events, and determining the average time of the processing of the approval events according to the ratio of the total approval time of the approval events to the number of the approval events.
For specific limitations of the approval data query device, reference may be made to the above limitations of the approval data query method, which are not described herein again. The various modules in the above-described apparatus may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 5. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of approving a data query.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
receiving an approval data query request, wherein the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event;
acquiring an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events;
acquiring an approval time list corresponding to each approval event in the approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event;
determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data, and outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
receiving an approval data query request, wherein the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event;
acquiring an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events;
acquiring an approval time list corresponding to each approval event in the approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event;
determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data, and outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. An approval data query method, the method comprising:
receiving an approval data query request, wherein the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event;
acquiring an approval event list of a preset time period, wherein the approval event list comprises a plurality of approval events;
acquiring an approval time list corresponding to each approval event in the approval event list, wherein the approval event list comprises approval time for processing the approval event by each approval object in the corresponding approval event;
determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
and calculating the average time of the processing of the approval object and/or the average time of the processing of the approval event according to the approval time of the normal data, and outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
2. The method according to claim 1, wherein the determining the data attribute of each approval time in the list of approval times comprises:
according to the approval time in the approval time column, averagely dividing the approval time into K time intervals;
counting the number Z of examination and approval events in each time intervalk；
According to the total amount of the examination and approval events and the number Z of the examination and approval events in each time intervalkAnd determining the data attribute of each approval time in the approval time list.
3. The method for inquiring approval data according to claim 2, wherein the total number of approval events and the number of approval events Z in each time interval are determined according to the total number of approval eventskDetermining data attributes of each approval time in the approval time list, wherein the data attributes comprise:
calculating the number Z of examination and approval events in each time intervalkA ratio to the total number of approval events;
if the ratio of the current time interval is larger than a preset value, determining that all the approval times in the current time interval are normal data;
and if the ratio of the current time interval is less than or equal to the preset value and the ratios of the previous time interval and the next time interval are both greater than the preset value, determining that all the approval times in the current time interval are normal data.
4. The approval data query method of claim 3, wherein the preset value is determined according to a total number of events.
5. The method for inquiring approval data according to claim 3, wherein the step of calculating the average time of the approval object processing and/or the average time of the approval event processing according to the approval time of the normal data comprises:
if the average time of the processing of the approval object is requested to be inquired, accumulating and summing the approval time of the normal data according to the approval event to obtain the total approval time of the approval object, and determining the average time of the processing of the approval object according to the ratio of the total approval time of the approval object to the number of the approval objects corresponding to the normal data;
and if the average time of the processing of the approval events is requested to be inquired, accumulating and summing the approval time of the normal data in the approval events of all types according to the approval objects to obtain the total approval time of all the approval events, and determining the average time of the processing of the approval events according to the ratio of the total approval time of the approval events to the number of the approval events.
6. An approval data query apparatus, the apparatus comprising:
the system comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving an approval data query request, and the request comprises the average time of processing an approval object requested to be queried and/or the average time of processing an approval event;
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring an approval event list of a preset time period, and the approval event list comprises a plurality of approval events;
the acquisition module is further configured to acquire an approval time list corresponding to each approval event in the approval event list, where the approval event list includes approval times for processing the approval events by each approval object in the corresponding approval events;
the determining module is used for determining the data attribute of each approval time in the approval time list, wherein the data attribute is abnormal data or normal data;
the calculation module is used for calculating the average time of the processing of the examination and approval object and/or the average time of the processing of the examination and approval event according to the examination and approval time of the normal data;
and the output module is used for outputting the average time of the processing of the approval object and/or the average time of the processing of the approval event.
7. The approval data query device of claim 6, wherein the determination module comprises:
the dividing unit is used for averagely dividing the approval time into K time intervals according to the approval time in the approval time column;
a statistic unit for counting the number Z of approval events in each time intervalk；
A determining unit for determining the total number of the examination and approval events and the number Z of the examination and approval events in each time intervalkAnd determining the data attribute of each approval time in the approval time list.
8. The approval data query device of claim 7, wherein the determining unit is further configured to:
calculating the number Z of examination and approval events in each time intervalkA ratio to the total number of approval events;
if the ratio of the current time interval is larger than a preset value, determining that all the approval times in the current time interval are normal data;
and if the ratio of the current time interval is less than or equal to the preset value and the ratios of the previous time interval and the next time interval are both greater than the preset value, determining that all the approval times in the current time interval are normal data.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the approval data query method of any one of claims 1 to 5 when executing the computer program.
10. A computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out the approval data query method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011495655.2A CN112712331A (en) | 2020-12-17 | 2020-12-17 | Approval data query method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011495655.2A CN112712331A (en) | 2020-12-17 | 2020-12-17 | Approval data query method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112712331A true CN112712331A (en) | 2021-04-27 |
Family
ID=75544021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011495655.2A Pending CN112712331A (en) | 2020-12-17 | 2020-12-17 | Approval data query method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112712331A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102945519A (en) * | 2012-10-23 | 2013-02-27 | 中国建设银行股份有限公司 | Internal work approval process management system of bank |
| CN107169743A (en) * | 2017-05-25 | 2017-09-15 | 大连云匠科技有限公司 | Flow nodes approver's Efficiency Statistics method for OA system subscriber terminals |
| CN111813624A (en) * | 2020-06-29 | 2020-10-23 | 中国平安人寿保险股份有限公司 | Robot execution time length estimation method based on time length analysis and related equipment thereof |
-
2020
- 2020-12-17 CN CN202011495655.2A patent/CN112712331A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102945519A (en) * | 2012-10-23 | 2013-02-27 | 中国建设银行股份有限公司 | Internal work approval process management system of bank |
| CN107169743A (en) * | 2017-05-25 | 2017-09-15 | 大连云匠科技有限公司 | Flow nodes approver's Efficiency Statistics method for OA system subscriber terminals |
| CN111813624A (en) * | 2020-06-29 | 2020-10-23 | 中国平安人寿保险股份有限公司 | Robot execution time length estimation method based on time length analysis and related equipment thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Kaminskyi et al. | Recovery Gaps in Experimental Data. | |
| CN108492005B (en) | Project data processing method and device, computer equipment and storage medium | |
| CN108920498B (en) | Data query method, device and equipment | |
| CN110704675B (en) | Object management method, device, computer equipment and storage medium | |
| CN110929994A (en) | Enterprise associated risk analysis method, device, equipment and storage medium | |
| CN112101584A (en) | Nuclear power station spare part systematic maintenance method, device, equipment and storage medium | |
| CN110706016A (en) | Method and device for detecting business abnormity and computer readable storage medium | |
| CN108629050B (en) | Service data adjustment method, device, computer equipment and storage medium | |
| CN110084476B (en) | Case adjustment method, device, computer equipment and storage medium | |
| CN112750027A (en) | Batch business processing method and device, computer equipment and storage medium | |
| CN109190929B (en) | Workload allocation method and device, computer equipment and storage medium | |
| CN107844496B (en) | Statistical information output method and device | |
| CN112712331A (en) | Approval data query method and device, computer equipment and storage medium | |
| CN110134680B (en) | Space monitoring method and device, computer equipment and storage medium | |
| CN110489394B (en) | Intermediate data processing method and device | |
| CN109542947B (en) | Data statistical method, device, computer equipment and storage medium | |
| CN115202890B (en) | Data element production resource space distribution method, system and equipment | |
| US20210064452A1 (en) | Assigning a severity level to a computing service using tenant telemetry data | |
| CN112860763B (en) | Real-time streaming data processing method and device, computer equipment and storage medium | |
| CN111814001B (en) | Method and device for feeding back information | |
| CN113094241A (en) | Method, device and equipment for determining accuracy of real-time program and storage medium | |
| CN112559805A (en) | Index optimization method and device | |
| CN110969430A (en) | Method and device for identifying suspicious user, computer equipment and storage medium | |
| CN114401494B (en) | Short message issuing abnormality detection method, device, computer equipment and storage medium | |
| CN110377592B (en) | Data preprocessing method and device for quantifying variable to virtual variable and terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 310020 floor 5, building 5, No. 206, Xinglu Road, Jianggan District, Hangzhou City, Zhejiang Province Applicant after: Zhejiang Gaoxin Technology Co.,Ltd. Address before: 310020 floor 5, building 5, No. 206, Xinglu Road, Jianggan District, Hangzhou City, Zhejiang Province Applicant before: ZHEJIANG HIGHWAY INFORMATION ENGINEERING TECHNOLOGY CO.,LTD. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210427 |
|
| RJ01 | Rejection of invention patent application after publication |