Centurio Systemen en modules
🏛️ Plattformarchitectuur 🔑 Login
🏠 Alle modules / crm_office / Intranet & publicaties
📰

Intranet & publicaties

publishing crm_office 🛡️ RLS Protected

SharePoint-achtige sites, pagina's/nieuws/beleid, omloop vrijgave, DMS-aanhangsels en leesbevestiging.

Fachliche Bestimmung: medewerker intranet: domeinen (sites) met lidrollen, ontwerpen met TinyMCE-body, vrijgave via DocumentCirculation (source_type=publishing_page), grote versie bij Publish, optionele actaakken bij beleidsmaatregelen. Aanhangsels zijn DMS-documenten; download via /api/v1/documents/{id}/download. TinyMCE kiest link/beeld uit het DMS.

⚡ Werkstromen en levenscyclus

Intranet-pagina: ontwerp → omloop → publicatie intranet_page_lifecycle

Inhoudspad van het ontwerp tot de gepubliceerde hoofdversie, inclusief optionele lezenbevestiging.

sequenceDiagram Author->>PublishingAPI: POST /pages (draft) Author->>PublishingAPI: POST /pages/{id}/attachments Author->>PublishingAPI: POST /pages/{id}/submit PublishingAPI->>Circulations: create source_type=publishing_page Approver->>Circulations: complete_step approved Circulations->>PublishingAPI: publish_from_circulation Reader->>Web: GET /intranet/pages/{id}
1. DRAFT
Ontwerp
Contributor maakt pagina's en maakt HTML-body (bleach-sanitiseerd).
Aktionen: attach_document, upload_and_attach, save_draft
2. PENDING
Voor de vrijlating
start DocumentCirculation met source_type=publishing_page.
Aktionen: submit_for_approval
3. PUBLISHED
Gepubliceerd
publish_from_circulation stelt voor grote versie en feed zichtbaarheid.
Aktionen: audience_filter, optional_ack_tasks
4. ACK
Leesbevestiging
De Commissie heeft een aantal voorstellen ingediend om de Commissie te informeren over de mogelijkheden om de verwerking van de gegevens te verbeteren.
Aktionen: -

🗄️ Datamodellen & velden

PublishingAcks publishing_acks RLS Aktiv
9 Veld / kolom

Tabelle publishing_acks

Feldname Datatipe Verplichting Schlüssel Gezondheid
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
user_id UUID Ja * FK ➔ users.id Feld user_id
version INTEGER Ja * - Feld version
acknowledged_at DATETIME Ja * - Feld acknowledged_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
PublishingAttachments publishing_attachments RLS Aktiv
8 Veld / kolom

Tabelle publishing_attachments

Feldname Datatipe Verplichting Schlüssel Gezondheid
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
document_id UUID Ja * FK ➔ documents.id Feld document_id
sort_order INTEGER Ja * - Feld sort_order
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
PublishingPageVersions publishing_page_versions RLS Aktiv
12 Veld / kolom

Tabelle publishing_page_versions

Feldname Datatipe Verplichting Schlüssel Gezondheid
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
version INTEGER Ja * - Feld version
is_major BOOLEAN Ja * - Feld is_major
title VARCHAR(255) Ja * - Feld title
summary TEXT Nein - Feld summary
body TEXT Ja * - Feld body
created_by UUID Nein - Feld created_by
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
PublishingPages publishing_pages RLS Aktiv
28 Veld / kolom

Tabelle publishing_pages

Feldname Datatipe Verplichting Schlüssel Gezondheid
site_id UUID Ja * FK ➔ publishing_sites.id Feld site_id
page_type VARCHAR(48) Ja * - Feld page_type
status VARCHAR(48) Ja * - Feld status
title VARCHAR(255) Ja * - Feld title
slug VARCHAR(255) Ja * - Feld slug
summary TEXT Nein - Feld summary
body TEXT Ja * - Feld body
pinned BOOLEAN Ja * - Feld pinned
requires_ack BOOLEAN Ja * - Feld requires_ack
published_version INTEGER Nein - Feld published_version
draft_version INTEGER Ja * - Feld draft_version
published_at DATETIME Nein - Feld published_at
published_by UUID Nein - Feld published_by
circulation_id UUID Nein FK ➔ document_circulations.id Feld circulation_id
ism_policy_id UUID Nein - Feld ism_policy_id
audience_kind VARCHAR(48) Ja * - Feld audience_kind
audience_roles JSONB Ja * - Feld audience_roles
audience_unit_ids JSONB Ja * - Feld audience_unit_ids
audience_user_ids JSONB Ja * - Feld audience_user_ids
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
PublishingSiteMembers publishing_site_members RLS Aktiv
8 Veld / kolom

Tabelle publishing_site_members

Feldname Datatipe Verplichting Schlüssel Gezondheid
site_id UUID Ja * FK ➔ publishing_sites.id Feld site_id
user_id UUID Ja * FK ➔ users.id Feld user_id
role VARCHAR(48) Ja * - Feld role
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
PublishingSites publishing_sites RLS Aktiv
18 Veld / kolom

Tabelle publishing_sites

Feldname Datatipe Verplichting Schlüssel Gezondheid
name VARCHAR(255) Ja * - Feld name
slug VARCHAR(128) Ja * - Feld slug
description TEXT Nein - Feld description
is_active BOOLEAN Ja * - Feld is_active
default_approver_ids JSONB Ja * - Feld default_approver_ids
default_audience_kind VARCHAR(48) Ja * - Feld default_audience_kind
default_audience_roles JSONB Ja * - Feld default_audience_roles
default_audience_unit_ids JSONB Ja * - Feld default_audience_unit_ids
navigation JSONB Ja * - Feld navigation
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata

🔌 Inleidende punten (UI&API's)

Art Metode Eindpunt / pad Titel & Zweck Aanpassing
⚡ REST API DELETE /api/v1/publishing/pages/{page_id}/attachments/{document_id}
detach_document
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API GET /api/v1/publishing/dms-search
dms_search
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/feed
publishing_feed
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}
get_page
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}/attachments
list_attachments
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/sites
list_sites
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/members
list_members
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/pages
list_site_pages
Semantic binding: inventory_only; mutation=False
publishing
⚡ REST API PATCH /api/v1/publishing/pages/{page_id}
update_page
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API PATCH /api/v1/publishing/sites/{site_id}
update_site
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/pages
create_page
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/ack
acknowledge_page
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/attachments
attach_document
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/submit
submit_page
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/unpublish
unpublish_page
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API POST /api/v1/publishing/sites
create_site
Semantic binding: operator_surface; mutation=True
publishing
⚡ REST API PUT /api/v1/publishing/sites/{site_id}/members
set_member
Semantic binding: operator_surface; mutation=True
publishing
🖥️ WEB-UI GET /intranet
Intranet-feed
Gefilterde overzicht
Standard
🖥️ WEB-UI GET /intranet/pages/{id}/edit
Verwerking van de pagina
Aanhangsels van de onderhavige verordening
Standard
⚡ REST API POST /api/v1/publishing/pages/{id}/submit
Voor de vrijlating
Start omloop
Standard

🛡️ Reglementarische en compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • De Commissie heeft de Commissie verzocht om een aanvullende verordening te treffen.
  • Audit publicatie.aanhang_*
  • De volgende voorwaarden worden vastgesteld:
Gecombineerde modules:
➔ circulations ➔ documents ➔ tasks