require('../connections/mysql-server');
require('../helpers/CheckToken');
const express = require('express');
const router = express.Router();
const bodyParser = require('body-parser');

router.use(bodyParser.urlencoded({ extended: true }));
router.use(bodyParser.json());

var routes = function () {

  router.get('/getAllEventos', (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM agenda;`, res, req.originalUrl);
  });

  router.post('/insertEventos', verifyJWT, (req, res) => {
    const title = req.body.title;
    const date = req.body.date;
    const hour = req.body.hour;
    const duration = req.body.duration;
    const description = req.body.description;
    const access = req.body.access;
    execSQLQuery(` INSERT INTO agenda (title, date, hour, duration, description, access) values
    (
      ?,?,'2021-01-01T${hour}',?,?,?
    )` , res, req.originalUrl, [title, date, duration, description, access]);
  });

  router.post('/editEventos', verifyJWT, (req, res) => {
    const id = req.body.id;
    const title = req.body.title;
    const date = req.body.date;
    const hour = req.body.hour;
    const duration = req.body.duration;
    const description = req.body.description;
    const access = req.body.access;
    execSQLQuery(` UPDATE agenda SET 
    title='${title}', 
    date='${date}', 
    hour='2021-01-01T${hour}', 
    duration='${duration}', 
    description='${description}', 
    access='${access}' 
    WHERE (idagenda = '${id}')`
      , res, req.originalUrl);
  });

  router.post('/deleteEventos', verifyJWT, (req, res) => {
    const id = req.body.id;
    execSQLQuery(` DELETE FROM agenda
    WHERE (idagenda = '${id}')`
      , res, req.originalUrl);
  });

  return router;
};

module.exports = routes;