Logistics financial data processing method and device
By adopting GraphQL (Graphical Data Query Language) in logistics and financial data processing, the front-end system defines its own data structure, solving the problem of redundant fields returned by the API layer and achieving flexible data acquisition and resource conservation.
Patent Information
- Application Number
- CN202410276427.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-03-11
- Publication Date
- 2025-09-12
AI Technical Summary
In the existing technology, logistics merchants are unable to meet the diverse needs of different merchants in different scenarios when reconciling accounts. The data returned by the API layer contains redundant fields, causing the front-end system to obtain excessive amounts of unnecessary data, increasing the waste of network and memory resources.
GraphQL (Graph Data Query Language) is used instead of API layer development. The front-end system defines the data structure by itself and obtains the target financial data by generating query statements, avoiding the acquisition of redundant fields and meeting the diverse needs of merchants.
It reduces the waste of network and memory resources, realizes flexible data acquisition based on user needs, and meets the diverse reconciliation and settlement needs of different merchants.
Smart Images

Figure CN120631910A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a logistics financial data processing method and device. Background Art
[0002] When reconciling accounts with logistics merchants, they can only obtain data of specified dimensions through the API (Application Programming Interface) in the front-end system according to the preset demand scenarios provided in the logistics system. Therefore, the front-end system cannot control the data content returned by the server and cannot specify the interface to return specified data. As a result, it cannot meet the diverse needs of different merchants when there are differences in the reconciliation and settlement methods. If the API layer is used to meet the data needs of different merchants in different scenarios, it is necessary to introduce more unstructured parameters and conditions for management and expansion into the API layer, and it is necessary to carry out tedious design, development and maintenance of the front-end system and API layer, which greatly increases the development and application costs. Furthermore, the data returned by the API in response to the request usually contains redundant fields, causing the front-end system to obtain excessive data information that the merchant does not need, resulting in a waste of network resources. Summary of the Invention
[0003] In view of this, an embodiment of the present invention provides a logistics financial data processing method and device to solve the problem that the API layer includes redundant fields when returning requests, causing the front-end system to obtain excessive unnecessary data. While reducing the waste of network and memory resources, it meets the diverse needs of different merchants.
[0004] To achieve the above objectives, according to one aspect of an embodiment of the present invention, a method for processing logistics financial data is provided.
[0005] A logistics financial data processing method according to an embodiment of the present invention includes:
[0006] Receiving a data acquisition request for target financial data sent using a preset financial control;
[0007] Generate a query statement using a graph data query language based on the data acquisition request;
[0008] The target financial data is obtained from the data source based on the query statement and fed back to the client so that the client can display it.
[0009] Optionally, the method for setting the above preset financial controls includes:
[0010] Generate user data templates based on the user type and user needs of target users;
[0011] Construct the preset financial controls corresponding to the target users according to the user data template.
[0012] Optionally, after receiving the data acquisition request for target financial data sent using the preset financial control, the method further includes:
[0013] Receive the merchant reconciliation and settlement method selected by the target user;
[0014] The data assembly structure is determined based on the merchant reconciliation and write-off method selected above.
[0015] Optionally, the above-mentioned obtaining the target financial data from the data source based on the above-mentioned query statement and feeding it back to the client so that the client can display it includes:
[0016] Obtain the target financial data from the data source based on the query statement;
[0017] The above-mentioned target financial data is spliced according to the above-mentioned data splicing structure, and fed back to the client configured with the above-mentioned preset financial control to be displayed through the client.
[0018] Optionally, the target financial data is spliced according to the data splicing structure and fed back to a client configured with the preset financial control for display through the client, including:
[0019] Confirm the restricted date based on the target user's fund flow timeframe;
[0020] The above target financial data is spliced according to the above data splicing structure, and the target financial data with the above restricted date is fed back to the client as the target logistics waybill flow for display.
[0021] Optionally, after acquiring the target financial data from the data source based on the query statement and feeding it back to the client so that the client can display it, the method further includes:
[0022] Compare the above-mentioned target logistics waybill flow with the above-mentioned cash flow to conduct logistics account write-off.
[0023] Optionally, the merchant reconciliation and write-off methods include write-off by balance, write-off by document, and write-off by order quantity.
[0024] To achieve the above objectives, according to another aspect of an embodiment of the present invention, a logistics financial data processing device is provided.
[0025] A logistics financial data processing device according to an embodiment of the present invention includes:
[0026] A receiving module, configured to receive a data acquisition request for target financial data sent using a preset financial control;
[0027] A generation module, configured to generate a query statement using a graph data query language based on the data acquisition request;
[0028] The acquisition module is used to obtain the above-mentioned target financial data from the data source based on the above-mentioned query statement and feed it back to the client so that the client can display it.
[0029] To achieve the above objectives, according to another aspect of an embodiment of the present invention, an electronic device for processing logistics financial data is provided.
[0030] An electronic device for processing logistics financial data according to an embodiment of the present invention includes: one or more processors; a storage device for storing one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors implement a logistics financial data processing method according to an embodiment of the present invention.
[0031] To achieve the above objective, according to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided.
[0032] A computer-readable storage medium according to an embodiment of the present invention stores a computer program, which, when executed by a processor, implements a logistics financial data processing method according to an embodiment of the present invention.
[0033] An embodiment of the above invention has the following advantages or beneficial effects: by setting different preset financial controls, the target financial data of the corresponding data template is obtained according to the user's expectations, avoiding the problem of only being able to obtain the specified data fields preset by the API layer, thereby failing to meet the diverse needs of merchants; by replacing the development of the API layer with a graphical data query language, a declarative language is provided for the front-end system, and the front-end system can define the data structure and express data requirements by itself. When obtaining data, it only needs to generate a query statement of the graphical data query language based on the data acquisition request. According to the query statement, the required target financial data can be obtained without obtaining non-essential data fields. This solves the problem of the API layer returning a request covering redundant fields, causing the front-end system to obtain excessive non-essential data, and reduces the waste of network and memory resources.
[0034] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with specific embodiments. BRIEF DESCRIPTION OF THE DRAWINGS
[0035] The accompanying drawings are provided for a better understanding of the present invention and are not intended to limit the present invention.
[0036] Figure 1 is a flow chart of a method for processing logistics financial data according to an embodiment of the present invention;
[0037] Figure 2 is an example diagram of a first preset financial control according to an embodiment of the present invention;
[0038] Figure 3 is an example diagram of a second preset financial control according to an embodiment of the present invention;
[0039] Figure 4 is an example diagram of a third preset financial control according to an embodiment of the present invention;
[0040] Figure 5 is a schematic diagram of different data assembly structures according to an embodiment of the present invention;
[0041] Figure 6 is a schematic diagram of different data display structures according to an embodiment of the present invention;
[0042] Figure 7 is a schematic diagram of an implementation architecture according to an embodiment of the present invention;
[0043] Figure 8 is a flow chart of a logistics financial data processing method according to another embodiment of the present invention;
[0044] Figure 9 is a schematic diagram of main modules of a logistics financial data processing device according to an embodiment of the present invention;
[0045] Figure 10 is an exemplary system architecture diagram in which embodiments of the present invention may be applied;
[0046] Figure 11 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION
[0047] The following description of exemplary embodiments of the present invention is made in conjunction with the accompanying drawings, in which various details of the embodiments of the present invention are included to facilitate understanding. These details should be considered as merely exemplary. Therefore, it should be appreciated by those skilled in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for the sake of clarity and conciseness, descriptions of well-known functions and structures are omitted in the following description.
[0048] It should be pointed out that, in the absence of conflict, the embodiments of the present invention and the technical features therein may be combined with each other.
[0049] It should be noted that the collection, collection, updating, analysis, processing, use, transmission, and storage of user personal information involved in the technical solutions disclosed herein all comply with relevant laws and regulations, are used for legitimate purposes, and do not violate public order and good morals. Necessary measures are taken with respect to user personal information to prevent unauthorized access to user personal information data and to safeguard the security of user personal information, network security, and national security.
[0050] Figure 1 3 is a schematic diagram of the main steps of the logistics financial data processing method according to an embodiment of the present invention.
[0051] like Figure 1 As shown, the logistics financial data processing method of the embodiment of the present invention mainly includes the following steps:
[0052] Step S101: receiving a data acquisition request for target financial data sent using a preset financial control;
[0053] Step S102: Generate a query statement using a graph data query language based on the data acquisition request;
[0054] Step S103: acquiring the target financial data from the data source based on the query statement and feeding it back to the client so that the client can display it.
[0055] Specifically, a preset financial control is a financial UI control pre-configured on the client. This allows users to initiate data acquisition requests based on UI operations to obtain target financial data. The target financial data is the data required by the target user. After being acquired from the data source, the target financial data can be assembled according to the data assembly structure and displayed on the client configured with the preset financial control for reconciliation and settlement by the target user.
[0056] GraphQL is an open source query language. The present invention uses GraphQL to replace the development of the API layer, thereby transferring the dominance of data structure definition from the server to the front-end system control.
[0057] In logistics financial data processing, all financial-related metadata is generated based on logistics waybills. Therefore, the hierarchical relationships and data types of the data stored in the server-side data source are known and fixed. The front-end system can use GraphQL to directly request data from the data source without requesting preset API data. Based on GraphQL, the server can provide a GraphQL schema (GraphQL data model) that defines the hierarchical relationships and data types of the data. In this case, the front-end system only needs to use GraphQL query statements to query the target financial data to obtain the target financial data.
[0058] In an optional embodiment, the method for setting the preset financial control includes:
[0059] Generate user data templates based on the user type and user needs of target users;
[0060] Construct the preset financial controls corresponding to the target users according to the user data template.
[0061] Specifically, users of different user types have different user needs. Therefore, Figure 2-Figure 4 As shown, each user can configure a corresponding preset financial control on their client based on their type and needs, displaying the data they need. This eliminates the need for large, comprehensive components that display a single dimension across all users. Development only needs to be done on the front-end system, eliminating the need for additional server-side development. Users select the required data through the corresponding preset financial control, generate a data retrieval request, and use GraphQL declaratively to request the required data from the server.
[0062] When the above-mentioned target financial data needs to be obtained from multiple data sources, without using GraphQL, it is necessary to request the server multiple times to retrieve data, including user basic information, waybill data, and other related financial order data. After all the data are retrieved, the data structure is spliced and then sent to the client for display. When GraphQL is used in the present invention, the front-end system uses GraphQL to generate query statements according to the data acquisition request for front-end and back-end communication, declaratively expresses the data requirements of the user interface, obtains all target financial data through the server at one time, without the need for multiple data requests, and does not obtain non-essential fields, eliminating the need for the API to hard-code the data shape and size, and does not require the API layer to encapsulate the data fed back by the data source, thereby realizing the decoupling of the interface return data and the data source, and the data structure of the returned target financial data is determined based on the conditions selected by the target user, such as the merchant reconciliation and settlement method, so that the data structure of the target financial data returned by the server is determined by the data splicing structure of the front-end system.
[0063] Furthermore, the data structure includes a data assembly structure and a data display structure. Figure 5-Figure 6As shown, the data assembly structure can be determined according to the merchant reconciliation and settlement method selected by the user, and each user data template also defines a different data display structure. After the target financial data is spliced according to the data assembly structure, it is fed back to the client, and then assembled according to the data display structure defined by the user data template of the preset financial control in the client, and the target financial data is displayed using the corresponding data display structure. Therefore, after obtaining the target financial data from the data source, the front-end system can assemble the target financial data by itself based on the data assembly structure and the data display structure, and display it on the client after assembly, realizing the multi-dimensional display of the target financial data. However, using the API layer to obtain the target financial data cannot meet the multi-dimensional display requirements of the target financial data in different scenarios.
[0064] In an optional embodiment, after receiving the data acquisition request for target financial data sent using the preset financial control, the method further includes:
[0065] Receive the merchant reconciliation and settlement method selected by the target user;
[0066] The data assembly structure is determined based on the merchant reconciliation and write-off method selected above.
[0067] Specifically, different merchant reconciliation and write-off methods have different data assembly structures. In addition, different data assembly structures can also be used in different scenarios selected by the user, with each scenario corresponding to a data assembly structure, including but not limited to cost centers, data reports, etc.
[0068] In an optional embodiment, the step of obtaining the target financial data from the data source based on the query statement and feeding it back to the client for display by the client includes:
[0069] Obtain the target financial data from the data source based on the query statement;
[0070] The above-mentioned target financial data is spliced according to the above-mentioned data splicing structure, and fed back to the client configured with the above-mentioned preset financial control to be displayed through the client.
[0071] The GraphQL schema defined on the server provides the source for all currently available data retrieval. The front-end system can read (query) and write (mutate) data based on the GraphQL schema. Therefore, after introducing the GraphQL layer, the server-side data source provides all available data, and the front-end system only needs to use GraphQL to query and obtain the target financial data. Data sources include but are not limited to databases, other service applications, and third-party APIs.
[0072] Specifically, if Figure 7 As shown in the architecture, the front-end system can request all queries from the GraphQL layer through preset financial controls. The GraphQL schema represents the range of available data that the GraphQL layer can respond to, including several master and slave libraries. After the front-end system generates a data acquisition request through the preset financial controls, it generates a query statement after authentication and authorization by the GraphQL layer, expressing the data requirements in a declarative manner. At the same time, the front-end system performs a query cost analysis on the data acquisition request, thereby limiting the amount of data used in the query, setting a timeout to terminate requests that require a long time to parse, and also limiting the processing rate. Then, the target financial data is obtained from the data source on the server side according to the query statement.
[0073] In an optional embodiment, the target financial data is spliced according to the data splicing structure and fed back to a client configured with the preset financial control for display through the client, including:
[0074] Confirm the restricted date based on the target user's fund flow timeframe;
[0075] The above target financial data is spliced according to the above data splicing structure, and the target financial data with the above restricted date is fed back to the client as the target logistics waybill flow for display.
[0076] Furthermore, when the target logistics waybill flow is fed back to the client, it is assembled based on the data display structure of the data template of the client's preset financial control and displayed using the corresponding data display structure.
[0077] In an optional embodiment, after obtaining the target financial data from the data source based on the query statement and feeding it back to the client for display by the client, the method further includes:
[0078] Compare the above-mentioned target logistics waybill flow with the above-mentioned cash flow to conduct logistics account write-off.
[0079] When displaying the assembled target logistics waybill flow from the logistics system on the client, users collate the fund flows for the restricted date using the user account of the fund receiving channel. This includes both fund receipts and refunds. The assembled target logistics waybill flow and fund flow are displayed on the client, and any abnormal data is annotated to facilitate reconciliation of logistics accounts.
[0080] In an optional embodiment, the merchant reconciliation and write-off method includes at least write-off by balance, write-off by document, and write-off by order quantity.
[0081] The following describes in detail the method for processing logistics financial data through a specific embodiment:
[0082] Based on user type and needs, a user data template is generated for each user. Preset financial controls are then built based on the user data template, and the corresponding pre-set financial controls are configured in each user's client. The user data template defines different data display structures to achieve multi-dimensional display of target financial data.
[0083] like Figure 8 As shown, when a user uses the financial reconciliation and write-off service through the logistics system, a data acquisition request is generated through the preset financial control to request the target financial data and select the merchant reconciliation and write-off method according to their own needs.
[0084] After receiving a data retrieval request and the merchant reconciliation method selected by the user, a query statement is generated based on the data retrieval request using a graph-based data query language. This query statement retrieves the target financial data from the server's data source in one go. Simultaneously, the user selects a restricted date in their account and retrieves the fund flow for that restricted date. This fund flow can include both inbound and refund flows.
[0085] After obtaining the target financial data, the data assembly structure is determined based on the merchant reconciliation and write-off method selected by the user, and the target financial data is spliced according to the data assembly structure. The restricted date is confirmed based on the capital flow, and the spliced target financial data with the restricted date is fed back to the user's client as the target logistics waybill flow.
[0086] The client further assembles the target logistics waybill flow using its pre-set financial control data display structure and displays it on the client. Users can also import funds flow from their own user accounts into the client's display page and compare the assembled target logistics waybill flow with the funds flow. On the display page, users can visually compare the waybill details in the target logistics waybill flow with the funds flow, marking any abnormal data for logistics account write-offs.
[0087] According to the technical solution of the embodiment of the present invention, by setting different preset financial controls in the front-end system, the target financial data of the corresponding data template is obtained according to the user's expectations, thereby avoiding the problem of only being able to obtain the specified data fields preset by the API layer, thereby failing to meet the diverse needs of merchants. For new users of different user types or with different user needs, it is only necessary to develop and set up corresponding preset financial controls in the front-end system, without increasing the development work on the server side. By replacing the development of the API layer with a graphical data query language, a declarative language is provided for the front-end system, and the front-end system can define the data structure and express data requirements by itself. When obtaining data, it only needs to generate a query statement of the graphical data query language based on the data acquisition request, and the required target financial data can be obtained according to the query statement, without obtaining non-essential data fields. This solves the problem of the API layer returning a request covering redundant fields, causing the front-end system to obtain excessive non-essential data, thereby reducing the waste of network and memory resources.
[0088] Figure 9 2 is a schematic diagram of main modules of a logistics financial data processing device according to an embodiment of the present invention.
[0089] like Figure 9 As shown, the logistics financial data processing device 900 of the embodiment of the present invention includes:
[0090] Receiving module 901, configured to receive a data acquisition request for target financial data sent using a preset financial control;
[0091] A generating module 902 is configured to generate a query statement using a graph data query language based on the data acquisition request;
[0092] The acquisition module 903 is configured to acquire the target financial data from a data source based on the query statement and feed the target financial data back to the client so that the client can display the data.
[0093] In an optional embodiment of the present invention, the method for setting the preset financial control includes: generating a user data template based on the user type and user needs of the target user; and constructing the preset financial control corresponding to the target user according to the user data template.
[0094] In an optional embodiment of the present invention, the receiving module 901 is further configured to: receive the merchant reconciliation and settlement method selected by the target user; and determine a data assembly structure according to the selected merchant reconciliation and settlement method.
[0095] In an optional embodiment of the present invention, the acquisition module 903 is further used to: obtain the target financial data from the data source based on the query statement; splice the target financial data according to the data assembly structure, and feed it back to the client configured with the preset financial control for display through the client.
[0096] In an optional embodiment of the present invention, the above-mentioned target financial data is spliced according to the above-mentioned data splicing structure, and fed back to the client configured with the above-mentioned preset financial control for display through the client, including: confirming the restriction date according to the time range of the above-mentioned target user's capital flow; splicing the above-mentioned target financial data according to the above-mentioned data splicing structure, and feeding back the target financial data with the splicing completed on the above-mentioned restriction date as the target logistics waybill flow to the client for display.
[0097] In an optional embodiment of the present invention, the above-mentioned device further includes: a comparison module, which is used to compare the above-mentioned target logistics waybill flow and the above-mentioned capital flow to perform logistics account write-off.
[0098] In an optional embodiment of the present invention, the merchant reconciliation and write-off methods include write-off by balance, write-off by document, and write-off by order quantity.
[0099] According to the technical solution of the embodiment of the present invention, by setting different preset financial controls, the target financial data of the corresponding data template is obtained according to the user's expectations, avoiding the problem of only being able to obtain the specified data fields preset by the API layer, thereby failing to meet the diverse needs of merchants; by replacing the development of the API layer with a graphical data query language, a declarative language is provided for the front-end system, and the front-end system can define the data structure and express data requirements by itself. When obtaining data, it only needs to generate a query statement of the graphical data query language based on the data acquisition request. According to the query statement, the required target financial data can be obtained, and there is no need to obtain non-essential data fields. This solves the problem of the API layer returning a request covering redundant fields, causing the front-end system to obtain excessive non-essential data, and reduces the waste of network and memory resources.
[0100] Figure 10 An exemplary system architecture 1000 is shown to which the logistics financial data processing method or the logistics financial data processing apparatus according to the embodiment of the present invention can be applied.
[0101] like Figure 10As shown, system architecture 1000 may include terminal devices 1001, 1002, and 1003, a network 1004, and a server 1005. Network 1004 is used to provide a medium for communication links between terminal devices 1001, 1002, and 1003 and server 1005. Network 1004 may include various connection types, such as wired or wireless communication links or fiber optic cables.
[0102] Users can use terminal devices 1001, 1002, and 1003 to interact with server 1005 via network 1004 to receive or send data, etc. Various communication client applications can be installed on terminal devices 1001, 1002, and 1003, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc.
[0103] The terminal devices 1001 , 1002 , and 1003 may be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers, etc. The user initiates a data acquisition request using the terminal devices 1001 , 1002 , and 1003 .
[0104] Server 1005 can be a server that provides various services, such as a backend management server that generates query statements based on data acquisition requests sent by users using terminal devices 1001, 1002, and 1003, and provides support for data acquisition based on the query statements. The backend management server can perform data query and acquisition from data sources based on the query statements, and feed back the processing results (e.g., target financial data) to the terminal device.
[0105] It should be noted that the logistics financial data processing method provided in the embodiment of the present invention is generally executed by the server 1005 , and accordingly, the logistics financial data processing device is generally set in the server 1005 .
[0106] It should be understood that Figure 10 The number of terminal devices, networks and servers in the embodiment is merely illustrative. Any number of terminal devices, networks and servers may be provided as required.
[0107] Reference below Figure 11 , which shows a schematic structural diagram of a computer system 1100 of a terminal device suitable for implementing an embodiment of the present invention. Figure 11 The terminal device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0108] like Figure 11As shown, the computer system 1100 includes a central processing unit (CPU) 1101, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1102 or a program loaded from a storage unit 1108 into a random access memory (RAM) 1103. Various programs and data required for the operation of the system 1100 are also stored in the RAM 1103. The CPU 1101, the ROM 1102, and the RAM 1103 are connected to each other via a bus 1104. An input / output (I / O) interface 1105 is also connected to the bus 1104.
[0109] The following components are connected to the I / O interface 1105: an input section 1106 including a keyboard, a mouse, and the like; an output section 1107 including devices such as a cathode ray tube (CRT), a liquid crystal display (LCD), and a speaker; a storage section 1108 including a hard disk; and a communication section 1109 including a network interface card such as a LAN card or a modem. The communication section 1109 performs communication processing via a network such as the Internet. A drive 1110 is also connected to the I / O interface 1105 as needed. Removable media 1111, such as a magnetic disk, an optical disk, a magneto-optical disk, or a semiconductor memory, is installed in the drive 1110 as needed, so that computer programs read therefrom can be installed into the storage section 1108 as needed.
[0110] In particular, according to the embodiments disclosed in the present invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, the embodiments disclosed in the present invention include a computer program product comprising a computer program carried on a computer-readable medium, the computer program comprising program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network via the communication section 1109, and / or installed from a removable medium 1111. When the computer program is executed by the central processing unit (CPU) 1101, the above-mentioned functions defined in the system of the present invention are performed.
[0111] It should be noted that the computer-readable medium described in the present invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media can include, but are not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. This propagated data signal can take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device. Program code embodied on a computer-readable medium may be transmitted using any suitable medium, including but not limited to wireless, wireline, optical fiber cable, RF, or any suitable combination thereof.
[0112] The flowcharts and block diagrams in the accompanying drawings illustrate the possible implementation architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present invention. In this regard, each box in the flowchart or block diagram can represent a module, program segment, or a part of code, and the above-mentioned module, program segment, or a part of code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in an order different from that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0113] The modules described in the embodiments of the present invention may be implemented via software or hardware. The modules described may also be provided within a processor. For example, a processor may be described as comprising a receiving module, a generating module, and an acquiring module. The names of these modules do not, in some cases, limit the modules themselves. For example, the receiving module may also be described as a "module that receives a data acquisition request for target financial data sent using a preset financial control."
[0114] As another aspect, the present invention further provides a computer-readable medium, which may be included in the device described in the above embodiments, or may exist independently and not incorporated into the device. The computer-readable medium carries one or more programs. When executed by the device, the device performs the following steps: receiving a data acquisition request for target financial data sent using a preset financial control; generating a query statement using a graphical data query language based on the data acquisition request; and acquiring the target financial data from a data source based on the query statement and transmitting the query statement to a client for display.
[0115] According to the technical solution of the embodiment of the present invention, by setting different preset financial controls, the target financial data of the corresponding data template is obtained according to the user's expectations, avoiding the problem of only being able to obtain the specified data fields preset by the API layer, thereby failing to meet the diverse needs of merchants; by replacing the development of the API layer with a graphical data query language, a declarative language is provided for the front-end system, and the front-end system can define the data structure and express data requirements by itself. When obtaining data, it only needs to generate a query statement of the graphical data query language based on the data acquisition request. According to the query statement, the required target financial data can be obtained, and there is no need to obtain non-essential data fields. This solves the problem of the API layer returning a request covering redundant fields, causing the front-end system to obtain excessive non-essential data, and reduces the waste of network and memory resources.
[0116] The above specific embodiments do not limit the scope of protection of the present invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions may occur depending on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention are intended to be included within the scope of protection of the present invention.
Claims
1. A logistics financial data processing method, characterized in that: include: Receiving a data acquisition request for target financial data sent using a preset financial control; Generate a query statement using a graph data query language based on the data acquisition request; The target financial data is obtained from a data source based on the query statement and fed back to the client so that the client can display it.
2. The logistics financial data processing method according to claim 1, characterized in that: The method for setting the preset financial control includes: Generate user data templates based on the user type and user needs of target users; Construct a preset financial control corresponding to the target user according to the user data template.
3. The logistics financial data processing method according to claim 2, characterized in that: After receiving the data acquisition request for target financial data sent using the preset financial control, the method further includes: Receiving the merchant reconciliation and settlement method selected by the target user; The data assembly structure is determined according to the selected merchant reconciliation and write-off method.
4. The logistics financial data processing method according to claim 3, characterized in that: The acquiring the target financial data from the data source based on the query statement and feeding it back to the client so that the client can display the data includes: Acquire the target financial data from a data source based on the query statement; The target financial data is spliced according to the data splicing structure and fed back to a client configured with the preset financial control so as to be displayed through the client.
5. The logistics financial data processing method according to claim 4, characterized in that: The step of splicing the target financial data according to the data splicing structure and feeding the data back to a client configured with the preset financial control for display through the client includes: Confirm the restriction date based on the time range of the target user's fund flow; The target financial data is spliced according to the data splicing structure, and the target financial data with the spliced restricted date is fed back to the client as the target logistics waybill flow for display.
6. The logistics financial data processing method according to claim 5, characterized in that: After acquiring the target financial data from the data source based on the query statement and feeding it back to the client so that the client can display it, the method further includes: Compare the target logistics waybill flow and the cash flow to write off the logistics accounts.
7. The logistics financial data processing method according to claim 3, characterized in that: The merchant reconciliation and write-off methods include write-off by balance, write-off by document, and write-off by order quantity.
8. A logistics financial data processing device, characterized in that: include: A receiving module, configured to receive a data acquisition request for target financial data sent using a preset financial control; A generating module, configured to generate a query statement using a graph data query language based on the data acquisition request; The acquisition module is used to acquire the target financial data from a data source based on the query statement and feed the target financial data back to the client so that the client can display the target financial data.
9. An electronic device for processing logistics financial data, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 7.
10. A computer-readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.
Citation Information
Patent Citations
Report generation method and system
CN105843945A
Information query method and device, electronic equipment and readable storage medium
CN113094574A
Data processing method for enterprise application integration and related device
CN114328492A
Script acquisition method and device
CN114816377A
Data query method, server, equipment and storage medium
CN115982199A
