How to Remove Column from Laravel Collection variable

Question

I am trying to move values from temp table to main table after approval.

But, I don't have status, cancelled, and cancelled by columns in main table it's only available in the temp table. So, if I try to move all the fields from temp table to main table, it's showing error.

I am trying to move using the below codes.

public function approve(mpd_temp $mpd)
{

$result = mpd::insert($mpd->toArray());

if ($result) {
    mpd_temp::where('sno', $mpd->sno)->delete();
    toast('MPD Successfully Approved', 'success');
}

}

I have tried

$mpd->forget('status');
$mpd->forget('cancelled_at');
$mpd->forget('cancelledby');

But it's showing

Is there any best way to move columns from temp table to main table and delete from temp after insert?

try to `unset($mpd->cancelledby)` (I'm not sure if that's gonna work). Or you could use `array_except()`. — Laralex, Jun 27 '22 at 11:32
It's showing Call to undefined method App\Models\admin\mpd_temp::transform() — Lokesh M, Jun 27 '22 at 11:43
I have tried $mpd->push('approved_at', now()); but it's not adding value into the attributes[]; — Lokesh M, Jun 27 '22 at 11:46
Google "add key to laravel collection" and try everything that seems to be working for you. — Laralex, Jun 27 '22 at 11:49

score 2 · Accepted Answer · answered Jun 27 '22 at 11:36

2

You must unset() the key you want to remove. In your case you must do

unset($mpd->cancelledby);

And it should be removed from the collection.

answered Jun 27 '22 at 11:36

Laralex

125
8

score 2 · Answer 2 · answered Jun 27 '22 at 11:44

2

You can use except function on your collection:

$mpd->except(['status', 'cancelled_at', 'cancelledby']);

answered Jun 27 '22 at 11:44

Vahid

940
4
14

Yeah this will work too. – Laralex Jun 27 '22 at 11:45
I have tried except but it's showing BadMethodCallException Call to undefined method App\Models\admin\mpd_temp::except() – Lokesh M Jun 27 '22 at 11:49
1

@LokeshM So your $mpd is not a Collection! – Vahid Jun 27 '22 at 11:53
Got it, I have tried collect($mpd)->except(['status', 'cancelled_at', 'cancelledby']); this worked. – Lokesh M Jun 27 '22 at 12:31

How to Remove Column from Laravel Collection variable

2 Answers2