search

博客列表 >基于微信小程序的会议室预定平台开发笔记

基于微信小程序的会议室预定平台开发笔记

P粉009333381
P粉009333381原创
2022年09月23日 07:14:40554浏览

业务背景

会议室是一个单位或部门的共用资源,但在使用的时候往往会遇到时间冲突、预约困难、不方便协调等问题。目前大部分公司是统一在公司群聊中预约，每次预约时，都需要翻一下聊天记录，了解是否有人预定以及预定时间等。如果冲突则需要找到相关联系人进行沟通。查找历史预约记录麻烦。而现在员工人人都有微信，基于微信环境下的小程序，不用安装独立APP，访问方便。所以我们可以基于小程序，借助于会议室预约系统改善这种情况，实现会议室资源的最优使用

需求分析

在这里插入图片描述

数据库设计

  1. EnrollModel.DB_STRUCTURE = {
  2.     _pid: 'string|true',
  3.     ENROLL_ID: 'string|true',
  5.     ENROLL_TITLE: 'string|true|comment=标题',
  6.     ENROLL_STATUS: 'int|true|default=1|comment=状态 0=未启用,1=使用中',
  8.     ENROLL_CATE_ID: 'string|true|default=0|comment=分类',
  9.     ENROLL_CATE_NAME: 'string|false|comment=分类冗余',
  11.     ENROLL_CANCEL_SET: 'int|true|default=1|comment=取消设置 0=不允,1=允许,2=仅截止前可取消,3=审核后不可取消',
  12.     ENROLL_EDIT_SET: 'int|true|default=1|comment=修改 0=不允,1=允许,2=仅截止前可,3=审核后不可修改',
  13.     ENROLL_CHECK_SET: 'int|true|default=0|comment=审核 0=不需要审核,1=需要审核',
  17.     ENROLL_ORDER: 'int|true|default=9999',
  18.     ENROLL_VOUCH: 'int|true|default=0',
  20.     ENROLL_FORMS: 'array|true|default=[]',
  21.     ENROLL_OBJ: 'object|true|default={}',
  23.     ENROLL_JOIN_FORMS: 'array|true|default=[]',
  25.     ENROLL_QR: 'string|false',
  26.     ENROLL_VIEW_CNT: 'int|true|default=0',
  27.     ENROLL_JOIN_CNT: 'int|true|default=0',
  29.     ENROLL_ADD_TIME: 'int|true',
  30.     ENROLL_EDIT_TIME: 'int|true',
  31.     ENROLL_ADD_IP: 'string|false',
  32.     ENROLL_EDIT_IP: 'string|false',
  33. };
  35. EnrollJoinModel.DB_STRUCTURE = {
  36.     _pid: 'string|true',
  37.     ENROLL_JOIN_ID: 'string|true',
  38.     ENROLL_JOIN_ENROLL_ID: 'string|true|comment=报名PK',
  40.     ENROLL_JOIN_IS_ADMIN: 'int|true|default=0|comment=是否管理员添加 0/1',
  42.     ENROLL_JOIN_DAY: 'string|false|comment=预约日期',
  43.     ENROLL_JOIN_START: 'string|false|comment=开始时间',
  44.     ENROLL_JOIN_END: 'string|false|comment=结束时间',
  45.     ENROLL_JOIN_END_POINT: 'string|false|comment=结束时间末尾',
  47.     ENROLL_JOIN_USER_ID: 'string|true|comment=用户ID', 
  48.     ENROLL_JOIN_FORMS: 'array|true|default=[]|comment=表单',
  49.     ENROLL_JOIN_OBJ: 'object|true|default={}',
  51.     ENROLL_JOIN_STATUS: 'int|true|default=1|comment=状态 0=待审核 1=报名成功, 99=审核未过',
  52.     ENROLL_JOIN_REASON: 'string|false|comment=审核拒绝或者取消理由',
  54.     ENROLL_JOIN_LAST_TIME: 'int|true|default=0', 
  56.     ENROLL_JOIN_ADD_TIME: 'int|true',
  57.     ENROLL_JOIN_EDIT_TIME: 'int|true',
  58.     ENROLL_JOIN_ADD_IP: 'string|false',
  59.     ENROLL_JOIN_EDIT_IP: 'string|false',
  60. };

