router.get('/city', async (req, res, next) => {
    try {
           
            let hosts;
            let count;
            let city;
            let category
...
                        hosts = await Host.findAll({
                    where: {
                        hostaddress: {
                            [Op.like]: "%" + req.query.city + "%"
                        },
                    },
                    include: {
                        model: Image,
                        attributes: ['src'],
                    },
                    order: [['id', 'DESC']],
                    offset: offset,
                    limit: 12,
                            
                         });
            count = await Host.count({
                where: {
                    city: {
                        [Op.like]: "%" + req.query.city + "%"
                    },
                },
            });
            if(req.query.city) {
                city = req.query.city;
            } else {
                city = "전체"
            }
            res.render('hosts', {hosts, count, city});
        }
        
    } catch (error) {
        console.error(error);
        next(error);
    }
});

// 프론트 코드
document.getElementById('join__form').addEventListener('submit', (e) => {
            e.preventDefault();
            const joinData = {
                email: e.target.email.value,
                password: e.target.password.value,
                name: e.target.name.value,
                nickname: e.target.nickname.value,
                phone: e.target.firstNum.value + e.target.middleNum.value + e.target.lastNum.value,
            } 
            console.log(joinData);  
            if(joinData.email === "" ) {
                return alert('이메일을 입력해주세요.');
            }
            if(joinData.password < 4) {
                return alert('비밀번호는 4글자 이상입니다.');
            }
            if(joinData.name === "" || joinData.nickname === "" || joinData.phone === "" || joinData.phone.length > 11) {
                return alert('잘못된 정보입니다.');
            }
            
             axios.post('/auth/join', joinData)
                .then((response) => {
                    if(response.data.joinsuccess){
                        alert(response.data.message);
                        return window.location = "/login";
                    }
                    alert(response.data.message);
                    return location.reload();
                })
                .catch((error) => {
                    console.log(error);
                });

           
            e.target.email.value = '';
            e.target.password.value = '';
            e.target.name.value = '';
            e.target.nickname.value = '';
            e.target.firstNum.value = '';
            e.target.middleNum.value = '';
            e.target.lastNum.value = '';
        });
// 서버 코드
router.post('/join', isNotLoggedIn, async (req, res, next) => {
    try {
        const {
            email,
            password,
            name,
            nickname,
            phone,
        } = req.body;
        console.log(req.body);
        //const phone = firstNum + middleNum + lastNum;
        const user = await User.findOne({ where: {email} });
        if(user) {
            return res.json({ joinsuccess: false, message: "입력하신 이메일로 가입한 계정이 존재합니다..." });
        }
        const hash = await bcrypt.hash(password, 12);
        const newUser = await User.create({
            email,
            password: hash,
            name,
            nickname,
            phone,
        });
        return res.json({ joinsuccess: true, message: "회원가입 성공입니다."});
        
    } catch (error) {
        console.error(error);
        return res.json({ joinsuccess: false, message: "데이터 베이스 오류 입니다 관리자에게 문의 하세요..."});
    }
});

try {
    fs.readdirSync('uploads');
} catch (error) {
    console.error('uploads 폴더가 없어 uploads 폴더를 생성 합니다.');
    fs.mkdirSync('uploads');
}

const upload = multer({
    storage: multer.diskStorage({
        destination(req, file, cb) {
            cb(null, 'uploads/');
        },
        filename(req, file, cb) {
            const ext = path.extname(file.originalname);
            cb(null, path.basename(file.originalname, ext) + Date.now() + ext);
        },
    }),
});

// 게시글 업로드
router.post('/host', isLoggedIn, upload.array('img'), async (req, res, next) => {
    const hostaddress = req.body.firstCity.concat(" ", req.body.middleCity," ", req.body.hostaddress);

    try{
        const newHost = await Host.create({
            title: req.body.title,
            hostaddress,
            city: req.body.firstCity,
            person: req.body.person,
            roominfo_room: req.body.room,
            roominfo_bed: req.body.bed,
            roominfo_cook: req.body.cook,
            roominfo_bathroom: req.body.bathroom,
            hostinfo: req.body.hostinfo,
            hosttype: req.body.hosttype,
            UserId: req.user.id,
        });
        for(i=0; i<req.files.length; i++){
            let newImage = await Image.create({
                src: "img/" + req.files[i].filename,
                HostId: newHost.id,
            });
            
        }
        console.log("success");
        res.redirect('/');
    } catch (error) {
        console.log(error);
        next(error);
    }
});