Hackathon.js

const express = require('express')
const path = require('path');
const session = require("express-session")
const app = express()
const port = process.env.PORT || 3000
let options = {};
var request = require('request');
const { plot, Plot } = require('nodeplotlib');

const Categorias = {
  ["Hogar e Interiores"]: ["MOOIMOM", "SOFTEXINDONESIA", "STICKERS", "DEDEMAN", "HORNBACH", "GAME.CO.ZA", "CLICKS.CO.ZA", "MATAHARIMALL", "SODIMAC", "MRPHOME", "NETFLORIST", "ILUMINACION", "ABC HOME", "4 TINTAS"],
  ["Salud"]: ["SPORT", "DRMAX", "MEDICA", "FAITHFUL-TO-NATURE", "MEDICOS", "PHARMACY", "OPTICA", "FARMACIA"],
  ["Compras Virtuales"]: ["AMZN", "SHOPEE", "REV.", "SUPERMARKET", "CUOTA", "AMAZON", "MERCADO", "GEANT", "REDIVA", "EL CORTE INGLES", "2CO.COM"],
  ["Comida"]: ["STARBUCK", "PICCOLINO", "BAR", "EL CLUB DE LA PAPA F", "ANCAP", "CARNICERIA", "STARBUCKS", "PASTAS", "SUBWAY", "PANADERIA", "RESTAURANTE", "EMPANADAS", "A PAO DE QUEIJARIA", "879 HOUSE", "DUTY FREE AMERIC", "7 ELEVEN", "OPEN BAR", "BRIO DOLPHIN", "123 COMIDA", "PARRILLADA", "PEPSIVEN", "SUSHI", "STARBUCKS"],
  ["Turismo y cultura"]: ["ESSO", "CURRY MOUNTAIN", "AIRBNB", "VIAJE", "WIKIPEDI", "SHERATON LIMA", "ARTESANAL", "HOTEL ART DESIGN"],
  ["Vehiculos y transporte"]: ["GOMERIA", "LOGISTICS", "DIDI", "AUTOMOVI", "JAYS TRAVEL CENTER", "UBER"],
  ["Ropa"]: ["ZALORA", "FASHION", "ACKERMANS", "BRO.DO", "RELOJERIA", "MEDIERIAS", "BARBER", "NIKE", "ADIDAS", "ZARA", "A EAGLE OUTFTR", "FOREVER 21", "3SECOND.CO"],
  ["Mascotas"]: ["PETMEDS", "PETSOLUTIONS"],
  ["Empresas Reportadas Negativamente"]: ["ITALO HMADRID", "AA INFLIGHT MC FACET 2"],
  ["Software y Tecnologias"]: ["EVETECH", "JAKARTANOTEBOOK", "GAMES	", "EMAG", "STEAM", "MICROSOFT", "DIRECTV", "NETFLIX", "OCULUS", "FACEBK", "GOOGLE", "YOUTUBE", "69CASES", "1PASSWORD", "42ND STREET PHOTO"],
  ["Economia y acciones"]: ["FRAUDE FULL ZS", "INVERSIONES", "HOVEREX", "NETELLER", "PAYPAL", "VISA", "XAPO", "ADS", "ABEONACOIN"],
  ["Retiros"]: ["CHEQUE", "DEVUELTO", "COMISION", "DEB", "DEBITO", "RETIRO", "COBRO"],
  ["Entradas"]: ["TRF", "ACREDITACION", "CRED.", "SUELDO", "CAMBIOS", "DEPOSITO", "TRASPASO", "PAGO", "ABONO"],
  ["Donaciones"]: ["SOLIDARIDAD", "3SECOND"],
}

bodyParser = require('body-parser'),
  app.use(session({ secret: "3d2qd2dcj20j", resave: true, saveUninitialized: true }))
app.use(express.json())
app.engine('html', require('ejs').renderFile);
app.use(express.urlencoded({
  extended: true
}))
app.use(express.static(__dirname + 'public')); //Serves resources from public folder
app.use(express.static('public'));

app.get('/', (req, res) => {
  idcuenta = req.query.user
  if(idcuenta){
    res.render(path.join(__dirname, '/templates/index.html'), { "user":idcuenta});
  }else{
    res.render(path.join(__dirname, '/templates/index.html'),{"user":false});

  }
})


app.post('/auth', (req, res) => {
  app.set('json spaces', 40);
  var responsex = ""
  request.post({

    "url": "https://banking.sandbox.prometeoapi.com/login/",
    "json": true,
    "headers": {
      "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
    },
    "form": {
      "provider": "test",
      "username": req.body["user"],
      "password": req.body["pass"]
    }
  }, function (err, response, body) {
    if (body["status"] == "logged_in") {
      req.session.key = body["key"]
      req.session.logged = true
      req.session.user = req.body["user"]
      res.redirect("/inicio")
    } else {
      res.redirect("/?user="+req.body["user"])
    }
  });
})



app.get("/inicio", (req, res) => {
  var name = ""
  if (req.session.logged) {
    request.get({
      "url": "https://banking.sandbox.prometeoapi.com/info/",
      "json": true,
      "headers": {
        "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
      },
      "qs": {
        "key": req.session.key
      }
    }, function (e, res2, body) {
      if (body["status"] == "error") { res.redirect("/logout"); return null; }
      name = body["info"]["name"]
      request.get({
        "url": "https://banking.sandbox.prometeoapi.com/account/",
        "json": true,
        "headers": {
          "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
        },
        "qs": {
          "key": req.session.key
        }
      }, function (e, res3, body2) {
        let cuentas = ""
        if (body2["accounts"].length <= 1) {
          cuentas = " 1 cuenta bancaria"
        } else {
          cuentas = body2["accounts"].length + " cuentas bancarias"
        }
        req.session.cuentas = body2

        res.render(path.join(__dirname, '/templates/inicio.html'), { "name": name.toUpperCase(), "cuentas": cuentas });
      });

    })
  } else {
    res.redirect("/")
  }

})

