A statistical report generation method and device

Abstract

The application discloses a statistical report generation method and device, modifies the staff number in the user table into the corresponding organization name, divides the user level of each organization name in the user table to obtain an updated user table containing the user level and the corresponding relationship of the organization name, obtains a comparison table containing the organization name and the corresponding branch number of the organization name, obtains the transaction data corresponding to each organization and the branch number contained in the transaction data, and generates a temporary statistical table, replaces the branch number in the temporary statistical table with the organization name according to the comparison table, groups the temporary statistical table to obtain each sub-statistical table containing the same organization level, determines the sub-statistical table of the same level and lower than the user level according to the user level in the updated user table, and performs association. When the user work changes or the organization affiliation changes, only the organization name needs to be modified, the change can be completed, the change efficiency is improved, and the normal work of the user is ensured.

Description

Technical Field

[0001] This application relates to the field of report processing, and in particular to a method and apparatus for generating statistical reports. Background Technology

[0002] With the widespread application of computers, software is used extensively in various fields to complete daily tasks, and reports are an indispensable part of enterprise application software systems. Statistical reports are written reports reflecting the financial status of banks, and are a comprehensive reflection of the bank's various financial activities, financial income and expenditure, and operating results.

[0003] Currently, users log in to the system using their employee ID to query and download statistical reports, thereby gaining access to the bank's current financial status. When a user's job changes or their organizational affiliation changes, they need to submit an application to the system administrator to modify the application (e.g., XX branch) or change the affiliation. Only after the modification can they query the statistical reports. Because the modification process is quite complex and involves a lot of work, the efficiency of the modification is low, which in turn affects the user's normal work.

[0004] Therefore, ensuring normal operation for users has become an urgent problem to be solved in this field. Summary of the Invention

[0005] This application provides a method and apparatus for generating statistical reports, with the aim of ensuring normal operation for users.

[0006] To achieve the above objectives, this application provides the following technical solution:

[0007] A method for generating statistical reports, comprising:

[0008] The employee IDs obtained from the user table are modified to the corresponding organization names according to their affiliated organizations, where each organization has a corresponding organization level.

[0009] The user level of each institution name in the user table is divided according to the institution level, resulting in an updated user table containing the correspondence between user level and institution name. The same institution level corresponds to the same level of user level.

[0010] Obtain a lookup table containing the organization name and its corresponding branch number;

[0011] The transaction data corresponding to each institution is obtained from the transaction database, as well as the branch number contained in the transaction data, and a temporary statistical table containing the branch number and the transaction data corresponding to the branch number is generated.

[0012] According to the aforementioned lookup table, replace the outlet number in the temporary statistics table with the organization name;

[0013] The temporary statistical table is grouped according to the institution level corresponding to the institution name to obtain sub-statistical tables containing the same institution level.

[0014] Based on the user level in the updated user table, determine the sub-statistical tables with the same level and those with lower levels, and associate them.

[0015] Optionally, generating a temporary statistical table containing branch numbers and corresponding transaction data includes:

[0016] Obtain the number of business transactions from the transaction data;

[0017] Based on the number of business transactions and the branch numbers included in the transaction data, a temporary statistical table containing branch numbers and the corresponding transaction data is generated.

[0018] Optionally, the step of grouping the temporary statistical table according to the institutional level corresponding to the institutional name to obtain sub-statistical tables containing the same institutional level includes:

[0019] Obtain each institution name and the corresponding transaction data from the temporary statistics table;

[0020] For each institution name, institutions at the same institution level and the corresponding transaction data are grouped into the same sub-statistical table to obtain sub-statistical tables containing the same institution level.

[0021] Optionally, determining sub-statistical tables for users at the same level and those at lower levels based on the user levels in the updated user table includes:

[0022] When the user level in the updated user table is a Level 1 user, the Level 1 user and the sub-statistics table below the Level 1 user are determined as the first sub-statistics table;

