Our team

Our group name was Fireteam Idiot, our group members are Sam Bloomfield, Oli Masters and Oliver Shipside.

Inspiration

We were inspired from the brief set by the corporate sponsor NEXT Plc, to make a webpage where employees can clock in and out of work, where it connects to a database so that management and admins can be aware of people who are working.

What it does

It allows employees to clock onto their job, and clock off again, making changes in a database so that an admin can view things that they may need. The webpage creates a post request to the fastapi server, where database management is handled. There is also a suite of admin utils which can be used to assign work and manage the databases manually.

How we built it

We built the frontend using HTML, CSS and JS, and the backend using Python, fastapi and SQLite.

In order to run, fastapi and uvicorn will need to be installed via pip to run the server.

Challenges we ran into

At first, the server did not want to communicate with the webpage, this being because we had not added a list of safe URL's which could execute POST requests to the server. Other challenges were making the SQLite database interface properly with the website controls and with admin functionality.

Accomplishments that we're proud of

We have managed to create a working webpage with a server, which can communicate and make changes to a centralised database. While already knowing the basics, we have learned a lot more about using git, especially about solving merge conflicts and remembering to commit changes before pulling from remote.

What we learned

SQLite, Fast API, more GIT skills and usage, Javascript.

What's next for Next Online Automated Timesheet Manager

If we had more time, we would have had the server also be running an SMTP server so that employees time sheets could be emailed to them, we currently only have timesheets being written to a file to be sent manually. We would also add some more features to the webpage so that the employee can view certain pieces of data, instead of only clocking in and out.

Notes

The person who owned the git repo did not return after going to bed in the evening, so the repo is forked to allow public access

Built With

Share this project:

Updates

Submission history