special-dispatch-app/lib/controllers/workdays.js

const { sequelize } = require('../database')
const moment = require('moment-immutable')
const { Op } = require('sequelize')

const list = async (req, res) => {
  const date = req.params.date
  ? moment(req.params.date)
  : moment(moment.now())

  const startDate = date.add(-365, 'days')
  const endDate = date.add(365, 'days')

  const [results, metadata] = await sequelize.query(`
    select distinct date from workdays where laborCost > 0
  `)

  const dates = results.map(x => x.date)

  res.status(200).send({
    startDate: startDate.format('YYYY-MM-DD'),
    endDate: endDate.format('YYYY-MM-DD'),
    dates
  })
}


module.exports = {
  list
}