Logistics box task progress automatic generation method and device based on code scanner

Abstract

The invention discloses a logistics box task progress automatic generation method and device based on a code scanner, and relates to the technical field of the Internet of Things, and the method comprises the steps: storing the scanning record of a code scanner passed by a logistics box in a scanning record table, and the scanning record table comprises a task number, a box number, a code scanner number, scanning time, a sending place and a destination; according to the data in the scanning record table, generating an inevitable code scanner route map from a sending place to a destination through query and grouping operations; storing the route map in a route table, wherein the route table comprises a task number, a sending place, a destination and a sequence in which a code scanner must pass; monitoring a code scanner through which the logistics box passes in real time, matching the current code scanner with the data in the route table, and calculating the current task progress; and displaying the current task progress in a visual interface, and providing a real-time updating function of a progress bar.

Description

Technical Field

[0001] The present application relates to the technical field of the Internet of Things, and particularly to a method and device for automatically generating the task progress of a logistics box based on a barcode scanner. Background Art

[0002] In the field of logistics transportation, with the booming development of e-commerce, logistics efficiency and service quality have become key factors in enterprise competition. In order to improve the transparency and traceability of logistics transportation, a logistics tracking system has emerged. The logistics tracking system realizes the real-time tracking and monitoring of a logistics box during transportation by integrating technologies such as the Internet of Things, big data, and cloud computing. These systems not only provide the real-time location information of the logistics box but also can monitor the status of the logistics box, such as temperature, humidity, vibration, etc., to ensure the safe transportation of goods.

[0003] However, in practical applications, the logistics tracking system also faces many challenges. Especially during the transportation of a logistics box, due to various unforeseen factors (such as weather changes, traffic congestion, equipment failures, etc.), abnormal situations may occur to the logistics box, such as barcode scanner failures, damage to the logistics box, incorrect transportation routes, etc. If these abnormal situations are not handled in a timely manner, they may lead to delays in logistics transportation, loss or damage to goods, thus causing serious economic losses and reputational damage to enterprises. Summary of the Invention

[0004] The purpose of the present application is to provide a method and device for automatically generating the task progress of a logistics box based on a barcode scanner.

[0005] To achieve the above purpose, the present application provides the following solutions:

[0006] In a first aspect, the present application provides a method for automatically generating the task progress of a logistics box based on a barcode scanner, including:

[0007] Storing the scanning records of the barcode scanners passed by the logistics box in a scanning record table, where the scanning record table includes a task number, a box number, a barcode scanner number, a scanning time, a departure place, and a destination;

[0008] Generating a necessary barcode scanner route map from the departure place to the destination through querying and grouping operations based on the data in the scanning record table;

[0009] Storing the route map in a route table, where the route table includes a task number, a departure place, a destination, and the order of necessary barcode scanners;

[0010] Real-time monitoring of the barcode scanners passed by the logistics box, and matching the current barcode scanner with the data in the route table to calculate the current task progress;

[0011] Display the current task progress in the visualization interface and provide a real-time update function for the progress bar.

[0012] Optionally, the step of storing the scan records scanned by the barcode scanner passed by the logistics box in the scan record table includes:

[0013] Design the scan record table, and the fields of the scan record table include task number, box number, barcode scanner number, scan time, departure location, and destination.

[0014] When the logistics box passes by a barcode scanner, generate a scan record and store the scan record in the scan record table.

[0015] Optionally, the step of generating a necessary barcode scanner route map from the departure location to the destination through querying and grouping operations based on the data in the scan record table includes:

[0016] Query the scan record table through SQL and group the task number, box number, departure location, and destination.

[0017] Remove duplicate data and sort the data according to the scan time to generate the necessary barcode scanner order from the departure location to the destination.

[0018] Store the necessary barcode scanner order in the route table.

[0019] Optionally, the step of storing the route map in the route table includes:

[0020] Design the route table, and the fields of the route table include task number, departure location, destination, and the order of necessary barcode scanners.

[0021] Store the generated route map in the route table.

[0022] Optionally, the step of real-time monitoring the barcode scanner passed by the logistics box, matching the current barcode scanner with the data in the route table, and calculating the current task progress includes:

[0023] When the logistics box passes by a barcode scanner, obtain the number of the current barcode scanner.

[0024] Match the number of the current barcode scanner with the data in the route table to determine the order of the current barcode scanner in the route map.

[0025] Calculate the current task progress according to the order of the current barcode scanner and the total number of barcode scanners in the route map.

[0026] Optionally, the step of displaying the current task progress in the visualization interface and providing a real-time update function for the progress bar includes:

[0027] Display a progress bar of the current task progress in the visualization interface;

[0028] When the logistics box passes by a barcode scanner, update the display of the progress bar in real time;

[0029] Provide a function to click on the progress bar to display the detailed information of the roadmap.

[0030] Optionally, the method for automatically generating the logistics box task progress based on the barcode scanner further includes:

