This is the package tracking system for RRG Freight Services—a logistics company from North Fairview, Quezon City.
This project is developed as a capstone project, in compliance with the requirements of CAP101 and CAP102 subject of the Bachelor of Science in Information Technology program of Quezon City University.
The driver app is available here.
- GPS-based location tracking and route optimization
- Delivery time estimation and precise location search
- Automatic load planning for delivery vehicles
- Optimized batching and dispatch of packages
- Capacity planning and monitoring for warehouses
- Automated status updates and reminders
- Secure sign in with biometrics and FIDO2 security keys
- React and Next.js with tRPC for frontend and backend
- Tailwind CSS for styling
- Lucia Auth for authentication
- Firebase for object storage
- PostgreSQL for the database
- Tanstack Query for caching
- Resend for email
- Web SMS Sender for SMS
- AWS SQS and AWS Lambda for queueing
- Google Maps API for location search and estimations
This project requires at least Node.js v20 to be installed and uses pnpm for package management.
You will need a running PostgreSQL database and a Firebase project with Cloud Storage configured for object storage.
Take the following steps to setup this project:
- Clone this repository.
$ git clone https://github.com/arvl130/rrg-freight-services-web.git- Install the project dependencies.
$ cd rrg-freight-services-web
$ pnpm install- Setup the API keys and database secrets.
$ cp .env.template .env
$ vi .env # type :wq! to exit-
Obtain a copy of the seed script and save it as
db-seed.tsin thescriptsfolder. -
Push the schema to the database and run the seeder.
$ pnpm db:pushThis command may fail if your database has existing tables.
- Run the project.
$ pnpm dev- Build for production. (optional)
$ pnpm buildThis project is licensed under the MIT License.
Copyright © 2023 Angelo Geulin, Wally Boy Gaynor, Arlene Joy Nacion, Florence Gobilab, Rommel Rivera