Clean Pagination

[Dave Maharaj :: WidePixels.com]

I hate all the pagination params in the controller so I did this
 
To paginate all active users for an example
 
controller:
 

$this->paginate['User'] = $this->User->userPagination();
$this->set('users', $this->paginate('User', array('User.id' =>
$this->User->getActiveUsers())));
 
model:

Build pagination as normal:

function userPagination()
{
                $params = array(
                        'fields' => array(
                                'User.id',
                                'User.name',
                                'User.city'),
                        'limit' => 20,
                        'order' => array(
                                'User.name  DESC'),
                        'contain' => array(
                                'State' => array(
                                        'fields' => array('State.abrev')),
                                'Country' => array(
                                        'fields' =>
array('Country.name'))));
        
        
        return $params;
} 



public function getActiveUsers()
 //this fetches all Users who have been admin approved
{
        $params = array(
                'conditions' => array(
                        'User.status' => '1'),
                'fields' => array(
                        'User.id'),
                'contain' => false);
        
        $q = $this->find('all', $params);
  
    //create an array of User.id's to pass to paginate
    
    $active = array();

    //return only the id
    foreach ($q as $active_user) 
    {
            array_push($active, $active_user['User']['id']);
    }
    
    return $active;
 }
 
Has anyone found a cleaner or easier way to do this? 

I needed to paginate different sets in the same model and the configuration
was driving me crazy so this way I found I can have different paginations
for the same model with different params.

getActiveUsers()

usersByCountry($country_id) and so on
 
Dave 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---