WO2020047840A1

WO2020047840A1 - Bill information caching method, bill information query method and terminal device

Info

Publication number: WO2020047840A1
Application number: PCT/CN2018/104602
Authority: WO
Inventors: 周诗松; 姚伟
Original assignee: 威富通科技有限公司
Priority date: 2018-09-07
Filing date: 2018-09-07
Publication date: 2020-03-12
Also published as: CN109313642A; CN109313642B

Abstract

The present application is applicable to the technical field of data query, and provides a bill information caching method, a bill query method and a terminal device, comprising: querying whether there is data in a cache when a user side sends a bill query request; if not, determining whether the number of transactions of a user on the day of query reaches a preset number of transactions, and if so, carrying out bill pagination on transactions according to the number of transactions and a preset number of transactions on each page, determining transaction time information of each page of bill and storing same in a cache; and if not, acquiring daily settlement data on a preset day closest to the day of query, carrying out bill pagination according to the daily settlement data and the preset number of transactions on each page, determining transaction time information of each page of bill and storing same into the cache, when the user queries the bill, determining a time span of a transaction bill of the user according to the data in the cache, and further querying account statement data of the bill of the user according to the time span. The present application is simple and rapid, reduces the bill database query load pressure and increases the query speed.

Description

Billing information buffering method, billing information query method, and terminal device

Technical field

The present application belongs to the technical field of data query, and particularly relates to a billing information buffering method, a billing information querying method, and a terminal device.

Background technique

In the prior art, each time a user trades a bill, the transaction information is stored in the billing database. When the bill is queried, all the transaction information in the billing database is summarized, and then the page information is displayed and displayed in real time. However, when the billing database caches transaction information, it simply sorts the cache based on the time of the transaction or the amount of the transaction. When querying the bill, it directly accesses all the transaction information in the billing database, which puts great pressure on the billing database and even causes the query service to fail to complete. A large number of concurrent queries may cause the system to crash.

technical problem

In view of this, embodiments of the present application provide a method for billing information caching, a method for querying billing information, and a terminal device, so as to solve the huge pressure on the billing database when the billing query in the prior art is caused. System crash problem ...

Technical solutions

A first aspect of the embodiments of the present application provides a method for buffering bill information, including:

When receiving the bill query request sent by the client, query whether there is data in the cache;

If there is no data in the cache, obtaining a user's query for the number of transactions of the day, and determining whether the number of transactions reaches a preset number of transactions;

If the number of transactions reaches the preset number of transactions, according to the number of transactions and the preset number of transactions per page, perform pagination of bills on the day of the user's query, and determine the billing of each page according to the results Transaction time information, and storing paged results and transaction time information for each page of bills into the cache;

If the number of transactions does not reach the preset number of transactions, the day-end data of the preset day closest to the query day is obtained from the preset day-end data table according to the identity of the user, and according to the acquired Day-end data and the preset number of transactions per page, pagination of bills for the preset day's transactions closest to the query day of the user, determining the transaction time information of each page of the bill based on the results of the paging, and dividing the paged results with The transaction time information of each page of bills is stored in the cache, wherein a piece of daily settlement data includes the number of transactions per day of the user.

A second aspect of the embodiments of the present application provides a bill query method based on the bill information cache method of the foregoing embodiment, including:

When receiving the bill query request sent by the client, determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill;

Obtaining the daily settlement data of the user from a preset daily settlement data table according to the time span of the bill per page;

Query the per-page flow data corresponding to the user and the date of each page flow based on the user's day-end data.

A third aspect of the embodiments of the present application provides a billing information buffering device, including:

A request query module is used to query whether there is data in the cache when a bill query request sent by a user terminal is received;

A transaction determining module, configured to obtain, if there is no data in the cache, a user querying the number of transactions on the day, and determining whether the number of transactions reaches a preset number of transactions;

An information buffer module, configured to: if the number of transactions reaches the preset number of transactions, perform pagination of bills on the transaction of the user's query on the basis of the number of transactions and the preset number of transactions per page, and The result determines the transaction time information of each page of the bill, and stores the paged result and the transaction time information of each page of the bill into the cache;

