How to view alphabetically - Cakephp

Question

I’m listing neighborhoods, when I select instead of taking the list value, the json_encode is returning to her position. ex:

-BARRIO I -WARD II

If I select the "NEIGHBORHOOD II", it will return me: "1"

"0"-QUARTER I "1"-QUARTER II ...

Follow the code:

    public function pegarBairros ($cidade = null) {
    $this->layout = 'json';
    $result = array();

    if (in_array($_REQUEST['cidade'], array_keys($this->cidade))) {
        $this->loadModel('Bairro');
        $bairros = $this->Bairro->find('list', array('fields' => array('id','bairro'), 'conditions' => array('cidade' => $this->cidade[$_REQUEST['cidade']]),'group' => 'bairro'));
        sort($bairros);     
        foreach ($bairros as $bairro) 
            if (!empty($bairro)){
                $result[] = $bairro;
                $arr = $result;
                json_encode($arr);
            }
    } else $result[] = 'error';
    $this->set('data', $arr);
}

for me to show, I use so:

echo $this->Form->input('bairro', array('label' => 'Bairro', 'empty' => 'Selecione o Bairro', 'options' => array() ));

What’s wrong with the code?

E How to sort the neighborhoods in this line in Cakephp?

$bairros = $this->Bairro->find('list', 
    array('fields' => array('id','bairro'), 
          'conditions' => array('cidade' => $this->cidade[$_REQUEST['cidade']])
    )
);

Answer 1

It wouldn’t be because you’re assigning value to the array without declaring index?

In this case, the interpreter automatically aggregates index 0 at the beginning of the array.

foreach ($bairros as $bairro) 
        if (!empty($bairro)){
            $result[] = $bairro;
            $arr = $result;
            json_encode($arr);
        }
} else $result[] = 'error';

Try this:

\\Seu código...
foreach ($bairros as $indice => $bairro) {
        if (!empty($bairro)){
            $result[$indice] = $bairro;
        }
 }
 //após iteração(foreach) de todo array, usar encode.
 json_encode($result);
} else {
$result = false;

Using the pattern

foreach ($array as $key => $value)

It provides the index of the array you obtained in find('list', $params) through the variable $key .

Answer 2

Possibly the error is mounting the neighborhood array.

Your problem is the Sort function. It reorders the array indexes, if you place the database ordering your problem is solved.

Cakephp allows using the following positions as the find parameter.

array(
    'conditions' => array('Model.field' => $thisValue), //array of conditions
    'recursive' => 1, //int
    //array of field names
    'fields' => array('Model.field1', 'DISTINCT Model.field2'),
    //string or array defining order
    'order' => array('Model.created', 'Model.field3 DESC'),
    'group' => array('Model.field'), //fields to GROUP BY
    'limit' => n, //int
    'page' => n, //int
    'offset' => n, //int
    'callbacks' => true //other possible values are false, 'before', 'after'
)

so that json stays that way:

{
    'bairros' : [
        'bairro1' : 1 // bairro => id,
        'bairro2' : 2,
        'bairro3' : 3
     ],
     success : true
}

PHP would look like this

public function pegarBairros ($cidade = null) {
    $this->layout = 'json';
    $result = array();

    if (in_array($_REQUEST['cidade'], array_keys($this->cidade))) {
        $this->loadModel('Bairro');
        $bairros = $this->Bairro->find( 'list', array(
             'fields' => array( 'bairro','id' ),
             'conditions' => array('cidade' => $this->cidade[$_REQUEST['cidade']]),
             'group' => 'bairro'),
             'order' => array('Bairro.bairro' => 'ASC')
        );
        $result['bairros'] = $bairros;
        $result['success'] = true;
    } else {
        $result['success'] = false;
    }
    $return = json_encode($result);
    $this->set('data', $return);
}

so that json stays that way:

{
    'bairros' : [
        1 : 'bairro1' // id => bairro,
        2 : 'bairro2',
        3 : 'bairro3'
     ],
     success : true
}

PHP would look like this

public function pegarBairros ($cidade = null) {
    $this->layout = 'json';
    $result = array();

    if (in_array($_REQUEST['cidade'], array_keys($this->cidade))) {
        $this->loadModel('Bairro');
        $bairros = $this->Bairro->find( 'list', array(
             'fields' => array( 'id','bairro' ),
             'conditions' => array('cidade' => $this->cidade[$_REQUEST['cidade']]),
             'group' => 'bairro'),
             'order' => array('Bairro.bairro' => 'ASC')
        );    
        $result['bairros'] = $bairros;
        $result['success'] = true;
    } else {
        $result['success'] = false;
    }
    $return = json_encode($result);
    $this->set('data', $return);
}

Source Cakephp

Answer 3

Just add the parameter order:

$bairros = $this->Bairro->find('list', array('order' => array('Bairro.bairro ASC'), 'fields' => array('id','bairro'), 'conditions' => array('cidade' => $this->cidade[$_REQUEST['cidade']])));

The ASC is not necessary in this case, as we well know in SQL, put so that you can see that there is this possibility, both ASC how much DESC.