CN111125496A

CN111125496A - Price query method, device and system

Info

Publication number: CN111125496A
Application number: CN201911419930.XA
Authority: CN
Inventors: 王旋; 薛俊; 徐泽夏琛; 燕斌祺; 张永
Original assignee: Jiangsu Suning Logistics Co ltd
Current assignee: Jiangsu Suning Logistics Co ltd
Priority date: 2019-12-31
Filing date: 2019-12-31
Publication date: 2020-05-08
Anticipated expiration: 2039-12-31
Also published as: CN111125496B

Abstract

The invention discloses a price query method, a device and a system, wherein the method comprises the following steps: receiving a target price type and target price dimension information input by a user; the target price dimension information is used for indicating scenes and sequences of prices to be inquired; determining target configuration information matched with the target price type and the target price dimension information from pre-stored configuration information; the target configuration information comprises target price type description information and target dimension description information; generating a query request according to the target configuration information, the price configuration table and the price parameters input by the user and then sending the query request to a database for query; the price configuration table is configured with the names of all relevant fields of price types and price dimensions for price inquiry; and acquiring a query result, calling a public computing interface to calculate the query result to obtain a calculation result, and returning the calculation result to the user. The invention realizes the high configurability of the price type information and the dimension information thereof.

Description

Price query method, device and system

Technical Field

The invention relates to the technical field of maintenance and calculation of price dimension, in particular to a price query method, device and system.

Background

At present, the logistics industry is rapidly developed, the polymorphism of logistics is an important expression in the logistics industry, and the fact that other businesses relying on radiation of the logistics industry are rapidly expanded is reflected. The range of basic services such as warehouse and distribution of logistics is high originally, and the access of other related services causes the complexity of the system to grow exponentially.

The logistics field settlement comprises services such as warehouse and distribution income, cost, salary and the like, and the core links of the services are price, the amount is calculated through different prices, and then a bill report is generated. Different services have different scenes, and the corresponding price types are various, such as charging by piece, charging by mileage, charging by grade and the like, and similarity and difference exist among the price types. The current mode of operation is that each price type independently implements its own function.

This approach has the following drawbacks:

1) the query configuration of each price type is independent, the price type needs to be developed again each time the price is increased and adjusted, so that great repeated workload is caused, the code repetition rate is increased, the repeated labor of staff is increased, and the efficiency of developers is lowered.

2) Each dimension of each price type corresponds to one template, the independent maintenance is needed, the operation and maintenance cost is high, and the code package of the system is also heavy due to the infinite increase of the templates.

3) The maintenance cost of the code is high, and meanwhile, due to the fact that the scene is complex, the scene is easy to be omitted, and production accidents are caused.

Disclosure of Invention

The invention aims to provide a price query method, a price query device and a price query system aiming at the defects of the prior art, so that the price type information and the dimension information thereof can be highly configurable.

According to a first aspect of the present invention, there is provided a price query method, the method comprising:

receiving a target price type and target price dimension information input by a user; the target price dimension information is used for indicating scenes and sequences of prices to be inquired;

determining target configuration information matched with the target price type and the target price dimension information from pre-stored configuration information; the target configuration information comprises target price type description information and target dimension description information;

generating a query request according to the target configuration information, the price configuration table and the price parameters input by the user and then sending the query request to a database for query; the price configuration table is configured with names of all relevant fields of price types and names of all relevant fields of price dimensions for price inquiry;

and acquiring a query result, calling a public computing interface to calculate the query result to obtain a computing result, and returning the computing result to the user.

Preferably, the method further comprises:

the price configuration table is created in advance, and comprises a price type configuration table and a price dimension configuration table; the price type configuration table comprises field information of service types, price types, calculation types and price levels; the dimension configuration table comprises price query scene field information and each scene sequence information.

Preferably, the generating a query request according to the target configuration information, the price configuration table and the price parameter input by the user and then sending the query request to the database for querying includes:

generating a price query template according to the target configuration information and the price configuration table;

and generating a query request through a JAVA reflection mechanism according to the price query template and the price parameters input by the user, and sending the query request to a database for querying.

Preferably, the generating the query request through the JAVA reflection mechanism includes:

and transmitting the price type, the dimension field and the price parameter in the price query template to a query interface so that the query interface corresponds the price type to a table, the dimension field to the table field and the price parameter to a database field value to assemble an SQL query request.

