mardi 16 octobre 2018

Laravel Mongodb Jessenger relations data not filtering

I have 3 collection with belongsToMany relation. i want to filter data from all 3 collection. but didn't able to get.

Collection Structure.

                payment
                {"_id":"5ba3c8f7c2ab9b3bed20ae22","code":"GHFH","amount":"345.00"}

                user
                {"_id":"5ba3c87cc2ab9b34be139382","name":"Jack","email":"Pd@gmail.com","payment_ids":["5ba3c8f7c2ab9b3bed20ae22"]}

                customer
                {"_id":"23c34c87cc2ab9b34b3423423","name":"cfb","email":"Psfsdd@gmail.com","payment_ids":["5ba3c8f7c2ab9b3bed20ae22"]}

i have create below query.

            $cruds = payment::with([
                        'user' => function ($query) {
                            $query->orWhere('name','like', "%'".$search."'%");
                        }, 
                        'customer' => function ($query) {
                            $query->orWhere('name','like', "%'".$search."'%");
                        }
                    ])
                ->orWhere('code','like', "%'".$search."'%")
                ->orWhere('amount', 'like', "%'".$search."'%")
                ->offset($start)
                ->limit($limit)
                ->orderBy($order, $dir)
                ->get();

Please Suggest.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire