Two-dimensional code clearing method for cross-city application

Abstract

The invention discloses a cross-city application two-dimensional code clearing method, which comprises the steps that a local city acquiring terminal performs verification and transaction processing according to two-dimensional code information shown by a mobile terminal, the two-dimensional code information comprises a city code sending mechanism ID, and when the transaction is completed, the city code sending mechanism ID is sent to the local city acquiring terminal; the local city acquisition terminal uploads transaction acceptance data to a local city acquisition mechanism, and the mobile terminal uploads consumption transaction data to a corresponding city code sending mechanism; the local city acquirer classifies the accepted transaction data according to the city code issuing mechanism ID and generates a local city reconciliation table and a cross-city reconciliation table, and the city code issuing mechanism generates a city consumption reconciliation table according to the consumption transaction data; the local clearing center and the cross-city clearing center can acquire the reconciliation table from the corresponding mechanism regularly and carry out transaction clearing processing. According to the invention, local or cross-city riding travel can be realized, regular clearing and settlement processing can be realized, and the clearing efficiency and accuracy are high.

Description

Technical Field

[0001] The present invention relates to the technical field of traffic clearing, and in particular to a two-dimensional code clearing method for cross-city applications. Background Art

[0002] With the rapid development and popularization of smart mobile terminals and QR code payment technology, the payment methods in the public transportation field are undergoing significant changes. The current payment methods in the bus and subway industry no longer only use traditional card swiping or coin-operated methods for payment transactions. In order to meet the needs of modern urban residents for payment speed and convenience, transportation QR code payment transactions have also been added. As an emerging payment method, QR code payment has been widely introduced into the public transportation system, providing passengers with more flexible and fast payment options. For example, urban subways and buses use QR codes to scan rides, identify ride information through QR codes, and settle and deduct money. However, in the clearing and settlement processing process of transportation QR code transaction data, each city area only clears and settles local QR code transactions. In actual application scenarios, users need to download local QR code generation software in each city to generate QR codes for ride deduction processing, which brings inconvenience to users traveling across cities and reduces the convenience of cross-city transportation.

[0003] Therefore, there is an urgent need for a QR code clearing method that can be used across cities. The QR code that can be used across cities is not limited to use in a single city, but can be used in multiple cities to achieve seamless connection and interoperability between transportation systems in different cities. It can smoothly exchange information and complete the clearing process without geographical restrictions, simplify the operating process, and provide an intuitive and easy-to-use interface, so that users can easily complete payment even in different cities and enjoy convenient travel services. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a QR code clearing method for cross-city applications, which can enable users to use the urban traffic applet or APP of their city to realize local or cross-city travel, and can perform regular clearing and settlement processing on the generated local traffic transaction data or cross-city traffic transaction data, with high clearing efficiency and accuracy.

[0005] In order to solve the above technical problems, the present invention provides a QR code settlement method for cross-city applications, including: reading the QR code information presented by the passenger's mobile terminal through a local city acquiring terminal, wherein the QR code information is generated by the city transportation applet or APP of the city code issuing agency of the corresponding city, and the QR code information includes the city code issuing agency ID; the local city acquiring terminal verifies and processes the transaction according to the QR code information. When the transaction is completed, the local city acquiring terminal uploads the accepted transaction data to the local city acquiring agency, and the mobile terminal uploads the consumption transaction data to the corresponding city code issuing machine Structure; the local city acquiring institution classifies the accepted transaction data according to the city coding institution ID and generates a local city reconciliation table and a cross-city reconciliation table, the city coding institution generates a city consumption reconciliation table according to the consumption transaction data, wherein the cross-city reconciliation table includes at least one city reconciliation table and a city coding institution ID of a non-local city; the local clearing center regularly obtains local reconciliation tables from the local city acquiring institution and the city coding institution in the local city and performs local transaction clearing processing; the cross-city clearing center regularly obtains cross-city reconciliation tables from all city acquiring institutions in the area and performs cross-city transaction clearing processing.

[0006] As an improvement of the above scheme, the steps of the local clearing center regularly obtaining local reconciliation statements from the local city acquiring institution and the city code issuing institution in the local city and performing local transaction clearing processing include: the local clearing center regularly sends bill request instructions to the local city acquiring institution and the city code issuing institution in the local city, and receives feedback data returned by the local city acquiring institution and the city code issuing institution; the local clearing center performs data preprocessing on the received feedback data to obtain a local city data detail table and a city consumption data detail table; the local clearing center performs data statistics on the local city data detail table and the city consumption data detail table according to the keyword grouping rules to obtain local city data statistical tables and consumption data statistical tables of different transaction types; the local clearing center performs data verification processing on the local city data statistical tables and consumption data statistical tables of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified.