UI设计

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

核心代码

  1. class EnrollService extends BaseProjectService {
  3.     // 获取当前登记状态
  4.     getJoinStatusDesc(enroll) {
  6.         return '进行中';
  7.     }
  9.     /** 浏览信息 */
  10.     async viewEnroll(userId, id) {
  12.         let fields = '*';
  14.         let where = {
  15.             _id: id,
  16.             ENROLL_STATUS: EnrollModel.STATUS.COMM
  17.         }
  18.         let enroll = await EnrollModel.getOne(where, fields);
  19.         if (!enroll) return null;
  21.         EnrollModel.inc(id, 'ENROLL_VIEW_CNT', 1);
  23.         // 判断是否有登记
  24.         let whereJoin = {
  25.             ENROLL_JOIN_USER_ID: userId,
  26.             ENROLL_JOIN_ENROLL_ID: id,
  27.             ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]]
  28.         }
  29.         let enrollJoin = await EnrollJoinModel.getOne(whereJoin);
  30.         if (enrollJoin) {
  31.             enroll.myEnrollJoinId = enrollJoin._id;
  32.             enroll.myEnrollJoinTag = (enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.WAIT) ? '待审核' : '已预约';
  33.         }
  34.         else {
  35.             enroll.myEnrollJoinId = '';
  36.             enroll.myEnrollJoinTag = '';
  37.         }
  39.         return enroll;
  40.     }
  43.     /** 取得分页列表 */
  44.     async getEnrollList({
  45.         search, // 搜索条件
  46.         sortType, // 搜索菜单
  47.         sortVal, // 搜索菜单
  48.         orderBy, // 排序 
  49.         page,
  50.         size,
  51.         isTotal = true,
  52.         oldTotal
  53.     }) {
  55.         orderBy = orderBy || {
  56.             'ENROLL_ORDER': 'asc',
  57.             'ENROLL_ADD_TIME': 'desc'
  58.         };
  59.         let fields = 'ENROLL_STOP,ENROLL_JOIN_CNT,ENROLL_OBJ,ENROLL_VIEW_CNT,ENROLL_TITLE,ENROLL_ORDER,ENROLL_STATUS,ENROLL_CATE_NAME';
  61.         let where = {};
  62.         where.and = {
  63.             _pid: this.getProjectId() //复杂的查询在此处标注PID
  64.         };
  66.         where.and.ENROLL_STATUS = EnrollModel.STATUS.COMM; // 状态  
  68.         if (util.isDefined(search) && search) {
  69.             where.or = [{
  70.                 ENROLL_TITLE: ['like', search]
  71.             },];
  72.         } else if (sortType && util.isDefined(sortVal)) {
  73.             // 搜索菜单
  74.             switch (sortType) {
  75.                 case 'cateId': {
  76.                     if (sortVal) where.and.ENROLL_CATE_ID = String(sortVal);
  77.                     break;
  78.                 }
  79.                 case 'sort': {
  80.                     orderBy = this.fmtOrderBySort(sortVal, 'ENROLL_ADD_TIME');
  81.                     break;
  82.                 }
  84.             }
  85.         }
  87.         return await EnrollModel.getList(where, fields, orderBy, page, size, isTotal, oldTotal);
  88.     }
  90.     // 获取某天某会议室预约情况
  91.     async getEnrollJoinByDay(enrollId, day) {
  92.         let where = {
  93.             ENROLL_JOIN_DAY: day,
  94.             ENROLL_JOIN_ENROLL_ID: enrollId,
  95.         };
  96.         return EnrollJoinModel.getAll(where);
  97.     }
  100.     /** 取得我的登记分页列表 */
  101.     async getMyEnrollJoinList(userId, {
  102.         search, // 搜索条件
  103.         sortType, // 搜索菜单
  104.         sortVal, // 搜索菜单
  105.         orderBy, // 排序 
  106.         page,
  107.         size,
  108.         isTotal = true,
  109.         oldTotal
  110.     }) {
  111.         orderBy = orderBy || {
  112.             'ENROLL_JOIN_ADD_TIME': 'desc'
  113.         };
  114.         let fields = 'ENROLL_JOIN_OBJ,ENROLL_JOIN_DAY,ENROLL_JOIN_START,ENROLL_JOIN_END,ENROLL_JOIN_END_POINT,ENROLL_JOIN_LAST_TIME,ENROLL_JOIN_REASON,ENROLL_JOIN_ENROLL_ID,ENROLL_JOIN_STATUS,ENROLL_JOIN_ADD_TIME,enroll.ENROLL_TITLE,enroll.ENROLL_EDIT_SET,enroll.ENROLL_CANCEL_SET';
  116.         let where = {
  117.             ENROLL_JOIN_USER_ID: userId
  118.         };
  120.         if (util.isDefined(search) && search) {
  121.             where['enroll.ENROLL_TITLE'] = {
  122.                 $regex: '.*' + search,
  123.                 $options: 'i'
  124.             };
  125.         } else if (sortType) {
  126.             // 搜索菜单
  127.             switch (sortType) {
  128.                 case 'timedesc': { //按时间倒序
  129.                     orderBy = {
  130.                         'ENROLL_JOIN_ADD_TIME': 'desc'
  131.                     };
  132.                     break;
  133.                 }
  134.                 case 'timeasc': { //按时间正序
  135.                     orderBy = {
  136.                         'ENROLL_JOIN_ADD_TIME': 'asc'
  137.                     };
  138.                     break;
  139.                 }
  140.                 case 'succ': {
  141.                     where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC;
  142.                     break;
  143.                 }
  144.                 case 'wait': {
  145.                     where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.WAIT;
  146.                     break;
  147.                 }
  148.                 case 'cancel': {
  149.                     where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.ADMIN_CANCEL;
  150.                     break;
  151.                 }
  152.             }
  153.         }
  155.         let joinParams = {
  156.             from: EnrollModel.CL,
  157.             localField: 'ENROLL_JOIN_ENROLL_ID',
  158.             foreignField: '_id',
  159.             as: 'enroll',
  160.         };
  162.         let result = await EnrollJoinModel.getListJoin(joinParams, where, fields, orderBy, page, size, isTotal, oldTotal);
  164.         return result;
  165.     }
  167.     /**
  168.      * 获取从某天开始有预约的日期
  169.      * @param {*} fromDay  日期 Y-M-D
  170.      */
  171.     async getEnrollJoinHasDaysFromDay(fromDay) {
  172.         let where = {
  173.             ENROLL_JOIN_DAY: ['>=', fromDay],
  174.         };
  176.         let fields = 'ENROLL_JOIN_DAY';
  177.         let list = await EnrollJoinModel.distinct(where, fields);
  179.         return list;
  180.     }
  182.     /** 按天获取所有预定项目 */
  183.     async getEnrollJoinAllListByDay(day) {
  184.         let where = {
  185.             ENROLL_JOIN_STATUS: EnrollJoinModel.STATUS.SUCC,
  186.             ENROLL_JOIN_DAY: day,
  187.         };
  189.         let orderBy = {
  190.             'ENROLL_JOIN_START': 'asc',
  191.             'ENROLL_JOIN_ADD_TIME': 'desc'
  192.         };
  194.         let fields = 'ENROLL_JOIN_START,ENROLL_JOIN_END_POINT,ENROLL_JOIN_OBJ';
  196.         let list = await EnrollJoinModel.getAll(where, fields, orderBy);
  198.         let retList = [];
  200.         for (let k = 0; k < list.length; k++) {
  201.             console.log(list[k])
  202.             let node = {};
  203.             node.timeDesc = list[k].ENROLL_JOIN_START;
  204.             node.title = list[k].ENROLL_JOIN_OBJ.name; 
  205.             node._id = list[k]._id;
  206.             retList.push(node);
  208.         }
  209.         return retList;
  210.     }
  212.     /** 取得我的登记详情 */
  213.     async getMyEnrollJoinDetail(enrollJoinId) {
  215.         let fields = '*';
  217.         let where = {
  218.             _id: enrollJoinId
  219.         };
  220.         let enrollJoin = await EnrollJoinModel.getOne(where, fields);
  221.         if (enrollJoin) {
  222.             enrollJoin.enroll = await EnrollModel.getOne(enrollJoin.ENROLL_JOIN_ENROLL_ID, 'ENROLL_TITLE');
  223.         }
  225.         return enrollJoin;
  226.     }
  228.     //################## 登记 
  229.     // 登记 
  230.     async enrollJoin(userId, enrollId, start, end, endPoint, day, forms) {
  232.         // 登记是否结束
  233.         let whereEnroll = {
  234.             _id: enrollId,
  235.             ENROLL_STATUS: EnrollModel.STATUS.COMM
  236.         }
  237.         let enroll = await EnrollModel.getOne(whereEnroll);
  238.         if (!enroll)
  239.             this.AppError('该' + ENROLL_NAME + '不存在或者已经停止');
  243.         // 时段是否冲突 TODO
  246.         // 入库
  247.         let data = {
  248.             ENROLL_JOIN_USER_ID: userId,
  249.             ENROLL_JOIN_ENROLL_ID: enrollId,
  251.             ENROLL_JOIN_START: start,
  252.             ENROLL_JOIN_END: end,
  253.             ENROLL_JOIN_END_POINT: endPoint,
  254.             ENROLL_JOIN_DAY: day,
  256.             ENROLL_JOIN_STATUS: (enroll.ENROLL_CHECK_SET == 0) ? EnrollJoinModel.STATUS.SUCC : EnrollJoinModel.STATUS.WAIT,
  258.             ENROLL_JOIN_FORMS: forms,
  259.             ENROLL_JOIN_OBJ: dataUtil.dbForms2Obj(forms),
  260.         }
  262.         let enrollJoinId = await EnrollJoinModel.insert(data);
  264.         // 统计数量
  265.         this.statEnrollJoin(enrollId);
  267.         let check = enroll.ENROLL_CHECK_SET;
  269.         return { enrollJoinId, check }
  271.     }
  274.     // 修改登记 
  275.     async enrollJoinEdit(userId, enrollId, enrollJoinId, forms) {
  276.         let whereJoin = {
  277.             _id: enrollJoinId,
  278.             ENROLL_JOIN_USER_ID: userId,
  279.             ENROLL_JOIN_ENROLL_ID: enrollId,
  280.             ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]],
  281.         }
  282.         let enrollJoin = await EnrollJoinModel.getOne(whereJoin);
  283.         if (!enrollJoin)
  284.             this.AppError('该' + ENROLL_NAME + '记录不存在或者已经被系统取消');
  286.         // 登记是否结束
  287.         let whereEnroll = {
  288.             _id: enrollId,
  289.             ENROLL_STATUS: EnrollModel.STATUS.COMM
  290.         }
  291.         let enroll = await EnrollModel.getOne(whereEnroll);
  292.         if (!enroll)
  293.             this.AppError('该' + ENROLL_NAME + '不存在或者已经停止');
  296.         if (enroll.ENROLL_EDIT_SET == 0)
  297.             this.AppError('该' + ENROLL_NAME + '不允许修改资料');
  300.         if (enroll.ENROLL_EDIT_SET == 3
  301.             && enroll.ENROLL_CHECK_SET == 1
  302.             && enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.SUCC
  303.         )
  304.             this.AppError('该' + ENROLL_NAME + '已通过审核，不能修改资料');
  307.         let data = {
  308.             ENROLL_JOIN_FORMS: forms,
  309.             ENROLL_JOIN_OBJ: dataUtil.dbForms2Obj(forms),
  310.             ENROLL_JOIN_LAST_TIME: this._timestamp,
  311.         }
  312.         await EnrollJoinModel.edit(whereJoin, data);
  314.     }
  316.     async statEnrollJoin(id) {
  317.         let where = {
  318.             ENROLL_JOIN_ENROLL_ID: id,
  319.             ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]]
  320.         }
  321.         let cnt = await EnrollJoinModel.count(where);
  323.         await EnrollModel.edit(id, { ENROLL_JOIN_CNT: cnt });
  324.     }
  326.     /**  登记前获取关键信息 */
  327.     async detailForEnrollJoin(userId, enrollId, enrollJoinId = '') {
  328.         let fields = 'ENROLL_JOIN_FORMS, ENROLL_TITLE';
  330.         let where = {
  331.             _id: enrollId,
  332.             ENROLL_STATUS: EnrollModel.STATUS.COMM
  333.         }
  334.         let enroll = await EnrollModel.getOne(where, fields);
  335.         if (!enroll)
  336.             this.AppError('该' + ENROLL_NAME + '不存在');
  340.         let joinMy = null;
  341.         if (enrollJoinId) {
  342.             // 编辑
  343.             let whereMy = {
  344.                 ENROLL_JOIN_USER_ID: userId,
  345.                 _id: enrollJoinId
  346.             }
  347.             joinMy = await EnrollJoinModel.getOne(whereMy);
  348.             enroll.join = {
  349.                 start: joinMy.ENROLL_JOIN_START,
  350.                 end: joinMy.ENROLL_JOIN_END,
  351.                 endPoint: joinMy.ENROLL_JOIN_END_POINT,
  352.                 day: joinMy.ENROLL_JOIN_DAY,
  353.             }
  354.         }
  355.         else {
  356.             // 取出本人最近一次的填写表单 
  357.             /*
  358.             let whereMy = {
  359.                 ENROLL_JOIN_USER_ID: userId,
  360.             }
  361.             let orderByMy = {
  362.                 ENROLL_JOIN_ADD_TIME: 'desc'
  363.             }
  364.             joinMy = await EnrollJoinModel.getOne(whereMy, 'ENROLL_JOIN_FORMS', orderByMy);*/
  365.         }
  367.         let myForms = joinMy ? joinMy.ENROLL_JOIN_FORMS : [];
  368.         enroll.myForms = myForms;
  370.         return enroll;
  371.     }
  373.     /** 取消我的登记 只有成功和待审核可以取消 取消即为删除记录 */
  374.     async cancelMyEnrollJoin(userId, enrollJoinId) {
  375.         let where = {
  376.             ENROLL_JOIN_USER_ID: userId,
  377.             _id: enrollJoinId,
  378.             ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]]
  379.         };
  380.         let enrollJoin = await EnrollJoinModel.getOne(where);
  382.         if (!enrollJoin) {
  383.             this.AppError('未找到可取消的记录');
  384.         }
  386.         let enroll = await EnrollModel.getOne(enrollJoin.ENROLL_JOIN_ENROLL_ID);
  387.         if (!enroll)
  388.             this.AppError('该' + ENROLL_NAME + '不存在');
  390.         if (enroll.ENROLL_CANCEL_SET == 0)
  391.             this.AppError('该' + ENROLL_NAME + '不能取消');
  394.         if (enroll.ENROLL_CANCEL_SET == 3
  395.             && enroll.ENROLL_CHECK_SET == 1
  396.             && enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.SUCC
  397.         )
  398.             this.AppError('该' + ENROLL_NAME + '已通过审核，不能取消');
  400.         await EnrollJoinModel.del(where);
  402.         this.statEnrollJoin(enrollJoin.ENROLL_JOIN_ENROLL_ID);
  404.     }
  406. }

后台管理

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

git代码

git代码

上一条：微信商城小程序开发源码设计功能方案下一条：峻瑜膜结构
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议