server.js

import express from 'express';
import session from 'express-session';
import passport from 'passport';
import GoogleStrategy from 'passport-google-oauth2';
import database from './database.js';
import url from 'url';
import path from 'path';
import fileupload from 'express-fileupload'
import { HowLongToBeatService, HowLongToBeatEntry } from 'howlongtobeat';
import dotenv from 'dotenv';
import puppeteer from 'puppeteer';
import request from 'request';

let hltbService = new HowLongToBeatService();

dotenv.config();

const app = express();
var __filename = url.fileURLToPath(
  import.meta.url);
var __dirname = path.dirname(__filename) + "/views";
var caminhopadrao = path.dirname(__filename);

app.use((req, res, next) => {
   console.log(req.url);
    next();
  })


app.listen(8080, () => console.log('Servidor rodando!'));

app.use(fileupload());
app.use(express.json());
app.use(express.static('assets/css'));
app.use(express.static('assets/js'));
app.use(express.static('assets/img'));
app.use(session({
  resave: false,
  saveUninitialized: true,
  secret: 'calvo'
}));

app.use(passport.initialize());
app.use(passport.session());
passport.use(new GoogleStrategy({
      clientID: process.env.clientID,
      clientSecret: process.env.clientSecret,
      callbackURL: "http://localhost:8080/callback",
      passReqToCallback: true
  },
  function (request, accessToken, refreshToken, profile, done) {
      return done(null, profile);
  }
));

passport.serializeUser((user, done) => {
  done(null, user)
});

passport.deserializeUser((user, done) => {
  done(null, user)
});

function isLoggedIn(req, res, next) {
  if (req.isAuthenticated()) { return next() }
  res.redirect("/login")
}
app.get('/login', (req, res) => {
  res.header('Content-Type', 'text/html');
  res.sendFile(__dirname + '/login.html');
})

app.get('/google',
    passport.authenticate('google', {
        scope: ['email', 'profile']
    }));

app.get('/callback',
    passport.authenticate('google', {
        successRedirect: '/verificacao',
        failureRedirect: '/google/failure'
    })
);

app.get('/google/failure', async (req, res) => {
    res.send("Deu errado!", function (err) {
        if (err) {
            return res.status(err.status).end();
        } else {
            return res.status(200).end();
        }
    });
});


app.get('/verificacao', isLoggedIn, async (req, res) => {
  let foto = req.user.photos[0].value;
  let nome = req.user.displayName;
  let idfacebook = req.user.id;
  let resposta = await database.getLogin(idfacebook);
  if(resposta.length == 0){
    let insert =  await database.insertUser(idfacebook, nome, foto);
    if (insert.numero = !0) {
      res.redirect('/configuracao');
  }}else{
    res.redirect('/cadastro');
  }});   

app.post('/jogou', isLoggedIn, async (req, res) => {
  let {vnome, vurl, vhora, vvalor, vplataforma, vid, vmulti, vprogresso} = req.body;
  await database.cadastrarjogo(vnome, vurl, vhora, vvalor, vplataforma, vid, vprogresso, vmulti, req.user.id);
  })


app.get('/cadastro', isLoggedIn,  (req, res) => {
    res.header('Content-Type', 'text/html');
    res.sendFile(__dirname + '/cadastro.html');
  })

  app.get('/dados', isLoggedIn,  async (req, res) => {

    let todo = await database.gettodos(req.user.id);
    let platina = await database.getplatinas(req.user.id);
    let hora = await database.gethoras(req.user.id);
    let valor = await database.getvalores(req.user.id);
    res.send([{
      nome: req.user.displayName,
      foto: req.user.picture, 
      todos: todo.length, 
      platinas: platina.length,
      horas: hora[0].qtd + "h",
      valores: 'R$' + valor[0].quanto

    }]);
  })
  app.get('/dados1', isLoggedIn,  async (req, res) => {

    let todo = await database.gettodos1(req.user.id);
    let platina = await database.getplatinas1(req.user.id);
    let hora = await database.gethoras1(req.user.id);
    let valor = await database.getvalores1(req.user.id);
    res.send([{
      nome: req.user.displayName,
      foto: req.user.picture, 
      todos: todo.length, 
      platinas: platina.length,
      horas: hora[0].qtd + "h",
      valores: 'R$' + valor[0].quanto

    }]);
  })

  app.get('/getjogosc', isLoggedIn,  async (req, res) => {
    res.send(await database.getjogosc(req.user.id));
  })
  app.get('/getjogost', isLoggedIn,  async (req, res) => {
    res.send(await database.getjogost(req.user.id));
  })
  app.get('/getjogosn', isLoggedIn,  async (req, res) => {
    res.send(await database.getjogosn(req.user.id));
  })
  app.get('/getjogosa', isLoggedIn,  async (req, res) => {
    res.send(await database.getjogosa(req.user.id));
  })

app.get('/pesqjogo/:jogo', isLoggedIn, (req, res) => {
  
  hltbService.search(req.params.jogo).then(result => res.send(result));
  
})    
app.get('/jogopesq/:pesquisa', isLoggedIn,  async (req, res) => {
  res.send(await database.getpesquisa(req.user.id, req.params.pesquisa));
})

app.get('/cadastrar', isLoggedIn,  (req, res) => {
  res.header('Content-Type', 'text/html');
  res.sendFile(__dirname + '/cadastrar.html');
})
app.get('/perfil', isLoggedIn,  (req, res) => {
  res.header('Content-Type', 'text/html');
  res.sendFile(__dirname + '/lista.html');
})

app.get('/price/:nome', async (req, res) => {
  // let precojogo = await pesquisa_jogo(req.params.nome)
  // const link = `https://economia.awesomeapi.com.br/json/last/USD-BRL`;
  // request(link, (err, response, html) => {
  //   if (!err) {
  //     const json1 = JSON.parse(html);
  //     res.send([{ dinheiro: precojogo*json1.USDBRL.high }]);

  //   }
  // });
  

  

})

async function pesquisa_jogo(jogo) {

  const browser = await puppeteer.launch({
    headless: true
  });
  const page = await browser.newPage();
  await page.setUserAgent('Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0');
  await page.setViewport({
    width: 1280,
    height: 1800
  })
  await page.goto("https://www.pricecharting.com/search-products?q="+ jogo + "&type=prices");
  const resultado = await page.evaluate(() => {

    let rnome = document.querySelectorAll("td.title > a")[0].textContent
    let rpreco = document.querySelectorAll("td.price.numeric.cib_price > span")[0].textContent
      
      console.log(rnome)
        return rpreco
        
}); await browser.close();
 return resultado.replace("$", "");}


app.get('*', isLoggedIn, (req, res) => {
  res.header('Content-Type', 'text/html');
  res.sendFile(__dirname + '/login.html');
})