コード例 #1
0
 /**
  * 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);
 }
コード例 #2
0
                        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();