Method for determining delivery progress of same-number cards of bank and related device

Abstract

The invention discloses a delivery progress determination method for cards of the same number of a bank and a related device, and relates to the technical field of bank card processing, and the method comprises the steps: firstly, receiving a plurality of express numbers sent by bank operation equipment; and then respectively acquiring information of a plurality of cards with the same number and information of a plurality of character cards from a bank data warehouse and a bank report server, and storing the information in an application table. And obtaining recipient information according to the express number, querying and obtaining the information of a target person card corresponding to the express number in the application table by using the recipient information, querying and obtaining the information of a target same-number card corresponding to the express number in the application table by using the card number of the target person card, and automatically matching the express number with the information of the same-number card. And finally, the express number and the logistics information obtained according to the express number are added to the information of the target same-number card and updated, so that the client can check the logistics progress of the same-number card at any time, and the delivery progress tracking process of the same-number card is simplified.

Description

Technical Field

[0001] The present application relates to the field of bank card processing technology, and in particular to a method for determining the delivery progress of a bank card with the same number and a related device. Background Art

[0002] With the continuous advancement of financial technology, bank cards are becoming increasingly popular. A bank card is the card a customer actually uses. The profile card is the initial information record when a customer applies for a bank card and serves as the basis for bank card production. Its content determines the basic attributes of the bank card and the cardholder's identity. A "same number card" is a special case of a bank card replacement (e.g., when the bank card is lost, damaged, or expired). This card is a new bank card created while retaining the original card number.

[0003] At present, after the bank successfully produces the same-number card, the bank staff will manually match the express delivery number and the information of the same-number card based on the information of the personal card, and then notify the customer to pick it up at the bank or mail it directly to the customer. The mailing progress of the same-number card will be followed up by the logistics company.

[0004] However, with high volumes of business, bank staff face a significant amount of verification work, which is inefficient and prone to errors. Furthermore, the existing process prevents banks from obtaining real-time status information on identical card numbers during logistics transportation. Because card production and logistics information are not interoperable, customers must contact both the bank and the logistics company separately, making tracking the delivery progress of identical cards a cumbersome process. Summary of the Invention

[0005] In view of the above problems, this application provides a bank's delivery progress determination method and related devices for identical card numbers, in order to simplify the delivery progress tracking process of identical card numbers. The specific solution is as follows:

[0006] In a first aspect, the present application provides a method for determining the delivery progress of a same-number card of a bank, which is applied to a device for determining the delivery progress of a same-number card of the bank, wherein the device is communicatively connected to a bank data warehouse, a bank report server, and a bank operation device, respectively. The method comprises:

[0007] Receiving a courier number file sent by the bank operating device, wherein the courier number file includes multiple courier numbers;

[0008] Obtaining information of multiple cards with the same number from the bank data warehouse, and obtaining information of multiple person cards from the bank report server, wherein the information of each person card includes cardholder information and card number;

[0009] Storing the information of each of the same-number cards and the information of each of the character cards in an application table;

[0010] For each express delivery number, obtain recipient information according to the express delivery number;

[0011] Using the recipient information to query the application table, obtain the target person card information corresponding to the express number, where the cardholder information in the target person card information is consistent with the recipient information;

[0012] Using the information of the target person card to query the application table, obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card;

[0013] The express delivery number and the logistics information obtained based on the express delivery number are added to the information of the target card with the same number and updated until the target card with the same number is delivered to the customer.

[0014] In a possible implementation, after obtaining the recipient information according to each express delivery number, the method further includes:

[0015] Obtain the express delivery outlet number according to the express delivery number;

[0016] Using the first express delivery outlet number to query the application table, obtain information of a candidate character card corresponding to the express delivery number, where the delivery address number in the candidate character card information is consistent with the express delivery outlet number;

[0017] The method of querying the application table using the recipient information to obtain the information of the target person card corresponding to the express delivery number includes:

[0018] The recipient information is used to obtain the target person card information corresponding to the express delivery number from the candidate person card information.

[0019] In a possible implementation, the information of each target person card includes the card application date and card type;

[0020] The method of using the information of the target person card to query the application table to obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, includes:

[0021] The information of the target person card is used to query the application table to obtain the information of the target card with the same number corresponding to the express delivery number, the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, the card application date of the target card with the same number is consistent with at least one card application date included in the information of the target person card, and the card type of the target card with the same number is consistent with at least one card type included in the information of the target person card.

[0022] In a possible implementation, after obtaining information of multiple cards with the same number from the bank data warehouse and obtaining information of multiple person cards from the bank report server, the method further includes:

[0023] Formatting the information of each of the same-number cards and the information of each of the character cards respectively to obtain a plurality of formatted information of the same-number cards and a plurality of formatted information of the character cards;

[0024] Encrypting the information of each formatted same-number card and the information of each formatted person card respectively to obtain a plurality of pre-processed information of the same-number card and a plurality of pre-processed information of the person card;

[0025] The storing the information of each of the same-number cards and the information of each of the character cards into the application table includes:

[0026] The information of each of the pre-processed same-number cards and the information of each of the pre-processed character cards are stored in the application table.

[0027] In one possible implementation, the method further includes:

