<?php
/**
 * Created by PhpStorm.
 * User: xiaofeng
 * Date: 2018/3/4
 * Time: 上午9:25
 */

namespace common\models;

class PushmMansion extends Common
{
     public $house_name; //搜索楼盘名字

	 public function rules()
     {
        return [
            ['reason','string','max'=>20],
            [['hid'],'required','message'=>'{attribute}不能为空'],
            ['did','number'],
            ['haoqi', 'compare', 'compareValue' => 5, 'operator' => '<='],
            ['jingmi', 'compare', 'compareValue' => 5, 'operator' => '<='],

        ];
     }

    public function attributeLabels()
    {
        return [
           'hid'=>'楼盘名称',
           'reason'=>'推荐理由',
        ];
    }

    public function getList($page)
    {
        $query = self::find();
        $query->select(['pfg_house.name','pfg_pushm_mansion.*','pfg_developers.name as dname']);
        $query->andWhere(['pfg_pushm_mansion.del'=>1]);
        $query->leftJoin('pfg_house','pfg_pushm_mansion.hid=pfg_house.id');
        $query->leftJoin('pfg_developers','pfg_pushm_mansion.did=pfg_developers.id');
        if(!empty($page['house_name']))
        {
            $query->andWhere(['like','pfg_house.name',$page['house_name']]);
        }

        if(!empty($page['page']))
        {
            $query->offset = ($page['page'] - 1) * $page['limit'];
            $query->limit = $page['limit'];
        }

        $query->orderBy(['pfg_pushm_mansion.sort'=>SORT_DESC,'pfg_pushm_mansion.create_at'=>SORT_DESC])->asArray();
        return $query->all();
    }

    public function Total($page)
    {
        $query = self::find();
        $query->select(['pfg_house.name','pfg_pushm_mansion.*']);
        $query->innerJoin('pfg_house', 'pfg_pushm_mansion.hid=pfg_house.id');
        $query->andWhere(['pfg_pushm_mansion.del'=>1]);
        $query->andFilterWhere(['pfg_pushm_mansion.hid'=>$this->hid]);
        if(!empty($page['house_name']))
        {
            $query->andWhere(['like','pfg_house.name',$page['house_name']]);
        }

        return $query->count();
    }


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


}