$query=Work::find()
        ->select (['wkp_info.*', 'emp_first_name'])
     -> where(['wkp_master.wkp_year'=>$params['wkp_year'],
            'wkp_master.created_by'=>Yii::$app->getid->getId()])
     ->joinWith(['wkpMaster'])
     ->joinWith(['wkpAccountable'])
     ->joinWith(['entMaster.entMasterEntInfo'])
     ->joinWith(['entMaster.entMasterActivity'])
     ->joinWith(['entMaster.entMasterTavakkalnoki'])
     ->joinWith(['wkpAccountable.empMaster.empMasterEmpInfo'])  ;



    $dataProvider = new SqlDataProvider([
        'sql' => $query->createCommand()->getRawSql(),
        'sort' => ['enableMultiSort' => true],
        'sort'=> ['defaultOrder' => ['wkp_info_id'=>SORT_DESC]]
    ]);