[0028] Detecting the information of each of the same-number cards and the information of each of the character cards to obtain error information of each of the same-number cards and error information of each of the character cards;

[0029] The error information of each of the same-number cards and the error information of each of the character cards are stored in an error record table, and the error record table is sent to the bank operating device, so that the bank operator can correct the error information of each of the same-number cards and the error information of each of the character cards in the error record table through the bank operating device.

[0030] In a possible implementation, after storing the information of each of the same-number cards and the information of each of the character cards in the application table, the method further includes:

[0031] The information of each of the same-number cards and the information of each of the character cards are stored in a backup table, so that when a problem occurs in the application table, the data in the backup table can be backed up to the application table.

[0032] A second aspect of the present application provides a device for determining the delivery progress of a bank card with the same number, wherein the device is communicatively connected to a bank data warehouse, a bank report server, and a bank operation device, respectively, and the method includes:

[0033] A receiving unit, configured to receive a courier number file sent by the bank operating device, wherein the courier number file includes a plurality of courier numbers;

[0034] An acquisition unit, configured to acquire information of a plurality of cards with the same number from the bank data warehouse, and acquire information of a plurality of person cards from the bank report server, wherein the information of each person card includes cardholder information and card number;

[0035] A storage unit, configured to store information of each of the same-number cards and information of each of the character cards into an application table;

[0036] An obtaining unit, configured to obtain, for each express delivery number, recipient information according to the express delivery number;

[0037] A first query unit is configured to query the application table using the recipient information to obtain information of a target person card corresponding to the express delivery number, wherein the cardholder information in the target person card information is consistent with the recipient information;

[0038] a second query unit, configured to query the application table using the information of the target person card to obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card;

[0039] An updating unit is used to add the express delivery number to the information of the target card with the same number, and update the logistics status of the information of the target card with the same number based on the obtained logistics information of the express delivery number until the target card with the same number is delivered to the customer.

[0040] The third aspect of the present application provides a computer program product, including computer-readable instructions. When the computer-readable instructions are executed on an electronic device, the electronic device implements the method for determining the delivery progress of the same-number card of the bank according to the first aspect or any implementation of the first aspect.

[0041] A fourth aspect of the present application provides an electronic device, comprising at least one processor and a memory connected to the processor, wherein:

[0042] The memory is used to store computer programs;

[0043] The processor is used to execute the computer program so that the electronic device can implement the method for determining the delivery progress of the bank's same-number card according to the above-mentioned first aspect or any implementation method of the first aspect.

[0044] In a fifth aspect, the present application provides a computer storage medium, which carries one or more computer programs. When the one or more computer programs are executed by an electronic device, the electronic device can determine the delivery progress of the same-number card of the bank according to the above-mentioned first aspect or any implementation method of the first aspect.

[0045] Based on the above technical solution, the present application provides a method and related device for determining the delivery progress of identical cards at a bank. The method is applied to the device for determining the delivery progress of identical cards at a bank, wherein the device is respectively connected to a bank data warehouse, a bank reporting server, and a bank operating device. The method comprises: first, receiving multiple express delivery tracking numbers from the bank operating device to achieve centralized management of the express delivery tracking numbers, thereby avoiding the tedious and error-prone manual entry. Then, information on the multiple identical cards and information on multiple person cards are obtained from the bank data warehouse and the bank reporting server, respectively, and stored in an application table, thereby integrating the bank's internal data resources. Then, for each express delivery tracking number, recipient information is obtained based on the express delivery tracking number. The recipient information is used to query the application table to obtain information on the target person card corresponding to the express delivery tracking number. The card number of the target person card is used to query the application table to obtain information on the target identical card corresponding to the express delivery tracking number. The express delivery tracking number is automatically matched with the identical card information, thereby avoiding manual matching errors and improving data processing efficiency. Finally, the express delivery number and the logistics information obtained based on the express delivery number are added to the information of the target card with the same number and updated until the target card with the same number is delivered to the customer, so that the customer can check the logistics progress of the card with the same number at any time, simplifying the delivery progress tracking process of the card with the same number. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] The above and other features, advantages, and aspects of the various embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that the originals and elements are not necessarily drawn to scale.

[0047] Figure 1 A flow chart of a method for determining the delivery progress of a bank card with the same number provided in an embodiment of the present application;

[0048] Figure 2 A schematic diagram of the structure of a device for determining the delivery progress of a bank card with the same number provided in an embodiment of the present application;

[0049] Figure 3 A schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0050] The following describes the embodiments of the present application in conjunction with the accompanying drawings. The terms used in the implementation methods of the present application are only used to explain the specific embodiments of the present application and are not intended to limit the present application.

[0051] The embodiments of the present application are described below in conjunction with the accompanying drawings. Those skilled in the art will appreciate that, with the development of technology and the emergence of new scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems.

[0052] The terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the terms used in this way can be interchangeable under appropriate circumstances, and this is merely a way of distinguishing the objects of the same attributes when describing them in the embodiments of the present application. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, so that the process, method, system, product or equipment comprising a series of units need not be limited to those units, but may include other units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0053] In order to simplify the delivery progress tracking process of cards with the same number, the present application provides a method for determining the delivery progress of cards with the same number by a bank. The method for determining the delivery progress of cards with the same number by a bank provided in the present application is further described in detail below in combination with the accompanying drawings and specific implementation methods.

