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;