KR102171291B1 - Spread sheet service for group chat room - Google Patents

Abstract

According to the present invention, a table calculating service method in a messenger group chat room comprises the steps of: allowing a service server to purchase a label for obtaining a service beneficiary qualification; downloading and installing a table calculating application provided by the service server in a terminal; preparing a form for table calculation by executing the table calculating application; setting a keyword used for an item of the form; searching for a number in conversation content of a messenger group chat room; extracting the searched numeric data and sequentially storing the same in a column or row cell of the corresponding item; and compiling statistics with the numeric data stored for a predetermined period in a table calculating form. According to the present invention, conversation content can be easily and conveniently organized.

Description

Spread sheet service for group chat room {Spread sheet service for group chat room}

The present invention relates to a table calculation service method in a messenger group chat room, and more particularly, to a service method for performing table calculation by searching for a number in a chat content of a group chat room and storing it in a designated cell of a table calculation application. .

With the development of the Internet and smartphones, mobile instant messengers (MIMs) are becoming a communication channel for everyday life. MIM is a PC-based real-time interactive conversation application applied to a mobile terminal. It can effectively convey user's emotions through voice, video, photo and video sharing functions and emoticon stickers as well as chat. It is used in various ways.

Among the MIM services, the most notable is a group chat room service. If the existing messenger was mainly for one-on-one chat, MIM enabled multi-party chat in real time. Through a group chat room, you can perform group work and share your interests or content with your friends. In addition, even if the conversation is interrupted, the chat room and the content of the conversation remain, so it can be used as a psychological sense of belonging and a record.

However, even if it remains as a record, there is a limit to the retention period of the server and there is no limit to the format of the conversation, making it difficult to organize and search for conversations going to Junggu Heating.

In particular, in order to generate statistics such as sales or performance in a group chat room opened for business purposes, manpower is required and time and effort are required because the person in charge must keep watching and organizing the conversation.

Korean Patent Registration No. 10-0739058

In accordance with the above necessity, the present invention is to provide a service capable of creating statistics by retrieving numbers from conversation contents of a messenger group chat room and storing them in a designated cell of a table calculation application.

The table calculation service method in a messenger group chat room according to the present invention for the above problem to be solved comprises the steps of: purchasing a ticket in order to obtain a service beneficiary qualification in a service server; Downloading and installing a table calculation application provided from the service server to a terminal; Preparing a form for table calculation by executing the table calculation application; Setting a keyword used for the item of the form; Searching for a number in the conversation content of the messenger group chat room; And extracting the retrieved numeric data and sequentially storing them in a column or row cell of a corresponding item, and generating statistics using numeric data stored for a predetermined period in a table calculation form.

The keyword is characterized in that it is an accounting term such as item, quantity, unit, purchase, sales, inventory, order, amount, or total.

The predetermined period is characterized in that the group chat room is daily, weekly, monthly, quarterly or annually.

The statistics are characterized in that the statistics are generated by classifying each conversation participant.

The number search is characterized by extracting only when the adjacent word text is a set keyword.

The number search is characterized in that only numbers between set keywords are extracted.

The number search is characterized by extracting from a selected block among conversation contents.

The table calculation application is characterized in that it is executed in the background during a conversation.

The table calculation application is embedded in a messenger application and is executed at the same time when the messenger application is executed.

The ticket may include a personal ticket capable of mounting an advertisement on an emoticon held by the user terminal; It characterized in that it comprises an advertisement ticket for displaying an advertisement on the display window and a personal linkable ticket used based on the personal ticket.

In the messenger group chat room, the ticket holder uses the fusion emoticon loaded with the advertisement in the messenger conversation service to share the advertisement to the sharer's terminal to transfer the right to share the advertisement or receive a reward for viewing the advertisement in a display window.

The present invention provides a service that retrieves numbers from the conversation contents of a messenger group chat room and stores them in a designated cell of a table calculation application, so that not only records but also statistics such as sales, performance, and orders can be created, for business purposes such as accounting and accounting purposes. It can be used variously and conveniently.

Due to the nature of the messenger, the short preservation period can be compensated and recorded as a record, and there is no restriction on the format of the conversation, making it easy and convenient to organize conversations going to and from Junggu heating.

The present invention provides various conversation services such as financial transaction service, group networking service, game service, open market service, authentication service, and ticket calculation service as well as advertisement sharing compensation service to users who purchase tickets to conveniently meet the user's various needs. Can be satisfied.

1 is a symbolic representation of the label of the present invention.
2 is a block diagram showing a system for providing a service for ticket buyers according to the present invention.
3 is an embodiment of a user terminal according to the present invention.
4A to 4C illustrate examples of setting an advertisement mounted display in consideration of the pixel size of a general emoticon according to the present invention.
5 shows an example of inserting a general emoticon and an advertisement mounted display in a display area according to the present invention.
6A is an example of displaying a fusion emoticon according to the present invention on a screen.
6B is an example of displaying a general emoticon according to the present invention on a screen.
7 is a block diagram showing in detail a service server according to the present invention.
8 is a block diagram showing in detail a service unit according to the present invention.
9 is an example showing a screen of a display window according to the present invention.
10 is another embodiment showing a screen of a display window according to the present invention.
11 is a flowchart illustrating a method of providing a service for a ticket buyer according to an embodiment of the present invention.
12 is a flowchart illustrating an advertisement compensation service provided by a service server according to the present invention.
13 is a flowchart of providing a table calculation service in a chat room according to the present invention.
14 is an example of contents of a group chat room conversation according to the present invention.
15 is an example of table calculation for a group chat room according to the present invention.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings and contents described in the accompanying drawings, but the present invention is not limited or limited by the embodiments.