[0031] When an abnormal situation occurs during the transportation of the logistics box, send an alarm through the visualization interface and notify the technician to handle it.

[0032] In a second aspect, the present application provides a device for automatically generating the logistics box task progress based on the barcode scanner, including:

[0033] An acquisition module, configured to store the barcode scanner scan records passed by the logistics box in a scan record table, where the scan record table includes a task number, a box number, a barcode scanner number, a scan time, a departure location, and a destination;

[0034] A processing module, configured to generate a necessary barcode scanner roadmap from the departure location to the destination through query and grouping operations according to the data in the scan record table;

[0035] Store the roadmap in a route table, where the route table includes a task number, a departure location, a destination, and the order of necessary barcode scanners;

[0036] Monitor in real time the barcode scanners passed by the logistics box, match the current barcode scanner with the data in the route table, and calculate the current task progress;

[0037] A display module, configured to display the current task progress in the visualization interface and provide a real-time update function for the progress bar.

[0038] Optionally, the acquisition module is further configured to:

[0039] Design the scan record table, where the fields of the scan record table include a task number, a box number, a barcode scanner number, a scan time, a departure location, and a destination;

[0040] When the logistics box passes by a barcode scanner, generate a scan record and store the scan record in the scan record table.

[0041] Optionally, the processing module is further configured to:

[0042] Query the scan record table through SQL, and group the task number, box number, departure place, and destination;

[0043] Remove duplicate data, and sort the data according to the scan time to generate the necessary scanner order from the departure place to the destination;

[0044] Store the necessary scanner order in the route table.

[0045] Optionally, the processing module is further configured to:

[0046] Design the route table, and the fields of the route table include the task number, departure place, destination, and the order of the necessary scanners;

[0047] Store the generated route map in the route table.

[0048] Optionally, the processing module is further configured to:

[0049] When the logistics box passes through a scanner, obtain the number of the current scanner;

[0050] Match the number of the current scanner with the data in the route table to determine the order of the current scanner in the route map;

[0051] Calculate the current task progress according to the order of the current scanner and the total number of scanners in the route map.

[0052] Optionally, the display module is further configured to:

[0053] Display a progress bar of the current task progress in the visualization interface;

[0054] When the logistics box passes through a scanner, update the display of the progress bar in real time;

[0055] Provide a function to click on the progress bar to display the detailed information of the route map.

[0056] Optionally, the display module is further configured to:

[0057] When an abnormal situation occurs during the transportation of the logistics box, send an alarm through the visualization interface and notify the technical personnel to handle it.

[0058] In a third aspect, the present application provides a computer device, including: a memory, a processor, and a computer program stored on the memory and executable on the processor, and the processor executes the computer program to implement the steps of the method for automatically generating the logistics box task progress based on a scanner as described in any one of the above.

[0059] Fourthly, the present application provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the method for automatically generating the task progress of a logistics box based on a barcode scanner described in any one of the above are implemented.

[0060] Fifthly, the present application provides a computer program product, including a computer program. When the computer program is executed by a processor, the steps of the method for automatically generating the task progress of a logistics box based on a barcode scanner described in any one of the above are implemented.

[0061] According to the specific embodiments provided by the present application, the following technical effects are disclosed in the present application:

[0062] The present application provides a method and a device for automatically generating the task progress of a logistics box based on a barcode scanner. By scanning and recording the passing situation of the logistics box through the barcode scanner and storing this information in a scan record table, accurate basic data is provided for subsequent route planning and task progress monitoring. Then, based on the data in the scan record table, the system automatically generates a necessary barcode scanner route map from the place of departure to the destination, optimizing the transportation path and improving the logistics efficiency. Then, the system stores the route map in a route table for convenient query and management. During the real-time monitoring of the transportation process of the logistics box, the system can match the current barcode scanner with the data in the route table to accurately calculate the current task progress. Finally, the system displays the task progress in a visualization interface and provides a real-time update function for the progress bar, enabling users to intuitively and real-time understand the transportation situation of the logistics box. Description of the Drawings

[0063] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings required for use in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.

[0064] Figure 1 It is a schematic flowchart of a method for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0065] Figure 2 It is one of the schematic diagrams of the effect of a method for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0066] Figure 3 It is the second of the schematic diagrams of the effect of a method for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0067] Figure 4Schematic diagram III of the effects of a method for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0068] Figure 5 Schematic diagram IV of the effects of a method for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0069] Figure 6 Functional module schematic diagram of a device for automatically generating the task progress of a logistics box based on a barcode scanner provided by an embodiment of the present application;

[0070] Figure 7 Schematic diagram of the structure of a computer device provided by an embodiment of the present application. Detailed implementation manners

[0071] Next, the technical solutions in the embodiments of the present application will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present application without creative efforts shall fall within the protection scope of the present application.

