Styjun

In a edit-template, I created 2 forms. The first to edit a record from 'Table1' and a second form to add an record to the associated (belongsTo) table 'Table2'. I don't want to edit the associated record but add a new one in Table2 and change the bindingkey of the record from 'Table1'.

In the controller I use patchEntity(), but this way the original linked record in 'Table2' is edited.

The code for the second form look like this.

 <?= $this->Form->create($machine, ['url' => ['action' => 'edit_foto']]);?>
 <?= $this->Form->controls([
 'id' => ['type' => 'hidden'],
 'foto.omschrijving' => [
 'type' => 'text',
 'label' => __('naam van de machine'),
 'value' => $result->type_machine
 ], []);?>

 <?= $this->Form->button(__('save'), ['type' => 'submit']); ?>
 <?= $this->Form->end(); ?>

In the controller for 'Table1' I use something like this.

public function editFoto($id) 

 $data = $this->getRequest()->getData();
 $machine = $this->Machines->get($id, [
 'contain' => [
 'Foto'
 ]
 ]);

 if ($this->request->is([
 'patch',
 'post',
 'put'
 ])) 

 $machine = $this->Machines->patchEntity($machine, $data);
 if ($this->Machines->save($machine)) 
 $this->Flash->success(__('Machine naam has been saved.', [
 'naam' => $machine['naam']
 ]));
 return $this->redirect(['action' => 'edit', $id]);
 
 

How can I prevent the controller from editing the original record and instead force to add a new record in 'Table2' and change the bindingkey in 'Table1'?

Help is much appreciated.

added information:
the data send by the form looks like:

[
 'id' => '87',
 'foto' => [
 'omschrijving' => 'WAKER 135 - ter - testje',
 'foto' => [
 'tmp_name' => 'C:xampptmpphp6CFD.tmp',
 'error' => (int) 0,
 'name' => 'MAKITA DTD153RTJ accuschroevendraaier.jpg',
 'type' => 'image/jpeg',
 'size' => (int) 188971
 ],
 'dir_id' => '5c9dd428cc4ef'
 ]
]

Instead of

$machine = $this->Machines->patchEntity($machine, $data);
$this->Machines->save($machine);

you should use

$machine = $this->Machines->newEntity($data, [
 'associated' => ['Fotos']
]);
$this->Machines->save($machine);

to save the data. If the associations between Table1 and Table2 are correct in the models, this will also update the binding keys.

Make sure, the format of the ids in FormHelper is correct. See the docs, how to handle Saving With Associations. You can see this in $data. When submitting the form, $data should be in the following format:

$data = [
 'id' => '...',
 'foto' => [
 // ... model data
 ],
];