1 is a symbolic representation of the label of the present invention. The label is a kind of license symbol indicating qualifications or rights to mount advertisements in an emoticon or file, such as a mark, certificate, virtual currency, chip, etc. It can be implemented in various forms.

Tickets can be issued in various ways according to the purpose of the desired service, based on personal tickets that can place advertisements on emoticons held by user terminals, advertisement tickets that advertisers or advertising agencies can place advertisements on the display window, and personal tickets. There is a personal connection type ticket used and an additional service ticket that can use additional functions.

Personal label refers to the qualification or right to mount advertisements by fusing advertisements with general emoticons or files owned by an individual, and advertisement label refers to the qualification or right to place advertisements, and the personal label refers to a personal ticket and It refers to the qualification or right to participate in the game or to post personal videos by linking.

For example, in the present invention, such as a service membership, only a person who has a ticket has the qualification to post or share advertisements and receive compensation and various service benefits accordingly.

Since an individual's regular emoticon is automatically loaded through the personal ticket, the user can use the individual's general emoticon without any inconvenience as usual, and the personal ticket has a reflective configuration.

Advertising tickets can be divided into a shared type with the ability to share advertisements and a fixed type with the function of mounting fixed advertisements displayed in an open market, and advertisements according to the period in which advertisements can be posted. It can be divided into a rechargeable type with a function that can be charged when the reward for sharing is exhausted within a set range, and a destructive type in which advertisements are extinguished when the set target number of sharing is reached.

An open marketplace is a type of Internet open market, and is a department store-style shopping mall where anyone, such as individuals and businesses, can freely trade, and is referred to as'Takji Web' in the present invention.

2 is a block diagram showing a system for providing a service for ticket buyers according to an embodiment of the present invention. The service providing system 10 provides a user terminal 100, a sharer terminal 200, a service server 300, and an advertisement. And a terminal 400 and the like.

The user terminal 100, the sharer terminal 200, or the advertiser terminal (hereinafter abbreviated as'terminal') may be a smartphone, a desktop, a laptop, or a tablet PC, and a user interface for selecting and displaying an emoticon in a messenger service is provided. Can provide.

The service server 300 may provide a chat or messenger service for a conversation between a user and a sharer to the user terminal 100 and the sharer terminal 200.

The user terminal 100 and the sharer terminal 200 may download and install an app for a messenger or conversation service from a service server 300 connected through a wired or wireless communication network or an app providing server (not shown).

The messenger or conversation service may include text messages, katok, YouTube, Facebook, Instagram, or various SNS services, and may be a mobile instant messenger (MIM).

The service server 300 is equipped with an advertisement upload service so that an advertiser or an advertising agency can upload an advertisement to the display window, and an advertisement display service is constructed to allow a user or a sharer to view or select the displayed advertisement. The advertiser or advertisement agency may upload an advertisement through the advertisement providing terminal 400.

3 illustrates an embodiment of a user terminal including an input unit 110, a display unit 120, a connection unit 130, and a service providing unit 140.

The input unit 110 may provide a keyboard, button, touch or click input method, and may provide various input means. The display unit 120 may display input items input through the input unit 110 and display a result of processing the input items. The connection unit 130 provides access to the service server 300 by establishing an Internet communication network.

The service provider 140 is driven through a ticket management program provided by the service server 300. The ticket management program may be provided as an additional function of a chat service or a messenger service, and may be provided as an independent app (application).

The service providing unit may include a ticket purchase unit, an advertisement selection unit, a conversation service providing unit, and an emoticon fusion unit. The ticket purchase department connects to the service server and purchases a personal ticket that provides the qualification to install advertisements by fusing advertisements with a general emoticon held by an individual, and an advertisement ticket that provides the qualification to place advertisements, and can participate in the game. You can purchase additional personal tickets.

The sharer terminal 200 may be installed with a ticket management program or a conversation service program provided by the service server 300. The ticket management program may include a conversation service program.

The sharer terminal 200 generates a notification notifying that the fusion emoticon input from the user terminal 100 has been transmitted through a conversation service. The sharer may recognize the notification and view the fusion emoticon through the screen of the sharer terminal 200, and may not check the fusion emoticon due to not recognizing the notification, or may check it after a predetermined period of time.

The sharer terminal 200 may transfer the right to share the fusion emoticon to another sharer by mounting the transferred advertisement on a general emoticon owned by it.

The service server 300 displays a plurality of advertisements that can be fused to a general emoticon held by an individual in a display window, and the advertisement selection unit 142 selects an advertisement from the display window. Users can purchase tickets and install advertisements by fusing advertisements with ordinary emoticons owned by individuals, obtain qualifications to share advertisements, select advertisements to be shared, and personalize through the user terminal 100 installed with the ticket management program. You can create a fusion emoticon in which advertisements are fused to the general emoticons you have, and you can share the fusion emoticons. The ticket management program may include a fusion emoticon program for generating a fused emoticon by fusing advertisements with a general emoticon held by an individual.

