60 lines
1.7 KiB
JavaScript
60 lines
1.7 KiB
JavaScript
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; |