CN111428459A - Staff transaction amount statistical method and device - Google Patents
Staff transaction amount statistical method and device Download PDFInfo
- Publication number
- CN111428459A CN111428459A CN202010228131.0A CN202010228131A CN111428459A CN 111428459 A CN111428459 A CN 111428459A CN 202010228131 A CN202010228131 A CN 202010228131A CN 111428459 A CN111428459 A CN 111428459A
- Authority
- CN
- China
- Prior art keywords
- transaction amount
- database
- work completion
- employee
- completion information
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a device for counting employee transaction amount, wherein the method for counting the employee transaction amount comprises the following steps: summarizing the current day work completion information loaded into the pipeline database according to preset conditions; screening the collected current day work completion information to obtain staff transaction amount information; and generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table. The method and the device at least solve the problem that in the prior art, when staff transaction amount statistics is carried out, Excel is greatly depended on, and efficiency is low when a function in the Excel processes a large amount of data.
Description
Technical Field
The application belongs to the technical design field of financial industry database warehouses, and particularly relates to a method and a device for counting employee transaction amount.
Background
In the financial field, in order to count the transaction amount of employees, the transactions made by all the employees are exported to the same database in a Trigger mode, then the data in the database is extracted into an Excel form by a data extraction tool, and finally useful data is extracted through a function in the Excel form to generate a final form for a manager to use. However, because the number of employees is increasingly huge, tens of thousands of transactions may be imported into the database every day, executing the Trigger under the huge data volume consumes the database resources, and the content of the finally extracted Excel table is also extremely huge, so the process of extracting data through the self-carried function of the Excel table is very slow, and the efficiency is low.
Disclosure of Invention
The application provides a method and a device for counting employee transaction amount, which at least solve the problem that the existing method needs to completely rely on Excel when counting the employee transaction amount, and the function in the Excel responds slowly when processing a large amount of data.
According to one aspect of the application, a statistical method for employee transaction amount is provided, which comprises the following steps:
summarizing the current day work completion information loaded into the pipeline database according to preset conditions;
screening the collected current day work completion information to obtain staff transaction amount information;
and generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
In one embodiment, the preset conditions include: idle time; summarizing the current day work completion information loaded into the pipeline database according to preset conditions, wherein the summarizing comprises the following steps:
determining the idle time of the pipeline database according to the area and the corresponding time zone, and taking the idle time as data summarizing time;
and summarizing the current day work completion information in the pipeline database according to the data summarizing time.
In one embodiment, the preset conditions include: resource usage level of the pipeline database; summarizing the current day work completion information loaded into the pipeline database according to preset conditions, wherein the summarizing comprises the following steps:
and monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
In one embodiment, the aggregating the work completion information of the current day in the pipeline database according to the data aggregating time includes: and acquiring the current day work completion information from the pipeline database at regular time according to the data summarizing time and storing the current day work completion information into the convergence database.
In one embodiment, when the resource usage level of the pipeline database is lower than a preset threshold, the aggregating of the work completion information of the current day in the pipeline database includes: and when the resource utilization degree of the pipeline is lower than a preset threshold value, sending a prompt, calling all the work completion information of the current day in the pipeline database, and storing the work completion information of the current day in the convergence database.
In one embodiment, the step of filtering the summarized work completion information of the current day to obtain the staff transaction amount information includes:
generating a SQ L query statement according to a preset transaction key field;
and screening from the aggregated database by using SQ L query statements to obtain employee transaction amount information.
In one embodiment, generating an employee transaction amount report according to the employee transaction amount information and a pre-acquired organization-employee mapping relationship table includes:
counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees;
and generating a staff transaction amount report of each organization.
According to another aspect of the application, a statistical device for employee transaction amount is also provided, which comprises:
the summarizing unit is used for summarizing the current day work completion information loaded into the pipeline database according to preset conditions;
the screening unit is used for screening the collected work completion information of the current day to obtain the staff transaction amount information;
and the report generation unit is used for generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
In one embodiment, the preset conditions include: idle time; the summarization unit includes:
the data summarizing time determining module is used for determining the idle time of the pipeline database according to the area and the corresponding time zone, and taking the idle time as the data summarizing time;
and the aggregation module is used for aggregating the current day work completion information in the pipeline database according to the data aggregation time.
In one embodiment, the preset conditions include: resource usage level of the pipeline database; the summarization unit includes:
and the monitoring and summarizing module is used for monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
In one embodiment, the convergence module comprises: and the first acquisition and storage module is used for acquiring the work completion information of the day from the pipeline database at regular time according to the data summarizing time and storing the work completion information of the day into the convergence database.
In one embodiment, the monitoring and summarizing module comprises: and the second acquisition and storage module is used for sending a prompt and calling all the work completion information of the current day in the pipeline database and storing the work completion information of the current day into the convergence database when the resource utilization degree of the pipeline is lower than a preset threshold value.
In one embodiment, the screening unit includes:
the query statement generating module is used for generating SQ L query statements according to preset transaction key fields;
and the transaction amount information acquisition module is used for screening from the aggregation database by using SQ L query statements to acquire employee transaction amount information.
In one embodiment, the report generation unit includes:
the statistical module is used for counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees;
and the report module is used for generating employee transaction amount reports of all the institutions.
According to the method and the device, the condition of low resource shortage and efficiency caused by gathering in busy time of the pipeline database is avoided by judging the idle time of the pipeline database.
According to the method and the device, the query statement is configured, and the query statement is utilized to directly screen the related data in the converged database to replace the traditional Excel form to screen the related data, so that the effect of integrally improving the efficiency of staff transaction amount statistics is achieved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a statistical method for employee transaction amount according to the present application.
Fig. 2 is a schematic diagram illustrating importing information in a pipeline database into a shoon tool in an embodiment of the present application.
Fig. 3 is a flowchart of a method for summarizing the work completion information of the current day loaded into the pipeline database according to a preset condition in the embodiment of the present application.
Fig. 4 is a schematic diagram of a corresponding aggregated database that summarizes data into different pipelines in the embodiment of the present application.
Fig. 5 is a flowchart of a method for obtaining employee transaction amount information by screening the summarized work completion information on the same day in the embodiment of the present application.
FIG. 6 is a flowchart of a method for generating an employee transaction amount report in an embodiment of the present application
Fig. 7 is a block diagram of a structure of a device for counting employee transaction amounts according to the present application.
Fig. 8 is a block diagram of a structure of a summary unit in the embodiment of the present application.
Fig. 9 is a block diagram of a screening unit in the embodiment of the present application.
Fig. 10 is a block diagram of a report generation unit in the embodiment of the present application.
Fig. 11 is a specific implementation of an electronic device in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the bank industry, especially when the transaction amount of employees in a row is counted, the transactions made by all employees are generally exported to a unified database, then the data in the database is extracted into an Excel table form through a data extraction tool, and finally useful data is extracted by using a function in the Excel table to form a final table, but the method is only suitable for the case that the number of employees is small, in the actual work of the bank, the number of employees is usually up to ten thousand, and up to tens of thousands of transactions are possibly imported every day, and at the moment, if the existing method is still used, not only the resource consumption of the database is too large, but also the function execution speed in the Excel is slow, the application adopts a spoon L (Extract, Transform, L oad warehouse data technology) tool to count the transaction amount of employees, as shown in fig. 1, and comprises the following steps:
s101: and summarizing the current day work completion information loaded into the pipeline database according to preset conditions.
In a specific embodiment, the daily job completion information is information of all jobs completed by the in-line staff on the same day, and includes job information such as transaction, account opening, account selling, examination and approval. As shown in fig. 2, the work completion information of the current day is first loaded into the pipeline database, then the work completion information of the current day loaded into the pipeline database is imported into the zoon tool according to the set conditions (such as data summarization time) by the zoon tool according to the test requirements, and the work completion information of the current day is further summarized into the aggregated database by the zoon tool.
S102: and screening the summarized current day work completion information to obtain staff transaction amount information.
In a specific embodiment, a SQ L query statement is generated in a spaon tool and is used for directly screening the current day work completion information stored in the aggregation database to obtain the employee transaction amount information.
S103: and generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
In one embodiment, each branch office of the bank provides a record (copy) of employee data of each office in advance, and the office where each employee is located is recorded in detail in the record, and a mapping relation table between the office and the employee can be established by using the record. After the mapping relation table between the institutions and the employees is obtained, the transaction amount of each employee in each institution and the transaction amount of each institution can be known according to the employee transaction amount information (namely the number of transactions completed by each employee on the day, the transaction amount and the like).
The execution main body of the method shown in fig. 1 can be a PC, a terminal and the like, and a traditional Excel statistical mode is replaced by a speon tool, so that the effect of greatly improving the staff transaction amount statistical efficiency is realized.
In one embodiment, the preset conditions include: idle time; summarizing the work completion information of the current day loaded into the pipeline database according to preset conditions, as shown in fig. 3, the method includes:
s301: and determining the idle time of the pipeline database according to the area and the corresponding time zone, and taking the idle time as data summarizing time.
In one embodiment, since the bank employees are distributed around the world (e.g., north america, asia-pacific regions, etc.), employees in different regions correspond to different hours of work and trips. Generally, the database of the non-working time is in an idle state, so that the working time, that is, the idle time of the database, can be calculated according to the area where the employee is located and the time zone corresponding to the area. The idle time of the database is used as the data summarizing time, so that the problem of low efficiency caused by overload of database resources due to data summarizing when the database is busy can be solved.
S302: and summarizing the current day work completion information in the pipeline database according to the data summarizing time.
In a specific embodiment, when the daily database is idle, the step of summarizing the daily work information is completed by summarizing the data into the corresponding aggregated databases of different pipelines (as shown in fig. 4).
According to the method and the system, the corresponding off-duty time (namely the non-busy time) of the staff is deduced through the area where the staff is located, so that the off-peak time of the production line database is determined, and the function of acquiring information in the off-peak time of the production line database is realized, and the information acquisition speed is improved.
In one embodiment, the preset conditions include: resource usage level of the pipeline database; summarizing the current day work completion information loaded into the pipeline database according to preset conditions, wherein the summarizing comprises the following steps:
and monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
In a specific embodiment, the resource usage degree of the pipeline database may also be monitored in real time, a real-time numerical value of the resource usage degree of the pipeline database is obtained, and when the resource usage degree of the pipeline database is lower than a preset threshold (for example, 60%), and the resource usage degree of the pipeline database is maintained for a certain time (for example, 1 hour) within a range lower than the preset threshold, the pipeline database may be determined to be in an idle state at that time, and at this time, the work completion information of the current day in the pipeline database may be summarized.
In one embodiment, the aggregating the work completion information of the current day in the pipeline database according to the data aggregating time includes: and acquiring the current day work completion information from the pipeline database at regular time according to the data summarizing time and storing the current day work completion information into the convergence database.
In a specific embodiment, when the monitored usage degree of the pipeline database resource is lower than a threshold value within a certain time period, the pipeline database is determined to be in an idle state, and the current time is the appropriate data summarization time. At this time, the data is collected into the corresponding aggregated databases of different pipelines (as shown in fig. 4), and the step of collecting the work information of the day is completed.
In one embodiment, when the resource usage level of the pipeline database is lower than a preset threshold, the aggregating of the work completion information of the current day in the pipeline database includes: and when the resource utilization degree of the pipeline is lower than a preset threshold value, sending a prompt, calling all the work completion information of the current day in the pipeline database, and storing the work completion information of the current day in the convergence database.
In a specific embodiment, when the resource usage level of the pipeline database is lower than a preset threshold (for example, 60%), the pipeline database is in a non-busy state, a prompt is sent to a manager or a statistics user (prompting that the pipeline database is in an idle state at this time), and then the work completion information of the current day is summarized into the aggregation database corresponding to each pipeline.
In an embodiment, the filtering the summarized work completion information of the current day to obtain the employee transaction amount information, as shown in fig. 5, includes:
and S501, generating an SQ L query statement according to the preset transaction key field.
In one embodiment, the preset transaction key fields include more than ten keywords including a date of the day field (cur _ date), a menu name (menu _ name), a menu number (menu _ id), an organization number (instad), and the like, so as to ensure the basis of the searched data.
And S502, screening from the aggregated database by using SQ L query statements to obtain employee transaction amount information.
In a specific embodiment, the SQ L query statement generated in S501 is used to perform query in the aggregated database, and the entries with the transaction types of simpletraction and BatchTransaction are extracted to obtain the required employee transaction amount information.
According to the method, the SQ L query sentence is generated and is directly screened from the aggregated database, the method replaces a method of screening data by using an Excel function, and the effect of speed increase when a large amount of data is processed is achieved.
In an embodiment, the generating of the employee transaction amount report according to the employee transaction amount information and the pre-obtained organization-employee mapping relationship table as shown in fig. 6 includes:
s601: and counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees.
In a specific embodiment, a mapping relationship table between institutions and employees can be obtained by using pre-obtained copies of employee data of the institutions, so as to count the employee transaction amount of each institution, for example, the employee transaction amount information includes: employee A transacts 4 times, employee B transacts 5 times, and employee C transacts 3 times; the mapping relation table of the mechanism and the staff is as follows: employees a and C belong to organization 1 and employee B belongs to organization 2, so the employee transaction volume for organization 1 is 7 and the employee transaction volume for organization 2 is 5.
S602: and generating a staff transaction amount report of each organization.
In one embodiment, the employee transaction amount report of each organization is generated according to the information (including the employee transaction amount data of each organization and the transaction amount data of each employee) obtained in S601 for reference of the manager. After the spoon extracts the data of daily employee transaction amount, cleaning the content in the current database to avoid repeated statistics.
According to the method and the system, the staff transaction amount reports of all the institutions are automatically generated, so that the conditions of all the institutions are presented in a chart form, data can be clear at a glance, and management of all the institutions by management layer personnel is facilitated.
The method and the device utilize the spoon tool, acquire the work completion information of the current day from the production line database by judging the busy time of the production line database, avoid the congestion of the production line database in the peak using period, and accordingly improve the information acquisition efficiency.
According to the method and the device, SQ L query sentences are generated through the keywords, then staff transaction amount information meeting conditions is directly screened from the aggregated database by using the query sentences, and compared with a traditional Excel function, the function of improving screening speed under the condition of a large amount of data is achieved.
According to the method and the device, the mapping relation table of the mechanism in the staff is generated in advance, the manual searching of the corresponding relation between the staff and the mechanism is replaced, the time is saved, and the efficiency is improved.
Based on the same inventive concept, the embodiment of the present application further provides a device for counting employee transaction amounts, which can be used to implement the method described in the above embodiment, as described in the following embodiments. Because the principle of the statistic device for the employee transaction amount for solving the problems is similar to the statistic method for the employee transaction amount, the implementation of the statistic device for the employee transaction amount can refer to the implementation of the statistic method for the employee transaction amount, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. While the system described in the embodiments below is preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.
The present application further provides a device for counting employee transaction amount, as shown in fig. 7, including:
the summarizing unit 701 is used for summarizing the current-day work completion information loaded into the pipeline database according to preset conditions;
the screening unit 702 is configured to screen the summarized work completion information of the current day to obtain the staff transaction amount information;
and the report generating unit 703 is configured to generate an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization-employee mapping relationship table.
In one embodiment, the preset conditions include: idle time; as shown in fig. 8, the summarizing unit 701 includes:
a data summarizing time determining module 801, configured to determine idle time of the pipeline database according to the area and the corresponding time zone, and use the idle time as data summarizing time;
the aggregation module 802 is configured to aggregate the work completion information in the pipeline database on the same day according to the data aggregation time.
In one embodiment, the preset conditions include: resource usage level of the pipeline database; the summarization unit includes:
and the monitoring and summarizing module is used for monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
In one embodiment, the convergence module comprises: and the first acquisition and storage module is used for acquiring the work completion information of the day from the pipeline database at regular time according to the data summarizing time and storing the work completion information of the day into the convergence database.
In one embodiment, the monitoring and summarizing module comprises: and the second acquisition and storage module is used for sending a prompt and calling all the work completion information of the current day in the pipeline database and storing the work completion information of the current day into the convergence database when the resource utilization degree of the pipeline is lower than a preset threshold value.
In one embodiment, as shown in fig. 9, the screening unit 702 includes:
a query statement generating module 901, configured to generate an SQ L query statement according to a preset transaction key field;
and the transaction amount information acquisition module 902 is configured to perform screening from the aggregated database by using an SQ L query statement to obtain employee transaction amount information.
In an embodiment, as shown in fig. 10, the report generating unit 703 includes:
the statistical module 1001 is used for counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees;
and the report module 1002 is used for generating employee transaction amount reports of each organization.
According to the method and the system, time consumed by manual statistics of staff transaction amount and possible human errors in the prior art are reduced by using a spoon tool, required information obtained by directly inquiring in a converged database by constructing SQ L statements is used for replacing inquiry and screening by using functions in Excel, so that screening efficiency is higher, meanwhile, data are obtained from the database at a peak using period of the database, so that the resource burden of the database is reduced, and working efficiency is improved.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
An embodiment of the present application further provides a specific implementation manner of an electronic device, which is capable of implementing all steps in the method in the foregoing embodiment, and referring to fig. 11, the electronic device specifically includes the following contents:
a processor (processor)1101, a memory 1102, a Communications Interface 1103, a bus 1104, and a non-volatile memory 1105;
the processor 1101, the memory 1102 and the communication interface 1103 complete mutual communication through the bus 1104;
the processor 1101 is configured to call the computer programs in the memory 1102 and the nonvolatile memory 1105, and when the processor executes the computer programs, the processor implements all the steps in the method in the foregoing embodiments, for example, when the processor executes the computer programs, the processor implements the following steps:
s101: and summarizing the current day work completion information loaded into the pipeline database according to preset conditions.
S102: and screening the summarized current day work completion information to obtain staff transaction amount information.
S103: and generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
Embodiments of the present application also provide a computer-readable storage medium capable of implementing all the steps of the method in the above embodiments, where the computer-readable storage medium stores thereon a computer program, and the computer program when executed by a processor implements all the steps of the method in the above embodiments, for example, the processor implements the following steps when executing the computer program:
s101: and summarizing the current day work completion information loaded into the pipeline database according to preset conditions.
S102: and screening the summarized current day work completion information to obtain staff transaction amount information.
S103: and generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the hardware + program class embodiment, since it is substantially similar to the method embodiment, the description is simple, and the relevant points can be referred to the partial description of the method embodiment. Although embodiments of the present description provide method steps as described in embodiments or flowcharts, more or fewer steps may be included based on conventional or non-inventive means. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual apparatus or end product executes, it may execute sequentially or in parallel (e.g., parallel processors or multi-threaded environments, or even distributed data processing environments) according to the method shown in the embodiment or the figures. The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, the presence of additional identical or equivalent elements in a process, method, article, or apparatus that comprises the recited elements is not excluded. For convenience of description, the above devices are described as being divided into various modules by functions, and are described separately. Of course, in implementing the embodiments of the present description, the functions of each module may be implemented in one or more software and/or hardware, or a module implementing the same function may be implemented by a combination of multiple sub-modules or sub-units, and the like. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form. The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, embodiments of the present description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present description may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and so forth) having computer-usable program code embodied therein. The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction. The above description is only an example of the embodiments of the present disclosure, and is not intended to limit the embodiments of the present disclosure. Various modifications and variations to the embodiments described herein will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present specification should be included in the scope of the claims of the embodiments of the present specification.
Claims (16)
1. A statistical method for employee transaction amount is characterized by comprising the following steps:
summarizing the current day work completion information loaded into the pipeline database according to preset conditions;
screening the collected current day work completion information to obtain staff transaction amount information;
and generating an employee transaction amount report according to the employee transaction amount information and a pre-acquired organization and employee mapping relation table.
2. Statistical method according to claim 1, characterized in that said preset conditions comprise: idle time; the collecting the work completion information of the current day loaded into the pipeline database according to the preset conditions comprises the following steps:
determining the idle time of the pipeline database according to the area and the corresponding time zone, and taking the idle time as data summarizing time;
and summarizing the current day work completion information in the pipeline database according to the data summarizing time.
3. Statistical method according to claim 1, characterized in that said preset conditions comprise: resource usage level of the pipeline database; the collecting the work completion information of the current day loaded into the pipeline database according to the preset conditions comprises the following steps:
and monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
4. The statistical method of claim 2, wherein the aggregating the work completion information of the current day in the pipeline database according to the data aggregation time comprises: and acquiring the current-day work completion information from the pipeline database at regular time according to the data summarizing time and storing the current-day work completion information into a convergence database.
5. The statistical method of claim 3, wherein when the resource usage level of the pipeline database is lower than a preset threshold, the aggregating the work completion information of the current day in the pipeline database comprises: and when the resource utilization degree of the assembly line is lower than a preset threshold value, sending a prompt, calling all the current day work completion information in the assembly line database, and storing the current day work completion information in a convergence database.
6. A statistical method according to claim 3, wherein the filtering the aggregated work completion information of the current day to obtain employee transaction amount information comprises:
generating a SQ L query statement according to a preset transaction key field;
and screening from the aggregation database by using the SQ L query statement to obtain the employee transaction amount information.
7. The statistical method of claim 1, wherein generating the employee transaction amount report according to the employee transaction amount information and the pre-obtained organization-employee mapping relationship table comprises:
counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees;
and generating a staff transaction amount report of each organization.
8. A statistic device for employee transaction amount is characterized by comprising:
the summarizing unit is used for summarizing the current day work completion information loaded into the pipeline database according to preset conditions;
the screening unit is used for screening the collected work completion information of the current day to obtain the staff transaction amount information;
and the report generation unit is used for generating an employee transaction amount report according to the employee transaction amount information and the pre-acquired organization and employee mapping relation table.
9. The statistical apparatus according to claim 8, wherein the preset condition comprises: idle time; the summarization unit comprises:
the data summarizing time determining module is used for determining the idle time of the pipeline database according to the area and the corresponding time zone, and taking the idle time as the data summarizing time;
and the aggregation module is used for aggregating the work completion information in the current day in the pipeline database according to the data aggregation time.
10. The statistical apparatus according to claim 8, wherein the preset condition comprises: resource usage level of the pipeline database; the summarization unit comprises:
and the monitoring and summarizing module is used for monitoring the resource utilization degree of the pipeline database in real time, and summarizing the daily work completion information in the pipeline database when the resource utilization degree of the pipeline database is lower than a preset threshold value.
11. The statistical apparatus of claim 9, wherein the aggregation module comprises: and the first acquisition and storage module is used for acquiring the work completion information of the current day from the pipeline database at regular time according to the data summarizing time and storing the work completion information of the current day into a convergence database.
12. The statistical apparatus of claim 10, wherein the monitoring aggregation module comprises: and the second acquisition and storage module is used for sending out a prompt and calling all the current day work completion information in the pipeline database and storing the current day work completion information into the convergence database when the resource utilization degree of the pipeline is lower than a preset threshold value.
13. The statistical apparatus of claim 10, wherein the filtering unit comprises:
the query statement generating module is used for generating SQ L query statements according to preset transaction key fields;
and the transaction amount information acquisition module is used for screening from the aggregation database by using the SQ L query statement to acquire the employee transaction amount information.
14. The statistical apparatus according to claim 8, wherein the report generation unit comprises:
the statistical module is used for counting the employee transaction amount of each organization according to the corresponding relationship between the employees and the organizations in the mapping relationship table of the organizations and the employees;
and the report module is used for generating employee transaction amount reports of all the institutions.
15. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements a statistical method of employee transaction amounts as claimed in any one of claims 1 to 7 when executing the program.
16. A computer-readable storage medium, on which a computer program is stored, wherein the computer program, when executed by a processor, implements a method for accounting of employee transaction amounts according to any one of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010228131.0A CN111428459A (en) | 2020-03-27 | 2020-03-27 | Staff transaction amount statistical method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010228131.0A CN111428459A (en) | 2020-03-27 | 2020-03-27 | Staff transaction amount statistical method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN111428459A true CN111428459A (en) | 2020-07-17 |
Family
ID=71548984
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010228131.0A Pending CN111428459A (en) | 2020-03-27 | 2020-03-27 | Staff transaction amount statistical method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111428459A (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2011258118A (en) * | 2010-06-11 | 2011-12-22 | Hitachi Ltd | Daily work report preparation supporting device and daily work report preparation supporting method |
CN108717404A (en) * | 2018-05-11 | 2018-10-30 | 广州天维信息技术股份有限公司 | A kind of data processing method and system based on performance appraisal system |
CN109313642A (en) * | 2018-09-07 | 2019-02-05 | 威富通科技有限公司 | Bill information caching method, bill information querying method and terminal device |
CN110083814A (en) * | 2019-04-09 | 2019-08-02 | 大唐微电子技术有限公司 | A kind of report form generation method and device, computer readable storage medium |
CN110532253A (en) * | 2019-09-05 | 2019-12-03 | 北京博睿宏远数据科技股份有限公司 | A kind of business diagnosis method, system and cluster |
-
2020
- 2020-03-27 CN CN202010228131.0A patent/CN111428459A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2011258118A (en) * | 2010-06-11 | 2011-12-22 | Hitachi Ltd | Daily work report preparation supporting device and daily work report preparation supporting method |
CN108717404A (en) * | 2018-05-11 | 2018-10-30 | 广州天维信息技术股份有限公司 | A kind of data processing method and system based on performance appraisal system |
CN109313642A (en) * | 2018-09-07 | 2019-02-05 | 威富通科技有限公司 | Bill information caching method, bill information querying method and terminal device |
CN110083814A (en) * | 2019-04-09 | 2019-08-02 | 大唐微电子技术有限公司 | A kind of report form generation method and device, computer readable storage medium |
CN110532253A (en) * | 2019-09-05 | 2019-12-03 | 北京博睿宏远数据科技股份有限公司 | A kind of business diagnosis method, system and cluster |
Non-Patent Citations (1)
Title |
---|
李剑波 等: "《大数据挖掘技术与应用》", 延吉:延边大学出版社, pages: 25 - 26 * |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107145586B (en) | Label output method and device based on electric power marketing data | |
CN107810500A (en) | Data quality analysis | |
CN108415964A (en) | Tables of data querying method, device, terminal device and storage medium | |
CN107247811B (en) | SQL statement performance optimization method and device based on Oracle database | |
CN109344153A (en) | The processing method and terminal device of business datum | |
CN110618911B (en) | Data monitoring method and device, storage medium and server | |
CN111127105A (en) | User hierarchical model construction method and system, and operation analysis method and system | |
CN104217004A (en) | Monitoring method and device for database hot spot of transaction system | |
CN114416891A (en) | Method, system, apparatus and medium for data processing in a knowledge graph | |
CN105447069A (en) | BW platform based account checking platform data synchronization method and system | |
CN116701525A (en) | Early warning method and system based on real-time data analysis and electronic equipment | |
CN112395370B (en) | Data processing method, device, equipment and storage medium | |
CN109768878A (en) | A kind of network work order calculation method and device based on big data | |
CN112181972A (en) | Data management method and device based on big data and computer equipment | |
CN111428459A (en) | Staff transaction amount statistical method and device | |
CN115455106B (en) | Power distribution monitoring method, service platform, equipment and storage medium for power distribution operation and maintenance | |
CN113515515B (en) | Method, device, equipment and medium for fusing customer data and power grid equipment data | |
CN109377391A (en) | A kind of tracking of information method, storage medium and server | |
CN114116908A (en) | Data management method and device and electronic equipment | |
CN112965793B (en) | Identification analysis data-oriented data warehouse task scheduling method and system | |
EP4209933A1 (en) | Data processing method and apparatus, and electronic device and storage medium | |
CN114155076A (en) | Method, device and equipment for checking business data and financial data | |
CN113392290A (en) | Data monitoring method and device and server | |
CN106528274A (en) | Electricity consumption information data processing method, electricity consumption information acquisition system and intelligent electric meter | |
CN117742975B (en) | Resource data processing method and device, storage medium and electronic 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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20220922 Address after: 12 / F, 15 / F, 99 Yincheng Road, Pudong New Area pilot Free Trade Zone, Shanghai, 200120 Applicant after: Jianxin Financial Science and Technology Co.,Ltd. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
TA01 | Transfer of patent application right |