🏷️ Asset Tracking Webhook

A comprehensive PHP webhook for tracking corporate assets and equipment through QR code scanning.

PHP SQLite Portable
Configure Webhook Full Documentation

Key Features

  • Asset Registration - Complete asset database with detailed information
  • Check-in/Check-out - Track who has what equipment and when
  • Location Tracking - Monitor asset locations across buildings and rooms
  • Maintenance Scheduling - Track maintenance due dates and alerts
  • Asset History - Complete audit trail of all asset activities
  • Status Management - Available, checked out, maintenance, retired states
  • Condition Tracking - Monitor asset condition ratings
  • Portable Database - Uses SQLite for easy deployment

Asset Status Types

🟢 Available

Asset is ready for use, can be checked out, located at designated spot.

🟡 Checked Out

Asset is assigned to a user, shows who has it and since when.

🔧 In Maintenance

Asset is being serviced, not available for checkout.

🔴 Retired

Asset is no longer in service, kept for historical records.

❌ Lost/Missing

Asset cannot be located, requires investigation.

Usage Examples

🟢 Available Asset

When scanning an available asset:

🏷️ Dell Latitude 7420 📋 ID: LAPTOP001 🏢 Category: Computers 📍 Location: IT Department 📊 Status: Available 🟢 ⏰ Updated: Dec 15, 2024 14:30

🟡 Checked Out Asset

For assets currently in use:

🏷️ Samsung 27" Monitor 📋 ID: MONITOR002 🏢 Category: Monitors 📍 Location: Office Floor 1 📊 Status: Checked Out 🟡 👤 Checked out to: John Smith 📅 Since: Dec 10, 2024 ⏰ Updated: Dec 15, 2024 09:15

🔧 Maintenance Due

For assets requiring maintenance:

🏷️ Cordless Drill 📋 ID: DRILL004 🏢 Category: Tools 📍 Location: Warehouse 📊 Status: In Maintenance 🔧 🔧 Maintenance due: Dec 20, 2024 (5 days) ⏰ Updated: Dec 15, 2024 11:45

Quick Start

1. Setup

# Ensure PHP SQLite extension is enabled php -m | grep sqlite # Upload asset-tracking-webhook.php to your web server # The database will be created automatically on first run

2. Configure AllCodeRelay

Use the configuration tool to generate a QR code with your webhook URL:

http://your-server/path/to/asset-tracking-webhook.php

3. Start Scanning

Scan asset QR codes to get instant information about:

Note: The system includes sample data for immediate testing. No database setup required!

Database Schema

Assets Table
  • asset_code - Unique asset identifier (QR code content)
  • name - Asset name/description
  • category_id - Asset category
  • serial_number - Manufacturer serial number
  • current_location_id - Current location
  • status - Current status
  • checked_out_to - User who has the asset
Supporting Tables
  • Categories - Asset categorization (Computers, Tools, etc.)
  • Locations - Physical locations with building/floor/room
  • Users - Employee information
  • Asset Logs - Complete activity history

Sample Assets Included

Test Asset Codes
  • LAPTOP001 - Dell Latitude 7420 (Checked out)
  • MONITOR002 - Samsung 27" Monitor (Available)
  • DESK003 - Standing Desk (Available)
More Test Codes
  • DRILL004 - Cordless Drill (Maintenance)
  • VAN005 - Delivery Van (Available)
  • Plus categories, locations, and users

Files Included

Core Files
  • asset-tracking-webhook.php - Main webhook script
  • asset-tracking-README.md - Complete documentation
Features
  • SQLite database (auto-created)
  • Sample data included
  • Complete error handling
  • Production-ready code

Get Started

Ready to implement asset tracking with AllCodeRelay?

Download Webhook Script View Full Documentation
Back to Gallery Main Site