[0054] Please see the attached Figure 1 , Figure 1 This is a flow chart of a method for determining the delivery progress of a card with the same number provided in an embodiment of the present application. The method is applied to a device for determining the delivery progress of a card with the same number in a bank, which is in communication with a bank data warehouse, a bank report server, and a bank operating device. The method may include the following steps:

[0055] Step S101: receiving a courier number file sent by a bank operating device, where the courier number file includes multiple courier numbers.

[0056] It should be noted that bank operating devices refer to the terminal devices used within the bank to handle various business operations, such as teller computers and self-service terminals. In scenarios where the delivery progress of identical card numbers is determined, these devices can be used to generate and send files containing express delivery numbers. Express delivery number files are electronic files containing multiple express delivery numbers, and can be in formats such as text or Excel. Express delivery numbers are unique codes used to identify express packages, and each express delivery number corresponds to a specific express package.

[0057] In this application, you can receive a tracking number file sent from a bank's operating device. This file contains multiple tracking numbers associated with the delivery of the same-number card. When the bank reissues or replaces a card with the same number for a customer, it will send the new card to the customer by courier. At this time, the corresponding tracking number is generated and recorded in the tracking number file.

[0058] Step S102: obtaining information of multiple cards with the same number from the bank data warehouse, and obtaining information of multiple person cards from the bank report server, wherein the information of each person card includes cardholder information and card number.

[0059] It's important to note that a bank's data warehouse is a large database that centrally stores all types of bank business data. Its primary function is to provide a data basis for business decision-making. In this step, a timer can be used to retrieve data from the data warehouse daily for newly created cards with the same card number. Each card with the same card number can include multiple dimensions, such as the card number (a unique identifier for the card), card type (e.g., debit card, credit card), card application date, and card status (e.g., activated, pending activation, reported lost). This data is generated and stored during the bank's daily business operations. The data warehouse can integrate this data, which is dispersed across various business systems, to facilitate subsequent query and analysis.

[0060] The bank's report server is primarily used to store and generate various bank business reports, which visually showcase the bank's business data and operational status. The report server stores person card information, which includes the cardholder's information and card number. This information may include personal identification and contact information such as the cardholder's name, phone number, ID number, and account opening date. This information is entered by the customer when the bank processes their card business and stored in the bank's business system. It is then aggregated to the report server for generating various reports, such as customer information reports and card business reports.

[0061] In this application, a timer is set to ensure timely and regular access to the latest card-with-identity information, thus ensuring data timeliness. When the timer triggers, a related program or script sends a query request to the bank's data warehouse. Based on pre-set query criteria (such as a date range of the previous day), it filters and extracts matching card-with-identity information from the data warehouse. A Linux client for the file transfer system is installed, and connection information such as the report server's IP address and port number is prepared in advance. The timer invokes a shell script at a set interval, which uses the GFTS client to periodically download new person card files from the report server. This method ensures that person card data in the bank's report server is promptly synchronized with the device for determining the delivery progress of the card-with-identity, providing data support for subsequent matching and queries.

[0062] Because the same-number card information and person card information obtained from different data sources may have inconsistent formats, for example, date formats may vary, such as "YYYY-MM-DD" or "MM / DD / YYYY," card numbers may contain different separators (such as spaces and hyphens), and names may be inconsistently capitalized. To ensure data consistency and accuracy and facilitate subsequent query and matching operations, the information for each same-number card and each person card must be formatted separately. Therefore, it is also possible to format each same-number card and each person card separately, generating multiple formatted same-number card and person card information. For the date field in the same-number card information, it can be uniformly converted to the standard "YYYY-MM-DD" date format; for the card number field, all separators are removed to form a continuous numeric string; and for the name field in the person card information, it is uniformly converted to a specific case (such as all lowercase or all uppercase) and any spaces before and after the name are removed. These formatting operations ensure uniform information formatting, facilitating subsequent data processing.

[0063] Because bank ID and ID card information contains sensitive customer information, such as card numbers, ID numbers, and names, leaking this information could result in financial losses and privacy risks. To ensure data security and privacy, encryption can be used to convert the original data into ciphertext. Even if the data is illegally accessed during storage or transmission, attackers cannot easily recover the original data, effectively protecting customer information. Therefore, it is possible to encrypt the formatted ID card information and the formatted ID card information separately, generating multiple pre-processed ID card information and multiple pre-processed ID card information. Hash encryption is a one-way encryption algorithm that converts input data (i.e., plaintext) of arbitrary length into an output value (i.e., hash value or ciphertext) of fixed length using a hash function. Hash functions are deterministic, meaning that identical input data will produce the same hash value after being processed by the same hash function. Furthermore, hash functions are irreversible, meaning the original input data cannot be deduced from the hash value. Common hash encryption algorithms include MD5 (Message-Digest Algorithm 5), SHA-1 (Secure Hash Algorithm 1), and SHA-256 (Secure Hash Algorithm 256). In this embodiment, a suitable hash algorithm can be selected to encrypt the formatted same-number card information and person card information, thereby obtaining multiple pieces of pre-processed same-number card information and multiple pieces of pre-processed person card information. This encrypted information can better protect customer privacy and data security during subsequent storage, transmission, and query processes.

