Report data processing method and device, electronic equipment and storage medium
By automating post-investment report management and using preset template formats to acquire and parse key data, the problems of low efficiency and low accuracy in post-investment management have been solved, achieving efficient and accurate report management.
Patent Information
- Application Number
- CN202111392499.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-11-19
- Publication Date
- 2025-12-12
- Estimated Expiration
- 2041-11-19
AI Technical Summary
The lack of unified standards in post-investment management reports leads to inefficiency, error-proneness, high manual processing costs, and difficulty in ensuring accuracy.
The system automatically retrieves enterprise customer reports using preset template formats, parses key data and stores it in the database, and periodically checks whether early warning conditions are met, triggering corresponding early warnings.
It has automated report management, reduced labor costs, improved management efficiency and accuracy, and reduced errors caused by manual processing.
Smart Images

Figure CN114298649B_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of data processing, and in particular to a report data processing method and device, electronic equipment and storage medium. BACKGROUND
[0002] Post-investment management is a very important part of the investment business process, and the post-investment report management part is particularly important, which is related to the diagnosis of the financial and business indicators of the invested projects and the judgment of whether to provide assistance to the projects, so as to maximize the investment returns. Each institution will have a few dozen to hundreds of projects that need post-investment management.
[0003] However, the current post-investment management is basically manually collecting and analyzing data, and lacks unified management standards. In addition, the financial reports and business reports of each company are not the same, and even the report formats of the same company at different times are different, which is very inefficient and prone to errors. For post-investment management personnel, in addition to basic email sending and receiving, report review, and data extraction, there are other difficult problems, such as the overdue submission of post-investment enterprise reports, which requires multiple reminders. In addition, the management of financial reports of each post-investment enterprise is too large for an institution to manage the number of reports each year, so it is difficult to ensure the efficiency, accuracy, and cost of post-investment report management. SUMMARY
[0004] The purpose of the present application is to solve the above problems, and provide a report data processing method, device, electronic equipment and storage medium, which realizes the purposes of reducing report management labor cost, improving report management efficiency and ensuring report analysis accuracy.
[0005] To solve the above problems, the embodiments of the present application provide a report data processing method, which comprises: periodically obtaining a report uploaded by an enterprise client from a mailbox bound to the enterprise client at a preset first period; wherein the report adopts a template format agreed with the enterprise client; obtaining a key data analysis rule according to the template format of the report, wherein the correspondence between the template format and the key data analysis rule is preset; obtaining key data from the report according to the key data analysis rule, and storing the key data into a database; periodically obtaining the key data of the enterprise client from the database at a preset second period, detecting whether the key data meets a preset early warning condition according to the preset early warning condition; and triggering an early warning in the case that the key data meets the early warning condition.
[0006] To solve the above problems, the embodiment of the present application provides a report data processing device, comprising: a report acquisition module, configured to periodically acquire a report uploaded by an enterprise client from a mailbox bound to the enterprise client at a preset first period; wherein the report adopts a template format agreed with the enterprise client; a rule acquisition module, configured to acquire a key data analysis rule according to the template format of the report, wherein a corresponding relationship between the template format and the key data analysis rule is preset; a key data acquisition module, configured to acquire key data from the report according to the key data analysis rule, and store the key data into a database; a detection module, configured to periodically acquire the key data of the enterprise client from the database at a preset second period, and detect whether the key data meets a preset early warning condition; and an early warning module, configured to trigger early warning in the case that the key data meets the early warning condition.
[0007] To solve the above problems, the embodiment of the present application further provides an electronic device, comprising: at least one processor; and a memory in communication connection with the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the report data processing method.
[0008] To solve the above problems, the embodiment of the present application further provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the report data processing method.
[0009] The report data processing method provided by the embodiment of the present application periodically and automatically acquires the report of the enterprise client, acquires the key data analysis rule according to the preset template format, and acquires the key data from the report, so as to determine whether the key data triggers early warning according to the preset early warning condition. A standard process is established for report data management, and the human cost of report data processing is saved through computer automatic processing, the efficiency of report data management is improved, and the accuracy of report data analysis is ensured. BRIEF DESCRIPTION OF DRAWINGS
[0010] One or more embodiments are illustrated by way of example in the drawings that are not intended to be limiting of the embodiments as disclosed herein, in which like numerals designate similar components throughout the drawings, and in which: the drawings are not necessarily to scale, unless otherwise specifically noted.
[0011] Figure 1 is a flowchart of the report data processing method provided by an embodiment of the present application;
[0012] Figure 2 is an interaction diagram of the report data processing method provided by an embodiment of the present application;
[0013] Figure 3 is a structural schematic diagram of a report data processing device provided by an embodiment of the present application;
[0014] Figure 4 is an electronic structural schematic diagram provided by an embodiment of the present application. DETAILED DESCRIPTION
[0015] To make the objectives, technical solutions, and advantages of the embodiments of the present application clearer, the embodiments of the present application will be described in detail below with reference to the drawings. However, those skilled in the art can understand that, in the embodiments of the present application, many technical details are presented in order to make the readers better understand the present application. However, the technical solutions claimed by the present application can be implemented even without these technical details and based on various changes and modifications of the following embodiments.
[0016] An embodiment of the present application relates to a report data processing method, which comprises: periodically obtaining, at a preset first period, a report uploaded by an enterprise client from a mailbox bound to the enterprise client; wherein the report adopts a template format agreed with the enterprise client; obtaining a key data analysis rule according to the template format of the report, wherein a corresponding relationship between the template format and the key data analysis rule is preset; obtaining key data from the report according to the key data analysis rule, and storing the key data into a database; periodically obtaining, at a preset second period, the key data of the enterprise client from the database, detecting whether the key data meets a preset early warning condition according to the preset early warning condition; and triggering early warning in a case where the key data meets the early warning condition.
[0017] The implementation details of the report data processing method in the embodiment will be described in detail below. The following content is only for facilitating understanding of the implementation details of the present solution, and is not necessary for implementing the present solution. The specific process is as shown in Figure 1 , which can comprise the following steps:
[0018] In step 101, a report uploaded by an enterprise client is periodically obtained, at a preset first period, from a mailbox bound to the enterprise client; wherein the report adopts a template format agreed with the enterprise client.
[0019] In an example, an investment institution agrees on and determines the template format of a report according to the business situation of an enterprise client, wherein the template comprises: a profit statement, a balance sheet, a cash flow statement, and a business data table, etc.
[0020] According to the specific situation of an enterprise client, the template format is determined, which facilitates the unified management of the report by the system, and avoids the problem that the efficiency of processing the report is greatly reduced due to different report formats.
[0021] Further, before periodically obtaining the report uploaded by the enterprise client from the mailbox bound with the enterprise client at a preset first period, the system generates a two-dimensional code containing enterprise information and identity information according to the enterprise information, wherein the identity information is the identity information of the person in charge of the enterprise; the two-dimensional code is sent to the terminal device of the person in charge of the enterprise, so that the terminal device of the person in charge of the enterprise scans the code to obtain the public number; the notification information is sent to the terminal device of the person in charge of the enterprise, and the notification information is used to notify the person in charge of the enterprise to set the mailbox through the public number; and the report uploaded by the enterprise client is periodically obtained from the mailbox set through the public number at a preset first period.
[0022] In one example, the system generates a two-dimensional code containing enterprise information and identity information according to the enterprise information of the enterprise client, wherein the identity information can be the Chief Executive officer (CEO) or the Chief financial officer (CFO). After the system generates the two-dimensional code, the two-dimensional code is sent to the CEO and the CFO of the enterprise client respectively. After the CEO and the CFO receiving the two-dimensional code scan the code, they automatically follow the public number of the institution. At the same time, the system will notify the CEO and the CFO to set their own mailbox in the public number of the institution. After the above setting is completed, the system binds the CEO and the CFO with the enterprise client in the two-dimensional code; the enterprise client uploads the report to the designated mailbox, and the system obtains the report of the enterprise client through the mailbox bound with the public number of the enterprise client at a regular time.
[0023] Further, the system sends a notification message indicating that the report is overdue and not uploaded to the terminal device of the person in charge of the enterprise in the case that the system fails to obtain the report uploaded by the enterprise client from the mailbox; and sends a notification message indicating that the report does not match the template to the terminal device of the person in charge of the enterprise in the case that the system fails to obtain the key data from the report according to the key data analysis rule.
[0024] In one example, the system reminds the CEO and the CFO of the enterprise client to upload the report to the designated mailbox through the WeChat public number at a regular time every month. If the report is overdue and not uploaded, the system automatically notifies the post-investment personnel of the institution to intervene manually through the WeChat public number. After the report is uploaded, if the system fails to analyze the report, the system automatically reminds the enterprise client and the post-investment management personnel of the institution through the WeChat public number information that "the report does not match the Excel template". If the system successfully analyzes the report, the system also automatically reminds the post-investment management personnel of the institution through the WeChat public number information that "the report has been successfully analyzed and can be viewed".
[0025] By reminding the enterprise client to upload the report at a regular time, and automatically notifying the enterprise client of the above problems when the enterprise client does not upload the report on time or uploads the report in an incorrect format, the system reduces the waste of human resources in reminding the uploading of the report, and also facilitates the system to obtain the report in a correct template format in time and process the report data.
[0026] In step 102, the key data parsing rules are obtained according to the template format of the report, wherein the correspondence between the template format and the key data parsing rules is pre-configured; wherein the key data includes N key data, and N is a natural number greater than 1.
[0027] Specifically, according to the template format of the report, the key data parsing rules of the N key data are obtained respectively; and the N key data are obtained from the report according to the key data parsing rules of the N key data respectively.
[0028] In an example, the investment institution sets a key data table in the system, including data such as main business income, operating cash flow, and investment cash flow, and sets the parsing rules for each key data table to extract data from the template according to the above-mentioned template format agreed with the enterprise client, wherein each parsing rule includes: enterprise client ID, report type, keyword, and data position, for example: the operating cash flow and the investment cash flow in the key data table are obtained by adding the net cash flow generated by operating activities and the net cash flow generated by investment activities in the cash flow table of the enterprise client, and the parsing rule is "${CF. Operating activities generated cash flow net. 0}+${CF. Investment activities generated cash flow net. 0}". The "CF" represents the report type as the cash flow table, and "0" represents the position of the data in the report sent by the enterprise client.
[0029] Configuring the key data parsing rules is beneficial to the rapid extraction of key data by the system and improves the efficiency of report data processing.
[0030] In step 103, the key data is obtained from the report according to the key data parsing rules, and the key data is stored in the database; wherein the key data is stored in the database according to the enterprise type, the acquisition time, and the report type.
[0031] In an example, the system automatically obtains the attachment report in the email sent by the enterprise client from the specified mailbox, and the system identifies the current enterprise client according to the binding relationship between the mailbox sender and the enterprise client, and finds out the template format matched with the current enterprise client. Then the xlrd class library of Python is used to read the report, and all reports in the email attachment and all sheets in each report are read one by one. Whether it matches the previously configured template format is judged according to the keyword in the sheet, if it matches, the report type is calculated, and then the key data required by the institution is automatically parsed according to the key data parsing rules pre-configured for the template format report, and stored in the database.
[0032] In addition, the report sent by the enterprise client in each period is automatically archived in MongoDB according to the enterprise, time and report type, and the management system function is realized through the web front and back end technology, so as to facilitate the post-investment personnel to search, check and count.
[0033] In step 104, the key data of the enterprise client is periodically obtained from the database at a preset second period, and whether the key data meets the preset early warning condition is detected according to the preset early warning condition, wherein the preset early warning condition includes the early warning condition corresponding to each of the N key data.
[0034] Specifically, according to the preset corresponding relationship between the enterprise client and the early warning condition, the early warning condition corresponding to the enterprise client is obtained; according to the early warning condition corresponding to the enterprise client, whether the key data meets the early warning condition is detected, that is, according to the preset early warning condition of each key data, whether any key data meets the corresponding early warning condition is detected.
[0035] In one example, the institution configures the early warning condition for the enterprise client in the report management system according to the enterprise business and development stage of each enterprise client and other factors, wherein each early warning condition is an expression, for example, the early warning condition is "cash flow is insufficient to support 6 months", and the expression configuration is: ${currency funds / cash net outflow} <6; for example, the early warning condition is "continuous 3 months gross profit rate is negative", and the expression configuration is: ${gross profit rate} <0|~3.
[0036] The early warning condition configured for the enterprise client conforms to the actual situation of the enterprise, so that the report analysis result is more in line with the actual situation, and the report analysis accuracy is higher.
[0037] In one example, the system extracts the key data from the report sent by the enterprise client every month, and automatically judges whether the post-investment management personnel of the institution needs to be notified to pay attention according to the early warning condition set for the current enterprise client in advance.
[0038] In step 105, the early warning is triggered when the key data meets the early warning condition.
[0039] Specifically, the early warning is triggered when any of the key data meets the corresponding early warning condition.
[0040] In one example, when the obtained key data meets the early warning condition, the system notifies the post-investment report management personnel of the key data currently triggering the early warning.
[0041] In addition, by the report data processing method, the post-investment managers of the institution only need to perform initial setting, and no longer need to pay attention to the report sending situation of the enterprise client all the time. The system can automatically remind the enterprise client, and timely notify the post-investment personnel to pay attention to the situation such as "overdue", "report error", "index early warning" and the like, and the error caused by manual processing can be avoided.
[0042] In order to make the report data processing method process of the embodiment of the application more concise, the following will be described by taking the report data processing method of the embodiment of the application as an example. Figure 2 The interactive process of the report data processing method will be described in detail. The report data processing method of the embodiment of the application comprises a system configuration step and a data processing step. The steps 201 to 205 are the system configuration step, and the steps 206 to 212 are the data processing step. The specific content is as follows.
[0043] In step 201, the institution and the enterprise client determine the template format.
[0044] In step 202, the institution sets the analysis rule and the early warning condition of each key data on the system.
[0045] In step 203, the system generates a two-dimensional code of the enterprise client.
[0046] In step 204, the enterprise client obtains the two-dimensional code generated by the system, scans the code to follow the public number, and binds the mailbox.
[0047] In step 205, the system binds the client information.
[0048] In step 206, the system reminds the enterprise client to upload the report in time.
[0049] In step 207, the enterprise client uploads the report through the mailbox.
[0050] In step 208, the system obtains the report uploaded by the enterprise client in time.
[0051] In step 209, the system judges whether the report uploaded by the system is successfully obtained. If the acquisition fails, the notification information indicating that the report is not uploaded in time is sent to the enterprise client. If the acquisition succeeds, step 210 is performed.
[0052] In step 210, the system judges whether the template format of the obtained report matches the enterprise client. If not, the notification information indicating that the report does not match the template is sent to the enterprise client and the report management personnel. If the matching succeeds, step 211 is performed.
[0053] In step 211, the key data analysis rule is obtained according to the template format, and the key data is extracted according to the key data analysis rule.
[0054] In step 212, it is judged whether the key data satisfies the early warning condition, and if yes, an early warning notification information is sent to the report manager.
[0055] The report data processing method provided in the embodiments of the present application standardizes the post-investment report management process, unifies the online management of post-investment reports, facilitates the data review of post-investment managers, and ensures data completeness and safety, thereby avoiding the problem of report loss; the system has an automatic reminding function, and does not need human supervision for the report uploading of the invested companies; in addition, personalized reminding rules are provided according to the business and development stage of the invested companies, and when an abnormal index appears, the abnormal index automatically triggers an early warning without manual calculation, which is accurate and timely, effectively reduces the human and material resources spent by the institution on post-investment report management, and is more efficient and accurate in post-investment management.
[0056] The step division of the above methods is only for the purpose of clear description, and in actual implementation, one step can be combined or some steps can be split and decomposed into multiple steps, as long as the same logical relationship is included, which is within the protection scope of the present patent; adding irrelevant modifications or introducing irrelevant designs in the algorithm or process, but not changing the core design of the algorithm and process, are within the protection scope of the present patent.
[0057] The embodiments of the present application also provide a report data processing device, as shown in Figure 3 The device includes a report acquisition module 301, a rule acquisition module 302, a key data acquisition module 303, a detection module 304, and a warning module 305.
[0058] Specifically, the report acquisition module 301 is configured to periodically acquire, at a preset first period, a report uploaded by an enterprise client from a mailbox bound to the enterprise client; the report adopts a template format agreed with the enterprise client; the rule acquisition module 302 is configured to acquire a key data analysis rule according to the template format of the report, wherein a correspondence between the template format and the key data analysis rule is preset; the key data acquisition module 303 is configured to acquire key data from the report according to the key data analysis rule, and store the key data into a database; the detection module 304 is configured to periodically acquire the key data of the enterprise client from the database at a preset second period, and detect whether the key data satisfies a preset early warning condition; and the warning module 305 is configured to trigger a warning in the case that the key data satisfies the early warning condition.
[0059] In one example, the report data processing apparatus further comprises a two-dimensional code generation module (not shown in the figure). The two-dimensional code generation module is configured to generate a two-dimensional code containing enterprise information and identity information of the enterprise client according to the enterprise information of the enterprise client, wherein the identity information can be a Chief Executive officer (CEO) or a Chief financial officer (CFO). After the system generates the two-dimensional code, the two-dimensional code is sent to the CEO and CFO of the enterprise client respectively. After the CEO and CFO receiving the two-dimensional code scan the code, they automatically follow the official account of the agency. At the same time, the system will notify the CEO and CFO to set their own mailbox in the official account of the agency. After the above setting is completed, the system binds the CEO and CFO with the enterprise client in the two-dimensional code. The enterprise client uploads the report to the designated mailbox, and the report acquisition module 301 acquires the report of the enterprise client through the mailbox bound to the official account of the agency at regular intervals.
[0060] Further, the report acquisition module sends a notification message indicating that the report is overdue if the report uploaded by the enterprise client from the mailbox fails; and sends a notification message indicating that the report does not match the template if the key data fails to be acquired from the report according to the key data analysis rule.
[0061] In one example, the report data processing apparatus further comprises a reminding module (not shown in the figure). The reminding module reminds the CEO and CFO of the enterprise client to upload the report to the designated mailbox through the WeChat official account at regular intervals every month. If the report is overdue, the system automatically notifies the post-investment personnel of the agency to intervene manually through the WeChat official account. After the report is uploaded, if the system fails to analyze the report, the system automatically reminds the enterprise client and the post-investment management personnel of the agency through the WeChat official account that the report does not match the Excel template. If the system successfully analyzes the report, the system also automatically reminds the post-investment management personnel of the agency through the WeChat official account that the report has been successfully analyzed and can be viewed.
[0062] In one example, the investment institution sets a key data table in the system, including: main business revenue, operating cash flow and investment cash flow data, and sets the parsing rule of each key data table to extract data from the template according to the above-mentioned template format agreed with the enterprise client, wherein each parsing rule includes: enterprise client ID, report type, keyword and data location, for example: the operating cash flow and the investment cash flow in the key data table are obtained by adding the net cash flow generated by the operating activities and the cash flow generated by the investment activities in the cash flow table of the enterprise client, and the parsing rule is "${CF. Net cash flow generated by operating activities. 0}+${CF. Net cash flow generated by investment activities. 0}". The "CF" represents the report type as the cash flow table, and "0" represents the location of the data in the report sent by the enterprise client.
[0063] In one example, the key data acquisition module 303 automatically obtains the attachment report in the email sent by the enterprise client from the specified mailbox, and the system identifies the current enterprise client according to the binding relationship between the mailbox sender and the enterprise client, and finds out the template format matched with the current enterprise client. Then the xlrd class library of Python is used to read the report, and all reports in the email attachment and all sheets in each report are read one by one. Whether it matches the template format configured before is judged according to the keyword in the sheet, if it matches, the report type is calculated, and then according to the key data parsing rule configured in advance for the template format report, the key data required by the institution is automatically parsed and stored in the database.
[0064] In one example, the key data is extracted from the report sent by the enterprise client every month, and the detection module 304 automatically judges whether the post-investment management personnel of the institution needs to be notified to pay attention according to the early warning condition set for the current enterprise client in advance.
[0065] It is not difficult to find that the present embodiment is a device embodiment corresponding to the above-mentioned report data processing method embodiment, and the present embodiment can be implemented in cooperation with the above-mentioned report data processing method embodiment. The related technical details mentioned in the above-mentioned report data processing method embodiment are still effective in the present embodiment, and in order to reduce repetition, they will not be described here. Correspondingly, the related technical details mentioned in the present embodiment can also be applied in the above-mentioned report data processing method embodiment.
[0066] The report data processing device provided in this application standardizes the post-investment report management process, unifies online management of post-investment reports, facilitates data retrieval by post-investment managers, and ensures data integrity and security, avoiding the problem of report loss. The system has an automatic reminder function, eliminating the need for manual reminders to investee companies to upload reports. In addition, it provides personalized reminder rules based on the business and development stage of the investee company. When abnormal indicators occur, the abnormal indicators are automatically alerted without manual calculation, ensuring high accuracy and timely reporting. This effectively reduces the overall manpower and material resources spent by the organization on post-investment report management, and makes post-investment management more efficient and accurate.
[0067] It is worth mentioning that all modules involved in the above embodiments of this application are logical modules. In practical applications, a logical unit can be a physical unit, a part of a physical unit, or a combination of multiple physical units. Furthermore, to highlight the innovative aspects of this application, this embodiment does not introduce units that are not closely related to solving the technical problem proposed in this application; however, this does not mean that other units are absent from this embodiment.
[0068] Embodiments of this application also provide an electronic device, such as... Figure 4 As shown, it includes at least one processor 401; and a memory 402 communicatively connected to the at least one processor 401; wherein the memory 402 stores instructions executable by the at least one processor 401, the instructions being executed by the at least one processor 401 to enable the at least one processor to perform the above-described report data processing method.
[0069] The memory and processor are connected via a bus, which can include any number of interconnecting buses and bridges, connecting various circuits of one or more processors and memories. The bus can also connect various other circuits, such as peripheral devices, voltage regulators, and power management circuits, which are well known in the art and will not be described further herein. The bus interface provides an interface between the bus and the transceiver. The transceiver can be a single element or multiple elements, such as multiple receivers and transmitters, providing a unit for communicating with various other devices over a transmission medium. Data processed by the processor is transmitted over the wireless medium via an antenna, which further receives data and transmits it to the processor.
[0070] The processor manages the bus and general processing, and also provides various functions, including timing, peripheral interfaces, voltage regulation, power management, and other control functions. Memory is used to store data used by the processor during operation.
[0071] The product can execute the method provided in the embodiments of the present application, has the corresponding function modules and beneficial effects of the executed method, and the technical details not described in the embodiments can be referred to the method provided in the embodiments of the present application.
[0072] The embodiments of the present application further provide a computer readable storage medium storing a computer program. The computer program is executed by a processor to implement the method embodiments.
[0073] Those skilled in the art can understand that all or part of the steps of the methods in the above embodiments can be completed by a program instructing related hardware. The program is stored in a storage medium, and includes a plurality of instructions to make a device (which can be a single-chip microcomputer, a chip, etc.) or a processor execute all or part of the methods described in the embodiments of the present application. The foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), a magnetic disk or an optical disk, and various media that can store program codes.
[0074] The above embodiments are provided for those skilled in the art to implement and use the present application, and those skilled in the art can make various modifications or changes to the above embodiments without departing from the inventive concept of the present application. Therefore, the protection scope of the present application should not be limited by the above embodiments, but should conform to the maximum scope of the innovative features mentioned in the claims.
Claims
1. A report data processing method characterized by comprising: The method comprises the following steps: periodically obtaining a report uploaded by an enterprise client from a mailbox bound to the enterprise client at a preset first period; wherein the report adopts a template format agreed with the enterprise client; obtaining a key data analysis rule according to the template format of the report, wherein a corresponding relationship between the template format and the key data analysis rule is preset; obtaining key data from the report according to the key data analysis rule, and storing the key data into a database; periodically obtaining the key data of the enterprise client from the database at a preset second period, and detecting whether the key data meets a preset early warning condition according to the preset early warning condition; triggering early warning in the case that the key data meets the early warning condition; before the step of periodically obtaining the report uploaded by the enterprise client from the mailbox bound to the enterprise client at the preset first period, the method further comprises the following steps: generating a two-dimensional code containing enterprise information and identity information according to the enterprise information; wherein the identity information is the identity information of an enterprise leader; sending the two-dimensional code to a terminal device of the enterprise leader, so that the terminal device of the enterprise leader scans the code to obtain a public number; sending notification information to the terminal device of the enterprise leader, wherein the notification information is used to notify the enterprise leader to set up a mailbox through the public number; the step of periodically obtaining the report uploaded by the enterprise client from the mailbox bound to the enterprise client at the preset first period comprises the following step: periodically obtaining the report uploaded by the enterprise client from the mailbox set up through the public number at the preset first period.
2. The report data processing method of claim 1, wherein, the step of detecting whether the key data meets the early warning condition according to the preset early warning condition comprises the following steps: obtaining an early warning condition corresponding to the enterprise client according to a preset corresponding relationship between the enterprise client and the early warning condition; detecting whether the key data meets the early warning condition according to the early warning condition corresponding to the enterprise client.
3. The report data processing method of claim 1, wherein, the key data comprises N key data, wherein N is a natural number greater than 1; the step of obtaining a key data analysis rule according to the template format of the report comprises the following step: obtaining a key data analysis rule of each of the N key data according to the template format of the report; the step of obtaining key data from the report according to the key data analysis rule comprises the following step: obtaining the N key data from the report according to the key data analysis rule of each of the N key data.
4. The report data processing method of claim 3, wherein, the preset early warning condition comprises an early warning condition corresponding to each of the N key data; the step of detecting whether the key data meets the early warning condition according to the preset early warning condition comprises the following step: detecting whether any of the key data meets the corresponding early warning condition according to the preset early warning condition of each of the key data; the step of triggering early warning in the case that the key data meets the early warning condition comprises the following step: triggering early warning in the case that any of the key data meets the corresponding early warning condition.
5. The report data processing method of claim 1, wherein, the method further comprises the following step: in the case that the step of obtaining the report uploaded by the enterprise client from the mailbox fails, sending a notification message indicating that the report is overdue to the terminal device of the enterprise leader. In a case where the key data is failed to be acquired from the report according to the key data analysis rule, a notification message indicating that the report does not match the template is sent to a terminal device of the enterprise person in charge.
6. The report data processing method according to any one of claims 1 to 4, characterized by, The storing the key data into the database comprises: The key data is stored in the database according to enterprise types, acquisition times and report types.
7. A report data processing apparatus characterized by comprising: Comprise: A report acquisition module is configured to periodically acquire a report uploaded by an enterprise client from a mailbox bound to the enterprise client at a preset first period; wherein the report adopts a template format agreed with the enterprise client; A rule acquisition module is configured to acquire a key data analysis rule according to the template format of the report, wherein a correspondence between the template format and the key data analysis rule is preset; A key data acquisition module is configured to acquire key data from the report according to the key data analysis rule, and store the key data into a database; A detection module is configured to periodically acquire the key data of the enterprise client from the database at a preset second period, and detect whether the key data meets a preset early warning condition according to the early warning condition; An early warning module is configured to trigger early warning in a case where the key data meets the early warning condition. Before the report acquisition module acquires the report uploaded by the enterprise client from the mailbox bound to the enterprise client at the preset first period, the method further comprises: Generating a two-dimensional code containing enterprise information and identity information according to the enterprise information; wherein the identity information is identity information of an enterprise person in charge; Sending the two-dimensional code to a terminal device of the enterprise person in charge, so that the terminal device of the enterprise person in charge acquires a public number by scanning the code; Sending notification information to the terminal device of the enterprise person in charge, wherein the notification information is used to notify the enterprise person in charge to set a mailbox through the public number; The report acquisition module acquires the report uploaded by the enterprise client from the mailbox set through the public number at the preset first period. Comprise:
8. An electronic device, comprising: At least one processor; And A memory connected in communication with the at least one processor; wherein The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the report data processing method in any one of claims 1 to 6. The computer program is executed by the processor to implement the report data processing method in any one of claims 1 to 6.
9. A computer readable storage medium storing a computer program, characterized in that,
Citation Information
Patent Citations
Data portal system for enterprise data unified platform
CN102663024A
Statement analysis report pushing method and device
CN104616134A