微信小程序图书馆座位预约管理系统-Toy模板网

这篇具有很好参考价值的文章主要介绍了微信小程序图书馆座位预约管理系统。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

开发工具：IDEA、微信小程序

服务器：Tomcat9.0， jdk1.8

项目构建：maven

数据库：mysql5.7

前端技术：vue、uniapp

服务端技术：springboot+mybatis

本系统分微信小程序和管理后台两部分，项目采用前后端分离

项目功能描述：

1.微信小程序：登录、注册、主页、公告、轮播图、图书馆预约(座位选择、时间选择)，图书借阅、个人中心(预约状态、扫码签到、修改密码、设置、退出登录)

2.后台管理：登录、修改密码、系统管理(用户管理、角色管理、菜单管理、组织管理)、图书馆管理、座位管理、通知管理、预约管理、借阅管理、图书管理

文档截图：

基于微信小程序图书馆座位预约管理系统

微信小程序截图：

后台截图：文章来源地址https://www.toymoban.com/news/detail-417237.html


package com.yiyue.service.wx;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yiyue.common.util.PageUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.apache.commons.lang3.StringUtils;
import com.yiyue.model.bean.wx.NoticeAdvise;
import com.yiyue.model.dto.wx.NoticeAdviseDTO;
import com.yiyue.mapper.wx.NoticeAdviseMapper;

@Service
@Transactional
public class NoticeAdviseService {

    @Autowired
    private NoticeAdviseMapper noticeAdviseMapper;

    public IPage<NoticeAdvise> findNoticeAdviseListPageByParam(NoticeAdviseDTO noticeAdviseDTO) {
        // 从dto对象中获得查询条件，添加到queryWrapper对象中, 查询条件还需要视情况自行修改
        QueryWrapper<NoticeAdvise> queryWrapper=getQueryWrapper(noticeAdviseDTO);

        IPage<NoticeAdvise> noticeAdviseList=noticeAdviseMapper.findNoticeAdvisePageList(PageUtil.getPagination(noticeAdviseDTO),queryWrapper);
        return noticeAdviseList;
    }

    private QueryWrapper getQueryWrapper(NoticeAdviseDTO noticeAdviseDTO){
        QueryWrapper<NoticeAdvise> queryWrapper=new QueryWrapper<>();
        // 序号
        if(!StringUtils.isBlank(noticeAdviseDTO.getId())){
            queryWrapper.eq("id",noticeAdviseDTO.getId());
        }
        // 标题
        if(!StringUtils.isBlank(noticeAdviseDTO.getTitle())){
            queryWrapper.like("title","%"+noticeAdviseDTO.getTitle()+"%");
        }
        // 内容
        if(!StringUtils.isBlank(noticeAdviseDTO.getNoticeContent())){
            queryWrapper.eq("notice_content",noticeAdviseDTO.getNoticeContent());
        }
        // 时间
        if(!StringUtils.isBlank(noticeAdviseDTO.getCreateDate())){
            queryWrapper.eq("create_date",noticeAdviseDTO.getCreateDate());
        }
        return queryWrapper;
    }

    public void insertNoticeAdvise(NoticeAdvise noticeAdvise) {
        noticeAdviseMapper.insert(noticeAdvise);
    }

    public void updateNoticeAdvise(NoticeAdvise noticeAdvise) {
        this.noticeAdviseMapper.updateById(noticeAdvise);
    }

    public void deleteNoticeAdviseById(String id) {
        this.noticeAdviseMapper.deleteById(id);
    }

    public NoticeAdvise findNoticeAdviseById(String id) {
        return noticeAdviseMapper.selectById(id);
    }

}


package com.yiyue.service.wx;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yiyue.common.util.PageUtil;
import com.yiyue.mapper.wx.SeatStatusMapper;
import com.yiyue.model.bean.wx.SeatStatus;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.apache.commons.lang3.StringUtils;
import com.yiyue.model.bean.wx.OrderMange;
import com.yiyue.model.dto.wx.OrderMangeDTO;
import com.yiyue.mapper.wx.OrderMangeMapper;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;


@Service
@Transactional
public class OrderMangeService {

    @Autowired
    private OrderMangeMapper orderMangeMapper;

    @Autowired
    private SeatStatusMapper seatStatusMapper;

