From 3ef6abbd7a73bd464bfb24fd99f7f9956f2562ef Mon Sep 17 00:00:00 2001 From: yanzhaofeige <yanzhaofeige@qq.com> Date: Wed, 09 Oct 2024 22:55:39 +0800 Subject: [PATCH] 草稿箱 --- /dev/null | 7 cpzidc-ui/src/api/bis/drafts.js | 44 ++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcDraftsMapper.java | 61 +++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcDraftsServiceImpl.java | 96 ++++ cpzidc-admin/pom.xml | 6 cpzidc-bis/pom.xml | 6 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcDraftsService.java | 61 +++ cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcDraftsController.java | 104 +++++ cpzidc-ui/src/views/login.vue | 2 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcDrafts.java | 250 ++++++++++++ cpzidc-bis/src/main/resources/mapper/bis/IdcDraftsMapper.xml | 138 ++++++ cpzidc-ui/src/views/bis/drafts/index.vue | 368 ++++++++++++++++++ 12 files changed, 1,135 insertions(+), 8 deletions(-) diff --git a/cpzidc-admin/pom.xml b/cpzidc-admin/pom.xml index f9fbefc..d19bf17 100644 --- a/cpzidc-admin/pom.xml +++ b/cpzidc-admin/pom.xml @@ -73,6 +73,12 @@ <version>2.7.6</version> <scope>test</scope> </dependency> + <dependency> + <groupId>com.odcc.cpzidc</groupId> + <artifactId>cpzidc-bis</artifactId> + <version>3.8.8</version> + <scope>compile</scope> + </dependency> </dependencies> diff --git a/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcDraftsController.java b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcDraftsController.java new file mode 100644 index 0000000..d3e02a2 --- /dev/null +++ b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcDraftsController.java @@ -0,0 +1,104 @@ +package com.odcc.cpzidc.web.controller.bis; + +import java.util.List; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.odcc.cpzidc.common.annotation.Log; +import com.odcc.cpzidc.common.core.controller.BaseController; +import com.odcc.cpzidc.common.core.domain.AjaxResult; +import com.odcc.cpzidc.common.enums.BusinessType; +import com.odcc.cpzidc.bis.domain.IdcDrafts; +import com.odcc.cpzidc.bis.service.IIdcDraftsService; +import com.odcc.cpzidc.common.utils.poi.ExcelUtil; +import com.odcc.cpzidc.common.core.page.TableDataInfo; + +/** + * 草稿箱Controller + * + * @author ruoyi + * @date 2024-10-09 + */ +@RestController +@RequestMapping("/bis/drafts") +public class IdcDraftsController extends BaseController +{ + @Autowired + private IIdcDraftsService idcDraftsService; + + /** + * 查询草稿箱列表 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:list')") + @GetMapping("/list") + public TableDataInfo list(IdcDrafts idcDrafts) + { + startPage(); + List<IdcDrafts> list = idcDraftsService.selectIdcDraftsList(idcDrafts); + return getDataTable(list); + } + + /** + * 导出草稿箱列表 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:export')") + @Log(title = "草稿箱", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IdcDrafts idcDrafts) + { + List<IdcDrafts> list = idcDraftsService.selectIdcDraftsList(idcDrafts); + ExcelUtil<IdcDrafts> util = new ExcelUtil<IdcDrafts>(IdcDrafts.class); + util.exportExcel(response, list, "草稿箱数据"); + } + + /** + * 获取草稿箱详细信息 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return success(idcDraftsService.selectIdcDraftsById(id)); + } + + /** + * 新增草稿箱 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:add')") + @Log(title = "草稿箱", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IdcDrafts idcDrafts) + { + return toAjax(idcDraftsService.insertIdcDrafts(idcDrafts)); + } + + /** + * 修改草稿箱 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:edit')") + @Log(title = "草稿箱", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IdcDrafts idcDrafts) + { + return toAjax(idcDraftsService.updateIdcDrafts(idcDrafts)); + } + + /** + * 删除草稿箱 + */ + @PreAuthorize("@ss.hasPermi('bis:drafts:remove')") + @Log(title = "草稿箱", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(idcDraftsService.deleteIdcDraftsByIds(ids)); + } +} diff --git a/cpzidc-bis/pom.xml b/cpzidc-bis/pom.xml index 329c01b..b808fd9 100644 --- a/cpzidc-bis/pom.xml +++ b/cpzidc-bis/pom.xml @@ -16,5 +16,11 @@ <maven.compiler.target>8</maven.compiler.target> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> + <dependencies> + <dependency> + <groupId>com.odcc.cpzidc</groupId> + <artifactId>cpzidc-common</artifactId> + </dependency> + </dependencies> </project> \ No newline at end of file diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/Main.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/Main.java deleted file mode 100644 index f01b4cc..0000000 --- a/cpzidc-bis/src/main/java/com/odcc/cpzidc/Main.java +++ /dev/null @@ -1,7 +0,0 @@ -package com.odcc.cpzidc; - -public class Main { - public static void main(String[] args) { - System.out.println("Hello world!"); - } -} \ No newline at end of file diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/Main.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/Main.java deleted file mode 100644 index 8397d02..0000000 --- a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/Main.java +++ /dev/null @@ -1,7 +0,0 @@ -package com.odcc.cpzidc.bis; - -public class Main { - public static void main(String[] args) { - System.out.println("Hello world!"); - } -} \ No newline at end of file diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcDrafts.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcDrafts.java new file mode 100644 index 0000000..15f34d7 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcDrafts.java @@ -0,0 +1,250 @@ +package com.odcc.cpzidc.bis.domain; + +import org.apache.commons.lang3.builder.ToStringBuilder; +import org.apache.commons.lang3.builder.ToStringStyle; +import com.odcc.cpzidc.common.annotation.Excel; +import com.odcc.cpzidc.common.core.domain.BaseEntity; + +/** + * 草稿箱对象 idc_drafts + * + * @author ruoyi + * @date 2024-10-09 + */ +public class IdcDrafts extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** 序号 */ + private Long id; + + /** 数据中心 ID */ + @Excel(name = "数据中心 ID") + private Long baseId; + + /** 日期节点 */ + @Excel(name = "日期节点") + private String dateNode; + + /** 暂存类型 */ + @Excel(name = "暂存类型") + private Long type; + + /** 在用基础信息 */ + @Excel(name = "在用基础信息") + private String idcUseBase; + + /** 在用绿色 */ + @Excel(name = "在用绿色") + private String idcUseGreen; + + /** 在用算力 */ + @Excel(name = "在用算力") + private String idcUseComputility; + + /** 在用基础设施 */ + @Excel(name = "在用基础设施") + private String idcUseInfrastructure; + + /** 在用存力指标 */ + @Excel(name = "在用存力指标") + private String idcUseStorage; + + /** 在用运力指标 */ + @Excel(name = "在用运力指标") + private String idcUseTransport; + + /** 在建基础 */ + @Excel(name = "在建基础") + private String idcBuildBase; + + /** 在建扩展 */ + @Excel(name = "在建扩展") + private String idcBuildExtend; + + /** 排序 */ + @Excel(name = "排序") + private Long sort; + + /** 状态 */ + @Excel(name = "状态") + private Integer state; + + /** 创建者 */ + @Excel(name = "创建者") + private Long createUser; + + /** 更新者 */ + @Excel(name = "更新者") + private Long updateUser; + + public void setId(Long id) + { + this.id = id; + } + + public Long getId() + { + return id; + } + public void setBaseId(Long baseId) + { + this.baseId = baseId; + } + + public Long getBaseId() + { + return baseId; + } + public void setDateNode(String dateNode) + { + this.dateNode = dateNode; + } + + public String getDateNode() + { + return dateNode; + } + public void setType(Long type) + { + this.type = type; + } + + public Long getType() + { + return type; + } + public void setIdcUseBase(String idcUseBase) + { + this.idcUseBase = idcUseBase; + } + + public String getIdcUseBase() + { + return idcUseBase; + } + public void setIdcUseGreen(String idcUseGreen) + { + this.idcUseGreen = idcUseGreen; + } + + public String getIdcUseGreen() + { + return idcUseGreen; + } + public void setIdcUseComputility(String idcUseComputility) + { + this.idcUseComputility = idcUseComputility; + } + + public String getIdcUseComputility() + { + return idcUseComputility; + } + public void setIdcUseInfrastructure(String idcUseInfrastructure) + { + this.idcUseInfrastructure = idcUseInfrastructure; + } + + public String getIdcUseInfrastructure() + { + return idcUseInfrastructure; + } + public void setIdcUseStorage(String idcUseStorage) + { + this.idcUseStorage = idcUseStorage; + } + + public String getIdcUseStorage() + { + return idcUseStorage; + } + public void setIdcUseTransport(String idcUseTransport) + { + this.idcUseTransport = idcUseTransport; + } + + public String getIdcUseTransport() + { + return idcUseTransport; + } + public void setIdcBuildBase(String idcBuildBase) + { + this.idcBuildBase = idcBuildBase; + } + + public String getIdcBuildBase() + { + return idcBuildBase; + } + public void setIdcBuildExtend(String idcBuildExtend) + { + this.idcBuildExtend = idcBuildExtend; + } + + public String getIdcBuildExtend() + { + return idcBuildExtend; + } + public void setSort(Long sort) + { + this.sort = sort; + } + + public Long getSort() + { + return sort; + } + public void setState(Integer state) + { + this.state = state; + } + + public Integer getState() + { + return state; + } + public void setCreateUser(Long createUser) + { + this.createUser = createUser; + } + + public Long getCreateUser() + { + return createUser; + } + public void setUpdateUser(Long updateUser) + { + this.updateUser = updateUser; + } + + public Long getUpdateUser() + { + return updateUser; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("id", getId()) + .append("baseId", getBaseId()) + .append("dateNode", getDateNode()) + .append("type", getType()) + .append("idcUseBase", getIdcUseBase()) + .append("idcUseGreen", getIdcUseGreen()) + .append("idcUseComputility", getIdcUseComputility()) + .append("idcUseInfrastructure", getIdcUseInfrastructure()) + .append("idcUseStorage", getIdcUseStorage()) + .append("idcUseTransport", getIdcUseTransport()) + .append("idcBuildBase", getIdcBuildBase()) + .append("idcBuildExtend", getIdcBuildExtend()) + .append("sort", getSort()) + .append("state", getState()) + .append("createTime", getCreateTime()) + .append("createUser", getCreateUser()) + .append("updateTime", getUpdateTime()) + .append("updateUser", getUpdateUser()) + .append("remark", getRemark()) + .toString(); + } +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcDraftsMapper.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcDraftsMapper.java new file mode 100644 index 0000000..f881af2 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcDraftsMapper.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.mapper; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcDrafts; + +/** + * 草稿箱Mapper接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IdcDraftsMapper +{ + /** + * 查询草稿箱 + * + * @param id 草稿箱主键 + * @return 草稿箱 + */ + public IdcDrafts selectIdcDraftsById(Long id); + + /** + * 查询草稿箱列表 + * + * @param idcDrafts 草稿箱 + * @return 草稿箱集合 + */ + public List<IdcDrafts> selectIdcDraftsList(IdcDrafts idcDrafts); + + /** + * 新增草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + public int insertIdcDrafts(IdcDrafts idcDrafts); + + /** + * 修改草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + public int updateIdcDrafts(IdcDrafts idcDrafts); + + /** + * 删除草稿箱 + * + * @param id 草稿箱主键 + * @return 结果 + */ + public int deleteIdcDraftsById(Long id); + + /** + * 批量删除草稿箱 + * + * @param ids 需要删除的数据主键集合 + * @return 结果 + */ + public int deleteIdcDraftsByIds(Long[] ids); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcDraftsService.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcDraftsService.java new file mode 100644 index 0000000..6df1b2d --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcDraftsService.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.service; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcDrafts; + +/** + * 草稿箱Service接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IIdcDraftsService +{ + /** + * 查询草稿箱 + * + * @param id 草稿箱主键 + * @return 草稿箱 + */ + public IdcDrafts selectIdcDraftsById(Long id); + + /** + * 查询草稿箱列表 + * + * @param idcDrafts 草稿箱 + * @return 草稿箱集合 + */ + public List<IdcDrafts> selectIdcDraftsList(IdcDrafts idcDrafts); + + /** + * 新增草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + public int insertIdcDrafts(IdcDrafts idcDrafts); + + /** + * 修改草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + public int updateIdcDrafts(IdcDrafts idcDrafts); + + /** + * 批量删除草稿箱 + * + * @param ids 需要删除的草稿箱主键集合 + * @return 结果 + */ + public int deleteIdcDraftsByIds(Long[] ids); + + /** + * 删除草稿箱信息 + * + * @param id 草稿箱主键 + * @return 结果 + */ + public int deleteIdcDraftsById(Long id); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcDraftsServiceImpl.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcDraftsServiceImpl.java new file mode 100644 index 0000000..2914380 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcDraftsServiceImpl.java @@ -0,0 +1,96 @@ +package com.odcc.cpzidc.bis.service.impl; + +import java.util.List; +import com.odcc.cpzidc.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.odcc.cpzidc.bis.mapper.IdcDraftsMapper; +import com.odcc.cpzidc.bis.domain.IdcDrafts; +import com.odcc.cpzidc.bis.service.IIdcDraftsService; + +/** + * 草稿箱Service业务层处理 + * + * @author ruoyi + * @date 2024-10-09 + */ +@Service +public class IdcDraftsServiceImpl implements IIdcDraftsService +{ + @Autowired + private IdcDraftsMapper idcDraftsMapper; + + /** + * 查询草稿箱 + * + * @param id 草稿箱主键 + * @return 草稿箱 + */ + @Override + public IdcDrafts selectIdcDraftsById(Long id) + { + return idcDraftsMapper.selectIdcDraftsById(id); + } + + /** + * 查询草稿箱列表 + * + * @param idcDrafts 草稿箱 + * @return 草稿箱 + */ + @Override + public List<IdcDrafts> selectIdcDraftsList(IdcDrafts idcDrafts) + { + return idcDraftsMapper.selectIdcDraftsList(idcDrafts); + } + + /** + * 新增草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + @Override + public int insertIdcDrafts(IdcDrafts idcDrafts) + { + idcDrafts.setCreateTime(DateUtils.getNowDate()); + return idcDraftsMapper.insertIdcDrafts(idcDrafts); + } + + /** + * 修改草稿箱 + * + * @param idcDrafts 草稿箱 + * @return 结果 + */ + @Override + public int updateIdcDrafts(IdcDrafts idcDrafts) + { + idcDrafts.setUpdateTime(DateUtils.getNowDate()); + return idcDraftsMapper.updateIdcDrafts(idcDrafts); + } + + /** + * 批量删除草稿箱 + * + * @param ids 需要删除的草稿箱主键 + * @return 结果 + */ + @Override + public int deleteIdcDraftsByIds(Long[] ids) + { + return idcDraftsMapper.deleteIdcDraftsByIds(ids); + } + + /** + * 删除草稿箱信息 + * + * @param id 草稿箱主键 + * @return 结果 + */ + @Override + public int deleteIdcDraftsById(Long id) + { + return idcDraftsMapper.deleteIdcDraftsById(id); + } +} diff --git a/cpzidc-bis/src/main/resources/mapper/bis/IdcDraftsMapper.xml b/cpzidc-bis/src/main/resources/mapper/bis/IdcDraftsMapper.xml new file mode 100644 index 0000000..8922850 --- /dev/null +++ b/cpzidc-bis/src/main/resources/mapper/bis/IdcDraftsMapper.xml @@ -0,0 +1,138 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.odcc.cpzidc.bis.mapper.IdcDraftsMapper"> + + <resultMap type="IdcDrafts" id="IdcDraftsResult"> + <result property="id" column="id" /> + <result property="baseId" column="base_id" /> + <result property="dateNode" column="date_node" /> + <result property="type" column="type" /> + <result property="idcUseBase" column="idc_use_base" /> + <result property="idcUseGreen" column="idc_use_green" /> + <result property="idcUseComputility" column="idc_use_computility" /> + <result property="idcUseInfrastructure" column="idc_use_infrastructure" /> + <result property="idcUseStorage" column="idc_use_storage" /> + <result property="idcUseTransport" column="idc_use_transport" /> + <result property="idcBuildBase" column="idc_build_base" /> + <result property="idcBuildExtend" column="idc_build_extend" /> + <result property="sort" column="sort_" /> + <result property="state" column="state" /> + <result property="createTime" column="create_time" /> + <result property="createUser" column="create_user" /> + <result property="updateTime" column="update_time" /> + <result property="updateUser" column="update_user" /> + <result property="remark" column="remark" /> + </resultMap> + + <sql id="selectIdcDraftsVo"> + select id, base_id, date_node, type, idc_use_base, idc_use_green, idc_use_computility, idc_use_infrastructure, idc_use_storage, idc_use_transport, idc_build_base, idc_build_extend, sort_, state, create_time, create_user, update_time, update_user, remark from idc_drafts + </sql> + + <select id="selectIdcDraftsList" parameterType="IdcDrafts" resultMap="IdcDraftsResult"> + <include refid="selectIdcDraftsVo"/> + <where> + <if test="baseId != null "> and base_id = #{baseId}</if> + <if test="dateNode != null and dateNode != ''"> and date_node = #{dateNode}</if> + <if test="type != null "> and type = #{type}</if> + <if test="idcUseBase != null and idcUseBase != ''"> and idc_use_base = #{idcUseBase}</if> + <if test="idcUseGreen != null and idcUseGreen != ''"> and idc_use_green = #{idcUseGreen}</if> + <if test="idcUseComputility != null and idcUseComputility != ''"> and idc_use_computility = #{idcUseComputility}</if> + <if test="idcUseInfrastructure != null and idcUseInfrastructure != ''"> and idc_use_infrastructure = #{idcUseInfrastructure}</if> + <if test="idcUseStorage != null and idcUseStorage != ''"> and idc_use_storage = #{idcUseStorage}</if> + <if test="idcUseTransport != null and idcUseTransport != ''"> and idc_use_transport = #{idcUseTransport}</if> + <if test="idcBuildBase != null and idcBuildBase != ''"> and idc_build_base = #{idcBuildBase}</if> + <if test="idcBuildExtend != null and idcBuildExtend != ''"> and idc_build_extend = #{idcBuildExtend}</if> + <if test="sort != null "> and sort_ = #{sort}</if> + <if test="state != null "> and state = #{state}</if> + <if test="createUser != null "> and create_user = #{createUser}</if> + <if test="updateUser != null "> and update_user = #{updateUser}</if> + </where> + </select> + + <select id="selectIdcDraftsById" parameterType="Long" resultMap="IdcDraftsResult"> + <include refid="selectIdcDraftsVo"/> + where id = #{id} + </select> + + <insert id="insertIdcDrafts" parameterType="IdcDrafts" useGeneratedKeys="true" keyProperty="id"> + insert into idc_drafts + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="baseId != null">base_id,</if> + <if test="dateNode != null">date_node,</if> + <if test="type != null">type,</if> + <if test="idcUseBase != null">idc_use_base,</if> + <if test="idcUseGreen != null">idc_use_green,</if> + <if test="idcUseComputility != null">idc_use_computility,</if> + <if test="idcUseInfrastructure != null">idc_use_infrastructure,</if> + <if test="idcUseStorage != null">idc_use_storage,</if> + <if test="idcUseTransport != null">idc_use_transport,</if> + <if test="idcBuildBase != null">idc_build_base,</if> + <if test="idcBuildExtend != null">idc_build_extend,</if> + <if test="sort != null">sort_,</if> + <if test="state != null">state,</if> + <if test="createTime != null">create_time,</if> + <if test="createUser != null">create_user,</if> + <if test="updateTime != null">update_time,</if> + <if test="updateUser != null">update_user,</if> + <if test="remark != null">remark,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="baseId != null">#{baseId},</if> + <if test="dateNode != null">#{dateNode},</if> + <if test="type != null">#{type},</if> + <if test="idcUseBase != null">#{idcUseBase},</if> + <if test="idcUseGreen != null">#{idcUseGreen},</if> + <if test="idcUseComputility != null">#{idcUseComputility},</if> + <if test="idcUseInfrastructure != null">#{idcUseInfrastructure},</if> + <if test="idcUseStorage != null">#{idcUseStorage},</if> + <if test="idcUseTransport != null">#{idcUseTransport},</if> + <if test="idcBuildBase != null">#{idcBuildBase},</if> + <if test="idcBuildExtend != null">#{idcBuildExtend},</if> + <if test="sort != null">#{sort},</if> + <if test="state != null">#{state},</if> + <if test="createTime != null">#{createTime},</if> + <if test="createUser != null">#{createUser},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="updateUser != null">#{updateUser},</if> + <if test="remark != null">#{remark},</if> + </trim> + </insert> + + <update id="updateIdcDrafts" parameterType="IdcDrafts"> + update idc_drafts + <trim prefix="SET" suffixOverrides=","> + <if test="baseId != null">base_id = #{baseId},</if> + <if test="dateNode != null">date_node = #{dateNode},</if> + <if test="type != null">type = #{type},</if> + <if test="idcUseBase != null">idc_use_base = #{idcUseBase},</if> + <if test="idcUseGreen != null">idc_use_green = #{idcUseGreen},</if> + <if test="idcUseComputility != null">idc_use_computility = #{idcUseComputility},</if> + <if test="idcUseInfrastructure != null">idc_use_infrastructure = #{idcUseInfrastructure},</if> + <if test="idcUseStorage != null">idc_use_storage = #{idcUseStorage},</if> + <if test="idcUseTransport != null">idc_use_transport = #{idcUseTransport},</if> + <if test="idcBuildBase != null">idc_build_base = #{idcBuildBase},</if> + <if test="idcBuildExtend != null">idc_build_extend = #{idcBuildExtend},</if> + <if test="sort != null">sort_ = #{sort},</if> + <if test="state != null">state = #{state},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="createUser != null">create_user = #{createUser},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="updateUser != null">update_user = #{updateUser},</if> + <if test="remark != null">remark = #{remark},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteIdcDraftsById" parameterType="Long"> + delete from idc_drafts where id = #{id} + </delete> + + <delete id="deleteIdcDraftsByIds" parameterType="String"> + delete from idc_drafts where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </delete> +</mapper> \ No newline at end of file diff --git a/cpzidc-ui/src/api/bis/drafts.js b/cpzidc-ui/src/api/bis/drafts.js new file mode 100644 index 0000000..bb2ca51 --- /dev/null +++ b/cpzidc-ui/src/api/bis/drafts.js @@ -0,0 +1,44 @@ +import request from '@/utils/request' + +// 查询草稿箱列表 +export function listDrafts(query) { + return request({ + url: '/bis/drafts/list', + method: 'get', + params: query + }) +} + +// 查询草稿箱详细 +export function getDrafts(id) { + return request({ + url: '/bis/drafts/' + id, + method: 'get' + }) +} + +// 新增草稿箱 +export function addDrafts(data) { + return request({ + url: '/bis/drafts', + method: 'post', + data: data + }) +} + +// 修改草稿箱 +export function updateDrafts(data) { + return request({ + url: '/bis/drafts', + method: 'put', + data: data + }) +} + +// 删除草稿箱 +export function delDrafts(id) { + return request({ + url: '/bis/drafts/' + id, + method: 'delete' + }) +} diff --git a/cpzidc-ui/src/views/bis/drafts/index.vue b/cpzidc-ui/src/views/bis/drafts/index.vue new file mode 100644 index 0000000..c13b036 --- /dev/null +++ b/cpzidc-ui/src/views/bis/drafts/index.vue @@ -0,0 +1,368 @@ +<template> + <div class="app-container"> + <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="90px"> + <el-form-item label="数据中心 ID" prop="baseId"> + <el-input + v-model="queryParams.baseId" + placeholder="请输入数据中心" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="日期节点" prop="dateNode"> + <el-input + v-model="queryParams.dateNode" + placeholder="请输入日期节点" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="类型" prop="type"> + <el-select v-model="queryParams.type" placeholder="请选择类型" clearable> + <el-option + v-for="dict in dict.type.idc_submit_type" + :key="dict.value" + :label="dict.label" + :value="dict.value" + /> + </el-select> + </el-form-item> + <el-form-item> + <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button> + <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button> + </el-form-item> + </el-form> + + <el-row :gutter="10" class="mb8"> + <el-col :span="1.5"> + <el-button + type="primary" + plain + icon="el-icon-plus" + size="mini" + @click="handleAdd" + v-hasPermi="['bis:drafts:add']" + >新增</el-button> + </el-col> + <el-col :span="1.5"> + <el-button + type="success" + plain + icon="el-icon-edit" + size="mini" + :disabled="single" + @click="handleUpdate" + v-hasPermi="['bis:drafts:edit']" + >修改</el-button> + </el-col> + <el-col :span="1.5"> + <el-button + type="danger" + plain + icon="el-icon-delete" + size="mini" + :disabled="multiple" + @click="handleDelete" + v-hasPermi="['bis:drafts:remove']" + >删除</el-button> + </el-col> + <el-col :span="1.5"> + <el-button + type="warning" + plain + icon="el-icon-download" + size="mini" + @click="handleExport" + v-hasPermi="['bis:drafts:export']" + >导出</el-button> + </el-col> + <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> + </el-row> + + <el-table v-loading="loading" :data="draftsList" @selection-change="handleSelectionChange"> + <el-table-column type="selection" width="55" align="center" /> + <el-table-column label="序号" align="center" prop="id" /> + <el-table-column label="数据中心 ID" align="center" prop="baseId" /> + <el-table-column label="日期节点" align="center" prop="dateNode" /> + <el-table-column label="暂存类型" align="center" prop="type"> + <template slot-scope="scope"> + <dict-tag :options="dict.type.idc_submit_type" :value="scope.row.type"/> + </template> + </el-table-column> + <el-table-column label="在用基础信息" align="center" prop="idcUseBase" /> + <el-table-column label="在用绿色" align="center" prop="idcUseGreen" /> + <el-table-column label="在用算力" align="center" prop="idcUseComputility" /> + <el-table-column label="在用基础设施" align="center" prop="idcUseInfrastructure" /> + <el-table-column label="在用存力指标" align="center" prop="idcUseStorage" /> + <el-table-column label="在用运力指标" align="center" prop="idcUseTransport" /> + <el-table-column label="在建基础" align="center" prop="idcBuildBase" /> + <el-table-column label="在建扩展" align="center" prop="idcBuildExtend" /> + <el-table-column label="排序" align="center" prop="sort" /> + <el-table-column label="状态" align="center" prop="state" /> + <el-table-column label="创建者" align="center" prop="createUser" /> + <el-table-column label="更新者" align="center" prop="updateUser" /> + <el-table-column label="管理员备注" align="center" prop="remark" /> + <el-table-column label="操作" align="center" class-name="small-padding fixed-width"> + <template slot-scope="scope"> + <el-button + size="mini" + type="text" + icon="el-icon-edit" + @click="handleUpdate(scope.row)" + v-hasPermi="['bis:drafts:edit']" + >修改</el-button> + <el-button + size="mini" + type="text" + icon="el-icon-delete" + @click="handleDelete(scope.row)" + v-hasPermi="['bis:drafts:remove']" + >删除</el-button> + </template> + </el-table-column> + </el-table> + + <pagination + v-show="total>0" + :total="total" + :page.sync="queryParams.pageNum" + :limit.sync="queryParams.pageSize" + @pagination="getList" + /> + + <!-- 添加或修改草稿箱对话框 --> + <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body> + <el-form ref="form" :model="form" :rules="rules" label-width="80px"> + <el-form-item label="数据中心 ID" prop="baseId"> + <el-input v-model="form.baseId" placeholder="请输入数据中心 ID" /> + </el-form-item> + <el-form-item label="日期节点" prop="dateNode"> + <el-input v-model="form.dateNode" placeholder="请输入日期节点" /> + </el-form-item> + <el-form-item label="暂存类型" prop="type"> + <el-radio-group v-model="form.type"> + <el-radio + v-for="dict in dict.type.idc_submit_type" + :key="dict.value" + :label="parseInt(dict.value)" + >{{dict.label}}</el-radio> + </el-radio-group> + </el-form-item> + <el-form-item label="在用基础信息" prop="idcUseBase"> + <el-input v-model="form.idcUseBase" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在用绿色" prop="idcUseGreen"> + <el-input v-model="form.idcUseGreen" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在用算力" prop="idcUseComputility"> + <el-input v-model="form.idcUseComputility" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在用基础设施" prop="idcUseInfrastructure"> + <el-input v-model="form.idcUseInfrastructure" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在用存力指标" prop="idcUseStorage"> + <el-input v-model="form.idcUseStorage" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在用运力指标" prop="idcUseTransport"> + <el-input v-model="form.idcUseTransport" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在建基础" prop="idcBuildBase"> + <el-input v-model="form.idcBuildBase" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="在建扩展" prop="idcBuildExtend"> + <el-input v-model="form.idcBuildExtend" type="textarea" placeholder="请输入内容" /> + </el-form-item> + <el-form-item label="排序" prop="sort"> + <el-input v-model="form.sort" placeholder="请输入排序" /> + </el-form-item> + <el-form-item label="状态" prop="state"> + <el-input v-model="form.state" placeholder="请输入状态" /> + </el-form-item> + <el-form-item label="创建者" prop="createUser"> + <el-input v-model="form.createUser" placeholder="请输入创建者" /> + </el-form-item> + <el-form-item label="更新者" prop="updateUser"> + <el-input v-model="form.updateUser" placeholder="请输入更新者" /> + </el-form-item> + <el-form-item label="管理员备注" prop="remark"> + <el-input v-model="form.remark" placeholder="请输入管理员备注" /> + </el-form-item> + </el-form> + <div slot="footer" class="dialog-footer"> + <el-button type="primary" @click="submitForm">确 定</el-button> + <el-button @click="cancel">取 消</el-button> + </div> + </el-dialog> + </div> +</template> + +<script> +import { listDrafts, getDrafts, delDrafts, addDrafts, updateDrafts } from "@/api/bis/drafts"; + +export default { + name: "Drafts", + dicts: ['idc_submit_type'], + data() { + return { + // 遮罩层 + loading: true, + // 选中数组 + ids: [], + // 非单个禁用 + single: true, + // 非多个禁用 + multiple: true, + // 显示搜索条件 + showSearch: true, + // 总条数 + total: 0, + // 草稿箱表格数据 + draftsList: [], + // 弹出层标题 + title: "", + // 是否显示弹出层 + open: false, + // 查询参数 + queryParams: { + pageNum: 1, + pageSize: 10, + baseId: null, + dateNode: null, + type: null, + idcUseBase: null, + idcUseGreen: null, + idcUseComputility: null, + idcUseInfrastructure: null, + idcUseStorage: null, + idcUseTransport: null, + idcBuildBase: null, + idcBuildExtend: null, + sort: null, + state: null, + createUser: null, + updateUser: null, + }, + // 表单参数 + form: {}, + // 表单校验 + rules: { + createUser: [ + { required: true, message: "创建者不能为空", trigger: "blur" } + ], + } + }; + }, + created() { + this.getList(); + }, + methods: { + /** 查询草稿箱列表 */ + getList() { + this.loading = true; + listDrafts(this.queryParams).then(response => { + this.draftsList = response.rows; + this.total = response.total; + this.loading = false; + }); + }, + // 取消按钮 + cancel() { + this.open = false; + this.reset(); + }, + // 表单重置 + reset() { + this.form = { + id: null, + baseId: null, + dateNode: null, + type: null, + idcUseBase: null, + idcUseGreen: null, + idcUseComputility: null, + idcUseInfrastructure: null, + idcUseStorage: null, + idcUseTransport: null, + idcBuildBase: null, + idcBuildExtend: null, + sort: null, + state: null, + createTime: null, + createUser: null, + updateTime: null, + updateUser: null, + remark: null + }; + this.resetForm("form"); + }, + /** 搜索按钮操作 */ + handleQuery() { + this.queryParams.pageNum = 1; + this.getList(); + }, + /** 重置按钮操作 */ + resetQuery() { + this.resetForm("queryForm"); + this.handleQuery(); + }, + // 多选框选中数据 + handleSelectionChange(selection) { + this.ids = selection.map(item => item.id) + this.single = selection.length!==1 + this.multiple = !selection.length + }, + /** 新增按钮操作 */ + handleAdd() { + this.reset(); + this.open = true; + this.title = "添加草稿箱"; + }, + /** 修改按钮操作 */ + handleUpdate(row) { + this.reset(); + const id = row.id || this.ids + getDrafts(id).then(response => { + this.form = response.data; + this.open = true; + this.title = "修改草稿箱"; + }); + }, + /** 提交按钮 */ + submitForm() { + this.$refs["form"].validate(valid => { + if (valid) { + if (this.form.id != null) { + updateDrafts(this.form).then(response => { + this.$modal.msgSuccess("修改成功"); + this.open = false; + this.getList(); + }); + } else { + addDrafts(this.form).then(response => { + this.$modal.msgSuccess("新增成功"); + this.open = false; + this.getList(); + }); + } + } + }); + }, + /** 删除按钮操作 */ + handleDelete(row) { + const ids = row.id || this.ids; + this.$modal.confirm('是否确认删除草稿箱编号为"' + ids + '"的数据项?').then(function() { + return delDrafts(ids); + }).then(() => { + this.getList(); + this.$modal.msgSuccess("删除成功"); + }).catch(() => {}); + }, + /** 导出按钮操作 */ + handleExport() { + this.download('bis/drafts/export', { + ...this.queryParams + }, `drafts_${new Date().getTime()}.xlsx`) + } + } +}; +</script> diff --git a/cpzidc-ui/src/views/login.vue b/cpzidc-ui/src/views/login.vue index 5331195..2109256 100644 --- a/cpzidc-ui/src/views/login.vue +++ b/cpzidc-ui/src/views/login.vue @@ -73,7 +73,7 @@ codeUrl: "", loginForm: { username: "admin", - password: "admin123", + password: "dceco!", rememberMe: false, code: "", uuid: "" -- Gitblit v1.9.3