A data-penetration-based cargo area management system and cargo area management method

Abstract

The application discloses a kind of based on data perspective's cargo area management system and cargo area management method, by database server, application server and user terminal composition, database server is used to store cargo area relevant parameter and business data;Application server is used to listen to the data of database server storage and update each state of cargo area and business situation, to the page data generated by pre-set template is carried out real-time update, also be used to respond to the request of user terminal, according to the input condition of user terminal, corresponding result data is generated and output to user terminal display to user;User terminal shows cargo area situation and receives the operation of user request.The application carries out comprehensive management and control from information display, goods location positioning operation, key business operation, has the advantages such as convenient and intuitive understanding the storage and layout of shelf, quickly carrying out operation in warehouse area and displaying to page in the form of graphics by data perspective.

Description

Technical Field

[0001] The present invention relates to a cargo area management system and a cargo area management method based on data perspective, belonging to the field of logistics management technology, in particular to the field of tobacco logistics management technology. Background Art

[0002] The main features of existing online cargo area management methods include: using traditional forms for functional operations and information display, requiring multiple queries and switching back and forth between business documents between different business needs during operation, and mainly focusing on single objects such as cargo locations and materials in the data display dimension.

[0003] Current online cargo area management methods have the following shortcomings:

[0004] (1) The business display dimension is relatively single and cannot intuitively display multi-dimensional information. For example: key object attribute information (production line, team, plan, etc.), business dimension information (spot inspection, delivery, adjustment, etc.), management control dimension information (locking, freezing, solidification status of cargo space, etc.);

[0005] (2) The operation mode is relatively traditional. Some businesses need to switch back and forth between different pages, which makes it impossible to centrally and efficiently process data.

[0006] (3) Some quick operation functions are missing. For example, it is not possible to quickly locate the cargo location, it is not possible to select the cargo location by custom, it is not possible to filter by custom conditions, and it is not possible to quickly convert business (sampling business requires going to the specific sampling document page to re-query and perform other operations before generating the sampling document). Summary of the Invention

[0007] To solve the above problems, the present invention provides a cargo area management system and method based on data perspective.

[0008] The present invention comprehensively manages and controls the entire cargo area from the perspectives of cargo area information display, cargo location positioning, and key business operations. The cargo area information is displayed from the perspectives of cargo area layout, cargo area storage, and business management and control.

[0009] in:

[0010] The cargo area layout dimension shows the distribution of the cargo area from a side view of the entire cargo area, and flatly expresses the relative position relationship between the equipment, shelves, and cargo locations in the entire cargo area. It can intuitively display information such as the rows, layers, columns, and cargo location numbers of the shelves;

[0011] The cargo area storage dimension takes the attributes of the cargo storage object as the starting point, and comprehensively displays the storage status of the cargo location (empty tray, full tray, solidified, empty cargo location, etc.) and the attribute information of the material;

[0012] The business management control dimension intuitively displays the status of a management dimension of the cargo location, such as normal, locked, and frozen status.

[0013] According to a first aspect, the present invention provides a cargo area management system based on data perspective, comprising a database server, an application server, and a user terminal. The database server is used to store cargo area model parameters, cargo area storage parameters, material parameters, and business data from the production process. The application server is used to monitor the data stored in the database server in real time, and update the cargo area status and business status in real time based on the monitored data, and to update the page data generated by a preset template in real time. The application server is also used to respond to requests from the user terminal and, based on the user terminal's input conditions, generate corresponding result data and output it to the user terminal for display to the user. The page data provides information on the relative position of the cargo area, storage information on the cargo location, and status of the cargo location. The user terminal is used to display the page data generated by the application server to show the real-time status of the entire cargo area and to receive user-requested operations. The application server includes a basic business module and a data perspective module. The basic business module is a unit that processes business data, and the data perspective module analyzes, adds value to, and organizes the data processed by the basic business module.

[0014] The cargo area management system based on data perspective provided by the present invention uses the cargo area planning page to display the cargo area business in perspective, wherein the cargo area planning page mainly displays the following objects: button control area, cargo area, cargo location partition, cargo location group 2, main cargo location, secondary cargo location, business expression area, and information display area.

[0015] The basic business information displayed on the user terminal by the cargo area management system based on data perspective provided by the present invention mainly includes the following dimensions:

