/PHP/Laravel - Query Builder Raw Query selectRaw

Laravel - Query Builder Raw Query selectRaw

 $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();

Similar codes

0 vote258 views1 answer
Php jwt firebase
PHP
0 vote245 views1 answer
Object of class stdclass could not be converted to string php laravel
PHP
0 vote292 views1 answer
Laravel8 can't read env
PHP
37 votes318 views6 answers
Laravel order by
PHP Laravel
53 votes298 views5 answers
How to check laravel version
PHP
11 votes253 views4 answers
Session variable in laravel
PHP
0 vote235 views1 answer
Display date time twig
PHP
1 vote248 views1 answer
Laravel map array
PHP
0 vote250 views1 answer
DisableTimeRanges
PHP
0 vote298 views1 answer
Drop foreign key laravel eloquent
PHP Laravel