[0007] As an improvement of the above scheme, the local clearing center performs data preprocessing on the received feedback data to obtain a preprocessed local city data detail table and a city consumption data detail table, including the following steps: the local clearing center performs data validity verification on the received feedback data to obtain a corresponding verification result; the local clearing center determines whether the verification result is the preset result data, and when the judgment is yes, it indicates that the data verification is successful, and the feedback data is saved in a file; when the judgment is no, it indicates that the data verification fails, and an abnormal alarm is processed; the local clearing center performs data parsing on the feedback data according to the preset file parsing specification, and determines whether the feedback data is parsed successfully, and when the judgment is yes, optimizes the parsed data to obtain a local city data detail table or a city consumption data detail table, and when the judgment is no, stores the data that failed to be parsed into an error data table.

[0008] As an improvement of the above scheme, the local clearing center performs data verification processing on the local city data statistical table and consumption data statistical table of the same transaction type, and performs clearing processing on the successfully verified statistical tables, including: the local clearing center performs type grouping and data verification processing on the local city data statistical table and consumption data statistical table according to the table transaction type to obtain the corresponding transaction type data verification result; the local clearing center determines whether the transaction type data verification result is the preset result data, and when it is judged as yes, performs clearing processing according to the local city data statistical table of the transaction type, and when it is judged as no, saves the cross-city data statistical table and consumption data statistical table of the transaction type into the incorrectly verified data table.

[0009] As an improvement of the above scheme, the steps of the cross-city clearing center periodically obtaining cross-city reconciliation tables from all city acquiring institutions in the area and performing cross-city transaction clearing processing include: the cross-city clearing center periodically sends cross-city bill request instructions to all city acquiring institutions in the area, and receives feedback data returned by each of the city acquiring institutions; the cross-city clearing center pre-processes the received feedback data to obtain a cross-city data list of each of the city acquiring institutions and the corresponding city coding agency ID; the cross-city clearing center calculates the cross-city data list of each of the city acquiring institutions based on the transaction city ID and The city code issuing agency ID requests the corresponding city code issuing agency to obtain the city consumption reconciliation table under the transaction city ID, and performs data preprocessing on the received feedback data to obtain the corresponding city consumption data details table; the cross-city clearing center performs data statistics on the cross-city data details table and the city consumption data details table according to the keyword grouping rules to obtain cross-city data statistics tables and consumption data statistics tables of different transaction types; the cross-city clearing center performs data verification processing on the cross-city data statistics tables and consumption data statistics tables of the same transaction type, and performs clearing processing on the successfully verified statistics tables.

[0010] As an improvement of the above scheme, the data preprocessing step includes: the cross-city clearing center performs data validity verification on the received feedback data to obtain a corresponding verification result; the cross-city clearing center determines whether the verification result is the preset result data. When the judgment is yes, it indicates that the data verification is successful, and the feedback data is saved in a file; when the judgment is no, it indicates that the data verification fails, and an abnormal alarm is processed; the cross-city clearing center performs data parsing on the feedback data according to the preset file parsing specification, and determines whether the feedback data is parsed successfully. When the judgment is yes, the parsed data is optimized to obtain a cross-city data details table or a city consumption data details table. When the judgment is no, the data that failed to be parsed is stored in the error data table.

[0011] As an improvement of the above scheme, the cross-city clearing center performs data verification processing on the cross-city data statistical table and consumption data statistical table of the same transaction type, and performs clearing processing on the successfully verified statistical table, including: the cross-city clearing center performs type grouping and data verification processing on the cross-city data statistical table and consumption data statistical table according to the table transaction type to obtain the corresponding transaction type data verification result; the cross-city clearing center determines whether the transaction type data verification result is the preset result data, and when it is judged as yes, performs clearing processing according to the cross-city data statistical table of the transaction type, and when it is judged as no, saves the cross-city data statistical table and consumption data statistical table of the transaction type into the incorrectly verified data table.

[0012] As an improvement of the above-mentioned scheme, the keyword grouping rule is to count the attribute data in the data details table according to multiple keyword attributes to construct keyword statistical data of the statistical table; wherein, the keyword attributes include transaction type, bill file ID, issuing institution code, code issuing platform code, transaction channel, off-site transaction identification, number of orders, deduction amount and refund amount.

[0013] As an improvement of the above scheme, the step of data validity verification processing includes: reading the feedback data in a character string manner to obtain the first character data and the last character data; judging whether the first character data is the first preset character data and whether the last character data is the second preset character data, and when the judgment is yes, it indicates that the data validity verification is successful, and the verification success result is output; when the judgment is no, it indicates that the data validity verification fails, and the verification failure result is output.

