'use strict'; /* Attendee hub demonstration. All people and flights below are invented. */ const CSV={ roster:`name,email,office,lodging,n16,n17,arr_mode,arr_day,arr_time,arr_hour,arr_flight,arrives,dep_mode,dep_day,dep_time,dep_hour,dep_flight,departs Maya Lindqvist,maya.lindqvist@riverbend.example,110,Hotel,1,0,Flying,2027-03-08,10:20,10,XA 214,Mon 10:20 AM · XA 214,Flying,2027-03-09,16:30,16,XB 78,Tue 4:30 PM · XB 78 Owen Okafor,owen.okafor@riverbend.example,110,Hotel,1,0,Flying,2027-03-08,10:55,10,XB 77,Mon 10:55 AM · XB 77,Flying,2027-03-09,17:20,17,XA 215,Tue 5:20 PM · XA 215 Priya Raman,priya.raman@riverbend.example,125,Hotel,1,0,Flying,2027-03-08,10:55,10,XB 77,Mon 10:55 AM · XB 77,Flying,2027-03-09,17:20,17,XA 215,Tue 5:20 PM · XA 215 Lucas Whitlock,lucas.whitlock@riverbend.example,140,Hotel,1,0,Flying,2027-03-08,12:10,12,XC 1402,Mon 12:10 PM · XC 1402,Flying,2027-03-09,18:05,18,XC 1403,Tue 6:05 PM · XC 1403 Elena Marchetti,elena.marchetti@riverbend.example,140,Hotel,1,0,Flying,2027-03-08,13:35,13,XA 530,Mon 1:35 PM · XA 530,Flying,2027-03-09,18:05,18,XC 1403,Tue 6:05 PM · XC 1403 Marcus Dunmore,marcus.dunmore@riverbend.example,210,Hotel,1,0,Flying,2027-03-08,13:35,13,XA 530,Mon 1:35 PM · XA 530,Flying,2027-03-09,18:05,18,XC 1403,Tue 6:05 PM · XC 1403 Hannah Feldt,hannah.feldt@riverbend.example,210,Hotel,1,0,Flying,2027-03-08,14:05,14,XD 918,Mon 2:05 PM · XD 918,Flying,2027-03-09,18:40,18,XD 919,Tue 6:40 PM · XD 919 Diego Castellan,diego.castellan@riverbend.example,210,Hotel,1,0,Flying,2027-03-08,14:05,14,XD 918,Mon 2:05 PM · XD 918,Flying,2027-03-09,18:40,18,XD 919,Tue 6:40 PM · XD 919 Naomi Abiodun,naomi.abiodun@riverbend.example,305,Hotel,1,0,Flying,2027-03-08,14:40,14,XB 261,Mon 2:40 PM · XB 261,Flying,2027-03-09,19:15,19,XB 262,Tue 7:15 PM · XB 262 Felix Thornbury,felix.thornbury@riverbend.example,305,Hotel,1,0,Flying,2027-03-08,14:40,14,XB 261,Mon 2:40 PM · XB 261,Flying,2027-03-09,19:15,19,XB 262,Tue 7:15 PM · XB 262 Ingrid Halvorsen,ingrid.halvorsen@riverbend.example,320,Hotel,1,0,Flying,2027-03-08,14:40,14,XB 261,Mon 2:40 PM · XB 261,Flying,2027-03-09,19:15,19,XB 262,Tue 7:15 PM · XB 262 Tobias Reyes-Park,tobias.reyespark@riverbend.example,410,Hotel,1,0,Flying,2027-03-08,15:15,15,XC 88,Mon 3:15 PM · XC 88,Flying,2027-03-09,19:50,19,XA 531,Tue 7:50 PM · XA 531 Leila Nasser,leila.nasser@riverbend.example,410,Hotel,1,0,Flying,2027-03-08,15:15,15,XC 88,Mon 3:15 PM · XC 88,Flying,2027-03-09,19:50,19,XA 531,Tue 7:50 PM · XA 531 Grant Ellery,grant.ellery@riverbend.example,455,Hotel,1,1,Flying,2027-03-08,15:50,15,XA 1177,Mon 3:50 PM · XA 1177,Flying,2027-03-10,08:10,8,XC 89,Wed 8:10 AM · XC 89 Sofia Varga,sofia.varga@riverbend.example,455,Hotel,1,1,Flying,2027-03-08,15:50,15,XA 1177,Mon 3:50 PM · XA 1177,Flying,2027-03-10,08:10,8,XC 89,Wed 8:10 AM · XC 89 Henrik Stromberg,henrik.stromberg@riverbend.example,510,Hotel,1,1,Flying,2027-03-08,16:25,16,XD 45,Mon 4:25 PM · XD 45,Flying,2027-03-10,10:30,10,XD 46,Wed 10:30 AM · XD 46 Amara Chukwu,amara.chukwu@riverbend.example,510,Hotel,1,1,Flying,2027-03-08,16:25,16,XD 45,Mon 4:25 PM · XD 45,Flying,2027-03-10,10:30,10,XD 46,Wed 10:30 AM · XD 46 Julian Ashcombe,julian.ashcombe@riverbend.example,510,Hotel,1,1,Flying,2027-03-08,16:25,16,XD 45,Mon 4:25 PM · XD 45,Flying,2027-03-10,12:45,12,XA 1178,Wed 12:45 PM · XA 1178 Keiko Tanaka,keiko.tanaka@riverbend.example,620,Hotel,1,0,Flying,2027-03-08,17:05,17,XB 602,Mon 5:05 PM · XB 602,Flying,2027-03-09,18:40,18,XD 919,Tue 6:40 PM · XD 919 Rafael Montoya,rafael.montoya@riverbend.example,620,Hotel,1,0,Flying,2027-03-08,17:05,17,XB 602,Mon 5:05 PM · XB 602,Flying,2027-03-09,18:05,18,XC 1403,Tue 6:05 PM · XC 1403 Tessa Brightwell,tessa.brightwell@riverbend.example,700,Hotel,1,0,Flying,2027-03-08,17:40,17,XC 319,Mon 5:40 PM · XC 319,Flying,2027-03-09,17:20,17,XA 215,Tue 5:20 PM · XA 215 Dmitri Volkov,dmitri.volkov@riverbend.example,700,Hotel,1,0,Flying,2027-03-08,12:10,12,XC 1402,Mon 12:10 PM · XC 1402,Flying,2027-03-09,19:15,19,XB 262,Tue 7:15 PM · XB 262 Nora Hadley,nora.hadley@riverbend.example,715,Hotel,1,0,Flying,2027-03-08,15:15,15,XC 88,Mon 3:15 PM · XC 88,Flying,2027-03-09,19:50,19,XA 531,Tue 7:50 PM · XA 531 Caleb Pruitt,caleb.pruitt@riverbend.example,,Hotel,1,0,Flying,2027-03-08,14:05,14,XD 918,Mon 2:05 PM · XD 918,Flying,2027-03-09,16:30,16,XB 78,Tue 4:30 PM · XB 78 Yara Mansour,yara.mansour@riverbend.example,810,Hotel,1,0,Driving,,,,,Driving,Driving,,,,,Driving Simon Everhart,simon.everhart@riverbend.example,810,Hotel,1,0,Driving,,,,,Driving,Driving,,,,,Driving Bianca Lombardi,bianca.lombardi@riverbend.example,905,Hotel,1,0,Driving,,,,,Driving,Driving,,,,,Driving Arjun Sethi,arjun.sethi@riverbend.example,905,No room needed,0,0,Not listed,,,,,Not listed,Not listed,,,,,Not listed Greta Aalto,greta.aalto@riverbend.example,,No room needed,0,0,Not listed,,,,,Not listed,Not listed,,,,,Not listed Malik Greaves,malik.greaves@riverbend.example,140,No room needed,0,0,Not listed,,,,,Not listed,Not listed,,,,,Not listed `, dietary:`need,count Vegetarian,3 Vegan,1 Gluten-free,2 No shellfish,1 No restrictions,22 Not stated,1 `, flight_status:`flight,leg,day,origin,level,status_text,delay_min,checked XA 214,arr,2027-03-08,BOS,ok,In the air · 12 min early · due 10:08 AM,-12,Mon 9:30 AM MT XB 77,arr,2027-03-08,ORD,ok,On time · due 10:55 AM,0,Mon 9:30 AM MT XC 1402,arr,2027-03-08,ATL,ok,On time · due 12:10 PM,0,Mon 9:30 AM MT XA 530,arr,2027-03-08,DEN,warn,Delayed 35 min · now due 2:10 PM,35,Mon 9:30 AM MT XD 918,arr,2027-03-08,DFW,ok,On time · due 2:05 PM,0,Mon 9:30 AM MT XB 261,arr,2027-03-08,LGA,ok,On time · due 2:36 PM,-4,Mon 9:30 AM MT XC 88,arr,2027-03-08,MCO,ok,On time · due 3:15 PM,0,Mon 9:30 AM MT XA 1177,arr,2027-03-08,PHL,bad,Delayed 1 h 40 min · now due 5:30 PM,100,Mon 9:30 AM MT XD 45,arr,2027-03-08,BNA,ok,On time · due 4:25 PM,0,Mon 9:30 AM MT XB 602,arr,2027-03-08,MSP,ok,On time · due 5:01 PM,-4,Mon 9:30 AM MT XC 319,arr,2027-03-08,LAX,bad,Cancelled,,Mon 9:30 AM MT XB 78,dep,2027-03-09,DEN,ok,On time · departs 4:30 PM,0,Mon 9:30 AM MT XA 215,dep,2027-03-09,DEN,ok,On time · departs 5:20 PM,0,Mon 9:30 AM MT XC 1403,dep,2027-03-09,DEN,ok,On time · departs 6:05 PM,0,Mon 9:30 AM MT XD 919,dep,2027-03-09,DEN,ok,On time · departs 6:40 PM,0,Mon 9:30 AM MT XB 262,dep,2027-03-09,DEN,ok,On time · departs 7:15 PM,0,Mon 9:30 AM MT XA 531,dep,2027-03-09,DEN,ok,On time · departs 7:50 PM,0,Mon 9:30 AM MT XC 89,dep,2027-03-10,DEN,ok,On time · departs 8:10 AM,0,Mon 9:30 AM MT XD 46,dep,2027-03-10,DEN,ok,On time · departs 10:30 AM,0,Mon 9:30 AM MT XA 1178,dep,2027-03-10,DEN,ok,On time · departs 12:45 PM,0,Mon 9:30 AM MT `}; /* Stand-in for the dashboard runtime: serves the saved data and runs the page's drawings. */ (function(){ const parse=(id)=>{ const text=CSV[id];if(!text)return null; const lines=text.split('\n').map((l)=>l.replace(/\r$/,'')).filter((l)=>l.length); const cols=lines[0].split(','); const rows=lines.slice(1).map((l)=>{const c=l.split(',');const o={};cols.forEach((k,i)=>{o[k]=c[i]===undefined||c[i]===''?null:c[i];});return o;}); rows.columns=cols;return rows; }; const DATA={roster:parse('roster'),dietary:parse('dietary'),flight_status:parse('flight_status')}; const calcs={},cache={},draws={},watchers=[]; const dash={ colors:['#1f6fb5'], data(id){ if(calcs[id]){ if(!(id in cache)){try{cache[id]=calcs[id].fn(...calcs[id].inputs.map((i)=>dash.data(i).data||[]));}catch(e){return {status:'error',data:null,message:String(e)};}} return {status:'ok',data:cache[id]}; } return DATA[id]?{status:'ok',data:DATA[id]}:{status:'missing',data:[]}; }, calc(id,def){calcs[id]=def;}, onData(fn){watchers.push(fn);}, draw(name,fn){ if(typeof fn==='function'){draws[name]=fn;return;} if(draws[name])document.querySelectorAll('[data-draw="'+name+'"]').forEach((e)=>{try{draws[name](e);}catch(err){console.error(name,err);}}); }, params(){return {};},setParams(){},resetParams(){},setLink(){},refresh(){} }; window.dash=dash; window.addEventListener('DOMContentLoaded',()=>{ watchers.forEach((fn)=>{try{fn();}catch(e){console.error(e);}}); Object.keys(draws).forEach((n)=>dash.draw(n)); }); })(); document.querySelectorAll('#dash-root .la').forEach((e)=>e.classList.add('js')); const MON='2027-03-08', TUE='2027-03-09'; const DAYS={'2027-03-08':'Monday, Mar 8','2027-03-09':'Tuesday, Mar 9','2027-03-10':'Wednesday, Mar 10'}; const SHORT={'2027-03-05':'Fri 11/13','2027-03-06':'Sat 11/14','2027-03-07':'Sun 11/15','2027-03-08':'Mon','2027-03-09':'Tue','2027-03-10':'Wed'}; const s=(x)=>x==null?'':String(x); const hr=(h)=>((h+11)%12+1)+' '+(h%24<12?'AM':'PM'); const t12=(t)=>{const [h,m]=s(t).split(':').map(Number);return ((h+11)%12+1)+':'+String(m).padStart(2,'0')+' '+(h<12?'AM':'PM');}; const el=(tag,cls,text)=>{const e=document.createElement(tag);if(cls)e.className=cls;if(text!=null)e.textContent=text;return e;}; const state={q:'',office:'',plan:'',pick:null,me:''}; const WINDOW_MIN=60; const DEN_UTC_OFFSET_H=5; const teamsUrl=(emails,topic,msg)=>'https://teams.microsoft.com/l/chat/0/0?users='+emails.map(encodeURIComponent).join(',')+(emails.length>1?'&topicName='+encodeURIComponent(topic):'')+'&message='+encodeURIComponent(msg); const teamsBtn=(emails,topic,msg)=>{const a=el('a','la-tmg','Message this group on Teams');a.href=teamsUrl(emails,topic,msg);a.target='_blank';a.rel='noopener';return a;}; const live=(flight,day,leg)=>{const fs=dash.data('flight_status');const f=s(flight).split(' / ')[0];return fs.status==='ok'&&Array.isArray(fs.data)?fs.data.find((x)=>x.flight===f&&x.day===day&&x.leg===leg):null;}; const mins=(t)=>{const [h,m]=s(t).split(':').map(Number);return h*60+m;}; dash.calc('summary',{inputs:['roster'],title:'Headline counts',description:'Counts of attendees, offices, hotel nights and flights, worked out from the roster.', fn:(roster)=>[{ attending:roster.length, offices:new Set(roster.map((r)=>r.office).filter(Boolean)).size, hotel_mon:roster.filter((r)=>String(r.n16)==='1').length, hotel_tue:roster.filter((r)=>String(r.n17)==='1').length, flying_mon:roster.filter((r)=>r.arr_mode==='Flying'&&r.arr_day==='2027-03-08').length, leaving_tue:roster.filter((r)=>r.dep_mode==='Flying'&&r.dep_day==='2027-03-09').length }]}); dash.calc('ride_groups',{inputs:['roster'],title:'Ride-share groups by hour',description:'People per flight hour: Monday arrivals, and departures on each day.', fn:(roster)=>{ const m=new Map(); const add=(leg,day,hour)=>{const key=leg+'|'+day+'|'+hour;const g=m.get(key)||{key,leg,day,hour:+hour,count:0};g.count++;m.set(key,g);}; for(const r of roster){ if(r.arr_mode==='Flying'&&r.arr_day==='2027-03-08')add('arr',r.arr_day,r.arr_hour); if(r.dep_mode==='Flying'&&r.dep_day)add('dep',r.dep_day,r.dep_hour); } return [...m.values()].sort((a,b)=>a.leg.localeCompare(b.leg)||a.day.localeCompare(b.day)||a.hour-b.hour); }}); dash.calc('shared_flights',{inputs:['roster'],title:'Flights shared by two or more',description:'Flight numbers that at least two attendees listed for the same day.', fn:(roster)=>{ const m=new Map(); const add=(leg,day,time,flight)=>{if(!flight||!/\d/.test(String(flight)))return;const key=leg+'|'+day+'|'+flight;const g=m.get(key)||{key,leg,day,time,flight,count:0};g.count++;m.set(key,g);}; for(const r of roster){ if(r.arr_mode==='Flying')add('arr',r.arr_day,r.arr_time,r.arr_flight); if(r.dep_mode==='Flying')add('dep',r.dep_day,r.dep_time,r.dep_flight); } return [...m.values()].filter((g)=>g.count>1).sort((a,b)=>(a.day+a.time).localeCompare(b.day+b.time)); }}); dash.onData(()=>{document.querySelectorAll('#dash-root .la').forEach((e)=>e.style.setProperty('--la-accent',dash.colors[0]));}); dash.draw('stat',(e)=>{const d=dash.data('summary');e.textContent=d.status==='ok'&&d.data&&d.data[0]?d.data[0][e.dataset.field]:'—';}); function drawGroups(box,leg){ const g=dash.data('ride_groups'),r=dash.data('roster'); if(g.status!=='ok'||r.status!=='ok'||!g.data){box.textContent='—';return;} const groups=g.data.filter((x)=>x.leg===leg); box.replaceChildren(); if(!groups.length){box.append(el('div','la-cnt','No flights listed.'));return;} const max=Math.max(...groups.map((x)=>x.count)); const P=leg==='arr'?{mode:'arr_mode',day:'arr_day',hour:'arr_hour',time:'arr_time',flight:'arr_flight'}:{mode:'dep_mode',day:'dep_day',hour:'dep_hour',time:'dep_time',flight:'dep_flight'}; let last=null; for(const grp of groups){ if(leg==='dep'&&grp.day!==last){box.append(el('div','la-day',DAYS[grp.day]||grp.day));last=grp.day;} const wrap=el('div','la-grp'),head=el('div','la-grp-head'); head.append(el('span',null,hr(grp.hour)+' – '+hr(grp.hour+1))); const track=el('span','la-track'),bar=el('span','la-bar');bar.style.width=(grp.count/max*100)+'%';track.append(bar);head.append(track); const cnt=el('span','la-cnt');const n=el('span',null,grp.count); cnt.append(n,document.createTextNode(grp.count===1?' person':' people'));head.append(cnt); const ul=el('ul','la-chips'); const ppl=r.data.filter((p)=>p[P.mode]==='Flying'&&p[P.day]===grp.day&&+p[P.hour]===grp.hour) .sort((a,b)=>s(a[P.time]).localeCompare(s(b[P.time]))); ppl.forEach((p)=>{const li=el('li','la-chip');li.dataset.name=s(p.name);const lv=live(p[P.flight],p[P.day],leg);if(lv)li.append(el('span','la-dot la-dot-'+s(lv.level)));li.append(document.createTextNode(s(p.name)));li.append(el('small',null,t12(p[P.time])+' · '+s(p[P.flight])+(lv?' · '+s(lv.status_text):'')));ul.append(li);}); wrap.append(head,ul); if(ppl.length>1){const when=hr(grp.hour)+' – '+hr(grp.hour+1)+' '+(SHORT[grp.day]||'');wrap.append(teamsBtn(ppl.map((p)=>s(p.email)),leg==='arr'?'DEN arrivals '+when:'Ride to DEN '+when,leg==='arr'?'Hi all! Looks like we land at DEN around the same time ('+when+'). Want to share a ride to the hotel?':'Hi all! Looks like we fly out of DEN around the same time ('+when+'). Want to share a ride to the airport?'));} box.append(wrap); } } dash.draw('checked',(e)=>{const fs=dash.data('flight_status');e.textContent=fs.status==='ok'&&Array.isArray(fs.data)&&fs.data[0]?s(fs.data[0].checked):'—';}); dash.draw('me-select',(sel)=>{ const r=dash.data('roster'); const people=r.status==='ok'?[...r.data].sort((a,b)=>s(a.name).localeCompare(s(b.name))):[]; sel.replaceChildren(new Option('Pick your name',''),...people.map((p)=>new Option(p.name,p.email))); sel.value=state.me; sel.onchange=()=>{state.me=sel.value;dash.draw('match-in');dash.draw('match-out');dash.draw('dir-teams');dash.draw('tue-teams');}; }); function drawMatch(box,leg){ const r=dash.data('roster'); if(r.status!=='ok'){box.textContent='—';return;} box.replaceChildren(); if(!state.me){box.append(el('div','la-you','Pick your name above to see your options.'));return;} const P=leg==='arr'?{mode:'arr_mode',day:'arr_day',time:'arr_time',label:'arrives',flight:'arr_flight'}:{mode:'dep_mode',day:'dep_day',time:'dep_time',label:'departs',flight:'dep_flight'}; const status=(p)=>{ const f=s(p[P.flight]).split(' / ')[0];if(!/\d/.test(f)||!p[P.day]||!p[P.time])return null; const [y,mo,d]=s(p[P.day]).split('-').map(Number),[hh,mm]=s(p[P.time]).split(':').map(Number); const left=Math.round((Date.UTC(y,mo-1,d,hh+DEN_UTC_OFFSET_H,mm)-Date.now())/60000); const dur=(n)=>n>=60?Math.floor(n/60)+' h '+String(n%60).padStart(2,'0')+' min':n+' min'; const verb=leg==='arr'?'lands':'departs'; let cls,text;const lv=live(p[P.flight],p[P.day],leg); if(lv){cls='la-st-'+s(lv.level);text=s(lv.status_text)+' · checked '+s(lv.checked);} else if(window.__static){cls='la-st-sched';text='Scheduled time only';} else if(left>60){cls='la-st-sched';text='Scheduled: '+verb+' in '+dur(left);} else if(left>=0){cls='la-st-soon';text='Due soon: '+verb+' in '+dur(left)+' by schedule';} else{cls='la-st-past';text=(leg==='arr'?'Scheduled landing':'Scheduled departure')+' was '+dur(-left)+' ago';} const a=el('a','la-status '+cls);a.href='https://www.google.com/search?q='+encodeURIComponent(f+' flight status');a.target='_blank';a.rel='noopener'; a.append(el('span','la-st-bar'),el('span','la-st-text',f+' · '+text),el('span','la-st-go','Live status ›')); return a;}; const me=r.data.find((p)=>p.email===state.me); if(!me)return; if(me[P.mode]!=='Flying'||!me[P.time]){box.append(el('div','la-you','The sheet has no flight for you here ('+s(me[P.label])+').'));return;} box.append(el('div','la-you','You: '+s(me[P.label])));const ms=status(me);if(ms)box.append(ms); const t0=mins(me[P.time]); const near=r.data.filter((p)=>p.email!==me.email&&p[P.mode]==='Flying'&&p[P.day]===me[P.day]&&p[P.time]&&(leg==='arr'?(mins(p[P.time])-t0>=0&&mins(p[P.time])-t0<=WINDOW_MIN):Math.abs(mins(p[P.time])-t0)<=WINDOW_MIN)) .map((p)=>({p,d:mins(p[P.time])-t0})).sort((a,b)=>Math.abs(a.d)-Math.abs(b.d)); if(!near.length){box.append(el('div',null,leg==='arr'?'No one is listed landing in the hour after you. Check the hour-by-hour groups below.':'No one else is listed within an hour of you. Check the hour-by-hour groups below.'));return;} const myF=s(me[P.flight]).split(' / ')[0]; const msg=(leg==='arr'?'Hi! I land at DEN '+s(me.arrives)+'. Want to share a ride to the hotel?':'Hi! I fly out of DEN '+s(me.departs)+'. Want to share a ride to the airport?') +(/\d/.test(myF)?' My live flight status: https://www.google.com/search?q='+myF.replace(/[^A-Za-z0-9]/g,''):''); const teams=(emails)=>'https://teams.microsoft.com/l/chat/0/0?users='+emails.map(encodeURIComponent).join(',')+(emails.length>1?'&topicName='+encodeURIComponent(leg==='arr'?'DEN ride share Monday':'Ride share to DEN'):'')+'&message='+encodeURIComponent(msg); const ul=el('ul','la-mlist'); for(const {p,d} of near){ const li=el('li'),a=el('a',null,p.name);a.href='mailto:'+s(p.email);li.append(a); const tm=el('a','la-tm','Message on Teams');tm.href=teams([s(p.email)]);tm.target='_blank';tm.rel='noopener';li.append(tm); li.append(el('small',null,s(p.email)));const sm=el('small',null,s(p[P.label])+' · '+(d===0?'same time as you':Math.abs(d)+' min '+(d<0?'before':'after')+' you'));li.append(sm);const st=status(p);if(st)li.append(st); ul.append(li); } box.append(ul); const list=near.map((x)=>s(x.p.email)).join('; '); const row=el('div','la-actions'); const all=el('a','la-btn','Email this group'); all.href='mailto:'+near.map((x)=>s(x.p.email)).join(',')+'?subject='+encodeURIComponent(leg==='arr'?'Share a ride from DEN on Monday?':'Share a ride to DEN?'); all.target='_blank';all.rel='noopener'; const addr=el('div','la-emails',list); const copy=el('button','la-btn la-btn2','Copy emails');copy.type='button'; const pick=()=>{const rg=document.createRange();rg.selectNodeContents(addr);const sel=window.getSelection();sel.removeAllRanges();sel.addRange(rg);}; copy.onclick=()=>{pick();let ok=false;try{ok=document.execCommand('copy');}catch(e){} const done=()=>{copy.textContent='Copied';}; if(ok)done();else if(navigator.clipboard&&navigator.clipboard.writeText)navigator.clipboard.writeText(list).then(done,()=>{copy.textContent='Selected below, press copy';}); else copy.textContent='Selected below, press copy';}; all.className='la-btn la-btn2'; const tg=el('a','la-btn','Message this group on Teams');tg.href=teams(near.map((x)=>s(x.p.email)));tg.target='_blank';tg.rel='noopener'; row.append(tg,all,copy); box.append(row,el('div','la-you','Teams opens with this message ready to send:'),el('div','la-emails',msg),el('div','la-you','Or copy the addresses:'),addr); } dash.draw('match-in',(b)=>drawMatch(b,'arr')); dash.draw('match-out',(b)=>drawMatch(b,'dep')); dash.draw('rides-in',(b)=>drawGroups(b,'arr')); dash.draw('rides-out',(b)=>drawGroups(b,'dep')); dash.draw('flights',(box)=>{ const f=dash.data('shared_flights'),r=dash.data('roster'); if(f.status!=='ok'||r.status!=='ok'||!f.data){box.textContent='—';return;} box.replaceChildren(); for(const g of f.data){ const card=el('div','la-fl'),top=el('div','la-fl-top'); top.append(el('span','la-fl-no',g.flight),el('span','la-fl-tag',g.leg==='arr'?'Into DEN':'Out of DEN')); const when=el('div','la-fl-when',(SHORT[g.day]||g.day)+' '+t12(g.time)+' · '); const n=el('span',null,g.count); when.append(n,document.createTextNode(' of us')); const ul=el('ul','la-chips'); const fp=r.data.filter((p)=>g.leg==='arr'?(p.arr_flight===g.flight&&p.arr_day===g.day):(p.dep_flight===g.flight&&p.dep_day===g.day)); fp.forEach((p)=>{const li=el('li','la-chip',p.name);li.dataset.name=s(p.name);ul.append(li);}); card.append(top,when,ul,teamsBtn(fp.map((p)=>s(p.email)),g.flight+' '+(SHORT[g.day]||''),'Hi all! Looks like we are on the same flight, '+g.flight+' ('+(SHORT[g.day]||'')+' '+t12(g.time)+'). Want to share a ride?'));box.append(card); } }); dash.draw('meet',(box)=>{ const r=dash.data('roster'); if(r.status!=='ok'||!r.data.length){box.textContent='—';return;} if(state.pick==null||state.pick>=r.data.length)state.pick=Math.floor(Math.random()*r.data.length); const p=r.data[state.pick]; box.replaceChildren(); box.append(el('div','la-meet-name',p.name)); const sub=el('div','la-meet-sub',(p.office?'Office '+p.office+' · ':'')+'Arrives: '+s(p.arrives)+' · '); const a=el('a',null,'Say hello');a.href='mailto:'+s(p.email)+'?subject='+encodeURIComponent('Hello from the Team Summit');sub.append(a); box.append(sub); }); dash.draw('diet',(ul)=>{ const d=dash.data('dietary');ul.replaceChildren(); if(d.status!=='ok')return; d.data.forEach((row)=>{const li=el('li',null);li.append(el('span',null,row.need));li.append(el('b',null,row.count));ul.append(li);}); }); dash.draw('tue-night',(ul)=>{ const r=dash.data('roster');ul.replaceChildren(); if(r.status!=='ok')return; r.data.filter((p)=>String(p.n17)==='1'||p.dep_day==='2027-03-10').forEach((p)=>{const li=el('li','la-chip',p.name);li.dataset.name=s(p.name);li.append(el('small',null,'Leaves '+s(p.departs)));ul.append(li);}); }); dash.draw('office-select',(sel)=>{ const r=dash.data('roster'); const codes=r.status==='ok'?[...new Set(r.data.map((p)=>p.office).filter(Boolean).map(String))].sort():[]; sel.replaceChildren(new Option('All offices',''),...codes.map((c)=>new Option('Office '+c,c))); sel.value=state.office; sel.onchange=()=>{state.office=sel.value;dash.draw('dir-body');}; }); const PLAN_LABEL={fly_mon:'landing Monday',fly_tue:'flying home Tuesday',hotel_mon:'at the hotel Monday',tue_night:'staying Tuesday night',driving:'driving'}; const dirRows=()=>{ const r=dash.data('roster');if(r.status!=='ok')return []; const q=state.q.trim().toLowerCase(); const plan={fly_mon:(p)=>p.arr_mode==='Flying'&&p.arr_day===MON,fly_tue:(p)=>p.dep_mode==='Flying'&&p.dep_day===TUE,hotel_mon:(p)=>String(p.n16)==='1',tue_night:(p)=>String(p.n17)==='1',driving:(p)=>p.arr_mode==='Driving'}[state.plan]; return r.data.filter((p)=>(!q||(s(p.name)+' '+s(p.arrives)+' '+s(p.departs)).toLowerCase().includes(q))&&(!state.office||s(p.office)===state.office)&&(!plan||plan(p))) .sort((a,b)=>s(a.name).localeCompare(s(b.name))); }; dash.draw('dir-teams',(a)=>{ const rows=dirRows().filter((p)=>p.email&&p.email!==state.me); const filtered=!!(state.q.trim()||state.office||state.plan); a.hidden=!rows.length;if(!rows.length)return; const who=[state.office?'office '+state.office:'',state.plan?PLAN_LABEL[state.plan]:''].filter(Boolean).join(', '); a.textContent=rows.length===1?'Message '+s(rows[0].name)+' on Teams':(filtered?'Message these '+rows.length+' people on Teams':'Message everyone ('+rows.length+') on Teams'); a.href=teamsUrl(rows.map((p)=>s(p.email)),'Team Summit Denver'+(who?' · '+who:''),rows.length===1?'Hi! Looking forward to seeing you at the Team Summit in Denver.':'Hi all! Looking forward to seeing everyone at the Team Summit in Denver.'); }); dash.draw('tue-teams',(a)=>{ const r=dash.data('roster'); const rows=r.status==='ok'?r.data.filter((p)=>(String(p.n17)==='1'||p.dep_day==='2027-03-10')&&p.email!==state.me):[]; a.hidden=rows.length<2;if(rows.length<2)return; a.textContent='Message this group on Teams'; a.href=teamsUrl(rows.map((p)=>s(p.email)),'Denver Tuesday night','Hi all! Looks like we are all still in Denver on Tuesday night. Want to get dinner together?'); }); dash.draw('dir-body',(tb)=>{ const r=dash.data('roster');tb.replaceChildren(); if(r.status!=='ok')return; const rows=dirRows(); dash.draw('dir-teams'); if(!rows.length){const tr=el('tr'),td=el('td',null,'No one matches. Clear a filter to see everyone.');td.colSpan=4;tr.append(td);tb.append(tr);return;} for(const p of rows){ const tr=el('tr'); const td=el('td'),a=el('a',null,p.name);a.href='mailto:'+s(p.email);td.append(a); tr.append(td,el('td',null,s(p.office)),el('td',null,s(p.arrives)),el('td',null,s(p.departs))); tb.append(tr); } }); document.querySelectorAll('#dash-root .la-search').forEach((i)=>i.addEventListener('input',()=>{state.q=i.value;dash.draw('dir-body');})); document.querySelectorAll('#dash-root #la-plan').forEach((i)=>i.addEventListener('change',()=>{state.plan=i.value;dash.draw('dir-body');})); const goTo=(id)=>{const t=document.getElementById(id);if(t)t.scrollIntoView({behavior:window.matchMedia('(prefers-reduced-motion: reduce)').matches?'auto':'smooth',block:'start'});}; const setDir=(o)=>{if('q' in o){state.q=o.q;document.querySelectorAll('#dash-root .la-search').forEach((i)=>{i.value=o.q;});} if('plan' in o){state.plan=o.plan;document.querySelectorAll('#dash-root #la-plan').forEach((i)=>{i.value=o.plan;});} dash.draw('dir-body');}; document.querySelectorAll('#dash-root .la').forEach((root)=>root.addEventListener('click',(ev)=>{ const chip=ev.target.closest('.la-chip[data-name]'); if(chip&&root.contains(chip)){setDir({q:chip.dataset.name,plan:''});goTo('people');return;} const a=ev.target.closest('a[href^="#"]'); if(a&&root.contains(a)){ev.preventDefault();if(a.dataset.plan!==undefined)setDir({q:'',plan:a.dataset.plan});goTo(a.getAttribute('href').slice(1));} })); document.querySelectorAll('#dash-root #meet-btn').forEach((b)=>b.addEventListener('click',()=>{const r=dash.data('roster');if(r.status!=='ok'||r.data.length<2)return;let n;do{n=Math.floor(Math.random()*r.data.length);}while(n===state.pick);state.pick=n;dash.draw('meet');}));