/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 vote265 views1 answer
Laravel job delay dispatch
PHP Laravel
1 vote224 views3 answers
Laravel multiple paginate
PHP Laravel
18 votes223 views1 answer
Schema::default string laravel
PHP Laravel
8 votes158 views2 answers
Laravel password hash online
PHP Laravel
1 vote263 views1 answer
Laravel refresh server
PHP Laravel
1 vote210 views2 answers
Cart::subtotal in laravel
PHP Laravel
33 votes215 views4 answers
Carbon format date in laravel
PHP Laravel
31 votes208 views5 answers
How to make db seeder in laravel
PHP Laravel
18 votes219 views6 answers
Redirect to route laravel
PHP Laravel
23 votes218 views6 answers
Laravel validation messages
PHP Laravel