The information caching module is further configured to: if the number of transactions does not reach the preset number of transactions, obtain a date of a preset day closest to the query day from the preset day-end data table according to the identity of the user; Settle the data, and based on the obtained daily settlement data and the preset number of transactions per page, perform billing pagination on the preset day's transactions closest to the query day of the user, and determine the transaction time of each page of bills based on the paged results Information, and store the paged results and transaction time information of each page of bills into the cache, where a day-end data includes the number of transactions per day of the user.

A fourth aspect of the embodiments of the present application provides a bill query device based on the bill information cache device of the foregoing embodiment, including:

A time determination module is used to determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill when the bill query request sent by the user is received;

A data acquisition module, configured to acquire daily settlement data of the user from a preset daily settlement data table according to a time span of the bill of each page;

The flow query module is configured to query the flow data of each page corresponding to the user and the date on which the flow of each page is located according to the daily settlement data of the user.

A fifth aspect of the embodiments of the present application provides a terminal device including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, Implement the steps of the billing information caching method as described above.

According to a sixth aspect of the embodiments of the present application, a computer-readable storage medium is provided. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the billing information caching method described above are implemented.

Beneficial effect

In the embodiment of the present application, when the client sends a bill query request, it first queries whether there is data in the cache. If there is no data in the cache, it is determined whether the number of transactions on the user ’s query day reaches the preset number of transactions. The number of transactions and the preset number of transactions per page paginate the transactions and determine the transaction time information of each page of the bill, and store the paged results and the transaction time information of each page of the bill into the cache; if it does not reach, obtain the nearest Set the day-to-day data, perform billing based on the day-to-day data and the preset number of transactions per page, and determine the transaction time information of each page of the bill. The paged results and transaction time information of each page of the bill are stored in the cache. The number of transactions is first cached on the billing information. When a user queries the bill, the time span of the user's transaction bill is determined based on the data in the cache, and the user's billing data is further queried based on the time span. To ensure the successful completion of the query service, which improves the query speed. A large amount of time to avoid system crashes.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a schematic flowchart of an implementation of a billing information caching method provided by an embodiment of the present application;

FIG. 2 is a schematic flowchart of the implementation of step S103 in FIG. 1;

FIG. 3 is a schematic flowchart of an implementation of a bill query method according to an embodiment of the present application; FIG.

4 is a schematic structural diagram of a billing information buffering device provided by an embodiment of the present application;

5 is a schematic structural diagram of a bill inquiry device according to an embodiment of the present application;

FIG. 6 is a schematic diagram of a terminal device according to an embodiment of the present application.

Embodiments of the invention

In order to explain the technical solution described in this application, specific examples are used for description below.

Example one

Referring to FIG. 1, a schematic flowchart of implementation of a method for billing information caching is provided. In this embodiment, an angle trigger of a terminal is used as an example for description. Here, the terminal may be a mobile terminal such as a smart phone or a tablet computer. As shown in FIG. 1, in this embodiment, the processing process of the terminal may include the following steps:

Step S101: when receiving a bill query request sent by a user terminal, query whether there is data in the cache.

Wherein, the data refers to a paged result and transaction time information of each page of the bill, which are obtained according to the number of transactions on the day of the user's query or the day-end data of a preset day closest to the day of the query.

Specifically, in this embodiment, when the user terminal sends a bill query request, the terminal first queries whether there is user data in the cache. If there is data, it directly obtains the total transaction information of the user's query on the basis of the data in the cache and the user's identity. , Or directly obtain the day-end data of the preset day closest to the query day in the preset day-end data table based on the data in the cache and the user ’s identity, and display the total transaction information for the day or the day-end data of the preset day In the query bill, for the current user to view, the query speed is improved.

In step S102, if there is no data in the cache, the user queries the number of transactions for the current day, and determines whether the number of transactions reaches the preset number of transactions.

