How to insert data into 2 different table from single form.

[rahulJ-addweb]

I have used tabs(Basic Details, Applicant Details) in customer crud. I want to store Basic Details (Tab 1) data in the customers_general table & Applicant Details (Tab 2) data in the customers table. Can you please help me here with how I can do it?

[ziming]

1 possible way to handle this is by overriding the create or update method of ur CrudController depending on if you are trying to create or update.

Look at the following trait below for an example. If u just use this trait in your CrudController without overriding it, it will be backpack default update behaviour

• \Backpack\CRUD\app\Http\Controllers\Operations\UpdateOperation

Then inside ur overridden method, u save to your 2 separate models

[dandarie]

1. CRUDs are resposible for a single model.
2. A tab is just a design feature, it doesn't change anything in terms of backend functionality.

To accomplish what you're trying to obtain, I'd use accessors and mutators for the main CRUD model (Customer), accessors and mutators that retrieve and update the data from and into the customers_general table.

More on accessors and mutators: Laravel 8.x, Laravel 9.x.

[christmex]

Take a look at this documentation
https://backpackforlaravel.com/docs/5.x/crud-operation-create#override-the-store-method

or maybe u want to overwrite the store trait, but idk if it's correct, please let me know, because I also use this way and observer, but don't know the correct way, but it works

    public function store()
    {
        $this->crud->hasAccessOrFail('create');

        // execute the FormRequest authorization and validation, if one is required
        $request = $this->crud->validateRequest();

        // register any Model Events defined on fields
        $this->crud->registerFieldEvents();

        // insert item in the db
        $item = $this->crud->create($this->crud->getStrippedSaveRequest($request));
        $this->data['entry'] = $this->crud->entry = $item;

       // do another insert to another db below

        // show a success message
        \Alert::success(trans('backpack::crud.insert_success'))->flash();

        // save the redirect choice for next time
        $this->crud->setSaveAction();

        return $this->crud->performSaveAction($item->getKey());
    }

[christmex]

Hey, this is the correction of my answer.

like @tabacitu said, it's not a good way to overwrite your store or update method, but instead of that you can use
https://backpackforlaravel.com/docs/5.x/release-notes#use-model-events-inside-crudcontrollers

you can read it here
#414 (comment)

[jcastroa87]

I'm closing this issue due to inactivity. If you need further assistance or have additional questions, feel free to reopen this issue or create a new one. We're here to help!