<?php
require_once("header.php");
echo $page_content;

if($loggedcreds):
	$tab = isset($_GET['tab']) ? $fn->escape($_GET['tab']) : NULL;
	$id = isset($_GET['id']) ? $fn->escape($_GET['id']) : NULL;

	$stmt = $mysqli->prepare("SELECT name FROM users WHERE email = ? LIMIT 1") or die(output(false, 'An error occurred. Please try after some time.'));
	$stmt->bind_param('s', $loggedcreds);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($name);
	$stmt->fetch();
	$stmt->close();
	if($count_rows == 1):
echo <<<EOJ
		<div class="fluid account">
EOJ;
			if(($tab && $id)):
				$stmt = $mysqli->prepare("SELECT title, status FROM articlestatus WHERE (email = ? AND articlestatusid = ?)") or die('An error occurred. Please try after some time.');
				$stmt->bind_param('si', $loggedcreds, $id);
				$stmt->execute();
				$stmt->store_result();
				$count_rows = $stmt->num_rows();
				$stmt->bind_result($title, $status);
				$stmt->fetch();
				$stmt->close();
				if($count_rows == 1):
?>
					<div class="fluid statusbar">
						<div class="head" style="font-size:14px"><b>Title:</b> <?php echo $title;?><br /><br /><b>Author:</b> Abubakar Esenowo</div>
						<table border="0" cellpadding="0" cellspacing="0" class="fluid">
						<tbody>
						<tr>
							<td class="l" style="background:none"></td>
							<td class="c act"></td>
							<td class="r"></td>
							<td class="l"></td>
							<td class="c">2</td>
							<td class="r"></td>
							<td class="l"></td>
							<td class="c">3</td>
							<td class="r"></td>
							<td class="l"></td>
							<td class="c">4</td>
							<td class="r"></td>
							<td class="l"></td>
							<td class="c">5</td>
							<td class="r"></td>
							<td class="l"></td>
							<td class="c">6</td>
							<td class="r" style="background:none"></td>
						</tr>
						</tbody>
						<tfoot>
						<tr>
							<td colspan="3">Submit</td>
							<td colspan="3">Under Review</td>
							<td colspan="3">Accepted</td>
							<td colspan="3">Dues Completed</td>
							<td colspan="3">Proof Send</td>
							<td colspan="3">Published</td>
						</tr>
						</tfoot>
						</table>
					</div>
<?php
				else:
					echo 'No article found.';
				endif;
			else:
				$snum = 0;
				$stmt = $mysqli->prepare("SELECT articlestatusid, title FROM articlestatus WHERE email = ? ORDER BY creation DESC") or die('An error occurred. Please try after some time.');
				$stmt->bind_param('s', $loggedcreds);
				$stmt->execute();
				$stmt->store_result();
				if($stmt->num_rows() > 0):
					$stmt->bind_result($articlestatusid, $title);
echo <<<EOJ
					<table border="0" cellpadding="0" cellspacing="0" class="fluid articles">
					<tr>
					<th align="center" valign="middle" class="xs">S. No.</th>
					<th align="left" valign="middle">Title</th>
					</tr>
EOJ;
					while($stmt->fetch()):
						$snum = $snum + 1;
						$title = strip_tags(html_entity_decode($title), '<i><em>');
						echo '<tr>';
						echo '<td align="center" valign="top" class="xs">'.$snum.'</td>';
						echo '<td align="left" valign="top" style="text-align:justify">';
						echo '<a href="'.$baseurl.'account/article/'.$articlestatusid.'">'.$title.'</a>';
						echo '</td>';
						echo '</tr>';
					endwhile;
					echo '</table>';
				else:
					echo 'You have not submitted any article.';
				endif;
				$stmt->close();
			endif;
		echo '</div>';
	else:
		unset($_SESSION);
		session_destroy();
		echo 'User not found.';
	endif;
else:
	echo 'You are not logged in. <a href="'.$baseurl.'login">Click here</a> to login.';
endif;

require_once("footer.php");
?>