Preferably, the invoking a public computing interface to compute the query result includes:

and calling a public computing interface to calculate the grade and the tax rate of the query result.

According to a second aspect of the present invention, there is provided a price inquiry apparatus, the system comprising:

the receiving module is used for receiving the target price type and the target price dimension information input by the user; the target price dimension information is used for indicating scenes and sequences of prices to be inquired;

the determining module is used for determining target configuration information matched with the target price type and the target price dimension information from the prestored configuration information; the target configuration information comprises target price type description information and target dimension description information;

the query module is used for generating a query request according to the target configuration information, the price configuration table and the price parameters input by the user and then sending the query request to a database for query; the price configuration table is configured with names of all relevant fields of price types and names of all relevant fields of price dimensions for price inquiry;

and the return module is used for acquiring the query result, calling a public computing interface to calculate the query result to obtain a computing result and then returning the computing result to the user.

Preferably, the system further comprises:

the creating module is used for creating the price configuration table in advance, and the price configuration table comprises a price type configuration table and a price dimension configuration table; the price type configuration table comprises field information of service types, price types, calculation types and price levels; the dimension configuration table comprises price query scene field information and each scene sequence information.

Preferably, the query module includes:

the template generating module is used for generating a price query template according to the target configuration information and the price configuration table;

and the query request generating module is used for generating a query request through a JAVA reflection mechanism according to the price query template and the price parameters input by the user and sending the query request to the database for querying.

Preferably, the query request generating module is specifically configured to transmit the price type, the dimension field, and the price parameter in the price query template to a query interface, so that the query interface corresponds the price type to a table, corresponds the dimension field to the table field, and assembles the price parameter to the database field value into an SQL query request.

A third aspect of the present invention provides a computer system comprising:

one or more processors; and

a memory associated with the one or more processors for storing program instructions that, when read and executed by the one or more processors, perform the method as described above.

The invention has the beneficial effects that: according to the technical scheme, the universal price configuration table containing all query fields is created in advance, all the query fields are specifically described through the configuration information, so that a user can determine the target price and the target dimension according to the requirement of the user to obtain the corresponding configuration information, and a dynamic template is generated by combining the configuration table to further perform service calling query. Therefore, the price type information and the dimension information thereof can be highly configurable, the abstract stripping of the price calling part is realized according to the configuration information, the development and maintenance cost is reduced, the independence of maintenance and service is realized, and the stability and timeliness of the service are improved.

The features and advantages of the present invention will become apparent by reference to the following drawings and detailed description of specific embodiments of the invention.

Drawings

FIGS. 1A and 1B are schematic diagrams of configuration information page input according to the present invention;

FIG. 2 is a flow chart of a price query method of the present invention;

FIG. 3 is a schematic diagram of the price inquiry apparatus of the present invention;

FIG. 4 is a diagram of the computer system architecture of the present invention.

Detailed Description

The technical solutions in the embodiments of the present invention are clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.

The invention aims to provide a price query scheme, which is used for describing table fields by creating a general price query related field table and combining configuration information, then selecting corresponding configuration information according to price types and dimensions input by a user to combine the general table to generate a corresponding query template, and generating a query request according to related query parameters input by the user to perform query calculation.

To implement the above scheme, a general table is first created to specify the relevant field names that are subsequently needed for performing the query. In the application, a price type configuration table and a price dimension configuration table can be created according to requirements. As shown in table 1 below, the price type configuration table may contain relevant fields such as service type, price type, calculation type, level base and level type.

TABLE 1

The service type refers to a type related to a service, and may be, for example: 1-transport income 2-warehouse income 3-transport cost 4-warehouse resource cost; price types refer to various prices, such as FB 12-distance level unit price, FB 48-handling fee unit price, and so forth; the calculation type can be 1-amount, 2-volume, 3-weight, 4-distance, 5-value, 6-fixed value, 7 percent and the like, the grade information comprises grade type and grade base, and the grade type is 0-none; 1-full progressive; 2-extra progressive, on a level basis such as 0-none; 1 value rating; 2 number levels; 3 weight grade; 4 volume grade; 5 distance steps.