[0023] When the user level in the updated user table is a level 2 user, the level 2 user and the sub-statistics table below the level 2 user are determined as the second sub-statistics table; the level of the level 2 user is lower than the level of the level 1 user.

[0024] When the user level in the updated user table is a level 3 user, the level 3 user and the sub-statistics table below the level 3 user are determined as the third sub-statistics table; the level 3 user is lower than the level 2 user.

[0025] Optional, also includes:

[0026] When a query is received from a user, a statistical report corresponding to the query is displayed to the user through a preset interface; the query information includes the organization name.

[0027] A statistical report generation apparatus, comprising:

[0028] The modification unit is used to modify the employee number in the obtained user table to the corresponding organization name according to the organization to which the organization belongs, and the organization has a corresponding organization level;

[0029] The partitioning unit is used to partition the user level of each institution name in the user table according to the institution level, so as to obtain an updated user table containing the correspondence between user level and institution name, with the same institution level corresponding to the same level of user level;

[0030] The acquisition unit is used to obtain a lookup table containing the organization name and the corresponding branch number of the organization name;

[0031] The generation unit is used to obtain the transaction data corresponding to each institution from the transaction database, as well as the branch number contained in the transaction data, and generate a temporary statistical table containing the branch number and the transaction data corresponding to the branch number.

[0032] The replacement unit is used to replace the outlet number in the temporary statistics table with the organization name according to the lookup table;

[0033] A grouping unit is used to group the temporary statistical table according to the institution level corresponding to the institution name, so as to obtain sub-statistical tables containing the same institution level.

[0034] The determining unit is used to determine, based on the user level in the updated user table, sub-statistical tables with the same level and those with lower levels, and to associate them.

[0035] Optionally, the generation unit is specifically used for:

[0036] Obtain the number of business transactions from the transaction data;

[0037] Based on the number of business transactions and the branch numbers included in the transaction data, a temporary statistical table containing branch numbers and the corresponding transaction data is generated.

[0038] Optionally, the grouping unit is used for:

[0039] Obtain each institution name and the corresponding transaction data from the temporary statistics table;

[0040] For each institution name, institutions at the same institution level and the corresponding transaction data are grouped into the same sub-statistical table to obtain sub-statistical tables containing the same institution level.

[0041] Optionally, the determining unit is used for:

[0042] When the user level in the updated user table is a Level 1 user, the Level 1 user and the sub-statistics table below the Level 1 user are determined as the first sub-statistics table;

[0043] When the user level in the updated user table is a level 2 user, the level 2 user and the sub-statistics table below the level 2 user are determined as the second sub-statistics table; the level of the level 2 user is lower than the level of the level 1 user.

[0044] When the user level in the updated user table is a level 3 user, the level 3 user and the sub-statistics table below the level 3 user are determined as the third sub-statistics table; the level 3 user is lower than the level 2 user.

[0045] Optional, also includes:

[0046] The display unit is used to display statistical reports corresponding to the query information to the user through a preset interface when the user inputs query information; the query information includes the name of the organization.

[0047] The technical solution provided in this application modifies the employee numbers in the obtained user table according to their affiliated institutions to the corresponding institution names; it divides the user levels of each institution name in the user table according to the institution level, resulting in an updated user table containing the correspondence between user levels and institution names; it obtains a lookup table containing institution names and their corresponding branch numbers; it retrieves the transaction data corresponding to each institution from the transaction database, as well as the branch numbers contained in the transaction data, and generates a temporary statistical table containing branch numbers and their corresponding transaction data; based on the lookup table, it replaces the branch numbers in the temporary statistical table with institution names; it groups the temporary statistical table according to the institution level corresponding to the institution name, resulting in sub-statistical tables containing the same institution level; and based on the user levels in the updated user table, it determines the sub-statistical tables of the same level and lower user levels, and associates them. In this application, when a user's job changes or their institution affiliation changes, only the institution name needs to be modified to complete the change, improving the efficiency of the change process and thus ensuring the user's normal work. Attached Figure Description