[0072] As Figure 1 shown, some embodiments of the present application provide a method for automatically generating the task progress of a logistics box based on a barcode scanner. In the embodiments of the present application, the following steps 101 to 104 are included. Among them:

[0073] Step 101, store the scan records of the barcode scanners passed by the logistics box in a scan record table, where the scan record table includes a task number, a box number, a barcode scanner number, a scan time, a place of departure, and a destination.

[0074] In the embodiments of the present application, a logistics box is a container for storing and transporting items, usually having standardized dimensions and markings. A barcode scanner is a device capable of reading barcode or two-dimensional code information on a logistics box and is used to record the passing situation of the logistics box. The scan record table is a database table for storing relevant information when a barcode scanner scans a logistics box.

[0075] In a logistics system, when a logistics box passes by a barcode scanner, the barcode scanner reads the identification information (such as a barcode or a two-dimensional code) on the logistics box and records the relevant information of this scan (including a task number, a box number, a barcode scanner number, a scan time, a place of departure, and a destination) in the scan record table. Exemplarily, the scan record table can refer to Figure 2 . In this way, the system can track each passing point of the logistics box during transportation.

[0076] Step 102: According to the data in the scanning record table, generate a required scanner route map from the origin to the destination through query and grouping operations.

[0077] In the embodiment of the present application, the query and grouping operations are processes of retrieving data in a database according to specific conditions and grouping the retrieved data according to certain rules. The required scanner route map is a sequence diagram of the scanners that the logistics box must pass through on the transportation path from the origin to the destination. Exemplarily, the required scanner route map can refer to Figure 3 .

[0078] The system will retrieve all the scanning records related to a specific task number through the query operation according to the data in the scanning record table. Then, the system will perform a grouping operation on these records to determine the required scanner sequence from the origin to the destination according to the combination of the origin and the destination. Finally, the system will generate a required scanner route map, which shows the scanners that the logistics box must pass through and their sequence during the transportation process.

[0079] Step 103: Store the route map in a route table, where the route table includes the task number, the origin, the destination, and the sequence of required scanners.

[0080] In the embodiment of the present application, the route table: a database table for storing the sequence of required scanners from the origin to the destination and related information.

[0081] The system will store the generated required scanner route map in the route table. The route table contains information such as the task number, the origin, the destination, and the sequence of required scanners. In this way, the system can conveniently query and manage the transportation routes of different tasks.

[0082] Step 104: Real-time monitor the scanners passed by the logistics box, match the current scanner with the data in the route table, and calculate the current task progress.

[0083] In the embodiment of the present application, real-time monitoring is a process of real-time tracking and monitoring the situation of the logistics box passing through the scanner. Matching is to compare the information of the current scanner with the information in the route table to determine whether the logistics box is transported according to the predetermined route. The task progress is the completion situation of the logistics box during the transportation process, usually represented by the number or proportion of the scanners passed through.

[0084] The system will monitor the scanners passed by the logistics box in real time. Whenever the logistics box passes by a scanner, the system will match the information of the current scanner with the information in the route table. Through the matching, the system can determine whether the logistics box is transported along the predetermined route and calculate the progress of the current task. For example, if the route table contains 5 necessary scanners to pass by and the logistics box has passed by 3 of them, then the current task progress is 60%.

[0085] Step 105, display the current task progress in the visualization interface and provide a real-time update function for the progress bar.

[0086] In the embodiment of the present application, the visualization interface is a user interface that intuitively displays information through graphics, charts, etc. The progress bar is an element that graphically represents the task progress and is usually displayed in the form of a bar chart.

[0087] The system will display the progress of the current task in the visualization interface and provide a real-time update function for the progress bar. In this way, the user can intuitively see the transportation progress of the logistics box and how many scanners are left to pass by. The progress bar will be updated in real time as the logistics box passes by the scanner, ensuring that the user can obtain the latest transportation information.

[0088] Exemplarily, the form of displaying the current task progress in the visualization interface can refer to Figure 4 , and when the user clicks on the progress bar, it can be switched to Figure 5 the real-time display of the task progress in the form of a subway line map as described above.

[0089] In the embodiment of the present application, the passing situation of the logistics box is scanned and recorded by the scanner, and this information is stored in the scan record table, providing accurate basic data for subsequent route planning and task progress monitoring. Then, the system automatically generates a necessary scanner route map from the place of departure to the destination according to the data in the scan record table, optimizing the transportation path and improving the logistics efficiency. Then, the system stores the route map in the route table for convenient query and management. During the real-time monitoring of the transportation process of the logistics box, the system can match the current scanner with the data in the route table and accurately calculate the current task progress. Finally, the system displays the task progress in the visualization interface and provides a real-time update function for the progress bar, enabling the user to intuitively and real-time understand the transportation situation of the logistics box.

[0090] Optionally, step 101 includes:

[0091] Step 1011, design the scan record table, and the fields of the scan record table include task number, box number, scanner number, scan time, place of departure, and destination.

