1.思路
a.后台添加批量修改方法
b.使用测试工具测试接口
c.前端发送httppost请求,将收集的拖拽数据批量更新到数据库
2代码
CategoryController.java
@RequestMapping("/update/sort")
public R sort(@RequestBody CategoryEntity[] categorys){
categoryService.updateBatchById(Arrays.asList(categorys));
return R.ok();
}
category.vue
<template>
<div>
<el-tree
:data="menus"
:props="defaultProps"
:expand-on-click-node="false"
show-checkbox
node-key="catId"
:default-expanded-keys="expandedkey"
draggable
:allow-drop="allowDrop"
@node-drop="handleDrop"
>
<span class="custom-tree-node" slot-scope="{ node, data }">
<span>{{ node.label }}</span>
<span>
<el-button
v-if="node.level <= 2"
type="text"
size="mini"
@click="() => append(data)"
>Append</el-button>
<el-button type="text" size="mini" @click="() => edit(data)">Edit</el-button>
<el-button
v-if="node.childNodes.length==0"
type="text"
size="mini"
@click="() => remove(node, data)"
>Delete</el-button>
</span>
</span>
</el-tree>
<el-dialog :title="title" :visible.sync="dialogVisible" width="30%">
<el-form :model="category" label-width="80px">
<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>
<div slot="footer" class="dialog-footer">
<el-button @click="dialogVisible = false">取 消</el-button>
<el-button type="primary" @click="submitData">确 定</el-button>
</div>
</el-dialog>
</div>
</template>
<script>
export default {
components: {},
data() {
return {
updateNodes: [],
maxLevel: 0,
title: "",
dialogType: "",
dialogVisible: false,
category: {
name: "",
parentCid: 0,
catLevel: 0,
showStatus: 1,
sort: 0,
productUnit: "",
icon: "",
catId: null,
},
expandedkey: [],
menus: [],
defaultProps: {
children: "children",
label: "name",
},
};
},
methods: {
handleDrop(draggingNode, dropNode, dropType, ev) {
console.log("handleDrop: ", draggingNode, dropNode, dropType);
var pId = 0;
let siblings = null;
if (dropType == "inner") {
pId = dropNode.key;
siblings = dropNode.childNodes;
} else {
pId = dropNode.parent.key ? dropNode.parent.key : 0;
siblings = dropNode.parent.childNodes;
}
for (let i = 0; i < siblings.length; i++) {
if (siblings[i].data.catId == draggingNode.data.catId) {
if (siblings[i].level != draggingNode.level) {
updateChildNodeLevel(siblings[i]);
this.updateNodes.push({
catId: siblings[i].data.catId,
sort: i,
parentCid: pId,
catLevel: siblings[i].level,
});
} else {
this.updateNodes.push({
catId: siblings[i].data.catId,
sort: i,
parentCid: pId,
});
}
} else {
this.updateNodes.push({ catId: siblings[i].data.catId, sort: i });
}
}
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 = [pId];
this.updateNodes = [];
this.maxLevel = 0;
});
},
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]);
}
}
},
allowDrop(draggingNode, dropNode, type) {
var nodeMaxLevel = { maxLevel: draggingNode.level };
this.countNodeLevel(draggingNode, nodeMaxLevel);
var deep = nodeMaxLevel.maxLevel - draggingNode.level + 1;
var parentLevel = 0;
if (type == "inner") {
parentLevel = dropNode.level;
} else {
parentLevel = dropNode.parent.level;
}
return deep + parentLevel <= 3;
},
countNodeLevel(node, nodeMaxLevel) {
if (node.childNodes != null && node.childNodes.length > 0) {
for (let i = 0; i < node.childNodes.length; i++) {
var data = node.childNodes[i];
if (data.level > nodeMaxLevel.maxLevel) {
nodeMaxLevel.maxLevel = data.level;
}
this.countNodeLevel(data, nodeMaxLevel);
}
}
},
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];
console.log("this.expandedKey=", this.expandedkey);
});
},
addCategory() {
this.$http({
url: this.$http.adornUrl("/product/category/save"),
method: "post",
data: this.$http.adornData(this.category, false),
}).then(({ data }) => {
this.$message({
type: "success",
message: `添加菜单成功`,
});
this.dialogVisible = false;
this.getMenus();
this.expandedkey = [this.category.parentCid];
console.log("this.expandedKey", this.expandedkey);
});
},
submitData() {
console.log("submitData........");
if (this.dialogType == "add") {
this.addCategory();
}
if (this.dialogType == "edit") {
this.editCategory();
}
},
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;
console.log("this.expandedKey......", this.expandedkey);
});
},
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;
},
remove(node, data) {
console.log("remove", node, data);
var catIds = [data.catId];
this.$confirm(`确认删除【${data.name}】菜单`, "提示", {
confirmButtonText: "确定",
cancelButtonText: "取消",
type: "warning",
})
.then(({ value }) => {
this.$http({
url: this.$http.adornUrl("/product/category/delete"),
method: "post",
data: this.$http.adornData(catIds, false),
}).then(({ data }) => {
console.log("删除成功");
this.$message({
type: "success",
message: `删除【${data.name}】菜单成功`,
});
this.getMenus();
this.expandedkey = [node.parent.data.catId];
console.log("this.expandedkey", this.expandedkey);
});
})
.catch(() => {});
},
getMenus() {
this.$http({
url: this.$http.adornUrl("/product/category/list/tree"),
method: "get",
}).then(({ data }) => {
console.log("成功获取到分类数据", data);
this.menus = data.data;
});
},
},
computed: {},
watch: {},
created() {
console.log("获取到分类数据");
this.getMenus();
},
mounted() {},
beforeCreate() {},
beforeMount() {},
beforeUpdate() {},
updated() {},
beforeDestroy() {},
destroyed() {},
activated() {},
};
</script>
<style scoped>
</style>