[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","ed5e6d5a-ac56-11f1-9e36-1607ee4eb77e","name","fileType","http","content","/**\n * Val Town HTTP val — importa le commesse reali (185 righe) sulla scheda\n * \"Elenco Commesse\" (board id 5103849226), nel gruppo \"Commesse Attive\".\n *\n * Lavora a LOTTI per evitare il timeout di Val Town sulle richieste HTTP:\n * ogni chiamata crea al massimo BATCH_SIZE righe, poi la pagina richiama\n * automaticamente il passo successivo mostrando una barra di avanzamento.\n *\n * USO: apri l'URL del val nel browser (nessun parametro) e clicca\n * \"Avvia caricamento\".\n *\n * Richiede la env var MONDAY_TOKEN.\n *\n * Nota tecnica: lo script client è servito come file JS separato\n * (?asset=app.js) invece che inline nell'HTML, per evitare problemi con\n * eventuali policy di sicurezza che bloccano lo script incorporato.\n */\n\nconst API_URL = \"https://api.monday.com/v2\";\nconst BOARD_ID = \"5103849226\";\nconst GROUP_TITLE = \"Commesse Attive\";\nconst CLIENTE_COLUMN_TITLE = \"Cliente\";\nconst PL_COLUMN_TITLE = \"PL (da assegnare)\";\nconst BATCH_SIZE = 12;\n\ninterface Row {\n work: string;\n cliente: string;\n pl: string;\n}\n\nconst DATA: Row[] = [\n {\n \"work\": \"T_26/210\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/208\",\n \"cliente\": \"AMARC02\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/207\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/203\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/205\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/206\",\n \"cliente\": \"SITE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/046.05\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.27\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/033.28\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/200\",\n \"cliente\": \"ISOIL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/201\",\n \"cliente\": \"COMUNE DI SPIGNO MONFERRATO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/197\",\n \"cliente\": \"ASCANI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/192\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.24\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/184.03\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/191\",\n \"cliente\": \"SICAM\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/190\",\n \"cliente\": \"FERROVIENORD\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/188\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/187\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/212.03\",\n \"cliente\": \"CIIP\",\n \"pl\": \"LEONARDUZZI\",\n },\n {\n \"work\": \"T_25/_01.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/183\",\n \"cliente\": \"COGEN\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/180\",\n \"cliente\": \"SEI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/177\",\n \"cliente\": \"SIEL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/172\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/174\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"T_26/175\",\n \"cliente\": \"AP RETI01\",\n \"pl\": \"CINQUEGRANA\",\n },\n {\n \"work\": \"T_26/033.22\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/170\",\n \"cliente\": \"BACINI-PIACENTINI_03\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/171\",\n \"cliente\": \"SORICAL\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_24/333.02\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/162\",\n \"cliente\": \"COMUNI RIUNITI BM\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/164\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/165\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/166\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/158\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/153\",\n \"cliente\": \"AIR LIQUIDE\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/156\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/157\",\n \"cliente\": \"A.QUANTUM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/135.02\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/135.03\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/200.01\",\n \"cliente\": \"ETRA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/139\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/143\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/146\",\n \"cliente\": \"ECODEPURA\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/147\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/137\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/134\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"MAZZUCCHI\",\n },\n {\n \"work\": \"T_26/135\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/322.01\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/124\",\n \"cliente\": \"GIOVANNI MALINCONICO\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/125\",\n \"cliente\": \"CAFC\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/121\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"PASSA\",\n },\n {\n \"work\": \"T_26/114\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/115\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/108\",\n \"cliente\": \"HERA-TECH_SRL\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/109\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/111\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/105\",\n \"cliente\": \"TAMAI E MINETTO_01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/099\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/046.03\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/046.04\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/033.05\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.06\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.07\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.08\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.09\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.10\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.11\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/087\",\n \"cliente\": \"TALETE\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/088\",\n \"cliente\": \"ELETTROPIU01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/090\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/093\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/096\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/076\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/077\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/069\",\n \"cliente\": \"TEAPER\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/064\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/066\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_26/061\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/063\",\n \"cliente\": \"LARIO\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/053\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/054\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/046\",\n \"cliente\": \"EUROCONDOTTE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/043\",\n \"cliente\": \"AQA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/033\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/034\",\n \"cliente\": \"MARCHE MULTISERVIZI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/035\",\n \"cliente\": \"INRETESPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/036\",\n \"cliente\": \"AIMAG\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/032\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/024\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/011\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/012\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/016\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/010\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/009\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"2023/001\",\n \"cliente\": \"REGIONE MOLISE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2023/142.02\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/397\",\n \"cliente\": \"CABRINI ALBINO\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/395\",\n \"cliente\": \"LTA\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/212\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/010\",\n \"cliente\": \"CONSTRAT\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/385\",\n \"cliente\": \"R.G.A.\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/142.01\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/297\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/318\",\n \"cliente\": \"GRIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/367\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/252\",\n \"cliente\": \"CEBAT\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/340\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/322\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/213\",\n \"cliente\": \"NEVERHACK\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/305\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/300\",\n \"cliente\": \"AP RETI02\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/079\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/267\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/230\",\n \"cliente\": \"RIVIERACQUA\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/226\",\n \"cliente\": \"AMAG\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/223\",\n \"cliente\": \"ACDA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/388\",\n \"cliente\": \"ACDA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/323\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/514\",\n \"cliente\": \"SICILIACQUE01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/046\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/191\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/184\",\n \"cliente\": \"MM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/180\",\n \"cliente\": \"BRIANZACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/155\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/130\",\n \"cliente\": \"ATS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/098\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/097\",\n \"cliente\": \"AMAMBIENTE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2022/171\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/066\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/047\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CORTELLINO\",\n },\n {\n \"work\": \"2022/018\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2024/103\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"DODA\",\n },\n {\n \"work\": \"T_25/030\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/014\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/_03\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_24/190\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/467\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/455\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/442\",\n \"cliente\": \"ACINQUE INNOVAZIONE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_24/426\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/315\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/408\",\n \"cliente\": \"ENYDROS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/379\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_24/374\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/334\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_24/317\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/518\",\n \"cliente\": \"TEATEK\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/250\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/234\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/541\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_24/212.01\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/209\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/374\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2024/111\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2024/072\",\n \"cliente\": \"ACQUE VERONESI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/558\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/546\",\n \"cliente\": \"ACQUEDOTTO DEL FIORA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/530\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2023/536.PVE.07\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.PVE.06\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/197\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2023/536.BIM.00\",\n \"cliente\": \"BIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536\",\n \"cliente\": \"VIVERACQUA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.BIM.01\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/491\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2023/420\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/411\",\n \"cliente\": \"ACQUE VENETE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/004\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/349\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/319\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/163\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/321\",\n \"cliente\": \"UNIBO01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/072\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/006\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2022/433\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2021/540\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/543\",\n \"cliente\": \"VIACQUA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/536.ATS.04\",\n \"cliente\": \"ATS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/215\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2021/455\",\n \"cliente\": \"IREN-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"T_24/477\",\n \"cliente\": \"ABBANOA\",\n \"pl\": \"CESANI\",\n },\n];\n\nasync function callMonday(\n token: string,\n query: string,\n variables: Record,\n) {\n const res = await fetch(API_URL, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": token,\n },\n body: JSON.stringify({ query, variables }),\n });\n const json = await res.json();\n if (json.errors) {\n throw new Error(JSON.stringify(json.errors));\n }\n return json.data;\n}\n\nfunction sleep(ms: number) {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\nasync function runBatch(token: string) {\n const boardQuery = `\n query ($boardId: [ID!]) {\n boards(ids: $boardId) {\n columns { id title type }\n groups { id title }\n items_page(limit: 500) { items { id name } }\n }\n }`;\n const boardData = await callMonday(token, boardQuery, {\n boardId: [BOARD_ID],\n });\n const board = boardData.boards[0];\n\n const clienteCol = board.columns.find((c: any) =>\n c.title === CLIENTE_COLUMN_TITLE\n );\n if (!clienteCol) {\n throw new Error(`Colonna \"${CLIENTE_COLUMN_TITLE}\" non trovata sul board.`);\n }\n\n let plCol = board.columns.find((c: any) => c.title === PL_COLUMN_TITLE);\n if (!plCol) {\n const createColQuery = `\n mutation ($boardId: ID!, $title: String!) {\n create_column(board_id: $boardId, title: $title, column_type: text) { id title }\n }`;\n const created = await callMonday(token, createColQuery, {\n boardId: BOARD_ID,\n title: PL_COLUMN_TITLE,\n });\n plCol = created.create_column;\n }\n\n const group = board.groups.find((g: any) => g.title === GROUP_TITLE);\n if (!group) {\n throw new Error(`Gruppo \"${GROUP_TITLE}\" non trovato sul board.`);\n }\n\n const existingNames = new Set(board.items_page.items.map((i: any) => i.name));\n const toCreate = DATA.filter((row) => !existingNames.has(row.work));\n const remainingBefore = toCreate.length;\n const batch = toCreate.slice(0, BATCH_SIZE);\n\n let createdThisBatch = 0;\n const failures: string[] = [];\n\n for (const row of batch) {\n const columnValues: Record = {\n [clienteCol.id]: row.cliente,\n [plCol.id]: row.pl,\n };\n try {\n const createItemQuery = `\n mutation ($boardId: ID!, $groupId: String, $itemName: String!, $columnValues: JSON) {\n create_item(board_id: $boardId, group_id: $groupId, item_name: $itemName, column_values: $columnValues) { id }\n }`;\n await callMonday(token, createItemQuery, {\n boardId: BOARD_ID,\n groupId: group.id,\n itemName: row.work,\n columnValues: JSON.stringify(columnValues),\n });\n createdThisBatch++;\n } catch (e) {\n failures.push(`${row.work} (${row.cliente}): ${e.message}`);\n }\n await sleep(100);\n }\n\n const remainingAfter = remainingBefore - batch.length;\n return {\n totalRows: DATA.length,\n alreadyDone: DATA.length - remainingBefore,\n createdThisBatch,\n failures,\n remaining: remainingAfter,\n done: remainingAfter <= 0,\n };\n}\n\nconst PAGE_HTML = `\n\n\n\nImport commesse su Monday\n\n\n\n

Import commesse reali su Monday

Carica ${DATA.length} commesse sulla scheda \"Elenco Commesse\", gruppo \"Commesse Attive\".

\n \n

In attesa di avvio.

\n \n\n`;\n\nconst CLIENT_JS = `\nlet totalFailures = [];\n\nfunction start() {\n document.getElementById(\"startBtn\").disabled = true;\n document.getElementById(\"status\").textContent = \"Avvio in corso...\";\n step(0);\n}\n\nfunction step(iteration) {\n if (iteration > 40) {\n document.getElementById(\"status\").textContent = \"Mi sono fermato dopo troppi tentativi. Controlla i dettagli qui sotto e ricarica la pagina per riprendere.\";\n return;\n }\n fetch(\"?action=batch\", { method: \"POST\" })\n .then(function (res) { return res.json(); })\n .then(function (data) {\n if (data.error) {\n document.getElementById(\"status\").textContent = \"ERRORE: \" + data.error;\n return;\n }\n var percent = Math.round((data.alreadyDone / data.totalRows) * 100);\n document.getElementById(\"bar-fill\").style.width = percent + \"%\";\n document.getElementById(\"status\").textContent =\n \"Caricate \" + data.alreadyDone + \" di \" + data.totalRows + \" (\" + percent + \"%)\";\n\n if (data.failures && data.failures.length > 0) {\n totalFailures = totalFailures.concat(data.failures);\n document.getElementById(\"failures\").textContent =\n \"Righe non create finora (\" + totalFailures.length + \"):\\n\" + totalFailures.join(\"\\n\");\n }\n\n if (data.done) {\n document.getElementById(\"status\").textContent =\n \"Caricamento completato: \" + data.alreadyDone + \" commesse su Monday.\";\n document.getElementById(\"startBtn\").disabled = false;\n document.getElementById(\"startBtn\").textContent = \"Fatto\";\n } else {\n step(iteration + 1);\n }\n })\n .catch(function () {\n document.getElementById(\"status\").textContent = \"Errore di rete, riprovo tra 2 secondi...\";\n setTimeout(function () { step(iteration + 1); }, 2000);\n });\n}\n\ndocument.addEventListener(\"DOMContentLoaded\", function () {\n var btn = document.getElementById(\"startBtn\");\n if (btn) btn.addEventListener(\"click\", start);\n});\n`;\n\nexport default async function (req: Request): Promise {\n const token = Deno.env.get(\"MONDAY_TOKEN\");\n const url = new URL(req.url);\n const action = url.searchParams.get(\"action\");\n const asset = url.searchParams.get(\"asset\");\n\n if (asset === \"app.js\") {\n return new Response(CLIENT_JS, {\n status: 200,\n headers: { \"Content-Type\": \"application/javascript; charset=utf-8\" },\n });\n }\n\n if (action === \"batch\") {\n if (!token) {\n return new Response(\n JSON.stringify({ error: \"Manca la env var MONDAY_TOKEN.\" }),\n {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n try {\n const result = await runBatch(token);\n return new Response(JSON.stringify(result), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (e) {\n return new Response(JSON.stringify({ error: e.message }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n return new Response(PAGE_HTML, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","/**\n * Val Town HTTP val — importa le commesse reali (185 righe) sulla scheda\n * \"Elenco Commesse\" (board id 5103849226), nel gruppo \"Commesse Attive\".\n *\n * Lavora a LOTTI per evitare il timeout di Val Town sulle richieste HTTP:\n * ogni chiamata crea al massimo BATCH_SIZE righe, poi la pagina richiama\n * automaticamente il passo successivo mostrando una barra di avanzamento.\n *\n * USO: apri l'URL del val nel browser (nessun parametro) e clicca\n * \"Avvia caricamento\".\n *\n * Richiede la env var MONDAY_TOKEN.\n *\n * Nota tecnica: lo script client è servito come file JS separato\n * (?asset=app.js) invece che inline nell'HTML, per evitare problemi con\n * eventuali policy di sicurezza che bloccano lo script incorporato.\n */\n\nconst API_URL = \"https://api.monday.com/v2\";\nconst BOARD_ID = \"5103849226\";\nconst GROUP_TITLE = \"Commesse Attive\";\nconst CLIENTE_COLUMN_TITLE = \"Cliente\";\nconst PL_COLUMN_TITLE = \"PL (da assegnare)\";\nconst BATCH_SIZE = 12;\n\ninterface Row {\n work: string;\n cliente: string;\n pl: string;\n}\n\nconst DATA: Row[] = [\n {\n \"work\": \"T_26/210\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/208\",\n \"cliente\": \"AMARC02\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/207\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/203\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/205\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/206\",\n \"cliente\": \"SITE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/046.05\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.27\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/033.28\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/200\",\n \"cliente\": \"ISOIL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/201\",\n \"cliente\": \"COMUNE DI SPIGNO MONFERRATO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/197\",\n \"cliente\": \"ASCANI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/192\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.24\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/184.03\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/191\",\n \"cliente\": \"SICAM\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/190\",\n \"cliente\": \"FERROVIENORD\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/188\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/187\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/212.03\",\n \"cliente\": \"CIIP\",\n \"pl\": \"LEONARDUZZI\",\n },\n {\n \"work\": \"T_25/_01.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/183\",\n \"cliente\": \"COGEN\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/180\",\n \"cliente\": \"SEI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/177\",\n \"cliente\": \"SIEL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/172\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/174\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"T_26/175\",\n \"cliente\": \"AP RETI01\",\n \"pl\": \"CINQUEGRANA\",\n },\n {\n \"work\": \"T_26/033.22\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/170\",\n \"cliente\": \"BACINI-PIACENTINI_03\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/171\",\n \"cliente\": \"SORICAL\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_24/333.02\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/162\",\n \"cliente\": \"COMUNI RIUNITI BM\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/164\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/165\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/166\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/158\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/153\",\n \"cliente\": \"AIR LIQUIDE\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/156\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/157\",\n \"cliente\": \"A.QUANTUM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/135.02\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/135.03\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/200.01\",\n \"cliente\": \"ETRA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/139\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/143\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/146\",\n \"cliente\": \"ECODEPURA\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/147\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/137\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/134\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"MAZZUCCHI\",\n },\n {\n \"work\": \"T_26/135\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/322.01\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/124\",\n \"cliente\": \"GIOVANNI MALINCONICO\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/125\",\n \"cliente\": \"CAFC\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/121\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"PASSA\",\n },\n {\n \"work\": \"T_26/114\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/115\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/108\",\n \"cliente\": \"HERA-TECH_SRL\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/109\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/111\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/105\",\n \"cliente\": \"TAMAI E MINETTO_01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/099\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/046.03\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/046.04\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/033.05\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.06\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.07\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.08\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.09\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.10\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.11\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/087\",\n \"cliente\": \"TALETE\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/088\",\n \"cliente\": \"ELETTROPIU01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/090\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/093\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/096\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/076\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/077\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/069\",\n \"cliente\": \"TEAPER\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/064\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/066\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_26/061\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/063\",\n \"cliente\": \"LARIO\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/053\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/054\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/046\",\n \"cliente\": \"EUROCONDOTTE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/043\",\n \"cliente\": \"AQA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/033\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/034\",\n \"cliente\": \"MARCHE MULTISERVIZI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/035\",\n \"cliente\": \"INRETESPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/036\",\n \"cliente\": \"AIMAG\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/032\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/024\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/011\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/012\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/016\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/010\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/009\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"2023/001\",\n \"cliente\": \"REGIONE MOLISE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2023/142.02\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/397\",\n \"cliente\": \"CABRINI ALBINO\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/395\",\n \"cliente\": \"LTA\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/212\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/010\",\n \"cliente\": \"CONSTRAT\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/385\",\n \"cliente\": \"R.G.A.\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/142.01\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/297\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/318\",\n \"cliente\": \"GRIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/367\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/252\",\n \"cliente\": \"CEBAT\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/340\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/322\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/213\",\n \"cliente\": \"NEVERHACK\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/305\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/300\",\n \"cliente\": \"AP RETI02\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/079\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/267\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/230\",\n \"cliente\": \"RIVIERACQUA\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/226\",\n \"cliente\": \"AMAG\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/223\",\n \"cliente\": \"ACDA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/388\",\n \"cliente\": \"ACDA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/323\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/514\",\n \"cliente\": \"SICILIACQUE01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/046\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/191\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/184\",\n \"cliente\": \"MM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/180\",\n \"cliente\": \"BRIANZACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/155\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/130\",\n \"cliente\": \"ATS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/098\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/097\",\n \"cliente\": \"AMAMBIENTE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2022/171\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/066\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/047\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CORTELLINO\",\n },\n {\n \"work\": \"2022/018\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2024/103\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"DODA\",\n },\n {\n \"work\": \"T_25/030\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/014\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/_03\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_24/190\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/467\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/455\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/442\",\n \"cliente\": \"ACINQUE INNOVAZIONE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_24/426\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/315\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/408\",\n \"cliente\": \"ENYDROS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/379\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_24/374\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/334\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_24/317\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/518\",\n \"cliente\": \"TEATEK\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/250\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/234\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/541\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_24/212.01\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/209\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/374\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2024/111\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2024/072\",\n \"cliente\": \"ACQUE VERONESI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/558\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/546\",\n \"cliente\": \"ACQUEDOTTO DEL FIORA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/530\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2023/536.PVE.07\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.PVE.06\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/197\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2023/536.BIM.00\",\n \"cliente\": \"BIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536\",\n \"cliente\": \"VIVERACQUA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.BIM.01\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/491\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2023/420\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/411\",\n \"cliente\": \"ACQUE VENETE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/004\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/349\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/319\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/163\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/321\",\n \"cliente\": \"UNIBO01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/072\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/006\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2022/433\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2021/540\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/543\",\n \"cliente\": \"VIACQUA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/536.ATS.04\",\n \"cliente\": \"ATS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/215\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2021/455\",\n \"cliente\": \"IREN-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"T_24/477\",\n \"cliente\": \"ABBANOA\",\n \"pl\": \"CESANI\",\n },\n];\n\nasync function callMonday(\n token: string,\n query: string,\n variables: Record,\n) {\n const res = await fetch(API_URL, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": token,\n },\n body: JSON.stringify({ query, variables }),\n });\n const json = await res.json();\n if (json.errors) {\n throw new Error(JSON.stringify(json.errors));\n }\n return json.data;\n}\n\nfunction sleep(ms: number) {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\nasync function runBatch(token: string) {\n const boardQuery = `\n query ($boardId: [ID!]) {\n boards(ids: $boardId) {\n columns { id title type }\n groups { id title }\n items_page(limit: 500) { items { id name } }\n }\n }`;\n const boardData = await callMonday(token, boardQuery, {\n boardId: [BOARD_ID],\n });\n const board = boardData.boards[0];\n\n const clienteCol = board.columns.find((c: any) =>\n c.title === CLIENTE_COLUMN_TITLE\n );\n if (!clienteCol) {\n throw new Error(`Colonna \"${CLIENTE_COLUMN_TITLE}\" non trovata sul board.`);\n }\n\n let plCol = board.columns.find((c: any) => c.title === PL_COLUMN_TITLE);\n if (!plCol) {\n const createColQuery = `\n mutation ($boardId: ID!, $title: String!) {\n create_column(board_id: $boardId, title: $title, column_type: text) { id title }\n }`;\n const created = await callMonday(token, createColQuery, {\n boardId: BOARD_ID,\n title: PL_COLUMN_TITLE,\n });\n plCol = created.create_column;\n }\n\n const group = board.groups.find((g: any) => g.title === GROUP_TITLE);\n if (!group) {\n throw new Error(`Gruppo \"${GROUP_TITLE}\" non trovato sul board.`);\n }\n\n const existingNames = new Set(board.items_page.items.map((i: any) => i.name));\n const toCreate = DATA.filter((row) => !existingNames.has(row.work));\n const remainingBefore = toCreate.length;\n const batch = toCreate.slice(0, BATCH_SIZE);\n\n let createdThisBatch = 0;\n const failures: string[] = [];\n\n for (const row of batch) {\n const columnValues: Record = {\n [clienteCol.id]: row.cliente,\n [plCol.id]: row.pl,\n };\n try {\n const createItemQuery = `\n mutation ($boardId: ID!, $groupId: String, $itemName: String!, $columnValues: JSON) {\n create_item(board_id: $boardId, group_id: $groupId, item_name: $itemName, column_values: $columnValues) { id }\n }`;\n await callMonday(token, createItemQuery, {\n boardId: BOARD_ID,\n groupId: group.id,\n itemName: row.work,\n columnValues: JSON.stringify(columnValues),\n });\n createdThisBatch++;\n } catch (e) {\n failures.push(`${row.work} (${row.cliente}): ${e.message}`);\n }\n await sleep(100);\n }\n\n const remainingAfter = remainingBefore - batch.length;\n return {\n totalRows: DATA.length,\n alreadyDone: DATA.length - remainingBefore,\n createdThisBatch,\n failures,\n remaining: remainingAfter,\n done: remainingAfter <= 0,\n };\n}\n\nconst PAGE_HTML = `\n\n\n\nImport commesse su Monday\n\n\n\n

Import commesse reali su Monday

Carica ${DATA.length} commesse sulla scheda \"Elenco Commesse\", gruppo \"Commesse Attive\".

\n \n

In attesa di avvio.

Diff · v6