Add 2 array values in Laravel

Question

I a, new learner and working on home project. I stuck to to get additions of 2 array values . The array values are as follows, Thanks for your help.. Thanks u

Array 1

array:1 [▼
    0 => array:3 [▼
        "totalbmilk" => "168.00"
        "totala2milk" => "0.00"
        "totaljmilk" => "390.00"
    ]
]

Array 2

array:1 [▼
    0 => array:3 [▼
        "totalbmilk" => "8.00"
        "totala2milk" => "5.50"
        "totaljmilk" => "2.50"
    ]
]

Expecting

totalbmilk = 168 + 8 = 176
totala2milk = 0 + 5.5 = 5.50
totaljmilk = 390 + 2.50 = 392.50

Controller file

$milksalefordairy = Dairymilksale::selectraw('
        SUM(buffalomilk) as "totalbmilk",
        SUM(a2milk) as "totala2milk",
        SUM(jerseymilk) as "totaljmilk"
    ')
    ->whereBetween('saledate', [$startdateofmonth, $enddateofmonth])
    ->get()
    ->toArray();
    
$milksaleforcustomer = Customermilksale::selectraw('
        SUM(buffalomilk) as "totalbmilk", 
        SUM(a2milk) as "totala2milk",
        SUM(jerseymilk) as "totaljmilk"
    ')
    ->whereBetween('saledate', [$startdateofmonth, $enddateofmonth])
    ->get()
    ->toArray();

IGP · Accepted Answer · 2022-08-10 01:13:30Z

1

You could use collection methods.

$milksalefordairy = Dairymilksale::selectraw('
        SUM(buffalomilk) as "totalbmilk",
        SUM(a2milk) as "totala2milk",
        SUM(jerseymilk) as "totaljmilk"
    ')
    ->whereBetween('saledate', [$startdateofmonth, $enddateofmonth])
    ->get()
    ->toArray();
    
$milksaleforcustomer = Customermilksale::selectraw('
        SUM(buffalomilk) as "totalbmilk", 
        SUM(a2milk) as "totala2milk",
        SUM(jerseymilk) as "totaljmilk"
    ')
    ->whereBetween('saledate', [$startdateofmonth, $enddateofmonth])
    ->get()
    ->toArray();

$collection = collect([...$milksalefordairy, ...$milksaleforcustomer]);

echo $collection->sum('totalbmilk');
echo $collection->sum('totala2milk');
echo $collection->sum('totaljmilk');

answered Aug 10, 2022 at 1:13

IGP

16.4k5 gold badges34 silver badges55 bronze badges

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

Comments

Sinatrya Yogi Rizal · Accepted Answer · 2024-11-28 05:38:29Z

0

you can use collection laravel, work in charm :)

 $array = [
    [
        "express_fee"=> 0,
        "provider_template_id"=> 501,
        "provider_id"=> 263
    ],
    [
        "express_fee"=> 2,
        "provider_template_id"=> 220,
        "provider_id"=> 4
    ],
    [
        "express_fee"=> 40000,
        "provider_template_id"=> 220,
        "provider_id"=> 4
    ]
];

return collect($array)->groupBy('provider_template_id')->map(function($item , $key){
    return [
        'provider_templae_id' => $key, 
        'express_fee' => collect($item)->sum('express_fee')
    ];
})->values();

answered Nov 28, 2024 at 5:38

Sinatrya Yogi Rizal

254 bronze badges

Collectives™ on Stack Overflow

Add 2 array values in Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related