A method, device, equipment and medium for transaction data page loading

Abstract

The application discloses a kind of transaction data page loading method, device, equipment and medium.The present application is sorted and paged according to the data code of two-party transaction data and the preset two-party single page data volume, determines the total number of two parties and the data code of the transaction data corresponding to each page of two parties, renders the page when the user terminal initiates the request of account checking, extracts the account checking field value of the transaction data corresponding to the target page of two parties, and when the user terminal initiates the request of account checking operation for the target page of two parties, the transaction data corresponding to the target data code and the target account checking field is stored as account checking data to target block area, and when at least one target page is detected Page switching occurs, the account checking data of the corresponding target page is extracted from the target block area and backfilled to the current page, which can support dynamic loading and cross-page loading of transaction data, effectively improve the accuracy and efficiency of user account checking.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method, apparatus, device, and medium for loading transaction data pages. Background Technology

[0002] Most companies have a large number of transactions between their various organizations, and it is often necessary to reconcile the transaction data between the two organizations to check for any problems.

[0003] Currently, to reconcile transaction data between two organizations, users primarily rely on loading the transaction data of both organizations at once using a computer. The data is then rendered through journal entries to directly view the transaction data on the page for reconciliation. However, limited by computer memory capacity and page rendering performance, when the amount of transaction data from both organizations is enormous—for example, loading 100,000 transactions from each organization at once—it easily leads to slow page rendering. Furthermore, it requires paginating the transaction data from both organizations, meaning users can only reconcile the transactions on the current page. After paginating, the transaction data on the current page is reset, preventing cross-page reconciliation and impacting the accuracy and efficiency of the reconciliation process. Summary of the Invention

[0004] To overcome the shortcomings of the prior art, the present invention provides a method, apparatus, device and medium for loading transaction data pages, which can support dynamic loading and cross-page loading of transaction data, effectively improving the accuracy and efficiency of user reconciliation.

[0005] To address the aforementioned technical problems, in a first aspect, an embodiment of the present invention provides a method for loading a transaction data page, comprising:

[0006] The transaction data in the transaction dataset is sorted according to the data internal code of each transaction data in the transaction dataset to obtain the transaction data sequence. Based on the transaction data sequence, the total number of pages and the data internal code of the transaction data corresponding to each page are determined according to the pre-set amount of data per page.

[0007] The transaction data in the counterparty transaction dataset is sorted according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence. Based on the counterparty transaction data sequence, the total number of counterparty pages and the data internal code of the transaction data corresponding to each counterparty page are determined according to the pre-set amount of data per counterparty page.

[0008] In response to a reconciliation request initiated by a user terminal, based on the target local page and the target counterparty page in the reconciliation request, the reconciliation field values ​​of the transaction data corresponding to the target local page are extracted for page rendering, and the reconciliation field values ​​of the transaction data corresponding to the target counterparty page are extracted for page rendering.

[0009] In response to the reconciliation operation request initiated by the user terminal, the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request is stored as reconciliation data in the target block area, and when a page switch is detected, the reconciliation data is extracted from the target block area and backfilled into the current page.

[0010] Furthermore, the target segmented region is located based on the target segmented region identifier, which is calculated by offset based on the target data internal code.

[0011] Furthermore, before sorting the transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, the method further includes:

[0012] Obtain the original transaction dataset of this party, and filter the transaction data in the original transaction dataset of this party according to the filtering conditions input by the user terminal to obtain the original transaction dataset of this party;

[0013] Before sorting the transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, the method further includes:

[0014] Obtain the original transaction dataset of the other party, and filter the transaction data in the original transaction dataset of the other party according to the filtering conditions to obtain the transaction dataset of the other party.

[0015] Furthermore, after responding to the reconciliation operation request initiated by the user terminal, storing the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and retrieving the reconciliation data from the target block area and backfilling it to the current page when a page switch is detected, the method further includes:

[0016] The system checks whether the reconciliation data meets the predefined reconciliation requirements. If it does, the reconciliation operation is considered successful; otherwise, it is considered a failure.

[0017] Further, the step of sorting the transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence is specifically as follows:

[0018] Sort the transaction data in the local transaction dataset according to the ascending order of the data internal code values ​​of each transaction data in the local transaction dataset to obtain the local transaction data sequence;

[0019] The step of sorting the transaction data in the counterparty's transaction dataset according to the data internal code of each transaction data in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence is as follows:

