CN114490701A - Intelligent scenic spot offline ticket data processing method, system and storage medium - Google Patents
Intelligent scenic spot offline ticket data processing method, system and storage medium Download PDFInfo
- Publication number
- CN114490701A CN114490701A CN202210235785.5A CN202210235785A CN114490701A CN 114490701 A CN114490701 A CN 114490701A CN 202210235785 A CN202210235785 A CN 202210235785A CN 114490701 A CN114490701 A CN 114490701A
- Authority
- CN
- China
- Prior art keywords
- ticket
- offline
- online
- ticketing
- private
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 15
- 238000012545 processing Methods 0.000 claims abstract description 21
- 238000000034 method Methods 0.000 claims abstract description 17
- 230000001502 supplementing effect Effects 0.000 claims description 21
- 238000004064 recycling Methods 0.000 claims description 17
- 238000004590 computer program Methods 0.000 claims description 4
- 238000011084 recovery Methods 0.000 claims description 4
- 239000013589 supplement Substances 0.000 claims description 4
- 238000012163 sequencing technique Methods 0.000 claims description 3
- 230000002354 daily effect Effects 0.000 description 7
- 230000003203 everyday effect Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/14—Travel agencies
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of data processing, in particular to an intelligent scenic spot offline ticket business data processing method, system and storage medium. The method, the system and the storage medium mainly realize the steps that: establishing an online ticket business server and an offline ticket business server, and forming ticket records corresponding to the number of tickets in all scenic spots in a ticket business database; dividing the entrance ticket record into a public ticket type and a private ticket type; selecting and editing an entrance ticket record of a private ticket type from an offline ticket record table according to ticket purchasing information and issuing a corresponding entity ticket; and when the ticket record of the private ticket type is insufficient, modifying the ticket record of the public ticket type acquired from the online distribution node into the private ticket type. The invention firstly carries out centralized processing on the ticket business conditions of each online and offline distribution channel, and simultaneously calls and records the offline ticket sales conditions through the offline ticket business server, and carries out issuing control on the offline tickets according to the ticket purchasing information.
Description
Technical Field
The invention relates to the field of data processing, in particular to an intelligent scenic spot offline ticket business data processing method, system and storage medium.
Background
The prior scenic spot entrance tickets are generally sold in two ways of on-line ticketing and off-line ticketing, wherein the off-line ticketing comprises scenic spot ticket machine ticketing and scenic spot window ticketing, the scenic spot window ticketing mainly aims at the preferential treatment groups such as the elders, children and soldiers, and the users who purchase tickets by cash, the sold entrance tickets are generally two-link paper entrance tickets which are connected by a broken line or a broken line, one of the two-link is a ticket face, the other link is a ticket root, the ticket root is a paper entrance ticket with ticket checking identification information, and the ticket checking identification information comprises a magnetic strip, a two-dimensional code or a bar code. When in ticket checking, a ticket checker tears off the ticket root and identifies the ticket checking identification information on the ticket root through the gate, the ticket is opened for passing after passing, and the ticket face is reserved by tourists. Such offline physical tickets are mainly used for solving the ticket purchasing types and the ticket purchasing needs of people which are inconvenient for self-service operation.
However, such offline physical tickets have several problems in actual data processing and statistics. Firstly, the tickets are reserved, namely, a certain proportion is reserved from the total tickets which can be supplied, the manufactured offline entity tickets are sold online, and the rest tickets are sold online; secondly, such offline entity tickets are difficult to realize data processing rules of people, certificates and tickets, the tickets which are printed in a centralized manner only record information such as scenic spots, dates, times, prices and the like, and certificate information about ticket purchasers cannot be added, so that the tickets are easy to sell after being purchased in a centralized manner, and real data records cannot be acquired in the process of affairs such as scenic spot emergency management, later consumption complaints and the like.
Disclosure of Invention
In order to solve the above technical problems, in a first aspect, the present invention provides an intelligent scenic spot offline ticket business data processing method, which enables offline physical tickets to record more information and facilitate statistics and search.
The method comprises the following steps:
s1, establishing an online ticketing server and an offline ticketing server, establishing a ticketing database in the online ticketing server, issuing all daily scenic spot entrance tickets through the ticketing database, and forming entrance ticket records corresponding to the number of all scenic spot entrance tickets in the ticketing database;
s2, dividing the entrance ticket records into a public ticket type for each online distribution node to purchase and a private ticket type for the offline ticket server to call according to a preset proportion;
s3, acquiring entrance ticket records of private ticket types in the online ticketing server through the offline ticketing server, establishing an offline ticketing record table, receiving entrance ticket purchase requests of all offline ticketing nodes, reading ticket purchase information of the offline ticketing nodes, and selecting and editing an entrance ticket record of the private ticket types from the offline ticketing record table according to the ticket purchase information;
s4, the offline ticketing server issues an edited private ticket record to an offline ticketing node, and the offline ticketing node generates corresponding entity ticket face information according to the received edited private ticket record and issues the corresponding entity ticket;
s5, when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online ticket selling nodes, receive responses of the online ticket selling nodes, modify the entrance ticket records of the public ticket types obtained from the online ticket selling nodes into the private ticket types, the online ticket selling servers obtain the entrance ticket records modified into the private ticket types, and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
By adopting the method, when the intelligent scenic spot offline ticket data processing method is used for processing, online and offline tickets are firstly published in a centralized manner, the online ticket server processes the tickets of all online and offline distribution channels in a centralized manner, the offline ticket server calls and records the offline ticket sales conditions, and the offline tickets are issued and controlled according to the ticket purchasing information, so that the online and offline ticket quantity, types and prices can be effectively counted, the ticket purchasing information can be recorded, repeated ticket purchasing is avoided, and the condition of excessive issuing caused by different online and offline information is avoided.
In one possible implementation, the method further includes the steps of:
s6, when the tickets of the public ticket types called by one or more online distribution nodes are insufficient in record, the online distribution nodes with insufficient ticket records send online ticket source supplement requests to an online ticketing server, the online ticketing server sends remaining ticket recovery requests to the online distribution nodes with remaining ticket records, receives responses of the online distribution nodes with remaining ticket records, and allocates the tickets of the public ticket types obtained by the online distribution nodes with remaining ticket records to the online distribution nodes with insufficient ticket records;
s7, after the online ticketing server sends the surplus ticket recycling request, when the wireless upper distribution node responds or the public ticket type entrance tickets of one or more online distribution nodes are still insufficient after being allocated, the online distribution node further sends the ticket purchasing information to an online ticketing server, the online ticketing server forwards the ticket purchasing information to an offline ticketing server, the offline ticketing server selects and edits a ticket record of a private ticket type and a ticket fetching voucher from an offline ticketing record table according to the ticket purchasing information, the ticket fetching voucher is uploaded to the online ticketing server and forwarded to the online distribution node which makes a request, on the day of the ticket selling, the offline ticket selling node reads the ticket-taking certificate and searches and reads the corresponding private ticket record from the offline ticket service server, and generating corresponding entity ticket face information according to the private ticket record, and issuing the corresponding entity ticket.
In a possible implementation manner, the fields of the entrance ticket record in step S1 include one or more of a call type, a date of use, a ticket price, a discount type, a purchase channel, and ticket fetching information.
In one possible implementation, the public and private ticket types in step S2 are marked in the call type field of the ticket record.
In one possible implementation manner, the step S3 of obtaining, by the offline ticket server, an entrance ticket record of a private ticket type in the online ticket server, and creating the offline ticket record table further includes the steps of:
s31, setting a pre-sale time period comprising a plurality of continuous natural days and the sale starting time and the sale stopping time of each natural day in the pre-sale time period in an online ticketing server;
s32, at the starting time of the pre-sale time period, the online off-line ticket server acquires the entrance ticket record of the private ticket type in the online ticket server;
s33, the offline ticket server establishes an offline ticket record table according to the acquired entrance ticket record of the private ticket type;
s34, when the sale stopping time of the first natural day of the pre-sale time period is up, the off-line server uploads the sold entrance ticket records to the on-line ticketing server, and then the first-day entrance ticket records in the ticketing record table are deleted;
and S35, when the sale starting time of the next day of the continuous natural day is up, the offline ticket server acquires the entrance ticket record of the type of the private ticket of the next day from the online ticket server, and the entrance ticket record is merged into the original ticket record table to complete the updating of the ticket record table.
In a possible implementation manner, the step S3 of receiving an entrance ticket purchase request of each offline ticketing node, reading the ticket purchase information of the offline ticketing node, and selecting and editing an entrance ticket record of a private ticket type from the offline ticket record table according to the ticket purchase information, further includes the steps of:
s36, the offline ticketing node receives a ticket buying application of the user, records ticket buying information of the user and uploads the ticket buying information to an offline ticketing server;
s37, the offline ticket server selects a saleable ticket record from the ticket record table, and modifies one or more corresponding fields in the ticket record according to the ticket purchasing information of the user;
and S38, taking the modified entrance ticket record as a private ticket record corresponding to the ticketing information.
In one possible implementation manner, the step S4 issues the corresponding entity ticket, that is, the information of the entity ticket face is printed on the entity ticket face and delivered to the ticket buyer.
In a possible implementation manner, the online ticketing server in step S5 sends the remaining ticket recycling request to each online distribution node, further comprising the steps of:
s51, performing allowance sequencing on the admission ticket records of the public ticket types purchased by each online distribution node;
and S52, sending a surplus ticket recycling request to one or more online distribution nodes with the largest surplus.
In a second aspect, the present invention further provides an intelligent offline ticket processing system in a scenic spot, the system comprising:
the online distribution node is used for purchasing tickets of scenic spots for sale online;
the off-line ticket selling node is an artificial or automatic ticket selling device positioned in a scenic spot and used for selling tickets for the scenic spot on the scene of the scenic spot;
an online ticketing server; communicating with an online distribution node, establishing and storing a ticket database, issuing all daily scenic spot tickets through the ticket database, forming ticket records corresponding to the number of all scenic spot tickets in the ticket database, and dividing the ticket records into public ticket types and private ticket types according to a preset proportion;
offline ticket service server: communicating with an offline ticket selling node and an online ticket selling server, acquiring entrance ticket records of private ticket types in the online ticket selling server, establishing an offline ticket selling record table, receiving entrance ticket purchasing requests of all offline ticket selling nodes, reading and storing ticket purchasing information of the offline ticket selling nodes, selecting and editing an entrance ticket record of a private ticket type from a ticket database of the online ticket selling server through the offline ticket selling nodes, issuing the entrance ticket record to the offline ticket selling nodes, and generating corresponding entity ticket face information by the offline ticket selling nodes according to the received edited private ticket record and issuing corresponding entity tickets;
when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online distributing nodes, receive the responses of the online distributing nodes, modify the entrance ticket records of the public ticket types obtained from the online distributing nodes into the private ticket types, and the online ticket selling servers obtain the entrance ticket records modified into the private ticket types and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
In a third aspect, the present invention also provides a storage medium storing a computer program comprising program instructions which, when executed by a processor, cause the processor to perform the method of the first aspect.
Drawings
Fig. 1 is a schematic flow chart of the first embodiment.
Fig. 2 is a schematic flow chart of a second embodiment.
Fig. 3 is a detailed flowchart of step S3 in the third embodiment.
Fig. 4 is a detailed flowchart of the step of sending the remaining ticket recycling request in step S5 in the fourth embodiment.
Fig. 5 is a schematic block diagram of a fifth embodiment.
Detailed Description
A first embodiment of the present invention relates to a new method for processing offline tickets in an intelligent scenic spot, as shown in fig. 1, the method includes the steps of:
s1, establishing an online ticketing server and an offline ticketing server, establishing a ticketing database in the online ticketing server, issuing all daily scenic spot entrance tickets through the ticketing database, and forming entrance ticket records corresponding to the number of all scenic spot entrance tickets in the ticketing database;
for the ticketing of scenic spots, there are many division modes, for example, the division modes can be divided into sales taking and self-selling according to the difference of sales channels, and the division modes can be divided into online sales and offline sales according to the difference of sales modes.
Step S1 is to unify the online sale and offline sale entrance ticket data sources into one data source, and to call corresponding records from the ticketing database to process the sale data so as to uniformly control the total amount of online and offline sales, and to establish a data source basis for subsequent ticketing data allocation.
The fields of the entrance ticket record comprise one or more of calling type, using date, ticket price, discount type, purchasing channel and ticket fetching information.
The calling type is described in detail in the following description of step S2, the date of use is a date that the ticket record corresponds to and can be verified, the ticket price is a price when the ticket is sold, and the discount type includes a full ticket, a half ticket or a free ticket, and is mainly for a general ticket buyer or the old, children, soldiers, handicapped people or some specific preferential treatment group; the ticket buying channel is a sale channel corresponding to the entrance ticket record and comprises a traveler, a network OTA platform, a ticket office and the like, and the ticket fetching information mainly records the identity information of the ticket buyer and is used for the consistency verification of later-stage people, certificates and tickets.
S2, dividing the entrance ticket records into a public ticket type for each online distribution node to purchase and a private ticket type for the offline ticket server to call according to a preset proportion;
in step S2, the ticket records for online sales and offline sales are mainly distinguished, and the public ticket type or the private ticket type is calibrated for each ticket record in the field of the call type of each ticket record. The preset proportion can be set according to the proportion of daily on-line tickets and off-line tickets, and when the balance is still left between the total ticket amount and the sum of the ticket records of the public ticket types purchased by each on-line distribution node and the private ticket types required by the off-line ticket server during actual calibration, the ticket records of the balance can be temporarily not classified, and the ticket records can be calibrated to be of undetermined types. In this embodiment, since the proportion can be adjusted in the subsequent steps as required, the following steps are only divided into a public ticket type and a private ticket type, and the remaining amount can also be marked as the private ticket type.
S3, acquiring entrance ticket records of private ticket types in the online ticketing server through the offline ticketing server, establishing an offline ticketing record table, receiving entrance ticket purchase requests of all offline ticketing nodes, reading ticket purchase information of the offline ticketing nodes, and selecting and editing an entrance ticket record of the private ticket types from the offline ticketing record table according to the ticket purchase information;
step S3 is mainly a process of purchasing tickets in scene areas, where the offline server downloads daily entrance ticket records of private ticket types from the online server, and creates an offline ticket record table for calling, where the offline ticket record table may be split into multiple record tables according to dates, or may obtain an offline ticket record for calling on a corresponding date in one record table by using the corresponding date as an access condition.
Then each offline ticket selling node comprises an artificial ticket selling department and an automatic ticket selling machine, and ticket purchasing operation can be started according to the needs of ticket purchasers, and the offline ticket purchasing operation is carried out by firstly recording ticket purchasing information comprising certificate information of the ticket purchasers, identity information of the ticket purchasers (old people, children, soldiers, disabled people) and the like according to the situations of the ticket purchasers, selecting discount types corresponding to the identity information, calculating ticket face prices and the like, uploading the ticket face prices and the like to an offline ticket server, selecting an empty private ticket record (not sold) by the offline ticket server, writing the uploaded information into corresponding fields in the private ticket record, and realizing editing of the selected private ticket record.
S4, the offline ticketing server issues an edited private ticket record to an offline ticketing node, and the offline ticketing node generates corresponding entity ticket face information according to the received edited private ticket record and issues the corresponding entity ticket;
the step S4 of issuing the corresponding entity ticket is to print the information of the entity ticket face onto the entity ticket face and deliver the entity ticket face to the ticket buyer.
S5, when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online ticket selling nodes, receive responses of the online ticket selling nodes, modify the entrance ticket records of the public ticket types obtained from the online ticket selling nodes into the private ticket types, the online ticket selling servers obtain the entrance ticket records modified into the private ticket types, and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
Step S5 is a step of supplementing offline tickets by allocating, when the tickets of private ticket types reserved in the scenic spot are sold empty, and there are still tourists waiting for buying tickets at the scenic spot ticket outlets, this situation generally occurs on the day of playing, and the tickets purchased by each online distribution node are often used for pre-selling, and if there are remaining tickets not sold at each online distribution node, it is difficult to continue selling on the online, and at this time, the remaining tickets on the online can be used to supplement offline physical tickets. Therefore, each offline ticket selling node estimates a required quantity according to the number of people queuing to purchase tickets, the offline ticket selling nodes gather through the offline ticket server to obtain the total required quantity, a private ticket supplementing request with a corresponding quantity is sent to the online ticket server, the online ticket server sends a surplus ticket recycling request to each online ticket distributing node, the online ticket server receives the response of the online ticket distributing node, the entrance ticket record of the public ticket type obtained from the online ticket distributing node is modified into the private ticket type, the offline ticket server obtains the entrance ticket record modified into the private ticket type, and the entrance ticket record is added to an offline ticket record table to be called by each offline ticket selling node, so that the offline ticket supplementing processing is realized.
Through the steps of the first embodiment, the online and offline tickets are managed comprehensively, excessive ticket issuing of the tickets is avoided, and through management and control of offline ticket number data processing, detailed ticket purchasing information is recorded in ticket records corresponding to each entity ticket, later information statistics and information processing are facilitated, and repeated ticket purchasing is facilitated.
Step 5 of the first embodiment discloses a data processing step of allocating the ticket allowance from online to offline, and actually, the on-line allocation node often has the situation that the number of tickets to be purchased is insufficient or redundant, so the second embodiment of the present invention further performs data processing on the part of ticket data combined with offline tickets, specifically, as shown in fig. 2, further includes the steps of:
s6, when the tickets of the public ticket types called by one or more online distribution nodes are insufficient in record, the online distribution nodes with insufficient ticket records send online ticket source supplement requests to an online ticketing server, the online ticketing server sends remaining ticket recovery requests to the online distribution nodes with remaining ticket records, receives responses of the online distribution nodes with remaining ticket records, and allocates the tickets of the public ticket types obtained by the online distribution nodes with remaining ticket records to the online distribution nodes with insufficient ticket records;
since the allocation of the online tickets and the offline tickets requires modification of the calling types and the purchasing channels of the ticket records, in order to simplify the processing amount of data modification and improve the efficiency of data processing, step S6 mainly allocates the ticket records of the public ticket types among all online distribution nodes, and at this time, since the ticket records of the public ticket types are all processed, the calling types of the ticket records do not need to be modified, and only the purchasing channels need to be modified.
S7, after the online ticketing server sends the surplus ticket recycling request, when the wireless upper distribution node responds or the public ticket type entrance tickets of one or more online distribution nodes are still insufficient after being allocated, the online distribution node further sends the ticket purchasing information to an online ticketing server, the online ticketing server forwards the ticket purchasing information to an offline ticketing server, the offline ticketing server selects and edits a ticket record of a private ticket type and a ticket fetching voucher from an offline ticketing record table according to the ticket purchasing information, the ticket fetching voucher is uploaded to the online ticketing server and forwarded to the online distribution node which makes a request, on the day of the ticket selling, the offline ticket selling node reads the ticket-taking certificate and searches and reads the corresponding private ticket record from the offline ticket service server, and generating corresponding entity ticket face information according to the private ticket record, and issuing the corresponding entity ticket.
Step S7 is used to process further data processing under the condition that the on-line ticket can not be allocated, at this time, the on-line distribution node with insufficient ticket will send the ticket purchasing information of the person to be purchased to the on-line ticket server according to the actual ticket purchasing requirement, the on-line ticket server will transmit to the off-line ticket server, the off-line ticket server will select and edit a ticket record and a ticket fetching voucher from the off-line ticket record list according to the ticket purchasing information, then the on-line distribution node will send the ticket fetching voucher to the ticket buyer, the ticket buyer can get the entity ticket from the ticket selling place of the scenic spot according to the ticket purchasing voucher and the identity certificate, this step will convert the scene of the ticket buyer that can not purchase the ticket into the off-line entity ticket by modifying the information of the type of the private ticket, the ticket buyer will get to the ticket selling point of the scenic spot without changing the distribution amount of the ticket record of the private ticket, the conversion from the online purchase demand to the offline physical ticket purchase can be realized without changing the calling type of the ticket record of the private ticket type, the sales channel of the online ticket purchase demand is still attributed to the online distribution node, and the later-stage data statistics and ticket resource distribution are cheap.
Since scenic spot tickets are generally sold in a pre-sale mode, and the pre-sale period dynamically changes every day, the offline ticket record table should also be dynamically updated according to the change of the date, in order to realize the update of the offline ticket record table, the third embodiment of the present invention further processes step S3 related to the data processing of the offline ticket record table based on the above-mentioned first and second embodiments, obtains the entrance ticket record of the private ticket type in the online ticket server through the offline ticket server in step S3, and establishes the offline ticket record table, as shown in fig. 3, further comprising the steps of:
s31, setting a pre-sale time period comprising a plurality of continuous natural days and the sale starting time and the sale stopping time of each natural day in the pre-sale time period in an online ticketing server;
the pre-selling time period is a fixed pre-selling time range, generally a week, ten days, fifteen days and the like, and is set artificially according to the actual situation of the scenic spot, the sale starting time and the sale stopping time of each natural day are the time points of starting and finishing the ticket selling each day, for example, the ticket selling is started at 7 am every day, the ticket selling is finished at 4 pm every day, and the time point of finishing the ticket selling should be considered the playing time of the tourists in the scenic spot and generally should be earlier than the closing time of the scenic spot.
S32, at the starting time of the pre-sale time period, the online off-line ticket server acquires the entrance ticket record of the private ticket type in the online ticket server;
wherein the starting time of the pre-sale period is the starting time of the first day in the pre-sale period.
S33, the offline ticket server establishes an offline ticket record table according to the acquired entrance ticket record of the private ticket type;
and when the starting time of the first day arrives, simultaneously acquiring the daily entrance ticket records of the private ticket types in the pre-sale time period, so as to establish the entrance ticket records of all the private ticket types in the pre-sale time period and establish an offline ticket record table.
S34, when the sale stopping time of the first natural day of the pre-sale time period is up, the off-line server uploads the sold entrance ticket records to the on-line ticketing server, and then the first-day entrance ticket records in the ticketing record table are deleted;
and S35, when the sale starting time of the next day of the continuous natural day is up, the offline ticket server acquires the entrance ticket record of the private ticket type of the next day from the online ticket server, and the entrance ticket record is merged into the original ticket record table to finish the updating of the ticket record table.
The steps S34 and S35 are mainly the updating operation of the offline ticket record table, that is, the ticket records corresponding to the dates are dynamically deleted and added according to the change of the dates, so that the offline ticket record table only records the ticket records of the private ticket types in a certain pre-sale time period, and therefore, the online ticket record table has small data volume, small data volume of reading and writing operations, and high data processing efficiency.
In a possible implementation manner, the step S3 of receiving an entrance ticket purchase request of each offline ticketing node, reading the ticket purchase information of the offline ticketing node, and selecting and editing an entrance ticket record of a private ticket type from the offline ticket record table according to the ticket purchase information, further includes the steps of:
s36, the offline ticketing node receives a ticket buying application of the user, records ticket buying information of the user and uploads the ticket buying information to an offline ticketing server;
s37, the offline ticket server selects a saleable ticket record from the ticket record table, and modifies one or more corresponding fields in the ticket record according to the ticket purchasing information of the user;
and S38, taking the modified entrance ticket record as a private ticket record corresponding to the ticketing information.
Steps S36-S38 show that off-line ticket purchasing is a processing method for private ticket records, wherein modifying one or more corresponding fields in the ticket record further includes adding required fields when no corresponding field exists, for example, the original private ticket record does not have a ticket-in-package record, at this time, the corresponding fields of the ticket-in-package can be added, and relevant number information is filled, and the modified ticket record is also regarded as modifying one or more corresponding fields in the ticket record.
The above third embodiment is the same as the first and second embodiments except that the detailed further data processing is performed in step S3, and the description thereof is not repeated here.
In step 5 of the above embodiments, when each online distribution node sends a remaining ticket recycling request in step S5, communication of invalid information should be avoided based on consideration of the remaining ticket stock condition of each online distribution node, so that a fourth embodiment is further proposed on the basis of the above three embodiments, and the fourth embodiment sends a remaining ticket recycling request to each online distribution node in step S5 without changing the remaining steps, as shown in fig. 4, further comprising the steps of:
s51, performing allowance sequencing on the admission ticket records of the public ticket types purchased by each online distribution node;
and S52, sending a surplus ticket recycling request to one or more online distribution nodes with the largest surplus.
Through margin ordering of the ticket records of the public ticket types bought by each online distribution node, the ticket information is empty ticket records which are not sold through inquiring the purchase channel field and the ticket fetching information field of the ticket records of the public ticket types, so that the online distribution nodes can effectively provide redundant ticket records of the public ticket types, and further, surplus ticket recovery requests can be reasonably and effectively put forward,
The fifth embodiment of the present invention further provides an intelligent offline ticket processing system in scenic spots, as shown in fig. 5, the system includes:
the on-line distribution node 1 is used for purchasing the scenic spot tickets for sale on line;
the offline ticket selling node 2 is manual or automatic ticket selling equipment positioned in a scenic spot and used for selling tickets in the scenic spot;
an online ticketing server 3; communicating with an online distribution node, establishing and storing a ticket database, issuing all daily scenic spot tickets through the ticket database, forming ticket records corresponding to the number of all scenic spot tickets in the ticket database, and dividing the ticket records into public ticket types and private ticket types according to a preset proportion;
offline ticketing server 4: communicating with an offline ticket selling node and an online ticket selling server, acquiring entrance ticket records of private ticket types in the online ticket selling server, establishing an offline ticket selling record table, receiving entrance ticket purchasing requests of all offline ticket selling nodes, reading and storing ticket purchasing information of the offline ticket selling nodes, selecting and editing an entrance ticket record of a private ticket type from a ticket database of the online ticket selling server through the offline ticket selling nodes, issuing the entrance ticket record to the offline ticket selling nodes, and generating corresponding entity ticket face information by the offline ticket selling nodes according to the received edited private ticket record and issuing corresponding entity tickets;
when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online distributing nodes, receive the responses of the online distributing nodes, modify the entrance ticket records of the public ticket types obtained from the online distributing nodes into the private ticket types, and the online ticket selling servers obtain the entrance ticket records modified into the private ticket types and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
The intelligent scenic spot offline ticket processing system of the fifth embodiment further implements the methods described in the second to fourth embodiments.
The sixth embodiment of the present invention also provides a storage medium storing a computer program comprising program instructions that, when executed by a processor, cause the processor to perform the method described in the first to fourth embodiments above.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. An intelligent scenic spot offline ticket business data processing method is characterized by comprising the following steps:
s1, establishing an online ticketing server and an offline ticketing server, establishing a ticketing database in the online ticketing server, issuing all daily scenic spot entrance tickets through the ticketing database, and forming entrance ticket records corresponding to the number of all scenic spot entrance tickets in the ticketing database;
s2, dividing the entrance ticket records into a public ticket type for each online distribution node to purchase and a private ticket type for the offline ticket server to call according to a preset proportion;
s3, acquiring entrance ticket records of private ticket types in the online ticketing server through the offline ticketing server, establishing an offline ticketing record table, receiving entrance ticket purchase requests of all offline ticketing nodes, reading ticket purchase information of the offline ticketing nodes, and selecting and editing an entrance ticket record of the private ticket types from the offline ticketing record table according to the ticket purchase information;
s4, the offline ticketing server issues an edited private ticket record to an offline ticketing node, and the offline ticketing node generates corresponding entity ticket face information according to the received edited private ticket record and issues the corresponding entity ticket;
s5, when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online ticket selling nodes, receive responses of the online ticket selling nodes, modify the entrance ticket records of the public ticket types obtained from the online ticket selling nodes into the private ticket types, the online ticket selling servers obtain the entrance ticket records modified into the private ticket types, and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
2. The intelligent scenic spot offline ticketing data processing method of claim 1, further comprising the steps of:
s6, when the tickets of the public ticket types called by one or more online distribution nodes are insufficient in record, the online distribution nodes with insufficient ticket records send online ticket source supplement requests to an online ticketing server, the online ticketing server sends remaining ticket recovery requests to the online distribution nodes with remaining ticket records, receives responses of the online distribution nodes with remaining ticket records, and allocates the tickets of the public ticket types obtained by the online distribution nodes with remaining ticket records to the online distribution nodes with insufficient ticket records;
s7, after the online ticketing server sends the surplus ticket recycling request, when the wireless upper distribution node responds or the public ticket type entrance tickets of one or more online distribution nodes are still insufficient after being allocated, the online distribution node further sends the ticket purchasing information to an online ticketing server, the online ticketing server forwards the ticket purchasing information to an offline ticketing server, the offline ticketing server selects and edits a ticket record of a private ticket type and a ticket fetching voucher from an offline ticketing record table according to the ticket purchasing information, the ticket fetching voucher is uploaded to the online ticketing server and forwarded to the online distribution node which makes a request, on the day of the ticket selling, the offline ticket selling node reads the ticket-taking certificate and searches and reads the corresponding private ticket record from the offline ticket service server, and generating corresponding entity ticket face information according to the private ticket record, and issuing the corresponding entity ticket.
3. The intelligent scenic spot offline ticketing data processing method of claim 2, wherein the field of the entrance ticket record in step S1 includes one or more of a call type, a date of use, a ticket price, a discount type, a purchase channel, and ticket information.
4. The intelligent scenic spot offline ticketing data processing method of claim 3, wherein the public ticket type and the private ticket type in step S2 are marked in the call type field of the entrance ticket record.
5. The intelligent scenic spot offline ticketing data processing method of claim 4, wherein the offline ticketing server in step S3 obtains entrance ticket records of private ticket types in the online ticketing server to establish an offline ticketing record list, further comprising the steps of:
s31, setting a pre-sale time period comprising a plurality of continuous natural days and the sale starting time and the sale stopping time of each natural day in the pre-sale time period in an online ticketing server;
s32, at the starting time of the pre-sale time period, the online off-line ticket server acquires the entrance ticket record of the private ticket type in the online ticket server;
s33, the offline ticket server establishes an offline ticket record table according to the acquired entrance ticket record of the private ticket type;
s34, when the sale stopping time of the first natural day of the pre-sale time period is up, the off-line server uploads the sold entrance ticket records to the on-line ticketing server, and then the first-day entrance ticket records in the ticketing record table are deleted;
and S35, when the sale starting time of the next day of the continuous natural day is up, the offline ticket server acquires the entrance ticket record of the private ticket type of the next day from the online ticket server, and the entrance ticket record is merged into the original ticket record table to finish the updating of the ticket record table.
6. The off-line ticket data processing method of claim 5, wherein the step S3 comprises receiving a ticket purchase request from each off-line ticketing node, reading the ticket purchasing information from the off-line ticketing node, and selecting and editing a ticket record of a private ticket type from the off-line ticketing record table according to the ticket purchasing information, further comprising the steps of:
s36, the offline ticketing node receives a ticket buying application of the user, records ticket buying information of the user and uploads the ticket buying information to an offline ticketing server;
s37, the offline ticket server selects a saleable ticket record from the ticket record table, and modifies one or more corresponding fields in the ticket record according to the ticket purchasing information of the user;
and S38, taking the modified entrance ticket record as a private ticket record corresponding to the ticketing information.
7. The intelligent scenic spot offline ticket data processing method as claimed in claim 6, wherein said issuing of the corresponding physical ticket in step S4 is to print the information of the face of the physical ticket onto the face of the physical ticket and deliver the information to the ticket buyer.
8. The intelligent scenic spot offline ticketing data processing method of claim 7, wherein the online ticketing server sends a remaining ticket collection request to each online distribution node in step S5, further comprising the steps of:
s51, performing allowance sequencing on the admission ticket records of the public ticket types purchased by each online distribution node;
and S52, sending a surplus ticket recycling request to one or more online distribution nodes with the largest surplus.
9. Intelligent scenic spot offline ticket processing system is characterized by comprising:
the online distribution node is used for purchasing the scenic spot tickets for sale from the online;
the off-line ticketing node is manual or automatic ticketing equipment positioned in a scenic spot and sells tickets in the scenic spot;
an online ticketing server; communicating with an online distribution node, establishing and storing a ticket database, issuing all daily scenic spot tickets through the ticket database, forming ticket records corresponding to the number of all scenic spot tickets in the ticket database, and dividing the ticket records into public ticket types and private ticket types according to a preset proportion;
offline ticket service server: communicating with an offline ticket selling node and an online ticket selling server, acquiring entrance ticket records of private ticket types in the online ticket selling server, establishing an offline ticket selling record table, receiving entrance ticket purchasing requests of all offline ticket selling nodes, reading and storing ticket purchasing information of the offline ticket selling nodes, selecting and editing an entrance ticket record of a private ticket type from a ticket database of the online ticket selling server through the offline ticket selling nodes, issuing the entrance ticket record to the offline ticket selling nodes, and generating corresponding entity ticket face information by the offline ticket selling nodes according to the received edited private ticket record and issuing corresponding entity tickets;
when the entrance ticket records of the private ticket types are insufficient, the offline ticket selling nodes send ticket source supplementing requests to the offline ticket selling servers, the offline ticket selling servers collect the offline ticket source supplementing requests of all the offline ticket selling nodes, obtain the entrance ticket record quantity of the private ticket types needing to be supplemented, send the private ticket supplementing requests of corresponding quantity to the online ticket selling servers, the online ticket selling servers send surplus ticket recycling requests to all the online distributing nodes, receive the responses of the online distributing nodes, modify the entrance ticket records of the public ticket types obtained from the online distributing nodes into the private ticket types, and the online ticket selling servers obtain the entrance ticket records modified into the private ticket types and add the entrance ticket records into an offline ticket recording list to be taken by all the offline ticket selling nodes; and when the types of the private tickets are still insufficient, the offline ticket business server sends out sold-out information to each offline ticket selling node.
10. A storage medium, in which a computer program is stored, the computer program comprising program instructions which, when executed by a processor, cause the processor to carry out the method as claimed in any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210235785.5A CN114490701B (en) | 2022-03-11 | 2022-03-11 | Intelligent scenic spot offline ticket data processing method, system and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210235785.5A CN114490701B (en) | 2022-03-11 | 2022-03-11 | Intelligent scenic spot offline ticket data processing method, system and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114490701A true CN114490701A (en) | 2022-05-13 |
| CN114490701B CN114490701B (en) | 2022-07-05 |
Family
ID=81487071
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210235785.5A Active CN114490701B (en) | 2022-03-11 | 2022-03-11 | Intelligent scenic spot offline ticket data processing method, system and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114490701B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120271668A1 (en) * | 2011-04-19 | 2012-10-25 | Yudin Jake S | Open Date Ticketing Method and System |
| CN103353951A (en) * | 2012-02-07 | 2013-10-16 | 周双桂 | Data processing and automatic ticketing of online booking |
| CN108074095A (en) * | 2016-11-18 | 2018-05-25 | 腾讯科技（深圳）有限公司 | A kind of ticket processing method and device |
| CN110119896A (en) * | 2019-05-13 | 2019-08-13 | 湖南易景通智能科技有限公司 | A kind of anti-down bill system in scenic spot |
| US20190251757A1 (en) * | 2016-05-18 | 2019-08-15 | Tixserve Limited | Electronic Ticketing System |
| US20190251482A1 (en) * | 2018-02-14 | 2019-08-15 | Aaron ZHANG | Ticketing System and Method Thereof |
| CN110533202A (en) * | 2019-08-30 | 2019-12-03 | 浙江深大智能科技有限公司 | System of real name timesharing reservation ticket booking method, apparatus, equipment and medium |
| CN110782053A (en) * | 2019-09-30 | 2020-02-11 | 浙江深大智能科技有限公司 | Time-sharing reservation scheduling method, device, equipment and medium |
| CN112804344A (en) * | 2021-01-29 | 2021-05-14 | 湖南惠旅云网络科技有限公司 | Scenic spot ticketing system |
| CN113903085A (en) * | 2021-12-10 | 2022-01-07 | 北京凯泰铭科技文化发展有限公司 | Trickle-based anti-ticket-swiping method and system for scenic spot ticketing system |
-
2022
- 2022-03-11 CN CN202210235785.5A patent/CN114490701B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120271668A1 (en) * | 2011-04-19 | 2012-10-25 | Yudin Jake S | Open Date Ticketing Method and System |
| CN103353951A (en) * | 2012-02-07 | 2013-10-16 | 周双桂 | Data processing and automatic ticketing of online booking |
| US20190251757A1 (en) * | 2016-05-18 | 2019-08-15 | Tixserve Limited | Electronic Ticketing System |
| CN108074095A (en) * | 2016-11-18 | 2018-05-25 | 腾讯科技（深圳）有限公司 | A kind of ticket processing method and device |
| US20190251482A1 (en) * | 2018-02-14 | 2019-08-15 | Aaron ZHANG | Ticketing System and Method Thereof |
| CN110119896A (en) * | 2019-05-13 | 2019-08-13 | 湖南易景通智能科技有限公司 | A kind of anti-down bill system in scenic spot |
| CN110533202A (en) * | 2019-08-30 | 2019-12-03 | 浙江深大智能科技有限公司 | System of real name timesharing reservation ticket booking method, apparatus, equipment and medium |
| CN110782053A (en) * | 2019-09-30 | 2020-02-11 | 浙江深大智能科技有限公司 | Time-sharing reservation scheduling method, device, equipment and medium |
| CN112804344A (en) * | 2021-01-29 | 2021-05-14 | 湖南惠旅云网络科技有限公司 | Scenic spot ticketing system |
| CN113903085A (en) * | 2021-12-10 | 2022-01-07 | 北京凯泰铭科技文化发展有限公司 | Trickle-based anti-ticket-swiping method and system for scenic spot ticketing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114490701B (en) | 2022-07-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6477503B1 (en) | Active reservation system | |
| US8301520B1 (en) | Tax return signature systems and methods | |
| US20040073484A1 (en) | Electronic display advertising method and apparatus | |
| US20040039679A1 (en) | Generation and acceptance of tailored offers | |
| Yoon et al. | Demand and capacity sharing decisions and protocols in a collaborative network of enterprises | |
| US20200117411A1 (en) | System and method of data processing for a printing operation | |
| US20100268556A1 (en) | System and Method for Booking a Performance Venue | |
| US20090292644A1 (en) | System and method maximizing video license utilization using billboard services | |
| JPH11296587A (en) | Electronic mall server, electronic mall client, electronic mall system and storing medium | |
| US20010051897A1 (en) | Method and system for qualifying consumers for trade publication subscriptions | |
| KR102390924B1 (en) | Apparatus and method for managing mileage related to proxy driving brokerage service | |
| CN108665317A (en) | Share in the benefit method and device based on barcode scanning payment | |
| CN114490701B (en) | Intelligent scenic spot offline ticket data processing method, system and storage medium | |
| KR20200111045A (en) | Hair(Beauty)Salon share system platfoam | |
| JP2011524041A (en) | Network printing | |
| CN114612192A (en) | Method, system and storage medium for assigning performance | |
| SE1650965A1 (en) | Method and system for purchasing a product | |
| JP2004118832A (en) | Method and system for processing information for allocation of business results of insurance or sale commission | |
| KR101535756B1 (en) | Marriage information system using a wedding Qsheet | |
| KR101031780B1 (en) | Method for providing a funeral service of a dividend type deferred payment | |
| KR102253603B1 (en) | Method of supporting food source supply for non-franchise | |
| KR20170058887A (en) | A Method For Multi-Offering An Estimate | |
| US20080215422A1 (en) | Coordinating a location based advertising campaign | |
| RU2743461C1 (en) | Method for exchanging data between advertising agencies and an ad space grid using software interfaces for automated ad placement in a network plus a method of optimal ad placement | |
| GB2379755A (en) | Online purchasing and inventory distribution of materials |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |