<?php
echo <<<EOJ
	<div class="head">
		<button type="submit" class="waves-effect btn-flat" onclick="sOPT('downloaddoixml', '')">Download DOI XML</button>
		<button type="submit" class="waves-effect btn-flat red white-text" onclick="sOPT('markasactive', '')">find non activated dois</button>
	</div>
	<table class="table">
		<thead>
			<tr>
				<th class="xs center-align" nowrap>s. no.</th>
				<th nowrap>Vol. Issue</th>
				<th nowrap>Ref. No.</th>
				<th nowrap>DOI</th>
				<th>Title</th>
			</tr>
		</thead>
		<tbody>
EOJ;
		$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, volume, issue, part, title FROM archives WHERE (doi != '' AND doiactive = 'N' AND status = 'enabled')") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($id, $doi, $refnumber, $volume, $issue, $part, $title);
			while($stmt->fetch()):
				$snum  = $snum + 1;
				$title = html_entity_decode($title);
?>
				<tr>
					<td class="center-align" nowrap><?php echo $snum;?></td>
					<td nowrap>Vol. <?php echo $volume . ' Issue ' . $issue . ' Part ' . $part;?></td>
					<td nowrap><?php echo $refnumber;?></td>
					<td nowrap>
						<a href="https://doi.org/<?php echo $doi;?>" target="_blank"><?php echo $doi;?></a>
					</td>
					<td><?php echo html_entity_decode($title);?></td>
				</tr>
<?php
		endwhile;
	else:
		echo '<tr><td colspan="5" class="center-align">MySQL returned an empty result set (i.e. zero rows).</td></tr>';
	endif;
	$stmt->close();
echo '</tbody>';
echo '</table>';