A method, device, equipment and storage medium for querying bill data

By receiving the client's bill details query request, obtaining detailed data from the database based on the bill identification and selecting the target template to generate page data, it solves the problems of high resource costs and poor flexibility in the business system, and realizes unified management and flexibility in the bill data.

CN114398431BActive Publication Date: 2025-08-19JINGDONG TECH HLDG CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210008231.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-01-06
Publication Date
2025-08-19
Estimated Expiration
2042-01-06

AI Technical Summary

Technical Problem

In the prior art, each business system maintains the bill data of this business, with high resource costs and a single generation method, and poor flexibility.

Method used

By receiving the client's bill details query request, obtain detailed data from the database based on the bill identification, and select the target template to generate bill details page data, and display it using the template description data.

Benefits of technology

It realizes unified management of billing data of each business, reduces resource costs, and improves query flexibility and reliability.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114398431B_ABST
    Figure CN114398431B_ABST
Patent Text Reader

Abstract

The present invention discloses a method, apparatus, device, and storage medium for querying bill data. The method comprises: receiving a bill details query request sent by a client; obtaining bill detail data to be displayed from a database according to a bill identifier in the bill details query request; selecting a target template for displaying the bill detail data according to business parameters in the bill details query request, and obtaining template description data of the target template; generating bill detail page data based on the bill detail data and template description data, and sending the bill detail page data to the client, so that the client generates and displays a bill detail page based on the bill detail page data. Through the technical solution of the present invention, it is possible to uniformly manage the bill data of each business, display the bill detail page according to the template description data, reduce resource costs, and improve the flexibility, efficiency, and reliability of querying bill data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] Embodiments of the present invention relate to the field of computer technology, and in particular to a method, apparatus, device, and storage medium for querying bill data. Background Art

[0002] With the continuous development of e-commerce systems, users need to view the billing data generated by various businesses. Various businesses refer to various businesses under the same software, such as the same e-commerce application software, which may include payment business, financial management business, etc.

[0003] In the process of implementing the present invention, it was found that the prior art has at least the following technical problems:

[0004] Currently, each business's own business system maintains its own billing data and provides query services for its billing data, which requires high resource costs. At the same time, each business's business system generates billing data to be displayed on the front end in a fixed manner, which has a single generation method and poor flexibility. Summary of the Invention

[0005] Embodiments of the present invention provide a method, apparatus, device, and storage medium for querying bill data to improve the flexibility, efficiency, and reliability of querying bill data and reduce resource costs.

[0006] In a first aspect, an embodiment of the present invention provides a method for querying bill data, comprising:

[0007] Receive bill details query request sent by the client;

[0008] Obtain the bill details to be displayed from the database based on the bill ID in the bill details query request;

[0009] Select the target template used to display the bill details data based on the business parameters in the bill details query request, and obtain the template description data of the target template;

[0010] Generate bill details page data based on the bill detail data and the template description data, and send the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data.

[0011] In a second aspect, an embodiment of the present invention further provides a device for querying bill data, the device comprising:

[0012] Request receiving module, used to receive bill details query request sent by the client;

[0013] The data acquisition module is used to obtain the bill details to be displayed from the database according to the bill ID in the bill details query request;

[0014] The model selection module is used to select the target template used to display the bill details data based on the business parameters in the bill details query request and obtain the template description data of the target template;

[0015] The page display module is used to generate bill details page data based on bill detail data and template description data, and send the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data.

[0016] In a third aspect, an embodiment of the present invention further provides a computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, a method for querying bill data as described in any one of the embodiments of the present invention is implemented.

[0017] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method for querying bill data as described in any one of the embodiments of the present invention.

[0018] In an embodiment of the present invention, a bill details query request sent by a client is received, bill detail data to be displayed is obtained from a database according to a bill identifier in the bill details query request, a target template used to display the bill detail data is selected according to the business parameters in the bill details query request, and template description data of the target template is obtained, bill details page data is generated based on the bill detail data and the template description data, and the bill details page data is sent to the client, so that the client generates and displays a bill details page based on the bill details page data. It can be seen that this solution selects the target template to be used according to the business parameters in the bill details query request, and generates and displays the bill details page according to the template description data of the target template, which solves the problem of poor flexibility in generating bill data of the business system, realizes unified management of bill data of each business, reduces resource costs, and improves the flexibility, efficiency and reliability of querying bill data. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the embodiments. It should be understood that the following drawings only illustrate certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other relevant drawings can be obtained based on these drawings without paying any creative work.

[0020] Figure 1 This is a flowchart of a method for querying bill data in Example 1 of the present invention;

[0021] Figure 2 Schematic diagram of template synchronization update provided in the first embodiment of the present invention;

[0022] Figure 3 This is a flowchart of a method for querying bill data in Example 2 of the present invention;

[0023] Figure 4 This is a schematic diagram of the bill details page provided in the second embodiment of the present invention;

[0024] Figure 5 This is a flowchart of a method for querying bill data in Example 3 of the present invention;

[0025] Figure 6 This is a schematic diagram of a bill list in Example 3 of the present invention;

[0026] Figure 7 This is a schematic diagram of the structure of a bill data query device in the fourth embodiment of the present invention;

