invisio v2.0

<?php
session_start();
include("config.php");
include("innerpageheader.php");
$empids = $_SESSION['empids'];
$sql1 = $js->prepare('SELECT * FROM employees WHERE empid = :empids ');
$sql1->execute(array(':empids' => $empids));

while($row1 = $sql1->fetch(PDO::FETCH_ASSOC)) 
{
	$branch = $row1['empbranch'];
	$ename = $row1['empname'];
	$sql2 = $js->prepare('SELECT * FROM branches WHERE brid = :branch ');
	$sql2->execute(array(':branch' => $branch));
	while($row2 = $sql2->fetch(PDO::FETCH_ASSOC)) 
	{
		$brname = $row2['brname'];
	}	
}		
if($empids == 'admin')
{
	$resemp = $js->query('SELECT * FROM `employees` ORDER BY `id`');
	$resemp->execute();
}
else
{
	$resemp = $js->prepare('SELECT * FROM `employees` WHERE empid = :empids ORDER BY `id`');
	$resemp->execute(array(':empids' => $empids));	
}
								
?>
<section>
			<div class="content add-details">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<h5 align="center" style="margin-top:40px"> Search Marketing Visits Report</h6>
	   <hr>
	   <br>
                            
                            <form class="user" method="post" action="dailymarketingvisitsreport.php">
                                <div class="form-group row">
									
                                     <div class="col-sm-4 mb-3 mb-sm-0">
                                    	<input type="date" class="form-control form-control-user" id="fdate" name="fdate">
                                      </div>
                                      <div class="col-sm-4 mb-3 mb-sm-0">
                                    	<input type="date" class="form-control form-control-user" id="tdate" name="tdate">
                                      </div>
                                      <div class="col-sm-4 mb-sm-0">
                                      <select class="form-control" style="border-radius: 25px;border-color:#2368BF; height:50px;" id="empids" name="empids">
										<?php
											if($empids == 'admin')
											{
										?>
                                        	<option disabled>Select Employee</option>
                                            <option selected value="All">All</option>	
                                        <?php
											}
										?>										
											<?php
											
												while($rowt = $resemp->fetch(PDO::FETCH_ASSOC)) 
												{
													echo $empid = $rowt['empid'];
													echo $empname = $rowt['empname']; 
													echo "<option value='$empid'>$empname</option>";
												}
											?>
												
										</select>
                                       
                                    </div>
                                   
                                    
                                </div>
                               
                                <input type="submit" value="Generate Report" class="btn btn-primary btn-user btn-block">
                               
                                
                            </form>
                         
    </div>

<div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
                    <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
                <div class="modal-footer">
                    <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
                    <a class="btn btn-primary" href="login.html">Logout</a>
                </div>
            </div>
        </div>
    </div>

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

<script src="vendor/jquery-easing/jquery.easing.min.js"></script>

<script src="js/sb-admin-2.min.js"></script>

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

<script src="js/demo/datatables-demo.js"></script>