AssetTracker - Physical Asset Management System

A modern, responsive web application for tracking personal or organizational assets with QR scanning, lending management, and role-based administration.

🌟 Project Title & One-Line Pitch

"AssetTracker - Physical Asset Management System"

A modern, responsive web application for tracking personal or organizational assets with QR scanning, lending management, and role-based administration.

🚀 Key Features

• Dual-Role Authentication:
  • Secure Email/Password Login (JWT).
  • OAuth Integration (Google & Microsoft).
  • Split Login Flow: Dedicated "Admin Login" vs. "Standard Sign In".
• Admin Dashboard:
  • Visual statistics (Total Users, Items, Value).
  • User Management Table (View all users, Delete users).
  • Role-based route protection (RequireAdmin).
• Asset Management:
  • Create, Read, Update, Delete (CRUD) items.
  • Organize items by Locations.
  • Search & Filter functionality.
• Advanced Tools:
  • QR Code/Barcode Scanning (for quick lookup).
  • Lending System (Track borrowed/lent items).
  • PayPal Integration (for payments/subscriptions).
  • Dark Mode support.

🛠️ Tech Stack

• Frontend: React, Vite, Tailwind CSS, Lucide React (Icons), React Router v6.
• Backend: Node.js, Express, Sequelize ORM.
• Database: PostgreSQL.
• Security: BCrypt (hashing), JWT (tokens), CORS.

📦 Installation & Setup

Prerequisites

• Node.js (v16 or higher)
• PostgreSQL installed and running
• Git

1. Cloning the Repo

git clone https://github.com/yangpeisen/asset-tracker.git
cd asset-tracker

2. Database Setup

1. Open your PostgreSQL tool (e.g., pgAdmin or command line).
2. Create a new database named asset_tracker.

CREATE DATABASE asset_tracker;

3. Backend Setup

Navigate to the backend directory and install dependencies:

cd backend
npm install

Create a .env file in the backend directory based on the template below:

# Server Configuration
PORT=5002
NODE_ENV=development

# Database Configuration
DB_HOST=localhost
DB_PORT=5432
DB_NAME=asset_tracker
DB_USER=postgres
DB_PASSWORD=your_password_here

# JWT Configuration
JWT_SECRET=your_super_secret_jwt_key
JWT_EXPIRES_IN=7d

# OAuth Configuration (Optional)
GOOGLE_CLIENT_ID=your_google_client_id
GOOGLE_CLIENT_SECRET=your_google_client_secret
MICROSOFT_CLIENT_ID=your_microsoft_client_id
MICROSOFT_CLIENT_SECRET=your_microsoft_client_secret

# CORS Configuration
FRONTEND_URL=http://localhost:5173

Run database migrations (if applicable) or start the server to sync models:

npm run migrate
# OR
npm run dev

4. Frontend Setup

Open a new terminal, navigate to the project root (frontend), and install dependencies:

cd ..
# or cd asset-tracker if opening a new terminal
npm install

Create a .env.local file in the root directory if needed (for frontend-specific vars):

VITE_API_URL=http://localhost:5002/api

Start the frontend development server:

npm run dev

5. Running the App

• Backend: Runs on http://localhost:5002
• Frontend: Runs on http://localhost:5173

Access the application at http://localhost:5173.

📸 Screenshots

Login Screen

Home Screen

Item Screen

Lending Screen

Profile Screen

Dark Mode Screen

📞 Contact

• Developer: Yang Peisen
• Email: [email protected]
• GitHub: Yang Peisen