const db = require('../config/db.config.js');
const lesson = db.lesson;

/**
 * Get Lessons 
 */
exports.getLessons = (req, res) => {
    db.sequelize.query("SELECT * FROM (SELECT * FROM lessons where course_id = " + req.headers['course-id']  + ") as l LEFT JOIN (SELECT lesson_id FROM opened_lessons where user_id = " + req.userId + ") ol ON l.id = ol.lesson_id;")
    .then(lessons => {
        for(i in lessons[0]) {
            lessons[0][i].locked = lessons[0][i].lesson_id === null ? true : false
        }
		res.status(200).json({
			"description": "Lessons Page",
			"courses": lessons[0]
		});
	}).catch(err => {
		res.status(500).json({
			"description": "Can not access courses Page",
			"error": err
		});
	})
}