KR20010111860A - Lottery B2B e-Commerce System - Google Patents

Abstract

The present invention is applied to the inter-company e-commerce (B2B model) in the sale of the lottery through the Internet, the role of supplying and retrieving the lottery using the Internet to several stores and several stores that sell the lottery It is about how to efficiently send and receive information between the headquarters. In the process of porting the lottery sales program to various types of stores that have their own unique site, we have presented a way to facilitate the link between the customer DB and payment solutions that the stores already have, We present a way to centrally and collectively handle many kinds of work at the head office. As a result, labor and costs can be drastically reduced by eliminating the tasks of receiving, storing, sorting, and returning the physical lottery, which each retailer had to do.

Description

Lottery B2B e-Commerce System

The present invention relates to an inter-company electronic commerce system and a logistics management through a network of digital goods in the Internet lottery sales to centralize and manage a large part of manpower necessary for management through a central main computer.

The conventional method has been a method of contacting an intermediate lottery supplier and a store by telephone, fax, etc., paying the real lottery to all the stores, and then collecting them again. .

In addition, when a new internet lottery shop was opened at the site where the company was operating, it was difficult to link with the user of the existing site and the payment solution that it had.

The present invention is a lottery B2B SOLUTION to enable interworking with the existing DB and payment solutions, and to enable the sale of lotteries between companies without logistics movement is currently not developed and implemented.

As mentioned above, in view of the difficulties and inefficiencies of the prior art, the technical problem to be achieved by the present invention is to construct an lottery sales network that minimizes the movement of the real lottery and minimizes the work of the head office and the store by forming an efficient network. In this regard, the aim is to build an inter-company lottery e-commerce system that makes it easy to use existing user information and existing proprietary payment solutions to easily sell lotteries on many different types of existing sites.

1 is a schematic diagram showing a communication system connecting a main computer of a main store and a store computer.

2 is a flowchart for transmitting lottery data from a main computer to a store computer.

3 is a flow chart of transferring sales details from a retailer computer to a main computer.

Fig. 4 is a flowchart in which the sales computer ends the sale and requests the collection from the main computer.

Fig. 5 is a flow chart of transferring collected lottery ticket (unsold lottery) data from a store computer to a main computer.

6 is a flowchart in which a main computer transmits a winning lottery ticket to a retailer computer.

7 is a schematic diagram showing a communication protocol between a main computer and a store computer.

8 is a diagram showing a method of organizing a message in a communication system between a main computer and a store computer.

Fig. 9 is a schematic diagram showing the interworking with the existing user DB and the existing payment solution in the store computer.

Fig. 10 is a flowchart showing the interworking process with the user DB already held at the store computer.

Fig. 11 is a flowchart showing the interworking process with the pre-payment solution in the store computer.

* Description of the main symbols in the drawing

Main store's main computer in charge of overall control, such as supplying and collecting lottery tickets to 100 store computers

150 main computer DB of the main store that manages lottery shop data and lottery data

200 The store computer responsible for selling lottery tickets to Internet users

230 user's store DB

250 Store DB that manages lottery data and user assigned to the lottery

270 Dealer's Holding Payment Solutions

A computer network that connects the main computer to the retailer's computer.

The configuration of the network for achieving the above technical problem is largely composed of the main computer 100 and the main computer DB 150 of the main store, the store computer 200 and the store computer DB 250 of the store, as shown in FIG. Communication between the main computer 100 and the store computer 200 basically uses the Internet (including wired / wireless), and also has a pre-owned user DB 230 and a pre-payment solution to facilitate interworking with existing sites. 270.

Based on the network configuration, the process that is substantially progressed may include a first step (FIG. 2) of transmitting the lottery data from the main computer 100 to the store computer 200;

A second step of transmitting the sales contents from the store computer 200 to the main computer 100 after the data transfer (FIG. 3);

A third step of terminating the sale in the main computer 100 and requesting the store computer 200 to collect the lottery data (FIG. 4);

A fourth step (FIG. 5) of transmitting the collected lottery ticket (unsold lottery ticket) data to the main computer 100 in the store computer 200 after the above step;

