ColivingLiguria

S.r.l. — Startup Innovativa
Apply Now

7 min read

GEMINI PRO MEMORIES - COLIVING LIGURIA RECONSTRUCTION

This document contains the absolute Source of Truth for the files lost during the CL-sync crash. Do not hallucinate code. Use the exact snippets provided below for the manual reconstruction of the LaTeX_CL submodule.

1. TODOAI: MASTER ARCHITECTURE PLAN (CL-BR & SYNC OVERHAUL)

# TODOAI: MASTER ARCHITECTURE PLAN - BureauRegister, Bilingual Automation & Sync Dashboard
 
## PHASE 1: "BureauRegister" (CL-BR) Creation & SQL Database
1. **Register Architecture:** Create a new register directory named `BureauRegister` (CLI: `CL-BR`). 
2. **SQL Database (The SSOT):** Initialize a new SQL database within `CL-BR`.
3. **Database Schema (`DocumentRegistry`):**
   - `Doc_ID` (String, PK)
   - `Doc_Category` (String/ENUM)
   - `Prefix_Letter` (String/CHAR)
   - `Major_Version` (Integer)
   - `Minor_Version` (Integer)
   - `Full_Version_Code` (String)
   - `Title_IT` / `Title_EN` (String)
   - `File_Path` (String)
   - `Total_Articles` (Integer)
   - `Is_Vexatious` (Boolean)
   - `Vexatious_Articles_List` (JSON Array of Integers)
   - `Vexatious_Desc_IT` / `Vexatious_Desc_EN` (String/TEXT)
 
## PHASE 2: Python Automation & Data Injection (The "Sync Engine")
1. **Database Extraction:** `sync_bureau.py` connects to SQL and fetches current records.
2. **Targeted LaTeX Injection:** Use hardcoded comment boundaries (`% --- BEGIN...`) to safely inject data via `expl3` property lists without overwriting structural LaTeX.
3. **Task A:** Generate the Official Internal Registry (Allegato R) table.
4. **Task B:** Populate the Smart Closing Macro Dictionary.
5. **Sync Dashboard Integration:** Dashboard MUST execute `sync_bureau.py` and wait for Exit 0 before triggering any `pdflatex` compilation.
 
## PHASE 3: The "Smart Closing Macro" Implementation
1. **File:** `System/pre/pre/macros/contract_closing.tex`
2. **Inputs:** `\makeClosingBlock{<Attachments_List>}{<Contract_Articles_List>}`
3. **Execution Logic:**
   - Print Summary Table fetching `Version_Code` and `Bilingual_Title` from injected `expl3` data.
   - Print Vexatious Clauses (Approvazione Specifica) iterating through inputs. If attachment `Is_Vexatious == True`, print description.
   - Append `\printConditionalSignatureBlock`.
 
## PHASE 4: LaTeX Single-Source Bilingual Refactoring
1. **Purge Legacy:** Delete all `_EN.tex` files.
2. **Macro:** Wrap all text in `\Bilingual{Italian}{English}`. Break into sentence-by-sentence blocks.
3. **Courtesy Translation Guardrail:** If compiled in EN/BOTH, automatically inject `\translationFooter` stating English is an unofficial facsimile with NO legal efficacy (Savona jurisdiction prevails).
 
## PHASE 5: Sync Dashboard Frontend & Compilation Engine
1. **Document Navigation UI:** Mirror LaTeX directory exactly. Hide `Private_Archive`.
2. **Language Selector:** `Italian`, `English`, `Bilingual`.
3. **Backend Trigger:** Inject language flag into `pdflatex`, compile, and download to Desktop (zipped if batch).

2. LATEX FILE: Contract_for_Internship.tex

Path: /Users/nianoble-wedd/Projects/CL/LaTeX_CL/Contract_for_Internship.tex

% !TEX root = Contract_for_Internship.tex
% !TEX program = pdflatex
\providecommand{\rootPath}{../../../../Private_Archive/}
\input{\rootPath System/pre/pre}
\input{\rootPath System/pre/pre/macros/attachment_configs}
\input{../../Allegati/_G_Tutela_Asset_Non-tangibili.tex}
 
\Courtesyfalse 
\translationFooter 
 
% ========================================================
% CONFIGURAZIONE VARIABILI DEL CONTRATTO
% ========================================================
\providecommand{\signatoryNameSurname}{\underline{\hspace{8cm}}}
\providecommand{\signatoryBirthInfo}{\underline{\hspace{8cm}}}
\providecommand{\signatoryResidency}{\underline{\hspace{8cm}}}
\providecommand{\signatoryEmail}{\underline{\hspace{6cm}}}
\providecommand{\signatoryPhone}{\underline{\hspace{6cm}}}
\providecommand{\signatoryCF}{\underline{\hspace{6cm}}}
\providecommand{\signatoryDocType}{\underline{\hspace{3cm}}}
\providecommand{\signatoryDocNum}{\underline{\hspace{3cm}}}
 
