cakePHP containable model should not be empty

Question

I have problem in filtering records, I don't want any records have empty models.

       $this->paginate = array('fields' =>
            array('DISTINCT Joborder.id',
                'Joborder.job_type',
                'Joborder.payment_status',
                'Joborder.estimate_id',
                'Joborder.quantity',
                'Joborder.date_created'
            ),
            'contain' => array(
                'Workorder.id',
                'Workorder.joborder_id',
                'Joborderpart.id',
                'Joborderpart.binding',
                'Orderstatus.id',
                'Estimate' => array(
                    'Client' => array(
                        'fields' => array(
                            'Client.company_name'
                        )
                    )
                ),
                'Orderstatus' => array(
                    'fields' => array('Orderstatus.id'),
                    'order' => array(
                        'Orderstatus.id DESC'
                    ),
                    'conditions' => array(
                        'Orderstatus.Orderstatustype_id LIKE' => 5
                    ),
                    'Orderstatustype' => array(
                        'fields' => array(
                            'Orderstatustype.id',
                            'Orderstatustype.orderstatus'
                        )
                    ),
                    'limit' => 1
                )
            )
        );

I have checked a condition in Orderstatus table for selecting orderstatustype_id LIKE 5 which is Shipped.

I need only shipping records but its pulling all the records like the following

I need to filter only the shipped records.. please help me..

Hi sudhir I have updated my question with complete detail.. – msmohan Jan 05 '12 at 07:44 — msmohan, Jan 05 '12 at 07:44

score 0 · Answer 1 · answered May 31 '13 at 10:29

It is possible to remove empty contains results from the paginate by including a join as well as the contain and checking for null values.

For example:-

$this->paginate = array(
    'fields' => array(
        'DISTINCT Order.id',
        'Order.*'
    ),
    'conditions' => array(
        'OrderItem.id IS NOT NULL'
    ),
    'joins' => array(
        array(
            'table' => 'order_items',
            'alias' => 'OrderItem',
            'type' => 'LEFT',
            'conditions' => array('Order.id = OrderItem.order_id')
        )
    ),
    'contain' => array(
        'OrderItem'
    )
)

This would ensure that only orders with order items would be returned.

score 0 · Answer 2 · answered Jan 05 '12 at 09:54

0

This is the intended behaviour of Containable. When there are no records for the given model, an empty array is returned.

The only way to get rid of them is to loop over the resulting array and filter out the empty children. This article proposes a solution involving afterFind().

answered Jan 05 '12 at 09:54

mensch

4,411
3
28
49

Thanks for your reply. I have a doubt that aftefind() will support paginate option because if I remove unwanted records in the afterfind function then how it will calculate next 10 records for next page? – msmohan Jan 05 '12 at 10:07
Is containable breaking pagination when used with the empty model arrays still present in the find data? – mensch Jan 05 '12 at 10:11
It's is? Because if it isn't I would just ignore the empty model arrays. – mensch Jan 05 '12 at 10:40
Paginate and containable working properly except unwanted records BUT find with contain breaking the pagination. – msmohan Jan 05 '12 at 10:41
Strange, containable and pagination are supposed to work in conjunction. Your problem might merit another question. – mensch Jan 05 '12 at 13:07
Really strange containable and paginate are not working in the scene i can't set the limit per page.. its not working.. – msmohan Jan 06 '12 at 04:57

cakePHP containable model should not be empty

2 Answers2