wangdu_public_api/app/Console/Commands/Tool/TitleImageStatistics.php

<?php
/**
维护公众号交互的用户表
 */

namespace App\Console\Commands\Tool;

use Log;
use Illuminate\Console\Command;
use App\Modules\Promotion\Services\PromotionService;
use App\Modules\Promotion\Models\TempTitleImageStatistic;
use DB;
use Redis;

class TitleImageStatistics extends Command
{
    /**
     * 执行命令  TitleImageStatistics
     *
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'TitleImageStatistics';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '标题图片统计';

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        ini_set('memory_limit', '1024M');
        print_r('memory_used:'.memory_get_usage()."\n");
        print_r("======标题图片统计【任务执行开始】=====".date("y-m-d H:i:s"."\n"));
        $headlines = PromotionService::getFullHeadline();
        $images = PromotionService::getFullMessageRandomDocumentCovers(3);
        $calculate_time = date('Y-m-d H:i:s');
        foreach($headlines as $key=>$headline){
        	\Log::info('headlines_key:'.$key);
        	foreach($images as $image){
        		try{
        			$title_image_key = $headline['id'].'_'.$image['id'];
        			//         		\Log::info('TitleImageStatistics_title_image_key:'.$title_image_key);
        			$title_image_statistics_key = 'smart_push_from_title_image:'.$title_image_key;
        			$send_num = Redis::hget($title_image_statistics_key,'send_num');
        			
        			if($send_num > 0){
        				\Log::info('TitleImageStatistics_insert_title_image_key:'.$title_image_key);
        				$title_image_send_uv_key = 'smart_push_from_title_image_send_uv:'.$title_image_key;
        				$title_image_click_uv_key = 'smart_push_from_title_image_click_uv:'.$title_image_key;
        				$send_uv = Redis::SCARD($title_image_send_uv_key);
        				$click_uv = Redis::SCARD($title_image_click_uv_key);
        				$click_num = Redis::hget($title_image_statistics_key,'click_num');
        			
        				$insert_data = [
	        				'title_id'=>$headline['id'],
	        				'image_id'=>$image['id'],
	        				'send_uv'=>isset($send_uv)?$send_uv:0,
	        				'click_uv'=>isset($click_uv)?$click_uv:0,
	        				'send_num'=>isset($send_num)?$send_num:0,
	        				'click_num'=>isset($click_num)?$click_num:0,
	        				'calculate_time'=>$calculate_time,
        				];
        				\Log::info($insert_data);
        				 
        				TempTitleImageStatistic::create($insert_data);
        			}
        		}catch(\Exception $e){
        			\Log::info('TitleImageStatistics_ept:'.$e->getMessage());
        		}
        	
        	}
        }
        
        
        print_r("======标题图片统计 【任务执行结束】=====".date("y-m-d H:i:s"."\n"));
        print_r('memory_used:'.memory_get_usage()."\n");
    }
}