[0014] As an improvement of the above scheme, the step of optimizing the parsed data includes: saving the parsed data into a database temporary table; associating the data in the database temporary table with a preset standard data detail table through a database SQL query method and filtering out duplicate data; saving the filtered duplicate data into an error data table, and inserting the remaining data into the preset standard data detail table accordingly to obtain a corresponding data detail table.

[0015] The implementation of the present invention has the following beneficial effects:

[0016] The present invention can support urban transportation mini-programs or APPs in different cities to carry out local or cross-city transportation transaction payments, so that users can use the urban transportation mini-programs or APPs in their cities to realize local or cross-city travel, thereby improving the convenience and user experience of users' transportation travel; and can perform regular clearing and settlement processing on local transportation transaction data or cross-city transportation transaction data generated by urban transportation mini-programs or APP payment transactions, has efficient and accurate clearing and settlement processing capabilities, and can automatically execute clearing tasks according to set time intervals to ensure timely updating and accuracy of transaction data.

[0017] In addition, the present invention has a complete error detection and correction mechanism, which can quickly discover and solve problems that may arise in the clearing process and ensure the safety of funds. It provides a clear bill query function to help users understand the details of each transaction and enhance user trust. It solves the problem of users' travel payment between different cities and provides city managers with efficient traffic management and data analysis tools, which helps promote the construction of smart cities and regional integrated development. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Figure 1It is a flow chart of the QR code clearing method for cross-city application of the present invention;

[0019] Figure 2 It is a flow chart of the local clearing center in the present invention periodically obtaining a local reconciliation statement from a local city acquiring institution and a city code issuing institution in a local city and performing local transaction clearing processing;

[0020] Figure 3 It is a flow chart of the cross-city clearing center in the present invention periodically obtaining cross-city reconciliation statements from all city acquiring institutions in the region and performing cross-city transaction clearing processing. Specific implementation methods

[0022] In order to make the objectives, technical solutions and advantages of the present invention more clear, the present invention will be further described in detail below with reference to the accompanying drawings.

[0023] like Figure 1 As shown, a specific embodiment of the present invention provides a QR code clearing method for cross-city applications, including:

[0024] S101. Using a local city acquiring terminal to read the QR code information presented by the passenger's mobile terminal;

[0025] It should be noted that the QR code information is generated by the urban transportation applet or APP of the urban code issuing agency of the corresponding city, and the QR code information includes the ID of the urban code issuing agency. The urban code issuing agency of each city has its corresponding urban transportation applet or APP, that is, each urban transportation applet or APP has its own urban code issuing agency. When passengers travel locally or across cities, they use the urban transportation applet or APP on the mobile terminal to generate the required QR code information, which includes the ID of the urban code issuing agency of the corresponding city.

[0026] Among them, in addition to the city code issuing agency ID, the QR code information also includes the necessary information required for QR code generation, such as QR code version, QR code data length, city code issuing agency public key certificate, payment account number, user account number, user account type, single consumption amount limit, payment account user public key, payment account system authorization expiration time, QR code validity period, city code issuing agency custom domain length, city code issuing agency custom domain, city code issuing agency authorization signature, QR code generation time and payment account user private key signature, etc.

[0027] S102, the local city acquiring terminal performs verification and transaction processing according to the QR code information. When the transaction is completed, the local city acquiring terminal uploads the accepted transaction data to the local city acquiring institution, and the mobile terminal uploads the consumption transaction data to the corresponding city code issuing institution;

[0028] It should be noted that when a passenger travels by car, he / she will present a QR code signal to the local city acquiring terminal, which will scan and verify the QR code information. When the verification is passed, the payment transaction will be processed. When the transaction is completed, the local city acquiring terminal will upload the accepted transaction data to the local city acquiring institution, and the mobile terminal will upload the consumption transaction data to its corresponding city code issuing institution. Among them, the consumption transaction data includes the transaction city ID, that is, the transaction city ID of the city where the passenger is traveling. Correspondingly, the accepted transaction data also includes the transaction city ID.

[0029] S103, the local city acquiring institution classifies the accepted transaction data according to the city code issuing institution ID and generates a local city reconciliation table and a cross-city reconciliation table, and the city code issuing institution generates a city consumption reconciliation table according to the consumption transaction data;

