开发背景
随着全民健身的遍及，为进一步贯彻落实《“衰弱中国 2030”布局大纲》和《全民健身条例》，更好地满足宽广青少年学生和人民大众就近、便当加入体育健身活动的需要，继续扩充公共服务配套资源供应，中小学校园的操场，静止设施周也开始对市民凋谢，那么为了正当工夫，不便各项设施的无效利用，缩小不必要的人员汇集，预订小程序提供了线上预约的便捷性
性能概要设计
技术选型
- 本我的项目应用微信小程序平台进行开发。
- 应用腾讯专门的小程序云开发技术，云资源蕴含云函数，数据库，带宽，存储空间，定时器等，资源配额价格低廉，无需域名和服务器即可搭建。
- 小程序自身的即用即走，适宜小工具的应用场景，也适宜疾速开发迭代。
- 云开发技术采纳腾讯外部链路，没有被黑客攻击的危险，不会 DDOS 攻打，节俭防火墙费用，安全性高且免保护。
- 资源承载力可依据业务倒退须要随时弹性扩大。
数据库设计
EnrollJoinModel.DB_STRUCTURE = {
_pid: 'string|true',
ENROLL_JOIN_ID: 'string|true',
ENROLL_JOIN_PRICE: 'int|true|default=0',
ENROLL_JOIN_IS_ADMIN: 'int|true|default=0|comment= 是否管理员增加 0/1',
ENROLL_JOIN_ENROLL_ID: 'string|true|comment= 报名 PK',
ENROLL_JOIN_ENROLL_TITLE: 'string|false',
ENROLL_JOIN_CATE_ID: 'string|false|default=0|comment= 分类',
ENROLL_JOIN_CATE_NAME: 'string|false|comment= 分类冗余',
ENROLL_JOIN_CODE: 'string|true|comment= 核验码 15 位',
ENROLL_JOIN_IS_CHECKIN: 'int|true|default=0|comment= 是否核销 0/1',
ENROLL_JOIN_CHECKIN_TIME: 'int|true|default=0',
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_END_FULL: 'string|false|comment= 残缺的完结工夫 YYYY-MM-DD hh:mm',
ENROLL_JOIN_START_FULL: 'string|false|comment= 残缺的开始工夫 YYYY-MM-DD hh:mm',
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= 胜利, 9= 用户勾销, 99= 零碎勾销',
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',
};
// 字段前缀
EnrollJoinModel.FIELD_PREFIX = "ENROLL_JOIN_";
/**
* 状态 0= 待审核 1= 胜利,9= 用户勾销, 99= 审核未过
*/
EnrollJoinModel.STATUS = {
WAIT: 0,
SUCC: 1,
CANCEL: 9,
ADMIN_CANCEL: 99
};
EnrollJoinModel.STATUS_DESC = {
WAIT: '待审核',
SUCC: '胜利',
CANCEL: '用户勾销',
ADMIN_CANCEL: '零碎勾销'
};
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_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_DAYS: 'array|true|default=[]|comment= 最近一次批改保留的可用日期',
ENROLL_DAY_CNT: 'int|true|default=0',
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',
};
要害难点
// 获取某天某个场合下的可约工夫点
async getOneDayTimePoint(day, enrollId) {
let where = {
DAY_ENROLL_ID: enrollId,
day
};
let fields = 'times';
let data = await DayModel.getOne(where, fields);
if (!data)
data = [];
else
data = data.times;
return data;
}
// 获得某天内所有场地信息
async getAllEnroll(cateId, day) {
let where = {ENROLL_CATE_ID: String(cateId),
ENROLL_STATUS: EnrollModel.STATUS.COMM
}
let orderBy = {
ENROLL_ORDER: 'asc',
ENROLL_ADD_TIME: 'asc'
}
let list = await EnrollModel.getAll(where, '*', orderBy);
let arr = [];
let startTime = 23;
let endTime = 0;
for (let k = 0; k < list.length; k++) {let times = await this.getOneDayTimePoint(day, list[k]._id);
// 合成小时
let t = [];
for (let j = 0; j < times.length; j++) {if (times[j].start < startTime) startTime = times[j].start;
if (times[j].end > endTime) endTime = times[j].end;
for (let i = times[j].start; i <= times[j].end; i++) {
let node = {
t: i, // 工夫点
price: times[j].price, // 价格
};
t.push(node);
}
}
if (t.length > 0)
arr.push({enrollId: list[k]._id,
label: list[k].ENROLL_TITLE,
timePrice: t
})
}
// 获得可预订的最大日期
let maxDay = await DayModel.max({day: ['>=', day], DAY_CATE_ID: cateId }, 'day');
if (maxDay == 0) maxDay = '';
return {
maxDay,
startTime,
endTime,
list: arr
};
}
// 获取某天预订状况
async getUsedByDay(cateId, day) {
let where = {ENROLL_JOIN_CATE_ID: String(cateId),
ENROLL_JOIN_DAY: day,
ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]],
};
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_IS_CHECKIN,ENROLL_JOIN_CATE_NAME,ENROLL_JOIN_ENROL_TITLE,ENROLL_JOIN_PRICE,ENROLL_JOIN_END_FULL,ENROLL_JOIN_OBJ,ENROLL_JOIN_DAY,ENROLL_JOIN_START,ENROLL_JOIN_END,ENROLL_JOIN_END_POINT,ENROLL_JOIN_LAST_TIME,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_JOIN_OBJ.name'] = {
$regex: '.*' + search,
$options: 'i'
};
} else if (sortType) {
// 搜寻菜单
switch (sortType) {
case 'timedesc': { // 按工夫倒序
orderBy = {'ENROLL_JOIN_START_FULL': 'desc'};
break;
}
case 'timeasc': { // 按工夫正序
orderBy = {'ENROLL_JOIN_START_FULL': 'asc'};
break;
}
case 'status': {break;}
case 'today': {where.ENROLL_JOIN_DAY = timeUtil.time('Y-M-D');
where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC;
break;
}
case 'run': {where.ENROLL_JOIN_END_FULL = ['>', timeUtil.time('Y-M-D h:m')];
where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC;
where.ENROLL_JOIN_IS_CHECKIN = 0;
break;
}
case 'check': {where.ENROLL_JOIN_END_FULL = ['>', timeUtil.time('Y-M-D h:m')];
where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC;
where.ENROLL_JOIN_IS_CHECKIN = 1;
break;
}
case 'out': {where.ENROLL_JOIN_END_FULL = ['<=', timeUtil.time('Y-M-D h:m')];
where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.SUCC;
break;
}
case 'cancel': {
where.ENROLL_JOIN_STATUS = EnrollJoinModel.STATUS.CANCEL;
break;
}
case 'syscancel': {
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;
}
/** 获得我的注销详情 */
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;
}
//################## 注销
// 把工夫格局 'hh:mm' 转为数组 [1,2,3,4]
getTimeArr(start, end) {start = start.replace(':00', '').trim();
start = start.replace(':30', '').trim();
start = Number(start);
end = end.replace(':00', '');
end = end.replace(':30', '').trim();
end = Number(end);
let ret = [];
for (let k = start; k <= end; k++) {ret.push(k);
}
return ret;
}
// 注销
async enrollJoin(userId, {
enrollId,
price,
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 + '不存在或者曾经进行');
// 判断是否曾经被约 (数组交加)
let nowTimeArr = this.getTimeArr(start, end);
let joinWhere = {
ENROLL_JOIN_ENROLL_ID: enrollId,
ENROLL_JOIN_DAY: day,
ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]],
}
let joinList = await EnrollJoinModel.getAll(joinWhere, 'ENROLL_JOIN_START,ENROLL_JOIN_END', { 'ENROLL_JOIN_START': 'asc'});
for (let k = 0; k < joinList.length; k++) {let listTimeArr = this.getTimeArr(joinList[k].ENROLL_JOIN_START, joinList[k].ENROLL_JOIN_END);
for (let j = 0; j < nowTimeArr.length; j++) {if (listTimeArr.includes(nowTimeArr[j])) {this.AppError(nowTimeArr[j] + '点曾经被预订，请从新抉择');
}
}
}
// 入库
let data = {
ENROLL_JOIN_USER_ID: userId,
ENROLL_JOIN_ENROLL_ID: enrollId,
ENROLL_JOIN_CATE_ID: enroll.ENROLL_CATE_ID,
ENROLL_JOIN_CATE_NAME: enroll.ENROLL_CATE_NAME,
ENROLL_JOIN_CODE: dataUtil.genRandomIntString(15),
ENROLL_JOIN_PRICE: price,
ENROLL_JOIN_START: start,
ENROLL_JOIN_END: end,
ENROLL_JOIN_END_POINT: endPoint,
ENROLL_JOIN_DAY: day,
ENROLL_JOIN_ENROLL_TITLE: enroll.ENROLL_TITLE,
ENROLL_JOIN_END_FULL: day + ' ' + endPoint,
ENROLL_JOIN_START_FULL: day + ' ' + start,
ENROLL_JOIN_FORMS: forms,
ENROLL_JOIN_OBJ: dataUtil.dbForms2Obj(forms),
}
let enrollJoinId = await EnrollJoinModel.insert(data);
// 统计数量
this.statEnrollJoin(enrollId);
return {enrollJoinId}
}
// 批改注销
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 (enrollJoin.ENROLL_JOIN_IS_CHECKIN == 1)
this.AppError('该预订已核销，不能批改');
if (enroll.ENROLL_EDIT_SET == 0)
this.AppError('该' + ENROLL_NAME + '不容许批改材料');
if (enroll.ENROLL_EDIT_SET == 2 && enrollJoin.ENROLL_JOIN_START_FULL <= timeUtil.time('Y-M-D h:m'))
this.AppError('该' + ENROLL_NAME + '曾经开始，不能批改材料');
if (enroll.ENROLL_EDIT_SET == 3 && enrollJoin.ENROLL_JOIN_END_FULL <= timeUtil.time('Y-M-D h:m'))
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, ENROLL_CATE_NAME';
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('未找到可勾销的记录');
}
if (enrollJoin.ENROLL_JOIN_IS_CHECKIN == 1)
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 == 2 && enrollJoin.ENROLL_JOIN_START_FULL <= timeUtil.time('Y-M-D h:m'))
this.AppError('该' + ENROLL_NAME + '曾经开始，不能取消');
if (enroll.ENROLL_CANCEL_SET == 3 && enrollJoin.ENROLL_JOIN_END_FULL <= timeUtil.time('Y-M-D h:m'))
this.AppError('该' + ENROLL_NAME + '曾经完结，不能取消');
if (enroll.ENROLL_CANCEL_SET > 20) {
let step = enroll.ENROLL_CANCEL_SET - 20;
let day = timeUtil.time2Timestamp(enrollJoin.ENROLL_JOIN_END_FULL + ':00') - step * 86400 * 1000;
day = timeUtil.timestamp2Time(day, 'Y-M-D');
let now = timeUtil.time('Y-M-D');
if (now > day) this.AppError('仅开始前' + step + '天可勾销');
}
await EnrollJoinModel.edit(where,
{
ENROLL_JOIN_STATUS: EnrollJoinModel.STATUS.CANCEL,
ENROLL_JOIN_IS_CHECKIN: 0
});
await this.statEnrollJoin(enrollJoin.ENROLL_JOIN_ENROLL_ID);
}
前端 UI 设计
后盾管理系统 UI 设计
git 源码
git 源码下载