Specifically, the determination of whether the number of transactions reaches the preset number of transactions is to first determine whether the user queries whether there is a transaction on the day, and if there is a transaction, the current bill query conditions are met, and according to the number of transactions and The preset number of transactions per page performs pagination of the bills on the day of the user's query. If there is no transaction, it means that the number of transactions on the day of the query does not meet the current bill query conditions. Get the day-end data of the preset day closest to the query day in the end-data table.

Exemplarily, the client sends a bill query request on August 20, and there is no data in the cache, then the user's transaction number on August 20 is obtained, the transaction number is 6 and the preset transaction number is 2 transactions, if the number of transactions reaches the preset number of transactions, billing pagination of transactions on the day of the user's query is performed according to the number of transactions and the preset number of transactions per page.

Exemplarily, the client sends a bill query request on August 20, and there is no data in the cache, then the transaction number of the user on August 20 is obtained. The transaction number is 2 and the preset transaction number is 5, if the number of transactions does not reach the preset number of transactions, the day-end data of the preset day closest to the query day is obtained from the preset day-end data table according to the identity of the user, for example, from Get the day-end data in the preset day-end data table for the 8 days closest to the query day.

In step S103, if the number of transactions reaches the preset number of transactions, then according to the number of transactions and the preset number of transactions per page, perform billing pagination on the transactions of the user's query day, and determine each Page transaction time information, and paged results and transaction time information of each page bill are stored in the cache.

Specifically, the paged results and transaction time information of each page of bills are stored in the cache, so that when a user initiates a bill query request again, he can directly obtain the data in the cache (paged results and transaction time information of each page of bills). The transaction information of the users in the daily settlement database does not need to access the entire billing database, which improves the query speed of the bill and reduces the pressure on the billing database.

Among them, each transaction includes the transaction time, and can also include the transaction amount.

In another embodiment, referring to FIG. 2, in step S103, according to the number of transactions and a preset number of transactions per page, perform billing pagination on the transaction of the user's query day, and determine the transaction of each page of billing according to the paging results. The specific implementation process of time information includes:

Step S201, according to the expression pageCount = (orderCount- pageSize)% pageSize + 1, pagination of bills for transactions on the day of the user's query, where pageCount is a pageable number, orderCount is the number of transactions, and pageSize is the preset number of transactions per page.

Specifically, the difference between the number of transactions minus the preset number of transactions per page is divided by the preset number of transactions per page, and the resulting quotient is rounded up by one and finally the pageable number is obtained.

Exemplarily, the number of transactions is 95, the preset number of transactions per page is 20, the quotient obtained is 3.75, the quotient is rounded and rounded, and 1 is added to obtain a pageable number of 5 pages.

Step S202: Determine the transaction time information of each page of the bill according to the pageable number and the transaction time of each transaction.

The transaction time information of each page of the bill may include the start transaction time and the last transaction time of each page of the bill, that is, each page of the bill includes the start transaction time point and the end transaction time point.

Specifically, each transaction is allocated to a pageable bill according to a preset number of transactions per page. After the allocation is completed, the start time and end of each page of the bill can be determined according to the transaction time of each transaction in the bill of each page. Trading point in time.

Exemplarily, the client sends a bill query request on August 20th, and there is no data in the cache, then the transaction number of the user on August 20th is obtained, and the transaction number reaches the preset transaction number, according to the The number of transactions and the preset number of transactions per page are used to perform pagination of the transactions on the day of the user's query. For example, the number of transactions on August 20 is 36, the default number of transactions per page is 10, and the pageable number is 4 pages. 36 transactions are allocated to 4 pages of bills according to the preset number of transactions per page. At this time, each page of the bill includes the time point of starting the transaction and the time point of ending the transaction.

Step 104: if the number of transactions does not reach the preset number of transactions, obtain the day-end data of the preset day closest to the query day from the preset day-end data table according to the identity of the user, and According to the obtained daily settlement data and the preset number of transactions per page, perform billing pagination on the preset day's transactions closest to the query day of the user, determine the transaction time information of each page of bills based on the paged results, and Paging results and transaction time information for each page of bills are stored in the cache, where a piece of daily settlement data includes the number of transactions per day of the user.