[0020] The transaction data in the counterparty transaction dataset is sorted in ascending order of its internal code value to obtain the counterparty transaction data sequence.

[0021] Further, the step of extracting the reconciliation field values ​​of the transaction data corresponding to the target self-side page for page rendering based on the target self-side page and the target other-side page in the reconciliation request, and extracting the reconciliation field values ​​of the transaction data corresponding to the target other-side page for page rendering, specifically involves:

[0022] Based on the data internal code of the transaction data corresponding to the target page, extract the reconciliation field value of the transaction data corresponding to the target page from the database for page rendering;

[0023] Based on the data internal code of the transaction data corresponding to the target counterparty's page, the reconciliation field value of the transaction data corresponding to the target counterparty's page is extracted from the database for page rendering.

[0024] Secondly, an embodiment of the present invention provides an apparatus for loading a transaction data page, comprising:

[0025] The local transaction data processing module is used to sort each transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, and based on the local transaction data sequence, determine the total number of local pages and the data internal code of the transaction data corresponding to each local page according to the preset local single page data volume;

[0026] The counterparty transaction data processing module is used to sort each transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, and based on the counterparty transaction data sequence, determine the total number of counterparty pages and the data internal code of the transaction data corresponding to each counterparty page according to the preset single page data volume of the counterparty.

[0027] The transaction data dynamic loading module is used to respond to the reconciliation request initiated by the user terminal. Based on the target local page and the target counterparty page in the reconciliation request, it extracts the reconciliation field values ​​of the transaction data corresponding to the target local page for page rendering, and extracts the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering.

[0028] The transaction data cross-page loading module is used to respond to the reconciliation operation request initiated by the user terminal, store the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and extract the reconciliation data from the target block area and backfill it to the current page when a page switch is detected.

[0029] Furthermore, the local transaction data processing module is also used to obtain the local original transaction dataset before sorting each transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, and to filter the transaction data in the local original transaction dataset according to the filtering conditions input by the user terminal to obtain the local transaction dataset.

[0030] The counterparty transaction data processing module is further configured to, before sorting each transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, obtain the counterparty original transaction dataset, and filter the transaction data in the counterparty original transaction dataset according to the filtering conditions to obtain the counterparty transaction dataset.

[0031] Thirdly, an embodiment of the present invention provides an apparatus for loading transaction data pages, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, the memory being coupled to the processor, and the processor implementing the transaction data page loading method as described above when executing the computer program.

[0032] Fourthly, one embodiment of the present invention provides a computer-readable storage medium, the computer-readable storage medium including a stored computer program, wherein, when the computer program is executed, it controls the device where the computer-readable storage medium is located to perform the transaction data page loading method as described above.

[0033] Fifthly, one embodiment of the present invention provides a computer program product that, when run on a computer, causes the computer to execute the transaction data page loading method described above.

[0034] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0035] By sorting and paginating the transaction data of both parties based on the internal codes of the transaction data and the preset data volume per page for both parties, the total number of pages for both parties and the internal codes of the transaction data corresponding to each page for both parties are determined. When a user initiates a reconciliation request, the reconciliation field values ​​of the transaction data corresponding to the target page for both parties are extracted and the page is rendered. When a user initiates a reconciliation operation request for the target page for both parties, the transaction data corresponding to the target internal code and the target reconciliation field is stored as reconciliation data in the target block area. When a page switch is detected for at least one target page, the reconciliation data of the corresponding target page is extracted from the target block area and populated back to the current page. This allows users to choose any transaction data from their own page and the other party's page for reconciliation, including cross-page reconciliation, thereby supporting dynamic loading and cross-page loading of transaction data, effectively improving the accuracy and efficiency of user reconciliation. Attached Figure Description

[0036] Figure 1 This is a flowchart illustrating a method for loading a transaction data page according to a first embodiment of the present invention;

[0037] Figure 2 This is a data flow diagram illustrating a conventional transaction data loading method as exemplified in the first embodiment of the present invention;

[0038] Figure 3 This is a data flow diagram illustrating a method for loading a transaction data page, as exemplified in the first embodiment of the present invention.

[0039] Figure 4 This is a schematic diagram of a device for loading transaction data pages according to a second embodiment of the present invention. Detailed Implementation