[0030] It should be noted that the cross-city reconciliation table includes at least one city reconciliation table and city code issuing agency ID of a non-local city. Each local city acquiring institution classifies the accepted transaction data by city according to the city code issuing agency ID. If the city code issuing agency ID in the single transaction is the city code issuing agency ID of the local city, the accepted transaction data will be saved in the local city reconciliation table; if the city code issuing agency ID in the single transaction is the city code issuing agency ID of another city, the accepted transaction data will be saved in the cross-city reconciliation table, and further saved in the corresponding non-local city city reconciliation table (i.e., the city reconciliation table corresponding to the city code issuing agency ID) according to the specific city code issuing agency ID. Among them, the reconciliation table generated by the local city acquiring institution includes the transaction city ID. The city code issuing agency generates a city consumption reconciliation table based on the consumption transaction data, and can generate multiple city consumption reconciliation tables for each transaction city by classification. If there is a transaction city ID in each single consumption transaction data, the consumption transaction data can be classified and the city consumption reconciliation table of the corresponding transaction city can be generated through the transaction city ID.

[0031] S104, the local clearing center regularly obtains local reconciliation statements from the local city acquiring institution and the city code issuing institution in the local city and performs local transaction clearing processing;

[0032] Specifically, Figure 2 As shown, the steps of the local clearing center periodically obtaining a local reconciliation statement from a local city acquiring institution and a city code issuing institution in a local city and performing local transaction clearing processing include:

[0033] S201, the local clearing center regularly sends bill request instructions to the local city acquiring institution and the city code issuing institution in the local city, and receives feedback data returned by the local city acquiring institution and the city code issuing institution;

[0034] It should be noted that the local clearing center sends bill request instructions to the local city acquiring institution and the city coding institution on a regular basis every day. The local city acquiring institution and the city coding institution return corresponding feedback data to the local clearing center based on the request instructions.

[0035] S202: The local clearing center performs data preprocessing on the received feedback data to obtain a local city data detail table and a city consumption data detail table;

[0036] Specifically, the local clearing center performs data preprocessing on the received feedback data to obtain a preprocessed local city data list and a city consumption data list, including:

[0037] Step 1: The local clearing center performs data validity verification on the received feedback data to obtain corresponding verification results;

[0038] It should be noted that the received feedback data needs to be verified for validity to determine whether the received data is valid, such as whether it is the required bill file, which includes the reconciliation table data. If the data is valid, the verification result is successful, otherwise the verification result is failed.

[0039] Step 2: The local clearing center determines whether the verification result is the preset result data. If it is, it means that the data verification is successful, and the feedback data is saved in a file. If it is, it means that the data verification fails, and an abnormal alarm is processed;

[0040] It should be noted that the preset result data is the verification success result. When the verification result is the preset result data, it means that the data verification is successful and the received data is valid. The feedback data, i.e. the bill file, is saved in the form of a file. When the verification result is not the preset result data, it means that the data verification has failed and the received data is invalid. At this time, after waiting for the preset time, the local clearing center sends the bill request instruction again. If the received data is still invalid, an alarm message is sent to the monitoring center and / or the mobile terminal of the operation and maintenance personnel, so as to promptly notify the operation and maintenance personnel to carry out maintenance and processing to ensure the implementation of transaction data clearing work.

[0041] Step 3: The local clearing center performs data parsing on the feedback data according to the preset file parsing specification, and determines whether the feedback data is parsed successfully. If it is judged to be yes, the parsed data is optimized to obtain a local city data detail table or a city consumption data detail table. If it is judged to be no, the data that failed to be parsed is stored in the error data table.

[0042] It should be noted that the saved feedback data is decompressed and the decompressed text file is parsed using the preset file parsing specifications; if the data parsing is successful, the successfully parsed transaction data is uniformly optimized to filter out duplicate transaction data and generate a local city data detail table or a city consumption data detail table; if the data parsing fails, the failed feedback data is stored in the error data table to facilitate subsequent operation and maintenance personnel to perform abnormality inspection and processing based on the content in the error data table, and further determine manually whether the transaction data is abnormal error data. If it is abnormal error data, no clearing processing is required, otherwise manual clearing processing is performed.

[0043] Among them, the preset file parsing specification stipulates the number of fields in the text file, the type, length, parsing method and value range of each field, that is, the data format of general regular files, such as numbers, strings, dates, etc.

[0044] S203, the local clearing center performs data statistics on the local city data detail table and the city consumption data detail table respectively according to the keyword grouping rule to obtain local city data statistics table and consumption data statistics table of different transaction types;

[0045] It should be noted that the key data in the local city data detail table and the city consumption data detail table are counted according to the keyword grouping rules to obtain a statistical table including multiple statistical keyword data structures. Among them, the statistical table is classified by transaction type, which includes at least one or more local city data statistical tables and consumption data statistical tables of different transaction types. For example, the transaction type includes a local city data statistical table of normal deductions and normal refunds and a consumption data statistical table of normal deductions and normal refunds.

[0046] S204: The local clearing center performs data verification processing on the local city data statistical table and consumption data statistical table of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified.

