Re: Doing pagination without paginate()

Ive been messing around with it a bit and got this, is this the right
way to do things?

class DashboardController extends AppController {
var $uses = array('Friend');

// Pagination
var $paginate = array(
'Friend' => array(
'limit' => 5,
'order' => array('Friend.requestTime' => 'ASC'),
'recursive' => -1
)
);

function index() {
$this->paginate['Friend'] = array('extra' => array('user_id' =>
$this->Auth->user('id')));
debug($this->paginate('Friend', array('Friend.status' =>
'approved')));
}
}

And the custom paginate query:

function paginate($conditions, $fields, $order, $limit, $page = 1,
$recursive = null, $extra = array()) {
$conditions[] = array('OR' => array(
'Friend.user_id' => $extra['extra']['user_id'],
'Friend.friend_id' => $extra['extra']['user_id']
));

$results = $this->findAll($conditions, $fields, $order, $limit,
$page, $recursive);
$cleanResults = array();

if (!empty($results)) {
foreach ($results as $friend) {
if ($friend['Friend']['friend_id'] != $extra['extra']['user_id']) {
$friend_id = $friend['Friend']['friend_id'];
} else {
$friend_id = $friend['Friend']['user_id'];
}

$userObj = $this->User->find('first', array(
'fields' => array('User.id', 'User.username', 'User.avatar',
'User.handle', 'User.country_id', 'User.signupDate'),
'recursive' => -1,
'conditions' => array('User.id' => $friend_id)
));

if (!empty($userObj)) {
$cleanResults[] = array_merge($friend, $userObj);
}
}
}

return $cleanResults;
}

--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---