<?php

namespace app\common\model\plus\groupbuy;

use app\common\library\helper;
use app\common\model\BaseModel;

/**
 * 团购活动模型
 */
class Active extends BaseModel
{
    protected $name = 'groupbuy_active';
    protected $pk = 'groupbuy_active_id';

    /**
     * 关联文件表
     */
    public function file()
    {
        return $this->belongsTo('app\\common\\model\\file\\UploadFile', 'image_id', 'file_id');
    }
    public function getEndTimeAttr($value)
    {
        return date('Y-m-d H:i:s', $value);
    }
    public function getStartTimeAttr($value)
    {
        return date('Y-m-d H:i:s', $value);
    }
    /**
     * 获取活动详情
     */
    public static function detail($groupbuy_active_id,$with = ['file'])
    {
        return (new static())->with($with)->where('groupbuy_active_id', '=', $groupbuy_active_id)->find();
    }

    /**
     * 获取有效的团购活动
     */
    public static function getValidActive()
    {
        return (new static())
            ->where('start_time', '<=', time())
            ->where('end_time', '>', time())
            ->where('status', '=', 1)
            ->where('is_delete', '=', 0)
            ->order(['sort' => 'asc', 'create_time' => 'desc'])
            ->find();
    }

    /**
     * 获取活动列表
     */
    public function getList($param)
    {
        $model = $this;
        if (isset($param['status']) && $param['status'] > -1) {
            $model = $model->where('status', '=', $param['status']);
        }
        if (isset($param['title']) && !empty($param['title'])) {
            $model = $model->where('active_name', 'like', '%' . trim($param['title']) . '%');
        }
        $res = $model->with(['file'])
            ->order('create_time', 'desc')
            ->paginate($param);

        foreach ($res as $key => $val) {
            $res[$key]['start_time'] = format_time($val['start_time']);
            $res[$key]['end_time'] = format_time($val['end_time']);
        }
        return $res;
    }
}