public function index() { // [ "active", "pending", null, "canceled" ] $league_id = '4f9ffe2b406eb74b4100001d'; $a['male'] = array('active' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'active', 'gender' => 'male'))), 'pending' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'pending', 'gender' => 'male'))), 'canceled' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'canceled', 'gender' => 'male'))), 'null' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => null, 'gender' => 'male')))); $a['female'] = array('active' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'active', 'gender' => 'female'))), 'pending' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'pending', 'gender' => 'female'))), 'canceled' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => 'canceled', 'gender' => 'female'))), 'null' => Registrations::count(array('conditions' => array('league_id' => $league_id, 'status' => null, 'gender' => 'female')))); return compact('a', 'b', 'c'); }