CN115146006A - Report statistical method and related equipment for corrugated paper packaging industry - Google Patents
Report statistical method and related equipment for corrugated paper packaging industry Download PDFInfo
- Publication number
- CN115146006A CN115146006A CN202211004923.5A CN202211004923A CN115146006A CN 115146006 A CN115146006 A CN 115146006A CN 202211004923 A CN202211004923 A CN 202211004923A CN 115146006 A CN115146006 A CN 115146006A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- database
- corrugated paper
- packaging industry
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004806 packaging method and process Methods 0.000 title claims abstract description 72
- 238000007619 statistical method Methods 0.000 title claims abstract description 20
- 238000000034 method Methods 0.000 claims abstract description 36
- 230000003068 static effect Effects 0.000 claims abstract description 20
- 238000003860 storage Methods 0.000 claims abstract description 16
- 238000004364 calculation method Methods 0.000 claims abstract description 13
- 238000001914 filtration Methods 0.000 claims abstract description 13
- 238000012216 screening Methods 0.000 claims abstract description 12
- 230000006870 function Effects 0.000 claims description 66
- 238000004519 manufacturing process Methods 0.000 claims description 65
- 238000012423 maintenance Methods 0.000 claims description 7
- 238000012935 Averaging Methods 0.000 claims description 4
- 230000002776 aggregation Effects 0.000 claims description 4
- 238000004220 aggregation Methods 0.000 claims description 4
- 238000011161 development Methods 0.000 abstract description 22
- 230000018109 developmental process Effects 0.000 description 19
- 230000008569 process Effects 0.000 description 7
- 230000002950 deficient Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 3
- 241000282813 Aepyceros melampus Species 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
- 230000008447 perception Effects 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a report statistical method and related equipment for corrugated paper packaging industry, wherein the method comprises the following steps: the report form counting function application system reads the configuration information of the database, is connected with the database according to a database driving program and reads the storage data information of the table in the database; configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting; the report statistics designer determines page coordinates by using grid units, the grid units are used for defining various components, static data and dynamic data are bound in a grid working area, calculation and statistics are carried out according to data information filled in the grid units, and a report used for the corrugated paper packaging industry is generated. The invention improves the development efficiency of the report counting business function, can reduce the development manpower resource and the development time to a great extent, and can quickly build the report counting function.
Description
Technical Field
The invention relates to the technical field of data visualization, in particular to a report statistical method, a report statistical system, a report statistical terminal and a computer-readable storage medium for the corrugated paper packaging industry.
Background
With the rapid development of internet technology and the improvement of social informatization degree, faster, higher and stronger requirements are provided for information acquisition capability, data analysis capability and decision making capability, the report can be used for carrying out preliminary statistics on events and can vividly and intuitively display relevant information of the events, for example, in daily work, the work content can be reported to relevant departments through a daily report, a weekly report and a monthly report, the application of the report with the function of comprehensively displaying the data statistical analysis result is more and more extensive, and report statistical analysis tools are more and more provided. The report statistics designer application is a visual tool for specially designing a report template, and a main interface of the whole application program consists of a main menu, a toolbar, a report layout window, an object browsing window and an attribute editing window.
The traditional development mode is that a required data result set of report statistics is firstly inquired, the report statistics is inquired according to conditions, and a report statistics display page calls a background interface to acquire the data result set to be displayed on a page. If the requirement change needs to modify the corresponding front-end display page and the rear-end query interface code, and then the application is released, the requirement change needs professional developers to realize the requirement change. The making of one report statistic occupies a large amount of development resources, the development period is long, the requirement change is not flexible enough, and the iterative release is complex, so that the maintenance cost is increased.
Accordingly, there is a need for improvements and developments in the art.
Disclosure of Invention
The invention mainly aims to provide a report statistics method, a report statistics system, a report statistics terminal and a computer readable storage medium for corrugated paper packaging industry, and aims to solve the problems that in the prior art, report statistics occupies a large amount of development resources, the development period is long, the demand change is not flexible enough, the iterative release is complex, and the maintenance cost is increased.
In order to achieve the above object, the present invention provides a report statistics method for corrugated paper packaging industry, which comprises the following steps:
the report counting function application system reads the configuration information of the database, is connected with the database according to a database driving program and reads the stored data information of a table in the database;
configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting;
the report statistics designer determines page coordinates by using grid units, the grid units are used for defining various components, static data and dynamic data are bound in a grid working area, calculation and statistics are carried out according to data information filled in the grid units, and a report used for the corrugated paper packaging industry is generated.
Optionally, the report statistics method for the corrugated paper packaging industry, where the database is connected according to a database driver, and the reading of the stored data information in the table in the database includes:
if the database is connected to the Mysql database according to the database driver, the configuration address information of the Mysql database is read through the drive package of the Mysql database, and the Mysql database is accessed according to the user name and the password to acquire the business data information related to the report statistical function.
Optionally, the report statistics method for the corrugated paper packaging industry is that the static data is data information to be displayed which is directly input in an input box of the component configuration item; the dynamic data is a data set which is configured in an associated mode or a data set of http.
Optionally, the report statistics method for the corrugated paper packaging industry, wherein the calculating and counting according to the data information filled in the grid unit includes:
according to the data information filled in the grid unit, calculation and statistics are carried out through functions, including data aggregation, averaging and data grouping.
Optionally, the report statistics designer determines page coordinates by using a grid unit, where the grid unit is used to define various components, bind static data and dynamic data in a grid work area, perform calculation and statistics according to data information filled in the grid unit, and generate a report for the corrugated paper packaging industry, and then the report statistics designer further includes:
and after generating a report for the corrugated paper packaging industry, generating an access address of the report for the corrugated paper packaging industry, wherein the access address is used for a user to enter a display page with a report counting function after clicking.
Optionally, the report statistical method for the corrugated paper packaging industry is that the report for the corrugated paper packaging industry includes: the method comprises the steps of equipment production statistics, equipment state information statistics, monthly production task statistics, monthly production information statistics, equipment maintenance information statistics, production and work reporting information statistics, shutdown daily report information statistics and production daily report statistics.
Optionally, the report statistics method for the corrugated paper packaging industry, wherein the data set includes: a device production dataset, a production task dataset, a production progress dataset, a monthly production information dataset, a production work report dataset, a shutdown daily report dataset, and a production daily report dataset.
In addition, in order to achieve the above object, the present invention further provides a report statistics system for corrugated paper packaging industry, wherein the report statistics system for corrugated paper packaging industry includes:
the data reading module is used for reading the database configuration information by the report counting function application system, connecting the database according to the database driving program and reading the stored data information of the table in the database;
the information screening module is used for configuring a corresponding data source according to a business data set required by the report counting function, performing parameter configuration and condition filtering on the data set and screening out information required by report counting;
and the report generation module is used for determining page coordinates by using a grid unit through the report statistical designer, wherein the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, calculating and counting according to data information filled in the grid unit, and generating a report for the corrugated paper packaging industry.
In addition, to achieve the above object, the present invention further provides a terminal, wherein the terminal includes: the report statistics program for the corrugated paper packaging industry is stored on the memory and can run on the processor, and when being executed by the processor, the report statistics program for the corrugated paper packaging industry realizes the steps of the report statistics method for the corrugated paper packaging industry.
In addition, in order to achieve the above object, the present invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a report statistical program for the corrugated paper packaging industry, and when the report statistical program for the corrugated paper packaging industry is executed by a processor, the steps of the report statistical method for the corrugated paper packaging industry as described above are implemented.
In the invention, a report statistics function application system reads database configuration information, is connected with a database according to a database driving program and reads stored data information of a table in the database; configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting; the report statistics designer determines page coordinates by using grid units, the grid units are used for defining various components, static data and dynamic data are bound in a grid working area, calculation and statistics are carried out according to data information filled in the grid units, and a report used for the corrugated paper packaging industry is generated. The invention improves the development efficiency of the report counting business function, automatically generates the report counting function, greatly improves the reusability of the function by configuring a data set and matching the report components, can reduce the development manpower resource and the development time to a great extent, and quickly builds the report counting function.
Drawings
FIG. 1 is a flow chart of a report statistical method for corrugated paper packaging industry according to a preferred embodiment of the present invention;
FIG. 2 is a diagram illustrating a self-defined report counting function in a preferred embodiment of the report counting method for corrugated paper packaging industry according to the present invention;
FIG. 3 is a diagram illustrating a report display page in the preferred embodiment of the report statistical method for corrugated paper packaging industry according to the present invention;
FIG. 4 is a schematic diagram of a report statistics system for corrugated paper packaging industry according to a preferred embodiment of the present invention;
FIG. 5 is a diagram illustrating an operating environment of a terminal according to a preferred embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer and clearer, the present invention is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, the report statistics method for corrugated paper packaging industry according to the preferred embodiment of the present invention includes the following steps:
and S10, reading the configuration information of the database by the report counting function application system, connecting the database according to the database driving program, and reading the stored data information of the table in the database.
Wherein the database comprises: the system comprises a relational database and a non-relational database, wherein the relational database is a structured database and is established on the basis of a relational model (a two-dimensional table model) and generally faces to records; databases other than the mainstream relational database are considered to be non-relational; the relational database includes: a Mysql database, an Oracle database, a Sqlserver database and a Postgress database; the non-relational database includes: the Elasticsearch database, the Kudu database and the Impala database.
Specifically, the data source is configured, and the report statistics function shows the source of the data; the data source configuration support service application is a distributed micro service and also supports database configuration connection to third party services. The report statistics function application system reads the configuration information of the database, is connected with the database according to the database driving program, and directly reads the stored data information of the table in the database.
For example, the Mysql database reads the configuration address information of the Mysql database through a drive package of the Mysql database, and accesses the Mysql database according to a user name and a password, so as to obtain service data information related to the report statistics function. For example: the report counting function needs to display the work starting and work descending information of the staff, the data source is configured into a database served by the user center, the work production and work descending information table of the staff is read, and the work starting and work descending data information of the corresponding staff is inquired.
Meanwhile, the invention supports various data acquisition modes, such as relational databases of Mysql, oracle, sqlserver, postgress and the like, non-relational databases of Elasticisearch, kudu, impala and the like, and also supports HTTP request to acquire data information.
And S20, configuring a corresponding data source according to the business data set required by the report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting.
The data set is a result set of reading data information of a database table or HTTP request through a Sql statement (Structured Query Language, a database Query and programming Language for accessing data and querying, updating and managing a relational database system); the data set includes: a device production dataset, a production task dataset, a production progress dataset, a monthly production information dataset, a production work report dataset, a shutdown daily report dataset, and a production daily report dataset.
Specifically, the data set is configured according to the data source, the service data set required by the report statistics function configures the corresponding data source, and the service data set is acquired through Sql query or HTTP request. The data set can be processed, query condition parameters are configured (condition parameters can be added in the data set query), and the configuration parameters are used for performing condition filtering on the data set.
For example: the report statistics function counts the information of production equipment in production and production equipment not started in a factory, and judges according to the equipment state information pushed by an IOT (equipment information acquisition service) service. The equipment state information parameters comprise states of non-operation, standby, production, fault shutdown, normal shutdown, equipment abnormity and the like, and the filtering treatment can be carried out when the states are not met. The report statistics function inquires statistical data by setting parameters, only displays the equipment in production of the A factory, performs condition filtering by the equipment state and the organization to which the equipment belongs, removes the equipment information which does not belong to the production state and does not belong to the A factory, and screens out the equipment result information in production of the A factory required by statistics.
And S30, determining page coordinates by using a grid unit by using a report statistics designer, wherein the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, calculating and counting according to data information filled in the grid unit, and generating a report for the corrugated paper packaging industry.
The static data is data information to be displayed which is directly input in an input box of the component configuration item; the dynamic data is a data set which is configured in an associated mode or a data set of http. The assembly comprises: a bar graph component, a table component, a map component, a dashboard, a text box, a line graph, and a thermodynamic diagram.
Specifically, the report statistics function designer determines page coordinates by using grid cells, each grid cell may define various components including various charts, tables, characters, and the like, for example, a histogram component, a table component, a map component, a dashboard, a text box, a line graph, a thermodynamic diagram, and the like, static data may be directly bound in a grid workspace, the static data is directly input content, and what is seen is what is obtained is that static data is data information to be displayed directly input in an input box of a component configuration item, such as: the dynamic data is a data set which is configured in a relevant mode or a data set of http, the result can be directly checked through previewing, and the required report counting function can be conveniently and quickly achieved. The grid can also bind dynamic data sets or well-bound plug-ins, the dynamic data sets are configured data sets, and various calculations and statistics such as data aggregation, averaging, data grouping and the like are performed according to data information and functions filled in grid cells.
Furthermore, the developer synthesizes a report statistic function through the combination of various report components. The report statistics function display area can perform data binding according to the table, and perform data statistics through functions, for example: a factory needs to display production data information for one month, the information can be displayed by a list, a configured data set is bound to a table component, a statistical result can be output, the total product yield, good products and defective products are calculated, statistical analysis is carried out again, the yield and the defective product rate are calculated, and the required display effect can be achieved without code development. After the combination is completed, an access address is generated, and a user can access the address to enter a display page of the report counting function. The report counting function only needs to carry out corresponding component matching, thereby greatly reducing the development manpower resources and reducing the development threshold.
In addition, due to the installation and deployment of the report counting function, system operation and maintenance personnel can configure the request address of the prepared report counting function to a menu which can be accessed by a user, and the user only needs to log in the system and enter the menu. The whole process can lead the client to have no perception, and the client can be deployed online without restarting the service.
As shown in fig. 2, a data source corresponding to a service is configured; configuring a data set according to a data source; the self-defined report comprises equipment production statistics, equipment state information statistics, monthly production task statistics, monthly production information statistics, equipment maintenance information statistics, production and work reporting information statistics, shutdown daily report information statistics, production daily report statistics and other business reports.
Configuring a data source corresponding to the service, for example: the system comprises a user center database, a basic information database, an equipment center database, a user database, an MES database, a WMS database, an APS database and the like, wherein a data source is the basis of a report counting function; configuring a data set according to a data source, configuring an equipment state information data set according to an equipment center data source, configuring a staff information data set by a user center data source, and configuring an equipment production data set, a production task data set, a production progress data set, a monthly production information data set, a production and reporting data set, a stop daily report data set, a production daily report data set and the like by an MES (manufacturing execution system) database, wherein the data set is a report statistics function display; the report counting function is used for carrying out component collocation, a component is used for forming a report counting function component for binding a data set, a percentage instrument panel component is used for binding an equipment production data set, and the information of equipment production, the finished production quantity and the unfinished production quantity of each equipment and the like can be checked; the report counting function is realized, an access address is generated, and a user accesses the report counting function; the report designer application display picture is shown in fig. 3, and report statistics show a report form number, a product name, an equipment code, an equipment name, a non-defective product number, an output number, a defective product number, a scrap number, a report worker and report time, for example, the report form number is fsbg-509-22016, the product number is XM-0021, the product name is a television packing box, the equipment code is MRS-2200, the equipment name is a 2 m 2 seven-layer corrugated board production equipment, the non-defective product number is 111, the output number is 111, the defective product number is 0, the scrap number is 0, the report worker is a placement 1, and the report time is 2022-05-09 18.
In addition, the user can self-make the statistical analysis report as required, select the corresponding view and the related attributes of the report, such as the size of the report, the type of the report, the name of the report, the unit and the like, click the preview to generate the report, and the user can also adjust the report by adjusting the parameters in real time. The method is suitable for report making scenes of application systems based on the relational database, and particularly under the condition that a user needs to create data statistical analysis reports with similar business processes in batches, the user can reduce a lot of workload through the method, and the user can meet the report making requirements, namely the requirement of the user for quickly generating the statistical reports is met.
The invention improves the development efficiency of the report counting service function, automatically generates the report counting function, greatly improves the reusability of the function by configuring a data set and matching the report components, can reduce the development manpower resource and the development time to a great extent, and quickly builds the report counting function; the number of developers who add information manually is reduced, intelligent functions are increased, and human resources are reduced.
Further, as shown in fig. 4, based on the above report statistics method for the corrugated paper packaging industry, the present invention also provides a report statistics system for the corrugated paper packaging industry, wherein the report statistics system for the corrugated paper packaging industry includes:
the data reading module 51 is used for reading the database configuration information by the report statistics function application system, connecting the database according to the database driving program, and reading the stored data information of the table in the database;
the information screening module 52 is configured to configure a corresponding data source according to the service data set required by the report statistics function, perform parameter configuration and condition filtering on the data set, and screen out information required by the report statistics;
and the report generation module 53 is used for determining the page coordinates by using a grid unit by the report statistics designer, wherein the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, performing calculation and statistics according to data information filled in the grid unit, and generating a report for the corrugated paper packaging industry.
Further, as shown in fig. 5, based on the above report statistics method and system for corrugated paper packaging industry, the present invention also provides a terminal, where the terminal includes a processor 10, a memory 20, and a display 30. Fig. 5 shows only some of the components of the terminal, but it is to be understood that not all of the shown components are required to be implemented, and that more or fewer components may be implemented instead.
The memory 20 may in some embodiments be an internal storage unit of the terminal, such as a hard disk or a memory of the terminal. The memory 20 may also be an external storage device of the terminal in other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like provided on the terminal. Further, the memory 20 may also include both an internal storage unit and an external storage device of the terminal. The memory 20 is used for storing application software installed in the terminal and various types of data, such as program codes of the installation terminal. The memory 20 may also be used to temporarily store data that has been output or is to be output. In an embodiment, the memory 20 stores a report statistics program 40 for the corrugated paper packaging industry, and the report statistics program 40 for the corrugated paper packaging industry can be executed by the processor 10, so as to implement the report statistics method for the corrugated paper packaging industry in the present application.
The processor 10 may be a Central Processing Unit (CPU), a microprocessor or other data Processing chip in some embodiments, and is used for running program codes stored in the memory 20 or Processing data, such as executing the report counting method for the corrugated paper packaging industry.
The display 30 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch panel, or the like in some embodiments. The display 30 is used for displaying information at the terminal and for displaying a visual user interface. The components 10-30 of the terminal communicate with each other via a system bus.
In one embodiment, the following steps are implemented when the processor 10 executes the reporting statistic program 40 in the memory 20 for the corrugated paper packaging industry:
the report form counting function application system reads the configuration information of the database, is connected with the database according to a database driving program and reads the storage data information of the table in the database;
configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting;
and the report statistics designer determines page coordinates by using a grid unit, the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, and performing calculation and statistics according to data information filled in the grid unit to generate a report for the corrugated paper packaging industry.
The connecting the database according to the database driver, and reading the stored data information in the table in the database includes:
if the database is connected to the Mysql database according to the database driver, the configuration address information of the Mysql database is read through the drive package of the Mysql database, and the Mysql database is accessed according to the user name and the password to acquire the business data information related to the report statistical function.
The static data is data information to be displayed which is directly input in an input box of the component configuration item; the dynamic data is a data set which is configured in an associated mode or a data set of http.
Wherein, the calculating and counting according to the data information filled in by the grid unit comprises:
and calculating and counting according to the data information filled in the grid unit through functions, wherein the functions comprise data aggregation, averaging and data grouping.
The report statistics designer determines page coordinates by using a grid unit, the grid unit is used for defining various components, static data and dynamic data are bound in a grid working area, calculation and statistics are carried out according to data information filled in the grid unit, and a report used for the corrugated paper packaging industry is generated, and the report statistics designer further comprises the following steps:
and after generating a report for the corrugated paper packaging industry, generating an access address of the report for the corrugated paper packaging industry, wherein the access address is used for a user to enter a display page with a report counting function after clicking.
Wherein, the report form for corrugated paper packaging industry includes: the method comprises the steps of equipment production statistics, equipment state information statistics, monthly production task statistics, monthly production information statistics, equipment maintenance information statistics, production and work reporting information statistics, shutdown daily report information statistics and production daily report statistics.
Wherein the data set comprises: a device production dataset, a production task dataset, a production progress dataset, a monthly production information dataset, a production work report dataset, a shutdown daily report dataset, and a production daily report dataset.
The invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a report statistical program for corrugated paper packaging industry, and the report statistical program for corrugated paper packaging industry realizes the steps of the report statistical method for corrugated paper packaging industry when being executed by a processor.
In summary, the present invention provides a report statistics method and related device for corrugated paper packaging industry, wherein the method includes: the report counting function application system reads the configuration information of the database, is connected with the database according to a database driving program and reads the stored data information of a table in the database; configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting; and the report statistics designer determines page coordinates by using a grid unit, the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, and performing calculation and statistics according to data information filled in the grid unit to generate a report for the corrugated paper packaging industry. The invention improves the development efficiency of the report counting business function, automatically generates the report counting function, greatly improves the reusability of the function by configuring a data set and matching the report components, can reduce the development manpower resource and the development time to a great extent, and quickly builds the report counting function.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrases "comprising a component of' 8230; \8230;" does not exclude the presence of additional like elements in the process, method, article, or terminal that comprises the element.
Of course, it will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by instructing relevant hardware (such as a processor, a controller, etc.) through a computer program, and the program can be stored in a computer readable storage medium, and when executed, the program can include the processes of the embodiments of the methods described above. The computer readable storage medium may be a memory, a magnetic disk, an optical disk, etc.
It will be understood that the invention is not limited to the examples described above, but that modifications and variations will occur to those skilled in the art in light of the above teachings, and that all such modifications and variations are considered to be within the scope of the invention as defined by the appended claims.
Claims (10)
1. A report statistical method for the corrugated paper packaging industry is characterized by comprising the following steps:
the report counting function application system reads the configuration information of the database, is connected with the database according to a database driving program and reads the stored data information of a table in the database;
configuring a corresponding data source according to a business data set required by a report counting function, performing parameter configuration and condition filtering on the data set, and screening out information required by report counting;
the report statistics designer determines page coordinates by using grid units, the grid units are used for defining various components, static data and dynamic data are bound in a grid working area, calculation and statistics are carried out according to data information filled in the grid units, and a report used for the corrugated paper packaging industry is generated.
2. A report statistical method for corrugated paper packaging industry according to claim 1, wherein the connecting the database according to the database driver, and reading the stored data information in the table in the database comprises:
if the database is connected to the Mysql database according to the database driver, the configuration address information of the Mysql database is read through the drive package of the Mysql database, and the Mysql database is accessed according to the user name and the password to acquire the business data information related to the report statistical function.
3. A report statistical method for corrugated paper packaging industry as claimed in claim 1, wherein the static data is data information to be displayed directly inputted in an input box of a component configuration item; the dynamic data is a data set which is configured in an associated mode or a data set of http.
4. A report statistical method for corrugated paper packaging industry as claimed in claim 1, wherein said calculating and counting according to the data information filled in the grid unit comprises:
according to the data information filled in the grid unit, calculation and statistics are carried out through functions, including data aggregation, averaging and data grouping.
5. A report statistic method for corrugated paper packaging industry as claimed in claim 1, wherein said report statistic designer determines page coordinates using grid cells, said grid cells are used for defining various components, binding static data and dynamic data in grid work area, performing calculation and statistics according to data information filled in grid cells, and generating report for corrugated paper packaging industry, and thereafter further comprising:
and after generating a report for the corrugated paper packaging industry, generating an access address of the report for the corrugated paper packaging industry, wherein the access address is used for a user to enter a display page with a report counting function after clicking.
6. The report statistical method for the corrugated paper packaging industry according to claim 1, wherein the report for the corrugated paper packaging industry comprises: the method comprises the steps of equipment production statistics, equipment state information statistics, monthly production task statistics, monthly production information statistics, equipment maintenance information statistics, production and work reporting information statistics, shutdown daily report information statistics and production daily report statistics.
7. A report statistical method for corrugated paper packaging industry according to claim 1, wherein said data set comprises: a device production dataset, a production task dataset, a production progress dataset, a monthly production information dataset, a production work report dataset, a shutdown daily report dataset, and a production daily report dataset.
8. A report statistic system for corrugated paper packaging industry is characterized by comprising:
the data reading module is used for reading the database configuration information by the report counting function application system, connecting the database according to the database driving program and reading the stored data information of the table in the database;
the information screening module is used for configuring a corresponding data source according to a business data set required by the report counting function, performing parameter configuration and condition filtering on the data set and screening out information required by report counting;
and the report generation module is used for determining page coordinates by using a grid unit through the report statistical designer, wherein the grid unit is used for defining various components, binding static data and dynamic data in a grid working area, calculating and counting according to data information filled in the grid unit, and generating a report for the corrugated paper packaging industry.
9. A terminal, characterized in that the terminal comprises: a memory, a processor and a report statistic program for corrugated paper packaging industry stored on the memory and capable of running on the processor, wherein the report statistic program for corrugated paper packaging industry realizes the steps of the report statistic method for corrugated paper packaging industry according to any one of claims 1-7 when being executed by the processor.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a reporting statistic program for corrugated paper packaging industry, which when executed by a processor, implements the steps of the reporting statistic method for corrugated paper packaging industry according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211004923.5A CN115146006A (en) | 2022-08-22 | 2022-08-22 | Report statistical method and related equipment for corrugated paper packaging industry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211004923.5A CN115146006A (en) | 2022-08-22 | 2022-08-22 | Report statistical method and related equipment for corrugated paper packaging industry |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115146006A true CN115146006A (en) | 2022-10-04 |
Family
ID=83415865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211004923.5A Pending CN115146006A (en) | 2022-08-22 | 2022-08-22 | Report statistical method and related equipment for corrugated paper packaging industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115146006A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN109582937A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | Report form generation method, device, storage medium and processor |
| CN114036177A (en) * | 2021-11-03 | 2022-02-11 | 重庆邮电大学 | Design and implementation method of intelligent report based on component |
-
2022
- 2022-08-22 CN CN202211004923.5A patent/CN115146006A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582937A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | Report form generation method, device, storage medium and processor |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN114036177A (en) * | 2021-11-03 | 2022-02-11 | 重庆邮电大学 | Design and implementation method of intelligent report based on component |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10275221B2 (en) | Systems and methods for generating data visualization applications | |
| CN106682097B (en) | Method and device for processing log data | |
| US9076072B2 (en) | System and method for web page rendering test automation suite | |
| KR101322975B1 (en) | Customizable parameter user interface | |
| US8260813B2 (en) | Flexible data archival using a model-driven approach | |
| US9223847B2 (en) | Using dimension substitutions in OLAP cubes | |
| EP2166496A1 (en) | Method, system, and computer for analytical reporting and archiving of data | |
| CN102867282A (en) | Implementation method for mobile Internet-based customer service quality analysis system | |
| US20180136793A1 (en) | Visual work instructions for assembling product | |
| CN112527373A (en) | Visual platform expanding method based on operation integrated management center service | |
| CN113031936A (en) | Method and system for automatically setting up page and immediately releasing page | |
| US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
| CN114371845A (en) | Form generation method and device | |
| CN114185750A (en) | Process monitoring method, device, equipment and storage medium | |
| CN115146006A (en) | Report statistical method and related equipment for corrugated paper packaging industry | |
| CN110888802A (en) | Method for managing test requirement | |
| CN115510361A (en) | Data chart page generation method based on visual configuration and related equipment | |
| CN113435944A (en) | Marketing effect post-evaluation system | |
| WO2024065338A1 (en) | Electronic kanban determining method and apparatus | |
| CN115114320A (en) | Data visualization large screen creating method and related equipment for corrugated industry | |
| CN116227452B (en) | Method, apparatus, device and storage medium for analyzing templates using assembled cards | |
| CN117150598B (en) | Family table management and integration method and system for CAD model construction | |
| CN116185381B (en) | Cloud native low-code construction method, system and application based on micro-service architecture | |
| CN117472380B (en) | Front-end form generation method and system | |
| CN114168121B (en) | Software system, terminal and storage medium based on code factory mode development |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20221004 |