Adding arrays within loop Laravel

Question

Please need help...

$months = Records::select('payment_month')
    ->distinct()->where('payment_year',$year)
    ->where('company_id',$company_id)->get();

foreach ($months as $month) {

    $data = Records::select(
        DB::raw('SUM(record_db.credits) as credits'),
        DB::raw('SUM(record_db.amount) as amount'),
        DB::raw('SUM(record_db.totalamount) as totalamt'), 'record_db.payment_month')
            ->where('record_db.company_id','=',$company_id)
            ->where('record_db.payment_month','=',$month->payment_month)
            ->where('record_db.payment_year','=',$year)
            ->first();
}       

return Response::json($data);

The above query works fine and I have the month of January, February and March in the database table but it only returns the records of March.

I tried results[]=$data but still don't work.

January 910 345 657 February 345 980 123 March 214 436 989, something like this... — BlackPearl
– BlackPearl, Commented May 16, 2014 at 5:01

Jarek Tkaczyk · Accepted Answer · 2014-05-16 13:12:41Z

1

I think this is what you need:

$data = Records::select(
    'payment_month',
    DB::raw('SUM(record_db.credits) as credits'),
    DB::raw('SUM(record_db.amount) as amount'),
    DB::raw('SUM(record_db.totalamount) as totalamt')
)->where('company_id', '=', $company_id)
->where('payment_year', '=', $year)
->groupBy('payment_month')
->orderBy('payment_month')
->get();

// then
$data->toJson(); // returns something like:
[{"payment_month":"January","credits":"123","amount":"456","totalamt":"789"}, ... ]

answered May 16, 2014 at 13:12

Jarek Tkaczyk

81.4k27 gold badges167 silver badges162 bronze badges

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

1 Comment

BlackPearl Over a year ago

Was able to solve it when the site was in read only mode, using $result[]=$data->toArray(). Thanks...

Dinuka Thilanga · Accepted Answer · 2014-05-15 03:19:14Z

0

You had override $data array from every month result. You should use whereIn as follows.

$months = Records::select('payment_month')
    ->distinct()->where('payment_year', $year)
    ->where('company_id',$company_id)->get();

$monthValues = array();

foreach ($months as $month) {
    $monthValues[] = $month->payment_month;
}

$data = Records::select(
    DB::raw('SUM(record_db.credits) as credits'),
    DB::raw('SUM(record_db.amount) as amount'),
    DB::raw('SUM(record_db.totalamount) as totalamt'), 'record_db.payment_month')
    ->where('record_db.company_id','=',$company_id)
    ->whereIn('record_db.payment_month', $monthValues)
    ->where('record_db.payment_year','=',$year)
    ->first();

edited May 15, 2014 at 3:19

answered May 15, 2014 at 3:11

Dinuka Thilanga

4,35010 gold badges59 silver badges94 bronze badges

5 Comments

BlackPearl Over a year ago

$monthValues is returning null

Dinuka Thilanga Over a year ago

check your $months array. It should null.

BlackPearl Over a year ago

Months array contain payment_month: January, payment_month: February, payment_month: March

Dinuka Thilanga Over a year ago

So. how $monthValues be null? check print $month array in the loop. Anyway you should to do whereIn. Check it with laravel manual.

BlackPearl Over a year ago

sorry, I was doing a typo but using whereIn is giving errors

Collectives™ on Stack Overflow

Adding arrays within loop Laravel

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related