/** * Delete a check by check ID * @access public * @param $checkID * @return true / false * @author Cindy Qi Li */ function Delete($checkID) { $checkID = intval($checkID); // delete all languages require_once AC_INCLUDE_PATH . 'classes/DAO/LanguageTextDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/CheckPrerequisitesDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/TestPassDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/SubgroupChecksDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/Techniques.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/CheckExamplesDAO.class.php'; $langTextDAO = new LanguageTextDAO(); $row = $this->getCheckByID($checkID); if ($row['note'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['note']); } if ($row['name'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['name']); } if ($row['err'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['err']); } if ($row['description'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['description']); } if ($row['search_str'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['search_str']); } if ($row['long_description'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['long_description']); } if ($row['rationale'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['rationale']); } if ($row['how_to_repair'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['how_to_repair']); } if ($row['repair_example'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['repair_example']); } if ($row['question'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['question']); } if ($row['decision_pass'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['decision_pass']); } if ($row['decision_fail'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['decision_fail']); } if ($row['test_procedure'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['test_procedure']); } if ($row['test_expected_result'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['test_expected_result']); } if ($row['test_failed_result'] != '') { $langTextDAO->DeleteByVarAndTerm('_check', $row['test_failed_result']); } $checkPrerequisitesDAO = new CheckPrerequisitesDAO(); $checkPrerequisitesDAO->DeleteByCheckID($checkID); $testPassDAO = new TestPassDAO(); $testPassDAO->DeleteByCheckID($checkID); $subgroupChecksDAO = new SubgroupChecksDAO(); $subgroupChecksDAO->DeleteByCheckID($checkID); $techniques = new Techniques(); $techniques->DeleteByCheckID($checkID); $checkExamplesDAO = new CheckExamplesDAO(); $checkExamplesDAO->DeleteByCheckID($checkID); $sql = "DELETE FROM " . TABLE_PREFIX . "checks WHERE check_id=" . $checkID; return $this->execute($sql); }
include_once AC_INCLUDE_PATH . 'classes/DAO/GuidelineGroupsDAO.class.php'; include_once AC_INCLUDE_PATH . 'classes/DAO/GuidelineSubgroupsDAO.class.php'; include_once AC_INCLUDE_PATH . 'classes/DAO/SubgroupChecksDAO.class.php'; include_once AC_INCLUDE_PATH . 'classes/DAO/ChecksDAO.class.php'; include_once AC_INCLUDE_PATH . 'classes/DAO/UsersDAO.class.php'; global $_current_user; if (isset($_GET["id"])) { $gid = intval($_GET["id"]); } if ($gid == 0) { unset($gid); } $guidelinesDAO = new GuidelinesDAO(); $guidelineGroupsDAO = new GuidelineGroupsDAO(); $guidelineSubgroupsDAO = new GuidelineSubgroupsDAO(); $subgroupChecksDAO = new SubgroupChecksDAO(); // handle submits if (isset($_POST['cancel'])) { $msg->addFeedback('CANCELLED'); header('Location: index.php'); exit; } else { if (isset($_POST['save_no_close']) || isset($_POST['save_and_close']) || $_POST['javascript_submit']) { if (isset($gid)) { $guidelinesDAO->update($gid, $_POST['user_id'], $_POST['title'], $_POST['abbr'], $_POST['long_name'], $_POST['published_date'], $_POST['earlid'], '', $_POST['status'], $_POST['open_to_public']); } else { $gid = $guidelinesDAO->Create($_SESSION['user_id'], $_POST['title'], $_POST['abbr'], $_POST['long_name'], $_POST['published_date'], $_POST['earlid'], '', $_POST['status'], $_POST['open_to_public']); if (intval($gid) == 0) { unset($gid); } }
/** * Add checks into guideline * @access public * @param $guidelineID : guideline id * $cids : array of check ids to be added into guideline * @return true : if successful * false : if unsuccessful * @author Cindy Qi Li */ public function addChecks($guidelineID, $cids) { require_once AC_INCLUDE_PATH . 'classes/DAO/GuidelineGroupsDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/GuidelineSubgroupsDAO.class.php'; require_once AC_INCLUDE_PATH . 'classes/DAO/SubgroupChecksDAO.class.php'; $guidelineID = intval($guidelineID); if ($guidelineID == 0) { $msg->addError('MISSING_GID'); return false; } $guidelineGroupsDAO = new GuidelineGroupsDAO(); $groups = $guidelineGroupsDAO->getUnnamedGroupsByGuidelineID($guidelineID); if (is_array($groups)) { $group_id = $groups[0]['group_id']; } else { $group_id = $guidelineGroupsDAO->Create($guidelineID, '', '', ''); } if ($group_id) { $guidelineSubgroupsDAO = new GuidelineSubgroupsDAO(); $subgroups = $guidelineSubgroupsDAO->getUnnamedSubgroupByGroupID($group_id); if (is_array($subgroups)) { $subgroup_id = $subgroups[0]['subgroup_id']; } else { $subgroup_id = $guidelineSubgroupsDAO->Create($group_id, '', ''); } if ($subgroup_id) { $subgroupChecksDAO = new SubgroupChecksDAO(); if (is_array($cids)) { foreach ($cids as $cid) { $cid = intval($cid); if ($cid > 0) { $subgroupChecksDAO->Create($subgroup_id, $cid); } } } } else { return false; } } else { return false; } return true; }
/** * Add checks into guideline subgroup * @access public * @param $groupID : subgroup id * $cids : array of check ids to be added into group * @return true : if successful * false : if unsuccessful * @author Cindy Qi Li */ public function addChecks($subgroupID, $cids) { global $msg; require_once AC_INCLUDE_PATH . 'classes/DAO/SubgroupChecksDAO.class.php'; $subgroupID = intval($subgroupID); if ($subgroupID == 0) { $msg->addError('MISSING_GID'); return false; } $subgroupChecksDAO = new SubgroupChecksDAO(); if (is_array($cids)) { foreach ($cids as $cid) { $cid = intval($cid); if ($cid > 0) { $subgroupChecksDAO->Create($subgroupID, $cid); } } } return true; }