<?php

include 'load.php';

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

	mysqli_query($conn,"UPDATE mobileasmdailyroute SET status='$status' WHERE asid='$route'");
	header("refresh:2;dailyasmroutelist.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 - Eat More Resturant   | Pos & Invetory System | Dashboard

">
<meta name="keywords" content="Eat More Resturant   | Pos & Invetory System | Dashboard

">
<meta name="author" content="Eat More Resturant   | Pos & Invetory System | Dashboard

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

<title>ASM Route | Eat More Resturant   | 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>ASM Route List</h4>
<h6>Manage your ASM Route</h6>
</div>
<div class="pcredit-btn">
<a href="adddailyasmroute.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" alt="img" class="me-1">Add New ASM Route</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>Route</th>
<th>Route Date</th>
<th>ASM</th>
<th>Date</th>
</tr>
</thead>
<tbody> 
<?php

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

$stmt->execute();

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

{

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

{

extract($row);

?>
<tr>
<td>#<?php echo $row['asid']; ?></td>
<td>
<a href="editdailyasmroute.php?asid=<?php echo $row["asid"]; ?>" 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="deletedailyasmroute.php?asid=<?php echo $row["asid"]; ?>" 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="dailyasmroutelist.php?route=<?php echo $row["asid"]; ?>&status=1" class="btn btn-block btn-outline-info active btn-sm text-white" title="Active Route" onClick="JavaScript:return confirm('Are your sure change this Route 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="dailyasmroutelist.php?route=<?php echo $row["asid"]; ?>&status=0" class="btn btn-block btn-outline-warning active btn-sm text-white" title="Deactive Route" onClick="JavaScript:return confirm('Are your sure change this Route 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['route'];  

												$query = $DB_con->prepare('SELECT routename FROM mobileroute WHERE rtid='.$id);

												$query->execute();

												$result = $query->fetch();

												echo $result['routename'];

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

												$id = $row['asm'];  

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

												$query->execute();

												$result = $query->fetch();

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

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