[0048] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0049] Figure 1 A flowchart illustrating a method for generating statistical reports provided in an embodiment of this application;

[0050] Figure 2 This is a schematic diagram of the architecture of a statistical report generation device provided in an embodiment of this application. Detailed Implementation

[0051] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0052] like Figure 1 The flowchart shown is a method for generating a statistical report according to an embodiment of this application, including the following steps:

[0053] S101: Modify the employee IDs obtained from the user table to the corresponding organization names according to their respective organizations.

[0054] Among them, the institutions have corresponding institutional levels.

[0055] The institutions include, but are not limited to: XX Branch, XX Branch XX Sub-branch, XX Branch XX Sub-branch XXX Branch Office.

[0056] Organizational levels include, but are not limited to: Level 1, Level 2, and Level 3.

[0057] It should be noted that XX branch corresponds to the first-level institution, XX branch XX sub-branch corresponds to the second-level institution, and XX branch XX sub-branch XXX branch office corresponds to the third-level institution.

[0058] It is understandable that the employee ID in the user table is modified according to the organization to be affiliated with, so that there is a unique correspondence between each employee ID and the organization. For example, if the employee ID belongs to the XX branch, modifying the employee ID according to the organization to be affiliated with the corresponding organization name is equivalent to modifying the employee ID to the XX branch.

[0059] S102: Divide the user level of each organization name in the user table according to the organization level, and obtain the updated user table containing the correspondence between user level and organization name.

[0060] In this context, the same organizational level corresponds to the same user level, meaning that the user level and the organizational level correspond to the same level. For example, a level one user corresponds to a level one organization.

[0061] It should be emphasized that Level 1 users have four Chinese characters; if they have more than four characters, they should be abbreviated to four Chinese characters. Level 2 users have eight Chinese characters; if they have more than eight characters, they should be abbreviated to eight Chinese characters, and the first four characters must be consistent with the superior organization (i.e., Level 1 users). Level 3 users have no less than eight Chinese characters, and the first eight characters must be consistent with the superior organization (i.e., Level 2 users).

[0062] Understandably, the user level of each organization name in the user table is divided according to the organization level. Specifically, the organization names corresponding to Level 1 users who are consistent with Level 1 organizations are grouped into the same area, the organization names corresponding to Level 2 users who are consistent with Level 2 organizations are grouped into the same area, and the organization names corresponding to Level 3 users who are consistent with Level 3 organizations are grouped into the same area.

[0063] Specifically, assuming there are three organizational levels, namely Level 1, Level 2, and Level 3, the user level of each organizational name in the user table is divided according to the organizational level, resulting in an updated user table containing the correspondence between user level and organizational name. The specific form of the updated user table is shown in Table 1.

[0064] Table 1

[0065]

[0066]

[0067] It should be noted that the content shown in Table 1 above is for illustrative purposes only.

[0068] Understandably, users at each organizational level can only see statistical report data for their own level and the subordinate levels they manage. For example, a second-level organization can see statistical report data for its own level and the subordinate levels it manages (i.e., a third-level organization).

[0069] S103: Obtain a lookup table containing the organization name and the corresponding branch number.

[0070] The outlet number is a unique identifier for each outlet, and there is no duplicate outlet number.

[0071] Optionally, the specific format of the reference table is shown in Table 2.

[0072] Table 2

[0073] Branch Number Branch Name 460931 XX Branch XX Sub-branch XX Sub-office 460932 XX Branch XX Sub-branch XX Sub-office

[0074] It should be noted that the contents shown in Table 2 are for illustrative purposes only.

[0075] S104: Obtain the transaction data corresponding to each institution from the transaction database, as well as the branch numbers contained in the transaction data, and generate a temporary statistical table containing the branch numbers and the transaction data corresponding to the branch numbers.

[0076] Optionally, the group by function in the SQL database language can be used to generate a temporary statistical table containing the branch number and the corresponding transaction data.

