CN112463534B - Daily newspaper generating method, device, equipment and medium - Google Patents
Daily newspaper generating method, device, equipment and medium Download PDFInfo
- Publication number
- CN112463534B CN112463534B CN202011352387.9A CN202011352387A CN112463534B CN 112463534 B CN112463534 B CN 112463534B CN 202011352387 A CN202011352387 A CN 202011352387A CN 112463534 B CN112463534 B CN 112463534B
- Authority
- CN
- China
- Prior art keywords
- target
- daily report
- data file
- template
- test
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a daily newspaper generating method, a device, equipment and a medium, wherein the method comprises the following steps: acquiring a production test data file and a preset daily report template; determining a target daily report template corresponding to the production test data file from the daily report template according to a first test station name in the production test data file and a preset configuration file, wherein the configuration file comprises the first test station name, a second test station name and an incidence relation between the first test station name and the second test station name, and the second test station name is the test station name in the target daily report template; and generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template. Therefore, the daily report can be automatically generated, the consumed time is short, and errors are not easy to occur.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a medium for generating a daily newspaper.
Background
At present, data storage methods tend to be electronic, for example, related production data is recorded in a production data record table, and a product corresponds to one record in the production data record table, for example, environmental temperature detection data, production data and the like can be automatically stored in an excel file or a csv file. In practical application, daily newspapers need to be generated according to production data records and the like, and the current daily newspapers are generated in a mode that required data are manually found in the production data records and then the found data are filled in the daily newspapers. In this manner, when a product has hundreds or thousands of test items and hundreds or thousands of records exist, the excel file or csv file becomes large and complex. When the input volume needs to be inquired from such an excel file or csv file, the passing rate is calculated, and the daily report is filled out due to failure, the method is time-consuming and easy to make mistakes.
Disclosure of Invention
In view of this, an object of the present application is to provide a method, an apparatus, a device, and a medium for generating a daily report, which can automatically generate a daily report, and is short in time consumption and not prone to error. The specific scheme is as follows:
in a first aspect, the present application discloses a daily newspaper generating method, including:
acquiring a production test data file and a preset daily report template;
determining a target daily report template corresponding to the production test data file from the daily report template according to a first test station name and a preset configuration file in the production test data file, wherein the configuration file comprises the first test station name, a second test station name and an incidence relation between the first test station name and the second test station name, and the second test station name is the test station name in the target daily report template;
and generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template.
Optionally, the acquiring the production test data file and the preset daily report template includes:
importing a production test data file and a preset daily template;
and preprocessing the production test data file.
Optionally, the preprocessing the production test data file includes:
extracting and storing data in the production test data file into a multi-dimensional list;
acquiring the maximum row number and the maximum column number of the multidimensional list;
and storing the data in the production test data file into a target matrix, wherein the row number of the target matrix is equal to the maximum row number, and the column number of the target matrix is equal to the maximum column number.
Optionally, the determining, according to the first test station name in the production test data file and a preset configuration file, a target daily report template corresponding to the production test data file includes:
inquiring a preset configuration file according to the first test station name in the production test data file to obtain a second test station name of the target daily report template;
and determining a first target daily report template, a second target daily report template and a third target daily report template corresponding to the second test station name from a first type template, a second type template and a third type template in the daily report templates respectively, and taking the first target daily report template, the second target daily report template and the third target daily report template as the target daily report templates.
Optionally, the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
inserting rows for the first target daily template based on different values of a first target field and different values of a second target field in the target matrix, wherein the first target field and the second target field are used for representing the version of a product;
matching different values of the first target field with different values of the second target field and storing the matched values in a two-dimensional list;
screening out data records corresponding to the values of each pair of the first target field and the second target field from the target matrix, and storing the data records in the two-dimensional list;
determining product test information corresponding to each pair of values of the first target field and the second target field based on the two-dimensional list;
and filling the product test information into rows corresponding to the values of each pair of the first target field and the second target field in the first target daily report template to obtain a first daily report.
Optionally, the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
inserting the second target daily report template into a row based on the total number of the test failure products in the first daily report;
acquiring test failure information of each test failure product based on the target matrix, wherein the test failure information comprises a product two-dimensional code, a test failure project name and test starting time;
and filling the test failure information into the second target daily report template to obtain a second daily report.
Optionally, the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
inserting the third target daily report template into a row based on the total number of the retested products in the first daily report;
obtaining retest information of each retest product based on the target matrix, wherein the retest information comprises a product two-dimensional code, a test failure project name and test starting time;
and filling the retest information into the third target daily report template to obtain a third daily report.
In a second aspect, the present application discloses a daily newspaper generating apparatus, including:
the data acquisition module is used for acquiring a production test data file and a preset daily report template;
a template determining module, configured to determine, from the daily report template, a target daily report template corresponding to the production test data file according to a first test station name in the production test data file and a preset configuration file, where the configuration file includes the first test station name, a second test station name, and an association relationship between the first test station name and the second test station name, and the second test station name is a test station name in the target daily report template;
and the daily report generating module is used for generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template.
In a third aspect, the present application discloses an electronic device, comprising:
a memory and a processor;
wherein the memory is used for storing a computer program;
the processor is configured to execute the computer program to implement the daily report generation method disclosed above.
In a fourth aspect, the present application discloses a computer readable storage medium for storing a computer program, wherein the computer program, when executed by a processor, implements the daily generation method disclosed above.
It can be seen that, according to the application, a production test data file and a preset daily report template are obtained, and then a target daily report template corresponding to the production test data file is determined from the daily report template according to a first test station name and a preset configuration file in the production test data file, wherein the configuration file comprises the first test station name, a second test station name and an association relationship between the first test station name and the second test station name, the second test station name is a test station name in the target daily report template, and then the daily report corresponding to the production test data file can be generated according to the production test data file and the target daily report template. Therefore, after the production test data file and the preset daily newspaper template are obtained, the target daily newspaper template can be determined from the daily newspaper template according to the first test station name and the preset configuration file in the production test data file, and then the corresponding daily newspaper is generated according to the production test data file and the target daily newspaper template, so that the daily newspaper generation automation is realized, the corresponding daily newspaper can be generated only by importing the production test data file, the preset daily newspaper template and the configuration file, the consumed time is short, and errors are not prone to occurring.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only the embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a flowchart of a daily newspaper generation method disclosed in the present application;
FIG. 2 is a flow chart illustrating a pre-processing procedure for producing a test data file as disclosed herein;
FIG. 3 is a flow chart of a method of determining a target daily template disclosed herein;
FIG. 4 is a partial flow diagram of a particular daily newspaper generation method disclosed herein;
FIG. 5 is a flow chart of a method of generating a first daily report as disclosed herein;
FIG. 6 is a flow chart of a method of generating a first daily report as disclosed herein;
FIG. 7 is a first daily (Yield Summary) screenshot as disclosed herein;
FIG. 8 is a partial flow diagram of a particular daily newspaper generation method disclosed herein;
FIG. 9 is a flow chart of a second daily report generation disclosed herein;
FIG. 10 is a second daily newspaper (Yield Top Issue) screenshot as disclosed herein;
FIG. 11 is a partial flow diagram of a particular daily newspaper generation method disclosed herein;
FIG. 12 is a flow chart of a third daily report generation disclosed herein;
FIG. 13 is a third daily newspaper (Yield Top test) screenshot as disclosed in the present application;
fig. 14 is a schematic structural diagram of a daily newspaper generating device disclosed in the present application;
fig. 15 is a block diagram of an electronic device disclosed in the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
At present, when a daily newspaper is generated according to electronically stored production data, required data needs to be found out from the production data manually and written into the daily newspaper, and the daily newspaper generating method needs to consume too much time and is very easy to make mistakes when the production data volume is large. In view of this, the present application provides a daily newspaper generation method, which can automatically generate a daily newspaper, and is short in time consumption and less prone to error.
Referring to fig. 1, an embodiment of the present application discloses a daily newspaper generating method, including:
step S11: and acquiring a production test data file and a preset daily template.
In practical application, when a daily report is generated, a production test data file and a preset daily report template need to be obtained first, wherein the production test data file can be an excel file or a csv file, information such as a test record of a produced product is recorded in the production test data file, the preset daily report template comprises three different types of daily report templates, and each type of daily report template comprises a daily report template suitable for different test stations.
That is, yieldreport format is a daily template of yieldreport to be generated. The yieldreportformat has three sheets: yield Summary, yield Top Issue, yield Top test, each sheet having a small table suitable for different test stations (station) to produce test data daily.
Specifically, the production test data file and a preset daily report template can be imported; and preprocessing the production test data file. That is, the production test data file and the preset daily report template are imported, and then the production test data file can be correspondingly preprocessed, so that the subsequent daily report generation processing is facilitated.
Wherein the preprocessing the production test data file comprises: extracting and storing data in the production test data file into a multi-dimensional list; acquiring the maximum row number and the maximum column number of the multidimensional list; and storing the data in the production test data file into a target matrix, wherein the row number of the target matrix is equal to the maximum row number, and the column number of the target matrix is equal to the maximum column number. Referring to fig. 2, a flow chart for preprocessing the production test data file is shown. Opening a production test data file with a format of a csv file, extracting file original data in the production test data file to a multi-dimensional list, inquiring and acquiring a maximum column n and a maximum row m of the multi-dimensional list, processing the file original data, storing the file original data in an (m, n) matrix, and filling a null value in the position of missing data.
Step S12: and determining a target daily report template corresponding to the production test data file from the daily report template according to a first test station name in the production test data file and a preset configuration file, wherein the configuration file comprises the first test station name, a second test station name and an incidence relation between the first test station name and the second test station name, and the second test station name is the test station name in the target daily report template.
It can be understood that after the production test data file and the preset daily report template are obtained, a target daily report template corresponding to the production test data file needs to be determined from the daily report template according to a first test station name in the production test data file and a preset configuration file. The configuration file comprises the first test station name, a second test station name and the incidence relation between the first test station name and the second test station name, and the second test station name is the test station name in the target daily report template.
That is, the production test data file has a first test station name corresponding to the production test data file, each daily report template in the daily report template also has a second test station name corresponding to the daily report template, and the first test station name and the second test station name are generally different, and each test station has a corresponding daily report template, so that the configuration file needs to be preset, and the configuration file includes the first test station name in the production test data file, the second test station name in the daily report template, and the association relationship between the first test station name and the second test station name, so that the corresponding second test station name can be found by the first test station name.
Therefore, after the production test data file is obtained, a second test station name corresponding to the target daily report template can be found from the configuration file according to the first test station name in the production test data file, and then the daily report template in which the second test station name in the daily report template is the second test station name corresponding to the target daily report template is determined as the target daily report template.
Specifically, a preset configuration file is inquired according to a first test station name in the production test data file to obtain a second test station name of the target daily report template; and respectively determining a first target daily report template, a second target daily report template and a third target daily report template corresponding to the second test station name from a first type template, a second type template and a third type template in the daily report templates, and taking the first target daily report template, the second target daily report template and the third target daily report template as the target daily report templates.
Referring to fig. 3, a flow chart for determining the target template is shown. Inquiring a first test Station Name (Station Name) in a production test data file, then inquiring names in GH & PDCA Name columns of a configuration file (Station Name format table) according to the inquired first test Station Name (Station Name), corresponding to the names in the state Display Name columns, inquiring corresponding second test Station names (Station names) in Yield Summary, yield Top Issue and Yield Top test according to the inquired names in the state Display Name columns, and locking small tables corresponding to the second test Station names (Station names) to serve as the target daily report template. The Name column GH & PDCA of the query configuration file (Station Name format) stores a first test Station Name in the production test data file, and the Name column Station Display Name of the query configuration file (Station Name format) stores a second test Station Name in the corresponding daily template.
Step S13: and generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template.
After the target daily report template is determined, a daily report corresponding to the production test data file can be generated according to the production test data file and the target daily report template, wherein the generated daily report can comprise a plurality of daily reports.
Specifically, the data in the production test data file is extracted and inserted into the target daily report template to obtain the daily report corresponding to the production test data file.
It can be seen that, according to the application, a production test data file and a preset daily report template are obtained, and then a target daily report template corresponding to production test data is determined from the daily report template according to a first test station name and a preset configuration file in the production test data file, wherein the configuration file comprises the first test station name, a second test station name and an association relationship between the first test station name and the second test station name, the second test station name is a test station name in the target daily report template, and then a daily report corresponding to the production test data file can be generated according to the production test data file and the target daily report template. Therefore, after the production test data file and the preset daily newspaper template are obtained, the target daily newspaper template can be determined from the daily newspaper template according to the first test station name in the production test data file and the preset configuration file, then the corresponding daily newspaper is generated according to the production test data file and the target daily newspaper template, the daily newspaper generation automation is achieved, the corresponding daily newspaper can be generated only by importing the production test data file, the preset daily newspaper template and the configuration file, the consumed time is short, and errors are not prone to occurring.
Referring to fig. 4, the generating the daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
step S21: inserting rows for the first target daily template based on different values of a first target field and different values of a second target field in the target matrix, wherein the first target field and the second target field are used for representing versions of products.
Firstly, inserting rows for the first target daily report template based on different values of a first target field and different values of a second target field in the target matrix, wherein the first target field and the second target field jointly represent versions of products, the first target field can be represented by overlay, the second target field can be represented by config, when the values of the first target field are the same and the values of the second target field are different, corresponding products are different, and when the values of the first target field are different and the values of the second target field are the same, corresponding products are different. Specifically, the number of different values of the first target field overlap multiplied by the number of different values of the second target field config is the number of lines to be inserted in the first target daily template. For example, if the first target field overlap has 2 different values and the second target field config has 4 different values, the number of lines to be inserted in the first target datagram template is 8.
Step S22: and matching the different values of the first target field and the different values of the second target field and storing the different values of the first target field and the different values of the second target field in a two-dimensional list.
It is also necessary to pair and store the different values of the first target field and the different values of the second target field in a two-dimensional list. That is, different versions of products included in the production test data file are determined. For example, if the first target field overlap has 2 different values, a and B respectively, and the second target field config has 2 different values, C and D respectively, AC, AD, BC, and BD are stored in the two-dimensional list.
Step S23: and screening out data records corresponding to the values of each pair of the first target field and the second target field from the target matrix, and storing the data records into the two-dimensional list.
Data records corresponding to the values of each pair of the first target field and the second target field may then be screened from the target matrix and stored in the two-dimensional list. That is, the data included in the production test data file is sorted by product and stored as a two-dimensional list.
Step S24: determining product test information corresponding to each pair of values of the first and second target fields based on the two-dimensional list.
Step S25: and filling the product test information into rows corresponding to the values of each pair of the first target field and the second target field in the first target daily report template to obtain a first daily report.
Then, product test information corresponding to each pair of values of the first target field and the second target field can be determined based on the two-dimensional list, wherein the product test information comprises input amount, actual failure amount, re-measurement and the like, and the product test information is filled into a row corresponding to each pair of values of the first target field and the second target field in the first target daily report template to obtain a first daily report.
Referring to fig. 5, a flowchart of generating the first daily report, i.e., a flowchart of Yield Summary processing, is shown. Firstly, searching a small table corresponding to a first test station name in a production test data file and locking a corresponding second test station name, namely, determining the first target daily report template. And then querying the number of different overlaps and configs in the data matrix (namely the target matrix), wherein the overlap _ config is the line number of the small table determined in the previous step, and inserting a new line into the small table according to the calculated line number. The overlay and the config are paired one by one and stored in a two-dimensional list, then data records meeting conditions are screened out from a data matrix according to each pair of overlay and config, the data records are stored in a corresponding overlay-config two-dimensional list, then corresponding Input (Input), actual failure (True Fail) and Retest (Retest) are obtained according to the data records in each pair of overlay, config and overlay-config two-dimensional lists, and the data such as the Input, the actual failure (True Fail), the Retest Rate (Retest Rate) and the like are filled in a small table.
Referring to fig. 6, a specific flowchart of the corresponding Input amount (Input), actual failure amount (True Fail), and Retest (Retest) is obtained according to the data records in the two-dimensional list of overlay and config, and overlay-config for each pair. For each pair of overlay and config (corresponding to each row in the small table), the overlay and config are obtained first. Screening test records of repeated tests from data records in an overlay-config two-dimensional list to obtain Input (Input), inquiring the test records of each product, storing multiple test records of each product, judging the number of the test records of one product, if only one test record is available, judging whether the test is passed (pass), if so, judging the number of successful products +1, if not, judging the number of failed products +1, if the number of the test records is greater than or equal to 2, sequencing the test records according to the record time from small to large, then judging whether the first record is passed, if so, judging the number of successful products +1, if not, judging the second record, and judging the number of the products (Retest) +1 until the last record is judged. Corresponding test failure amounts and re-measurements are obtained.
Referring to fig. 7, a schematic diagram of the first daily newspaper (Yield Summary) is shown.
Referring to fig. 8, the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
step S31: and inserting the second target daily report template into a row based on the total number of the test failure products in the first daily report.
Step S32: and acquiring the test failure information of each test failure product based on the target matrix, wherein the test failure information comprises a product two-dimensional code, a test failure project name and test starting time.
Step S33: and filling the test failure information into the second target daily report template to obtain a second daily report.
The second target daily report is mainly used for counting specific information of the products with test failures counted in the first daily report, so the total number of the products with test failures in the first daily report is used as a line for inserting the template of the second target daily report, test failure information of each product with test failures, including information such as a two-dimensional code of the product, a name of a test failure item, test starting time and the like, is obtained based on the target matrix, and the test failure information is filled into the template of the second target daily report, so that the second daily report can be obtained.
See fig. 9, which is a flow chart for the second daily report (Yield Top Issue). Firstly, searching a small table corresponding to a first test station name in a production test data file and locking a corresponding second test station name, namely, determining the second target daily report template. Obtaining the number (fail number) of failed test products in a first table (Yield Summary), adding a new line to a second target daily template (small table) according to the fail number, inquiring a first test record of each fail product, judging whether the config and item (test item) of the first test record are the same as those of the existing line, if so, positioning to the line with the same config and item, storing a Newsdded parameter + 1, judging the number of test data records of the fail product, storing the fail time (fail test item), the state ID (test product identification) and the test start e (test item start time) of each record of a two-dimensional code (sn) corresponding to the product into a mark column of the line, and if the config and item (test item) of the first test record are not the same as those of the existing line, writing a new line, writing the new line and item, and performing the Newsdded operation on the subsequent parameters + 1. Finally, the Total Input size of the first table (Yield Summary) is obtained, and the value of the Fail Yield column written in each row is Newsawed/Total Input.
Referring to FIG. 10, a schematic diagram of the second daily newspaper (Yield Top Issue) is generated.
Referring to fig. 11, the generating the daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
step 41: inserting the third target daily report template into a row based on the total number of the retested products in the first daily report;
step 42: obtaining retest information of each retest product based on the target matrix, wherein the retest information comprises a product two-dimensional code, a test failure project name and test starting time;
step 43: and filling the retest information into the third target daily report template to obtain a third daily report.
The third target daily report is mainly used for counting specific information of the retested products counted in the first daily report, so the retested products are inserted into the row based on the total number of the retested products in the first daily report, retested information of each retested product, including information such as a product two-dimensional code, a test failure project name and test start time, is obtained based on the target matrix, and the retested information is filled into the second target daily report template, so that the third daily report can be obtained.
See fig. 12 for a flow chart for generating the third daily report (Yield Top test). Firstly, searching a small table corresponding to a first test station name in a production test data file and locking a corresponding second test station name, namely, determining the third target daily report template. Obtaining the number of retested products (number of retests) in a first table (Yield Summary), adding a new line to a third target daily template (small table) according to the number of retests, inquiring a first test record of each retested product, judging whether the config and item (test item) of the first test record are the same as those of the existing line, if so, positioning to the line with the same config and item, and storing a Newsdded parameter + 1, judging the number of test data records of the retested product, storing a fail item, a state ID (test item identification) and a test item start time (test item start time) of each record of a two-dimensional code (sn) corresponding to the product into a record column of the line, if the config and item (test item) of the first test record are the same as those of the existing line, writing a new line and the Newsdded parameter, and then performing subsequent operations on the parameter + 1. Finally, the Total Input size of the first table (Yield Summary) is obtained, and the value of RetestYield column written in each row is Newsawed/Total Input.
See fig. 13 for a schematic representation of the third daily report (Yield Top test) generated.
Referring to fig. 14, an embodiment of the present application discloses a daily report generation device, including:
the data acquisition module 11 is used for acquiring a production test data file and a preset daily report template;
a template determining module 12, configured to determine a target daily report template corresponding to the production test data file from the daily report template according to a first test station name in the production test data file and a preset configuration file, where the configuration file includes the first test station name, a second test station name, and an association relationship between the first test station name and the second test station name, and the second test station name is a test station name in the target daily report template;
and the daily report generating module 13 is configured to generate a daily report corresponding to the production test data file according to the production test data file and the target daily report template.
It can be seen that, according to the application, a production test data file and a preset daily report template are obtained, and then a target daily report template corresponding to production test data is determined from the daily report template according to a first test station name and a preset configuration file in the production test data file, wherein the configuration file comprises the first test station name, a second test station name and an association relationship between the first test station name and the second test station name, the second test station name is a test station name in the target daily report template, and then a daily report corresponding to the production test data file can be generated according to the production test data file and the target daily report template. Therefore, after the production test data file and the preset daily newspaper template are obtained, the target daily newspaper template can be determined from the daily newspaper template according to the first test station name in the production test data file and the preset configuration file, then the corresponding daily newspaper is generated according to the production test data file and the target daily newspaper template, the daily newspaper generation automation is achieved, the corresponding daily newspaper can be generated only by importing the production test data file, the preset daily newspaper template and the configuration file, the consumed time is short, and errors are not prone to occurring.
In some specific implementations, the data obtaining module 11 is configured to: importing a production test data file and a preset daily template; and preprocessing the production test data file.
In some specific implementations, the data obtaining module 11 is configured to: extracting and storing data in the production test data file into a multi-dimensional list; acquiring the maximum row number and the maximum column number of the multidimensional list; and storing the data in the production test data file into a target matrix, wherein the row number of the target matrix is equal to the maximum row number, and the column number of the target matrix is equal to the maximum column number.
In some specific implementations, the template determination module 12 is configured to: inquiring a preset configuration file according to the first test station name in the production test data file to obtain a second test station name of the target daily report template; and respectively determining a first target daily report template, a second target daily report template and a third target daily report template corresponding to the second test station name from a first type template, a second type template and a third type template in the daily report templates, and taking the first target daily report template, the second target daily report template and the third target daily report template as the target daily report templates.
In some specific implementations, the daily report generation module 13 is configured to: inserting rows for the first target daily template based on different values of a first target field and different values of a second target field in the target matrix, wherein the first target field and the second target field are used for representing the version of a product; matching different values of the first target field with different values of the second target field and storing the matched values in a two-dimensional list; screening out data records corresponding to the values of each pair of the first target field and the second target field from the target matrix, and storing the data records into the two-dimensional list; determining product test information corresponding to each pair of values of the first target field and the second target field based on the two-dimensional list; and filling the product test information into rows corresponding to the values of each pair of the first target field and the second target field in the first target daily report template to obtain a first daily report.
In some specific implementations, the daily report generation module 13 is configured to: inserting a row for the second target daily report template based on the total number of the test failure products in the first daily report; acquiring test failure information of each test failure product based on the target matrix, wherein the test failure information comprises a product two-dimensional code, a test failure project name and test starting time; and filling the test failure information into the second target daily report template to obtain a second daily report.
In some specific implementations, the daily report generation module 13 is configured to: inserting the third target daily report template into a row based on the total number of the retested products in the first daily report; obtaining retest information of each retest product based on the target matrix, wherein the retest information comprises a product two-dimensional code, a test failure project name and test starting time; and filling the retest information into the third target daily report template to obtain a third daily report.
Referring to fig. 15, a schematic structural diagram of an electronic device 20 provided in the embodiment of the present application is shown, where the electronic device 20 may implement the steps of the daily report generation method disclosed in the foregoing embodiment.
In general, the electronic device 20 in the present embodiment includes: a processor 21 and a memory 22.
The processor 21 may include one or more processing cores, such as a four-core processor, an eight-core processor, and so on. The processor 21 may be implemented by at least one hardware of a DSP (digital signal processing), an FPGA (field-programmable gate array), and a PLA (programmable logic array). The processor 21 may also include a main processor and a coprocessor, where the main processor is a processor for processing data in an awake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 21 may be integrated with a GPU (graphics processing unit) which is responsible for rendering and drawing images to be displayed on the display screen. In some embodiments, the processor 21 may include an AI (artificial intelligence) processor for processing computing operations related to machine learning.
Memory 22 may include one or more computer-readable storage media, which may be non-transitory. Memory 22 may also include high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In this embodiment, the memory 22 is at least used for storing the following computer program 221, wherein after being loaded and executed by the processor 21, the steps of the daily report generation method disclosed in any one of the foregoing embodiments can be implemented.
In some embodiments, the electronic device 20 may further include a display 23, an input/output interface 24, a communication interface 25, a sensor 26, a power supply 27, and a communication bus 28.
Those skilled in the art will appreciate that the configuration shown in fig. 15 is not limiting to electronic device 20 and may include more or fewer components than those shown.
Further, an embodiment of the present application also discloses a computer-readable storage medium for storing a computer program, wherein the computer program is executed by a processor to implement the daily report generation method disclosed in any of the foregoing embodiments.
For the specific process of the daily report generation method, reference may be made to corresponding contents disclosed in the foregoing embodiments, and details are not repeated here.
The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
Finally, it should also be noted that, in this document, relational terms such as first and second are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of other elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a … …" does not exclude the presence of another identical element in a process, method, article, or apparatus that comprises the element.
The method, the device, the equipment and the medium for generating the daily newspaper provided by the application are introduced in detail, specific examples are applied in the description to explain the principle and the implementation mode of the application, and the description of the above embodiments is only used for helping to understand the method and the core idea of the application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (6)
1. A daily newspaper generating method is characterized by comprising the following steps:
acquiring a production test data file and a preset daily report template;
determining a target daily report template corresponding to the production test data file from the daily report template according to a first test station name in the production test data file and a preset configuration file, wherein the configuration file comprises the first test station name, a second test station name and an incidence relation between the first test station name and the second test station name, and the second test station name is the test station name in the target daily report template;
generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template;
wherein, the acquiring of the production test data file and the preset daily newspaper template comprises:
importing a production test data file and a preset daily template;
preprocessing the production test data file;
wherein the preprocessing the production test data file comprises:
extracting and storing data in the production test data file into a multi-dimensional list;
acquiring the maximum row number and the maximum column number of the multidimensional list;
storing data in the production test data file into a target matrix, wherein the row number of the target matrix is equal to the maximum row number, and the column number of the target matrix is equal to the maximum column number;
the determining a target daily report template corresponding to the production test data file according to the first test station name in the production test data file and a preset configuration file includes:
inquiring a preset configuration file according to the first test station name in the production test data file to obtain a second test station name of the target daily report template;
determining a first target daily report template, a second target daily report template and a third target daily report template corresponding to the second test station name from a first type template, a second type template and a third type template in the daily report templates respectively, and taking the first target daily report template, the second target daily report template and the third target daily report template as the target daily report templates;
generating the daily report corresponding to the production test data file according to the production test data file and the target daily report template comprises the following steps:
inserting rows for the first target daily report template based on different value numbers of a first target field and different value numbers of a second target field in the target matrix, wherein the first target field and the second target field are used for representing the version of a product;
matching the different values of the first target field with the different values of the second target field and storing the different values of the first target field and the different values of the second target field into a two-dimensional list;
screening out data records corresponding to the values of each pair of the first target field and the second target field from the target matrix, and storing the data records into the two-dimensional list;
determining product test information corresponding to each pair of values of the first target field and the second target field based on the two-dimensional list;
and filling the product test information into rows corresponding to the values of each pair of the first target field and the second target field in the first target daily report template to obtain a first daily report.
2. The daily report generation method according to claim 1, wherein the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
inserting the second target daily report template into a row based on the total number of the test failure products in the first daily report;
acquiring test failure information of each test failure product based on the target matrix, wherein the test failure information comprises a product two-dimensional code, a test failure project name and test starting time;
and filling the test failure information into the second target daily report template to obtain a second daily report.
3. The daily report generation method according to claim 1, wherein the generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template includes:
inserting a third target daily report template into a row based on the total number of retested products in the first daily report;
acquiring retest information of each retest product based on the target matrix, wherein the retest information comprises a product two-dimensional code, a test failure project name and test start time;
and filling the retest information into the third target daily report template to obtain a third daily report.
4. A daily newspaper generating apparatus, comprising:
the data acquisition module is used for acquiring a production test data file and a preset daily report template;
a template determining module, configured to determine, from the daily report template, a target daily report template corresponding to the production test data file according to a first test station name in the production test data file and a preset configuration file, where the configuration file includes the first test station name, a second test station name, and an association relationship between the first test station name and the second test station name, and the second test station name is a test station name in the target daily report template;
the daily report generating module is used for generating a daily report corresponding to the production test data file according to the production test data file and the target daily report template;
the data acquisition module is also used for importing a production test data file and a preset daily report template; preprocessing the production test data file;
the data acquisition module is further used for extracting and storing data in the production test data file into a multi-dimensional list; acquiring the maximum row number and the maximum column number of the multidimensional list; storing data in the production test data file into a target matrix, wherein the row number of the target matrix is equal to the maximum row number, and the column number of the target matrix is equal to the maximum column number;
the template determining module is further configured to query a preset configuration file according to the first test station name in the production test data file to obtain a second test station name of the target daily report template; determining a first target daily report template, a second target daily report template and a third target daily report template corresponding to the second test station name from a first type template, a second type template and a third type template in the daily report templates respectively, and taking the first target daily report template, the second target daily report template and the third target daily report template as the target daily report templates;
the first target daily report template is used for storing product test information, the second target daily report template is used for storing test failure information of a product with test failure, and the third target daily report template is used for storing retest information of a retest product;
the daily report generation module is further configured to insert rows for the first target daily report template based on different value numbers of a first target field and different value numbers of a second target field in the target matrix, where the first target field and the second target field are used for representing versions of products; matching different values of the first target field with different values of the second target field and storing the matched values in a two-dimensional list; screening out data records corresponding to the values of each pair of the first target field and the second target field from the target matrix, and storing the data records into the two-dimensional list; determining product test information corresponding to each pair of values of the first target field and the second target field based on the two-dimensional list; and filling the product test information into rows corresponding to the values of each pair of the first target field and the second target field in the first target daily report template to obtain a first daily report.
5. An electronic device, comprising:
a memory and a processor;
wherein the memory is used for storing a computer program;
the processor is configured to execute the computer program to implement the daily report generation method according to any one of claims 1 to 3.
6. A computer-readable storage medium for storing a computer program, wherein the computer program, when executed by a processor, implements the daily report generation method according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011352387.9A CN112463534B (en) | 2020-11-26 | 2020-11-26 | Daily newspaper generating method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011352387.9A CN112463534B (en) | 2020-11-26 | 2020-11-26 | Daily newspaper generating method, device, equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112463534A CN112463534A (en) | 2021-03-09 |
| CN112463534B true CN112463534B (en) | 2022-11-11 |
Family
ID=74808878
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011352387.9A Active CN112463534B (en) | 2020-11-26 | 2020-11-26 | Daily newspaper generating method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112463534B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107622014A (en) * | 2017-09-22 | 2018-01-23 | 广州视源电子科技股份有限公司 | Test report generation method and device, readable storage medium and computer equipment |
| CN109933770A (en) * | 2019-03-20 | 2019-06-25 | 浪潮商用机器有限公司 | A kind of test report generation method, system and electronic equipment and storage medium |
| CN110096434A (en) * | 2019-03-28 | 2019-08-06 | 咪咕文化科技有限公司 | Interface testing method and device |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7913230B2 (en) * | 2007-01-31 | 2011-03-22 | Oracle International Corporation | Computer-implemented methods and systems for generating software testing documentation and test results management system using same |
| CN102650984A (en) * | 2011-02-24 | 2012-08-29 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN106126406B (en) * | 2016-06-22 | 2019-05-31 | 中国建设银行股份有限公司 | A kind of generation method and device using daily paper |
| CN109376069B (en) * | 2018-09-03 | 2023-07-21 | 中国平安人寿保险股份有限公司 | Method and device for generating test report |
| CN111241804A (en) * | 2020-01-21 | 2020-06-05 | 中国海洋大学 | Household appliance test report generation and interaction method and device for Internet of things |
-
2020
- 2020-11-26 CN CN202011352387.9A patent/CN112463534B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107622014A (en) * | 2017-09-22 | 2018-01-23 | 广州视源电子科技股份有限公司 | Test report generation method and device, readable storage medium and computer equipment |
| CN109933770A (en) * | 2019-03-20 | 2019-06-25 | 浪潮商用机器有限公司 | A kind of test report generation method, system and electronic equipment and storage medium |
| CN110096434A (en) * | 2019-03-28 | 2019-08-06 | 咪咕文化科技有限公司 | Interface testing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112463534A (en) | 2021-03-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI582616B (en) | Formatting data by example | |
| CN110096434A (en) | Interface testing method and device | |
| CN104657274B (en) | software interface test method and device | |
| CN106446091A (en) | Preprocessing method and device for multi-source time series data | |
| US11675756B2 (en) | Data complementing system and data complementing method | |
| CN114005126A (en) | Table reconstruction method and device, computer equipment and readable storage medium | |
| CN106294825A (en) | A kind of excel data managing method and system, client, service end | |
| CN111813593B (en) | Data processing method, device, server and storage medium | |
| CN111931460B (en) | Variable-row-supporting Excel file analysis method and system | |
| CN112487072A (en) | Method, device, system and medium for standardizing parameter structure of electronic component | |
| CN111159167B (en) | Labeling quality detection device and method | |
| CN114359533B (en) | Page number identification method based on page text and computer equipment | |
| CN115794641A (en) | Method, device and equipment for making number based on business process and storage medium | |
| CN110275938B (en) | Knowledge extraction method and system based on unstructured document | |
| CN117423299B (en) | Performance detection method, device and equipment for liquid crystal display screen and storage medium | |
| CN112632926B (en) | Bill data processing method and device, electronic equipment and storage medium | |
| CA3142579A1 (en) | Method and apparatus for validation of event tracking acquired data | |
| CN112463534B (en) | Daily newspaper generating method, device, equipment and medium | |
| CN116702703A (en) | Automatic typesetting method and electronic equipment | |
| CN112732681B (en) | Data platform migration method and system | |
| CN115129590A (en) | Test case generation method and device, electronic equipment and storage medium | |
| CN112241445B (en) | Labeling method and device, electronic equipment and storage medium | |
| CN111309623B (en) | Coordinate class data classification test method and device | |
| CN113868411A (en) | Contract comparison method and device, storage medium and computer equipment | |
| CN110928910A (en) | Method and device for reading and writing vector elements in Shapfile at high speed |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |