const express = require('express')
const router = express.Router()
const connection = require('../../Config/database')
const controllerAdmin = require('../../controllers/Administration')
const controlleruser = require('../../controllers/Alliances')

router.get('/Administration/Alliances', (req, res) => controllerAdmin.findcidade3(connection, req, res));
router.get('/Administration/Alliances', (req, res) => controlleruser.findAlianca(connection, req, res));


module.exports = app => app.use('/', router)

const Allianca = require('../models/Alliances')

const findAlianca = async (connection,  req, res) => {

  const allianca = await Allianca.find(connection,req.session.user.username)
  if (!allianca) {
 res.status(404).send('Nenhuma cidade encontrada.')
 return;
}
console.log("dddd");
          req.session.alianca = allianca
          res.locals.alianca = allianca
res.render('Administration/Aliances/tem')
  }

  module.exports = {
   findAlianca
  }

const find = (connection,username) => {
        return new Promise((resolve, reject) => {
          connection.query(`SELECT alianca.nome,alianca.N_membros,alianca.TAG FROM user INNER JOIN alianca ON user.cod_alianca=alianca.id WHERE user.username='${username}'`, (err, result) => {
                if(err){
                    reject(err)
                }else{
                  console.log(result[0]);
                    resolve(result[0])
                }
            })
        })
    }

    module.exports = {
        find
    }

require('./routes/Administration/Alliances')(app)

extends layout
block title
   .col-xs-6.col-xs-offset-3.col-sm-6.col-sm-offset-3
   .col-sm-4(style='width:76%')
    div.panel.panel-primary(style='height:50px') Alliances Page
    div.panel.panel-primary(style='height:700px')  fdssdklfsdklfjskldfjkldsjfl
      if locals.user.cod_alianca==null
         p You Dont Have Alliances
      else
        br
        span Your Aliance
        span= locals.alianca.nome

   .col-xs-2.panel-red(style='width:24%;height:100%;text-align:center')

const mysql = require('mysql')
const config = require( "./config.json" )
const connection =mysql.createConnection({
 host:config.host,
 user:config.user,
 password:config.password,
 database:config.database,
// port:config.port
});

connection.connect((err) =>{
    if(err){
        console.log(err)
        process.exit(0)
    }else{
    console.log('database on')
}
})
connection.query(`CREATE TABLE IF NOT EXISTS user (userId INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(50) DEFAULT NULL, password VARCHAR(60) DEFAULT NULL, PRIMARY KEY (userId))`, (err ,result) =>{
    if(err){
        console.log(err)
    }
})

module.exports = connection