[0064] Step S103: Store the information of each same-number card and the information of each character card into the application table.

[0065] In the present application, the information of each pre-processed same-number card and the information of each pre-processed character card can be stored in the application table.

[0066] It should be noted that the application table is a database table specifically used to store and process information related to the delivery progress determination of identical card numbers. It plays a core data-carrying and operational role in the bank's identical card delivery progress determination system. The application table will design corresponding storage fields for each identical card number information and person card information. For example, identical card information may have fields such as "Card Number," "Card Type," "Card Application Date," and "Card Production Time." For person card information, it includes fields such as "Card Number," "Cardholder Name," "Cardholder Phone Number," and "Cardholder ID Number." Each pre-processed identical card number information and person card information will be stored in the corresponding location in the application table according to the definitions of these fields. Storing this information in the application table facilitates subsequent operations such as data query, matching, and updating.

[0067] Furthermore, the information of each same-number card and the information of each character card can also be stored in the backup table, so that the data in the backup table can be backed up to the application table when a problem occurs in the application table.

[0068] It's important to note that the backup table is a copy of the application table, with a structure largely identical to the application table. This table is used for data recovery in the event of an application table failure. When storing data, the backup table uses the same field definitions as the application table, storing each pre-processed identical card number and person card information.

[0069] Specifically, the purpose of setting up a backup table is to ensure data security and reliability. During actual data processing, various unexpected situations may occur, such as data loss, corruption, or errors in application tables due to system failures, human error, software vulnerabilities, and so on. In these cases, the data in the backup table can be used as a backup to restore data to the application table, ensuring normal system operation and data integrity. In a bank's card delivery schedule confirmation system, regular backup tasks can be set to back up data from the application table to the backup table at a specified time interval (such as daily, weekly, or monthly). Furthermore, backup operations can be triggered when specific operations or events occur. For example, before a large-scale data update or system upgrade, data from the application table can be backed up to the backup table to ensure timely data recovery in the event of a problem.

[0070] Step S104: For each express delivery number, obtain the recipient information according to the express delivery number.

[0071] It should be noted that the express delivery number is the core identifier in the express company system, which runs through the entire life cycle of the express package.

[0072] In this application, when a courier collects a new package, it generates a unique tracking number for the package and records the recipient's detailed information, including name, phone number, and ID number. This information is stored in the courier's database and tied to the tracking number. Therefore, by sending a query request containing the tracking number to the courier's system, the bank's system can quickly and accurately obtain the corresponding recipient information.

[0073] Furthermore, the express delivery point number can be obtained according to the express delivery order number. The first express delivery point number is used to query the application table to obtain the candidate character card information corresponding to the express delivery order number, and the delivery address number in the candidate character card information is consistent with the express delivery point number.

[0074] It's important to note that a courier outlet number uniquely identifies a specific courier company outlet. In the courier company's system, each tracking number is associated with a corresponding courier outlet number, as parcel collection, sorting, and delivery operations are all performed at specific courier outlets. By sending a query request containing the tracking number to the courier company's system, you can obtain the courier outlet number corresponding to that tracking number.

[0075] Specifically, in the application table, there is a certain correlation between the information of the character card and the express delivery number. Among them, the receiving address number in the character card information can be linked to the express delivery point number. The receiving address number is a code used to identify the receiving address, and the express delivery point number can be associated with the receiving address number, because the express delivery point usually covers a certain area and is responsible for the delivery of packages in the area. By matching the first express delivery point number (the express delivery point number obtained from the express delivery point number) with the receiving address number in the character card information in the application table, the information of the candidate character card corresponding to the express delivery point number can be queried. The receiving address number and the express delivery point number in the candidate character card information are consistent, which means that the receiving address of the character card matches the service area of ​​the express delivery point involved in the express delivery point number.

[0076] Step S105: Use the recipient information to query in the application table to obtain the information of the target person card corresponding to the express delivery number. The card owner information in the target person card information is consistent with the recipient information.

[0077] It's important to note that the cardholder information on the target person card must be consistent with the recipient information. Cardholder information typically includes their name, phone number, and ID number, while recipient information also includes similar information such as name, phone number, and ID number. This is crucial for matching, as the same card number is delivered to the cardholder, and the recipient corresponding to the express delivery number should be the cardholder themselves. Therefore, this consistency matching is used to find the corresponding target person card information.

[0078] In this application, the recipient information obtained from the express delivery number can be used as a query condition to filter the person card information in the application table. The application table stores a large amount of person card information. By setting query conditions, such as the recipient name equals the cardholder name in the person card, the recipient's contact number equals the contact number in the person card, etc., the person card information that meets the conditions can be found from the numerous person card information, that is, the target person card information corresponding to the express delivery number.

[0079] At this time, the recipient information can be used to obtain the target person card information corresponding to the express delivery number from the candidate person card information.