    public IPage<OrderMange> findOrderMangeListPageByParam(OrderMangeDTO orderMangeDTO) {
        // 从dto对象中获得查询条件，添加到queryWrapper对象中, 查询条件还需要视情况自行修改
        QueryWrapper<OrderMange> queryWrapper=getQueryWrapper(orderMangeDTO);

        IPage<OrderMange> orderMangeList=orderMangeMapper.findOrderMangePageList(PageUtil.getPagination(orderMangeDTO),queryWrapper);
        return orderMangeList;
    }

    private QueryWrapper getQueryWrapper(OrderMangeDTO orderMangeDTO){
        QueryWrapper<OrderMange> queryWrapper=new QueryWrapper<>();
        // 序号
        if(!StringUtils.isBlank(orderMangeDTO.getId())){
            queryWrapper.eq("s1.id",orderMangeDTO.getId());
        }
        // 订单编号
        if(!StringUtils.isBlank(orderMangeDTO.getOrderId())){
//            queryWrapper.eq("s1.order_id",orderMangeDTO.getOrderId());
            queryWrapper.eq("s1.id",orderMangeDTO.getOrderId());
        }
        // 用户
        if(!StringUtils.isBlank(orderMangeDTO.getUserId())){
            queryWrapper.eq("s1.user_id",orderMangeDTO.getUserId());
        }
        // 图书馆id
        if(!StringUtils.isBlank(orderMangeDTO.getLibraryId())){
            queryWrapper.eq("s1.library_id",orderMangeDTO.getLibraryId());
        }
        // 图书馆
        if(!StringUtils.isBlank(orderMangeDTO.getLibraryName())){
            queryWrapper.eq("s1.library_name",orderMangeDTO.getLibraryName());
        }
        // 座位id
        if(!StringUtils.isBlank(orderMangeDTO.getSeatId())){
            queryWrapper.eq("s1.seat_id",orderMangeDTO.getSeatId());
        }
        // 座位
        if(!StringUtils.isBlank(orderMangeDTO.getSeatName())){
            queryWrapper.eq("s1.seat_name",orderMangeDTO.getSeatName());
        }
        // 订单状态
        if(!StringUtils.isBlank(orderMangeDTO.getOrderStatus())){
            queryWrapper.eq("s1.order_status",orderMangeDTO.getOrderStatus());
        }
        // 预约时间
        if(!StringUtils.isBlank(orderMangeDTO.getPlanTime())){
            queryWrapper.eq("s1.plan_time",orderMangeDTO.getPlanTime());
        }
        // 创建时间
        if(!StringUtils.isBlank(orderMangeDTO.getCreateDate())){
            queryWrapper.eq("create_date",orderMangeDTO.getCreateDate());
        }
        return queryWrapper;
    }

    public void insertOrderMange(OrderMange orderMange) {
        orderMangeMapper.insert(orderMange);
    }

    public void updateOrderMange(OrderMange orderMange) {
        this.orderMangeMapper.updateById(orderMange);
    }

    public void deleteOrderMangeById(String id) {
        this.orderMangeMapper.deleteById(id);
    }

    public OrderMange findOrderMangeById(String id) {
        return orderMangeMapper.selectById(id);
    }

    public int findUserIdOrOrder(String userId) {
        QueryWrapper<OrderMange> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("user_id",userId);
        queryWrapper.eq("order_status",0);
        return orderMangeMapper.selectCount(queryWrapper);

    }

    public OrderMange findOrderState(OrderMangeDTO orderMangeDTO) {
        QueryWrapper<OrderMange> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("user_id",orderMangeDTO.getUserId());
        queryWrapper.eq("order_status",0);
        if (orderMangeMapper.selectList(queryWrapper).size()==0){
            return null;
        }
        return orderMangeMapper.selectList(queryWrapper).get(0);
    }

    public void findSeatState(String id) {
        OrderMange orderMange = orderMangeMapper.selectById(id);
        int seatId = orderMange.getSeatId();
        SeatStatus seatStatus = new SeatStatus();
        seatStatus.setId(seatId);
        seatStatus.setStatus(0);
        seatStatusMapper.updateById(seatStatus);
    }

