Prova.database.gemini

database
#kyoto-manager{font-family:Arial,sans-serif;color:#263244;background:#f4f6f9;padding:20px;border-radius:12px;min-height:700px} #kyoto-manager *{box-sizing:border-box} #kyoto-manager h1{font-size:25px;margin:0 0 5px} #kyoto-manager h2{font-size:19px;margin:0 0 15px} #kyoto-manager p{color:#6b7280} #kyoto-manager button,#kyoto-manager input,#kyoto-manager select,#kyoto-manager textarea{font:inherit} #kyoto-manager button{cursor:pointer;border:0;border-radius:7px;padding:10px 14px;background:#e5eaf1;color:#263244} #kyoto-manager button.primary{background:#263d5c;color:white} #kyoto-manager button.danger{background:#fae5e5;color:#a52b2b} #kyoto-manager input,#kyoto-manager select,#kyoto-manager textarea{width:100%;padding:10px;border:1px solid #d9dee7;border-radius:7px;background:white} #kyoto-manager textarea{min-height:75px;resize:vertical} #kyoto-manager label{font-size:13px;font-weight:600;display:block;margin-bottom:5px} #kyoto-manager .layout{display:grid;grid-template-columns:210px minmax(0,1fr);gap:18px;margin-top:20px} #kyoto-manager .sidebar,#kyoto-manager .panel{background:white;border:1px solid #e5e9ef;border-radius:10px;padding:16px} #kyoto-manager .sidebar button{display:block;width:100%;text-align:left;margin:4px 0;background:transparent} #kyoto-manager .sidebar button.active{background:#eaf0f8;color:#24466f;font-weight:bold} #kyoto-manager .top{display:flex;justify-content:space-between;align-items:center;gap:12px;flex-wrap:wrap} #kyoto-manager .stats{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:12px;margin:18px 0} #kyoto-manager .stat{background:white;border:1px solid #e5e9ef;border-radius:10px;padding:16px} #kyoto-manager .stat strong{display:block;font-size:27px;margin-top:8px} #kyoto-manager .grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:14px} #kyoto-manager .field{margin-bottom:12px} #kyoto-manager .tablewrap{overflow-x:auto} #kyoto-manager table{width:100%;border-collapse:collapse;font-size:13px} #kyoto-manager th,#kyoto-manager td{text-align:left;padding:11px 9px;border-bottom:1px solid #edf0f4;vertical-align:top} #kyoto-manager th{background:#f7f8fa} #kyoto-manager .tag{display:inline-block;padding:4px 8px;border-radius:20px;background:#edf0f4;font-size:11px} #kyoto-manager .actions{display:flex;gap:6px;flex-wrap:wrap} #kyoto-manager .toolbar{display:flex;gap:8px;flex-wrap:wrap;margin-bottom:14px} #kyoto-manager .toolbar input{max-width:260px} #kyoto-manager .hidden{display:none!important} #kyoto-manager .notice{padding:12px;background:#f0f4fa;border-radius:8px;font-size:13px;margin:12px 0} #kyoto-manager .formgrid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:12px} #kyoto-manager .full{grid-column:1/-1} #kyoto-manager .modal{position:fixed;inset:0;background:#0008;z-index:99999;display:flex;align-items:center;justify-content:center;padding:15px} #kyoto-manager .modalbox{background:white;padding:22px;border-radius:12px;width:min(650px,100%);max-height:90vh;overflow:auto} #kyoto-manager .modalhead{display:flex;justify-content:space-between;align-items:center;margin-bottom:18px} #kyoto-manager .empty{padding:25px;text-align:center;color:#778194} @media(max-width:700px){ #kyoto-manager{padding:12px} #kyoto-manager .layout{grid-template-columns:1fr} #kyoto-manager .sidebar{display:grid;grid-template-columns:repeat(2,1fr);gap:4px} #kyoto-manager .stats{grid-template-columns:repeat(2,1fr)} #kyoto-manager .grid,#kyoto-manager .formgrid{grid-template-columns:1fr} #kyoto-manager .full{grid-column:auto} }

