/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

1 vote163 views1 answer
Popular cms
PHP
0 vote178 views1 answer
Wordpress get posts by multiple authors
PHP Wordpress
1 vote152 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
43 votes163 views2 answers
Get array length using php
PHP
46 votes242 views6 answers
Clear laravel cache
PHP Laravel
0 vote283 views1 answer
Drupal 8 entity_view
PHP Drupal
0 vote209 views1 answer
$age = 20; print ($age >= 18) ? "Adult" : "Not Adult";
PHP
2 votes181 views4 answers
Foreach in laravel
PHP
0 vote194 views2 answers
Default language laravel
PHP Laravel
2 votes173 views2 answers
Php mod
PHP