<?php
require_once('header.php');
echo '<div class="row head main"><div class="col s12 m12 l12 center-align"><h1>'.$pagetitle.'</h1></div></div>';
?>
<style>
	.journalsHead {
		float: left;
		width: 100%;
		padding: 10px 16px;
		color: #fff !important;
		text-transform: uppercase;
		margin-bottom: 16px;
		border-radius: 4px;
	}

	.journalsBody .col {
		margin-bottom: 16px;
	}

	.journalsBody .col .jWrapper {
		display: flex;
		justify-content: left;
		align-items: center;
		column-gap: 12px;
		border: 1px solid #d9d9d9;
		padding: 12px;
		border-radius: 4px;
	}

	.journalsBody .col .jCoverPage {
		flex-shrink: 0;
		width: 80px;
	}

	.journalsBody .col .jInfo {
		display: flex;
		flex-direction: column;
		row-gap: 6px;
		text-align: left;
	}

	@media (max-width: 600px) {
		.journalsBody .col .jWrapper {
			flex-direction: column;
			row-gap: 20px;
		}

    	.journalsBody .col .jCoverPage {
    		width: 120px;
    	}

		.journalsBody .col .jInfo {
			justify-content: center;
			text-align: center;
		}
	}
</style>
<?php
function journal($subject)
{
	global $mysqli, $imageurl, $uploadpath;
	$html = '';
	$stmt = $mysqli->prepare("SELECT journal, journalemail, domain, coverpage, issn, doi FROM journals WHERE (subject = ? AND status = 'enabled') ORDER BY journal ASC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('s', $subject);
	$stmt->execute();
	$stmt->store_result();
	$stmt->bind_result($journal, $journalemail, $domain, $coverpage, $issn, $doi);
	while ($stmt->fetch()) :
		$coverpage = ($coverpage && file_exists($uploadpath . 'journals/' . $coverpage)) ? '<div class="jCoverPage"><img src="' . $imageurl . 'journals/' . $coverpage . '" alt="' . $journal . '" class="left" /></div>' : '';
		$doi = $doi ? '<p><b>DOI:</b> <a href="https://doi.org/'.$doi.'" target="_blank">https://doi.org/'.$doi.'</a></p>' : '';
		$html .= <<<EOJ
		<div class="col s12 m12 l6">
			<div class="jWrapper">
				{$coverpage}
				<div class="jInfo">
					<b>{$journal}</b>
					<b>{$issn}</b>
					{$doi}
					<p><b>Email:</b> {$journalemail}</p>
					<p><b>Website:</b> <a href="{$domain}" target="_blank" class="red-text" rel="dofollow">{$domain}</a></p>
				</div>
			</div>
		</div>
EOJ;
	endwhile;
	$stmt->close();
	return $html;
}
function slugify($text, $divider = '-')
{
	$text = preg_replace('~[^\pL\d]+~u', $divider, $text);
	$text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
	$text = preg_replace('~[^-\w]+~', '', $text);
	$text = trim($text, $divider);
	$text = preg_replace('~-+~', $divider, $text);
	$text = strtolower($text);

	return $text;
}
$stmt = $mysqli->prepare("SELECT TRIM(subject) FROM journals WHERE subject != '' AND status = 'enabled' GROUP BY TRIM(subject) ORDER BY subject ASC") or die('An error occurred. Please try after some time.');
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows() > 0) :
	$stmt->bind_result($subject);
	while ($stmt->fetch()) :
		echo '<a class="journalsHead indigo" href="' . $baseurl . 'journallist#' . slugify($subject) . '" id="' . slugify($subject) . '">' . $subject . '</a><br clear="all">';
		echo '<div class="row journalsBody">' . journal($subject) . '</div>';
	endwhile;
endif;
$stmt->close();

// $journalstatus = 'enabled';
// function journal($subject){
// 	global $mysqli, $imageurl, $uploadpath, $journalstatus;$html = '';
// 	$stmt = $mysqli->prepare("SELECT journal, journalemail, domain, coverpage FROM journals WHERE (subject = ? AND status = ?) ORDER BY journal ASC") or die('An error occurred. Please try after some time.');
// 	$stmt->bind_param('ss', $subject, $journalstatus);
// 	$stmt->execute();
// 	$stmt->store_result();
// 	$stmt->bind_result($journal, $journalemail, $domain, $coverpage);
// 	while($stmt->fetch()):
// 		$coverpage = ($coverpage && file_exists($uploadpath.'journals/'.$coverpage)) ? '<img src="'.$imageurl.'journals/'.$coverpage.'" alt="'.$journal.'" class="left eng-cover-img" />' : '';
// 		if($coverpage):
// $html .= <<<EOJ
// 			<div class="col s12 m12 l6">
// 				<table border="0" cellpadding="0" cellspacing="0" class="blue-grey lighten-5">
// 					<tr>
// 						<td>{$coverpage}</td>
// 						<td>
// 							<h6>{$journal}</h6>
// 							<b>Email: {$journalemail}</b>
// 							<p>Website: <a href="{$domain}" target="_blank" class="red-text">{$domain}</a></p>
// 						</td>
// 					</tr>
// 				</table>
// 			</div>
// EOJ;
// 		endif;
// 	endwhile;
// 	$stmt->close();
// 	return $html;
// }
// $stmt = $mysqli->prepare("SELECT TRIM(subject) FROM journals WHERE status = ? GROUP BY TRIM(subject) ORDER BY subject ASC") or die('An error occurred. Please try after some time.');
// $stmt->bind_param('s', $journalstatus);
// $stmt->execute();
// $stmt->store_result();
// if($stmt->num_rows() > 0):
// 	$stmt->bind_result($subject);
// 	while($stmt->fetch()):
// 		if($subject):
// 			echo '<div class="fluid indigo z-depth-1 white-text journallisthead">'.$subject.'</div><br clear="all">';
// 		endif;
// 		echo '<div class="row journallistbody">'.journal($subject).'</div>';
// 	endwhile;
// endif;
// $stmt->close();
require_once('footer.php');
?>