Display Table form with Eloquent Data Laravel

Question

I have an Object structure that is store in Eloquent Form

{"item_id": "2",
"item_color": "Black",
"item_size": "L",
"item_Quantity": "5",},

{"item_id": "2",
"item_color": "Black",
"item_size": "M",
"item_Quantity": "5",},

{"item_id": "2",
"item_color": "Black",
"item_size": "S",
"item_Quantity": "5",},

{"item_id": "2",
"item_color": "White",
"item_size": "S",
"item_Quantity": "5",},

What I'm trying to achieve is to combine up all item_quantity which has the same item_id and item_color and Display in Table form like this.

ItemID ItemColor ItemSize  Quantity   Total
2         Black    L-M-S    5-5-5      15
2         White     S       5          5

In my research this is the nearest kind of solution but Im having trouble on displaying it in table form

http://stackoverflow.com/questions/23902541/add-array-values-of-same-array-keys-in-session

I already Got the right answer below Thank you guys :) @M0rtiis — Martney Acha
– Martney Acha, Commented Aug 3, 2015 at 6:31

Mustafa ASAN · Accepted Answer · 2015-08-03 06:23:27Z

2

$items = DB::table('item')
            ->select(DB::raw("item_id,item_color,GROUP_CONCAT(item_size SEPARATOR '-') as ItemSize,GROUP_CONCAT(item_Quantity SEPARATOR '-') as Quantity,sum(item_Quantity) as TOTAL"))
            ->groupBy('item_id','item_color')
            ->get();

answered Aug 3, 2015 at 6:23

Mustafa ASAN

3,8552 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Martney Acha Over a year ago

I needed to upgrade from "item_id": "1771", "item_color": "Black", "ItemSize": "L-S", "Quantity": "10-5", "Discount": "20", "Total": "10" To "item_id": "1771", "item_color": "Black", "ItemSizeQty1": "L-10", "ItemSizeQty2": "S-5", "Discount": "20", "Total": "10"

Mustafa ASAN Over a year ago

why not make it another question with all requirements,there are a lot of people to be able to solve it and i will try my best.

Martney Acha Over a year ago

Thank you for your suggestion, Hi this is my new needed query thank you for your response, stackoverflow.com/questions/31964258/… @ConvertToInt32

Collectives™ on Stack Overflow

Display Table form with Eloquent Data Laravel

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related