The terminal provides at least one chat service and provides an interface for displaying contents input by a user through an input unit. The content input by the user may be a general emoticon or a fusion emoticon, and may be in various formats such as text, numbers, voices, images, videos, or document files.

The terminal may set whether to apply or selectively apply fusion emoticons to all conversation services, and may set whether to convert all general emoticons owned by an individual into fusion emoticons or selectively convert only some of them. For example, it is possible to set that the fusion emoticon is used in the messenger service of a specific company by receiving the user's input, and the fusion emoticon is not used in the SNS service.

The service server 300 provides a reward to the shared user when the sharer clicks the fusion emoticon. In addition, the service server 300 automatically transfers the right to share the advertisement mounted on the fusion emoticon to the sharer if the sharer is a personal ticket holder, and returns only the advertisement to the display window without compensation if the sharer does not have a personal ticket so that it is selected and shared by other ticket buyers. .

In the generation of the fusion emoticon in the user or the sharer's terminal, a position indicating that an advertisement is mounted may be set in consideration of the pixel size of a general emoticon.

4A to 4C illustrate an example of setting an advertisement loading display such as a target share number, a reward amount, or an advertisement period in consideration of the pixel size of a general emoticon. The pixels of the general emoticon are displayed in the display area 510 of the set pixel size. A first display area 511 considering a size and a second display area 512 for displaying advertisements are set, and a general emoticon and an advertisement display are mounted on the display area 510 to generate a fused emoticon.

The fusion emoticon is an emoticon that indicates that an advertisement is mounted on a general emoticon held by the user terminal as a target number or compensation amount, and is converted so that the sharer can view the advertisement when clicked on the sharer terminal 200. The advertisement mounted display does not damage the general emoticon, but rather displays the target number of sharing, the amount of compensation for viewing advertisements, or the duration of the advertisement in a blank space or blank space of the emoticon to arouse curiosity to the sharer. Convergence emoticons provide a function to load, distribute, and share advertisements in conversation services.

The emoticon fusion unit may prepare an advertisement loading display including at least one of a share of the fusion emoticon and a compensation amount according to the transfer, a target share number, and an advertisement period. The reason for displaying the advertisement display is to help the sharer decide whether to choose to transfer the fusion emoticon. Sharers can decide whether to transfer advertisements by looking at the reward amount or the number of shares, just like playing a game. Another reason for displaying an advertisement-loaded mark can cause interest and ticket purchase to a sharer who does not have a ticket.

The fusion emoticon displays the color of the advertisement-mounted display so as not to be translucent or prominent, so as not to damage the meaning of the general emoticon. The maximum display area 500 of the fused emoticon may include a display area 510 and an empty blank area 520 occupied by a general emoticon or an advertisement mounted display. The maximum display area 500 refers to an area in which an image or emoticon can be displayed on the screen in maximum, and the blank area 520 is an empty area and is an area not displayed on an actual screen.

The second display area 512 of the fusion emoticon may include a 2-1 display area 512a and a 2-2 display area 512b. The 2-1th display area 512a may indicate the number of times of advertisement sharing. The 2-2th display area 512b may represent a compensation amount or a one-time compensation amount according to the number of shares or transfers.

FIG. 5 shows an example of inserting a general emoticon and an advertisement display in the display area. While expressing his or her feelings during a conversation, the advertisement display can be induced to click by arousing curiosity to the sharer of the advertisement display roll.

6A is an example of displaying the fusion emoticon on the screen, and shows an example of using the fusion emoticon during a chat. The sharer can select by clicking the fusion emoticon through the sharer terminal 200, and in the sharer terminal 200, when the sharer clicks the fusion emoticon, an advertisement is immediately exposed or linked to a related site.

The service server 300 provides a reward to the shared user when the sharer clicks the fusion emoticon. In addition, the service server 300 automatically transfers the right to share the advertisement mounted on the fusion emoticon to the sharer if the sharer is a personal ticket holder, and returns only the advertisement to the display window without compensation if the sharer does not have a personal ticket so that other ticket holders can select it.

The target number of sharing may be counted when the user terminal 100 uses the fusion emoticon, or when the sharer terminal 200 clicks the fusion emoticon. The amount of compensation is the amount incurred by sharing and transferring. For example, as shown in FIG. 6A, when a sharer clicks on the fusion emoticon for the first time in the user terminal 100, it is recognized as the first share and the number of shares is one, and the amount of compensation is 800 displayed according to the number of shares. It becomes a circle. When the sharer terminal 200 clicks the fusion emoticon, the advertisement mounted on the fusion emoticon is transferred, and the user receives a reward for sharing. Since the service server 300 transfers the advertisement mounted with the fusion emoticon to the sharer, the compensation amount may be increased by generating compensation according to the advertisement transfer. The sharer terminal 200 can share the fused emoticon with others by mounting the previously received advertisement on a general emoticon owned by it, and when shared, the number of sharing is accumulated and counted. If there are many participants in the conversation service, the probability of sharing or the efficiency of advertising promotion can be improved.

