Architecture, Fonctionnalités et Modèle Économique

export async function checkQuoteLimit(companyId: string): Promise<void> {
  const plan = await getPlan(companyId);   // "free" | "pro"
  if (plan === "pro") return;              // illimité

  const { count } = await supabase
    .from("quotes")
    .select("id", { count: "exact", head: true })
    .eq("company_id", companyId)
    .gte("created_at", startOfMonth());

  if (count !== null && count >= 2) {
    throw new PlanLimitError(
      "Limite de 2 devis/mois atteinte. Passez au plan Pro."
    );
  }
}

"use server";
import { requireWrite } from "@/lib/permissions";

export async function createQuote(data: QuoteInput) {
  const supabase = await createClient();
  const { data: { user } } = await supabase.auth.getUser();
  const { data: profile } = await supabase
    .from("profiles").select("role, company_id")
    .eq("id", user!.id).single();

  // Lève une erreur si role = "comptable" ou "viewer"
  requireWrite(profile?.role);

  // Vérifie le quota plan avant insertion
  await checkQuoteLimit(profile!.company_id);

  return supabase.from("quotes")
    .insert({ ...data, company_id: profile!.company_id });
}

{
  "invoice_number": "FAC-2026-00421",
  "date":           "2026-05-14",
  "supplier_name":  "Brico Pro SAS",
  "supplier_siret": "82345678900012",
  "total_ht":       "248.50",
  "total_tva":      "49.70",
  "total_ttc":      "298.20",
  "vat_breakdown": [
    { "rate": "20", "base_ht": "248.50", "tva": "49.70" }
  ],
  "category":       "Matériaux",
  "confidence":     0.97
}

CREATE TABLE company_memberships (
  id         UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id    UUID NOT NULL REFERENCES profiles(id)  ON DELETE CASCADE,
  company_id UUID NOT NULL REFERENCES companies(id) ON DELETE CASCADE,
  role       TEXT NOT NULL DEFAULT 'viewer',
  created_at TIMESTAMPTZ DEFAULT now(),
  UNIQUE(user_id, company_id)
);

const ASSISTANT_SYSTEM_PROMPT_VIEWER = `
Tu es l'assistant de l'application Kompta, pour un EMPLOYÉ.
Tu peux UNIQUEMENT répondre aux questions sur :
- La création et soumission de notes de frais
- La clôture mensuelle des notes de frais
- La consultation du profil

Tu ne mentionnes JAMAIS et ne réponds JAMAIS aux questions sur :
les devis, factures clients, TVA, FEC, transactions, clients,
chiffre d'affaires, paiements, abonnements.
`;

export function getSystemPrompt(role: string | null): string {
  if (role === "comptable") return ASSISTANT_SYSTEM_PROMPT_COMPTABLE;
  if (role === "viewer")    return ASSISTANT_SYSTEM_PROMPT_VIEWER;
  return ASSISTANT_SYSTEM_PROMPT;   // artisan / admin
}

<rsm:CrossIndustryInvoice>
  <rsm:ExchangedDocumentContext>
    <ram:GuidelineSpecifiedDocumentContextParameter>
      <ram:ID>urn:factur-x.eu:1p0:basicwl</ram:ID>
    </ram:GuidelineSpecifiedDocumentContextParameter>
  </rsm:ExchangedDocumentContext>
  <rsm:ExchangedDocument>
    <ram:ID>FAC-2026-00089</ram:ID>
    <ram:TypeCode>380</ram:TypeCode>
    <ram:IssueDateTime>
      <udt:DateTimeString format="102">20260514</udt:DateTimeString>
    </ram:IssueDateTime>
  </rsm:ExchangedDocument>
  <rsm:SupplyChainTradeTransaction>
    <ram:ApplicableHeaderTradeSettlement>
      <ram:SpecifiedTradeSettlementHeaderMonetarySummation>
        <ram:TaxBasisTotalAmount>1200.00</ram:TaxBasisTotalAmount>
        <ram:TaxTotalAmount currencyID="EUR">240.00</ram:TaxTotalAmount>
        <ram:GrandTotalAmount>1440.00</ram:GrandTotalAmount>
      </ram:SpecifiedTradeSettlementHeaderMonetarySummation>
    </ram:ApplicableHeaderTradeSettlement>
  </rsm:SupplyChainTradeTransaction>
</rsm:CrossIndustryInvoice>

-- Appliqué sur toutes les tables business (quotes, invoices, transactions…)
CREATE POLICY "isolate_by_company" ON client_invoices
  FOR ALL USING (
    company_id IN (
      SELECT company_id FROM profiles WHERE id = auth.uid()
    )
  );