<?php
include "globalVars.php";

if ($adminID == 1 || $adminID == 2) {
} else {
	header("Location: $ADurl");
}

if (!isset($_SERVER['HTTP_X_PJAX'])) {
	include "header.php";
}

$linkURL		= "userManagementLogDetails.html";
$thisDate		= "";
$dateCreated	= "";

if (isset($_POST["viewAdminID"])) {
	$adminUserID	= $_POST["viewAdminID"];
} else {
	$adminUserID	= $_GET["vA"];

	if (isset($_GET["date"])) {
		$thisDate		= $_GET["date"];

		if (trim($thisDate) == "") {
			$dateCreated	= "";
		} else {
			if (strpos($thisDate, "/")) {
				list($thisDay, $thisMonth, $thisYear)	= explode("/", $thisDate);
				$dateCreated	= $thisYear ."-". $thisMonth ."-". $thisDay;
			} else {
				$dateCreated	= $thisDate;
			}
		}
	} else {
		$dateCreated	= "";
	}
}
if ($adminUserID == 0) {
	$adminUserName	= "All Admin Users";
	$SQLsearch		= "id > '0'";
} else {
	$adminUsersQuery = mysqli_query($conn, "SELECT adminName FROM admin WHERE id = '$adminUserID'") or die (mysqli_error($conn));
	while ($aUQ = mysqli_fetch_array($adminUsersQuery)) {
		$adminUserName	= $aUQ["adminName"];
	}
	$SQLsearch		= "adminID = '$adminUserID'";
}

if (!isset($_SERVER['HTTP_X_PJAX'])) {
	?>

	<h2>Admin User Activity Log: <?php echo $adminUserName ?></h2>

	<div id="aGroupSearch">
		<div class="aGroupTitle">Select a Date:</div>
		<div class="pFormInput">
			<input type="text" id="dateSearch">
		</div>
		<a id="clearDate">Clear</a>
	</div>

	<div id="userLog" data-f="<?php echo $adminUserID ?>">
	<?php
}
	$SQLquery = "SELECT * FROM userActions WHERE $SQLsearch";

	if (trim($thisDate) != "") {
		$SQLquery .= " AND (dateCreated LIKE '$dateCreated %%')";
	}

	if (isset($_GET["page"])) {
		if ($_GET['page'] == '' || !$_GET['page']) {
			$page	= 1;
		} else {
			$page	= $_GET['page'];
		}
	} else {
		$page	= 1;
	}
					
	$prev		= ($page - 1);
	$next		= ($page + 1);
	$maxResults	= 20;
	$from		= (($page * $maxResults) - $maxResults);
//	echo $SQLquery;
	$logQueryResults	= mysqli_query($conn, "$SQLquery") or die(mysqli_error($conn));
	$totalResults		= mysqli_num_rows($logQueryResults);
	$totalPages			= ceil($totalResults / $maxResults);

	$pagination	= ''; 
	if ($totalPages >= 2) {
		// CREATE A PREVIOUS LINK IF THE PAGE IS GREATER THAN ONE
		if($page > 1) {
			$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='. $prev .'" class="prevLink" title="Previous"><i class="fas fa-angle-left"></i></a>';
		}
		// LOOP THROUGH THE TOTAL PAGES AND CREATE THE CORRECT LINKS
		// THIS SCRIPT WILL SHORTEN THE NUMBER OF LINKS TO DISPLAY IF THERE ARE MORE THAN 10 PAGES
		for($i = 1; $i <= $totalPages; $i++) {
			if($i == $page) {
				$pagination .= '<span class="currentPage">'.$i.'</span>'; 
			} else {
				if ($totalPages > 6) {
					if ($i == 1) {
						if ($page > 3) {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobileSplitRight ">'.$i.'</a>';
						} else {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobilePage">'.$i.'</a>';
						}
					} elseif ($i == $totalPages) {
						if ($page >= ($totalPages - 2)) {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobilePage">'.$i.'</a>';
						} else {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobileSplitLeft">'.$i.'</a>';
						}
					} elseif (($i > ($page - 2)) && ($i < ($page + 2))) {
						$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobilePage">'.$i.'</a>';
					} else {
					}
				} else {
					$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="mobilePage">'.$i.'</a>';
				}
				if ($totalPages > 10) {
					if ($i == 1) {
						if ($page > 6) {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="pageSplitRight">'.$i.'</a>';
						} else {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="fullPage">'.$i.'</a>';
						}
					} elseif ($i == $totalPages) {
						if ($page >= ($totalPages - 5)) {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="fullPage">'.$i.'</a>';
						} else {
							$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="pageSplitLeft">'.$i.'</a>';
						}
					} elseif (($i > ($page - 5)) && ($i < ($page + 5))) {
						$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="fullPage">'.$i.'</a>';
					} else {
					}
				} else {
					$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$i.'" class="fullPage">'.$i.'</a>';
				} 
			}
		}
		// CREATE A NEXT LINK IF THERE ARE MORE PAGES
		if($page < $totalPages) {
			$pagination .= '<a href="'. $ADurl . $linkURL .'?vA='. $adminUserID .'&date='. $dateCreated .'&page='.$next.'" class="nextLink" title="Next"><i class="fas fa-angle-right"></i></a>';
		}
	} else {
		$pagination = "&nbsp;";
	}
	if ($totalPages >= 2) {
		?>
		<div class="pagination">
			<div class="pageNumbers">
				<?php echo $pagination ?>
			</div>
		</div>
		<?php
	}