6B is an example of displaying a general emoticon on the screen. If the sharer's personal ticket is not registered, the sharer terminal 200 may provide a setting for determining whether to display an advertisement mounted display on the screen. For example, if the sharer's terminal 200 does not have a personal label of the sharer, it may be set to expose a fusion emoticon with an advertisement mounted on the screen as shown in FIG. 6A, and display the advertisement mounted on the screen as shown in FIG. 6B. It can be set not to be exposed.

The present invention can provide advertisement sharing between users with personal tickets and sharers, can provide existing conversation services to sharers who do not have personal tickets, and induce purchase of personal tickets to sharers who do not have a personal ticket. In addition, it is possible to provide active and autonomous advertisement sharing and distribution services by users or sharers.

7 is a block diagram illustrating the service server 300 in detail, and the service server 300 includes a communication unit 310, a ticket sales unit 320, a management unit 330, and a service unit 340. The communication unit 310 provides communication with the user terminal 100, the sharer terminal 200, or the advertisement providing terminal 400.

The ticket sales unit 320 sells tickets for each type, such as personal tickets, advertisement tickets, personal interlocking tickets, and additional service tickets. The ticket sales unit 320 sells one semi-permanent personal ticket per person, but may sell a personal ticket with a limited quantity. The reason for limiting the quantity of personal tickets is to protect personal tickets that can be used for identification purposes, maintain and increase the value of tickets, and become popular.

Personal tickets represent membership status as symbols online, and can be implemented as identification cards, virtual currency, and real-type chips, and can provide the function of virtual currency, ID card, or bankbook to be used in various countries. Personal tickets can be linked with a pay system or a payment system, and can be used by applying a reward accumulated in connection with a pay account of the pay system to the pay system. Reward can be used as a currency that can be commonly paid around the world in virtual currency.

The pay system can be used for payment online, and it requires registration of an account, card or personal ticket of the present invention for payment. The accumulated rewards of personal tickets can be called'ticket money' as virtual currency, and can be converted into points of the pay system. Ticket sales unit 320 may sell personal tickets only to users or sharers who have opened a Pay account.

'Ticket Money', which is the accumulated reward of personal tickets, can be used like cash and can be used internationally as it can be used as a virtual currency combined with blockchain technology in partnership with the Pay system and global companies. Personal tickets can be purchased through the pay system.

When a personal ticket is purchased through the user terminal 100, the management unit 330 manages the ticket information including the user information and the ticket identification number. User information may include name, gender, date of birth, social security number, phone number, address, or e-mail. The ticket unique number may be an issue number indicating a number that issued a personal ticket, or an additional number indicating a virtually added number. For example, the unique ticket number can be used as a function of the account number of a passbook, can be used as a function to find out which user's personal ticket is, and can be used to authenticate the user's identity. The management unit 330 may manage not only user information, but also sharer information or advertiser information.

The ticket sales unit 320 may divide and sell the advertisement ticket by at least one of each subject and display type of the advertisement. The subject of advertising can be classified into individuals, businesses, non-profit organizations, and government agencies. The display format of the advertisement may be text, image, video, hyperlink, game, YouTube, or a combination. The production of advertisements can be produced by the subject directly or customized through an advertisement agency.

The advertisement ticket may be provided in at least one of a shared type, a rechargeable type, a extinguishing type, and a fixed type. In more detail, the advertisement ticket is a function to share advertisements, a function to charge when the reward for sharing advertisements is exhausted within a set range, a function to extinguish an advertisement when the set target number of sharing is reached, or an open marketplace. It is possible to provide a function of loading a fixed advertisement displayed on the screen.

The YouTube-type advertisement label is a label that provides the user with the qualification to install his or her advertisement in the form of YouTube. In addition, the YouTube-type advertisement label can be equipped with a YouTube-type advertisement, and a user-made or custom-made advertisement can be mounted. For example, a user may access the service server 300 through the user terminal 100, purchase a YouTube-type advertisement ticket, and mount his or her advertisement on a YouTube-type advertisement ticket.

Personal video items displayed through YouTube-type advertisement tickets can be rewarded when they reach a predetermined target number of views, and can generate revenue, and personal ticket holders can pay a predetermined reward (ticket money) and view video content immediately. . YouTube has to see advertisements displayed on YouTube in order to view videos, but the present invention is an advertisement that he wants to see among those posted on the display window if he does not see the advertisement and sees the video content with the reward (ticket money) accumulated immediately, or if there is no accumulated ticket money. You can view video content by accumulating ticket money by viewing. In other words, it has the advantage of not being able to see advertisements that he does not want to see and being able to see video contents immediately.

The fixed advertisement ticket can display advertisements for a single product displayed in an open marketplace, and can provide qualifications to display advertisements for the entire shopping mall product or homepage.

Fixed advertising tickets are used for product sales as individuals gather things that are difficult to share with each other in a chat window, and are used for product purchases by calling advertisements because they cannot provide shared compensation.

In order for an individual to use a single product such as a video or document form displayed as a fixed advertisement ticket, the individual can use it after paying a reverse compensation to the provider of the single product, that is, once a day.