A fifth step in which the main computer 100 transmits the winning lottery details to the store computer 200 (FIG. 6);

A sixth step (Figs. 9, 10, and 11) is performed in the store computer 200 to convert to a deposit using the holding user DB 230 and the holding payment solution 270.

1 is a schematic diagram showing a communication system 300 connecting a main computer 100 and a store computer 200. The main computer 100 stores the contents of the main computer DB 150 as a store computer of the store computer 200. The lottery data is transmitted to the DB 250 (FIG. 2), the transfer ends the sale and a collection request is made (FIG. 4), and the winning lottery ticket is transmitted (FIG. 6). The store computer 200 stores the DB of the store computer ( The contents of 250) are transferred to the main computer DB 150 of the main computer 100 (Fig. 3) and the collected lottery (unsold lottery) data (Fig. 5) to the respective databases listed above. It is a figure showing the content recorded.

7 shows a process of uploading and downloading data between the main computer 100 and the store computer 200.

Looking at the upload process, the store computer 200 transmits data to the main computer 100 through a Post method using the HTTP protocol. An example of the configuration of a message at the time of data transmission is shown in FIG. The download process is similar to the upload process, and the store computer 200 receives data from the main computer 100 through the Get method using the HTTP protocol. At this time, an example of the message regarding the condition of the data to be received is shown in FIG.

Fig. 8 is a diagram showing the structure of a message when data is uploaded and downloaded by the above-described method in the communication system described above. The message is composed of data of command (S810), table (S820), column (S830), value (S840), and where_clause (S850) .In accordance with the SQL statement to be transmitted, S860 and It is configured as described above and transmitted to the web server of the main computer 100, and select is S870, update is S880, and delete is S890.

The first step is to transfer the lottery data from the main computer 100 to the store computer 200 through the process of FIG. 2 according to the communication system of FIG. 1 and the communication protocol of FIG.

2 is a flowchart illustrating a process of transmitting lottery data from the main computer 100 to the store computer 200. In order to efficiently transmit lottery-related data to various stores, the type of data to be transmitted is determined in advance, and a time for transmission is set. In addition, in accordance with the type of lottery for each store in the main computer DB 150, the initial allocation amount / additional allocation amount for each group is determined in advance. Newly assigned lottery numbers, new lottery images, and lottery round / lottery data are usually sent on Friday evenings. Only then can the store close with the new lottery number received and sell the new lottery at the same time. In addition, it is possible to return unsold lottery tickets to the head office from among the lottery tickets closed while selling new lotteries. The additional allocation lottery is a minimum inventory by comparing the stocks of each lottery from the lottery sales data sent from each store at regular intervals (currently 5 minutes) with the minimum stocks of each lottery / group entered in the main computer DB 150 by each store. When the number is below, an additional number of lottery numbers will be allocated / transmitted. This allows you to quickly and accurately send new lottery data (numbers, images, episodes, lottery dates) to multiple retailers, and prevents stock shortages at each retailer. Referring to the flowchart of FIG. 2 in detail, the main computer 100 obtains store data from the main computer DB 150 (S210) and checks a store that has not been transmitted (S220), and if there is no store to transmit (S220). S225) The operation is terminated (S299), and if there is a store to be transmitted, after preparing new lottery data to be transmitted from the main computer DB 150 (S230), transmission is started to the store computer DB 250 through the store computer 200. (S240). After the transmission is completed, the transmission result is received (S250), and it is checked whether or not the transmission is successful (S260). If the transfer is successful, the transfer result is stored in the main computer DB 150 (S270), and moves to a series of work orders (S205) requesting data from another store, and when the transfer fails (S265), the transfer start sequence (S235). Go back to. Through this process, data of the lottery ticket (new lottery number / image / time / lottery date, additional assignment number) possessed by the main computer 100 may be transmitted to the store computer DB 250 of the store computer 200.

