const db = require("../models");
const Project = db.projects;
const Op = db.Sequelize.Op;

const LocaleService = require('../services/locale.service.js');
const localeService = new LocaleService();

// Create and Save a new Project
exports.create = (req, res) => {
    // Validate request
    if (!req.body.title) {
        res.status(400).send({
            message: "Content can not be empty!"
        });
        return;
    }
    
    // Create a Project
    const Project = {
        title: req.body.title,
        description: req.body.description,
        published: req.body.published ? req.body.published : false
    };
    
    // Save Project in the database
    Project.create(Project)
    .then(data => {
        res.send(data);
    })
    .catch(err => {
        res.status(500).send({
            message:
            err.message || "Some error occurred while creating the Project."
        });
    });
};

// Retrieve all Projects from the database.
exports.findAll = (req, res) => {
    //const title = req.query.title;
    
    //Project.findAll({ where: condition })
    //Project.findAll({include: ["titles"]})
    //Project.findAll({where: {visible: true,},include: db.License})
    Project.findAll({where: {visible: true,}, include: ["license"], attributes: {exclude: ['licenseId']}})
    .then(async data => {
        data = await localeService.localizeProjects(data, db);
        res.send(data);
    })
    .catch(err => {res.status(500).send({message: err.message || "Some error occurred while retrieving Projects."});});
};

// Find a single Project with an id
exports.findOne = (req, res) => {
    const id = req.params.id;
    Project.findByPk(id, {where: {visible: true,}, include: ["license"], attributes: {exclude: ['licenseId']}})
    .then(async data => {
        if (data) {
            data = await localeService.localizeProject(data, db);
            res.send(data);
        }
        else {
            res.status(404).send({message: `Cannot find Project with id=${id}.`});
        }
    })
    .catch(err => {res.status(500).send({message: "Error retrieving Project with id=" + id});});
};

// Update a Project by the id in the request
exports.update = (req, res) => {
    const id = req.params.id;
    
    Project.update(req.body, {
        where: { id: id }
    })
    .then(num => {
        if (num == 1) {
            res.send({
                message: "Project was updated successfully."
            });
        } else {
            res.send({
                message: `Cannot update Project with id=${id}. Maybe Project was not found or req.body is empty!`
            });
        }
    })
    .catch(err => {
        res.status(500).send({
            message: "Error updating Project with id=" + id
        });
    });
};

// Delete a Project with the specified id in the request
exports.delete = (req, res) => {
    const id = req.params.id;
    
    Project.destroy({
        where: { id: id }
    })
    .then(num => {
        if (num == 1) {
            res.send({
                message: "Project was deleted successfully!"
            });
        } else {
            res.send({
                message: `Cannot delete Project with id=${id}. Maybe Project was not found!`
            });
        }
    })
    .catch(err => {
        res.status(500).send({
            message: "Could not delete Project with id=" + id
        });
    });
};

// Delete all Projects from the database.
exports.deleteAll = (req, res) => {
    Project.destroy({
        where: {},
        truncate: false
    })
    .then(nums => {
        res.send({ message: `${nums} Projects were deleted successfully!` });
    })
    .catch(err => {
        res.status(500).send({
            message:
            err.message || "Some error occurred while removing all Projects."
        });
    });
};

// Find all published Projects
exports.findAllPublished = (req, res) => {
    Project.findAll({ where: { published: true } })
    .then(data => {
        res.send(data);
    })
    .catch(err => {
        res.status(500).send({
            message:
            err.message || "Some error occurred while retrieving Projects."
        });
    });
};