<?php

namespace app\common\model\branch;

use app\common\model\BaseModel;

/**
 * 活动模型
 */
class Activity extends BaseModel
{
    protected $name = 'branch_activity';
    protected $pk = 'activity_id';

    /**
     * 追加字段
     * @var string[]
     */
    protected $append = [
        'register_time_text',
        'activity_time_text',
        'status_text',
        'audit_status_text',
    ];

    /**
     * 关联封面图
     * @return \think\model\relation\HasOne
     */
    public function image()
    {
        return $this->hasOne('app\\common\\model\\file\\UploadFile', 'file_id', 'image_id');
    }

    /**
     * 关联分享海报
     * @return \think\model\relation\HasOne
     */
    public function pic()
    {
        return $this->hasOne('app\\common\\model\\file\\UploadFile', 'file_id', 'pic_id');
    }

    /**
     * 关联活动分类表
     * @return \think\model\relation\BelongsTo
     */
    public function category()
    {
        return $this->BelongsTo("app\\common\\model\\branch\\Category", 'category_id', 'category_id');
    }

    /**
     * 关联连盟
     * @return \think\model\relation\BelongsTo
     */
    public function branch()
    {
        return $this->BelongsTo("app\\common\\model\\branch\\Branch", 'branch_id', 'branch_id');
    }

    /**
     * 关联走访企业
     * @return \think\model\relation\BelongsTo
     */
    public function visitSupplier()
    {
        return $this->BelongsTo("app\\common\\model\\supplier\\Supplier", 'visit_supplier_id', 'shop_supplier_id');
    }

    /**
     * 关联提供场地企业
     * @return \think\model\relation\BelongsTo
     */
    public function spaceSupplier()
    {
        return $this->BelongsTo("app\\common\\model\\supplier\\Supplier", 'space_supplier_id', 'shop_supplier_id');
    }

    /**
     *报名时间
     * @param $value
     * @param $data
     * @return string
     */
    public function getRegisterTimeTextAttr($value, $data)
    {
        if(isset($data['register_start_time'])) {
            return $data['register_start_time'] ? date('Y-m-d H:i', $data['register_start_time']).' - ' . date('Y-m-d H:i', $data['register_end_time']) : '';
        }
        return '';
    }
    /**
     * 活动时间
     * @param $value
     * @param $data
     * @return string
     */
    public function getActivityTimeTextAttr($value, $data)
    {
        if(isset($data['activity_start_time'])) {
            return $data['activity_start_time'] ? date('Y-m-d H:i', $data['activity_start_time']).' - ' . date('Y-m-d H:i', $data['activity_end_time']) : '';
        }
        return '';
    }
    /**
     * 活动状态
     * @param $value
     * @param $data
     * @return string
     */
    public function getStatusTextAttr($value, $data)
    {
        if (!isset($data['activity_start_time'])) {
            return '';
        }
        if (time() >= $data['activity_start_time'] && ($data['activity_end_time']) >= time()) {
            $status_text = "进行中";
            $status = 1;
        } elseif (time() > ($data['activity_end_time'])){
            $status_text = "已结束";
            $status = 2;
        } else {
            $status_text = "未开始";
            $status = 0;
        }
        if (time() >= $data['register_start_time'] && ($data['register_end_time']) >= time()) {
            $reg_status_text = "进行中";
            $reg_status = 1;
        } elseif (time() > ($data['register_end_time'])) {
            $reg_status_text = "已结束";
            $reg_status = 2;
        } else {
            $reg_status_text = "未开始";
            $reg_status = 0;
        }
        $result = [
            "status" => $status,
            "status_text" => $status_text,
            "reg_status" => $reg_status,
            "reg_status_text" => $reg_status_text,
            "act_start_time" => date("Y-m-d H:i", $data['activity_start_time']),
            "act_end_time" => date("Y-m-d H:i", $data['activity_end_time']),
            "reg_end_time" => date("Y-m-d H:i", $data['register_end_time'])
        ];
        return $result;
    }