[0092] In the embodiments of the present application, the scan record table is a data structure designed in a database or memory, which is used to store the relevant information of the logistics box passing through each scanner during transportation. This information is the key data for generating the route map and calculating the task progress subsequently. This table consists of multiple fields, and each field carries specific information. For example, the task number is used to distinguish different logistics tasks, the box number is used to identify the specific logistics box, the scanner number is used to locate the specific scanning device that the logistics box passes through, the scanning time records the time point when the logistics box passes through the scanner, and the departure place and destination respectively identify the starting point and ending point of the logistics box.

[0093] In the process of system implementation, first, it is necessary to design the scan record table according to the business requirements. This step is usually completed by system developers or database administrators. They need to determine the structure and fields of the scan record table according to the specific requirements of the logistics system and the database design specifications. After determining the field names and data types, this table can be created in the database. After creation, the system can start using this table to store the scan records of the logistics boxes.

[0094] Step 1012, when a logistics box passes through a scanner, generate a scan record and store the scan record in the scan record table.

[0095] In the embodiments of the present application, when a logistics box passes through a scanner during transportation, the system needs to generate a scan record and store this record in the previously designed scan record table. This step is the basis for the logistics system to track the position of the logistics box in real time and generate a route map. A scanner is a device that can read the barcode or two-dimensional code information on the logistics box. When the logistics box passes by, the scanner will read the information and send it to the system.

[0096] In the process of system implementation, when a logistics box passes through a scanner, the scanner will read the barcode or two-dimensional code information on the logistics box and send this information to the system. After receiving this information, the system will generate a new scan record according to the information such as the task number and box number contained in the barcode or two-dimensional code. This record will include information such as the task number, box number, scanner number passed by, scanning time (i.e., the current time), departure place and destination of the current logistics box. Then, the system will store this newly generated scan record in the previously designed scan record table. In this way, the system can track the position of the logistics box in real time according to these scan records and generate the corresponding route map.

[0097] Optionally, step 102 includes:

[0098] Step 1021, query the scan record table through SQL and group the task number, box number, departure place and destination.

[0099] In the embodiment of the present application, SQL (Structured Query Language) is a programming language specifically used to communicate with a database. In this step, SQL is used to query the previously designed scan record table. The task number, box number, origin, and destination are key fields in the scan record table, which are used to identify different logistics tasks, logistics boxes, and their starting and ending positions. Through the SQL query, the system can group the records with the same task number, box number, origin, and destination, providing a data basis for subsequent steps.

[0100] During the system implementation process, when a route map from a certain origin to a certain destination needs to be generated, the system will first execute an SQL query statement. This query statement will specify the scan record table as the query object and select the task number, box number, origin, and destination as the grouping basis. The database will group the records in the scan record table according to the values of these fields. Each group represents a logistics task from a specific origin to a specific destination and contains the records of all logistics boxes passing through the scanner under this task.

[0101] Step 1022: Remove duplicate data and sort the data according to the scan time to generate the order of the necessary scanners from the origin to the destination.

[0102] In the embodiment of the present application, in the SQL query result, there may be multiple records with the same task number, box number, origin, and destination. These records may be generated because the logistics box passes through the same scanner multiple times during transportation. Therefore, before generating the route map, these duplicate data need to be removed. At the same time, in order to determine the order of the necessary scanners for the logistics box from the origin to the destination, the remaining data also needs to be sorted according to the scan time.

[0103] During the system implementation process, the operations of removing duplicate data and sorting are usually completed in the SQL query statement or after the query result is returned to the system. The system will first check the records within each group and remove those records with exactly the same task number, box number, and scanner number (note that here it is not simply to remove all records with the same fields, but allows different scan times), and only keep the earliest record (i.e., the record of the first pass through the scanner). Then, the system will sort the remaining records within each group according to the scan time field to ensure that the records are arranged in the order of the logistics box passing through the scanner. After sorting, the system can generate the order of the necessary scanners from the origin to the destination based on these records.

[0104] Step 1023: Store the order of the necessary scanners in the route table.

[0105] In the embodiments of the present application, the route table is a data structure designed in a database and is used to store the sequence of mandatory scanners from each origin to each destination. This table is the basis for the logistics system to generate and display the route map. Each record represents a specific logistics task route and contains information such as the task number, origin, destination, and the sequence of mandatory scanners.

[0106] During the system implementation process, after the sequence of mandatory scanners from a certain origin to a certain destination is generated, the system will store this information in the route table. This step is usually automatically completed by the system background program without manual intervention. The system will first check whether there is already a record in the route table with the same task number, origin, and destination. If it exists, the mandatory scanner sequence field of this record will be updated; if not, a new record will be created and information such as the task number, origin, destination, and the sequence of mandatory scanners will be filled into the corresponding fields. In this way, the system can generate and display the corresponding route map according to the data in the route table. At the same time, since the data in the route table is updated in real time, the system can also reflect the latest position and progress information of the logistics box in real time.

