Invoices

Development Services: Design and development of core inventory management, calculation engine, and workflow to generate accurate pre-built stable instructions for staff.

-

-

-

-

-

-

-

-

IT/Consultant (15 hours at $125p/hour, for week Nov 17) - Quote Preview PDF functionality|updating with changes - Product Options / Product Options Category, Product option rules for products - Product options update to Products page - Connected product options to live product list - Bug fixes for: Prevent error when 0 hours provided for product

IT/Consultant (15 hours at $125p/hour, for week Nov 24) - Quote Preview PDF auto syncing, Job and Print and Packlist PDF updates, Product Category reordering management and integration into Products Category page and Available Products - Introduced Total Materials, Infill, Finish and Total Labour into jobs and Gross Profit explanation - View Quote PDF now accessible and updatable on dirty form - Minimised Activity Log - Workshop Capacity page - Bug fixes for: Product height calculation for product length values on product description page - Bug fix: Failed to fetch network error on /workshop-capacity page

IT/Consultant (35 hours at $125p/hour, for week Dec 1) - Workshop Capacity page updates - Production Options for A-0101000 - Quote PDF exception rules - Pack List Hide options - Product Modifiers updates - Bug fixes

IT Consultant (15 hours at $125p/hour, for week Dec 8) Workshop Capacity page updates to Scheduling and overlapping tasks, Update to minimum requirements before charting. Creating a draggable interface to show start date and end date. Job Planning phases, Job Planning convert to Quote/Job, Job Planning renaming, rules, “Must come after” Job Planning transition to Awaiting finalisation Bug fixing: Combining phases not working, fixed, Bug fix: Job Plan Rules not being honoured, now resolved. Bug fix: Stock taking not saving; publishing changes to Jobs/Quotes, Bug fix: Job Plans couldn’t be deleted. Now possible.

IT Consulting (For week of Dec 15 2025) - New plan button routing- - Addressing new in planning status- On the floor, in Production and now Planning. - Simplifying workflow - Adding annotation to job status table- - Workshop Capacity page updates to Scheduling and overlapping tasks, Update to minimum requirements before charting. Creating a draggable interface to show start date and end date. - Scheduling Page now gives oversight of being overbooked, with the toggle to show Planned or Unplanned Jobs - Job Planning phases, Job Planning convert to Quote/Job, - Job Planning renaming, rules, "Must come after" - Job Planning transition to Awaiting finalisation - phase rule, such as: Maximum days, No minimum days, Gap between Phase I and Phase II, Forces gap and dates in both: - Toggling of Pricing Details, Stock and Quote - Finalise job plan change to send job to workshop - User interface available products expand/collapse in line with expanding - products and phases, enabling pricing, stock, and quote Bugfix: "Details" button displaying job details status change to job details. - Bug fixing: Combining phases not working, fixed, - Bug fix: Job Plan Rules not being honoured, now resolved. - Bug fix: Stock taking not saving; publishing changes to Jobs/Quotes, - Bug fix: Job Plans couldn't be deleted. Now possible. - Bugfix: Addressing Today button on Scheduling page causing design shift, now resolved.

IT Consultant Updates from 05/01/2026-18/01/2026 ** UPDATES** 16/01: Updated Jobs page to show accurate total products/product types with improved Products column showing joined badges and hover card. 16/01: Added View As feature 15/01: Updated Scheduling View with Financials panel, On The Floor/Planning forecast, and export with financial summary. 15/01: Improved Scheduling page UI layout with separated rows and confirmation dialog. 09/01: Added Forecasting Rules in dedicated modal with warnings. 09/01: Merged reports into unified Impact Radar with tabs and overview page. 09/01: Added read-only banner for workshop view of planning jobs. 08/01: Added product filter to Quotes and Jobs lists with database search. 08/01: Show current workflow step name under job progress bar. 06/01: Updating Planning mode status within Scheduling page. 06/01: Updating Jobs On The Floor Mode, showing nested states within /jobs. 06/01: Removing Quotes (deleting) when Quote transitions to New Job Plan and New Job Plan is deleted. 05/01: Enabled admin user updates and Magic Link login for existing users. 05/01: Security improvements - protected debug endpoints with auth, secured Cloudflare configuration. **MAINTENANCE** 18/01: Executed backup in production, included new Jobs in Planning/Client change updates. 01/01: Secured function search_path for 20 functions. ** BUG FIXES** 16/01: Fixed Jobs index page calculations showing incorrect inc GST values for specific Jobs In Planning - stopped doubling GST, persisted cost breakdown correctly, aligned material cost calculation with product-cost API. 16/01: Fixed stale impersonation data clearing for non-superadmin users. 15/01: Fixed Svelte 5 compatibility - moved @const declarations to derived values. 09/01: Fixed Jobs moving freely between Quote -> Job in Planning <-> Job On the Floor. 09/01: Fixed Change of Status menu update to show within dropdown (not off screen). 09/01: Fixed Quote to New Job Plan response handling. 09/01: Fixed Gantt chart job bars starting at 0h (flush left) instead of ~12h offset. 09/01: Fixed job drag in /scheduling uses jobs API instead of quotes API. 09/01: Fixed table design system alignment and font consistency. 09/01: Fixed border-radius and UI improvements across design audit. 08/01: Fixed product filter dropdowns using fixed popovers on quotes and jobs. 08/01: Fixed job notes queries using maybeSingle() instead of single(). 06/01: Fixed pending state of Quote transition, missing quote when changing state. 06/01: Fixed missing workshop hours when updating product. 06/01: Fixed error detection logic to properly identify and filter temporary connectivity issues, reducing false-positive error alerts. 05/01: Fixed user edit from client-side to server-side form action.

