<?php

namespace app\admin\model\course;

use think\Model;
use app\admin\model\course\GroupBind;

class Live extends Model
{
    // 表名
    protected $name = 'course';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'integer';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = false;


    // 追加属性
    protected $append = [
        'live_status',
        'live_status_text',
        'live_start_time_text'
//        'pay_type_text',
//        'validity_type_text',
//        'validity_diy_time_text',
//        'validity_fix_time_text',
//        'shelf_time_text',
//        'unshelf_time_text'
    ];

    /**
     * 通过优惠券 ids 集合获取可正常展示的优惠券
     * @param $ids
     * @return void
     */
    public function idsGetLives($ids,$limit=0){

        $lives = self::normal()
            ->where([
                'id'=>['in',$ids]
            ])   // 符合指定商品，并且检测商品所属分类
            ->order('id', 'desc');

        if($limit){
            $lives = $lives->limit($limit);
        }

        $lives = $lives->select();

        $lives = collection($lives)->each(function ($coupon) {

        });

        return $lives;
    }


    public function scopeNormal($query)
    {
        return $query->where([
            'status'=>1,
            'sales_type'=>['like',"%alone%"],
            'hide'=>0,
            'type'=>'live'
        ]);
    }

    /**
     * 直播中
     * @param $query
     * @return void
     */
    public function scopeIng($query){
        return $query->where([
            'live_start_time'=>['<',time()],
            'live_end_time'=>['>',time()]
        ]);
    }

    /**
     * 未开始
     * @param $query
     * @return void
     */
    public function scopeUnstart($query){
        return $query->where([
            'live_start_time'=>['>',time()]
        ]);
    }


    /**
     * 已结束
     * @param $query
     * @return void
     */
    public function scopeEnd($query){
        return $query->where([
            'live_end_time'=>['<',time()]
        ]);
    }

    /**
     * 最近直播
     * @param $query
     * @return void
     */
    public function scopeRecently($query){
        return $query->order('live_start_time','desc');
    }

    /**
     * 最近直播
     * @param $query
     * @return void
     */
    public function scopeFieldLimit($query){
        return $query->field(['id','name','price','price_marking','pay_type','cover','briefing','status','live_start_time','live_end_time']);
    }


    /**
     * 直播状态
     * @return void
     */
    public function getLiveStatusList()
    {
        return [
            'ing'=>'直播中',
            'recently'=>'最近直播',
            'unstart'=>'未开始',
            'end'=>'已结束'
        ];
    }

    public function getLiveStatusAttr($value, $data)
    {

        if($data['live_end_time'] < time()){
            return 'end';
        }

        if($data['live_start_time'] > time()){
            return 'unstart';
        }

        if($data['live_end_time'] > time() && $data['live_start_time'] < time()){
            return 'ing';
        }
    }

    public function getLiveStatusTextAttr($value, $data)
    {
        $liveStatusList = $this->getLiveStatusList();
        return $liveStatusList[$this->getLiveStatusAttr($value, $data)];
    }

    public function getLiveStartTimeTextAttr($value, $data)
    {
        return date('Y-m-d H:i',$data['live_start_time']);
    }


    public function getPayTypeList()
    {
        return ['free' => __('Free'), 'pay' => __('Pay'), 'password' => __('Password')];
    }


    public function getTypeTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['type']) ? $data['type'] : '');
        $list = $this->getTypeList();
        return isset($list[$value]) ? $list[$value] : '';
    }

}