use common\models\Podkategoria;
use common\models\PodkategoriaSearch;


public function actionView($id)
    {
        $searchModel = new PodkategoriaSearch();

        $totalCount = Yii::$app->db->createCommand('SELECT COUNT(*) FROM podkategoria WHERE kategoria_id='.$id, [':kategoria_id' => 1])
			->queryScalar();


        $dataProvider = new SqlDataProvider([
            'sql' => 'SELECT * FROM podkategoria WHERE kategoria_id='.$id,
            'params' => [':id' => 1],
            'totalCount' => $totalCount,
            'sort' => [
                'attributes' => [
                    'name' => [
                        'asc' => ['name' => SORT_ASC],
                        'desc' => ['name' => SORT_DESC],
                        'label' => 'Name',
                    ],
                ],
            ],
            'pagination' => [
                'pageSize' => 20,
            ],
        ]);

        return $this->render('view', [
            'model' => $this->findModel($id),
            'dataProvider' => $dataProvider,
        ]);
    }