A corporate advertisement label may be a label about a company's product or image, may be a label used by recharging when the shared reward is exhausted within a set range, and may be a label in which a fee occurs during the charging process. Link-type, video-type, election campaign type, and government agency advertisement tickets may be volatile labels, and may be extinguished when a set target number of sharing is reached.

The service unit 340 provides a plurality of services to the user terminal with reference to ticket information. The plurality of services may include a conversation service by a messenger, advertisement sharing compensation, financial transaction provision, group networking, open market, authentication and ticket calculation services.

8 is a block diagram showing in detail the service unit 340 of the service server, wherein the service unit 340 includes a conversation service unit 341, an advertisement service unit 342, a financial transaction service unit 343, and group networking. A service unit 344, an authentication service unit 345, and a game service unit 346 may be included.

The conversation service unit 341 may provide a conversation service program for conversation between a user and a sharer to the user terminal 100. The chat service unit 341 may develop and hold a chat service program by itself, and may provide it to the user terminal 100 by interlocking with the chat service server.

The advertisement service unit 342 may provide an advertisement fusion emoticon service for fusing advertisements with a general emoticon held by an individual and an advertisement sharing compensation service for sharing a fusion emoticon equipped with advertisements.

The financial transaction service unit 343 provides a compensation service that processes compensation according to advertisement sharing by interlocking with the pay system. The financial transaction service unit 343 can process various financial transactions such as ticket purchase, payment, cash withdrawal, and virtual currency remittance by interlocking with the pay system.

The advertisement service unit 342 may include an advertisement convergence service unit 342-1, an advertisement display service unit 342-2, and an advertisement sharing service unit 332-3.

The advertisement fusion service unit 342-1 provides the user terminal 100 with a fusion emoticon program for generating fusion emoticons by fusing advertisements with general emoticons held by an individual. The user terminal 100 may generate a fusion emoticon by installing a fusion emoticon program.

The advertisement display service unit 342-2 displays a plurality of advertisements that can be fused to a general emoticon held by an individual in a display window, and provides an advertisement selection to the user terminal 100.

The advertisement display service unit 342-2 displays advertisements that are not infected with viruses by performing a virus test on advertisements, videos, games, documents, etc. displayed in the display window.

The advertisement display service unit 342-2 may provide an advertisement uploading function and a payment function according to advertisement uploading to the advertisement providing terminal 400. The advertisement providing terminal 400 may access the web of the service server 300 to upload an advertisement to the display window, and pay for the advertisement display through the control of the financial transaction service unit 343.

The advertiser or advertising agency may set the target sharing number, total compensation amount, and posting expiration date of the advertisement through the advertisement providing terminal 400. The service server 300 autonomously determines the amount of compensation in the advertisement providing terminal 400 in order to maximize the advertisement effect.

When the advertisement display service unit 342-2 receives the display basic information from the advertisement providing terminal 400, the advertisement display service may calculate a cost for the advertisement display by referring to the display basic information. The display basic information may include information on at least one of an advertisement sharing and compensation amount according to transfer, a target sharing number, and a posting expiration date.

Reward is the price of viewing the advertisement by viewing the advertisement displayed in the window, the price of sharing the advertisement to the conversation service, the price of viewing the advertisement by viewing the advertisement shared in the conversation service, the price of receiving the advertisement, and the transfer of the advertisement to another conversation. It may include information according to at least one of the considerations shared for the service.

The advertisement display service unit 342-2 requests payment request information to pay the calculated advertisement display fee to the advertisement providing terminal 400, and displays the advertisement in the display window when the payment of the advertisement display fee is completed. The advertisement providing terminal 400 may pay an advertisement display fee in the concept of prepaid or charging. The financial transaction service unit 343 may receive an advertisement display fee by interlocking with the pay system.

The service server 300 provides part of the advertisement display fee to the user terminal 100 and the sharer terminal 200, and the balance may be used as a profit as a service operation cost or an expansion investment cost. For example, part of the advertising display fee can be used as compensation for sharing, viewing, or transferring advertisements, and the remaining income can be used as service operating expenses and dividends such as database construction or maintenance.

The service server 300 may provide the user terminal 100 with a one-time compensation amount set by the advertiser in exchange for viewing the advertisement displayed on the display window or the advertisement mounted on the fusion emoticon in the user terminal 100. The service server 300 may limit the number of compensation or the amount of compensation in order to prevent misuse due to excessive advertisement viewing.

When the fusion emoticon is clicked on the sharer terminal 200, the advertisement sharing service unit 342-3 transfers the advertisement with the fusion emoticon to the sharer terminal 200, and generates reward information according to the sharing and transfer of the advertisement.

The financial transaction service unit 343 processes compensation according to sharing and transfer by referring to compensation information. The financial transaction service unit 343 may provide compensation to the user terminal 100 or the sharer terminal 200 with reference to the compensation information. The financial transaction service unit 343 may deposit the compensation amount in real time with a pay account, such as ticket money or virtual money, and use the compensation amount to pay the purchase price of a product or withdraw in cash.

9 is an example of a display window, the advertisement display service unit 342-2 divides advertisements by category and displays them, arranges advertisements with various sorting options, and sets the display window arrangement. At least one of them may be provided to the user terminal 100.

