/**
* 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;
}
}