[0047] Specifically, the local clearing center performs data verification processing on the local city data statistical table and the consumption data statistical table of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified, including:

[0048] Step 1: The local clearing center groups the local city data statistics table and the consumption data statistics table according to the table transaction type and performs data verification processing to obtain corresponding transaction type data verification results;

[0049] Step 2: The local clearing center determines whether the transaction type data verification result is the preset result data. If it is, clearing processing is performed according to the local city data statistics table of the transaction type. If it is not, the cross-city data statistics table and consumption data statistics table of the transaction type are saved in the error verification data table.

[0050] It should be noted that statistical tables of the same type are checked and processed according to the transaction type of the table, such as the local city data statistical table with normal deductions and the consumption data statistical table with normal deductions. The checking process is: for example, checking whether the statistical information such as the total number of orders, the total amount of deductions for orders and the deduction channels between the two statistical tables are consistent. If the data is consistent, it means that the checking is successful, and the settlement processing is carried out according to the amount data in the local city data statistical table to realize the settlement of local city traffic transactions; if the data is inconsistent, it means that the checking fails, and the cross-city data statistical table and the consumption data statistical table of the transaction type are saved in the error checking data table, so that the subsequent operation and maintenance personnel can perform abnormal inspection and processing according to the content in the error checking data table, and further determine whether the transaction data is valid manually. If it is valid, manual settlement processing is carried out.

[0051] S105. The cross-city clearing center periodically obtains cross-city reconciliation statements from all city acquiring institutions in the region and performs cross-city transaction clearing processing.

[0052] Specifically, Figure 3 As shown, the steps of the cross-city clearing center periodically obtaining cross-city reconciliation statements from all city acquirers in the region and performing cross-city transaction clearing processing include:

[0053] S301, the cross-city clearing center periodically sends cross-city bill request instructions to all city acquirers in the area, and receives feedback data returned by each of the city acquirers;

[0054] It should be noted that the cross-city clearing center sends bill request instructions to the city acquiring institutions in the area on a regular basis every day, and the city acquiring institutions return corresponding feedback data to the cross-city clearing center based on the request instructions.

[0055] S302: The cross-city clearing center performs data preprocessing on the received feedback data to obtain a cross-city data list of each city acquirer and a corresponding city code issuing agency ID;

[0056] Specifically, the data preprocessing step includes:

[0057] Step 1: The cross-city clearing center performs data validity verification on the received feedback data to obtain corresponding verification results;

[0058] It should be noted that the received feedback data needs to be verified for validity to determine whether the received data is valid, such as whether it is the required bill file, which includes the reconciliation table data. If the data is valid, the verification result is successful, otherwise the verification result is failed.

[0059] Step 2: The cross-city clearing center determines whether the verification result is the preset result data. If it is, it means that the data verification is successful, and the feedback data is saved in a file. If it is, it means that the data verification fails, and an abnormal alarm is processed;

[0060] It should be noted that the preset result data is the verification success result. When the verification result is the preset result data, it means that the data verification is successful and the received data is valid. The feedback data, i.e. the bill file, is saved in the form of a file. When the verification result is not the preset result data, it means that the data verification has failed and the received data is invalid. At this time, after waiting for the preset time, the cross-city clearing center sends the bill request instruction again. If the received data is still invalid, an alarm message is sent to the cross-city monitoring center and / or the mobile terminal of the operation and maintenance personnel, so as to promptly notify the operation and maintenance personnel to carry out maintenance and processing to ensure the implementation of transaction data clearing work.

[0061] Step 3: The cross-city clearing center performs data parsing on the feedback data according to the preset file parsing specification, and determines whether the feedback data is parsed successfully. If it is judged to be yes, the parsed data is optimized to obtain a cross-city data detail table or a city consumption data detail table. If it is judged to be no, the data that failed to be parsed is stored in the error data table.

[0062] It should be noted that the saved feedback data is decompressed and the decompressed text file is parsed using the preset file parsing specifications; if the data parsing is successful, the successfully parsed transaction data is uniformly optimized to filter out duplicate transaction data and generate a cross-city data detail table or a city consumption data detail table, where each cross-city data detail table corresponds to a city coding agency ID; if the data parsing fails, the failed part of the feedback data is stored in the error data table, so that subsequent operation and maintenance personnel can perform abnormality inspection and processing based on the content in the error data table, and further determine manually whether the transaction data is abnormal error data. If it is abnormal error data, no clearing processing is required, otherwise manual clearing processing is performed.

[0063] Among them, the preset file parsing specification stipulates the number of fields in the text file, the type, length, parsing method and value range of each field, that is, the data format of general regular files, such as numbers, strings, dates, etc.