[0040] The technical solutions of this invention will now be clearly and completely described with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this invention, and not all of them. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0041] It should be noted that the step numbers in this document are only for the convenience of explaining the specific embodiments and are not intended to limit the order in which the steps are executed. The method provided in this embodiment can be executed by relevant terminal devices, and the following description uses a processor as the execution subject.

[0042] like Figure 1 As shown, the first embodiment provides a method for loading a transaction data page, including steps S1 to S4:

[0043] S1. Sort each transaction in the transaction dataset according to the data internal code of each transaction in the transaction dataset to obtain the transaction data sequence of the transaction dataset. Based on the transaction data sequence of the transaction dataset, determine the total number of pages of the transaction dataset and the data internal code of the transaction data corresponding to each page of the transaction dataset according to the pre-set amount of data per page of the transaction dataset.

[0044] S2. Sort each transaction in the counterparty's transaction dataset according to the data internal code of each transaction in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence. Based on the counterparty's transaction data sequence, determine the total number of counterparty pages and the data internal code of the transaction data corresponding to each counterparty page according to the pre-set amount of data per counterparty page.

[0045] S3. Respond to the reconciliation request initiated by the user terminal. Based on the target local page and the target counterparty page in the reconciliation request, extract the reconciliation field values ​​of the transaction data corresponding to the target local page for page rendering, and extract the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering.

[0046] S4. Respond to the reconciliation operation request initiated by the user terminal, store the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and when a page switch is detected, extract the reconciliation data from the target block area and populate it back to the current page.

[0047] It should be noted that user terminals include communication devices such as mobile phones, computers, and tablets that can connect to the server.

[0048] As an example, in step S1, considering the actual reconciliation needs, the domestic and counterparty organizations are identified, and several transaction data points of the domestic organization are obtained, i.e., the domestic transaction dataset. The data internal code of each transaction data point in the domestic transaction dataset is then queried. The data internal code of the transaction data is a long integer field, which is a unique and ordered column of data. Based on the data internal codes of each transaction data point in the domestic transaction dataset, the transaction data in the domestic transaction dataset is sorted to obtain a domestic transaction data sequence. Then, according to a pre-set domestic single-page data volume, each transaction data point in the domestic transaction data sequence is paginated to determine the total number of domestic pages and the data internal code of the transaction data corresponding to each domestic page.

[0049] In step S2, several transaction data sets from the other party's organization are obtained, i.e., the other party's transaction dataset, and the data internal code of each transaction data set in the other party's transaction dataset is queried. Based on the data internal codes of each transaction data set in the other party's transaction dataset, the transaction data in the other party's transaction dataset is sorted to obtain the other party's transaction data sequence. Then, according to the pre-set amount of data per page of the other party, each transaction data in the other party's transaction data sequence is paginated to determine the total number of pages of the other party and the data internal code of the transaction data corresponding to each page of the other party.

[0050] In step S3, the user can select any local page and any counterparty page at any time according to actual reconciliation needs and initiate a reconciliation request through the user terminal. When the reconciliation request initiated by the user terminal is received, the system responds to the request and, based on the target local page and target counterparty page in the reconciliation request (i.e., the target local page and target counterparty page selected by the user), automatically extracts the reconciliation field values ​​of the transaction data corresponding to the target local page for page rendering based on the data internal code of the transaction data corresponding to the target local page, and automatically extracts the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering based on the data internal code of the transaction data corresponding to the target counterparty page, displaying the target local page and target counterparty page on the front-end interface.

[0051] In step S4, the user can select any transaction data's internal code and reconciliation field from the target user's page and the target counterparty's page according to actual reconciliation needs, and initiate a reconciliation operation request through the user terminal. When the reconciliation operation request initiated by the user terminal is received, the system responds to the user terminal's reconciliation operation request by storing the transaction data corresponding to the target internal code and target reconciliation field in the reconciliation operation request, i.e., the transaction data corresponding to the target internal code and target reconciliation data selected by the user, as reconciliation data in the target block area. When a page switch is detected on the target user's page or the target counterparty's page, the system extracts the reconciliation data from the target block area and populates it back to the current page.

