从0到1：活动报名小程序开发笔记

背景

在日常生活中，大家也经常有组织活动，比如体育、才艺比赛报名，户外、聚餐、出游报名，休闲小聚，会议报名，创业聚会，校友聚会，公益活动，培训报名等需求。如果一个个收集就非常费时间和人力成本，这个时候只需要一款在线报名小程序就可以快速搞定，报名、签到、活动收集一气呵成！

概要设计

包括公告通知，活动分类，活动列表，活动报名，活动评价，我的活动报名，后台活动项目管理，后台报名记录管理，后台报名审核，后台报名数据导出等功能，组织方可以自定义要填写的内容，比如姓名、性别、年龄，身份证、手机号等

数据库设计

ActivityJoinModel.DB_STRUCTURE = {
	_pid: 'string|true',
	ACTIVITY_JOIN_ID: 'string|true',
	ACTIVITY_JOIN_ACTIVITY_ID: 'string|true|comment=报名PK',

	ACTIVITY_JOIN_IS_ADMIN: 'int|true|default=0|comment=是否管理员添加 0/1',

	ACTIVITY_JOIN_CODE: 'string|true|comment=核验码15位',
	ACTIVITY_JOIN_IS_CHECKIN: 'int|true|default=0|comment=是否签到 0/1 ',
	ACTIVITY_JOIN_CHECKIN_TIME: 'int|false|default=0|签到时间',

	ACTIVITY_JOIN_USER_ID: 'string|true|comment=用户ID',


	ACTIVITY_JOIN_FORMS: 'array|true|default=[]|comment=表单',
	ACTIVITY_JOIN_OBJ: 'object|true|default={}',

	ACTIVITY_JOIN_STATUS: 'int|true|default=1|comment=状态  0=待审核 1=报名成功, 99=审核未过',
	ACTIVITY_JOIN_REASON: 'string|false|comment=审核拒绝或者取消理由',

	ACTIVITY_JOIN_ADD_TIME: 'int|true',
	ACTIVITY_JOIN_EDIT_TIME: 'int|true',
	ACTIVITY_JOIN_ADD_IP: 'string|false',
	ACTIVITY_JOIN_EDIT_IP: 'string|false',
};

ActivityModel.DB_STRUCTURE = {
_pid: ‘string|true’,
ACTIVITY_ID: ‘string|true’,

ACTIVITY_TITLE: 'string|true|comment=标题',
ACTIVITY_STATUS: 'int|true|default=1|comment=状态 0=未启用,1=使用中',

ACTIVITY_CATE_ID: 'string|true|default=0|comment=分类',
ACTIVITY_CATE_NAME: 'string|false|comment=分类冗余',

ACTIVITY_CANCEL_SET: 'int|true|default=1|comment=取消设置 0=不允,1=允许,2=仅截止前可取消',
ACTIVITY_CHECK_SET: 'int|true|default=0|comment=审核 0=不需要审核,1=需要审核', 
ACTIVITY_IS_MENU: 'int|true|default=1|comment=是否公开展示名单',

ACTIVITY_MAX_CNT: 'int|true|default=20|comment=人数上限 0=不限',
ACTIVITY_START: 'int|false|comment=活动开始时间',
ACTIVITY_END: 'int|false|comment=活动截止时间',
ACTIVITY_STOP: 'int|true|default=0|comment=报名截止时间 0=永不过期',

ACTIVITY_ORDER: 'int|true|default=9999',
ACTIVITY_VOUCH: 'int|true|default=0',

ACTIVITY_FORMS: 'array|true|default=[]',
ACTIVITY_OBJ: 'object|true|default={}',

ACTIVITY_JOIN_FORMS: 'array|true|default=[]',

ACTIVITY_ADDRESS: 'string|false|comment=详细地址',
ACTIVITY_ADDRESS_GEO: 'object|false|comment=详细地址坐标参数',

ACTIVITY_QR: 'string|false',
ACTIVITY_VIEW_CNT: 'int|true|default=0',
ACTIVITY_JOIN_CNT: 'int|true|default=0',
ACTIVITY_COMMENT_CNT: 'int|true|default=0',

ACTIVITY_USER_LIST: 'array|true|default=[]|comment={name,id,pic}',

ACTIVITY_ADD_TIME: 'int|true',
ACTIVITY_EDIT_TIME: 'int|true',
ACTIVITY_ADD_IP: 'string|false',
ACTIVITY_EDIT_IP: 'string|false',

};