The day-end data of the preset day closest to the query day includes the number of transactions per day in the preset day. Specifically, the obtained daily settlement data of the preset days is summarized, that is, the total number of transactions of the preset days is obtained, and according to the total number of transactions of the preset days and the preset number of transactions per page, the user is The transactions on the preset day closest to the query day are billed by page.

Wherein, the setting of the preset day may be obtained by accumulating according to the query interval of the user's multiple query. For example, if the user frequently inquires the bill for the last 5 days, the user can automatically set the preset day to 5 days when he initiates the query request.

In another embodiment, the billing information caching method further includes:

The daily transaction number of each user is summarized after the daily cut, and the daily settlement data of each user is generated according to the transaction number of the previous day of each user and stored in the preset daily settlement data table.

Specifically, the daily transaction number of each user is stored in the preset daily settlement data table in units of daily settlement data, that is, the daily transaction number of each user is stored as one daily settlement data. Optionally, the daily settlement data may also include information on each transaction of the user per day, such as the transaction time and transaction amount of each transaction.

In the above billing information buffering method, when a client sends a billing query request, it first queries whether there is data in the buffer. If there is no data in the buffer, it is determined whether the number of transactions on the user's query day reaches a preset number of transactions. The number of transactions and the preset number of transactions per page paginate the transaction and determine the transaction time information of each page of the bill, and store the paged results and the transaction time information of each page of the bill in the cache; if not, obtain the closest Set the daily settlement data for a preset day, perform billing based on the daily settlement data and the preset number of transactions per page, and determine the transaction time information for each page of the bill. The paged results and the transaction time information for each page of the bill are stored in the cache. The number of transactions is first cached for billing information. When the user queries the bill, the time span of the user's transaction bill is determined based on the data in the cache, and the user's billing flow data is further queried according to the time span. Pressure to ensure the successful completion of the query service and increase the query speed, When large queries concurrently to avoid system crashes.

Example two

Referring to FIG. 3, this embodiment provides a bill query method based on the bill information caching method in the foregoing embodiment. The specific process is as follows:

In step S301, upon receiving the bill query request sent by the user terminal, the time span of the bill of each page of the user transaction is determined according to the paged results in the cache and the transaction time information of the bill of each page.

In the prior art, the query of bills is based on the current user ID. In all scenarios, the user can check the billing data of the user at all times, which will cause great pressure on the billing database, reduce the query speed, and even cause the query service to be completed. When multiple users query at the same time, it may cause the system to crash. Therefore, this implementation scans the user transaction information in the preset day-end data table according to the paged results in the cache and the transaction time information of each page of the bill, reducing the amount of data scanned per query, reducing the load pressure of the database paging query, and greatly Improved query performance.

Specifically, the transaction time information of each page of the bill may include the starting transaction time and the last transaction time of each page of the bill, that is, each page of the bill includes the starting transaction time point and the ending transaction time point. According to the starting transaction of each page of the bill, The time point and the end time of the transaction determine the time span of each page of the user's transaction.

Step S302: Acquire the daily settlement data of the user from a preset daily settlement data table according to the time span of the bill of each page.

Step S303: Query the per-page flow data corresponding to the user and the date of each page flow based on the user's day-end data.

Specifically, the flow data of each page corresponding to the user is determined according to the daily settlement data of the user, for example, the transaction amount and transaction route of each transaction, and the transaction time of each transaction is determined, so that the user can query the bill At the same time, understand your current transaction situation.

Determine the time span of the bill based on the number of users' transactions, and obtain the user's daily settlement data in the preset daily settlement data table based on the time span, which is faster than directly displaying all transactions by page in the prior art. For a long time, if the number of bills displayed on each page is the same, the user may need to repeatedly switch pages. In this embodiment, the number of bills displayed on each page is set according to the time span of each page, which reduces the amount of data scanned per query and reduces database paging. Query load pressure, while increasing the user's query experience.