[0064] S303, the cross-city clearing center requests the corresponding city code issuing institution to obtain the city consumption reconciliation table under the transaction city ID according to the transaction city ID and the city code issuing institution ID of the city acquiring institution, and performs data preprocessing on the received feedback data to obtain the corresponding city consumption data detailed table;

[0065] It should be noted that the cross-city clearing center can determine the city code issuing agency to be cleared and settled according to the city code issuing agency ID, and request the city code issuing agency to obtain the city consumption reconciliation table under the transaction city ID through the transaction city ID in the feedback data of the city acquiring agency. The cross-city clearing center receives the feedback data returned by the city code issuing agency and performs the above data preprocessing to obtain the city consumption data detailed table.

[0066] S304: The cross-city clearing center performs data statistics on the cross-city data detail table and the city consumption data detail table according to the keyword grouping rule to obtain cross-city data statistics tables and consumption data statistics tables of different transaction types;

[0067] It should be noted that the key data in the cross-city data detail table and the city consumption data detail table are counted according to the keyword grouping rules to obtain a statistical table including multiple statistical keyword data structures. Among them, the statistical table is classified by transaction type, which includes at least one or more cross-city data statistical tables and consumption data statistical tables of different transaction types. For example, the transaction type includes a cross-city data statistical table of normal deductions and normal refunds, and a consumption data statistical table of normal deductions and normal refunds.

[0068] S305. The cross-city clearing center performs data verification processing on the cross-city data statistical table and consumption data statistical table of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified.

[0069] Specifically, the cross-city clearing center performs data verification processing on the cross-city data statistical table and the consumption data statistical table of the same transaction type, and performs clearing processing on the statistical table that has been successfully verified, including:

[0070] Step 1: The cross-city clearing center groups the cross-city data statistics table and the consumption data statistics table according to the table transaction type and performs data verification processing to obtain corresponding transaction type data verification results;

[0071] Step 2: The cross-city clearing center determines whether the transaction type data verification result is the preset result data. If it is, clearing processing is performed according to the cross-city data statistics table of the transaction type. If it is not, the cross-city data statistics table and consumption data statistics table of the transaction type are saved in the error verification data table.

[0072] It should be noted that statistical tables of the same type are checked and processed according to the transaction type of the table, such as the cross-city data statistical table of normal deductions and the consumption data statistical table of normal deductions. The checking process is: for example, checking whether the statistical information such as the total number of orders, the total amount of deductions for orders and the deduction channels between the two statistical tables are consistent. If the data is consistent, it means that the checking is successful, and the settlement processing is carried out according to the amount data of the cross-city data statistical table to realize the settlement of cross-city transportation transactions; if the data is inconsistent, it means that the checking fails, and the cross-city data statistical table and the consumption data statistical table of the transaction type are saved in the error checking data table, so that the subsequent operation and maintenance personnel can perform abnormal inspection and processing according to the content in the error checking data table, and further determine whether the transaction data is valid manually. If it is valid, manual settlement processing is carried out.

[0073] Preferably, the step of data validity verification processing includes: reading the feedback data in a character string manner to obtain first character data and last character data; judging whether the first character data is the first preset character data and whether the last character data is the second preset character data, and when the judgment is yes, it indicates that the data validity verification is successful, and a verification success result is output; when the judgment is no, it indicates that the data validity verification fails, and a verification failure result is output.

[0074] It should be noted that the feedback data returned is a bill file or a string indicating the failed request. The feedback data is read in string form to determine whether the first and last characters of the data conform to the preset character data. If so, it means the request failed, and a string indicating the failed request is returned. In this case, a verification failure result is output. Otherwise, it means the request was successful, and a bill file is returned. In this case, a verification success result is output, thereby realizing data validity verification and effectively improving data processing accuracy and efficiency.

[0075] Preferably, the keyword grouping rule is to count the attribute data in the data detail table according to multiple keyword attributes to construct the keyword data structure of the statistical table. Wherein, the keyword attributes include transaction type, bill file ID, card issuer code, code issuing platform code, transaction channel, off-site transaction identification, number of orders, deduction amount and refund amount, etc.; the attribute data in the data detail table are counted by the above keyword attributes to obtain a statistical table of corresponding transaction types, such as the statistical table includes the transaction type of normal deduction, the bill file ID and card issuer code of the valid feedback data and the code issuing platform, online transaction (such as WeChat), off-site transaction identification (i.e., preset identification code), total number of orders and total order deduction amount, etc. or the transaction type of normal refund, the bill file ID and card issuer code of the valid feedback data and the code issuing platform, online transaction (such as WeChat), off-site transaction identification, total number of orders and total order refund amount, etc.

