Need Help On Translating a Complex Query into Laravel

Can use as is see https://laracasts.com/discuss/channels/laravel/sql-native-to-query-builder

Example of eloquent query

This is just an example:

$quy = Powner::query()->leftJoin('dc_pets', 'dc_powners.ownerid', '=', 'dc_pets.ownerid')
                ->select('dc_powners.ownerid', 'dc_powners.oname')
                ->selectRaw('count(dc_pets.petid) as countOfPets')
                ->groupby('dc_powners.ownerid')
                ->orderby('dc_powners.oname')
                ->get();

Results basically give:

ownerid, oname, countOfPets

Like:

5|Bob|3
4|Greg|9
2|Rob|1
// more

@vincej remember these types of queries can take a little trial and error.

Ok - in the end it was easy, all I had to do was this:

public function inventory_by_product() {
        $result = DB::select('select orders.product_id, products.product_name, sum(orders.quantity) as orders, stock
        from orders
        left join
        (select inventory.inv_product_id,
        sum(inventory.stock_quantity) as stock
        from inventory
        group by inventory.inv_product_id ) i
        on inv_product_id = orders.product_id
        left join products on orders.product_id = products.product_id
        group by orders.product_id');
        return $result;
              }

@jlrdw Thanks a bunch !! Our messages crossed paths!!

Anyway, now that I have found out how to use raw queries in Laravel I am as happy as pig in poo. I will still carry on using query builder for easy stuff, and especially so when sanitized inputs are used.

Cheers ! as always !

@vincej also see the link above which shows an example of bindings.