[0052] This embodiment sorts and paginates the transaction data of both parties based on the data internal codes of the transaction data and the preset single-page data volume of both parties. It determines the total number of pages for both parties and the data internal codes of the transaction data corresponding to each page of both parties. When the user terminal initiates a reconciliation request, the reconciliation field values ​​of the transaction data corresponding to the target page of both parties are extracted and the page is rendered. When the user terminal initiates a reconciliation operation request for the target page of both parties, the transaction data corresponding to the target data internal code and the target reconciliation field is stored as reconciliation data in the target block area. When a page switch is detected for at least one target page, the reconciliation data of the corresponding target page is extracted from the target block area and filled back into the current page. This allows the user to choose any transaction data in their own page and the other party's page for reconciliation, including cross-page reconciliation, thereby supporting dynamic loading and cross-page loading of transaction data, effectively improving the accuracy and efficiency of user reconciliation.

[0053] In a preferred embodiment, the target block region is located based on the target block region identifier, which is calculated by offset based on the target data internal code.

[0054] As an example, when a reconciliation operation request is received from a user terminal for the target local page and the target counterparty page, the system responds to the user terminal's reconciliation operation request by using the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request, i.e., the transaction data corresponding to the target data internal code and target reconciliation data selected by the user, as the reconciliation data. The system renders the target local page and the target counterparty page to select the reconciliation data. Simultaneously, the system calculates the target segment region identifier based on the target data internal code, locates the target segment region based on the target segment region identifier, stores the reconciliation data in the target segment region, and detects in real time whether the target local page and the target counterparty page have switched pages, i.e., whether the user has performed a page-turning action. When a page switch is detected, the system extracts the reconciliation data of the target local page or the target counterparty page from the target segment region and fills it back into the current page, i.e., the new page after page turning.

[0055] This can be achieved using Java's bitwise operations to calculate the offset of long integer data (Long type data) by displacement, and then use the calculated offset as a key in the Map.

[0056] During the user's reconciliation process, the reconciliation data selected by the user each time is stored in different block areas, and each bit operation locates the block area where the reconciliation data required for this reconciliation is located.

[0057] This embodiment calculates the target block region identifier based on the offset of the target data internal code, and uses the target block region located by the target block region identifier to store the reconciliation data. This enables the segmented storage of the reconciliation data selected by the user when the user operates the transaction data for reconciliation, thereby supporting dynamic loading and cross-page loading of transaction data, effectively improving the accuracy and efficiency of user reconciliation.

[0058] In a preferred embodiment, before sorting the transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, the method further includes: obtaining the local original transaction dataset and filtering the transaction data in the local original transaction dataset according to the filtering conditions input by the user terminal to obtain the local transaction dataset; before sorting the transaction data in the counterparty's transaction dataset according to the data internal code of each transaction data in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence, the method further includes: obtaining the counterparty's original transaction dataset and filtering the transaction data in the counterparty's original transaction dataset according to the filtering conditions to obtain the counterparty's transaction dataset.

[0059] As an example, several original transaction data sets of our organization are obtained, i.e., our original transaction datasets. Based on preset filtering conditions such as time periods and reconciliation schemes input by the user terminal, the transaction data in our original transaction datasets is filtered to obtain our own transaction dataset. Similarly, several original transaction data sets of the other party's organization are obtained, i.e., the other party's original transaction datasets. Based on preset filtering conditions such as time periods and reconciliation schemes input by the user terminal, the transaction data in the other party's original transaction datasets is filtered to obtain the other party's transaction dataset. For example, the transaction data belonging to period 5 of 2022 and reconciliation scheme X in our original transaction dataset is retained to obtain our own transaction dataset, and the transaction data belonging to period 5 of 2022 and reconciliation scheme X in the other party's original transaction dataset is retained to obtain the other party's transaction dataset.

[0060] This embodiment filters the transaction data of both parties based on the user's input filtering conditions before the user reconciliation operation, which helps to further improve the accuracy and efficiency of user reconciliation.

[0061] In a preferred embodiment, after responding to the reconciliation operation request initiated by the user terminal, storing the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and extracting the reconciliation data from the target block area and backfilling it to the current page when a page switch is detected, the method further includes: verifying whether the reconciliation data meets the predefined reconciliation requirements; if it does, the reconciliation operation is determined to be successful; otherwise, the reconciliation operation is determined to be unsuccessful.

[0062] As an example, after reconciliation data is extracted from the target segment area and backfilled to the current page, the system automatically checks whether the reconciliation data meets the predefined reconciliation requirements. This includes checking whether the difference between the total amount of the user and the other party is within the preset reconciliation tolerance range. If the debit and credit amounts are opposite, the reconciliation operation is considered successful; otherwise, the reconciliation operation is considered to have failed.

