ExternalLinks.php 3.5 KB
<?php

namespace App\Console\Commands\RankData;

use App\Helper\Arr;
use App\Helper\SemrushApi;
use App\Models\Domain\DomainInfo;
use App\Models\RankData\ExternalLinks as ExternalLinksModel;
use App\Models\Project\DeployOptimize;
use App\Utils\HttpUtils;
use App\Utils\LogUtils;

/**
 * Class ExternalLinks
 * @package App\Console\Commands
 * @author zbj
 * @date 2023/5/9
 */
class ExternalLinks extends BaseCommands
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'rank_data_external_links';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '排名数据-外链数据';

    /**
     * @author zbj
     * @date 2023/5/6
     */
    public function do()
    {
        $error = 0;
        $semrushApi = new SemrushApi();
        //有排名api编号的项目
        $list = DeployOptimize::where('api_no', '>', 0)->select('domain', 'api_no', 'project_id')->get()->toArray();
        LogUtils::info('start rank_data_external_links:' . count($list));
        foreach ($list as $item) {
            $project_id = $item['project_id'];
            $api_no = $item['api_no'];
            $domain = $item['domain'];
            if(!$domain){
                continue;
            }
            $model = ExternalLinksModel::where('project_id', $project_id)->first();
            if ($model && $model->updated_date >= getThisWeekStarDate()) {
                continue;
            }
            if (!$model) {
                $model = new ExternalLinksModel();
            }


            //5.0
            try {
                $data = HttpUtils::get("https://www.quanqiusou.cn/semrush-api/data_json/{$api_no}.json", []);
                $data = Arr::s2a($data);
            }catch (\Exception $e){
                $data = [];
            }

            if(!$data){
                //外链数据
                $domain =  (new DomainInfo())->getDomain($domain);
                $res = $semrushApi->backlinks_overview($domain);
                if (!$res) {
                    $error++;
                    continue;
                }

                $data = $this->_data($project_id, $res['total']);
            }

            $model->project_id = $project_id;
            $model->total = $data['total'];
            $model->data = $data['data'];
            $model->updated_date = date('Y-m-d');
            $model->save();
        }
        return !$error;
    }


    /**
     * 构造chat数据
     * @param $project_id
     * @param $total
     * @return array|mixed
     * @author zbj
     * @date 2023/5/10
     */
    public function _data($project_id, $total)
    {
        // //外链数
        $data['total'] = intval($total);
        $model = ExternalLinksModel::where('project_id', $project_id)->first();
        if ($model) {
            //特殊处理的外链数
//            $data['total'] = ($total > $model->total) ? intval($total) : $model->total; //特殊处理的

            //chat数据
            $chat_data = Arr::s2a($model['data']);
            if (empty($chat_data[date('Y-m-d')])) {
                array_shift($chat_data);
            }
        } else {
            //chat数据
            for ($i = 1; $i < 12; $i++) {
                $date = date("Y-m-d", strtotime(-7 * $i . 'days'));
                $chat_data[$date] = 0;  //伪造ceil($total - ($total * rand(5, 10) / 100));
            }
        }
        $chat_data[date('Y-m-d')] = $data['total'];
        $data['data'] = $chat_data;
        return $data;
    }

}