Base_data_tower/uni_modules/uni-sign-in/uniCloud/cloudfunctions/uni-clientDB-actions/signIn.js

// 开发文档：https://uniapp.dcloud.io/uniCloud/clientdb?id=action
const db = uniCloud.database();
const dbCmd = db.command
const signInTable = db.collection('opendb-sign-in');
const scoresTable = db.collection('uni-id-scores');
module.exports = {
	before: async (state, event) => {
		// console.log({state});
		if(state.type == 'create'){
			let date = todayTimestamp()
			let {total} = await signInTable.where({
				user_id:state.auth.uid,
				date,
				isDelete:false
			}).count()
			console.log(total);
			if(total){
			  throw new Error("今天已经签到")
			}
			state.newData.date = date
			state.newData.isDelete = false
		}
	},
	after: async (state, event, error, result) => {
		if (error) {
			throw error
		}
		let date = todayTimestamp()
		//查最近7天的签到情况
		let {data:signInData} = await signInTable.where({
			user_id:state.auth.uid,
			date:dbCmd.gte(date-3600*24*6*1000),
			isDelete:false
		}).get()
		
		let allDate = signInData.map(item=>item.date)
		
		//今天是本轮签到的第几天
		const n = ( date - Math.min(...allDate) )/3600/24/1000+1;
		//换成数字--第几天
		let days = signInData.map(item=>{
			return (n*10000 - (date - item.date)/3600/24/1000*10000)/10000  -1
		})
		
		//查出来用户当前有多少积分
		let {data: [userScore]} = await scoresTable
										.where({user_id:state.auth.uid})
										.orderBy("create_date", "desc")
										.limit(1)
										.get()
		let balance = 0
		if(userScore){
			balance = userScore.balance
		}
		
		if(state.type == 'create'){
			if(n == 7){ //如果已经满一轮就软删除之前的内容
				let setIsDeleteRes = await signInTable.where({
					user_id:state.auth.uid,
					date:dbCmd.neq(date)
				}).update({isDelete:true})
				console.log({setIsDeleteRes});
			}
			//给加积分
			let score = n+days.length==14?60:10 //如果连续签到7天就多加50分，也就是60分
			balance += score
			let addScores = await scoresTable.add({
				user_id:state.auth.uid,
				balance,
				score,
				type:1,
				create_date:Date.now()
			})
			console.log({addScores});
		}
		return {...result,score:balance,signInData,n,days}
	}
}


function todayTimestamp(){
	//时区
	let timeZone = new Date().getTimezoneOffset()/60
	//获得相对于北京时间的时间戳
	let timestamp = Date.now()+3600*1000*(8+timeZone)
	//一天一共多少毫秒
	const D = 3600*24*1000
	//去掉余数，再减去东8区的8小时 得到当天凌晨的时间戳
	return parseInt(timestamp/D)*D - 3600*1000*8
}