The advertisement display service unit 342-2 may hold various types of advertisements, display advertisements by category to display advertisements in a form that is easy for users to see, and arrange the order of advertisement display. Can provide. 9 is an example of a display window in which a category is classified as a corporate image advertisement and advertisements in the order of the highest compensation amount are arranged. One-time compensation is the compensation amount set by the advertiser in exchange for viewing the advertisement. The display management unit 322 may separately classify and display advertisements with a large amount of shared rewards.

The advertisement display service unit 342-2 may limit the number or amount of compensation per day according to the advertisement viewing in order to prevent this from being excessively repeated by the user.

10 is another example of a display window. 10 is an example of a display window showing a result of categorizing a category as a corporate product advertisement and searching for a product with a fan.

The advertisement display service unit 342-2 removes the selected advertisement when one advertisement is selected among advertisements displayed on the display window through the user terminal 100, and clicks to share the advertisement for a predetermined time on the sharer terminal 200 If there is no, the selected advertisement can be returned to the display window and displayed again.

The advertisement display service unit 342-2 sets a limit value for limiting the number of sharing by referring to the display basic information, and generates redisplay request information to check whether the advertisement is re-displayed before the number of sharing reaches the limit value. can do. When the number of sharing of advertisements displayed in the display window reaches a limit value or if a cost for re-displaying the advertisement has not been paid, the advertisement display service unit 342-2 may remove the advertisement displayed in the display window.

The advertisement display service unit 342-2 may provide the redisplayed advertisement to another user terminal when another user terminal selects the redisplayed advertisement, thereby activating the distribution of the advertisement.

Messenger service companies, telecommunications companies, and local governments can participate as a system construction cost of the service server 300 and a plan to revitalize the local economy, and it is possible to attract investment from global companies or establish an investment corporation for global expansion.

The financial transaction service unit 343 provides a financial transaction service that enables compensation for sharing, transfer, and viewing of advertisements to be used for financial transactions. The financial transaction service unit 343 receives the user's ticket information from the management unit 330, receives compensation information from the advertisement sharing service unit 343-3, and refers to the user information and the ticket identification number included in the ticket information. You can handle the reward.

The financial transaction service unit 343 may accumulate rewards to the ticket money or account of the ticket money, the pay account of the pay system, or the user's bank account, provide a linked account, and convert it into cash. You can pay for the purchase of certain items.

The group networking service unit 344 groups members who have a relationship with a specific element among members who have purchased tickets, and provides an environment for information exchange between grouped members, thereby developing the local community, improving or interested in job skills by industry. Can provide knowledge acquisition in the field.

The group networking service unit 344 groups members based on at least one of a region, an industry, and an area of interest, and provides a regional group conversation service by interworking with the conversation service unit 341 so that the grouped members can participate in the conversation service. can do.

For example, the group networking service unit 344 may group local members by eup, myeon, or dong, and users with personal tickets can automatically enter the chat group at the eup, myeon, or dong unit, and If you create a small group with a real name in the chat group, you can recommend the owner of the small group as a higher group so that a higher group can be formed.

The regional group dialogue service creates a regional group dialogue service of towns, villages, dongs, and units, selects the desired activity area, selects and displays advertisement tickets suitable for the desired area, so that small business owners share the number of times in proportion to the population of the region at low cost. You can purchase advertising tickets by entering.

The regional group dialogue service displays the relevant regional advertisement on the main screen, allows the individual ticket holder to automatically enter the regional dialogue group, and opens various dialogue groups ranging from small local small groups with real names to national districts to display various advertisements. Make use of.

Regional heads can be elected through the upper group formation stage, and the CEO or cyber president can be elected as the final stage of the upper group formation stage, helping to vitalize local gatherings.

For example, when a chat room titled '56th Bongpyeong Elementary School Meeting' is created, the chairman of the meeting is elected by voting to cover the cyber crown provided by the service provider, and create a chat room for the general alumni association, which is a higher group. When the general alumni president is born, the general alumni president is created from the general alumni meeting room. In the same way, a higher group chat room can be continually recommended, resulting in a cyber president.

Gifts are given when the highest authority is born, and when the term of office of the highest authority is over, the election begins with a small local group. The term of office of the head of the organization extends from election to the end of the term of cyber president.

When you enter text in a messenger, you can call up the product on the fixed ticket or connect it with a link. For example, if you enter'Hyundai Motors' in a messenger chat window, you can go to Hyundai Motor's products in an open marketplace or connect to Hyundai Motor's homepage.

The authentication service unit 345 may receive and register biometric information from the user terminal 100 or a biometric recognition device (not shown), and generate authentication information including biometric information and ticket information of the user. The biometric device may be installed in a government agency capable of issuing, correcting, or printing a user identification certificate. The authentication service unit 345 may be interlocked with a biometric device or a government agency to register the user's biometric information, and may mount biometric information that can prove the user's identity on the ticket.

The authentication information may be transmitted to the user terminal 100, stored in a chip or accessory, and used for identification or payment authentication. Even without a resident registration card, driver's license, or passport that proves their identity, users can prove their identity with a chip that stores authentication information. For example, a user may connect a chip in which authentication information is stored to a chip recognition module of a biometric search unit for access control, and allow the biometric recognition module of the biometric search unit to recognize his or her fingerprint or iris. The biometric search desk may perform user access control by comparing the biometric information stored in the chip with the biometric information recognized by the biometric recognition module.

