My name is Okan and I'm a student of Computer Engineer. You can find me on 
-
Login, Dashboard, Logout
-
View User Profile, Warehouses, Staff
-
View Orders, Shipments, Packages, Products
-
Track packages, Control bills
-
3 user types that are Admin, Staff and basic user
-
Add/Edit/Delete operations within your jurisdiction
Login page
Admin main page
Staff main page
User main page
User list
User profile
Packages list
Package Detail
Edit Product Quantity
Track a package and include all informations
The Online Warehousing Information System (OWIS), information about the warehousing environment including operations of the warehousing company with the incoming and outgoing packages, warehouses, suppliers, products and user information are stored. This system have 3 user types such as Admin, Staff and Basic user. Admin which has all permisions, is mainly responsible of maintaining the users, suppliers, warehouses, staff and products. Admin can any CRUD actions over any specific record. Admin users are the owners or the managers of the system. Users which have the user type '1' are the staff members. Staff members are responsible for the transactions on their specific warehouse. They can perform CRUD operations for incoming or outgoing transactions, but they are not authorized for any operation on any object else even including their own user account which is in responsibility of the admin users. The last user type, basic users, can only view the status of products, warehouses and transactions. Basic users can also track packages like other user types. In short, admin users are the responsible ones for the OWIS, staff members are the responsible ones for the warehouses with transactions and the basic users are only authorized for the monitoring operations.
System keeps track of the incoming or outgoing products with the products table where products’ information (name, description, image, manufacturer, weight) and current quantity is held. System also has the inventory table which is including only products those are in stock with their quantity. The source of products, suppliers, are also recorded in a table with their brand information (name, country, city) and contact information (address, phone number, e-mail). Whenever needed, product, inventory or the supplier information can be gathered via these tables.
Transactions between warehouses (incoming or outgoing) are made by orders(incoming) and shipments(outgoing). Each order or shipment has its own package, and every package has its own content that is kept within the package contents table with product’s quantities. These packages have related order or shipment ID, a bit value for package’s direction (0 for incoming and 1 for outgoing), supplier ID, created time information, package status (to inform user) and additional notes. Every transaction can have more than one package, but every package is belonging to only one transaction.
To keep the records of the payment operations, each order has a payment, and each shipment has a bill record. Payments keeps the record of money paid for orders and bills are the records of money paid to the company by shipments
For every package, there is the shipping record within the shipping table that is keeping the package’s ID, current location, status, shipping date, estimated delivery date (if exists), delivery date(if delivered) and shipping note if given. Package track requests will be satisfied by this table’s records.