Yii2 REST do sorting when response JSON

Question

When the JSON format is response, the original sorting of the data is lost. When response in XML, the sort is saved. How can I preserve the original sorting with JSON?

My controller:

use yii\rest\ActiveController;

class  DomainController extends ActiveController
{
    ...
    public function behaviors()
    {
      $behaviors = parent::behaviors();
      $behaviors['corsFilter' ] = [
          'class' => \yii\filters\Cors::className(),
      ];

      $behaviors['contentNegotiator'] = [
        'class' => \yii\filters\ContentNegotiator::className(),
        'formats' => [
            'application/json' => \yii\web\Response::FORMAT_JSON,
        ],
      ];

      return $behaviors;
    }

And action in the controller:

public function actionIndex()
{
    $domains =  Domain::find()
        ->leftJoin('WEB_DOMAIN_PRIORITY', 'WEB_DOMAIN_PRIORITY.id = WEB_DOMAIN.priority_id')
        ->orderBy(['priority' => SORT_DESC])->all();

    $test = [];

    foreach ($domains as $domain) {
        $test[$domain->id] = $domain->title;
    }
    //echo "<pre>"; print_r($test);die;  < -- its ok. right sort
    //return $test;                      < -- its wrong. sort is changed
}

And if i change in behavior this:

'application/json' => \yii\web\Response::FORMAT_JSON,

To:

'application/json' => \yii\web\Response::FORMAT_XML,

I have xml response with right sort.

Only JSON response sorting my array by array keys(ASC).

Fabrizio Caldarelli · Accepted Answer · 2018-03-16 10:46:33Z

1

Here

$test[$domain->id] = $domain->title;

you are adding new array keys. This could change order based on rest/Serializer.

You could apply preserveKeys to serializer as here http://www.yiiframework.com/doc-2.0/yii-rest-serializer.html#$preserveKeys-detail or don't change keys order.

answered Mar 16, 2018 at 10:46

Fabrizio Caldarelli

3,00813 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gud3 · Accepted Answer · 2018-03-19 06:50:04Z

0

@Fabrizio Caldarelli not exactly. In this moment response preparing JsonResponseFormatter and it use yii\helpers\Json::encode for format data.

answered Mar 19, 2018 at 6:50

gud3

5653 silver badges10 bronze badges

Collectives™ on Stack Overflow

Yii2 REST do sorting when response JSON

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related