Ticket cancel-after-verification method compatible with network offline mode

Abstract

The invention discloses an entrance ticket cancel-after-verification method compatible with a network offline mode, and relates to the technical field of entrance ticket cancel-after-verification, and the method comprises the following steps: selecting a cancel-after-verification mode of a POS machine according to the network condition and demand in a use scene, and the mode is one of an automatic mode, an offline mode and a common mode. Three verification modes including an offline mode and a common mode are selected, the offline mode is adopted when the network is poor, ticket information is stored in a local sqlite database of the POS machine and compared with existing ticket information in the local sqlite database, so that repeated verification is avoided, and when the network is unstable, the automatic mode is adopted, so that the ticket verification efficiency is improved. According to the method and the system, the ticket information is transmitted through the network to be cancelled after verification, and when the network transmission fails, the ticket information is input into the local sqlite database of the POS machine to be compared and cancelled after verification, so that the two-dimensional code ticket can still be cancelled after verification when the network of the POS machine is interrupted, and the efficiency of cancelling after verification of the ticket is improved.

Description

Technical Field

[0001] The invention relates to the technical field of ticket cancellation, in particular to a ticket cancellation method in a compatible network offline mode. Background Art

[0002] Most scenic spots sell tickets online. After users complete the online ticket purchase, when verifying the ticket, the staff needs to use the POS machine to scan the ticket QR code for verification. However, if it is during the peak user period, the number of people is relatively dense, and a large number of users use the mobile network at the same time, it will increase signal interference, causing network congestion and freezes. In severe cases, it will cause network disconnection, thereby affecting the efficiency of ticket verification and resulting in a poor user experience. For this reason, we propose a ticket verification method that is compatible with the network offline mode. Summary of the invention

[0003] In view of the deficiencies of the prior art, the present invention provides a ticket verification method in a compatible network offline mode, which solves the problems raised in the above background technology.

[0004] To achieve the above purpose, the present invention is implemented by the following technical solution: a ticket verification method in a compatible network offline mode, comprising the following steps:

[0005] S1: Select the verification mode of the POS terminal according to the network status and needs in the usage scenario, which can be one of the automatic mode, offline mode and normal mode;

[0006] S11: When the network condition is good and the tourist flow is moderate, the tourist's ticket QR code is scanned by the POS machine in normal mode, and the QR code scan information is transmitted to the terminal through the network to cancel the ticket. When the cancellation is successful, the cancellation result is displayed on the POS machine and the completion of the cancellation is announced by voice;

[0007] S12: When the network condition is poor and the tourist traffic is at a peak, the offline mode is turned on, the tourist's ticket QR code is scanned by the POS machine, and the scanned ticket information is stored in the local sqlite database of the POS machine. When the data is stored, it will be compared with the ticket verification data stored in the local sqlite database of the POS machine. When there is no verification order data of the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice, and the order information is recorded in the waiting verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the same ticket verification data exists in the local sqlite database, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice;

[0008] S13: When the network condition is unstable and the tourist flow is large, the automatic mode is turned on, and the tourist's ticket QR code is scanned by the POS machine, and the QR code scan information is transmitted through the network for verification. When the verification is successful, the normal verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice. When the verification fails, the POS system automatically analyzes whether the verification failure is caused by network problems. When the system analyzes that the verification failure is not caused by the network, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice. When the system analyzes that the verification failure is caused by the network, the QR code ticket information is stored in the data storage to the POS The POS machine stores the data in the local sqlite database of the POS machine, and compares the existing QR code ticket information in the local sqlite database. When there is no verification order data for the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and a voice announcement is made at the same time. The order information is recorded in the pending verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the local sqlite database contains the same ticket verification data, the verification failure result is displayed on the POS machine, and a voice announcement is made on the verification failure.

[0009] Optionally, in step S1, after selecting to turn on the offline mode and the automatic mode, when the QR code ticket information is stored in the local sqlite database of the POS machine, the verification APP of the POS machine automatically runs the scheduled task program in the background, and automatically uploads the QR code ticket information entered in the to-be-verified table to the terminal through the network at regular intervals for verification. When the upload and verification is successful, the uploaded QR code ticket information will be changed from the to-be-verified status to the verified status in the local sqlite database of the POS machine.

[0010] Optionally, the structure of the QR code ticket adopts GUID + added order information and signature, and the signature adopts RSA2.

[0011] The present invention provides a ticket verification method in a compatible network offline mode, which has the following beneficial effects:

[0012] 1. The ticket verification method in the compatible network offline mode selects the automatic mode, offline mode and normal mode of the POS machine according to the network conditions and tourist flow conditions when the staff verifies the tourists' QR code tickets. When the network is poor, the offline mode is used to store the ticket information in the local sqlite database of the POS machine, and compare it with the existing ticket information in the local sqlite database to avoid repeated verification. When the network is unstable, the automatic mode is used to transmit the ticket information to the terminal through the network for verification. When the network transmission fails, it is entered into the local sqlite database of the POS machine for comparison and verification, so that the QR code ticket can still be verified when the POS machine network is interrupted. Through the flexible use of the three modes, the congestion of tourists in the scenic area is avoided, the efficiency of ticket verification is improved, and the scaled tour experience is improved. This method has been put into use in the electric vehicle ticket verification scenario of Luoyang Longmen Scenic Area. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 The present invention is a flowchart of a ticket verification method in a compatible network offline mode. DETAILED DESCRIPTION

