<?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>User 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">User 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">User Managemnet</li>
										
										<li class="breadcrumb-item text-muted">User 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");
	
	$eve = "select * from res_user_master where umid=".$_GET['id'];
			$re = mysqli_query($conn, $eve);
			while($rt = mysqli_fetch_assoc($re))
			{
	$umid=$rt['umid'];
	$ufullname=$rt['ufullname'];
	$uaddress=$rt['uaddress'];
	$umobile=$rt['ucontact'];
	$umobile2=$rt['umobile2'];
	$uwhatsapp=$rt['uwhatsapp'];
	$ustatus="Approved";
	$uskype=$rt['uskype'];
	$uname=$rt['umobile'];
	$upass=$rt['upass'];
	$uemail=$rt['uemail'];
	$dname=$rt['departmentmid'];
	$ftime=$rt['ftime'];
	$ttime=$rt['ttime'];
	$bname=$rt['branchmid'];
	$utype=$rt['utype'];
	$ubirthdate=date("Y-m-d", strtotime($rt['udate1']));
	$ujoindate=date("Y-m-d", strtotime($rt['udate2']));
	$usalary=$rt['usalary'];
	$upannumber=$rt['upannumber'];
	$uimage=$rt['uimage'];
	$unote=$rt['unote'];
	
	if(strlen($uimage)>3)
				{
					$uimage="<img src='docs/$uimage' width='80px' height='80px'>";
				}
				
				$departmentmid =$rt['departmentmid'];
				
				$dname='';
				
				$eve2 = "select * from res_department_master where departmentmid  ='$departmentmid'";
																					 								
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$dname=$rt2['departmentname'];
					}
				}
				

				
				
				
				$branchmid=$rt['branchmid'];
				
				$bname='';
				
				$eve2 = "select * from res_branch_master where branchmid ='$branchmid'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$bname=$rt2['branchname'];
					}
				}
				
				if($ubirthdate=='0000-00-00')
				{
					$ubirthdate="";
				}
				else
				{
					$ubirthdate=date("d-m-Y",strtotime($rt['udate1']));
				}
				
				if($ujoindate=='0000-00-00')
				{
					$ujoindate="";
				}
				else
				{
					$ujoindate=date("d-m-Y",strtotime($rt['udate2']));
				}
				
				
			/*$ivisaticket=$rt['ivisaticket'];
				$ivisacontactfrom=urldecode($rt['ivisacontactfrom']);
				$ivisaaddress=urldecode($rt['ivisaaddress']);
				$ivisaremarks=urldecode($rt['ivisaremarks']);
				$ivisadetail=urldecode($rt['ivisadetail']);
				$visaedit="<a data-toggle='modal' href='#responsive11' title='Edit' class='fa fa-edit fa-lg' >  </a>";
				
				$eveag = "select * from res_user_master where umid=$entrybyuserid";
				$reag = mysqli_query($conn, $eveag);
				if(mysqli_num_rows($reag) > 0)
				{
					while($rtag = mysqli_fetch_assoc($reag))
					{
						$entrybyuserid=$rtag['ufullname'];
					}
				}
				else
				{
					$entrybyuserid="";
				}
				
				$eveag1 = "select * from res_country_master where countrymid=$inquiryprefercountry";
				$reag1 = mysqli_query($conn, $eveag1);
				if(mysqli_num_rows($reag1) > 0)
				{
					while($rtag1 = mysqli_fetch_assoc($reag1))
					{
						$countryname=$rtag1['countryname'];
					}
				}
				else
				{
					$countryname="";
				} 
			
				$eve2 = "select * from res_visatype_master where visatmid='$visatmid'";
				$re2 = mysqli_query($conn, $eve2);
				$visatype="";
				while($rt2 = mysqli_fetch_assoc($re2))
				{
					$visatype=$rt2['visatype'];
				}*/
			}
			/*$eve3 = "select * from  res_payment_master where imid='$imid'";
			$re3 = mysqli_query($conn, $eve3);
			$receivedamount=0;
			while($rt3 = mysqli_fetch_assoc($re3))
			{
				$receivedamount=$rt3['receivedamount'];
			}
			$receivedamount1=$registeredamount - $receivedamount;
			
			$eve31 = "select sum(paytotalamount) as cc,sum(payrecivedamt) as cc1,sum(paypendingamt) as cc2 from  res_payments_master where imid='$imid'";
			$re31 = mysqli_query($conn, $eve31);
			$totalamt=0;
			$totalreceivedamt=0;
			$totalpendingamt=0;
			while($rt31 = mysqli_fetch_assoc($re31))
			{
				$totalamt=$rt31['cc'];
				$totalreceivedamt=$rt31['cc1'];
				$totalpendingamt=$rt31['cc2'];
			}*/
	
