const express = require('express');
const XLSX = require('xlsx');
const XLSX_CALC = require('xlsx-calc');
const formulajs = require('@formulajs/formulajs');

const db = require('../db');
const Vehicles = require('../db/repo/Vehicles');

const router = express.Router();

XLSX_CALC.import_functions(formulajs, { override: true });
const workbook = XLSX.readFile('backend/excel/calc.xlsm');
const sheet = workbook.SheetNames[8];
const worksheet = workbook.Sheets[sheet];

router.post('/api/vehicles', async (req, res) => {
  try {
    const {
      user_id,
      year,
      make,
      model
    } = req.body;

    worksheet['B2'].v = make;
    worksheet['B3'].v = model;
    worksheet['B5'].v = year;


    XLSX_CALC(workbook);

    const summary = XLSX.utils.sheet_to_json(worksheet);
    res.send(summary);

    // const vehicle = await Vehicles.create(req.body);
    // res.send(vehicle);
  } catch (error) {
    console.error(error);
    res.status(error.status || 500).send({ error: error.message });
  }
});

module.exports = router;