7f924ccc45
Overhaul the app's color system by replacing all hardcoded Tailwind color classes with semantic theme variables to ensure consistent theming across all components, pages, and tests. Additional changes: - Add assigned date support for order item status updates: add `assignedDate` field to the order item status PATCH API, implement server-side normalization/validation, and add corresponding tests - Refactor purchase order PDF workflows to use the consolidated `purchase_orders.documents` field instead of the legacy separate `purchase_order_pdfs` collection - Fix quote number parsing and formatting to support both dashed (Q-YYYY-MM-NNN) and dashless (QYYYYMMNNN) formats - Rename `driver_pool` item status to `collection_pool` across the codebase - Add null handling for order item quantities and pricing to display "—" for missing values - Improve filter tab styling: make mobile tabs scrollable, prevent text wrapping, hide scrollbar - Add new utility scripts, API routes, migrations, and polish small UI/UX fixes including tsconfig updates and theme hook improvements
63 lines
2 KiB
JavaScript
63 lines
2 KiB
JavaScript
onRecordCreate((e) => {
|
|
if (e.record.getString("quote_number") !== "") {
|
|
e.next();
|
|
return;
|
|
}
|
|
|
|
try {
|
|
var now = new Date();
|
|
var year = now.getFullYear();
|
|
var month = String(now.getMonth() + 1).padStart(2, '0');
|
|
var prefix = "Q" + year + month;
|
|
|
|
let attempts = 0;
|
|
let candidate;
|
|
|
|
do {
|
|
// findRecordsByFilter accepts sort as the 3rd arg.
|
|
// findFirstRecordByFilter's 3rd arg is params (dbx.Params),
|
|
// which is why the old "-quote_number" sort string threw
|
|
// "could not convert -quote_number to dbx.Params".
|
|
const records = $app.findRecordsByFilter(
|
|
"quotes",
|
|
"quote_number != ''",
|
|
"-quote_number",
|
|
1,
|
|
0
|
|
);
|
|
|
|
let newNum = 1;
|
|
if (records && records.length > 0) {
|
|
var raw = records[0].getString("quote_number");
|
|
// Extract trailing digits (handles Q202607011,
|
|
// legacy Q-2026-07-011, Q1782862717620, etc.).
|
|
var m = raw.match(/(\d+)$/);
|
|
if (m) {
|
|
newNum = parseInt(m[1], 10) + 1 + attempts;
|
|
}
|
|
}
|
|
|
|
candidate = prefix + String(newNum).padStart(3, '0');
|
|
attempts++;
|
|
|
|
// check if this candidate already exists
|
|
var exists;
|
|
try {
|
|
exists = $app.findFirstRecordByFilter(
|
|
"quotes",
|
|
"quote_number = {:num}",
|
|
{ num: candidate }
|
|
);
|
|
} catch (e) {
|
|
exists = null; // not found throws in some versions
|
|
}
|
|
} while (exists && attempts < 5);
|
|
|
|
e.record.set("quote_number", candidate);
|
|
} catch (err) {
|
|
console.error("Auto-numbering error:", err);
|
|
e.record.set("quote_number", "Q" + Date.now()); // fallback that's at least unique
|
|
}
|
|
|
|
e.next();
|
|
}, "quotes");
|