CODEWITHSUNDEEP
cakephpcakephp-1.3
Msofts
Msofts

Reputation: 87

cakephp contain - condition

my problem is that can i give condition [ 'BookTitleMaster.id' => $xtitid, ] as like below

$bbookinfs = $this->BookStockin->BookIssue->find('all', array(
    'conditions' => array('return_status' => 2),
    'contain' => array(
        'BookStockin' => array(
            'BookTitleMaster' => array(
                'BookTitleMaster.id' => $xtitid,
                'fields' => array('id','title','sub_title','book_material_type_id','book_author_id','course_detail_id','isbn_no','book_publisher_id','pub_year','pub_place','desc','no_pages','volume'),
                'BookMaterialType' => array('name'),
                'CourseDetail' => array('name'),
                'BookPublisher' => array('name'),
                'BookAuthor' => array('name')       
            )
        )
    )
));

Upvotes: 3

Views: 9576

Answers (2)

AKKAweb
AKKAweb

Reputation: 3817

Shouldn't it be:

'conditions' =>  array('BookTitleMaster.id' => $xtitid),

Upvotes: 0

Nik Chankov
Nik Chankov

Reputation: 6047

I believe that you miss is:

'conditions' =>  array('BookTitleMaster.id' => $xtitid),

So, your final code should be:

$bbookinfs = $this->BookStockin->BookIssue->find('all', array(
'conditions' => array('return_status' => 2),
'contain' => array(
    'BookStockin' => array(
        'BookTitleMaster' => array(
            'conditions' =>  array('BookTitleMaster.id' => $xtitid),
            'fields' => array('id','title','sub_title','book_material_type_id','book_author_id','course_detail_id','isbn_no','book_publisher_id','pub_year','pub_place','desc','no_pages','volume'),
            'BookMaterialType' => array('name'),
            'CourseDetail' => array('name'),
            'BookPublisher' => array('name'),
            'BookAuthor' => array('name')       
        )
    )
)

));

HTH

Upvotes: 5

Related Questions