SPB Git

Repository Public

DataExplorerView.swift 10.7 KB 184 lines swift

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
Files main
Menu

Theme