Information processing method and device, electronic equipment and computer readable medium
By receiving information processing requests, obtaining bill information files and processing fee item information in the order number merge cache, generating waybill dimension fee information, and executing information transmission programs to realize online return, solving the problem of extending the information cycle by manually checking and improving the problem of improving The speed and accuracy of waybill verification are improved, and business processing efficiency is improved.
Patent Information
- Application Number
- CN202310943298.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-07-28
- Publication Date
- 2025-02-14
AI Technical Summary
As the merchant’s business develops, the verification cycle becomes longer and longer, resulting in the extension of the collection cycle of both parties and the inefficient business processing.
By receiving information processing requests, obtaining bill information files, traversing the line information in the file to obtain header information, mapping the line information into expense item information, and processing this information in the order number merge cache, generating waybill dimension fee information, and executing information Transfer the program to achieve online return.
Through online return, the speed and accuracy of waybill checking is improved and the efficiency of business processing is improved.
Smart Images

Figure CN119444451A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to an information processing method, device, electronic device and computer-readable medium. Background Art
[0002] At present, merchants have three modes for freight: cash on delivery, pay by post, and monthly settlement. The verification of monthly bills is an offline mode, that is, exporting EXCEL files from the logistics and merchant settlement systems respectively, and checking each waybill item by item. Manual verification As the merchant's business develops, the verification cycle becomes longer and longer, which makes the collection cycle of both parties longer and longer, making the corresponding business processing efficiency low.
[0003] In the process of implementing this application, the inventors found that there are at least the following problems in the prior art:
[0004] As the merchant's business develops, the verification cycle of manual information becomes longer and longer, which makes the collection cycle of both parties longer and longer, making the corresponding business processing efficiency inefficient. Summary of the invention
[0005] In view of this, the embodiments of the present application provide an information processing method, device, electronic device and computer-readable medium, which can solve the problem that the verification cycle of existing manual information verification becomes longer and longer as the merchant's business develops, resulting in low efficiency of corresponding business processing.
[0006] To achieve the above objective, according to one aspect of an embodiment of the present application, there is provided an information processing method, including:
[0007] Receive information processing requests and obtain corresponding billing information files;
[0008] Traverse the row information in the bill information file to obtain the corresponding header information;
[0009] Map the row information to the expense item information based on the header information;
[0010] In response to the fact that the expense item information does not exist in the order number merge cache, writing the expense item information into the order number merge cache, and in response to the fact that the expense detail list corresponding to the expense item information exists in the order number merge cache, acquiring the corresponding cache value;
[0011] Merge the cache value with the fee item information to generate waybill dimension fee information and execute the information transmission procedure based on the waybill dimension fee information.
[0012] Optionally, the information processing method further includes:
[0013] In response to the fact that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, an empty list is initialized, the expense item information is added to the empty list and written into the order number merge cache.
[0014] Optionally, the information processing method further includes:
[0015] In response to the existence of the fee item information in the order number merge cache and the waybill number in the waybill number merge cache is different from the waybill number corresponding to the fee item information, the cache value and the fee item information are merged to generate the waybill dimension fee information.
[0016] Optionally, an information transmission procedure is performed based on the waybill dimension cost information, including:
[0017] Obtain the delivery ID, billing ID and billing status ID carried in the information processing request;
[0018] The waybill fee information is stored according to the delivery ID, billing ID and billing status ID.
[0019] Optionally, store shipping cost information, including:
[0020] Determine the file type corresponding to the waybill fee information;
[0021] Upload the waybill fee information to the cloud storage based on the file type, delivery ID, billing ID, and billing status ID.
[0022] Optionally, after uploading the waybill fee information to the cloud storage, the method further includes:
[0023] Call the return program to download the waybill cost information from the cloud storage and execute the corresponding parsing program according to the corresponding file type to obtain the return data;
[0024] Transmit the return data to a third-party system.
[0025] Optionally, a parsing program, including:
[0026] When the file type is a data file, check whether the order number merge cache contains header information. If not, execute the exception retry logic. If yes, read the header information and parse the data file based on the header information.
[0027] In addition, the present application also provides an information processing device, including:
[0028] A receiving unit, configured to receive an information processing request and obtain a corresponding billing information file;
[0029] A header information acquisition unit is configured to traverse the row information in the bill information file to acquire corresponding header information;
[0030] a mapping unit configured to map the row information into the expense item information according to the header information;
[0031] a cache value acquisition unit configured to write the expense item information into the order number merge cache in response to the expense item information not existing in the order number merge cache, and to acquire the corresponding cache value in response to the expense detail list corresponding to the expense item information existing in the order number merge cache;
[0032] The execution unit is configured to merge the cache value with the fee item information to generate waybill dimension fee information and execute the information transmission program based on the waybill dimension fee information.
[0033] Optionally, the information processing device further includes an information adding unit configured to:
[0034] In response to the fact that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, an empty list is initialized, the expense item information is added to the empty list and written into the order number merge cache.
[0035] Optionally, the information processing device further includes a merging unit configured to:
[0036] In response to the existence of the fee item information in the order number merge cache and the waybill number in the waybill number merge cache is different from the waybill number corresponding to the fee item information, the cache value and the fee item information are merged to generate the waybill dimension fee information.
[0037] Optionally, the execution unit is further configured to:
[0038] Obtain the delivery ID, billing ID and billing status ID carried in the information processing request;
[0039] The waybill fee information is stored according to the delivery ID, billing ID and billing status ID.
[0040] Optionally, the execution unit is further configured to:
[0041] Determine the file type corresponding to the waybill fee information;
[0042] Upload the waybill fee information to the cloud storage based on the file type, delivery ID, billing ID, and billing status ID.
[0043] Optionally, the execution unit is further configured to:
[0044] Call the return program to download the waybill cost information from the cloud storage and execute the corresponding parsing program according to the corresponding file type to obtain the return data;
[0045] Transmit the return data to a third-party system.
[0046] Optionally, the execution unit is further configured to:
[0047] When the file type is a data file, check whether the order number merge cache contains header information. If not, execute the exception retry logic. If yes, read the header information and parse the data file based on the header information.
[0048] In addition, the present application also provides an information processing electronic device, including: one or more processors; a storage device for storing one or more programs, when the one or more programs are executed by one or more processors, the one or more processors implement the information processing method as described above.
[0049] In addition, the present application also provides a computer-readable medium on which a computer program is stored, and when the program is executed by a processor, the above-mentioned information processing method is implemented.
[0050] One embodiment of the above invention has the following advantages or beneficial effects: the present application obtains the corresponding bill information file by receiving an information processing request; traverses the row information in the bill information file to obtain the corresponding header information; maps the row information to the expense item information according to the header information; in response to the expense item information not existing in the order number merge cache, writes the expense item information into the order number merge cache, and in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtains the corresponding cache value; merges the cache value with the expense item information to generate the waybill dimension expense information and executes the information transmission program based on the waybill dimension expense information. The subsequent online backhaul of the bill data based on the waybill dimension expense information facilitates waybill verification, improves the speed and accuracy of waybill verification, and improves the corresponding business processing efficiency.
[0051] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0052] The accompanying drawings are used to better understand the present application and do not constitute an improper limitation on the present application.
[0053] Figure 1 It is a schematic diagram of the main process of the information processing method provided according to one embodiment of the present application (I);
[0054] Figure 2 It is a schematic diagram of the main process of the information processing method provided according to one embodiment of the present application (II);
[0055] Figure 3 It is a schematic diagram of an application scenario of an information processing method provided according to an embodiment of the present application;
[0056] Figure 4It is a schematic diagram of the process of receiving and dumping bill files according to an information processing method provided in one embodiment of the present application;
[0057] Figure 5 This is a flowchart of parsing bill files and returning them to the merchant system according to an information processing method provided in one embodiment of the present application;
[0058] Figure 6 It is a schematic diagram of the process of checking whether the returned information is complete according to the information processing method provided in one embodiment of the present application;
[0059] Figure 7 is a schematic diagram of main units of an information processing device according to an embodiment of the present application;
[0060] Figure 8 is an exemplary system architecture diagram to which the embodiments of the present application can be applied;
[0061] Fig. 9 It is a structural diagram of a computer system of a terminal device or server suitable for implementing an embodiment of the present application. DETAILED DESCRIPTION
[0062] The following is a description of exemplary embodiments of the present application in conjunction with the accompanying drawings, including various details of the embodiments of the present application to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the present application. Similarly, for the sake of clarity and conciseness, the description of well-known functions and structures is omitted in the following description.
[0063] It should be noted that the collection, collection, updating, analysis, processing, use, transmission, storage and other aspects of user personal information involved in the technical solution of this disclosure are in compliance with the provisions of relevant laws and regulations, are used for legitimate purposes, and do not violate public order and good morals. Necessary measures are taken for user personal information to prevent illegal access to user personal information data and maintain the security of user personal information, network security and national security.
[0064] Figure 1 is a schematic diagram of the main process of the information processing method provided according to an embodiment of the present application (I), such as Figure 1 As shown, the information processing method includes:
[0065] Step S101, receiving an information processing request and obtaining a corresponding billing information file.
[0066] In this embodiment, the execution subject of the information processing method (for example, it can be a server) can receive the information processing request through a wired connection or a wireless connection. The information processing request can, for example, be a request for online transmission of billing data. After receiving the information processing request, the execution subject can obtain the corresponding billing information file. The billing information file can, for example, be a file that needs to be transmitted online. For example, the billing information file is a file composed of billing data generated between logistics and merchants.
[0067] Step S102, traverse the row information in the bill information file to obtain corresponding header information.
[0068] After obtaining the corresponding bill information file, the execution subject can traverse the row information in the bill information file. The row information refers to the information corresponding to each row in the bill information file. After traversing the row information, the header information corresponding to each row information can be obtained.
[0069] Step S103: Map the row information to expense item information according to the header information.
[0070] The row information is parsed according to the header information, and specifically each column of data in the row information is mapped to a corresponding expense item field to obtain mapped expense item information.
[0071] Step S104, in response to the expense item information not existing in the order number merge cache, write the expense item information into the order number merge cache, and in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtain the corresponding cache value.
[0072] The order number merge cache stores the fee item information corresponding to each order number. After obtaining the fee item information, the execution subject can match the obtained fee item information with the fee item information in the order number merge cache. If there is matching fee item information (that is, there is the same information as the obtained fee item information in the order number merge cache), the cache value corresponding to the fee item information is obtained from the order number merge cache; if there is no matching fee item information, the obtained fee item information is added to the order number merge cache.
[0073] Step S105, merging the cache value and the fee item information to generate waybill dimension fee information and executing the information transmission program based on the waybill dimension fee information.
[0074] Specifically, the information processing method further includes: in response to the existence of the fee item information in the order number merge cache and the waybill number in the waybill number merge cache is different from the waybill number corresponding to the fee item information, merging the cache value with the fee item information to generate the waybill dimension fee information. This ensures that multiple fee information of the same waybill dimension appear continuously in the same file, improves the efficiency of subsequent verification of the corresponding waybill, and further improves the processing efficiency of related businesses.
[0075] The cache value corresponding to the current waybill number in the cost detail list in the waybill merge cache is taken out, and combined with the current cost item information into a waybill dimension cost information, i.e., the waybill dimension cost information. An information transmission program is executed based on the waybill dimension cost information to transmit the combined cost information to the third-party merchant system.
[0076] Specifically, an information transmission procedure is executed based on the waybill dimension cost information, including: obtaining the delivery identification, billing identification and billing status identification carried in the information processing request; storing the waybill cost information according to the delivery identification, billing identification and billing status identification.
[0077] For example, for a machine in the feedback system that does not have external network access rights, after receiving a message that the summary information has been successfully uploaded to the cloud storage, the execution entity can send summary information to the merchant system, including the number of bills, the number of waybill details to be returned, and the bill status. Among them, the number of bills can be obtained through the billing identifier, the number of waybill details to be returned can be obtained through the delivery identifier, and the bill status can be determined by the billing status identifier. The execution entity can then obtain the number of waybill details to be returned, the number of bills, and the bill status according to the delivery identifier, the billing identifier, and the billing status identifier, respectively, and then locate the target storage location corresponding to the delivery identifier, the billing identifier, and the billing status identifier in the cloud storage to store the waybill fee information such as the number of bills, the number of waybill details to be returned, the bill status, etc.
[0078] Specifically, storing the waybill fee information includes: determining the file type corresponding to the waybill fee information; and uploading the waybill fee information to the cloud storage according to the file type, delivery identification, bill identification and bill status identification.
[0079] After the billing feedback system receives the message of successful file upload, it can log in to the pre-agreed server, enter the directory with the same name according to the delivery identifier (such as the delivery code) in the message, and enter the corresponding directory according to the billing identifier_billing status identifier (such as bill number_billing status code) in the message, traverse all files in the directory and upload them to cloud storage. After each file is uploaded successfully, a successful upload to cloud storage message is sent.
[0080] Specifically, after uploading the waybill charge information to the cloud storage, the method further includes: calling a return program to download the waybill charge information from the cloud storage and executing a corresponding parsing program according to a corresponding file type to obtain return data; transmitting the return data to a third-party system.
[0081] Specifically, the parsing program includes: when the file type is a data file, querying whether the order number merge cache contains header information, if not, executing the exception retry logic, and if so, reading the header information and parsing the data file based on the header information.
[0082] In the embodiment of the present application, the file type corresponding to the waybill fee information may be, for example, a summary file or a data file. When the file type is a summary file, the header information is parsed and stored in the cache. When a data file is received, the cache is queried to see whether it contains the header information. If not, the abnormal retry logic is entered; if it contains the header, the header data is read and the data file is parsed according to the header data (the data in each column is mapped to the corresponding fee item field). If the waybill number of the next row of data is consistent with the currently processed data, the details are not returned, but the next row of data is read continuously, and the fee details are merged into a list in the memory according to the waybill number to generate the waybill dimension data; if the data of the next row is inconsistent with the waybill number of the current row, the merged waybill dimension data is returned to the third-party system, which may be a merchant system, for example.
[0083] This embodiment receives an information processing request to obtain the corresponding bill information file; traverses the row information in the bill information file to obtain the corresponding header information; maps the row information to the expense item information according to the header information; in response to the expense item information not existing in the order number merge cache, writes the expense item information into the order number merge cache; in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtains the corresponding cache value; merges the cache value with the expense item information to generate the waybill dimension expense information and executes the information transmission program based on the waybill dimension expense information. The subsequent online backhaul of the bill data based on the waybill dimension expense information facilitates waybill verification, improves the speed and accuracy of waybill verification, and improves the corresponding business processing efficiency.
[0084] Figure 2 is a schematic diagram of the main flow of the information processing method provided according to an embodiment of the present application (II), such as Figure 2 As shown, the information processing method includes:
[0085] Step S201, receiving an information processing request and obtaining a corresponding billing information file.
[0086] The information processing request may be, for example, a request for online transmission of billing data. After receiving the information processing request, the execution subject may obtain the billing information file corresponding to the request. The billing information file may be, for example, a file consisting of billing data generated by a transaction between a supplier and a consumer user.
[0087] Step S202, traverse the row information in the bill information file to obtain corresponding header information.
[0088] The bill information file is processed by lines to obtain the corresponding line information of the bill information file. The header information corresponding to each line information is obtained.
[0089] Step S203: Map the row information to expense item information according to the header information.
[0090] Map each column of data in the row information to the corresponding expense item field to obtain mapped expense item information.
[0091] Step S204, in response to the expense item information not existing in the order number merge cache, write the expense item information into the order number merge cache, and in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtain the corresponding cache value.
[0092] When the expense item information does not exist in the order number merge cache, the execution subject can execute the information writing program to determine the write location A corresponding to the expense item information, so as to write the expense item information to the write location A in the order number merge cache. When the expense detail list corresponding to the expense item information exists in the order number merge cache, the execution subject can obtain the corresponding cache value from the order number merge cache.
[0093] Step S205, in response to the fact that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, an empty list is initialized, the expense item information is added to the empty list and written into the order number merge cache.
[0094] When it is detected that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, the execution entity can execute an empty list initialization program to initialize an empty list for storing the expense detail list corresponding to the expense item information, and write the empty list containing the expense detail list corresponding to the expense item information into the order number merge cache.
[0095] Step S206, merging the cache value and the fee item information to generate waybill dimension fee information and executing the information transmission program based on the waybill dimension fee information.
[0096] The cache value may be, for example, a specific fee amount, fee type, etc. The embodiment of the present application does not specifically limit the cache value.
[0097] Figure 3 Schematic diagram of an application scenario of an information processing method provided according to an embodiment of the present application. The information processing method of the embodiment of the present application can be applied to the scenario of online backhaul of billing data. Figure 3 As shown, a row of data is obtained from the EXCEL of the bill information file, the header information is obtained from the cache, and the obtained row of data is mapped into a fee item information according to the header information. It is determined whether the fee item information exists in the order number merge cache. If it exists, it is further determined whether the cached waybill number is the same as the waybill number of the current fee item. If they are not the same, the cache value of the fee detail list of the current waybill number is taken out and merged with the current fee item information into a fee information; if the fee item information does not exist in the order number merge cache, the waybill number of the current fee item data is written into the order number merge cache, and it is further determined whether the fee detail list cache of the current waybill number exists. If it does not exist, an empty list is initialized, the current fee item information is added to the list, and written into the order number merge cache, and then it is further determined whether there is the next row of data. If not, the cache value of the fee detail list of the current waybill number is taken out and merged with the current fee item information into a fee information of the waybill dimension. If the cost detail list cache of the current waybill number exists, the current cost item information is appended to the cache value, and it is determined whether there is the next row of data. If not, the cost detail list cache value of the current waybill number is taken out and merged with the current cost item information into a cost information of the waybill dimension.
[0098] For example, the information processing method can be specifically implemented through the following steps: generating a bill file, uploading the bill file to cloud storage, returning summary information, returning bill detail information, and discovering and retransmitting abnormal data.
[0099] The merchant system, logistics system, cloud storage, SFTP file server and settlement system used in the embodiments of the present application can all be called by the execution entity.
[0100] Specifically, generate a bill file: the business personnel export the bill EXCEL file according to the existing system operation process. The settlement system splits the EXCEL file into several small files according to the principle that each file does not exceed 100M. After the splitting is completed, a summary information file (text file) is generated to record the header information of the bill data file, the number of waybills involved in the bill, and the number of small files after the split, and the small files and summary information files are uploaded to the secure file transfer SFTP file server. After the upload is completed, a successful upload message is sent.
[0101] Bill file upload to cloud storage: The bill return system receives the file upload success message, logs in to the pre-agreed SFTP server, enters the directory with the same name according to the delivery code in the message, enters the corresponding directory according to the bill number_bill status code in the message, traverses all files in the directory and uploads them to cloud storage. After each file is uploaded successfully, a cloud storage upload success message is sent.
[0102] The reason for uploading to cloud storage instead of logging in to the SFTP server directly is that the SFTP resource is on the external network. For security reasons, only a few specific machines have external network access rights. If each machine that sends back the bill obtains the bill data through a few machines with external network access rights, the external network access bandwidth will become a business bottleneck. As the merchant's business develops, the efficiency of sending back the bill will become lower and lower. Summary information sending back: The machine that sends back the bill without external network access rights will send the summary information to the merchant system after receiving the message that the summary information has been successfully uploaded to the cloud storage, including the number of bills, the number of waybill details to be sent back, and the bill status (set to start at this time).
[0103] When a bill detail file is returned (the last piece of data is processed), check whether the number of files successfully returned by the current bill is consistent with the number of split files in the summary information. If so, send summary information to the merchant system, including the number of bills, the number of waybill details to be returned, and the bill status (set to end at this time); if not, check whether the time interval between the start time of bill detail return in the cache and the current time is greater than the timeout time (the default is 4 hours). If so, send summary information to the merchant system, including the number of bills, the number of waybill details to be returned, and the bill status (set to end at this time), otherwise do nothing.
[0104] Return of billing details: The machine that returns the system without external network access rights receives the successful upload message to the cloud storage, and downloads the summary file and data file through the cloud storage. When the summary file is received, the header information is parsed and stored in the cache. When the data file is received, the cache is queried to see if it contains the header information. If not, the exception retry logic is entered. If it contains a header, the header data is read and the data file is parsed according to the header data (the data in each column is mapped to the corresponding expense item field). If the waybill number of the next row of data is consistent with the currently processed data, the details are not returned. Instead, the next row of data is read and the expense details are merged into a list in the memory according to the waybill number to generate the waybill dimension data. If the waybill number of the next row of data is inconsistent with the current row, the merged waybill dimension data is returned to the merchant system.
[0105] Abnormal data discovery and retransmission: When all data is returned (triggered by a summary message that the billing status is ended), the returned information is verified. The total number of waybills is found from the database according to the bill number and compared with the query result of calling the merchant interface. If there is any inconsistency, an email is sent to the relevant person for investigation. If there is any consistency, the data is taken out from the database one by one and compared with the result returned by calling the merchant detailed information query interface. If there is any inconsistency, an email is sent to the relevant node for processing. After the relevant node confirms the data abnormality, the specified data can be modified in the bill return information management page and then retransmitted to the merchant system.
[0106] Figure 4 1 is a flow chart of receiving and dumping bill files according to an information processing method provided in an embodiment of the present application. Figure 4 The interactive diagram of the bill return system shown in the figure shows the process of receiving and dumping bill files. For example, the execution subject of the information processing method includes a merchant system, a logistics system, a cloud storage, an SFTP file server and a settlement system. Among them, SFTP, the full name of which is SSH File Transfer Protocol Server, is a secure file transfer service based on the SSH (Secure Shell) protocol. For example, in Figure 4 In the process, the logistics system receives and processes the upload completion message, then traverses the bill folder, reads the bill file from the SFTP file server, determines whether the file is read, and if not, traverses the bill folder until the bill file is read. If so, upload the read bill file to the storage file in the cloud storage, and the cloud storage sends a file upload cloud storage success message to the logistics system. The logistics system determines whether the file successfully uploaded to the cloud storage is a summary summary file. If it is not a summary summary file, it sends a data file upload cloud storage completion message. If it is a summary information summary file, it sends a summary information file upload cloud storage completion message, and then continues to determine whether it contains unread files. If not, it ends. If so, it continues to traverse the bill folder until the bill file is read. For the settlement system, the export file can be manually triggered. The export task splits the bill data into independent files according to the threshold of 100M (only an example, this application does not specifically limit the threshold), generates a summary information summary file (describing the number of waybills, the number of split files, and the header information of the bill file), and then uploads the file, calls the SFTP file server to store the file, and sends an upload completion message. This can improve the efficiency and accuracy of dumping bill files after receiving the bill file.
[0107] Figure 5 1 is a flowchart of parsing bill files and returning them to the merchant system according to an information processing method provided in an embodiment of the present application. Figure 5The interactive diagram of the bill return system shown in FIG. 1 shows the process of parsing the bill file and returning it to the merchant system. In this process, the merchant system, logistics system and SFTP file server in the execution body are used. For example, Figure 5 As shown, the logistics system receives and processes the summary information upload cloud storage completion message, sends the summary information to the merchant system (billing status: start to return), and the merchant system receives the summary information. The logistics system determines whether the header information of the current bill in the cache already exists. If not, it retries to receive and process the data file, uploads the cloud storage completion message, and determines whether the currently processed file is a summary file (determined by the file name). If it is a summary file, it reads the header information and sets the cache. If it is not a summary file, it continues to determine whether the header information of the current bill in the cache already exists. If it does exist, it reads a row of data, and then maps the data into standard fee item data according to the header, merges the fee item information according to the waybill number, and then converts it into merchant detailed information, sends the detailed information to the merchant system, and the merchant system receives the detailed information. The logistics system continues to determine whether there is the next row of data in the current bill in the cache. If there is, it continues to read until it is converted into merchant detailed data. If there is no next row of data, it is determined that the bill file is returned successfully, and the cache +1 is processed. The logistics system continues to determine whether the number of successful bill file returns is equal to the number of split files in the summary information summary file, or whether the time from the start of bill return to the current time is greater than the preset timeout (for example, the preset timeout can be 4 hours). If it is not greater than the preset timeout, it ends. If it is greater than the preset timeout, it sends summary information to the merchant system (bill status: end return), sends a bill file archiving message, sends a bill data verification message, and the merchant system receives the summary message (end). In addition, the logistics system also receives detailed information and stores it in the warehouse. Receive and process the bill file archiving message, move the corresponding bill data on the SFTP in the message to the archiving directory, and the SFTP file server moves the bill data to the archiving directory. The bill parsing automation is realized, the efficiency and accuracy of bill parsing are improved, and the efficiency of returning the parsed bill files to the merchant system is improved, and the efficiency of corresponding business processing is improved.
[0108] Figure 6 FIG. 1 is a flow chart of checking whether the returned information is complete according to an information processing method provided in an embodiment of the present application. Figure 6 The bill return system interaction diagram shown in FIG. 1 shows the process of verifying whether the return information is complete. For example, Figure 6As shown, the merchant system and logistics system of the execution subject are used in this process. The logistics system receives and processes the bill data verification information, queries the corresponding total data in the database according to the bill number, and sends it to the merchant system. The merchant system queries the number of successfully received waybills corresponding to the bill number. The logistics system queries the total number of waybills received by the merchant, and determines whether the total number of data in the database queried according to the bill number is consistent with the number of successfully received waybills corresponding to the bill number queried by the merchant system. If the total number is inconsistent, manual exception processing is performed. If the total number is consistent, a piece of data is read from the database. The logistics system queries the data received by the merchant based on the corresponding bill number and waybill number based on the read data, that is, the merchant system queries the freight information based on the bill number and waybill number in the read data, and then determines whether the details of the data (or information) queried by the logistics system and the merchant system are consistent. If the details are inconsistent, manual exception processing is performed. If the details are consistent, it is determined whether there is any unread data in the database. If there is no unread data in the database, the information processing process is terminated. If there is still unread data in the database, a piece of data is continued to be read from the database, and the details are continued to be determined based on the read data. Whether the details are consistent until there is no unread data in the database, the information processing process is terminated. For example, when all data is returned (triggered by the summary message that the bill status is ended), the returned information is verified, the total number of waybills is found from the database according to the bill number and compared with the query result of calling the merchant interface. If there is inconsistency, the relevant person is notified by email for investigation. If there is consistency, the data is taken out from the database one by one and compared with the result returned by calling the merchant detailed information query interface. If there is inconsistency, the relevant node is notified by email for processing. After the relevant node confirms the data abnormality, it can modify the specified data in the bill return information management page and then return it to the merchant system. This ensures the accuracy of information processing, improves the efficiency of information processing and improves the success rate of information processing.
[0109] Figure 7 is a schematic diagram of the main units of the information processing device according to an embodiment of the present application. Figure 7 As shown, the information processing device 700 includes a receiving unit 701, a header information obtaining unit 702, a mapping unit 703, a cache value obtaining unit 704 and an execution unit 705.
[0110] The receiving unit 701 is configured to receive an information processing request and obtain a corresponding billing information file.
[0111] The header information acquisition unit 702 is configured to traverse the row information in the bill information file to acquire the corresponding header information.
[0112] The mapping unit 703 is configured to map the row information into the expense item information according to the header information.
[0113] The cache value acquisition unit 704 is configured to write the expense item information into the order number merge cache in response to the expense item information not existing in the order number merge cache, and to acquire the corresponding cache value in response to the expense detail list corresponding to the expense item information existing in the order number merge cache.
[0114] The execution unit 705 is configured to merge the cache value with the fee item information to generate waybill dimension fee information and execute the information transmission program based on the waybill dimension fee information.
[0115] In some embodiments, the information processing device further includes Figure 7 The information adding unit not shown in the figure is configured to: in response to the fact that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, initialize an empty list, add the expense item information to the empty list and write it into the order number merge cache.
[0116] In some embodiments, the information processing device further includes Figure 7 The merging unit not shown in the figure is configured to: in response to the existence of fee item information in the order number merging cache and the waybill number in the order number merging cache is different from the waybill number corresponding to the fee item information, merge the cache value with the fee item information to generate waybill dimension fee information.
[0117] In some embodiments, the execution unit 705 is further configured to: obtain the delivery identification, billing identification and billing status identification carried in the information processing request; and store the waybill charge information according to the delivery identification, billing identification and billing status identification.
[0118] In some embodiments, the execution unit 705 is further configured to: determine the file type corresponding to the waybill charge information; and upload the waybill charge information to the cloud storage according to the file type, delivery identification, bill identification and bill status identification.
[0119] In some embodiments, the execution unit 705 is further configured to: call the return program to download the waybill charge information from the cloud storage and execute the corresponding parsing program according to the corresponding file type to obtain the return data; transmit the return data to a third-party system.
[0120] In some embodiments, the execution unit 705 is further configured to: when the file type is a data file, query whether the order number merge cache contains header information, if not, execute the exception retry logic, if so, read the header information and parse the data file based on the header information.
[0121] It should be noted that the information processing method and information processing device of the present application have a corresponding relationship in terms of specific implementation contents, so the repeated contents will not be described again.
[0122] Figure 8An exemplary system architecture 800 to which the information processing method or information processing device according to the embodiment of the present application can be applied is shown.
[0123] like Figure 8 As shown, system architecture 800 may include terminal devices 801, 802, 803, a network 804, and a server 805. Network 804 is used to provide a medium for communication links between terminal devices 801, 802, 803 and server 805. Network 804 may include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.
[0124] Users can use terminal devices 801, 802, and 803 to interact with server 805 through network 804 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 801, 802, and 803, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only examples).
[0125] The terminal devices 801 , 802 , and 803 may be various electronic devices having an information processing screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, and the like.
[0126] Server 805 can be a server that provides various services, such as a background management server that provides support for information processing requests submitted by users using terminal devices 801, 802, and 803 (only as an example). The background management server can receive information processing requests and obtain the corresponding bill information file; traverse the row information in the bill information file to obtain the corresponding header information; map the row information to the expense item information according to the header information; in response to the expense item information not existing in the order number merge cache, write the expense item information into the order number merge cache, and in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtain the corresponding cache value; merge the cache value with the expense item information to generate the waybill dimension expense information and execute the information transmission program based on the waybill dimension expense information. The subsequent online backhaul of bill data based on the waybill dimension expense information facilitates waybill verification, improves the speed and accuracy of waybill verification, and improves the corresponding business processing efficiency.
[0127] It should be noted that the information processing method provided in the embodiment of the present application is generally executed by the server 805 , and accordingly, the information processing device is generally set in the server 805 .
[0128] It should be understood that Figure 8 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.
[0129] Reference below Fig. 9 , which shows a schematic diagram of the structure of a computer system 900 of a terminal device suitable for implementing an embodiment of the present application. Fig. 9 The terminal device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0130] like Fig. 9 As shown, the computer system 900 includes a central processing unit (CPU) 901, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 902 or a program loaded from a storage part 908 into a random access memory (RAM) 903. In the RAM 903, various programs and data required for the operation of the computer system 900 are also stored. The CPU 901, the ROM 902, and the RAM 903 are connected to each other via a bus 904. An input / output (I / O) interface 905 is also connected to the bus 904.
[0131] The following components are connected to the I / O interface 905: an input section 906 including a keyboard, a mouse, etc.; an output section 907 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 908 including a hard disk, etc.; and a communication section 909 including a network interface card such as a LAN card, a modem, etc. The communication section 909 performs communication processing via a network such as the Internet. A drive 910 is also connected to the I / O interface 905 as needed. A removable medium 911, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 910 as needed, so that a computer program read therefrom is installed into the storage section 908 as needed.
[0132] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 909, and / or installed from the removable medium 911. When the computer program is executed by the central processing unit (CPU) 901, the above-mentioned functions defined in the system of the present application are executed.
[0133] It should be noted that the computer-readable medium shown in the present application may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. Computer-readable storage media may include, for example, but are not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present application, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.
[0134] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the above-mentioned module, program segment or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order 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 flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0135] The units involved in the embodiments described in the present application may be implemented by software or hardware. The units described may also be set in a processor, for example, it may be described as: a processor includes a receiving unit, a header information acquisition unit, a mapping unit, a cache value acquisition unit, and an execution unit. The names of these units do not, in some cases, constitute limitations on the units themselves.
[0136] As another aspect, the present application also provides a computer-readable medium, which may be included in the device described in the above embodiment; or it may exist independently and not be assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device receives an information processing request and obtains a corresponding bill information file; traverses the line information in the bill information file to obtain the corresponding header information; maps the line information to the expense item information according to the header information; in response to the expense item information not existing in the order number merge cache, writes the expense item information into the order number merge cache, and in response to the expense detail list corresponding to the expense item information existing in the order number merge cache, obtains the corresponding cache value; merges the cache value with the expense item information to generate the waybill dimension expense information and executes the information transmission program based on the waybill dimension expense information.
[0137] According to the technical solution of the embodiment of the present application, subsequent billing data is transmitted online based on the waybill dimension fee information, which facilitates waybill verification, improves the speed and accuracy of waybill verification, and improves the corresponding business processing efficiency.
[0138] The above specific implementations do not constitute a limitation on the protection scope of this application. It should be understood by those skilled in the art 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 this application should be included in the protection scope of this application.
Claims
1. An information processing method, characterized in that: include: Receive information processing requests and obtain corresponding billing information files; Traverse the row information in the bill information file to obtain corresponding header information; Mapping the row information into expense item information according to the header information; In response to the fact that the fee item information does not exist in the order number merge cache, writing the fee item information into the order number merge cache, and in response to the fact that the fee detail list corresponding to the fee item information exists in the order number merge cache, acquiring the corresponding cache value; The cache value is combined with the fee item information to generate waybill dimension fee information and an information transmission procedure is performed based on the waybill dimension fee information.
2. The method according to claim 1, characterized in that: The method further comprises: In response to the fact that the expense detail list corresponding to the expense item information does not exist in the order number merge cache, an empty list is initialized, and the expense item information is added to the empty list and written into the order number merge cache.
3. The method according to claim 1, characterized in that The method further comprises: In response to the fee item information existing in the order number merge cache and the waybill number in the order number merge cache is different from the waybill number corresponding to the fee item information, the cache value is merged with the fee item information to generate waybill dimension fee information.
4. The method according to claim 1, characterized in that: The information transmission procedure is performed based on the waybill dimension fee information, including: Obtaining the delivery identifier, billing identifier, and billing status identifier carried in the information processing request; The waybill charge information is stored according to the delivery identifier, the bill identifier and the bill status identifier.
5. The method according to claim 4, characterized in that The storing of the waybill fee information includes: Determine the file type corresponding to the waybill fee information; The waybill charge information is uploaded to cloud storage according to the file type, the delivery identifier, the bill identifier and the bill status identifier.
6. The method according to claim 5, characterized in that After uploading the waybill fee information to the cloud storage, the method further includes: Calling a return program to download the waybill fee information from the cloud storage and executing a corresponding parsing program according to the corresponding file type to obtain return data; The returned data is transmitted to a third-party system.
7. The method according to claim 6, characterized in that The analysis program includes: When the file type is a data file, it is queried whether the order number merge cache contains header information. If not, the exception retry logic is executed. If yes, the header information is read and the data file is parsed based on the header information.
8. An information processing device, characterized in that: Configured to: A receiving unit, configured to receive an information processing request and obtain a corresponding billing information file; A header information acquisition unit is configured to traverse the row information in the bill information file to acquire corresponding header information; a mapping unit, configured to map the row information into expense item information according to the header information; a cache value acquisition unit configured to, in response to the fact that the fee item information does not exist in the order number merge cache, write the fee item information into the order number merge cache, and in response to the fact that the fee detail list corresponding to the fee item information exists in the order number merge cache, acquire the corresponding cache value; An execution unit is configured to merge the cache value with the fee item information to generate waybill dimension fee information and execute an information transmission program based on the waybill dimension fee information.
9. An information processing electronic device, 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.