pfhwyigou/common/models/LiveRemark.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2020/3/5
 * Time: 16:24
 */
namespace common\models;


class LiveRemark extends Common
{
    public function rules()
    {
        return [
//            ['mobile', 'match', 'pattern' => '/^1[23456789]\d{9}$/', 'message' => '请输入正确的手机号码'],
//            [['mobile', 'hid', 'content', 'ip'], 'required', 'message' => '{attribute}不能为空'],
            ['comment', 'string', 'max' => 200],
//            ['ip', 'ip'],
            ['lid','required', 'message' => '直播id不能为空'],
            [['del', 'is_show','initiator'], 'in', 'range' => [1, 2], 'message' => '请输入正确的信息'],
            [['del', 'is_show','initiator'], 'default', 'value' => 1],

        ];
    }

    public function getList($input)
    {
        $query = self::find();
//        $query->select(['pfg_house.name', 'pfg_live_remark.*']);
        $query->andWhere(['pfg_live_remark.lid' => $input['lid']]);
        $query->andWhere(['pfg_live_remark.del' => 1]);
        $query->andWhere(['pfg_live_remark.is_show' => $this->is_show]);

//        $query->leftJoin('pfg_house', 'pfg_house_comment.hid=pfg_house.id');
        $data['count'] =$query->count();
        if (!empty($page['page'])) {
            $query->offset = ($page['page'] - 1) * $page['limit'];
            $query->limit = $page['limit'];
        }
        $data['data'] = $query->orderBy(['pfg_live_remark.create_at'=>SORT_DESC])->asArray()->all();

        return $data;
    }


}