[0027] Figure 8 This is a framework diagram of a bill data query system in Embodiment 5 of the present invention;

[0028] Figure 9 This is a schematic diagram of specific modules of the template data generation engine provided in the fifth embodiment of the present invention;

[0029] Figure 10 It is a structural diagram of a computer device in embodiment 6 of the present invention. DETAILED DESCRIPTION

[0030] The present invention will be further described in detail below with reference to the accompanying drawings and examples. It will be understood that the specific embodiments described herein are intended only to illustrate the present invention and are not intended to limit the present invention. It should also be noted that, for ease of description, the accompanying drawings only illustrate portions relevant to the present invention, not all structures.

[0031] Example 1

[0032] Figure 1 This is a flow chart of a method for querying bill data in the first embodiment of the present invention. This embodiment is applicable to the query and display of bill details. The method can be executed by the bill data query device in the embodiment of the present invention. The device can be implemented in software and / or hardware. Figure 1 As shown, the method specifically includes the following steps:

[0033] S110: Receive a bill details query request sent by a client.

[0034] Among them, the client specifically includes an e-commerce application installed on the user terminal or a business application of the business system; the bill specifically includes payment (mall consumption, active / automatic repayment of Baitiao / Gold Bar, insurance purchase, small treasury transfer, offline consumption), wealth trading platform (funds, securities investment, pension insurance, gold, insurance investment, smart investment, credit insurance investment, bank), consumer finance (Bai Tiao offline repayment, Didi Baitiao, Baitiao Quick Pay, Gold Bar), transaction unified events (collection, payment, pre-authorization, online transactions using A payment) and other bills generated by the business, etc., this embodiment does not limit this.

[0035] Specifically, the bill details query request is used to query the detailed information of the bill. When the bill details need to be queried, click the bill entry button or link on the client to view the bill and receive the specific bill details query request.

[0036] S120: Obtain detailed bill data to be displayed from a database according to the bill identifier in the bill details query request.

[0037] The bill identifier is the attribute information of the bill, which can specifically be a mark or symbol for identifying the bill, indicating certain characteristics of the bill, including the bill number, user personal identification code, and business order number. A database refers to a large amount of bill data that is stored in a computer for a long period of time, organized, shared, and uniformly managed; the bill detail data can be understood as the specific data to be displayed, including basic transaction data and business data. Specifically, basic transaction data includes transaction description, merchant name, amount, discount, payment method, funding direction, primary classification, secondary classification, business action, etc. Business data includes delivery address, recharge mobile phone number, insurance policy number, progress bar data, gold redemption weight, Electronic Toll Collection (ETC) payment license plate, fund purchase net value, etc. This embodiment does not limit this.

[0038] Specifically, after initiating a bill details query request, the bill attribute information, such as the bill ID, is parsed from the bill details query request; then, the bill details, such as the basic data and business data of the transaction to be displayed, are obtained from the database through the bill ID.

[0039] S130 , selecting a target template for displaying bill detail data according to the business parameters in the bill detail query request, and obtaining template description data of the target template.

[0040] Specifically, templates are pre-configured and saved on the server side. There can be multiple templates, each suitable for different business scenarios. Therefore, when a bill details query request is received, the template that matches the business parameters in the bill details query request will be selected from the configured templates as the target template to be used.

[0041] The business parameters refer to the descriptive information of the business to which the bill to be queried belongs, including the business identifier, business operation, business type, and business funds. Business types include payment, wealth management, insurance, and consumer finance. The target template is composed of different modules based on the template used to display bill details. Template description data is used to describe the target template information, including the number of modules, module arrangement, module parameter types, module attributes, and display mode. This is not limited in this embodiment of the present invention.

[0042] Specifically, the business identifier in the business parameters can be a business name, business number, etc. For example, the business number can be the number of Class 1 business (such as payment business) or Class 2 business (such as financial management business); business operation refers to specific business actions, including payment, transfer, etc.; business funds include the specific funding direction of the business, which is not limited in this embodiment.

[0043] S140 , generating bill detail page data based on the bill detail data and the template description data, and sending the bill detail page data to the client, so that the client generates and displays a bill detail page based on the bill detail page data.

[0044] Among them, the bill details page data can be Hypertext Markup Language (HTML) page data. Specifically, the freemarker template engine can be used to render the bill details data and template description data to obtain HTML page data; the bill details page is a page used to display bill details data, and this embodiment does not limit this.

[0045] Based on the above embodiment, optionally, the query method for billing data also includes: periodically obtaining the latest version number of the template from the remote distributed cache system; obtaining the configuration information of the latest version of the template from the database; in response to the inconsistency between the configuration information of the template in the local cache and the configuration information obtained from the database, aggregating and processing the relevant data of the configuration information of the template in the local cache based on the configuration information obtained from the database and then placing it in the local cache; storing the configuration information of the locally cached template and the version number of the template in the remote distributed cache system.

[0046] Among them, the remote distributed cache system refers to a distributed cache system for large-scale applications. The total memory capacity of the machines currently managed exceeds 60TB, there are nearly 600 Redis Cluster clusters, and more than 9,200 Redis instances.

