<?php
session_start();
include 'actions/dbconnection.php';

$sql = "SELECT * FROM appointments where sno=".$_GET['sno']." ";
$result = $conn->query($sql);
$arows = mysqli_num_rows($result);

$sql1 = "select * from team";
$result1 = $conn->query($sql1);

$uno=time().rand(1,9);

?>

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

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="" />
    <meta name="keywords" content="" />
	<title>Wisibles</title>
    <link rel="icon" href="images/fav-icon.png" type="image/png" sizes="16x16">
    
    <link rel="stylesheet" href="css/main.min.css">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="css/color.css">
    <link rel="stylesheet" href="css/responsive.css">
	<link href="plugins/apex/apexcharts.css" rel="stylesheet" type="text/css">

</head>
<body>
<div class="page-loader" id="page-loader">
	 <div class="lds-ellipsis"><div></div><div></div><div></div><div></div></div>
	 <span>Loading...</span>
</div><!-- page loader -->
<div class="theme-layout">
	
	<?php include 'header.php'; ?>
	<div class="top-sub-bar">
		<div class="container-fluid">
			<div class="row">
				<div class="col-lg-6 col-md-6 col-sm-6">
					<div class="menu-btn">
						<i class="">
<svg id="menu-btn" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-menu"><line x1="3" y1="12" x2="21" y2="12"></line><line x1="3" y1="6" x2="21" y2="6"></line><line x1="3" y1="18" x2="21" y2="18"></line></svg></i>
					</div>
					
				</div>
				<div class="col-lg-6 col-md-6 col-sm-6">
					<ul class="breadcrumb d-none d-sm-block">
						<li><a href="#" title="">Home</a></li>
						<li><a href="#" title="">Lead Management</a></li>
					</ul>
				</div>
			</div>
		</div>	
	</div><!-- top sub bar -->
	<?php include 'left_menu.php'; ?>
	

	<div class="container-fluid">
		<div class="row">
			<div class="col-lg-12">
				<div class="panel-content">
					<h4 class="main-title">appointments <i class="icofont-pen-alt-1"></i></h4>
					<?php
		   
				$count=0;
					while($row = $result->fetch_assoc())
					{   
				$time = $row['time']; 
					$time = strtotime($time);
?>	
						<form action="actions/edit_astatus_exec.php" method="post" enctype="multipart/form-data">
						<div class="row merged20 mb-4">
						<div class="col-lg-4">
							<div class="d-widget text-center">
								<div class="user-avatar-edit">
									<figure><img src="images/resources/user-mockupbg.jpg" alt=""></figure>
									
								</div>
							</div>	
						</div>
                            
						<div class="col-lg-8">
						
							
								 	<div class="streamline ">
										
<div class="col-lg-11">
				<div class="panel-content1 ">
				
					<div class="row merged20 mb-4">
						
						<div class="main-wraper1 ">
                            <div class="tab-content" id="components-nav">
                                <!-- settings -->
                                <div class="tab-pane active fade show" id="account">
									<div class="uk-width">
										<div class="setting-card">
											
											<h4>Appointment Status</h4>
											
										<fieldset class="row merged-10">
<!--
												<input type="hidden" class="uk-input" placeholder="uno" name="status" value="Active">
												<input type="hidden"  class="uk-input" placeholder="pay_status" name="pay_status" value="Active"> 
-->
                                                    <div class="mb-4 col-lg-12">
                                                        <label>Appointment Number</label>
														<input class="uk-input" type="text" placeholder="S NO" name="sno" value="<?php echo $row['sno']?>" required readonly>
													</div>

													<div class="mb-4 col-lg-6">
                                                        <label>Appointment Status</label>
                                                        <select name="status" required style="width:100%">
                                                            <option value="">Appointment Status</option>
                                                            <option value="Open">Open</option>
                                                            <option value="Follow Up">Follow Up</option>
                                                            <option value="Close">Close</option>
                                                            <option value="Pending">Pending</option>
                                                        </select>
													</div>
													
													<div class="mb-0 col-lg-12">
													<br>
														<button type="submit" class="button primary circle">Submit status</button>
													</div>	
												</fieldset>
										</div>
									</div>
                                </div>
                                
                            </div>
                        </div>
					</div>	
				</div>
			</div>

									
									</div>	
								
							
						</div>
					</div>
                    </form>
                    <?php } ?>	
				</div>
			</div>
		</div>
	</div>
	
	<!-- side slide message & popup -->
</div>
	
	<script src="js/main.min.js"></script>
	<script src="js/vivus.min.js"></script>
	<script src="js/script.js"></script>
	
	<script src="plugins/apex/apexcharts.min.js"></script>
	<script src="js/graphs-scripts.js"></script>

	

</body>	

</html>