<?php

include 'load.php';

if(isset($_GET['meters'])){
	
	$meters=mysqli_real_escape_string($conn,$_GET['meters']);
	$status=mysqli_real_escape_string($conn,$_GET['status']);

	mysqli_query($conn,"UPDATE mobiledailymeters SET status='$status' WHERE dmid='$meters'");
	header("refresh:2;dailymeterslist.php"); // redirects image view page after 5 seconds
	
}

?>

<!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>Daily Meters | 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>Daily Meters List</h4>
<h6>Manage your Daily Meters</h6>
</div>
<div class="ptype-btn">
<a href="adddailymeters.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" alt="img" class="me-1">Add New Daily Meters</a>
</div>
</div>

<div class="card">
<div class="card-body">
<div class="table-top">
<div class="search-set">
<div class="search-path">
<a class="btn btn-filter" id="filter_search">
<img src="assets/img/icons/filter.svg" alt="img">
<span><img src="assets/img/icons/closes.svg" alt="img"></span>
</a>
</div>
<div class="search-input">
<a class="btn btn-searchset"><img src="assets/img/icons/search-white.svg" alt="img"></a>
</div>
</div>
<div class="wordset">
<ul>
<li>
<a data-bs-toggle="tooltip" data-bs-placement="top" title="pdf"><img src="assets/img/icons/pdf.svg" alt="img"></a>
</li>
<li>
<a data-bs-toggle="tooltip" data-bs-placement="top" title="excel"><img src="assets/img/icons/excel.svg" alt="img"></a>
</li>
<li>
<a data-bs-toggle="tooltip" data-bs-placement="top" title="print"><img src="assets/img/icons/printer.svg" alt="img"></a>
</li>
</ul>
</div>
</div>

<div class="table-responsive">
<table class="table  datanew">
<thead>
<tr>
<th>ID#</th>
<th>Actions</th>
<th>Status</th>
<th>Employee</th>
<th>Meter Photo</th>
<th>Mileages</th>
<th>Type</th>
<th>Date</th>
</tr>
</thead>
<tbody> 
<?php

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

$stmt->execute();

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

{

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

{

extract($row);

?>
<tr>
<td>#<?php echo $row['dmid']; ?></td>
<td>
<a href="editdailymeters.php?dmid=<?php echo $row["dmid"]; ?>" 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="deletedailymeters.php?dmid=<?php echo $row["dmid"]; ?>" 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>
<a href="dailymeterslist.php?meters=<?php echo $row["dmid"]; ?>&status=1" class="btn btn-block btn-outline-info active btn-sm text-white" title="Active Meters" onClick="JavaScript:return confirm('Are your sure change this Meters Active status?');"><i class="fa fa-check-circle" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-check-circle" aria-label="fa fa-check-circle"></i></a>
<a href="dailymeterslist.php?meters=<?php echo $row["dmid"]; ?>&status=0" class="btn btn-block btn-outline-warning active btn-sm text-white" title="Deactive Meters" onClick="JavaScript:return confirm('Are your sure change this Meters Deactive status?');"><i class="fa fa-window-close" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-window-close" aria-label="fa fa-window-close"></i></a>
</td>
<td>
										<?php 
						
														if($row['status'] == "1"){

														echo '<span class="badge bg-success"><i class="bx bxs-circle me-1"></i>Active</span>';

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

														echo '<span class="badge bg-danger"><i class="bx bxs-circle me-1"></i>Deactive</span>';

														}
						
												
										?>
										</td>
										<td><?php

												$id = $row['employee'];  

												$query = $DB_con->prepare('SELECT emname,emphonenumber FROM mobileemployee WHERE emid='.$id);

												$query->execute();

												$result = $query->fetch();

												echo $result['emname']." - ".$result['emphonenumber'];

												?></td>
										<td><?php if($row['image']==""){$pro_img="assets/img/empty.png";}else{$pro_img="images/dailymeters/".$row['image'];} ?><img src="<?php echo $pro_img; ?>" class="pro_pick" style="width:80px;"></td>
										<td><?php echo $row['mileages']; ?></td>
										<td>
										<?php 
						
										if($row['type'] == "Start"){

										echo '<span class="badge bg-primary"><i class="bx bxs-circle me-1"></i>Start</span>';

									    }else if($row['type'] == "End"){

										echo '<span class="badge bg-primary"><i class="bx bxs-circle me-1"></i>End</span>';

									    }
		
										?>
										</td>
										<td><?php echo $row['add_date']; ?></td>

</tr>
<?php 
} 
}
?>
</tbody>
</table>
</div>
</div>
</div>

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


<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/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>