require('../connections/mysql-server');
require('../helpers/CheckToken');
require('../helpers/config');

const express = require('express');
const router = express.Router();
const bodyParser = require('body-parser');

router.use(bodyParser.urlencoded({
    limit: '10mb',
    extended: true
  }
));
router.use(bodyParser.json({
  limit: '10mb',
  extended: true
}));

var routes = function () {

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

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

  router.post('/insert', verifyJWT, (req, res) => {
    const idcuriosities = parseInt(req.body.idcuriosities);
    const src = req.body.src;
    const description = req.body.description;
    const itens = parseInt(req.body.itens);
    execSQLQuery(`INSERT INTO curiosities (src, description, itens)
    VALUES (?, ?, ?);`, res, req.originalUrl, [src, description, itens]);
  });

  router.patch('/update', verifyJWT, (req, res) => {
    const idcuriosities = parseInt(req.body.idcuriosities);
    const src = req.body.src;
    const description = req.body.description;
    const itens = req.body.itens;
    execSQLQuery(`UPDATE curiosities SET
      src = ?,
      description = ?,
      itens = ?
    WHERE idcuriosities = ?;`, res, req.originalUrl, [src, description, itens, idcuriosities]);
  });

  router.post('/copy', verifyJWT, (req, res) => {
    var base64ToImage = require('base64-to-image');
    var img64 = req.body.src;
    var Name = req.body.name;
    var Obj = {'fileName': Name, 'type':'jpg'};
    var path = Variables('src_media') + 'files/';
    if(base64ToImage(img64,path,Obj)) {
      res.send(true)
    }
    else {
      res.send(false);
    }
    //res.send("images uploaded with success!");
  });

  router.post('/backimg', verifyJWT, (req, res) => {
    var base64Img = require('base64-img');
    var name = req.body.name;
    var src = Variables('src_media') + 'files/' + name + '.jpg';
    if(base64Img.base64Sync(src)) {
      var srcCuriosity = base64Img.base64Sync(src);
    } else {
      var srcCuriosity = "";
    }
    var imagens = {
        srcCuriosity: srcCuriosity
    }
    res.send(imagens);
  });

  return router;
};

module.exports = routes;