Change Children id to another id

Question

I made a panel with some functions of Tree, edit, move and delete. Until then my erasing is working when I want to erase a specific thing without children. The problem is that when I delete an item that has children, it erases all the children together, and my intention was that it would change the parent_id of the children from the item that will be deleted, to the item that I selected in the list.

PS: that $this->request->data['Navigation']['childs'] is the id I have a menu with a list returning all the ids I have available so that the person can change them.

public function apagar($id){
        if ($this->request->is('post')){
            empty($this->request->data['Navigation']['childs']) ? null : $this->request->data['Navigation']['childs'];
            $this->Navigation->updateAll(array(
            'Navigation.parent_id' => $id,
             ), array(
            'Navigation.parent_id' => $this->request->data['Navigation']['childs'],
            ));
            $this->Navigation->id = $id;
            $this->Navigation->delete();
            $this->Session->setFlash('Menu Apagado!');
            return $this->redirect('/navegacao');
        } else {
            $tree = $this->Navigation->generateTreeList(null, null, null, '   - ');
            unset($tree[$id]);
            $this->set('tree', $tree);
        }
    }

Answer 1

Note that this line below does not result in anything.

empty($this->request->data['Navigation']['childs']) ? null : $this->request->data['Navigation']['childs'];

To be honest, I don’t quite understand what your logic is about deleting the record or not. But apparently, his intention was to use the value of his column childs to make this update. So you need to do something more or less like this:

if (!empty($this->request->data['Navigation']['childs'])) {
    // Possui filhos
    $this->Navigation->updateAll(
                array('Navigation.parent_id' => $id),
                array('Navigation.parent_id' => $this->request->data['Navigation']['childs'])
    );
} else {
    // Não possui filhos
}