Hello, everyone!
I apologize for being incommunicado for so long. I was sick for a few weeks and then I had to wrap up work at the lab for the summer. Excuses, excuses, I know. Anyway, I'm here! I'll be posting a lot more as we are now in the final stretch.
Part of PizzaPi is hardware, but a majority of it is software and right now I'm working on the web/mobile/tablet interface. I'm doing this using MySQL as my database; PHP, JQuery/JavaScript, HTML, and CSS to create the web site. I'm also using Bootstrap to handle compatibility across devices, so the website will actually look great in just about any screen size.
Here is a screenshot of how the database is setup. I use relational database theory and link all the tables together to ensure consistency throughout the backend.
Hopefully the layout is easy to understand. I plan to collect sensor data from individual orders as well as delivery time. This information will later be available for the pizza store to use to improve future orders. There are tables that deal with the pizza itself, such as the kind of sauce, crust, or toppings that a customer might want. The latter tables all link into the main pizza table and then most everything else links into the order table, known as "piorder".
The video is short, but I thought it might be nicer to see the website in motion rather than in screenshots. This is a static version, of course. I will be working on linking the backend to the front so that information is pulled dynamically based on the customer input. I also have drawings in my notebook that show the layout for the store's frontend, that will be coming later in the week.
That's about it for now. Looking forward to getting this project done!