[0016] The business information that can be displayed on the entire user terminal mainly includes the following:

[0017] (1) Cargo location: All cargo locations in the cargo area are displayed in a graphically visualized manner on the user terminal.

[0018] (2) Cargo location group: Each cargo location group includes two cargo locations, and the cargo location group information can be displayed in a graphically visualized manner on the page of the user terminal.

[0019] (3) Storage location status: The storage location status is displayed from two sub-dimensions. The first sub-dimension is used to indicate the status of the materials stored in the current storage location, and the second sub-dimension is used to indicate the management and control status of the current storage location.

[0020] (3) Extended business information: Displays other relevant information of the inventory materials on the shelf. The other relevant information of the materials includes but is not limited to the material code, name, specification, plan, production line, machine, team, batch, production time, and resource definition.

[0021] According to a second aspect, a cargo area management method based on data perspective of the present invention comprises the following steps:

[0022] Step 1: When the present invention is started, it will obtain the source data required for data perspective from the database server in real time, including storage location files, current inventory, storage location control status, production information and other information.

[0023] Step 2: After the source data is acquired, the corresponding data perspective model rules are obtained according to the storage location group pattern. The source data is integrated and processed in the application server according to this rule to obtain storage location perspective data. The data includes storage area model parameters, storage location management control status, on-hand quantity information, basic inventory information and production information, etc.

[0024] Step 3: In the application server, the data pivot module reads the pivot data and dynamically generates a location display model composed of HTML elements based on the location group (stacker double-fork operation unit, source location file). The model uses multi-dimensional elements such as div, img, a, checkbox, etc. combined with style control to display the storage information and management control status of the location group.

[0025] In step 4, the data pivot module of the application server traverses the pivot data, combines the cargo area to obtain the layout rules of the shelf cargo location, and processes the cargo location group units processed in step 3 according to the layout rules in the data pivot module of the application server. Finally, the storage status of all data pivoted cargo locations is graphically displayed on the user terminal.

[0026] In step 5, after the user selects the cargo location information to be processed through the interface of the user terminal (quick selection can be made through positioning, full / inverse selection, and location group selection), the user can quickly perform business operations in the warehouse area (such as freezing / unfreezing inventory, sampling, adjustment, and delivery). After the data pivot module in the application server traverses the interface selection results, it is converted into corresponding cargo location information. After processing the data, it is converted into business data. After being transferred to the application server for processing, the user terminal jumps to the specific business interface for subsequent operations.

[0027] Beneficial effects of the present invention

[0028] (1) Traditional inventory displays use a tabular format, which is not very concrete. This invention uses a data perspective method to display information through a graphical interface, allowing users to intuitively understand the storage and layout of shelves.

[0029] (2) Traditional inventory interface information is too single, and multi-dimensional information needs to be inquired through multiple pages. The application integrates multi-dimensional data related to the goods area and the storage location, and displays the data in a graphical form through data visualization on a page. The layout of different dimensional data visualization is clear and intuitive, and the function area is divided regularly, which helps users quickly understand multi-dimensional information (material, production time, production line, freezing, availability, locking, etc.) of the goods area and the storage location.

[0030] (3) The traditional system business operation needs to enter a special page for input maintenance and the like to be executed. The application supports quick business operation functions (sampling inspection, freezing, etc.) in the goods area, supports users to quickly locate and operate inventory information, and performs different business operations on the same interface, instead of the traditional opening interface and input function, so that users can more intuitively and quickly perform system business processing. BRIEF DESCRIPTION OF DRAWINGS

[0031] Figure 1 is a system structure diagram.

[0032] Figure 2 is a layout schematic diagram of a goods area planning page of the system.

[0033] Figure 3 is a goods area management process based on data visualization. DETAILED DESCRIPTION

[0034] A goods area management system based on data visualization, as shown in Figure 1 , comprises a database server, an application server, and a user terminal.

[0035] The database server is used to store model parameters of the goods area, storage condition parameters of the goods area, material parameters, and business data in the production process.

[0036] The application server is used to listen to the stored data of the database server in real time, and update the states and business conditions of the goods area in real time according to the listened data, and update the page data generated through a preset template in real time. The application server is also used to respond to the request of the user terminal, generate corresponding result data according to the input condition of the user terminal, and output the result data to the user terminal to display for the user. The page data provides relative position information of the goods area, storage information of the storage location, and state information of the storage location.