The second step is a step of transmitting sales details from the store computer 200 to the main computer 100 through the process of FIG. 3 according to the communication protocol of FIG. The reason why the store sends the sales status to the main store is to keep track of the sales volume and inventory of the store from time to time so that the store can provide the best service to the customer immediately and automatically when the stock runs out. By understanding the sales trend of the lottery, the inventories of the main store can be properly maintained, and the best inventory management is performed by ordering the appropriate amount of the lottery at the next order.

FIG. 3 is a flowchart illustrating a process of transmitting sales data from the store computer 200 to the main computer DB 150 of the main computer 100. The store computer 200 requests sales history data from the store computer DB 250 (S310). Check the contents (sales by lottery / group sales, stocks, etc.) of the sales history (S320), if there is no sales history to transmit (S325), terminate the program (S399), and if there is sales history to be transmitted, the main computer ( Start transmission to the main computer DB (150) (100) (S330). After the transmission is finished, if the transmission result is received from the main computer 100 (S340) and the transmission has failed (S345), it moves to the work order (S305) for requesting the sales computer DB 250 to send the sales details to be resent, and transmits. If this is successful, the transmission result is stored in the store computer DB 250 (S360). After this operation is completed, the program moves to a work sequence (S305) after which a predetermined time (currently 5 minutes) passes (S355) again to start the transmission of sales details.

The third step is a step of transmitting the end-of-sale command from the main computer 100 to the store computer 200 through the process of FIG. 4 according to the communication protocol of FIG.

The reason for sending the end of sales order to the store is that the closing order must be closed to start the sale of the new lottery, which was executed in step 1 above, and to start the sale of the new lottery. Because you can receive. In reality, the return of the unsold lottery ticket must be returned to the issuer by the Saturday of every Saturday morning, so the number must be available by midnight every Friday. Therefore, closing orders are appropriate on Friday evenings.

4 is a flowchart showing a process of transmitting the end of sale command from the main computer 100 to the store computer 200.

The manager of the main computer 100 inputs an end-of-sale command (S410). The program fetches the data of the retailer from the main computer DB 150 (S420), checks the retailer that has not transmitted the command (S430), and if all have been transmitted (S435), the program ends (S499). Check the stores that have not been transmitted and start the transmission to the undelivered retailer (S450). Receive the transmission result (S460). If the transmission fails, move to the operation sequence (S445) of the transmission start (S475). The transmission result is stored (S480) and the process moves to the transmission of another store (S415).

Receiving the end-of-sale order, the store closes the sale and starts the sale of the next lottery ticket received.

The fourth step is a step of transmitting the data of the collected lottery ticket (unsold lottery ticket) from the store computer 200 to the main computer 100 through the process of FIG. 5 according to the communication protocol of FIG.

The reason for sending the unsold lottery data to the main computer of the main office after the end of the sale is to execute the return of the lottery automatically, which can drastically reduce the manpower, time and cost of the store and the main office, and return it accurately and quickly. Because.

FIG. 5 is a flowchart illustrating a process of receiving data of an unsold lottery ticket from a store computer DB 250 at a store computer 200 (S510) and transmitting the data to the main computer 100.

Data to be retrieved is retrieved from the store computer DB 250 (S510). If there is no recovery history (S520), and if there is no recovery history (S525), the program ends (S599). If the recovery history is sent to the main computer 100 (S530). Receiving a transmission result from the main computer 100 (S540), when the transmission fails (S555) and moves to the step (S515) to start the transfer to the main computer 100. If the transmission is successful, the transmission result is stored in the store computer DB 250 (S560).

The fifth step is to transfer the winning lottery data from the main computer 100 to the store computer DB 250 of the store computer 200 through the process of FIG. 6 according to the communication system of FIG. 1 and the communication protocol of FIG. 7. .

The reason for transferring the winning lottery data from the main store to the retailer is not only the primary goal of reducing the dealer's hand, but also the processing of the winning lottery ticket (matching the winning lottery ticket, returning the winnings to the customer's deposit, etc.) at each store. This is because it maintains the uniformity of time, thereby maintaining the consistency of work and minimizing errors.