[0107] Optionally, step 103 includes:

[0108] Step 1031, design the route table, and the fields of the route table include the task number, origin, destination, and the sequence of mandatory scanners.

[0109] In the embodiments of the present application, the system needs to determine which fields the route table needs to contain according to the business requirements. In this example, the route table is designed to contain key fields such as the task number, origin, destination, and the sequence of mandatory scanners. The task number is used to uniquely identify a logistics task, and the origin and destination respectively represent the starting and ending positions of the logistics box. The sequence of mandatory scanners is a complex field that records the sequence of all scanners that the logistics box must pass through from the origin to the destination. This field is usually a string or an array that contains the numbers or identifiers of the scanners, and these numbers or identifiers are arranged in the order in which the logistics box passes through.

[0110] After designing the fields of the route table, the system needs to create this table and allocate storage space for it in the database. This process usually involves the use of a database management system, such as MySQL, Oracle, etc. The system will execute the corresponding SQL statements to create the route table according to the designed fields and table structure. After creation, the system can start storing the generated route map information in this table.

[0111] Step 1032, store the generated route map in the route table.

[0112] In the embodiment of the present application, the route map is a logical structure that represents all possible paths of the logistics box from the place of origin to the destination. This path is generated by analyzing the records of the logistics box passing through each scanner. In this step, the generated route map is stored in the route table so that the system can query and display it at any time. The process of storing the route map is actually to convert the information of the route map into records in the database for persistent storage and efficient query.

[0113] In the process of system implementation, generating the route map and storing it in the route table is a key step. First, the system needs to generate a route map from the place of origin to the destination through algorithm analysis based on the data in the scan record table. This route map is usually a graph structure containing multiple nodes and edges, where the nodes represent scanners or logistics sites, and the edges represent the movement paths of the logistics box between these nodes.

[0114] After generating the route map, the system needs to store it in the route table. This process involves converting the information of the route map into database records. Specifically, the system needs to traverse all nodes and edges in the route map, extract information such as task number, place of origin, destination, and the order of required scanners, and fill these information into the corresponding fields according to the design of the route table. Then, the system executes the corresponding SQL statement to insert these records into the route table.

[0115] After storage, the system can obtain the real-time location and progress information of the logistics box by querying the route table. This process usually involves executing an SQL query statement, filtering out the corresponding records according to conditions such as task number, place of origin, and destination, and extracting information such as the order of required scanners from them. Then, the system can generate and display the corresponding route map according to this information so that users can view the real-time location and progress of the logistics box at any time.

[0116] Optionally, step 104 includes:

[0117] Step 1041, when the logistics box passes through a scanner, obtain the number of the current scanner.

[0118] In the embodiment of the present application, during the logistics transportation process, the logistics box will pass through multiple scanners in sequence. Whenever the logistics box passes through a scanner, the scanner will read the information on the logistics box and send this information to the system. After receiving this information, the system will automatically extract the number of the current scanner. This number is the unique identifier of the scanner in the system and is used to distinguish different scanners. The process of obtaining the current scanner number is usually automatically completed without manual intervention.

[0119] Step 1042: Match the number of the current barcode scanner with the data in the route table to determine the order of the current barcode scanner in the route map.

[0120] In the embodiment of the present application, after obtaining the number of the current barcode scanner, the system needs to match it with the data in the route table. The route table stores all possible route information from the origin to the destination, including the order of barcode scanners in each route. The system traverses the data in the route table to find a record that matches the number of the current barcode scanner. Once a matching record is found, the system can determine the order of the current barcode scanner in the route map. This order information is crucial for subsequent calculation of the task progress.

[0121] Step 1043: Calculate the current task progress based on the order of the current barcode scanner and the total number of barcode scanners in the route map.

[0122] In the embodiment of the present application, after determining the order of the current barcode scanner in the route map, the system can start calculating the current task progress. First, the system needs to obtain the total number of barcode scanners in the route map, which represents the total number of barcode scanners to be passed through from the origin to the destination. Then, the system divides the order of the current barcode scanner by the total number of barcode scanners to obtain a ratio value between 0 and 1. This ratio value is the current task progress. To more intuitively display the task progress, the system usually converts this ratio value into a percentage form and displays it on the visualization interface. In this way, the user can view the real-time progress information of the logistics box at any time.

[0123] Optionally, step 105 includes:

[0124] Step 1051: Display a progress bar of the current task progress in the visualization interface.

[0125] In the embodiment of the present application, the visualization interface is a graphical interface for user-system interaction, which allows users to view and operate the data in the system in an intuitive way. The progress bar is a commonly used element in the visualization interface to represent the completion progress of a certain task. In this step, the system will display a progress bar of the current task progress in the visualization interface so that users can understand the transportation progress of the logistics box in real time.

