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('', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM concepts;`, res, req.originalUrl);
  });

  router.get('/List', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM concepts
    WHERE disabled = 0;`, res, req.originalUrl);
  });

  router.get('/getConcept/:idconcepts', verifyJWT, (req, res) => {
    const idconcepts = parseInt(req.params.idconcepts);
    execSQLQuery(`SELECT
      *
    FROM concepts
    WHERE idconcepts = ${idconcepts};`, res, req.originalUrl);
  });

  router.post('/insert', verifyJWT, (req, res) => {
    const idconcepts = parseInt(req.body.idconcepts);
    const concept = req.body.concept;
    const weight = req.body.weight;
    const disabled = req.body.disabled ? 1 : 0;
    execSQLQuery(`INSERT INTO concepts(concept, weight, disabled)
    VALUES (?, ?, ?);`, res, req.originalUrl, [concept, weight, disabled]);
  });

  router.patch('/update', verifyJWT, (req, res) => {
    const idconcepts = parseInt(req.body.idconcepts);
    const concept = req.body.concept;
    const weight = req.body.weight;
    const disabled = req.body.disabled ? 1 : 0;
    execSQLQuery(`UPDATE concepts SET
      concept = ?,
      weight = ?,
      disabled = ?
    WHERE idconcepts = ?;`, res, req.originalUrl, [concept, weight, disabled, idconcepts]);
  });

  router.get('/disable/:idconcepts', verifyJWT, (req, res) => {
    const idconcepts = parseInt(req.params.idconcepts);
    execSQLQuery(`UPDATE concepts SET
      disabled = not disabled
    WHERE idconcepts = ${idconcepts};`, res, req.originalUrl);
  });

  return router;
};

module.exports = routes;