const conn = require('../../core/util/conn');
const query = require('../../core/util/query/kaskolu-cihazlar-queries');

exports.getAll = async (req, res) => {
    conn.query(query.GET_ALL, (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getById = async (req, res) => {
    let id = req.body.id;

    conn.query(query.GET_BY_ID(id), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results[0]);
    });
};

exports.getByPoliceNo = async (req, res) => {
    let policeNo = req.body.policyNo;

    conn.query(query.GET_BY_POLICE_NO(policeNo), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results[0]);
    });
};

exports.getByCity = async (req, res) => {
    let city = req.body.city;

    conn.query(query.GET_BY_CITY(city), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getCityCodes = async (req, res) => {
    conn.query(query.GET_CITY_CODES, (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByPrice = async (req, res) => {
    let price = req.body.price;

    conn.query(query.GET_BY_PRICE(price), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getBrands = async (req, res) => {
    conn.query(query.GET_BRANDS, (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getBrandsById = async (req, res) => {
    const id = req.body.id;

    conn.query(query.GET_BRANDS_BY_ID(id), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results[0]);
    });
};

exports.getModelById = async (req, res) => {
    const id = req.body.id;

    conn.query(query.GET_MODEL_BY_ID(id), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results[0]);
    });
};

exports.getStorage = async (req, res) => {
    conn.query(query.GET_STORAGE, (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByTakipNo = async (req, res) => {
    const value = req.body.value;

    conn.query(query.GET_BY_TAKIPNO(value), (err, results) => {
        if (err) throw err.message;

        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByDate = async (req, res) => {
    const value = req.body.date;

    conn.query(query.GET_BY_DATE(value), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getBetweenDate = async (req, res) => {
    const startDate = req.body.startDate;
    const endDate = req.body.endDate;

    conn.query(query.GET_BETWEEN_DATE(startDate, endDate), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getBetweenActivateDate = async (req, res) => {
    const startDate = req.body.startDate;
    const endDate = req.body.endDate;

    conn.query(query.GET_BETWEEN_ACTIVATE_DATE(startDate, endDate), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getBetweenBirthDate = async (req, res) => {
    const startDate = req.body.startDate;
    const endDate = req.body.endDate;

    conn.query(query.GET_BETWEEN_BIRTH_DATE(startDate, endDate), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByGender = async (req, res) => {
    const gender = req.body.gender;

    conn.query(query.GET_BY_GENDER(gender), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByCustomerType = async (req, res) => {
    const type = req.body.type;

    conn.query(query.GET_BY_CUSTOMER_TYPE(type), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByNationality = async (req, res) => {
    const nationality = req.body.nationality;

    conn.query(query.GET_BY_NATIONALITY(nationality), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};

exports.getByTransactionId = async (req, res) => {
    const nationality = req.body.nationality;

    conn.query(query.GET_BY_NATIONALITY(nationality), (err, results) => {
        if (err) throw err.message;
        res.setHeader('Content-Type', 'application/json');
        res.status(200).json(results);
    });
};