业务背景
公益培训报名小程序，提供给文化馆，图书馆，文体核心，青少年活动中心，少年宫等社会公益机构进行公益培训流动报名注销的小工具
性能合成
技术选型
- 应用腾讯专门的小程序云开发技术，云资源蕴含云函数，数据库，带宽，存储空间，定时器等，资源配额价格低廉，无需域名和服务器即可搭建。
- 小程序自身的即用即走，适宜小工具的应用场景，也适宜疾速开发迭代。
- 云开发技术采纳腾讯外部链路，没有被黑客攻击的危险，不会 DDOS 攻打，节俭防火墙费用，安全性高且免保护。
- 资源承载力可依据业务倒退须要随时弹性扩大。
数据库设计
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_USER_ID: 'string|true|comment= 用户 ID',
ENROLL_JOIN_FORMS: 'array|true|default=[]|comment= 表单',
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 设计
外围代码
// 获取以后注销状态
getJoinStatusDesc(enroll) {
let timestamp = this._timestamp;
if (enroll.ENROLL_STATUS == 0)
return '已进行';
else if (enroll.ENROLL_START > timestamp)
return '未开始';
else if (enroll.ENROLL_END <= timestamp)
return '已截止';
else if (enroll.ENROLL_MAX_CNT > 0
&& enroll.ENROLL_JOIN_CNT >= enroll.ENROLL_MAX_CNT)
return '人数已满';
else
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_MAX_CNT,ENROLL_START,ENROLL_END,ENROLL_ORDER,ENROLL_STATUS,ENROLL_CATE_NAME,ENROLL_OBJ';
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 getMyEnrollJoinList(userId, {
search, // 搜寻条件
sortType, // 搜寻菜单
sortVal, // 搜寻菜单
orderBy, // 排序
page,
size,
isTotal = true,
oldTotal
}) {
orderBy = orderBy || {'ENROLL_JOIN_ADD_TIME': 'desc'};
let fields = '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;
}
/** 获得我的注销详情 */
async getMyEnrollJoinDetail(userId, enrollJoinId) {
let fields = '*';
let where = {
_id: enrollJoinId,
ENROLL_JOIN_USER_ID: userId
};
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, forms) {
// 注销是否完结
let whereEnroll = {
_id: enrollId,
ENROLL_STATUS: EnrollModel.STATUS.COMM
}
let enroll = await EnrollModel.getOne(whereEnroll);
if (!enroll)
this.AppError('该' + ENROLL_NAME + '不存在或者曾经进行');
// 是否注销开始
if (enroll.ENROLL_START > this._timestamp)
this.AppError('该' + ENROLL_NAME + '尚未开始');
// 是否过了注销截止期
if (enroll.ENROLL_END < this._timestamp)
this.AppError('该' + ENROLL_NAME + '曾经截止');
// 人数是否满
if (enroll.ENROLL_MAX_CNT > 0) {
let whereCnt = {
ENROLL_JOIN_ENROLL_ID: enrollId,
ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]]
}
let cntJoin = await EnrollJoinModel.count(whereCnt);
if (cntJoin >= enroll.ENROLL_MAX_CNT)
this.AppError('该' + ENROLL_NAME + '人数已满');
}
// 本人是否曾经有注销
let whereMy = {
ENROLL_JOIN_USER_ID: userId,
ENROLL_JOIN_ENROLL_ID: enrollId,
ENROLL_JOIN_STATUS: ['in', [EnrollJoinModel.STATUS.WAIT, EnrollJoinModel.STATUS.SUCC]]
}
let my = await EnrollJoinModel.getOne(whereMy);
if (my) {if (my.ENROLL_JOIN_STATUS == EnrollJoinModel.STATUS.WAIT)
this.AppError('您曾经填报，正在期待审核，毋庸反复填报');
else
this.AppError('您曾经填报胜利，毋庸反复填报');
}
// 入库
let data = {
ENROLL_JOIN_USER_ID: userId,
ENROLL_JOIN_ENROLL_ID: enrollId,
ENROLL_JOIN_STATUS: (enroll.ENROLL_CHECK_SET == 0) ? EnrollJoinModel.STATUS.SUCC : EnrollJoinModel.STATUS.WAIT,
ENROLL_JOIN_FORMS: 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 == 2 && enroll.ENROLL_END < this._timestamp)
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_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);
}
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 == 2 && enroll.ENROLL_END < this._timestamp)
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 源码