[0047] Specifically, Figure 2 Schematic diagram of template synchronization update provided in the first embodiment of the present invention; Figure 2 The remote distributed cache system shown can perform full web-visualized operation and maintenance, one-click deployment of cache clusters, coordinated management of resource pools, online capacity expansion and rapid data migration, multi-computer room switching and disaster recovery, comprehensive monitoring and alarm, Redis, and Application Programming Interface (API) compatibility, etc.

[0048] For example, the latest version of the template is periodically retrieved and the configuration information for the latest version of the template is retrieved from the database. If the two configuration information are inconsistent, the configuration information is aggregated and stored in the local cache. The configuration information and template version number in the locally cached template are then stored in the remote distributed cache system and updated synchronously. This setup provides real-time template updates and improves the flexibility of querying billing data.

[0049] On the basis of the above embodiment, optionally, the client is an e-commerce application installed on the user terminal, and the bill identifier includes the bill number; or, the client is a business application installed on the business system, and the bill identifier includes the user's personal identification code and the business order number. The advantage of this setting is that the bill business to be queried can be quickly and accurately locked, the bill query efficiency can be improved, and the user experience can be greatly improved. At the same time, when the client is an e-commerce application installed on the user terminal, the user using the user terminal can query the detailed information of the corresponding bill by entering or selecting the bill number on the client. When the client is a business application installed on the business system, business-related personnel, such as business developers, can query the detailed information of the bill of the corresponding user and business by entering or selecting the user's personal identification code and business order number on the client.

[0050] The technical solution of this embodiment is to receive a bill details query request sent by a client; obtain the bill details data to be displayed from the database according to the bill identifier in the bill details query request; select the target template used to display the bill details data according to the business parameters in the bill details query request, and obtain the template description data of the target template; generate bill details page data based on the bill details data and the template description data, and send the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data, thereby solving the problem of poor flexibility of business bills, realizing unified management of bill data of various businesses, displaying the bill details page according to the template description data, reducing resource costs, and improving the flexibility, efficiency and reliability of querying bill data.

[0051] Example 2

[0052] Figure 3 This is a flowchart of a method for querying bill data in the second embodiment of the present invention. This embodiment is optimized based on the above embodiment. In this embodiment, the template description data for obtaining the target template is further optimized.

[0053] like Figure 3 As shown, the method of this embodiment specifically includes the following steps:

[0054] S310: Receive a bill details query request sent by a client.

[0055] S320: Obtain detailed bill data to be displayed from a database according to the bill identifier in the bill details query request.

[0056] Specifically, after initiating a bill details query request, the bill attribute information is parsed from the bill details query request, such as the bill identifier including the bill number and business order number; then, the bill details such as the basic data and business data of the transaction to be displayed are obtained from the database through the bill number and business order number.

[0057] Based on the above embodiment, optionally, before obtaining the bill detail data to be displayed from the database according to the bill identifier in the bill detail query request, it also includes: reading the source identifier in the bill detail query request; wherein the source identifier represents the application entry that triggers the bill detail query request; verifying the legitimacy of the source identifier, and triggering the execution of the operation of obtaining the bill detail data to be displayed from the database according to the bill identifier in the bill detail query request after the verification passes.

[0058] Among them, the application entry may include application (APP) 1-My-My Bill; APP2-My-My Wallet-Bill; APP3-My-Financial Service-Payment; many vertical business bill records, etc., which are not limited in this embodiment. Specifically, it can be determined whether the application entry represented by the source identifier in the bill details query request is in the pre-set whitelist. If it is in the whitelist, the verification passes. After determining that the verification passes, the operation of obtaining the bill details data to be displayed from the database according to the bill identifier in the bill details query request is triggered. The advantage of this setting is that the source of the bill business to be queried can be quickly and accurately determined, thereby improving the reliability of bill queries.

[0059] S330 , querying the template configuration table according to the business parameters in the bill details query request, and obtaining the identifier of the target template corresponding to the business parameters.

[0060] Among them, the business parameters include at least one of the business identifier, business operation, business type, and business funds. Among them, the template configuration table contains the definition information of each template. The definition information of each template may include the template identifier (including English alias, template name), lock status, refresh status, corresponding business parameters and version, etc., which is not limited in this embodiment. Specifically, the lock status will not be used by the program when locked, and the newly added template is locked by default; version refresh is to update the version when it is applied to the template. The current template processing class version will be saved in the local memory of the application. When it is inconsistent with the version in the database, the template processing class will be automatically updated.

[0061] Specifically, the service identifier can be a service name, service number, etc. For example, the service number can be the number of a Category 1 service (such as a payment service) or a Category 2 service (such as a wealth management service). A service operation refers to a specific service action, including payment, transfer, etc.; and service funds include the specific funding direction of the service, which is not limited in this embodiment. Based on the service identifier or service operation in the bill details query request, a funnel query method is used to query the template configuration table, gradually expanding the query scope to obtain the identifier of the target template corresponding to the service parameters.

