TWI403967B - System and method for scheduling programs viewing on electronic boards - Google Patents

Abstract

A system for scheduling programs viewing on electronic boards includes a scheduling server, a database, a plurality of relay servers, a plurality of client computers, and a plurality of displays. The scheduling server includes a schedule processing module, which is configured for obtaining an IP address of each client computer, calculating, adjusting and updating a beginning time and an end time of a schedule, dynamically generating a schedule information list and a schedule content list for each day, determining schedule information needs to update according to priorities of schedules in the schedule information list, searching schedule contents to be downloaded in the relay servers according to the schedule information list and the schedule content list, controlling each client computer having a corresponding IP address to download the schedule contents from each relay server and display the schedule contents on each display. A related method is also disclosed.

Description

Electronic kanban scheduling system and method

The present invention relates to a scheduling system and method, and more particularly to an electronic kanban scheduling system and method.

The electronic signage system is an information display system specially designed for the environment of the display screen using photoelectric display technology, computer application technology, and automatic control technology. Electronic signage, also known as multimedia communication platform, replaces traditional flat document announcements and posters with digital multimedia audio and video, and can be used for stand-alone operation or to transmit information to each electronic bulletin board through the regional network routing database server. The multimedia electronic signage system can also be used for live video playback at the same time, and can use multiple audio and video sources for multi-channel input. Each server can process up to eight audio and video input channels, and the whole system can have up to 64 input channels. The central broadcast schedule system can play the audio and video content of the designated channel at each designated time of the designated place. It is most suitable for commercial billboards and peer-to-peer exhibition planning. It can also be easily extended to supermarkets, stores, cinemas, stations, etc. Different occasions, and with the timing recording system for advertising platforms.

At present, most of the scheduling operations of electronic kanban on the market are not satisfactory to users, and they mainly focus on the following three aspects: First, the processing of scheduling The ability is too weak, the priority order of the schedule is not defined, so that the urgent schedule cannot be prioritized; secondly, the basic information of the schedule cannot be updated dynamically, so that the user cannot intuitively and accurately understand the latest date. Basic information about scheduling. Third, the scheduling operation is too cumbersome to perform a brief and effective scheduling operation.

In view of the above, it is necessary to propose an electronic signage scheduling system that can dynamically update schedule information in a specified client computer and process the schedule content in accordance with the priority order of the schedule.

In view of the above, it is also necessary to propose an electronic kanban scheduling method, which can dynamically update scheduling information in a specified client computer, and process scheduling content in a priority order such as scheduling.

An electronic kanban scheduling system includes a scheduling server, a database, a relay server, a client computer, and a display. The scheduling server includes a scheduling processing module, and the scheduling processing module is configured to obtain an IP address of the client computer from the client computer, calculate, adjust, and update the scheduling start time and the end of the scheduling. Time, dynamically create a schedule information list and schedule content list for each day, and store the scheduled schedule information list and schedule content list in the database, according to the schedule priority in the schedule information list The order level level determines whether the schedule information needs to be updated, searches the relay server for the corresponding schedule content according to the schedule information list and the schedule content list, and controls the client computer having the corresponding IP address. Download the found schedule content directly from the relay server, and display the downloaded schedule content on the client The brain is connected to the display.

An electronic kanban scheduling method, the method comprising the steps of: (a) obtaining an IP address of each client computer; (b) calculating a schedule start time and a schedule end time by using a time component, and by using a time component The date component dynamically adjusts and updates the schedule start time and the schedule end time; (c) generates a schedule information list for the day according to the schedule information of each day, and generates a row of the day according to the schedule summary of each day. a list of program contents, and storing the schedule information list and the schedule content list in the database; (d) judging whether the schedule information needs to be updated according to the level of the schedule priority level; (e) the priority level of the schedule level a change, the schedule information in the schedule information list and the schedule content summary in the schedule content list are updated; and (f) the relay server is listed according to the schedule information list and the schedule content list. Searching for the corresponding schedule content, and controlling the client computer having the corresponding IP address to directly download the found schedule content from the relay server, and displaying the content of the schedule connected to the client computer On the display.

Compared with the prior art, the electronic kanban scheduling system and method can dynamically update scheduling information in a specified client computer, and process the scheduling content according to the priority order of the scheduling.

1‧‧‧ Schedule Server

10‧‧‧ Schedule Processing Module

101‧‧‧Scheduled Address Acquisition Submodule

102‧‧‧ Scheduling time calculation sub-module

103‧‧‧ Schedule List Generation Submodule

