Oil product completion order splitting method and system, electronic equipment and storage medium
By establishing metering and splitting rules for each minimum inventory unit SKU in each station, the problem of inflexible splitting of oil products in the existing technology is solved, and flexible splitting and accurate settlement of oil products are achieved.
Patent Information
- Application Number
- CN202411143523.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-20
- Publication Date
- 2025-03-04
AI Technical Summary
The existing technology is difficult to flexibly split oil product completion orders, and does not support the unique splitting logic of oil product completion orders, which leads to difficulties in forming downstream settlement statements.
Establish metering and splitting rules for each minimum inventory unit SKU of each station yard, match the corresponding metering and splitting rules based on the station name on the oil product completion order to be split and the oil sales user, and split them.
It realizes flexible splitting of oil products according to actual conditions, ensuring accurate splitting results, supporting unique splitting logic, and providing strong data guarantees for downstream settlement.
Smart Images
Figure CN119558923A_ABST
Abstract
Description
Background Art
[0002] In recent years, with the continuous expansion of pipeline network business, the measurement of oil pipeline transportation volume has become a major issue. At present, there is no fixed processing mode for the processing of oil completion orders, and the processing rules are not fixed and not flexible enough, which poses a great challenge to the generation of settlement orders downstream.
[0003] Although the existing order splitting technology has relatively mature solutions, it is not applicable to the splitting of oil product completion orders because the splitting requirements of oil product completion orders are relatively flexible. Moreover, the splitting of oil product completion orders has its own unique splitting logic, which is not supported by the existing order splitting technology. Summary of the invention
[0004] The technical problem to be solved by the present invention is to address the deficiencies of the prior art, and specifically provide a method, system, electronic device and storage medium for splitting oil product completion orders, as follows:
[0005] 1) In the first aspect, the present invention provides a method for splitting oil products, and the specific technical scheme is as follows:
[0006] Establish measurement splitting rules for each minimum inventory unit SKU of each station. Each minimum inventory unit SKU corresponds to an oil sales user and a station.
[0007] When receiving the completed list of oil products to be split, the metering splitting rules corresponding to the completed list of oil products to be split are matched according to the station name and oil sales user on the completed list of oil products to be split;
[0008] The oil product completion order to be split is split according to the measurement splitting rules corresponding to the oil product completion order to be split.
[0009] The beneficial effects of the oil product complete single splitting method provided by the present invention are as follows:
[0010] According to the actual situation, it is possible to establish measurement splitting rules for each minimum inventory unit SKU of each station. By matching, it is possible to match the measurement splitting rules corresponding to the oil product completion order to be split, and then split it. When any measurement splitting rule is not applicable, the measurement splitting rule can be directly modified without affecting the code of the subsequent splitting program. It is more flexible and can ultimately split the oil product completion order to be split into the corresponding minimum inventory unit SKU, providing strong data protection for downstream settlement.
[0011] On the basis of the above scheme, the oil product single splitting method of the present invention can also be improved as follows.
[0012] Furthermore, the established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule.
[0013] Furthermore, each pipeline in each station is regarded as a minimum inventory unit SKU.
[0014] Furthermore, it also includes: settling the split orders obtained by splitting the completed orders of the oil products to be split.
[0015] 2) In the second aspect, the present invention also provides an oil product complete unit splitting system, and the specific technical solution is as follows:
[0016] It includes rule building module, matching module and order splitting module;
[0017] The rule establishment module is used to establish a measurement splitting rule for each minimum inventory unit SKU of each station, and each minimum inventory unit SKU corresponds to an oil sales user and a station;
[0018] The matching module is used to: when receiving the oil product completion order to be split, match the metering splitting rules corresponding to the oil product completion order to be split according to the station name and oil sales user on the oil product completion order to be split;
[0019] The completion order splitting module is used to split the oil product completion order to be split according to the measurement splitting rules corresponding to the oil product completion order to be split.
[0020] On the basis of the above scheme, the oil product splitting system of the present invention can also be improved as follows.
[0021] Furthermore, the established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule.
[0022] Furthermore, each pipeline in each station is regarded as a minimum inventory unit SKU.
[0023] Furthermore, it also includes a settlement module, which is used to settle the split orders obtained by splitting the completed orders of the oil products to be split.
[0024] 3) In a third aspect, the present invention further provides an electronic device, comprising a processor, the processor being coupled to a memory, the memory storing at least one computer program, the at least one computer program being loaded and executed by the processor, so that the electronic device can implement any of the above-mentioned oil product completion single splitting methods.
[0025] 4) In a fourth aspect, the present invention further provides a computer-readable storage medium, in which at least one computer program is stored, and the at least one computer program is loaded and executed by a processor so that a computer implements any of the above-mentioned oil product completion single splitting methods.
[0026] It should be noted that the beneficial effects achieved by the technical solutions of the second to fourth aspects of the present invention and the corresponding possible implementation methods can be found in the above-mentioned technical effects of the first aspect and its corresponding possible implementation methods, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS
[0027] Other features, objects and advantages of the present invention will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings:
[0028] Figure 1 A schematic diagram of a process for completing a single splitting method of an oil product according to an embodiment of the present invention;
[0029] Figure 2 This is a structural schematic diagram of an oil product completion and splitting system according to an embodiment of the present invention;
[0030] Figure 3 The figure is a schematic diagram of the structure of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION
[0031] In order to make the objectives, technical solutions and advantages of the present invention more clear, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings.
[0032] like Figure 1 As shown, a method for splitting oil products according to an embodiment of the present invention comprises the following steps:
[0033] S1. Establish a measurement splitting rule for each minimum inventory unit SKU of each station, and each minimum inventory unit SKU corresponds to an oil sales user and a station;
[0034] Through investigation and analysis of the minimum inventory unit SKU of each station and the oil sales users of each station, metering splitting rules are set for each minimum inventory unit SKU (pipeline) of each station. Each minimum inventory unit SKU corresponds to an oil sales user and a station. The information of each minimum inventory unit SKU (number, specific parts, etc.) and its corresponding metering splitting rules, the information of the oil sales user (such as company name, contact information, address, etc.) and the station information (such as the name and address of the station, etc.) are stored in the MYSQL database or REDIS database. The information and programs in the PPS data source connected to the MYSQL database or REDIS database make it easy to obtain data from the MYSQL database or REDIS database.
[0035] S2. When receiving the completed list of the oil products to be split, the metering splitting rules corresponding to the completed list of the oil products to be split are matched according to the station name and the oil seller on the completed list of the oil products to be split;
[0036] S3. Split the oil product completion order to be split according to the measurement splitting rules corresponding to the oil product completion order to be split.
[0037] Among them, a scheduled task can be set for the oil product completion orders to be split, and the oil product completion orders to be split can be split regularly. A summary scheduled task can also be set. After a preset number of oil product completion orders to be split are summarized, the oil product completion orders to be split can be split regularly.
[0038] Optionally, when the metering splitting rules corresponding to the oil product completion order to be split are not matched, a reminder can be issued to facilitate manual intervention and subsequent processing.
[0039] Optionally, in the above technical solution, the established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule, specifically:
[0040] 1) Point Quantification Rules:
[0041] The application scenario of the point-based quantitative rule is: single-point measurement of a single minimum inventory unit SKU, the metering point is a station, and the value type of the metering point is oil sales type, oil collection type or oil transportation type. The corresponding value type can be selected according to the metering point, and a split order can be obtained by using the point-based quantitative rule. The completion quantity in the split order is: the completion quantity of the corresponding value type of the station at the metering point obtained from the oil product completion order to be split. For example, the metering point is station A, and the value type of station A (metering point) is oil sales type. Using the point-based quantitative rule, a split order can be obtained, and the split quantity of the split order is: the completion quantity of the oil sales type of station A obtained from the oil product completion order to be split (oil sales completion quantity).
[0042] 2) Rules for taking difference:
[0043] The application scenario of the difference quantity rule is: two-point measurement of a single minimum inventory unit SKU, involving two metering points, and the value type of each metering point is oil sales type, oil collection type or oil transportation type. Using the difference quantity rule, a split order is obtained, and the completion quantity in the split order is: the difference between the completion quantities of the corresponding value types of the stations at the two metering points obtained from the oil product completion order to be split. For example, the two metering points are station B and station C, and the value types of station B and station C are both oil sales type. Using the difference quantity rule, a split order can be obtained, and the completion quantity in the split order is: the difference between the completion quantity of the oil sales type of station B (oil sales completion quantity) and the completion quantity of the oil sales type of station C (oil sales completion quantity).
[0044] 3) Addition and quantity rules:
[0045] The application scenario of the sum quantity rule is: multi-point measurement of a single minimum inventory unit SKU, involving multiple metering points, and the value type of each metering point is oil sales type, oil collection type or oil transportation type. Using the sum quantity rule, a split order is obtained, and the completion quantity in the split order is: the sum of the completion quantities of the corresponding value types of the stations of each metering point obtained from the oil product completion order to be split. For example, the three metering points are station D, station E and station F, and the value types of station D, station E and station F are all oil sales type. Using the sum quantity rule, a split order can be obtained, and the completion quantity in the split order is: the sum of the completion quantity of the oil sales type of station D (oil sales completion quantity), the completion quantity of the oil sales type of station E (oil sales completion quantity) and the completion quantity of the oil sales type of station F (oil sales completion quantity).
[0046] 4) Rules for taking quantities at different points:
[0047] The application scenario of the different-point quantity rule is: multi-point measurement of a single minimum inventory unit SKU, involving multiple metering points. The value type of each metering point is oil sales type, oil collection type or oil transportation type. Each metering point can select or enter the value ratio (the value ratio means: the proportion of the completed quantity of the value type of any metering point in all the completed quantities of the metering point), elements (oil source, pipeline, injection direction). Using the different-point quantity rule, multiple split orders can be obtained. The number of split orders is the same as the number of metering points. The completed quantity of any split order is: the product of the completed quantity of the value type of the metering point and the value ratio of the metering point. Specifically:
[0048] The completed quantity of the first split order is: the product of the completed quantity of the corresponding value type of the station field of the first metering point and the value ratio of the first metering point; the completed quantity of the second split order is: the product of the completed quantity of the corresponding value type of the station field of the first metering point and the value ratio of the second metering point... The completed quantity of the nth split order is: the product of the completed quantity of the corresponding value type of the station field of the nth metering point and the value ratio of the nth metering point, where n is a positive integer and represents the number of metering points.
[0049] For example, when using the different-point quantity taking rule, there are three metering points involved, namely, G station, H station and I station. The value types of G station, H station and I station are all oil sales types. Using the summing quantity taking rule, we can get:
[0050] The completion quantity of the first split order = the completion quantity of the oil sales type of G station (oil sales completion quantity) × the value ratio of G station; the completion quantity of the second split order = the completion quantity of the oil sales type of H station (oil sales completion quantity) × the value ratio of H station; the completion quantity of the third split order = the completion quantity of the oil sales type of I station (oil sales completion quantity) × the value ratio of I station.
[0051] 5) Proportional split rules:
[0052] The application scenario of the proportional splitting rule is: single-point measurement of multiple minimum inventory unit SKUs, involving one metering point, and each minimum inventory unit SKU is configured with a corresponding weight value (also known as the paper shortage ratio). Using the proportional splitting rule, the number of split orders is the same as the number of minimum inventory unit SKUs, and the completion quantity of any split order is: the completion quantity of the completed order of the oil product to be split × (the weight value of the first minimum inventory unit SKU / the sum of the weight values of all minimum inventory unit SKUs). For example, if there are two minimum inventory unit SKUs, the completion quantity of the first split order is: the completion quantity of the completed order of the oil product to be split × (the weight value of the first minimum inventory unit SKU / the sum of the weight values of the first minimum inventory unit SKU and the second minimum inventory unit SKU), and the completion quantity of the second split order is: the completion quantity of the completed order of the oil product to be split × (the weight value of the second minimum inventory unit SKU / the sum of the weight value of the first minimum inventory unit SKU and the weight value of the second minimum inventory unit SKU).
[0053] Optionally, in the above technical solution, each pipeline in each station is taken as a minimum inventory unit SKU.
[0054] Optionally, the above technical solution further includes: settling the split orders obtained by splitting the oil product completion orders to be split.
[0055] The beneficial effects of the present invention are as follows:
[0056] 1) The present invention is mainly to solve the problem of oil product completion order splitting. The oil product splitting will eventually split the completion order into the smallest inventory unit SKU, which is convenient for downstream settlement based on the smallest inventory unit SKU. Combined with the geographical location, injection direction, pipeline, sales and collection status and splitting requirements of each oil product station, an efficient and flexible splitting method based on dynamic coupling of oil product completion orders is established, and the oil product completion order splitting is carried out, which can enable the oil product splitting to form its own splitting system, respond more flexibly to future splitting needs, and provide strong data guarantee for downstream settlement.
[0057] 2) Aiming at the current status of oil pipeline transportation, the present invention conducts sufficient market research, is based on mathematical models and mechanism analysis, and can quickly adapt to each usage scenario, so as to complete the splitting of the completion volume of each station in a more accurate, flexible and targeted manner, providing a strong data integrity guarantee for the downstream oil settlement module.
[0058] 3) The present invention is suitable for the splitting of oil pipeline transportation volume, and can quickly, accurately and flexibly adapt to the splitting needs of the pipeline transportation volume of each station. It can quickly respond to the splitting needs according to the current market situation, save labor costs, and provide strong data support for downstream modules while ensuring data integrity and reliability.
[0059] In the above embodiments, although the steps are numbered S1, S2, etc., these are only specific embodiments given by the present invention. Those skilled in the art may adjust the execution order of S1, S2, etc. according to actual conditions, which is also within the protection scope of the present invention. It can be understood that in some embodiments, some or all of the above embodiments may be included.
[0060] like Figure 2 As shown, an oil product completed order splitting system 200 according to an embodiment of the present invention includes a rule establishing module 201, a matching module 202 and a completed order splitting module 203;
[0061] The rule establishment module 201 is used to establish a measurement splitting rule for each minimum inventory unit SKU of each station, and each minimum inventory unit SKU corresponds to an oil sales user and a station;
[0062] The matching module 202 is used to: when receiving the oil product completion order to be split, match the metering splitting rules corresponding to the oil product completion order to be split according to the station name and the oil sales user on the oil product completion order to be split;
[0063] The completion order splitting module 203 is used to split the oil product completion order to be split according to the measurement splitting rules corresponding to the oil product completion order to be split.
[0064] Optionally, in the above technical solution, the established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule.
[0065] Optionally, in the above technical solution, each pipeline in each station is taken as a minimum inventory unit SKU.
[0066] Optionally, the above technical solution further includes a settlement module, which is used to settle the split orders obtained by splitting the oil product completion orders to be split.
[0067] It should be noted that the beneficial effects of the oil product completion order splitting system 200 provided in the above embodiment are the same as the beneficial effects of the above oil product completion order splitting method, which will not be described in detail here. In addition, when the system provided in the above embodiment realizes its functions, it only uses the division of the above functional modules as an example. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the system can be divided into different functional modules according to actual conditions to complete all or part of the functions described above. In addition, the system and method embodiments provided in the above embodiment belong to the same concept, and the specific implementation process is detailed in the method embodiment, which will not be described in detail here.
[0068] like Figure 3 As shown, an electronic device 300 according to an embodiment of the present invention includes a processor 320, the processor 320 is coupled to a memory 310, and the memory 310 stores at least one computer program 330, and the at least one computer program 330 is loaded and executed by the processor 320, so that the electronic device 300 implements any of the above-mentioned oil product completion single splitting methods, specifically:
[0069] The electronic device 300 may have relatively large differences due to different configurations or performances, and may include one or more processors 320 (Central Processing Units, CPU) and one or more memories 310, wherein at least one computer program 330 is stored in the one or more memories 310, and the at least one computer program 330 is loaded and executed by the one or more processors 320, so that the electronic device 300 implements any oil product complete single splitting method provided in the above embodiments. Of course, the electronic device 300 may also have components such as a wired or wireless network interface, a keyboard, and an input and output interface for input and output. The electronic device 300 may also include other components for realizing the functions of the device, which will not be described in detail here. The electronic device may specifically be a computer, etc.
[0070] A computer-readable storage medium according to an embodiment of the present invention stores at least one computer program, and the at least one computer program is loaded and executed by a processor so that a computer implements any of the above-mentioned oil product completion single splitting methods.
[0071] Optionally, the computer-readable storage medium may be a read-only memory (ROM), a random access memory (RAM), a compact disc (CD-ROM), a magnetic tape, a floppy disk, an optical data storage device, and the like.
[0072] In an exemplary embodiment, a computer program product or a computer program is also provided, the computer program product or the computer program comprising computer instructions, the computer instructions being stored in a computer-readable storage medium. A processor of an electronic device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the electronic device executes any of the above-mentioned oil product completion single splitting methods.
[0073] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application are used to distinguish similar objects and represent the definition of a specific order or sequence. The order of use of similar objects can be interchanged where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than the order shown or described.
[0074] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present invention can be specifically implemented in the following forms, namely: it can be complete hardware, it can be complete software (including firmware, resident software, microcode, etc.), or it can be a combination of hardware and software, which is generally referred to as "circuit", "module" or "system" herein. In addition, in some embodiments, the present invention can also be implemented in the form of a computer program product in one or more computer-readable media, and the computer-readable medium contains computer-readable program code.
[0075] Any combination of one or more computer-readable media can be used. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
[0076] Although the embodiments of the present invention have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present invention. A person skilled in the art may change, modify, replace and vary the above embodiments within the scope of the present invention.
Claims
1. A method for splitting oil products, characterized in that: include: Establish measurement splitting rules for each minimum inventory unit SKU of each station. Each minimum inventory unit SKU corresponds to an oil sales user and a station. When receiving a completed list of oil products to be split, matching the metering splitting rules corresponding to the completed list of oil products to be split according to the station name and the oil seller on the completed list of oil products to be split; The oil product completion order to be split is split according to the measurement splitting rule corresponding to the oil product completion order to be split.
2. The oil product completion order splitting method according to claim 1, characterized in that: The established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule.
3. The oil product completion order splitting method according to claim 2, characterized in that: Each pipeline at each station is regarded as a minimum inventory unit SKU.
4. The oil product complete order splitting method according to any one of claims 1 to 3, characterized in that: Also includes: The split orders obtained by splitting the oil product completion orders to be split are settled.
5. An oil product complete single splitting system, characterized in that: It includes rule building module, matching module and order splitting module; The rule establishment module is used to establish a measurement splitting rule for each minimum inventory unit SKU of each station, and each minimum inventory unit SKU corresponds to an oil sales user and a station; The matching module is used to: when receiving a completed list of oil products to be split, match the metering splitting rules corresponding to the completed list of oil products to be split according to the station name and the oil seller on the completed list of oil products to be split; The completion order splitting module is used to split the oil product completion order to be split according to the measurement splitting rules corresponding to the oil product completion order to be split.
6. The oil product complete separation system according to claim 5, characterized in that: The established measurement splitting rules include: point quantity rule, difference quantity rule, addition quantity rule, different point quantity rule and proportion splitting rule.
7. The oil product complete separation system according to claim 6, characterized in that: Each pipeline at each station is regarded as a minimum inventory unit SKU.
8. An oil product complete separation system according to any one of claims 5 to 7, characterized in that: It also includes a settlement module, which is used to settle the split orders obtained by splitting the oil product completion orders to be split.
9. An electronic device, characterized in that: The electronic device includes a processor, the processor is coupled to a memory, the memory stores at least one computer program, and the at least one computer program is loaded and executed by the processor so that the electronic device implements an oil product completion single splitting method as described in any one of claims 1 to 4.
10. A computer-readable storage medium, characterized in that: At least one computer program is stored in the computer-readable storage medium, and the at least one computer program is loaded and executed by the processor to enable the computer to implement the oil product completion unit splitting method as claimed in any one of claims 1 to 4.