公司网站建设价格,怎样制作单页网站,动易官方网站,互联网代理开发工具#xff1a;IDEA、微信小程序服务器#xff1a;Tomcat9.0#xff0c; jdk1.8项目构建#xff1a;maven数据库#xff1a;mysql5.7前端技术#xff1a;vue、uniapp服务端技术#xff1a;springbootmybatis本系统分微信小程序和管理后台两部分#xff0c;项目采用…开发工具IDEA、微信小程序服务器Tomcat9.0 jdk1.8项目构建maven数据库mysql5.7前端技术vue、uniapp服务端技术springbootmybatis本系统分微信小程序和管理后台两部分项目采用前后端分离项目功能描述 1.微信小程序登录、注册、主页、公告、轮播图、图书馆预约(座位选择、时间选择)图书借阅、个人中心(预约状态、扫码签到、修改密码、设置、退出登录)2.后台管理登录、修改密码、系统管理(用户管理、角色管理、菜单管理、组织管理)、图书馆管理、座位管理、通知管理、预约管理、借阅管理、图书管理文档截图微信小程序截图后台截图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 {Autowiredprivate NoticeAdviseMapper noticeAdviseMapper;public IPageNoticeAdvise findNoticeAdviseListPageByParam(NoticeAdviseDTO noticeAdviseDTO) {// 从dto对象中获得查询条件添加到queryWrapper对象中, 查询条件还需要视情况自行修改QueryWrapperNoticeAdvise queryWrappergetQueryWrapper(noticeAdviseDTO);IPageNoticeAdvise noticeAdviseListnoticeAdviseMapper.findNoticeAdvisePageList(PageUtil.getPagination(noticeAdviseDTO),queryWrapper);return noticeAdviseList;}private QueryWrapper getQueryWrapper(NoticeAdviseDTO noticeAdviseDTO){QueryWrapperNoticeAdvise queryWrappernew 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 {Autowiredprivate OrderMangeMapper orderMangeMapper;Autowiredprivate SeatStatusMapper seatStatusMapper;public IPageOrderMange findOrderMangeListPageByParam(OrderMangeDTO orderMangeDTO) {// 从dto对象中获得查询条件添加到queryWrapper对象中, 查询条件还需要视情况自行修改QueryWrapperOrderMange queryWrappergetQueryWrapper(orderMangeDTO);IPageOrderMange orderMangeListorderMangeMapper.findOrderMangePageList(PageUtil.getPagination(orderMangeDTO),queryWrapper);return orderMangeList;}private QueryWrapper getQueryWrapper(OrderMangeDTO orderMangeDTO){QueryWrapperOrderMange queryWrappernew 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());}// 图书馆idif(!StringUtils.isBlank(orderMangeDTO.getLibraryId())){queryWrapper.eq(s1.library_id,orderMangeDTO.getLibraryId());}// 图书馆if(!StringUtils.isBlank(orderMangeDTO.getLibraryName())){queryWrapper.eq(s1.library_name,orderMangeDTO.getLibraryName());}// 座位idif(!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) {QueryWrapperOrderMange queryWrapper new QueryWrapper();queryWrapper.eq(user_id,userId);queryWrapper.eq(order_status,0);return orderMangeMapper.selectCount(queryWrapper);}public OrderMange findOrderState(OrderMangeDTO orderMangeDTO) {QueryWrapperOrderMange 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() {//取消座位预约findSeatStateSimpleDateFormat sdfnew SimpleDateFormat(yyyy-MM-dd HH:mm:ss);/* QueryWrapperOrderMange queryWrapper new QueryWrapper();queryWrapper.eq(order_status,0);*/ListOrderMange 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);}}//时间到时的确认时间QueryWrapperOrderMange queryWrapper2 new QueryWrapper();queryWrapper2.eq(order_status,1);ListOrderMange 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;ServiceTransactionalpublic class SeatStatusService {Autowired private SeatStatusMapper seatStatusMapper; public IPageSeatStatus findSeatStatusListPageByParam(SeatStatusDTO seatStatusDTO) {// 从dto对象中获得查询条件添加到queryWrapper对象中, 查询条件还需要视情况自行修改 QueryWrapperSeatStatus queryWrappergetQueryWrapper(seatStatusDTO); IPageSeatStatus seatStatusListseatStatusMapper.findSeatStatusPageList(PageUtil.getPagination(seatStatusDTO),queryWrapper); return seatStatusList; }private QueryWrapper getQueryWrapper(SeatStatusDTO seatStatusDTO){ QueryWrapperSeatStatus queryWrappernew 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 ListItemVO findSeatListName(String typeId) { ArrayListItemVO arrayList new ArrayList(); QueryWrapperSeatStatus queryWrapper new QueryWrapper(); queryWrapper.eq(library_type,typeId); queryWrapper.eq(status,0); ListSeatStatus seatStatusListthis.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 ListSeatStatus findSeatListGetLibrary(int id) { QueryWrapperSeatStatus queryWrapper new QueryWrapper(); queryWrapper.eq(library_type,id); ListSeatStatus list seatStatusMapper.selectList(queryWrapper); return list; }}
