Breaking News: Grepper is joining You.com. Read the official announcement!

Laravel - Query Builder Raw Query selectRaw

Fani385 answered on November 15, 2021 Popularity 9/10 Helpfulness 3/10

answer Laravel - Query Builder Raw Query selectRaw

related Using Having Raw in query builder laravel

Laravel - Query Builder Raw Query selectRaw

Comment

 $totalUsers = MyInventoryModel::selectRaw('pos_inventory.id as pos_inventory_id,pos_products.*,pos_products.product_name as product_name,pos_inventory.reorder_point,pos_inventory.reorder_qty,pos_inventory.current_stock,
                       pos_inventory.variant_id,pos_products.product_sku,pos_product_variants.combination_names,pos_product_variants.sku,pos_outlets.*,pos_roles.*')
                ->leftJoin('pos_products', 'pos_inventory.product_id', '=', 'pos_products.id')
                ->leftJoin('pos_product_variants', 'pos_inventory.product_id', '=', 'pos_product_variants.id')
                ->leftjoin('pos_outlets', 'pos_inventory.outlet_id', '=', 'pos_outlets.id')
                ->leftjoin('pos_roles', 'pos_outlets.store_id', '=', 'pos_roles.store_id')
                ->where('outlet_id', $item->outlet_id)
                ->groupBy('pos_inventory.product_id')
                ->get();

Popularity 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel php query-builder raw

Link to this answer
Share Copy Link

Contributed on Nov 15 2021

Fani385

0 Answers Avg Quality 2/10

Closely Related Answers

Using Having Raw in query builder laravel

Comment

having is used where aggregate functions are within the where clause

$orders = DB::table('orders')
                ->select('department', DB::raw('SUM(price) as total_sales'))
                ->groupBy('department')
                ->havingRaw('SUM(price) > ?', [2500])
                ->get();

Popularity 9/10 Helpfulness 2/10 Language sql

Source: laravel.com

Tags: having ha

Link to this answer
Share Copy Link

Contributed on May 25 2023

Young Master

0 Answers Avg Quality 2/10

Laravel - Query Builder Raw Query selectRaw

Contents

More Related Answers

Laravel - Query Builder Raw Query selectRaw

Closely Related Answers

Using Having Raw in query builder laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.