Laundry Management System Project with Online Booking, Pickup Scheduling and Rate Cards

The Laundry Management System Project with Online Booking, Pickup Scheduling and Rate Cards is a full-stack web application that moves a local laundry's workflow — price list, booking, pickups, order tracking — onto one website. Built with PHP and MySQL, it gives customers a storefront with a transparent digital rate card, and gives the shop owner an admin panel that turns bookings into scheduled pickups and settled orders. Most small laundries run on phone calls and WhatsApp: prices live in the owner's head, orders go in a notebook, and customers keep calling to ask where their clothes are. That breaks three ways: disputed bills, missed pickups promised from memory, and dead time answering status calls. One system fixes this: the rate card becomes one editable table, slots become a capacity-capped calendar, and every order gets a timestamped status log the customer watches. For a student it is a complete CRUD-plus-roles project: auth, sessions, relational data, slot logic, reporting dashboard.

A customer opens the FreshFold storefront, adds rate-card services to a basket, chooses a pickup day and one of four two-hour slots, then enters name, phone and address. Confirming writes one orders row plus one row per basket item, generates an order ID like FF-2026-1042, and reserves one of the slot's six pickup seats. The admin sees the booking instantly, plans the rider's route from the schedule view, and advances the status as clothes move through the shop — each change appending a timestamped entry to the status log. The customer watches the same log on the tracking page, so "is my order ready?" answers itself. At day end, the revenue view sums the orders table into daily totals and category shares with SQL GROUP BY queries. Builder note from the demo build: statuses are stored as an append-only log of {status, timestamp} pairs, not a single status column — that one decision makes the tracking timeline replayable.

1. The customer browses the 24-service rate card and adds items to the basket; the running total updates per item.
2. The customer picks a pickup day from the 7-day window and a two-hour slot; slots already at 6 bookings show as full and cannot be selected.
3. Checkout captures name, phone, address and locality; the validated booking is written to the orders and order_items tables with a generated order ID.
4. The admin dashboard lists the new order immediately; the pickup schedule view shows it against its slot with remaining capacity.
5. As garments move through the shop, the admin advances the status — Booked, Picked Up, In Wash, Ironing, Ready, Out for Delivery, Delivered — and each transition appends a timestamped log entry.
6. The customer tracking page replays the log as a timeline, and the revenue view aggregates orders into daily and category totals.

Tech stack:

• PHP 8 (backend logic, session auth, routing)
• MySQL 8 (orders, items, users, status-log tables)
• HTML5 · CSS3 (responsive storefront and dashboard)
• JavaScript ES6 (basket, slot picker, canvas charts)
• Apache · XAMPP (local development stack)
• bcrypt password hashing
• phpMyAdmin (database administration)
• Git (version control)

The system's strongest capabilities are its digital rate card, its slot-based pickup scheduling, its live order tracking, and its admin revenue view — four pieces covering the whole laundry workflow from first click to final delivery. The rate card lists every service with per-item rupee prices across five categories; the admin edits any price in one table with instant effect on the storefront. Pickup scheduling replaces phone haggling with a seven-day calendar of two-hour slots, each capped at six pickups so the rider's route stays realistic and overbooking is impossible. Order tracking gives every booking a timestamped journey — Booked, Picked Up, In Wash, Ironing, Ready, Out for Delivery, Delivered — visible to the customer and advanced from the admin panel. The revenue view aggregates the same orders table into daily totals and category shares, showing the owner exactly which services earn.

• [Digital rate card] Implemented. 24 services across 5 categories with per-item INR prices — the demo build's exact count. Customers add services to a basket like a shop cart; the admin edits any price in one table and the storefront updates immediately.
• [Pickup slot scheduling] Implemented. A seven-day calendar with four daily two-hour slots, each capped at 6 pickups. Slots that reach capacity are hidden from customers automatically, so the rider is never double-booked.
• [Live order tracking] Implemented. Every order carries an immutable, timestamped status log across seven stages. The customer page replays the journey as a timeline; status changes made in admin appear with exact times.
• [Admin dashboard] Implemented. One screen with the orders table and status control, a 3-day pickup schedule with booked-vs-capacity bars, revenue analytics (7-day bar chart plus category-share donut) computed live from the orders table, and the rate-card editor.
• [Role-based access] Implemented. Separate customer and admin logins over PHP sessions; admin routes are guarded server-side so the dashboard and rate-card editor are unreachable without an admin login.
• [Checkout with address capture] Implemented. Each booking captures name, phone, address and locality, giving the pickup rider a complete route sheet. Validation blocks empty baskets, unselected slots and missing contact details before an order is written.
• [Configurable pricing and slots] Configurable. Prices, slot count, slot timings and per-slot capacity are admin settings, not code changes — the demo's 6-pickup cap is a single editable value.
• [Multi-branch support] Future scope. The schema is single-shop: one rate card, one slot calendar. Branch-level logins and per-branch reporting are a documented extension, not part of the current build.

• Complete PHP/MySQL source code (customer storefront + admin dashboard)
• Database schema with seed data (24-service rate card, slots, demo orders)
• Step-by-step setup guide (XAMPP to live host)
• The working single-file demo used for the screenshots
• Project report PDF (background, methodology, schema design, testing)
• PPT presentation for final review
• Viva Q&A preparation document (sessions, SQL joins, slot-capacity logic, password hashing)