LIVNA v0.2.1977 - Kept all software dependencies current and secure - Ensured the platform is running on the latest stable, patched versions of its core libraries, reducing the risk of known vulnerabilities and maintaining compatibility with third-party services (264 packages updated within safe version ranges) - Products catalogue now loads significantly faster - Staff browsing the products list no longer wait for a redundant internal network hop that was doubling the time to fetch product data; the page now retrieves everything it needs in a single direct pass (fetch-to-self pattern eliminated on /products) - Product editing sessions start faster - Opening any product to view or edit no longer triggers a wasteful second round-trip to re-fetch cost data the system already had in hand, meaning quicker access to the build editor where most daily design work happens (replaced API call with inline computation on /products/[code]) - Less data pulled from the database when editing products - The system now only requests the specific fields it actually uses rather than fetching every column, which means less data travelling between the server and database on every single product page load (targeted column selects replacing blanket select *) - Cleaner, lighter product editor in the browser - Removed over 400 leftover development diagnostics that were silently running in the background during every product editing session, reducing browser memory usage and improving responsiveness when working with complex assemblies (412 debug statements removed, error logging preserved) - Job pages with many line items load dramatically faster - Previously, every single line item on a job triggered its own individual database lookup to resolve product codes - a job with 20 items meant 20+ separate calls. Now the system gathers all the names upfront and resolves them in one or two batches (N+1 query pattern replaced with batch resolution) - Job detail pages no longer wait unnecessarily between queries - Four database requests that were queuing up one after another now run at the same time as everything else, cutting out dead wait time when loading job details - the page staff use most throughout the day (sequential waterfall parallelised) - Eliminated repeated fetching of the same data on job pages - The system was asking the database for the same quote line items three separate times and the same hourly rate twice per page load; now each is fetched once and shared, ensuring consistent figures across all cost calculations (5 redundant queries removed) - Overall database efficiency on job pages more than halved - The single most data-heavy page in the application now makes roughly half the database calls it used to, translating directly to faster load times for the core workflow staff interact with dozens of times daily - All changes independently verified for data integrity - Three separate automated review processes confirmed that every optimisation preserves the exact same data, calculations, and page behaviour as before - faster delivery with zero risk to existing functionality

IT Fixes Summary All fixes deployed to production as v0.2.1980: - Fixed print preview tab staying open after print dialog - Added automatic window close when user saves/cancels from the browser print dialog, eliminating the lingering about:blank tab v0.2.1984 deployed successfully. - Fixed and deployed. The formula popup now positioned in center/top half of window, - Fixed "Print All Workshop Items" to include actual workshop table - Print output now includes full workshop package with cover page listing documents AND the complete product details table (with Length/Height measurements), not just instructions - Fixed individual cutting list document links showing R2 credential error - Created server-side API endpoint for secure presigned URL generation, resolving the "Credential access key has length 0" error when clicking PDF links

Web development Updated sortable headings on <jobs> were previously throwing errors. Faster Page Loading - All pages load quicker, especially on mobile Drag & Drop - /products/new - smoother part reordering when building assemblies - /products/[code] - better touch response when editing product parts - /admin/system - improved list reordering File Uploads & Downloads - /jobs/[id] - faster PDF uploads for cutting lists and manuals - /jobs/[id] - quicker document downloads from attachments panel - /admin/backups - more reliable backup file handling Offline Data - /quotes - better local caching when working offline - All pages - smoother experience on slow connections Diagrams - /help - improved workflow diagram rendering - /admin/system - clearer system architecture diagrams Error Tracking - /products/new, /products/[code] - issues captured more accurately - All pages - better error reporting for faster fixes Security - All forms - updated input sanitization - Login/auth - improved password handling