[0063] Assuming the reconciliation tolerance is set to 10, if the total debit amount on this side is 100 and the total credit amount on the other side is 105, the difference of 5 is less than the set reconciliation tolerance of 10, then the reconciliation operation is successful; if the total debit amount on this side is 100 and the total credit amount on the other side is 115, the difference of 15 is greater than the set reconciliation tolerance of 10, then the reconciliation operation fails.

[0064] This embodiment automatically checks whether the reconciliation data meets the reconciliation requirements after each user reconciliation operation, which helps to further improve the accuracy and efficiency of user reconciliation.

[0065] In a preferred embodiment, sorting the transaction data in the local transaction dataset according to the internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence specifically involves: sorting the transaction data in the local transaction dataset in ascending order of the internal code values ​​of each transaction data in the local transaction dataset to obtain the local transaction data sequence; and sorting the transaction data in the counterparty's transaction dataset according to the internal code of each transaction data in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence specifically involves: sorting the transaction data in the counterparty's transaction dataset in ascending order of the internal code values ​​of each transaction data in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence.

[0066] As an example, by querying the internal code of each transaction in the domestic transaction dataset, the value of the internal code of each transaction in the domestic transaction dataset is determined. Then, the transactions in the domestic transaction dataset are sorted in ascending order of their internal code values ​​to obtain the domestic transaction data sequence. Similarly, by querying the internal code of each transaction in the counterparty's transaction dataset, the value of the internal code of each transaction in the counterparty's transaction dataset is determined. Then, the transactions in the counterparty's transaction dataset are sorted in ascending order of their internal code values ​​to obtain the counterparty's transaction data sequence.

[0067] In a preferred embodiment, the step of extracting the reconciliation field values ​​of the transaction data corresponding to the target user page and the target counterparty page from the reconciliation request for page rendering, and extracting the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering, specifically involves: extracting the reconciliation field values ​​of the transaction data corresponding to the target user page from the database based on the data internal code of the transaction data corresponding to the target user page for page rendering; and extracting the reconciliation field values ​​of the transaction data corresponding to the target counterparty page from the database based on the data internal code of the transaction data corresponding to the target counterparty page for page rendering.

[0068] As an example, when a reconciliation request initiated by a user terminal is received, the system responds to the reconciliation request initiated by the user terminal. Based on the target local page and target counterparty page in the reconciliation request, i.e. the target local page and target counterparty page selected by the user, the system automatically extracts the reconciliation field values ​​of the transaction data corresponding to the target local page from the database and renders the page based on the data internal code of the transaction data corresponding to the target local page. Similarly, the system automatically extracts the reconciliation field values ​​of the transaction data corresponding to the target counterparty page from the database and renders the page based on the data internal code of the transaction data corresponding to the target counterparty page. The target local page and target counterparty page are then displayed on the front-end interface.

[0069] This embodiment extracts the reconciliation field values ​​of the transaction data corresponding to the two target pages selected by the user from the database, loads them into memory, and then renders the page. This eliminates the need to load all the transaction data of both parties, which helps reduce memory usage.

[0070] To more clearly illustrate the method for loading a transaction data page provided in the first embodiment, a comparison is made between this method and a traditional method for loading transaction data.

[0071] like Figure 2 As shown, using the traditional transaction data loading method, 100,000 transactions from each of organizations A and B (totaling 200,000) are loaded into memory and then paginated. This consumes a lot of memory, and the transaction data on the current page is reset after pagination, making cross-page reconciliation impossible. This results in slow page rendering, a poor user experience, and users are unable to find the data they need to reconcile, and can only reconcile the data on the current page.

[0072] The execution flow of the method for loading the application transaction data page is as follows:

[0073] 1. Query the transaction data of organization A that occurred in period 5 of 2022 and belong to reconciliation scheme X; query the transaction data of organization B that occurred in period 5 of 2022 and belong to reconciliation scheme X;

[0074] 2. The user selects the transaction data that needs to be reconciled for organization A on the first page:

[0075] Data code: 1193417324003079168, reconciliation amount: 100;

[0076] Data code: 1193417324003079169, reconciliation amount: 200;

[0077] The transaction data that needs to be reconciled is on the second page:

[0078] Data code: 1193417324003079170, reconciliation amount: 300;

[0079] The user selects the transaction data that needs to be reconciled for organization B on the first page:

