index.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 = async function({user_id,ip}) {
	let date = todayTimestamp()
	let {
		total
	} = await signInTable.where({
		user_id,
		date,
		isDelete: false
	}).count()
	console.log(total);
	if (total) {
		throw new Error("今天已经签到")
	}
	// state.newData.date = date
	// state.newData.isDelete = false
	
	await signInTable.add({
		ip,
		date,
		user_id,
		create_date:Date.now(),
		isDelete:false,
	})
	
	
	// after -------------------------
	//查最近7天的签到情况
	let {
		data: signInData
	} = await signInTable.where({
		user_id,
		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
		})
		.orderBy("create_date", "desc")
		.limit(1)
		.get()
	let balance = 0
	if (userScore) {
		balance = userScore.balance
	}

	if (n == 7) { //如果已经满一轮就软删除之前的内容
		let setIsDeleteRes = await signInTable.where({
			user_id,
			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,
		balance,
		score,
		type: 1,
		create_date: Date.now()
	})
	console.log({
		addScores
	});
	return {
		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
}