12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- <?php
- namespace App\Console\Commands;
- use App\Modules\User\Services\UserSubscribeBehaviorStatsService;
- use DB;
- use GuzzleHttp\Client;
- use Illuminate\Console\Command;
- use Log;
- use Redis;
- class UpdateUserActualSubscribeNum extends Command
- {
-
- protected $signature = 'updateUserSubNum';
-
- protected $description = '更新强关号实际新增粉丝';
-
- public function handle()
- {
- $lists = UserSubscribeBehaviorStatsService::getList(date('Y-m-d',strtotime('-1 day')));
- foreach ($lists as $list){
- $new_user_num_raw = self::getOfficialAccountFansNum($list->appid,$list->date,$list->date);
- $new_user_num = 0;
- $cancel_user_num = 0;
- if(isset($new_user_num_raw['user_summary']['list']) && count($new_user_num_raw['user_summary']['list'])>0){
- $new_user_num = $new_user_num_raw['user_summary']['list'][0]['new_user'];
- $cancel_user_num = $new_user_num_raw['user_summary']['list'][0]['cancel_user'];
- }
- $list->yesterday_actual_new_user = $new_user_num;
- $list->yesterday_actual_sub_num = $new_user_num-$cancel_user_num;
-
-
- $list->save();
- }
- }
- private static function getOfficialAccountFansNum($appid,$start_date,$end_date){
- $client = New Client(['base_uri' => env('MEDIA_API_BASE_URI')]);
- $response = $client->request('GET','get_gzh_statistics',['query'=>['gzh_app_id'=>$appid,'from_date'=>$start_date,'to_date'=>$end_date]]);
- $res = json_decode($response->getBody(),true);
-
- return $res['data'];
- }
- }
|