[0037] The user terminal is used to display the page data generated by the application server to display the real-time condition of the entire goods area, and receive the operation requested by the user. The application server comprises a basic business module and a data visualization module. The basic business module is a unit for processing business data, and the data visualization module analyzes, values, and organizes the data processed by the basic business module.

[0038] The cargo area management system based on data perspective provided by the present invention uses the cargo area planning page 1 to display the cargo area business in perspective, wherein the cargo area planning page 1 mainly displays the following objects: button control area 2, cargo area 3, cargo location partition 3.1, cargo location group 3.2, main cargo location 3.2.1, secondary cargo location 3.2.2, business expression area 3.2.3, information display area 4, such as Figure 2 As shown, the following is a detailed description;

[0039] (1) Cargo area planning page 1, used to present the relative location information of the cargo area, business information in the production process and operable functions, and also used to interact with the user and receive user input instructions;

[0040] (2) Button control area 2, used to receive user operation instructions to control the system to perform corresponding business operations;

[0041] (3) Cargo area 3, used to present the relative layout information of the cargo area and display business information related to the cargo area, including:

[0042] Cargo area partition 3.1 is used to express the division of areas based on the cargo area to facilitate further and more refined management;

[0043] The cargo location group 3.2 is used to represent the unit of a stacker crane operation. It consists of two cargo locations: the main cargo location and the secondary cargo location. The main cargo location 3.2.1 is used to represent the cargo location where the stacker crane's main fork operates. The secondary cargo location 3.2.2 is used to represent the cargo location where the stacker crane's secondary fork operates.

[0044] (4) Business expression area 3.3 is used to display some business information of the cargo location, such as cargo location storage status, cargo location management status, etc.

[0045] (5) Information display area 4, used to display the binding relationship between the platform or production line and the partition.

[0046] The basic business information displayed on the user terminal by the cargo area management system based on data perspective provided by the present invention mainly includes the following dimensions:

[0047] As shown in the composition structure of the cargo area planning page 1 described above, its main features are that the business information that can be displayed on the entire user terminal mainly includes the following:

[0048] (1) Cargo location: All cargo locations in the cargo area are displayed in a graphically visualized manner on the user terminal.

[0049] (2) Cargo location group: Each cargo location group includes two cargo locations, and the cargo location group information can be displayed in a graphically visualized manner on the page of the user terminal.

[0050] (3) Storage location status: The storage location status is displayed from two sub-dimensions. The first sub-dimension is used to indicate the status of the materials stored in the current storage location, and the second sub-dimension is used to indicate the management and control status of the current storage location. The storage material status of the first sub-dimension includes at least full tray (i.e., materials are stored on the tray of the current storage location), empty tray (there is no material on the tray of the current storage location), and empty storage location (there is no tray on the current storage location). The storage location management and control status of the second sub-dimension includes at least locked (where locked is divided into issued lock and planned lock), frozen (e.g., if there is a problem with the stored material, the current storage location can be frozen for subsequent processing), and solidified (representing that the filter rod is in the process of solidification. Solidification is a process requirement for filter rods. The produced filter rods need a certain amount of time to solidify before they can be used).

[0051] For example, the storage locations of the storage location group can be displayed with different colors or icons to indicate the storage status of different storage locations. When a storage location at the managed site is operated by a stacker to remove or receive materials, the storage location status information stored in database server 1 will change. Application server 2 will then perform corresponding analysis and calculations based on the updated information in the database server and update the corresponding storage location color or icon displayed on the user terminal. Preferably, a predefined display indicator can be added to the storage location displayed on the page to indicate the current storage location management and control status.

[0052] (3) Extended business information: Displays other relevant information of the inventory materials on the shelf. The other relevant information of the materials includes but is not limited to the material code, name, specification, plan, production line, machine, team, batch, production time, and resource definition.

[0053] For example: when the user points the page cursor to the storage location where the material is stored, the material code, name, specifications, which plan it comes from, the production line, machine, team, batch, production time, resources and other information stored in the current storage location will be displayed.

[0054] Preferably, the data perspective-based cargo area management system provided by the present invention can also provide users with business information operation functions for the currently managed cargo locations and inventory. In this embodiment, specifically, the following operation functions can be provided for the target cargo location and inventory currently selected by the user terminal:

