/PHP/Laravel/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 vote170 views1 answer
Laravel share
PHP Laravel
0 vote270 views1 answer
Parameter to laravel seeder
PHP Laravel
1 vote172 views2 answers
Join multiple query in laravel
PHP Laravel
0 vote162 views1 answer
Multi theme laravel
PHP Laravel
0 vote158 views1 answer
How to import in laravel excel command
PHP Laravel
44 votes183 views6 answers
How to make controller in laravel
PHP Laravel
11 votes151 views3 answers
Laravel get last 5 records
PHP Laravel
5 votes148 views4 answers
Laravel auth register false
PHP Laravel
6 votes151 views3 answers
Laravel blade route redirect back
PHP Laravel
1 vote141 views1 answer
Laravel validate enum field
PHP Laravel