<?php
/**
 * Created by PhpStorm.
 * User: xiaofeng
 * Date: 2018/5/21
 * Time: 下午5:18
 */

namespace common\models;


class PushmRecommend  extends Common
{

        public function rules()
        {
            return [
                [['url','title'],'required','message'=>'{attribute}不能为空'],
                ['url', 'url', 'defaultScheme' => 'http','message'=>'请输入正确的地址'],
                ['title','string','max'=>50],
                ['url','string','max'=>255],
                ['hid','number','message'=>'请选择楼盘'],
                ['sort','number','message'=>'排序只能是数字'],
                ['sort','number','max'=>10000],
            ];
        }

        public function attributeLabels()
        {
            return [
                'hid'=>'楼盘名称',
                'url'=>'地址',
            ];
        }


        public function Authenticator($input)
        {
            $this->load($input,'');
            if(!$this->validate()) return $this->errors;
            return $this;
        }

        public function FindById($id)
        {
            return self::findOne($id);
        }


        public function getList($input)
        {
            $query = self::find();
            $query->select(['id','title','create_at','is_show','url']);
            $query->andWhere(['del'=>$this->setDel]);
            if(!empty($input['page']))
            {
                $query->limit = $input['limit'];
                $query->offset = ($input['page']-1 )* $input['limit'];
            }
            return $query->orderBy(['create_at'=>SORT_DESC])->asArray()->all();
        }

        public function WhereColumn($query)
        {

        }

        public function Total()
        {
            $query = self::find();
            $query->andWhere(['del'=>$this->setDel]);
            return $query->count();
        }

        public function Homegetlist($limit)
        {
            $query = self::find();
            $query->select(['url','title']);
            $query->andWhere(['del'=>$this->setDel]);
            $query->andWhere(['is_show'=>1]);
            $query->orderBy(['sort'=>SORT_ASC]);
            $query->limit = $limit;
            return $query->all();
        }

}