
<html dir="ltr" lang="en"><head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="keywords" content="">
    <meta name="description" content="">
    <meta name="robots" content="noindex,nofollow">
    <title>View Details</title>
    <link rel="canonical" href="https://www.wrappixel.com/templates/materialpro-lite/">
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="assets/images/favicon.png">
    <!-- Custom CSS -->
    <link href="css/style.min.css" rel="stylesheet">
    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
    <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
<style>
.searchBx .fleft{
 float:left;
 padding-bottom:35px;
 margin-left:1%;
}
.searchBx .fleft input{
 border:1px solid #999;
 padding:4px;
}
.searchBx .fleft select{
 border:1px solid #999;
 padding:4px;
}
.searchBx .fleft span{
	font-weight:600;
}
.searchBx .fleft button{
 margin:18px 25px;	
}
.card{
	position:relative;
	top:-190px;
}
.card input{
	border:1px solid #999;
	padding:4px;
	background:#eee;
}
.page-wrapper h3{
	position:relative;
	left:10px;
	padding-bottom:15px;
}
</style>
</head>

<body>
    <!-- ============================================================== -->
    <!-- Preloader - style you can find in spinners.css -->
    <!-- ============================================================== -->
    <div class="preloader" style="display: none;">
        <div class="lds-ripple">
            <div class="lds-pos"></div>
            <div class="lds-pos"></div>
        </div>
    </div>
   
    <div id="main-wrapper" data-layout="vertical" data-navbarbg="skin5" data-sidebartype="full" data-sidebar-position="absolute" data-header-position="absolute" data-boxed-layout="full">
        
      <?php include"include/header.php"; ?>
        
        <div class="page-wrapper">
            <div class="page-breadcrumb">
                <div class="row align-items-center">
                    <div class="col-md-6 col-8 align-self-center">
                        <h3 class="page-title mb-0 p-0">Customer Data</h3>
                        <div class="d-flex align-items-center">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Data</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                   
                </div>
            </div>
			<?php
			if(isset($_GET['view'])){
			$viewid = $_GET['view'];	
			$selectBooking = "SELECT * FROM booking_db WHERE id='$viewid'";
			$bookingQuery  = mysqli_query($conn, $selectBooking);
			while($bk = mysqli_fetch_array($bookingQuery)){	
			$dataId = $bk['id'];
										
			$selectPax = "SELECT * FROM passenger_details WHERE booking_id='$dataId'";
			$count_pax = mysqli_query($conn,$selectPax);
			$countPax = mysqli_num_rows($count_pax);

			$flightDetails = "SELECT * FROM flight_details WHERE booking_id='$dataId'";
			$flightQuery  = mysqli_query($conn, $flightDetails);
			while($flg = mysqli_fetch_array($flightQuery)){	

				
			?>
            
            <div class="container-fluid">
                <div class="row">
				 <div class="col-lg-12 searchBx" style="background:white;">
				 <form action="" method="post">
				 <br>
				 <h5>Booking Number: <?php echo $bk['booking_id']; ?></h5>
				 <div class="clearfix"></div><hr><br>
				 
				 <div class="col-lg-12">
					<div class="col-md-1 fleft">
					    <span>From</span>
						<input type="text" class="form-control" name="from" value="<?php echo $flg['depIata']; ?>">
					</div>
					<div class="col-md-1 fleft">
					    <span>To</span>
						<input type="text" class="form-control" name="to" value="<?php echo $flg['arrIata']; ?>">
					</div>
				</div>
				<div class="clearfix"></div>
				
				
					<!--<div class="col-md-8 fleft">
					<textarea name="getData" style="width:100%;height:150px;"></textarea>
					</div>
					<div class="col-md-2 fleft">
                    <button type="submit" name="search" class="btn btn-danger d-none d-md-inline-block text-white">
					Get Data</button>
                    </div>-->
					
					<div class="col-md-6 fleft">
					  <span>Agent</span>
						<select name="status" class="form-control">
							<option value="Cancel">Naveen</option>
							<option value="Pending">Ranjeet</option>
						</select>
					</div>
					<div class="clearfix"></div><hr><br>
					<h3>Passenger Details</h3>
					<?php
					$passangers= "SELECT * FROM passenger_details WHERE booking_id='$dataId'";
					$passQuery  = mysqli_query($conn, $passangers);
					while($pass = mysqli_fetch_array($passQuery)){	
					?>
					<div class="col-md-1 fleft">
					    <span>Title</span>
						<select name="title" class="form-control">
						    <option value="<?php echo $pass['traveler_type']; ?>"><?php echo $pass['traveler_type']; ?></option>
							<option value="Adult">Adult</option>
							<option value="Child">Child</option>
							<option value="Infant">Infant</option>
						</select>
					</div>
					<div class="col-md-2 fleft">
					    <span>First Name</span>
						<input type="text" name="fname" value="<?php echo $pass['first_name']; ?>" class="form-control">
					</div>
					<div class="col-md-2 fleft">
					    <span>Middle Name</span>
						<input type="text" name="mname" value="<?php echo $pass['middle_name']; ?>" class="form-control">
					</div>
					<div class="col-md-2 fleft">
					    <span>Last Name</span>
						<input type="text" name="lname" value="<?php echo $pass['last_name']; ?>" class="form-control">
					</div>
					<div class="col-md-2 fleft">
					<span>Date Of Birth</span>
						<input type="text" name="dob" value="<?php echo $pass['date_of_birth']; ?>" class="form-control">
                    </div>
					<div class="col-md-2 fleft">
					    <span>Gender</span>
						<select name="gender" class="form-control">
							<option value="<?php echo $pass['gender']; ?>"><?php echo $pass['gender']; ?></option>
							<option value="Male">Male</option>
							<option value="Female">Female</option>
						</select>
					</div>
					<?php } ?>
					<div class="clearfix"></div><hr>
					
					
					<!--<div class="col-md-3 fleft">
					    <span>Marketing Channel</span>
						<select name="gender" class="form-control">
							<option value="1">1</option>
							<option value="2">2</option>
						</select>
					</div>
					<div class="col-md-3 fleft">
					     <span>PNR</span>
						<input type="text" placeholder="From Date" class="form-control">
					</div>-->
					<div class="clearfix"></div>
					
					<h3>Flight Details</h3>
					<div class="col-md-1 fleft">
					    <span>Dep.Date</span>
						<input type="text" name="depDate" value="<?php echo $flg['depDate']; ?>" class="form-control">
					</div>
					<div class="col-md-1 fleft">
					    <span>Flight No.</span>
						<input type="text" name="fname" value="<?php echo $flg['carrierCode']; ?>" class="form-control">
					</div>
					<div class="col-md-1 fleft">
					    <span>Airline</span>
						<input type="text" name="mname" value="<?php echo $flg['airName']; ?>" class="form-control">
					</div>
					<div class="col-md-1 fleft">
					    <span>Depart On</span>
						<input type="text" name="lname" value="<?php echo $flg['depTime']; ?>" class="form-control">
					</div>
					<div class="col-md-1 fleft">
					<span>From</span>
						<input type="text" name="dob" value="<?php echo $flg['depIata']; ?>"  class="form-control">
                    </div>
					<div class="col-md-1 fleft">
					<span>Arrive</span>
						<input type="text" name="dob" value="<?php echo $flg['arrTime']; ?>"  class="form-control">
					</div>
					<div class="col-md-1 fleft">
					<span>At</span>
						<input type="text" name="dob" value="<?php echo $flg['arrIata']; ?>" class="form-control">
					</div>
					<div class="col-md-2 fleft">
					<span>ArrivalDate</span>
						<input type="text" name="dob" value="<?php echo $flg['depDate']; ?>" class="form-control">
					</div>
					<div class="clearfix"></div>
					
					
					<h3>Contact Details</h3>
					<div class="col-md-3 fleft">
					<span>Contact Name</span>
					<input type="text" name="contactName" value="<?php echo $bk['cus_name']; ?>" class="form-control">
					</div>
					
					<div class="col-md-3 fleft">
					<span>Contact Phone</span>
					<input type="number" name="contactNo" value="<?php echo $bk['contact']; ?>" class="form-control">
					</div>
					
					<div class="col-md-3 fleft">
					<span>Contact Email</span>
					<input type="text" name="contactEmail" value="<?php echo $bk['email']; ?>" class="form-control">
					</div>
					<div class="clearfix"></div><hr>
					
					<h3>Address</h3>
					<div class="col-md-1 fleft">
					<span>HouseNo</span>
					<input type="text" name="HouseNo" value="<?php echo $bk['address1']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Street No</span>
					<input type="text" name="street" value="<?php echo $bk['address2']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>City</span>
					<input type="text" name="city" value="<?php echo $bk['city']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>PostCode</span>
					<input type="text" name="postcode" value="<?php echo $bk['postal_code']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>State/Region</span>
					<input type="text" name="state" value="<?php echo $bk['state']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Country</span>
				    <select name="country" class="form-control">
					<option value="<?php echo $bk['country']; ?>"><?php echo $bk['country']; ?></option>
					<option value="US">United States</option>
					<option value="AU">Australia</option>
					</select>
					</div>
					<div class="clearfix"></div><hr>
					
					<h3>Payment Information</h3>
					
					
					<div class="col-md-2 fleft">
					<span>cancellation Policy</span>
					<input type="text" name="Cancellation" value="<?php echo $bk['cancellation_amount']; ?>"  class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Flexible Ticket</span>
					<input type="text" name="flexible_ticket" value="<?php echo $bk['flexible_amount']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Seat Selection</span>
					<input type="text" name="seat_selection" value="<?php echo $bk['seats_assign_amount']; ?>" class="form-control" >
					</div>
					
					<div class="col-md-2 fleft">
					<span>Base Fare</span>
					<input type="text" name="base_fare" value="<?php echo $bk['base_fare']; ?>" class="form-control" >
					</div>
					
					<div class="col-md-2 fleft">
					<span>Fee & taxes</span>
					<input type="text" name="fee_taxes" value="<?php echo $bk['fee_taxes']; ?>" class="form-control" >
					</div>
					
					<div class="clearfix"></div>
					<div class="col-md-4 fleft">
					<span>GRAND TOTAL</span>
					<input type="number" name="totalAmt" value="<?php echo $bk['total_booking_amount']; ?>" class="form-control" style="font-weight:700 !important; font-size:24px;" readonly >
					</div>
					
					
					<div class="clearfix"></div><hr>
					
					<div class="col-md-2 fleft">
					<span>Amount Received</span>
					<input type="number" name="amtReceived" value="<?php echo $bk['total_booking_amount']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Date</span>
					<input type="date" name="amtReceivedDate" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Payment Mode</span>
					<input type="text" name="paymentMode" value="<?php echo $bk['cardType']; ?>" class="form-control">
					</div>
					<div class="clearfix"></div><hr>
					
					<div class="col-md-6 fleft">
					<span>status</span>
					<select name="status" class="form-control">
					<option value="Cancelled">Cancelled</option>
					<option value="Pending">Pending</option>
					<option value="Ongoing">Ongoing</option>
					</select>
					</div>
					<div class="clearfix"></div><hr>
					
					<h3>Card Details</h3>
					<div class="col-md-2 fleft">
					<span>Card Name</span>
					<input type="text" name="cardName" value="<?php echo $bk['card_name']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Card Type</span>
					<input type="text" name="cartType" value="<?php echo $bk['cardType']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>Card Number</span>
					<input type="number" name="cardNumber" value="<?php echo $bk['card_no']; ?>" class="form-control">
					</div>
					
					<div class="col-md-2 fleft">
					<span>CardVal.</span>
					<input type="text" name="cardVal" value="<?php echo $bk['month']; ?>-<?php echo $bk['year']; ?>" class="form-control" >
					</div>
					
					<div class="col-md-2 fleft">
					<span>Card CVV</span>
				    <input type="text" name="cardCvv" value="<?php echo $bk['cvv']; ?>" class="form-control" >
					</div>
					
					<div class="col-md-8 fleft">
					<textarea name="comment" placeholder="Comments"  style="width:100%;height:120px;"></textarea>
					</div>
					
					<div class="col-md-2 fleft">
                    <button type="submit" name="search" class="btn-lg btn-success d-none d-md-inline-block text-white">
					Submit</button>
                    </div>	


					
								
						
						
						
						
						
				 </form>
				 </div>
			</div>
			</div>
			
			<?php }}} ?>
                
           
            <footer class="footer"> © 2022 travelobien.com </a>
            </footer>
           
        </div>
      
    </div>
    <script src="assets/plugins/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap tether Core JavaScript -->
    <script src="assets/plugins/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
    <script src="js/app-style-switcher.js"></script>
    <!--Wave Effects -->
    <script src="js/waves.js"></script>
    <!--Menu sidebar -->
    <script src="js/sidebarmenu.js"></script>
    <!--Custom JavaScript -->
    <script src="js/custom.js"></script>


</body></html>