<?php
include 'load.php';
?>

<!DOCTYPE html>
<html lang="en">

<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
	<meta name="description" content="POS - Payroll | Pos & Invetory System | Dashboard

">
	<meta name="keywords" content="Payroll | Pos & Invetory System | Dashboard

">
	<meta name="author" content="Payroll | Pos & Invetory System | Dashboard

">
	<meta name="robots" content="noindex, nofollow">

	<title>Users | Payroll | Pos & Invetory System | Dashboard
</title>


	<?php
	require_once 'headercss.php';
	?>
</head>

<body>
	<div id="global-loader">
		<div class="whirly-loader"> </div>
	</div>

	<div class="main-wrapper">
		<?php
		require_once 'header.php';
		?>

		<?php
		require_once 'navbar.php';
		?>

		<div class="page-wrapper">
			<div class="content">
				<div class="page-header">
					<div class="page-title">
						<h4>User List</h4>
						<h6>Manage your User</h6>
					</div>
					<div class="page-btn">
						<a href="newuser.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" alt="img">Add User</a>
					</div>
				</div>

				<div class="card">
					<div class="card-body">
						<div class="table-top">
							<div class="search-set">

							</div>
							<div class="wordset">

							</div>
						</div>

						<div class="table-responsive">
							<table class="table datanew">
								<thead>
									<tr>
										<th>#ID</th>
										<th>Action</th>
										<th>Status</th>
										<th>Full Name</th>
										<th>Phone Number</th>
										<th>Address</th>
										<th>Email</th>
										<th>User Roll</th>
										<th>Branch</th>
										<th>Username</th>
										<th>Comission</th>
										<th>Basic Salary</th>
										<th>OT Rate</th>
										<th>Add Date</th>
									</tr>
								</thead>
								<tbody>
									<?php
									
									$count=0;

									$stmt = $DB_con->prepare('SELECT * FROM mobileusers ORDER BY user_id');

									$stmt->execute();

									if ($stmt->rowCount() > 0) {

									while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

									extract($row);
									
									$count++;

									?>
											<tr>
												<td><?php echo number_format($count,0); ?></td>
												<td>
												<a href="changepassword.php?user_id=<?php echo $row["user_id"]; ?>" class="btn btn-block btn-outline-dark active btn-sm text-white"><i class="fa fa-key" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-key" aria-label="fa fa-key"></i></a>
												<a href="newuseredit.php?user_id=<?php echo $row["user_id"]; ?>" class="btn btn-block btn-outline-primary active btn-sm text-white"><i class="fa fa-edit" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-edit" aria-label="fa fa-edit"></i></a>
												<a href="deleteuser.php?user_id=<?php echo $row["user_id"]; ?>" class="btn btn-block btn-outline-danger active btn-sm text-white"><i class="fa fa-trash" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-trash" aria-label="fa fa-trash"></i></a>
												</td>
												<td>
													<?php

													if ($row['status'] == "0") {

														echo '<a class="bg-lightred badges text-white">Deactive</a>';
													} else if ($row['status'] == "1") {

														echo '<a class="bg-lightgreen badges text-white">Active</a>';
													}

													?>
												</td>
												<td class="productimgname">
													<a class="product-img" href="productlist.php">
														<?php if ($row['image'] == "") {
															$pro_img = "assets/img/empty.png";
														} else {
															$pro_img = "images/admin/" . $row['image'];
														} ?><img src="<?php echo $pro_img; ?>" width="42" height="42" class="rounded-circle" alt="">
													</a>
													<span><?php echo $row['fullname']; ?></span>
												</td>
												<td><?php echo $row['phonenumber']; ?></td>
												<td><?php echo $row['address']; ?></td>
												<td><?php echo $row['user_email']; ?></td>
												<td>
													<?php
													$id = $row['admintype'];
													$groupinfo = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM user_groups WHERE group_id='$id'"));
													echo $groupinfo['group_name'];
													?>
												</td>
												<td>
													<?php

													$id = $row['user_id'];

													$query = $DB_con->prepare('SELECT branch_id FROM tbl_user_branch WHERE user_id='.$id);

													$query->execute();

													$result = $query->fetch();

													$id2 = $result['branch_id'];

													$query2 = $DB_con->prepare('SELECT branch_name FROM branch WHERE branch_id='.$id2);

													$query2->execute();

													$result2 = $query2->fetch();

													echo $result2['branch_name'];

													?>
												</td>
												<td><?php echo $row['user_name']; ?></td>
												<td><?php echo $row['ucomission']; ?></td>
												<td><?php echo $row['basicsalary']; ?></td>
												<td><?php echo $row['othourrate']; ?></td>
												<td><a class="bg-lightred badges text-white"><?php echo $row['joining_date']; ?></a></td>
											</tr>
									<?php
										}
									}
									?>
								</tbody>
							</table>
						</div>
					</div>
				</div>

			</div>
		</div>
	</div>

	<script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
	<script src="assets/js/jquery-3.6.0.min.js"></script>

	<script src="assets/js/feather.min.js"></script>

	<script src="assets/js/jquery.slimscroll.min.js"></script>

	<script src="assets/js/jquery.dataTables.min.js"></script>
	<script src="assets/js/dataTables.bootstrap4.min.js"></script>

	<script src="assets/js/bootstrap.bundle.min.js"></script>

	<script src="assets/plugins/select2/js/select2.min.js"></script>

	<script src="assets/js/moment.min.js"></script>
	<script src="assets/js/bootstrap-datetimepicker.min.js"></script>

	<script src="assets/plugins/sweetalert/sweetalert2.all.min.js"></script>
	<script src="assets/plugins/sweetalert/sweetalerts.min.js"></script>

	<script src="assets/js/script.js"></script>
</body>

</html>