• Login
• Main Menu
• Product
• Order
• Inventory
• Personnel
• Security
• Cashier
• Store

The GUIDOs system developed by Squidsoft Inc. has fulfilled the requirements of Calgary Foods purposed in the functional specifications along with some additions to the system. Below is a list of major requirements of our project, with a brief discussion of what we have changed in order to make GUIDOs easier to use for Calgary Foods employees.

The "Login" Interface window will be displayed as soon as the system starts up. This window is basically used to prevent unknown users from obtaining access to the GUIDOs system.

Changed features:

According to our original specification, the authorized users can access the "Change password" window by clicking on the OK button with a blank password field in the "Login" Interface window. However, in our final GUIDOs system, the "Change password" window has been moved to the "Main menu" Interface window.

The "Main Menu" Interface appears once a user has successfully completed the login process. The Main Menu consists of eight buttons, which, when clicked on, brings the authorized users to the different interface windows of the GUIDOs system.

Added features:

Three more buttons have been added to the Main Menu Interface window and now the Main Menu consists of eleven buttons. One of the added buttons is a "Password" button which will bring the users to the "Change Password" window and the users can change their passwords whenever they want to for security purposes. Another button has been added to the "Main Menu" is a "About" button which will display a short description of the GUIDOs system when it is chosen. Finally, the third button that has been added is the "Exit" button which will shut down the GUIDOs system.

The Product database contains a list of product information. Through the user friendly "Product" Interface window, authorized users can add, delete, update, sort, find, and print the information about the products easily.

Changed features:

In our original specification, the users needed to click on the "Update" button shown in the "Product" Interface window in order to apply the modification of products to the actual database. However, in our final product, the "Update" button is no longer needed. All the user has to do is to highlight whatever field needed to be modified and hit the "enter" key on the keyboard once the modification is complete. This new feature actually saves the users steps and allows the users to update the store database more quickly and easily.

The "Order" screen contains all of the orders currently in the system as well as buttons to create a new order, update, find, sort, print, and display information about a highlighted order.

Added features:

The "new" button of our original design has been replaced by the "Auto Order" and "Manual Order" buttons. Orders can normally be made manually at any point in time by authorized users pressing the "Manual Order" button. However, With the new "Auto Order" button, Our system can now generate orders automatically when the quantity in stock drops below the alert level and this is usually done at the end of a business day. However, user who have the required security level may change the time for automatic ordering.

The "Inventory" screen is used primarily for viewing the current inventory of a store. When it is accessed a scrolling table will appear before the user containing all the information available for any particular inventory item. Also, it has the ability to allow users to find, sort, and print the information in the inventory database.

Changed features:

In our original specification, we did not have a full description of the "sort by" window. However, the "sort by" window of our final product has been fully developed. Now the user can sort the inventory table by using the primary key (i.e. UPC), or secondary key (i.e. Description), or tertiary key (i.e. Price). Also, the two new "Ascending" and "Descending" buttons can be chosen as well by the users for a proper sort.

The "Personnel" interface window contains all employee information with the ability to add, delete, update, sort, find, and print the information about employees and set employees' passwords.

Added features:

In order to make our system more secure, we have add one more function to the "Personnel" interface window. It allows authorized users to set other employees passwords when required.

Changed features:

In our original specification, the users needed to click on the "update" button in order to apply the modification of employees to the actual database. However, in our final product, the user has only to highlight the field to be modified and hit "enter" key on the keyboard. It actually saves the users steps and allows the users to update the employee database more quickly and easily.

Also, there was a "Clear Pwd" button in our original design. But in our final system, the "Clear Pwd" has been replaced by a "Set Pwd" button which allows authorized users to set other employees passwords.

The "Security" interface contains the information of all employees' security levels currently available in the system. In general, employees do not have access to all different functions of the system. The security window is used to pre-define the access of each security level and therefore the system can restrict certain information that an employee will have access to.

Added features:

Basically, the overall functions of our final product is very similar to our original specification. However, as we were developing our final product, we found out that we needed to allow users to pre-define the access to different windows as well. So, more check boxes have been added to the Security Interface and this allows more flexibility in the security hierarchy in the system.

The Cashier's Window Interface is designed to simulate a series of purchases a cashier would enter into the system.

Nothing has been changed for the Cashier Interface. The final product of this interface has been successfully implemented exactly the same as our original specification.

The Store database contains a list of store information. By displaying the user friendly "Stores" window, our customers can easily add, delete, update, and print the information about a store.

Added features:

Two more functions are added to the "Stores" window. One is "Find" function which allows the users to enter the search criteria in order to find the information of a specific store quickly. The other one is "sort" function which allows the users to choose several different sorting criteria in order to display the stores in the "Store" window in an order according to the users' selection of sorting criteria.

Changed features:

In our original specification, the users needed to click on the "update" button in order to apply the modification of stores to the actual database. However, in our final system, the "Update" button is no longer needed. All the users have to do is to highlight the field to be modified and hit the "enter" key on the keyboard. It saves the users steps and allows the users to update the store database more quickly and easily.

Find Button  

Demo Script  
Source Code  

Main Page