Power line tables, quantities and GIS export

const CY_M3 = 0.764554857984;

// ---------------------------------------------------------------------------------------------------------- stringing
export function stringingRows(analysis, { units = 'm' } = {}) {
  const um = unitM(units), out = [];
  for (const [si, S] of (analysis?.sections || []).entries()) {
    for (const row of S.stringing || []) {
      out.push({ section: si + 1, from: S.from, to: S.to, Lr: fin(S.Lr) ? S.Lr / um : null, temp: row.temp, H: toForce(row.H, units), Tmax: toForce(row.Tmax, units),
        spans: row.spans.map((sp, k) => ({ span: S.spans[k]?.i ?? k, L: sp.L / um, sag: sp.sag / um, length: sp.length / um })) });
    }
  }
  return out;
}

export function stringingCsv(analysis, line, { units = 'm' } = {}) {
  const lu = units === 'm' ? 'm' : 'ft', fu = forceUnit(units);
  const rows = stringingRows(analysis, { units });
  const out = [];
  for (const [si, S] of (analysis?.sections || []).entries()) {
    const mine = rows.filter((x) => x.section === si + 1);
    if (!mine.length) continue;
    if (out.length) out.push([]);
    const spans = mine[0].spans;
    out.push([t('pl.out.str.section', { n: si + 1, from: nm(line, S.from), to: nm(line, S.to) }), t('pl.out.str.ruling', { unit: lu }), r(mine[0].Lr)]);
    out.push([t('pl.out.str.span'), '', ...spans.map((sp) => nm(line, sp.span) + ' – ' + nm(line, sp.span + 1))]);
    out.push([t('pl.out.str.length', { unit: lu }), '', ...spans.map((sp) => r(sp.L))]);
    out.push([t('pl.out.str.temp'), t('pl.out.str.h', { unit: fu }), ...spans.map(() => t('pl.out.str.sag', { unit: lu }))]);
    for (const x of mine) out.push([x.temp, r(x.H, 1), ...x.spans.map((sp) => r(sp.sag))]);
  }
  return toCsv(out);
}

// ---------------------------------------------------------------------------------------------------------- supports
export function supportRows(analysis, line, lib, { units = 'm', cases = null } = {}) {
  const um = unitM(units);
  const caseName = (id) => (id == null ? '' : cases?.find((c) => c.id === id)?.name || id);
  return (analysis?.supports || []).map((s, i) => {
    const p = line?.supports?.[i] || {};
    const it = getItem(lib, s.item), sug = getItem(lib, s.suggest);
    return {
      i, id: s.id, name: nm(line, i), role: s.role, item: it?.name ?? (p.support || ''), itemKey: s.item ?? null,
      ground: s.groundZ ?? null, attach: s.attachZ ?? null, attachH: fin(s.attachZ) && fin(s.groundZ) ? s.attachZ - s.groundZ : null,
      angle: analysis.angles?.[i] ?? 0, load: toForce(s.worstFeq || 0, units), loadCase: s.worstCase ?? null, loadCaseName: caseName(s.worstCase),
      nominal: fin(it?.nominal_N) ? toForce(it.nominal_N, units) : null, ok: s.sizeOk ?? null,
      suggest: sug?.name ?? '', suggestKey: s.suggest ?? null,
      fdDepth: s.foundation ? s.foundation.depth_m / um : null, fdDia: s.foundation ? s.foundation.dia_m / um : null,
      swing: s.swing_deg ?? null, uplift: !!s.uplift, existing: !!p.existing,
    };
  });
}

let m = 0, est = 0;
for (const sp of a.spans) {
  const cat = catOf(a, sp.i);
  if (cat) m += cat.length; else { m += Math.hypot(sp.L_m || 0, sp.dz_m || 0); est++; }
}
const phases = line.phases || 1, circuits = line.circuits || 1, n = phases * circuits;
const x = add('conductor:' + line.id, 'conductor', `${c.name} (${line.name})`, LU, len(m * n * (1 + JUMPER_PCT / 100)), line.conductor);

const len = (m) => m / um, vol = (m3) => (feet ? m3 / CY_M3 : m3);

/** TakeoffCraft's quantities format (fixedqty.js reads it), as planting.js scheduleQuantities writes it. */
export function takeoffQuantities(rows, { project = '', made = new Date().toISOString().replace(/\.\d+Z$/, 'Z') } = {}) {
  return {
    format: 'cadcraft-quantities', version: 1, app: 'CivilCraft', project: String(project).slice(0, 200), made,   // i18n-ignore: the app's name in the file
    items: rows.map((x) => ({ key: ('pl:' + x.key).slice(0, 80), name: String(x.name).slice(0, 200), unit: x.unit, qty: round(x.qty, 2), note: String(x.note || '').slice(0, 400) }))
      .filter((x) => QKEY.test(x.key) && x.qty >= 0),
  };
}