As shown in Table 2 below, the price dimension configuration table may include various scenarios and order fields of a certain price type to indicate what priority the price is computed on. If the dimensions include 10 dimensions and 20 dimensions, taking the unit price of FBXX-distance grade as an example, the 10 dimensions include: origin city/destination city/unit price, etc., 20 dimensions include: origin province/destination province/unit price, etc. Preferably, when the unit price is queried, the query is performed according to the 10 dimensions, and if the query cannot be performed, the query is performed according to the 20 dimensions.

TABLE 2

TABLE_NAME	COLUMN_NAME	REMARKS
			lpss_price_type_dimension	id	Primary key ID
lpss_price_type_dimension	biz_type	Type of service
			lpss_price_type_dimension	price_type	Price type
lpss_price_type_dimension	dimension_order	Dimension order (10, 20.)
			lpss_price_type_dimension	dimension_field_desc	Dimension field description list
lpss_price_type_dimension	dimension_field_name	Dimension field name list
			lpss_price_type_dimension	create_id	Creator
lpss_price_type_dimension	create_time	Creation time
			lpss_price_type_dimension	update_id	Modifier
lpss_price_type_dimension	update_time	Modifying time
			lpss_price_type_dimension	del_flag	0 not deleted 1 deleted

The two tables are configured with the universal field name information in the tables, and the configuration information is preset in the application for instantiating the tables, so that related personnel can configure the specific information of each type and each dimension price in advance and then instantiate the tables specifically. Before configuration, the configuration table may be synchronized to the cache from the database in which the configuration table is located. Then, an information configuration page may be set according to the general configuration table, as shown in fig. 1A and 1B, and specific description information of related personnel for different price types and different dimensions is received through the configuration page.

If the input service type is transportation income, the price type is GEX2, the dimension field is 10, and the dimension field is the five-digit code of the originating region, the service type and the like.

Through this step configuration information is generated that describes each price type, business type … …, and dimension.

The configuration information may be loaded in a cache, where the general configuration table and the instantiated configuration information of each field in the corresponding configuration table, that is, each specific price type, calculation type, dimension, and the like, are stored at the same time.

And then the method can be used for specific service calling. The user can input the target price type (including types of price, business, calculation and the like) to be queried and the target price dimension on the page to find specific description information from the configuration information, and a specific price query template can be generated by combining the general configuration table.

And then generating a query statement to perform corresponding query calculation by combining a corresponding price query template according to specific parameters input by a user.

For example, the user inputs the transportation income under the transportation service type, the price type is the distance grade unit price, the calculation type is the distance, and the calculation dimension is 10. The input address is from Nanjing to Beijing, and the distance is XX kilometers. Accordingly, under the condition of obtaining the type of the transportation income from the configuration information, the distance grade unit price is firstly obtained, the price inquiry template from Nanjing to Beijing with the dimension of 10 is calculated, and the inquiry request is generated according to the specific distance, so that the corresponding grade unit price can be correspondingly inquired.

Therefore, real-time query of different types and dimensions can be realized, a configuration table does not need to be independently set for each type of dimension, and independent maintenance for each type of dimension is also not needed. If the new or the deletion is generated, the setting can be carried out through the configuration information.

According to the scheme, the query fields required by price query are configured through a universal table, and the possible objects related to the query fields are configured with specific information, so that the corresponding query templates can be dynamically generated according to the requirements to carry out parameter bring-in and query.

Example 1

In summary, as shown in fig. 2, the present invention provides a price query method, where the method includes:

step S1:

step S2, determining target configuration information matched with the target price type and the target price dimension information from the pre-stored configuration information; the target configuration information comprises target price type description information and target dimension description information

Step S3, generating a query request according to the target configuration information, the price configuration table and the price parameter input by the user and then sending the query request to a database for query; the price configuration table is configured with names of all relevant fields of price types and names of all relevant fields of price dimensions for price inquiry;

and step S4, acquiring a query result, calling a public computing interface to compute the query result to obtain a computation result, and returning the computation result to the user.

Preferably, the method further comprises step S0:

creating the price configuration table in advance, wherein the price configuration table comprises a price type configuration table and a price dimension configuration table; the price type configuration table comprises field information of service types, price types, calculation types and price levels; the dimension configuration table comprises price query scene field information and each scene sequence information.

Preferably, step S3 includes:

s31, generating a price query template according to the target configuration information and the price configuration table;

and S32, generating a query request through a JAVA reflection mechanism according to the price query template and the price parameters input by the user, and sending the query request to a database for query.

