Exemplo n.º 1
0
 /**
  * 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);
 }
Exemplo n.º 2
0
include AC_INCLUDE_PATH . 'vitals.inc.php';
include AC_INCLUDE_PATH . 'classes/DAO/ChecksDAO.class.php';
include AC_INCLUDE_PATH . 'classes/DAO/GuidelinesDAO.class.php';
include AC_INCLUDE_PATH . 'classes/DAO/GuidelineGroupsDAO.class.php';
include AC_INCLUDE_PATH . 'classes/DAO/GuidelineSubgroupsDAO.class.php';
include AC_INCLUDE_PATH . 'classes/DAO/CheckPrerequisitesDAO.class.php';
include AC_INCLUDE_PATH . 'classes/DAO/TestPassDAO.class.php';
// initialize constants
$results_per_page = 50;
$dao = new DAO();
$checksDAO = new ChecksDAO();
$guidelinesDAO = new GuidelinesDAO();
$guidelineGroupsDAO = new GuidelineGroupsDAO();
$guidelineSubgroupsDAO = new GuidelineSubgroupsDAO();
$checkPrerequisitesDAO = new CheckPrerequisitesDAO();
$testPassDAO = new TestPassDAO();
// handle submit
if ((isset($_GET['edit']) || isset($_GET['edit_function']) || isset($_GET['delete']) || isset($_GET['add'])) && !isset($_GET['id'])) {
    $msg->addError('SELECT_ONE_ITEM');
} else {
    if (isset($_GET['edit'], $_GET['id'])) {
        header('Location: check_create_edit.php?id=' . $_GET['id']);
        exit;
    } else {
        if (isset($_GET['edit_function'], $_GET['id'])) {
            header('Location: check_function_edit.php?id=' . $_GET['id']);
            exit;
        } else {
            if (isset($_GET['delete'], $_GET['id'])) {
                header('Location: check_delete.php?id=' . $_GET['id']);
                exit;
Exemplo n.º 3
0
/* as published by the Free Software Foundation.                        */
/************************************************************************/
// $Id$
define('AC_INCLUDE_PATH', '../include/');
include_once AC_INCLUDE_PATH . 'vitals.inc.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/ChecksDAO.class.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/CheckPrerequisitesDAO.class.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/TestPassDAO.class.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/CheckExamplesDAO.class.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/GuidelinesDAO.class.php';
include_once AC_INCLUDE_PATH . 'classes/DAO/UsersDAO.class.php';
if (isset($_GET['id'])) {
    $check_id = $_GET['id'];
}
$checkPrerequisitesDAO = new CheckPrerequisitesDAO();
$testPassDAO = new TestPassDAO();
$guidelinesDAO = new GuidelinesDAO();
$checkExamplesDAO = new CheckExamplesDAO();
// handle submit
if (isset($_POST['cancel'])) {
    header('Location: index.php');
    exit;
} else {
    if (isset($_POST['save_no_close']) || isset($_POST['save_and_close']) || $_POST['javascript_submit']) {
        $checksDAO = new ChecksDAO();
        if (!isset($check_id)) {
            $check_id = $checksDAO->Create($_SESSION['user_id'], $_POST['html_tag'], $_POST['confidence'], $_POST['note'], $_POST['name'], $_POST['err'], $_POST['description'], $_POST['search_str'], $_POST['long_description'], $_POST['rationale'], $_POST['how_to_repair'], $_POST['repair_example'], $_POST['question'], $_POST['decision_pass'], $_POST['decision_fail'], $_POST['test_procedure'], $_POST['test_expected_result'], $_POST['test_failed_result'], $_POST['open_to_public']);
        } else {
            $checksDAO->Update($check_id, $_SESSION['user_id'], $_POST['html_tag'], $_POST['confidence'], $_POST['note'], $_POST['name'], $_POST['err'], $_POST['description'], $_POST['search_str'], $_POST['long_description'], $_POST['rationale'], $_POST['how_to_repair'], $_POST['repair_example'], $_POST['question'], $_POST['decision_pass'], $_POST['decision_fail'], $_POST['test_procedure'], $_POST['test_expected_result'], $_POST['test_failed_result'], $_POST['open_to_public']);
        }
        if (!$msg->containsErrors()) {