[0126] In a logistics tracking system, the system generates a progress bar in the visualization interface based on the calculated current task progress. This progress bar is usually a long bar-shaped graphical element, and its length or filling degree is proportional to the task progress. The system adjusts the length or filling color of the progress bar according to the percentage value of the task progress to visually display the transportation progress of the logistics box. Users can quickly understand the current location and estimated arrival time of the logistics box by viewing the progress bar, thereby improving the efficiency and accuracy of logistics tracking.

[0127] Step 1052: When the logistics box passes by a barcode scanner, update the display of the progress bar in real time.

[0128] In the embodiment of the present application, real-time update means that the system can immediately reflect the change of data and display it in the visualization interface. In this step, when the logistics box passes by a barcode scanner, the system will update the display of the progress bar in real time to reflect the latest transportation progress of the logistics box.

[0129] During the logistics transportation process, whenever the logistics box passes by a barcode scanner, the system will receive the information sent by the barcode scanner and update the current task progress accordingly. The system will adjust the display of the progress bar in the visualization interface in real time according to the updated task progress. Specifically, the system will recalculate the percentage value of the task progress and adjust the length or filling color of the progress bar according to this value. In this way, users can view the latest transportation progress of the logistics box at any time without manually refreshing or querying the system.

[0130] Step 1053: Provide a function to click on the progress bar to display the detailed information of the route map.

[0131] In the embodiment of the present application, the click function refers to the function that users trigger specific operations by clicking on an element with the mouse in the visualization interface. The detailed information of the route map refers to the detailed path information of the logistics box from the departure place to the destination, including the barcode scanners passed by, transportation time, etc. In this step, the system provides a function to click on the progress bar to display the detailed information of the route map.

[0132] In the visualization interface, the system adds a click event listener to the progress bar. When the user clicks on the progress bar, the system will capture this click event and trigger the corresponding operation. Specifically, the system will generate the detailed information of the route map according to the current task progress and the data in the route table and display it in the visualization interface. This detailed information may include the numbers of all barcode scanners passed by the logistics box, transportation time, estimated arrival time, etc. Users can view this detailed information to more comprehensively understand the transportation situation and estimated arrival time of the logistics box. In this way, the system provides a more convenient and intuitive logistics tracking method, improving user satisfaction and usage experience.

[0133] Optionally, the method for automatically generating the task progress of the logistics box based on the barcode scanner further includes: when an abnormal situation occurs during the transportation of the logistics box, an alarm is issued through the visualization interface, and the technical personnel are notified to handle it.

[0134] In the embodiment of the present application, the abnormal situation refers to a situation that does not conform to the normal transportation process or may cause problems such as transportation delays and losses during the transportation of the logistics box. These situations may include, but are not limited to, barcode scanner failures, damage to the logistics box, incorrect transportation routes, etc. The visualization interface is a graphical operation interface provided by the system for displaying information such as the transportation status and progress of the logistics box and allowing users to interact with the system. During the logistics transportation process, the system continuously monitors the status and transportation progress of the logistics box. When the system detects an abnormal situation of the logistics box, it immediately triggers an abnormal handling mechanism. This mechanism is a series of preset operation processes in the system for coping with and handling various possible abnormal situations to ensure the smooth progress of the logistics transportation.

[0135] An alarm refers to a prompt or warning message sent by the system to the user through the visualization interface to inform the user that an abnormal situation has occurred in the logistics box and attention or corresponding measures need to be taken. This alarm is usually presented in the form of vision or audition, such as a pop-up window, a flashing icon, a sound prompt, etc. When the system detects an abnormal situation of the logistics box, it immediately issues an alarm through the visualization interface. The system generates an alarm message containing detailed contents such as abnormal information, logistics box number, and abnormal occurrence time and displays it in a prominent position on the visualization interface. At the same time, the system may issue a sound prompt to attract the user's attention. After seeing the alarm message, the user can immediately understand what problems have occurred in the logistics box and take corresponding measures to handle them.

[0136] While issuing the alarm, the system also automatically notifies the technical personnel to handle it. The system sends the abnormal information to the relevant technical personnel according to the preset notification methods (such as text messages, emails, system messages, etc.). This abnormal information usually includes contents such as the logistics box number, abnormal type, abnormal occurrence time, possible reasons, and recommended handling measures. After receiving the notification, the technical personnel can quickly understand the abnormal situation and take corresponding measures to handle it. They may view the transportation records of the logistics box, check the working status of the barcode scanner, adjust the transportation route, etc. to ensure the smooth progress of the logistics transportation.

[0137] Based on the same inventive concept, an embodiment of the present application further provides a device for automatically generating the task progress of a logistics box based on a barcode scanner for implementing the method for automatically generating the task progress of a logistics box based on a barcode scanner as described above. The implementation solution provided by this device for solving problems is similar to the implementation solution described in the above method. Therefore, the specific limitations in one or more embodiments of the device for automatically generating the task progress of a logistics box based on a barcode scanner provided below can refer to the limitations on the method for automatically generating the task progress of a logistics box based on a barcode scanner in the foregoing, and will not be repeated here.

