Description and Summary
05-07-03




Description:

    Can be found here: Project Description

Summary

    In my project there are quite a few seperate components that work together as the entire system. I have been working on these different parts one at a time, and have completed a few. However the project will not be completed until I finish all the parts. Here are the parts and the ones I have completed so far:
  1. Inventory Constructed -- DONE
  2. Inventory Viewable by Stores -- DONE
  3. Inventory Modifiable by Distribution Center (DC) -- DONE
  4. Orders from Stores to DC -- DONE
  5. Order viewed by DC -- DONE
  6. Shipment Sent to Stores from DC -- DONE
  7. Shipment Checked by Stores -- DONE
  8. Message Center -- DONE

    Here is what each of the parts above is supposed to do:
  1. Inventory -- This is a database that stores all the items the company has. The variables associated with each item is its description, sku, color, and price.
  2. Inventory Viewable by Stores -- This allows the stores to see the database in an organized manner so they can keep themselves updated on what the store has to offer to its customers.
  3. Inventory Modifiable by Distribution Center (DC) -- This allows the DC to modify, delete, or add items to the inventory. This is essential because inventorys are always changing and this is will keep the store updated.
  4. Orders from Stores to DC -- Whenever a store needs a certain item, it can easily go to this page and order from the inventory list. This page offers options to delete items from an order, and to then finalize it into the database. This done by having a seperate table for each of the stores in the database.
  5. Order viewed by DC -- This allows the DC to view the databases of each stores order. That way the DC can send the store exactly what it needs.
  6. Shipment Sent to Stores from DC -- This allows the DC to send shipments to the stores. The DC is first asked which store to send a shipment to. Then it displays the inventory with an add button and also stars the items that that specific store ordered. As items are added, they are added to a table for that stores shipment. At the end, the table is displayed and can be edited.
  7. Shipment Checked by Stores -- This will allow the stores to check in the shipment sent by the DC and to report back any descrepencies found in the shipment. This is done by displaying the table that holds that stores's shipment. Then they are given the input field to input how many of the item they actually got. This is then sent to another page, where if they received the same amount sent, it is simply erased from their shipment page. However if there was a discrepency, it is saved into another table for discrepencies that also holds the store number and then it is erased from the shipment table. This page continues while all items in the shipment have not been checked in. Then they can return to the menu. Also the Distribution Center can view these discrepencies as one of their menu options. This allows them to view the errors, and the data fields for this include the store number, the sku of the item, the quantity sent, the quantity received, and the difference betweeen the last two (for example -5 or +2).
  8. Message Center -- This will allow the stores and DC to get updates for the following:
    • When shipment checked in by a store
    • When ordered made by a store
    • When shipment sent by DC
    • When inventory changed by DC
    To do this, after each event the "return to menu" button actually links to the message creator page. This page is sent the "to" and "from" data as well as a number that corresponds to the even that just took place (ie "2" stands for "shipment sent" etc.) Then the message creator page uses the data and also creates a variable for the date (using function getdate()) and then adds to the database of messages. Also created was two message viewing centers, one for the stores and one for the DC. These are table driven pages that display the messages (for the stores, it displays messages to and from their store number and messages sent to "all", for dc it displays all messages) and also gives the option of deleting messages sent to them.


    Currently I just finished the message center system. This was kind of an add on to the project because i have finished all the main parts of getting the inventory/shipment/order part of the program. As an added feature, i decided to make this message center to help the stores and dc out so they know every time and event or action happens, in order to track the business of the company even better. The details about the system can be found above (short) or can be found in more detail HERE

Goals

    Check entire project for glitches. Also see if i want to make the project more secure and therefore check for the password on each page to prevent people from just linkin to one page without having a password (this would also cause errors.) And finally, to make sure all the parts work together and that the project satisfies the requirements I made for it at the beginning of the year.