Repository Public
1// Author: Simon-Pierre Boucher — contact@spboucher.ai2// File: Features/Data/DataExplorerView.swift3// Description: Data Explorer: the datasets the server proxies for a symbol (statements, ratios, estimates, ownership, news, prices) in a sortable, filterable table with CSV export and a time-series preview.4import Charts5import SwiftUI6import UniformTypeIdentifiers7import VQuantCore89struct DataExplorerView: View {10 let app: AppEnvironment11 @Bindable var model: WindowModel1213 @State private var table: DataTable?14 @State private var fetchedAt: Date?15 @State private var fromCache = false16 @State private var loading = false17 @State private var error: String?18 @State private var quarterly = false19 @State private var limit = 520 @State private var filter = ""21 @State private var sort: (column: String, ascending: Bool)?22 @State private var hidden: [Dataset: Set<String>] = [:]23 @State private var from = ""24 @State private var to = ""25 @State private var previewColumn: String?26 @State private var showColumns = false2728 private var dataset: Dataset { model.dataset }2930 var body: some View {31 HSplitView {32 List {33 ForEach(["Fundamentals", "Analysts", "Ownership & events", "News", "Prices"], id: \.self) { g in34 Section(g) { ForEach(Dataset.allCases.filter { $0.group == g }) { d in SelectableRow(isSelected: model.dataset == d) { model.dataset = d } content: { Text(d.title) }.accessibilityIdentifier("dataset.\(d.rawValue)") } }35 }36 }37 .listStyle(.inset).frame(minWidth: 170, idealWidth: 200, maxWidth: 220)3839 VStack(spacing: 0) {40 controls41 Divider()42 if fromCache, let f = fetchedAt { NoticeBar(kind: .cached, text: "Offline: rows received \(Fmt.relative(f)).") }43 if let error, table == nil {44 EmptyState(symbol: "tablecells", title: "No data", detail: error)45 } else if let shown {46 if shown.rows.isEmpty { EmptyState(symbol: "tablecells", title: "No row", detail: (table?.rows.isEmpty ?? true) ? "The provider returned nothing for \(model.symbol) in “\(dataset.title)”." : "No row matches the filter.") }47 else {48 VSplitView {49 GridTable(table: shown, hidden: hidden[dataset] ?? [], sort: $sort) { row in open(row) }.frame(minHeight: 160)50 if let col = previewColumn, shown.columns.contains(col) { SeriesPreview(table: shown, column: col).frame(minHeight: 150, idealHeight: 200, maxHeight: 320) }51 }52 }53 } else { ProgressView().frame(maxWidth: .infinity, maxHeight: .infinity) }54 Divider()55 footer56 }57 .frame(minWidth: 520, maxWidth: .infinity)58 }59 .task(id: "\(model.symbol)|\(dataset.rawValue)|\(quarterly)|\(limit)") { await load() }60 .onChange(of: model.dataset) { _, d in limit = d.defaultLimit; sort = nil; previewColumn = nil; filter = "" }61 }6263 /// Filter, date range and sort are applied to the rows the server returned; the server itself offers a page size, not an offset.64 private var shown: DataTable? {65 guard var t = table else { return nil }66 if !from.isEmpty || !to.isEmpty { t = t.between(from.isEmpty ? nil : from, to.isEmpty ? nil : to, column: dateColumn(t) ?? "date") }67 t = t.filtered(filter)68 if let s = sort, t.columns.contains(s.column) { t = t.sorted(by: s.column, ascending: s.ascending) }69 return t70 }71 private func dateColumn(_ t: DataTable) -> String? { ["date", "publishedDate", "filingDate", "transactionDate"].first { t.columns.contains($0) } }7273 private var controls: some View {74 HStack(spacing: 10) {75 Text("\(model.symbol) · \(dataset.title)").font(.headline).lineLimit(1).fixedSize()76 if dataset.hasPeriod { Picker("", selection: $quarterly) { Text("Annual").tag(false); Text("Quarterly").tag(true) }.pickerStyle(.segmented).labelsHidden().fixedSize() }77 if dataset.hasLimit {78 Picker("Rows", selection: $limit) { ForEach([dataset.defaultLimit, 10, 20, 40, 80, 120].sorted().uniqued(), id: \.self) { Text("\($0) rows").tag($0) } }.labelsHidden().fixedSize()79 .help("Number of rows requested from the server (its page size)")80 }81 Spacer()82 if table.flatMap(dateColumn) != nil {83 TextField("From date", text: $from).textFieldStyle(.roundedBorder).frame(width: 96).help("Keep rows on or after this date (yyyy-mm-dd)")84 TextField("To date", text: $to).textFieldStyle(.roundedBorder).frame(width: 96).help("Keep rows on or before this date (yyyy-mm-dd)")85 }86 TextField("Filter rows", text: $filter).textFieldStyle(.roundedBorder).frame(width: 130)87 Button { showColumns = true } label: { Label("Columns", systemImage: "rectangle.split.3x1") }.labelStyle(.iconOnly).help("Show or hide columns; pick a column to plot")88 .popover(isPresented: $showColumns, arrowEdge: .bottom) { ColumnsPopover(table: table, hidden: Binding(get: { hidden[dataset] ?? [] }, set: { hidden[dataset] = $0 }), preview: $previewColumn) }89 Button { export() } label: { Label("Export CSV", systemImage: "square.and.arrow.up") }.labelStyle(.iconOnly).help("Export the rows shown, at the provider's precision").disabled(shown?.rows.isEmpty ?? true)90 }91 .padding(.horizontal, 10).padding(.vertical, 6)92 }9394 private var footer: some View {95 HStack(spacing: 12) {96 if loading { ProgressView().controlSize(.mini) }97 if let t = table, let s = shown { Text("\(s.rows.count) of \(t.rows.count) rows · \(t.columns.count - (hidden[dataset]?.count ?? 0)) of \(t.columns.count) columns").font(.caption).foregroundStyle(.secondary) }98 FreshnessBadge(freshness: fromCache ? .cached(fetched: fetchedAt ?? Date()) : .historical(through: nil), compact: true)99 Spacer()100 Text("Source: VQuant server · Financial Modeling Prep · /api/fmp/\(dataset.rawValue)/\(model.symbol)").font(.caption2).foregroundStyle(.tertiary).textSelection(.enabled)101 if let f = fetchedAt { Text("Received \(Fmt.time(f))").font(.caption).foregroundStyle(.tertiary) }102 }103 .padding(.horizontal, 10).frame(height: 24)104 }105106 private func load() async {107 loading = true; defer { loading = false }108 let d = dataset, s = model.symbol, q = quarterly, n = limit109 do {110 let r = try await app.cache.fetch("dataset-\(d.rawValue)-\(s)-\(q)-\(n)") { [api = app.api] in try await api.dataset(d, symbol: s, quarterly: q, limit: n) }111 guard !Task.isCancelled else { return }112 table = DataTable(rows: r.value); fetchedAt = r.fetchedAt; fromCache = r.fromCache; error = nil113 if previewColumn == nil, let t = table { previewColumn = ["revenue", "close", "netIncome", "marketCap", "epsActual", "dividend", "priceTarget", "ESGScore"].first { t.columns.contains($0) } }114 } catch is CancellationError {} catch { if !Task.isCancelled { self.error = error.localizedDescription; table = nil } }115 }116117 private func export() {118 guard let s = shown else { return }119 let cols = s.columns.filter { !(hidden[dataset] ?? []).contains($0) }120 SavePanel.save(Data(s.csv(columns: cols).utf8), name: "\(model.symbol.replacingOccurrences(of: "^", with: ""))-\(dataset.rawValue).csv", types: [.commaSeparatedText])121 }122123 /// Rows that carry a link (news, filings) open it in the default browser.124 private func open(_ row: [String: JSONValue]) {125 for k in ["url", "finalLink", "link", "newsURL"] { if let s = row[k]?.stringValue, let u = URL(string: s), u.scheme == "https" { NSWorkspace.shared.open(u); return } }126 }127}128129private extension Array where Element: Hashable {130 func uniqued() -> [Element] { var seen = Set<Element>(); return filter { seen.insert($0).inserted } }131}132133private struct ColumnsPopover: View {134 let table: DataTable?135 @Binding var hidden: Set<String>136 @Binding var preview: String?137 var body: some View {138 VStack(alignment: .leading, spacing: 6) {139 HStack { Text("Columns").font(.headline); Spacer(); Button("Show All") { hidden = [] }.controlSize(.small) }140 ScrollView {141 VStack(alignment: .leading, spacing: 3) {142 ForEach(table?.columns ?? [], id: \.self) { c in143 HStack {144 Toggle(GridTable.header(c), isOn: Binding(get: { !hidden.contains(c) }, set: { if $0 { hidden.remove(c) } else { hidden.insert(c) } }))145 Spacer()146 if table?.isNumeric(c) == true {147 Button { preview = preview == c ? nil : c } label: { Image(systemName: preview == c ? "chart.xyaxis.line" : "chart.line.flattrend.xyaxis").foregroundStyle(preview == c ? Color.accentColor : .secondary) }148 .buttonStyle(.borderless).help("Plot this column over time")149 }150 }151 }152 }153 }154 .frame(width: 320, height: 360)155 }156 .padding(12)157 }158}159160/// One numeric column plotted against the table's date column.161private struct SeriesPreview: View {162 let table: DataTable163 let column: String164 var body: some View {165 let dateCol = ["date", "publishedDate", "filingDate", "transactionDate"].first { table.columns.contains($0) }166 let pts: [(Date, Double)] = table.rows.compactMap { r in167 guard let dc = dateCol, let ds = r[dc]?.stringValue, let d = BarParser.date(ds), let v = r[column]?.doubleValue else { return nil }168 return (d, v)169 }.sorted { $0.0 < $1.0 }170 VStack(alignment: .leading, spacing: 4) {171 Text("\(GridTable.header(column)) over time · \(pts.count) points").font(.caption).foregroundStyle(.secondary)172 if pts.count < 2 { Text("Not enough dated values to plot.").font(.callout).foregroundStyle(.secondary).frame(maxWidth: .infinity, maxHeight: .infinity) }173 else {174 Chart(pts, id: \.0) { p in175 if pts.count <= 40 { BarMark(x: .value("Date", p.0, unit: pts.count <= 12 ? .year : .month), y: .value(column, p.1)).foregroundStyle(p.1 >= 0 ? Color.accentColor : Palette.red) }176 else { LineMark(x: .value("Date", p.0), y: .value(column, p.1)).foregroundStyle(Color.accentColor) }177 }178 .chartYAxis { AxisMarks { v in AxisGridLine(); AxisValueLabel { if let d = v.as(Double.self) { Text(Fmt.compact(d)) } } } }179 }180 }181 .padding(10)182 }183}184