[0077] The transaction data contains the branch number where the transaction occurred; therefore, the branch number can be obtained from the transaction data.

[0078] Understandably, the transaction data corresponding to each institution and the branch numbers contained in the transaction data are obtained from the transaction database, and a temporary statistical table containing the branch numbers and the corresponding transaction data is generated based on the transaction data corresponding to each institution and the branch numbers.

[0079] Optionally, in another embodiment of this application, a specific implementation of generating a temporary statistical table containing branch numbers and corresponding transaction data in step S104 includes the following steps:

[0080] Obtain the number of business transactions from transaction data.

[0081] Understandably, since transaction data includes the number of business transactions, the number of transactions can be obtained from the transaction database.

[0082] Based on the number of business transactions and the branch numbers included in the transaction data, a temporary statistical table containing branch numbers and their corresponding transaction data is generated.

[0083] Specifically, assuming there are two branch numbers, 460931 and 460932, with 256 business transactions for 460931 and 356 business transactions for 460932, a temporary statistical table containing the branch number and the corresponding transaction data is generated based on the number of business transactions and the branch number included in the transaction data. The specific format of this temporary statistical table is shown in Table 3.

[0084] Table 3

[0085] Branch Number Number of business transactions 460931 256 460932 356

[0086] It should be noted that the contents shown in Table 3 are for illustrative purposes only.

[0087] S105: Based on the comparison table, replace the outlet number in the temporary statistics table with the organization name.

[0088] Understandably, based on the lookup table, the outlet numbers in the temporary statistics table are replaced with the organization names. Specifically, for each outlet number in the temporary statistics table, the corresponding organization name is found in the lookup table, and then the outlet number in the temporary statistics table is replaced with the organization name.

[0089] S106: Group the temporary statistical table according to the institution level corresponding to the institution name to obtain sub-statistical tables containing the same institution level.

[0090] Optionally, the temporary statistics table can be grouped using the grouping statistics function in the database SQL language, group by left(institution name, number of Chinese characters in the institution name in bytes). One Chinese character corresponds to two bytes. For example, group by left(institution name, 8) groups the statistics according to the first four Chinese characters of the branch name, and group by left(institution name, 16) groups the statistics according to the first eight Chinese characters of the branch name.

[0091] It is understandable that the temporary statistical table is grouped according to the institutional level corresponding to the institutional name. Specifically, if there are three institutional levels, the temporary statistical table is grouped according to the institutional level corresponding to the institutional name. The number of sub-statistical tables containing the same institutional level is the same as the number of institutional levels, that is, three sub-statistical tables are obtained by grouping.

[0092] Optionally, in another embodiment of this application, one specific implementation of step S106 includes the following steps:

[0093] Retrieve the name of each institution from the temporary statistics table, along with the transaction data corresponding to that institution name.

[0094] Specifically, assuming the institution names are XX Branch, XX Branch XX Sub-branch, and XX Branch XX Sub-branch XX Service Center, retrieve the transaction data corresponding to XX Branch from the temporary statistics table; retrieve the corresponding transaction data from the temporary statistics table; and retrieve the transaction data corresponding to XX Branch XX Sub-branch and XX Branch XX Sub-branch XX Service Center from the temporary statistics table.

[0095] For each institution name, institutions at the same institution level, along with the corresponding transaction data, are grouped into the same sub-statistical table, resulting in sub-statistical tables containing institutions at the same institution level.

[0096] It is understandable that the names of institutions at the same level, and the transaction data corresponding to those names, are grouped into the same sub-statistical table. That is, the names of first-level institutions and the transaction data corresponding to the first-level level are grouped into the same sub-statistical table; the names of second-level institutions and the transaction data corresponding to the second-level level are grouped into the same sub-statistical table; and the names of third-level institutions and the transaction data corresponding to the third-level level are grouped into the same sub-statistical table.

