can I perform multi insert on my model?

[christmex]

Hi guys so I have a question, can I perform multi-insert on my current model, I will provide my ERD and the scenario detail.

here's my ERD

here's my form

when I try to insert it, it will show an error, like this

here's my specific setupcreateoperation()

little explanation, I have a transactions table that is related to a few tables, but it doesn't really matter, except for the books table, the scenario is, I want to choose more than one book from my create form, the school_year_id, semester_id,member_id they're all same and the value is not multiple just one value, so if I choose multiple books, then it will insert all the book with another data is same the difference is just the book_id, I hope you understand my question.

//example data
$data = [
    [
        'school_year_id' => 1,
        'semester_id' => 1,
        'member_id' => 1,
        'book_id' => 1,
    ],
    [
        'school_year_id' => 1,
        'semester_id' => 1,
        'member_id' => 1,
        'book_id' => 2,
    ],
];

so, like the $data, I will choose more than one book and I want to insert them at one time

should I make a new operation? or there is a way that I can use for this case? or anything? let me know, thanks for your attention

I also trying to read all of this but still, not that understand if it's the way or not
https://backpackforlaravel.com/docs/5.x/crud-how-to#hasmany-1-n-relationship
https://backpackforlaravel.com/docs/5.x/crud-fields#select_multiple-n-n-relationship

[jcastroa87]

Hi @christmex did you try add to this the "model"

'model' => "App\Models\Book",

Let me know if thats works for you.

Cheers.

[christmex]

Hi @jorgetwgroup , thx for the suggestion, I've tried your suggestion my code looks like this

but the same error return

[tabacitu]

@christmex the error message is a bit weird to me:

• first of all book_stock is an attribute on the book model... and you're in the Add Transaction form... so it shouldn't even interact with that;
• second of all, the error seems to be happening on a collection instance...

Where is this error happening more exactly? Are you sure this isn't some custom code that's triggering this error? What does your full error stack look like? Because Laravel is using Flare, once you get that error you should be able to "share" your entire error stack - it'll give you a link you can give us, so we have a picture of WHERE that error is happening.

Cheers!

[tabacitu]

Oddly enough the error seems to happens after the POST request... this makes no sense. Do you have anything in your model (observers, mutators) that might use string helpers?

[pxpm]

Probably missing adding to the $casts property in the model ?

protected $casts = ['book_id' => 'array'];

What seems odd to me is that book_**id** is an array of ids and not only the book id.

[christmex]

@tabacitu Thx for replying, I don't have any mutator and when I try it, I already disabled my observer inside my model 😓

[christmex]

@pxpm Hii, thx for replying, I already tried this and still it doesn't work 🙏

[christmex]

@tabacitu @pxpm , Thanks guys for helping me, maybe I will just close this issue, if I already figure it out, I will come up with the updates, again thank you so much for helping 🙏