[0080] Specifically, candidate character card information is retrieved from the application table using the courier outlet number. Preliminary screening is performed based on the consistency between the delivery address number and the courier outlet number. This is then used to further refine the match using recipient information, such as name, contact number, and other details, to identify the target character card corresponding to the current courier tracking number. This is because multiple candidate character cards may meet the matching conditions for delivery address and courier outlet number, but only one of the target character cards has the cardholder information completely consistent with the recipient. This allows accurate identification of the character card associated with the courier tracking number, and then linking it to the corresponding card with the same number, providing accurate object reference for subsequent delivery progress tracking and updates.

[0081] Step S106: Query the application table using the target person card information to obtain the target card with the same number corresponding to the express delivery number. The card number of the target card with the same number is consistent with at least one card number included in the target person card information.

[0082] It should be noted that the information of each target person card includes the card application date and card type.

[0083] In this application, the information of the target person card can be used to query in the application table to obtain the information of the target card with the same number corresponding to the express delivery number. The card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, the card application date of the target card with the same number is consistent with at least one card application date included in the information of the target person card, and the card type of the target card with the same number is consistent with at least one card type included in the information of the target person card.

[0084] The card number of the target card with the same number must match at least one card number in the target person card's information. This is because cards with the same number are associated with the person card, and the card number under the person card is the key to determining the card's ownership. Only when the card numbers match can we be sure that the card with the same number is the card corresponding to the person card.

[0085] The application date of the target card with the same number must match at least one of the card application dates listed on the target person's card. The card application date is crucial information for recording the date of card application. By matching the card application date on the person's card, you can further narrow your search and accurately locate the corresponding card with the same number. For example, if the person's card application date is June 1, 2025, then the target card with the same number should also have the same application date. This avoids confusion caused by multiple card numbers with different application dates under the person's card.

[0086] The card type of the target card with the same number must match at least one card type listed in the target person's card information. Card type determines the card's function and scope of use, such as debit, credit, or VIP card. Different card types have different business processing and management requirements. Therefore, card type consistency matching ensures that the business attributes of the found card with the same number match those of the person, further improving query accuracy.

[0087] Specifically, the application table is filtered for cards with the same number, using the target person's card information (including card number, application date, and card type) as query criteria. The application table stores information on numerous cards with the same number. By setting up multiple matching conditions (card number, application date, and type are all consistent), the information on these cards with the same number is found to fully match the target person's card. This is the target card with the same number corresponding to the express delivery number. This multi-condition, precise match query accurately locates the card with the same number associated with the current express delivery number. This is because the delivery of cards with the same number is closely tied to a specific person's card and its corresponding card information. Only by ensuring the consistency of key information such as card number, application date, and card type can subsequent tracking and updates on the delivery progress of cards with the same number be performed on the correct card, thereby enabling precise management and monitoring of the entire process from production to delivery of cards with the same number.

[0088] Step S107: Add the express delivery number and the logistics information obtained based on the express delivery number to the information of the target card with the same number and update it until the target card with the same number is delivered to the customer.

[0089] It's important to note that the tracking number is a unique identifier closely associated with a package. The courier company's system uses this number to record and update the package's logistics information. This information includes the package's pickup time, shipping time, transportation route, transit points along the way, estimated delivery time, and receipt status. The bank system, through an interface with the courier company's system, uses the tracking number to query and obtain this real-time logistics information.

[0090] In this application, after the target card with the same number is determined, an update operation is triggered each time new logistics information is obtained. Logistics information is typically obtained by connecting to the courier company's system. The bank's card with the same number delivery progress determination device will periodically or in real time send a query request containing the courier number to the courier company's system to obtain the latest logistics status.

[0091] Specifically, the express delivery order number is used as the key identifier to associate the same-number card with the express package, and it is clearly recorded in the information of the target same-number card. The logistics status can reflect the in-transit status of the same-number card in real time, such as "collected", "in transit", "arrived at the transfer station", "delivering", "signed for", etc. After finding the information record of the target same-number card in the application table, the obtained express delivery order number and logistics information are added to the corresponding fields according to the preset data structure and field format. For existing logistics information fields, if the new logistics information is different from the previous status, the content of the field is updated. If it is newly added logistics status information, a new record is added to the corresponding position. For example, in the application table, the information of the target same-number card may have a field or area specifically for storing logistics information. Every time there is new logistics information, this information is appended or overwritten to this position.

[0092] The update frequency can be determined based on business needs and system design. It can be real-time, meaning that whenever the courier system updates logistics information, the bank system immediately retrieves and updates the target card with the same number. Alternatively, it can be scheduled, such as querying and updating logistics information corresponding to a batch of courier tracking numbers at regular intervals (such as every hour or at a specific time each day). The update process only stops when the target card with the same number is successfully delivered to the customer and the customer confirms receipt. In practice, the courier system updates the logistics status to "Signed for" after the customer signs for the package. Upon receiving this status, the bank system records it in the target card with the same number, marking the completion of the delivery of the card with the same number, and the update process is complete. Throughout the update process, the bank can provide customers or internal staff with a delivery progress query service for the card with the same number based on the information in the application table, allowing customers to understand the real-time status of the card in transit and improving the customer service experience.