6 is a flowchart illustrating a process of transmitting winning lottery ticket data from the main computer 100 to the store computer 200. The main computer 100 takes the store data from the main computer DB 150 (S610) and checks the store that has not been transmitted (S620), and if there is no store to transmit (S625), terminates the operation (S699), and stores the store. If there is, prepare the winning lottery data to be transmitted in the main computer DB (150) (S630) and starts the transmission to the store computer DB (250) via the store computer (200) (S640). After the transmission is finished, the transmission result is received (S650) to check whether the transmission is successful (S660), when the transmission fails (S665), the transfer proceeds to the start sequence (S635), and if the transmission is successful, transfer to the main computer DB 150 The result is stored (S670), and the process proceeds to a series of work orders (S605) requesting data of another store. Through this process, the data of the winning lottery ticket of the main computer 100 may be transferred to the store computer DB 250 of the store computer 200.

In a sixth step, the store computer 200 converts the deposit to the deposit using the holding user DB 230 and the holding payment solution 270.

9 is a schematic diagram of the above steps.

FIG. 10 is a flowchart illustrating a process of storing a user DB in the lottery shop computer DB 250 after confirming the user by using the user DB 230 in the store computer 200 in the above step. . When the shop user uses the lottery shop computer 200, if the user selects a menu requiring confirmation of the user (SA10). If you are already logged in at the lottery store (SA15), provide the information of the page you want (SA99), and if you are not logged in at the lottery store, save the URL of the page you want to go to in memory (SA20), and Check whether it is logged in (SA30). If it is not logged in at the existing site, it moves to the user login page of the existing site (SA33) and transmits the ID and PW to the existing user confirmation page of the existing store. Here, after confirming the user (SA37) and retrieves the necessary member information (ID, name, email, social security number) from the existing user information (SA40). If the user is logged in at the existing site, the store's user holding program checks the user's information (ID, name, email, social security number) from the user's DB 230 and passes it to the lottery shop user checking program (SA40). (SA50). At this time, the passing method generates and transmits a token string to the corresponding CGI program of the store by using the GET method, which is one of the HTTP protocols. Token string generation is created by combining ID, name, email and social security number with Delimiter. This method uses the "/" character. If there is a "/" character in ID, name, e-mail, or social security number, it is converted into a string of "% 2F" using URL encoding method.

The lottery retailer user verification program checks whether the corresponding user information exists in the retailer computer DB 250, and if not, enters a new entry (SA60). If there is corresponding user information in the retailer computer DB 250, the page URL information, which has been stored in the memory before login, is obtained from the memory and provided (SA80).

In this way, customers of the existing site can enter the newly installed lottery sales screen and freely perform the desired action as in the existing site without logging in or registering again.

FIG. 11 is a flowchart showing a process in which the store computer 200 converts to a deposit using the pre-payment solution 270 in the above step. The web client selects a prepaid card to purchase (SB20). Here, the prepaid card is a deposit in order to purchase a lottery ticket and is the same as one product at an existing store. The lottery shop computer 200 stores user information and prepaid card purchase history in a memory (SB30), transmits a purchase history to a store's existing payment page (SB40) and simultaneously shows a payment confirmation screen of a previously held payment solution. If the customer confirms the payment (SB50), enter the card number and expiration date (SB60), and confirm the approval in succession (SB70). If the approval is confirmed, using the pre-existing payment server, and related information such as member and product information is entered into the existing store DB and stored in the lottery store DB 250 (SB100). In addition, the screen shows the memory storage history (User information, card purchase history) of the previous step (SB30) (SB80), and shows that the customer has been converted to the deposit (SB90). By doing so, customers of the existing site can conveniently pay as in the existing site using the payment solution 270 in the lottery sale screen.

