index.js

const express = require("express");
const readXlsxFile = require("read-excel-file/node");
const path = require("path");
const basicAuth = require("express-basic-auth");
const schema = require("./schema");
const multer = require("multer");
const fs = require("fs");
const fetch = require("node-fetch");

const port = process.env.port || 8080;
const app = express();

const storage = multer.diskStorage({
  destination: function (req, file, cb) {
    cb(null, "./upload/");
  },
  filename: function (req, file, cb) {
    cb(null, "current.xlsx");
  },
});

const excelUpload = multer({
  storage: storage,
  fileFilter: (req, file, cb) => {
    if (
      file.mimetype == "application/vnd.ms-excel" ||
      file.mimetype == "application/xls" ||
      file.mimetype ==
        "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
    ) {
      cb(null, true);
    } else {
      cb(null, false);
      return cb(new Error("Only .xls and .xlsx format allowed!"));
    }
  },
});

app.get("/excel/api", async (req, res) => {
  const data = await readXlsxFile("./upload/current.xlsx", { schema }).then(
    ({ rows, errors }) => {
      errors.length === 0;
      return rows;
    }
  );

  res.send(data);
});

app.get("/excel/api/:projectid", async (req, res) => {
  const data = await readXlsxFile("./upload/current.xlsx", { schema }).then(
    ({ rows, errors }) => {
      errors.length === 0;
      return rows;
    }
  );
  const result = data.filter((e) => e.project_id == req.params.projectid);
  res.send(result);
});

app.use(
  basicAuth({
    challenge: true,
    users: {
      admin: "admin",
      admin1: "admin1",
    },
  })
);

app.use(express.json());

app.get("/excel", (req, res) => {
  res.sendFile(path.join(__dirname + "/index.html"));
});

app.get("/excel/metadata", (req, res) => {
  const metadata = fs.readFileSync("./metadata.json");
  res.send(JSON.parse(metadata));
});

app.post("/excel/upload", excelUpload.single("file"), async (req, res) => {
  var result = "";
  var d = new Date();
  result +=
    d.getFullYear() +
    "/" +
    (d.getMonth() + 1) +
    "/" +
    d.getDate() +
    " " +
    d.getHours() +
    ":" +
    d.getMinutes() +
    ":" +
    d.getSeconds() +
    " " +
    d.getMilliseconds();

  fs.writeFileSync(
    "./metadata.json",
    JSON.stringify({
      date: result,
      last_modifay: req.auth.user,
    })
  );

  await updateApi();

  res.status(200).send("done");
});

const updateApi = () => {
  readXlsxFile("./upload/current.xlsx", { schema }).then(({ rows, errors }) => {
    errors.length === 0;
    rows.map((e) => {
      fetch(
        `http://localhost:8081/test?id=${e.project_id
          .toString()
          .padStart(8, "0")}&location=${e.location}`
      );
    });
  });
};

app.listen(port, () => {
  console.log(`excel app listening on ${port} port!`);
});

//Run app, then load http://localhost:port in a browser to see the output.