<?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>Appointment | 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>Appointment List</h4>
<h6>Mandoctor your Appointment</h6>
</div>
<div class="pdoctor-btn">
<a href="addappointment.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" alt="img" class="me-1">Add New Appointment</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>Status</th>
<th>Appointment Number</th>
<th>Patient</th>
<th>Appointment Date</th>
<th>Appointment Time</th>
<th>Species/Breed</th>
<th>Services</th>
<th>Doctor</th>
<th>Type Of Pets</th>
<th>Reason</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody> 
<?php

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

										$stmt->execute();

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

										{

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

										{

										extract($row);

								?>
<tr>
<td>#<?php echo $row['apid']; ?></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 echo $row['appno']; ?></td>
										<td><?php

											  $id = $row['patient'];

											  $query = $DB_con->prepare('SELECT ptno,ptname,phonenumber,address FROM mobilepatient WHERE paid='.$id);

											  $query->execute();

											  $result = $query->fetch();

											  echo $result['ptno']."<br>".$result['ptname']."<br>".$result['phonenumber']."-".$result['address'];

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

											  $id = $row['species'];

											  $query = $DB_con->prepare('SELECT spname FROM mobilespecies WHERE spid='.$id);

											  $query->execute();

											  $result = $query->fetch();

											  echo $result['spname'];

											  ?> - <?php

											  $id = $row['breed'];

											  $query = $DB_con->prepare('SELECT brname FROM mobilebreed WHERE brid='.$id);

											  $query->execute();

											  $result = $query->fetch();

											  echo $result['brname'];

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

											  $id = $row['services'];

											  $query = $DB_con->prepare('SELECT sname FROM mobileservices WHERE seid='.$id);

											  $query->execute();

											  $result = $query->fetch();

											  echo $result['sname'];

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

											  $id = $row['doctor'];

											  $query = $DB_con->prepare('SELECT doname,position FROM mobiledoctors WHERE doid='.$id);

											  $query->execute();

											  $result = $query->fetch();

											  echo $result['doname'];

											  ?>
											  <br>
											  <?php

											  $id2 = $result['position'];

											  $query2 = $DB_con->prepare('SELECT poid,pname FROM mobileposition WHERE poid='.$id2);

											  $query2->execute();

											  $result2 = $query2->fetch();

											  echo $result2['pname'];

											  ?>
											  </td>
										<td><?php echo $row['typeofpets']; ?></td>
										<td><?php echo $row['message']; ?></td>
										<td><?php echo $row['add_date']; ?></td>
<td>
<a href="editappointment.php?apid=<?php echo $row["apid"]; ?>" 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="deleteappointment.php?apid=<?php echo $row["apid"]; ?>" 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="appointmentlist.php?active=<?php echo $row["apid"]; ?>" class="btn btn-block btn-outline-info active btn-sm text-white"><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="appointmentlist.php?deactive=<?php echo $row["apid"]; ?>" class="btn btn-block btn-outline-warning active btn-sm text-white"><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>
<a href="appointmentreciept.php?appno=<?php echo $row["appno"]; ?>" class="btn btn-block btn-outline-dark active btn-sm text-white"><i class="fa fa-clone" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-clone" aria-label="fa fa-clone"></i></a>
</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>