Awada Printing Services is a personal freelance project designed as a web-based business management system for small and medium printing businesses.
The application focuses on handling core operational workflows, including inventory, orders, deliveries, clients, and financial tracking.
This project represents my first real-world application built with a PHP REST API backend, a React frontend, and PostgreSQL as the database engine.
The goal is to design a clean, scalable, and maintainable system that reflects real business requirements rather than academic examples.
- Frontend: React
- Backend: PHP (RESTful API)
- Database: PostgreSQL
- API Communication: Axios
- Architecture: Modular, API-driven system
The system is designed around real printing business workflows, focusing on accuracy, traceability, and structured data management.
It supports:
- Inventory and stock lifecycle tracking
- Order-based production management
- Client and supplier relationships
- Financial visibility and reporting
- Purchase registration and stock updates
- Component-based product building
- Waste tracking and stock adjustments
- Reserved vs available quantity tracking
- Sales order creation
- Invoice generation
- Order status tracking (pending, confirmed, in production, delivered)
- Delivery note management
- Client account management
- Credit tracking for B2B clients
- Supplier management and outstanding debts tracking
- Detailed cost tracking (labor, utilities, expenses)
- Third-party cost management (e.g. tailoring, ironing)
- Clear financial results and reporting
- B2B order-for-order management
- Structured workflow from purchase → production → delivery
This application is currently designed as a local-host, offline system intended for internal business use.
- Simple authentication is implemented for access control
- No advanced security mechanisms (encryption, token-based auth, or hardening) are included
- The system is not production-hardened and is not exposed to the public internet
Security enhancements and production deployment considerations are planned for future iterations.
This project is actively evolving and developed incrementally.
- 🗄️ Database schema design — Completed
- 🔧 Backend REST API development — In Progress
- 💻 Frontend interface development — Planned
- RESTful API design using PHP
- Clean separation between frontend and backend
- Relational database modeling with PostgreSQL
- Real-world business logic implementation
- Scalable and maintainable system architecture