php基于Redis实现播放量增加功能

开发思路就是用redis得有序组合功能

1.先自增到reids中

$redisGetKey = 'ciku_promoter_click_number';
$jyId = 2; // 文章id
$redis = RedisService::build()->getInstance();
$videoPlayNumber = $redis->zScore($redisGetKey, $jyId);
// 如果该文章id存在，则新增，否则自增1
if ($videoPlayNumber) {
  $redis->zAdd($redisGetKey, intval($videoPlayNumber + 1), $jyId);
}else{
  $redis->zAdd($redisGetKey, 1, $jyId);
}

2.再从redis取出并匹配自增

	// 统计redis中的点击量，写入数据库中
	public function setPromoterClickNumber()
	{
		$redis = RedisService::build()->getInstance();
		$redisKey = 'ciku_promoter_click_number';
		// 获取有序集合中的全部数据
		$newArticleList = [];
		$articleIdArr = $redis->zRange($redisKey, 0, -1);
		foreach ($articleIdArr as $key => $value) {
			$redisKeyNumber = $redis->zScore($redisKey, $value);
			if ($redisKeyNumber) {
				$newArticle['id'] = $value;
				$newArticle['click_number'] = intval($redisKeyNumber);
				$newArticleList[] = $newArticle;
			}
		}

		$articleList = PromoterUser::build()->where('id','in',$articleIdArr)->column('click_number','id');
		// 更新文章的点击量
		$updateArticleList = [];
		foreach ($articleList as $key => $value) {
			foreach ($newArticleList as $key1 => $value1) {
				if ($key == $value1['id']) {
					$updateArticle['id'] = $key;
					$updateArticle['click_number'] = $value + $value1['click_number'];
					$updateArticleList[] = $updateArticle;
				}
			}
		}
　　　　　// 组合sql语句，批量更新
		if ($updateArticleList) {
            $updateField = ['click_number'];
            $this->sqlBatchUpdate('cy_promoter_user', $updateArticleList, $updateField, 'id');
        }
		// 删除有序集合中的全部数据
		$redis->del($redisKey);
	}

　　

3.组合sql语句，批量更新

	/**
	 * 数据用sql批量更新
	 *
	 * @param [type] $tableName     表名，包含表前缀
	 * @param [type] $updateData	待更新数据列表
	 * @param [type] $updateField  	更新字段数组列表，顺序需要与数据列表一致
	 * @param [type] $whereId		更新条件，id、order_sn等
	 * @return void
	 */
	public function sqlBatchUpdate($tableName, $updateData, $updateField, $whereId)
	{
		$updateValueSql = '';
		$updateIdSql = '';
		$updateKey = $updateField;
		foreach ($updateKey as $key) {
			$n = 0;
			foreach ($updateData as $value) {
				$n++;
				if ($n == 1) {
					$updateValueSql .= $key . " = CASE $whereId ";
				}
				$updateValueSql .= 'WHEN \'' . $value[$whereId] . '\' THEN \'' . $value[$key] . '\'';
				if ($n != count($updateData)) {
					$updateValueSql .= " ";
				} else {
					$updateValueSql .= " END,";
				}
			}
		}
		$updateValueSql = substr($updateValueSql, 0, strlen($updateValueSql) - 1);
		$n = 0;
		foreach ($updateData as $value) {
			$n++;
			if ($n == 1) {
				$updateIdSql .= "(";
			}
			$updateIdSql .= ' \'' . $value[$whereId] . '\' ';
			if ($n != count($updateData)) {
				$updateIdSql .= ",";
			} else {
				$updateIdSql .= ")";
			}
		}
		if (count($updateData)) {
			$update_sql = 'UPDATE ' . $tableName . ' SET ' . $updateValueSql . ' WHERE ' . $whereId . ' IN ' . $updateIdSql . ';';
			Db::query($update_sql); // 执行更新语句
		}
	}