The personal interlocking service unit 346 may satisfy various demands of users by providing various services to a user who has purchased a personal interlocking type ticket.

The personal connection service unit 346 provides a game service and a personal video service, but is not limited thereto.

The personal interlocking type, which is an interlocking type of personal ticket, includes a game type ticket and a personal video ticket, and the game type ticket includes a shared game type, a general game type, and a speculative game type ticket, but is not limited thereto.

Personal interlocking tickets can be purchased by selecting them through the ticket purchase unit 320.

The sharing game is a competitive game in which advertisements are shared in the chat window and rewards are rewarded in exchange for sharing.

For shared game tickets, the usage period per ticket is limited (for example, 10 days per ticket), and when purchasing tickets for shared games, you can select and view separate advertisement tickets operated by the ticket gift program and sell advertisement tickets. A menu is provided for business.

The ticket gift program provides a gift as a reward when the target number of shares is reached when an advertisement is shared, and a ticket containing a separately displayed gift can be loaded first, so you can get a lot of shared rewards.

When you purchase a ticket for a shared game, you can sell advertisement tickets to acquaintances with an email provided by the service company, and your purchase points also become additional points, and if you sell advertisement tickets, an email is sent to attract advertisers. And the daily, monthly, and yearly sales results are saved, and they are automatically participated in before the sharing king, which is elected monthly and annually, and they acquire qualifications to be elected as Takji CEO with many benefits.

Tickets for speculatory games are used as a measure to cultivate speculatory games, and the purchase of tickets for speculatory games can be restricted depending on age at the time of purchase.

For speculative games, you can limit the number of admissions per day, limit the amount of use per day, and limit the amount of use and the number of entries per week and month.

11 is a flow chart showing a method for providing a service for ticket buyers according to an embodiment of the present invention, wherein the ticket purchase unit 141 connects to the service server 300 and integrates and mounts advertisements with general emoticons held by individuals. Buy a personal ticket that provides qualifications. The management unit 330 registers the ticket information including the user information of the user terminal 100 and the ticket identification number, and the service unit 340 refers to the ticket information and provides a conversation service, advertisement sharing compensation, and financial transaction by messenger. , Group networking, open market, authentication and table calculation services, etc. to provide a plurality of services to the user terminal 100.

12 is a flowchart of an advertisement sharing compensation service according to the present invention, by purchasing a ticket for each purpose such as personal or advertisement, and posting advertisements or advertisements on a display window. The purchaser of the personal ticket creates a fusion emoticon by selecting the advertisement displayed in the advertisement window from the general emoticon he has.

Users use fusion emoticons during conversations such as messengers. If the sharer participating in the conversation does not click the fusion emoticon for a predetermined period of time, the sharing is not transferred and the advertisement is returned to the advertisement window to wait for another user's selection.

When the fusion emoticon used during the conversation is clicked on the sharer's terminal, the advertisement loaded with the fusion emoticon is transferred to the sharer's terminal, and reward information according to the sharing and transfer of the advertisement is generated. The financial transaction service unit processes compensation for sharing, transferring, and viewing advertisements by referring to advertisement compensation information.

In the present invention, the user terminal 100 uses a fusion emoticon with an advertisement mounted on a general emoticon held by an individual, and only when the user terminal 200 clicks the fusion emoticon, the mounted advertisement is exposed and the advertisement is not exposed. Ads do not interfere with the expression.

In the present invention, the sharer terminal 200 displays a fusion emoticon including an advertisement loading display indicating the target share number, the number of times shared, the duration of the advertisement, or the amount of compensation to share the advertisement as the sharer plays a game, and the interest of the sharer Can cause.

13 is a service flow diagram for additionally providing a table calculation service for statistics when a ticket holder uses a conversation service as another embodiment of the present invention.

A group chat room can be a group room opened for the same business purpose or for business purposes by local small business owners. The number mentioned in the chat room is treated as a book in Excel format to provide a service that enables table calculation, and this is called'number room' as a table calculation in the chat room.

In the present invention, only those who have purchased personal or personal tickets can create a group chat room for a specific purpose to generate sales statistics or sales order statistics.

The detailed table calculation service method is as follows.

1) Step of purchasing a ticket in order to obtain service beneficiary qualification from the service server

In the ticket system of the present invention, only those who have purchased personal, advertisement or personally linked tickets can receive the ticket calculation service. However, the table calculation application is a spreadsheet like Excel, but a program like Excel has many functions, so it is a difficult program to run on a smartphone, so it can be developed as a lightweight program capable of simple calculations and can be operated alone, so it is applied to other services. can do.

2) Downloading and installing the table calculation application provided from the service server to the terminal

The table calculation application provided by the service server can be a lightweight Excel or spreadsheet to run on a terminal, or can be independently developed and an app in app embedded in a messenger program. When provided as an app-in-app, it can be driven like a conversation program.

3) preparing a form for calculating a table by executing the table calculation application;

Since the purpose of the table calculation is various, it is to determine the daily sales or stocking quantity or the quantity of stock, so it is written in a desired form as shown in FIG. 15.

4) setting a keyword used for the item of the form;