    /**
     * 审核状态文本
     * @param $value
     * @param $data
     * @return string
     */
    public function getAuditStatusTextAttr($value, $data)
    {
        $status = isset($data['audit_status']) ? $data['audit_status'] : 0;
        $text = [0=>'待审核',10=> '已通过', 20=> '已驳回'];
        return [
            'status' => $status,
            'text' => $text[$status] ?? '待审核'
        ];
    }

    /**
     * 活动详情
     */
    public static function detail($activity_id)
    {
        return (new static())->with(['image', 'category', 'branch', 'pic', 'visitSupplier', 'spaceSupplier'])->find($activity_id);
    }

    /**
     * 更新报名人数
     */
    public static function incTotal($activity_id, $inc = 1)
    {
        $res = self::detail($activity_id);
        if ($res) {
            $total = $res['total'] + $inc;
            // if ($res['limit_num'] && $res['limit_num'] < $total) {
            //     $total = $res['limit_num'];
            // }
            $res->save(['total' => $total]);
        }
    }

    /**
     * 批量更新活动
     * @param $activityIds
     * @param $data
     * @return bool
     */
    public static function onBatchUpdate($activityIds, $data)
    {
        $model = new static();
        return $model->where('activity_id', 'in', $activityIds)->save($data);
    }

    /**
     * 获取活动数据 (可指定某天)
     */
    public function getActivityData($startDate = null, $endDate = null, $type, $branch_id = 0)
    {
        $model = $this;
        !is_null($startDate) && $model = $model->where('create_time', '>=', strtotime($startDate));
        if (is_null($endDate)) {
            !is_null($startDate) && $model = $model->where('create_time', '<', strtotime($startDate) + 86400);
        } else {
            $model = $model->where('create_time', '<', strtotime($endDate) + 86400);
        }
        if ($branch_id > 0) {
            $model = $model->where('branch_id', '=', $branch_id);
        }
        $model = $model->where('is_delete', '=', 0);
        if ($type == 'activity_total') {
            return $model->count();
        }
        return 0;
    }

    /**
     * 分会排行榜
     */
    public function getBranchRankList($date, $parent_branch_id, $limit = 7)
    {
        return $this->alias('A')
            ->join('branch B', 'A.branch_id=B.branch_id')
            ->field('count(A.activity_id) as total,B.name as branch_name')
            ->when($date, function ($query, $date) {
                getModelTime($query, $date, 'A.create_time');
            })
            ->where('B.parent_branch_id', '=', $parent_branch_id)
            ->where('A.is_delete', '=', 0)
            ->group('A.branch_id')
            ->order('total DESC')
            ->limit($limit)
            ->select();
    }

    /**
     * 检查走访企业30天内是否已被走访
     * @param int $visit_supplier_id 被走访企业ID
     * @param int $visit_supplier_name 被走访企业名称
     * @param int $exclude_activity_id 排除的活动ID（编辑时使用）
     * @return array|bool 返回剩余天数或false
     */
    public function checkVisitLimit($visit_supplier_id, $visit_supplier_name, $exclude_activity_id = 0)
    {
        // 查询30天内该分会是否走访过该企业
        $thirtyDaysAgo = time() - (30 * 24 * 3600);
        
        $query = $this
            ->where('is_delete', '=', 0)
            ->where('create_time', '>', $thirtyDaysAgo);
        if ($visit_supplier_id!=0){
            $query = $query->where('visit_supplier_id', '=', $visit_supplier_id);
        }elseif ($visit_supplier_name!=''){
            $query = $query->where('visit_supplier_name', '=', $visit_supplier_name);
        }
        // 如果是编辑操作，排除当前活动
        if ($exclude_activity_id > 0) {
            $query =  $query->where('activity_id', '<>', $exclude_activity_id);
        }
        
        $recentVisit = $query->order('create_time', 'desc')->find();
        
        if ($recentVisit) {
            // 计算剩余天数
            $daysSinceVisit = floor((time() - strtotime($recentVisit['create_time'])) / (24 * 3600));
            $remainingDays = 30 - $daysSinceVisit;
            return [
                'visited' => true,
                'remaining_days' => max(0, $remainingDays),
                'last_visit_time' => $recentVisit['create_time'],
                'activity_id' => $recentVisit['activity_id']
            ];
        }
        
        return false;
    }
}