[0055] (1) Positioning: Quickly locate the cargo area.

[0056] For example, users can enter certain conditions (such as the storage location of a certain material) and then perform a positioning operation. The page can then quickly locate the storage location that meets the conditions by highlighting the background.

[0057] (2) All / Reverse selection: quickly select and filter the storage locations.

[0058] For example, if a user needs to perform a business operation (such as delivery, freezing, etc.) on a material of a certain specification, they can enter certain conditions to filter the storage locations and select all the storage locations that meet the conditions. They can also deselect the selected storage locations. This way, the target storage location can be quickly selected from the numerous storage locations in the entire storage area.

[0059] (3) Freeze / unfreeze: Freeze or unfreeze the cargo space.

[0060] For example, during on-site management, if quality issues are discovered for materials produced under certain conditions (e.g., within a certain time period), users can use quick selection to freeze the set of locations that meet the conditions and simultaneously unfreeze the frozen locations. This also changes the inventory status (available / frozen) for that location in the database server.

[0061] (4) Resources: Support a more flexible production model based on materials + batches, while ensuring traceability and production stability within a unit of time, and essentially solving the supply and demand relationship (problems that can be solved include dedicated materials, inventory division, substitute materials, and the switching frequency of substitute materials).

[0062] For example, users can define resources for inventory on a shelf. In subsequent production processes, the inventory with defined resources will be allocated to the plan for the defined resources.

[0063] (5) Random inspection: Carry out random inspection on the inventory at the cargo location, and call the interface of the basic business module to convert the random inspection business done in the cargo area management system into a standard random inspection document.

[0064] For example: During on-site management, users need to conduct random inspections on one or more inventory locations. They can combine quick positioning and select all or reverse selection operations to quickly select the target location and perform random inspections on the target location. At this time, the target location will perform subsequent operations according to the random inspection business process. At the same time, the data perspective module of this system will request the basic business module and call the corresponding interface to convert a series of random inspection operation-related data into standard random inspection documents.

[0065] (6) Adjustment: Adjust the inventory location. The interface of the basic business module will be called to convert the adjustment business made in the cargo area management system into a standard cargo location adjustment document.

[0066] For example: During on-site management, considering the execution efficiency of all execution equipment in the entire cargo area, the corresponding management personnel need to centrally plan the inventory of scattered materials of the same specifications in one area, select the inventory locations and storage target locations, and then perform adjustment operations. At this time, the selected locations and inventory will be followed by subsequent business according to the business process of location adjustment. At the same time, the data perspective module of this system will request the basic business module and call the corresponding interface to convert a series of adjustment operation-related data into standard location adjustment documents.

[0067] (7) Outbound: Carry out outbound operations on inventory. The interface of the basic business module will be called to generate an outbound plan for the outbound operations performed in the cargo area management system.

[0068] For example, during on-site management, inventory with quality issues needs to be shipped out. By combining positioning and other operations, the target location can be quickly selected for shipment. At this point, the basic business module will be called to generate a shipment plan, which will be scheduled in the subsequent production process to ultimately achieve the goal of shipping out inventory from the target location.

[0069] (8) Zoning: Divide the cargo space into zones for management.

[0070] For example: the cargo space can be zoned according to the on-site platform or production line, and the zones can be bound to the platform or production line.

[0071] like Figure 2 As shown, in the display page of the user terminal, in addition to providing a basic business display area 1, a control button area 2 is also provided; wherein, the basic business status display area 1 is used to display the above-mentioned multi-dimensional basic business information, and the control button area 2 provides request trigger buttons corresponding to the above-mentioned operation functions.

[0072] like Figure 3 As shown, a cargo area management method based on data perspective of the present invention includes the following steps:

[0073] Step 1, when the present invention is started, Figure 1 The database server obtains the source data required for data perspective in real time, including storage location files, current inventory, storage location control status, production information and other information.

[0074] Step 2: After the source data is acquired, Figure 2 3.2 The location group style gets the corresponding data pivot model rule, and the source data is placed in Figure 1 Integration processing is performed in the application server to obtain storage location perspective data, which includes storage area model parameters, storage location management control status, on-hand quantity information, basic inventory information and production information.

