📊 Why Choose Our Solution?

Stop losing time with manual registers, Excel sheets, and paper-based tracking. Our system eliminates errors, saves hours of work daily, and ensures you never miss a critical expiry date or calibration deadline.

❌ Manual Tracking Nightmares

Searching through paper registers, Excel files scattered across computers, samples getting lost or expired without warning.

❌ Audit Failures

Missing documentation, incomplete history, unable to prove who took what sample when - resulting in audit findings.

❌ Equipment Downtime

Missed calibration dates causing production stops, regulatory non-compliance, and costly emergency calibrations.

✓ Instant Sample Tracking

Scan QR codes to find any sample in seconds. Real-time location tracking, automatic expiry alerts, complete transaction history.

✓ 100% Audit Ready

Every action logged automatically with timestamp, user name, and complete details. Generate reports in seconds.

✓ Never Miss Deadlines

Automatic alerts for expiring samples and calibration due dates. Color-coded visual indicators - see critical items instantly.

• Windows 10 or higher
• MariaDB 10.x or MySQL 8.x
• At least 8 GB RAM
• 500 MB free disk space
• Modern web browser (Chrome, Edge, Firefox)

Ready to Transform Your QC Operations?

Stop wasting hours on manual tracking. Start saving time, money, and eliminate errors from day one.

📧 Get in Touch

🚀 Version 1.1.4 (Current Release)

Release Date: December 5, 2024

New Features:

• Equipment Status Management: Track equipment operational state
  • Two status types: 🔴 Not in Use | 🟠 Gone for Calibration
  • Automatic timestamp capture when status is changed
  • Status date display in Edit modal showing when status was last set
  • Smart status display: Shows equipment status OR calibration alert (not both)
  • Clean single-line status column for better UI/UX
• Forgot Password System: Complete OTP-based password reset via email
  • Three-step reset flow: Email → OTP Verification → New Password
  • 6-digit OTP sent to registered email with 10-minute expiration
  • Rate limiting: 3 requests per hour, 5 verification attempts
  • Professional HTML email template with company branding
  • SMTP integration with Hostinger email server
• Dark Theme UI: Modern dark interface for login and password reset
  • Dark background (#2b2b2b) with dark gray containers (#4a4a4a)
  • White Starengts logo (70% container width)
  • Green accent color (#32c800) for buttons and links
  • Dark input fields with green focus states
  • Fully responsive design for desktop, tablet, and mobile
• Permanent Auto-Fill for User Name Fields: All "By" fields automatically populate with logged-in user's name
• Multi-Trigger Auto-Fill: Works on page load, section navigation, and field focus
• Calibration Document Upload: Server configuration for PDF uploads (up to 10MB)
• HTTPS Server Support: Dual HTTP/HTTPS server configuration with SSL certificates

Improvements:

• Simplified status column display - shows only one status at a time for cleaner interface
• Enhanced Edit modal with status date tracking and orange-themed display
• Enhanced login page with modern dark theme and improved UX
• Better mobile responsiveness with proper margins (80% width on mobile)
• Improved input field styling with consistent dark backgrounds
• User name fields persist after form submission
• Enhanced workflow efficiency across all QC sections
• Professional email notifications for password reset

Security Enhancements:

• OTP-based password reset with expiration and attempt limits
• Rate limiting to prevent abuse (3 requests/hour)
• Secure password hashing with bcrypt (10 rounds)
• HTTPS support for encrypted connections
• Session-based OTP verification

Bug Fixes:

• Fixed calibration update history 404 error by reordering API routes
• Fixed calibration_updates INSERT error with automatic updateID generation
• Corrected equipment status date tracking with conditional SQL queries
• Fixed calibration dates calculation issue
• Corrected number of days remaining calculation for equipment calibration
• Fixed modal positioning on mobile devices
• Resolved input field autofill background color issues

Database Schema Updates:

• New Columns Added to equipment_calibrations table:
  • location - Physical location of equipment (e.g., Lab Room A, Storage Area B)
  • verification_method_accuracy - Description of verification method used for calibration
  • certification - Certification status (Yes/No/N/A)
  • equipment_status_date - Automatic timestamp tracking for equipment status changes

Technical Updates:

• Implemented conditional SQL queries for status date management
• Fixed Express route order: /updates endpoint now before /:id parameter route
• Automatic updateID generation using timestamp + random string pattern
• Enhanced Edit modal with 4 new fields for better equipment tracking
• Added nodemailer package (v7.0.10) for email functionality
• Implemented in-memory OTP storage with automatic cleanup
• Generated self-signed SSL certificates for HTTPS
• API endpoints: /api/forgot-password, /api/verify-otp, /api/reset-password
• Enhanced CSS with dark theme variables and responsive breakpoints

✨ Version 1.1.3 (Previous Release)

Release Date: November 2025

Major Updates:

• Database Backend: Migrated from Excel to MariaDB/MySQL for improved reliability and concurrent access
• Multi-User Authentication: Secure login system with role-based access control
• Visual Status System: Color-coded icons (Critical=Purple, Warning=Orange, Caution=Yellow, Expired=Red, Safe=Green)
• Enhanced UI: Compact legends, mobile-responsive design, status icons in all tables
• Thermal Printer: Fixed duplicate printing, automatic 90° rotation for 52mm printers
• Scrapped Material Tracking: Separate counting and display of scrapped batches
• User Profile: Display actual user information with login timestamp
• Data Visualization: Fixed sidebar overlap issue on charts page

Bug Fixes:

• Fixed database "updateID missing" error in expiry_updates table
• Corrected API to include scrapped samples in summary counts
• Resolved login window width issue on iPhone/mobile devices
• Fixed user profile modal showing "Guest" instead of actual user data

📦 Version 1.1.2 (Previous Release)

Release Date: April 2025

Features:

• Equipment Calibration Management with QR codes
• Bin-to-Bin Transfer functionality
• Excel-based local storage
• QR code label generation
• Basic transaction history and logging
• Data visualization with charts

🏢 Developed by Starengts

QC Sample & Equipment's Calibration Management System | Version 1.1.4