The Complete QR-Based Asset Tracking Solution for Modern Fleet Operations
EquipQR is a comprehensive fleet equipment management platform that revolutionizes how organizations track, maintain, and collaborate on equipment across teams and locations. Built with enterprise-grade security and designed for cross-organizational workflows, EquipQR delivers powerful asset management capabilities through an intuitive, mobile-first interface.
🎯 Serving Equipment-Heavy Industries Across Texas and Beyond
Headquartered in Giddings, TX • Trusted by Construction, Fleet Management, and Logistics Companies
Before setting up EquipQR for development, ensure you have:
- Node.js (version 18 or higher)
- npm or yarn package manager
- Git for version control
- Supabase Account (free tier available at supabase.com)
- Stripe Account (for billing features - stripe.com)
- Mapbox Account (for map features - mapbox.com)
# Clone the repository
git clone <repository-url>
cd equipqr
# Install dependencies
npm install# Copy the example environment file
cp .env.example .env.local
# Edit .env.local with your actual values
# See detailed configuration guide belowCreate a Supabase Project:
- Go to supabase.com/dashboard
- Click "New Project"
- Choose your organization and create the project
- Wait for the project to be ready (usually 2-3 minutes)
Get Your Supabase Credentials:
- In your Supabase dashboard, go to Settings > API
- Copy your Project URL and anon public key
- Update
.env.localwith these values:VITE_SUPABASE_URL=https://your-project-ref.supabase.co VITE_SUPABASE_ANON_KEY=your_anon_key_here
Update Hardcoded Project References: The current codebase has hardcoded Supabase project references that need to be updated:
-
Update
src/integrations/supabase/client.ts:const SUPABASE_URL = "https://your-project-ref.supabase.co"; const SUPABASE_PUBLISHABLE_KEY = "your_anon_key_here";
-
Update
src/utils/auth/authUtils.ts:const supabaseUrl = "https://your-project-ref.supabase.co";
Configure Authentication:
- In Supabase dashboard, go to Authentication > Providers
- Enable Email provider (enabled by default)
- Enable Google provider:
- Add your Google OAuth client ID and secret
- Add authorized redirect URIs:
https://your-project-ref.supabase.co/auth/v1/callback
Set Up Edge Function Secrets:
- Go to Edge Functions > Manage secrets in your Supabase dashboard
- Add the following secrets:
STRIPE_SECRET_KEY: Your Stripe secret key (sk_test_... for development)MAPBOX_ACCESS_TOKEN: Your Mapbox secret access tokenOPENAI_API_KEY: Your OpenAI API key (if using AI features)
- Create a Stripe account at stripe.com
- Get your API keys from the Stripe Dashboard
- For development, use test keys (they start with
pk_test_andsk_test_) - Update
.env.local:VITE_STRIPE_PUBLISHABLE_KEY=pk_test_your_publishable_key_here
- Add your secret key to Supabase Edge Function secrets (see above)
- Create a Mapbox account at mapbox.com
- Get your access token from account.mapbox.com/access-tokens
- Update
.env.local:VITE_MAPBOX_ACCESS_TOKEN=pk.your_mapbox_token_here
The database schema is automatically applied when you connect to Supabase through the Lovable interface. If you're setting up manually:
- The migration files are in
supabase/migrations/ - Apply them using the Supabase CLI or dashboard
- Ensure Row Level Security (RLS) policies are enabled
# Start the development server
npm run dev
# The app will be available at http://localhost:5173Your .env.local file should look like this:
# Supabase
VITE_SUPABASE_URL=https://your-project-ref.supabase.co
VITE_SUPABASE_ANON_KEY=your_supabase_anon_key
# Stripe
VITE_STRIPE_PUBLISHABLE_KEY=pk_test_your_stripe_key
# Mapbox
VITE_MAPBOX_ACCESS_TOKEN=pk.your_mapbox_token
# Application URLs
VITE_APP_BASE_URL=http://localhost:5173
VITE_SITE_URL=http://localhost:5173
# Development
NODE_ENV=development
VITE_DEBUG=true"Invalid JWT" or Authentication Errors:
- Verify your Supabase URL and anon key are correct
- Check that the hardcoded values in the codebase match your project
- Ensure authentication providers are properly configured
Map Not Loading:
- Verify your Mapbox access token is valid
- Check browser console for CORS or network errors
- Ensure the token has the required scopes
Billing Features Not Working:
- Confirm Stripe publishable key is correct (starts with
pk_test_for development) - Verify Stripe secret key is added to Supabase Edge Function secrets
- Check Stripe webhook configuration if testing subscriptions
Database Connection Issues:
- Ensure your Supabase project is active and not paused
- Check Row Level Security policies are properly configured
- Verify database migrations have been applied
- Use Browser D ED4F evTools: Check the Console and Network tabs for errors
- Supabase Logs: Monitor real-time logs in your Supabase dashboard
- Edge Function Logs: Check Edge Function logs for backend errors
- Test with Different Browsers: Some features may behave differently across browsers
Environment Variables:
- Use production/live API keys instead of test keys
- Update
VITE_APP_BASE_URLto your production domain - Set
NODE_ENV=production
Supabase Production:
- Enable database backups
- Configure proper RLS policies
- Set up monitoring and alerts
- Review and tighten security settings
Domain Configuration:
- Configure custom domains in Supabase
- Update OAuth provider redirect URLs
- Set up SSL certificates
- Configure CORS settings
Performance:
- Enable Supabase CDN
- Configure caching strategies
- Optimize database queries
- Set up monitoring
- Supabase Documentation
- Stripe API Documentation
- Mapbox GL JS Documentation
- React Query Documentation
- Dynamic QR Code Generation: Automatically generate unique QR codes for every asset with embedded metadata
- Enhanced Scan Tracking: Real-time location capture with GPS coordinates, accuracy metrics, and timestamp logging
- Scan History Analytics: Complete audit trail of equipment interactions with geographic visualization
- Mobile-Optimized Scanning: Camera integration for instant equipment identification and status updates
- Comprehensive Asset Records: Track specifications, installation dates, warranty periods, serial numbers, and custom attributes
- Smart Equipment Duplication: One-click equipment cloning with automatic naming conventions and attribute inheritance
- Custom Attribute System: Flexible metadata fields for industry-specific equipment characteristics
- Multi-View Interface: Toggle between detailed list view and visual card layout for optimal data consumption
- Intelligent Filtering: Advanced search across all fields with status, team, and organization filters
- Structured Work Order Workflow: Submit → Accept → Assign → Complete with full status tracking
- Role-Based Work Order Management: Differentiated permissions for requestors, technicians, and managers
- Integrated Work Notes: Link maintenance notes directly to specific work orders for complete service history
- Time Tracking Integration: Automatic hours calculation from linked work notes for accurate billing and reporting
- Work Order Analytics: Performance metrics and completion tracking across teams and equipment
- Immutable Maintenance Records: Technician-submitted notes with non-repudiation for regulatory compliance
- Dual Visibility System: Public notes for team collaboration, private notes for sensitive information
- Role-Aware Note Management: Permissions-based note creation, viewing, and editing capabilities
- Hours Tracking Integration: Built-in time logging for maintenance activities and service calls
- Maintenance History: Complete chronological record of all equipment service activities
- Multi-Source Location Tracking: Manual location entry, GPS-based scanning, and coordinate-based positioning
- Location Override System: Toggle between automatic scan-based updates and manual location control
- Fleet Mapping Dashboard: Interactive map visualization of equipment locations with real-time updates
- Geographic Analytics: Location-based reporting and equipment distribution insights
- Accuracy Metrics: GPS precision tracking for reliable location data
- Cross-Organizational Collaboration: Invite members from external organizations while maintaining strict ownership boundaries
- Hierarchical Role System: Owner → Manager → Technician → Requestor → Viewer with granular permissions
- Team-Based Equipment Assignment: Flexible equipment-to-team relationships with automatic access inheritance
- Organization Ownership Model: Clear equipment ownership with delegation capabilities through team assignments
- Advanced Invitation System: Email-based invitations with role-specific onboarding workflows
- React 18 with TypeScript for type-safe, scalable development
- Vite for lightning-fast development and optimized production builds
- Tailwind CSS with shadcn/ui for consistent, accessible design system
- React Query (TanStack Query) for intelligent data fetching, caching, and synchronization
- React Hook Form with Zod validation for robust form management
- React Router for seamless client-side navigation
- Supabase backend-as-a-service with PostgreSQL database
- Row Level Security (RLS) for data protection and multi-tenancy
- Edge Functions for serverless API endpoints and business logic
- Real-time Subscriptions for live data updates across teams
- Advanced Query Optimization with intelligent caching strategies
- Progressive Web App (PWA) capabilities for offline functionality
- Responsive Design optimized for desktop, tablet, and mobile workflows
- Camera Integration for QR code scanning and equipment photography
- Touch-Friendly Interface designed for field technician workflows
- Offline Capabilities for critical operations in low-connectivity environments
- Google OAuth with multi-factor authentication support
- CSV Export/Import for data migration and reporting
- RESTful APIs for third-party system integration
- Audit Logging for compliance and regulatory requirements
- Backup & Recovery with point-in-time restoration capabilities
- Vehicle Maintenance Coordination: Track service schedules across multiple service teams and locations
- Equipment Assignment Optimization: Manage tool and equipment distribution between job sites
- Regulatory Compliance: Maintain DOT logs and inspection records with immutable audit trails
- Cross-Location Collaboration: Coordinate equipment sharing between facilities and service centers
- Job Site Equipment Management: Monitor tool inventory and equipment status across active projects
- Maintenance Schedule Coordination: Proactive equipment servicing with team-based responsibility assignment
- Safety Compliance Tracking: Equipment inspection records and safety certification management
- Project-Based Equipment Allocation: Dynamic equipment assignment based on project requirements
- Building Systems Management: Track HVAC, electrical, and mechanical equipment across properties
- Maintenance Team Coordination: Assign equipment responsibility to specialized maintenance teams
- Warranty & Service Contract Tracking: Monitor equipment warranties and service agreement compliance
- Vendor Management: Coordinate external service providers with internal maintenance teams
- Rental Fleet Tracking: Monitor equipment location, condition, and availability in real-time
- Customer Equipment Assignment: Track which equipment is assigned to specific rental customers
- Maintenance Scheduling: Coordinate equipment servicing between rental periods
- Multi-Location Inventory: Manage equipment across multiple rental locations and service centers
- Complete Platform Control: Full access to organization settings, billing, and member management
- Equipment Ownership: Create, modify, and delete any equipment within the organization
- Team Management: Create teams, assign managers, and oversee cross-organizational collaborations
- Data Export & Analytics: Access to comprehensive reporting and data export capabilities
- Team Leadership: Create teams, invite members, and manage team-specific equipment assignments
- Equipment Assignment: Assign organization equipment to teams and manage team-based access
- Work Order Management: Accept, assign, and track work orders for team-assigned equipment
- Member Coordination: Manage team member roles and responsibilities within assigned teams
- Comprehensive Equipment Access: View all equipment details and complete maintenance history
- Work Note Management: Create both public and private maintenance notes with time tracking
- Work Order Execution: Accept assigned work orders and update completion status
- Mobile-First Workflow: Optimized mobile interface for field-based equipment management
- Work Order Submission: Submit maintenance requests and track work order progress
- Public Communication: Create public work notes visible to entire maintenance team
- Equipment Monitoring: View equipment status and public maintenance history
- Limited Write Access: Focus on reporting issues rather than performing maintenance
- Read-Only Access: View equipment details and public maintenance records
- Reporting Capabilities: Generate reports and export data for analysis
- Dashboard Access: Monitor team equipment status and maintenance trends
- No Modification Rights: Cannot create, edit, or delete equipment or maintenance records
- Asset Registration: Create equipment records with comprehensive metadata and custom attributes
- QR Code Generation: Generate and print QR codes for physical asset tagging
- Team Assignment: Assign equipment to appropriate teams based on location or function
- Ongoing Maintenance: Track service history through work orders and maintenance notes
- Lifecycle Analytics: Monitor equipment performance, maintenance costs, and replacement timing
- Issue Identification: Requestors submit work orders for equipment requiring attention
- Work Assignment: Managers review, accept, and assign work orders to qualified technicians
- Service Execution: Technicians complete work and document activities through integrated work notes
- Quality Assurance: Managers review completed work and update equipment status
- Performance Analysis: Track team performance, maintenance costs, and equipment reliability
- Partnership Setup: Organizations invite external teams to collaborate on shared equipment
- Role Assignment: External team members receive appropriate roles based on collaboration scope
- Equipment Access: External teams gain access to specifically assigned equipment only
- Boundary Maintenance: Ownership boundaries remain intact while enabling collaboration
- Audit & Compliance: Complete audit trail maintained across organizational boundaries
- Multi-Tenant Architecture: Organization-scoped data with cross-organizational team capabilities
- Immutable Audit Trails: Non-repudiation maintenance records for regulatory compliance
- Flexible Attribute System: Custom metadata support for industry-specific equipment characteristics
- Optimized Query Performance: Strategic indexing and caching for real-time data access
- Row Level Security (RLS): Database-level access control preventing unauthorized data access
- JWT Authentication: Secure session management with refresh token rotation
- Cross-Site Protection: CSRF protection and input validation throughout the platform
- Audit Logging: Comprehensive activity logging for compliance and security monitoring
- Intelligent Caching: Multi-layer caching strategy with automatic cache invalidation
- Optimized Database Queries: Strategic query optimization for large equipment datasets
- Edge Function Processing: Serverless architecture for scalable business logic execution
- Real-Time Updates: Efficient WebSocket connections for live data synchronization
- Equipment Utilization Metrics: Track equipment usage patterns and optimization opportunities
- Maintenance Cost Analysis: Monitor maintenance expenses across teams and equipment categories
- Team Performance Dashboards: Analyze team productivity and work order completion rates
- Predictive Maintenance Insights: Identify equipment requiring proactive maintenance attention
- CSV Data Exchange: Import/export equipment data for integration with existing systems
- RESTful API Access: Programmatic access for custom integrations and reporting tools
- Webhook Support: Real-time notifications for external system synchronization
- Third-Party Authentication: Support for enterprise SSO and directory integration
- Offline Functionality: Core operations available without internet connectivity
- Camera Integration: Direct QR code scanning and equipment photography
- GPS Location Services: Automatic location capture during equipment interactions
- Touch-Optimized Interface: Designed specifically for mobile field operations
Transforming Equipment Management for Texas Businesses and Beyond
EquipQR was specifically designed for equipment-heavy industries across Texas, with deep roots in Giddings, TX. Our platform addresses the unique challenges faced by construction, fleet management, and logistics companies operating across multiple locations with diverse teams.
Our Mission: Simplify complex equipment management workflows while maintaining enterprise-grade security and compliance standards.
Core Values:
- Simplicity: Complex operations made simple through intuitive design
- Security: Enterprise-grade security without compromising usability
- Collaboration: Breaking down silos while maintaining organizational boundaries
- Compliance: Built-in audit trails and regulatory compliance features
Geographic Focus: Giddings, TX and broader Texas region
Target Industries: Fleet management, construction, facilities management, and logistics
Platform Version: v2.0 - Advanced Fleet Management Edition
- Comprehensive User Guides: Step-by-step documentation for all platform features
- API Documentation: Complete reference for developers and integrators
- Video Training Library: Visual tutorials for common workflows and advanced features
- Best Practices Guide: Indus 1E79 try-specific recommendations for optimal platform usage
- GitHub Issues: Bug reports, feature requests, and community discussions
- Email Support: Direct support for technical assistance and platform guidance
- Training Services: Custom onboarding and training for enterprise customers
- Integration Consulting: Professional services for complex deployment scenarios
- Priority Support: Dedicated support channels for business customers
- Custom Development: Tailored features and integrations for enterprise requirements
- Training & Onboarding: Comprehensive team training and change management support
- Compliance Consulting: Regulatory compliance guidance and audit preparation
This project is built with modern web technologies and follows industry-standard security practices. Detailed licensing information and terms of service are available in the project settings.
Data Protection: GDPR-compliant data handling with user control over personal information
Security Standards: SOC 2 Type II compliance with regular security audits
Availability: 99.9% uptime SLA with redundant infrastructure and disaster recovery
Built with ❤️ using Lovable - The AI-powered web application development platform
EquipQR v2.0 - Advanced Fleet Equipment Management Platform
Empowering Texas businesses with intelligent asset tracking and collaborative maintenance workflows