[0075] Step 3, in Figure 1The data pivot module in the application server reads the pivot data and dynamically generates a location display model composed of HTML elements based on the location group (stacker double-fork operation unit, source location file). The model uses multi-dimensional elements such as div, img, a, checkbox, etc. combined with style control to display the storage information and management control status of the location group.

[0076] Step 4, in Figure 1 The data pivot module of the application server traverses the pivot data and combines Figure 2 The layout rules of the shelf storage area are obtained in the 3rd storage area, and the storage group units processed in step 3 are arranged according to the layout rules. Figure 1 The data pivot module in the application server processes the data and finally Figure 1 The user terminal graphically displays the storage status of all data perspectives.

[0077] Step 5: User Figure 1 After the user terminal selects the cargo location information to be processed through the interface (can be quickly selected by positioning, full / reverse selection and cargo location group selection), business operations within the warehouse area (such as freezing / unfreezing inventory, sampling, adjustment, delivery, etc.) can be quickly performed. Figure 1 The data pivot module in the application server traverses the interface selection results and converts them into corresponding cargo location information. After processing the data, it is converted into business data and transferred to Figure 1 After processing by the application server, Figure 1 The user terminal jumps to the specific business interface for subsequent operations.

Claims

1. A cargo area management system based on data perspective, consisting of a database server, an application server and a user terminal interconnected through a network; characterized in that: The database server is used to store model parameters of the cargo area, storage status parameters of the cargo area, material parameters and business data in the production process; the application server is used to monitor the data stored in the database server in real time, and update the status and business status of the cargo area in real time according to the monitored data, and update the page data generated by the preset template in real time; it is also used to respond to the request of the user terminal, generate corresponding result data according to the input conditions of the user terminal, output it to the user terminal and display it to the user; wherein, the page data provides relative position information of the cargo area, cargo storage information and cargo status information; the application server includes a basic business module and a data perspective module; wherein, the basic business module is a unit for processing business data, and the data perspective module analyzes, adds value and organizes the data processed by the basic business module; the user terminal is used to display the page data generated by the application server to display the real-time status of the entire cargo area, and is used to receive operations requested by the user; The page data includes a cargo area planning page (1) for displaying cargo area business in a perspective manner, and the objects displayed include: a button control area (2), a cargo area (3), a cargo location partition (3.1), a cargo location group (3.2), a main cargo location (3.2.1), a secondary cargo location (3.2.2), a business expression area (3), and an information display area (4); The cargo area planning page (1) is used to present cargo area relative position information, business information in the production process and operable functions, and is also used to interact with the user and receive user input instructions; the button control area (2) is used to receive user operation instructions to control the system to perform corresponding business operations; the cargo area (3) is used to present cargo area relative layout information and display cargo area related business information, including: Cargo area zoning (3.1) is used to express the division of areas based on the cargo area to facilitate further and more refined management; The cargo location group (3.2) is used to express the unit of a stacker crane operation, and is composed of two cargo locations: the main cargo location (3.2.1) and the secondary cargo location (3.2.2). The main cargo location (3.2.1) is used to express that the cargo location operated by the stacker crane's main fork is the main cargo location; the secondary cargo location (3.2.2) is used to express that the cargo location operated by the stacker crane's secondary fork is the secondary cargo location. Business expression area (3), used to display the storage status and management status of the cargo location; The information display area (4) is used to display the binding relationship between the station or production line and the partition.

2. The cargo area management system based on data perspective according to claim 1 is characterized in that: The information displayed by the user terminal includes the following dimensions: (1) Cargo location partitioning (3.1), which displays all cargo locations in the cargo area in a graphically visualized manner on the user terminal; (2) Cargo location group (3.2), the cargo location group information is displayed in a graphically visualized manner on the user terminal page; (3) Business expression area (3), which is displayed from two sub-dimensions. The first sub-dimension is used to represent the status of the storage materials of the current storage location, and the second sub-dimension is used to represent the management and control status of the current storage location; (4) Information display area (4), which displays other relevant information of the inventory materials on the storage location.

3. The cargo area management system based on data perspective according to claim 2, characterized in that: The storage material status of the shelf in the first sub-dimension includes at least full pallet, empty pallet and empty shelf; the shelf management control status of the second sub-dimension includes at least locked, frozen and solidified; Other relevant information of the material includes the material code, name, specification, plan, production line, machine, team, batch, production time and resource definition.

