var express = require('express');
var router = express.Router();

function addMyToons(id,index,cb){
  connection.query("INSERT INTO user_toon_relation SET ?;", {user_id : id,toon_index : index},function (err) {
    if(err) {
        throw err;
        console.log("내 웹툰 추가 중 에러!")
    } else {
      alert("추가되었습니다.")
      cb();
    }
  });
}

//내툰 수정하기
router.post('/toggle_toon',function(req,res,next) {
  var index = req.body.toon_index;
  var id = req.user.user_id;
  connection.query("SELECT COUNT(*) FROM user_toon_relation WHERE user_id='"+id+"' && toon_index='"+index+"'", [id,index], function (err, rows,result) {
    if(err) {
      console.log("내 웹툰 등록 중 에러!");
    } else {
      var count = rows[0]["COUNT(*)"];
      if(count > 0) { //이미 등록되어 있는 것이라면,
        connection.query("DELETE FROM user_toon_relation WHERE user_id='"+id+"' && toon_index='"+index+"';", [id, index],function (err, rows, result) {
          if(err) {
            console.log("내 웹툰 제거중 에러!");
            throw err;
          } else {
            alert("제거되었습니다.")
            res.redirect('/setting');
          }
        });
      } else {
        addMyToons(id,index,function() {
          res.redirect('/setting');
        });
      }
    }
  });
});

//
function getMyToons(id,cb){
  //mysql5.7 syntax에 맞게 수정 => 로그인한 유저의
  var sqlquery = "SELECT  t.toon_index, t.name, t.thum_link, t.webtoon_link, t.week, t.site FROM user u, user_toon_relation ur, toon t WHERE u.id = '"+id+"' && u.id=ur.user_id && t.toon_index=ur.toon_index;";
  var mylist = new Array();
  connection.query(sqlquery,id,function(err,rows,result) {
    if(!err) {
      mylist = rows;
      cb(mylist);
    } else {
      router.get('/')
      console.log("내 웹툰 리스트 가져오는데 실패했습니다!");
      //throw err;
    }
  });
}

router.get('/', function(req, res, next) {
  getMyToons(req.user.user_id,function (mytoons) {
    res.render('setting',{
      alltoons : allWebtoons,
      mytoons : mytoons
    });
  })
});

module.exports = router;