app.get("/movimientos", (req, res) => {
  if (req.session.logged) {
    idcuenta = req.query.Cuentas
    tiempo = req.query.Dias
    Rubro = req.query.Rubro
    movimientos = {}
    if (idcuenta && tiempo) {
      let Rubros = Rubro.replace(/_/g, " ").split(",")
      let moneda = ""
      let accountnumber = ""
      let diactual = new Date();
      let currentdate = diactual.getDate() + "/" + (diactual.getMonth() + 1) + "/" + diactual.getFullYear()
      diactual.setDate(diactual.getDate() - tiempo)
      let targetdate = diactual.getDate() + "/" + (diactual.getMonth() + 1) + "/" + diactual.getFullYear()
      Object.keys(req.session.cuentas["accounts"]).forEach(key => {
        if (key === idcuenta) {
          moneda = req.session.cuentas["accounts"][key]["currency"]
          accountnumber = req.session.cuentas["accounts"][key]["number"]
        }
      })
      request.get({
        "url": "https://banking.sandbox.prometeoapi.com/account/" + accountnumber + "/movement/",
        "json": true,
        "headers": {
          "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
        },
        "qs": {
          "key": req.session.key,
          "currency": moneda,
          "date_start": targetdate,
          "date_end": currentdate
        }
      }, function (e, r, b) {
        Object.keys(b["movements"]).forEach(function (k) {
          b["movements"][k]["Categoria"] = "Otro"
          Object.keys(Categorias).forEach(function (v2) {
            if (Categorias[v2].some(v => b["movements"][k]["detail"].includes(v))) {
              b["movements"][k]["Categoria"] = v2
            }
          })

        })

        res.render(path.join(__dirname, '/templates/movimientos.html'), { "cuentas": req.session.cuentas, "movimientos": b, "rubro": Rubros })
      });

    } else {

      res.render(path.join(__dirname, '/templates/movimientos.html'), { "cuentas": req.session.cuentas, "movimientos": {} })
    }
  } else {
    res.redirect("/")
  }

})

app.get("/estadisticas", (req, res) => {
  if (req.session.logged) {
    idcuenta = req.query.Cuentas
    tiempo = req.query.Dias
    Rubro = req.query.Rubro
    movimientos = {}
    let x = {}
    let y = {}
    if (idcuenta && tiempo) {
      let moneda = ""
      let accountnumber = ""
      let diactual = new Date();
      let currentdate = diactual.getDate() + "/" + (diactual.getMonth() + 1) + "/" + diactual.getFullYear()
      diactual.setDate(diactual.getDate() - tiempo)
      let targetdate = diactual.getDate() + "/" + (diactual.getMonth() + 1) + "/" + diactual.getFullYear()
      Object.keys(req.session.cuentas["accounts"]).forEach(key => {
        if (key === idcuenta) {
          moneda = req.session.cuentas["accounts"][key]["currency"]
          accountnumber = req.session.cuentas["accounts"][key]["number"]
        }
      })
      request.get({
        "url": "https://banking.sandbox.prometeoapi.com/account/" + accountnumber + "/movement/",
        "json": true,
        "headers": {
          "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
        },
        "qs": {
          "key": req.session.key,
          "currency": moneda,
          "date_start": targetdate,
          "date_end": currentdate
        }
      }, function (e, r, b) {

        Object.keys(b["movements"]).forEach(function (k) {
          b["movements"][k]["Categoria"] = "Otro"
          Object.keys(Categorias).forEach(function (v2) {
            if (Categorias[v2].some(v => b["movements"][k]["detail"].includes(v))) {
              b["movements"][k]["Categoria"] = v2
            }
          })
        })
        let diactualx = new Date();
        switch (Rubro) {
          case "1":
            x["Otro"] = 0
            Object.keys(Categorias).forEach(function (v, k) {
              x[v] = 0
            })
            Object.keys(b["movements"]).forEach(function (v, k) {
              if (b["movements"][v]["credit"] == "") {
                b["movements"][v]["credit"] = 0
              }
              if (b["movements"][v]["debit"] == "") {
                b["movements"][v]["debit"] = 0
              }
              x[b["movements"][v]["Categoria"]] = x[b["movements"][v]["Categoria"]] + parseInt(b["movements"][v]["debit"])
            })
            delete x["Otros"]
            break;
          case "2":
            x["Otro"] = 0
            Object.keys(Categorias).forEach(function (v, k) {
              x[v] = 0
            })
            Object.keys(b["movements"]).forEach(function (v, k) {
              x[b["movements"][k]["Categoria"]] = x[b["movements"][k]["Categoria"]] + 1
            })
            break;

        }
        res.render(path.join(__dirname, '/templates/estadisticas.html'), { "cuentas": req.session.cuentas, "estadisticas": x })
      });

    } else {

      res.render(path.join(__dirname, '/templates/estadisticas.html'), { "cuentas": req.session.cuentas, "estadisticas": {} })
    }



  } else {
    res.redirect("/")
  }
})

app.get("/logout", (req, res) => {
  if (req.session.key) {
    request.get({
      "url": "https://banking.sandbox.prometeoapi.com/info/",
      "json": true,
      "headers": {
        "X-API-Key": "51mxMHOk90UGuJCYHFYqu7PrZLdoCqfSxj9uTcGMfz67SwszdKofhVAaIhmd0ULB"
      },
      "qs": {
        "key": req.session.key
      }
    });
    req.session.destroy()
  }
  res.redirect("/")
})

app.listen(port, () => {
  console.log(`Example app listening at http://localhost:${port}`)
})