104‧‧‧ Schedule Information Update Sub-module

105‧‧‧ Schedule Content Download Submodule

12‧‧‧Connect

14‧‧‧Network

2‧‧‧Database

21‧‧‧ Schedule information list

22‧‧‧ Scheduled Content List

3‧‧‧Relay Server

30‧‧‧ memory

4‧‧‧Client computer

40‧‧‧Distributor

5‧‧‧ display

1 is a system architecture diagram of a preferred embodiment of a scheduling system for an electronic signage of the present invention.

FIG. 2 is a functional module diagram of the scheduling processing module in FIG. 1.

FIG. 3 is a schematic diagram of the schedule information list in FIG. 1.

4 is a schematic diagram of a list of schedule contents in FIG. 1.

FIG. 5 is a flow chart showing an implementation of a preferred embodiment of the scheduling method of the electronic signage of the present invention.

Referring to Figure 1, there is shown a system architecture diagram of a preferred embodiment of the scheduling system for an electronic signage of the present invention. The system mainly includes a scheduling server 1, a database 2, a plurality of relay servers 3, a plurality of client computers 4, and a plurality of displays 5. The scheduling server 1 is connected to the database 2 via the connection 12 and connected to the client computer 4 via the network 14. The relay server 3 is directly connected to the schedule server 1 and connected to the client computer 4 via the network 14. The client computer 4 can be directly connected to one display 5, or a plurality of displays 5 can be connected by a single distributor 40.

The scheduling server 1 includes a scheduling processing module 10, and the scheduling processing module 10 is configured to acquire an IP address of each client computer 4 from the client computer 4, and calculate a scheduling start time. And scheduling end time, dynamically creating a schedule information list 21 and a schedule content list 22 for each day, and storing the schedule information list 21 and the schedule content list 22 in the database 2, according to The schedule priority level level determines whether the schedule information needs to be updated, and searches the corresponding schedule content in the relay server 3 according to the schedule information list 21 and the schedule content list 22, and the control has corresponding The client computer 4 of the IP address directly downloads the found schedule content from the relay server 3, and displays the downloaded schedule content on the display connected to the client computer 4. . The schedule information includes schedule number, schedule name, schedule date, schedule time, client address, and schedule priority (refer to FIG. 3 for detailed description). The summary of the scheduled content includes a file number, a file name, a file type, and a schedule number (refer to FIG. 4 for a detailed description). The schedule priority order indicates the priority level of a certain schedule. In this embodiment, four scheduling priorities of “A”, “B”, “C” and “D” are adopted, and the above four are defined. The scheduling priority levels are sequentially reduced, that is, the scheduling priority order is: A>B>C>D.

The database 2 is used to store the schedule information list 21 and the schedule content list 22. Each relay server 3 includes a memory 30 for storing scheduled content that can be downloaded by the client computer 4. The scheduled content is a file that can be downloaded and played by the client computer 4, such as files File1, File2, File3, ..., Filen, mainly including file types such as movies, music, animations, and news. Each client computer 4 has a uniquely defined IP address, such as IP1, IP2, IP3, ..., IPn, which is the destination address of the client computer 4. The client computer 4 can be a general user's computer, such as a desktop or a laptop, or any other suitable computer. The display 5 can be a CRT display, an LCD display, or any other suitable display device. The connection 12 is a database connection, such as Open Database Connectivity (ODBC), or Java Database Connectivity (JDBC). The network 14 can be an intranet or an Internet or other type of communication network. .

Referring to FIG. 2, it is a functional module diagram of the scheduling processing module 10. The scheduling processing module 10 includes a scheduling address acquisition sub-module 101, a scheduling time calculation sub-module 102, a scheduling list generation sub-module 103, a scheduling information update sub-module 104, and scheduling content. The submodule 105 is downloaded.

The scheduling address acquisition sub-module 101 is configured to acquire the IP address of each client computer 4 from the client computer 4. Each client computer 4 has a uniquely defined IP address, such as IP1, IP2, IP3, ..., IPn, which is the destination address of the client computer 4.

The scheduling time calculation sub-module 102 is configured to calculate a schedule start time and a schedule end time by using a predefined time component, and perform scheduling start time and schedule end time by a predefined date component. Dynamic adjustments and updates. The time component includes a setTitle component, a setList component, and a setListDate component; the date component includes a setSelectDate component and an update component.

