Production test data statistical management method and system, computer equipment and storage medium
By recording the test start and end time of the device on the test end, and performing data merging and calculating on the management end, the problem of inaccurate equipment production and testing time is solved, and data integrity and accuracy are achieved in different network environments.
Patent Information
- Application Number
- CN202410036130.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-01-10
- Publication Date
- 2025-07-11
AI Technical Summary
In the prior art, because the production and testing time of each device is not accurately recorded, the calculation of the production and testing time-consuming data of each device is inaccurate, and it can only be used in factories that can be connected to the Internet, and the scenario is single.
By recording the test start and end time on the test end and server side, and performing data merging and computing on the management side, ensuring the accuracy and integrity of the data, supporting local and server import modes, adapting to different network environments.
It realizes accurate recording and statistics of test time of each device, supports accurate storage and merging of data in a factory environment without network connection, and improves data reliability and calculation accuracy.
Smart Images

Figure CN120296067A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data management, and particularly to a production test data statistics management method, system, computer device and storage medium. Background Art
[0002] In the prior art, due to the lack of accurate recording of the production test time of each device, the calculated production test time-consuming data of each device is inaccurate. Because during the opening of the production test tool, the tester cannot be completely testing the device, and may go to handle other things. Due to this statistical method, if the tester does not close the production test software and goes to handle other things after testing the first device, the time for handling other things in the middle will also be included in the statistics, resulting in inaccurate data. Since there is only a server database, it can only be used in factories with network access. Some factories in the market do not connect to the external network for confidentiality reasons. Therefore, it cannot be used in this scenario, and the applicable scenarios are single. Summary of the Invention
[0003] In a first aspect, the present application provides a production test data statistics management method, which is applied to a management end and includes:
[0004] Determine an import mode according to the operation instruction of the import operation;
[0005] If it is a local import, send a data import instruction to all test ends;
[0006] If it is a server import, send a data import instruction to the server;
[0007] Receive and store the device information, test start time and test end time from all test ends or the server;
[0008] According to the input time interval, calculate the production capacity data of each test end within the time interval.
[0009] Further, the calculating the production capacity data of each test end within the time interval according to the input time interval includes:
[0010] Obtain the test start time and test end time of all target devices tested within the time interval;
[0011] According to the test start time and the test end time, calculate the test duration of each target device, the working duration of the test end and the average test duration of each target device.
[0012] In a second aspect, the present application provides a production test data statistics management method, which is applied to a test end and includes:
[0013] When performing production testing on a target device, record the test start time of the target device, locally save the test start time, and send the device information of the target device and the test start time to the server;
[0014] When the test of the target device ends, record the test end time of the target device, locally save the test end time, and send the device information of the target device and the test end time to the server;
[0015] When receiving a data import instruction from the management terminal, send the test start time, test end time, and corresponding device information of all target devices saved locally to the management terminal.
[0016] Further, the method further includes:
[0017] When receiving a data merge instruction from the management terminal, parse the merge instruction and send the target device and the corresponding test start time, test end time, and device information in the merge instruction to the management terminal.
[0018] In a third aspect, the present application provides a production test data statistics management method, which is applied to a server and includes:
[0019] Receive and save the device information, test start time, and test end time sent by the test terminal;
[0020] When receiving a data import instruction from the management terminal, send the test start time, test end time, and device information of each target device to the management terminal.
[0021] Further, the method further includes:
[0022] When receiving a data merge request from the management terminal, receive the target device information from the management terminal and the corresponding test start time and test end time, and merge them with the incomplete test start time and test end time stored in the server database.
[0023] Further, when receiving a data import instruction from the management terminal, it further includes:
[0024] Determine whether the test start time and test end time of each target device in the server database are incomplete;
[0025] If incomplete, feedback a data incomplete signal to the management terminal.
[0026] In a fourth aspect, the present application further provides a production test data statistics management system, including: a test terminal, a server, and a management terminal;
[0027] When the test end performs production testing on the target device, record the test start time of the target device, locally save the test start time, and send the device information of the target device and the test start time to the server;
[0028] When the testing of the target device ends, record the test end time of the target device, locally save the test end time, and send the device information of the target device and the test end time to the server;
[0029] The server receives and saves the device information, test start time, and test end time sent by the test end;
[0030] The management end determines the import mode according to the operation instruction of the import operation. If it is a local import, it sends a data import instruction to all test ends. If it is a server import, it sends a data import instruction to the server;
[0031] When the server receives a data import instruction from the management end,
[0032] Send the test start time, test end time of each target device, and the device information of the target device to the management end;
[0033] When the test end receives a data import instruction from the management end, send the test start time, test end time of all target devices locally saved, and the corresponding device information to the management end;
[0034] The management end receives and stores the device information, test start time, and test end time from all test ends or the server; calculate the production capacity data of each test end within the input time interval.
[0035] In a fifth aspect, the present application provides a computer device, including a processor and a memory. The memory stores a computer program, and when the computer program runs on the processor, it executes the production test data statistics management method described above.
[0036] In a sixth aspect, the present application provides a readable storage medium, which stores a computer program, and when the computer program runs on a processor, it executes the production test data statistics management method described above.
[0037] The present invention discloses a method, system, computer device and storage medium for statistical management of production test data. The method includes: when performing production testing on a target device, recording the test start time of the target device, and sending the device information and test start time of the target device to a server; when the test of the target device ends, recording the test end time of the target device, and sending the device information and test end time of the target device to the server; when receiving a data import instruction from a management terminal, sending the test start time, test end time and corresponding device information of all target devices saved locally to the management terminal. This enables the calculated test time of a single target device from the recorded data, making the statistical time more accurate. BRIEF DESCRIPTION OF THE DRAWINGS
[0038] In order to more clearly illustrate the technical solutions of the present invention, the following will briefly introduce the drawings required for use in the embodiments. It should be understood that the following drawings only show some embodiments of the present invention, and therefore should not be regarded as limiting the protection scope of the present invention. In each drawing, similar components are numbered similarly.
[0039] Figure 1 FIG. shows the structural diagram of a production test data statistical management system according to an embodiment of the present application;
[0040] Figure 2 FIG. shows the schematic flow diagram of a production test data statistical management method according to an embodiment of the present application;
[0041] Figure 3 FIG. shows the schematic flow diagram of another production test data statistical management method according to an embodiment of the present application;
[0042] Figure 4 FIG. shows the schematic flow diagram of yet another production test data statistical management method according to an embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0043] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments.
[0044] Generally, the components of the embodiments of the present invention described and illustrated in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the drawings is not intended to limit the scope of the present invention claimed, but only represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts belong to the scope of protection of the present invention.
[0045] In the following text, the terms "comprising", "having" and their cognates that can be used in various embodiments of the present invention are only intended to represent specific features, numbers, steps, operations, elements, components or combinations of the foregoing items, and should not be construed as precluding the existence of one or more other features, numbers, steps, operations, elements, components or combinations of the foregoing items or as precluding the possibility of adding one or more features, numbers, steps, operations, elements, components or combinations of the foregoing items.
[0046] In addition, the terms "first", "second", "third", etc. are only used for distinguishing descriptions and should not be construed as indicating or implying relative importance.
[0047] Unless otherwise defined, all terms (including technical terms and scientific terms) used herein have the same meaning as commonly understood by those of ordinary skill in the art to which the various embodiments of the present invention belong. The terms (such as those defined in a commonly used dictionary) will be construed to have the same meaning as the contextual meaning in the relevant technical field and will not be construed to have an idealized meaning or an overly formal meaning unless clearly defined in the various embodiments of the present invention.
[0048] The technical solution of this application is applied to the statistical management of production test data. Particularly, in the scenario of mass device outfield tests in a factory, data such as the test time of each test device is statistically managed, and it is ensured that these data can be accurately recorded. When the test end of this application performs a production test operation on a target device, it records the test start time of the target device and sends the device information and the test start time of the target device to the server; when the test of the target device ends, it records the test end time of the target device and sends the device information and the test end time of the target device to the server.
[0049] Next, the technical solution of this application will be described with specific embodiments.
[0050] Embodiment 1
[0051] As Figure 1 shown, this application provides a production test data statistical management system, which includes: a test end 100, a server 200, and a management end 300;
[0052] Among them, the test terminal 100 refers to a computer device used for performing test operations, such as a computer dedicated to testing factory-produced products in a factory, etc. The server 200 is a server in the test environment, which can provide local area network services and data storage functions. In different working scenarios, the server 200 can be connected to the external network, while some cannot. The management terminal 300 is a device equipped with management software for managing devices in the entire test environment. The management terminal 300 can be located in the server 200 or exist independently as a device. For the convenience of description in this embodiment, the management terminal 300 is described as an independent device.
[0053] In this system, when the test terminal performs a production test operation on the target device, it records the test start time of the target device and sends the device information and test start time of the target device to the server.
[0054] When the test of the target device ends, it records the test end time of the target device and sends the device information and the test end time of the target device to the server.
[0055] For the test terminal, its main function is to perform test operations. The test start time and test end time are the times recorded when testing a single target device. By recording these two events, the test duration of the target device can be determined. Generally speaking, these data are all sent to the server.
[0056] The server receives and saves the device information, test start time, and test end time sent by the test terminal.
[0057] When the server receives these data, it will save them to the server database. Among them, since the test start time and test end time are uploaded at two different time points, there may be a situation where the start time is recorded but the end time is missing, or vice versa, there is an end time but the start time is missing. In this case, the server still saves the missing data and waits for the merge command from the management terminal to perform a merge operation and then complete these data.
[0058] The management terminal determines the import mode according to the operation instruction of the import operation. If it is a local import, it sends a data import instruction to all test terminals. If it is a server import, it sends a data import instruction to the server.
[0059] The management terminal is used to manage the test environment. In this embodiment, it mainly focuses on the management of statistical data, such as calculating statistics on data such as the working efficiency and working hours of each test device. However, these data are not stored in the management terminal but in the server or locally on the test terminal. Therefore, when statistical calculations are required, these data need to be imported into the management terminal. And there are import modes for data import, namely local import from the test terminal and server import from the server. Under different import modes, the data import instruction will be sent to the corresponding port device.
[0060] When the server receives a data import instruction from the management terminal, it determines whether the test start time and test end time of each target device in the server database are incomplete.
[0061] If incomplete, it feeds back a data incomplete signal to the management terminal.
[0062] If not incomplete, it sends the test start time, test end time of each target device, and the device information of the target device to the management terminal.
[0063] For the server, because there may be incomplete data, when receiving the corresponding data import instruction, it will judge whether the data is incomplete. Incomplete data will not be sent, while non-incomplete data can be sent.
[0064] When the test terminal receives a data import instruction from the management terminal, it sends the test start time, test end time of all target devices saved locally, and the corresponding device information to the management terminal.
[0065] The management terminal receives and stores the device information, test start time, and test end time from all test terminals or the server.
[0066] According to the input time interval, calculate the production capacity data of each test terminal within the time interval.
[0067] For the management terminal, when performing the final statistical calculation, it will not necessarily be a calculation for the entire time period, but a calculation within a certain time interval. This time interval is input by the operator, and the management terminal performs corresponding calculations according to the time interval input by the operator to obtain the statistical data of each test terminal.
[0068] The calculated statistical data can be the average test time of each device, the actual test time within this time interval, the test efficiency, etc.
[0069] Specifically, as Figure 2 shown, it is the production test data statistical management method executed by the test terminal, including:
[0070] Step S100, when performing production testing on the target device, record the test start time of the target device, and send the device information and test start time of the target device to the server;
[0071] The test terminal is mainly used to test the target device. Production testing operations are generally tests on products after production in the factory. Currently, it is basically automated testing, and the target device is tested through pre-written scripts. The target device is the product specifically produced by the factory. For example, network cameras, mobile phones, computers, etc. can all be target devices.
[0072] The production testing steps for the target device are basically starting the test and ending the test. The test results generated during the test are not the production testing data concerned in this embodiment. This embodiment mainly manages some performance data during production testing by the test terminal, such as the time to test one target device, or the time to test one hundred target devices, etc. Therefore, the accurate test time of each device is required. Therefore, when starting to test a target device in this embodiment, the start time of the test will be recorded, and this test start time and the device information will be sent to the server together.
[0073] The device information can be a unique identifier such as the mac code or serial number of the target device.
[0074] Among them, considering that the data sent to the server may fail to be sent, and the network may be disconnected in the factory due to certain business requirements, the above data will also be saved in the local database as a backup first.
[0075] Step S200, when the test of the target device ends, record the test end time of the target device, and send the device information and the test end time of the target device to the server.
[0076] Similar to the operation regarding the test start time in the previous step, after testing a target device is completed, the test end time and the device information of the device will be sent to the server together, and a backup will also be made locally.
[0077] Step S300, when receiving a data import instruction from the management terminal, send the test start time, test end time, and corresponding device information of all target devices saved locally to the management terminal.
[0078] The management terminal will send a data import instruction to the test terminal. At this time, the test terminal will send the test start time, test end time, and corresponding device information of all target devices saved locally to the management terminal.
[0079] In addition, the management terminal will also perform a data merging operation. That is, when the data in the server is incomplete, the management terminal will request the test terminal to merge data in order to complete the incomplete data in the server. At this time, the merge instruction will contain the required information.
[0080] It can be understood that one device information corresponds to a test start time and a test end time. Therefore, in the merge request, only the requested device information needs to be written, and the test terminal can send the corresponding test start time and test end time to the management terminal according to the entire device information for data merging operations.
[0081] As Figure 3 shown, the production test data statistics management method executed by the server includes:
[0082] Step S400: Receive and save the device information, test start time, and test end time sent by the test terminal.
[0083] The test terminal will send the test start time and test end time corresponding to the device information. After receiving the device information and test start time first, these two data will be associated and stored. Then, after receiving the same device information and test end time, the storage location corresponding to the device information will be found by searching for the device information, and then the test end time will be stored.
[0084] The storage form of this data is shown in the following table.
[0085]
[0086]
[0087] Step S500: When receiving a data import instruction from the management terminal, send the test start time, test end time of each target device, and the device information of the target device to the management terminal.
[0088] When receiving a data import instruction from the management terminal, it is necessary to send the test start time and test end time of each target device stored in the server database. The data import instruction will carry a time interval. That is, for the staff, they only want to obtain the statistical data within a certain period of time. At this time, they can limit the range of the obtained data by inputting the time interval. Similarly, they can also set the range of the test terminal to be obtained for further limitation. After the limitation, the test start time, test end time of these relevant target devices, and the device information of the target device can be sent to the management terminal.
[0089] However, as mentioned above, the data stored in the server may be incomplete. It can be understood that there will be a test duration interval between the test start time and the test end time. Therefore, even if the test start time is sent normally, there may still be a situation where the test end time fails to be sent, and vice versa. As a result, there may be a situation where one of these two data is missing. At this time, it can be determined that the data is incomplete.
[0090] When in an incomplete state, the server will not send the data it stores to the management terminal. Instead, it will feedback a data incomplete signal to the management terminal, informing the management terminal that the data it stores is missing within the requested time range. If it is not incomplete, it can be directly sent to the management terminal.
[0091] In addition, the server will also receive a data merging request from the management terminal. At this time, the server must be in a data incomplete state. The server will receive the data sent from the management terminal and then perform the merging. This merging operation is similar to the aforementioned storage operation, indexing by device information to store the missing test start time or test end time. After merging, the data stored in the server is complete and correct.
[0092] This embodiment provides two ways of saving statistical data, namely local saving on the test side and server saving. This ensures the complete preservation of statistical data whether there is a network or not. And when the network is connected, data merging can be performed to ensure that the correct data is saved in the server.
[0093] As Figure 4 shown, it is the production test data statistics management method executed by the management terminal.
[0094] Step S700, determine the import mode according to the operation instruction of the import operation. If it is a local import, send a data import instruction to all test terminals. If it is a server import, send a data import instruction to the server.
[0095] The management terminal is managed by staff. The management terminal provides staff with the function of importing data and performing statistical calculations. For example, there are local import and server import. Local import means directly obtaining the corresponding statistical data from the test terminal. When facing multiple test terminals in this import method, it needs to be imported multiple times. When performing server import, all the data stored on the server can be directly obtained without the need for multiple imports.
[0096] The import instruction will include the time range to be imported. At the same time, when interacting with the server, for security reasons, a key also needs to be entered to ensure the legality of data acquisition. In addition to entering the key, there can also be other security measures, which will not be specifically exemplified here.
[0097] Step S800: Receive and store the device information, test start time, and test end time from all test terminals or the server.
[0098] The management terminal will save the requested data locally for subsequent calculation and statistical operations.
[0099] Step S900: Calculate the production capacity data of each test terminal within the input time interval.
[0100] In an actual production test environment, there are multiple test terminals, and each test terminal tests multiple devices. The production capacity data calculated in this step refers to the test time of a single device and the total test time when a single test terminal is testing, etc.
[0101] For example, if a test terminal tests n devices, then for this test terminal, the calculation expression for the average test time of one device is: (the test end time of the first device - the test start time of the first device) +... + (the test end time of the nth device - the test start time of the nth device) / the number of devices in production test = the time taken to produce one.
[0102] The total time taken is the cumulative sum of the time taken for each device calculated above. It can be understood that in an actual production environment, when a test terminal finishes testing one device and switches to the next device, there is a time interval, and this time interval will also vary depending on the operator and the device. Therefore, in this embodiment, the accurate test duration of each device is calculated by the difference between the test end time and the test start time, so that the total duration actually used for testing by this test terminal can be calculated, rather than simply calculating based on the power-on and power-off time of the test terminal. This makes the calculated time more accurate and better reflects the work efficiency of a test terminal when working.
[0103] At the same time, because there are multiple test terminals, the above content needs to be calculated for each test terminal. For each test terminal, a thread can be started for calculation, so that the data of multiple test terminals can be calculated synchronously, greatly saving time.
[0104] Embodiment 2
[0105] This application also provides a computer device, including a processor and a memory. The memory stores a computer program, and when the computer program runs on the processor, it executes the production test data statistics management method described above.
[0106] This application also provides a readable storage medium, which stores a computer program, and when the computer program runs on a processor, it executes the production test data statistics management method described above.
[0107] In several embodiments provided in the present application, it should be understood that the disclosed devices and methods can also be implemented in other ways. The device embodiments described above are merely illustrative. For example, the flowcharts and structure diagrams in the accompanying drawings show the possible architectures, functions, and operations of devices, methods, and computer program products according to multiple embodiments of the present invention. In this regard, each block in the flowchart or block diagram can represent a module, a program segment, or a part of the code, and the module, program segment, or part of the code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in an alternative implementation, the functions marked in the blocks may occur in a different order from that marked in the accompanying drawings. For example, two consecutive blocks can actually be executed substantially in parallel, and they can sometimes be executed in the reverse order, depending on the functions involved. It should also be noted that each block in the structure diagram and / or flowchart, as well as the combination of blocks in the structure diagram and / or flowchart, can be implemented by a dedicated hardware-based system for performing the specified functions or actions, or can be implemented by a combination of dedicated hardware and computer instructions.
[0108] In addition, in each embodiment of the present invention, the various functional modules or units can be integrated together to form an independent part, or each module can exist separately, or two or more modules can be integrated to form an independent part.
[0109] If the above functions are implemented in the form of software functional modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a smart phone, a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in each embodiment of the present invention. The foregoing storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROMs), random access memories (RAMs), magnetic disks, or optical discs that can store program codes.
[0110] The above is only the specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any person skilled in the art within the technical scope disclosed by the present invention can easily think of changes or substitutions, which should all be covered by the protection scope of the present invention.
Claims
1. A method for statistical management of production test data, characterized in that Applied to the management side, including: Determine the import mode according to the operation instructions of the import operation; If it is a local import, send a data import instruction to all test sides; If it is a server import, send a data import instruction to the server; Receive and store the device information, test start time, and test end time from all test sides or the said server; According to the input time interval, calculate the production capacity data of each test side within the said time interval.
2. The production test data statistics management method according to claim 1, characterized in that The calculating the production capacity data of each test side within the said time interval according to the input time interval includes: Obtain the test start time and test end time of all target devices tested within the said time interval; According to the test start time and the test end time, calculate the test duration of each target device, the working duration of the test side, and the average test duration of each target device.
3. A production test data statistics and management method, characterized in that, Applied to the test side, including: When performing production testing operations on the target device, record the test start time of the target device, locally save the test start time, and send the device information of the target device and the test start time to the server; When the test of the target device ends, record the test end time of the target device, locally save the test end time, and send the device information of the target device and the test end time to the server; When receiving a data import instruction from the management side, send the test start time, test end time, and corresponding device information of all target devices locally saved to the management side.
4. The production test data statistics management method according to claim 3, characterized in that, Also includes: When receiving a data merge instruction from the management side, parse the merge instruction and send the target device requested in the merge instruction and the corresponding test start time, test end time, and device information to the management side.
5. A method for statistical management of production test data, characterized in that, Applied to the server, including: Receive and save the device information, test start time, and test end time sent by the test side; When receiving a data import instruction from the management side, send the test start time, test end time, and device information of each target device to the management side.
6. The production test data statistics management method according to claim 5, wherein Also includes: When receiving a data merge request from the management side, receive the target device information from the management side and the corresponding test start time and test end time, and merge them with the incomplete test start time and test end time stored in the server database.
7. The production test data statistical management method according to claim 6, characterized in that, The when receiving a data import instruction from the management side also includes: Determine whether the test start time and test end time of each target device in the server database are incomplete; If incomplete, feedback a data incomplete signal to the management side.
8. A production test data statistical management system, characterized in that, Includes: Test side, server, and management side; When the test side performs production testing operations on the target device, record the test start time of the target device, locally save the test start time, and send the device information of the target device and the test start time to the server; When the test of the target device is completed, record the test end time of the target device, locally save the test end time, and send the device information of the target device and the test end time to the server; The server receives and saves the device information, test start time and test end time sent by the test terminal; The management terminal determines the import mode according to the operation instruction of the import operation. If it is a local import, it sends a data import instruction to all test terminals. If it is a server import, it sends a data import instruction to the server; When the server receives a data import instruction from the management terminal, send the test start time, test end time of each target device and the device information of the target device to the management terminal; When the test terminal receives a data import instruction from the management terminal, send the test start time, test end time of all target devices saved locally and the corresponding device information to the management terminal; The management terminal receives and stores the device information, test start time and test end time from all test terminals or the server; calculates the production capacity data of each test terminal within the time interval according to the input time interval.
9. A computer device, characterized in that, It includes a processor and a memory. The memory stores a computer program. When the computer program runs on the processor, it executes the production test data statistics management method according to any one of claims 1 to 7.
10. A readable storage medium, characterized in that, It stores a computer program. When the computer program runs on the processor, it executes the production test data statistics management method according to any one of claims 1 to 7.