Mattsson
c8461397c8
* feat(api): implement commit functionality for journal entries * fix(extensions): make ExtensionSettings.clear() a real delete so disconnect flows work The 2026-03-30 multi-tenant refactor dropped all RLS policies on extension_data and recreated only SELECT/INSERT/UPDATE. Combined with `value jsonb NOT NULL`, every extension that called `settings.set(key, null)` to clear stored state (cloud-backup disconnect, skatteverket OAuth/AGI cleanup, arcim-migration consent reset) silently failed — the upsert hit the NOT NULL constraint and the error was swallowed, leaving users stuck with stale connection rows. Adds an `extension_data_delete` RLS policy, a `clear(key)` method backed by a real DELETE, switches the four affected handlers, and makes `set()` throw on Supabase error so this class of silent failure can't recur. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com> * feat(journal-entries): add draft saving functionality to journal entry form * feat: add periodisk sammanställning report generation and CSV export - Implemented period date helpers in `period-dates.ts` for calculating start and end dates based on period type (monthly, quarterly, yearly). - Created `periodisk-sammanstallning.ts` to generate the periodisk sammanställning report, including data fetching, validation, and warning handling. - Developed CSV serializer in `periodisk-sammanstallning-csv.ts` for exporting the report in SKV574008 format. - Added new columns to `company_settings` for storing periodisk sammanställning settings and tax contact information via migration. - Introduced a new migration to add a `paid_with_private_funds` flag to `supplier_invoices` for tracking out-of-pocket expenses. - Updated journal entries to include the new source type for privately paid supplier invoices. * feat(migrations): add paid_with_private_funds flag to supplier_invoices and expand journal_entries.source_type CHECK * fix(ai_requests): drop existing policies and trigger before creating new ones * fix(migrations): ensure extension_data has a proper DELETE policy for ExtensionSettings.clear() * fix(supplier-invoices): update error handling for invalid input in POST request * fix: correct capitalization in project title * fix(migrations): resolve duplicate version 20260513120000 Two migrations shared the same timestamp prefix, causing schema_migrations_pkey collision on Supabase preview branches. Bump extension_data_delete_policy to 20260513120001. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com> --------- Co-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
43 lines
1.6 KiB
SQL
43 lines
1.6 KiB
SQL
-- Add fields to company_settings needed for periodisk sammanställning (SKV 5740).
|
|
--
|
|
-- periodisk_sammanstallning_period:
|
|
-- Separate from moms_period because:
|
|
-- 1. PS does not support 'yearly' (only monthly or quarterly).
|
|
-- 2. Goods sellers must report monthly even if VAT is quarterly
|
|
-- (35 kap. 2 § SFL).
|
|
-- 3. Services-only sellers can apply for quarterly independently.
|
|
--
|
|
-- tax_contact_*:
|
|
-- The SKV574008 file header requires contact person + phone + email of the
|
|
-- declarant. Stored on company_settings so it is reusable for future
|
|
-- Skatteverket filings (e.g. AGI, momsdeklaration export).
|
|
|
|
ALTER TABLE public.company_settings
|
|
ADD COLUMN IF NOT EXISTS periodisk_sammanstallning_period text,
|
|
ADD COLUMN IF NOT EXISTS tax_contact_name text,
|
|
ADD COLUMN IF NOT EXISTS tax_contact_phone text,
|
|
ADD COLUMN IF NOT EXISTS tax_contact_email text;
|
|
|
|
-- Backfill: monthly default for everyone except quarterly VAT-payers.
|
|
UPDATE public.company_settings
|
|
SET periodisk_sammanstallning_period = CASE
|
|
WHEN moms_period = 'quarterly' THEN 'quarterly'
|
|
ELSE 'monthly'
|
|
END
|
|
WHERE periodisk_sammanstallning_period IS NULL;
|
|
|
|
ALTER TABLE public.company_settings
|
|
ALTER COLUMN periodisk_sammanstallning_period SET DEFAULT 'monthly';
|
|
|
|
ALTER TABLE public.company_settings
|
|
ALTER COLUMN periodisk_sammanstallning_period SET NOT NULL;
|
|
|
|
ALTER TABLE public.company_settings
|
|
DROP CONSTRAINT IF EXISTS company_settings_ps_period_check;
|
|
|
|
ALTER TABLE public.company_settings
|
|
ADD CONSTRAINT company_settings_ps_period_check
|
|
CHECK (periodisk_sammanstallning_period IN ('monthly', 'quarterly'));
|
|
|
|
NOTIFY pgrst, 'reload schema';
|