function delete($id) { $req_mgr = new requirement_mgr($this->db); // Delete Custom fields $this->cfield_mgr->remove_all_design_values_from_node($id); $result = $this->attachmentRepository->deleteAttachmentsFor($id, "req_specs"); // delete requirements (one type req spec children) with all related data // coverage, attachments, custom fields, etc $requirements_info = $this->get_requirements($id); if (!is_null($requirements_info)) { $items = null; foreach ($requirements_info as $req) { $items[] = $req["id"]; } $req_mgr->delete($items); } // delete specification itself $sql = "DELETE FROM {$this->object_table} WHERE id = {$id}"; $result = $this->db->exec_query($sql); $sql = "DELETE FROM {$this->tables['nodes_hierarchy']} WHERE id = {$id}"; $result = $this->db->exec_query($sql); if ($result) { $result = 'ok'; } else { $result = 'The DELETE SRS request fails.'; } return $result; }