3 files modified
2 files deleted
8 files added
| | |
| | | <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> |
| | | |
New file |
| | |
| | | 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)); |
| | | } |
| | | } |
| | |
| | | <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> |
New file |
| | |
| | | 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(); |
| | | } |
| | | } |
New file |
| | |
| | | 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); |
| | | } |
New file |
| | |
| | | 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); |
| | | } |
New file |
| | |
| | | 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); |
| | | } |
| | | } |
New file |
| | |
| | | <?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> |
New file |
| | |
| | | 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' |
| | | }) |
| | | } |
New file |
| | |
| | | <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> |
| | |
| | | codeUrl: "", |
| | | loginForm: { |
| | | username: "admin", |
| | | password: "admin123", |
| | | password: "dceco!", |
| | | rememberMe: false, |
| | | code: "", |
| | | uuid: "" |