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('/getInfo/:idUser/:idUnit', verifyJWT, (req, res) => {
        console.log(req.body);
        const idUser = parseInt(req.params.idUser);
        const idUnit = parseInt(req.params.idUnit);
        execSQLQuery(`SELECT *
        FROM customizeZoeProfile
        WHERE idAluno = ${idUser} AND idUnit = ${idUnit};`, res, req.originalUrl);
    });

    router.post('/insertNew', verifyJWT, (req, res) => {
        const idUser = parseInt(req.body.idUser);
        const idUnit = parseInt(req.body.idUnit);
        execSQLQuery(`INSERT INTO
        customizeZoeProfile (idAluno, idUnit, boughtItens)
        VALUES (${idUser}, ${idUnit},
            "Eyes_Blue;Eyes_Green;Eyes_Red;Eyes_Yellow;Eyes_White;Cheek_Basic;");`, res, req.originalUrl);
    });

    router.post('/updateCoins', verifyJWT, (req, res) => {
        const coinsToAdd = parseInt(req.body.coinsToAdd);
        const idUser = parseInt(req.body.idUser);
        const idUnit = parseInt(req.body.idUnit);
        execSQLQuery(`UPDATE customizeZoeProfile
        SET coins = coins + ${coinsToAdd}
        WHERE idAluno = ${idUser} AND idUnit = ${idUnit};`, res, req.originalUrl);
    });

    router.post('/updateItens', verifyJWT, (req, res) => {
        const itemToAdd = req.body.itemToAdd;
        const coinsToRemove = parseInt(req.body.coinsToRemove);
        const idUser = parseInt(req.body.idUser);
        const idUnit = parseInt(req.body.idUnit);
        execSQLQuery(`UPDATE customizeZoeProfile
        SET coins = coins - ${coinsToRemove}, boughtItens = '${itemToAdd}'
        WHERE idAluno = ${idUser} AND idUnit = ${idUnit};`, res, req.originalUrl);
    });

    router.post('/updateActualItens', verifyJWT, (req, res) => {
        const newActuals = req.body.newActuals;
        const idUser = parseInt(req.body.idUser);
        const idUnit = parseInt(req.body.idUnit);
        execSQLQuery(`UPDATE customizeZoeProfile
        SET actualItens = '${newActuals}'
        WHERE idAluno = ${idUser} AND idUnit = ${idUnit};`, res, req.originalUrl);
    });

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

  return router;
};

module.exports = routes;