lhovo / gangshow_cue Goto Github PK

Load the data from google sheets when the service loads.

Have a webpage location that an Admin can navigate to force a data refresh without having to restart the server.

Full script with operator notes

Simple large display with upcoming Scene at the top and 'Cast Call' in the middle.

Bonus points for making the 'Cast Call' text "bling" or some eye catching sparkle animation

Note, this mockup has current at the top and next on the bottom of the screen.
This has been changed to next ant the top and nothing at the bottom.

TW 20190622
Updated database headings from "Next Scene" and "Cast Call" to "NextScene" and "CastCall". Check with Luke that this won't cause a problem elsewhere.
Also, check that the transition works in prod.
Could maybe also add a right to left transition to the scene name change.

Make two websocket servers one for the client and the other for the controller.

This has two purposes

• The small microcontroller doesn't need to listen to the data payload sent to the web clients and overflowing it's small buffer causing it to crash.
• Make it more secure as web clients sending data on the socket can be rejected and not placed on the WebSocket connection to other clients

Split screen with Left and Right Operator notes, cue numbers in the middle

Have two ways to reset the system to Q1:
Password protected admin section on the webpage and
Hold a button on the controller for x seconds

On a pre-programmed cue number,
Start a count down timer for a pre-configured time interval (say 20 minutes),
send this count down to the web client WebSocket connection along with the cue information.
This will allow a timer for interval or other show item where a timer to next event is needed

Design Questions:
How will this data be represented on the WebSocket to the web client?

• Time in seconds
• Time split fields, minutes and seconds
• Date time when the count down will expire
• -- Insert another idea here --

Load the google spreadsheet data into memory when the server is started.
Create a webpage URL to force the reloading of the data without the need for restarting the server.

Write any cache files to tmpfs so we can make the image read only.