1. In \qq\rests\article_category\StandardIndexAction.php
PHP
/* @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. The expected response result is as follows:
JSON
"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. The actual response result is as follows: all field types are strings, as shown in Figure 1
JSON
"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. Edit \qq\rests\article_category\Serializer.php to print $models
PHP
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. The print result is as follows, all fields are strings
Plaintext
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. Edit \qq\rests\article_category\StandardIndexAction.php and remove ->asArray(), because only the current model’s data is needed, not the related model’s data (i.e., qqArticleCategoryNormal)
PHP
/* @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. The actual response result is as follows: the field types are consistent with those in the database, meeting expectations, as shown in Figure 2
JSON
"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
}
]