[0138] In an exemplary embodiment, as Figure 6 shown, a device 20 for automatically generating the task progress of a logistics box based on a barcode scanner is provided, including:

[0139] An acquisition module 201, configured to store the scanning records scanned by the barcode scanners passed by the logistics box in a scanning record table, where the scanning record table includes a task number, a box number, a barcode scanner number, a scanning time, a place of departure, and a destination;

[0140] A processing module 202, configured to generate a necessary barcode scanner route map from the place of departure to the destination through querying and grouping operations according to the data in the scanning record table;

[0141] Store the route map in a route table, where the route table includes a task number, a place of departure, a destination, and the order of necessary barcode scanners;

[0142] Real-time monitor the barcode scanners passed by the logistics box, match the current barcode scanner with the data in the route table, and calculate the current task progress;

[0143] A display module 203, configured to display the current task progress in a visualization interface and provide a real-time update function for the progress bar.

[0144] Optionally, the acquisition module 201 is further configured to:

[0145] Design the scanning record table, where the fields of the scanning record table include a task number, a box number, a barcode scanner number, a scanning time, a place of departure, and a destination;

[0146] When the logistics box passes by a barcode scanner, generate a scanning record and store the scanning record in the scanning record table.

[0147] Optionally, the processing module 202 is further configured to:

[0148] Query the scanning record table through SQL, and group the task number, the box number, the place of departure, and the destination;

[0149] Remove duplicate data, sort the data according to the scanning time, and generate the order of mandatory scanners from the place of dispatch to the destination;

[0150] Store the order of mandatory scanners in the route table.

[0151] Optionally, the processing module 202 is further configured to:

[0152] Design the route table, where the fields of the route table include task number, place of dispatch, destination, and the order of mandatory scanners;

[0153] Store the generated route map in the route table.

[0154] Optionally, the processing module 202 is further configured to:

[0155] When the logistics box passes through a scanner, obtain the number of the current scanner;

[0156] Match the number of the current scanner with the data in the route table to determine the order of the current scanner in the route map;

[0157] Calculate the current task progress according to the order of the current scanner and the total number of scanners in the route map.

[0158] Optionally, the display module 203 is further configured to:

[0159] Display a progress bar of the current task progress in the visualization interface;

[0160] When the logistics box passes through a scanner, update the display of the progress bar in real time;

[0161] Provide a function to click on the progress bar to display the detailed information of the route map.

[0162] Optionally, the display module 203 is further configured to:

[0163] When an abnormal situation occurs during the transportation of the logistics box, send an alarm through the visualization interface and notify the technical personnel for handling.

[0164] In the embodiments of the present application, the passing conditions of the logistics boxes are scanned and recorded by a barcode scanner, and this information is stored in a scanning record table, providing accurate basic data for subsequent route planning and task progress monitoring. Then, based on the data in the scanning record table, the system automatically generates a necessary barcode scanner route map from the place of departure to the destination, optimizing the transportation route and improving logistics efficiency. Subsequently, the system stores the route map in a route table for convenient query and management. During the real-time monitoring of the transportation process of the logistics boxes, the system can match the current barcode scanner with the data in the route table to accurately calculate the current task progress. Finally, the system displays the task progress in a visual interface and provides a real-time update function for the progress bar, enabling users to intuitively and real-time understand the transportation situation of the logistics boxes.

[0165] In an exemplary embodiment, a computer device is provided. This computer device can be a server or a terminal, and its internal structure diagram can be as Figure 7 shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, abbreviated as I / O), and a communication interface. Among them, the processor, the memory, and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data automatically generated based on the task progress of the logistics boxes by the barcode scanner. The input / output interface of the computer device is used for the exchange of information between the processor and external devices. The communication interface of the computer device is used to communicate with external terminals through a network connection. When the computer program is executed by the processor, it implements a method for automatically generating the task progress of logistics boxes based on barcode scanners.

[0166] Those skilled in the art can understand that Figure 7 the structure shown in

[0167] is only a block diagram of some structures related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine some components, or have different component arrangements.

[0168] In an exemplary embodiment, a computer-readable storage medium is provided, storing a computer program, which when executed by a processor, implements the steps in the above method embodiments.

[0169] In an exemplary embodiment, a computer program product is provided, including a computer program, which when executed by a processor, implements the steps in the above method embodiments.

[0170] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use, and processing of relevant data need to comply with relevant regulations.

[0171] Those of ordinary skill in the art can understand that all or part of the processes in the above method embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the above method embodiments. Among them, any reference to a memory, database, or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memories. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc.

[0172] In each of the embodiments provided in the present application, the database involved may include at least one of a relational database and a non-relational database. The non-relational database may include a distributed database based on a blockchain, etc., without limitation. In each of the embodiments provided in the present application, the processor may be a general-purpose processor, a central processing unit, a graphics processing unit, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., without limitation.

