/**
* Removes all uploads associated with the current response, deletes all response value
* entries and removes the response.
*
* @return bool
*/
public function Delete($survey_id = 0)
{
// deleting the actual survey images folder if there are any..
if (!empty($survey_id)) {
$dir = TEMP_DIRECTORY . DIRECTORY_SEPARATOR . $survey_id . DIRECTORY_SEPARATOR . $this->id;
if (is_dir($dir)) {
$dir = new IEM_FileSystem_Directory($dir);
$dir->delete();
}
}
// remove all response values associated to this response
$this->db->Query("\r\n\t\t\t\tDELETE FROM " . $this->Db->TablePrefix . self::RESPONSEVALUE_TABLE_NAME . "\r\n\t\t\t\tWHERE surveys_response_id = " . $this->id);
// delete the response
$this->db->Query("\r\n\t\t\t\tDELETE FROM " . $this->Db->TablePrefix . self::RESPONSE_TABLE_NAME . "\r\n\t\t\t\tWHERE id = " . $this->id);
}
/**
* Removes all uploads associated with the current response, deletes all response value
* entries and removes the response.
*
* @return bool
*/
public function Delete($survey_id = 0)
{
// delete any files being uploaded..
if (!empty($survey_id)) {
//survey ID
$dir = TEMP_DIRECTORY . DIRECTORY_SEPARATOR . 'surveys' . DIRECTORY_SEPARATOR . $survey_id . DIRECTORY_SEPARATOR . $this->id;
if (is_dir($dir)) {
$dir = new IEM_FileSystem_Directory($dir);
$dir->delete();
}
}
// remove all response values associated to this response
$this->Db->Query("\n\t\t\t\tDELETE FROM " . $this->Db->TablePrefix . self::RESPONSEVALUE_TABLE_NAME . "\n\t\t\t\tWHERE surveys_response_id = " . $this->id);
// delete the response
$this->Db->Query("\n\t\t\t\tDELETE FROM " . $this->Db->TablePrefix . self::RESPONSE_TABLE_NAME . "\n\t\t\t\tWHERE id = " . $this->id);
return true;
}
/**
* Deletes a surveys, together with its Widgets and Fields
*
* @param Int $surveyid The surveyid to delete
*
* @return Void Returns nothing
*/
public function Delete($surveyid)
{
$surveyid = (int) $surveyid;
$prefix = $this->Db->TablePrefix;
// First Delete all Widgets Associated with the form,
$widgets = $this->getWidgets($surveyid);
foreach ($widgets as $key => $widget) {
// for each widget delete all the fields related ..
$query = "DELETE FROM {$prefix}surveys_fields WHERE surveys_widget_id = {$widget['id']}";
$this->Db->Query($query);
}
// Delete the actual widget,
$query = "DELETE FROM {$prefix}surveys_widgets WHERE surveys_id = {$surveyid}";
$this->Db->Query($query);
// Lastly delete the actual suvey
$query = "DELETE FROM {$prefix}surveys WHERE id = {$surveyid}";
$this->Db->Query($query);
// Delete all the responses and response value as well..
$query = "DELETE sr, srv\n\t\t\t\t FROM {$prefix}surveys_response as sr, {$prefix}surveys_response_value as srv\n\t\t\t\t WHERE sr.id = srv.surveys_response_id and\n\t\t\t\t sr.surveys_id = {$surveyid}";
// Delete all the files uploaded from the survey folders..
$survey_images_dir = TEMP_DIRECTORY . DIRECTORY_SEPARATOR . 'surveys' . DIRECTORY_SEPARATOR . $surveyid;
if (is_dir($survey_images_dir)) {
// Delete using our library file
$dir = new IEM_FileSystem_Directory($survey_images_dir);
$dir->delete();
}
$this->Db->Query($query);
}
