Part statistics method, apparatus, electronic device, and storage medium based on workstation location

Abstract

A material statistics method, apparatus, electronic device, and storage medium based on workstation location are disclosed. The method includes acquiring production scheduling information for multiple target work orders, the production scheduling information including scheduling identification information and work order identification; obtaining work order status information corresponding to each target work order based on the work order identification, the work order status information including work order production status and batch identification; determining the batch production status of at least one batch sequence based on the batch identification, work order production status, and scheduling identification information of each target work order; obtaining target material information for at least one target sequence based on a preset material type; performing workstation location-based material shortage classification statistics on the at least one target material information; and obtaining material preparation progress information for at least one target sequence. The target sequence represents a batch sequence whose batch production status is either in production or waiting for production. This invention can instantly grasp the overall material preparation progress, reducing the number of times production supervisors need to provide feedback and inquiries about material preparation progress.

Claims

1. A material statistics method based on workstation location, the method comprising the following steps: acquiring production scheduling information of multiple target work orders, the production scheduling information including scheduling identification information and work order identification; obtaining work order status information corresponding to each target work order based on the work order identification, the work order status information including work order production status and batch identification; determining the batch production status of at least one batch sequence based on the batch identification, work order production status, and scheduling identification information of each target work order; obtaining target material information of at least one target sequence based on a preset material type, performing workstation location material shortage classification statistics on the at least one target material information to obtain material preparation progress information of the at least one target sequence, the target sequence being used to represent a batch sequence whose batch production status is either in production or waiting for production; and obtaining the estimated changeover time of the at least one target sequence. The material preparation urgency of the at least one target sequence is determined based on at least one estimated line changeover time and at least one material preparation progress information; and a material preparation warning is issued for the at least one target sequence based on the ranking of at least one material preparation urgency, or the comparison results of at least one material preparation urgency with multiple preset urgency thresholds, so as to adjust the priority of material preparation tasks.

2. The material statistics method based on workstation location as described in claim 1, wherein determining the batch production status of at least one batch sequence based on the batch identification, production status, and scheduling identification information of each target work order, further comprises the following steps: If the production status of at least one work order corresponding to the batch identification is in production, then the initial production status of all target work orders corresponding to the batch identification is determined to be in production; If the production status of all work orders corresponding to the batch identification is offline, then the initial production status of all target work orders corresponding to the batch identification is determined to be offline; If the initial production status corresponding to the batch identification is not offline and there is no corresponding initial production status in production, then the initial production status of all target work orders corresponding to the batch identification is determined to be waiting for production; and based on each scheduling identification information, the initial production status of the same type of batch identification is deduplicated to obtain the batch production status of at least one batch sequence.

3. The material statistics method based on workstation location as described in claim 1, wherein the determination of the material preparation urgency is as follows: the material shortage urgency coefficient and the time urgency coefficient are used to determine the material preparation urgency; or the material preparation urgency is determined according to a preset first weight, a material shortage urgency coefficient, a preset second weight, and a time urgency coefficient; wherein, The material shortage urgency coefficient is obtained based on the reciprocal of the material preparation achievement rate, the material shortage rate, or the number of material shortages. The time urgency coefficient is obtained based on the reciprocal of the expected line changeover time. The material preparation achievement rate, the material shortage rate, and the number of material shortages are obtained based on the material preparation progress information.

4. The material statistics method based on workstation location as described in claim 1, wherein the target material dispensing information is classified and statistically analyzed for material shortage at workstation locations to obtain material preparation progress information, further comprising: if a bonding workstation location is a front workstation location on a printed circuit board, and the material dispensing status of the bonding workstation location is picking, then the number of first material shortage workstation locations is increased; if the bonding workstation location is a back workstation location on a printed circuit board, and the material dispensing status of the bonding workstation location is picking, then the number of second material shortage workstation locations is increased; and the material preparation achievement rate of the target sequence is determined based on the number of first material shortage workstation locations, the number of second material shortage workstation locations, the total number of first workstation locations on the front workstation location, and the total number of second workstation locations on the back workstation location; wherein... The target material preparation information includes the type and preparation status of multiple bonding workstations, as well as the total number of bonding workstations of different types. The total number of bonding workstations includes the total number of the first workstations and the total number of the second workstations. The material preparation progress information includes the material preparation achievement rate, the total number of bonding workstations of different types, and the number of bonding workstations lacking material. The number of bonding workstations lacking material includes the number of the first and second material-deficient workstations. The material preparation achievement rate includes the overall achievement rate of the target sequence and / or the achievement rate of the workstations of different types.

5. The material statistics method based on workstation location as described in any one of requests 1 to 4, wherein after obtaining the material preparation progress information of the at least one target sequence, it further includes: if the batch production status of the batch sequence is a waiting production status, then obtaining the off-site material preparation status information according to the work order identity identification corresponding to the batch sequence, and determining the off-site material preparation progress information of the batch sequence according to the off-site material preparation status information.

6. The material statistics method based on workstation location as described in claim 5, wherein after obtaining the material preparation progress information of the at least one target sequence, it further includes: if the batch production status of the target sequence is in production, then displaying the scheduling identification information, batch identification, estimated changeover time, and material preparation progress information corresponding to the target sequence; if the batch production status of the target sequence is in waiting production, then displaying the scheduling identification information, batch identification, estimated changeover time, material preparation progress information, and off-site material preparation progress information corresponding to the target sequence; and if there is a material preparation warning for the target sequence, then displaying a warning for the target sequence; wherein, The scheduling identification information includes the scheduling time information, production line information, and production line identification information of the target sequence.

7. A material statistics device based on workstation location, the device comprising: an information acquisition module for acquiring production scheduling information of multiple target work orders, the production scheduling information including scheduling identification information and work order identification; an information retrieval module for acquiring work order status information corresponding to each target work order based on the work order identification, the work order status information including work order production status and batch identification; and a status determination module for determining the batch production status of at least one batch sequence based on the batch identification, work order production status, and scheduling identification information of each target work order. The material shortage statistics module is used to obtain target material information for at least one target sequence based on preset material types, perform workstation location material shortage classification statistics on the at least one target material information, obtain material preparation progress information for the at least one target sequence, where the target sequence represents the batch production status as either in production or waiting for production, obtain the estimated changeover time for the at least one target sequence, determine the material preparation urgency of the at least one target sequence based on the estimated changeover time and the material preparation progress information, and issue a material preparation warning for the at least one target sequence based on the ranking of the at least one material preparation urgency, or the comparison results of the at least one material preparation urgency with multiple preset urgency thresholds, so as to adjust the priority of material preparation tasks.

8. An electronic device comprising: one or more processors; and a storage device for storing one or more programs that, when executed by the one or more processors, cause the electronic device to implement the workstation location-based material statistics method as described in any one of claims 1 to 6.

9. A computer-readable storage medium having a computer program stored thereon, which, when executed by a computer's processor, causes the computer to perform any one of claims 1 to 6, a material statistics method based on workstation location.

Images