<?php

namespace App\Console\Commands\Domain;

use App\Models\Devops\ServerConfig;
use App\Models\Devops\ServersIp;
use App\Models\Domain\DomainInfo;
use App\Models\Project\Project;
use App\Services\BatchExportService;
use Illuminate\Console\Command;

class ProjectDomainCheck extends Command
{
    protected $signature = 'project_domain_check';
    protected $description = '筛选域名解析不统一的项目';

    public function handle()
    {
        $map = ['项目id', '名称', '域名', '项目所选IP', '项目实际IP'];

        //获取所有恢复项目
        $domain_model = new DomainInfo();
        $domain_list = $domain_model->select(['id', 'domain', 'project_id'])->where('status', 1)->where('project_id', '>', 0)->where('id', '>', 3)->get();
        $data = [];
        if ($domain_list->count() > 0) {
            $project_model = new Project();
            $server_ip_model = new ServersIp();

            foreach ($domain_list as $value) {
                $project_info = $project_model->read(['id' => $value->project_id], ['id', 'serve_id', 'company']);
                $server_ip_info = $server_ip_model->read(['id' => $project_info['serve_id']], ['servers_id', 'ip', 'domain']);

                if ($server_ip_info['servers_id'] == ServerConfig::SELF_SITE_ID) {
                    //过滤自建站项目
                    continue;
                }

                //获取域名解析
                $records = dns_get_record($value->domain, DNS_A);
                $record_ip = $records[0]['ip'] ?? '';
                $record_domain = $records[0]['host'] ?? '';
                if ($record_domain == $server_ip_info['domain'] || $record_ip == $server_ip_info['ip']) {
                    continue;
                } else {
                    $data[] = [
                        $value->project_id,
                        $project_info['company'],
                        $value->domain,
                        $server_ip_info['ip'],
                        $record_ip,
                    ];
                }
            }
        }

        //生成文件，发送到客户端
        if ($data) {
            $table = new BatchExportService("域名解析不统一的项目结果导出");
            $file = $table->head($map)->data($data)->save();
            if (!$file) {
                $this->output('文件生成失败，请重试');
            } else {
                $this->output('export success');
            }
        } else {
            $this->output('no data');
        }
    }

    /**
     * 输出处理日志
     * @param $message
     */
    public function output($message)
    {
        echo date('Y-m-d H:i:s') . ' | ' . $message . PHP_EOL;
    }
}