Level 75
Oct 1, 2023
14
Level 17
Get all shipments and foreach shipment i need to count each products
I want to get all the shipments adding to each shipment each count of the scanned prods and the unscanned prods as shown here :
public function allShipments()
{
$ships = Shipment::all();
foreach ($ships as $ship) {
$scanned_products = $ship->products()->where('scanned', true)->where('visibility',true)->get();
$unscanned_products = $ship->products()->where('scanned', false)->where('visibility',true)->get();
$ship->$scanned_products = $scanned_products;
$ship->$unscanned_products = $unscanned_products;
}
return Datatables::of($ships)->make();
}
I want only the count of scanned and unscanned products foreach every ship , then using datatables with them which obligates not using all() or get as it only needs the query itself.
Level 17
@MichalOravec Not really there are some conditionals that I need. I see in the docs some conditionals BUT I am not able to generate the full query required for my case
Level 17
public function allShipments()
{
$ships = DB::table('shipments');
foreach ($ships as $ship){
$ship->scanned = DB::table('products')->where('shipment_id',$ship->id)->where('scanned', true)->count();
$ship->unscanned = DB::table('products')->where('shipment_id',$ship->id)->where('scanned', false)->count();
}
return Datatables::of($ships)->make();
}
also this does not work errors
Level 17
no dice here as well
public function allShipments()
{
$ships = DB::table('shipments');
foreach ($ships as $ship){
$ship->scanned = Shipment::withCount('products')->where('scanned', true);
$ship->unscanned = Shipment::withCount('products')->where('scanned', false);
}
return Datatables::of($ships)->make();
}
Level 17
i have this err on the console
{message: "The route [object%20Object] could not be found.",…}
exception
:
"Symfony\Component\HttpKernel\Exception\NotFoundHttpException"
file
:
/vendor/laravel/framework/src/Illuminate/Routing/AbstractRouteCollection.php"
line
:
44
message
:
"The route [object%20Object] could not be found."
trace
:
Level 17
I did it like that manually and it is ok
$ships =Shipment::all();
foreach ($ships as $ship){
$ship->scanned = Product::where('shipment_id',$ship->id)->where('scanned',true)->count();
$ship->unscanned = Product::where('shipment_id',$ship->id)->where('scanned',false)->count();
}
Level 122
@lifesound but have you looked how many queries it creates? Jeez!
1 like
Level 14
@lifesound great, now people searching for a similar problem will also get a terrible solution.
Level 27
@lifesound DO NOT DO THIS! This is terrible. Please read about eager-loading.
1 like
Level 17
@Snapey Lol yes
Level 17
@krisi_gjika i have changed the solution to another reply
1 like
Level 75
@lifesound It was hard to see an example in the documentation, wasn't it?
$ships = Shipment::withCount([
'products as scanned' => function ($query) {
$query->where('scanned', true);
},
'products as unscanned' => function ($query) {
$query->where('scanned', false);
},
])->get();
or
$ships = Shipment::withCount([
'products as scanned' => fn ($query) => $query->where('scanned', true),
'products as unscanned' => fn ($query) => $query->where('scanned', false)
])->get();
Level 122
@michaloravec perhaps or old friend oxbir has learned to make his profile private
Level 75
Please or to participate in this conversation.