invisio v2.0

<?php
session_start();
include("config.php");
include("innerpageheader.php");

$empids = $_SESSION['empids'];

$results = $js->query('SELECT * FROM `heads` ORDER BY `name`');
$results->execute();
							
?>
<script type="text/javascript">
			
			function showsubheads(str) {
				if (str=="") {
					document.getElementById("r_sub").innerHTML="";
					return;
				}
				if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
					xmlhttp=new XMLHttpRequest();
				} else {// code for IE6, IE5
					xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
				}
				xmlhttp.onreadystatechange=function() {
					if (xmlhttp.readyState==4 && xmlhttp.status==200) {
						document.getElementById("r_sub").innerHTML=xmlhttp.responseText;
					}
				}
				xmlhttp.open("GET","show_subheadajax.php?q="+str,true);
				xmlhttp.send();
			}
		</script>

<div class="col">
							<div class="heading-messages">
								<h3>Search</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Accounts</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>Ledger Statement
								</div>
							</div>
						</div>

</div>

<div class="row">
							<div class="col">
								<div class="details-text">
									<h4>Search Details</h4>
								</div>
							</div>
						</div>
						<div class="hotel-listing-form">
							<form class="text-center" method="post" action="companyexpense_report.php">
                                <div class="row">
                                
                                   <div class="col-md">
                                    	<div class="form-group">
                                            <label for="inputGroupSelect07" class="">From Date:</label>
                                            <input type="date" class="form-control" id="fdate" name="fdate"  placeholder="Date" >
                                    	</div>
                                    </div>
                                    
                                    <div class="col-md">
										<div class="form-group">
                                            <label for="inputGroupSelect07" class="">To Date:</label>
                                            <input type="date" class="form-control" id="tdate" name="tdate"  placeholder="Date" >
                                    	</div>
                                    </div>
                                 </div>
                                   
                                    <div class="row"> 
                                     <div class="col-md">
										<div class="form-group">
											<div class="input-group">
												<div class="input-group-prepend">
													<label class="input-group-text" for="inputGroupSelect00">Heads</label>
												</div>
												<select  class="form-select" name="heads" id="heads" onChange="showsubheads(this.value)">
												<option disabled selected="selected">Select Heads</option>
                                                <option value="All" >All Heads</option>
												<?php
                                                $i=1;
                                                    while($rowt = $results->fetch(PDO::FETCH_ASSOC)) 
                                                    {
                                                        $headid = $rowt['headid'];
                                                        $hname = $rowt['name']; 
                                                        
                                                        echo "<option value='$headid' style='background-color:#D1D3E2' >$hname</option>";
                                                    }
                                                ?>
                                                </select>
                                       
											</div>
										</div>
									</div>
                                    
                                     <div class="col-md">
										<div class="form-group">
											<div class="input-group">
												<div class="input-group-prepend">
													<label class="input-group-text" for="inputGroupSelect00">Sub Heads</label>
												</div>
												<select  class="form-select" name="r_sub" id="r_sub">
												<option disabled selected="selected">Select SubHeads</option>
                                                
                                                </select>
                                       
											</div>
										</div>
									</div>
                                    
                                  </div>
                                                                   
                                <input type="submit" value="Generate Statement" class="btn btn-primary btn-user btn-block">
                               
                                
                            </form>
                         <br />
						
    </div>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>

<?php
	include('footer.php');
?>