🚚 Package Tracking System for RRG Freight Services

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.

Features

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

Tech Stack

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

Setup

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.ts in the scripts folder.
Push the schema to the database and run the seeder.

$ pnpm db:push

This command may fail if your database has existing tables.

Run the project.

$ pnpm dev

Build for production. (optional)

$ pnpm build

License

This project is licensed under the MIT License.