[0076] Preferably, the step of optimizing the parsed data includes: saving the parsed data into a database temporary table; associating the data in the database temporary table with a preset standard data detail table through a database SQL query method and filtering duplicate data; saving the filtered duplicate data into an error data table, and inserting the remaining data into the preset standard data detail table accordingly to obtain a corresponding data detail table.

[0077] It should be noted that the successfully parsed data is first saved in a database temporary table, and the data in the database temporary table is associated with the preset standard data detail table through a database SQL query method, and the duplicate data in the database temporary table is screened out; the screened duplicate data is saved in an error data table, so that subsequent operation and maintenance personnel can perform abnormality inspection and processing based on the content in the error data table, and further determine manually whether the transaction data is abnormal error data. If it is abnormal error data, no clearing processing is required, otherwise manual clearing processing is performed; and the remaining data is inserted or filled into the preset standard data detail table accordingly to obtain a local city data detail table or a cross-city data detail table or a city consumption data detail table.

[0078] In summary, the present invention can support urban transportation applets or APPs in different cities to make local or cross-city transportation transaction payments, so that users can use the urban transportation applets or APPs in their own cities to realize local or cross-city travel by bus, thereby improving the convenience and user experience of users' transportation travel; and it can perform regular clearing and settlement processing on local transportation transaction data or cross-city transportation transaction data generated by urban transportation applets or APP payment transactions, and has efficient and accurate clearing and settlement processing capabilities, and can automatically perform clearing tasks according to set time intervals to ensure timely updating and accuracy of transaction data. Among them, user consumption data for different transaction types can be classified, checked and cleared to apply to different types of consumption data clearing work, and has high applicability.

[0079] In addition, the present invention has a complete error detection and correction mechanism, which can quickly discover and solve problems that may arise in the clearing process and ensure the safety of funds. It provides a clear bill query function to help users understand the details of each transaction and enhance user trust. It solves the problem of users' travel payment between different cities and provides city managers with efficient traffic management and data analysis tools, which helps promote the construction of smart cities and regional integrated development.

[0080] The above disclosure is only the preferred embodiment of the present invention, which certainly cannot be used to limit the scope of the present invention. Therefore, equivalent changes made according to the claims of the present invention are still within the scope of the present invention.

Claims

1. A QR code clearing method for cross-city applications, characterized in that: include: The QR code information presented by the passenger's mobile terminal is read by the local city acquiring terminal, wherein the QR code information is generated by the city transportation applet or APP of the city code issuing agency of the corresponding city, and the QR code information includes the city code issuing agency ID; The local city acquiring terminal performs verification and transaction processing according to the QR code information. When the transaction is completed, the local city acquiring terminal uploads the accepted transaction data to the local city acquiring institution, and the mobile terminal uploads the consumption transaction data to the corresponding city code issuing institution; The local city acquiring institution classifies the accepted transaction data according to the city code issuing institution ID and generates a local city reconciliation table and a cross-city reconciliation table. The city code issuing institution generates a city consumption reconciliation table according to the consumption transaction data, wherein the cross-city reconciliation table includes at least one city reconciliation table and a city code issuing institution ID of a non-local city; The local clearing center regularly obtains local reconciliation statements from the city acquiring institution and the city issuing institution in the local city and performs local transaction clearing and processing; The cross-city clearing center regularly obtains cross-city reconciliation statements from all city acquiring institutions in the region and conducts cross-city transaction clearing processing.

2. The QR code clearing method for cross-city applications according to claim 1 is characterized in that: The steps of the local clearing center periodically obtaining a local reconciliation statement from a local city acquiring institution and a city code issuing institution in a local city and performing local transaction clearing processing include: The local clearing center periodically sends bill request instructions to the local city acquiring institution and the city code issuing institution in the local city, and receives feedback data returned by the local city acquiring institution and the city code issuing institution; The local clearing center performs data preprocessing on the received feedback data to obtain a local city data detail table and a city consumption data detail table; The local clearing center performs data statistics on the local city data detail table and the city consumption data detail table respectively according to the keyword grouping rule to obtain local city data statistics table and consumption data statistics table of different transaction types; The local clearing center performs data verification processing on the local city data statistical table and consumption data statistical table of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified.

3. The QR code clearing method for cross-city applications according to claim 2 is characterized in that: The local clearing center performs data preprocessing on the received feedback data to obtain a preprocessed local city data list and a city consumption data list, including: The local clearing center performs data validity verification on the received feedback data to obtain a corresponding verification result; The local clearing center determines whether the verification result is the preset result data. If it is, it means that the data verification is successful, and the feedback data is saved in a file. If it is, it means that the data verification fails, and an abnormal alarm process is performed; The local clearing center performs data parsing on the feedback data according to the preset file parsing specifications, and determines whether the feedback data is parsed successfully. When it is judged to be yes, the parsed data is optimized to obtain a local city data details table or a city consumption data details table. When it is judged to be no, the data that failed to be parsed is stored in the error data table.

