pfhwyigou/common/models/HouseAuditingrecord.php

<?php
/**
 * Created by PhpStorm.
 * User: xiaofeng
 * Date: 2018/4/8
 * Time: 上午8:46
 */

namespace common\models;

//use yii\db\ActiveRecord;
//use yii\behaviors\TimestampBehavior;
class HouseAuditingrecord  extends Common
{
//    public $setDel = 1;
//    public function behaviors()
//    {
//        return [
//            [
//                'class' => TimestampBehavior::className(),
//                'attributes' => [
//                    # 创建之前
//                    ActiveRecord::EVENT_BEFORE_INSERT => ['create_at', 'update_at'],
//                    # 修改之前
//                    ActiveRecord::EVENT_BEFORE_UPDATE => ['update_at']
//                ],
//                #设置默认值
//                'value' => $_SERVER['REQUEST_TIME']
//            ]
//        ];
//    }
    public function rules()
    {
        return [
            [['reason','hid','uid','house_state'],'required','message'=>'{attribute}不能为空'],
            ['reason','string','max'=>255],
        ];
    }

    public function attributeLabels()
    {
        return [
            'reason'=>'说明',
            'hid'=>'楼盘ID',
            'uid'=>'用户ID',
            'house_state'=>'楼盘状态',
        ];
    }

    public function getList()
    {
        $query = self::find();
        $query->select(['pfg_house_auditingrecord.*','pfg_user.name']);
        $query->andFilterWhere(['pfg_house_auditingrecord.hid'=>$this->hid]);
        $query->leftJoin('pfg_user','pfg_house_auditingrecord.uid = pfg_user.uid');
        $query->orderBy(['pfg_house_auditingrecord.create_at'=>SORT_DESC]);
        return $query->asArray()->all();
    }

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

}