<?php

namespace app\admin\model;

use think\Model;

class Exclusive extends Model
{
    // 表名
    protected $table = 'exclusive';
    
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    
    // 追加属性
    protected $append = [
        'endtime_text',
        'createtime_text'
    ];
    

    public function getEndtimeTextAttr($value, $data)
    {
        $value = $value ? $value : $data['endtime'];
        return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
    }


    public function getCreatetimeTextAttr($value, $data)
    {
        $value = $value ? $value : $data['createtime'];
        return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
    }

    protected function setEndtimeAttr($value)
    {
        return $value && !is_numeric($value) ? strtotime($value) : $value;
    }

    protected function setCreatetimeAttr($value)
    {
        return $value && !is_numeric($value) ? strtotime($value) : $value;
    }

    public function getAllBindChannelIds(){
        $sql = "SELECT DISTINCT ec.cid FROM `exclusive_channel` AS ec INNER JOIN `exclusive` AS e ON ec.eid=e.id WHERE e.endtime>".time()." AND e.status=1";
        $rs = $this->query($sql);
        if(!empty($rs)){
            $result = array_column($rs,'cid');
        }else{
            $result = [];
        }
        return $result;
    }
}