4 Mar 2024

1. Updated GitHub project page URL.
2. Updated Installer - Graceful failure for existing database and unable to generate VAPID keys.

12 Feb 2024

1. Added YouTube Quickstart guide.
2. Updated installer, about pages.

11 Feb 2024

Dealing with cascade update/delete...

1. Edit item - Will cascade update movement, supplier items, delivery items, and purchase items.
2. Delete item - Will cascade delete movement, supplier items, delivery items, and purchase items.
3. Delete customer - Will cascade delete all related delivery orders, order items, and movement.
4. Delete supplier item > Will cascade delete all related purchase order items and movement.
5. Delete supplier > Will cascade delete all related purchase orders, order items, movement, and supplier items.

10 Feb 2024 - Added Purchase Order

1. Added customer_id as foreign key into purchases table.
2. The idea - "Customer" is the "company" itself. "Deliver To" can be any person/department/branch within the company.
3. QR and delivery order report - Print on page load.
4. Added purchase order and purchase order items tables.
5. Added PURCHASE_STAT setting.
6. Added company name, address, telephone, email settings.
7. Include company info in DO & PO.
8. PAGE-settings.php - Company address will be the odd textarea.
9. Some general code cleanup for delivery order.
10. Updated autocomplete - Added purchase supplier suggestion and fixed supplier item to also include supplier id.

8 Feb 2024

Changed client-side caching mechanics, so that developers can "force push update" for assets.

1. ADDED CACHE_VER to settings.
2. Added LIB-CCache.php
3. Updated LIB-Install.php > Run CCache->init() on installation end.
4. CB-worker.js - Removed storage cache, moved to PAGE-cbwork.js instead.
5. Updated TEMPLATE-top.php - Load PAGE-cbwork.js
6. Renamed assets/head-storage-boxx.webp to banner.webp
7. Page settings - Will not show "CACHE_VER"

TLDR) Call $_CORE->CCache->init() and all clients will rebuild cached assets.

7 Feb 2024

1. Removed item name and unit from delivery items table.
2. Added "item sort order" to delivery items table.
3. Delivery order - Added sortable items.
4. Updated report and delivery library to adapt sort order.
5. Updating an item SKU/name/unit will also change the delivery items.
6. A warning is now displayed in the edit item page to highlight potential problems when changing SKU/name/unit.
7. Movement - Trigger save after clicking on auto-suggested SKU.

2 Feb 2024

DATABASE CHANGES

1. Removed item batches & expiry - Confusing and a hassle to deal with.
2. Added customers.
3. Added item unit price.
4. Added deliveries and delivery items.
5. Added delivery order ID and purchase order ID to item movement.
6. Added "delivery status code" to settings.

CODE CHANGES

1. Removed item batches & expiry.
2. Cleaned up NFC scanner code and interface.
3. Small update to QR scanner - Auto start on show.
4. Combined generate QR code page into report generator.
5. Restructed main menu - Removed "entities", added into "delivery" and "purchase".
6. A few other general UI and library updates.

29 Jan 2024

1. Added QR code login
2. Some general code cleanup.

27 Jan 2024

1. Library updates - Bootstrap, JWT, WebAuthn, webpush.
2. A couple of general UI updates.
3. QRcode scanner for movement and check pages are now merged into PAGE-qrscan.js.

14 Sep 2023

A tentatively stable build of Storage Boxx.