在 Yii 2 中基于 yii\db\ActiveQuery::joinWith() 关联声明查询数据，响应字段类型为字符串的分析解决
1、在 \qq\rests\article_category\StandardIndexAction.php 中
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | /* @var $modelClass \yii\db\BaseActiveRecord */$modelClass = $this->modelClass;$query = $modelClass::find() ->joinWith('qqArticleCategoryNormal') ->where([ $modelClass::tableName() . '.is_deleted' => $modelClass::IS_DELETED_NO, QqArticleCategoryNormal::tableName() . '.is_deleted' => QqArticleCategoryNormal::IS_DELETED_NO, ]) ->asArray() ->orderBy([$modelClass::tableName() . '.id' => SORT_DESC]);if (!empty($filter)) { $query->andFilterWhere($filter);}// 设置每页资源数量默认为资源总数$count = (int) $query->count($modelClass::tableName() . '.id');if (empty($requestParams['per-page'])) { $requestParams['per-page'] = $count;}return Yii::createObject([ 'class' => ActiveDataProvider::className(), 'query' => $query, 'pagination' => [ 'params' => $requestParams, 'pageSizeLimit' => [1, $count], ], 'sort' => [ 'params' => $requestParams, ],]); |
2、期待的响应结果如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | "items": [ { "id": 226, "name": "其他综艺", "parent_id": 0, "status": 1, "is_deleted": 0, "created_at": 1542178227, "updated_at": 1542178227, "deleted_at": 0 }, { "id": 225, "name": "舞台剧", "parent_id": 0, "status": 1, "is_deleted": 0, "created_at": 1542178227, "updated_at": 1542178227, "deleted_at": 0 }] |
3、实际的响应结果如下：所有字段类型皆为字符串，如图1
图1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | "items": [ { "id": "67", "name": "跑步", "parent_id": "0", "status": "1", "is_deleted": "0", "created_at": "1542178227", "updated_at": "1542178227", "deleted_at": "0" }, { "id": "66", "name": "健身", "parent_id": "0", "status": "1", "is_deleted": "0", "created_at": "1542178227", "updated_at": "1542178227", "deleted_at": "0" }] |
4、编辑 \qq\rests\article_category\Serializer.php，打印 $models
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | class Serializer extends \yii\rest\Serializer{ /** * Serializes a data provider. * @param DataProviderInterface $dataProvider * @return array the array representation of the data provider. */ protected function serializeDataProvider($dataProvider) { if ($this->preserveKeys) { $models = $dataProvider->getModels(); } else { $models = array_values($dataProvider->getModels()); } $models = $this->serializeModels($models); var_dump($models); exit; }} |
5、打印结果如下，所有字段皆为字符串
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | array(67) { [0]=> array(9) { ["id"]=> string(2) "67" ["name"]=> string(6) "跑步" ["parent_id"]=> string(1) "0" ["status"]=> string(1) "1" ["is_deleted"]=> string(1) "0" ["created_at"]=> string(10) "1542178227" ["updated_at"]=> string(10) "1542178227" ["deleted_at"]=> string(1) "0" ["qqArticleCategoryNormal"]=> array(8) { ["id"]=> string(3) "334" ["article_category_id"]=> string(2) "67" ["name"]=> string(6) "跑步" ["status"]=> string(1) "1" ["is_deleted"]=> string(1) "0" ["created_at"]=> string(10) "1542178227" ["updated_at"]=> string(10) "1542178227" ["deleted_at"]=> string(1) "0" } }} |
6、编辑 \qq\rests\article_category\StandardIndexAction.php，删除 ->asArray()，因为仅需要当前模型的数据，不需要关联模型的数据(即 qqArticleCategoryNormal)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | /* @var $modelClass \yii\db\BaseActiveRecord */$modelClass = $this->modelClass;$query = $modelClass::find() ->joinWith('qqArticleCategoryNormal') ->where([ $modelClass::tableName() . '.is_deleted' => $modelClass::IS_DELETED_NO, QqArticleCategoryNormal::tableName() . '.is_deleted' => QqArticleCategoryNormal::IS_DELETED_NO, ]) ->orderBy([$modelClass::tableName() . '.id' => SORT_DESC]);if (!empty($filter)) { $query->andFilterWhere($filter);}// 设置每页资源数量默认为资源总数$count = (int) $query->count($modelClass::tableName() . '.id');if (empty($requestParams['per-page'])) { $requestParams['per-page'] = $count;}return Yii::createObject([ 'class' => ActiveDataProvider::className(), 'query' => $query, 'pagination' => [ 'params' => $requestParams, 'pageSizeLimit' => [1, $count], ], 'sort' => [ 'params' => $requestParams, ],]); |
7、实际的响应结果如下：字段类型与数据库中一致，符合预期，如图2
图2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | "items": [ { "id": 67, "name": "跑步", "parent_id": 0, "status": 1, "is_deleted": 0, "created_at": 1542178227, "updated_at": 1542178227, "deleted_at": 0 }, { "id": 66, "name": "健身", "parent_id": 0, "status": 1, "is_deleted": 0, "created_at": 1542178227, "updated_at": 1542178227, "deleted_at": 0 }] |
近期评论