Sort Birthdays per Day

2

Well, I needed some help to display the Birthdays of the Month sorted by the day, in the bank it pulls the information from the Senior so the date comes ex: 1970-10-30, in my controller it looks like this:

public function index()

{
    $condicoes['order'] = array('Funcionario.data_nascimento' => 'ASC');
    $condicoes['conditions'] = array(
        'Funcionario.situacao_afastamento <>' => 7,
        "DATE_FORMAT(Funcionario.data_nascimento, '%m') = DATE_FORMAT(NOW(), '%m')"
    );
    $condicoes['limit'] = 59;
    $this->paginate = $condicoes;
    $this->set('aniversariantes', $this->paginate());
}

In this condition it first orders the date of the year :( and then the date of the month.

    
asked by anonymous 01.10.2015 / 16:25

1 answer

1

You can do this:

$condicoes['order'] = array('DAY(Funcionario.data_nascimento) => 'ASC')

    
01.10.2015 / 16:35