<?php
require_once('header.php');

$keyword = filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING);
$keyword = strip_tags($fn->remaspace($fn->escape($keyword)));
if($keyword):
	$like = "%$keyword%";
	$stmt = $mysqli->prepare("SELECT archive.archivesid, archive.doi, archive.doistatus, archive.year, archive.refnumber, archive.volume, archive.issue, archive.part, archive.title, archive.titlefont, archive.authorname, archive.authornamefont, archive.abstract, archive.file, archive.supplementaryfile, archive.country, archive.pagenumber, archive.views, archive.downloads, archive.specialissue FROM archives as archive LEFT JOIN archiveauthors as archiveauthor ON archive.archivesid = archiveauthor.archiveid WHERE (archive.refnumber = ? OR STRIP_TAGS(archive.title) LIKE ? OR archive.authorname LIKE ? OR archive.abstract LIKE ? OR archive.keywords LIKE ? OR archive.country LIKE ? OR archive.mobile LIKE ? OR archive.email LIKE ? OR archiveauthor.name LIKE ? OR archiveauthor.email LIKE ? OR archiveauthor.phone LIKE ?) AND (archive.status = 'enabled') GROUP BY archive.archivesid ORDER BY archive.creation DESC") or die('An error occurred. Please try after some time.'.$mysqli->error);
	$stmt->bind_param('sssssssssss', $keyword, $like, $like, $like, $like, $like, $like, $like, $like, $like, $like);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
else:
	$count_rows = 0;
endif;
if($count_rows > 0):
	echo '<div class="fluid">Results: <b>'.number_format($count_rows, 0).'</b>, Query: <b>'.trim($keyword,'%').'</b></div>';
echo <<<EOJ
	<table border="0" cellpadding="0" cellspacing="0" class="articles">
	<tr>
	<th class="xs center-align">S. No.</th>
	<th>Title and Authors Name</th>
	</tr>
EOJ;
	$snum = 1;
	$stmt->bind_result($archivesid, $doi, $doistatus, $year, $refnumber, $volume, $issue, $part, $title, $titlefont, $authorname, $authornamefont, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads, $specialissue);
	while($stmt->fetch()):
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = ($titlefont) ? '<b style="font-family:'.$titlefont.' !important;font-size:17px;">'.$title.'</b>' : '<b>'.$title.'</b>';
		$authorname = ($authornamefont) ? '<font style="font-family:'.$authornamefont.' !important;font-size:15px">'.$authorname.'</font>' : $authorname;
		echo '<tr>';
		echo '<td class="xs center-align">'.$snum++.'</td>';
		echo '<td>';
		echo '<div class="body">'.html_entity_decode($title).'</div>';
		echo '<div class="body author"><i>'.html_entity_decode($authorname).'</i></div>';

		if($doi && $doistatus == 'enabled'):
			echo '<div class="body"><b style="font-size:12px">DOI: <a href="https://doi.org/'.$doi.'" class="indigo-text text-darken-3" target="_blank">'.$doi.'</a></b></div>';
		endif;

		echo '<div class="body">Int. J. Midwifery Nurs. Pract., '.$year.'; '.$volume.'('.$issue.'): '.$pagenumber.'</div>';

		echo '<div class="foot">';
		if($abstract):
			echo '<a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'" class="indigo-text text-darken-3"><b>Abstract</b></a>&nbsp;&nbsp;|&nbsp;&nbsp;';
		endif;
		if($file && file_exists($uploadpath.'archives/'.$file)):
			$filesize = round((filesize($uploadpath.'archives/'.$file)) / 1024).' KB';
			echo '<a href="' . $baseurl . 'archives/' . $year . '/vol' . $volume . 'issue' . $issue . '/Part' . $part . '/' . $file . '" target="_blank" class="indigo-text text-darken-3"><b>Download</b></a>&nbsp;&nbsp;|&nbsp;&nbsp;';
		else:
			$filesize = 'NA';
		endif;
		if($supplementaryfile && file_exists($uploadpath.'archives/'.$supplementaryfile)):
			echo '<a href="' . $baseurl . 'archives/' . $year . '/vol' . $volume . 'issue' . $issue . '/Part' . $part . '/' . $supplementaryfile . '" target="_blank" class="indigo-text text-darken-3"><b>Supplementary File</b></a>&nbsp;&nbsp;|&nbsp;&nbsp;';
		endif;
		echo 'Country : '.$country.'&nbsp;&nbsp;|&nbsp;&nbsp;File Size: ('.$filesize.')&nbsp;&nbsp;|&nbsp;&nbsp;<b>'.$views.'</b> Views&nbsp;&nbsp;<b>'.$downloads.'</b> Downloads';
		echo '</div>';

		echo '<div class="foot">'.$year.', Vol. '.$volume.', Issue '.$issue.', Part '.$part.'</div>';
		echo '</td>';
		echo '</tr>';
	endwhile;
	$stmt->close();
	echo '</table>';
else:
	echo 'Sorry, nothing matched your search terms. Please try again with different keywords.';
endif;
require_once('footer.php');
?>