/**
* Delete guideline by ID
* @access public
* @param $guidelineID : guideline id
* @return true : if successful
* false : if unsuccessful
* @author Cindy Qi Li
*/
public function Delete($guidelineID)
{
require_once AC_INCLUDE_PATH . 'classes/DAO/GuidelineGroupsDAO.class.php';
$guidelineID = intval($guidelineID);
// Delete all subgroups
$guidelineGroupsDAO = new GuidelineGroupsDAO();
$sql = "SELECT group_id FROM " . TABLE_PREFIX . "guideline_groups\n\t\t WHERE guideline_id = " . $guidelineID;
$rows = $this->execute($sql);
if (is_array($rows)) {
foreach ($rows as $row) {
$guidelineGroupsDAO->Delete($row['group_id']);
}
}
// delete language for long name
$sql = "DELETE FROM " . TABLE_PREFIX . "language_text \n\t\t WHERE variable='_guideline' \n\t\t AND term=(SELECT long_name \n\t\t FROM " . TABLE_PREFIX . "guidelines\n\t\t WHERE guideline_id=" . $guidelineID . ")";
$this->execute($sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "guidelines WHERE guideline_id=" . $guidelineID;
return $this->execute($sql);
}
foreach ($value as $del_check_id) {
$subgroupChecksDAO->deleteChecksByTypeAndID('subgroup', $action_on_id, substr($del_check_id, strlen($value_prefix) + 1));
}
}
}
}
}
}
}
// remove groups and subgroups
if ($_GET['action'] == 'remove') {
if (isset($_GET['gsg'])) {
$guidelineSubgroupsDAO->Delete($_GET['gsg']);
}
if (isset($_GET['gg'])) {
$guidelineGroupsDAO->Delete($_GET['gg']);
}
header('Location: create_edit_guideline.php?id=' . $gid);
exit;
}
// interface display
if (!isset($gid)) {
// create guideline
$checksDAO = new ChecksDAO();
$savant->assign('author', $_current_user->getUserName());
} else {
// edit existing guideline
$checksDAO = new ChecksDAO();
$rows = $guidelinesDAO->getGuidelineByIDs($gid);
// get author name
$usersDAO = new UsersDAO();
