Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT userorders.`delivered` as delivered_status, items.`name` as itemname,
- sizes.`size` as sizename,SUM(userorders.`order_qty`) as order_quantity,
- sizes.`qty` as stockremaining FROM userorders inner join sizes on
- userorders.`size`=sizes.`id` inner join items on sizes.`item_id`=items.`id`
- WHERE 1 group by userorders.`delivered`, userorders.`size`;
- $userorders = DB::table('userorders')
- ->join('sizes', 'userorders.size', '=', 'sizes.id')
- ->join('items', 'sizes.item_id', '=', 'items.id')
- ->join('categories', 'items.category_id', '=', 'categories.id')
- ->select('SUM(userorders.order_qty) as order_quantity','userorders.delivered as delivered_status', 'items.name as itemname','categories.name as categoryname', 'sizes.size as sizename','sizes.qty as stockremaining')
- ->groupBy('userorders.delivered', 'userorders.size')
- ->get();
- $userorders = DB::table('userorders')
- ->join('sizes', 'userorders.size', '=', 'sizes.id')
- ->join('items', 'sizes.item_id', '=', 'items.id')
- ->join('categories', 'items.category_id', '=', 'categories.id')
- ->SUM('userorders.order_qty');
Add Comment
Please, Sign In to add comment