[0093] In summary, the present application provides a method for determining the delivery progress of identical cards for a bank. The method is applied to a device for determining the delivery progress of identical cards for a bank. The device is communicatively connected to a bank data warehouse, a bank reporting server, and a bank operating device. The method comprises: first, receiving multiple express delivery tracking numbers from the bank operating device to achieve centralized management of the express delivery tracking numbers, thereby avoiding the tedious and error-prone manual entry. Then, information on the multiple identical cards and information on multiple person cards are obtained from the bank data warehouse and the bank reporting server, respectively, and stored in an application table, thereby integrating the bank's internal data resources. Then, for each express delivery tracking number, recipient information is obtained based on the express delivery tracking number. The recipient information is used to query the application table to obtain information on the target person card corresponding to the express delivery tracking number. The card number of the target person card is used to query the application table to obtain information on the target identical card corresponding to the express delivery tracking number. The express delivery tracking number is automatically matched with the identical card information, thereby avoiding manual matching errors and improving data processing efficiency. Finally, the express delivery number and the logistics information obtained based on the express delivery number are added to the information of the target card with the same number and updated until the target card with the same number is delivered to the customer, so that the customer can check the logistics progress of the card with the same number at any time, simplifying the delivery progress tracking process of the card with the same number.

[0094] Furthermore, based on the above method, the following steps may be further included: first, the information of each card with the same number and the information of each person card are checked to obtain error information of each card with the same number and the error information of each person card; then, the error information of each card with the same number and the error information of each person card are stored in an error record table, and the error record table is sent to a bank operating device, so that a bank operator can correct the error information of each card with the same number and the error information of each person card in the error record table through the bank operating device.

[0095] Specifically, the information of each card with the same number and each person's card is checked to promptly identify errors or anomalies. These errors may include, but are not limited to, data format errors (such as card number length violations or incorrect date formats), data inconsistencies (cardholder information on the card with the same number does not match that on the person's card), and missing data (such as key fields being empty). Automated data checking can be achieved by writing testing scripts or using data quality testing tools. These scripts or tools will check each field in the card with the same number and person's card information based on pre-set rules and validation logic. For example, they will check whether the card number complies with the bank's encoding rules, whether the card issuance time is within a reasonable timeframe, and whether the cardholder's name contains illegal characters.

[0096] A dedicated error log table can then be established to store error information for each card with the same number and each character card discovered during the detection process. This table typically includes a detailed description of the error, such as the error type, the information item where the error occurred, the time the error occurred, and the corresponding card number of the card with the same number or character card. When an error is detected, the error information is organized according to the field requirements of the error log table and stored in the table. For example, if a card with the same number is found to have a card number size error, the error type is recorded as "Card number size error," and the contents of the card number field where the error occurred, along with the card number of the card with the same number, are recorded and stored in the error log table.

[0097] Finally, the error log can be sent to the bank's operating device, allowing bank staff to promptly review and understand these error messages and correct them. The bank's operating device is a terminal used for internal bank operations and processing. Staff can view the error log and take appropriate actions based on the error prompts. The error log can be sent to the bank's operating device in the form of a file (such as an Excel file or text file) via the bank's internal network communication system. An automatic push function can also be configured in the bank's operating system to automatically display updates to the error log on a designated screen on the bank's operating device, making it easier for staff to review and process them.

[0098] To sum up, the present application provides a method for correcting an error record table. This method can detect and record error information in a timely manner by detecting the same-number card information and person card information. The error record table records the error information in detail, provides a basis for the bank to track problems, and prompts bank operators to correct these errors, thereby improving the accuracy, completeness and consistency of the information, and providing a more reliable data basis for subsequent operations such as determining the delivery progress.

[0099] The above describes a method for determining the delivery progress of a bank card with the same number provided in an embodiment of the present application. The following describes a device for determining the delivery progress of a bank card with the same number that executes the above method.

[0100] See also Figure 2 , Figure 2 This is a schematic diagram of a device for determining the delivery progress of a bank card with the same number provided in an embodiment of the present application. The device is respectively connected to a bank data warehouse, a bank report server, and a bank operation device. Figure 2 As shown, the bank's delivery progress determination device for the same-number card includes:

[0101] The receiving unit 11 is configured to receive a courier number file sent by the bank operating device, wherein the courier number file includes a plurality of courier numbers.

[0102] The acquisition unit 12 is used to acquire information of multiple cards with the same number from the bank data warehouse and acquire information of multiple person cards from the bank report server, wherein the information of each person card includes cardholder information and card number.

[0103] The storage unit 13 is used to store the information of each of the same-number cards and the information of each of the character cards into an application table.

[0104] The obtaining unit 14 is configured to obtain the recipient information according to each express delivery number.

[0105] The first query unit 15 is used to query the application table using the recipient information to obtain the information of the target person card corresponding to the express number, wherein the card owner information in the target person card information is consistent with the recipient information.

[0106] The second query unit 16 is used to query the application table using the information of the target person card to obtain information of a target card with the same number corresponding to the express number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card.

[0107] The updating unit 17 is used to add the express number to the information of the target card with the same number, and update the logistics status of the information of the target card with the same number based on the obtained logistics information of the express number until the target card with the same number is delivered to the customer.

[0108] In a possible implementation, the apparatus further includes:

[0109] The number obtaining unit is used to obtain the express outlet number according to the express order number.