[0014] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments.

[0015] See also Figure 1 The present invention provides a technical solution: a ticket verification method in a compatible network offline mode, comprising the following steps:

[0016] S1: Select the verification mode of the POS terminal according to the network status and needs in the usage scenario, which can be one of the automatic mode, offline mode and normal mode;

[0017] S11: When the network condition is good and the tourist flow is moderate, the tourist's ticket QR code is scanned by the POS machine in normal mode, and the QR code scan information is transmitted to the terminal through the network to cancel the ticket. When the cancellation is successful, the cancellation result is displayed on the POS machine and the completion of the cancellation is announced by voice;

[0018] S12: When the network condition is poor and the tourist traffic is at a peak, the offline mode is turned on, the tourist's ticket QR code is scanned by the POS machine, and the scanned ticket information is stored in the local sqlite database of the POS machine. When the data is stored, it will be compared with the ticket verification data stored in the local sqlite database of the POS machine. When there is no verification order data of the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice, and the order information is recorded in the waiting verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the same ticket verification data exists in the local sqlite database, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice;

[0019] S13: When the network condition is unstable and the tourist flow is large, the automatic mode is turned on, and the tourist's ticket QR code is scanned by the POS machine, and the QR code scan information is transmitted through the network for verification. When the verification is successful, the normal verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice. When the verification fails, the POS system automatically analyzes whether the verification failure is caused by network problems. When the system analyzes that the verification failure is not caused by the network, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice. When the system analyzes that the verification failure is caused by the network, the QR code ticket information is stored in the data storage to the POS The POS machine stores the data in the local sqlite database of the POS machine, and compares the existing QR code ticket information in the local sqlite database. When there is no verification order data for the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and a voice announcement is made at the same time. The order information is recorded in the pending verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the local sqlite database contains the same ticket verification data, the verification failure result is displayed on the POS machine, and a voice announcement is made on the verification failure.

[0020] Among them, in step S1, after selecting to turn on the offline mode and the automatic mode, when the QR code ticket information is stored in the local sqlite database of the POS machine, the verification APP of the POS machine automatically runs the scheduled task program in the background, and automatically uploads the QR code ticket information entered in the to-be-verified table to the terminal through the network at intervals for verification. When the upload verification is successful, the uploaded QR code ticket information will be changed from the to-be-verified status to the verified status in the local sqlite database of the POS machine.

[0021] The structure of the QR code ticket adopts GUID + added order information and signature, and the signature adopts RSA2.

[0022] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0023] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A ticket verification method in a compatible network offline mode, characterized in that: The following steps are involved: S1: Select the verification mode of the POS terminal according to the network status and needs in the usage scenario, which can be one of the automatic mode, offline mode and normal mode; S11: When the network condition is good and the tourist flow is moderate, the tourist's ticket QR code is scanned by the POS machine in normal mode, and the QR code scan information is transmitted to the terminal through the network to cancel the ticket. When the cancellation is successful, the cancellation result is displayed on the POS machine and the completion of the cancellation is announced by voice; S12: When the network condition is poor and the tourist traffic is at a peak, the offline mode is turned on, the tourist's ticket QR code is scanned by the POS machine, and the scanned ticket information is stored in the local sqlite database of the POS machine. When the data is stored, it will be compared with the ticket verification data stored in the local sqlite database of the POS machine. When there is no verification order data of the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice, and the order information is recorded in the waiting verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the same ticket verification data exists in the local sqlite database, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice; S13: When the network condition is unstable and the tourist flow is large, the automatic mode is turned on, and the tourist's ticket QR code is scanned by the POS machine, and the QR code scan information is transmitted through the network for verification. When the verification is successful, the normal verification is completed, and the verification completion result is displayed on the POS machine, and the verification completion is announced by voice. When the verification fails, the POS system automatically analyzes whether the verification failure is caused by network problems. When the system analyzes that the verification failure is not caused by the network, the verification failure result is displayed on the POS machine, and the verification failure is announced by voice. When the system analyzes that the verification failure is caused by the network, the QR code ticket information is stored in the data storage to the POS The POS machine stores the data in the local sqlite database of the POS machine, and compares the existing QR code ticket information in the local sqlite database. When there is no verification order data for the same ticket in the local sqlite database of the POS machine, the order verification is completed, and the verification completion result is displayed on the POS machine, and a voice announcement is made at the same time. The order information is recorded in the pending verification table in the local sqlite database of the POS machine. When the data is stored in the local sqlite database of the POS machine, if the local sqlite database contains the same ticket verification data, the verification failure result is displayed on the POS machine, and a voice announcement is made on the verification failure.

2. A ticket verification method in a compatible network offline mode according to claim 1, characterized in that: In the step S1, after selecting to turn on the offline mode and the automatic mode, when the QR code ticket information is stored in the local sqlite database of the POS machine, the verification APP of the POS machine automatically runs the scheduled task program in the background, and automatically uploads the QR code ticket information entered in the to-be-verified table to the terminal through the network at regular intervals for verification. When the upload verification is successful, the to-be-verified status of the uploaded QR code ticket information in the local sqlite database of the POS machine is changed to verified.

3. The ticket verification method in a compatible network offline mode according to claim 1, characterized in that: The structure of the QR code ticket adopts GUID+added order information and signature, and the signature adopts RSA2.

Images