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