movie.js

const router = require('express').Router();
let Movie = require('../models/movie.model');

const protect = require('./protect');


router.route('/').get((req, res) => {
    Movie.find()
        .then(movie => res.json(movie))
        .catch(err => res.status(400).json('Error: ' + err));
});

router.route('/count/').get((req, res) => {
    Movie.countDocuments({}, (err, count) => {
        if (err) {
            res.status(400).json('Error: ' + err)
        }
        else {
            res.json(count)
        }
    })
});

router.route('/add').post((req, res) => {
    const newMovie = new Movie({
        ...req.body
    });

    newMovie.save()
        .then(() => res.json('Movie added!'))
        .catch(err => res.status(400).json('Error: ' + err));
});

router.route('/id/:id/rate').post(protect, (req, res) => {
    Movie.findOneAndUpdate({ id: req.params.id }, { "$inc": { "rate.amount": 1, "rate.sum": req.body.rate } })
        .then(movie => res.json(movie))
        .catch(err => res.status(404).json('Error: ' + err));
});

router.route('/id/:id').get((req, res) => {
    Movie.findOne({ id: req.params.id })
        .then(movie => res.json(movie))
        .catch(err => res.status(404).json('Error: ' + err));
});


router.route('/id/:id/title').get((req, res) => {
    Movie.findOne({ id: req.params.id }, { title: 1, _id: 0 })
        .then(movie => res.json(movie))
        .catch(err => res.status(404).json('Error: ' + err));
});


router.route('/id/:id').delete((req, res) => {
    Movie.findByIdAndDelete(req.params.id, (err, doc) => {
        if (err) console.log(err)
        else {
            res.json(doc)
        }
    })

});

router.route('/filters/runtime').get((req, res) => {
    Movie.distinct('runtime')
        .then(runtime => res.json(runtime))
        .catch(err => res.status(400).json('Error: ' + err));
});

router.route('/filters/year').get((req, res) => {
    Movie.aggregate([
        { $project: { year: { $substr: ["$date", 0, 4] }, _id: 0 } },
        { $group: { _id: "$year" } }
    ])
        .then(years => {
            res.json(years.map(obj => obj._id).sort())
        })
        .catch(err => res.status(400).json('Error: ' + err));
})

router.route('/filters/genre').get((req, res) => {
    Movie.distinct('genre')
        .then(genres => res.json(genres))
        .catch(err => res.status(400).json('Error: ' + err))
})

router.route('/filters/platform').get((req, res) => {
    Movie.distinct('platforms.name')
        .then(platforms => res.json(platforms))
        .catch(err => res.status(400).json('Error: ' + err))
})

router.route('/filtered').post((req, res) => {
    const page = req.body.page
    const filter = (req.body.filter ? req.body.filter : {})
    let query = {}
    for (const [key, value] of Object.entries(filter)) {
        if (value !== "-") {
            if (key === "date") {
                query["date"] = { $regex: value }
            }
            else if (key === "platforms") {
                query["platforms.name"] = value
            }
            else if (key === "title") {
                query["title"] = { $regex: `.*${value}.*`, $options: "$i" }
            }
            else {
                query[key] = value
            }
        }
    }
    Movie.find(query).sort({date: -1}).skip((page - 1) * 30).limit(30)
        .then(movie => res.json(movie))
        .catch(err => res.status(404).json('Error: ' + err));
});

router.route('/filtered/count').post((req, res) => {
    let query = {}
    const filter = (req.body.filter ? req.body.filter : {})
    for (const [key, value] of Object.entries(filter)) {
        if (value !== "-") {
            if (key === "date") {
                query["date"] = { $regex: value }
            }
            else if (key === "platforms") {
                query["platforms.name"] = value
            }
            else if (key === "title") {
                query["title"] = { $regex: `.*${value}.*`, $options: "$i" }
            }
            else {
                query[key] = value
            }
        }
    }
    Movie.countDocuments(query, (err, count) => {
        if (err) {
            res.status(400).json('Error: ' + err)
        }
        else {
            res.json(count)
        }
    })
})

module.exports = router;