package com.doumee.service.business.impl;

import com.doumee.biz.system.SystemDictDataBiz;
import com.doumee.core.constants.ResponseStatus;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.LoginUserInfo;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Constants;
import com.doumee.core.utils.PinYinUtil;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.BaseCateParamMapper;
import com.doumee.dao.business.BaseCategoryMapper;
import com.doumee.dao.business.model.BaseCateParam;
import com.doumee.dao.business.model.BaseCategory;
import com.doumee.dao.business.model.dto.BaseCategoryRequest;
import com.doumee.service.business.BaseCateParamService;
import com.doumee.service.business.BaseCategoryService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.commons.lang3.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.util.stream.Collectors;

/**
 * 素材库-品类信息表Service实现
 * @author 江蹄蹄
 * @date 2023/09/07 11:41
 */
@Service
public class BaseCategoryServiceImpl implements BaseCategoryService {

    @Autowired
    private BaseCategoryMapper baseCategoryMapper;

    @Autowired
    private BaseCateParamMapper baseCateParamMapper;

    @Autowired
    private SystemDictDataBiz systemDictDataBiz;

    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
    @Override
    public Integer create(BaseCategoryRequest baseCategory) {
        LoginUserInfo loginUserInfo = (LoginUserInfo)SecurityUtils.getSubject().getPrincipal();
        QueryWrapper<BaseCategory> wrapper = new QueryWrapper<>();
        wrapper.lambda().eq(BaseCategory::getName,baseCategory.getName())
                        .eq(BaseCategory::getIsdeleted,Constants.ZERO);

        BaseCategory baseCategory1 = baseCategoryMapper.selectOne(wrapper);
        if (Objects.nonNull(baseCategory1)){
            throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"品类信息已存在");
        }
        BaseCategory baseCategory2 = new BaseCategory();
        baseCategory2.setCreator(loginUserInfo.getId());
        baseCategory2.setCreateDate(new Date());
        baseCategory2.setEditor(loginUserInfo.getId());
        baseCategory2.setEditDate(new Date());
        baseCategory2.setIsdeleted(Constants.ZERO);
        baseCategory2.setName(baseCategory.getName());
        baseCategory2.setRemark(baseCategory.getRemark());
        baseCategory2.setStatus(baseCategory.getStatus());
        baseCategory2.setSortnum(baseCategory.getSortnum());
        baseCategory2.setImgurl(baseCategory.getImgurl());
        baseCategory2.setPinyin(PinYinUtil.getFullSpell(baseCategory.getName()));
        baseCategory2.setShortPinyin(PinYinUtil.getFirstSpell(baseCategory.getName()));
        baseCategory2.setPriceRate(baseCategory.getPriceRate());
        baseCategoryMapper.insert(baseCategory2);