[0080] Data code: 1193417324003079171, reconciliation amount: 150;

[0081] Data code: 1193417324003079172, reconciliation amount: 450;

[0082] Bitwise calculation:

[0083] Offset: 4319 is used as the address of the block region; the block region stores organization A data: (1193417324003079168, 100), (1193417324003079169, 200), (1193417324003079170, 300) and organization B data: (1193417324003079171, 150), (1193417324003079172, 450);

[0084] 3. If the user flips through the pages from Organization A back to the first page, the data internal code of the reconciliation data on the first page is taken, the offset is calculated to obtain the value 4319, the reconciliation amount is taken from the 4319 block area and filled back into the reconciliation amount field on the first page and is in the selected state;

[0085] 4. Verify whether the reconciliation data stored in the block area meets the predefined reconciliation requirements. If it does, the reconciliation is successful; otherwise, the reconciliation fails.

[0086] like Figure 3As shown, the transaction data page loading method is used to reconcile the transaction data of organizations A and B. When the user enters the reconciliation interface, the data internal codes of the transaction data of organizations A and B are retrieved and sorted sequentially. The total number of pages and the data internal codes of the transaction data to be displayed on the current page are calculated based on the number of items displayed per page. The reconciliation field values ​​required for page rendering are retrieved from the database using the data internal codes of the transaction data on the current page. When the user performs a reconciliation operation, the data internal code of the reconciliation data selected by the user and the input reconciliation field values ​​are determined. First, the offset of the data internal code of the reconciliation data is calculated to obtain the target block area identifier. Then, the reconciliation data is stored in the corresponding target block area. When the user flips to return to the current page, the offset of the data internal code of the reconciliation data is calculated again to obtain the target block area identifier. Then, the reconciliation field values ​​of the reconciliation data operated on by the user are retrieved from the corresponding target block area and filled back into the current page. The entire process of storing and retrieving the reconciliation data in blocks helps to improve the reconciliation response speed. During the final reconciliation operation, data persistence operations can be performed on the reconciliation data in different block areas in parallel.

[0087] Based on the same inventive concept as the first embodiment, the second embodiment provides as follows: Figure 4 The apparatus for loading transaction data pages includes: a local transaction data processing module 21, used to sort each transaction data in the local transaction data set according to the data internal code of each transaction data in the local transaction data set to obtain a local transaction data sequence, and based on the local transaction data sequence, determine the total number of local pages and the data internal code of the transaction data corresponding to each local page according to a preset local single-page data volume; and a counterparty transaction data processing module 22, used to sort each transaction data in the counterparty transaction data set according to the data internal code of each transaction data in the counterparty transaction data set to obtain a counterparty transaction data sequence, and based on the counterparty transaction data sequence, determine the total number of counterparty pages and the data internal code of the transaction data corresponding to each local page according to a preset counterparty single-page data volume. The transaction data corresponding to each counterparty page has an internal data code; the transaction data dynamic loading module 23 is used to respond to the reconciliation request initiated by the user terminal, and extract the reconciliation field value of the transaction data corresponding to the target local page for page rendering based on the target local page and the target counterparty page in the reconciliation request, and extract the reconciliation field value of the transaction data corresponding to the target counterparty page for page rendering; the transaction data cross-page loading module 24 is used to respond to the reconciliation operation request initiated by the user terminal, store the transaction data corresponding to the target data code and the target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and when a page switch is detected, extract the reconciliation data from the target block area and fill it back into the current page.

[0088] In a preferred embodiment, the target block region is located based on the target block region identifier, which is calculated by offset based on the target data internal code.

[0089] In a preferred embodiment, the local transaction data processing module 21 is further configured to, before sorting the transaction data in the local transaction data set according to the data internal code of each transaction data in the local transaction data set to obtain the local transaction data sequence, obtain the local original transaction data set and filter the transaction data in the local original transaction data set according to the filtering conditions input by the user terminal to obtain the local transaction data set; the counterparty transaction data processing module 22 is further configured to, before sorting the transaction data in the counterparty transaction data set according to the data internal code of each transaction data in the counterparty transaction data set to obtain the counterparty transaction data sequence, obtain the counterparty original transaction data set and filter the transaction data in the counterparty original transaction data set according to the filtering conditions to obtain the counterparty transaction data set.

