const SalesRepository = require('../../repository/admin/SalesRepository.js');
const HttpException = require('../../utils/HttpException.js');
const { SearchFilter } = require('../../utils/SearchFilter.js');
const timeLocal = require('../../utils/TimeLocal.js');
const { createLog, updateLog, deleteLog } = require('../../utils/LogActivity.js');

exports.getAllSalesService = async ({ page, limit, search, sortBy, orderBy }) => {
    const skip = (page - 1) * limit;

    const where = {
        ...SearchFilter(search, ['username', 'email', 'firstname', 'lastname']),
        deletedAt: null
    };

    const [sales, total] = await Promise.all([
        SalesRepository.UserRepository.findAll({ skip, take: limit, where, orderBy: { [sortBy]: orderBy } }),
        SalesRepository.UserRepository.countAll(where)
    ]);

    return { sales, total };
};

exports.showSalesService = async (id) => {
    const sales = await SalesRepository.UserRepository.findById(id);
    if (!sales) {
        throw new HttpException("Data sales not found", 404);
    }
    return sales;
};

exports.storeSalesService = async (userData, req) => {
    const userId = await SalesRepository.KeycloakRepository.createUser(userData);
    await SalesRepository.KeycloakRepository.assignSalesRole(userId);
    const data = await SalesRepository.UserRepository.createUser(userId, userData);

    if (userData.province_ids && userData.province_ids.length > 0) {
        await SalesRepository.UserAreaRepository.createMany(userId, userData.province_ids);
    }

    await createLog(req, data);
};

exports.updateSalesService = async (userData, id, req) => {
    const sales = await SalesRepository.UserRepository.findById(id);
    if (!sales) throw new HttpException('Sales not found', 404);

    await SalesRepository.KeycloakRepository.updateUser(id, userData);
    const data = await SalesRepository.UserRepository.updateUser(id, userData);

    if (userData.province_ids && userData.province_ids.length > 0) {
        await SalesRepository.UserAreaRepository.deleteByUserId(id);
        await SalesRepository.UserAreaRepository.createMany(id, userData.province_ids);
    }

    await updateLog(req, data);
};

exports.deleteSalesService = async (id, req) => {
    const sales = await SalesRepository.UserRepository.findById(id);
    if (!sales) {
        throw new HttpException('Sales not found', 404);
    }

    await SalesRepository.KeycloakRepository.deleteUser(id);
    const data = await SalesRepository.UserRepository.deleteUser(id, { deletedAt: timeLocal.now().toDate() });

    await deleteLog(req, data);
};