[0062] For example, when the business parameters in the bill details query request include business identification, business operation, business type, and business funds, a funnel-type query template configuration table is used. First, the template identification corresponding to the business identification, business operation, business type, and business funds in the business parameters is queried from the template configuration table. If it is found, the queried template identification is used as the identification of the target template. If it is not found, a business parameter is deleted, such as deleting business funds. The template corresponding to the business identification, business operation, and business type in the business parameters is queried from the template configuration table. If it is found, the queried template identification is used as the identification of the target template. If it is not found, the query is continued after deleting a business parameter until the identification of the target template is found. Table 1 shows the template configuration table. The template configuration table includes an English alias, template name, lock status, refresh status, business parameters (specifically business operation), and version. If the template identification corresponding to business identification 1 is to be queried, the identification of the target template queried is the template name and English alias of the first template in Table 1.

[0063] Table 1

[0064]

[0065]

[0066] The lock status in Table 1 can be divided into locked and unlocked. Locked is represented by 0 and unlocked is represented by 1. When the lock status is locked 0, the template will not be used by the program. New templates are locked in state 0 by default.

[0067] S340, query the template row mapping configuration table according to the identifier of the target template to obtain row information of each row contained in the target template, the row information includes the row identifier of the corresponding row, the module identifier of the module to which the corresponding row belongs, and the position identifier of the corresponding row in the module to which it belongs.

[0068] The template row mapping configuration table includes the rows included in each template, as well as the position parameters and display parameters of each row.

[0069] Table 2

[0070]

[0071]

[0072] Table 2 shows the template row mapping configuration table. The row name is the row identifier for the corresponding row, the module name represents the module identifier of the module to which the corresponding row belongs, and the row number is the position of the corresponding row within the module. The row numbers in Table 2 are set to ensure the order of rows within the module. The template row mapping configuration table also includes fields such as row text, row value, row style, and row processing code. These fields can be overwritten to override the default processing.

[0073] S350: query the row configuration table according to the row identifier of each row to obtain row display parameters corresponding to each row.

[0074] Among them, the row configuration table contains the row display parameters of each row. Specifically, the row display parameters refer to the parameters that can express the data content and / or display style contained in the row, including: row name, row description, left copy, attribute style, copy style, row value, row value type, row value style and at least one of the row processing code. Furthermore, the row name is used by the front end to identify the specified row for special processing, such as: merchant name, payment amount, transaction amount, etc.; the row description is to facilitate operators to understand its meaning and use, and the program will not use this field; the attribute style refers to the specific style configuration, including color, prefix, h5, etc., and the Map format is convenient for extending attributes; the row value is the data that needs to be displayed, such as basic data, business data, etc.; the row value type is such as: ordinary string, progress bar, barcode, etc. Query the row configuration table according to the row identifier of each row, and obtain the row display parameters corresponding to each row in the row configuration table. The row value type refers to the data format in the template, which can include distinguishing ordinary strings, progress bars, barcodes, etc.; the row processing code specifically refers to the processing code of a certain row. Each processing code corresponds to a processing class, which mainly involves external data acquisition, including calling external interfaces and assembling data from configurations, complex logical judgment and data processing, etc. The embodiment of the present invention does not limit this.

[0075] For example, as shown in Table 3, the specific row display parameters in the row configuration table include left text, row value, value type, and row value style.

[0076] Table 3

[0077]

[0078] S360: Determine the module identifier, position identifier, and row display parameters corresponding to each row as template description data.

[0079] Based on the above embodiment, optionally, after obtaining the template description data of the target template, it also includes: for each row, in response to determining that external data needs to be obtained based on the row display parameters of the current row, obtaining the external data that needs to be displayed in the current row by calling the JSF interface; accordingly, generating bill detail page data based on the bill detail data and the template description data, including: generating bill detail page data based on the bill detail data, template description data and external data.

[0080] Specifically, whether external data needs to be obtained is determined based on the processing code in the row display parameters. One processing code corresponds to one processing class. If it is determined based on the processing code that the current row needs to display external data, the external data is obtained by executing the method function in the processing class corresponding to the processing code.

[0081] Specifically, the external data includes Baitiao installment information, product extended warranty information, Jingdou reward information, Baitiao cash withdrawal related agreements, gold bar repayment details, etc., which are not limited in this embodiment. JSF is a new standard Java service framework interface for building Web applications. It provides a component-centric method for developing Java Web user interfaces and provides an efficient development environment. When external data needs to be obtained, the interface is called to obtain external data, and bill detail data, template description data and external data are required to generate bill detail page data. The advantage of this setting is that more bill data can be flexibly obtained, which improves the flexibility and dynamism in the bill query process.

[0082] Based on the above embodiment, optionally, after obtaining the template description data of the target template, it also includes: for each row, in response to determining that configuration data needs to be obtained based on the row display parameters of the current row, querying the configuration data that needs to be displayed in the current row from the configuration data table; accordingly, generating bill details page data based on the bill details data and the template description data, including: generating bill details page data based on the bill details data, template description data and configuration data.

[0083] Specifically, whether configuration data needs to be obtained is determined based on the processing code parameters in the row display parameters. One processing code corresponds to one processing class. If it is determined based on the processing code that the current row needs to display configuration data, the configuration data is obtained by executing the method function in the processing class corresponding to the processing code. Specifically, the required configuration data can be read from the configuration data table.

[0084] Specifically, the configuration data includes progress bar configuration, merchant name configuration, and external interface configuration. The advantage of such a setting is that more bill data can be flexibly obtained, thereby improving the flexibility and dynamism in the bill query process.

