invisio v2.0

<?php
session_start();
date_default_timezone_set('Asia/Muscat');
 $de = date('Y-m-d');
include("config.php");
include("innerpageheader.php");
$empids = $_SESSION['empids'];
if($empids == 'admin')
{
	$branch = $_POST['branch'];	
}
else
{
	$sql1 = $js->prepare('SELECT * FROM employees WHERE empid = :empids ');
	$sql1->execute(array(':empids' => $empids));
	
	while($row1 = $sql1->fetch(PDO::FETCH_ASSOC)) 
	{
		$branch = $row1['empbranch'];
	}
}
	
$resultz1 = $js->query('SELECT * FROM `bankaccounts` ');
$resultz1->execute();

$enq = 'Confirmed';
$enq1 = 'Finished';

/*$resultc = $js->prepare('SELECT * FROM `customer_entry` WHERE enquirystatus = :enq OR enquirystatus !=  :enq1');*/

$resultc = $js->prepare('SELECT * FROM `customer_entry` WHERE enquirystatus = :enq');
$resultc->execute(array(':enq' => $enq));
?>

<div class="col">
							<div class="heading-messages">
								<h3>Create New Customer Expense</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>Customer Expense
								</div>
							</div>
						</div>

</div>

<div class="row">
							<div class="col">
								<div class="details-text">
									<h4>Add Details</h4>
								</div>
							</div>
						</div>
						<div class="hotel-listing-form">
							<form class="text-center" method="post" action="add_customerexpense.php">
                                                       
                                 <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">Client</label>
												</div>
												<select  class="form-select" name="client" id="client" onChange="showsubheads(this.value)">
                                        	<option value="" disabled="disabled" selected="selected">Select Client</option>
												<?php
													while($rowc = $resultc->fetch(PDO::FETCH_ASSOC)) 
													{
														$clid = $rowc['id'];
														$comp = $rowc['companyname'];
														$pdate = date('d-m-Y', strtotime($rowc['plannningdate']));
														$days = $rowc['daysplanning'];
														$todate = date('d-m-Y', strtotime($pdate.' + '.$days.' days - 1 day'));
														$clname = $rowc['custname'];
														if($comp == '')
														{
															$client = $clname;	
														}
														else
														{
															$client = $comp." - ".$clname;	
														}
														echo "<option value='$clid'> $client ($pdate To $todate)</option>";
													}
                                                ?>
                                                </select>
                                       
											</div>
										</div>
									</div>
                                 </div>
                                 
                                                                          
                                <input type="submit" value="Submit" class="btn btn-primary btn-user btn-block">
                               
                                
                            </form>
  </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');
?>