[0097] Specifically, suppose there are three sub-statistical tables: a first-level sub-statistical table, a second-level sub-statistical table, and a third-level sub-statistical table. The specific representation of the first-level sub-statistical table is shown in Table 4, the specific representation of the second-level sub-statistical table is shown in Table 5, and the specific representation of the third-level sub-statistical table is shown in Table 6.

[0098] Table 4

[0099] Organization Name Number of business transactions XX Branch 23569 XX Branch 45672

[0100] Table 5

[0101]

[0102]

[0103] Table 6

[0104] Organization Name Number of business transactions XX Branch XX Sub-branch XX Sub-office 256 XX Branch XX Sub-branch XX Sub-office 356

[0105] It should be noted that the contents shown in Tables 4, 5 and 6 above are for illustrative purposes only.

[0106] S107: Based on the user level in the updated user table, determine the sub-statistics tables with the same level and those with lower levels, and link them.

[0107] It is understandable that user levels are associated with sub-statistics tables that are the same as or lower than the user level, so that users can view the sub-statistics tables based on the organization name and other information later.

[0108] It should be noted that, based on the user level in the updated user table, sub-statistical tables of the same level and lower than the user level are determined. Specifically, sub-statistical tables of the same level and lower than the user level are obtained from each sub-statistical table.

[0109] Optionally, in another embodiment of this application, a specific implementation of step S107, which determines sub-statistical tables of the same and lower user levels based on the user levels in the updated user table, includes the following steps:

[0110] When the user level in the updated user table is Level 1, the sub-statistics tables for Level 1 users and users below Level 1 are designated as the first sub-statistics table.

[0111] It is understandable that the sub-statistics table for Level 1 users and users below Level 1 is designated as the first sub-statistics table. In other words, the sub-statistics table for Level 1 users and users below Level 1 is obtained from the various sub-statistics tables and designated as the first sub-statistics table.

[0112] When the user level in the updated user table is level 2, the sub-statistics tables for level 2 users and users below level 2 are designated as the second sub-statistics table.

[0113] Among them, the user level of a level 2 user is lower than that of a level 1 user.

[0114] It is understandable that the sub-statistics table for users at level 2 and below is designated as the second sub-statistics table. In other words, the sub-statistics table for users at level 2 and below is obtained from the various sub-statistics tables and designated as the second sub-statistics table.

[0115] When the user level in the updated user table is level 3, the sub-statistics tables for level 3 users and users below level 3 are designated as the third sub-statistics table.

[0116] Among them, the user level of a level 3 user is lower than that of a level 2 user.

[0117] It is understandable that the sub-statistics table for level 3 users and users below level 3 is designated as the second sub-statistics table. In other words, from the various sub-statistics tables, the sub-statistics table for level 3 users and users below level 3 is obtained and designated as the third sub-statistics table.

[0118] Optionally, after generating each sub-statistical table, users can query the information in the sub-statistical tables. Therefore, in another embodiment of this application, a method for viewing sub-statistical tables is provided, including the following steps:

[0119] When a query is received from a user, a statistical report corresponding to the query is displayed to the user through a preset interface.

[0120] The query information includes the organization name.

[0121] It should be noted that the sub-statistical table corresponding to the query information is the current level itself, as well as the sub-statistical tables of the subordinate levels under its jurisdiction (such as the first sub-statistical table, the second sub-statistical table, or the third sub-statistical table).

[0122] In summary, based on the lookup table, the outlet numbers in the temporary statistics table are replaced with the organization names. The temporary statistics table is then grouped according to the organization level corresponding to the organization name, resulting in sub-statistical tables containing the same organization level. In this embodiment, when a user's job changes or the organization's affiliation changes, only the organization names in the lookup table and the user table need to be modified to complete the change, improving the efficiency of the change and ensuring the user's normal work.

[0123] like Figure 2 The diagram shown is a schematic diagram of the architecture of a statistical report generation device provided in an embodiment of this application. The generation device includes: a modification unit 100, a division unit 200, an acquisition unit 300, a generation unit 400, a replacement unit 500, a grouping unit 600, and a determination unit 700.