The schedule list generation sub-module 103 is configured to generate a schedule information list 21 of the day according to schedule information of each day, and generate a schedule content list 22 of the day according to the schedule summary of each day, and The schedule information list 21 and the schedule content list 22 are stored in the database 2. The schedule information includes schedule number, schedule name, schedule date, schedule time, client address, and schedule priority. The summary of the scheduled content includes a file number, a file name, a file type, and a schedule number.

The schedule information update sub-module 104 is configured to determine whether the schedule information needs to be updated according to the schedule priority level level. If the schedule information needs to be updated, the schedule information is updated in the schedule information list 21 and The schedule content summary is updated in the schedule content list 22. In this embodiment, the four scheduling priorities of "A", "B", "C", and "D" are used to indicate the priority level of a certain scheduling, and the four scheduling priorities are defined to be sequentially decreased. That is, the scheduling priority order is: A>B>C>D. If the schedule priority changes, the schedule information needs to be updated.

The scheduled content downloading sub-module 105 is configured to search the relay server 3 for the required scheduling content according to the scheduled information list 21 and the scheduled content list 22, and control the corresponding IP address. The client computer 4 downloads the found schedule content from the relay server 3. The scheduled content is stored in the memory 30 of the relay server 3, which is a file that can be played in the client computer 4. The file type mainly includes movies, music, animation, news, and the like.

Referring to FIG. 3, a schematic diagram of the schedule information list 21 is shown. The schedule information in the schedule information list 21 includes a schedule number, a schedule name, a schedule start time, a schedule end time, a client address, and a schedule priority. Each schedule corresponds to a unique schedule number to indicate different schedules, such as ID1, ID1, ID3, ID4, ..., IDn. The schedule name includes movies, news, music, animations, and the like. Each schedule is calculated by the scheduled time calculation sub-module 102 to calculate a schedule time, which includes the schedule start time and the schedule end time, for example, October 8, 2006, Sunday, morning. 8:00 is the schedule start time of the schedule number ID2, and 10:00 am is the schedule end time of the schedule number ID2. The client address identifies the IP address of the client computer 4, such as IP1, IP2, IP3, ..., IPn, which is obtained by the scheduled address acquisition sub-module 101 from each client computer 4. The schedule priority order indicates the priority level of a certain schedule. In this embodiment, the scheduling schedules of "A", "B", "C", and "D" are used to define the schedule. The priority level of the above four schedules is lowered in order, namely: A>B>C>D.

Referring to FIG. 4, a schematic diagram of the schedule content list 22 is shown. The summary of the scheduled content in the scheduled content list 22 includes a file number, a file name, a file type, and a schedule number. Each file corresponds to a file number, such as P1, P2, P3, P4, ..., Pn. Each file has a unique file name, such as File1, File2, File3, File4, ..., Filen. The file type is used to distinguish each file type, for example, the file type is the file type of the movie is mov, the file type is the file type of the news is avi, the file type is the file type of the music is mp3 or mp4, and the file The file type of the type animation is MPEG. The schedule number is the same as the schedule number in the schedule information list 21, and the schedule information list 21 is associated with the schedule content list 22 to facilitate the memory 30 in the relay server 3. Find the corresponding schedule content.

Referring to FIG. 5, it is a flowchart of an implementation of a preferred embodiment of the scheduling method of the electronic signage of the present invention. The scheduling processing module 10 is loaded in the scheduling server 1 and operates in the scheduling server 1. First, the scheduling address acquisition sub-module 101 acquires each The IP address of a client computer 4, which is used to indicate the destination address of the client computer 4 (step S50). The schedule time calculation sub-module 102 calculates the schedule start time and the schedule end time by pre-defined time components (such as the setTitle component, the setList component, and the setListDate component), and uses the date component (for example, the setSelectDate component and the update component). Dynamic adjustment and update of the schedule start time and the schedule end time (step S51).

The schedule list generation sub-module 103 generates a schedule information list 21 for the day according to the schedule information of each day, and generates a schedule content list 22 for the day according to the schedule summary of each day, and lists the schedule information 21 The schedule content list 22 is stored in the database 2. The schedule information includes schedule number, schedule name, schedule date, schedule time, client address, and schedule priority. The summary of the scheduled content includes a file number, a file name, a file type, and a schedule number (step S52).

