Method, device, equipment and medium for automatically generating graphic and text reports from proposals
By obtaining and analyzing the data in the statistical indicator library and generating multi-ring statistical charts, the problems of low efficiency and poor accuracy of traditional manual editing conference proposal reports are solved, and efficient and beautiful graphic and text report generation is achieved.
Patent Information
- Application Number
- CN202210451782.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-27
- Publication Date
- 2025-01-07
- Estimated Expiration
- 2042-04-27
AI Technical Summary
Traditional conference proposal reports are manually edited, resulting in large data processing, error-prone and invisible forms.
By obtaining the statistical indicator library, calculating the number and data of the statistical indicators of the pending proposals, performing sorting and uniformity analysis, generating multi-ring statistical charts based on the uniformity value and boundary indicators, dynamically generating graphic and text reports, and using the echarts and highcharts frameworks to perform charts exhibit.
It improves the efficiency and accuracy of the generation of proposal reports, makes the report form vivid, pictures and texts rich, and the pages beautiful, simplifying data analysis and generation work.
Smart Images

Figure CN114896954B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a method, device, computer equipment and storage medium for automatically generating graphic reports from proposals. Background Art
[0002] With the development of computer technology, traditional manual work is gradually being replaced by computers. When various meetings are held, meeting participants generally submit a large number of proposals. In order to improve the progress of the meeting, it is necessary to analyze the submitted proposals and generate reports.
[0003] In traditional technology, these reports are generally generated by manual editing, usually in the form of text + numbers + tables. The format is not vivid, and the manual data sorting is labor-intensive and prone to errors. Summary of the invention
[0004] Based on this, it is necessary to provide a method, device, computer equipment and storage medium for automatically generating graphic reports from proposals in response to the above technical problems, which can automatically generate graphic reports.
[0005] The method for automatically generating graphic and text reports from a proposal includes:
[0006] Acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators;
[0007] Obtaining proposals to be processed, and calculating the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library;
[0008] When the number of the statistical indicators is greater than a preset threshold, the data of the statistical indicators are sorted, and the uniformity of the data of each statistical indicator is calculated to obtain a uniformity value;
[0009] When the uniformity value meets the preset condition, the demarcation index of the statistical index is calculated; the statistical index and the data of the statistical index are divided by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart;
[0010] A graphic report of the proposal to be processed is generated based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0011] In one embodiment, it also includes:
[0012] When the number of the statistical indicators is less than or equal to a preset threshold, a statistical chart of a bar graph is generated according to the statistical indicators and data of each statistical indicator.
[0013] In one embodiment, it also includes:
[0014] When the uniformity value does not meet the preset condition, a pie chart statistical diagram is generated according to the statistical indicator and the data of each statistical indicator.
[0015] In one of the embodiments, the graphic report of the proposal to be processed is dynamically generated by calling the echarts framework through the system front end.
[0016] In one of the embodiments, before the system front end calls the echarts framework, it also includes: the system back end calls the hightcharts plug-in, generates a temporary chart in the back end, and then passes the data to the front end.
[0017] In one embodiment, after the temporary chart is generated in the background, the method further includes: obtaining a determination criterion according to the proportion of the temporary chart:
[0018]
[0019] Where W C is the chart width, W P is the page width, and Y is a standard value; the standard value is determined according to the number n of statistical indicators, when n>30, Y=45%, when n≤30, Y=55%;
[0020] When the judgment criteria are met, the temporary chart is generated individually; when the judgment criteria are not met, the temporary chart is generated in parallel; wherein, individually generated means that the temporary chart occupies the content of one line of the graphic report, and parallel generated means that the temporary chart occupies the content of one or more lines of the graphic report after the alignment operation.
[0021] The device for automatically generating graphic reports from proposals includes:
[0022] An acquisition module, used to acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators;
[0023] A calculation module, used to obtain proposals to be processed, and calculate the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library;
[0024] A judgment module, used for sorting the data of the statistical indicators when the number of the statistical indicators is greater than a preset threshold value, and calculating the uniformity of the data of each statistical indicator to obtain a uniformity value;
[0025] A demarcation module is used to calculate the demarcation index of the statistical index when the uniformity value meets the preset condition; divide the statistical index and the data of the statistical index by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart;
[0026] A generation module is used to generate a graphic report of the proposal to be processed based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0027] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:
[0028] Acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators;
[0029] Obtaining proposals to be processed, and calculating the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library;
[0030] When the number of the statistical indicators is greater than a preset threshold, the data of the statistical indicators are sorted, and the uniformity of the data of each statistical indicator is calculated to obtain a uniformity value;
[0031] When the uniformity value meets the preset condition, the demarcation index of the statistical index is calculated; the statistical index and the data of the statistical index are divided by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart;
[0032] A graphic report of the proposal to be processed is generated based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0033] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:
[0034] Acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators;
[0035] Obtaining proposals to be processed, and calculating the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library;
[0036] When the number of the statistical indicators is greater than a preset threshold, the data of the statistical indicators are sorted, and the uniformity of the data of each statistical indicator is calculated to obtain a uniformity value;
[0037] When the uniformity value meets the preset condition, the demarcation index of the statistical index is calculated; the statistical index and the data of the statistical index are divided by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart;
[0038] A graphic report of the proposal to be processed is generated based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0039] The method, device, computer equipment and storage medium for automatically generating graphic reports from the above proposals extract statistical indicators and their corresponding data from the statistical indicator library for analysis. When there are many statistical indicators, the statistical indicators are analyzed for uniformity. When the statistical indicators are unevenly distributed, the statistical indicators are divided into multiple parts using boundary indicators to generate different rings of the multi-ring diagram. The above method analyzes the statistical indicators and data, and generates appropriate statistical charts according to the specific circumstances of the statistical data, so that the proposal report is vivid, with both pictures and texts, and the page is beautiful; and the use of computers for analysis and generation not only improves the generation efficiency of the proposal report, but also improves the generation accuracy of the proposal report; and the method is simple and easy to implement, and has high practicality. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 An application scenario diagram of a method for automatically generating a graphic report according to an embodiment of the present invention;
[0041] Figure 2 A schematic diagram of a process for automatically generating a graphic report from a proposal in an embodiment;
[0042] Figure 3 A structural block diagram of a device for automatically generating graphic and text reports for a proposal in an embodiment;
[0043] Figure 4 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION
[0044] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0045] The method for automatically generating graphic reports from proposals provided in this application can be applied to Figure 1In the application environment shown, the terminal 102 communicates with the server 104 through the network, and the terminal 102 may include but is not limited to various personal computers, laptops, smart phones, tablet computers and portable wearable devices, and the server 104 may be various portal websites, servers corresponding to the backend of the work system, etc.
[0046] like Figure 2 As shown, in one embodiment, a method for automatically generating a graphic report from a proposal is provided, and the method is applied to Figure 1 The following is an example of a terminal in the example, including:
[0047] Step 202: Obtain a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators.
[0048] The statistical indicator database is established after analyzing historical proposals and contains several statistical indicators and their corresponding data.
[0049] For example: the statistical indicators are the total number of proposals submitted in a certain year, the number of proposals submitted by male members in a certain year, and the number of proposals submitted by female members in a certain year. The corresponding data are 753, 536, and 217 respectively. The above information together constitutes the statistical indicator database.
[0050] Step 204, obtain the proposal to be processed, and calculate the number of statistical indicators and the data of each statistical indicator in the proposal to be processed based on the statistical indicator library.
[0051] The data of each statistical indicator is a group and can be arranged by year, month, date or region, etc.
[0052] Step 206: When the number of the statistical indicators is greater than a preset threshold, the data of the statistical indicators are sorted, and the uniformity of the data of each statistical indicator is calculated to obtain a uniformity value.
[0053] The threshold is predetermined according to the number of statistical indicators. For example, when the number of statistical indicators is large, the threshold can be appropriately large, otherwise it can be appropriately small. For example, when the number of statistical indicators is 100, the threshold can be 20, and when the number of statistical indicators is 50, the threshold can be 10.
[0054] When sorting data, you can sort them in descending order or in descending order. You can set the order according to the actual situation.
[0055] When calculating the uniformity value, the statistical indicator data is Q:
[0056]
[0057]
[0058] Where J is the uniformity value of the statistical index, n is the number of statistical indicators, Q i is the data value of the ith statistical indicator, Q a is the average value of the statistical index, Q max It is the maximum value of the statistical indicator.
[0059] The range of the uniformity value J is [0,1]. The closer it is to 0, the more uniform the distribution of the statistical indicator data is and the smaller the difference between the data is. Conversely, the greater the difference in the distribution of the data is.
[0060] Of course, other methods in the prior art may also be used to calculate the uniformity value, as long as they can characterize the uniformity of the data distribution of the statistical indicator.
[0061] Step 208, when the uniformity value meets the preset conditions, calculate the demarcation index of the statistical indicator; divide the statistical indicator and the data of the statistical indicator by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical indicator and the data of the statistical indicator before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart.
[0062] The demarcation index is the index where Q undergoes a sudden change. The demarcation index is used as the dividing point of the multi-ring statistical index. The statistical index and its corresponding data are divided into several parts, each part forms a ring, and the rings together constitute a multi-ring statistical chart.
[0063] When setting conditions and calculating demarcation indicators:
[0064]
[0065] In the formula, Q f is the demarcation index, Q f+1 It is the next statistical indicator of the demarcation indicator, and f∈n, f+1∈n.
[0066] That is to say, when the difference between a certain statistical indicator and its next statistical indicator divided by the data average of the statistical indicator is greater than the uniformity value, the statistical indicator is used as the dividing indicator.
[0067] Preferably, the statistical chart is a double-ring chart, with Q f The previous statistical indicators and the corresponding data output are the inner ring of the double ring diagram, and Q f+1 The subsequent statistical indicators and corresponding data output are the outer ring of the double ring diagram; or, Q f The previous statistical indicators and the corresponding data output are the outer ring of the double ring diagram, and Q f+1 The subsequent statistical indicators and corresponding data output are the inner ring of the double ring chart.
[0068] Step 210, generating a graphic report of the proposal to be processed based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0069] The graphic report includes statistical charts, and the statistical charts include statistical indicators and data information of the statistical indicators.
[0070] When there are relatively many statistical indicators and the distribution between them is uneven, you can use a multi-ring chart to represent the statistical chart. The multi-ring chart can prevent the problem of data being difficult to display uniformly. It divides the statistical indicators into different parts and clearly displays the relevant data. It is concise and easy to identify.
[0071] The method, device, computer equipment and storage medium for automatically generating graphic reports from the above proposals extract statistical indicators and their corresponding data from the statistical indicator library for analysis. When there are many statistical indicators, the statistical indicators are analyzed for uniformity. When the statistical indicators are unevenly distributed, the statistical indicators are divided into multiple parts using boundary indicators to generate different rings of the multi-ring diagram. The above method analyzes the statistical indicators and data, and generates appropriate statistical charts according to the specific circumstances of the statistical data, so that the proposal report is vivid, with both pictures and texts, and the page is beautiful; and the use of computers for analysis and generation not only improves the generation efficiency of the proposal report, but also improves the generation accuracy of the proposal report; and the method is simple and easy to implement, and has high practicality.
[0072] It should be understood that although Figure 2 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 2 At least part of the steps may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least part of the sub-steps or stages of other steps.
[0073] In one embodiment, it also includes:
[0074] When the number of statistical indicators is less than or equal to a preset threshold, a statistical chart of a bar graph is generated according to the statistical indicators and data of each statistical indicator.
[0075] That is to say, when the number of statistical indicators is not large, a bar chart can be used to represent the statistical chart. The bar chart can clearly show the difference between the data of each statistical indicator through height. Since the human eye is more sensitive to height and has a good recognition effect, the bar chart is simple and intuitive and easy to interpret.
[0076] In one embodiment, it also includes:
[0077] When the uniformity value does not meet the preset condition, a pie chart statistical diagram is generated according to the statistical indicator and the data of each statistical indicator.
[0078] In other words, when the statistical data is relatively uniform, a pie chart can be used to represent the statistical chart. The pie chart uses the area to represent the difference between the data of each statistical indicator. Especially when the statistical indicators and data are not very different, the specific data can be intuitively seen, rather than being squeezed together and inconvenient to identify.
[0079] In one embodiment, after the temporary chart is generated in the background, the method further includes: obtaining a determination criterion according to the proportion of the temporary chart:
[0080]
[0081] Where W C is the chart width, W P is the page width, and Y is a standard value; the standard value is determined according to the number n of statistical indicators, when n>30, Y=45%, when n≤30, Y=55%;
[0082] When the judgment criteria are met, the temporary chart is generated individually; when the judgment criteria are not met, the temporary chart is generated in parallel; wherein, individually generated means that the temporary chart occupies the content of one line of the graphic report, and parallel generated means that the temporary chart occupies the content of one or more lines of the graphic report after the alignment operation.
[0083] In this embodiment, the display form of the chart will automatically change to a format that adapts to the size of the web page according to the content of the statistical indicators, so that the generated report is as beautiful as possible and can be easily exported to Word; different statistical indicators will be output as different chart types, with rich and vivid forms.
[0084] Y can represent the ratio of the width of the chart to the width of the page. When there is a lot of data, even if the ratio of the width of the chart to the width of the page is small, the chart can occupy one line of the graphic report to make the various statistical indicators and their data clearer. When the charts are generated side by side, they may occupy multiple lines in the graphic report because the upper and lower ends are aligned.
[0085] Both n and Y can be specifically set according to actual conditions. For example, when n>30, Y=45%; when n≤30, Y=55%.
[0086] At the same time, this application can also automatically identify the relationship between various statistical indicators. The background presets statistical syntax, such as sql syntax. If it is the same type of statistics, then the statistical syntax will return the same field, but the filtering conditions are different, then these types of statistical indicators will be automatically merged and displayed as a graph. For example, the total number of proposals, the number of submissions by male committee members, and the number of submissions by female committee members, these three statistical indicators are all statistical proposals, and can be combined into a pie chart output. For example: "Selectcount()from tian where sex=1" and "select count()from tian where sex=2" These two sql syntaxes are both to query the return quantity of the tian table, but the where condition filtering is different, so they have an associated relationship and belong to the same type of statistics.
[0087] In one of the embodiments, the graphic report of the proposal to be processed is dynamically generated by calling the echarts framework through the system front end.
[0088] In one of the embodiments, before the system front end calls the echarts framework, it also includes: the system back end calls the hightcharts plug-in, generates a temporary chart in the back end, and then passes the data to the front end.
[0089] Specifically, the system front end transmits the statistical indicators, the data of the statistical indicators, and the statistical charts back to the background, and the background calls the hightcharts plug-in. The hightcharts plug-in generates a temporary chart based on the statistical indicators and the data of the statistical indicators. The temporary chart is saved in the background. The background program obtains the basic information of the temporary picture and returns it to the system front end. The system front end calls the echarts framework, allocates the layer size according to the statistical chart, determines the type of picture to be rendered, and generates a graphic report of the proposal to be processed.
[0090] For example, the front-end page needs to draw a "graphic report on the gender ratio of proposals submitted by committee members". The system front-end passes the data source format "male committee members: 536, female committee members: 217" and "statistical chart = pie" back to the background. The background calls the hightcharts plug-in. The hightcharts plug-in generates a temporary pie chart based on the data source and statistical chart. The temporary pie chart is saved in the background. The background program obtains the basic information of the temporary pie chart (including size and other information) and returns it to the system front-end. The system front-end calls the echarts framework, allocates the layer size, determines the type of image to be rendered, and redraws the graphics to generate a pie chart graphic report on the gender ratio of proposals submitted by committee members.
[0091] Since the report is dynamically generated by the front-end calling the echarts framework, the size of the chart can only be determined after the entire page is generated. At this time, the page has been rendered and the page layout cannot be readjusted. The introduction of the hightcharts plug-in generates a temporary chart in the background before passing the data to the front-end, and then determines the size of the chart and adjusts whether the chart is generated separately or in parallel.
[0092] This application can automatically generate graphic reports, and can automatically switch display types according to specific statistical data, which is vivid and beautiful.
[0093] In one embodiment, Figure 3 As shown, a device for automatically generating graphic and text reports from proposals is provided, including: an acquisition module 302, a calculation module 304, a judgment module 306, a demarcation module 308 and a generation module 310, wherein:
[0094] An acquisition module 302 is used to acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators;
[0095] The calculation module 304 is used to obtain the proposal to be processed, and calculate the number of statistical indicators and data of each statistical indicator in the proposal to be processed according to the statistical indicator library;
[0096] The judgment module 306 is used to sort the data of the statistical indicators when the number of the statistical indicators is greater than a preset threshold value, and calculate the uniformity of the data of each statistical indicator to obtain a uniformity value;
[0097] A demarcation module 308 is used to calculate the demarcation index of the statistical index when the uniformity value meets the preset condition; divide the statistical index and the data of the statistical index by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart;
[0098] The generation module 310 is used to generate a graphic report of the proposal to be processed based on the statistical indicators, the data of the statistical indicators and the statistical charts.
[0099] In one embodiment, the determination module 306 is further configured to include:
[0100] When the number of the statistical indicators is less than or equal to a preset threshold, a statistical chart of a bar graph is generated according to the statistical indicators and data of each statistical indicator.
[0101] In one embodiment, the demarcation module 308 is further configured to include:
[0102] When the uniformity value does not meet the preset condition, a pie chart statistical diagram is generated according to the statistical indicator and the data of each statistical indicator.
[0103] In one embodiment, the generation module 310 is also used to dynamically generate the graphic report of the proposal to be processed by calling the echarts framework through the system front end.
[0104] In one embodiment, the generation module 310 is also used to call the echarts framework before the system front end, and also includes: the system back end calls the hightcharts plug-in, generates a temporary chart in the background, and then passes the data to the front end.
[0105] In one embodiment, the generating module 310 is further configured to generate a temporary chart in the background, and further comprises: obtaining a determination criterion according to the proportion of the temporary chart:
[0106]
[0107] Where W C is the chart width, W P is the page width, and Y is a standard value; the standard value is determined according to the number n of statistical indicators, when n>30, Y=45%, when n≤30, Y=55%;
[0108] When the judgment criteria are met, the temporary chart is generated individually; when the judgment criteria are not met, the temporary chart is generated in parallel; wherein, individually generated means that the temporary chart occupies the content of one line of the graphic report, and parallel generated means that the temporary chart occupies the content of one or more lines of the graphic report after the alignment operation.
[0109] For the specific definition of the device for automatically generating graphic reports from proposals, please refer to the definition of the method for automatically generating graphic reports from proposals above, which will not be repeated here. Each module in the above device can be implemented in whole or in part by software, hardware and a combination thereof. Each of the above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.
[0110] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as follows: Figure 4As shown. The computer device includes a processor, a memory, a network interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for automatically generating a graphic report from a proposal is implemented. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.
[0111] Those skilled in the art will understand that Figure 4 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0112] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the method in the above embodiment when executing the computer program.
[0113] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps of the method in the above embodiment are implemented.
[0114] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
[0115] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0116] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.
Claims
1. A method for automatically generating graphic and text reports from proposals, characterized in that: include: Acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators; Obtaining proposals to be processed, and calculating the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library; When the number of the statistical indicators is greater than a preset threshold, the data of the statistical indicators are sorted, and the uniformity of the data of each statistical indicator is calculated to obtain a uniformity value; When the uniformity value meets the preset condition, the demarcation index of the statistical index is calculated; the statistical index and the data of the statistical index are divided by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart; Generate a temporary chart according to the statistical indicator, the data of the statistical indicator and the statistical chart; and obtain a determination criterion according to the proportion of the temporary chart: Where W C is the chart width, W P is the page width, and Y is the standard value; the standard value is determined according to the number n of statistical indicators, when n>30, Y=45%, when n≤30, Y=55%; When the judgment criteria are met, a temporary chart is generated individually; when the judgment criteria are not met, a temporary chart is generated in parallel; wherein, individually generated means that the temporary chart occupies the content of one line of the graphic report, and parallel generated means that the temporary chart occupies the content of one or more lines of the graphic report after the alignment operation; a graphic report of the proposal to be processed is generated.
2. The method according to claim 1, characterized in that Also includes: When the number of the statistical indicators is less than or equal to a preset threshold, a statistical chart of a bar graph is generated according to the statistical indicators and data of each statistical indicator.
3. The method according to claim 2, characterized in that Also includes: When the uniformity value does not meet the preset condition, a pie chart statistical diagram is generated according to the statistical indicator and the data of each statistical indicator.
4. The method according to any one of claims 1 to 3, characterized in that: The graphic report of the pending proposal is dynamically generated by calling the echarts framework through the system front end.
5. A device for automatically generating graphic reports based on proposals, characterized in that: include: An acquisition module, used to acquire a statistical indicator library, wherein the statistical indicator library includes a plurality of statistical indicators; A calculation module, used to obtain proposals to be processed, and calculate the number of statistical indicators and data of each statistical indicator in the proposals to be processed according to the statistical indicator library; A judgment module, used for sorting the data of the statistical indicators when the number of the statistical indicators is greater than a preset threshold value, and calculating the uniformity of the data of each statistical indicator to obtain a uniformity value; A demarcation module is used to calculate the demarcation index of the statistical index when the uniformity value meets the preset condition; divide the statistical index and the data of the statistical index by the demarcation index to obtain a multi-ring statistical chart; wherein the statistical index and the data of the statistical index before and after the demarcation index respectively generate adjacent rings of the multi-ring statistical chart; A generating module is used to generate a temporary chart according to the statistical indicator, the data of the statistical indicator and the statistical chart; and obtain a judgment criterion according to the proportion of the temporary chart: Where W C is the chart width, W P is the page width, and Y is the standard value; the standard value is determined according to the number n of statistical indicators, when n>30, Y=45%, when n≤30, Y=55%; When the judgment criteria are met, a temporary chart is generated individually; when the judgment criteria are not met, a temporary chart is generated in parallel; wherein, individually generated means that the temporary chart occupies the content of one line of the graphic report, and parallel generated means that the temporary chart occupies the content of one or more lines of the graphic report after the alignment operation; a graphic report of the proposal to be processed is generated.
6. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 4 are implemented.
7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 4 are implemented.
Citation Information
Patent Citations
Customer manager ability map generation method and device
CN113205408A
Chart drawing method and device thereof and computer readable storage medium
CN113516729A