From 1d25094b9f0e339d784e6f1b17c95c88c272dd45 Mon Sep 17 00:00:00 2001 From: yanzhaofeige <yanzhaofeige@qq.com> Date: Wed, 09 Oct 2024 23:03:21 +0800 Subject: [PATCH] 数据中心编号处理 --- cpzidc-bis/src/main/resources/mapper/bis/IdcTelCodeMapper.xml | 84 +++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcNoIndex.java | 79 ++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcTelCodeMapper.java | 61 ++ cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcNoIndexController.java | 104 +++ cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcTelCodeController.java | 104 +++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcNoIndexMapper.java | 61 ++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcNoIndexService.java | 61 ++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcTelCodeService.java | 61 ++ cpzidc-ui/src/views/bis/idcNoIndex/index.vue | 273 +++++++++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcTelCodeServiceImpl.java | 96 +++ cpzidc-ui/src/views/bis/idcTelCode/index.vue | 298 ++++++++++ cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcTelCode.java | 109 +++ cpzidc-ui/src/api/bis/idcTelCode.js | 44 + cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcNoIndexServiceImpl.java | 93 +++ cpzidc-ui/src/api/bis/idcNoIndex.js | 44 + cpzidc-bis/src/main/resources/mapper/bis/IdcNoIndexMapper.xml | 66 ++ 16 files changed, 1,638 insertions(+), 0 deletions(-) diff --git a/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcNoIndexController.java b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcNoIndexController.java new file mode 100644 index 0000000..7a8a8b5 --- /dev/null +++ b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcNoIndexController.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.IdcNoIndex; +import com.odcc.cpzidc.bis.service.IIdcNoIndexService; +import com.odcc.cpzidc.common.utils.poi.ExcelUtil; +import com.odcc.cpzidc.common.core.page.TableDataInfo; + +/** + * IDC编号索引Controller + * + * @author ruoyi + * @date 2024-10-09 + */ +@RestController +@RequestMapping("/bis/idcNoIndex") +public class IdcNoIndexController extends BaseController +{ + @Autowired + private IIdcNoIndexService idcNoIndexService; + + /** + * 查询IDC编号索引列表 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:list')") + @GetMapping("/list") + public TableDataInfo list(IdcNoIndex idcNoIndex) + { + startPage(); + List<IdcNoIndex> list = idcNoIndexService.selectIdcNoIndexList(idcNoIndex); + return getDataTable(list); + } + + /** + * 导出IDC编号索引列表 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:export')") + @Log(title = "IDC编号索引", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IdcNoIndex idcNoIndex) + { + List<IdcNoIndex> list = idcNoIndexService.selectIdcNoIndexList(idcNoIndex); + ExcelUtil<IdcNoIndex> util = new ExcelUtil<IdcNoIndex>(IdcNoIndex.class); + util.exportExcel(response, list, "IDC编号索引数据"); + } + + /** + * 获取IDC编号索引详细信息 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return success(idcNoIndexService.selectIdcNoIndexById(id)); + } + + /** + * 新增IDC编号索引 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:add')") + @Log(title = "IDC编号索引", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IdcNoIndex idcNoIndex) + { + return toAjax(idcNoIndexService.insertIdcNoIndex(idcNoIndex)); + } + + /** + * 修改IDC编号索引 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:edit')") + @Log(title = "IDC编号索引", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IdcNoIndex idcNoIndex) + { + return toAjax(idcNoIndexService.updateIdcNoIndex(idcNoIndex)); + } + + /** + * 删除IDC编号索引 + */ + @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:remove')") + @Log(title = "IDC编号索引", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(idcNoIndexService.deleteIdcNoIndexByIds(ids)); + } +} diff --git a/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcTelCodeController.java b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcTelCodeController.java new file mode 100644 index 0000000..33caf9a --- /dev/null +++ b/cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcTelCodeController.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.IdcTelCode; +import com.odcc.cpzidc.bis.service.IIdcTelCodeService; +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/idcTelCode") +public class IdcTelCodeController extends BaseController +{ + @Autowired + private IIdcTelCodeService idcTelCodeService; + + /** + * 查询电话区号列表 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:list')") + @GetMapping("/list") + public TableDataInfo list(IdcTelCode idcTelCode) + { + startPage(); + List<IdcTelCode> list = idcTelCodeService.selectIdcTelCodeList(idcTelCode); + return getDataTable(list); + } + + /** + * 导出电话区号列表 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:export')") + @Log(title = "电话区号", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, IdcTelCode idcTelCode) + { + List<IdcTelCode> list = idcTelCodeService.selectIdcTelCodeList(idcTelCode); + ExcelUtil<IdcTelCode> util = new ExcelUtil<IdcTelCode>(IdcTelCode.class); + util.exportExcel(response, list, "电话区号数据"); + } + + /** + * 获取电话区号详细信息 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return success(idcTelCodeService.selectIdcTelCodeById(id)); + } + + /** + * 新增电话区号 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:add')") + @Log(title = "电话区号", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody IdcTelCode idcTelCode) + { + return toAjax(idcTelCodeService.insertIdcTelCode(idcTelCode)); + } + + /** + * 修改电话区号 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:edit')") + @Log(title = "电话区号", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody IdcTelCode idcTelCode) + { + return toAjax(idcTelCodeService.updateIdcTelCode(idcTelCode)); + } + + /** + * 删除电话区号 + */ + @PreAuthorize("@ss.hasPermi('bis:idcTelCode:remove')") + @Log(title = "电话区号", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(idcTelCodeService.deleteIdcTelCodeByIds(ids)); + } +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcNoIndex.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcNoIndex.java new file mode 100644 index 0000000..c1c05fd --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcNoIndex.java @@ -0,0 +1,79 @@ +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编号索引对象 idc_no_index + * + * @author ruoyi + * @date 2024-10-09 + */ +public class IdcNoIndex extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** ID */ + private Long id; + + /** 省份 */ + @Excel(name = "省份") + private String telNo; + + /** 投产年份 */ + @Excel(name = "投产年份") + private String productionYear; + + /** 序号 */ + @Excel(name = "序号") + private String index; + + public void setId(Long id) + { + this.id = id; + } + + public Long getId() + { + return id; + } + public void setTelNo(String telNo) + { + this.telNo = telNo; + } + + public String getTelNo() + { + return telNo; + } + public void setProductionYear(String productionYear) + { + this.productionYear = productionYear; + } + + public String getProductionYear() + { + return productionYear; + } + public void setIndex(String index) + { + this.index = index; + } + + public String getIndex() + { + return index; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("id", getId()) + .append("telNo", getTelNo()) + .append("productionYear", getProductionYear()) + .append("index", getIndex()) + .toString(); + } +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcTelCode.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcTelCode.java new file mode 100644 index 0000000..b7c70e4 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcTelCode.java @@ -0,0 +1,109 @@ +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_tel_code + * + * @author ruoyi + * @date 2024-10-09 + */ +public class IdcTelCode extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** 表ID */ + private Long id; + + /** 省份 */ + @Excel(name = "省份") + private String province; + + /** 城市 */ + @Excel(name = "城市") + private String city; + + /** 号码 */ + @Excel(name = "号码") + private String code; + + /** 文章是否可用 */ + @Excel(name = "文章是否可用") + private Long state; + + /** 创建者 */ + @Excel(name = "创建者") + private Long createUser; + + public void setId(Long id) + { + this.id = id; + } + + public Long getId() + { + return id; + } + public void setProvince(String province) + { + this.province = province; + } + + public String getProvince() + { + return province; + } + public void setCity(String city) + { + this.city = city; + } + + public String getCity() + { + return city; + } + public void setCode(String code) + { + this.code = code; + } + + public String getCode() + { + return code; + } + public void setState(Long state) + { + this.state = state; + } + + public Long getState() + { + return state; + } + public void setCreateUser(Long createUser) + { + this.createUser = createUser; + } + + public Long getCreateUser() + { + return createUser; + } + + @Override + public String toString() { + return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) + .append("id", getId()) + .append("province", getProvince()) + .append("city", getCity()) + .append("code", getCode()) + .append("state", getState()) + .append("createTime", getCreateTime()) + .append("updateTime", getUpdateTime()) + .append("createUser", getCreateUser()) + .toString(); + } +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcNoIndexMapper.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcNoIndexMapper.java new file mode 100644 index 0000000..50728bc --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcNoIndexMapper.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.mapper; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcNoIndex; + +/** + * IDC编号索引Mapper接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IdcNoIndexMapper +{ + /** + * 查询IDC编号索引 + * + * @param id IDC编号索引主键 + * @return IDC编号索引 + */ + public IdcNoIndex selectIdcNoIndexById(Long id); + + /** + * 查询IDC编号索引列表 + * + * @param idcNoIndex IDC编号索引 + * @return IDC编号索引集合 + */ + public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex); + + /** + * 新增IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + public int insertIdcNoIndex(IdcNoIndex idcNoIndex); + + /** + * 修改IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + public int updateIdcNoIndex(IdcNoIndex idcNoIndex); + + /** + * 删除IDC编号索引 + * + * @param id IDC编号索引主键 + * @return 结果 + */ + public int deleteIdcNoIndexById(Long id); + + /** + * 批量删除IDC编号索引 + * + * @param ids 需要删除的数据主键集合 + * @return 结果 + */ + public int deleteIdcNoIndexByIds(Long[] ids); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcTelCodeMapper.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcTelCodeMapper.java new file mode 100644 index 0000000..5f70d60 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcTelCodeMapper.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.mapper; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcTelCode; + +/** + * 电话区号Mapper接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IdcTelCodeMapper +{ + /** + * 查询电话区号 + * + * @param id 电话区号主键 + * @return 电话区号 + */ + public IdcTelCode selectIdcTelCodeById(Long id); + + /** + * 查询电话区号列表 + * + * @param idcTelCode 电话区号 + * @return 电话区号集合 + */ + public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode); + + /** + * 新增电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + public int insertIdcTelCode(IdcTelCode idcTelCode); + + /** + * 修改电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + public int updateIdcTelCode(IdcTelCode idcTelCode); + + /** + * 删除电话区号 + * + * @param id 电话区号主键 + * @return 结果 + */ + public int deleteIdcTelCodeById(Long id); + + /** + * 批量删除电话区号 + * + * @param ids 需要删除的数据主键集合 + * @return 结果 + */ + public int deleteIdcTelCodeByIds(Long[] ids); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcNoIndexService.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcNoIndexService.java new file mode 100644 index 0000000..cca081b --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcNoIndexService.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.service; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcNoIndex; + +/** + * IDC编号索引Service接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IIdcNoIndexService +{ + /** + * 查询IDC编号索引 + * + * @param id IDC编号索引主键 + * @return IDC编号索引 + */ + public IdcNoIndex selectIdcNoIndexById(Long id); + + /** + * 查询IDC编号索引列表 + * + * @param idcNoIndex IDC编号索引 + * @return IDC编号索引集合 + */ + public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex); + + /** + * 新增IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + public int insertIdcNoIndex(IdcNoIndex idcNoIndex); + + /** + * 修改IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + public int updateIdcNoIndex(IdcNoIndex idcNoIndex); + + /** + * 批量删除IDC编号索引 + * + * @param ids 需要删除的IDC编号索引主键集合 + * @return 结果 + */ + public int deleteIdcNoIndexByIds(Long[] ids); + + /** + * 删除IDC编号索引信息 + * + * @param id IDC编号索引主键 + * @return 结果 + */ + public int deleteIdcNoIndexById(Long id); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcTelCodeService.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcTelCodeService.java new file mode 100644 index 0000000..8b03250 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcTelCodeService.java @@ -0,0 +1,61 @@ +package com.odcc.cpzidc.bis.service; + +import java.util.List; +import com.odcc.cpzidc.bis.domain.IdcTelCode; + +/** + * 电话区号Service接口 + * + * @author ruoyi + * @date 2024-10-09 + */ +public interface IIdcTelCodeService +{ + /** + * 查询电话区号 + * + * @param id 电话区号主键 + * @return 电话区号 + */ + public IdcTelCode selectIdcTelCodeById(Long id); + + /** + * 查询电话区号列表 + * + * @param idcTelCode 电话区号 + * @return 电话区号集合 + */ + public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode); + + /** + * 新增电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + public int insertIdcTelCode(IdcTelCode idcTelCode); + + /** + * 修改电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + public int updateIdcTelCode(IdcTelCode idcTelCode); + + /** + * 批量删除电话区号 + * + * @param ids 需要删除的电话区号主键集合 + * @return 结果 + */ + public int deleteIdcTelCodeByIds(Long[] ids); + + /** + * 删除电话区号信息 + * + * @param id 电话区号主键 + * @return 结果 + */ + public int deleteIdcTelCodeById(Long id); +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcNoIndexServiceImpl.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcNoIndexServiceImpl.java new file mode 100644 index 0000000..a91c2da --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcNoIndexServiceImpl.java @@ -0,0 +1,93 @@ +package com.odcc.cpzidc.bis.service.impl; + +import java.util.List; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.odcc.cpzidc.bis.mapper.IdcNoIndexMapper; +import com.odcc.cpzidc.bis.domain.IdcNoIndex; +import com.odcc.cpzidc.bis.service.IIdcNoIndexService; + +/** + * IDC编号索引Service业务层处理 + * + * @author ruoyi + * @date 2024-10-09 + */ +@Service +public class IdcNoIndexServiceImpl implements IIdcNoIndexService +{ + @Autowired + private IdcNoIndexMapper idcNoIndexMapper; + + /** + * 查询IDC编号索引 + * + * @param id IDC编号索引主键 + * @return IDC编号索引 + */ + @Override + public IdcNoIndex selectIdcNoIndexById(Long id) + { + return idcNoIndexMapper.selectIdcNoIndexById(id); + } + + /** + * 查询IDC编号索引列表 + * + * @param idcNoIndex IDC编号索引 + * @return IDC编号索引 + */ + @Override + public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex) + { + return idcNoIndexMapper.selectIdcNoIndexList(idcNoIndex); + } + + /** + * 新增IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + @Override + public int insertIdcNoIndex(IdcNoIndex idcNoIndex) + { + return idcNoIndexMapper.insertIdcNoIndex(idcNoIndex); + } + + /** + * 修改IDC编号索引 + * + * @param idcNoIndex IDC编号索引 + * @return 结果 + */ + @Override + public int updateIdcNoIndex(IdcNoIndex idcNoIndex) + { + return idcNoIndexMapper.updateIdcNoIndex(idcNoIndex); + } + + /** + * 批量删除IDC编号索引 + * + * @param ids 需要删除的IDC编号索引主键 + * @return 结果 + */ + @Override + public int deleteIdcNoIndexByIds(Long[] ids) + { + return idcNoIndexMapper.deleteIdcNoIndexByIds(ids); + } + + /** + * 删除IDC编号索引信息 + * + * @param id IDC编号索引主键 + * @return 结果 + */ + @Override + public int deleteIdcNoIndexById(Long id) + { + return idcNoIndexMapper.deleteIdcNoIndexById(id); + } +} diff --git a/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcTelCodeServiceImpl.java b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcTelCodeServiceImpl.java new file mode 100644 index 0000000..411e116 --- /dev/null +++ b/cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcTelCodeServiceImpl.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.IdcTelCodeMapper; +import com.odcc.cpzidc.bis.domain.IdcTelCode; +import com.odcc.cpzidc.bis.service.IIdcTelCodeService; + +/** + * 电话区号Service业务层处理 + * + * @author ruoyi + * @date 2024-10-09 + */ +@Service +public class IdcTelCodeServiceImpl implements IIdcTelCodeService +{ + @Autowired + private IdcTelCodeMapper idcTelCodeMapper; + + /** + * 查询电话区号 + * + * @param id 电话区号主键 + * @return 电话区号 + */ + @Override + public IdcTelCode selectIdcTelCodeById(Long id) + { + return idcTelCodeMapper.selectIdcTelCodeById(id); + } + + /** + * 查询电话区号列表 + * + * @param idcTelCode 电话区号 + * @return 电话区号 + */ + @Override + public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode) + { + return idcTelCodeMapper.selectIdcTelCodeList(idcTelCode); + } + + /** + * 新增电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + @Override + public int insertIdcTelCode(IdcTelCode idcTelCode) + { + idcTelCode.setCreateTime(DateUtils.getNowDate()); + return idcTelCodeMapper.insertIdcTelCode(idcTelCode); + } + + /** + * 修改电话区号 + * + * @param idcTelCode 电话区号 + * @return 结果 + */ + @Override + public int updateIdcTelCode(IdcTelCode idcTelCode) + { + idcTelCode.setUpdateTime(DateUtils.getNowDate()); + return idcTelCodeMapper.updateIdcTelCode(idcTelCode); + } + + /** + * 批量删除电话区号 + * + * @param ids 需要删除的电话区号主键 + * @return 结果 + */ + @Override + public int deleteIdcTelCodeByIds(Long[] ids) + { + return idcTelCodeMapper.deleteIdcTelCodeByIds(ids); + } + + /** + * 删除电话区号信息 + * + * @param id 电话区号主键 + * @return 结果 + */ + @Override + public int deleteIdcTelCodeById(Long id) + { + return idcTelCodeMapper.deleteIdcTelCodeById(id); + } +} diff --git a/cpzidc-bis/src/main/resources/mapper/bis/IdcNoIndexMapper.xml b/cpzidc-bis/src/main/resources/mapper/bis/IdcNoIndexMapper.xml new file mode 100644 index 0000000..33733b2 --- /dev/null +++ b/cpzidc-bis/src/main/resources/mapper/bis/IdcNoIndexMapper.xml @@ -0,0 +1,66 @@ +<?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.IdcNoIndexMapper"> + + <resultMap type="IdcNoIndex" id="IdcNoIndexResult"> + <result property="id" column="id" /> + <result property="telNo" column="tel_no" /> + <result property="productionYear" column="production_year" /> + <result property="index" column="index" /> + </resultMap> + + <sql id="selectIdcNoIndexVo"> + select id, tel_no, production_year, index from idc_no_index + </sql> + + <select id="selectIdcNoIndexList" parameterType="IdcNoIndex" resultMap="IdcNoIndexResult"> + <include refid="selectIdcNoIndexVo"/> + <where> + <if test="telNo != null and telNo != ''"> and tel_no = #{telNo}</if> + <if test="productionYear != null and productionYear != ''"> and production_year = #{productionYear}</if> + <if test="index != null and index != ''"> and index = #{index}</if> + </where> + </select> + + <select id="selectIdcNoIndexById" parameterType="Long" resultMap="IdcNoIndexResult"> + <include refid="selectIdcNoIndexVo"/> + where id = #{id} + </select> + + <insert id="insertIdcNoIndex" parameterType="IdcNoIndex" useGeneratedKeys="true" keyProperty="id"> + insert into idc_no_index + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="telNo != null">tel_no,</if> + <if test="productionYear != null">production_year,</if> + <if test="index != null">index,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="telNo != null">#{telNo},</if> + <if test="productionYear != null">#{productionYear},</if> + <if test="index != null">#{index},</if> + </trim> + </insert> + + <update id="updateIdcNoIndex" parameterType="IdcNoIndex"> + update idc_no_index + <trim prefix="SET" suffixOverrides=","> + <if test="telNo != null">tel_no = #{telNo},</if> + <if test="productionYear != null">production_year = #{productionYear},</if> + <if test="index != null">index = #{index},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteIdcNoIndexById" parameterType="Long"> + delete from idc_no_index where id = #{id} + </delete> + + <delete id="deleteIdcNoIndexByIds" parameterType="String"> + delete from idc_no_index 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-bis/src/main/resources/mapper/bis/IdcTelCodeMapper.xml b/cpzidc-bis/src/main/resources/mapper/bis/IdcTelCodeMapper.xml new file mode 100644 index 0000000..1ddf991 --- /dev/null +++ b/cpzidc-bis/src/main/resources/mapper/bis/IdcTelCodeMapper.xml @@ -0,0 +1,84 @@ +<?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.IdcTelCodeMapper"> + + <resultMap type="IdcTelCode" id="IdcTelCodeResult"> + <result property="id" column="id" /> + <result property="province" column="province" /> + <result property="city" column="city" /> + <result property="code" column="code" /> + <result property="state" column="state" /> + <result property="createTime" column="create_time" /> + <result property="updateTime" column="update_time" /> + <result property="createUser" column="create_user" /> + </resultMap> + + <sql id="selectIdcTelCodeVo"> + select id, province, city, code, state, create_time, update_time, create_user from idc_tel_code + </sql> + + <select id="selectIdcTelCodeList" parameterType="IdcTelCode" resultMap="IdcTelCodeResult"> + <include refid="selectIdcTelCodeVo"/> + <where> + <if test="province != null and province != ''"> and province = #{province}</if> + <if test="city != null and city != ''"> and city = #{city}</if> + <if test="code != null and code != ''"> and code = #{code}</if> + <if test="state != null "> and state = #{state}</if> + <if test="createUser != null "> and create_user = #{createUser}</if> + </where> + </select> + + <select id="selectIdcTelCodeById" parameterType="Long" resultMap="IdcTelCodeResult"> + <include refid="selectIdcTelCodeVo"/> + where id = #{id} + </select> + + <insert id="insertIdcTelCode" parameterType="IdcTelCode" useGeneratedKeys="true" keyProperty="id"> + insert into idc_tel_code + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="province != null">province,</if> + <if test="city != null">city,</if> + <if test="code != null">code,</if> + <if test="state != null">state,</if> + <if test="createTime != null">create_time,</if> + <if test="updateTime != null">update_time,</if> + <if test="createUser != null">create_user,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="province != null">#{province},</if> + <if test="city != null">#{city},</if> + <if test="code != null">#{code},</if> + <if test="state != null">#{state},</if> + <if test="createTime != null">#{createTime},</if> + <if test="updateTime != null">#{updateTime},</if> + <if test="createUser != null">#{createUser},</if> + </trim> + </insert> + + <update id="updateIdcTelCode" parameterType="IdcTelCode"> + update idc_tel_code + <trim prefix="SET" suffixOverrides=","> + <if test="province != null">province = #{province},</if> + <if test="city != null">city = #{city},</if> + <if test="code != null">code = #{code},</if> + <if test="state != null">state = #{state},</if> + <if test="createTime != null">create_time = #{createTime},</if> + <if test="updateTime != null">update_time = #{updateTime},</if> + <if test="createUser != null">create_user = #{createUser},</if> + </trim> + where id = #{id} + </update> + + <delete id="deleteIdcTelCodeById" parameterType="Long"> + delete from idc_tel_code where id = #{id} + </delete> + + <delete id="deleteIdcTelCodeByIds" parameterType="String"> + delete from idc_tel_code 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/idcNoIndex.js b/cpzidc-ui/src/api/bis/idcNoIndex.js new file mode 100644 index 0000000..0fa14ff --- /dev/null +++ b/cpzidc-ui/src/api/bis/idcNoIndex.js @@ -0,0 +1,44 @@ +import request from '@/utils/request' + +// 查询IDC编号索引列表 +export function listIdcNoIndex(query) { + return request({ + url: '/bis/idcNoIndex/list', + method: 'get', + params: query + }) +} + +// 查询IDC编号索引详细 +export function getIdcNoIndex(id) { + return request({ + url: '/bis/idcNoIndex/' + id, + method: 'get' + }) +} + +// 新增IDC编号索引 +export function addIdcNoIndex(data) { + return request({ + url: '/bis/idcNoIndex', + method: 'post', + data: data + }) +} + +// 修改IDC编号索引 +export function updateIdcNoIndex(data) { + return request({ + url: '/bis/idcNoIndex', + method: 'put', + data: data + }) +} + +// 删除IDC编号索引 +export function delIdcNoIndex(id) { + return request({ + url: '/bis/idcNoIndex/' + id, + method: 'delete' + }) +} diff --git a/cpzidc-ui/src/api/bis/idcTelCode.js b/cpzidc-ui/src/api/bis/idcTelCode.js new file mode 100644 index 0000000..3409ff8 --- /dev/null +++ b/cpzidc-ui/src/api/bis/idcTelCode.js @@ -0,0 +1,44 @@ +import request from '@/utils/request' + +// 查询电话区号列表 +export function listIdcTelCode(query) { + return request({ + url: '/bis/idcTelCode/list', + method: 'get', + params: query + }) +} + +// 查询电话区号详细 +export function getIdcTelCode(id) { + return request({ + url: '/bis/idcTelCode/' + id, + method: 'get' + }) +} + +// 新增电话区号 +export function addIdcTelCode(data) { + return request({ + url: '/bis/idcTelCode', + method: 'post', + data: data + }) +} + +// 修改电话区号 +export function updateIdcTelCode(data) { + return request({ + url: '/bis/idcTelCode', + method: 'put', + data: data + }) +} + +// 删除电话区号 +export function delIdcTelCode(id) { + return request({ + url: '/bis/idcTelCode/' + id, + method: 'delete' + }) +} diff --git a/cpzidc-ui/src/views/bis/idcNoIndex/index.vue b/cpzidc-ui/src/views/bis/idcNoIndex/index.vue new file mode 100644 index 0000000..fc1fceb --- /dev/null +++ b/cpzidc-ui/src/views/bis/idcNoIndex/index.vue @@ -0,0 +1,273 @@ +<template> + <div class="app-container"> + <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px"> + <el-form-item label="省份" prop="telNo"> + <el-input + v-model="queryParams.telNo" + placeholder="请输入省份" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="投产年份" prop="productionYear"> + <el-input + v-model="queryParams.productionYear" + placeholder="请输入投产年份" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="序号" prop="index"> + <el-input + v-model="queryParams.index" + placeholder="请输入序号" + clearable + @keyup.enter.native="handleQuery" + /> + </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:idcNoIndex: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:idcNoIndex: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:idcNoIndex: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:idcNoIndex:export']" + >导出</el-button> + </el-col> + <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> + </el-row> + + <el-table v-loading="loading" :data="idcNoIndexList" @selection-change="handleSelectionChange"> + <el-table-column type="selection" width="55" align="center" /> + <el-table-column label="ID" align="center" prop="id" /> + <el-table-column label="省份" align="center" prop="telNo" /> + <el-table-column label="投产年份" align="center" prop="productionYear" /> + <el-table-column label="序号" align="center" prop="index" /> + <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:idcNoIndex:edit']" + >修改</el-button> + <el-button + size="mini" + type="text" + icon="el-icon-delete" + @click="handleDelete(scope.row)" + v-hasPermi="['bis:idcNoIndex: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" + /> + + <!-- 添加或修改IDC编号索引对话框 --> + <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="省份" prop="telNo"> + <el-input v-model="form.telNo" placeholder="请输入省份" /> + </el-form-item> + <el-form-item label="投产年份" prop="productionYear"> + <el-input v-model="form.productionYear" placeholder="请输入投产年份" /> + </el-form-item> + <el-form-item label="序号" prop="index"> + <el-input v-model="form.index" 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 { listIdcNoIndex, getIdcNoIndex, delIdcNoIndex, addIdcNoIndex, updateIdcNoIndex } from "@/api/bis/idcNoIndex"; + +export default { + name: "IdcNoIndex", + data() { + return { + // 遮罩层 + loading: true, + // 选中数组 + ids: [], + // 非单个禁用 + single: true, + // 非多个禁用 + multiple: true, + // 显示搜索条件 + showSearch: true, + // 总条数 + total: 0, + // IDC编号索引表格数据 + idcNoIndexList: [], + // 弹出层标题 + title: "", + // 是否显示弹出层 + open: false, + // 查询参数 + queryParams: { + pageNum: 1, + pageSize: 10, + telNo: null, + productionYear: null, + index: null + }, + // 表单参数 + form: {}, + // 表单校验 + rules: { + } + }; + }, + created() { + this.getList(); + }, + methods: { + /** 查询IDC编号索引列表 */ + getList() { + this.loading = true; + listIdcNoIndex(this.queryParams).then(response => { + this.idcNoIndexList = response.rows; + this.total = response.total; + this.loading = false; + }); + }, + // 取消按钮 + cancel() { + this.open = false; + this.reset(); + }, + // 表单重置 + reset() { + this.form = { + id: null, + telNo: null, + productionYear: null, + index: 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 = "添加IDC编号索引"; + }, + /** 修改按钮操作 */ + handleUpdate(row) { + this.reset(); + const id = row.id || this.ids + getIdcNoIndex(id).then(response => { + this.form = response.data; + this.open = true; + this.title = "修改IDC编号索引"; + }); + }, + /** 提交按钮 */ + submitForm() { + this.$refs["form"].validate(valid => { + if (valid) { + if (this.form.id != null) { + updateIdcNoIndex(this.form).then(response => { + this.$modal.msgSuccess("修改成功"); + this.open = false; + this.getList(); + }); + } else { + addIdcNoIndex(this.form).then(response => { + this.$modal.msgSuccess("新增成功"); + this.open = false; + this.getList(); + }); + } + } + }); + }, + /** 删除按钮操作 */ + handleDelete(row) { + const ids = row.id || this.ids; + this.$modal.confirm('是否确认删除IDC编号索引编号为"' + ids + '"的数据项?').then(function() { + return delIdcNoIndex(ids); + }).then(() => { + this.getList(); + this.$modal.msgSuccess("删除成功"); + }).catch(() => {}); + }, + /** 导出按钮操作 */ + handleExport() { + this.download('bis/idcNoIndex/export', { + ...this.queryParams + }, `idcNoIndex_${new Date().getTime()}.xlsx`) + } + } +}; +</script> diff --git a/cpzidc-ui/src/views/bis/idcTelCode/index.vue b/cpzidc-ui/src/views/bis/idcTelCode/index.vue new file mode 100644 index 0000000..2d8e9d5 --- /dev/null +++ b/cpzidc-ui/src/views/bis/idcTelCode/index.vue @@ -0,0 +1,298 @@ +<template> + <div class="app-container"> + <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px"> + <el-form-item label="省份" prop="province"> + <el-input + v-model="queryParams.province" + placeholder="请输入省份" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="城市" prop="city"> + <el-input + v-model="queryParams.city" + placeholder="请输入城市" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="文章是否可用" prop="state"> + <el-input + v-model="queryParams.state" + placeholder="请输入文章是否可用" + clearable + @keyup.enter.native="handleQuery" + /> + </el-form-item> + <el-form-item label="创建者" prop="createUser"> + <el-input + v-model="queryParams.createUser" + placeholder="请输入创建者" + clearable + @keyup.enter.native="handleQuery" + /> + </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:idcTelCode: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:idcTelCode: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:idcTelCode: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:idcTelCode:export']" + >导出</el-button> + </el-col> + <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> + </el-row> + + <el-table v-loading="loading" :data="idcTelCodeList" @selection-change="handleSelectionChange"> + <el-table-column type="selection" width="55" align="center" /> + <el-table-column label="表ID" align="center" prop="id" /> + <el-table-column label="省份" align="center" prop="province" /> + <el-table-column label="城市" align="center" prop="city" /> + <el-table-column label="号码" align="center" prop="code" /> + <el-table-column label="文章是否可用" align="center" prop="state" /> + <el-table-column label="创建者" align="center" prop="createUser" /> + <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:idcTelCode:edit']" + >修改</el-button> + <el-button + size="mini" + type="text" + icon="el-icon-delete" + @click="handleDelete(scope.row)" + v-hasPermi="['bis:idcTelCode: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="省份" prop="province"> + <el-input v-model="form.province" placeholder="请输入省份" /> + </el-form-item> + <el-form-item label="城市" prop="city"> + <el-input v-model="form.city" placeholder="请输入城市" /> + </el-form-item> + <el-form-item label="号码" prop="code"> + <el-input v-model="form.code" type="textarea" 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> + <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 { listIdcTelCode, getIdcTelCode, delIdcTelCode, addIdcTelCode, updateIdcTelCode } from "@/api/bis/idcTelCode"; + +export default { + name: "IdcTelCode", + data() { + return { + // 遮罩层 + loading: true, + // 选中数组 + ids: [], + // 非单个禁用 + single: true, + // 非多个禁用 + multiple: true, + // 显示搜索条件 + showSearch: true, + // 总条数 + total: 0, + // 电话区号表格数据 + idcTelCodeList: [], + // 弹出层标题 + title: "", + // 是否显示弹出层 + open: false, + // 查询参数 + queryParams: { + pageNum: 1, + pageSize: 10, + province: null, + city: null, + code: null, + state: null, + createUser: null + }, + // 表单参数 + form: {}, + // 表单校验 + rules: { + createUser: [ + { required: true, message: "创建者不能为空", trigger: "blur" } + ] + } + }; + }, + created() { + this.getList(); + }, + methods: { + /** 查询电话区号列表 */ + getList() { + this.loading = true; + listIdcTelCode(this.queryParams).then(response => { + this.idcTelCodeList = response.rows; + this.total = response.total; + this.loading = false; + }); + }, + // 取消按钮 + cancel() { + this.open = false; + this.reset(); + }, + // 表单重置 + reset() { + this.form = { + id: null, + province: null, + city: null, + code: null, + state: null, + createTime: null, + updateTime: null, + createUser: 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 + getIdcTelCode(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) { + updateIdcTelCode(this.form).then(response => { + this.$modal.msgSuccess("修改成功"); + this.open = false; + this.getList(); + }); + } else { + addIdcTelCode(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 delIdcTelCode(ids); + }).then(() => { + this.getList(); + this.$modal.msgSuccess("删除成功"); + }).catch(() => {}); + }, + /** 导出按钮操作 */ + handleExport() { + this.download('bis/idcTelCode/export', { + ...this.queryParams + }, `idcTelCode_${new Date().getTime()}.xlsx`) + } + } +}; +</script> -- Gitblit v1.9.3