Keywords corresponding to items in the table calculation form are textual terms such as date, item, quantity, unit, purchase (receipt), sales (shipment), inventory, order, amount, or total. For example, in the dialogue "Shipping 100 shares of wild ginseng",'Sanyangsam' is the item, '100' is the Arabic numeral'share' is the unit, and'Shipping' is the sales item. Group chat room participants can be notified of the terms used or guided through help, and dialogue sentences can be presented as examples.

5) searching for a number in the conversation content of the messenger group chat room;

Numbers are based on Arabic numerals, but Korean numerals can be searched and stored so that the corresponding number can be stored and replaced in advance.

In the search of numbers, meaningless numbers can be searched, so only when the text of the adjacent words is set is extracted. For example, the set keyword is item, purchase/sales, but the sentence “I saw 30 cars today” in the conversation contains item, quantity, and unit, but since it is not possible to know whether this is purchase or sales, items and sales in adjacent keywords Or, if there is no purchase, ignore it.

Alternatively, you can extract the numbers by searching for numbers between the set keywords.

6) Extracting the searched numeric data and sequentially storing them in the column or row cell of the item

14 shows the contents of a group chat room, and numbers extracted according to search conditions are sequentially stored in a column or row cell of a corresponding item in the table calculation form as shown in FIG. 15.

7) Step of generating statistics from numerical data stored for a predetermined period in the table calculation form

For a predetermined period, statistics can be performed on a daily, weekly, monthly, quarterly or annual basis based on the date of the group chat room, and may be extracted from a selected block on a specific day of the chat contents. The number entered during the conversation can be selected and modified, or the group chat room administrator can delegate and modify it.

The table calculation form can be prepared by different sheets for each participant in the conversation, and it is possible to divide by each participant in the conversation to generate statistics for settlement, and to settle or pay in ticket money (virtual currency) such as advertising compensation.

The table calculation application can be executed when the messenger application is executed, can be executed in the background during a conversation, and displayed as an icon, and can be called and executed during a conversation.

The ticket calculation service is made up of tables only with the contents of conversation at a meeting of small businesses such as sellers, buyers, etc., so it is easy to place statistics, and the settlement is made of virtual currency such as ticket money, so you can make convenient transactions online without going through a financial institution.

10: service providing system 100: user terminal
110: input unit 120: display unit
130: connection unit 140: service providing unit
200: sharer terminal 300: service server
310: communication department 320: ticket sales department
330: management unit 340: service unit
341: conversation service unit 342: advertisement service unit
342-1: Advertisement Convergence Service Department 342-2: Advertisement Display Service Department
342-3: Advertisement Sharing Service Department 343: Financial Transaction Service Department
344: Group Networking Service Department 345: Authentication Service Department
346: Personal Interaction Service Department

Claims (13)

delete In a method for a terminal to purchase a ticket in order to obtain a service beneficiary qualification from a service server and to receive a ticket calculation service in a messenger group chat room,
Downloading and installing a table calculation application provided from the service server to a terminal;
Preparing a form for table calculation by executing the table calculation application;
Setting a keyword used for the item of the form;
Searching for a number in the conversation content of the messenger group chat room;
Extracting the retrieved numeric data and sequentially storing them in a column or row cell of the item; and
Including the step of generating statistics with numerical data stored for a predetermined period,
The table calculation service can only be received by a terminal having a personal ticket that can place an advertisement on an emoticon held by a user terminal, an advertisement ticket that can display an advertisement in the display window, or a personal linkable ticket used based on the personal ticket. There,
The settlement in the messenger group chat room is a ticket calculation service method in a messenger group chat room, characterized in that the settlement is made of virtual currency including ticket money, which is the accumulated compensation amount of personal tickets. The method of claim 2,
The keyword is a table calculation service method in a messenger group chat room, characterized in that the keyword is an accounting term such as date, item, quantity, unit, purchase, sales, inventory, order, amount, or total. The method of claim 2,
The predetermined period is a table calculation service method in a group chat room, characterized in that a daily, weekly, monthly, quarterly, or annual basis of the group chat room. The method of claim 2,
The statistics are classified for each conversation participant to generate statistics. The method of claim 2,
A table calculation service method in a messenger group chat room, characterized in that the number search is extracted only when the text of the adjacent word before and after is set. The method of claim 2,
A table calculation service method in a messenger group chat room, characterized in that the number search only extracts numbers between set keywords. The method of claim 2,
A table calculation service method in a messenger group chat room, characterized in that the number is extracted from a selected block among conversation contents. The method of claim 2,
Table calculation service method in a messenger group chat room, characterized in that the search for numbers is Arabic numerals or Korean numerals. The method of claim 2,
The table calculation service method in a messenger group chat room, wherein the table calculation application is executed in a background during a conversation. The method of claim 2,
The table calculation service method in a messenger group chat room, characterized in that the table calculation application is embedded in a messenger application and is executed at the same time when the messenger application is executed. delete The method of claim 2,
In the messenger group chat room, the user terminal holding the ticket uses the fusion emoticon with the advertisement in the messenger group chat room to share the advertisement to the sharer terminal to transfer the right to share the advertisement or to receive a reward for viewing the advertisement in the display window. How to service votes in group chat rooms.

Images