<?php 
session_start(); 
if(!isset($_SESSION['tulsilogin']))
	{
		header('Location: index.php');
		return;
	}


?>
<!DOCTYPE html>
<!--
Author: Keenthemes
Product Name: Metronic - Bootstrap 5 HTML, VueJS, React, Angular. Laravel, Asp.Net Core, Ruby on Rails, Spring Boot, Blazor, Django, Express Node.js & Flask Admin Dashboard Theme
Purchase: https://1.envato.market/EA4JP
Website: http://www.keenthemes.com
Contact: support@keenthemes.com
Follow: www.twitter.com/keenthemes
Dribbble: www.dribbble.com/keenthemes
Like: www.facebook.com/keenthemes
License: For each use you must have a valid license purchased only from above link in order to legally use the theme for your project.
-->
<html lang="en">
	<!--begin::Head-->
	<head>
		<title>package Detail</title>
		<meta charset="utf-8" />
		
		<meta name="viewport" content="width=device-width, initial-scale=1" />
		<meta property="og:locale" content="en_US" />
		<meta property="og:type" content="article" />
		<meta property="og:title" content="Metronic - Bootstrap 5 HTML, VueJS, React, Angular. Laravel, Asp.Net Core, Ruby on Rails, Spring Boot, Blazor, Django, Express Node.js & Flask Admin Dashboard Theme" />
		<meta property="og:url" content="https://keenthemes.com/metronic" />
		<meta property="og:site_name" content="Keenthemes | Metronic" />
		<link rel="canonical" href="https://preview.keenthemes.com/metronic8" />
		<link rel="shortcut icon" href="assets/media/logos/favicon.ico" />
		<!--begin::Fonts(mandatory for all pages)-->
		<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Inter:300,400,500,600,700" />
		<!--end::Fonts-->
		<!--begin::Vendor Stylesheets(used for this page only)-->
		<link href="assets/plugins/custom/datatables/datatables.bundle.css" rel="stylesheet" type="text/css" />
		<!--end::Vendor Stylesheets-->
		<!--begin::Global Stylesheets Bundle(mandatory for all pages)-->
		<link href="assets/plugins/global/plugins.bundle.css" rel="stylesheet" type="text/css" />
		<link href="assets/css/style.bundle.css" rel="stylesheet" type="text/css" />
		<style>
		    body{
		        background-image: none !important;
    background-color: #F3F6F9;
		    }
		</style>
		<!--end::Global Stylesheets Bundle-->
	</head>
	<!--end::Head-->
	<!--begin::Body-->
	<body id="kt_body" class="header-fixed header-tablet-and-mobile-fixed aside-fixed aside-secondary-disabled">
		<!--begin::Theme mode setup on page load-->
		<script>var defaultThemeMode = "light"; var themeMode; if ( document.documentElement ) { if ( document.documentElement.hasAttribute("data-theme-mode")) { themeMode = document.documentElement.getAttribute("data-theme-mode"); } else { if ( localStorage.getItem("data-theme") !== null ) { themeMode = localStorage.getItem("data-theme"); } else { themeMode = defaultThemeMode; } } if (themeMode === "system") { themeMode = window.matchMedia("(prefers-color-scheme: dark)").matches ? "dark" : "light"; } document.documentElement.setAttribute("data-theme", themeMode); }</script>
		<!--end::Theme mode setup on page load-->
		<!--begin::Main-->
		<!--begin::Root-->
		<div class="d-flex flex-column flex-root">
			<!--begin::Page-->
			<div class="page d-flex flex-row flex-column-fluid">
				<!--begin::Aside-->
				<?php include('sidebar.php'); ?>
				<!--end::Aside-->
				<!--begin::Wrapper-->
				<div class="wrapper d-flex flex-column flex-row-fluid" id="kt_wrapper">
					<!--begin::Header-->
					<div id="kt_header" style="" class="header align-items-stretch">
						<!--begin::Container-->
						<div class="container-fluid d-flex align-items-stretch justify-content-between">
							<!--begin::Aside mobile toggle-->
							<div class="d-flex align-items-center d-lg-none ms-n3 me-1" title="Show aside menu">
								<div class="btn btn-icon btn-active-color-primary w-40px h-40px" id="kt_aside_toggle">
									<!--begin::Svg Icon | path: icons/duotune/abstract/abs015.svg-->
									<span class="svg-icon svg-icon-1">
										<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
											<path d="M21 7H3C2.4 7 2 6.6 2 6V4C2 3.4 2.4 3 3 3H21C21.6 3 22 3.4 22 4V6C22 6.6 21.6 7 21 7Z" fill="currentColor" />
											<path opacity="0.3" d="M21 14H3C2.4 14 2 13.6 2 13V11C2 10.4 2.4 10 3 10H21C21.6 10 22 10.4 22 11V13C22 13.6 21.6 14 21 14ZM22 20V18C22 17.4 21.6 17 21 17H3C2.4 17 2 17.4 2 18V20C2 20.6 2.4 21 3 21H21C21.6 21 22 20.6 22 20Z" fill="currentColor" />
										</svg>
									</span>
									<!--end::Svg Icon-->
								</div>
							</div>
							<!--end::Aside mobile toggle-->
							<!--begin::Mobile logo-->
							<div class="d-flex align-items-center flex-grow-1 flex-lg-grow-0">
								<a href="dashboard.php" class="d-lg-none">
									<img alt="Logo" src="assets/media/logos/demo4-mobile.svg" class="h-25px" />
								</a>
							</div>
							<!--end::Mobile logo-->
							<div class="d-flex align-items-center" id="kt_header_wrapper">
								<!--begin::Page title-->
								<div class="page-title d-flex flex-column align-items-start justify-content-center flex-wrap me-lg-20 pb-5 pb-lg-0" data-kt-swapper="true" data-kt-swapper-mode="prepend" data-kt-swapper-parent="{default: '#kt_content_container', lg: '#kt_header_wrapper'}">
									<!--begin::Heading-->
									<h1 class="text-dark fw-bold my-1 fs-3 lh-1">package Details</h1>
									<!--end::Heading-->
									<!--begin::Breadcrumb-->
									<ul class="breadcrumb fw-semibold fs-8 my-1">
										<li class="breadcrumb-item text-muted">
											<a href="dashboard.php" class="text-muted">Home</a>
										</li>
										<li class="breadcrumb-item text-muted">package Managemnet</li>
										
										<li class="breadcrumb-item text-muted">package Details</li>
									</ul>
									<!--end::Breadcrumb-->
								</div>
								<!--end::Page title=-->
							</div>
							<!--begin::Wrapper-->
							<?php include('header.php'); ?>
							<!--end::Wrapper-->
						</div>
						<!--end::Container-->
					</div>
					<!--end::Header-->
					<?php
					
	
	include("connect.php");
	include("mylibrary.php");
	$eve = "select * from res_package_master where packagemid=".$_GET['id'];
			$re = mysqli_query($conn, $eve);
			while($rt = mysqli_fetch_assoc($re))
			{
				$packagemid=$rt['packagemid'];
				$branchmid=$rt['branchmid'];
				$packagename=$rt['packagename'];
				$pcurrency=$rt['pcurrency'];
				$pcurrencyrate=$rt['pcurrencyrate'];
				$pcurrencyinr=$rt['pcurrencyinr'];
				$pdescription=$rt['pdescription'];
				$subservicemid=$rt['subservicemid'];
				$subservicename = '';
				$eve2= "select subservicename from res_subservice_master where subservicemid=$subservicemid";
					$re2 = mysqli_query($conn, $eve2);
					 while($rt2 = mysqli_fetch_assoc($re2))
					{
						$subservicename=$rt2['subservicename'];
					}
					
					
			
				
				$countrymid=$rt['countrymid'];
				
				$countryname='';
				
				$eve2 = "select * from res_country_master where countrymid ='$countrymid'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$countryname=$rt2['countryname'];
					}
				}
				
				
			
			}
			
	