[0085] S370, generating bill details page data based on the bill detail data and the template description data, and sending the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data.

[0086] Specifically, the bill details page data can be HTML page data. Specifically, the FreeMarker template engine can be used to render the bill details data and template description data to obtain the HTML page data. After the bill details page data is generated, the bill details page data is sent to the client and the bill details page is displayed.

[0087] For example, Figure 4 This is a schematic diagram of the bill details page provided in the second embodiment of the present invention. Figure 4 As shown, the displayed bill details page includes four specific modules, headModule top module, bizeModule business information module, basicModule basic information module and othersModule other information module. The specific top module includes information such as merchant name, amount, discount and transaction status; the business information module includes transaction description, payment method, policy number, delivery address, installment status and progress bar and other information; the basic information module includes order number, merchant order number and refund barcode and other information; other information modules include product extended warranty, nearby discounts, Jingdou rewards and other information.

[0088] The technical solution of this embodiment is to receive a bill details query request sent by a client; obtain the bill details data to be displayed from the database according to the bill identifier in the bill details query request; query the template configuration table according to the business parameters in the bill details query request to obtain the identifier of the target template corresponding to the business parameters; query the template row mapping configuration table according to the identifier of the target template to obtain the row information of each row contained in the target template; query the row configuration table according to the row identifier of each row to obtain the row display parameters corresponding to each row; determine the module identifier, position identifier and row display parameters corresponding to each row as template description data; generate bill details page data based on the bill details data and the template description data, and send the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data, which solves the problem of poor flexibility of business bills, realizes unified management of bill data of each business, displays the bill details page according to the template description data, reduces resource costs, and improves the flexibility, efficiency and reliability of querying bill data.

[0089] Example 3

[0090] Figure 5This is a flowchart of a method for querying bill data in Example 3 of the present invention. This embodiment is optimized based on the above embodiment. In this embodiment, further optimization is performed before receiving a bill details query request sent by the client.

[0091] like Figure 5 As shown, the method of this embodiment specifically includes the following steps:

[0092] S510: Receive a bill query request sent by a client.

[0093] S520: Determine the target business corresponding to the source identifier in the bill query request.

[0094] Different services correspond to different business types, including payment services, wealth management services, insurance services, and consumer finance services. A correspondence between source identifiers and business identifiers can be pre-set, where the same source identifier can correspond to the same or different business identifiers. Upon receiving a bill query request from a client, the target business corresponding to the source identifier in the bill query request can be determined based on this correspondence.

[0095] Specifically, the target business corresponding to the source identifier includes all businesses or a preset portion of businesses. Based on the specific source identifier in the bill query request, the target business corresponding to the source identifier is determined. For example, when it is confirmed that the source identifier in the bill query request is APP1, the target business corresponding to APP1 can be a payment business.

[0096] S530: Obtain bill summary data of the target service corresponding to the user identifier in the bill query request, and generate a bill list based on the obtained bill summary data.

[0097] Specifically, after obtaining each bill summary data corresponding to the user ID in the bill query request of the target service, a bill list including each bill summary data is generated.

[0098] For example, Figure 6 This is a schematic diagram of a bill list in the third embodiment of the present invention, such as Figure 6 As shown, a bill list is displayed, which includes multiple bill summary data. Each bill summary data includes a merchant icon, a bill name (such as mobile phone recharge-expense) and a bill amount.

[0099] S540: Send the bill list to the client, so that the client can display the bill list.

[0100] Specifically, after obtaining the bill list, the system sends the bill list to the client and displays it visually. The user can click on one of the bill summary data to trigger a subsequent bill detail query request.

[0101] S550: Receive a bill details query request sent by the client.

[0102] S560: Obtain detailed bill data to be displayed from the database according to the bill identifier in the bill details query request.

[0103] S570: Select a target template for displaying the bill details data according to the business parameters in the bill details query request, and obtain template description data of the target template.

[0104] S580 , generating bill detail page data based on the bill detail data and the template description data, and sending the bill detail page data to the client, so that the client generates and displays a bill detail page based on the bill detail page data.

[0105] The technical solution of this embodiment is to receive a bill query request sent by a client; obtain bill summary data of the target business corresponding to the user identifier in the bill query request, and generate a bill list based on the obtained bill summary data; and send the bill list to the client so that the client can display the bill list, which can accurately determine the bill query request and improve the efficiency of the bill query.

[0106] Example 4

[0107] Figure 7 This is a schematic diagram of the structure of a bill data query device in the fourth embodiment of the present invention. This embodiment is applicable to the case of querying and displaying bill details. The device can be implemented in software and / or hardware. The device can be integrated into any device that provides the function of querying bill data, such as Figure 7 As shown, the bill data query device specifically includes: a request receiving module 710, a data acquisition module 720, a model selection module 730 and a page display module 740.

[0108] Request receiving module 710, for receiving a bill details query request sent by a client;

[0109] The data acquisition module 720 is used to acquire the bill details data to be displayed from the database according to the bill identifier in the bill details query request;

[0110] The model selection module 730 is used to select a target template for displaying bill details according to the business parameters in the bill details query request and obtain template description data of the target template;