[0110] The third query unit is used to query the application table using the first express outlet number to obtain information of a candidate character card corresponding to the express order number, wherein the receiving address number in the information of the candidate character card is consistent with the express outlet number.

[0111] The first query unit 15 includes:

[0112] The first obtaining subunit is configured to obtain information of a target person card corresponding to the express delivery number from information of the candidate person card using the recipient information.

[0113] In a possible implementation, the information of each target person card includes the card application date and card type.

[0114] The second query unit 16 includes:

[0115] The second obtaining sub-unit is used to use the information of the target person card to query in the application table to obtain the information of the target card with the same number corresponding to the express delivery number, the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, the card application date of the target card with the same number is consistent with at least one card application date included in the information of the target person card, and the card type of the target card with the same number is consistent with at least one card type included in the information of the target person card.

[0116] In a possible implementation, the apparatus further includes:

[0117] The processing unit is used to format the information of each of the same-number cards and the information of each of the character cards respectively to obtain a plurality of formatted information of the same-number cards and a plurality of formatted information of the character cards.

[0118] The encryption unit is used to encrypt the information of each formatted same-number card and the information of each formatted character card respectively to obtain multiple pre-processed information of the same-number card and multiple pre-processed information of the character card.

[0119] The storage unit 13 includes:

[0120] The storage subunit is used to store the information of each of the pre-processed same-number cards and the information of each of the pre-processed character cards into the application table.

[0121] In a possible implementation, the apparatus further includes:

[0122] The detection unit is used to detect the information of each of the same-number cards and the information of each of the character cards to obtain error information of each of the same-number cards and the error information of each of the character cards.

[0123] The sending unit is used to store the error information of each of the same-number cards and the error information of each of the character cards in an error record table, and send the error record table to the bank operating device, so that the bank operator can correct the error information of each of the same-number cards and the error information of each of the character cards in the error record table through the bank operating device.

[0124] In a possible implementation, the apparatus further includes:

[0125] The information storage unit is used to store the information of each of the same-number cards and the information of each of the character cards in a backup table, so as to back up the data in the backup table to the application table when a problem occurs in the application table.

[0126] An electronic device is also provided in an embodiment of the present application. Figure 3, which shows a schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present application. The electronic device in the embodiments of the present application may include, but is not limited to, fixed terminals such as mobile phones, laptops, PDAs (personal digital assistants), PADs (tablet computers), desktop computers, etc. Figure 3 The electronic device shown is merely an example and should not limit the functions and scope of use of the embodiments of the present application.

[0127] like Figure 3 As shown, the electronic device may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 301, which can perform various appropriate actions and processes based on programs stored in a read-only memory (ROM) 302 or programs loaded from a storage device 308 into a random access memory (RAM) 303. When the electronic device is powered on, the RAM 303 also stores various programs and data required for the operation of the electronic device. The processing device 301, ROM 302, and RAM 303 are interconnected via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0128] Typically, the following devices may be connected to the I / O interface 305: an input device 303 including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 307 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 308 including, for example, a memory card, a hard disk, etc.; and a communication device 309. The communication device 309 may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. Figure 3 The electronic device is shown with various devices, but it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed instead.

[0129] An embodiment of the present application also provides a computer program product including computer-readable instructions. When the computer-readable instructions are executed on an electronic device, the electronic device implements the method for determining the delivery progress of a card with the same number of any bank provided in the embodiment of the present application.

[0130] A computer-readable storage medium is also provided in an embodiment of the present application. The storage medium carries one or more computer programs. When one or more computer programs are executed by an electronic device, the electronic device can implement the method for determining the delivery progress of the same-number card of any bank provided in an embodiment of the present application.

[0131] It should also be noted that the device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed across multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the present embodiment. In addition, in the drawings of the device embodiments provided in this application, the connection relationship between the modules indicates that there is a communication connection between them, which can be specifically implemented as one or more communication buses or signal lines.

[0132] Through the description of the above embodiments, those skilled in the art can clearly understand that the present application can be implemented by means of software plus necessary general hardware, and of course can also be implemented by special hardware including application-specific integrated circuits, special CPUs, special memories, special components, etc. In general, all functions performed by computer programs can be easily implemented with corresponding hardware, and the specific hardware structures used to implement the same function can also be diverse, such as analog circuits, digital circuits or special circuits, etc. However, for the present application, software program implementation is a better implementation method in most cases. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a readable storage medium, such as a computer's floppy disk, USB flash drive, mobile hard disk, ROM, RAM, magnetic disk or optical disk, etc., and includes a number of instructions to enable a computer device (which can be a personal computer, training equipment, or network equipment, etc.) to execute the methods described in each embodiment of the present application.

[0133] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware, or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product.

[0134] The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions can be transmitted from a website, a computer, a training device or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website, a computer, a training device or a data center. The computer-readable storage medium can be any available medium that a computer can store or a data storage device such as a training device, a data center, etc. that includes one or more available media integrations. The available medium can be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive (SSD)).

Claims

