社区首页 >问答首页 >如何在Yii2中获取按类别排序项的参数？

问如何在Yii2中获取按类别排序项的参数？
EN

Stack Overflow用户

提问于 2015-02-17 09:32:48

回答 1查看 946关注 0票数 0

我使用Yii2高级模板。在我的数据库表中，我有带有categry字段的项(从1..(至inf)

主计长的行动：

public function actionIndex()
{
    $searchModel = new AdsSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);

    return $this->render('index', [
        'searchModel' => $searchModel,
        'dataProvider' => $dataProvider,
    ]);
}

查看：

<?= ListView::widget([
    'dataProvider' => $dataProvider,
    'itemOptions' => ['class' => 'item'],
    'itemView' => '_item_view',,
]) ?>

我已经启用了prettyUrl

'urlManager' => [
            'enablePrettyUrl' => true,
            'showScriptName' => false,
        ],

和前端/web/中的.htaccess

RewriteEngine on

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . index.php

1)如何显示仅按类别查找的项目？现在mysite.com/items显示了所有具有混合类别的项目，我想要使mysite.com/ items /cat/1或mysite.com/items/1使用category = 1显示类别。

( 2)是否有文章将mysite.com/items/类别-name-url改为编号？我将类别名称存储在$app->params中。下一个带有id = 5的项目页面将是mysite.com/items/items name-url/5。

php

.htaccess

url-routing

yii2

回答 1

Stack Overflow用户

回答已采纳

发布于 2015-02-17 11:00:07

1)在urlManager中的配置中放置：

'items/cat/<id:\d+>' => '{YOUR_CONTROLLER}/{YOUR_ACTION}',

在controller中是这样的：

public function actionIndex($id) // yii2 provide $id form url
    {                         

        $dataProvider = new ActiveDataProvider([
            'query' => AdsSearch::find()->where(['category' => $id]),
            'pagination' => [
                'pageSize' => 20,
            ],
        ]);

        return $this->render('index', [
            'dataProvider' => $dataProvider,
            'category' => $category
        ]);
    }

2)在urlManager中的配置中放置：

'items/<category>' => '{YOUR_CONTROLLER}/{YOUR_ACTION}',

在controller中

$subCategory = Yii::$app->request->get('category');

        $dataProvider = new ActiveDataProvider([
            'query' => AdsSearch::find()->where(['categoryUrl' => $subCategory]),
            'pagination' => [
                'pageSize' => 20,
            ],
        ]);

        return $this->render('index', [
            'dataProvider' => $dataProvider,
            'category' => $category
        ]);

或者在我的项目中，比如Category和Goods模型：

$category = Category::findOne(['url' => $subCategory]);

        $dataProvider = new ActiveDataProvider([
            'query' => Goods::find()->where(['categoryId' => $category->id])->with('mainPhoto'),
            'pagination' => [
                'pageSize' => 20,
            ],
        ]);

        return $this->render('index', [
            'dataProvider' => $dataProvider,
            'category' => $category
        ]);