GESTIONE CONTENUTI

Produzione · Archiviazione · Pubblicazione · Social

(function(){ const root=document.getElementById('kyoto-manager'); if(!root || root.dataset.ready)return; root.dataset.ready='1'; const KEY='kyoto_manager_v1'; const initial={ accounts:[ {id:'A01',platform:'YouTube',name:'Diario di un papà in Giappone'}, {id:'A02',platform:'YouTube',name:'Canale ASMR'}, {id:'A03',platform:'Instagram',name:'Instagram'}, {id:'A04',platform:'Facebook',name:'Facebook'}, {id:'A05',platform:'TikTok',name:'TikTok'}, {id:'A06',platform:'Twitch',name:'Twitch'}, {id:'A07',platform:'Telegram',name:'Telegram'}, {id:'A08',platform:'Google',name:'Google Business Profile'} ], contents:[], folders:[ {id:'F01',name:'Archivio originale',parent:''}, {id:'F02',name:'Video',parent:'F01'}, {id:'F03',name:'Fotografie',parent:'F01'}, {id:'F04',name:'Audio',parent:'F01'}, {id:'F05',name:'Montaggio',parent:''}, {id:'F06',name:'Esportazioni',parent:''}, {id:'F07',name:'Miniature',parent:''}, {id:'F08',name:'Materiali Google Drive',parent:''} ], publications:[], tasks:[] }; let db; try{ db=JSON.parse(localStorage.getItem(KEY))||initial; }catch(e){db=initial} const save=()=>localStorage.setItem(KEY,JSON.stringify(db)); const id=p=>p+'-'+Date.now().toString(36).toUpperCase(); const esc=s=>String(s??'').replace(/[&"']/g,c=>({'&':'&','':'>','"':'"',"'":'''}[c])); const el=(s)=>root.querySelector(s); const accountName=id=>db.accounts.find(x=>x.id===id)?.name||'—'; const contentName=id=>db.contents.find(x=>x.id===id)?.title||'—'; const folderName=id=>db.folders.find(x=>x.id===id)?.name||'Cartella principale'; function badge(s){ return ''+esc(s||'Da definire')+''; } function options(items,current){ return items.map(x=>''+esc(x.label)+'').join(''); } function selectField(label,name,items,current=''){ return '
'+options([{value:'',label:'Seleziona...'},...items])+'
'; } function inputField(label,name,value='',type='text'){ return '
'; } function areaField(label,name,value=''){ return '
'; } function formModal(title,body,submit){ el('#km-modal').classList.remove('hidden'); el('#km-modal').innerHTML=''; el('#km-form').onsubmit=e=>{e.preventDefault();submit(Object.fromEntries(new FormData(e.target)));}; } function table(headers,rows){ if(!rows.length)return '
Nessun elemento registrato.
'; return '
'+headers.map(x=>'').join('')+''+rows.join('')+'
'+x+'
'; } function remove(type,id){ if(!confirm('Vuoi eliminare questo elemento?'))return; db[type]=db[type].filter(x=>x.id!==id); save();render(); } function rowActions(type,id){ return '
'; } function dashboard(){ const count=(a)=>a.length; const open=db.tasks.filter(x=>x.status!=='Completata').length; const published=db.publications.filter(x=>x.status==='Pubblicata').length; return '

Panoramica generale

'+ '
'+ '
Contenuti'+count(db.contents)+'
'+ '
Account'+count(db.accounts)+'
'+ '
Pubblicazioni'+published+'
'+ '
Attività aperte'+open+'
'+ '
'+ '

Produzione

'+ '

Contenuti registrati: '+count(db.contents)+'

'+ '

In lavorazione: '+db.contents.filter(x=>x.status==='In lavorazione').length+'

'+ '

Pronti: '+db.contents.filter(x=>x.status==='Pronto').length+'

'+ '

Pubblicazioni

'+ '

Pubblicate: '+published+'

'+ '

Programmate: '+db.publications.filter(x=>x.status==='Programmata').length+'

'+ '

Da preparare: '+db.publications.filter(x=>x.status==='Da preparare').length+'

'+ '

Attività da completare

'+ (db.tasks.filter(x=>x.status!=='Completata').slice(0,8).map(x=>'

'+esc(x.title)+' '+badge(x.status)+'

').join('')||'

Nessuna attività aperta.

')+ '

Account registrati

'+ db.accounts.map(x=>'

'+esc(x.platform)+' — '+esc(x.name)+'

').join('')+ '
'; } function accounts(){ return '

Account e piattaforme

'+ table(['ID','Piattaforma','Account','Azioni'],db.accounts.map(x=>''+esc(x.id)+''+esc(x.platform)+''+esc(x.name)+''+rowActions('accounts',x.id)+'')); } function contents(){ return '

Archivio contenuti

'+ '
'+ table(['ID','Titolo','Tipo','Stato','Data','Azioni'],db.contents.map(x=>''+esc(x.id)+''+esc(x.title)+''+esc(x.type)+''+badge(x.status)+''+esc(x.date)+''+rowActions('contents',x.id)+'')); } function folders(){ return '

Cartelle e sottocartelle

'+ '
Registra i percorsi dei file sulle SSD e su Google Drive. I file originali restano nelle loro posizioni.
'+ table(['ID','Cartella','Cartella superiore','Azioni'],db.folders.map(x=>''+esc(x.id)+''+esc(x.name)+''+esc(folderName(x.parent))+''+rowActions('folders',x.id)+'')); } function publications(){ return '

Pubblicazioni

'+ table(['Contenuto','Account','Data','Stato','URL','Azioni'],db.publications.map(x=>''+esc(contentName(x.content))+''+esc(accountName(x.account))+''+esc(x.date)+''+badge(x.status)+''+(x.url?'Apri':'—')+''+rowActions('publications',x.id)+'')); } function tasks(){ return '

Attività di produzione

'+ table(['Attività','Contenuto','Scadenza','Stato','Azioni'],db.tasks.map(x=>''+esc(x.title)+''+esc(contentName(x.content))+''+esc(x.due)+''+badge(x.status)+''+rowActions('tasks',x.id)+'')); } const pages={dashboard,accounts,contents,folders,publications,tasks}; let page='dashboard'; function render(){ root.querySelectorAll('.sidebar button').forEach(b=>b.classList.toggle('active',b.dataset.page===page)); el('#km-main').innerHTML=pages[page](); } root.querySelectorAll('.sidebar button').forEach(b=>b.addEventListener('click',()=>{ page=b.dataset.page;render(); })); function add(type){edit(type,null)} function edit(type,recordId){ const r=recordId?db[type].find(x=>x.id===recordId):{}; let body=''; if(type==='accounts'){ body=inputField('Piattaforma','platform',r.platform)+inputField('Nome account / canale','name',r.name)+inputField('URL account','url',r.url); } if(type==='contents'){ body=inputField('Titolo','title',r.title)+ selectField('Tipologia','type',['Video','Short','Reel','Live','Fotografia','Carosello','Articolo','Podcast','Altro'].map(x=>({value:x,label:x})),r.type)+ selectField('Rubrica / progetto','project',['Exploring Kyoto','Inside Kyoto','EDOPODCAST','Kyoto in un minuto','ASMR','Templi e santuari','Archivio','Altro'].map(x=>({value:x,label:x})),r.project)+ selectField('Stato','status',['Idea','Da preparare','In lavorazione','Pronto','Pubblicato','Bloccato'].map(x=>({value:x,label:x})),r.status)+ inputField('Data idea / produzione','date',r.date,'date')+ inputField('Luogo collegato','place',r.place)+ inputField('Percorso file originale','source',r.source)+ inputField('Percorso montaggio / esportazione','export',r.export)+ areaField('Note operative','notes',r.notes); } if(type==='folders'){ body=inputField('Nome cartella','name',r.name)+ selectField('Cartella superiore','parent',db.folders.filter(x=>x.id!==recordId).map(x=>({value:x.id,label:x.name})),r.parent)+ selectField('Archivio','storage',[{value:'SSD',label:'SSD'},{value:'Google Drive',label:'Google Drive'},{value:'Altro',label:'Altro'}],r.storage)+ inputField('Percorso completo','path',r.path)+areaField('Descrizione','notes',r.notes); } if(type==='publications'){ body=selectField('Contenuto','content',db.contents.map(x=>({value:x.id,label:x.title})),r.content)+ selectField('Account di destinazione','account',db.accounts.map(x=>({value:x.id,label:x.platform+' — '+x.name})),r.account)+ inputField('Data pubblicazione','date',r.date,'date')+ selectField('Stato','status',['Da preparare','In preparazione','Programmata','Pubblicata','Annullata'].map(x=>({value:x,label:x})),r.status)+ inputField('URL pubblicazione','url',r.url)+ inputField('Titolo specifico della pubblicazione','title',r.title)+ areaField('Descrizione / testo pubblicato','description',r.description); } if(type==='tasks'){ body=inputField('Attività','title',r.title)+ selectField('Contenuto collegato','content',db.contents.map(x=>({value:x.id,label:x.title})),r.content)+ selectField('Categoria','category',['Ricerca','Selezione materiali','Montaggio','Audio','Titolo e descrizione','Miniatura','Esportazione','Caricamento','Programmazione','Verifica','Altro'].map(x=>({value:x,label:x})),r.category)+ inputField('Scadenza','due',r.due,'date')+ selectField('Stato','status',['Da fare','In lavorazione','Completata','Bloccata'].map(x=>({value:x,label:x})),r.status)+ areaField('Note','notes',r.notes); } formModal(recordId?'Modifica elemento':'Nuovo elemento',body,data=>{ const obj={...data,id:recordId||id(type.slice(0,1).toUpperCase())}; if(recordId)Object.assign(r,obj);else db[type].push(obj); save();close();render(); }); } function close(){el('#km-modal').classList.add('hidden');el('#km-modal').innerHTML=''} function filter(){ const q=(el('#km-search')?.value||'').toLowerCase(); root.querySelectorAll('[data-search]').forEach(x=>x.style.display=x.dataset.search.includes(q)?'':'none'); } function exportData(){ const blob=new Blob([JSON.stringify(db,null,2)],{type:'application/json'}); const a=document.createElement('a');a.href=URL.createObjectURL(blob); a.download='kyoto-manager-backup.json';a.click();URL.revokeObjectURL(a.href); } function importData(e){ const file=e.target.files[0];if(!file)return; const reader=new FileReader(); reader.onload=()=>{ try{ const data=JSON.parse(reader.result); ['accounts','contents','folders','publications','tasks'].forEach(k=>{ if(!Array.isArray(data[k]))throw new Error('Struttura non valida'); }); if(!confirm('Sostituire i dati attuali con quelli importati?'))return; db=data;save();render();alert('Database importato.'); }catch(err){alert('File non valido.');} }; reader.readAsText(file); } window.KM={add,edit,remove,close,filter,exportData,importData}; render(); })();
Benvenuti a Kyoto — Social & Content OS
京 Social & Content OS
Benvenuti a Kyoto / Matrice Piattaforme & Format (A–H)

🗂️ Database Piattaforme & Format Editoriali

Tutti i tuoi canali (A. YouTube → H. Sito Web) e ogni singolo format con regole di ideazione, preparazione, CTA e connessioni.