显示相关产品，将当前产品排除在网格之外。

Question

我有一个在Cakephp2中显示相关产品的网格，它工作得很好，但是在相关产品的网格中显示相同的产品，如何排除它呢？

这是我的艺术品控制器代码：

    public function view($id = null) {
    if (!$this->Artwork->exists($id)) {
        throw new NotFoundException(__('Invalid artwork'));
    }
    $options = array('conditions' => array(
        'Artwork.' . $this->Artwork->primaryKey => $id),
        'recursive' => 0);
    $artwork = $this->Artwork->find('first', $options);
    $this->set('artwork', $artwork);

    // related artworks
    $status = 'Artwork.status';
    $id = 'Artwork.artist_id';
    $related = $this->Artwork->find('all',
        array(
           'limit' => 4, 
           'conditions' => array(
             $status => 1, 
             $id => $artwork['Artwork']['artist_id'])));

    $this->set('artworks', $related);
}

Answer 1

你需要从相关的作品中排除这些艺术品：

'Artwork.id !=' => $artwork['Artwork']['id']

试试这个：

public function view($id = null) {
if (!$this->Artwork->exists($id)) {
    throw new NotFoundException(__('Invalid artwork'));
}
$options = array('conditions' => array(
    'Artwork.' . $this->Artwork->primaryKey => $id),
    'recursive' => 0);
$artwork = $this->Artwork->find('first', $options);
$this->set('artwork', $artwork);

// related artworks
$status = 'Artwork.status';
$id = 'Artwork.artist_id';
$related = $this->Artwork->find('all',
    array(
       'limit' => 4, 
       'conditions' => array(
         $status => 1, 
         $id => $artwork['Artwork']['artist_id'],
         'Artwork.id !=' => $artwork['Artwork']['id']
)));


$this->set('artworks', $related);
}