[0173] The technical features of the above embodiments can be combined arbitrarily. For the sake of brevity of description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as the scope described in this specification.

[0174] Specific examples are used in this article to elaborate on the principles and implementation manners of the present application. The description of the above embodiments is only used to help understand the method and its core idea of the present application; at the same time, for those of ordinary skill in the art, according to the idea of the present application, there will be changes in the specific implementation manners and application scopes. In summary, the content of this specification should not be construed as a limitation to the present application.

Claims

1. An automatic generation method for the task progress of a logistics box based on a barcode scanner, characterized in that, The method for automatically generating the task progress of a logistics box based on a barcode scanner includes: Storing the scanning records of the barcode scanners passed by the logistics box in a scanning record table, where the scanning record table includes a task number, a box number, a barcode scanner number, a scanning time, a departure location, and a destination; Generating a necessary barcode scanner route map from the departure location to the destination through querying and grouping operations based on the data in the scanning record table; Storing the route map in a route table, where the route table includes a task number, a departure location, a destination, and the order of necessary barcode scanners; Real-time monitoring of the barcode scanners passed by the logistics box, and matching the current barcode scanner with the data in the route table to calculate the current task progress; Displaying the current task progress in a visualization interface and providing a real-time update function for the progress bar.

2. The method for automatically generating the task progress of a logistics box based on a barcode scanner according to claim 1, wherein The step of storing the scanning records of the barcode scanners passed by the logistics box in the scanning record table includes: Designing the scanning record table, where the fields of the scanning record table include a task number, a box number, a barcode scanner number, a scanning time, a departure location, and a destination; When the logistics box passes by a barcode scanner, generating a scanning record and storing the scanning record in the scanning record table.

3. The method for automatically generating the task progress of a logistics box based on a barcode scanner according to claim 1, characterized in that, The step of generating a necessary barcode scanner route map from the departure location to the destination through querying and grouping operations based on the data in the scanning record table includes: Querying the scanning record table through SQL, and grouping the task number, the box number, the departure location, and the destination; Removing duplicate data and sorting the data according to the scanning time to generate the order of necessary barcode scanners from the departure location to the destination; Storing the order of necessary barcode scanners in the route table.

4. The method for automatically generating the task progress of a logistics box based on a barcode scanner according to claim 1, characterized in that, The step of storing the route map in the route table includes: Designing the route table, where the fields of the route table include a task number, a departure location, a destination, and the order of necessary barcode scanners; Storing the generated route map in the route table.

5. The method for automatically generating the task progress of a logistics box based on a barcode scanner according to claim 1, characterized in that, The step of real-time monitoring of the barcode scanners passed by the logistics box, and matching the current barcode scanner with the data in the route table to calculate the current task progress includes: When the logistics box passes by a barcode scanner, obtaining the number of the current barcode scanner; Matching the number of the current barcode scanner with the data in the route table to determine the order of the current barcode scanner in the route map; Calculating the current task progress according to the order of the current barcode scanner and the total number of barcode scanners in the route map.

6. The method for automatically generating the task progress of a logistics box based on a barcode scanner according to claim 1, characterized in that The step of displaying the current task progress in a visualization interface and providing a real-time update function for the progress bar includes: Displaying a progress bar of the current task progress in the visualization interface; When the logistics box passes by a barcode scanner, real-time updating the display of the progress bar; Providing a function to click on the progress bar to display the detailed information of the route map.

7. The method for automatically generating the task progress of the logistics box based on the barcode scanner according to claim 1, characterized in that The method for automatically generating the task progress of a logistics box based on a barcode scanner further includes: When an abnormal situation occurs during the transportation of the logistics box, sending an alarm through the visualization interface and notifying the technical personnel to handle it.

8. An automatic generation device for the task progress of a logistics box based on a barcode scanner, characterized in that, The device for automatically generating the task progress of a logistics box based on a barcode scanner includes: An acquisition module, configured to store the scanning records scanned by a barcode scanner passed by a logistics box in a scanning record table, where the scanning record table includes a task number, a box number, a barcode scanner number, a scanning time, a departure location, and a destination; A processing module, configured to generate a required barcode scanner route map from the departure location to the destination through querying and grouping operations according to the data in the scanning record table; Store the route map in a route table, where the route table includes a task number, a departure location, a destination, and the order of required barcode scanners; Monitor in real time the barcode scanners passed by the logistics box, match the current barcode scanner with the data in the route table, and calculate the current task progress; A display module, configured to display the current task progress in a visualization interface and provide a real-time update function for the progress bar.

9. A computer device, comprising: A memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the method for automatically generating the logistics box task progress based on a barcode scanner according to any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the method for automatically generating the logistics box task progress based on a barcode scanner according to any one of claims 1-7.

Images