1 2 3 4 5 6 7 8 9 10 11 12 13 |
$fields = array('BagBook.id','BagBook.bid','BagBook.position','Cmbook.name as name','BagBook.bag_class_id' ,'Cmbook.cover_url as cover_url','Cmbook.introduction as introduction','Cmbook.author as author'); $conditions = array('bag_class_id' => $id); $joins = array(array( 'table' => 'cmbooks', 'alias' => 'Cmbook', 'type' => 'LEFT', 'conditions' => array('Cmbook.bid = BagBook.bid') )); $order = array('BagBook.position','BagBook.id asc'); $this->paginate = array('limit' => 20,'fields'=>$fields, 'conditions' =>$conditions, 'joins'=>$joins,'order'=>$order); $this->NewBook->recursive = 0; $NewBooks = $this->paginate(); |