基于Vue3的likeadmin免费任意商用管理后台设计源码

package com.mdd.generator.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Assert; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.pagehelper.PageHelper; import com.mdd.common.core.PageResult; import com.mdd.common.entity.system.SystemAuthMenu; import com.mdd.common.exception.OperateException; import com.mdd.common.mapper.system.SystemAuthMenuMapper; import com.mdd.common.util.StringUtils; import com.mdd.common.util.TimeUtils; import com.mdd.generator.constant.GenConstants; import com.mdd.generator.entity.GenTable; import com.mdd.generator.entity.GenTableColumn; import com.mdd.generator.mapper.GenTableColumnMapper; import com.mdd.generator.mapper.GenTableMapper; import com.mdd.generator.service.IGenerateService; import com.mdd.generator.util.GenUtil; import com.mdd.generator.util.VelocityUtil; import com.mdd.generator.validate.GenParam; import com.mdd.generator.validate.PageParam; import com.mdd.generator.vo.DbColumnVo; import com.mdd.generator.vo.DbTableVo; import com.mdd.generator.vo.GenColumnVo; import com.mdd.generator.vo.GenTableVo; import org.apache.commons.io.FileUtils; import org.apache.commons.io.IOUtils; import org.apache.velocity.Template; import org.apache.velocity.VelocityContext; import org.apache.velocity.app.Velocity; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.BeanUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.IOException; import java.io.StringWriter; import java.util.*; import java.util.function.Function; import java.util.stream.Collectors; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; /** * 代码生成器服务实现类 */ @Service public class GenerateServiceImpl implements IGenerateService { private static final Logger log = LoggerFactory.getLogger(GenerateServiceImpl.class); @Resource GenTableMapper genTableMapper; @Resource GenTableColumnMapper genTableColumnMapper; @Resource SystemAuthMenuMapper systemAuthMenuMapper; /** * 库列表 * * @author fzr * @param pageParam 分页参数 * @param params 搜索参数 * @return PageResult<Map<String, String>> */ @Override public PageResult<DbTableVo> db(PageParam pageParam, Map<String, String> params) { Integer page = pageParam.getPageNo(); Integer limit = pageParam.getPageSize(); PageHelper.startPage(page, limit); List<DbTableVo> tables = genTableMapper.selectDbTableList(params); for (DbTableVo vo : tables) { if (vo.getUpdateTime() == null) { vo.setUpdateTime(""); } } return PageResult.pageHelper(tables); } /** * 库列表 * * @author fzr * @param params 搜索参数 * @return PageResult<Map<String, String>> */ @Override public List<DbTableVo> dbAll(Map<String, String> params) { List<DbTableVo> tables = genTableMapper.selectDbTableAllList(params); for (DbTableVo vo : tables) { if (vo.getUpdateTime() == null) { vo.setUpdateTime(""); } } return tables; } /** * 根据表名查字段 * * @param tableName 表名 * @return List<DbColumnVo> */ @Override public List<DbColumnVo> dbColumn(String tableName) { List<GenTableColumn> columns = genTableMapper.selectDbTableColumnsByName(tableName); List<DbColumnVo> list = new LinkedList<>(); for (GenTableColumn col : columns) { DbColumnVo vo = new DbColumnVo(); vo.setColumnName(col.getColumnName()); vo.setColumnType(col.getColumnType()); vo.setColumnComment(col.getColumnComment()); list.add(vo); } return list; } /** * 生成列表 * * @param pageParam 分页参数 * @param params 搜索参数 * @return PageResult<Map<String, Object>> */ @Override public PageResult<GenTableVo> list(PageParam pageParam, Map<String, String> params) { Integer page = pageParam.getPageNo(); Integer limit = pageParam.getPageSize(); QueryWrapper<GenTable> queryWrapper = new QueryWrapper<>(); queryWrapper.orderByDesc("id"); queryWrapper.select("id,gen_type,table_name,table_comment,create_time,update_time"); genTableMapper.setSearch(queryWrapper, params, new String[]{ "like:tableName@table_name:str", "like:tableComment@table_comment:str", "datetime:startTime-endTime@create_time:str" }); IPage<GenTable> iPage = genTableMapper.selectPage(new Page<>(page, limit), queryWrapper); List<GenTableVo> list = new LinkedList<>(); for (GenTable item : iPage.getRecords()) { GenTableVo vo = new GenTableVo(); BeanUtils.copyProperties(item, vo); vo.setCreateTime(TimeUtils.timestampToDate(item.getCreateTime())); vo.setUpdateTime(TimeUtils.timestampToDate(item.getUpdateTime())); list.add(vo); } return PageResult.iPageHandle(iPage.getTotal(), iPage.getCurrent(), iPage.getSize(), list); } /** * 生成详情 * * @author fzr * @return Object */ @Override public Map<String, Object> detail(Integer id) { Map<String, Object> maps = new LinkedHashMap<>(); GenTable genTable = genTableMapper.selectById(id); Assert.notNull(genTable, "查询的数据不存在"); // 基本信息 Map<String, Object> base = new LinkedHashMap<>(); base.put("id", genTable.getId()); base.put("tableName", genTable.getTableName()); base.put("tableComment", genTable.getTableComment()); base.put("entityName", genTable.getEntityName()); base.put("authorName", genTable.getAuthorName()); base.put("remarks", genTable.getRemarks()); base.put("createTime", TimeUtils.timestampToDate(genTable.getCreateTime())); base.put("updateTime", TimeUtils.timestampToDate(genTable.getUpdateTime())); maps.put("base", base); // 生成信息 Map<String, Object> gen = new LinkedHashMap<>(); gen.put("genTpl", genTable.getGenTpl()); gen.put("genType", genTable.getGenType()); gen.put("genPath", genTable.getGenPath()); gen.put("moduleName", genTable.getModuleName()); gen.put("functionName", genTable.getFunctionName()); gen.put("treePrimary", genTable.getTreePrimary()); gen.put("treeParent", genTable.getTreeParent()); gen.put("treeName", genTable.getTreeName()); gen.put("subTableName", genTable.getSubTableName()); gen.put("subTableFk", genTable.getSubTableFk()); gen.put("subTableFr", genTable.getSubTableFr()); gen.put("menuStatus", genTable.getMenuStatus()); gen.put("menuPid", genTable.getMenuPid()); gen.put("menuName", genTable.getMenuName()); maps.put("gen", gen); // 字段信息 QueryWrapper<GenTableColumn> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("table_id", id); queryWrapper.orderByAsc("sort"); List<GenColumnVo> columns = new LinkedList<>(); for (GenTableColumn item : genTableColumnMapper.selectList(queryWrapper)) { GenColumnVo vo = new GenColumnVo(); BeanUtils.copyProperties(item, vo); vo.setCreateTime(TimeUtils.timestampToDate(item.getCreateTime())); vo.setUpdateTime(TimeUtils.timestampToDate(item.getUpdateTime())); columns.add(vo); }