论文(设计)的主要任务与具体要求(有实验环节的要提出主要技术指标要求) 健身俱乐部小程序总的功能模块如下: 一、用户模块。用户管理包括:用户注册、用户信息管理、 1.用户注册包括:注册账号、用户密码修改 2.用户信息管理包括:修改个人信息(头像、名称、手机号等)、查看个人信息 二、教练预约管理模块。教练预约包括预约教练、修改预约、删除预约、取消预约 三、课程管理模块。课程管理包括添加课程、修改课程、删除课程 四、消息推送功能模块。用户预约教练或者课程信息状态发生变化时系统会提醒用户,比如教练安排时间发生变化等 小程序端功能: 首页:轮播图展示、推荐教练、推荐健身信息文章 教练预约:搜索教练、预约教练、取消预约 健身课程:查看健身课程、搜索健身课程、课程预约、取消预约 我的:查看个人信息、修改个人信息、查看个人健身课程,查看预约教练 Web端功能: 轮播图管理:修改轮播图 健身信息文章管理:查询文章、添加文章、修改文章、删除文章 用户管理模块:用户查询、删除用户 教练管理模块:查询教练、添加教练、修改教练信息、删除教练信息 课程管理模块:查询课程、添加课程、修改课程信息、删除课程信息 主要技术指标要求 1、 开发工具与技术:IntelliJ IDEA,微信开发者工具;Spring+Spring MVC+MyBatis 2、 数据库:MySQL5.7 3、 Web服务器:Tomcat8 4、 平台:Windows 10 | ||||||||||||||||||
进度安排(包括时间划分和各阶段主要工作内容)
|
【593】基于微信小程序的ssm运动健身俱乐部平台的设计与实现
package com.vacomall.controller.web;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.vacomall.common.anno.Log;
import com.vacomall.common.bean.Rest;
import com.vacomall.common.controller.SuperController;
import com.vacomall.common.util.MIniUtil;
import com.vacomall.entity.*;
import com.vacomall.service.*;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
/**
* <p>
* 教练预约管理 前端控制器
* </p>
*
*/
@Controller
@RequestMapping("/subjectsmake")
public class SubjectsmakeController extends SuperController {
@Autowired
private ISubjectsmakeService iSubjectsmakeService;
@Autowired
private ISubjectsmakedetailService iSubjectsmakedetailService;
@Autowired
private ISubjectsService iSubjectsService;
@Autowired
private ICoachService iCoachService;
@Autowired
private IMemberService iMemberService;
@Autowired
private JdbcTemplate jdbcTemplate;
/**
* 查询
*/
@RequestMapping("/list/{pageNumber}")
public String list(@PathVariable Integer pageNumber, @RequestParam(defaultValue = "15") Integer pageSize, String daterange, String search, Model model) {
Page<Subjectsmake> page = getPage(pageNumber, pageSize);
model.addAttribute("pageSize", pageSize);
// 查询分页
EntityWrapper<Subjectsmake> ew = new EntityWrapper<Subjectsmake>();
ew.orderBy("id", false);
if (StringUtils.isNotBlank(search)) {
ew.like("coachname", search).or().like("subjectsname", search);
model.addAttribute("search", search);
}
//日期查询
if (StringUtils.isNotBlank(daterange)) {
model.addAttribute("daterange", daterange);
String[] dateranges = StringUtils.split(daterange, "-");
ew.addFilter(" maketime >= {0}", dateranges[0].trim().replaceAll("/", "-") + " 00:00:00");
ew.addFilter(" maketime <= {0}", dateranges[1].trim().replaceAll("/", "-") + " 23:59:59");
}
Page<Subjectsmake> pageData = iSubjectsmakeService.selectPage(page, ew);
model.addAttribute("pageData", pageData);
return "system/subjectsmake/list";
}
/**
* 新增
*/
@RequestMapping("/add")
public String add(Model model) {
//查询课程
EntityWrapper<Subjects> ew = new EntityWrapper<Subjects>();
List<Subjects> subjectsList = iSubjectsService.selectList(ew);
//查询教练
EntityWrapper<Coach> ew1 = new EntityWrapper<Coach>();
List<Coach> coachList = iCoachService.selectList(ew1);
model.addAttribute("subjectsList", subjectsList);
model.addAttribute("coachList", coachList);
return "system/subjectsmake/add";
}
/**
* 查询本周课程安排
*/
@RequestMapping("/get")
public String get(Model model) {
//查询本周
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
Calendar calendar = Calendar.getInstance();
while (calendar.get(Calendar.DAY_OF_WEEK) != Calendar.MONDAY) {
calendar.add(Calendar.DAY_OF_WEEK, -1);
}
String[] dates = new String[7];
for (int i = 0; i < 7; i++) {
dates[i] = dateFormat.format(calendar.getTime());
calendar.add(Calendar.DATE, 1);
}
int sizenum = 0;
//循环查询每天安排
for (int i = 0; i<dates.length;i++) {
EntityWrapper<Subjectsmake> ew = new EntityWrapper<Subjectsmake>();
ew.orderBy("maketime", true);
ew.addFilter(" maketime >= {0}", dates[i] + " 00:00:00");
ew.addFilter(" maketime <= {0}", dates[i] + " 23:59:59");
List<Subjectsmake> subjectsmakes = iSubjectsmakeService.selectList(ew);
model.addAttribute("subjectsmakes"+i,subjectsmakes);
if (sizenum < subjectsmakes.size()) {
sizenum = subjectsmakes.size();
}
}
model.addAttribute("sizenum",sizenum);
model.addAttribute("dates",dates);
return "system/subjectsmake/weeklist";
}
/**
* 执行
*/
@RequestMapping("/doAdd")
@ResponseBody
public Rest doAdd(Subjectsmake subjectsmake, String[] roleId, String date1, String date2) throws ParseException {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
subjectsmake.setMaketime(simpleDateFormat.parse(date1));
subjectsmake.setEndtime(simpleDateFormat.parse(date2));
Subjects subjects = iSubjectsService.selectById(subjectsmake.getSubjectsid());
subjectsmake.setSubjectsname(subjects.getName());
Coach coach = iCoachService.selectById(subjectsmake.getCoachid());
subjectsmake.setCoachname(coach.getName());
iSubjectsmakeService.insert(subjectsmake);
return Rest.ok();
}
/**
* 取消
*/
@RequestMapping("/delete")
@ResponseBody
public Rest delete(Integer id) {
Subjectsmake subjectsmake = iSubjectsmakeService.selectById(id);
subjectsmake.setStatus(0);
iSubjectsmakeService.updateById(subjectsmake);
//取消发送模板消息
EntityWrapper<Subjectsmakedetail> ew = new EntityWrapper<Subjectsmakedetail>();
ew.orderBy("id",false);
ew.eq("subjectsmakeid",id);
ew.eq("sta",1);
List<Subjectsmakedetail> subjectsmakedetails = iSubjectsmakedetailService.selectList(ew);
for (int i = 0; i < subjectsmakedetails.size(); i++) {
Member member = iMemberService.selectById(subjectsmakedetails.get(i).getMemberid());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
MIniUtil.sendCancelMsg(member.getMpOpenid(),sdf.format(subjectsmake.getMaketime()),subjectsmake.getSubjectsname(),subjectsmake.getCoachname());
}
return Rest.ok();
}
/**
* 删除
*/
@RequestMapping("/deletee")
@ResponseBody
public Rest deletee(Integer id){
iSubjectsmakeService.deleteById(id);
return Rest.ok();
}
/**
* 编辑
*/
@RequestMapping("/edit/{id}")
public String edit(@PathVariable Integer id, Model model) {
Subjectsmake subjectsmake = iSubjectsmakeService.selectById(id);
//查询课程
EntityWrapper<Subjects> ew = new EntityWrapper<Subjects>();
List<Subjects> subjectsList = iSubjectsService.selectList(ew);
//查询教练
EntityWrapper<Coach> ew1 = new EntityWrapper<Coach>();
List<Coach> coachList = iCoachService.selectList(ew1);
model.addAttribute("subjectsList", subjectsList);
model.addAttribute("coachList", coachList);
model.addAttribute("subjectsmake", subjectsmake);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
model.addAttribute("date1", sdf.format(subjectsmake.getMaketime()));
model.addAttribute("date2", sdf.format(subjectsmake.getEndtime()));
return "system/subjectsmake/edit";
}
/**
* 执行
*/
@RequestMapping("/doEdit")
@ResponseBody
public Rest doEdit(Subjectsmake subjectsmake, Model model, String date1, String date2) throws ParseException {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
subjectsmake.setMaketime(simpleDateFormat.parse(date1));
subjectsmake.setEndtime(simpleDateFormat.parse(date2));
Subjects subjects = iSubjectsService.selectById(subjectsmake.getSubjectsid());
subjectsmake.setSubjectsname(subjects.getName());
Coach coach = iCoachService.selectById(subjectsmake.getCoachid());
subjectsmake.setCoachname(coach.getName());
iSubjectsmakeService.updateById(subjectsmake);
return Rest.ok();
}
/**
* 图表
*/
@RequestMapping("/echart")
public String echart() {
return "system/echarts/list";
}
/**
* 图表
*/
@RequestMapping("/echartlist")
@ResponseBody
public List<Map<String,Object>> echartlist() {
String sql = "select coachname name,count(coachname) value from coachmake group by coachname";
return jdbcTemplate.queryForList(sql);
}
/**
* 图表
*/
@RequestMapping("/echartlist2")
@ResponseBody
public List<Map<String,Object>> echartlist2() {
String sql = "select subjectsname name,sum(endnum) value from subjectsmake group by subjectsname";
return jdbcTemplate.queryForList(sql);
}
}
package com.vacomall.controller.web;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.vacomall.common.anno.Log;
import com.vacomall.common.bean.Rest;
import com.vacomall.common.controller.SuperController;
import com.vacomall.entity.Subjectsmakedetail;
import com.vacomall.service.ISubjectsmakeService;
import com.vacomall.service.ISubjectsmakedetailService;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
/**
* <p>
* 预约课程的人数
* </p>
*
*/
@Controller
@RequestMapping("/subjectsmakedetail")
public class SubjectsmakedetailController extends SuperController {
@Autowired
private ISubjectsmakedetailService iSubjectsmakedetailService;
/**
* 查询
*/
@RequestMapping("/list/{pageNumber}")
public String list(@PathVariable Integer pageNumber, @RequestParam(defaultValue="15") Integer pageSize, Integer subjectsmakeid,String search, Model model){
Page<Subjectsmakedetail> page = getPage(pageNumber,pageSize);
model.addAttribute("pageSize", pageSize);
// 查询分页
EntityWrapper<Subjectsmakedetail> ew = new EntityWrapper<Subjectsmakedetail>();
ew.orderBy("id",false);
ew.eq("subjectsmakeid",subjectsmakeid);
if(StringUtils.isNotBlank(search)){
ew.like("coachName",search);
model.addAttribute("search",search);
}
Page<Subjectsmakedetail> pageData = iSubjectsmakedetailService.selectPage(page, ew);
model.addAttribute("pageData", pageData);
model.addAttribute("subjectsmakeid", subjectsmakeid);
return "system/subjectsmakedetail/list";
}
/**
* 新增
*/
@RequestMapping("/add")
public String add(Model model){
return "system/subjectsmakedetail/add";
}
/**
* 执行
*/
@RequestMapping("/doAdd")
@ResponseBody
public Rest doAdd(Subjectsmakedetail subjectsmakedetail, String[] roleId){
iSubjectsmakedetailService.insert(subjectsmakedetail);
return Rest.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
@ResponseBody
public Rest delete(Integer id){
iSubjectsmakedetailService.deleteById(id);
return Rest.ok();
}
/**
* 编辑
*/
@RequestMapping("/edit/{id}")
public String edit(@PathVariable Integer id,Model model){
Subjectsmakedetail subjectsmakedetail = iSubjectsmakedetailService.selectById(id);
model.addAttribute("subjectsmakedetail",subjectsmakedetail);
return "system/subjectsmakedetail/edit";
}
/**
* 执行
*/
@RequestMapping("/doEdit")
@ResponseBody
public Rest doEdit(Subjectsmakedetail subjectsmakedetail,Model model){
iSubjectsmakedetailService.updateById(subjectsmakedetail);
return Rest.ok();
}
}