/**
* This function deletes a survey (and also all the question in that survey
*
* @param $survey_id the id of the survey that has to be deleted
* @return true
*
* @author Patrick Cool <*****@*****.**>, Ghent University
* @version January 2007
*/
public static function delete_survey($survey_id, $shared = false, $course_id = '')
{
// Database table definitions
if (empty($course_id)) {
$course_id = api_get_course_int_id();
}
$survey_id = intval($survey_id);
if (empty($survey_id)) {
return false;
}
$course_info = api_get_course_info_by_id($course_id);
$course_id = $course_info['real_id'];
$table_survey = Database::get_course_table(TABLE_SURVEY);
$table_survey_question_group = Database::get_course_table(TABLE_SURVEY_QUESTION_GROUP);
if ($shared) {
$table_survey = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY);
// Deleting the survey
$sql = "DELETE FROM {$table_survey} WHERE survey_id='" . $survey_id . "'";
Database::query($sql);
} else {
$sql = "DELETE FROM {$table_survey} WHERE c_id = {$course_id} AND survey_id='" . $survey_id . "'";
Database::query($sql);
}
// Deleting groups of this survey
$sql = "DELETE FROM {$table_survey_question_group} WHERE c_id = {$course_id} AND survey_id='" . $survey_id . "'";
Database::query($sql);
// Deleting the questions of the survey
survey_manager::delete_all_survey_questions($survey_id, $shared);
// Update into item_property (delete)
api_item_property_update($course_info, TOOL_SURVEY, $survey_id, 'SurveyDeleted', api_get_user_id());
return true;
}