In another embodiment, the bill query method further includes:

Display the flow data of each page and the date on which each flow of pages is displayed in a flow statement.

Specifically, the number of transactions in each page of the bill may be different, so each transaction in each page of the bill can be sorted according to the transaction time, so that the user can see it at a glance when viewing the bill.

Optionally, each transaction in each page of the bill can also be sorted by the transaction amount.

In actual applications, users may want to know more about the amount of money when querying the bill. Then, each transaction in each page of the bill can be sorted according to the transaction amount, so that the user can see at a glance what time he is at The amount of segment transactions is relatively large, increasing the user experience.

In the above bill query method, when receiving a bill query request sent by a client, the time span of each page of the bill is determined by the paged results in the cache and the transaction time information of each page of the bill, and then based on the time of each page of the bill The span obtains the user's day-end data from the preset day-end data table, and finally queries the user's per-page flow data and the date of each page's flow based on the day-end data, reducing the amount of data scanned per query and the database. Pagination query load pressure greatly improves query efficiency.

Those skilled in the art can understand that the size of the sequence numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not deal with the implementation process of the embodiment of the present invention. Constitute any limitation.

Example three

This embodiment provides another bill query method. The specific process is as follows:

When receiving the bill query request sent by the client, query whether there is data in the cache.

If there is no data in the cache, the user queries the number of transactions for the current day, and determines whether the number of transactions reaches the preset number of transactions.

If the number of transactions reaches the preset number of transactions, according to the number of transactions and the preset number of transactions per page, perform pagination of bills on the day of the user's query, and determine the billing of each page according to the results of the paging. Transaction time information, and storing the paged results and transaction time information of each page of bills into the cache.

When a user queries, the time span of each page of the user's transaction is determined according to the paged results in the cache and the transaction time information of each page of the bill.

Acquiring the daily settlement data of the user from a preset daily settlement data table according to the time span of the bill of each page.

In the above bill query method, the billing information is first cached according to the number of transactions of the user, and the day-end data in the preset day-end data table is directly obtained during the query based on the paged results in the cache and the transaction time information of each page of the bill. , Reduce the amount of data scanned per query, reduce the load on the billing database query load, improve the query speed, and greatly improve the query efficiency.

Embodiment 4

Corresponding to the billing information buffering method described in the first embodiment above, FIG. 4 shows a structural block diagram of the billing information buffering device in this embodiment. For convenience of explanation, only the parts related to this embodiment are shown.

The device includes a request query module 110, a transaction determination module 120, and an information cache module 130.

The request querying module 110 is configured to query whether there is data in the cache when a billing query request sent by a user terminal is received.

The transaction determining module 120 is configured to obtain the number of transactions of a user's query on the day if there is no data in the cache, and determine whether the number of transactions reaches a preset number of transactions.

The information buffering module 130 is configured to: if the number of transactions reaches the preset number of transactions, perform pagination of bills on the transaction of the user's query on the basis of the number of transactions and the preset number of transactions per page, and As a result, the transaction time information of each page of bills is determined, and the paging results and the transaction time information of each page of bills are stored in the cache.

The information caching module 130 is further configured to obtain, from the preset day-end data table, the day closest to the query day if the number of transactions does not reach the preset number of transactions, according to the identity of the user. Settle the data, and based on the obtained daily settlement data and the preset number of transactions per page, perform billing pagination on the preset day's transactions closest to the query day of the user, and determine the transaction time of each page of bills based on the paged results Information, and store the paged results and transaction time information of each page of bills into the cache, where a day-end data includes the number of transactions per day of the user.

Optionally, the device further includes: a daily settlement summary module.

The daily settlement summary module is used to summarize the number of transactions of the previous day for each user after the daily cut, and generate the daily settlement data of each user based on the number of transactions of the previous day for each user and store them in the preset day settlement. Data sheet.

