package com.doumee.service.business.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.doumee.core.constants.Constants;
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.Utils;
import com.doumee.dao.business.SeoMapper;
import com.doumee.dao.business.model.Carousel;
import com.doumee.dao.business.model.Seo;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.service.business.SeoService;
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 com.github.yulichang.query.MPJQueryWrapper;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
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.util.CollectionUtils;

import java.util.Date;
import java.util.List;
import java.util.Objects;

/**
 * 网站SEO配置Service实现
 * @author 江蹄蹄
 * @since 2025/07/02 11:35
 */
@Service
public class SeoServiceImpl implements SeoService {

    @Autowired
    private SeoMapper seoMapper;

    @Override
    public Integer create(Seo seo) {
        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
        if(Objects.isNull(seo)
                || Objects.isNull(seo.getPageAddr())
                || Objects.isNull(seo.getName())
        ){
            throw new BusinessException(ResponseStatus.BAD_REQUEST);
        }
        if(seoMapper.selectCount(new LambdaQueryWrapper<Seo>().eq(Seo::getIsdeleted,Constants.ZERO)
                .eq(Seo::getPageAddr,seo.getPageAddr())) >0 ){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"该页面地址已配置，请勿重复配置！");
        }
        seo.setIsdeleted(Constants.ZERO);
        seo.setCreateDate(new Date());
        seo.setCreator(user.getId());
        seo.setEditDate(new Date());
        seo.setEditor(user.getId());
        seoMapper.insert(seo);
        return seo.getId();
    }

    @Override
    public void deleteById(Integer id) {
        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
        seoMapper.update(new UpdateWrapper<Seo>().lambda()
                .set(Seo::getEditDate,new Date())
                .set(Seo::getEditor,user.getId())
                .set(Seo::getIsdeleted,Constants.ONE)
                .eq(Seo::getId,id));
    }

    @Override
    public void delete(Seo seo) {
        UpdateWrapper<Seo> deleteWrapper = new UpdateWrapper<>(seo);
        seoMapper.delete(deleteWrapper);
    }

    @Override
    public void deleteByIdInBatch(List<Integer> ids) {
        if (CollectionUtils.isEmpty(ids)) {
            return;
        }
        for(Integer id :ids){
            this.deleteById(id);
        }
    }

    @Override
    public void updateById(Seo seo) {
        LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
        if(StringUtils.isNotBlank(seo.getPageAddr()) &&
                seoMapper.selectCount(new LambdaQueryWrapper<Seo>().eq(Seo::getIsdeleted,Constants.ZERO)
                .eq(Seo::getPageAddr,seo.getPageAddr()).ne(Seo::getId,seo.getId())) >0 ){
            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"该页面地址已配置，请勿重复配置！");
        }
        seo.setIsdeleted(Constants.ZERO);
        seo.setEditDate(new Date());
        seo.setEditor(user.getId());
        seoMapper.updateById(seo);
    }

    @Override
    public void updateByIdInBatch(List<Seo> seos) {
        if (CollectionUtils.isEmpty(seos)) {
            return;
        }
        for (Seo seo: seos) {
            this.updateById(seo);
        }
    }

    @Override
    public Seo findById(Integer id) {
        return seoMapper.selectById(id);
    }

    @Override
    public Seo findOne(Seo seo) {
        QueryWrapper<Seo> wrapper = new QueryWrapper<>(seo);
        return seoMapper.selectOne(wrapper);
    }

    @Override
    public List<Seo> findList(Seo seo) {
        seo.setIsdeleted(Constants.ZERO);
        QueryWrapper<Seo> wrapper = new QueryWrapper<>(seo);
        return seoMapper.selectList(wrapper);
    }
  
    @Override
    public PageData<Seo> findPage(PageWrap<Seo> pageWrap) {
        IPage<Seo> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<Seo> queryWrapper = new MPJLambdaWrapper<Seo>();
        Utils.MP.blankToNull(pageWrap.getModel());
        pageWrap.getModel().setIsdeleted(Constants.ZERO);
        queryWrapper.selectAll(Seo.class )
                .selectAs(SystemUser::getUsername,Seo::getEditorName)
                .leftJoin(SystemUser.class,SystemUser::getId,Seo::getEditor)
                .eq(pageWrap.getModel().getId() != null, Seo::getId, pageWrap.getModel().getId())
                .eq(pageWrap.getModel().getCreator() != null, Seo::getCreator, pageWrap.getModel().getCreator())
                .ge(pageWrap.getModel().getCreateDate() != null, Seo::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()))
                .le(pageWrap.getModel().getCreateDate() != null, Seo::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()))
                .eq(pageWrap.getModel().getEditor() != null, Seo::getEditor, pageWrap.getModel().getEditor())
                .ge(pageWrap.getModel().getEditDate() != null, Seo::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()))
                .le(pageWrap.getModel().getEditDate() != null, Seo::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()))
                .eq(pageWrap.getModel().getIsdeleted() != null, Seo::getIsdeleted, pageWrap.getModel().getIsdeleted())
                .eq(pageWrap.getModel().getRemark() != null, Seo::getRemark, pageWrap.getModel().getRemark())
                .like(pageWrap.getModel().getName() != null, Seo::getName, pageWrap.getModel().getName())
                .notLike(pageWrap.getModel().getType() != null && pageWrap.getModel().getType() ==0, Seo::getPageAddr, "Mobile.html")
                .like(pageWrap.getModel().getType() != null && pageWrap.getModel().getType() ==1, Seo::getPageAddr, "Mobile.html")
                .like(pageWrap.getModel().getTitle() != null, Seo::getTitle, pageWrap.getModel().getTitle())
                .like(pageWrap.getModel().getKeywords() != null, Seo::getKeywords, pageWrap.getModel().getKeywords())
                .like(pageWrap.getModel().getAuthor() != null, Seo::getAuthor, pageWrap.getModel().getAuthor())
                .eq(pageWrap.getModel().getIcon() != null, Seo::getIcon, pageWrap.getModel().getIcon())
                .like(pageWrap.getModel().getImgalt() != null, Seo::getImgalt, pageWrap.getModel().getImgalt())
                .like(pageWrap.getModel().getPageAddr() != null, Seo::getPageAddr, pageWrap.getModel().getPageAddr())
                .eq(pageWrap.getModel().getSortnum() != null, Seo::getSortnum, pageWrap.getModel().getSortnum())
                  .orderByAsc(Seo::getSortnum);

        return PageData.from(seoMapper.selectPage(page, queryWrapper));
    }

    @Override
    public long count(Seo seo) {
        QueryWrapper<Seo> wrapper = new QueryWrapper<>(seo);
        return seoMapper.selectCount(wrapper);
    }
}