4. The QR code clearing method for cross-city applications according to claim 2 is characterized in that: The local clearing center performs data verification processing on the local city data statistical table and the consumption data statistical table of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified, including: The local clearing center groups the local city data statistics table and the consumption data statistics table according to the table transaction type and performs data verification processing to obtain corresponding transaction type data verification results; The local clearing center determines whether the transaction type data verification result is the preset result data. If it is judged to be yes, clearing processing is performed according to the local city data statistics table of the transaction type. If it is judged to be no, the cross-city data statistics table and consumption data statistics table of the transaction type are saved in the error verification data table.

5. The cross-city application QR code clearing method according to claim 1, characterized in that: The steps of the cross-city clearing center periodically obtaining cross-city reconciliation statements from all city acquiring institutions in the region and performing cross-city transaction clearing processing include: The cross-city clearing center periodically sends cross-city bill request instructions to all city acquirers in the area, and receives feedback data returned by each of the city acquirers; The cross-city clearing center performs data preprocessing on the received feedback data to obtain a cross-city data list of each city acquirer and a corresponding city code issuing agency ID; The cross-city clearing center requests the corresponding city code issuing institution to obtain the city consumption reconciliation table under the transaction city ID according to the transaction city ID and the city code issuing institution ID of the city acquiring institution, and performs data preprocessing on the received feedback data to obtain the corresponding city consumption data detailed table; The cross-city clearing center performs data statistics on the cross-city data detail table and the city consumption data detail table respectively according to the keyword grouping rule to obtain cross-city data statistics tables and consumption data statistics tables of different transaction types; The cross-city clearing center performs data verification processing on the cross-city data statistical tables and consumption data statistical tables of the same transaction type, and performs clearing processing on the statistical tables that have been successfully verified.

6. The QR code clearing method for cross-city applications according to claim 5, characterized in that: The data preprocessing step includes: The cross-city clearing center performs data validity verification on the received feedback data to obtain corresponding verification results; The cross-city clearing center determines whether the verification result is the preset result data. If it is, it means that the data verification is successful, and the feedback data is saved in a file. If it is, it means that the data verification fails, and an abnormal alarm process is performed; The cross-city clearing center performs data parsing on the feedback data according to the preset file parsing specifications, and determines whether the feedback data is parsed successfully. When it is judged to be yes, the parsed data is optimized to obtain a cross-city data details table or a city consumption data details table. When it is judged to be no, the data that failed to be parsed is stored in the error data table.

7. The QR code clearing method for cross-city applications according to claim 5, characterized in that: The step of the cross-city clearing center performing data verification processing on the cross-city data statistical table and the consumption data statistical table of the same transaction type and performing clearing processing on the statistical table that has been successfully verified includes: The cross-city clearing center groups the cross-city data statistics table and the consumption data statistics table according to the table transaction type and performs data verification processing to obtain corresponding transaction type data verification results; The cross-city clearing center determines whether the transaction type data verification result is the preset result data. If it is judged to be yes, clearing processing is performed according to the cross-city data statistics table of the transaction type. If it is judged to be no, the cross-city data statistics table and consumption data statistics table of the transaction type are saved in the error verification data table.

8. The QR code clearing method for cross-city applications according to claim 2 or 5, characterized in that: The keyword grouping rule is to count the attribute data in the data detail table according to multiple keyword attributes to construct keyword statistical data in the statistical table; Among them, the keyword attributes include transaction type, bill file ID, card issuing institution code, code issuing platform code, transaction channel, remote transaction identifier, number of orders, deduction amount and refund amount.

9. The QR code clearing method for cross-city applications according to claim 3 or 6, characterized in that: The steps of data validity verification processing include: Read the feedback data in a character string manner to obtain first character data and last character data; Determine whether the first character data is the first preset character data and whether the last character data is the second preset character data. If it is determined to be yes, it indicates that the data validity check is successful and a successful check result is output. If it is determined to be no, it indicates that the data validity check has failed and a failed check result is output.

10. The QR code clearing method for cross-city applications according to claim 3 or 6, characterized in that: The step of optimizing the parsed data comprises: Saving the parsed data into a temporary table of a database; The data in the temporary database table is associated with the preset standard data detail table through the database SQL query method and duplicate data is filtered out; The filtered duplicate data is saved in the error data table, and the remaining data is inserted into the preset standard data detail table accordingly to obtain the corresponding data detail table.

Images