var express  = require('express');
var cheerio  = require('cheerio');
var request  = require('request');
var mysql    = require('mysql');
var client   = require('cheerio-httpcli');
var passport = require('passport');
var KakaoStrategy = require('passport-kakao').Strategy;
var NaverStrategy = require('passport-naver').Strategy;
var GoogleStrategy = require('passport-google-oauth').OAuth2Strategy;
var router   = express.Router();

// kakao login API
var kakaoKey = {
  clientID    : '5634a5f8ca5c9a5eb378d6b6e6e869a0',
  callbackURL : '/auth/login/kakao/callback'
};

// naver login API
var naverKey = {
  clientID     : 'OHmCrpQuVFnIEB4GkmF_',
  callbackURL  : '/auth/login/naver/callback',
  clientSecret : 'BBgcRdnj0M'
};

// google login API
var googleKey = {
  clientID     : '924802195853-ir977i2ohnddaaninlqlbeg6sov629hq.apps.googleusercontent.com',
  callbackURL  : '/auth/login/google/callback',
  clientSecret : 'NaWeoJouUzYq4VfBesTkdUfA'
};

// kakao passport
passport.use(new KakaoStrategy(kakaoKey,
  function(accessToken, refreshToken,params, profile, done) {
    console.log(profile);
    loginByThirdparty({
      'auth_type' : 'kakao',
      'auth_id'   : profile._json.id,
      'auth_name' : profile._json.properties.nickname
    }, done);
  }
));

// naver passport
passport.use(new NaverStrategy(naverKey,
  function (accessToken, refreshToken, profile, done) {
    console.log(profile);
    loginByThirdparty({
      'auth_type': 'naver',
      'auth_id': profile._json.id,
      'auth_name': profile._json.nickName
    }, done);
  }
));

// google passport
passport.use(new GoogleStrategy(googleKey,
  function (accessToken, refreshToken, profile, done) {
   console.log(profile);
   loginByThirdparty({
     'auth_type': 'naver',
     'auth_id': profile._json.sub,
     'auth_name': profile._json.email
   }, done);
  }
));

// kakao 로그인, 로그인 콜백
router.get('/auth/login/kakao', passport.authenticate('kakao'));
router.get('/auth/login/kakao/callback', passport.authenticate('kakao', {
  successRedirect: '/mytoons',
  failureRedirect: '/'
  })
);

// naver 로그인, 로그인 콜백
router.get('/auth/login/naver', passport.authenticate('naver'));
router.get('/auth/login/naver/callback', passport.authenticate('naver', {
  successRedirect: '/mytoons',
  failureRedirect: '/'
  })
);

// facebook 로그인, 로그인 콜백
router.get('/auth/login/google', passport.authenticate('google', { scope: ['email profile'] }));
router.get('/auth/login/google/callback', passport.authenticate('google', {
  successRedirect: '/mytoons',
  failureRedirect: '/'
  })
);

// 로그인 처리
function loginByThirdparty(info, done) {
  var stmt_duplicated = "select *from `user` where id = id";
  //'select *from `user` where `id` = ?
  //"INSERT INTO `user` (id) VALUES (?) ON DUPLICATE KEY UPDATE id=id"
  connection.query(stmt_duplicated, info.auth_id, function (err, result) {
    if (err) {
      return done(err);
    } else {
      if (result.length === 0) {
        // 신규 유저는 회원 가입 이후 로그인 처리
        var stmt_thridparty_signup = 'insert into `user` set `user_id`= ?, `nickname`= ?';
        //
        connection.query(stmt_thridparty_signup, [info.auth_id, info.auth_name], function (err, result) {
          if(err){
            return done(err);
          } else {
            done(null, {
              'user_id': info.auth_id,
              'nickname': info.auth_name
            });
          }
        });
      } else {
        //기존유저 로그인 처리
        console.log('Old User');
        done(null, {
          'user_id': info.auth_id,
          'nickname': info.auth_name
        });
      }
    }
  });
}

router.get('/login', function(req,res) {
  res.render('login_page')
})


// 라우터 설정, 카카오
router.get('/auth/logout/kakao',function (req,res) {
  req.logout();
  res.redirect('/');
})

// 라우터 설정, 페이스북
router.get('/auth/logout/naver',function (req,res) {
  req.logout();
  res.redirect('/');
})

// 라우터 설정, 구글
router.get('/auth/logout/google',function (req,res) {
  req.logout();
  res.redirect('/');
})

//
function getLatestToon(titleid, day ,cb) {

}

var daumCount = 0;