4. The cargo area management system based on data perspective according to claim 1, characterized in that: The business information and operational functions in the production process include: (1) Positioning: quickly locate the cargo location; (2) Full / reverse selection, quickly select and filter the cargo locations; (3) Freeze / thaw: freeze or unfreeze the cargo space; (4) Resources: providing a more flexible production model based on materials + batches, while ensuring traceability and production stability within a unit of time, essentially solving the supply and demand relationship; (5) Random inspection: perform random inspection on the inventory at the cargo area, and call the interface of the basic business module to convert the random inspection business done in the cargo area management system into a standard random inspection document; (6) Adjustment: adjust the inventory location; (7) Outbound: perform outbound operations on inventory; (8) Zoning: manage cargo spaces in designated areas.

5. The cargo area management system based on data perspective according to claim 4 is characterized in that: The sampling inspection business also includes: during the on-site management process, when the user needs to conduct a sampling inspection on one or some inventory locations, the target location can be quickly selected by combining quick positioning and full selection or reverse selection operations, and the sampling inspection operation can be performed on the target location. At this time, the target location will perform subsequent business according to the sampling inspection business process. At the same time, the data perspective module of this system will make a request to the basic business module and call the corresponding interface to convert a series of sampling inspection operation-related data into standard sampling inspection documents.

6. The cargo area management system based on data perspective according to claim 4 is characterized in that: The storage location adjustment also includes: during the on-site management process, when the corresponding management personnel need to concentrate the inventory of scattered materials of the same specifications in one area, they select the inventory storage location and the storage target location and then perform the adjustment operation. At this time, the selected storage location and inventory will be followed up according to the business process of the storage location adjustment. At the same time, the data perspective module of this system will make a request to the basic business module and call the corresponding interface to convert a series of adjustment operation related data into standard storage location adjustment documents.

7. A cargo area management method based on a data perspective cargo area management system according to any one of claims 1 to 6, characterized in that: The following steps are involved: Step 1: acquiring source data required for data pivoting from the database server in real time, wherein the source data includes storage location files, on-hand quantity, storage location control status, and production information; Step 2: Obtain corresponding data perspective model rules based on the storage location group (3.2) pattern, integrate and process the source data in the application server according to the rules, and obtain storage location perspective data, which includes storage area model parameters, storage location management control status, on-hand quantity information, basic inventory information, and production information; Step 3: The data pivot module in the application server reads the pivot data and dynamically generates a shelf display model composed of HTML elements based on the shelf group. The model uses div, img, a, and checkbox multi-dimensional elements combined with style control to display the storage information and management control status of the shelf group. Step 4, the data perspective module of the application server traverses the perspective data, combines the cargo area (3) to obtain the layout rules of the shelf cargo space, processes the cargo space group units processed in step 3 according to the layout rules in the data perspective module of the application server, and finally displays the storage status of all the data perspective cargo spaces in a graphical manner on the user terminal; In step 5, after the user selects the cargo location information that needs to be processed through the interface on the user terminal, the user quickly performs business operations in the warehouse area. After the data perspective module in the application server traverses the interface selection results, it is converted into corresponding cargo location information. After processing the data, it is converted into business data. After being transferred to the application server for processing, the user terminal jumps to the specific business interface for subsequent operations.

8. The cargo area management method according to claim 7, characterized in that: In step 3, the cargo location group includes the stacker double-fork operation unit and the source cargo location file; In step 5, the cargo location information to be processed is selected by positioning, selecting all / inversely, and checking the cargo location group. The quick business operations within the warehouse area include freezing / unfreezing inventory, spot checking, adjustment, and delivery.

9. The cargo area management method according to claim 7, characterized in that: The cargo area display also includes: a function of quickly locating cargo locations, which assists users in quickly locating target cargo locations based on the conditions of the custom organization, and provides a function for quickly selecting and filtering cargo location sets with certain conditions.

10. The cargo area management method according to claim 7, characterized in that: The cargo location positioning operation also includes: directly performing freezing / unfreezing business, sampling business, outbound business, and adjustment business operations in the production process, and converting the data generated by the operation of the system user into standard documents by calling the interface of the basic business module.

Images