0) {
while($info9 = mysqli_fetch_array($result9)){
$reviewed_id=$info9['submission_id'];
//Show review submissions
$title_text ="
Your review submissions";
$sql_done = "SELECT * FROM submission_tbl WHERE status = 'completed' OR status = 'published' AND id='$reviewed_id'";
$note = "";
}
}
}else{
$sql_done = "SELECT * FROM review_comment WHERE reviewer_id = '$_SESSION[id]' ORDER BY id DESC";
$result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
if (mysqli_num_rows($result9) > 0) {
while($info9 = mysqli_fetch_array($result9)){
$submission_id=$info9['submission_id'];
//Show review submissions
$title_text ="
Awaiting your review";
$sql_done = "SELECT * FROM submission_tbl WHERE status = 'completed' AND id <> '$submission_id'"; //submission would be assigned to reviewer by the admin
$note = "Click the submission
title to download and read the document to be review.";
}
}
}
}else{
$status = mysqli_escape_string($conn, $_REQUEST['status']);
if($status=='0'){
$note = "
Note:
You will be able to update a completed submission after the reviews had been approved.
If you update your submission to effect a review, you must ensure you click the “Final Submission” in Step 5
";
$title_text ="
Active Submissions";
$sql_done = "SELECT * FROM submission_tbl WHERE user_id = '$_SESSION[id]' AND status = '' OR status = 'completed'";
}elseif($status=='1'){
$note = "
Your submission will be included in our next publication volume. Congratulations!
";
$title_text ="
Archive Submissions";
$sql_done = "SELECT * FROM submission_tbl WHERE user_id = '$_SESSION[id]' AND status = 'archived' ";
}elseif($status=='2'){
$note = "";
$title_text ="
Published Submissions";
$sql_done = "SELECT * FROM submission_tbl WHERE user_id = '$_SESSION[id]' AND status = 'published' ";
}
}
$result = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
$num_report = mysqli_num_rows($result);
print "
$title_text
$note
";
print '
| Id |
Submitted Date |
Section |
Authors |
Title |
Status |
|
';
$count++;
while($info = mysqli_fetch_array($result))
{
$submission_id=$info['id'];
$date_time=$info['date_time'];
$jounal_section=$info['jounal_section'];
$comments_for_the_editor=$info['comments_for_the_editor'];
$submission_file=$info['submission_file'];
$title=$info['title'];
$abstract=$info['abstract'];
$keywords_text =$info['keywords_text'];
$language_text =$info['language_text'];
$agencies =$info['agencies'];
$references_text =$info['references_text'];
$status =$info['status'];
$volume_id =$info['volume_id'];
if($_SESSION['user_type']=='1'){ //Publisher
if($status == ""){
$status_msg = "Incomplete";
$status_button =
"Delete
|
Edit";
}elseif($status == "completed"){
$status_msg = "completed";
//update can only be done when a review is approved....
$sql_done = "SELECT * FROM review_comment WHERE submission_id = '$submission_id' AND status='approved'";
$result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
$num_approved_review = mysqli_num_rows($result9);
if($num_approved_review > 0){
$status_button = "
$num_approved_review Reviews
Update Submission
";
}else{
$status_button="Under Review";
}
}elseif($status == "archived"){
$status_msg = "Archived";
$status_button = "";
}elseif($status=="published"){
$vol_id = $volume_id;
include("admin/inc_volume.php");
$status_msg = "Published";
$status_button = $volume_title;
}
}elseif($_SESSION['user_type']=='2'){ //Reviewer
if(isset($_REQUEST['see_review'])){
if($status=='completed'){
$status_msg = "Reviewed";
$status_button="
Detail
";
}elseif($status=='published'){
$status_msg = "$status";
$status_button="";
}
}else{
$status_msg = "Awaiting your reviewal";
$status_button="
Review
";
}
}
if($title != ""){
$title_msg = "$title";
}else{
$title_msg="Untitled";
}
//get all authors....
$authors="";
$all_authors="";
$sql_done = "SELECT * FROM authors_record WHERE submission_id = '$submission_id' ORDER BY id DESC";
$result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn));
if (mysqli_num_rows($result9) > 0) {
while($info9 = mysqli_fetch_array($result9))
{
$all_authors.=$info9['first_name'].", ";
}
$authors= rtrim($all_authors, ', ');
}
print "
| 00$submission_id |
$date_time |
$jounal_section |
$authors |
$title_msg |
$status_msg |
$status_button |
";
}
print '
';
?>