pfhwyigou/common/models/PushmColumn.php

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

namespace common\models;


class PushmColumn  extends Common
{

        public function rules()
        {
            return [
                ['did', 'unique','on'=>['add'],'message'=>'栏目ID已存在','filter'=>function($query){
                    return  $query->andWhere(['type'=>$this->type]);
                }],

                ['img','string','max'=>200],
                ['img_a','string','max'=>200],
                ['did','number'],
                ['type','number'],
                ['type','in','range'=>[1,2,3]],
                ['sort','number','message'=>'排序只能是数字'],
                ['sort','number','max'=>100000],
                ['sort','default','value'=>0],
                ['is_show','default','value'=>1],
            ];
        }

        public function attributeLabels()
        {
            return [
                'did'=>'栏目ID',
                'sort'=>'排序',
            ];
        }

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

        public function getList($input)
        {
            $arr = [];
            $query = self::find();
            $query->select(['pfg_developers.name','pfg_pushm_column.*']);
            $query->andFilterWhere(['pfg_pushm_column.type'=>$this->type]);
            $query->innerJoin('pfg_developers','pfg_pushm_column.did=pfg_developers.id');
            if(!empty($input['page']))
            {
                $count = clone $query;
                $arr['total'] = $count->count();
                $query->limit = $input['limit'];
                $query->offset = ($input['page']-1 )* $input['limit'];
            }
                $arr['data'] = $query->orderBy(['pfg_pushm_column.sort'=>SORT_DESC,'pfg_pushm_column.create_at'=>SORT_DESC])->asArray()->all();
            return $arr;
        }



}