/**
* @author BNTang
* @version 1.0
* @description 活动管理VO
* @since 2023-23-05
**/
public class ActivityVO extends BaseEntity {
/**
* 活动ID
*/
private Integer activityId;
/**
* 活动名称
*/
private String activityName;
/**
* 渠道ID
*/
private Integer channelId;
/**
* 渠道名称
*/
private String channelName;
/**
* 活动简介
*/
private String activityInfo;
/**
* 活动类型,1.折扣券、2.代金券
*/
private Integer activityType;
/**
* 活动状态,0.表示禁用、1.表示正常
*/
private Integer activityStatus;
/**
* 折扣券
*/
private Double discount;
/**
* 代金券
*/
private Double voucher;
/**
* 活动开始时间
*/
private LocalDateTime beginTime;
/**
* 活动结束时间
*/
private LocalDateTime endTime;
/**
* 删除标志(0代表存在 2代表删除)
*/
private String delFlag;
// Get Set 方法略
}
更改 Activity 折扣券,代金券的数据类型:
/**
* 折扣券
*/
private Double discount;
/**
* 代金券
*/
private Double voucher;
/**
* <p>
* 活动管理表 前端控制器
* </p>
*
* @author BNTang
* @since 2023-09-05
*/
@RestController
@RequestMapping("/tienchin/activity")
public class ActivityController extends BaseController {
@Resource
private IActivityService iActivityService;
@PreAuthorize("hasPermission('tienchin:activity:list')")
@GetMapping("/list")
TableDataInfo list() {
startPage();
List<ActivityVO> activityList = iActivityService.selectActivityList();
return getDataTable(activityList);
}
}
插入测试数据
INSERT INTO tienchin_activity (activity_id, activity_name, channel_id, activity_info, activity_type, activity_status, discount, voucher, begin_time, end_time, remark, create_by, update_by, create_time, update_time, del_flag) VALUES (1, 'aaa', 7, '小红书推广', 1, 1, 8, null, '2023-09-05 23:53:09', '2023-11-05 23:53:17', null, null, null, null, '2023-09-05 23:53:22', '0');
/**
* <p>
* 活动管理表 服务类
* </p>
*
* @author BNTang
* @since 2023-09-05
*/
public interface IActivityService extends IService<Activity> {
/**
* 查询活动列表
*
* @return 活动列表
*/
List<ActivityVO> selectActivityList();
}
/**
* <p>
* 活动管理表 服务实现类
* </p>
*
* @author BNTang
* @since 2023-09-05
*/
@Service
public class ActivityServiceImpl
extends ServiceImpl<ActivityMapper, Activity>
implements IActivityService {
@Resource
private ActivityMapper activityMapper;
@Override
public List<ActivityVO> selectActivityList() {
return activityMapper.selectActivityList();
}
}
/**
* <p>
* 活动管理表 Mapper 接口
* </p>
*
* @author BNTang
* @since 2023-09-05
*/
public interface ActivityMapper extends BaseMapper<Activity> {
/**
* 查询活动列表
*
* @return 活动列表
*/
List<ActivityVO> selectActivityList();
}
<?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="top.it6666.activity.mapper.ActivityMapper">
<select id="selectActivityList" resultType="top.it6666.activity.entity.vo.ActivityVO">
SELECT ta.*, tc.channel_name
FROM tienchin_activity ta,
tienchin_channel tc
WHERE ta.channel_id = tc.channel_id
AND ta.del_flag = 0
</select>
</mapper>
import request from '@/utils/request'
/**
* 查询活动列表
* @param query 查询条件参数
* @returns {*} 查询结果
*/
export function listActivity(query) {
return request({
url: '/tienchin/activity/list',
method: 'get',
params: query
})
}
// 查询活动详细
export function getActivity(activityId) {
return request({
url: '/tienchin/activity/' + activityId,
method: 'get'
})
}
// 新增活动
export function addActivity(data) {
return request({
url: '/tienchin/activity',
method: 'post',
data: data
})
}
// 修改活动
export function updateActivity(data) {
return request({
url: '/tienchin/activity',
method: 'put',
data: data
})
}
// 删除活动
export function delActivity(activityIds) {
return request({
url: '/tienchin/activity/' + activityIds,
method: 'delete'
})
}
<template>
<div class="app-container">
<el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="68px">
<el-form-item label="岗位编码" prop="postCode">
<el-input
v-model="queryParams.postCode"
placeholder="请输入岗位编码"
clearable
@keyup.enter="handleQuery"
/>
</el-form-item>
<el-form-item label="岗位名称" prop="postName">
<el-input
v-model="queryParams.postName"
placeholder="请输入岗位名称"
clearable
@keyup.enter="handleQuery"
/>
</el-form-item>
<el-form-item label="状态" prop="status">
<el-select v-model="queryParams.status" placeholder="岗位状态" clearable>
<el-option
v-for="dict in sys_normal_disable"
:key="dict.value"
:label="dict.label"
:value="dict.value"
/>
</el-select>
</el-form-item>
<el-form-item>
<el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
<el-button icon="Refresh" @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="Plus"
@click="handleAdd"
v-hasPermi="['system:post:add']"
>新增
</el-button>
</el-col>
<el-col :span="1.5">
<el-button
type="success"
plain
icon="Edit"
:disabled="single"
@click="handleUpdate"
v-hasPermi="['system:post:edit']"
>修改
</el-button>
</el-col>
<el-col :span="1.5">
<el-button
type="danger"
plain
icon="Delete"
:disabled="multiple"
@click="handleDelete"
v-hasPermi="['system:post:remove']"
>删除
</el-button>
</el-col>
<el-col :span="1.5">
<el-button
type="warning"
plain
icon="Download"
@click="handleExport"
v-hasPermi="['system:post:export']"
>导出
</el-button>
</el-col>
<right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
</el-row>
<el-table v-loading="loading" :data="activityList" @selection-change="handleSelectionChange">
<el-table-column type="selection" width="55" align="center"/>
<el-table-column label="活动编号" align="center" prop="activityId"/>
<el-table-column label="活动名称" align="center" prop="activityName"/>
<el-table-column label="渠道名称" align="center" prop="channelName"/>
<el-table-column label="活动简介" :show-overflow-tooltip="true" align="center" prop="activityInfo"/>
<el-table-column label="活动类型" align="center">
<template #default="scope">
<dict-tag :options="activity_type" :value="scope.row.activityType"/>
</template>
</el-table-column>
<el-table-column label="活动明细" align="center">
<template #default="scope">
<div v-if="scope.row.activityType === 1">
折扣券/{{ scope.row.discount }}折
</div>
<div v-else>
代金券/{{ scope.row.voucher }}元
</div>
</template>
</el-table-column>
<el-table-column label="活动状态" align="center">
<template #default="scope">
<dict-tag :options="activity_status" :value="scope.row.activityStatus"/>
</template>
</el-table-column>
<el-table-column label="活动起始时间" align="center" prop="beginTime" width="180">
<template #default="scope">
<span>{{ parseTime(scope.row.beginTime) }}</span>
</template>
</el-table-column>
<el-table-column label="活动结束时间" align="center" prop="endTime" width="180">
<template #default="scope">
<span>{{ parseTime(scope.row.endTime) }}</span>
</template>
</el-table-column>
<el-table-column label="操作" align="center" class-name="small-padding fixed-width" width="150">
<template #default="scope">
<el-button
type="text"
icon="Edit"
@click="handleUpdate(scope.row)"
v-hasPermi="['system:post:edit']"
>修改
</el-button>
<el-button
type="text"
icon="Delete"
@click="handleDelete(scope.row)"
v-hasPermi="['system:post:remove']"
>删除
</el-button>
</template>
</el-table-column>
</el-table>
<pagination
v-show="total > 0"
:total="total"
v-model:page="queryParams.pageNum"
v-model:limit="queryParams.pageSize"
@pagination="getList"
/>
<!-- 添加或修改岗位对话框 -->
<el-dialog :title="title" v-model="open" width="500px" append-to-body>
<el-form ref="postRef" :model="form" :rules="rules" label-width="80px">
<el-form-item label="岗位名称" prop="postName">
<el-input v-model="form.postName" placeholder="请输入岗位名称"/>
</el-form-item>
<el-form-item label="岗位编码" prop="postCode">
<el-input v-model="form.postCode" placeholder="请输入编码名称"/>
</el-form-item>
<el-form-item label="岗位顺序" prop="postSort">
<el-input-number v-model="form.postSort" controls-position="right" :min="0"/>
</el-form-item>
<el-form-item label="岗位状态" prop="status">
<el-radio-group v-model="form.status">
<el-radio
v-for="dict in sys_normal_disable"
:key="dict.value"
:label="dict.value"
>{{ dict.label }}
</el-radio>
</el-radio-group>
</el-form-item>
<el-form-item label="备注" prop="remark">
<el-input v-model="form.remark" type="textarea" placeholder="请输入内容"/>
</el-form-item>
</el-form>
<template #footer>
<div class="dialog-footer">
<el-button type="primary" @click="submitForm">确 定</el-button>
<el-button @click="cancel">取 消</el-button>
</div>
</template>
</el-dialog>
</div>
</template>
<script setup name="Activity">
import {listPost, addPost, delPost, getPost, updatePost} from "@/api/system/post";
import {listActivity} from "@/api/tienchin/activity";
const {proxy} = getCurrentInstance();
const {
sys_normal_disable,
activity_type,
activity_status
} = proxy.useDict("sys_normal_disable", 'activity_type', 'activity_status');
const activityList = ref([]);
const open = ref(false);
const loading = ref(true);
const showSearch = ref(true);
const ids = ref([]);
const single = ref(true);
const multiple = ref(true);
const total = ref(0);
const title = ref("");
const data = reactive({
form: {},
queryParams: {
pageNum: 1,
pageSize: 10,
postCode: undefined,
postName: undefined,
status: undefined
},
rules: {
postName: [{required: true, message: "岗位名称不能为空", trigger: "blur"}],
postCode: [{required: true, message: "岗位编码不能为空", trigger: "blur"}],
postSort: [{required: true, message: "岗位顺序不能为空", trigger: "blur"}],
}
});
const {queryParams, form, rules} = toRefs(data);
/** 查询岗位列表 */
function getList() {
loading.value = true;
listActivity(queryParams.value).then(response => {
activityList.value = response.rows;
total.value = response.total;
loading.value = false;
});
}
/** 取消按钮 */
function cancel() {
open.value = false;
reset();
}
/** 表单重置 */
function reset() {
form.value = {
postId: undefined,
postCode: undefined,
postName: undefined,
postSort: 0,
status: "0",
remark: undefined
};
proxy.resetForm("postRef");
}
/** 搜索按钮操作 */
function handleQuery() {
queryParams.value.pageNum = 1;
getList();
}
/** 重置按钮操作 */
function resetQuery() {
proxy.resetForm("queryRef");
handleQuery();
}
/** 多选框选中数据 */
function handleSelectionChange(selection) {
ids.value = selection.map(item => item.postId);
single.value = selection.length != 1;
multiple.value = !selection.length;
}
/** 新增按钮操作 */
function handleAdd() {
reset();
open.value = true;
title.value = "添加岗位";
}
/** 修改按钮操作 */
function handleUpdate(row) {
reset();
const postId = row.postId || ids.value;
getPost(postId).then(response => {
form.value = response.data;
open.value = true;
title.value = "修改岗位";
});
}
/** 提交按钮 */
function submitForm() {
proxy.$refs["postRef"].validate(valid => {
if (valid) {
if (form.value.postId != undefined) {
updatePost(form.value).then(response => {
proxy.$modal.msgSuccess("修改成功");
open.value = false;
getList();
});
} else {
addPost(form.value).then(response => {
proxy.$modal.msgSuccess("新增成功");
open.value = false;
getList();
});
}
}
});
}
/** 删除按钮操作 */
function handleDelete(row) {
const postIds = row.postId || ids.value;
proxy.$modal.confirm('是否确认删除岗位编号为"' + postIds + '"的数据项?').then(function () {
return delPost(postIds);
}).then(() => {
getList();
proxy.$modal.msgSuccess("删除成功");
}).catch(() => {
});
}
/** 导出按钮操作 */
function handleExport() {
proxy.download("system/post/export", {
...queryParams.value
}, `post_${new Date().getTime()}.xlsx`);
}
getList();
</script>