In S31, loading the configuration information into a cache, and subsequently obtaining the configuration information and reading the configuration information from the cache; reading the dimension description and the grade basis in the configuration information from the cache according to the price and the dimension selected by the user, splitting the dimension field into various fields, and generating a template by combining the grade basis information; the dimension information stores Chinese descriptions of dimensions. The template generation comprises the following steps:

1. obtaining public information and dimension information of corresponding price types from a cache;

2. splitting and sequentially combining the common information and the dimension information into a header of the template;

3. generating an excel template;

when the service is imported, the template can be corresponding to the price list field only by operating according to the template.

The generation of the export template in this step can be implemented using the following code:

preferably, in step S32, the generating the query request through the JAVA reflection mechanism includes:

transmitting the price type, the dimension field and the price parameter in the price query template to a query interface;

and the inquiry interface corresponds the price type to a table, corresponds the dimension field to a table field, and assembles the price parameter to a database field value to form an SQL inquiry request.

In this step, when the service is called, the SQL query request is dynamically generated through the JAVA reflection mechanism according to the price configuration information, and the parameters are transmitted to the database to query the price information according to the dimension sequence in the cache, where the price configuration includes the basic information and the dimension information.

The process of assembling SQL comprises the following steps:

1. transmitting price type, dimension and corresponding field thereof, and entity field value object to the query interface;

2. the interface corresponds the price type to a table, the dimension field to a table field, and the entity field value object to a database field value, and assembles into SQL;

3. and sending the assembled SQL to a database for execution.

The dynamic generation of the SQL query request in this step may be implemented using the following code:

preferably, step S4 may specifically be to perform a calculation of the rank and the tax rate, which belongs to public calculation, and includes: and calling a public computing interface to calculate the grade and the tax rate of the query result.

In this step, the queried price information needs to be subjected to grade and tax rate calculation, wherein the tax rate calculation mode has multiple modes, for example, a payroll tax calculation mode, that is, an excess progressive mode is adopted for calculation. The logic is universal for each price type, common codes can be separated out through a JAVA template mode, and the common codes can be specifically realized by the following codes:

the scheme realizes high configuration of the system service, can greatly improve the development efficiency of the system, even some changes do not need development intervention any more, and can be completed through simple page configuration, so that the service support timeliness can be greatly improved, and the user satisfaction is improved. Meanwhile, the templated design reduces a lot of redundant codes, more importantly, reduces the complexity of a test scene and reduces the cost of maintaining the codes. Meanwhile, due to the service design of the system, the coupling among the functional modules is reduced, the robustness of the system is improved, and meanwhile, infinite expansibility is provided.

Example 2

As shown in fig. 3, according to an aspect of the present invention, there is also provided a price inquiry system, including:

a receiving module 301, configured to receive a target price type and target price dimension information input by a user; the target price dimension information is used for indicating scenes and sequences of prices to be inquired;

a determining module 302, configured to determine, from pre-stored configuration information, target configuration information that matches the target price type and the target price dimension information; the target configuration information comprises target price type description information and target dimension description information;

the query module 303 is configured to generate a query request according to the target configuration information, the price configuration table, and the price parameter input by the user, and send the query request to a database for querying; the price configuration table is configured with names of all relevant fields of price types and names of all relevant fields of price dimensions for price inquiry;

and the returning module 304 is configured to obtain a query result, call a public computing interface to compute the query result, obtain a computation result, and return the computation result to the user.

Preferably, the system further comprises: a creating module 300, configured to create the price configuration table in advance, where the price configuration table includes a price type configuration table and a price dimension configuration table; the price type configuration table comprises field information of service types, price types, calculation types and price levels; the dimension configuration table comprises price query scene field information and each scene sequence information.

Preferably, the query module comprises:

Preferably, the return module is specifically configured to invoke a public computing interface to perform the rank and tax rate calculation on the query result.

The specific implementation process of the method steps executed by each module in this embodiment is the same as the implementation process of each method step in embodiment 1, and is not described herein again.

Example 3

Corresponding to the above method and apparatus, embodiment 3 of the present application discloses a computer system, including:

one or more processors; and

a memory associated with the one or more processors for storing program instructions that, when read and executed by the one or more processors, perform all of the operations of embodiment 1.