[0111] The page display module 740 is used to generate bill detail page data based on the bill detail data and template description data, and send the bill detail page data to the client, so that the client generates and displays the bill detail page based on the bill detail page data.

[0112] Optionally, the model selection module 730 is specifically used to: query the template configuration table according to the business parameters in the bill details query request to obtain the identifier of the target template corresponding to the business parameters; wherein the business parameters include at least one of the business identifier, business operation, business type and business funds.

[0113] Optionally, the model selection module 730 is specifically used to: query the template row mapping configuration table according to the identifier of the target template to obtain the row information of each row contained in the target template, the row information including the row identifier of the corresponding row, the module identifier of the module to which the corresponding row belongs, and the position identifier of the corresponding row in the module to which it belongs; query the row configuration table according to the row identifier of each row to obtain the row display parameters corresponding to each row; determine the module identifier, position identifier and row display parameters corresponding to each row as template description data.

[0114] Optionally, the device also includes an external data acquisition module, which is used to: for each row, in response to determining that external data needs to be obtained based on the row display parameters of the current row, obtain the external data that needs to be displayed in the current row by calling the JSF interface; accordingly, the page display module 740 is specifically used to: generate bill detail page data based on bill detail data, template description data and external data.

[0115] Optionally, the device also includes a configuration data acquisition module, which is used to: for each row, in response to determining that configuration data needs to be acquired based on the row display parameters of the current row, query the configuration data that needs to be displayed in the current row from the configuration data table; accordingly, the page display module 740 is specifically used to: generate bill details page data based on bill detail data, template description data and configuration data.

[0116] Optionally, the device also includes an identification verification module, which is used to: read the source identification in the bill details query request; wherein the source identification represents the application entry that triggers the bill details query request; verify the legitimacy of the source identification, and after the verification passes, trigger the execution of an operation to obtain the bill details data to be displayed from the database according to the bill identification in the bill details query request.

[0117] Optionally, the device also includes a list display module, which is used to: receive a bill query request sent by the client; determine the target business corresponding to the source identifier in the bill query request; obtain the bill summary data of the target business corresponding to the user identifier in the bill query request, and generate a bill list based on the obtained bill summary data; send the bill list to the client so that the client can display the bill list.

[0118] Optionally, the target business corresponding to the source identifier includes all businesses or a preset portion of businesses.

[0119] Optionally, the device also includes a local cache module, which is used to: periodically obtain the latest version number of the template from the remote distributed cache system; obtain the configuration information of the latest version of the template from the database; in response to the inconsistency between the configuration information of the template in the local cache and the configuration information obtained from the database, summarize and process the relevant data of the configuration information of the template in the local cache based on the configuration information obtained from the database and then put it into the local cache; store the configuration information of the locally cached template and the version number of the template in the remote distributed cache system.

[0120] Optionally, the client is an e-commerce application installed on the user terminal, and the billing identifier includes the bill number; or, the client is a business application installed in the business system, and the billing identifier includes the user's personal identification code and the business order number.

[0121] The above-mentioned product can execute the method provided by any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0122] The technical solution of this embodiment is to receive a bill details query request sent by a client; obtain the bill details data to be displayed from the database according to the bill identifier in the bill details query request; select the target template used to display the bill details data according to the business parameters in the bill details query request, and obtain the template description data of the target template; generate bill details page data based on the bill details data and the template description data, and send the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data, thereby solving the problem of poor flexibility of business bills, realizing unified management of the bill data of each business, displaying the bill details page according to the template description data, reducing resource costs, and improving the flexibility, efficiency and reliability of querying bill data.

[0123] Example 5

[0124] Figure 8 This is a framework diagram of a bill data query system in Example 5 of the present invention. Figure 8As shown, the system includes a client 810, a JSF interface 820, a template configuration module 830, a template data generation engine 840, a data storage module 850, a template synchronization module 860, and a support module 870. Among them, the JSF interface 820, the template configuration module 830, the template data generation engine 840, the data storage module 850, the template synchronization module (i.e., the template worker) 860, and the support module 870 belong to the server.

[0125] Client 810 is used to send a bill details query request. Client 810 is an e-commerce application installed on the user terminal, and the bill identifier includes the bill number; or, client 810 is a business application installed in the business system, and the bill identifier includes the user's personal identification code and the business order number.

[0126] Client 810 sends a bill details query request to the server by calling JSF interface 820. Specifically, when client 810 is an e-commerce application installed on a user terminal, it sends the bill details query request to the server by calling the internal bill details interface in JSF interface 820. When client 810 is a business application installed in a business system, it sends the bill details query request to the server by calling the third-party query details interface in JSF interface 820.

[0127] The template configuration module 830 is used to configure the template configuration table, the row configuration table and the template row mapping configuration table.

[0128] The template data generation engine 840 is used to perform specific operations on the data, including a data query and verification module 910, a template processor selection module 920, a data preprocessing module 930, an external data preparation module 940, a template rendering data filling module 950, and a post-verification and adjustment module 960.

[0129] The data storage module 850 is used to store specific data of the bill, including database transaction basic data, database business data, configuration data and external data. Each type of data can be stored using a different data table.

