Southaven live productivity feed uses C# and Python to present real time employee numbers in a visual animated format to employees, management, and others working on site.
Employees can see what has been done in real time presented like:
| EMPLOYEE | KIT_INBOUND | PIECE_INBOUND | INSTRUMENT_INBOUND | PUTAWAY | KIT_BUILD | OUTBOUND | OTHER |
|---|---|---|---|---|---|---|---|
| ROLANDO FLORES | 163 | 48 | 0 | 4 | 26 | 0 | 0 |
Information is queried from Oracle using the queries in the folder sql. These are then written to a json file. For example, running completed_work_other.sql returns the following json:
[
{
"EMPLOYEE": "NICHOLAS THOMAS",
"KIT_INBOUND_TRANSFER": 0,
"PIECE_INBOUND_TRANSFER": 0,
"INSTRUMENT_INBOUND_TRANSFER": 0,
"PUTAWAY_TRANSFER": 63,
"KIT_BUILD_TRANSFER": 0,
"OUTBOUND_TRANSFER": 7,
"OTHER_TRANSFER": 0,
"TOTAL_PRODUCTIVITY": 0.19
},
{
"EMPLOYEE": "GONZLA JOYNER",
"KIT_INBOUND_TRANSFER": 0,
"PIECE_INBOUND_TRANSFER": 0,
"INSTRUMENT_INBOUND_TRANSFER": 0,
"PUTAWAY_TRANSFER": 6,
"KIT_BUILD_TRANSFER": 0,
"OUTBOUND_TRANSFER": 0,
"OTHER_TRANSFER": 8,
"TOTAL_PRODUCTIVITY": 0.58
}
]The application consists of three main parts:
- Webserver / Website (Python, HTML, Js)
- Data Refresh (C#)
- Helper Scripts (Python)
The application runs off a python webserver using
python -m http.server 8000Data is refreshed in the background by the tracker application. it is then presented to the website via js.
The application currently requires Python 3.6+, .NET 4+, and HTML5. However, I plan on depreciating python entirely by setting up the simple web server in C#. Additionally, the proper Oracle prequisites are necessary, but these come standard on the computers this would run on at Southaven.
There are currently 3 pages displayed during the applications main loop as outlined in navigation.json
{
"productivity": "otherproductivity.html",
"otherproductivity": "motto.html",
"motto": "productivity.html"
}
There are 2 productivity pages but one is for managers, this is the main page
Created by: Ian Doarn (https://github.com/IanDoarn/)