require('../connections/sql-server');
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('/courses/:idmatricula/:idtreinando', (req, res) => {
    const idmatricula = parseInt(req.params.idmatricula);
    const idtreinando = parseInt(req.params.idtreinando);

    execSQLQuery(`
        select TT.IDCurso, TT.IDMatricula, TT.IDTreinando,
        C.NomeVersao
        from TreinandosTurmas TT
        inner join Cursos C
        on C.Codigo = TT.IDCurso
        inner join TurmasDetalhe TD
        on TD.IDTurma = TT.CodigoTurma
        and TD.CodigoCurso = TT.IDCurso
        where TT.IDMatricula = ${idmatricula}
        and TT.IDTreinando = ${idtreinando}
        order by TD.Ordem asc`,
      res,
      req.originalUrl
    );
  })

  return router;
};

module.exports = routes;