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

var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'soap',
    password : '111111',
    port     : 3306,
    database : 'ytmt'
});

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;