📘

It-tħaddim u l-eżami tad-dokumenti

circulations crm_office 🛡️ RLS Protected

Il-proċessi u d-dokumenti li ġejjin minn kodiċi

Fachliche Bestimmung: Dokumenti u eżamijiet <unk> Dokumentazzjoni tal-proċess u l-API derivat mill-kodiċi.

⚡ Flussi ta' xogħol u ċikli ta' ħajja (2) 🗄️ Modelli tad-dejta & Felder (3) 🔌 Punti ta' Bidu (UI & API) (23) 🛡️ Regolatorji u konformità

⚡ Flussi ta' xogħol u ċikli ta' ħajja

L-użu tal-prodott: `plan:command_circulation_agent`

Geprüfter Durable-Plan (durable_plan), Start: manual_command.

1. circulation_agent

circulation_agent

{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "circulation_agent", "condition_fact": null}

Aktionen: circulation_agent

Il-ġarr `status:circulation`

L-użu tal-apparat tal-istatus osservattiv (observable_only) ma jkunx obbligat.

1. draft

l-abbozz

Statut <unk> abbozz <unk> il-magna tal-istat

2. active

attiv

Statut <unk>attiv<unk> tal-magna tal-istat.

3. completed

kompluta

Stat <unk> komplet <unk> tal-magna tal-istat

4. rejected

Redditu

Stat <unk>Regettat<unk> tal-magna tal-istat.

5. returned

irritorna

Statut <unk>Returnat <unk> il-magna tal-istat

6. cancelled

ikkanċellati

Stat <unk>Cancelled<unk> tal-magna tal-istat.

🗄️ Modelli tad-dejta & Felder

CirculationComments circulation_comments RLS Aktiv

13 Il-kamps / il-kolla

Tabelle circulation_comments

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`circulation_id`	`UUID`	Ja *	FK ➔ document_circulations.id	Feld circulation_id
`step_id`	`UUID`	Nein	FK ➔ circulation_steps.id	Feld step_id
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`author_id`	`UUID`	Nein	FK ➔ organization_users.id	Feld author_id
`page`	`INTEGER`	Ja *	-	Feld page
`x`	`FLOAT`	Ja *	-	Feld x
`y`	`FLOAT`	Ja *	-	Feld y
`text`	`TEXT`	Ja *	-	Feld text
`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

CirculationStamps circulation_stamps RLS Aktiv

16 Il-kamps / il-kolla

Tabelle circulation_stamps

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`circulation_id`	`UUID`	Ja *	FK ➔ document_circulations.id	Feld circulation_id
`step_id`	`UUID`	Nein	FK ➔ circulation_steps.id	Feld step_id
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`placed_by`	`UUID`	Nein	FK ➔ organization_users.id	Feld placed_by
`page`	`INTEGER`	Ja *	-	Feld page
`x`	`FLOAT`	Ja *	-	Feld x
`y`	`FLOAT`	Ja *	-	Feld y
`width`	`FLOAT`	Ja *	-	Feld width
`height`	`FLOAT`	Ja *	-	Feld height
`text`	`VARCHAR(255)`	Ja *	-	Feld text
`color`	`VARCHAR(7)`	Ja *	-	Feld color
`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

CirculationSteps circulation_steps RLS Aktiv

17 Il-kamps / il-kolla

Tabelle circulation_steps

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`circulation_id`	`UUID`	Ja *	FK ➔ document_circulations.id	Feld circulation_id
`position`	`INTEGER`	Ja *	-	Feld position
`assignee_id`	`UUID`	Ja *	FK ➔ organization_users.id	Feld assignee_id
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`instructions`	`TEXT`	Nein	-	Feld instructions
`assigned_at`	`DATETIME`	Nein	-	Feld assigned_at
`started_at`	`DATETIME`	Nein	-	Feld started_at
`completed_at`	`DATETIME`	Nein	-	Feld completed_at
`decision`	`VARCHAR(32)`	Nein	-	Feld decision
`notes`	`TEXT`	Nein	-	Feld notes
`due_at`	`DATETIME`	Nein	-	Feld due_at
`decision_comment`	`TEXT`	Nein	-	Feld decision_comment
`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

🔌 Punti ta' Bidu (UI & API)

Art	Il-metodu	Punti ta ' tmiem / pjaċċ	Titel & Zweck	L-eżenzjoni
⚡ REST API	DELETE	`/api/v1/circulations/{circulation_id}/assignees/{step_id}`	remove_assignee Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	DELETE	`/api/v1/circulations/{circulation_id}/documents/{document_id}`	remove_document Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	GET	`/api/v1/circulations`	list_circulations Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/api/v1/circulations/{circulation_id}`	get_circulation Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/api/v1/circulations/{circulation_id}/documents/{document_id}/preview`	document_preview Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/api/v1/circulations/{circulation_id}/final-pdf`	download_final_pdf Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/circulations`	circulations_page Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/circulations/new`	circulation_create_page Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	GET	`/circulations/{circulation_id}`	circulation_detail_page Semantic binding: inventory_only; mutation=False	`circulations`
⚡ REST API	PATCH	`/api/v1/circulations/{circulation_id}`	update_circulation Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	PATCH	`/api/v1/circulations/{circulation_id}/assignees/{step_id}`	update_assignee Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations`	create_circulation Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/assignees`	add_assignee Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/begin-review`	begin_review Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/cancel`	cancel_circulation Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/comments`	add_comment Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/complete-step`	complete_step Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/documents`	add_document Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/return`	return_for_revision Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/stamps`	add_stamp Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/start`	start_circulation Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/steps/reorder`	reorder_steps Semantic binding: operator_surface; mutation=True	`circulations`
⚡ REST API	POST	`/api/v1/circulations/{circulation_id}/upload`	upload_document Semantic binding: operator_surface; mutation=True	`circulations`

🛡️ Regolatorji u konformità

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

L-impriża għandha tinvestiga l-impriża.
Il-konnessjoni tal-konnessjoni