JCRM
JCRM
Programming language:PHP
2021-05-19 05:29:41
0
Q:

paginate and sort 2nd level association

Jason Stout
Jason Stout
Code: PHP
2021-05-23 13:13:15 
// link below
https://en.it1352.com/article/3565133a7e174035a4e83f831c59008d.html


// Our case:
MemberNotification -> BelongsTo -> Notification, 
Notification -> HasMany -> NotificationLanguage

$this->MemberNotification->recursive = 0;
$this->set('memberNotifications', $this->paginate());
$this->MemberNotification->bindModel(array(
    'belongsTo' => array(
        'NotificationLanguage' => array(
            'foreignKey' => false,
            'conditions' => array('Notification.id = NotificationLanguage.notification_id')
        ),
    )
));

// our purpose just make the NotificationLanguage same level with the Notification, show we can sort 2nd level association

// on the view
<th><?php echo $this->Paginator->sort('NotificationLanguage.title', 'Region'); ?></th>

// we cannot use below code, cannot run: xxxxxx
<th><?php echo $this->Paginator->sort('Notification.NotificationLanguage.title', 'Region'); ?></th>
1

Tags

Related

New to Communities?

Join the community