业务背景
会议室是一个单位或部门的共用资源,但在应用的时候往往会遇到工夫抵触、预约艰难、不不便协调等问题。目前大部分公司是对立在公司群聊中预约，每次预约时，都须要翻一下聊天记录，理解是否有人预约以及预约工夫等。如果抵触则须要找到相干联系人进行沟通。查找历史预约记录麻烦。而当初员工人人都有微信，基于微信环境下的小程序，不必装置独立APP，拜访不便。所以咱们能够基于小程序，借助于会议室预约零碎改善这种状况，实现会议室资源的最优应用
需要剖析
数据库设计
EnrollModel.DB_STRUCTURE = { _pid: 'string|true', ENROLL_ID: 'string|true', ENROLL_TITLE: 'string|true|comment=题目', ENROLL_STATUS: 'int|true|default=1|comment=状态 0=未启用,1=应用中', ENROLL_CATE_ID: 'string|true|default=0|comment=分类', ENROLL_CATE_NAME: 'string|false|comment=分类冗余', ENROLL_CANCEL_SET: 'int|true|default=1|comment=勾销设置 0=不允,1=容许,2=仅截止前可勾销,3=审核后不可勾销', ENROLL_EDIT_SET: 'int|true|default=1|comment=批改 0=不允,1=容许,2=仅截止前可,3=审核后不可批改', ENROLL_CHECK_SET: 'int|true|default=0|comment=审核 0=不须要审核,1=须要审核', ENROLL_ORDER: 'int|true|default=9999', ENROLL_VOUCH: 'int|true|default=0', ENROLL_FORMS: 'array|true|default=[]', ENROLL_OBJ: 'object|true|default={}', ENROLL_JOIN_FORMS: 'array|true|default=[]', ENROLL_QR: 'string|false', ENROLL_VIEW_CNT: 'int|true|default=0', ENROLL_JOIN_CNT: 'int|true|default=0', ENROLL_ADD_TIME: 'int|true', ENROLL_EDIT_TIME: 'int|true', ENROLL_ADD_IP: 'string|false', ENROLL_EDIT_IP: 'string|false',};EnrollJoinModel.DB_STRUCTURE = { _pid: 'string|true', ENROLL_JOIN_ID: 'string|true', ENROLL_JOIN_ENROLL_ID: 'string|true|comment=报名PK', ENROLL_JOIN_IS_ADMIN: 'int|true|default=0|comment=是否管理员增加 0/1', ENROLL_JOIN_DAY: 'string|false|comment=预约日期', ENROLL_JOIN_START: 'string|false|comment=开始工夫', ENROLL_JOIN_END: 'string|false|comment=完结工夫', ENROLL_JOIN_END_POINT: 'string|false|comment=完结工夫开端', ENROLL_JOIN_USER_ID: 'string|true|comment=用户ID', ENROLL_JOIN_FORMS: 'array|true|default=[]|comment=表单', ENROLL_JOIN_OBJ: 'object|true|default={}', ENROLL_JOIN_STATUS: 'int|true|default=1|comment=状态 0=待审核 1=报名胜利, 99=审核未过', ENROLL_JOIN_REASON: 'string|false|comment=审核回绝或者勾销理由', ENROLL_JOIN_LAST_TIME: 'int|true|default=0', ENROLL_JOIN_ADD_TIME: 'int|true', ENROLL_JOIN_EDIT_TIME: 'int|true', ENROLL_JOIN_ADD_IP: 'string|false', ENROLL_JOIN_EDIT_IP: 'string|false',};UI设计
外围代码
class EnrollService extends BaseProjectService { // 获取以后注销状态 getJoinStatusDesc(enroll) { return '进行中'; } /** 浏览信息 */ async viewEnroll(userId, id) { let fields = '*'; let where = { _id: id, ENROLL_STATUS: EnrollModel.STATUS.COMM } let enroll = await EnrollModel.getOne(where, fields); if (!enroll) return null; EnrollModel.inc(id, 'ENROLL_VIEW_CNT', 1); // 判断是否有注销 let whereJoin = { ENROLL_JOIN_USER_ID: userId, ENROLL_JOIN_ENROLL_ID: id, ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]] } let enrollJoin = await EnrollJoinModel.getOne(whereJoin); if (enrollJoin) { enroll.myEnrollJoinId = enrollJoin._id; enroll.myEnrollJoinTag = (enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.WAIT) ? '待审核' : '已预约'; } else { enroll.myEnrollJoinId = ''; enroll.myEnrollJoinTag = ''; } return enroll; } /** 获得分页列表 */ async getEnrollList({ search, // 搜寻条件 sortType, // 搜寻菜单 sortVal, // 搜寻菜单 orderBy, // 排序 page, size, isTotal = true, oldTotal }) { orderBy = orderBy || { 'ENROLL_ORDER': 'asc', 'ENROLL_ADD_TIME': 'desc' }; let fields = 'ENROLL_STOP,ENROLL_JOIN_CNT,ENROLL_OBJ,ENROLL_VIEW_CNT,ENROLL_TITLE,ENROLL_ORDER,ENROLL_STATUS,ENROLL_CATE_NAME'; let where = {}; where.and = { _pid: this.getProjectId() //简单的查问在此处标注PID }; where.and.ENROLL_STATUS = EnrollModel.STATUS.COMM; // 状态 if (util.isDefined(search) && search) { where.or = [{ ENROLL_TITLE: ['like', search] },]; } else if (sortType && util.isDefined(sortVal)) { // 搜寻菜单 switch (sortType) { case 'cateId': { if (sortVal) where.and.ENROLL_CATE_ID = String(sortVal); break; } case 'sort': { orderBy = this.fmtOrderBySort(sortVal, 'ENROLL_ADD_TIME'); break; } } } return await EnrollModel.getList(where, fields, orderBy, page, size, isTotal, oldTotal); } // 获取某天某会议室预约状况 async getEnrollJoinByDay(enrollId, day) { let where = { ENROLL_JOIN_DAY: day, ENROLL_JOIN_ENROLL_ID: enrollId, }; return EnrollJoinModel.getAll(where); } /** 获得我的注销分页列表 */ async getMyEnrollJoinList(userId, { search, // 搜寻条件 sortType, // 搜寻菜单 sortVal, // 搜寻菜单 orderBy, // 排序 page, size, isTotal = true, oldTotal }) { orderBy = orderBy || { 'ENROLL_JOIN_ADD_TIME': 'desc' }; 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'; let where = { ENROLL_JOIN_USER_ID: userId }; if (util.isDefined(search) && search) { where['enroll.ENROLL_TITLE'] = { $regex: '.*' + search, $options: 'i' }; } else if (sortType) { // 搜寻菜单 switch (sortType) { case 'timedesc': { //按工夫倒序 orderBy = { 'ENROLL_JOIN_ADD_TIME': 'desc' }; break; } case 'timeasc': { //按工夫正序 orderBy = { 'ENROLL_JOIN_ADD_TIME': 'asc' }; break; } case 'succ': { where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC; break; } case 'wait': { where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.WAIT; break; } case 'cancel': { where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.ADMIN_CANCEL; break; } } } let joinParams = { from: EnrollModel.CL, localField: 'ENROLL_JOIN_ENROLL_ID', foreignField: '_id', as: 'enroll', }; let result = await EnrollJoinModel.getListJoin(joinParams, where, fields, orderBy, page, size, isTotal, oldTotal); return result; } /** * 获取从某天开始有预约的日期 * @param {*} fromDay 日期 Y-M-D */ async getEnrollJoinHasDaysFromDay(fromDay) { let where = { ENROLL_JOIN_DAY: ['>=', fromDay], }; let fields = 'ENROLL_JOIN_DAY'; let list = await EnrollJoinModel.distinct(where, fields); return list; } /** 按天获取所有预约我的项目 */ async getEnrollJoinAllListByDay(day) { let where = { ENROLL_JOIN_STATUS: EnrollJoinModel.STATUS.SUCC, ENROLL_JOIN_DAY: day, }; let orderBy = { 'ENROLL_JOIN_START': 'asc', 'ENROLL_JOIN_ADD_TIME': 'desc' }; let fields = 'ENROLL_JOIN_START,ENROLL_JOIN_END_POINT,ENROLL_JOIN_OBJ'; let list = await EnrollJoinModel.getAll(where, fields, orderBy); let retList = []; for (let k = 0; k < list.length; k++) { console.log(list[k]) let node = {}; node.timeDesc = list[k].ENROLL_JOIN_START; node.title = list[k].ENROLL_JOIN_OBJ.name; node._id = list[k]._id; retList.push(node); } return retList; } /** 获得我的注销详情 */ async getMyEnrollJoinDetail(enrollJoinId) { let fields = '*'; let where = { _id: enrollJoinId }; let enrollJoin = await EnrollJoinModel.getOne(where, fields); if (enrollJoin) { enrollJoin.enroll = await EnrollModel.getOne(enrollJoin.ENROLL_JOIN_ENROLL_ID, 'ENROLL_TITLE'); } return enrollJoin; } //################## 注销 // 注销 async enrollJoin(userId, enrollId, start, end, endPoint, day, forms) { // 注销是否完结 let whereEnroll = { _id: enrollId, ENROLL_STATUS: EnrollModel.STATUS.COMM } let enroll = await EnrollModel.getOne(whereEnroll); if (!enroll) this.AppError('该' + ENROLL_NAME + '不存在或者曾经进行'); // 时段是否抵触 TODO // 入库 let data = { ENROLL_JOIN_USER_ID: userId, ENROLL_JOIN_ENROLL_ID: enrollId, ENROLL_JOIN_START: start, ENROLL_JOIN_END: end, ENROLL_JOIN_END_POINT: endPoint, ENROLL_JOIN_DAY: day, ENROLL_JOIN_STATUS: (enroll.ENROLL_CHECK_SET == 0) ? EnrollJoinModel.STATUS.SUCC : EnrollJoinModel.STATUS.WAIT, ENROLL_JOIN_FORMS: forms, ENROLL_JOIN_OBJ: dataUtil.dbForms2Obj(forms), } let enrollJoinId = await EnrollJoinModel.insert(data); // 统计数量 this.statEnrollJoin(enrollId); let check = enroll.ENROLL_CHECK_SET; return { enrollJoinId, check } } // 批改注销 async enrollJoinEdit(userId, enrollId, enrollJoinId, forms) { let whereJoin = { _id: enrollJoinId, ENROLL_JOIN_USER_ID: userId, ENROLL_JOIN_ENROLL_ID: enrollId, ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]], } let enrollJoin = await EnrollJoinModel.getOne(whereJoin); if (!enrollJoin) this.AppError('该' + ENROLL_NAME + '记录不存在或者曾经被零碎勾销'); // 注销是否完结 let whereEnroll = { _id: enrollId, ENROLL_STATUS: EnrollModel.STATUS.COMM } let enroll = await EnrollModel.getOne(whereEnroll); if (!enroll) this.AppError('该' + ENROLL_NAME + '不存在或者曾经进行'); if (enroll.ENROLL_EDIT_SET == 0) this.AppError('该' + ENROLL_NAME + '不容许批改材料'); if (enroll.ENROLL_EDIT_SET == 3 && enroll.ENROLL_CHECK_SET == 1 && enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.SUCC ) this.AppError('该' + ENROLL_NAME + '已通过审核，不能批改材料'); let data = { ENROLL_JOIN_FORMS: forms, ENROLL_JOIN_OBJ: dataUtil.dbForms2Obj(forms), ENROLL_JOIN_LAST_TIME: this._timestamp, } await EnrollJoinModel.edit(whereJoin, data); } async statEnrollJoin(id) { let where = { ENROLL_JOIN_ENROLL_ID: id, ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]] } let cnt = await EnrollJoinModel.count(where); await EnrollModel.edit(id, { ENROLL_JOIN_CNT: cnt }); } /** 注销前获取要害信息 */ async detailForEnrollJoin(userId, enrollId, enrollJoinId = '') { let fields = 'ENROLL_JOIN_FORMS, ENROLL_TITLE'; let where = { _id: enrollId, ENROLL_STATUS: EnrollModel.STATUS.COMM } let enroll = await EnrollModel.getOne(where, fields); if (!enroll) this.AppError('该' + ENROLL_NAME + '不存在'); let joinMy = null; if (enrollJoinId) { // 编辑 let whereMy = { ENROLL_JOIN_USER_ID: userId, _id: enrollJoinId } joinMy = await EnrollJoinModel.getOne(whereMy); enroll.join = { start: joinMy.ENROLL_JOIN_START, end: joinMy.ENROLL_JOIN_END, endPoint: joinMy.ENROLL_JOIN_END_POINT, day: joinMy.ENROLL_JOIN_DAY, } } else { // 取出自己最近一次的填写表单 /* let whereMy = { ENROLL_JOIN_USER_ID: userId, } let orderByMy = { ENROLL_JOIN_ADD_TIME: 'desc' } joinMy = await EnrollJoinModel.getOne(whereMy, 'ENROLL_JOIN_FORMS', orderByMy);*/ } let myForms = joinMy ? joinMy.ENROLL_JOIN_FORMS : []; enroll.myForms = myForms; return enroll; } /** 勾销我的注销 只有胜利和待审核能够勾销 勾销即为删除记录 */ async cancelMyEnrollJoin(userId, enrollJoinId) { let where = { ENROLL_JOIN_USER_ID: userId, _id: enrollJoinId, ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]] }; let enrollJoin = await EnrollJoinModel.getOne(where); if (!enrollJoin) { this.AppError('未找到可勾销的记录'); } let enroll = await EnrollModel.getOne(enrollJoin.ENROLL_JOIN_ENROLL_ID); if (!enroll) this.AppError('该' + ENROLL_NAME + '不存在'); if (enroll.ENROLL_CANCEL_SET == 0) this.AppError('该' + ENROLL_NAME + '不能取消'); if (enroll.ENROLL_CANCEL_SET == 3 && enroll.ENROLL_CHECK_SET == 1 && enrollJoin.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.SUCC ) this.AppError('该' + ENROLL_NAME + '已通过审核，不能取消'); await EnrollJoinModel.del(where); this.statEnrollJoin(enrollJoin.ENROLL_JOIN_ENROLL_ID); }}后盾治理
git代码
git代码