瑞吉外卖项目学习笔记:P15-新增套餐功能开发
1.需求分析
1.1页面分析
套餐就是菜品的集合。
- 后台系统中可以管理套餐信息,通过新增套餐功能来添加一个新的套餐,在添加套餐时需要选择当前套餐所属的套餐分类和包含的菜品,并且需要上传套餐对应的图片
- 在移动端会按照套餐分类来展示对应的套餐。
1.2 数据模型
新增套餐,其实就是将新增页面录入的套餐信息插入到setmeal表,还需要向setmeal _dish表插入套餐和菜品关联数据。
所以在新增套餐时,涉及到两个表:
- setmeal 套餐表
- setmeal _dish 套餐菜品关系表
2.代码开发
2.1前后端交互流程分析
-
页面(backend/ page/combo/ add.html)发送ajax请求,请求服务端获取套餐分类数据并展示到下拉框中
-
页面发送ajax请求,请求服务端获取菜品分类数据并展示到添加菜品窗口中
-
页面发送ajax请求,请求服务端,根据菜品分类查询对应的菜品数据并展示到添加菜品窗口中
-
页面发送请求进行图片上传,请求服务端将图片保存到服务器
-
页面发送请求进行图片下载,将上传的图片进行回显
-
点击保存按钮,发送ajax请求,将套餐相关数据以json形式提交到服务端
开发新增套餐功能,其实就是在服务端编写代码去处理前端页面发送的这6次请求即可。
2.1前端代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Document</title>
<!-- 引入样式 -->
<link rel="stylesheet" href="../../plugins/element-ui/index.css" />
<link rel="stylesheet" href="../../styles/common.css" />
<link rel="stylesheet" href="../../styles/page.css" />
<style>
.addDish .el-input {
width: 130px;
}
.addDish .el-input-number__increase {
border-left: solid 1px #FFE1CA;
background: #fff3ea;
}
.addDish .el-input-number__decrease {
border-right: solid 1px #FFE1CA;
background: #fff3ea;
}
.addDish input {
border: 1px solid #ffe1ca;
}
.addDish .table {
border: solid 1px #EBEEF5;
border-radius: 3px;
}
.addDish .table th {
padding: 5px 0;
}
.addDish .table td {
padding: 7px 0;
}
.addDishList .seachDish {
position: absolute;
top: 10px;
right: 20px;
}
.addDishList .el-dialog__body {
padding: 0;
border-bottom: solid 1px #ccc;
}
.addDishList .el-dialog__footer {
padding-top: 27px;
}
.addDish {
width: 777px;
}
.addDish .addBut {
background: #ffc200;
display: inline-block;
padding: 0px 20px;
border-radius: 3px;
line-height: 40px;
cursor: pointer;
border-radius: 4px;
color: #333333;
font-weight: 500;
}
.addDish .content {
background: #fafafb;
padding: 20px;
border: solid 1px #ccc;
border-radius: 3px;
}
.addDishCon {
padding: 0 20px;
display: flex;
line-height: 40px;
}
.addDishCon .leftCont {
display: flex;
border-right: solid 2px #E4E7ED;
width: 60%;
padding: 15px;
}
.addDishCon .leftCont .tabBut {
width: 110px;
}
.addDishCon .leftCont .tabBut span {
display: block;
text-align: center;
border-right: solid 2px #f4f4f4;
cursor: pointer;
}
.addDishCon .leftCont .act {
border-color: #FFC200 !important;
color: #FFC200 !important;
}
.addDishCon .leftCont .tabList {
flex: 1;
padding: 15px;
}
.addDishCon .leftCont .tabList .table {
border: solid 1px #f4f4f4;
border-bottom: solid 1px #f4f4f4;
}
.addDishCon .leftCont .tabList .table .items {
border-bottom: solid 1px #f4f4f4;
padding: 0 10px;
display: flex;
}
.addDishCon .leftCont .tabList .table .items .el-checkbox, .addDishCon .leftCont .tabList .table .items .el-checkbox__label {
width: 100%;
}
.addDishCon .leftCont .tabList .table .items .item {
display: flex;
padding-right: 20px;
}
.addDishCon .leftCont .tabList .table .items .item span {
display: inline-block;
text-align: center;
flex: 1;
}
.addDishCon .ritCont {
width: 40%;
padding: 0 15px;
}
.addDishCon .ritCont .item {
box-shadow: 0px 1px 4px 3px rgba(0, 0, 0, 0.03);
display: flex;
text-align: center;
padding: 0 10px;
margin-bottom: 20px;
border-radius: 6px;
color: #818693;
}
.addDishCon .ritCont .item span:first-child {
text-align: left;
color: #20232A;
}
.addDishCon .ritCont .item .price {
display: inline-block;
flex: 1;
}
.addDishCon .ritCont .item .del {
cursor: pointer;
}
.addDishCon .ritCont .item .del img {
position: relative;
top: 5px;
width: 20px;
}
.addDishCon .el-checkbox__label{
width: 100%;
}
#combo-add-app .setmealFood .el-form-item__label::before{
content: '*';
color: #F56C6C;
margin-right: 4px;
}
#combo-add-app .uploadImg .el-form-item__label::before{
content: '*';
color: #F56C6C;
margin-right: 4px;
}
</style>
</head>
<body>
<div class="addBrand-container" id="combo-add-app">
<div class="container">
<el-form
ref="ruleForm"
:model="ruleForm"
:rules="rules"
:inline="true"
label-width="180px"
class="demo-ruleForm"
>
<div>
<el-form-item label="套餐名称:" prop="name" >
<el-input v-model="ruleForm.name" placeholder="请填写套餐名称" maxlength="20"/>
</el-form-item>
<el-form-item label="套餐分类:" prop="idType">
<el-select v-model="ruleForm.idType" placeholder="请选择套餐分类" @change="$forceUpdate()">
<el-option v-for="(item, index) in setMealList" :key="index" :label="item.name" :value="item.id" />
</el-select>
</el-form-item>
</div>
<div>
<el-form-item label="套餐价格:" prop="price">
<el-input v-model="ruleForm.price" placeholder="请设置套餐价格" />
</el-form-item>
</div>
<div>
<el-form-item label="套餐菜品:" class="setmealFood">
<el-form-item>
<div class="addDish">
<span v-if="dishTable.length == 0" class="addBut" @click="openAddDish"> + 添加菜品</span>
<div v-if="dishTable.length != 0" class="content">
<div class="addBut" style="margin-bottom: 20px" @click="openAddDish">+ 添加菜品</div>
<div class="table">
<el-table :data="dishTable" style="width: 100%">
<el-table-column prop="name" label="名称" width="180" align="center"></el-table-column>
<el-table-column prop="price" label="原价" width="180">
<template slot-scope="scope"> {{ Number(scope.row.price) / 100 }} </template>
</el-table-column>
<el-table-column prop="address" label="份数" align="center">
<template slot-scope="scope">
<el-input-number
v-model="scope.row.copies"
size="small"
:min="1"
:max="99"
label="描述文字"
></el-input-number>
</template>
</el-table-column>
<el-table-column prop="address" label="操作" width="180px;" align="center">
<template slot-scope="scope">
<el-button type="text" size="small" @click="delDishHandle(scope.$index)"> 删除 </el-button>
</template>
</el-table-column>
</el-table>
</div>
</div>
</div>
</el-form-item>
</el-form-item>
</div>
<div>
<el-form-item label="套餐图片:" class="uploadImg">
<el-upload
class="avatar-uploader"
action="/common/upload"
:show-file-list="false"
:on-success="handleAvatarSuccess"
:on-change="onChange"
ref="upload"
>
<img v-if="imageUrl" :src="imageUrl" class="avatar"></img>
<i v-else class="el-icon-plus avatar-uploader-icon"></i>
</el-upload>
</el-form-item>
</div>
<div class="address">
<el-form-item label="套餐描述:">
<el-input v-model="ruleForm.description" type="textarea" :rows="3" placeholder="套餐描述,最长200字" maxlength="200"/>
</el-form-item>
</div>
<div class="subBox address">
<el-form-item>
<el-button @click="goBack()"> 取消 </el-button>
<el-button type="primary" @click="submitForm('ruleForm', false)"> 保存 </el-button>
<el-button
v-if="actionType == 'add'"
type="primary"
class="continue"
@click="submitForm('ruleForm', true)"
>
保存并继续添加套餐
</el-button>
</el-form-item>
</div>
</el-form>
</div>
<el-dialog
title="添加菜品"
class="addDishList"
:visible.sync="dialogVisible"
width="60%"
:before-close="handleClose"
>
<el-input
v-model="value"
class="seachDish"
placeholder="请输入菜品名称进行搜索"
style="width: 250px"
size="small"
clearable
>
<i slot="prefix" class="el-input__icon el-icon-search" style="cursor: pointer" @click="seachHandle"></i>
</el-input>
<!-- <AddDish ref="adddish" :check-list="checkList" :seach-key="seachKey" @checkList="getCheckList" /> -->
<div class="addDishCon">
<div class="leftCont">
<div
v-show="seachKey.trim() == ''"
class="tabBut"
>
<span
v-for="(item, index) in dishType"
:key="index"
:class="{act:index == keyInd}"
@click="checkTypeHandle(index, item.id)"
>{{ item.name }}</span>
</div>
<div class="tabList">
<div class="table">
<div v-if="dishAddList.length == 0" style="padding-left:10px">
暂无菜品!
</div>
<el-checkbox-group
v-if="dishAddList.length > 0"
v-model="checkedList"
@change="checkedListHandle"
>
<div
v-for="(item, index) in dishAddList"
:key="index"
class="items"
>
<el-checkbox
:key="index"
:label="item"
>
<div class="item">
<span style="flex: 3;text-align: left">{{ item.dishName }}</span>
<span>{{ item.status == 0 ? '停售' : '在售' }}</span>
<span>{{ Number(item.price)/100 }}</span>
</div>
</el-checkbox>
</div>
</el-checkbox-group>
</div>
</div>
</div>
<div class="ritCont">
<div class="tit">
已选菜品({{ checkedList.length }})
</div>
<div class="items">
<div
v-for="(item, ind) in checkedList"
:key="ind"
class="item"
>
<span>{{ item.dishName }}</span>
<span class="price">¥ {{ Number(item.price)/100 }} </span>
<span
class="del"
@click="delCheck(ind)"
>
<img
src="../../images/icons/btn_clean@2x.png"
alt=""
>
</span>
</div>
</div>
</div>
</div>
<span slot="footer" class="dialog-footer">
<el-button @click="handleClose">取 消</el-button>
<el-button type="primary" @click="addTableList">确 定</el-button>
</span>
</el-dialog>
</div>
<!-- 开发环境版本,包含了有帮助的命令行警告 -->
<script src="../../plugins/vue/vue.js"></script>
<!-- 引入组件库 -->
<script src="../../plugins/element-ui/index.js"></script>
<!-- 引入axios -->
<script src="../../plugins/axios/axios.min.js"></script>
<script src="../../js/request.js"></script>
<script src="../../api/combo.js"></script>
<script src="../../js/validate.js"></script>
<script src="../../js/index.js"></script>
<script src="../../api/food.js"></script>
<script>
new Vue({
el: '#combo-add-app',
data() {
return {
id: '',
actionType: '',
value: '',
setMealList: [],
seachKey: '',
dishList: [],
imageUrl: '',
actionType: '',
dishTable: [],
dialogVisible: false,
checkList: [],
ruleForm: {
name: '',
categoryId: '',
price: '',
code: '',
image: '',
description: '',
dishList: [],
status: true,
idType: '',
},
dishType: [],
dishAddList: [],
dishListCache: [],
keyInd : 0,
searchValue: '',
checkedList: []
}
},
computed: {
rules() {
return {
name: {
required: true,
message: '请输入套餐名称',
trigger: 'blur',
},
idType: {
required: true,
message: '请选择套餐分类',
trigger: 'change',
},
price: {
required: true,
// 'message': '请输入套餐价格',
validator: (rules, value, callback) => {
if (!value) {
callback(new Error('请填写菜品价格'))
} else {
const reg = /^\d+(\.\d{0,2})?$/
if (reg.test(value)) {
if(value < 10000){
callback()
}else{
callback(new Error('菜品价格小于10000'))
}
} else {
callback(new Error('菜品价格格式只能为数字,且最多保留两位小数'))
}
}
},
trigger: 'blur',
},
}
},
},
watch:{
seachKey(value){
if (value.trim()){
this.getDishForName(this.seachKey)
}
},
checkList(value){
this.checkedList = value
}
},
created() {
this.getDishTypeList()
this.getDishType()
this.id = requestUrlParam('id')
this.actionType = this.id ? 'edit' : 'add'
if (this.id) {
this.init()
}
},
mounted() {},
methods: {
async init() {
querySetmealById(this.id).then((res) => {
if (String(res.code) === '1') {
this.ruleForm = res.data
this.ruleForm.status = res.data.status === '1'
this.ruleForm.price = res.data.price / 100
this.imageUrl = `/common/download?name=${res.data.image}`
this.checkList = res.data.setmealDishes
this.dishTable = res.data.setmealDishes
this.ruleForm.idType = res.data.categoryId
// this.ruleForm.password = ''
} else {
this.$message.error(res.msg || '操作失败')
}
})
},
seachHandle() {
this.seachKey = this.value
},
// 获取套餐分类
getDishTypeList() {
getCategoryList({ type: 2, page: 1, pageSize: 1000 }).then((res) => {
if (res.code === 1) {
this.setMealList = res.data.map((obj) => ({ ...obj, idType: obj.id }))
} else {
this.$message.error(res.msg || '操作失败')
}
})
},
// 删除套餐菜品
delDishHandle(index) {
this.dishTable.splice(index, 1)
this.checkList.splice(index, 1)
},
// 获取添加菜品数据
getCheckList(value) {
this.checkList = [...value]
},
// 添加菜品
openAddDish() {
this.seachKey = ''
this.dialogVisible = true
//搜索条件清空,菜品重新查询,菜品类别选第一个重新查询
this.value = ''
this.keyInd = 0
this.getDishList(this.dishType[0].id)
},
// 取消添加菜品
handleClose(done) {
// this.$refs.adddish.close()
this.dialogVisible = false
// this.checkList = JSON.parse(JSON.stringify(this.dishTable))
// this.dialogVisible = false
},
// 保存添加菜品列表
addTableList() {
this.dishTable = JSON.parse(JSON.stringify(this.checkList))
this.dishTable.forEach((n) => {
n.copies = 1
})
this.dialogVisible = false
// 添加处理逻辑清空选中list
this.checkList = []
},
submitForm(formName, st) {
this.$refs[formName].validate((valid) => {
if (valid) {
let prams = { ...this.ruleForm }
prams.price *= 100
prams.setmealDishes = this.dishTable.map((obj) => ({
copies: obj.copies,
dishId: obj.dishId,
name: obj.name,
price: obj.price,
}))
prams.status = this.ruleForm ? 1 : 0
prams.categoryId = this.ruleForm.idType
if(prams.setmealDishes.length < 1){
this.$message.error('请选择菜品!')
return
}
if(!this.imageUrl){
this.$message.error('请上传套餐图片')
return
}
// delete prams.dishList
if (this.actionType == 'add') {
delete prams.id
addSetmeal(prams)
.then((res) => {
if (res.code === 1) {
this.$message.success('套餐添加成功!')
if (!st) {
this.goBack()
} else {
this.$refs.ruleForm.resetFields()
this.dishList = []
this.dishTable = []
this.ruleForm = {
name: '',
categoryId: '',
price: '',
code: '',
image: '',
description: '',
dishList: [],
status: true,
id: '',
idType: '',
}
this.imageUrl = ''
}
} else {
this.$message.error(res.msg || '操作失败')
}
})
.catch((err) => {
this.$message.error('请求出错了:' + err)
})
} else {
delete prams.updateTime
editSetmeal(prams)
.then((res) => {
if (res.code === 1) {
this.$message.success('套餐修改成功!')
this.goBack()
} else {
this.$message.error(res.msg || '操作失败')
}
})
.catch((err) => {
this.$message.error('请求出错了:' + err)
})
}
} else {
return false
}
})
},
handleAvatarSuccess (response, file, fileList) {
// this.imageUrl = response.data
if(response.code === 0 && response.msg === '未登录'){
window.top.location.href = '/backend/page/login/login.html'
}else{
this.imageUrl = `/common/download?name=${response.data}`
this.ruleForm.image = response.data
}
},
onChange (file) {
if(file){
const suffix = file.name.split('.')[1]
const size = file.size / 1024 / 1024 < 2
if(['png','jpeg','jpg'].indexOf(suffix) < 0){
this.$message.error('上传图片只支持 png、jpeg、jpg 格式!')
this.$refs.upload.clearFiles()
return false
}
if(!size){
this.$message.error('上传文件大小不能超过 2MB!')
return false
}
return file
}
},
goBack() {
window.parent.menuHandle(
{
id: '5',
url: '/backend/page/combo/list.html',
name: '套餐管理',
},
false
)
},
// 获取套餐分类
getDishType () {
getCategoryList({'type':1}).then(res => {
if (res.code === 1) {
this.dishType = res.data
this.getDishList(res.data[0].id)
} else {
this.$message.error(res.msg)
}
})
},
// 通过套餐ID获取菜品列表分类
getDishList (id) {
queryDishList({categoryId: id}).then(res => {
if (res.code === 1) {
if (res.data.length == 0) {
this.dishAddList = []
return
}
let newArr = res.data;
newArr.forEach((n) => {
n.dishId = n.id
n.copies = 1
// n.dishCopies = 1
n.dishName = n.name
})
this.dishAddList = newArr
} else {
this.$message.error(res.msg)
}
})
},
// 关键词收搜菜品列表分类
getDishForName (name) {
queryDishList({name}).then(res => {
if (res.code === 1) {
let newArr = res.data
newArr.forEach((n) => {
n.dishId = n.id
n.dishName = n.name
})
this.dishAddList = newArr
} else {
this.$message.error(res.msg)
}
})
},
checkTypeHandle (ind,id) {
this.keyInd = ind
this.getDishList(id)
},
checkedListHandle (value) {
this.getCheckList(this.checkedList)
},
open (done) {
this.dishListCache = JSON.parse(JSON.stringify(this.checkList))
},
close (done) {
this.checkList = this.dishListCache
},
// 删除
delCheck (ind){
this.checkedList.splice(ind, 1)
}
},
})
</script>
</body>
</html>
2.2后端代码-准备工作
2.2.1实体类SetmealDish
package com.jq.entity;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;
import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;
/**
* 套餐菜品关系
*/
@Data
public class SetmealDish implements Serializable {
private static final long serialVersionUID = 1L;
private Long id;
//套餐id
private Long setmealId;
//菜品id
private Long dishId;
//菜品名称 (冗余字段)
private String name;
//菜品原价
private BigDecimal price;
//份数
private Integer copies;
//排序
private Integer sort;
@TableField(fill = FieldFill.INSERT)
private LocalDateTime createTime;
@TableField(fill = FieldFill.INSERT_UPDATE)
private LocalDateTime updateTime;
@TableField(fill = FieldFill.INSERT)
private Long createUser;
@TableField(fill = FieldFill.INSERT_UPDATE)
private Long updateUser;
//是否删除
private Integer isDeleted;
}
2.2.2DTO SetmealDto
package com.jq.dto;
import com.jq.entity.Setmeal;
import com.jq.entity.SetmealDish;
import lombok.Data;
import java.util.List;
@Data
public class SetmealDto extends Setmeal {
private List<SetmealDish> setmealDishes;
private String categoryName;
}
2.2.3Mapper接 口SetmealDishMapper
package com.jq.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jq.entity.SetmealDish;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface SetmealDishMapper extends BaseMapper<SetmealDish> {
}
2.2.4业务层接口SetmealDishService
package com.jq.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.jq.entity.SetmealDish;
public interface SetmealDishService extends IService<SetmealDish> {
}
2.2.5业务层实现类SetmealDishServicelmpl
package com.jq.service.impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.jq.entity.SetmealDish;
import com.jq.mapper.SetmealDishMapper;
import com.jq.service.SetmealDishService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
@Slf4j
@Service
public class SetmealDishServicelmpl extends ServiceImpl<SetmealDishMapper,SetmealDish> implements SetmealDishService {
}
2.2.6控制层SetmealController
package com.jq.controller;
import com.jq.service.SetmealDishService;
import com.jq.service.SetmealService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* 套餐管理
*
*/
@RestController
@RequestMapping("/setmeal")
@Slf4j
public class SetmealController {
@Autowired
private SetmealService setmealService;
@Autowired
private SetmealDishService setmealDishService;
}
2.3后端代码-正式开发
2.3.1根据菜品分类查询对应的菜品数据并展示到添加菜品窗口中-DishController
/**
* 根据条件查询对应的菜品数据
* @param dish
* @return
*/
@GetMapping("/list")
public R<List<Dish>> list(Dish dish){
//构早查询条件
LambdaQueryWrapper<Dish>dishLambdaQueryWrapper=new LambdaQueryWrapper<>();
dishLambdaQueryWrapper.eq(dish.getCategoryId()!=null,Dish::getCategoryId,dish.getCategoryId());
//添加排序条件
dishLambdaQueryWrapper.orderByAsc(Dish::getSort).orderByDesc(Dish::getUpdateTime);
//执行查询
List<Dish> list = dishService.list(dishLambdaQueryWrapper);
return R.success(list);
}
2.3.2点击保存按钮,需要保存数据到两张表,在SetmealService中扩展方法
1.保存套餐的基本信息,操作setmeal表,执行insert操作
2.保存套餐和菜品的关联信息,操作setmeal_dish,执行insert操作
package com.jq.service.impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.jq.dto.SetmealDto;
import com.jq.entity.Setmeal;
import com.jq.entity.SetmealDish;
import com.jq.mapper.SetmealMapper;
import com.jq.service.SetmealDishService;
import com.jq.service.SetmealService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
import java.util.stream.Collectors;
@Service
@Slf4j
public class SetmealServiceImpl extends ServiceImpl<SetmealMapper, Setmeal> implements SetmealService {
@Autowired
private SetmealDishService setmealDishService;
/**
* 扩展方法,新增套餐时涉及两张表操作,套餐基本信息,菜品的关联关系
* @param setmealDto
*/
@Transactional
@Override
public void saveWithDish(SetmealDto setmealDto) {
//1.保存套餐的基本信息,操作setmeal表,执行insert操作
this.save(setmealDto);
//2.保存套餐和菜品的关联信息,操作setmeal_dish,执行insert操作
List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();
setmealDishes=setmealDishes.stream().map((item)->{
item.setSetmealId(setmealDto.getId());
return item;
}).collect(Collectors.toList());
setmealDishService.saveBatch(setmealDishes);
}
}
2.3.3点击保存按钮,SetmealController层代码
/**
* 新增套餐
* @param setmealDto
* @return
* 涉及两张表操作
*/
@PostMapping
public R<String> save(@RequestBody SetmealDto setmealDto){
log.info("套餐信息:{}",setmealDto);
setmealService.saveWithDish(setmealDto);
return R.success("新增套餐成功");
}