TienChin 活动管理-活动导出

合集 - TienChin(49)

1.TienChin 开篇-运行 RuoYiVue2023-06-112.TienChin 代码格式化-项目结构大改造2023-06-153.TienChin 项目改造完善&项目结构分析2023-06-224.TienChin 验证码响应结果分析&验证码生成接口分析2023-06-225.TienChin 运行 RuoYi-Vue32023-08-126.TienChin-系统功能介绍2023-07-177.TienChin 新建业务菜单2023-08-128.TienChin 创建菜单页面2023-08-159.TienChin 引入 MyBatisPlus2023-08-1510.TienChin 渠道管理-表创建2023-08-1911.TienChin 渠道管理-渠道类型2023-08-2012.TienChin 渠道管理-工程创建2023-08-2213.TienChin 渠道管理-查看渠道接口2023-08-2914.TienChin 渠道管理-前端展示渠道信息2023-09-1715.TienChin 渠道管理-配置字典常量2023-09-1716.TienChin 渠道管理-字典原理分析2023-09-1717.TienChin 渠道管理-权限分配2023-09-1718.TienChin 渠道管理-添加渠道2023-09-1719.TienChin 渠道管理-配置校验失败信息2023-09-1720.TienChin 渠道管理-添加渠道页面开发2023-09-1721.TienChin 渠道管理-更新渠道接口开发2023-09-1722.TienChin 渠道管理-删除渠道2023-09-1723.TienChin 渠道管理-渠道搜索2023-09-1724.TienChin 渠道管理-渠道导出2023-09-1725.TienChin 渠道管理-渠道导入2023-09-1726.TienChin 渠道管理-渠道页面完善2023-09-1727.TienChin 活动管理-准备工作2023-09-1728.TienChin 活动管理-工程创建2023-09-2229.TienChin 活动管理-活动列表展示2023-09-2230.TienChin 活动管理-活动状态完善2023-09-2231.TienChin 活动管理-添加活动页面2023-09-2232.TienChin 活动管理-添加活动接口2023-09-2233.TienChin 活动管理-设置活动的默认状态2023-09-2334.TienChin 活动管理-完成添加活动2023-09-2235.TienChin 活动管理-修改活动接口2023-09-2236.TienChin 活动管理-修改活动2023-09-2237.TienChin 活动管理-删除活动2023-09-2238.TienChin 活动管理-搜索活动2023-09-23

39.TienChin 活动管理-活动导出2023-09-23

40.TienChin-课程管理-数据表创建2023-09-2341.TienChin-课程管理-创建工程2023-09-2342.TienChin-课程管理-配置课程字典2023-09-2343.TienChin-课程管理-展示课程列表2023-09-2444.TienChin-课程管理-添加课程接口2023-09-2445.TienChin-课程管理-添加课程页面2023-09-2446.TienChin-课程管理-课程更新接口2023-09-2447.TienChin-课程管理-删除课程2023-09-2448.TienChin-课程管理-课程搜索2023-09-2549.TienChin-课程管理-课程导出2023-09-25

收起

ActivityController

/**
 * 导出活动列表
 */
@PreAuthorize("hasPermission('tienchin:activity:export')")
@Log(title = "渠道管理", businessType = BusinessType.EXPORT)
@PostMapping("/export")
public void export(HttpServletResponse response, ActivityVO activityVO) {
    List<ActivityVO> activityVOList = iActivityService.selectActivityList(activityVO);
    ExcelUtil<ActivityVO> util = new ExcelUtil<>(ActivityVO.class);
    util.exportExcel(response, activityVOList, "活动数据");
}

ActivityVO.java

/**
 * 活动ID
 */
@NotNull(message = "{activity.id.notnull}", groups = {EditGroup.class})
@Excel(name = "活动ID")
private Integer activityId;

/**
 * 活动名称
 */
@NotBlank(message = "{activity.name.notBlank}", groups = {EditGroup.class, CreateGroup.class})
@Size(max = 20, message = "{activity.name.size}", groups = {EditGroup.class, CreateGroup.class})
@Excel(name = "活动名称")
private String activityName;

/**
 * 渠道ID
 */
@NotNull(message = "{activity.channelId.notnull}", groups = {EditGroup.class, CreateGroup.class})
@Excel(name = "渠道ID")
private Integer channelId;

/**
 * 渠道名称
 */
@Excel(name = "渠道名称")
private String channelName;

/**
 * 活动简介
 */
@NotBlank(message = "{activity.info.notBlank}", groups = {EditGroup.class, CreateGroup.class})
@Size(max = 255, message = "{activity.info.size}", groups = {EditGroup.class, CreateGroup.class})
@Excel(name = "活动简介")
private String activityInfo;

/**
 * 活动类型，1.折扣券、2.代金券
 */
@NotNull(message = "{activity.type.notnull}", groups = {EditGroup.class, CreateGroup.class})
@Excel(name = "活动类型", readConverterExp = "1=折扣券,2=代金券")
private Integer activityType;

/**
 * 活动状态，0.表示过期、1.表示正常
 */
@Max(value = 1, message = "{activity.status.max}", groups = {EditGroup.class, CreateGroup.class})
@Min(value = 0, message = "{activity.status.min}", groups = {EditGroup.class, CreateGroup.class})
@Excel(name = "活动状态", readConverterExp = "0=过期,1=正常")
private Integer activityStatus;

/**
 * 折扣券
 */
@Excel(name = "活动折扣")
@Max(value = 10, message = "{activity.discount.max}", groups = {EditGroup.class, CreateGroup.class})
@Min(value = 0, message = "{activity.discount.min}", groups = {EditGroup.class, CreateGroup.class})
private Double discount;

/**
 * 代金券
 */
@Excel(name = "代金券面值")
@Min(value = 0, message = "{activity.voucher.min}", groups = {EditGroup.class, CreateGroup.class})
private Double voucher;

/**
 * 活动开始时间
 */
@NotNull(message = "{activity.beginTime.notnull}", groups = {EditGroup.class, CreateGroup.class})
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "Asia/Shanghai")
@Excel(name = "活动开始时间", dateFormat = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime beginTime;

/**
 * 活动结束时间
 */
@NotNull(message = "{activity.endTime.notnull}", groups = {EditGroup.class, CreateGroup.class})
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "Asia/Shanghai")
@Excel(name = "活动结束时间", dateFormat = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime endTime;

/**
 * 备注
 */
@Excel(name = "活动备注")
private String remark;