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

function boards($category)
{
	global $mysqli, $imageurl, $uploadpath, $uploadurl, $editorspicture, $boardstatus;$html = '';

	$stmt = $mysqli->prepare("SELECT name, degree, post, content, email, emailshow, phone, phoneshow, picture, pictureshow FROM editors WHERE (category = ? AND status = ?) ORDER BY sortnumber ASC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('ss', $category, $boardstatus);
	$stmt->execute();
	$stmt->store_result();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($name, $degree, $post, $content, $email, $emailshow, $phone, $phoneshow, $picture, $pictureshow);
		while($stmt->fetch()):
			$name = html_entity_decode($name);
			$degree = $degree ? ' ('.html_entity_decode($degree).')' : '';
			$picture = ($picture && file_exists($uploadpath.'editors/'.$picture) && $pictureshow === 'Y') ? $uploadurl.'editors/'.$picture : $imageurl.'avatar_2x.png';
			$picture = $editorspicture === 'enabled' ?  '<div class="left"><img src="'.$picture.'" alt="'.$name.'" /></div>' : '';

			$html .= '<div class="body">';
			$html .= $picture;
			$html .= '<div class="left">';
			$html .= '<b>'.$name.'</b>'.$degree;
			$html .= '<br clear="all" />';
			$html .= $post ? html_entity_decode($post).'<br clear="all" />' : '';
			$html .= html_entity_decode($content).'<br clear="all" />';
			$html .= ($email && $emailshow === 'Y') ? '<b>Email:</b> '.$email.'<br clear="all" />' : '';
			$html .= ($phone && $phoneshow === 'Y') ? '<b>Phone:</b> '.$phone : '';
			$html .= '</div>';
			$html .= '</div>';
		endwhile;
	endif;
	$stmt->close();
	return $html.'<br clear="all"><br clear="all">';
}
$tab = pathinfo($_SERVER['REQUEST_URI'], PATHINFO_FILENAME);
if($tab && $tab === 'join'):
echo <<<EOJ
	<form action="{$baseurl}{$filename}" method="post" name="boardmemberapplicationform" class="grey lighten-3 form ajax" enctype="multipart/form-data">
		<input type="hidden" name="{$token_id}" value="{$token_value}" readonly />
		<input type="hidden" name="focus" value="{$en->encrypt('[JOIN_EDITORIAL_BOARD]')}" readonly />
	    <input type="hidden" name="zipcode" value="" readonly />
		<div class="progress grey lighten-2"><div class="indeterminate blue accent-3"></div></div>
		<div class="row">
			<div class="col s12 m6 l6">
				<label for="name">Name<span class="red-text right">*</span></label>
				<input type="text" name="name" id="name" />
			</div>
			<div class="col s12 m6 l6">
				<label for="email">Email<span class="red-text right">*</span></label>
				<input type="text" name="email" id="email" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m12 l12">
				<label for="phone">Phone<span class="red-text right">*</span></label>
				<input type="text" name="phone" id="phone" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m6 l6">
				<label for="degree">Degree<span class="red-text right">*</span></label>
				<input type="text" name="degree" id="degree" />
			</div>
			<div class="col s12 m6 l6">
				<label for="post">Current Position<span class="red-text right">*</span></label>
				<input type="text" name="post" id="post" />
			</div>
		</div>
		<div class="row">
			<div class="col s12 m12 l12">
				<label for="deptartment">Department & College<span class="red-text right">*</span></label>
				<textarea rows="5" cols="5" name="department" id="deptartment" class="materialize-textarea"></textarea>
			</div>
		</div>
		<div class="row">
			<div class="col s12 m6 l6">
				<label for="photo">Choose Photo<span class="red-text right">*</span></label>
				<div class="file-field left" style="width:100%">
					<div class="btn grey lighten-1 z-depth-0"><span>photo</span><input type="file" name="photo" id="photo" /></div>
					<div class="file-path-wrapper">
						<input type="text" name="photo" placeholder="Choose photo" class="file-path" />
					</div>
				</div>
			</div>
			<div class="col s12 m6 l6">
				<label for="resume">Choose Resume<span class="red-text right">*</span></label>
				<div class="file-field left" style="width:100%">
					<div class="btn grey lighten-1 z-depth-0"><span>resume</span><input type="file" name="resume" id="resume" /></div>
					<div class="file-path-wrapper">
						<input type="text" name="resume" placeholder="Choose resume" class="file-path" />
					</div>
				</div>
			</div>
		</div>
		{$recaptcha}
		<div class="row">
			<div class="col s12 m12 l12">
				<button type="submit" name="submit" class="waves-effect btn-flat blue accent-3 white-text right" disabled>submit</button>
			</div>
		</div>
	</form>
	<div class="smsg center-align"></div>
EOJ;
else:
	$boardstatus = 'enabled';
	$stmt = $mysqli->prepare("SELECT category FROM editors WHERE status = ? GROUP BY category ORDER BY catsortnumber ASC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('s', $boardstatus);
	$stmt->execute();
	$stmt->store_result();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($category);
		while($stmt->fetch()):
			echo '<div class="fluid boards">';
			echo '<div class="head">'.$category.'</div>';
			echo boards($category);
			echo '</div>';
		endwhile;
	else:
		echo '<div align="center"><img src="'.$imageurl.'coming-soon.png" alt="Comming Soon" style="float:none" /></div><br clear="all">';
	endif;
	$stmt->close();

echo <<<EOJ
<div align="center" class="fluid joinus"><a href="{$baseurl}board/join"><img src="{$imageurl}joinus.png" alt="Join Us" style="float:none" /></a></div>
EOJ;
endif;
require_once('footer.php');
?>