public static function deleteById($ID = NULL)
{
$result = EJHSJournalArticle::queryOneById($ID);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
EJHSJournalArticle::deleteUpload($row['upload_location'], $row['upload_name']);
if (EJHSJournalArticle::checkIfUploadExists($row['upload_location'], $row['upload_name'])) {
EJHSJournalArticle::deleteUpload($row['upload_location'], $row['upload_name']);
}
$query = "DELETE FROM journal_article WHERE id = '{$ID}'";
$result = mysql_query($query) or die('Error : ' . mysql_error());
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
if (EJHSJournalArticle::deleteById($_GET['del'])) {
$_SESSION['notice'] = 'File Deletion Was Successful.';
header('location:journal_article_list.php?artID=' . $jRow['id'] . '&vol=' . $jRow['volume'] . '&num=' . $jRow['num'] . '&year=' . $jRow['year'] . '');
exit;
} else {
$_SESSION['error'] = "File Deletion Was Not Sccuessful.";
header('Location: ' . $_SERVER['PHP_SELF'] . '?detailID=' . $_GET['detailID'] . '&her2e=here');
exit;
}
}
if (isset($_GET['detailID']) && EJHSJournalArticle::checkIfExists($_GET['detailID'])) {
## Get Journal By ID
$detailID = $_GET['detailID'];
$aResult = EJHSJournalArticle::queryOneById($detailID);
$aRow = mysql_fetch_array($aResult, MYSQL_ASSOC);
$jResult = EJHSJournalArticle::queryOneById($aRow['journal_id']);
$jRow = mysql_fetch_array($jResult, MYSQL_ASSOC);
} else {
## redirect to Journal Edit
$_SESSION['notice1'] = "Requested Journal Article Information Unavailable.";
header('location: journal_article_edit.php');
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>E J H S | About Ethiopian Journal of Health Sciences</title>
<link href="admin-style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
session_start();
if (!$_SESSION['user_is_logged_in']) {
header("location:login.php");
}
if ($_SESSION['privilege'] != "reviewer") {
header("location:login.php");
}
include 'library/config.php';
include 'library/opendb.php';
include 'EJHSJournal.class.php';
include 'EJHSJournalForm.class.php';
include 'EJHSJournalArticle.class.php';
include 'EJHSJournalArticleCategory.class.php';
if (isset($_GET['del'])) {
$aResult = EJHSJournalArticle::queryOneById($_GET['del']);
$aRow = mysql_fetch_array($aResult, MYSQL_ASSOC);
$jResult = EJHSJournal::queryOneById($aRow['journal_id']);
$jRow = mysql_fetch_array($jResult, MYSQL_ASSOC);
if (EJHSJournalArticle::deleteById($_GET['del'])) {
$_SESSION['notice'] = 'File Deletion Was Successful.';
header('location:journal_article_list.php?artID=' . $jRow['id'] . '&vol=' . $jRow['volume'] . '&num=' . $jRow['num'] . '&year=' . $jRow['year'] . '');
exit;
} else {
$_SESSION['error'] = "File Deletion Was Not Sccuessful.";
header('Location: ' . $_SERVER['PHP_SELF'] . '?detailID=' . $_GET['detailID'] . '&her2e=here');
exit;
}
}
?>
