Form and tables with relationships

You need to create Refund model which belongs to customer and than you can attach services.

I create Refund model (see post above) and i also create this function

     public function customers()
        {
            return $this->belongsTo(Customers::class);
        }   

or maybe i dont understand ur reply :S

You have to change this

$test = $customers->refunds();

to

$test = $customers->refunds()->create([
    // some data
]);

I dont understand now in my controller i only try to save customers data in main table customers just to test

public function storeRefunds(RefundsPost $request){
			
			
			$customers = Customers::create($request->all());


			return redirect("/");		
    }

i obtain this error

Call to undefined relationship [services] on model [App\Customers].

but there is no relationship between Customers and Services i write relationship between Refunds and Services

@niloleon WHat do you have in your RefundsPost and could you post you whole code of Customers model?

Ok my error i call services in index function in the controller. Instead i quite solved my problem writing this

public function storeRefunds(RefundsPost $request){
			
		DB::beginTransaction();
			$customers = Customers::create($request->all());

			$refunds = $customers->refunds()->create([
				'date_ref' => request('date_ref'),
				'status_ref' => request('stato'),
			]);
			
			$tipo = $request->input('tipo', []);
			$importo = $request->input('importo', []);
			
			$refunds = Refunds::create($request->all());
			
			for ($i=0; $i < count($tipo); $i++) {
				if ($tipo[$i] != '') {
					
					$refunds->services()->attach($tipo[$i], [
					'services_id' => $tipo[$i],
					'services_amount' => $importo[$i]
					]);
				}
			}
			
			return redirect("/");
 
	}

Now datas are inserted in the correct tables! BUT the second create is disconnected from the first...it generate another record in the REFUNDS table with CUstomer id 0. I mean it connect the second insertion to ANOTHER REFUNDS id....i think i have to use something find id? How thxs a lot

Ah right maybe i have to insert this as u suggest before

$refunds = $customers->refunds()->create([
			
			for ($i=0; $i < count($tipo); $i++) {
				if ($tipo[$i] != '') {
					
					$refunds->services()->attach($tipo[$i], [
					'services_id' => $tipo[$i],
					'services_amount' => $importo[$i]
					]);
				}
			},

but i can pass only associative array...mmm i have to create before an array of all couple tipo and importo maybe I dunno, and the attach method? uff

Maybe i cannot do this with eloquent relationship, but i need to pass manually the id?

The only other option I can think of is doing a associative table like tblCompanies_Forms_Roles that holds entries of FormNumber, Company, Role but even that sounds like an overly complicated fix for this tiny issue. https://getappvalley.com/ https://tutuappx.com/ https://tweakbox.mobi/

@niloleon Why do you create refunds again?

$refunds = Refunds::create($request->all());

public function storeRefunds(RefundsPost $request) {
    $customers = Customers::create($request->all());

    $refunds = $customers->refunds()->create([
        'date_ref' => request('date_ref'),
        'status_ref' => request('stato'),
    ]);

    $tipo = $request->input('tipo', []);

    $importo = $request->input('importo', []);

    for ($i = 0; $i < count($tipo); $i++) {
        if ($tipo[$i] != '') {
            $refunds->services()->attach($tipo[$i], [
                'services_id' => $tipo[$i],
                'services_amount' => $importo[$i]
            ]);
        }
    }

    return redirect('/'');
}

GREAT!!!! thx I thought that i had to do this

$refund_id = $refunds->id;
$model = Refunds::findOrFail($refund_id);
for ($i=0; $i < count($tipo); $i++) {
				if ($tipo[$i] != '') {
$model->services()->attach($tipo[$i], [
					......

But i saw with ur solution is not necessary Thks a lot!

@niloleon Why do you do this?

$refund_id = $refunds->id;

$model = Refunds::findOrFail($refund_id);

It's still same what I posted before.

public function storeRefunds(RefundsPost $request) {
    $customers = Customers::create($request->all());

    $refunds = $customers->refunds()->create([
        'date_ref' => request('date_ref'),
        'status_ref' => request('stato'),
    ]);

    $tipo = $request->input('tipo', []);

    $importo = $request->input('importo', []);

    for ($i = 0; $i < count($tipo); $i++) {
        if ($tipo[$i] != '') {
            $refunds->services()->attach($tipo[$i], [
                'services_id' => $tipo[$i],
                'services_amount' => $importo[$i]
            ]);
        }
    }

    return redirect('/'');
}

Yes thx i understand i will use ur solution :D thx

@niloleon If it's correct answer could you mark it as best reply? Thanks.