<?php

include_once "../vendor/autoload.php";

/**
 * 只有黑格 在使用此业务
 * 预热 邮件 数据处理
 * 主要功能：
 *  在 https://fob.ai.cc/api/mail/preheat 拉取 预热邮件
 *  在 https://oa.shopk.com/api/mail/preheat 拉取 预热邮件
 *  在 lists表中找到这些邮箱发出的邮件
 *  然后在 hot_mail表中记录起来
 * @author：dc
 * @time 2024/7/18 13:50
 * Class HotMail
 */
class HotMail {

    public function __construct(){$this->start();}

    /**
     * shopk那边的预热邮箱
     * @var array
     */
    private $shopkHotEmail = [];

    /**
     * @author：dc
     * @time 2024/7/18 14:04
     */
    private function start(){
        _echo('启动预热邮件处理 '.getmypid());

        $this->shopkHotEmail = $this->getHotEmail();
        if($this->shopkHotEmail){
            array_map([$this,'moveMail'],$this->getFobHotEmail());
        }

    }

    /**
     * 邮件检查及移动
     * @param string $email 检查的邮箱
     * @author：dc
     * @time 2024/7/18 14:06
     */
    private function moveMail(string $email){
        // 读取邮箱在表里的id
        $email_id = db()->value(sprintf("select `id` from `%s` where `email` = '%s' limit 1",\Model\emailSql::$table, $email));

        if($email_id){
            $this->findFolder($email_id,'收件箱','s');
            $this->findFolder($email_id,'发件箱','f');
        }

        return true;
    }

    /**
     * 查找文件夹
     * @param int $email_id 邮箱id
     * @param string $folder 那个文件夹
     * @author：dc
     * @time 2024/7/18 15:10
     */
    private function findFolder(int $email_id, string $folder,string $type){
        // 查询 文件夹
        $folders = db()->all(\Model\folderSql::all($email_id,'`id`,`folder`'));

        foreach ($folders as $f){
            if(folderAlias($f['folder']) == $folder){
                // 最后记录的id
                $last_id = db()->value('select max(`lists_id`) from `fob_hot_mail` where `email_id` = '.$email_id.' limit 1');
                $last_id = $last_id?$last_id:0;
                $this->findList(new Data($email_id,$f['id'],$type,$last_id));
            }
        }
        return true;
    }

    /**
     * 查找 邮件
     * @author：dc
     * @time 2024/7/18 15:11
     */
    private function findList(Data $data, int $p = 1){
        $lists = db()->all(
            sprintf(
                "select `id`,`folder_id`,`email_id`,`%s` from `lists` where `id` > %d and `email_id` = %d and `folder_id` = %d and (select count(*) from `fob_hot_mail` where `lists`.`id` = `fob_hot_mail`.`lists_id`) = 0 order by `id` asc limit 1000 offset ".(($p-1)*1000),
                $data->type=='s' ? 'from':'to_name', // 收件箱查询 from字段 发件箱 查询 to_name字段
                $data->last_id,
                $data->email_id,
                $data->folder_id
            )
        );
        if($lists){
            // 处理数据
            foreach ($lists as $list){
                $list['folder'] = $data->type;
                $this->insertData($list);
            }
            $lists = null;
            $list = null;
            // 再次查找
            $this->findList($data,$p + 1);
        }
        return true;
    }

    /**
     * 插入数据
     * @param array $data
     * @author：dc
     * @time 2024/7/18 15:25
     */
    private function insertData(array $data){
        $isInsert = false;
        if($data['folder'] == 's'){
            // 收件箱 匹配 from 字段
            $isInsert = in_array($data['from'],$this->shopkHotEmail);
        }else{
            // 发件箱 匹配 to_name字段
            $to_name = is_array($data['to_name']) ? $data['to_name'] : @json_decode($data['to_name'],1);
            if($to_name){
                foreach ($to_name as $item){
                    // 找到了就退出去
                    if(in_array($item['email'],$this->shopkHotEmail)){
                        $isInsert = true;
                        break;
                    }
                }
            }
        }

        // 是预热 邮箱发来的邮件
        if($isInsert){
            // 不存在 数据
            if(db()->count("select count(*) from `fob_hot_mail` where `lists_id` = ".$data['id']) == 0){
                db()->insert('fob_hot_mail',[
                    'lists_id'  =>  $data['id'],
                    'email_id'  =>  $data['email_id'],
                    'hot_form'  =>  $data['from'],
                    'folder'    =>  $data['folder']
                ],false);
            }
        }
        return true;
    }


    /**
     * 获取预热邮箱
     * shopk的
     * @return array
     * @author：dc
     * @time 2024/7/18 13:58
     */
    private function getHotEmail():array {
        $data = @file_get_contents('https://oa.shopk.com/api/mail/preheat');

        if($data){
            $data = @json_decode($data,1);
            if($data && isset($data['data']) && is_array($data['data'])){
                return $data['data'];
            }
        }
        logs('shopk 获取预热邮箱错误：'.print_r($data,1),'get_hot_oa_email.error.log')->write();
        return [];
    }

    /**
     * fob黑格的预热邮箱
     * @author：dc
     * @time 2024/7/18 14:21
     */
    private function getFobHotEmail(){
        $data = @file_get_contents('https://fob.ai.cc/api/mail/preheat/'.md5('aicc.'.date('ymdh')));
        if($data){
            $data = @json_decode($data,1);
            if($data && isset($data['data']) && is_array($data['data'])){
                return $data['data'];
            }
        }
        logs('fob 获取预热邮箱错误：'.print_r($data,1),'get_hot_fob_email.error.log')->write();
    }



}


class Data {

    public int $email_id = 0;
    public int $folder_id = 0;
    public string $type = '';
    public int $last_id = 0;

    public function __construct(int $email_id,int $folder_id, string $type,int $last_id)
    {
        $this->email_id = $email_id;
        $this->folder_id = $folder_id;
        $this->type = $type;
        $this->last_id = $last_id;
    }

}


new HotMail();