package jnpf.base.mapper;
|
|
|
import cn.hutool.core.util.ObjectUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import jnpf.base.entity.VisualdevEntity;
|
import jnpf.base.model.PaginationVisualdev;
|
import jnpf.util.JsonUtil;
|
import jnpf.util.StringUtil;
|
|
import java.util.Arrays;
|
import java.util.List;
|
import java.util.Objects;
|
|
/**
|
* @author JNPF开发平台组
|
* @version V3.1.0
|
* @copyright 引迈信息技术有限公司（https://www.jnpfsoft.com）
|
* @date 2021/3/16
|
*/
|
public interface VisualdevMapper extends SuperMapper<VisualdevEntity> {
|
|
default List<VisualdevEntity> getList(PaginationVisualdev paginationVisualdev) {
|
// 定义变量判断是否需要使用修改时间倒序
|
boolean flag = false;
|
QueryWrapper<VisualdevEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().select(VisualdevEntity::getId, VisualdevEntity::getCategory, VisualdevEntity::getEnCode, VisualdevEntity::getFullName,
|
VisualdevEntity::getCreatorTime, VisualdevEntity::getCreatorUserId, VisualdevEntity::getLastModifyTime, VisualdevEntity::getLastModifyUserId,
|
VisualdevEntity::getEnabledMark, VisualdevEntity::getSortCode, VisualdevEntity::getState, VisualdevEntity::getType, VisualdevEntity::getEnableFlow,
|
VisualdevEntity::getWebType, VisualdevEntity::getVisualTables, VisualdevEntity::getPlatformRelease);
|
|
if (!StringUtil.isEmpty(paginationVisualdev.getKeyword())) {
|
flag = true;
|
queryWrapper.lambda().and(t -> t.like(VisualdevEntity::getFullName, paginationVisualdev.getKeyword())
|
.or().like(VisualdevEntity::getEnCode, paginationVisualdev.getKeyword()));
|
}
|
|
if (ObjectUtil.isNotEmpty(paginationVisualdev.getType())) {
|
queryWrapper.lambda().eq(VisualdevEntity::getType, paginationVisualdev.getType());
|
}
|
|
if (StringUtil.isNotEmpty(paginationVisualdev.getCategory())) {
|
flag = true;
|
queryWrapper.lambda().eq(VisualdevEntity::getCategory, paginationVisualdev.getCategory());
|
}
|
|
//---功能类型查询
|
if (paginationVisualdev.getWebType() != null) {//普通表单
|
flag = true;
|
//2-表单：改成查询纯表单和列表
|
if (Objects.equals(paginationVisualdev.getWebType(), 2)) {
|
queryWrapper.lambda().in(VisualdevEntity::getWebType, Arrays.asList(1, 2));
|
} else {
|
queryWrapper.lambda().eq(VisualdevEntity::getWebType, paginationVisualdev.getWebType());
|
}
|
}
|
if (StringUtil.isNotEmpty(paginationVisualdev.getSystemId())) {//普通表单
|
queryWrapper.lambda().eq(VisualdevEntity::getSystemId, paginationVisualdev.getSystemId());
|
}
|
|
//状态
|
if (StringUtil.isNotEmpty(paginationVisualdev.getIsRelease())) {
|
flag = true;
|
List<String> releaseList = Arrays.asList(paginationVisualdev.getIsRelease().split(","));
|
if (releaseList.size() > 1) {
|
List<Integer> jsonToList = JsonUtil.getJsonToList(releaseList, Integer.class);
|
queryWrapper.lambda().in(VisualdevEntity::getState, jsonToList);
|
} else if (releaseList.size() == 1) {
|
queryWrapper.lambda().eq(VisualdevEntity::getState, paginationVisualdev.getIsRelease());
|
}
|
|
}
|
|
// 排序
|
queryWrapper.lambda().orderByAsc(VisualdevEntity::getSortCode).orderByDesc(VisualdevEntity::getCreatorTime);
|
if (flag) {
|
queryWrapper.lambda().orderByDesc(VisualdevEntity::getLastModifyTime);
|
}
|
Page<VisualdevEntity> page = new Page<>(paginationVisualdev.getCurrentPage(), paginationVisualdev.getPageSize());
|
IPage<VisualdevEntity> userPage = this.selectPage(page, queryWrapper);
|
return paginationVisualdev.setData(userPage.getRecords(), page.getTotal());
|
}
|
|
default List<VisualdevEntity> getList() {
|
QueryWrapper<VisualdevEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().orderByAsc(VisualdevEntity::getSortCode).orderByDesc(VisualdevEntity::getCreatorTime);
|
return this.selectList(queryWrapper);
|
}
|
|
default VisualdevEntity getInfo(String id) {
|
if (StringUtil.isBlank(id)) return null;
|
QueryWrapper<VisualdevEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().eq(VisualdevEntity::getId, id);
|
return this.selectOne(queryWrapper);
|
}
|
|
default Boolean getObjByEncode(String encode, Integer type) {
|
if (StringUtil.isEmpty(encode)) return false;
|
QueryWrapper<VisualdevEntity> visualWrapper = new QueryWrapper<>();
|
visualWrapper.lambda().eq(VisualdevEntity::getEnCode, encode).eq(VisualdevEntity::getType, type);
|
return this.selectCount(visualWrapper) > 0;
|
}
|
|
|
default Boolean getCountByName(String name, Integer type, String systemId) {
|
QueryWrapper<VisualdevEntity> visualWrapper = new QueryWrapper<>();
|
visualWrapper.lambda().eq(VisualdevEntity::getFullName, name).eq(VisualdevEntity::getType, type);
|
if (StringUtil.isNotEmpty(systemId)) {
|
visualWrapper.lambda().eq(VisualdevEntity::getSystemId, systemId);
|
}
|
return this.selectCount(visualWrapper) > 0;
|
}
|
|
|
default List<VisualdevEntity> selectorList(String systemId) {
|
QueryWrapper<VisualdevEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().select(
|
VisualdevEntity::getId,
|
VisualdevEntity::getFullName,
|
VisualdevEntity::getWebType,
|
VisualdevEntity::getType,
|
VisualdevEntity::getSystemId,
|
VisualdevEntity::getCategory);
|
if (StringUtil.isNotEmpty(systemId)) {
|
queryWrapper.lambda().eq(VisualdevEntity::getSystemId, systemId);
|
}
|
return this.selectList(queryWrapper);
|
}
|
|
|
}
|