    public void selectOrOrderState() {
        //取消座位预约findSeatState
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
       /* QueryWrapper<OrderMange> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("order_status","0");*/
        List<OrderMange> list = orderMangeMapper.selectList(null);
        if (list.size()==0){
            return;
        }
        for (int i = 0; i < list.size(); i++) {
            Date planDate = new Date(list.get(i).getPlanTime().getTime() + 900000);
            if (planDate.getTime()<new Date().getTime()){
                orderMangeMapper.deleteById(list.get(i).getId());
                SeatStatus seatStatus = new SeatStatus();
                seatStatus.setId(list.get(i).getSeatId());
                seatStatus.setStatus(0);
                seatStatusMapper.updateById(seatStatus);
            }
        }
        //时间到时的确认时间
        QueryWrapper<OrderMange> queryWrapper2 = new QueryWrapper<>();
        queryWrapper2.eq("order_status","1");
        List<OrderMange> list2 = orderMangeMapper.selectList(queryWrapper2);
        if (list.size()==0){
            return;
        }
        for (int i = 0; i < list2.size(); i++) {
            if (list2.get(i).getEndTime().getTime()<new Date().getTime()){
                orderMangeMapper.deleteById(list.get(i).getId());
                SeatStatus seatStatus = new SeatStatus();
                seatStatus.setId(list.get(i).getSeatId());
                seatStatus.setStatus(0);
                seatStatusMapper.updateById(seatStatus);
            }
        }

    }
}

package com.yiyue.service.wx;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yiyue.common.util.PageUtil;
import com.yiyue.common.vo.ItemVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.apache.commons.lang3.StringUtils;
import com.yiyue.model.bean.wx.SeatStatus;
import com.yiyue.model.dto.wx.SeatStatusDTO;
import com.yiyue.mapper.wx.SeatStatusMapper;

import java.util.ArrayList;
import java.util.List;

@Service
@Transactional
public class SeatStatusService {

@Autowired
private SeatStatusMapper seatStatusMapper;

public IPage<SeatStatus> findSeatStatusListPageByParam(SeatStatusDTO seatStatusDTO) {
// 从dto对象中获得查询条件，添加到queryWrapper对象中, 查询条件还需要视情况自行修改
QueryWrapper<SeatStatus> queryWrapper=getQueryWrapper(seatStatusDTO);

IPage<SeatStatus> seatStatusList=seatStatusMapper.findSeatStatusPageList(PageUtil. getPagination(seatStatusDTO),queryWrapper);
return seatStatusList;
}

private QueryWrapper getQueryWrapper(SeatStatusDTO seatStatusDTO){
QueryWrapper<SeatStatus> queryWrapper=new QueryWrapper<>();
// 序号
if(!StringUtils. isBlank(seatStatusDTO.getId())){
queryWrapper.eq("id",seatStatusDTO.getId());
}
// 状态（0空闲；1预约；2占用）
if(!StringUtils. isBlank(seatStatusDTO.getStatus())){
queryWrapper.eq("status",seatStatusDTO.getStatus());
}
// 座位
if(!StringUtils. isBlank(seatStatusDTO.getSeatName())){
queryWrapper.eq("seat_name",seatStatusDTO.getSeatName());
}
// 图书馆
if(!StringUtils. isBlank(seatStatusDTO.getLibraryType())){
queryWrapper.eq("library_type",seatStatusDTO.getLibraryType());
}
return queryWrapper;
}

public void insertSeatStatus(SeatStatus seatStatus) {
seatStatusMapper.insert(seatStatus);
}

public void updateSeatStatus(SeatStatus seatStatus) {
this.seatStatusMapper.updateById(seatStatus);
}

public void deleteSeatStatusById(String id) {
this.seatStatusMapper.deleteById(id);
}

public SeatStatus findSeatStatusById(String id) {
return seatStatusMapper.selectById(id);
}

public List<ItemVO> findSeatListName(String typeId) {
ArrayList<ItemVO> arrayList = new ArrayList<>();
QueryWrapper<SeatStatus> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("library_type",typeId);
queryWrapper.eq("status",0);
List<SeatStatus> seatStatusList=this.seatStatusMapper.selectList(queryWrapper);
seatStatusList.forEach(item->{
ItemVO itemVO = new ItemVO();
itemVO.setKey(item.getId()+"");
itemVO.setValue(item.getId()+"");
itemVO.setTitle(item.getSeatName());
arrayList.add(itemVO);
});
return arrayList;
}

public List<SeatStatus> findSeatListGetLibrary(int id) {
QueryWrapper<SeatStatus> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("library_type",id);
List<SeatStatus> list = seatStatusMapper.selectList(queryWrapper);
return list;
}

}