<?php
if($opt1 && ($opt1 === 'add' OR $opt1 === 'edit')):
	if($opt1 === 'edit' && $opt2):
		$stmt = $mysqli->prepare("SELECT $firstcol, journal, issn, domain, email, sorting, status FROM $table WHERE $firstcol = ? LIMIT 1") or die($mysqli->error);
		$stmt->bind_param('i', $opt2);
		$stmt->execute();
		$stmt->store_result();
		$count_rows = $stmt->num_rows();
		$stmt->bind_result($id, $journal, $issn, $domain, $email, $sorting, $status);
		$stmt->fetch();
		$stmt->close();
		if($count_rows !== 1):
			die('Invalid data selection.');
		endif;
	else:
		$id = '';$journal = '';$issn = '';$domain = '';$email = '';$sorting = '';$status = 'enabled';
	endif;

	$status = $status === 'enabled' ? 'checked' : '';

echo <<<EOJ
	<input type="hidden" name="dataid" value="{$id}" readonly />
	<div class="head white">
		<button type="button" class="waves-effect btn-flat" onclick="history.back()"><i class="material-icons">keyboard_return</i></button>
		<button type="submit" class="waves-effect btn-flat blue accent-3">submit</button>
	</div>
	<div class="body white">
		<div class="row">
			<div class="col s12 m12 l12">
				<label for="journal">journal<b class="red-text right">*</b></label>
				<input type="text" name="journal" value="{$journal}" id="journal" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m4 l4">
				<label for="issn">issn</label>
				<input type="text" name="issn" value="{$issn}" id="issn" />
			</div>
			<div class="col s12 m4 l4">
				<label for="domain">domain<b class="red-text right">*</b></label>
				<input type="text" name="domain" value="{$domain}" id="domain" />
			</div>
			<div class="col s12 m4 l4">
				<label for="email">email<b class="red-text right">*</b></label>
				<input type="text" name="email" value="{$email}" id="email" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m6 l6">
				<div class="file-field" style="margin-top:16px">
					<div class="btn btn-flat grey lighten-1 white-text">
						<span>cover page</span>
						<input type="file" name="coverpage" />
					</div>
					<div class="file-path-wrapper">
						<input type="text" placeholder="Only JPG, JPEG and PNG allowed." class="file-path" />
					</div>
				</div>
			</div>
			<div class="col s12 m6 l6">
				<label for="sorting">sorting<b class="red-text right">*</b></label>
				<input type="text" name="sorting" value="{$sorting}" id="sorting" class="digit" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m12 l12">
				<label class="chklab"><input type="checkbox" name="status" value="enabled" {$status} />status</label>
			</div>
		</div>
	</div>
EOJ;
else:
	$stmt = $mysqli->prepare("SELECT * FROM $table") or die($mysqli->error);
	$stmt->execute();
	$stmt->store_result();
	$total_rows = $stmt->num_rows();
	$stmt->close();
echo <<<EOJ
	<div class="head white">
		<button type="button" class="waves-effect btn-flat green" onclick="cURL('add')">add new</button>
		<button type="submit" class="waves-effect btn-flat h" onclick="sOPT('enabled')">enable</button>
		<button type="submit" class="waves-effect btn-flat h" onclick="sOPT('disabled')">disable</button>
		<button type="submit" class="waves-effect btn-flat h" onclick="sOPT('delete', 'Do you really want to delete?')"><i class="material-icons">delete</i></button>
		<div class="pagination right"><b class="left">Total Rows : {$total_rows}</b></div>
	</div>
	<table class="table">
		<thead>
		<tr>
		<th class="xs center-align"><input type="checkbox" name="checkall" id="checkall" value="" /></th>
		<th class="xs center-align">s. no.</th>
		<th class="sm center-align">image</th>
		<th>journal</th>
		<th>issn</th>
		<th>domain</th>
		<th>email</th>
		<th class="sm center-align">status</th>
		<th class="sm center-align">sorting</th>
		<th class="lg right-align">creation</th>
		<th class="sm center-align">action</th>
		</tr>
		</thead>
		<tbody>
EOJ;
		$stmt = $mysqli->prepare("SELECT $firstcol, journal, issn, domain, email, coverpage, sorting, status, creation FROM $table ORDER BY $firstcol DESC") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($id, $journal, $issn, $domain, $email, $coverpage, $sorting, $status, $creation);
			while($stmt->fetch()):
				$snum = $snum + 1;
				$coverpage = $coverpage && file_exists('../images/peer-reviewed-journals/'.$coverpage) ? $baseurl.'images/peer-reviewed-journals/'.$coverpage : $imageurl.'avatar_2x.png';
				$statuscolor = $status === 'enabled' ? 'green-text' : 'red-text';
				$option = $status === 'enabled' ? 'disabled' : 'enabled';
echo <<<EOJ
				<tr>
				<td class="center-align"><input type="checkbox" name="dataid[]" value="{$id}" class="checkbox" /></td>
				<td class="center-align">{$snum}</td>
				<td class="center-align"><img src="{$coverpage}" alt="{$journal}" style="max-width:50px" /></td>
				<td>{$journal}</td>
				<td>{$issn}</td>
				<td>{$domain}</td>
				<td>{$email}</td>
				<td class="center-align"><button type="submit" class="link {$statuscolor}" onclick="sOPT('{$option}', '', this);">{$status}</button></td>
				<td class="center-align">{$sorting}</td>
				<td class="right-align">{$fn->dateformat($creation)}</td>
				<td class="center-align"><button type="button" class="link blue-text text-accent-3" onclick="cURL('edit/{$id}')">edit</button></td>
				</tr>
EOJ;
			endwhile;
			$stmt->close();
		else:
			echo '<tr><td colspan="11" class="center-align">MySQL returned an empty result set (i.e. zero rows).</td></tr>';
		endif;
	echo '</tbody>';
	echo '</table>';
endif;
?>