pfhwyigou/common/models/DayToutiao.php

<?php


namespace common\models;


class DayToutiao extends Common
{

    public function rules()
    {
        return [

        ];
    }
    /*
     * 获取数据列表
     * */
    public function getList($input)
    {
        $query = self::find();
        $query->select(['pfg_day_toutiao.*','pfg_list_classnev.day_title']);
        if(!empty($input['name'])){
            $query->andFilterWhere(['like','pfg_day_toutiao.name',$input['name']]);
        }
        if(!empty($input['list_id'])){
            $query->andFilterWhere(['pfg_day_toutiao.list_id'=>$input['list_id']]);
        }
        if(!empty($input['efficacious'])){
            $query->andFilterWhere(['pfg_day_toutiao.efficacious'=>$input['efficacious']]);
        }
        if(!empty($input['send_state'])){
            $query->andFilterWhere(['pfg_day_toutiao.send_state'=>$input['send_state']]);
        }
        $count = $query->count();
        if(!empty($input['page'])){
            $query->offset(($input['page']-1)*$input['limit']);
            $query->limit($input['limit']);
        }
        $query->leftJoin('pfg_list_classnev','pfg_list_classnev.id = pfg_day_toutiao.list_id');
        $data = $query->orderBy(['pfg_day_toutiao.create_at'=>SORT_DESC,'pfg_day_toutiao.efficacious'=>SORT_DESC])->asArray()->all();
        foreach ($data as &$val){
            $val['create_time'] = date('Y-m-d H:i:s',$val['create_at']);
        }
        return ['count'=>$count,'data'=>$data];
    }
}