文章目录
商城三级分类删除
前端代码
<!-- data;树数据 在vue data初始化指定 -->
<!--default-expanded-keys;默认展开的节点的 key 的数组 -->
<!-- v-if="node.childNodes.length==0" ;只有三级分类才能删除 -->
<el-tree
:data="menus"
:props="defaultProps"
show-checkbox
node-key="catId"
:default-expanded-keys="expandedKey"
:expand-on-click-node="false"
>
<span class="custom-tree-node" slot-scope="{ node, data }">
<span>{{ node.label }}</span>
<span>
<el-button type="text" size="mini" @click="() => append(data)">添加</el-button>
<el-button
type="text"
size="mini"
v-if="node.childNodes.length==0"
@click="() => remove(node, data)"
>删除</el-button>
</span>
</span>
</el-tree>
remove(node, data) {
var ids = [data.catId];
this.$confirm(`是否删除【${data.name}】菜单?`, "提示", {
confirmButtonText: "确定",
cancelButtonText: "取消",
type: "warning"
})
.then(() => {
this.$http({
url: this.$http.adornUrl("/product/category/delete"),
method: "post",
data: this.$http.adornData(ids, false)
}).then(({ data }) => {
this.$message({
message: "菜单删除成功",
type: "success"
});
//刷新出新的菜单
this.getMenus();
//设置需要默认展开的菜单
this.expandedKey = [node.parent.data.catId];
});
})
.catch(() => {});
}
后端代码
使用Mybatis-Plus 逻辑删除
SpringBoot 配置方式:
application.yml 加入配置(如果你的默认值和mp默认的一样,该配置可无):
mybatis-plus:
global-config:
db-config:
logic-delete-field: flag #全局逻辑删除字段值 3.3.0开始支持,详情看下面。
logic-delete-value: 1 # 逻辑已删除值(默认为 1)
logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)
注册 Bean(3.1.1开始不再需要这一步):
import com.baomidou.mybatisplus.core.injector.ISqlInjector;
import com.baomidou.mybatisplus.extension.injector.LogicSqlInjector;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MyBatisPlusConfiguration {
@Bean
public ISqlInjector sqlInjector() {
return new LogicSqlInjector();
}
}
实体类字段上加上@TableLogic注解
/**
* 是否显示[0-不显示,1显示]
*/
@TableLogic(value = "1",delval = "0")
private Integer showStatus;
TableLogic 接口
/**
* 默认逻辑未删除值(该值可无、会自动获取全局配置)
*/
String value() default "";
/**
* 默认逻辑删除值(该值可无、会自动获取全局配置)
*/
String delval() default "";
CategoryServiceImpl实现类
/**
* 删除菜单
*
* @param asList
*/
@Override
public void removeMenusByIds(List<Long> asList) {
//TODO 检查当前要删除菜单是否被别的地方引用
baseMapper.deleteBatchIds(asList);
}
商城三级分类新增
前端代码
<template>
<div>
<!-- data;树数据 在vue data初始化指定 -->
<!--default-expanded-keys;默认展开的节点的 key 的数组 -->
<!-- v-if="node.childNodes.length==0" ;只有三级分类才能删除 -->
<!-- v-if="node.level <=2" ;只有一级和二级分类可以添加-->
<el-tree
:data="menus"
:props="defaultProps"
show-checkbox
node-key="catId"
:default-expanded-keys="expandedKey"
:expand-on-click-node="false"
>
<span class="custom-tree-node" slot-scope="{ node, data }">
<span>{{ node.label }}</span>
<span>
<el-button type="text" size="mini" v-if="node.level <=2" @click="() => append(data)">添加</el-button>
<el-button
type="text"
size="mini"
v-if="node.childNodes.length==0"
@click="() => remove(node, data)"
>删除</el-button>
</span>
</span>
</el-tree>
<!-- 添加修改窗口 -->
<el-dialog
:title="title"
:visible.sync="dialogVisible"
width="30%"
:close-on-click-modal="false"
>
<el-form :model="category">
<el-form-item label="分类名称">
<el-input v-model="category.name" autocomplete="off"></el-input>
</el-form-item>
<el-form-item label="图标">
<el-input v-model="category.icon" autocomplete="off"></el-input>
</el-form-item>
<el-form-item label="计量单位">
<el-input v-model="category.productUnit" autocomplete="off"></el-input>
</el-form-item>
</el-form>
<span slot="footer" class="dialog-footer">
<el-button @click="dialogVisible = false">取 消</el-button>
<el-button type="primary" @click="submitData">确 定</el-button>
</span>
</el-dialog>
</div>
</template>
data
data() {
return {
//树形数据
menus: [],
//默认树形
defaultProps: {
children: "children",
label: "name"
},
//默认展开数组
expandedKey: [],
//菜单对象
category: {
name: "",
parentCid: 0,
catLevel: 0,
showStatus: 1,
sort: 0,
productUnit: "",
icon: "",
catId: null
},
//动态窗口 默认关闭
dialogVisible: false,
//提交方式 edit,add
dialogType: "",
//动态窗口标题
title: ""
};
},
method
append(data) {
console.log("append", data);
this.dialogType = "add";
this.title = "添加分类";
this.dialogVisible = true;
this.category.parentCid = data.catId;
this.category.catLevel = data.catLevel * 1 + 1;
this.category.catId = null;
this.category.name = "";
this.category.icon = "";
this.category.productUnit = "";
this.category.sort = 0;
this.category.showStatus = 1;
},
//添加三级分类
addCategory() {
console.log("提交的三级分类数据", this.category);
this.$http({
url: this.$http.adornUrl("/product/category/save"),
method: "post",
data: this.$http.adornData(this.category, false)
}).then(({ data }) => {
this.$message({
message: "菜单保存成功",
type: "success"
});
//关闭对话框
this.dialogVisible = false;
//刷新出新的菜单
this.getMenus();
//设置需要默认展开的菜单
this.expandedKey = [this.category.parentCid];
});
},
//提交数据
submitData() {
if (this.dialogType == "add") {
this.addCategory();
}
if (this.dialogType == "edit") {
this.editCategory();
}
}
后端代码
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody CategoryEntity category) {
categoryService.save(category);
return R.ok();
}
这里插入时mysql乱码,排除数据库编码无问题,mysql连接配置问题,需在配置文件数据源配置中添加?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8
例如:
url: jdbc:mysql://localhost/数据库名?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8
商城三级分类修改
前端代码
修改按钮
<el-button type="text" size="mini" @click="edit(data)">修改</el-button>
动态窗口还是新增的动态窗口,但需要回显。当点击修改按钮,打开弹窗,同时发送请求回显数据
method
edit(data) {
console.log("要修改的数据", data);
this.dialogType = "edit";
this.title = "修改分类";
this.dialogVisible = true;
//发送请求获取当前节点最新的数据
this.$http({
url: this.$http.adornUrl(`/product/category/info/${data.catId}`),
method: "get"
}).then(({ data }) => {
//请求成功 回显
console.log("要回显的数据", data);
this.category.name = data.data.name;
this.category.catId = data.data.catId;
this.category.icon = data.data.icon;
this.category.productUnit = data.data.productUnit;
this.category.parentCid = data.data.parentCid;
this.category.catLevel = data.data.catLevel;
this.category.sort = data.data.sort;
this.category.showStatus = data.data.showStatus;
});
},
修改,点击确认,判断dialogType
//确认 提交数据
submitData() {
if (this.dialogType == "add") {
this.addCategory();
}
if (this.dialogType == "edit") {
this.editCategory();
}
}
修改
//修改三级分类数据
editCategory() {
var { catId, name, icon, productUnit } = this.category;
this.$http({
url: this.$http.adornUrl("/product/category/update"),
method: "post",
data: this.$http.adornData({ catId, name, icon, productUnit }, false)
}).then(({ data }) => {
this.$message({
message: "菜单修改成功",
type: "success"
});
//关闭对话框
this.dialogVisible = false;
//刷新出新的菜单
this.getMenus();
//设置需要默认展开的菜单
this.expandedKey = [this.category.parentCid];
});
},
后端代码
/**
* 信息
*/
@RequestMapping("/info/{catId}")
public R info(@PathVariable("catId") Long catId) {
CategoryEntity category = categoryService.getById(catId);
return R.ok().put("data", category);
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody CategoryEntity category) {
categoryService.updateById(category);
return R.ok();
}
商城三级分类拖拽修改
前端代码
树形结构添加 draggable 属性和添加选择是否拖拽功能和node-drop 拖拽成功完成时触发的事件
<el-switch v-model="draggable" active-text="开启拖拽" inactive-text="关闭拖拽"></el-switch>
<el-tree
:data="menus"
:props="defaultProps"
show-checkbox
node-key="catId"
:default-expanded-keys="expandedKey"
:expand-on-click-node="false"
:draggable="draggable"
:allow-drop="allowDrop"
@node-drop="handleDrop"
>
<span class="custom-tree-node" slot-scope="{ node, data }">
<span>{{ node.label }}</span>
<span>
<el-button type="text" size="mini" v-if="node.level <=2" @click="() => append(data)">添加</el-button>
<el-button type="text" size="mini" @click="edit(data)">修改</el-button>
<el-button
type="text"
size="mini"
v-if="node.childNodes.length==0"
@click="() => remove(node, data)"
>删除</el-button>
</span>
</span>
</el-tree>
data添加
//拖拽节点功能
draggable: false,
//初始化节点层级深度
maxLevel: 0,
//当前节点的夫节点
pCid: [],
//拖拽要修改的节点
updateNodes: []
method
//拖拽节点判断目标节点能否被放置
//draggingNode:当前节点,dropNode;目标节点
//type:三种情况,“prev”目标节点前,”inner“插入至目标节点,”next“放置在目标节点后
allowDrop(draggingNode, dropNode, type) {
//1、被拖动的当前节点以及所在的父节点总层数不能大于3
//1)、被拖动的当前节点总层数
console.log("allowDrop:", draggingNode, dropNode, type);
//计算当前节点所在层级深度
this.countNodeLevel(draggingNode);
//当前正在拖动的节点+父节点所在的深度不大于3即可
let deep = Math.abs(this.maxLevel - draggingNode.level) + 1;
console.log("深度:", deep);
if (type == "inner") {
return deep + dropNode.level <= 3;
} else {
return deep + dropNode.parent.level <= 3;
}
},
//计算当前节点所在层级深度
countNodeLevel(node) {
//找到所有子节点,求出最大深度
if (node.childNodes != null && node.childNodes.length > 0) {
for (let i = 0; i < node.childNodes.length; i++) {
if (node.childNodes[i].level > this.maxLevel) {
//当前节点层级深度等于子节点数据库中层级
this.maxLevel = node.childNodes[i].level;
}
//递归
this.countNodeLevel(node.childNodes[i]);
}
}
},
//node-drop 拖拽成功完成时触发的事件
//共四个参数,依次为:被拖拽节点对应的 Node、结束拖拽时最后进入的节点、被拖拽节点的放置位置(before、after、inner)、event事件
handleDrop(draggingNode, dropNode, dropType, ev) {
console.log("handleDrop: ", draggingNode, dropNode, dropType);
//1、当前节点最新的父节点id
let pCid = 0;
//子节点
let siblings = null;
if (dropType == "before" || dropType == "after") {
pCid =
dropNode.parent.data.catId == undefined
? 0
: dropNode.parent.data.catId;
siblings = dropNode.parent.childNodes;
} else {
pCid = dropNode.data.catId;
siblings = dropNode.childNodes;
}
//push() 方法可向数组的末尾添加一个或多个元素,并返回新的长度
this.pCid.push(pCid);
//2、当前拖拽节点的最新顺序,
for (let i = 0; i < siblings.length; i++) {
if (siblings[i].data.catId == draggingNode.data.catId) {
//如果遍历的是当前正在拖拽的节点
let catLevel = draggingNode.level;
if (siblings[i].level != draggingNode.level) {
//当前节点的层级发生变化
catLevel = siblings[i].level;
//修改他子节点的层级
this.updateChildNodeLevel(siblings[i]);
}
this.updateNodes.push({
catId: siblings[i].data.catId,
sort: i,
parentCid: pCid,
catLevel: catLevel
});
} else {
this.updateNodes.push({ catId: siblings[i].data.catId, sort: i });
}
}
//3、当前拖拽节点的最新层级
console.log("updateNodes", this.updateNodes);
//修改数据
this.$http({
url: this.$http.adornUrl("/product/category/update/sort"),
method: "post",
data: this.$http.adornData(this.updateNodes, false)
}).then(({ data }) => {
this.$message({
message: "菜单顺序修改成功",
type: "success"
});
//刷新出新的菜单
this.getMenus();
//设置需要默认展开的菜单
this.expandedKey = [pCid];
//修改完顺序应清空数据 层级和修改数据
this.maxLevel = 0,
//拖拽要修改的节点
this.updateNodes = [];
});
},
updateChildNodeLevel(node) {
if (node.childNodes.length > 0) {
for (let i = 0; i < node.childNodes.length; i++) {
var cNode = node.childNodes[i].data;
this.updateNodes.push({
catId: cNode.catId,
catLevel: node.childNodes[i].level
});
this.updateChildNodeLevel(node.childNodes[i]);
}
}
}
后端代码
/**
* 批量修改
*/
@RequestMapping("/update/sort")
public R updateSort(@RequestBody CategoryEntity[] category) {
categoryService.updateBatchById(Arrays.asList(category));
return R.ok();
}
商城三级分类批量保存
前端代码
<el-button v-if="draggable" @click="batchSave">批量保存</el-button>
method
将开始拖拽成功修改请求删除,只有当点击保存按钮才进行修改请求
//批量保存
batchSave() {
this.$http({
url: this.$http.adornUrl("/product/category/update/sort"),
method: "post",
data: this.$http.adornData(this.updateNodes, false)
}).then(({ data }) => {
this.$message({
message: "菜单顺序等修改成功",
type: "success"
});
//刷新出新的菜单
this.getMenus();
//设置需要默认展开的菜单
this.expandedKey = this.pCid;
this.updateNodes = [];
this.maxLevel = 0;
// this.pCid = 0;
});
}
后端代码
/**
* 批量修改
*/
@RequestMapping("/update/sort")
public R updateSort(@RequestBody CategoryEntity[] category) {
categoryService.updateBatchById(Arrays.asList(category));
return R.ok();
}
商城三级分类批量删除
前端代码
删除按钮
<el-button type="danger" @click="batchDelete">批量删除</el-button>
数组件添加唯一标识 ref
<el-tree
:data="menus"
:props="defaultProps"
show-checkbox
node-key="catId"
:default-expanded-keys="expandedKey"
:expand-on-click-node="false"
:draggable="draggable"
:allow-drop="allowDrop"
@node-drop="handleDrop"
ref="menuTree"
>
<span class="custom-tree-node" slot-scope="{ node, data }">
<span>{{ node.label }}</span>
<span>
<el-button type="text" size="mini" v-if="node.level <=2" @click="() => append(data)">添加</el-button>
<el-button type="text" size="mini" @click="edit(data)">修改</el-button>
<el-button
type="text"
size="mini"
v-if="node.childNodes.length==0"
@click="() => remove(node, data)"
>删除</el-button>
</span>
</span>
</el-tree>
method
batchDelete() {
let catIds = [];
let names = [];
//getCheckedNodes()返回目前被选中的节点所组成的数组
let checkedNodes = this.$refs.menuTree.getCheckedNodes();
console.log("被选中的元素", checkedNodes);
for (let i = 0; i < checkedNodes.length; i++) {
catIds.push(checkedNodes[i].catId);
names.push(checkedNodes[i].name);
}
this.$confirm(`是否批量删除【${names}】菜单?`, "提示", {
confirmButtonText: "确定",
cancelButtonText: "取消",
type: "warning"
})
.then(() => {
this.$http({
url: this.$http.adornUrl("/product/category/delete"),
method: "post",
data: this.$http.adornData(catIds, false)
}).then(({ data }) => {
this.$message({
message: "菜单批量删除成功",
type: "success"
});
this.getMenus();
});
})
.catch(() => {});
}
后端代码
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] catIds) {
categoryService.removeMenusByIds(Arrays.asList(catIds));
return R.ok();
}