[0090] In a preferred embodiment, the device for loading the transaction data page further includes: a reconciliation data verification module, used to, in response to a reconciliation operation request initiated by a user terminal, store the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in a target block area, and after detecting a page switch, extract the reconciliation data from the target block area and backfill it to the current page, verify whether the reconciliation data meets the predefined reconciliation requirements. If it does, the reconciliation operation is determined to be successful; otherwise, the reconciliation operation is determined to be unsuccessful.

[0091] In a preferred embodiment, the local transaction data processing module 21 is specifically used to sort the transaction data in the local transaction data set according to the value of the data internal code of each transaction data in the local transaction data set in ascending order, to obtain the local transaction data sequence; the counterparty transaction data processing module 22 is specifically used to sort the transaction data in the counterparty transaction data set according to the value of the data internal code of each transaction data in the counterparty transaction data set in ascending order, to obtain the counterparty transaction data sequence.

[0092] In a preferred embodiment, the transaction data dynamic loading module 23 is specifically used for: extracting the reconciliation field value of the transaction data corresponding to the target's own page from the database and rendering the page based on the data internal code of the transaction data corresponding to the target's own page; and extracting the reconciliation field value of the transaction data corresponding to the target's other party's page from the database and rendering the page based on the data internal code of the transaction data corresponding to the target's other party's page.

[0093] Based on the same inventive concept as the first embodiment, the third embodiment provides a device for loading transaction data pages, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor. The memory is coupled to the processor, and when the processor executes the computer program, it implements the transaction data page loading method as described in the first embodiment and achieves the same beneficial effects.

[0094] Based on the same inventive concept as the first embodiment, the fourth embodiment provides a computer-readable storage medium including a stored computer program, wherein, when the computer program is running, it controls the device where the computer-readable storage medium is located to execute the transaction data page loading method as described in the first embodiment, and can achieve the same beneficial effects.

[0095] Based on the same inventive concept as the first embodiment, the fifth embodiment provides a computer program product that, when run on a computer, causes the computer to execute the transaction data page loading method as described in the first embodiment, and achieves the same beneficial effects.

[0096] In summary, implementing the embodiments of the present invention has the following beneficial effects:

[0097] By sorting and paginating the transaction data of both parties based on the internal codes of the transaction data and the preset data volume per page for both parties, the total number of pages for both parties and the internal codes of the transaction data corresponding to each page for both parties are determined. When a user initiates a reconciliation request, the reconciliation field values ​​of the transaction data corresponding to the target page for both parties are extracted and the page is rendered. When a user initiates a reconciliation operation request for the target page for both parties, the transaction data corresponding to the target internal code and the target reconciliation field is stored as reconciliation data in the target block area. When a page switch is detected for at least one target page, the reconciliation data of the corresponding target page is extracted from the target block area and populated back to the current page. This allows users to choose any transaction data from their own page and the other party's page for reconciliation, including cross-page reconciliation, thereby supporting dynamic loading and cross-page loading of transaction data, effectively improving the accuracy and efficiency of user reconciliation.

[0098] The above description represents the preferred embodiments of the present invention. It should be noted that those skilled in the art can make various improvements and modifications without departing from the principles of the present invention, and these improvements and modifications are also considered to be within the scope of protection of the present invention.

[0099] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes described in the above embodiments. The storage medium can be a magnetic disk, optical disk, read-only memory (ROM), or random access memory (RAM), etc.

Claims

1. A method for loading transaction data pages, characterized in that, include: The transaction data in the transaction dataset is sorted according to the data internal code of each transaction data in the transaction dataset to obtain the transaction data sequence. Based on the transaction data sequence, the total number of pages and the data internal code of the transaction data corresponding to each page are determined according to the pre-set amount of data per page. The transaction data in the counterparty transaction dataset is sorted according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence. Based on the counterparty transaction data sequence, the total number of counterparty pages and the data internal code of the transaction data corresponding to each counterparty page are determined according to the pre-set amount of data per counterparty page. In response to a reconciliation request initiated by a user terminal, based on the target local page and the target counterparty page in the reconciliation request, the reconciliation field values ​​of the transaction data corresponding to the target local page are extracted for page rendering, and the reconciliation field values ​​of the transaction data corresponding to the target counterparty page are extracted for page rendering. In response to the reconciliation operation request initiated by the user terminal, the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request is stored as reconciliation data in the target block area, and when a page switch is detected, the reconciliation data is extracted from the target block area and backfilled into the current page.