1. A method for determining the delivery progress of a bank card with the same number, characterized in that: A device for determining the delivery progress of a card with the same number applied to the bank, wherein the device is respectively connected to a bank data warehouse, a bank report server, and a bank operation device, and the method includes: Receiving a courier number file sent by the bank operating device, wherein the courier number file includes multiple courier numbers; Obtaining information of multiple cards with the same number from the bank data warehouse, and obtaining information of multiple person cards from the bank report server, wherein the information of each person card includes cardholder information and card number; Storing the information of each of the same-number cards and the information of each of the character cards in an application table; For each express delivery number, obtain recipient information according to the express delivery number; Using the recipient information to query the application table, obtain the target person card information corresponding to the express number, where the cardholder information in the target person card information is consistent with the recipient information; Using the information of the target person card to query the application table, obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card; The express delivery number and the logistics information obtained based on the express delivery number are added to the information of the target card with the same number and updated until the target card with the same number is delivered to the customer.

2. The method for determining the delivery progress of a bank card with the same number according to claim 1, characterized in that: After obtaining the recipient information according to each express delivery number, the method further includes: Obtain the express delivery outlet number according to the express delivery number; Using the first express delivery outlet number to query the application table, obtain information of a candidate character card corresponding to the express delivery number, where the delivery address number in the candidate character card information is consistent with the express delivery outlet number; The method of querying the application table using the recipient information to obtain the information of the target person card corresponding to the express delivery number includes: The recipient information is used to obtain the target person card information corresponding to the express delivery number from the candidate person card information.

3. The method for determining the delivery progress of a bank card with the same number according to claim 1, characterized in that: The information of each target person card includes the card application date and card type; The method of using the information of the target person card to query the application table to obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, includes: The information of the target person card is used to query the application table to obtain the information of the target card with the same number corresponding to the express delivery number, the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card, the card application date of the target card with the same number is consistent with at least one card application date included in the information of the target person card, and the card type of the target card with the same number is consistent with at least one card type included in the information of the target person card.

4. The method for determining the delivery progress of a bank card with the same number according to claim 1, characterized in that: After obtaining information of multiple cards with the same number from the bank data warehouse and obtaining information of multiple person cards from the bank report server, the method further includes: Formatting the information of each of the same-number cards and the information of each of the character cards respectively to obtain a plurality of formatted information of the same-number cards and a plurality of formatted information of the character cards; Encrypting the information of each formatted same-number card and the information of each formatted person card respectively to obtain a plurality of pre-processed information of the same-number card and a plurality of pre-processed information of the person card; The storing the information of each of the same-number cards and the information of each of the character cards into the application table includes: The information of each of the pre-processed same-number cards and the information of each of the pre-processed character cards are stored in the application table.

5. The method for determining the delivery progress of a bank card with the same number according to claim 1, characterized in that: The method further comprises: Detecting the information of each of the same-number cards and the information of each of the character cards to obtain error information of each of the same-number cards and error information of each of the character cards; The error information of each of the same-number cards and the error information of each of the character cards are stored in an error record table, and the error record table is sent to the bank operating device, so that the bank operator can correct the error information of each of the same-number cards and the error information of each of the character cards in the error record table through the bank operating device.

6. The method for determining the delivery progress of a bank card with the same number according to claim 1, characterized in that: After storing the information of each of the same-number cards and the information of each of the character cards in the application table, the method further includes: The information of each of the same-number cards and the information of each of the character cards are stored in a backup table, so that when a problem occurs in the application table, the data in the backup table can be backed up to the application table.

7. A bank's delivery progress determination device for a card with the same number, characterized in that: The device is respectively connected to the bank data warehouse, the bank report server, and the bank operation equipment in communication, and the device includes: A receiving unit, configured to receive a courier number file sent by the bank operating device, wherein the courier number file includes a plurality of courier numbers; An acquisition unit, configured to acquire information of a plurality of cards with the same number from the bank data warehouse, and acquire information of a plurality of person cards from the bank report server, wherein the information of each person card includes cardholder information and card number; A storage unit, configured to store information of each of the same-number cards and information of each of the character cards into an application table; An obtaining unit, configured to obtain, for each express delivery number, recipient information according to the express delivery number; A first query unit is configured to query the application table using the recipient information to obtain information of a target person card corresponding to the express delivery number, wherein the cardholder information in the target person card information is consistent with the recipient information; a second query unit, configured to query the application table using the information of the target person card to obtain information of a target card with the same number corresponding to the express delivery number, wherein the card number of the target card with the same number is consistent with at least one card number included in the information of the target person card; An updating unit is used to add the express delivery number to the information of the target card with the same number, and update the logistics status of the information of the target card with the same number based on the obtained logistics information of the express delivery number until the target card with the same number is delivered to the customer.

8. A computer program product, characterized in that It includes computer-readable instructions, which, when executed on an electronic device, enable the electronic device to implement the method for determining the delivery progress of a bank card with the same number as described in any one of claims 1 to 6.

9. An electronic device, characterized in that: comprising at least one processor and a memory connected to the processor, wherein: The memory is used to store computer programs; The processor is used to execute the computer program so that the electronic device can implement the method for determining the delivery progress of the bank's same-number card as described in any one of claims 1 to 6.

10. A computer storage medium, characterized in that The storage medium carries one or more computer programs, which, when executed by an electronic device, enable the electronic device to implement the method for determining the delivery progress of the bank's same-number card as described in any one of claims 1 to 6.

Images