In the above-mentioned billing information buffering device, the requesting query module 110 first checks whether there is data in the buffer. If there is no data in the buffer, the transaction determining module 120 determines whether the number of transactions on the user's query day reaches the preset number of transactions. Module 130 paginates the transactions according to the number of transactions and the preset number of transactions per page and determines the transaction time information of each page of the bill, and stores the paged results and the transaction time information of each page of the bill into the cache; if not, the information cache module 130 Obtain the daily settlement data of the preset day closest to the query day, perform billing based on the daily settlement data and the preset number of transactions per page, and determine the transaction time information of each page of the bill, that is, the billing information is first based on the number of transactions by the user. Prediction cache is used to obtain transaction information based on the data in the cache when querying, which reduces the load on the billing database query load and improves the query speed.

Example 5

Corresponding to the bill query method described in the second embodiment above, FIG. 5 shows a structural block diagram of the bill query device in this embodiment, which is based on the bill information cache device described in any one of the fourth embodiments. For convenience of explanation, only the parts related to this embodiment are shown.

The device includes: a time determination module 210, a data acquisition module 220, and a pipeline query module 230.

The time determining module 210 is configured to determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill when receiving the bill query request sent by the user.

The data obtaining module 220 is configured to obtain daily settlement data of the user from a preset daily settlement data table according to a time span of the bill of each page.

The flow query module 230 is configured to query the flow data of each page corresponding to the user and the date on which the flow of each page is located according to the daily settlement data of the user.

In the above-mentioned billing information buffering device, the time determination module 210 determines the time span of each page of the billing transaction of the user through the paged results in the cache and the transaction time information of each page of billing when receiving the billing query request sent by the client. The obtaining module 220 obtains the daily settlement data of the user from a preset daily settlement data table according to the time span of the bill of each page, and finally the flow query module 230 queries the corresponding data of each page of the user and the date of each page of the flow according to the daily settlement data. , Reduce the amount of data scanned per query, reduce the database paging query load pressure, and greatly improve query efficiency.

Example Six

FIG. 6 is a schematic diagram of a terminal device 100 provided in Embodiment 3 of the present application. As shown in FIG. 6, the terminal device 100 according to this embodiment includes a processor 140, a memory 150, and a computer program 151 stored in the memory 150 and executable on the processor 140, such as a billing information cache. Method procedure, or bill inquiry method procedure. When the processor 140 executes the computer program 151, the steps of the foregoing billing information caching method embodiments are implemented, such as steps S101 to S104 shown in FIG. 1, or the steps of the above billing query method embodiments are implemented, For example, steps S101 to S103 shown in FIG. 3. Alternatively, when the processor 140 executes the computer program 151, the functions of the modules / units in the foregoing device embodiments are implemented, for example, the functions of modules 110 to 130 shown in FIG. 4 or the functions of modules 210 to 230 shown in FIG. 5 Features.

Exemplarily, the computer program 151 may be divided into one or more modules / units, and the one or more modules / units are stored in the memory 150 and executed by the processor 140 to complete this invention. The one or more modules / units may be a series of computer program instruction segments capable of performing specific functions, and the instruction segments are used to describe an execution process of the computer program 151 in the terminal device 100. For example, the computer program 151 can be divided into a request query module, a transaction determination module, and an information cache module. The specific functions of each module are as follows:

The request query module is used to query whether there is data in the cache when a bill query request sent by a user terminal is received.

The transaction determination module is used to obtain the number of transactions of a user's query on the day if there is no data in the cache, and determine whether the number of transactions reaches a preset number of transactions.

The information cache module is configured to: if the number of transactions reaches the preset number of transactions, according to the number of transactions and the preset number of transactions per page, perform pagination of the bills of the transaction of the user's query on the current day, and according to the paged results Determine transaction time information for each page of bills, and store the paged results and transaction time information for each page of bills into the cache.