2. The method for loading transaction data pages as described in claim 1, characterized in that, The target segmented region is located based on the target segmented region identifier, which is calculated based on the offset of the target data internal code.

3. The method for loading transaction data pages as described in claim 1, characterized in that, Before sorting the transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, the method further includes: Obtain the original transaction dataset of this party, and filter the transaction data in the original transaction dataset of this party according to the filtering conditions input by the user terminal to obtain the original transaction dataset of this party; Before sorting the transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, the method further includes: Obtain the original transaction dataset of the other party, and filter the transaction data in the original transaction dataset of the other party according to the filtering conditions to obtain the transaction dataset of the other party.

4. The method for loading transaction data pages as described in claim 1, characterized in that, In response to the reconciliation operation request initiated by the user terminal, the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request is stored as reconciliation data in the target block area, and when a page switch is detected, the reconciliation data is extracted from the target block area and populated back to the current page, the method further includes: The system checks whether the reconciliation data meets the predefined reconciliation requirements. If it does, the reconciliation operation is considered successful; otherwise, it is considered a failure.

5. The method for loading transaction data pages as described in claim 1, characterized in that, The step of sorting the transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence is as follows: Sort the transaction data in the local transaction dataset according to the ascending order of the data internal code values ​​of each transaction data in the local transaction dataset to obtain the local transaction data sequence; The step of sorting the transaction data in the counterparty's transaction dataset according to the data internal code of each transaction data in the counterparty's transaction dataset to obtain the counterparty's transaction data sequence is as follows: The transaction data in the counterparty transaction dataset is sorted in ascending order of its internal code value to obtain the counterparty transaction data sequence.

6. The method for loading transaction data pages as described in claim 1, characterized in that, The step of extracting the reconciliation field values ​​of the transaction data corresponding to the target user page and the target counterparty page from the reconciliation request for page rendering, and extracting the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering, specifically involves: Based on the data internal code of the transaction data corresponding to the target page, extract the reconciliation field value of the transaction data corresponding to the target page from the database for page rendering; Based on the data internal code of the transaction data corresponding to the target counterparty's page, the reconciliation field value of the transaction data corresponding to the target counterparty's page is extracted from the database for page rendering.

7. A device for loading transaction data pages, characterized in that, include: The local transaction data processing module is used to sort each transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, and based on the local transaction data sequence, determine the total number of local pages and the data internal code of the transaction data corresponding to each local page according to the preset local single page data volume; The counterparty transaction data processing module is used to sort each transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, and based on the counterparty transaction data sequence, determine the total number of counterparty pages and the data internal code of the transaction data corresponding to each counterparty page according to the preset single page data volume of the counterparty. The transaction data dynamic loading module is used to respond to the reconciliation request initiated by the user terminal. Based on the target local page and the target counterparty page in the reconciliation request, it extracts the reconciliation field values ​​of the transaction data corresponding to the target local page for page rendering, and extracts the reconciliation field values ​​of the transaction data corresponding to the target counterparty page for page rendering. The transaction data cross-page loading module is used to respond to the reconciliation operation request initiated by the user terminal, store the transaction data corresponding to the target data internal code and target reconciliation field in the reconciliation operation request as reconciliation data in the target block area, and extract the reconciliation data from the target block area and backfill it to the current page when a page switch is detected.

8. The apparatus for loading transaction data pages as described in claim 7, characterized in that, The local transaction data processing module is further configured to obtain the local original transaction dataset before sorting each transaction data in the local transaction dataset according to the data internal code of each transaction data in the local transaction dataset to obtain the local transaction data sequence, and filter the transaction data in the local original transaction dataset according to the filtering conditions input by the user terminal to obtain the local transaction dataset. The counterparty transaction data processing module is further configured to, before sorting each transaction data in the counterparty transaction dataset according to the data internal code of each transaction data in the counterparty transaction dataset to obtain the counterparty transaction data sequence, obtain the counterparty original transaction dataset, and filter the transaction data in the counterparty original transaction dataset according to the filtering conditions to obtain the counterparty transaction dataset.

9. A device for loading transaction data pages, characterized in that, The system includes a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, the memory being coupled to the processor, and the processor executing the computer program implementing the method for loading transaction data pages as described in any one of claims 1 to 6.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored computer program, wherein, when the computer program is executed, it controls the device on which the computer-readable storage medium is located to perform the method for loading transaction data pages as described in any one of claims 1 to 6.

Images