[0124] Modify unit 100 is used to modify the employee number in the obtained user table to the corresponding organization name according to the organization to which it belongs. The organization has a corresponding organization level.

[0125] The partitioning unit 200 is used to partition the user level of each institution name in the user table according to the institution level, so as to obtain an updated user table containing the correspondence between user level and institution name, with the same institution level corresponding to the same level of user level.

[0126] The acquisition unit 300 is used to obtain a lookup table containing the organization name and the corresponding branch number.

[0127] The generation unit 400 is used to obtain the transaction data corresponding to each institution from the transaction database, as well as the branch number contained in the transaction data, and generate a temporary statistical table containing the branch number and the transaction data corresponding to the branch number.

[0128] The generation unit 400 is specifically used for: obtaining the number of business transactions from the transaction data; and generating a temporary statistical table containing the branch numbers and corresponding transaction data based on the number of business transactions and the branch numbers contained in the transaction data.

[0129] Replacement unit 500 is used to replace the outlet number in the temporary statistics table with the organization name according to the lookup table.

[0130] Grouping unit 600 is used to group the temporary statistical table according to the institution level corresponding to the institution name, so as to obtain sub-statistical tables containing the same institution level.

[0131] The grouping unit 600 is specifically used to: obtain each institution name and the corresponding transaction data from the temporary statistical table; for each institution name, group the institution names at the same institution level and the corresponding transaction data into the same sub-statistical table to obtain various sub-statistical tables containing the same institution level.

[0132] Unit 700 is used to determine sub-statistical tables of the same level and lower level as users based on the user level in the updated user table, and to associate them.

[0133] The determination unit 700 is specifically used for: when the user level in the updated user table is Level 1 user, determining the sub-statistical tables of Level 1 users and users below Level 1 as the first sub-statistical table; when the user level in the updated user table is Level 2 user, determining the sub-statistical tables of Level 2 users and users below Level 2 as the second sub-statistical table; the user level of Level 2 users is lower than that of Level 1 users; when the user level in the updated user table is Level 3 user, determining the sub-statistical tables of Level 3 users and users below Level 3 as the third sub-statistical table; the user level of Level 3 users is lower than that of Level 2 users.

[0134] In summary, based on the lookup table, the outlet numbers in the temporary statistics table are replaced with the organization names. The temporary statistics table is then grouped according to the organization level corresponding to the organization name, resulting in sub-statistical tables containing the same organization level. In this embodiment, when a user's job changes or the organization's affiliation changes, only the organization names in the lookup table and the user table need to be modified to complete the change, improving the efficiency of the change and ensuring the user's normal work.

[0135] Preferred, combined Figure 2 The generating device, as shown, also includes a display unit, which, when receiving query information input by a user, displays a statistical report corresponding to the query information to the user through a preset interface; the query information includes the name of the organization.

[0136] The various embodiments in this specification are described in a progressive manner. Each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.

[0137] The above description of the disclosed embodiments enables those skilled in the art to make or use this application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of this application. Therefore, this application is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for generating statistical reports, characterized in that, include: The employee IDs obtained from the user table are modified to the corresponding organization names according to their affiliated organizations, where each organization has a corresponding organization level. The user level of each institution name in the user table is divided according to the institution level, resulting in an updated user table containing the correspondence between user level and institution name. The same institution level corresponds to the same level of user level. Obtain a lookup table containing the organization name and its corresponding branch number; The transaction data corresponding to each institution is obtained from the transaction database, as well as the branch number contained in the transaction data, and a temporary statistical table containing the branch number and the transaction data corresponding to the branch number is generated. According to the aforementioned lookup table, replace the outlet number in the temporary statistics table with the organization name; The temporary statistical table is grouped according to the institution level corresponding to the institution name to obtain sub-statistical tables containing the same institution level. Based on the user level in the updated user table, determine the sub-statistical tables with the same level and those with lower levels, and associate them.

