import Tabulator from 'tabulator-tables'
import csv from 'parse-csv'

const datasetColumns = [
  { title: 'Title', field: 'title', sorter: 'string' },
  { title: 'Images', field: 'images', sorter: 'number' },
  { title: 'People', field: 'people', sorter: 'number' },
  { title: 'Year', field: 'year', sorter: 'number' },
  { title: 'Citations', field: 'citations', sorter: 'number' },
  { title: 'Influenced', field: 'influenced', sorter: 'number' },
  // { title: 'Origin', field: 'origin', sorter: 'string' },
]
const citationsColumns = [
  { title: 'Title', field: 'title', sorter: 'string' },
  { title: 'Institution', field: 'institution', sorter: 'string' },
  { title: 'Country', field: 'country', sorter: 'string', width: 140 },
  { title: 'Year', field: 'year', sorter: 'number', width: 70 },
  { title: 'PDF', field: 'pdf', formatter: 'link', sorter: 'string', width: 100 },
]

function getColumns(payload) {
  let { cmd, url, fields } = payload
  if (cmd === 'citations') {
    return citationsColumns
  }
  if (url && url.match('datasets.csv')) {
    return datasetColumns
  }
  return ((fields && fields.length) ? fields[0] : '').split(', ').map(field => {
    switch (field) {
      default:
        return { title: field, field: field.toLowerCase(), sorter: 'string' }
    }
  })
}

function getCitations(dataset) {
  // console.log(dataset.citations)
  return dataset.citations.map(citation => ({
    title: citation.title,
    institution: citation.addresses[0].name,
    country: citation.addresses[0].country,
    year: citation.year,
    pdf: (citation.pdf && citation.pdf.length) ? citation.pdf[0] : "",
  }))
}

export default function append(el, payload) {
  const columns = getColumns(payload)
  // console.log(columns)
  const table = new Tabulator(el, {
    height: '311px',
    layout: 'fitColumns',
    placeholder: 'No Data Set',
    columns,
  })
  // let path = payload.opt
  // console.log(path, columns)

  if (payload.cmd === 'citations') {
    let { data } = payload
    if (!data) return null
    const citations = getCitations(data)
    // console.log(citations)
    table.setData(citations)
    el.classList.add('loaded')
  } else {
    fetch(payload.url, { mode: 'cors' })
      .then(r => r.text())
      .then(text => {
        try {
          // console.log(text)
          const data = csv.toJSON(text, { headers: { included: true } })
          // console.log(data)
          table.setData(data)
          el.classList.add('loaded')
        } catch (e) {
          
          console.error("error making json:", payload.url)
          console.error(e)
          // console.log(text)
        }
      })
  }

  // if (fields && fields.length > 1 && fields[1].indexOf('filter')) {
  //   const filter = fields[1].split(' ')
  // }
}