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('/getAllTTSmode', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM TTSmode
    order by description asc;`, res, req.originalUrl);
  });

  router.get('/getAllSTTmode', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM STTmode
    order by description asc;`, res, req.originalUrl);
  });

  router.get('/getAllChatBot', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      *
    FROM ChatBot
    order by description asc;`, res, req.originalUrl);
  });

  router.get('/getZoeConfig', verifyJWT, (req, res) => {
    execSQLQuery(`SELECT
      TTSmode,
      STTmode,
      RMaudio,
      ChatBot,
      zoevoiceEn,
      zoevoicePt
    FROM config;`, res, req.originalUrl);
  });

  router.post('/saveZoeConfig', verifyJWT, (req, res) => {
    const ChatBot = parseInt(req.body.ChatBot);
    const RMaudio = req.body.RMaudio ? 1 : 0;
    const STTmode = parseInt(req.body.STTmode);
    const TTSmode = parseInt(req.body.TTSmode);
    const zoevoiceEn = req.body.zoevoiceEn;
    const zoevoicePt = req.body.zoevoicePt;
    execSQLQuery(`update config set
      TTSmode = ${TTSmode},
      STTmode = ${STTmode},
      RMaudio = ${RMaudio},
      ChatBot = ${ChatBot},
      zoevoiceEn = '${zoevoiceEn}',
      zoevoicePt = '${zoevoicePt}'
    where idconfig = 1;`, res, req.originalUrl);
  });

  return router;
};

module.exports = routes;