The information caching module is further configured to obtain the day end of the preset day closest to the query day from the preset day end data table according to the identity of the user, if the number of transactions does not reach the preset number of transactions. Data, and according to the obtained daily settlement data and the preset number of transactions per page, perform billing pagination on the preset day's transactions closest to the query day of the user, and determine the transaction time information of each page of bills based on the paged results , And storing the paged results and transaction time information of each page of bills into the cache, wherein a piece of daily settlement data includes the number of transactions per day of the user.

For example, the computer program 151 may be divided into a time determination module, a data acquisition module, and a pipeline query module. The specific functions of each module are as follows:

The time determination module is used to determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill when receiving the bill query request sent by the user.

The data acquisition module is configured to acquire daily settlement data of the user from a preset daily settlement data table according to a time span of the bill of each page.

The flow query module is used to query the flow data of each page corresponding to the user and the date on which the flow of each page is located according to the daily settlement data of the user.

The terminal device 100 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The terminal device 100 may include, but is not limited to, a processor 140 and a memory 150. Those skilled in the art can understand that FIG. 6 is only an example of the terminal device 100, and does not constitute a limitation on the terminal device 100. It may include more or fewer components than shown in the figure, or combine some components or different components. For example, the terminal device 100 may further include an input / output device, a network access device, and a bus.

The processor 140 may be a central processing unit (Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), and application-specific integrated circuits (Applications) Specific Integrated Circuit (ASIC), off-the-shelf Programmable Gate Array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 150 may be an internal storage unit of the terminal device 100, such as a hard disk or a memory of the terminal device 100. The memory 150 may also be an external storage device of the terminal device 100, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, and a flash memory card provided on the terminal device 100. (Flash Card), etc. Further, the memory 150 may further include both an internal storage unit of the terminal device 100 and an external storage device. The memory 150 is configured to store the computer program and other programs and data required by the terminal device 100. The memory 150 may also be used to temporarily store data that has been output or is to be output.

In the above embodiments, the description of each embodiment has its own emphasis. For a part that is not detailed or recorded in an embodiment, reference may be made to related descriptions of other embodiments.

Those of ordinary skill in the art may realize that the units and algorithm steps of each example described in connection with the embodiments disclosed herein can be implemented by electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. A person skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

In the embodiments provided by the present invention, it should be understood that the disclosed apparatus / terminal device and method may be implemented in other ways. For example, the device / terminal device embodiments described above are only schematic. For example, the division of the modules or units is only a logical function division. In actual implementation, there may be another division manner, such as multiple units. Or components can be combined or integrated into another system, or some features can be ignored or not implemented. In addition, the displayed or discussed mutual coupling or direct coupling or communication connection may be indirect coupling or communication connection through some interfaces, devices or units, which may be electrical, mechanical or other forms.

The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objective of the solution of this embodiment.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist separately physically, or two or more units may be integrated into one unit. The above integrated unit may be implemented in the form of hardware or in the form of software functional unit.

When the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the present invention implements all or part of the processes in the methods of the above embodiments, and may also be completed by a computer program instructing related hardware. The computer program may be stored in a computer-readable storage medium. The computer When the program is executed by a processor, the steps of the foregoing method embodiments can be implemented. The computer program includes computer program code, and the computer program code may be in a source code form, an object code form, an executable file, or some intermediate form. The computer-readable medium may include: any entity or system capable of carrying the computer program code, a recording medium, a U disk, a mobile hard disk, a magnetic disk, an optical disk, a computer memory, a read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signals, telecommunication signals, and software distribution media. It should be noted that the content included in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdictions. For example, in some jurisdictions, the computer-readable medium Excludes electric carrier signals and telecommunication signals.

The above-mentioned embodiments are only used to illustrate the technical solutions of the present invention, but not limited thereto. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can still implement the foregoing implementations. The technical solutions described in the examples are modified, or some of the technical features are equivalently replaced; and these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in Within the scope of the present invention.

Claims

A billing information buffering method, which is characterized by:

When receiving the bill query request sent by the client, query whether there is data in the cache;

If there is no data in the cache, obtaining a user's query for the number of transactions of the day, and determining whether the number of transactions reaches a preset number of transactions;

