package jnpf.base.mapper;


import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import jnpf.base.entity.CommonWordsEntity;
import jnpf.util.StringUtil;
import jnpf.util.UserProvider;

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

/**
 * 审批常用语
 *
 * @author JNPF开发平台组 YanYu
 * @version v3.4.6
 * @copyrignt 引迈信息技术有限公司
 * @date 2023-01-06
 */
public interface CommonWordsMapper extends SuperMapper<CommonWordsEntity> {

    default List<CommonWordsEntity> getListModel(String type) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().eq(CommonWordsEntity::getEnabledMark, 1)
                .and(t ->
                        t.and(t2 -> t2.eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId()).or().eq(CommonWordsEntity::getCommonWordsType, 0))
                );
        // 排序
        query.lambda()
                .orderByDesc(CommonWordsEntity::getCommonWordsType)
                .orderByDesc(CommonWordsEntity::getUsesNum)
                .orderByAsc(CommonWordsEntity::getSortCode)
                .orderByDesc(CommonWordsEntity::getCreatorTime);
        return this.selectList(query);
    }

    default Boolean existSystem(String systemId) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().like(CommonWordsEntity::getSystemIds, systemId);
        return selectCount(query) > 0;
    }

    default Boolean existCommonWord(String id, String commonWordsText, Integer commonWordsType) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        if (StringUtil.isNotEmpty(id)) {
            query.lambda().ne(CommonWordsEntity::getId, id);
        }
        if (ObjectUtil.isNotEmpty(commonWordsType)) {
            if (Objects.equals(commonWordsType, 1)) {
                query.lambda().and(t ->
                        t.eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId()).or().eq(CommonWordsEntity::getCommonWordsType, 0)
                );
            } else {
                query.lambda().eq(CommonWordsEntity::getCommonWordsType, commonWordsType);
            }
        }
        query.lambda().eq(CommonWordsEntity::getCommonWordsText, commonWordsText);
        return selectCount(query) > 0;
    }

    default void addCommonWordsNum(String commonWordsText) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().eq(CommonWordsEntity::getCommonWordsText, commonWordsText);
        query.lambda().eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId());
        query.lambda().eq(CommonWordsEntity::getCommonWordsType, 1);
        List<CommonWordsEntity> list = selectList(query);
        if (list.size() > 0) {
            for (CommonWordsEntity item : list) {
                long num = item.getUsesNum() == null ? 0 : item.getUsesNum();
                item.setUsesNum(num + 1);
                this.updateById(item);
            }
        }
    }
}