<?php

namespace app\admin\model;

use think\Model;
use think\Request;
use think\Config;

class Download extends Model {

    use \app\common\traits\AdminModel;

    protected $insert = ['createtime', 'updatetime'];
    protected $update = ['updatetime'];

    public function getCategoryDownloadList($where = null, $order = null, $field = null, $limit = null) {
        $this->alias('a')->join('download_category c', 'a.cid=c.id', 'LEFT');
        if (is_array($where)) {
            $where = array_merge(['a.stat' => ['eq', '0'], 'c.stat' => ['eq', '0']], $where);
        }
        if ($where) {
            $this->where($where);
        }
        if ($order) {
            $this->order($order);
        }
        if ($field) {
            $this->field($field);
        }
        if ($limit) {
            $this->limit($limit);
        }
        $data = $this->select();
        return $data;
    }

    public function getCategoryDownloadLists($where = null, $order = null, $field = null, $limit = null) {
        $this->alias('a')
                ->join('download_category c', 'a.cid=c.id', 'LEFT');
        //->join('user u', 'a.id=u.id', 'LEFT');
        //$this->where('c.stat', ['eq', '0'], ['null', ''], 'or');
        if (is_array($where)) {
            $where = array_merge(['a.stat' => ['eq', '0'], 'c.stat' => ['eq', '0']], $where);
        }
        if ($where) {
            $this->where($where);
        }
        if ($order) {
            $this->order($order);
        }
        if ($field) {
            $this->field($field);
        }
        if (empty($limit)) {
            $limit = Config::get('list_rows');
        }
//        $this->fetchsql(true);
        $object = $this->paginate($limit);
//        header("content-type:text/html;charset=utf8;");
//        print_r($object);
//        exit;
        return $object;
    }

    public function getRecycleLists($where = null, $order = null, $field = null, $limit = null) {
        $this->alias('a')
                ->join('download_category c', 'a.cid=c.id', 'LEFT');
        //->join('user u', 'a.id=u.id', 'LEFT');
        if ($where) {
            $this->where($where);
        }
        if ($order) {
            $this->order($order);
        }
        if ($field) {
            $this->field($field);
        }
        if (empty($limit)) {
            $limit = Config::get('list_rows');
        }
        //$this->fetchsql(true);
        $object = $this->paginate($limit);
//        header("content-type:text/html;charset=utf8;");
//        print_r($object);
//        exit;
        return $object;
    }

    // 属性修改器 创建时间
    protected function setCreatetimeAttr($value, $data) {
        return time();
    }

    // 属性修改器 更新时间
    protected function setUpdatetimeAttr($value, $data) {
        return time();
    }

    // 属性修改器 设置注册ip
    protected function setIpAttr() {
        return Request::instance()->ip();
    }

    protected function setContentAttr($content, $data) {
        if (!empty($content)) {
            $config = \HTMLPurifier_Config::createDefault();
            $purifier = new \HTMLPurifier($config);
            $content = $purifier->purify($content);
        }
        return $content;
    }

}