\providecommand{\promoterName}{\underline{\hspace{6cm}}}
\providecommand{\promoterProtocol}{\underline{\hspace{4cm}}} 
\providecommand{\contractCodeString}{IN01-\underline{\hspace{2cm}}}
\providecommand{\internStartDate}{\underline{\hspace{4cm}}}
\providecommand{\internEndDate}{\underline{\hspace{4cm}}}
\providecommand{\taskListInternalCode}{\underline{\hspace{4cm}}} 
 
\providecommand{\accomYes}{\Square}
\providecommand{\accomNo}{\Square}
\providecommand{\contractRCode}{\underline{\hspace{4cm}}}
 
\begin{document}
\makeContractCover
    {\Bilingual{Contratto di Tirocinio e Formazione}{Internship and Training Agreement}}
    {\contractCodeString}
    {\signatoryNameSurname}
    {\signatoryBirthInfo}
    {\signatoryCF}
    {---}
    {\signatoryEmail}
    {\signatoryPhone}
    {\signatoryDocType\ n.\ \signatoryDocNum}
 
\pagebreak
\makeTOC
\makeContractingParties
 
\vspace{0.8cm}
\customSection{\Bilingual{Ente Promotore e Convenzione di Riferimento}{Promoting Entity and Reference Agreement}}
\noindent \Bilingual{Il presente rapporto di tirocinio è promosso, autorizzato e formalmente inquadrato sotto l'egida del seguente soggetto:}{This internship relationship is promoted, authorised, and formally framed under the auspices of the following entity:}
\vspace{0.4cm}
\noindent \textbf{\Bilingual{Denominazione Ente:}{Entity Name:}} \textbf{\promoterName}
 
\vspace{1cm}
\begin{center} \Large\bfseries \Bilingual{Si conviene e stipula quanto segue:}{It is agreed and stipulated as follows:} \end{center}
\newpage
 
\contractArticle{\Bilingual{Oggetto, Tipologia di Progetto e Disposizioni Economiche}{Subject, Project Type and Economic Provisions}}
\subsection{\Bilingual{Prevalenza Documentale}{Document Prevalence}}
\Bilingual{Il Tirocinante si assume la totale responsabilità di gestire le comunicazioni con l'Ente Promotore. Le clausole qui pattuite prevalgono su qualsiasi altro modulo standard dell'Ente Promotore.}{The Trainee assumes total responsibility for managing communications with the Promoting Entity. The clauses stipulated herein prevail over any other standard form of the Promoting Entity.}
 
\contractArticle{\Bilingual{Mansioni e Proprietà Intellettuale}{Duties and Intellectual Property}}
\subsection{\Bilingual{Proprietà Intellettuale dei Risultati}{Intellectual Property of Results}}
\Bilingual{In rigorosa conformità all'\textbf{Allegato G}, ogni risultato o codice realizzato appartiene in via esclusiva a ColivingLiguria S.r.l.}{In strict accordance with \textbf{Attachment G}, any result or code created belongs exclusively to ColivingLiguria S.r.l.}
 
\contractArticle{\Bilingual{Condizioni Essenziali e Gestione Finanziaria}{Essential Conditions and Financial Management}}
\subsection{\Bilingual{Condizione Sospensiva Assicurativa (INAIL e RC)}{Suspensive Insurance Condition (INAIL and RC)}}
\Bilingual{L'efficacia del contratto è sottoposta alla condizione sospensiva del pagamento dei premi INAIL e RC dall'Ente Promotore. In difetto, il contratto è nullo ex tunc.}{The validity of the contract is subject to the suspensive condition of the payment of INAIL and RC premiums by the Promoting Entity. Failing this, the contract is null and void ex tunc.}
 
\contractArticle{\Bilingual{Disposizioni Finali e Foro Competente}{Final Provisions and Competent Court}}
\Bilingual{Per ogni controversia è competente in via esclusiva il Foro di Savona.}{For any dispute, the Court of Savona shall have exclusive jurisdiction.}
 
\vspace{1.5cm}
\SignatureRowTwo{\SignPhysSecondParty[\Bilingual{Il Tirocinante}{The Trainee}]{\signatoryNameSurname}}{\SignDigiBusiness[]}
 
\newpage
\section*{\Bilingual{Approvazione Specifica ai sensi degli art. 1341 e 1342 c.c.}{Specific Approval pursuant to Articles 1341 and 1342 of the Italian Civil Code}}
\Bilingual{Il Firmatario approva specificamente le seguenti clausole:}{The Signatory specifically approves the following clauses:}
\begin{itemize}
    \item \textbf{Art. 1} (\Bilingual{Prevalenza Documentale}{Document Prevalence});
    \item \textbf{Art. 2} (\Bilingual{Proprietà Intellettuale}{Intellectual Property});
    \item \textbf{Art. 3} (\Bilingual{Condizione Sospensiva Assicurativa e Penali}{Suspensive Insurance Condition and Penalties});
    \item \textbf{Allegato G} (\Bilingual{Divieti di divulgazione e segreto industriale}{Prohibitions of disclosure and industrial secret});
    \item \textbf{Allegato F} (\Bilingual{Gestione della Linea di Debito}{Debt Line management}).
\end{itemize}
\vspace{1cm}
\printConditionalSignatureBlock{\signatoryNameSurname}
 
\newpage
\renderAllegatoG
\end{document}

3. LATEX FILE: _G_Tutela_Asset_Non-tangibili.tex (Attachment G)

Path: /Users/nianoble-wedd/Projects/CL/LaTeX_CL/Allegati/_G_Tutela_Asset_Non-tangibili.tex

% !TEX root = _G_Tutela_Asset_Non-tangibili.tex
\providecommand{\accessValidityTerm}{\underline{\hspace{4cm}}}
 
\customSection{\Bilingual{Allegato G: Tutela degli Asset Non Tangibili, Segreto Industriale e Database SQL}{Attachment G: Protection of Intangible Assets, Industrial Secret and SQL Databases}}
 
\subsection{\Bilingual{Definizione degli Asset Aziendali}{Definition of Corporate Assets}}
\Bilingual{Ai fini del presente accordo, per "Asset Non Tangibili" si intendono tutti i codici sorgente (Python, Bash, LaTeX, ecc.), le architetture di sistema, i prompt ingegnerizzati per le IA, i database SQL (inclusi schemi e dati del BureauRegister), le liste clienti, i manuali operativi e qualsiasi altra informazione tecnica o commerciale di proprietà di ColivingLiguria S.r.l.}{For the purposes of this agreement, "Intangible Assets" shall mean all source codes (Python, Bash, LaTeX, etc.), system architectures, engineered prompts for AI, SQL databases (including schemas and BureauRegister data), customer lists, operational manuals and any other technical or commercial information owned by ColivingLiguria S.r.l.}
 
\subsection{\Bilingual{Vincolo di Segretezza e Divieto di Esportazione}{Secrecy Obligation and Prohibition of Export}}
\Bilingual{Il Firmatario si impegna a mantenere il più rigoroso segreto industriale. È fatto divieto assoluto di scaricare in locale, copiare su supporti personali, inviare tramite email a terzi o salvare su cloud non aziendali qualsiasi stringa di codice, dump SQL o documento strategico.}{The Signatory undertakes to maintain the strictest industrial secret. It is absolutely forbidden to download locally, copy to personal media, send via email to third parties or save on non-corporate clouds any line of code, SQL dump or strategic document.} 
 
\subsection{\Bilingual{Proprietà Esclusiva}{Exclusive Ownership}}
\Bilingual{Ogni modifica, ottimizzazione o nuovo script realizzato dal Firmatario diviene automaticamente e irrevocabilmente di proprietà esclusiva di ColivingLiguria S.r.l.}{Any modification, optimisation or new script created by the Signatory automatically and irrevocably becomes the exclusive property of ColivingLiguria S.r.l.}

4. LATEX FILE: Defining_Parties_Macro.tex

Path: /Users/nianoble-wedd/Projects/CL/LaTeX_CL/System/pre/pre/macros/Defining_Parties_Macro.tex

% !TEX root = Defining_Parties_Macro.tex
\newcommand{\makeContractingParties}{
    \vspace{0.5cm}
    \noindent \textbf{\Bilingual{TRA}{BETWEEN}}
    \vspace{0.3cm}
    
    \noindent \textbf{ColivingLiguria S.r.l.} (Startup Innovativa), \Bilingual{con sede legale in Via Pia 71, 17100 Savona (SV), P.IVA e C.F. 01878890096, in persona del proprio Amministratore Unico e legale rappresentante pro tempore,}{with registered office in Via Pia 71, 17100 Savona (SV), VAT no. and Tax Code 01878890096, represented by its Sole Director and legal representative pro tempore,} (di seguito definita "Società" o "ColivingLiguria")
    
    \vspace{0.4cm}
    \begin{center} \textbf{\Bilingual{E}{AND}} \end{center}
    \vspace{0.4cm}
    
    \noindent \textbf{\signatoryNameSurname}, \Bilingual{nato/a a \signatoryBirthInfo, residente in \signatoryResidency, C.F. \signatoryCF, identificato/a a mezzo \signatoryDocType\ n.\ \signatoryDocNum}{born in \signatoryBirthInfo, residing in \signatoryResidency, Tax Code \signatoryCF, identified by \signatoryDocType\ no.\ \signatoryDocNum} (di seguito definito "Firmatario" o "Tirocinante")
    \vspace{0.8cm}
}

Graph View