//	echo "$SQLquery ORDER BY id DESC LIMIT $from, $maxResults<br>";
	$logDisplayQuery = mysqli_query($conn, "$SQLquery ORDER BY id DESC LIMIT $from, $maxResults") or die (mysqli_error($conn));
	if (mysqli_num_rows($logDisplayQuery) == 0) {

		echo "<p>No logs to display for this user and date.</p>";

	} else {
		while ($r = mysqli_fetch_array($logDisplayQuery)) {
			$logDate	= date("H:i:s<br>d/m/Y", strtotime($r["dateCreated"]));
			$logAdminID	= $r["adminID"];
			$logPage	= $r["pageTracking"];
			$logDBase	= $r["databaseUpdated"];
			$logMessage	= $r["updateDetails"];

			$logScriptType	= substr($logPage, -4);

			$adminUsersQuery = mysqli_query($conn, "SELECT * FROM admin WHERE id = '$logAdminID'") or die (mysqli_error($conn));
			while ($aUQ = mysqli_fetch_array($adminUsersQuery)) {
				$viewAdminName	= $aUQ["adminName"];
				$viewAdminEmail	= $aUQ["adminEmail"];
			}
			?>
		<div class="logAction">
			<div class="logRow">
				<div class="logHalf logDate">
					<?php echo $logDate ?>
				</div>
				<div class="logHalf logUser">
					User: <?php echo $viewAdminName ?><br><a href="mailto:<?php echo $viewAdminEmail ?>"><?php echo $viewAdminEmail ?></a>
				</div>
			</div>
			<div class="logRow">
				<div class="logHalf">
				<?php
				if ($logScriptType == ".php") {
					?>
					Script: <?php echo $logPage ?>
					<?php
				} else {
					?>
					Page: <a href="<?php echo $url . $logPage ?>" target="_blank"><?php echo $logPage ?></a>
					<?php
				}
				?>
				</div>
				<?php
				if (trim($logDBase) != "") {
					?>
				<div class="logHalf">
					Database Update: <?php echo $logDBase ?>
				</div>
					<?php
				}
				?>
			</div>
			<div class="logMsg">
				<p><strong>Event:</strong><br>
				<?php echo $logMessage ?></p>
			</div>
		</div>
			<?php
		}
		if ($totalPages >= 2) {
			?>
			<div class="pagination">
				<div class="pageNumbers">
					<?php echo $pagination ?>
				</div>
			</div>
			<?php
		}
	}
	?>

<?php
if (!isset($_SERVER['HTTP_X_PJAX'])) {
	?>
	</div>
	<div id="searchLoadingBG">
		<img src="images/searchLoading.gif" width="128" alt="Loading, Please wait..." title="Loading, Please wait...">
	</div>

	<?php
	include "footer.php";
}
?>