The field to which the present invention can be applied may be applied to sales of digital goods (EX; various reservation tickets, theater tickets, sports tickets, various gift certificates, cyber money, etc.) that can be distributed without physical logistics movement on the Internet. However, the identity verification process of the purchaser is required, which is required when the store transmits the store's data to the main store together with the purchaser's name, social security number, and purchased product number. If the head office holds the data or transfers it to the place where it is needed (the ticket supplier) via the Internet or a private ship, and calls the product number when the purchaser enters, the product number can be searched and the name and social security number can be identified. Use the tool (resident registration card, driver's license, passport, medical insurance card, student ID card, civil service card, citizen registration card, etc.) and pass it again or reissue it as a usable ticket.

The present invention is not limited to the above embodiments, and many variations are possible by those skilled in the art within the spirit of the present invention.

Therefore, in relation to the present invention and its preferred embodiment, as we believe for the first time, the time and cost of the existing physical lottery payment and recovery through the data transmission through the communication network between the main computer and the store computer, It is possible to drastically reduce the waste of manpower, time and money required to manage the lottery at an internet lottery.

In addition, by allowing the retailer to easily use the existing user DB and the payment solution they have, it is easy to sell the lottery on many sites by eliminating the difficulties of the existing construction.

Ultimately, the introduction of such a system will lead to the activation of lottery sales through the Internet, thereby facilitating the accumulation of funds to achieve the national public purpose, and by reducing the overall distribution cost by facilitating the purchase of lotteries by more Internet users. Has a positive effect.

Claims (9)

Lottery B2B The main office (consisting of the main computer and the main computer DB), which is responsible for supplying and retrieving lottery tickets, as well as the main computer DB, in the configuration for realizing B2B e-commerce, and the store (direct lottery computer) And lottery shop DB) In the process of exchanging information with each other through wired / wireless internet or leased line, A first step of transmitting various lottery data from a main computer to a store computer; A second step of transmitting the sale contents from the store computer to the main computer after the data transmission; Terminating the sale at the main computer and requesting the store computer to collect the lottery data; A fourth step of transmitting the collected lottery ticket (unsold lottery ticket) data to the main computer after the step; The inter-company electronic commerce system of the lottery, which has a fifth step of transmitting the winning lottery details from the main computer to the store computer. In the first step of claim 1, Sending various data (new lottery number / image / time / lottery day, additional assignment number) from the main computer of the store to the store computer automatically according to a fixed time or interval and confirming the transfer, and then sending various data to the store. How to UP-DATE In the second step of claim 1, Data transmission / reception method for optimal proper inventory management between the main store and the store, which automatically transfers the store data (lottery / group sales, inventory, etc.) from the store computer to the main computer at predetermined time intervals and then confirms the transfer. In the third step of claim 1, End of sale order for the entire store of the head office, which maintains consistency and accuracy by transmitting and confirming the end of sale order to the store computer at the main computer at the designated time and conducting the closing of sales of multiple stores and the sale of new lottery tickets simultaneously. Sending and receiving method In the fourth step of claim 1, How to collect all unsold lottery numbers of the main store that automatically sends and confirms unsold lottery numbers from the store computer to the main computer of the main store, and automatically collects unsold lottery tickets generated at multiple stores In the fifth step of claim 1, The main computer transmits the data of the winning lottery ticket to the retailer computer at the specified time and confirms the transmission, so that multiple stores can simultaneously update the winning lottery data and execute the winning lottery ticket and deposit the deposit for the winners at the same time. How to handle winning lottery tickets In order to activate B2B e-commerce, it is necessary to easily connect to other types of sites that operate existing websites.In order to easily link existing DBs of existing websites, customers of existing sites sell lotteries for the first time. How to use the customer's DB that is saved in the existing DB at the login screen and stored in the lottery retailer DB to facilitate future use In order to activate the lottery B2B e-commerce, it is necessary to easily connect to other types of sites that operate existing websites. In order to easily link the existing payment solutions of the existing websites, customers of existing sites purchase prepaid cards. If you choose to use a prepaid payment solution that treats the same effect as purchasing one item from an existing site and converts it into a deposit that can only be used on the lottery store screen. According to claim 1, 7, or 8, Except for the lottery illustrated in the text, The data (table number, date, seat number, etc.) is temporarily stored at various stores at the head office of digital goods (theater tickets, various reservation tickets, sports tickets, various gift certificates, cyber money, etc.) that are distributed without physical logistics movement on the Internet. B2B e-commerce system for all digital goods that are sold / finished / recovered and sent to the store from the store (sold number, buyer's name, resident registration number, etc.) and completed sales through the identity verification process at the counter.