[0130] Template synchronization module 860 is used to update the template in the local cache to ensure that the template version in the local cache is consistent with the template version in the database. Specifically, it periodically obtains the latest template version number from the remote distributed cache system and the latest template configuration information from the database. The template configuration information in the local cache is compared with the configuration information obtained from the database. If there is any inconsistency, the template configuration information in the local cache is aggregated and processed based on the configuration information obtained from the database, and then stored in the local cache. The template configuration information and the template version number in the local cache are then stored in the remote distributed cache system.

[0131] The support module 870 is used to provide support functions for the configuration of the template, so that users can configure the content that needs to be displayed in the template through the support module, including progress bar configuration, merchant icon configuration, merchant name configuration, external link red dot configuration and external interface configuration, etc.

[0132] Specifically, the template data generation engine 840 includes a data query and verification module 910 , a template processor selection module 920 , a data preprocessing module 930 , an external data preparation module 940 , a template rendering data filling module 950 , and a post-verification and adjustment module 860 . Figure 9 This is a schematic diagram of a specific module of the template data generation engine provided in the fifth embodiment of the present invention. Figure 9 As shown,

[0133] The data query and verification module 910 is used to query and obtain bill detail data from the database according to the bill identifier in the bill detail query request. The bill detail data includes business data and basic data.

[0134] The template processor selection module 920 is used to select a target template for displaying the bill detail data according to the business parameters in the bill detail query request, and obtain template description data of the target template.

[0135] The data pre-processing module 930 is used to fill the bill detail data into the target template.

[0136] The external data preparation module 940 is used to determine whether external data and configuration data need to be queried for each row in the target template based on the row display parameters of the row. If necessary, external data is obtained by calling the JSF interface and configuration data is queried from the configuration data table.

[0137] The template rendering data filling module 950 is used to generate bill detail page data based on the target template, the template description data of the target template, the queried bill detail data, external data and configuration data, and then send it to the client.

[0138] The post-verification and adjustment module 960 is used to verify whether the data on the generated bill details page can be displayed normally. If not, an error will be reported and manual processing will be performed.

[0139] The technical solution of this embodiment solves the problem of poor flexibility of business bills by receiving a bill details query request sent by the client, generating and displaying a bill details page based on the bill details page data, and realizing unified management of the bill data of each business. The bill details page is displayed according to the template description data, which reduces resource costs and improves the flexibility, efficiency and reliability of querying bill data.

[0140] Example 6

[0141] Figure 10 It is a structural diagram of a computer device in embodiment 6 of the present invention. Figure 10 A block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention is shown. Figure 10 The computer device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0142] like Figure 10 As shown, computer device 12 is implemented as a general-purpose computing device. Components of computer device 12 may include, but are not limited to, one or more processors or processing units 16, system memory 28, and a bus 18 that connects various system components (including system memory 28 and processing unit 16).

[0143] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, or a local bus using any of a variety of bus architectures. Examples of these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

[0144] The computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0145] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be configured to read and write non-removable, non-volatile magnetic media. Although Figure 10 Not shown in the figure are disk drives for reading and writing to removable non-volatile disks (e.g., floppy disks), and optical drives for reading and writing to removable non-volatile optical disks (e.g., CD-ROMs, DVD-ROMs, or other optical media). In these cases, each drive can be connected to bus 18 via one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of various embodiments of the present invention.

[0146] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28. Such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may include an implementation of a network environment. Program modules 42 generally perform the functions and / or methodologies of the embodiments described herein.

[0147] The computer device 12 can also communicate with one or more external devices 14 (e.g., a keyboard, a pointing device, a display 24, etc.), one or more devices that enable a user to interact with the computer device 12, and / or any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., a network card, a modem, etc.). This communication can be performed via an input / output (I / O) interface 22. In addition, in the computer device 12 of this embodiment, the display 24 is not a separate entity, but is embedded in the mirror surface. When the display surface of the display 24 is not displayed, the display surface of the display 24 and the mirror surface are visually integrated. Furthermore, the computer device 12 can also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 20. As shown in the figure, the network adapter 20 communicates with other modules of the computer device 12 via a bus 18. It should be understood that although not shown in the figures, other hardware and / or software modules may be used in conjunction with the computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0148] The processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, such as implementing the bill data query method provided in the embodiment of the present invention.

[0149] Example 7

[0150] Embodiment 7 of the present invention provides a computer-readable storage medium having a computer program stored thereon. When the program is executed by a processor, the method for querying bill data as provided in all the embodiments of the invention of this application is implemented: receiving a bill details query request sent by a client; obtaining the bill details data to be displayed from a database according to the bill identifier in the bill details query request; selecting a target template for displaying the bill details data according to the business parameters in the bill details query request, and obtaining template description data of the target template; generating bill details page data based on the bill details data and the template description data, and sending the bill details page data to the client, so that the client generates and displays the bill details page based on the bill details page data.

[0151] Any combination of one or more computer-readable media can be used. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example, but not limited to, a system, device or component of electricity, magnetism, light, electromagnetic, infrared, or semiconductors, or any combination thereof. More specific examples (non-exhaustive list) of computer-readable storage media 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 thereof. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by an instruction execution system, device or device or used in combination with it.

