Structure JSON output in cakePHP

Question

What is the simplest and best practice way to customise the JSON output in cakephp 2.x.

I have the following in my controller:

$questions = $this->Question->find('threaded', array(
  'fields' => array(
    'label',
    'id',
    'parent_id',
    'load_on_demand'
   ),
  'order' => array('lft ASC') 
));

$questions= $this->set('questions', $questions);

$this->set('_serialize', 'json');

I have the following JSON (truncated);

{
    "Question": {
        "id": "27",
        "parent_id": "0",
        "load_on_demand": "true",
        "label": "Main Menu"
    },
    "children": [
        {
            "Question": {
                "id": "28",
                "parent_id": "27",
                "load_on_demand": "true",
                "label": "Web Development"
            },

but I need it to be like the following example in jqTree;

{
    label: 'node1',
    children: [
        { label: 'child1' },
        { label: 'child2' }
    ]
},
{
    label: 'node2',
    children: [
        { label: 'child3' }
    ]
}

José Lorenzo Rodríguez · Accepted Answer · 2014-08-27 14:06:43Z

3

Just use the Hash class before setting the results:

function buildQuestion(){

$questions = $this->Question->find('all', array(
  'fields' => array('label', 'id', 'parent_id','load_on_demand'),
  'order' => array('lft ASC')
));

 $results = Hash::extract($questions, '{n}.Question');
 $results = Hash::nest($results, ['idPath' => '{n}.id', 'parentPath' => '{n}.parent_id');

answered Aug 27, 2014 at 14:06

José Lorenzo Rodríguez

9,62437 silver badges32 bronze badges

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

Comments

Momin · Accepted Answer · 2014-08-27 13:34:35Z

0

First of all, you shouldn't use find for these custom labeling or Rest api code. its simply because using any ORM might fetch extra data/object to that api, consuming lots of memory for bulk requests. Use sql like :

Select `Question`.`id` as `id`, .....
from `Question`
INNER JOIN `children` on `children`.`parent_id` = `Question`.`id`
where .......
//I cant say much about the query as the model aint clear to me

This might help if you want to add extra field. remember to alias the fields needed.

answered Aug 27, 2014 at 13:34

Momin

86812 silver badges22 bronze badges

Collectives™ on Stack Overflow

Structure JSON output in cakePHP

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