<?php

$TEAM_ACCESS = 'csp_team_user_access';
$TEAM_WORK = 'csp_team_work';
$CSP_EDITORS = 'csp_editors';

$sidebar_getAccess  = $conn->query("SELECT w.work_name,w.work_code,w.team_id FROM $TEAM_ACCESS as ac LEFT JOIN $TEAM_WORK as w on w.work_id=ac.work_id WHERE ac.editor_id='$editor_id' and w.status='1' and w.parent_id IS NULL order by w.display_order");

$checkPermissions = $conn->query("SELECT w.work_code FROM $TEAM_ACCESS as ac LEFT JOIN $TEAM_WORK as w on w.work_id=ac.work_id WHERE ac.editor_id='$editor_id'");
//$allPages = $checkPermissions->fetch_all(MYSQLI_ASSOC);
$pageArray = array();
//print_r($allPages);
while ($sideP = $checkPermissions->fetch_assoc()) {
	$pageArray[] = $sideP['work_code'];
}



?>

<div class="page-sidebar sidebar">
	<div class="page-sidebar-inner slimscroll">
		<div class="sidebar-header">
			<div class="sidebar-profile">
				<a href="javascript:void(0);" id="profile-menu-link">
					<div class="sidebar-profile-image">
						<img src="assets/images/editor.png" class="img-circle img-responsive" alt="">
					</div>
					<div class="sidebar-profile-details">
						<span><br><small><?php echo $editor_name; ?></small></span>
					</div>
				</a>
			</div>
		</div>
		<ul class="menu accordion-menu">
			<li id="mainB"><a href="dashboard" class="waves-effect waves-button"><span class="menu-icon glyphicon glyphicon-home"></span>
					<p>Dashboard</p>
				</a></li>
			<?php if ($editor_role != 5) { ?>
				<li class="droplink"><a href="#" class="waves-effect waves-button"><span class="menu-icon glyphicon glyphicon-book"></span>
						<p>Questions</p><span class="arrow"></span>
					</a>
					<ul class="sub-menu">
						<?php $im = 1;
						foreach ($sidebar_getAccess as $defineAccess) {
							if ($defineAccess['team_id'] == '3') {
						?>
								<li class="activeThis" id="activeThisQ<?php echo $im; ?>"><a href="<?php echo $defineAccess['work_code']; ?>"><?php echo $defineAccess['work_name']; ?></a></li>
						<?php }
							$im++;
						} ?>
					</ul>
				</li>
			<?php } else if ($editor_role == 5) { ?>
				<li class="droplink"><a href="#" class="waves-effect waves-button"><span class="menu-icon glyphicon glyphicon-book"></span>
						<p>My Masters</p><span class="arrow"></span>
					</a>
					<ul class="sub-menu">
						<?php $im = 1;
						while ($defineAccess = $sidebar_getAccess->fetch_assoc()) { ?>
							<li class="activeThis" id="activeThisQ<?php echo $im; ?>"><a href="<?php echo $defineAccess['work_code']; ?>"><?php echo $defineAccess['work_name']; ?></a></li>
						<?php $im++;
						} ?>
					</ul>
				</li>
			<?php } ?>
			<?php if ($editor_role != 5) { ?>
			<li class="droplink"><a href="#" class="waves-effect waves-button"><span class="menu-icon glyphicon glyphicon-cog"></span>
					<p>Users</p><span class="arrow"></span>
				</a>
				<ul class="sub-menu">
					<?php $im = 1;
					foreach ($sidebar_getAccess as $useracess) {
						if ($useracess['team_id'] == '1') {
					?>
							<li class="activeThis" id="activeThisQ<?php echo $im; ?>"><a href="<?php echo $useracess['work_code']; ?>"><?php echo $useracess['work_name']; ?></a></li>
					<?php }
						$im++;
					} ?>
				</ul>
			</li>
			<?php } ?>
		</ul>
	</div><!-- Page Sidebar Inner -->
</div><!-- Page Sibar -->