How reyharold/order-reservation-and-tracking-for-rgo-bsu-lipa-campus works
SIA-FinalProj is a role-based Resource Generation Office portal for student merchandise ordering and staff order/inventory management, with administrative reporting. Students sign in, browse item variants, place orders, and review or cancel pending orders; staff register accounts, maintain the catalog, and update order status; administrators review received orders and generate reports. PHP pages perform the database queries directly, with shared connection and profile rendering. Paths and links reflect the supplied tree and sampled code; some routes are represented by their exact tree paths because their source was not sampled.
Main entry points: db_sm3101.sql RGO database · template.php Profile template · index.php Role login · item.php Catalog list
Components 19
Access and Profiles
- Role login
index.php - Profile template
template.php - DB connection
conn.php
Student Ordering
- Browse and order
Student/home.php - Place order
Student/placeorder.php - Order history
Student/history.php - Cancel order
Student/del.php
Staff Operations
- Order queue
Staff/home.php - Update status
Staff/edit.php - Register staff
Staff/register.php - Catalog list
Staff/item.php - Add catalog item
Staff/additem.php - Edit catalog item
Staff/updateitem.php - Delete catalog item
Staff/del.php
Administration
- Received orders
Admin/home.php - Order report
Admin/report.php - Item report
Admin/itemrep.php
Database
- RGO database
Database/db_sm3101.sql
Other components
- Portal user
Connections 37
- Portal user → Role login: submits credentials
- Role login → DB connection: includes
- Role login → RGO database: checks account
- Role login → Browse and order: routes student
- Role login → Order queue: routes staff
- Role login → Received orders: routes admin
- Browse and order → Profile template: includes profile
- Order queue → Profile template: includes profile
- Received orders → Profile template: includes profile
- Profile template → DB connection: includes
- Profile template → RGO database: reads profile
- Browse and order → RGO database: reads catalog and orders
- Browse and order → Place order: submits order
- Place order → DB connection: includes
- Place order → RGO database: creates pending order
- Order history → Profile template: includes profile
- Order history → RGO database: reads order history
- Order history → Cancel order: cancels pending order
- Cancel order → RGO database: updates order
- Order queue → RGO database: reads order queue
- Order queue → Update status: submits status change
- Update status → RGO database: updates order
- Order queue → Register staff: registers account
- Register staff → RGO database: writes account
- Catalog list → Profile template: includes profile
- Catalog list → RGO database: reads catalog
- Catalog list → Add catalog item: submits new item
- Catalog list → Edit catalog item: submits item changes
- Catalog list → Delete catalog item: deletes item
- Add catalog item → RGO database: writes catalog
- Edit catalog item → RGO database: updates catalog
- Delete catalog item → RGO database: deletes catalog item
- Received orders → RGO database: reads received orders
- Received orders → Order report: requests report
- Received orders → Item report: requests report
- Order report → RGO database: queries order data
- Item report → RGO database: queries catalog data