Overview

Version 4.0 marks a major milestone for JustSale POS, introducing comprehensive financial tracking and a completely revamped mobile administration experience. This release focuses on enterprise-grade auditing, business expense management, and an ultra-modern, fluid mobile UI designed for rapid operations.

---

New Features & Enhancements

Modern Mobile Administration UI

- **Unified Flush Design**: Upgraded all mobile modules (Inventory, Sales, Expenses, Purchases, Users) to an edge-to-edge list-group layout, maximizing data density and readability.

- **Fluid Swipe-to-Action**: Implemented high-performance, spring-like swipe gestures for quick actions across all lists, complete with auto-closing logic when interacting with other elements.

- **Mobile Goods Reception**: Fully ported the Goods Reception module to the mobile interface. Managers can now look up Purchase Orders, verify quantities, and assign batches or expiries directly from their smartphones via a seamless full-screen overlay.

- **Optimized Navigation**: Replaced the traditional, card-cluttered desktop port with a clean, icon-driven "More" menu and bottom-border-only search inputs for a premium mobile experience.

Comprehensive Financial Suite

- **Expense Management**: Added a robust Business Expenses module with categorization, tracking, and filtering capabilities.

- **Expense Analytics**: Integrated expense tracking directly into the dashboard KPIs and trend charts to provide a true picture of net profitability.

- **Automated Audit Reports**: A professional-grade Audit Report generator that consolidates Sales, Purchases, and Expenses into a single unified ledger, exportable to PDF and MS Word.

- **Accounts Opinion Engine**: The system now automatically analyzes financial health and generates an actionable "Accounts Opinion" summary within the audit dashboard.

Core System Optimizations

- **Data Integrity**: Hardened database queries to eliminate schema-related "Column not found" errors during complex reporting operations.

- **Robust Search Architecture**: Optimized data retrieval paths and updated core reporting APIs to handle larger, more complex operational datasets seamlessly.

---

Database Changes

### New/Modified Tables

- **`expenses`**: Tracks day-to-day business expenditures linked to respective categories.

- **`expense_categories`**: Allows dynamic classification of expenses.

- **`salaries`** / **`salary_payments`**: Foundations for an integrated payroll tracking system.

Migration Info

- Ensure that the new database schema (including `expenses` and `salaries` structures) is applied when upgrading from **3.1.9**.

---

Developer & Distribution Notes

- **DIST4.0 Release Build**: The distribution package has been rigorously cleaned. Unnecessary migration scripts, development scratches, and standalone site portals have been pruned for a lighter, more secure footprint.

- **Fresh Baseline Database**: The `database.sql` has been regenerated to reflect the v4.0 schema natively, complete with necessary system roles, baseline categories, and clean initialization logic.

## 🚀 Overview

Version 3.1.9 is a significant update focused on modernizing the printing infrastructure, automating product identification, and preparing the system for cloud-based operations. This release also includes a more robust database migration engine.

---

## ✨ New Features & Enhancements

### 🖨️ Enhanced Printing Engine

- **Restructured Print Queue**: The database schema for printing has been overhauled. It now supports raw text/HTML content instead of being limited to sale IDs. This allows for printing of custom documents like barcodes, stock labels, and reports.

- **Printer Targeting**: Added support for specific `printer_name` targeting within the queue, enabling multi-printer setups (e.g., separate Kitchen and Front-Office printers).

- **Status Normalization**: Standardized print status tracking (`pending` vs `printed`) for better service compatibility.

### 🏷️ SKU & Barcode Automation

- **Dynamic SKU Templates**: Introduced a template system for SKU generation (e.g., `PROD-{MMYYYY}-00000`).

- **Auto-Incrementing SKU Numbers**: The system now tracks the next available SKU number globally to prevent collisions.

- **Improved Barcode Management**: Refined the API for batch-generating barcodes for products that lack them.

### ☁️ Cloud Printing Readiness

- **Cloud Config Keys**: Added new system settings for Cloud Printing, including URL, User Authorization, and Polling Intervals.

- **Background Service Support**: Updated configuration file generation (`cloud_printer_config.txt`) to sync with the database settings automatically.

### ⚙️ System Settings Standardization

- **Tax Configuration**: Global `tax_percent` setting added (defaulting to 18% for VAT).

- **Currency Localization**: Added settings for `company_currency_code` and `company_currency_name`.

- **SMTP Security**: Standardized SMTP encryption and authentication fields for reliable email notifications.

---

## 💾 Database Changes

### New/Modified Tables

- **`print_queue`**:

- Added `content` (LONGTEXT).

- Added `printer_name` (VARCHAR).

- Removed legacy `sale_id`, `user_id`, and `terminal_name` dependencies for more flexibility.

- **`settings`**: Seeded with 11+ new keys for SKU, Cloud, and Local settings.

### Migration Info

- Users upgrading from **3.1.0** should run `finish_update.php` or execute `update_v3.1.9.sql`.

- **Note:** The `print_queue` will be cleared during migration due to the structural overhaul.

---

## 🛠️ Developer & Distribution Notes

- **Clean Distribution**: The `DIST3.1.9` package now includes a "Clean Database" export that resets all transactional data while preserving system logic and default units.

- **Authenticity Verified**: All API and Asset files in the distribution folder have been synchronized with the latest production-ready code.

---

*Developed by Franklin BMC*

Release Notes — JUSTSALE POS v3.1.0

We are pleased to announce the release of JUSTSALE POS v3.1.0. This update standardizes the system baseline, hardens security protocols, and optimizes the distribution workflow for a more seamless deployment experience.

Key Improvements