?>
					<!--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">Full Name
                  </th>
                  <td>
                    <?php echo $ufullname;?>
                  </td>
				  <th class="fw-bold"> Address
                  </th>
                  <td>
                    <?php echo $uaddress;?>
                  </td>
                </tr>	
				
                <tr>
                  <th class="fw-bold">Mobile Number
                  </th>
                  <td >
                    <?php echo $umobile;?>
                  </td>								
                  <th class="fw-bold">Phone Number
                  </th>
                  <td >
                    <?php echo $umobile2;?>
                  </td>
                </tr>
				
                <tr>
                  <th class="fw-bold">Whatsapp Number
                  </th>
                  <td >
                    <?php echo $uwhatsapp;?>
                  </td>
				   <th class="fw-bold">Status
                  </th>
                  <td >
                    <?php echo $ustatus;?>
					
                  </td>
                </tr>
				
                <tr>
                  <th class="fw-bold">Skype ID
                  </th>
                  <td >
                    <?php echo $uskype;?>
                  </td>
                  <th class="fw-bold">User name
                  </th>
                  <td >
                    <?php echo $uname;?>
                  </td>
                </tr>
				
                <tr>
                  <th class="fw-bold">Password
                  </th>
                  <td >
                    <?php echo $upass;?>
                  </td>
                  <th class="fw-bold">Email ID 
                  </th>
                  <td >
                    <?php echo $uemail;?>
                  </td>
                </tr>
			  
				
				 <tr>
                  <th class="fw-bold">From Time
                  </th>
                  <td >
                    <?php echo $ftime;?>
                  </td>
                  <th class="fw-bold">To Time
                  </th>
                  <td>
                    <?php echo $ttime;?>
                  </td>
                </tr>
				
				<tr>
                  <th class="fw-bold">Branch Name
                  </th>
                  <td >
                    <?php echo $bname;?>
                  </td>
                  <th class="fw-bold"> User Type
                  </th>
                  <td>
                    <?php echo $utype;?>
                  </td>
                </tr>
				
				<tr>
                  <th class="fw-bold">Birth Date
                  </th>
                  <td >
                    <?php echo $ubirthdate;?>
                  </td>
                  <th class="fw-bold">Joininig Date
                  </th>
                  <td>
                    <?php echo $ujoindate;?>
                  </td>
                </tr>
			   <tr>
                  <th class="fw-bold">Salary
                  </th>
                  <td >
                    <?php echo $usalary;?>
                  </td>
                  <th class="fw-bold">Pan Number
                  </th>
                  <td>
                    <?php echo $upannumber;?>
                  </td>
                </tr>
				 <tr>
                  <th class="fw-bold">Department Name
                  </th>
                  <td >
                    <?php echo $dname;?>
                  </td>
            
                  <th class="fw-bold">Note
                  </th>
                  <td >
                    <?php echo $unote;?>
                  </td>
                </tr> 
				<tr>
                  <th class="fw-bold">Profile Pic
                  </th>
                  <td >
                    <?php echo $uimage;?>
                  </td>
            
                  
                </tr>
			   
              </table>
			  </div>
			  </div>
           
													<!--end::Card header-->
													<!--begin::Card body-->
													
													<!--end::Card body-->
												</div>
												<!--end::Payment address-->
												</div>
											<!--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">Country</h3>
														</div>
														<!--end::Card title-->
														<!--begin::Action-->
														<a href="#" data-bs-toggle="modal" data-bs-target="#user_country" class="btn btn-sm btn-primary align-self-center"><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">
													<rect opacity="0.5" x="11.364" y="20.364" width="16" height="2" rx="1" transform="rotate(-90 11.364 20.364)" fill="currentColor" />
													<rect x="4.36396" y="11.364" width="16" height="2" rx="1" fill="currentColor" />
												</svg>
											</span>Add </a>
														<!--end::Action-->
													</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">Country </th>

																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php 
															
															$eve11 = "select * from res_usercountry_detail where umid=$umid ";
															$re11 = mysqli_query($conn, $eve11);
															while($rt11 = mysqli_fetch_assoc($re11))
															{
																
																$countrymid=$rt11['countrymid'];
																		
																			 $eveag1 = "select * from res_country_master where countrymid=$countrymid";
																		$reag1 = mysqli_query($conn, $eveag1);
																		if(mysqli_num_rows($reag1) > 0)
																		{
																			while($rtag1 = mysqli_fetch_assoc($reag1))
																			{
																				$countryname=$rtag1['countryname'];
																			}
																		}
																		else
																		{
																			$countryname="";
																		} 
																
																
																
																
															
															?>
																<tr>
																	
																	<td><?php echo $countryname; ?></td>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Order history-->
											<!--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">Sub Service</h3>
														</div>
														<!--end::Card title-->
														<!--begin::Action-->
														<a href="#" data-bs-toggle="modal" data-bs-target="#user_subservice" class="btn btn-sm btn-primary align-self-center"><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">
													<rect opacity="0.5" x="11.364" y="20.364" width="16" height="2" rx="1" transform="rotate(-90 11.364 20.364)" fill="currentColor" />
													<rect x="4.36396" y="11.364" width="16" height="2" rx="1" fill="currentColor" />
												</svg>
											</span>Add </a>
														<!--end::Action-->
													</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">Country </th>
																	<th class="min-w-100px">Service </th>
																	<th class="min-w-100px">Sub Service </th>

																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php 
															
															$eve11 = "select * from res_userservice_master where umid=$umid ";
															$re11 = mysqli_query($conn, $eve11);
															while($rt11 = mysqli_fetch_assoc($re11))
															{
																
																$visatmid=$rt11['visatmid'];
																$subservicemid=$rt11['subservicemid'];
																		
																			$eve1 = "select * from res_visatype_master where visatmid=$visatmid";

																			$re1 = mysqli_query($conn, $eve1);
																			if(mysqli_num_rows($re1) > 0)
																		{
																			while($rt1 = mysqli_fetch_assoc($re1))

																			{
																				$visatype=$rt1['visatype'];
																			}
																		}
																		else
																		{
																			$visatype="";
																		} 
																$subservicename ="";
																			 $eves = "select * from res_subservice_master where subservicemid = $subservicemid ";
																			$res = mysqli_query($conn, $eves);
																			
																			while($rts = mysqli_fetch_assoc($res))

																			{
																				$subservicename = $rts['subservicename'];
																			}
																			
																			$countrymid=$rt11['countrymid'];
																		
																			 $eveag1 = "select * from res_country_master where countrymid=$countrymid";
																		$reag1 = mysqli_query($conn, $eveag1);
																		if(mysqli_num_rows($reag1) > 0)
																		{
																			while($rtag1 = mysqli_fetch_assoc($reag1))
																			{
																				$countryname=$rtag1['countryname'];
																			}
																		}
																		else
																		{
																			$countryname="";
																		} 
																
																
																
																
																
															
															?>
																<tr>
																	
																	<td><?php echo $countryname; ?></td>
																	<td><?php echo $visatype; ?></td>
																	<td><?php echo $subservicename; ?></td>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Order history-->
											<!--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">Institute</h3>
														</div>
														<!--end::Card title-->
														<!--begin::Action-->
														<a href="#" data-bs-toggle="modal" data-bs-target="#user_college" class="btn btn-sm btn-primary align-self-center"><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">
													<rect opacity="0.5" x="11.364" y="20.364" width="16" height="2" rx="1" transform="rotate(-90 11.364 20.364)" fill="currentColor" />
													<rect x="4.36396" y="11.364" width="16" height="2" rx="1" fill="currentColor" />
												</svg>
											</span>Add </a>
														<!--end::Action-->
													</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">Institute </th>
																	<th class="min-w-100px">Country </th>

																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php 
															
															$eve11 = "select * from res_usercollege_detail where umid=$umid ";
															$re11 = mysqli_query($conn, $eve11);
															while($rt11 = mysqli_fetch_assoc($re11))
															{
																
																$collegemid=$rt11['collegemid'];
																		
																			 $eveag1 = "select * from res_college_master where collegemid=$collegemid";
																		$reag1 = mysqli_query($conn, $eveag1);
																		if(mysqli_num_rows($reag1) > 0)
																		{
																			while($rtag1 = mysqli_fetch_assoc($reag1))
																			{
																				$cmname=$rtag1['cmname'];
																			}
																		}
																		else
																		{
																			$cmname="";
																		} 
																		
																		$countrymid=$rt11['countrymid'];
																		
																			 $eveag1 = "select * from res_country_master where countrymid=$countrymid";
																		$reag1 = mysqli_query($conn, $eveag1);
																		if(mysqli_num_rows($reag1) > 0)
																		{
																			while($rtag1 = mysqli_fetch_assoc($reag1))
																			{
																				$countryname=$rtag1['countryname'];
																			}
																		}
																		else
																		{
																			$countryname="";
																		} 
																
																
																
																
																
																
															
															?>
																<tr>
																	
																	<td><?php echo $cmname; ?></td>
																	<td><?php echo $countryname; ?></td>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Order history-->
											
											</div>
										<!--end::Orders-->
									</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-->
										
			<!--begin::Modal - Student follow up-->
							<div class="modal fade" id="user_country" tabindex="-1" aria-hidden="true">
								<!--begin::Modal dialog-->
								<div class="modal-dialog modal-dialog-centered mw-750px">
									<!--begin::Modal content-->
									<div class="modal-content rounded">
										<!--begin::Modal header-->
										<div class="modal-header pb-10 border-0 ">
										<div class="card-title text-uppercase ">
														<h2>Add Country</h2>
													</div>
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary justify-content-end" data-bs-dismiss="modal">
												<!--begin::Svg Icon | path: icons/duotune/arrows/arr061.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">
														<rect opacity="0.5" x="6" y="17.3137" width="16" height="2" rx="1" transform="rotate(-45 6 17.3137)" fill="currentColor" />
														<rect x="7.41422" y="6" width="16" height="2" rx="1" transform="rotate(45 7.41422 6)" fill="currentColor" />
													</svg>
												</span>
												<!--end::Svg Icon-->
											</div>
											<!--end::Close-->
										</div>
										<!--begin::Modal header-->
										<!--begin::Modal body-->
										<div class="modal-body scroll-y px-10 px-lg-15 pt-0 pb-15">
											<!--begin::Form-->
														<form id="kt_modal_add_user_form" class="form" action="usercountry2.php" method="POST">
														<input type="hidden" name="umid" value="<?php echo $umid; ?>">
															<!--begin::Scroll-->
															<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-1 rol-cols-md-1 row-cols-lg-1">
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2"> Country</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="countrymid" id="countrymid">
													<option value="0">Select</option>
													
													<?php 
																			$eve = "select * from res_country_master";

																			$re = mysqli_query($conn, $eve);
																			
																			while($rt = mysqli_fetch_assoc($re))

																			{											
																				
																				$countrymid=$rt['countrymid'];
																				$countryname=$rt['countryname'];
																				
																				echo "<option value='$countrymid'>$countryname</option>";
																				 
																			}
																			
																	?>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div>
												<!--end::Row-->
																
															<!--end::Scroll-->
															<!--begin::Actions-->
															<div class="text-center pt-15">
																<button type="reset" class="btn btn-light me-3" data-kt-users-modal-action="cancel" data-bs-dismiss="modal" data-bs-dismiss="modal">Discard</button>
																<button type="submit" class="btn btn-primary" data-kt-users-modal-action="submit">
																	<span class="indicator-label">Submit</span>
																	<span class="indicator-progress">Please wait...
																	<span class="spinner-border spinner-border-sm align-middle ms-2"></span></span>
																</button>
															</div>
															
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Student follow up-->
			<!--begin::Modal - Student follow up-->
							<div class="modal fade" id="user_subservice" tabindex="-1" aria-hidden="true">
								<!--begin::Modal dialog-->
								<div class="modal-dialog modal-dialog-centered mw-750px">
									<!--begin::Modal content-->
									<div class="modal-content rounded">
										<!--begin::Modal header-->
										<div class="modal-header pb-10 border-0 ">
										<div class="card-title text-uppercase ">
														<h2>Add Sub Service</h2>
													</div>
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary justify-content-end" data-bs-dismiss="modal">
												<!--begin::Svg Icon | path: icons/duotune/arrows/arr061.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">
														<rect opacity="0.5" x="6" y="17.3137" width="16" height="2" rx="1" transform="rotate(-45 6 17.3137)" fill="currentColor" />
														<rect x="7.41422" y="6" width="16" height="2" rx="1" transform="rotate(45 7.41422 6)" fill="currentColor" />
													</svg>
												</span>
												<!--end::Svg Icon-->
											</div>
											<!--end::Close-->
										</div>
										<!--begin::Modal header-->
										<!--begin::Modal body-->
										<div class="modal-body scroll-y px-10 px-lg-15 pt-0 pb-15">
											<!--begin::Form-->
														<form id="kt_modal_add_user_form" class="form" action="usersubservice2.php" method="POST">
														<input type="hidden" name="umid" value="<?php echo $umid; ?>">
															<!--begin::Scroll-->
																		<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-1 rol-cols-md-1 row-cols-lg-1">
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2"> Country</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="countrymid" id="countrymid">
													<option value="0">Select</option>
													
													<?php 
																			$eve = "select * from res_country_master";

																			$re = mysqli_query($conn, $eve);
																			
																			while($rt = mysqli_fetch_assoc($re))

																			{											
																				
																				$countrymid=$rt['countrymid'];
																				$countryname=$rt['countryname'];
																				
																				echo "<option value='$countrymid'>$countryname</option>";
																				 
																			}
																			
																	?>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div>
												<!--end::Row-->
												
															<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2">
													
													<!--begin::Col-->
													<div class="col fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2"> Service</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="visatmid" id="visatmid">
													<option value="0">Select</option>
													
													
													<?php 
																			$eve1 = "select * from res_visatype_master";

																			$re1 = mysqli_query($conn, $eve1);
																			
																			while($rt1 = mysqli_fetch_assoc($re1))

																			{											
																				
																				
																				
																				
																				$visatype=$rt1['visatype'];
																				$visatmid=$rt1['visatmid'];
																				
																				echo "<option value='$visatmid'>$visatype</option>";
																				 
																			}
																			
																	?>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													
													<!--begin::Col-->
													<div class="col fv-row" id="subservice1">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Preffered Sub Service</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="subservicemid" id="subservice">
												<option value="0">Select</option>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div>
												<!--end::Row-->
																
															<!--end::Scroll-->
															<!--begin::Actions-->
															<div class="text-center pt-15">
																<button type="reset" class="btn btn-light me-3" data-kt-users-modal-action="cancel" data-bs-dismiss="modal" data-bs-dismiss="modal">Discard</button>
																<button type="submit" class="btn btn-primary" data-kt-users-modal-action="submit">
																	<span class="indicator-label">Submit</span>
																	<span class="indicator-progress">Please wait...
																	<span class="spinner-border spinner-border-sm align-middle ms-2"></span></span>
																</button>
															</div>
															
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Student follow up-->
			<!--begin::Modal - Student follow up-->
							<div class="modal fade" id="user_college" tabindex="-1" aria-hidden="true">
								<!--begin::Modal dialog-->
								<div class="modal-dialog modal-dialog-centered mw-750px">
									<!--begin::Modal content-->
									<div class="modal-content rounded">
										<!--begin::Modal header-->
										<div class="modal-header pb-10 border-0 ">
										<div class="card-title text-uppercase ">
														<h2>Add Institute</h2>
													</div>
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary justify-content-end" data-bs-dismiss="modal">
												<!--begin::Svg Icon | path: icons/duotune/arrows/arr061.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">
														<rect opacity="0.5" x="6" y="17.3137" width="16" height="2" rx="1" transform="rotate(-45 6 17.3137)" fill="currentColor" />
														<rect x="7.41422" y="6" width="16" height="2" rx="1" transform="rotate(45 7.41422 6)" fill="currentColor" />
													</svg>
												</span>
												<!--end::Svg Icon-->
											</div>
											<!--end::Close-->
										</div>
										<!--begin::Modal header-->
										<!--begin::Modal body-->
										<div class="modal-body scroll-y px-10 px-lg-15 pt-0 pb-15">
											<!--begin::Form-->
														<form id="kt_modal_add_user_form" class="form" action="usercollege2.php" method="POST">
														<input type="hidden" name="umid" value="<?php echo $umid; ?>">
															<!--begin::Scroll-->
																		<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2">
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2"> Country</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="countrymid" id="countrymid1">
													<option value="0">Select</option>
													
													<?php 
																			$eve = "select * from res_country_master";

																			$re = mysqli_query($conn, $eve);
																			
																			while($rt = mysqli_fetch_assoc($re))

																			{											
																				
																				$countrymid=$rt['countrymid'];
																				$countryname=$rt['countryname'];
																				
																				echo "<option value='$countrymid'>$countryname</option>";
																				 
																			}
																			
																	?>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2"> Institute</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<!--begin::Input-->
													<select class="form-select form-select-solid" data-control="select2"   name="collegemid" id="collegemid1">
														<option value="0">Select</option>
													<?php 
																			$eve = "select * from res_college_master,res_contact_master where res_contact_master.clinkid = res_college_master.collegemid and res_contact_master.clinktype = 'College' ";

																			$re = mysqli_query($conn, $eve);
																			
																			while($rt = mysqli_fetch_assoc($re))

																			{											
																				
																				$collegemid=$rt['collegemid'];
																				$cmname=$rt['cmname'];
																				
																				echo "<option value='$collegemid'>$cmname</option>";
																				 
																			}
																			
																	?>
													
													</select>
													<!--end::Input-->
												
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div>
												<!--end::Row-->
																
															<!--end::Scroll-->
															<!--begin::Actions-->
															<div class="text-center pt-15">
																<button type="reset" class="btn btn-light me-3" data-kt-users-modal-action="cancel" data-bs-dismiss="modal" data-bs-dismiss="modal">Discard</button>
																<button type="submit" class="btn btn-primary" data-kt-users-modal-action="submit">
																	<span class="indicator-label">Submit</span>
																	<span class="indicator-progress">Please wait...
																	<span class="spinner-border spinner-border-sm align-middle ms-2"></span></span>
																</button>
															</div>
															
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Student follow up-->
									
									
		<!--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-->
		<script type="text/javascript">
		$(document).ready(function(){
			$('#visatmid').on('change',function(){
				var siprefferservice = $(this).val();
				//alert(ibirthstate);
				if(siprefferservice){
					$.ajax({
						type:'POST',
						url:'getsubservicedata2.php',
						data:'siprefferservice='+siprefferservice,
						success:function(html){
							$('#subservice').html(html);
						}
					}); 
				}else{
					$('#subservice').html('<option value="0">No Data Found</option>'); 
				}
			});
		});
		</script>
		<script type="text/javascript">
			$(document).ready(function(){
				$('#countrymid1').on('change',function(){
					var countrymid = $(this).val();
					//alert(countrymid);
					if(countrymid){
						$.ajax({
							type:'POST',
							url:'countrytocollegedata.php',
							data:'countrymid='+countrymid,
							success:function(html){
								$('#collegemid1').html(html);
							}
						});
					}else{
						$('#collegemid1').html('<option value=""></option>');
					}
				});
			});
	</script>
	
		<!--end::Javascript-->
	</body>
	<!--end::Body-->
</html>