If the number of transactions reaches the preset number of transactions, according to the number of transactions and the preset number of transactions per page, perform pagination of bills on the day of the user's query, and determine the billing of each page according to the results Transaction time information, and storing paged results and transaction time information for each page of bills into the cache;

If the number of transactions does not reach the preset number of transactions, the day-end data of the preset day closest to the query day is obtained from the preset day-end data table according to the identity of the user, and according to the acquired Day-end data and the preset number of transactions per page, pagination of bills for the preset day's transactions closest to the query day of the user, determining the transaction time information of each page of the bill based on the results of the paging, and dividing the paged results with The transaction time information of each page of bills is stored in the cache, wherein a piece of daily settlement data includes the number of transactions per day of the user.
The method for buffering bill information according to claim 1, further comprising:

The daily transaction number of each user is summarized after the daily cut, and the daily settlement data of each user is generated according to the transaction number of the previous day of each user and stored in the preset daily settlement data table.
The method according to claim 1, wherein each transaction includes a transaction time;

According to the number of transactions and a preset number of transactions per page, performing pagination of bills on transactions of the user's query on the current day, and determining transaction time information of each page of bills according to the results of the paging includes:

According to the expression pageCount = (orderCount- pageSize)% pageSize + 1, to perform pagination of bills on transactions of the user's query day, where pageCount is a pageable number, orderCount is the number of transactions, and pageSize is the preset number of transactions per page;

The transaction time information of each page of the bill is determined according to the pageable number and the transaction time of each transaction.
A bill query method based on the bill information caching method according to any one of claims 1 to 3, comprising:

When receiving the bill query request sent by the client, determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill;

Obtaining the daily settlement data of the user from a preset daily settlement data table according to the time span of the bill per page;

Query the per-page flow data corresponding to the user and the date of each page flow based on the user's day-end data.
The bill inquiry method according to claim 4, further comprising:

Display the flow data of each page and the date on which each flow of pages is displayed in a flow statement.
A billing information buffering device, comprising:

A request query module is used to query whether there is data in the cache when a bill query request sent by a user terminal is received;

A transaction determining module, configured to obtain, if there is no data in the cache, a user querying the number of transactions on the day, and determining whether the number of transactions reaches a preset number of transactions;

An information buffer module, configured to: if the number of transactions reaches the preset number of transactions, perform pagination of bills on the transaction of the user's query on the basis of the number of transactions and the preset number of transactions per page, and The result determines the transaction time information of each page of the bill, and stores the paged result and the transaction time information of each page of the bill into the cache;

The information caching module is further configured to: if the number of transactions does not reach the preset number of transactions, obtain a date of a preset day closest to the query day from the preset day-end data table according to the identity of the user; Settle the data, and based on the obtained daily settlement data and the preset number of transactions per page, perform billing pagination on the preset day's transactions closest to the query day of the user, and determine the transaction time of each page of bills based on the paged results Information, and store the paged results and transaction time information of each page of bills into the cache, where a day-end data includes the number of transactions per day of the user.
The billing information buffer device according to claim 6, further comprising:

The daily settlement summary module is used to summarize the daily transaction amount of each user after the daily cut, and generate daily settlement data of each user based on the transaction number of the previous day of each user and store the data into the preset day. Knot data table.
A bill query device based on the bill information cache device according to any one of claims 6 to 7, comprising:

A time determination module is used to determine the time span of each page of the user's transaction according to the paged results in the cache and the transaction time information of each page of the bill when the bill query request sent by the user is received;

A data acquisition module, configured to acquire daily settlement data of the user from a preset daily settlement data table according to a time span of the bill of each page;

The flow query module is configured to query the flow data of each page corresponding to the user and the date on which the flow of each page is located according to the daily settlement data of the user.
A terminal device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the computer program according to claims 1 to 1 when executing the computer program. Steps of the method of any one of 3.
A computer-readable storage medium storing a computer program, wherein when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 3 are implemented.