Progress Log
So, basically the idea is that here is where I can voice my POV over this whole project, and update what is/isn't happening.
- (c. Aug 2013) Conception of the idea of making a POS system. Idea was taking form: major goals are to create a user database for employees (and the management of them),
creating a sales menu that could easily process transactions and track overall sales in a day, generate sales reports from data given by System, and manage inventory as
needed. Skeleton of system is established.
- (9.9.2013) First progress check-- core idea was shown and general functionality was displayed. At the time, only the employee management was functional, as them
SQL functions weren't cooperating as expected. About 30% of the project is done, with the next major part being to create the sales menu and inventory database.
- (9.12-9.21.2013) Creation of sales menu and the beginning of the inventory management functions were implemented. Creation of the sql table for inventory was established, and
there was also some maintenance on the old hire/fire menus. Next up: time cards!
- (9.24.2013) Second progress check-- the employee management has been repaired and works as intended. The inventory menu is done for all intents and purposes, save for
formatting in the final product. Change of plans: next on the list is to create a sale menu that uses the ITEMS sql table already defined in the inventory section.
Approcimate progress: ~40%.
- (10.1->10.8.2013) Some complications are coming up in the project: having linked databases is a bit more to account for than I previously imagined it would be. So, what
has been done is a basic implementation of the idea, and a rudimentary clock in/out page. More to come, but the idea is that the sales will be included in the same database
as the hours which is in the USERS database. We'll see how well it holds up.
- (10.10-10.20.2013) Lots of research has been done over the past few weeks in order to get this clockin/out function to work. Some php functions have been applied and the
problem is solved. Working on updating hour totals over a week and then lifetime totals as "flavor statistics". Next is some re-aligning of previous sites to fit the new tables and
then comes the sale menu. After this the project will be mostly complete, save for formatting and research on CSS, which will be integrated into the project.
- (10.30-11.5.2013) Some progress has been made on the sales page: the main mechanics are in place so all that is left is to input the store table for mysql. From there,
there are two more pages that need to be made, both of which are using a simple SQL code and can be done easily. The project is nearing completion, so from here most of it
will be QC testing to smooth out the performance. After that, writing a CSS style sheet and designing the web elements will be last on the list.
- (11.7-11.10.2013) Sales page almost finished, it loops properly and just have to pass the values correctly and it can be finished handily. Last piece of work to be done is
to add in control values for a starting day fund for the register and some adjuster values through the Start of Day / End of Day page-- then end by having a database for the stores
so that they can have some way of tracking sales, employees, etc. Presenting on 11/12/13 to show the last part of the core project, then the rest is CSS styling.
- (11.12-11.26.2013) Lots and lots of research done-- particularly in more advanced html functions
such as the "< div>" tag and other fun stuff. Extensive CSS research has been done and a general CSS
file has been included. Lots of QC has been performed in order to being a polished finished product.
Other Bugs and stuff are being fixed in the process, should be done soon.
- (12.1-12.5.2013) The website was fully functional at this time. Improvements were made to the styling and some QC testing was done to ensure a smooth presentation. In the process,
a return menu was established using similar source coding as the sales menu since they function nearly identically from a business perspective. The presentation was a success at the UR
symposium on 12.5.2013, and a test account was added so that potential users could evaluate the system and provide feedback as needed, since this project is based on user
feedback.
Source code for reference:
Menus:  CS489index.html uposdir.php
Sales:  UposSale.php saleactiontest.php saleaction2.php saleaction3.php
Returns:  UposReturn.php returnactiontest.php returnaction2.php returnaction3.php
Time card:  UposTime.php timeaction.php timeaction2.php timeaction2a.php
Inventory Menu:  UposInven.php uposfindit.php