2. The method according to claim 1, characterized in that, The generation of a temporary statistical table containing branch numbers and corresponding transaction data includes: Obtain the number of business transactions from the transaction data; Based on the number of business transactions and the branch numbers included in the transaction data, a temporary statistical table containing branch numbers and the corresponding transaction data is generated.

3. The method according to claim 1, characterized in that, The temporary statistical table is grouped according to the institution level corresponding to the institution name to obtain sub-statistical tables containing the same institution level, including: Obtain each institution name and the corresponding transaction data from the temporary statistics table; For each institution name, institutions at the same institution level and the corresponding transaction data are grouped into the same sub-statistical table to obtain sub-statistical tables containing the same institution level.

4. The method according to claim 1, characterized in that, The step of determining sub-statistical tables for users at the same level and those at lower levels based on the user levels in the updated user table includes: When the user level in the updated user table is a Level 1 user, the Level 1 user and the sub-statistics table below the Level 1 user are determined as the first sub-statistics table; When the user level in the updated user table is a level 2 user, the level 2 user and the sub-statistics table below the level 2 user are determined as the second sub-statistics table; the level of the level 2 user is lower than the level of the level 1 user. When the user level in the updated user table is a level 3 user, the level 3 user and the sub-statistics table below the level 3 user are determined as the third sub-statistics table; the level 3 user is lower than the level 2 user.

5. The method according to claim 1, characterized in that, Also includes: When a query is received from a user, a statistical report corresponding to the query is displayed to the user through a preset interface. The query information includes the organization name.

6. A statistical report generation device, characterized in that, include: The modification unit is used to modify the employee number in the obtained user table to the corresponding organization name according to the organization to which the organization belongs, and the organization has a corresponding organization level; The partitioning unit is used to partition the user level of each institution name in the user table according to the institution level, so as to obtain an updated user table containing the correspondence between user level and institution name, with the same institution level corresponding to the same level of user level; The acquisition unit is used to obtain a lookup table containing the organization name and the corresponding branch number of the organization name; The generation unit is used to obtain the transaction data corresponding to each institution from the transaction database, as well as the branch number contained in the transaction data, and generate a temporary statistical table containing the branch number and the transaction data corresponding to the branch number. The replacement unit is used to replace the outlet number in the temporary statistics table with the organization name according to the lookup table; A grouping unit is used to group the temporary statistical table according to the institution level corresponding to the institution name, so as to obtain sub-statistical tables containing the same institution level. The determining unit is used to determine, based on the user level in the updated user table, sub-statistical tables with the same level and those with lower levels, and to associate them.

7. The apparatus according to claim 6, characterized in that, The generation unit is specifically used for: Obtain the number of business transactions from the transaction data; Based on the number of business transactions and the branch numbers included in the transaction data, a temporary statistical table containing branch numbers and the corresponding transaction data is generated.

8. The apparatus according to claim 6, characterized in that, The grouping unit is used for: Obtain each institution name and the corresponding transaction data from the temporary statistics table; For each institution name, institutions at the same institution level and the corresponding transaction data are grouped into the same sub-statistical table to obtain sub-statistical tables containing the same institution level.

9. The apparatus according to claim 6, characterized in that, The determining unit is used for: When the user level in the updated user table is a Level 1 user, the Level 1 user and the sub-statistics table below the Level 1 user are determined as the first sub-statistics table; When the user level in the updated user table is a level 2 user, the level 2 user and the sub-statistics table below the level 2 user are determined as the second sub-statistics table; the level of the level 2 user is lower than the level of the level 1 user. When the user level in the updated user table is a level 3 user, the level 3 user and the sub-statistics table below the level 3 user are determined as the third sub-statistics table; the level 3 user is lower than the level 2 user.

10. The apparatus according to claim 6, characterized in that, Also includes: The display unit is used to display statistical reports corresponding to the query information to the user through a preset interface when the user inputs query information. The query information includes the organization name.

Images