diff options
Diffstat (limited to 'general_deletion.inc')
| -rwxr-xr-x | general_deletion.inc | 195 |
1 files changed, 195 insertions, 0 deletions
diff --git a/general_deletion.inc b/general_deletion.inc new file mode 100755 index 0000000..0edfc3a --- /dev/null +++ b/general_deletion.inc @@ -0,0 +1,195 @@ +<?php +/******************************************************************************/ +/****************************** DELETION FUNCTIONS ****************************/ +/******************************************************************************/ +function om_pssp_abstract_delete_project($proposal_id) +{ + $status = TRUE; + $root_path = om_pssp_path(); + $query = db_select('om_pssp_proposal'); + $query->fields('om_pssp_proposal'); + $query->condition('id', $proposal_id); + $proposal_q = $query->execute(); + $proposal_data = $proposal_q->fetchObject(); + if (!$proposal_data) + { + drupal_set_message('Invalid power system simulation Project.', 'error'); + return FALSE; + } //!$proposal_data + $query = db_select('om_pssp_submitted_abstracts_file'); + $query->fields('om_pssp_submitted_abstracts_file'); + $query->condition('proposal_id', $proposal_id); + $abstract_q = $query->execute(); + $dir_project_files = $root_path . $proposal_data->directory_name . '/project_files'; + while ($abstract_data = $abstract_q->fetchObject()) + { + if (is_dir($dir_project_files)){ + + unlink($root_path . $proposal_data->directory_name . '/project_files/' . $abstract_data->filepath); + } + else + { + drupal_set_message('Invalid power system simulation project abstract.', 'error'); + } + db_delete('om_pssp_submitted_abstracts_file')->condition('proposal_id', $proposal_id)->execute(); + //!dwsim_flowsheet_delete_abstract_file($abstract_data->id) + } + $res = rmdir($root_path . $proposal_data->directory_name . '/project_files'); + $dir_path_udc = $root_path . $proposal_data->directory_name; + if (is_dir($dir_path_udc)) + { + unlink($root_path . $proposal_data->samplefilepath); + $res = rmdir($dir_path_udc); + } //is_dir($dir_path_udc) + db_delete('om_pssp_proposal')->condition('id', $proposal_data->id)->execute(); + + db_delete('om_pssp_submitted_abstracts')->condition('proposal_id', $proposal_id)->execute(); + return $status; +} +/*function om_pssp_delete_abstract_file($abstract_id) +{ + //var_dump($abstract_id);die; + $status = TRUE; + $root_path = om_pssp_path(); + $abstract_q = db_query("SELECT * from om_pssp_proposal dfp +LEFT JOIN om_pssp_submitted_abstracts dfsa ON dfp.id = dfsa.proposal_id +WHERE dfsa.id = :abstract_id", array( + ":abstract_id" => $abstract_id + )); + $abstract_data = $abstract_q->fetchObject(); + if (!$abstract_data) + { + drupal_set_message('Invalid flowsheet project abstract.', 'error'); + return FALSE; + } //!$abstract_data + /* deleting solutions */ + /*$query = db_select('om_pssp_submitted_abstracts_file'); + $query->fields('om_pssp_submitted_abstracts_file'); + $query->condition('submitted_abstract_id', $abstract_id); + $abstract_f_q = $query->execute(); + $delete_project_folder = FALSE; + while ($abstract_f_data = $abstract_f_q->fetchObject()) + { + $delete_project_folder = TRUE; + if (!_om_pssp_delete_abstract_file($abstract_f_data->id)) + $status = FALSE; + } //$abstract_f_data = $abstract_f_q->fetchObject() + if (!$delete_project_folder) + { + return TRUE; + } //!$delete_project_folder + if ($status) + { + $dir_path_udc = $root_path . $abstract_f_data->directory_name; + if (is_dir($dir_path_udc)) + { + unlink($root_path . $abstract_f_data->samplefilepath); + //$res = rmdir($dir_path_udc); + /*if (!$res) + { + drupal_set_message(t('Error in deleting user defiend folder !folder', array( + '!folder' => $abstract_f_data->directory_name + )), 'error'); + /* sending email to admins */ + /* $email_to = variable_get('om_pssp_emails', ''); + $from = variable_get('om_pssp_from_email', ''); + $bcc = ""; + $cc = variable_get('om_pssp_cc_emails', ''); + $params['standard']['subject'] = "[ERROR] Error deleting experiment folder"; + $params['standard']['body'] = "Error deleting folder " . $dir_path; + $params['standard']['headers'] = array( + 'From' => $from, + 'MIME-Version' => '1.0', + 'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes', + 'Content-Transfer-Encoding' => '8Bit', + 'X-Mailer' => 'Drupal', + 'Cc' => $cc, + 'Bcc' => $bcc + ); + if (!drupal_mail('om_pssp', 'standard', $email_to, language_default(), $params, $from, TRUE)) + drupal_set_message('Error sending email message.', 'error'); + return FALSE; + } //!$res + else + { + return TRUE; + } + }*/ //is_dir($dir_path_udc) + /*} //$status + return FALSE; +} +} +function _om_pssp_delete_abstract_file($abstract_id) +{ + global $user; + $root_path = om_pssp_path(); + $query = db_select('om_pssp_proposal'); + $query->fields('om_pssp_proposal'); + $query->condition('id', $abstract_id); + $abstract_q = $query->execute(); + $abstract_data = $abstract_q->fetchObject(); + $abstract_q = db_query("SELECT * from om_pssp_proposal dfp +LEFT JOIN om_pssp_submitted_abstracts dfsa ON dfp.id = dfsa.proposal_id +WHERE dfsa.id = :abstract_id", array( + ":abstract_id" => $abstract_id + )); + $abstract_data = $abstract_q->fetchObject(); + if (!$abstract_data) + { + drupal_set_message('Invalid flowsheet project abstract.', 'error'); + return FALSE; + } //!$abstract_data + /* deleting abstract files + $query = db_select('om_pssp_submitted_abstracts_file'); + $query->fields('om_pssp_submitted_abstracts_file'); + $query->condition('submitted_abstract_id', $abstract_id); + $abstract_f_q = $query->execute(); + while ($abstract_f_data = $abstract_f_q->fetchObject()) + { + unlink($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath); + $res = rmdir($root_path . $abstract_data->directory_name . '/project_files'); + /*if (!file_exists($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath)) + { + $status = FALSE; + drupal_set_message(t('Error deleting !file. File does not exists.', array( + '!file' => $abstract_data->directory_name . '/project_files' . $abstract_f_data->filepath + )), 'error'); + continue; + } //!file_exists($root_path . $abstract_data->directory_name . '/' . $abstract_f_data->filepath) + /* removing solution file */ + /*if (!unlink($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath)) + { + $status = FALSE; + drupal_set_message(t('Error deleting !file', array( + '!file' => $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath + )), 'error'); + /* sending email to admins */ + /* $from = variable_get('om_pssp_from_email', ''); + $bcc = variable_get('om_pssp_emails', ''); + $cc = variable_get('om_pssp_cc_emails', ''); + $params['standard']['subject'] = "[ERROR] Error deleting example file"; + $params['standard']['body'] = "Error deleting solution files by " . $user->uid . " at " . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] . " : + file id : " . $abstract_data->id . " + file path : " . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath; + $params['standard']['headers'] = array( + 'From' => $from, + 'MIME-Version' => '1.0', + 'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes', + 'Content-Transfer-Encoding' => '8Bit', + 'X-Mailer' => 'Drupal', + 'Cc' => $cc, + 'Bcc' => $bcc + ); + if (!drupal_mail('om_pssp', 'standard', $email_to, language_default(), $params, $from, TRUE)) + drupal_set_message('Error sending email message.', 'error'); + } *///!unlink($root_path . $abstract_data->directory_name . '/' . $abstract_f_data->filepath) + +/* } + /* deleting example files database entries */ + //db_delete('om_pssp_submitted_abstracts_file')->condition('id', $abstract_f_data->id)->execute();//$abstract_f_data = $abstract_f_q->fetchObject() +/* if (!$status) + { + return FALSE; + } //!$status + return $status; +}*/
\ No newline at end of file |