        if (!CollectionUtils.isEmpty(baseCategory.getBaseCateParamList())){

            long count = baseCategory.getBaseCateParamList().stream().map(s -> s.getName().trim()).distinct().count();

            if (baseCategory.getBaseCateParamList().size() != count){
                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"属性存在重复");
            }
            baseCategory.getBaseCateParamList().forEach(s->{
                BaseCateParam baseCateParam = new BaseCateParam();
                baseCateParam.setCreator(loginUserInfo.getId());
                baseCateParam.setCreateDate(new Date());
                baseCateParam.setEditor(loginUserInfo.getId());
                baseCateParam.setEditDate(new Date());
                baseCateParam.setIsdeleted(Constants.ZERO);
                baseCateParam.setName(s.getName());
                baseCateParam.setRemark(s.getRemark());
                baseCateParam.setStatus(s.getStatus());
                baseCateParam.setSortnum(s.getSortnum());
                baseCateParam.setCategoryId(baseCategory2.getId());
                baseCateParamMapper.insert(baseCateParam);
            });
        }
        return baseCategory2.getId();
    }

    @Override
    public void deleteById(Integer id) {
        baseCategoryMapper.deleteById(id);
    }

    @Override
    public void delete(BaseCategory baseCategory) {
        UpdateWrapper<BaseCategory> deleteWrapper = new UpdateWrapper<>(baseCategory);
        baseCategoryMapper.delete(deleteWrapper);
    }

    @Override
    public void deleteByIdInBatch(List<Integer> ids) {
        if (CollectionUtils.isEmpty(ids)) {
            return;
        }
        baseCategoryMapper.deleteBatchIds(ids);
    }

    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
    @Override
    public void update(BaseCategoryRequest baseCategory) {

        LoginUserInfo loginUserInfo = (LoginUserInfo)SecurityUtils.getSubject().getPrincipal();

        if (Objects.isNull(baseCategory.getId())
                || Objects.isNull(baseCategory.getName())){
            throw new BusinessException(ResponseStatus.BAD_REQUEST);
        }

        QueryWrapper<BaseCategory> wrapper = new QueryWrapper<>();
        wrapper.lambda().eq(BaseCategory::getName,baseCategory.getName())
                .eq(BaseCategory::getIsdeleted,Constants.ZERO);

        BaseCategory baseCategory1 = baseCategoryMapper.selectOne(wrapper);
        if (Objects.nonNull(baseCategory1) && (!baseCategory1.getId().equals(baseCategory.getId()))){
            throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"品类信息表");
        }
        if(baseCategory.getPriceRate() == null){
            baseCategory.setPriceRate(new BigDecimal(1.2));
        }

        UpdateWrapper<BaseCategory> updateWrapper = new UpdateWrapper<>();
        updateWrapper.lambda()
                .eq(BaseCategory::getId,baseCategory.getId())
                .set(BaseCategory::getName,baseCategory.getName())
                .set(BaseCategory::getPinyin,PinYinUtil.getFullSpell(baseCategory.getName()))
                .set(BaseCategory::getShortPinyin,PinYinUtil.getFirstSpell(baseCategory.getName()))
                .set(BaseCategory::getImgurl,baseCategory.getImgurl())
                .set(BaseCategory::getPriceRate,baseCategory.getPriceRate())
                .set(BaseCategory::getSortnum,baseCategory.getSortnum());

        baseCategoryMapper.update(null,updateWrapper);

        if (!CollectionUtils.isEmpty(baseCategory.getBaseCateParamList())){

            long count = baseCategory.getBaseCateParamList().stream().map(s -> s.getName().trim()).distinct().count();
            if (baseCategory.getBaseCateParamList().size() != count){
                throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"属性存在重复");
            }
            List<Integer> ids = new ArrayList<>();
            baseCategory.getBaseCateParamList().forEach(s->{
                if(s.getId() !=null){
                    ids. add(s.getId());
                }
            });
            QueryWrapper<BaseCateParam> baseCateParamQuery = new QueryWrapper<>();
            baseCateParamQuery.lambda()
                                .eq(BaseCateParam::getCategoryId,baseCategory.getId());
            baseCateParamQuery.lambda()
                                .notIn(ids!=null && ids.size()>0,BaseCateParam::getId,ids);
            //刪除逻辑
            baseCateParamMapper.delete(baseCateParamQuery);
            baseCategory.getBaseCateParamList().forEach(s->{
                BaseCateParam baseCateParam = new BaseCateParam();
                baseCateParam.setIsdeleted(Constants.ZERO);
                baseCateParam.setName(s.getName());
                baseCateParam.setRemark(s.getRemark());
                baseCateParam.setStatus(s.getStatus());
                baseCateParam.setSortnum(s.getSortnum());
                baseCateParam.setCategoryId(baseCategory.getId());
                if(s.getId() !=null ){
                    //更新数据
                    baseCateParam.setEditor(loginUserInfo.getId());
                    baseCateParam.setEditDate(new Date());
                    baseCateParam.setId(s.getId());
                    baseCateParamMapper.updateById(baseCateParam);
                }else{
                    //新增
                    baseCateParam.setCreator(loginUserInfo.getId());
                    baseCateParam.setCreateDate(new Date());
                    baseCateParamMapper.insert(baseCateParam);
                }
            });

        }

    }

    @Override
    public void updateById(BaseCategory baseCategory) {
        baseCategoryMapper.updateById(baseCategory);
    }
    @Override
    public void updateDisableById(BaseCategory baseCategory) {

        LoginUserInfo loginUserInfo = (LoginUserInfo)SecurityUtils.getSubject().getPrincipal();
        if(baseCategory.getId() == null || baseCategory.getStatus() == null){
            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
        }
        if(!Constants.equalsInteger(baseCategory.getStatus(), Constants.ONE)
                && !Constants.equalsInteger(baseCategory.getStatus(), Constants.ZERO)){
            throw  new BusinessException(ResponseStatus.BAD_REQUEST);
        }
        BaseCategory param= new BaseCategory();
        param.setId(baseCategory.getId());
        param.setEditDate(new Date());
        param.setEditor(loginUserInfo.getId());
        param.setId(baseCategory.getId());
        param.setStatus(baseCategory.getStatus());
        baseCategoryMapper.updateById(param);
    }

    @Override
    public void updateByIdInBatch(List<BaseCategory> baseCategorys) {
        if (CollectionUtils.isEmpty(baseCategorys)) {
            return;
        }
        for (BaseCategory baseCategory: baseCategorys) {
            this.updateById(baseCategory);
        }
    }

    @Override
    public BaseCategory findById(Integer id) {
        BaseCategory  model = baseCategoryMapper.selectById(id);
        if(StringUtils.isNotBlank(model.getImgurl())){
            model.setImgfullurl(
                    systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() +
                            systemDictDataBiz.queryByCode(Constants.OSS,Constants.CATEGORY_IMG).getCode() + model.getImgurl()
            );
        }
        return  model;
    }

    @Override
    public BaseCategory findOne(BaseCategory baseCategory) {
        QueryWrapper<BaseCategory> wrapper = new QueryWrapper<>(baseCategory);
        return baseCategoryMapper.selectOne(wrapper);
    }

    @Override
    public List<BaseCategory> findList(BaseCategory baseCategory) {
        QueryWrapper<BaseCategory> wrapper = new QueryWrapper<>(baseCategory);
        wrapper.eq("ISDELETED",Constants.ZERO);
        wrapper.eq("STATUS",Constants.ZERO);
        List<BaseCategory> list = baseCategoryMapper.selectList(wrapper);
        list.forEach(i->{
            if(StringUtils.isNotBlank(i.getImgurl())){
                i.setImgfullurl(
                        systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() +
                                systemDictDataBiz.queryByCode(Constants.OSS,Constants.CATEGORY_IMG).getCode() + i.getImgurl()
                );
            }
        });
        return list;
    }

    @Override
    public PageData<BaseCategory> findPage(PageWrap<BaseCategory> pageWrap) {
        IPage<BaseCategory> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        QueryWrapper<BaseCategory> queryWrapper = new QueryWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        if (pageWrap.getModel().getId() != null) {
            queryWrapper.lambda().eq(BaseCategory::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getCreator() != null) {
            queryWrapper.lambda().eq(BaseCategory::getCreator, pageWrap.getModel().getCreator());
        }
        if (pageWrap.getModel().getCreateDate() != null) {
            queryWrapper.lambda().ge(BaseCategory::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
            queryWrapper.lambda().le(BaseCategory::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
        }
        if (pageWrap.getModel().getEditor() != null) {
            queryWrapper.lambda().eq(BaseCategory::getEditor, pageWrap.getModel().getEditor());
        }
        if (pageWrap.getModel().getEditDate() != null) {
            queryWrapper.lambda().ge(BaseCategory::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
            queryWrapper.lambda().le(BaseCategory::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
        }
        if (pageWrap.getModel().getIsdeleted() != null) {
            queryWrapper.lambda().eq(BaseCategory::getIsdeleted, pageWrap.getModel().getIsdeleted());
        }
        if (pageWrap.getModel().getName() != null) {
            queryWrapper.lambda().like(BaseCategory::getName, pageWrap.getModel().getName());
        }
        if (pageWrap.getModel().getRemark() != null) {
            queryWrapper.lambda().eq(BaseCategory::getRemark, pageWrap.getModel().getRemark());
        }
        if (pageWrap.getModel().getAttrFirst() != null) {
            queryWrapper.lambda().eq(BaseCategory::getAttrFirst, pageWrap.getModel().getAttrFirst());
        }
        if (pageWrap.getModel().getAttrSecond() != null) {
            queryWrapper.lambda().eq(BaseCategory::getAttrSecond, pageWrap.getModel().getAttrSecond());
        }
        if (pageWrap.getModel().getStatus() != null) {
            queryWrapper.lambda().eq(BaseCategory::getStatus, pageWrap.getModel().getStatus());
        }
        if (pageWrap.getModel().getSortnum() != null) {
            queryWrapper.lambda().eq(BaseCategory::getSortnum, pageWrap.getModel().getSortnum());
        }
        if (pageWrap.getModel().getImgurl() != null) {
            queryWrapper.lambda().eq(BaseCategory::getImgurl, pageWrap.getModel().getImgurl());
        }
        if (pageWrap.getModel().getPinyin() != null) {
            queryWrapper.lambda().eq(BaseCategory::getPinyin, pageWrap.getModel().getPinyin());
        }
        if (pageWrap.getModel().getShortPinyin() != null) {
            queryWrapper.lambda().eq(BaseCategory::getShortPinyin, pageWrap.getModel().getShortPinyin());
        }
        queryWrapper.lambda().orderByAsc(BaseCategory::getSortnum);

        IPage<BaseCategory> baseCategoryIPage = baseCategoryMapper.selectPage(page, queryWrapper);
        String preUrl = getPreUrl();
        if (!CollectionUtils.isEmpty(baseCategoryIPage.getRecords())){
            baseCategoryIPage.getRecords().forEach(s->s.setImgfullurl(preUrl+s.getImgurl()));
        }

        return PageData.from(baseCategoryIPage);
    }

    @Override
    public long count(BaseCategory baseCategory) {
        QueryWrapper<BaseCategory> wrapper = new QueryWrapper<>(baseCategory);
        return baseCategoryMapper.selectCount(wrapper);
    }

    private String getPreUrl(){
        String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode()
                + systemDictDataBiz.queryByCode(Constants.OSS, Constants.CATEGORY_IMG).getCode();
        return prefixUrl;
    }
}