The schedule information update sub-module 104 updates the schedule information in the schedule information list 21 according to the schedule information, and updates the schedule content summary in the schedule content list 22 according to the schedule content summary (step S53). The schedule information update sub-module 104 determines whether the schedule information needs to be updated according to the schedule priority level level. If the schedule priority order changes, the schedule information needs to be updated (step S54). If the schedule information needs to be updated, the schedule information is updated in the schedule information list 21, and the schedule content summary is updated in the schedule content list 22, that is, the process returns to step S53. If the scheduling information is not required to be updated, the scheduled content downloading sub-module 105 is configured according to the scheduled information list 21 and the scheduled content list. Searching for the required schedule content in the memory 30 of the relay server 3, and controlling the client computer 4 to directly download the searched from the memory 30 according to the IP address of the client computer 4. Schedule content (step S55). The client computer 4 plays the scheduled content downloaded from the memory 30, and displays the scheduled content of the broadcast on the display 5 connected to the client computer 4 (step S56).

The present invention has been described above in terms of preferred embodiments, and is not intended to limit the invention. The scope of the present invention is defined by the scope of the appended claims, unless otherwise claimed.

1‧‧‧ Schedule Server

10‧‧‧ Schedule Processing Module

12‧‧‧Connect

14‧‧‧Network

2‧‧‧Database

21‧‧‧ Schedule information list

22‧‧‧ Scheduled Content List

3‧‧‧Relay Server

30‧‧‧ memory

4‧‧‧Client computer

40‧‧‧Distributor

5‧‧‧ display

Claims (10)

An electronic signage scheduling system includes an interconnected scheduling server, a database, a relay server, a client computer and a display, wherein: the client computer connects at least one display by a dispenser; The scheduling server includes a scheduling processing module, and the scheduling processing module is configured to acquire an IP address of the client computer, calculate, adjust, and update the scheduling start time and the scheduling end time, and dynamically create each a one-day schedule information list and a schedule content list, the schedule information list is associated with the schedule content list, and the schedule information list and the schedule content list are stored in the database, according to the row The schedule priority level level in the process information list determines whether the schedule information needs to be updated, and searches for the corresponding schedule content in the relay server according to the schedule information list and the schedule content list, and the control has corresponding The client computer of the IP address directly downloads the found schedule content from the relay server, and displays the downloaded schedule content on the client computer. On the display. The electronic kanban scheduling system of claim 1, wherein the relay server comprises a memory, and the scheduled content that can be downloaded and played by the client computer is stored in the memory. The scheduling system of the electronic signage according to claim 1, wherein the scheduling processing module calculates, adjusts, and updates the scheduling start time and the scheduling end time by calculating a row by a predefined time component. Start time and schedule end time, and schedule start time and row through pre-defined date components Dynamic adjustment and update at the end of the process. For example, in the electronic kanban scheduling system described in claim 1, the dynamic creation of the schedule information list and the schedule content list of each day is generated according to the schedule information of each day, and the schedule information list of the day is generated. And generate a list of schedule contents for the day based on the daily summary of the schedule content. For example, in the electronic kanban scheduling system described in claim 4, the schedule information list and the schedule content list are associated by the schedule number. For example, in the scheduling system of the electronic kanban described in claim 1, the judging whether the schedule information needs to be updated according to the rank priority level in the schedule information list is determined by judging the schedule information list. Whether the priority level of the process changes or not, if the priority level of the schedule changes, it is judged that the schedule information needs to be updated. An electronic kanban scheduling method, the method comprising the steps of: obtaining an IP address of a client computer, wherein the client computer is connected to at least one display by a dispenser; and calculating a scheduling start time by using a time component and Schedule end time, and dynamically adjust and update the schedule start time and schedule end time by the date component; generate a schedule information list for the day according to the schedule information of each day, and according to the schedule content of each day The summary generates a schedule content list of the day, associates the schedule information list with the schedule content list, and stores the schedule information list and the schedule content list in the database; according to the row in the schedule information list The priority level of the process determines whether the schedule information needs to be updated; Updating the schedule information in the schedule information list and the schedule content summary in the schedule content list if the priority level of the schedule changes, and according to the schedule information list and the schedule content list Locating the corresponding scheduling content in the relay server, and controlling the client computer having the corresponding IP address to directly download the found scheduling content from the relay server, and displaying the scheduled content on the client computer Connected to the display. For the scheduling method of the electronic kanban described in claim 7, the schedule information includes schedule number, schedule name, schedule date, schedule time, client address, and schedule priority information. The method for scheduling an electronic kanban according to item 8 of the patent application scope, wherein the schedule content summary includes a file number, a file name, a file type, and a schedule number. In the method for scheduling an electronic kanban according to claim 9, the schedule information list and the schedule content list are associated by the schedule number.