?>
					<!--begin::Content-->
					<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
						<!--begin::Container-->
						<div class="container-xxl" id="kt_content_container">
							<!--begin::Order details page-->
							<div class="d-flex flex-column gap-7 gap-lg-10">
								<!--<div class="d-flex flex-wrap flex-stack gap-5 gap-lg-10">
									
									<!--begin::Button-->
									<?php /*if($_SESSION['frompage'] == 'Inquirylistpage') {?>
									<a href="inquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php } else if ($_SESSION['frompage'] == 'planStudiesInquirylistpage') { ?>
									<a href="planstudiesinquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php } else if ($_SESSION['frompage'] == 'AgentDetail') {  ?>
									<a href="agentinquiry.php?id=<?php echo $_SESSION['agentid']; ?>" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php }else{ ?>
									<a href="inquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php }*/ ?>
										<!--begin::Svg Icon | path: icons/duotune/arrows/arr074.svg-->
										<!--<span class="svg-icon svg-icon-2">
											<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
												<path d="M11.2657 11.4343L15.45 7.25C15.8642 6.83579 15.8642 6.16421 15.45 5.75C15.0358 5.33579 14.3642 5.33579 13.95 5.75L8.40712 11.2929C8.01659 11.6834 8.01659 12.3166 8.40712 12.7071L13.95 18.25C14.3642 18.6642 15.0358 18.6642 15.45 18.25C15.8642 17.8358 15.8642 17.1642 15.45 16.75L11.2657 12.5657C10.9533 12.2533 10.9533 11.7467 11.2657 11.4343Z" fill="currentColor" />
											</svg>
										</span>
										<!--end::Svg Icon-->
									</a>
									<!--end::Button-->
									
							
								
								<!--begin::Tab content-->
								<div class="tab-content">
									<!--begin::Tab pane-->
									<div class="tab-pane fade show active" id="User_detail" role="tab-panel">
										<!--begin::Orders-->
										<div class="d-flex flex-column gap-7 gap-lg-10">
											<div class="d-flex flex-column flex-xl-row gap-7 gap-lg-10">
												<!--begin::Payment address-->
												<div class="card card-flush py-4 flex-row-fluid overflow-hidden">
													<!--begin::Background-->
													
													<!--end::Background-->
													<div class="d-flex justify-content-end" data-kt-user-table-toolbar="base">
													
													<!--begin::Add user-->
										
											<!--end::Add user-->
												</div>
													<!--begin::Card header-->
													<div class="card-body pt-0">
													<div class="table-responsive">
													<table class="table align-middle table-row-dashed fs-6 gy-5 mb-0">
                
             
				
				<tr>
                  <th class="fw-bold">Package Name
                  </th>
                  <td>
                    <?php echo $packagename;?>
                  </td>
				  <th class="fw-bold"> Sub Service
                  </th>
                  <td>
                    <?php echo $subservicename;?>
                  </td>
                </tr>	
				
                <tr>
                  <th class="fw-bold">Currency
                  </th>
                  <td >
                    <?php echo $pcurrency;?>
                  </td>								
                  <th class="fw-bold">Currency Rate
                  </th>
                  <td >
                    <?php echo $pcurrencyrate;?>
                  </td>
                </tr>
				
                <tr>
                  <th class="fw-bold">Price in INR
                  </th>
                  <td >
                    <?php echo $pcurrencyinr;?>
                  </td>
				   <th class="fw-bold">Country
                  </th>
                  <td >
                    <?php echo $countryname;?>
					
                  </td>
                </tr>
				 <tr>
                 
				   <th class="fw-bold">Description
                  </th>
                  <td colspan="3">
                    <?php echo $pdescription;?>
					
                  </td>
                </tr>
				
               
			   
			   
              </table>
			  </div>
			  </div>
           
													<!--end::Card header-->
													<!--begin::Card body-->
													
													<!--end::Card body-->
												</div>
												<!--end::Payment address-->
												</div>
											
											</div>
										<!--end::Orders-->
										<!--begin::Order history-->
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
													<div class="card-header cursor-pointer">
														<!--begin::Card title-->
														<div class="card-title m-0">
															<h3 class="fw-bold m-0 text-uppercase">Available Offers</h3>
														</div>
														<!--end::Card title-->
														
													</div>
												
												<!--end::Card header-->
												<!--begin::Card body-->
												<div class="card-body pt-0">
													<div class="table-responsive">
														<!--begin::Table-->
														<table class="table align-middle table-row-dashed fs-6 gy-5 mb-0">
															<!--begin::Table head-->
															<thead>
																<tr class="text-start text-gray-400 fw-bold fs-7 text-uppercase gs-0">
																	<th class="min-w-100px">Offer </th>
																	<th class="min-w-100px">Start Date </th>
																	<th class="min-w-100px">End Date </th>
																	<th class="min-w-100px">Discount </th>
																	<th class="min-w-100px">Coupon Code</th>
																	
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php 
															
															$eve11="SELECT * FROM res_offer_master WHERE offermid in (select offermid from res_offersubservice_detail where subservicemid= ".$subservicemid.") and  offermid in (select offermid from res_offerbranch_detail where branchmid= ".$branchmid.") and  offermid in (select offermid from res_offercountry_detail where countrymid= ".$countrymid.") ";
															$re11 = mysqli_query($conn, $eve11);
															while($rt11 = mysqli_fetch_assoc($re11))
															{
																
																$offername=checkvalidstring ($rt11['offername']);
				
				$offerdiscount=checkvalidstring ($rt11['offerdiscount']);
				
				$offercouponcode=checkvalidstring ($rt11['offercouponcode']);
				
																
																$offerstartdate=date("d-m-Y",strtotime($rt11['offerstartdate']));
																$offervalidtill=date("d-m-Y",strtotime($rt11['offervalidtill']));
																
																												
																
																
															
															?>
																<tr>
																	
																	<td><?php echo $offername; ?></td>
																	<td><?php echo $offerstartdate; ?></td>
																	<td><?php echo $offervalidtill; ?></td>
																	<td><?php echo $offerdiscount; ?></td>
																	<td><?php echo $offercouponcode; ?></td>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Order history-->
						
									</div>
									<!--end::Tab pane-->
									
								</div>
								<!--end::Tab content-->
							</div>
							<!--end::Order details page-->
						</div>
						<!--end::Container-->
					</div>
					<!--end::Content-->
					<!--begin::Footer-->
					<?php include('footer.php'); ?>
					<!--end::Footer-->
				</div>
				<!--end::Wrapper-->
			</div>
			<!--end::Page-->
		</div>
		<!--end::Root-->
		<!--begin::Drawers-->
		
		<!--begin::Engage modals-->
		<!--end::Engage modals-->
		<!--begin::Modal - Add task-->
										
						
									
		<!--end::Modals-->
		<!--begin::Javascript-->
		<script>var hostUrl = "assets/";</script>
		<!--begin::Global Javascript Bundle(mandatory for all pages)-->
		<script src="assets/plugins/global/plugins.bundle.js"></script>
		<script src="assets/js/scripts.bundle.js"></script>
		<!--end::Global Javascript Bundle-->
		<!--begin::Vendors Javascript(used for this page only)-->
		<script src="assets/plugins/custom/datatables/datatables.bundle.js"></script>
		<!--end::Vendors Javascript-->
		<!--begin::Custom Javascript(used for this page only)-->
		<script src="assets/js/widgets.bundle.js"></script>
		<script src="assets/js/custom/widgets.js"></script>
		<script src="assets/js/custom/apps/chat/chat.js"></script>
		<script src="assets/js/custom/utilities/modals/upgrade-plan.js"></script>
		<script src="assets/js/custom/utilities/modals/users-search.js"></script>
		<!--end::Custom Javascript-->
		<!--end::Javascript-->
	</body>
	<!--end::Body-->
</html>