package cc.mrbird.febs.ai.service.impl;

import cc.mrbird.febs.ai.entity.AiMemberRoleCategory;
import cc.mrbird.febs.ai.mapper.AiMemberRoleCategoryMapper;
import cc.mrbird.febs.ai.service.AiMemberRoleCategoryService;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * AI用户选择角色关联产品分类 Service实现类
 *
 * @author yourname
 * @date 2025-07-29
 */
@Slf4j
@Service
@RequiredArgsConstructor
public class AiMemberRoleCategoryServiceImpl extends ServiceImpl<AiMemberRoleCategoryMapper, AiMemberRoleCategory> implements AiMemberRoleCategoryService {

    private final AiMemberRoleCategoryMapper aiMemberRoleCategoryMapper;

    @Override
    public AiMemberRoleCategory getById(String id) {
        return this.getById(id);
    }

    @Override
    public List<AiMemberRoleCategory> getByRoleId(String roleId) {
        LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(AiMemberRoleCategory::getRoleId, roleId);
        return this.list(queryWrapper);
    }

    @Override
    public List<AiMemberRoleCategory> getByProductCategoryId(String productCategoryId) {
        LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(AiMemberRoleCategory::getProductCategoryId, productCategoryId);
        return this.list(queryWrapper);
    }

    @Override
    public List<AiMemberRoleCategory> getByCompanyId(String companyId) {
        LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(AiMemberRoleCategory::getCompanyId, companyId);
        return this.list(queryWrapper);
    }

    @Override
    public List<AiMemberRoleCategory> getByRoleIdAndProductCategoryId(String roleId, String productCategoryId) {
        LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(AiMemberRoleCategory::getRoleId, roleId);
        queryWrapper.eq(AiMemberRoleCategory::getProductCategoryId, productCategoryId);
        return this.list(queryWrapper);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean saveRoleCategory(AiMemberRoleCategory aiMemberRoleCategory) {
        try {
            return this.save(aiMemberRoleCategory);
        } catch (Exception e) {
            log.error("保存角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean saveBatchRoleCategories(List<AiMemberRoleCategory> roleCategories) {
        try {
            return this.saveBatch(roleCategories);
        } catch (Exception e) {
            log.error("批量保存角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean updateRoleCategory(AiMemberRoleCategory aiMemberRoleCategory) {
        try {
            return this.updateById(aiMemberRoleCategory);
        } catch (Exception e) {
            log.error("更新角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean deleteById(String id) {
        try {
            return this.removeById(id);
        } catch (Exception e) {
            log.error("删除角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean deleteByRoleId(String roleId) {
        try {
            LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.eq(AiMemberRoleCategory::getRoleId, roleId);
            return this.remove(queryWrapper);
        } catch (Exception e) {
            log.error("根据角色ID删除角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean deleteByProductCategoryId(String productCategoryId) {
        try {
            LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.eq(AiMemberRoleCategory::getProductCategoryId, productCategoryId);
            return this.remove(queryWrapper);
        } catch (Exception e) {
            log.error("根据产品分类ID删除角色产品分类关联记录失败: ", e);
            return false;
        }
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean deleteByRoleIdAndProductCategoryId(String roleId, String productCategoryId) {
        try {
            LambdaQueryWrapper<AiMemberRoleCategory> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.eq(AiMemberRoleCategory::getRoleId, roleId);
            queryWrapper.eq(AiMemberRoleCategory::getProductCategoryId, productCategoryId);
            return this.remove(queryWrapper);
        } catch (Exception e) {
            log.error("根据角色ID和产品分类ID删除角色产品分类关联记录失败: ", e);
            return false;
        }
    }
}