District Tour

-- The statistics are ordinary note properties; no Python or external service.
local root="blog/writing/District Tour"
local pages=nb.get_children(root)
table.sort(pages,function(a,b)
 return (tonumber(a.title:match("Prague (%d+)")) or 0)<(tonumber(b.title:match("Prague (%d+)")) or 0)
end)
local rows,links,total_km,total_minutes={},{},0,0
for _,page in ipairs(pages) do
 local blocks=nb.query({page=page.title,include_linked=true,limit=100})
 for _,block in ipairs(blocks) do
  local p=(block.metadata or {}).properties or {}
  if tonumber(p.distance) and type(p.duration)=="string" then
   local hours,minutes=p.duration:match("^(%d+):(%d%d)$")
   rows[#rows+1]={walk=page.title:match("([^/]+)$"),date=p.date or "",km=p.distance,duration=p.duration}
   total_km=total_km+p.distance
   total_minutes=total_minutes+(tonumber(hours) or 0)*60+(tonumber(minutes) or 0)
   links[#links+1]=ui.page_link(page.title,page.title:match("([^/]+)$"))
   break
  end
 end
end
ui.column({
 ui.row({ui.stat("Walks",tostring(#rows)),ui.stat("Distance",string.format("%.2f km",total_km)),ui.stat("Walking time",string.format("%dh %02dm",math.floor(total_minutes/60),total_minutes%60))},{appearance={gap=2}}),
 ui.table(rows,{columns={"walk","date","km","duration"}}),
 ui.collapsible("Read the walks",{open=true,children=ui.column(links,{appearance={gap=1}})}),
},{appearance={gap=2}})