Function normalizeSubmissionForCsv

public/js/adminPortals.js:2169–2204

(sub)

}

function normalizeSubmissionForCsv(sub) {
    const created = sub.createdAt || sub.created_at || sub.timestamp || sub.time || '';
    const raw = sub.raw || sub;
    const folder = sub.folder || (raw && raw.folder) || '';
    const submittedBy = sub.submittedBy || (raw && raw.submittedBy) || '';
    const ip = sub.ip || (raw && raw.ip) || '';
  
    const form = raw.form || sub.form || raw || {};
    const name = form.name || sub.name || '';
    const email = form.email || sub.email || '';
    const reference = form.reference || form.ref || sub.reference || sub.ref || '';
    const notes = form.notes || form.message || sub.notes || sub.message || '';
    const submissionRef = sub.submissionRef || raw.submissionRef || '';
    const downloads = Array.isArray(sub.downloads)
      ? sub.downloads
      : (Array.isArray(raw.downloads) ? raw.downloads : []);
    const downloadsSummary = downloads.map(dl => {
      const file = dl.file || dl.path || '';
      const when = dl.createdAt || dl.created_at || dl.timestamp || dl.time || '';
      if (file && when) return file + ' @ ' + when;
      return file || String(when || '');
    }).filter(Boolean).join('; ');
  
    return {
      created,
      folder,
      submittedBy,
      ip,
      submissionRef,
      name,
      email,
      reference,
      notes,
      downloadsSummary
    };
  }
  
  function csvEscape(val) {
    if (val == null) return '';