/** * Delete all entries of given subgroup ID * @access public * @param $subgroupID : subgroup id * @return true : if successful * false : if not successful * @author Cindy Qi Li */ public function Delete($subgroupID) { require_once AC_INCLUDE_PATH . 'classes/DAO/SubgroupChecksDAO.class.php'; $subgroupID = intval($subgroupID); // Delete all checks in this subgroup $subgroupChecksDAO = new SubgroupChecksDAO(); if ($subgroupChecksDAO->DeleteBySubgroupID($subgroupID)) { // delete language for subgroup name $sql = "DELETE FROM " . TABLE_PREFIX . "language_text \n\t\t\t WHERE variable='_guideline' \n\t\t\t AND term=(SELECT name \n\t\t\t FROM " . TABLE_PREFIX . "guideline_subgroups\n\t\t\t WHERE subgroup_id=" . $subgroupID . ")"; $this->execute($sql); // delete guideline_subgroups $sql = "DELETE FROM " . TABLE_PREFIX . "guideline_subgroups WHERE subgroup_id=" . $subgroupID; return $this->execute($sql); } else { return false; } }