1. System Baseline Standardization

v3.1.0 Synchronization: The entire ecosystem—including POS terminal, Mobile Admin, and API layers—is now fully synchronized to the v3.1.0 baseline.

Precision Tracking: Internal versioning logic has been overhauled to ensure the software state is accurately reflected across the database and UI.

2. Security & Privacy Hardening

Credential Sanitization: Removed hardcoded production credentials from core configuration files to eliminate data leak risks.

Redistribution Cleanup: Sensitive development logs, deployment scripts, and internal backups have been purged from the distribution package for a cleaner, more secure build.

3. Deployment & Installation

Unified Distribution: The distribution folder now supports both New Installations (via Setup Wizard) and Legacy Updates (via Database Sync Tool).

Bootstrap Optimization: The Setup Wizard has been refined to bootstrap new environments directly to the v3.1.0 baseline.

Automated Migrations: Enhanced finish_update.php to ensure schema consistency without the need for manual SQL intervention.

4. Technical Optimizations

Middleware Whitelisting: Critical migration scripts are now whitelisted in the licensing middleware, preventing session timeouts during database updates.

Centralized Logic: Standardized database connection handling across all core modules for improved stability.

Components Updated

1. api/db.php: Standardized connection logic.
2. api/installer.php: Integrated v3.1.0 setup logic.
3. finish_update.php: Improved migration stability.
4. pos.html & mobile-admin.html: Synchronized version indicators.

Professional Edition. Copyright © 2026. Powered by Franklin BMC.

JUSTSALE POS v3.0.0 | Release Notes

Status: Major Milestone Update (Stable)

Executive Summary

Version 3.0.0 marks a transition from a standard Point of Sale to an Intelligent Inventory Ecosystem. By focusing on granular batch tracking, a "Mobile-First" administrative experience, and a unified core infrastructure, this version is designed for high-volume businesses and those handling perishable goods.

1. Next-Gen Inventory Intelligence

1. Smart Batch Tracking: Manage multiple shipments of the same product with unique Purchase Costs and Selling Prices per batch.
2. Expiry & FEFO Logic: Automated First Expired, First Out (FEFO) support. The system now prioritizes older stock to reduce waste and highlights items nearing expiration.
3. Manual Adjustments: Direct batch correction tools for stock "In/Out/Loss/Damage" with mandatory reason logging for better auditing.

2. Premium Mobile Experience

1. Mobile Admin v3: A complete redesign of the backoffice. Handheld devices now enjoy a native app-like feel with smooth transitions and optimized "thumb-friendly" layouts.
2. Camera-as-Scanner: Integrated Html5QrcodeScanner allows any smartphone camera to act as a high-speed barcode scanner—eliminating the need for expensive external hardware.
3. Refined Checkout: Improved processing speeds and a streamlined batch selection interface for smaller screens.

3. Sales & Financial Maturity

1. Advanced Returns System: Full or partial refunds via Credit Notes, maintaining strict inventory and shift accuracy.
2. Smart Price Formatting: Automatic thousand separators (e.g., 5,000) across all inputs for easier data verification.
3. Enhanced Receipts: Professional layout updates including custom Header/Footer options and dedicated TIN/VRN fields.
4. Self-Service Security: Users can now perform password resets via email using updated, reliable SMTP configurations.

4. Core Infrastructure & Security

1. Master Update Script: The new finish_update.php handles sequential database migrations automatically from any version since v2.0.4.
2. Universal Branding: A cohesive UI across Desktop POS, Admin Dashboards, and Mobile apps.
3. Environment Awareness: Auto-detection for Local vs. Production environments and refined Hardware Locking (HWID) for secure licensing.
4. Technical Node: Optimized for PHP 8.0+ with an upgraded PHPMailer for reliable alerts.

The Upgrade Path

Moving to v3.0.0 is simpler than ever:

1. Backup: Always secure your database before a major version jump.
2. Deploy: Replace your current directory with the v3.0.0 Distribution Package.
3. Sync: Click the green "Finish Update" button on your dashboard or run yourpos.com/finish_update.php.
4. Verify: Look for the Ver: 3.0.0 badge in your system footer.

Our Philosophy: We don't just build features; we build tools that work as hard as you do. v3.0.0 is the result of thousands of hours of feedback, ensuring JUSTSALE POS remains the backbone of your success.

Release Notes: JUSTSALE POS v2.0.5

Release Date: March 16, 2026 | Version: 2.0.5 (Localized Production Build)

Major Infrastructure Updates

1. Centralized Licensing Migration: Moved heartbeat ecosystem to justsale.co.tz.
2. Redirect Resilience: Re-engineered CURL to support 301/302 redirects for seamless verification across WWW/non-WWW.
3. Universal Update System: Upgraded updater.php to pull builds from the new central repo.

New Features & Modules

1. Credit Note System: Full returns engine for processing refunds while maintaining inventory/shift accuracy.
2. Smart Distribution Engine: Added a Web Setup Wizard (install.html) for faster client-side deployments.

POS UX/UI Enhancements

1. Enhanced Numpad: Added "00" button to the cart modal for faster price/quantity adjustments.
2. Shift Management Fix: Resolved bug where "Shift Required" overlay stayed visible after opening.
3. Dynamic Branding: Updated all footers and PDF/Excel exports with new JUSTSALE branding.

Security & Maintenance

1. Hardware Lock (HWID): Refined Windows identification for more secure license-to-client binding.
2. Environment Detection: Auto-detects Local vs. Production database environments.
3. Schema Sync: Updated DB to support Credit Notes and Procurement History.

Initial stable release with localized assets.