微信小程序图书馆座位预约管理系统_怎么用微信小程序做一个图书馆座位预约系统

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

服务器：Tomcat9.0， jdk1.8

项目构建：maven

数据库：mysql5.7

前端技术：vue、uniapp

服务端技术：springboot+mybatis

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

项目功能描述：

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

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

文档截图：

微信小程序截图：

后台截图：

<code class="language-plaintext hljs">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);
    }

}
</code>

<code class="language-plaintext hljs">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);
            }
        }

    }
}
</code>

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;
}

}