How wanwisa2548/purrpetcare-web works
PurrPet Care is a customer-facing pet hotel and grooming booking website with an admin operations area, backed by SQL Server. Customers register or sign in, manage pet profiles, check grooming prices and room/groomer availability, create bookings, and track their status. Admins manage bookings, grooming schedules, room turnover, payments, and dashboard information. The Express server serves the web pages and routes API requests; route handlers use a shared SQL access layer. README documents database features implemented in SQL scripts, but those scripts were not sampled, so their internal relationships are not expanded here.
Main entry points: server.js Express server · db.js SQL access layer · public Customer pages · common.js Shared UI helpers
Components 15
Web interface
- Customer pages
public - Login pages
public - Admin pages
public - Shared UI helpers
public/js/common.js
Web server
- Express server
src/server.js
Customer services
- Authentication
src/routes/auth.js - Catalog, pets, booking
src/routes/customer.js
Admin operations
- Admin endpoints
src/routes/admin.js
SQL data layer
- SQL access layer
src/db.js - Database schema
database/PurrPetCare_Phase1.sql - Views and procedures
database/PurrPetCare_Phase2.sql - Web login security
database/PurrPetCare_WebLogin.sql
Other components
- Customer
- Admin
- SQL Server
Connections 19
- Customer → Customer pages: uses
README.md - Customer → Login pages: signs in
README.md - Admin → Admin pages: uses
README.md - Customer pages → Shared UI helpers: uses
- Login pages → Shared UI helpers: uses
- Admin pages → Shared UI helpers: uses
- Customer pages → Express server: loads pages
src/server.js - Login pages → Express server: loads pages
src/server.js - Admin pages → Express server: loads pages
src/server.js - Express server → Authentication: mounts routes
src/server.js - Express server → Catalog, pets, booking: mounts routes
src/server.js - Express server → Admin endpoints: mounts routes
src/server.js - Authentication → SQL access layer: calls
src/routes/auth.js - Catalog, pets, booking → SQL access layer: calls
src/routes/customer.js - Admin endpoints → SQL access layer: calls
src/routes/admin.js - SQL access layer → SQL Server: connects
src/db.js - Database schema → SQL Server: defines schema
README.md - Views and procedures → SQL Server: defines data logic
README.md - Web login security → SQL Server: configures login
README.md