// Shows Top-10 webtoons
function gettop(){
  var daum = 'http://webtoon.daum.net/data/pc/webtoon/list_daily_ranking/serialized?timeStamp=1559440437553';
  var site = 'daum';

  client.fetch(daum, {}, function (err, $, res, body){

    var data = JSON.parse(body);
    var list = data['data'];

    list.forEach(function(item, idx){
      var webtoon_link = 'http://webtoon.daum.net/webtoon/view/' + item.nickname.toString();
      var webtoon = {
        toon_index : item.id,
        name : item.title,
        thum_link : item.pcThumbnailImage.url,
        webtoon_link : webtoon_link,
        week : "TOP-10",
        site : site,
        lates : item.latestWebtoonEpisode.episode
      }
      allWebtoonList.push(webtoon);
    });
  });
};



//_day요일의 다음웹툰 불러오기
function getDaumToons(_day) {

  var day = _day;
  var day_name = day;
  var daum = `http://webtoon.daum.net/data/pc/webtoon/list_serialized/${day}?timeStamp=1515819276574`;
  var site = 'daum';

  client.fetch(daum, {}, function (err, $, res, body){

    var data = JSON.parse(body);
    var list = data["data"];

    if(err) {
      console.log("다음웹툰 DB 에러 : " + err);
    } else {
      list.forEach(function (item, idx) {

        var webtoon_link = 'http://webtoon.daum.net/webtoon/view/' + item.nickname.toString();
        var webtoon = {
          toon_index   : item.id,
          name         : item.title,
          thum_link    : item.pcThumbnailImage.url,
          webtoon_link : webtoon_link,
          week         : day_name,
          site         : site,
          latest       : item.latestWebtoonEpisode.episode,
          averageScore : item.webtoonServices.averageScore
        };
        daumCount++;
        allWebtoonList.push(webtoon);
      });
    }
  });
}

// 네이버 전체 웹툰 불러오기
function getNaverToons() {

  var allWeeklyToonsUrl = "http://comic.naver.com/webtoon/weekday.nhn";
  // 네이버 웹툰 개수
  var naverCount = 0;
  var webtoonCount = 0;

  request(allWeeklyToonsUrl,function (err, res, html) {
    if(!err){
      var $ = cheerio.load(html);
      var p = Promise.resolve();
      var eachs = $(".thumb").each(function (i) {

        var week = $(this).parent().parent().prev().attr('class');
        var webtoon_link = "http://comic.naver.com" + $(this).children().first().attr('href');
        var thumb_link = $(this).children().first().children().first().attr('src');
        var name = $(this).next().text();
        var titleid = webtoon_link.split('?')[1].split('&')[0].split('=')[1];
        var site = 'naver';
        var webtoon= {
            toon_index: titleid,
            name : name,
            thum_link : thumb_link,
            webtoon_link : webtoon_link,
            week : week,
            site : site,
            latest : 0,
            averageScore : 0
        };
        naverCount++;
        allWebtoonList.push(webtoon);
      });

      p.then(function() {
        i = 0;
        allWebtoonList.forEach(function (webtoon) {
          var sql= "INSERT INTO `toon` (toon_index, name, thum_link, webtoon_link, week, site, latest) VALUES(?) ON DUPLICATE KEY UPDATE latest=latest";
          var values=[webtoon.toon_index, webtoon.name, webtoon.thum_link, webtoon.webtoon_link,webtoon.week, webtoon.site, webtoon.latest];

          connection.query(sql,[values],function(err,result){
            if(err) {
              console.log("웹툰 DB 에러 : " + err);
            } else {
              webtoonCount++;
              console.log(`웹툰 ${webtoonCount}개 DB처리 완료!`);
            }
          });
        })
      });
    }
    console.log(`다음웹툰 ${daumCount}개, 네이버웹툰 ${naverCount}개`)
  });
}

// 모든 웹툰을 담고있는 배열
allWebtoons = new Array();

// 설명
function getAllToons() {

    allWebtoonList = new Array();

    //월요일 다음 웹툰
    getDaumToons('mon');
    //화요일 다음 웹툰
    getDaumToons('tue');
    //수요일 다음 웹툰
    getDaumToons('wed');
    //목요일 다음 웹툰
    getDaumToons('thu');
    //금요일 다음 웹툰
    getDaumToons('fri');
    //토요일 다음 웹툰
    getDaumToons('sat');
    //일요일 다음 웹툰
    getDaumToons('sun');
    //Top10
    gettop()
    //네이버 웹툰
    getNaverToons();

    allWebtoons = allWebtoonList;
};

//처음 한번 수행
getAllToons();

//5분에 한번 수행
setInterval(getAllToons, 5*60*1000);

/* GET home page. */
router.get('/', function(req,res,next) {

    if(req.isAuthenticated()) {
        res.redirect('/mytoons');
        console.log("(!)Already logined");
    } else {
        console.log("(!)로그인세션 없음");
        res.render('index',{
            title: "니툰내툰",
            list: allWebtoons
        });
    }
});

module.exports = router;