核心实现

async statActivityJoin(id) {
	let where = {
		ACTIVITY_JOIN_ACTIVITY_ID: id,
		ACTIVITY_JOIN_STATUS: ['in', [ActivityJoinModel.STATUS.WAIT, ActivityJoinModel.STATUS.SUCC]]
	}
	let cnt = await ActivityJoinModel.count(where);


	where = {
		ACTIVITY_JOIN_ACTIVITY_ID: id,
		ACTIVITY_JOIN_STATUS: ActivityJoinModel.STATUS.SUCC
	}
	let joinParams = {
		from: UserModel.CL,
		localField: 'ACTIVITY_JOIN_USER_ID',
		foreignField: 'USER_MINI_OPENID',
		as: 'user',
	};
	let orderBy = {
		ACTIVITY_JOIN_ADD_TIME: 'desc'
	}
	let list = await ActivityJoinModel.getListJoin(joinParams, where, 'ACTIVITY_JOIN_ADD_TIME,user.USER_MINI_OPENID,user.USER_NAME,user.USER_PIC', orderBy, 1, 6, false, 0);
	list = list.list;

	for (let k = 0; k < list.length; k++) {
		list[k] = list[k].user;
	} 

	await ActivityModel.edit(id, { ACTIVITY_JOIN_CNT: cnt, ACTIVITY_USER_LIST: list });
}

/**  报名前获取关键信息 */
async detailForActivityJoin(userId, activityId) {
	let fields = 'ACTIVITY_JOIN_FORMS, ACTIVITY_TITLE';

	let where = {
		_id: activityId,
		ACTIVITY_STATUS: ActivityModel.STATUS.COMM
	}
	let activity = await ActivityModel.getOne(where, fields);
	if (!activity)
		this.AppError('该活动不存在');


	// 取出本人最近一次的填写表单

	let whereMy = {
		ACTIVITY_JOIN_USER_ID: userId,
	}
	let orderByMy = {
		ACTIVITY_JOIN_ADD_TIME: 'desc'
	}
	let joinMy = await ActivityJoinModel.getOne(whereMy, 'ACTIVITY_JOIN_FORMS', orderByMy);


	let myForms = joinMy ? joinMy.ACTIVITY_JOIN_FORMS : [];
	activity.myForms = myForms;

	return activity;
}

/** 取消我的报名 只有成功和待审核可以取消 取消即为删除记录 */
async cancelMyActivityJoin(userId, activityJoinId) {
	let where = {
		ACTIVITY_JOIN_USER_ID: userId,
		_id: activityJoinId,
		ACTIVITY_JOIN_STATUS: ['in', [ActivityJoinModel.STATUS.WAIT, ActivityJoinModel.STATUS.SUCC]]
	};
	let activityJoin = await ActivityJoinModel.getOne(where);

	if (!activityJoin) {
		this.AppError('未找到可取消的报名记录');
	}

	if (activityJoin.ACTIVITY_JOIN_IS_CHECKIN == 1)
		this.AppError('该活动已经签到，无法取消');

	let activity = await ActivityModel.getOne(activityJoin.ACTIVITY_JOIN_ACTIVITY_ID);
	if (!activity)
		this.AppError('该活动不存在');

	if (activity.ACTIVITY_END <= this._timestamp)
		this.AppError('该活动已经结束，无法取消');

	if (activity.ACTIVITY_CANCEL_SET == 0)
		this.AppError('该活动不能取消');

	if (activity.ACTIVITY_CANCEL_SET == 2 && activity.ACTIVITY_STOP < this._timestamp)
		this.AppError('该活动已经截止报名，不能取消');

	await ActivityJoinModel.del(where); 

	// 统计
	await this.statActivityJoin(activityJoin.ACTIVITY_JOIN_ACTIVITY_ID);
}

UI设计

后台设计

代码git

git代码