Mattsson
072aedeaf9
* fix: prevent credit notes from entering payment flow * fix: persist and display customer personal numbers * feat: configure automatic invoice reminder days * fix: issue credit notes through send flow * chore: add repository agent guidance * feat(mcp): route tools across user companies * fix(articles): delete unused register entries * feat(invoices): improve issued invoice actions * feat(supplier-invoices): retain uploaded source documents * docs: record implementation decisions * feat: enhance customer personal number handling and validation - Updated CustomerForm to allow personal numbers in the format of "********-1234" for individual customers. - Added validation to ensure personal numbers are only accepted for individual customers in CreateCustomerSchema. - Implemented masking and encryption for personal numbers to enhance data protection. - Introduced new utility functions for masking and encrypting personal numbers. - Added database migration to enforce unique constraints on credit note relationships and prevent duplicate entries. - Enhanced error handling and logging for credit note issuance and invoice processing. - Updated tests to cover new credit note creation guards and personal number handling. * test: enhance list companies test with supabase query mocks
29 lines
953 B
SQL
29 lines
953 B
SQL
-- Credit notes are adjustments, not customer receivables. They must not enter
|
|
-- the ordinary customer-payment lifecycle.
|
|
--
|
|
-- NOT VALID avoids scanning or rewriting existing rows during deployment. The
|
|
-- constraint still applies to every new row and every future update, so all
|
|
-- API, RPC, extension, and legacy write paths share the same invariant.
|
|
DO $migration$
|
|
BEGIN
|
|
IF NOT EXISTS (
|
|
SELECT 1
|
|
FROM pg_constraint
|
|
WHERE conname = 'invoices_credit_note_not_paid'
|
|
AND conrelid = 'public.invoices'::regclass
|
|
) THEN
|
|
ALTER TABLE public.invoices
|
|
ADD CONSTRAINT invoices_credit_note_not_paid
|
|
CHECK (
|
|
credited_invoice_id IS NULL
|
|
OR status NOT IN ('paid', 'partially_paid')
|
|
) NOT VALID;
|
|
END IF;
|
|
END
|
|
$migration$;
|
|
|
|
COMMENT ON CONSTRAINT invoices_credit_note_not_paid ON public.invoices IS
|
|
'Credit notes cannot use the ordinary customer-invoice payment states.';
|
|
|
|
NOTIFY pgrst, 'reload schema';
|