DoNetSSS

Извините за мой код ведь я только учусь.
Вот как надо было сделать.

Контролер

public function actionIndex($nav = null)
    {
        $departments = Departments::getAll();
        $searchModel = new Payments();
        $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
        return $this->render('index', [
            'departments' => $departments,
            'dataProvider' => $dataProvider,
            'searchModel' => $searchModel,
        ]);
    }

Модель

class Payments extends ActiveRecord
{
    public $nameDepartments;
    public $nameExpenses;

    public function rules()
    {
        return [
            [['nameDepartments', 'nameExpenses', 'type', 'price', 'date', 'name'], 'safe'],
        ];
    }

    public function search($params, $where = null)
    {
        $query = Payments::find()->leftJoin(Expenses::tableName(), 'expenses.id = payments.idexpense')->leftJoin(Departments::tableName(), 'expenses.iddepartment = departments.id')->where($where);
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pagesize' => 20,
            ],
            'sort' => [
                'attributes' => ['name', 'type', 'price', 'date',
                    'nameDepartments' => [
                        'asc' => ['departments.name' => SORT_ASC],
                        'desc' => ['departments.name' => SORT_DESC],
                    ],
                    'nameExpenses' => [
                        'asc' => ['expenses.name' => SORT_ASC],
                        'desc' => ['expenses.name' => SORT_DESC],
                    ],
                ],
            ],
        ]);

        $this->load($params);

        if (!$this->validate()) {
            return $dataProvider;
        }

        $query->andFilterWhere([
            'id' => $this->id,
            'type' => $this->type,
            'price' => $this->price,
            'date' => $this->date,
        ]);

        $query->andFilterWhere(['like', 'payments.name', $this->name]);
        $query->andFilterWhere(['like', 'departments.name', $this->nameDepartments]);
        $query->andFilterWhere(['like', 'expenses.name', $this->nameExpenses]);

        return $dataProvider;
    }

    public function attributeLabels()
    {
        return array(
            'date' => 'Дата',
            'type' => 'Тип',
            'name' => 'Опис',
            'price' => 'Ціна',
            'nameDepartments' => 'Відділ',
            'nameExpenses' => 'Рахунок',
        );
    }

    public function getExpenses()
    {
        return $this->hasOne(Expenses::className(), ['id' => 'idexpense']);
    }

    public function getDepartments()
    {
        return $this->hasOne(Departments::className(), ['id' => 'iddepartment'])
            ->viaTable(Expenses::tableName(), ['id' => 'idexpense']);
    }

    public static function addPayments($input, $id)
    {
        $data = new Payments();
        $data->idexpense = $id;
        $data->name = $input['name'];
        $data->date = time();
        $data->type = $input['type'];
        $data->price = $input['price'];
        $data->save();
    }
}

Вюшка

<?= GridView::widget([
                        'dataProvider' => $dataProvider,
                        'filterModel' => $searchModel,
                        'columns' => [
                            [
                                'attribute'=>'date',
                                'format' => 'date',
                                'content'=>function($data){
                                    return date('Y-m-j G:i', $data['date']);
                                },
                            ],
                            [
                                'attribute'=>'nameDepartments',
                                'format' => 'text',
                                'content'=>function($data){
                                    return $data['departments']['name'];
                                }
                            ],
                            [
                                'attribute'=>'nameExpenses',
                                'format' => 'text',
                                'content'=>function($data){
                                    return $data['expenses']['name'];
                                }
                            ],
                            [
                                'attribute'=>'type',
                                'format' => 'text',
                                'content'=>function($data){
                                    return $data['type'] == 0 ? "Надходження" : "Видатки";
                                }
                            ],
                            'name',
                            'price',
                        ],
                        'layout' => '{items}<div class="text-center">{pager}</div>',
                    ]); ?>