Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Resolved in BrightInvoiceRepository.GetByCustomerAsync as "local appsettings config (Settings.Invoices:*) ?? company BCHEC flag".

The threeUDSMARK three UDSMARK visibility variants are independent and compose. Each active flag appends its own SQL clause; inactive flags add nothing (no runtime OR-gates).

  • ExcludeParked      ExcludeParked          = Settings.InvoiceExcludeParked      InvoiceExcludeParked                                ?? BCHEC VISEJPARKEREDE -> AND (UDSMARK IS NULL OR UDSMARK <= 25)        (hide UDSMARK > 25) 
  • CheckUdsmark       CheckUdsmark         = Settings.InvoiceCheckUdsmark       InvoiceCheckUdsmark                               ?? BCHEC CHECKUDSMARK  -> AND (UDSMARK IS NULL OR = 0 OR BETWEEN 2 AND 25)  (also drops UDSMARK = 1) 
  • ShowOnlyDelivered  = Settings.InvoiceShowOnlyDelivered                       ?? BCHEC VISKUNUDSKREVNE -> UDSMARK <= 25 + SNEX/DSEND delivery check (DELIVERYSTATE IN (5,9)) 
  • ExcludeFutureDated = Settings.InvoiceExcludeFutureDated InvoiceExcludeFutureDated                      ?? BCHEC EJFREMTID EJFREMTID -> AND BILAGSDATO <= @Today 
  • ExcludeAfregnTypes = Settings.InvoiceExcludeAfregnTypes (non-empty) ?? BCHEC W11_W12EJAFRTYP W12EJAFRTYP -> AND AFREGNTYPE NOT IN @ExcludeAfregnTypes 
  • OnlyRendered       OnlyRendered           = !Settings.InvoiceShowAlsoInvoicesWithoutPdf   (default true) -> AND EXISTS (AKONDDOC -> BDOC, DOCTYPE=1, DATALENGTH(PAYLOAD)>0,  MIMETYPE MIMETYPE LIKE @PdfMimeType) → @PdfMimeType defaults to application/pdf

Always-applied (Base query) filters, independent of the toggles above:

...