[0152] A computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, which carries computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0153] Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0154] The computer program code for performing the operations of the present invention can be written in one or more programming languages, or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0155] Note that the above are only preferred embodiments of the present invention and the technical principles employed. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments, and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments and may include many other equivalent embodiments without departing from the concept of the present invention. The scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method for querying bill data, characterized in that: include: Receive bill details query request sent by the client; Obtaining the bill details to be displayed from the database according to the bill identifier in the bill details query request; Selecting a target template for displaying bill detail data according to the business parameters in the bill detail query request, and obtaining template description data of the target template; generating bill details page data based on the bill detail data and the template description data, and sending the bill details page data to the client, so that the client generates and displays a bill details page based on the bill details page data; The acquiring of the template description data of the target template includes: Querying a template row mapping configuration table according to the identifier of the target template to obtain row information of each row included in the target template, wherein the row information includes a row identifier of the corresponding row, a module identifier of a module to which the corresponding row belongs, and a position identifier of the corresponding row in the module to which it belongs; Querying a row configuration table according to the row identifiers of the rows to obtain row display parameters corresponding to the rows; The module identifier, position identifier and row display parameters respectively corresponding to each row are determined as template description data; wherein the row display parameters include parameters expressing the row display style.

2. The method according to claim 1, characterized in that The selecting of a target template for displaying the bill details data according to the business parameters in the bill details query request includes: The template configuration table is queried according to the business parameters in the bill details query request to obtain the identifier of the target template corresponding to the business parameters; wherein the business parameters include at least one of a business identifier, a business operation, a business type, and a business fund.

3. The method according to claim 1, characterized in that After obtaining the template description data of the target template, the method further includes: For each of the rows, in response to determining that external data needs to be obtained according to the row display parameters of the current row, obtaining the external data required to be displayed in the current row by calling a Java service framework JSF interface; The generating of bill details page data based on the bill detail data and the template description data includes: Generate bill details page data based on the bill detail data, the template description data and the external data.

4. The method according to claim 1, wherein After obtaining the template description data of the target template, the method further includes: For each of the rows, in response to determining that configuration data needs to be acquired according to the row display parameters of the current row, querying the configuration data table for the configuration data that needs to be displayed in the current row; The generating of bill details page data based on the bill detail data and the template description data includes: Generate bill details page data based on the bill detail data, the template description data and the configuration data.

5. The method according to claim 1, wherein Before acquiring the bill details to be displayed from the database according to the bill identifier in the bill details query request, the method further includes: Reading a source identifier in the bill details query request; wherein the source identifier indicates an application entry that triggers the bill details query request; The legitimacy of the source identifier is verified, and after the verification passes, an operation of obtaining the bill detail data to be displayed from the database according to the bill identifier in the bill detail query request is triggered.

6. The method according to claim 1, characterized in that Before receiving the bill details query request sent by the client, the method further includes: Receive bill query requests sent by the client; Determining a target business corresponding to the source identifier in the bill query request; Obtaining bill summary data of the target service corresponding to the user identifier in the bill query request, and generating a bill list based on each of the obtained bill summary data; The bill list is sent to the client, so that the client displays the bill list.

7. The method according to claim 6, characterized in that The target business corresponding to the source identifier includes all businesses or a preset part of businesses.

8. The method according to claim 1, characterized in that The method further comprises: Regularly obtain the latest version of the template from the remote distributed cache system; Get the latest version of the template configuration information from the database; In response to a comparison result that the configuration information of the template in the local cache is inconsistent with the configuration information obtained from the database, the configuration information of the template in the local cache is aggregated and processed based on the configuration information obtained from the database and then stored in the local cache; The configuration information of the locally cached template and the template version number are stored in the remote distributed cache system.

9. The method according to any one of claims 1 to 8, characterized in that The client is an e-commerce application installed on the user terminal, and the bill identifier includes a bill number; or The client is a business application installed in the business system, and the bill identifier includes a user's personal identification code and a business order number.

10. A device for querying bill data, characterized in that: include: Request receiving module, used to receive bill details query request sent by the client; A data acquisition module, configured to acquire the bill details to be displayed from a database according to the bill identifier in the bill details query request; A model selection module, configured to select a target template for displaying bill detail data according to the business parameters in the bill detail query request, and obtain template description data of the target template; a page display module, configured to generate bill detail page data based on the bill detail data and the template description data, and send the bill detail page data to the client, so that the client generates and displays a bill detail page based on the bill detail page data; The model selection module is specifically used to: query the template row mapping configuration table according to the identifier of the target template to obtain row information of each row contained in the target template, where the row information includes the row identifier of the corresponding row, the module identifier of the module to which the corresponding row belongs, and the position identifier of the corresponding row in the module to which it belongs; query the row configuration table according to the row identifier of each row to obtain row display parameters corresponding to each row; determine the module identifier, position identifier, and row display parameters corresponding to each row as template description data; wherein the row display parameters include parameters expressing the row display style.

11. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the method for querying bill data according to any one of claims 1 to 9 is implemented.

12. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the bill data query method according to any one of claims 1 to 9 is implemented.

Citation Information

Patent Citations

  • Configurable form generation device and form generation method

    CN103218417A

  • Method and system for showing data table

    CN105205071A