/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 vote156 views2 answers
How to upload two files on same form different path in codeigniter
PHP
5 votes144 views3 answers
How to execute cmd command in php
PHP
13 votes180 views4 answers
Laravel make migration update table
PHP Laravel
2 votes159 views1 answer
Php beginner project ideas
PHP
15 votes166 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP
0 vote154 views1 answer
Php list directory files by date
PHP
8 votes159 views5 answers
Laravel route model binding
PHP
1 vote142 views1 answer
Laravel route slug
PHP
0 vote166 views1 answer
Php set x-frame-options
PHP
0 vote164 views1 answer
Validate number should by 12 digit in php
PHP