Fig. 4 illustrates an architecture of a computer system, which may include, in particular, a processor 1510, a video display adapter 1511, a disk drive 1512, an input/output interface 1513, a network interface 1514, and a memory 1520. The processor 1510, video display adapter 1511, disk drive 1512, input/output interface 1513, network interface 1514, and memory 1520 may be communicatively coupled via a communication bus 1530.

The processor 1510 may be implemented by a general-purpose CPU (Central processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more integrated circuits, and is configured to execute related programs to implement the technical solution provided by the present Application.

The Memory 1520 may be implemented in the form of a ROM (Read Only Memory), a RAM (random access Memory), a static storage device, a dynamic storage device, or the like. The memory 1520 may store an operating system 1521 for controlling the operation of the computer system 1500, a Basic Input Output System (BIOS) for controlling low-level operations of the computer system 1500. In addition, a web browser 1523, a data storage management system 1524, an icon font processing system 1525, and the like can also be stored. The icon font processing system 1525 may be an application program that implements the operations of the foregoing steps in this embodiment of the application. In summary, when the technical solution provided by the present application is implemented by software or firmware, the relevant program codes are stored in the memory 1520 and called for execution by the processor 1510.

The input/output interface 1513 is used for connecting an input/output module to realize information input and output. The i/o module may be configured as a component in a device (not shown) or may be external to the device to provide a corresponding function. The input devices may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output devices may include a display, a speaker, a vibrator, an indicator light, etc.

The network interface 1514 is used to connect a communication module (not shown) to enable the device to communicatively interact with other devices. The communication module can realize communication in a wired mode (such as USB, network cable and the like) and also can realize communication in a wireless mode (such as mobile network, WIFI, Bluetooth and the like).

The bus 1530 includes a path to transfer information between the various components of the device, such as the processor 1510, the video display adapter 1511, the disk drive 1512, the input/output interface 1513, the network interface 1514, and the memory 1520.

In addition, the computer system 1500 may also obtain information of specific extraction conditions from the virtual resource object extraction condition information database 1541 for performing condition judgment, and the like.

It should be noted that although the above devices only show the processor 1510, the video display adapter 1511, the disk drive 1512, the input/output interface 1513, the network interface 1514, the memory 1520, the bus 1530, etc., in a specific implementation, the devices may also include other components necessary for proper operation. Furthermore, it will be understood by those skilled in the art that the apparatus described above may also include only the components necessary to implement the solution of the present application, and not necessarily all of the components shown in the figures.

From the above description of the embodiments, it is clear to those skilled in the art that the present application can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the present application may be embodied in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, or the like, and includes several instructions for enabling a computer device (which may be a personal computer, a cloud server, or a network device) to execute the method according to the embodiments or some parts of the embodiments of the present application.

The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the system or system embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the descriptions of the method embodiments for related points. The above-described system and system embodiments are only illustrative, wherein the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.

The price query method, the price query platform and the price query system provided by the application are introduced in detail, specific examples are applied in the description to explain the principle and the implementation mode of the application, and the description of the embodiments is only used for helping to understand the method and the core idea of the application; meanwhile, for a person skilled in the art, according to the idea of the present application, the specific embodiments and the application range may be changed. In view of the above, the description should not be taken as limiting the application.

Claims

1. A method of price querying, the method comprising:

2. The price query method of claim 1, wherein the method further comprises:

3. The price query method according to claim 1 or 2, wherein the generating a query request according to the target configuration information, the price configuration table and the price parameter input by the user and then sending the query request to the database for querying comprises:

4. The price inquiry method of claim 3, wherein said generating an inquiry request by a JAVA reflection mechanism comprises:

5. The price query method of claim 1, wherein said invoking a public computing interface to compute the query result comprises:

6. A price inquiry apparatus, characterized in that the system comprises:

7. The price inquiry apparatus of claim 6, wherein: the system further comprises:

8. The price inquiry apparatus of claim 6 or 7, wherein the inquiry module comprises:

9. The price query device of claim 8, wherein the query request generation module is specifically configured to transmit the price type, the dimension field, and the price parameter in the price query template to a query interface, so that the query interface corresponds the price type to a table, corresponds the dimension field to a table field, corresponds the price parameter to a database field value, and assembles the SQL query request.

10. A computer system, comprising:

one or more processors; and

a memory associated with the one or more processors for storing program instructions that, when read and executed by the one or more processors, perform the method of any of claims 1-5.