<?php 
session_start(); 
if(!isset($_SESSION['tulsilogin']))
	{
		header('Location: index.php');
		return;
	}
include("connect.php");
$_SESSION['frompage']='aplicationInquirydetailpage';
?>
<!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>Inquiry 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">Inquiry 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">Inquiry Managemnet</li>
										
										<li class="breadcrumb-item text-muted">Inquiry 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
					
	
	
	
	date_default_timezone_set("Asia/Kolkata");
		$mdate1= date('Y-m-d H:i:s');
		$mdate= date('d-m-Y');
	$stiqmid=$_GET['id'];
	$eve = "select * from res_inquiry_master,res_studentinquiry_detail where res_inquiry_master.imid = res_studentinquiry_detail.imid and res_studentinquiry_detail.stiqmid=".$_GET['id'];
			$re = mysqli_query($conn, $eve);
			while($rt = mysqli_fetch_assoc($re))
			{
				
				$imid=$rt['imid'];
				$ipname=$rt['ipname'];
				$ipmiddlename=$rt['ipmiddlename'];
				$ipsurname=$rt['ipsurname'];
				$name=$ipname." ".$ipmiddlename." ".$ipsurname;
				$ipaddress=$rt['ipaddress'];
				$ipostcode=$rt['ipostcode'];
				$ipemail=$rt['ipemail'];
				$ipmobile=$rt['ipmobile'];
				$ihomemobile=$rt['ihomemobile'];
				$ipgender=$rt['ipgender'];
				//$ipdob=$rt['ipdob'];
				$idate=$rt['idate'];
				$ipbirthcountry=$rt['ipbirthcountry'];
				$ibirthstate=$rt['ibirthstate'];
				$ipbirthcity=$rt['ipbirthcity'];
				$address = $ipaddress.",".$ipbirthcity."-".$ipostcode.",".$ibirthstate.",".$ipbirthcountry;
				$imremarks=$rt['imremarks'];
				$imdetails=$rt['imdetails'];
				$imstatus=$rt['imstatus'];
				$registeredamount=$rt['registeredamount'];
				$entrybyuserid=$rt['entrybyuserid'];
				$visatmid=$rt['visatmid'];
				$ivisadate=$rt['ivisadate'];
				$ivisano=$rt['ivisano'];
				$ivisatraveldate=$rt['ivisatraveldate'];
				$ipdob=$rt['ipdob'];
				$ipmarritalstatus=$rt['ipmarritalstatus'];
				$ipstatus=$rt['ipstatus'];
				$sourceofinq=$rt['sourceofinq'];
				$ipoffer=$rt['ipoffer'];
				$referencename=$rt['referencename'];
				$agentid=$rt['agentid'];
				
				//$inquirypurpose=$rt['inquirypurpose'];
				$siprefferedcountry=$rt['siprefferedcountry'];
				
				//$inquirypurpose1="<button data-toggle='modal' data-target='#view-modal' data-id='$imid' id='getUser' class='btn btn-xs btn-warning'>$inquirypurpose</button>";
				
				if($ivisadate=='0000-00-00')
				{
					$ivisadate="";
				}
				else
				{
					$ivisadate=date("d-m-Y",strtotime($rt['ivisadate']));
				}
				
				if($ipdob=='0000-00-00')
				{
					$ipdob="";
				}
				else
				{
					$ipdob=date("d-m-Y",strtotime($rt['ipdob']));
				}	
				
				if($ivisatraveldate == '0000-00-00')
				{
					$ivisatraveldate="";
				}
				else
				{
					$ivisatraveldate=date("d-m-Y",strtotime($rt['ivisatraveldate']));
				}
				
				$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="";
				}
				
				
				if($agentid == 0)
				{
					$agentname="Direct";
				}else{
				$eveag = "select * from res_user_master where umid=$agentid";
				$reag = mysqli_query($conn, $eveag);
				if(mysqli_num_rows($reag) > 0)
				{
					while($rtag = mysqli_fetch_assoc($reag))
					{
						$agentname=$rtag['ufullname'];
					}
				}
				else
				{
					$agentname="";
				}
				}
				
				$eveag1 = "select * from res_country_master where countrymid=$siprefferedcountry";
				$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'];
			}
			
			$siprefferservice=$rt['siprefferservice'];
																$siprefferedsubservice=$rt['siprefferedsubservice'];
																			$subservicename ="";
																			 $eves = "select * from res_subservice_master where subservicemid = $siprefferedsubservice ";
																			$res = mysqli_query($conn, $eves);
																			
																			while($rts = mysqli_fetch_assoc($res))

																			{
																				$subservicename = $rts['subservicename'];
																			}
			}
			 $full_url = $_SERVER['REQUEST_URI'];

$hash_position = strpos($full_url, "#");

if (isset($_GET['tab'])) {
    $hash_value = $_GET['tab'];
   
} else {
   $hash_value = 'student_detail';
}
	
?>
					<!--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">
								<!--begin::Tab content-->
								<div class="tab-content">
									<!--begin::Tab pane-->
									<div class="tab-pane fade <?php if($hash_value == 'student_detail'){ echo 'show active'; }?>" id="student_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::Chat-->
									<div class="d-flex align-items-center ms-1 ms-lg-3">
										<!--begin::Menu wrapper-->
										<div class="btn btn-icon btn-active-light-primary position-relative btn btn-icon btn-active-light-primary w-30px h-30px w-md-40px h-md-40px" id="kt_drawer_chat_toggle">
											<!--begin::Svg Icon | path: icons/duotune/communication/com012.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 opacity="0.3" d="M20 3H4C2.89543 3 2 3.89543 2 5V16C2 17.1046 2.89543 18 4 18H4.5C5.05228 18 5.5 18.4477 5.5 19V21.5052C5.5 22.1441 6.21212 22.5253 6.74376 22.1708L11.4885 19.0077C12.4741 18.3506 13.6321 18 14.8167 18H20C21.1046 18 22 17.1046 22 16V5C22 3.89543 21.1046 3 20 3Z" fill="currentColor" />
													<rect x="6" y="12" width="7" height="2" rx="1" fill="currentColor" />
													<rect x="6" y="7" width="12" height="2" rx="1" fill="currentColor" />
												</svg>
											</span>
											<!--end::Svg Icon-->
											<span class="bullet bullet-dot bg-success h-6px w-6px position-absolute translate-middle top-0 start-50 animation-blink"></span>
										</div>
										<!--end::Menu wrapper-->
									</div>
									<!--end::Chat-->
									<!--begin::Chat-->
									<div class="d-flex align-items-center ms-1 ms-lg-3">
										<!--begin::Menu wrapper-->
										<div class="btn btn-icon btn-active-light-primary position-relative btn btn-icon btn-active-light-primary w-30px h-30px w-md-40px h-md-40px" id="kt_drawer_chat_toggle1">
											<!--begin::Svg Icon | path: icons/duotune/communication/com012.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 opacity="0.3" d="M20 3H4C2.89543 3 2 3.89543 2 5V16C2 17.1046 2.89543 18 4 18H4.5C5.05228 18 5.5 18.4477 5.5 19V21.5052C5.5 22.1441 6.21212 22.5253 6.74376 22.1708L11.4885 19.0077C12.4741 18.3506 13.6321 18 14.8167 18H20C21.1046 18 22 17.1046 22 16V5C22 3.89543 21.1046 3 20 3Z" fill="currentColor" />
													<rect x="6" y="12" width="7" height="2" rx="1" fill="currentColor" />
													<rect x="6" y="7" width="12" height="2" rx="1" fill="currentColor" />
												</svg>
											</span>
											<!--end::Svg Icon-->
											<span class="bullet bullet-dot bg-success h-6px w-6px position-absolute translate-middle top-0 start-50 animation-blink"></span>
										</div>
										<!--end::Menu wrapper-->
									</div>
									<!--end::Chat-->
									
											<!--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"> Name
                  </th>
                  <td calspnad="3">
                    <?php echo $name;?>
                  </td>
                 
                </tr>
				 <tr>
				 <th class="fw-bold">Gender
                  </th>
                  <td >
                    <?php echo $ipgender;?>
                  </td>
                  <th class="fw-bold">Email
                  </th>
                  <td >
                    <?php echo $ipemail;?>
                  </td>								
                 
                </tr>
				<tr>
                  
                  <th class="fw-bold">Mobile Number
                  </th>
                  <td>
                    <?php echo $ipmobile;?>
                  </td>
				  <th class="fw-bold"> Alternative Contact Number
                  </th>
                  <td>
                    <?php echo $ihomemobile;?>
                  </td>
                </tr>	
               
                <tr>
				
                 <th class="fw-bold">Birth Date
                  </th>
                  <td>
                    <?php echo $ipdob;?>
                  </td>
				
                  <th class="fw-bold">Marrital Status
                  </th>
                  <td >
                    <?php echo $ipmarritalstatus;?>
                  </td>
				   
                </tr>
                <tr >
                  <th class="fw-bold">Address
                  </th>
                  <td colspan="2">
                    <?php echo $ipaddress;?>
                  </td>
                  
                </tr> 
				
				<tr >
                  <th class="fw-bold">City
                  </th>
                  <td >
                    <?php echo $ipbirthcity;?>
                  </td>
				  <th class="fw-bold">Postcode
                  </th>
                  <td >
                    <?php echo $ipostcode;?>
                  </td>
                  
                </tr>
				<tr >
                  <th class="fw-bold">State
                  </th>
                  <td >
                    <?php echo $ibirthstate;?>
                  </td>
				  <th class="fw-bold">Country
                  </th>
                  <td >
                    <?php echo $ipbirthcountry;?>
                  </td>
                  
                </tr>
				
               <!-- <tr>
                  <th class="fw-bold">Remark
                  </th>
                  <td colspan="2">
                    <?php echo $imremarks;?>
                  </td>
                 
                </tr>-->
                <tr >
				 <th class="fw-bold">Heard About Us
                  </th>
                  <td >
                    <?php echo $sourceofinq;?>
                  </td>
                 
                 
                </tr>
				
				<tr >
				 <th class="fw-bold">Agent
                  </th>
                  <td >
                    <?php echo $agentname;?>
                  </td>
                  <th class="fw-bold">Reference by 
                  </th>
                  <td >
                    <?php echo $referencename;?>
                  </td>
                 
                </tr>
               <tr >
				 <th class="fw-bold">Preferred Country
                  </th>
                  <td >
                    <?php echo $countryname;?>
                  </td>
                  <th class="fw-bold">Preferred Service 
                  </th>
                  <td >
                    <?php echo $siprefferservice;?>
                  </td>
                 
                </tr>
               <tr >
				 <th class="fw-bold">Preferred Sub Service
                  </th>
                  <td >
                    <?php echo $subservicename;?>
                  </td>
                 
                </tr>
               
				
               
              </table>
			  </div>
			  </div>
           
													<!--end::Card header-->
													<!--begin::Card body-->
													
													<!--end::Card body-->
												</div>
												<!--end::Payment address-->
												</div>
												<!--begin::Service-->
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2>Program Shortlist</h2>
													</div>
													<!--begin::Add user-->
											
										
											<!--end::Add user-->
												</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"> Inquiry Time</th>
																	<th class="min-w-100px"> Country</th>
																	<th class="min-w-175px">College </th>
																	<th class="min-w-175px">Program </th>
																	<th class="min-w-175px">Remarks </th>
																	<th class="min-w-100px">Addedby</th>
<th class="min-w-100px">Addedon</th>
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
							$i=1;
							$eve1 = "select * from res_counselling_detail where stiqmid=".$_GET['id'];
							$re1 = mysqli_query($conn, $eve1);
							while($rt11 = mysqli_fetch_assoc($re1))
							{
								$stiqmid=$rt11['stiqmid'];
									$siprefferservice='';
									$inquirydate='';
									$eve78 = "select siprefferservice,inquirydate from res_studentinquiry_detail where imid=$imid and stiqmid=$stiqmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$siprefferservice=$rt78['siprefferservice'];
											$inquirydate=date("d-m-Y",strtotime($rt78['inquirydate']));
										}
									}
									
									$cdid=$rt11['cdid'];

														$countrymid=$rt11['countrymid'];
														$coursemid=$rt11['coursemid'];
														$collegemid=$rt11['collegemid'];
														//$codate=implode('-', array_reverse(explode('-', $rt11['codate'])));
														//$codate=implode('/', array_reverse(explode('/', $rt11['codate'])));
														$coremarks=$rt11['coremarks'];

														$eve13 = "select * from res_coursename_master where cnmid in(select cnmid from res_course_master where coursemid=$coursemid)";
														$re13 = mysqli_query($conn, $eve13);
														$coursename="";
														while($rt13 = mysqli_fetch_assoc($re13))
														{
														$coursename=$rt13['coursename'];
														}	
														$eve14 = "select * from res_college_master where collegemid=$collegemid";
														$re14 = mysqli_query($conn, $eve14);
														$cmname="";
														while($rt14 = mysqli_fetch_assoc($re14))
														{
														$cmname=$rt14['cmname'];
														}	
														$eve15 = "select * from res_country_master where countrymid=$countrymid";
														$re15 = mysqli_query($conn, $eve15);
														$countryname="";
														while($rt15 = mysqli_fetch_assoc($re15))
														{
														$countryname=$rt15['countryname'];
														}			
																				
														$cdaddedon='';	
														$cdaddedon=date("d-m-Y",strtotime($rt11['cdaddedon']));
														$cdaddedby=$rt11['cdaddedby'];

														$ufullname='';
														$utype='';
														$evea1 = "select ufullname,utype from res_user_master where umid=$cdaddedby";
														$rea1 = mysqli_query($conn, $evea1);
														if(mysqli_num_rows($rea1) > 0)
														{
														while($rta1 = mysqli_fetch_assoc($rea1))
														{
															$ufullname=$rta1['ufullname'];
															$utype=$rta1['utype'];
														}
														}														
									
							?>
																<tr>
																	
																	<td><?php echo $siprefferservice."(".$inquirydate.")"; ?></td>
																	<td><?php echo $countryname; ?></td>
																	
																	<td><?php echo $cmname; ?></td>
																	<td><?php echo $coursename; ?></td>
																	<td><?php echo $coremarks; ?></td>
																	
																	<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $cdaddedon; ?></td>

																	
																	
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Service-->
										
													<!--begin::Payment-->
													<?php
													 $eve23 = "select * from res_inquirymoduleallocation_detail where countrymid = $siprefferedcountry and subservicemid=$siprefferedsubservice and blockname='College Application'";
											$re23 = mysqli_query($conn, $eve23);
	
				if(mysqli_num_rows($re23)>0 )
					{
						?>
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2>College Application</h2>
													</div>
										
											<!--end::Add user-->
												</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>Sr No.
                          
                            </th>
							<th>Country
                            </th>
							
							<th>College
                            </th>
							<th>Program
                            </th>
                            <th>Remark
                            </th>
                            <th>Program Fees
                            </th>
                            <th>Status
                            </th>
                            <th>Student Date
                            </th>
							<th>Student ID
                            </th>
							<th>Process
                            </th>
							<th>Offer letter
                            </th>
							<th class="min-w-100px">Addedby</th>
<th class="min-w-100px">Addedon</th>
							 <?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){ ?>
                            <th>Operation
                            </th>
							 <?php }} ?>
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
															$i=1;
															$tt1=0;
															$evepay = "select * from res_collegeapp_master where stiqmid=".$_GET['id'];
															$repay = mysqli_query($conn, $evepay);
															$i=1;
															while($rtpay = mysqli_fetch_assoc($repay))
															{
															$clgappmid=$rtpay['clgappmid'];
															$imid=$rtpay['imid'];
															$coursefees=$rtpay['coursefees'];
								$statusmid=$rtpay['statusmid'];
								$stiqmid=$rtpay['stiqmid'];
								$siprefferservice='';
									$inquirydate='';
									$eve78 = "select siprefferservice,inquirydate from res_studentinquiry_detail where imid=$imid and stiqmid=$stiqmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$siprefferservice=$rt78['siprefferservice'];
											$inquirydate=date("d-m-Y",strtotime($rt78['inquirydate']));
										}
									}
								$coursemid=$rtpay['coursemid'];
								$capstatus=$rtpay['capstatus'];
								$status2 = ' <a href="#" data-bs-toggle="modal" data-bs-target="#view-modal6" class="fa fa-edit"  data-id="'.$clgappmid.'" id="getUser6">
												</a>';
								$capstatus=$capstatus." ".$status2;			
								$collegemid=$rtpay['collegemid'];
								$countrymid=$rtpay['countrymid'];
								$cstudentid=$rtpay['cstudentid'];
								$clgamid=$rtpay['clgamid'];
								$coremarks=$rtpay['coremarks'];
								$cofferdocument=$rtpay['cofferdocument'];
								$doapplication=date("d-m-Y", strtotime($rtpay['doapplication']));
								$df ='';
								if($clgamid != 0)
								{
									$df = "Application after Deferral";
								}
								
								
								$eve13 = "select * from res_coursename_master where cnmid in (select cnmid from res_course_master where coursemid=$coursemid)";
								$re13 = mysqli_query($conn, $eve13);
								$coursename="";
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									$coursename=$rt13['coursename'];
								}	
								
								$eve14 = "select * from res_college_master where collegemid=$collegemid";
								$re14 = mysqli_query($conn, $eve14);
								$cmname="";
								while($rt14 = mysqli_fetch_assoc($re14))
								{
									$cmname=$rt14['cmname'];
								}	
								
								$eve15 = "select * from res_country_master where countrymid=$countrymid";
								$re15 = mysqli_query($conn, $eve15);
								$countryname="";
								while($rt15 = mysqli_fetch_assoc($re15))
								{
									$countryname=$rt15['countryname'];
								}
								
								$capaddedon='';	
														$capaddedon=date("d-m-Y",strtotime($rtpay['capaddedon']));
														$capaddedby=$rtpay['capaddedby'];

														$ufullname='';
														$utype='';
														$evea1 = "select ufullname,utype from res_user_master where umid=$capaddedby";
														$rea1 = mysqli_query($conn, $evea1);
														if(mysqli_num_rows($rea1) > 0)
														{
														while($rta1 = mysqli_fetch_assoc($rea1))
														{
															$ufullname=$rta1['ufullname'];
															$utype=$rta1['utype'];
														}
														}
															?>
																<tr>
																	
																	 <td>
                              <?php echo $i++;?>
                            </td>
							
                            
							<td>
                              <?php echo $countryname;?>
                            </td>
							<td>
                              <?php echo $cmname;?>
                            </td> 
							<td>
                              <?php echo $coursename;?>
                            </td>
							<td>
                              <?php echo $coremarks;?>
                            </td>
                            <td>
                              <?php echo $coursefees;?>
                            </td>
                            <td>
                              <?php echo $capstatus;?>
                            </td>
                            <td>
                              <?php echo $doapplication;?>
                            </td> <td>
                              <?php echo $cstudentid;?>
                            </td>
							<td>
                              <?php echo $df;?>
                            </td>
                           <td><?php if($cofferdocument != ''){  ?>
                              <a href='./docs/<?php echo $cofferdocument;?>' target="_blank">View
                              </a>
																	 <?php } ?></td>
							<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $capaddedon; ?></td>
							<?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                            <td>
                              <a  href="clgapplicationdelete.php?id=<?php echo $rtpay['clgappmid']; ?>&&p3=<?php echo $_GET['id'];?>" onclick='return confirm(&#39;Are you sure you want to delete ?&#39;);' data-toggle='tooltip' data-placement='top' title='Delete' class='fa fa-trash-o fa-lg'>  
                              </a>
                            </td>
							<?php }} ?>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--begin::Payment-->
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2>College Application Management</h2>
													</div>
													<!--begin::Add user-->
													
											
											<a href="#" data-bs-toggle="modal" data-bs-target="#application_defferal" 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::Add user-->
												</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>Sr No.
                           
                            </th>
							<th>Country
                            </th>
							
							<th>College
                            </th>
							<th>Course</th>
							<th>Application Management Type</th>
                            <th>Steps</th>
                            <th>Status</th>
                            <th>Approval</th>
                            
                            
							<th class="min-w-100px">Addedby</th>
							<th class="min-w-100px">Addedon</th>
							
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
															$i=1;
															$tt1=0;
															$evepay = "select * from res_collegeapp_master,res_collegeappman_master where res_collegeappman_master.clgappmid= res_collegeapp_master.clgappmid and  res_collegeapp_master.stiqmid=".$_GET['id'];
															$repay = mysqli_query($conn, $evepay);
															$i=1;
															while($rtpay = mysqli_fetch_assoc($repay))
															{
															$clgappmid=$rtpay['clgappmid'];
															$imid=$rtpay['imid'];
															$clgamid=$rtpay['clgamid'];
															
															
								
								
								$coursemid=$rtpay['coursemid'];
										
								$collegemid=$rtpay['collegemid'];
								$countrymid=$rtpay['countrymid'];
								$camdid=$rtpay['camdid'];
								$clgstatus=$rtpay['clgstatus'];
								
								
								$stepdetail = ' <a href="#" data-bs-toggle="modal" data-bs-target="#view-modal3" class="fa fa-edit"  data-id="'.$clgamid.'" id="getUser3"></a>';
								
								
								
								 $eve13 = "select count(*) as a1 from res_collegedefferalsteps_detail where camdid = $camdid";
								$re13 = mysqli_query($conn, $eve13);
								$totalsteps=0;
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									  $totalsteps=$rt13['a1'];
								}
								
								 $eve13 = "select count(*) as a2 from res_collegeappmanstep_detail where clgamid in (select clgamid from res_collegeappman_master where camdid=$camdid and clgamid=$clgamid and clgappmid in (select clgappmid from res_collegeapp_master where clgappmid=$clgappmid)) ";
								$re13 = mysqli_query($conn, $eve13);
								$totalcsteps=0;
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									  $totalcsteps=$rt13['a2'];
								}
								
								if($totalcsteps < $totalsteps)
								{
									$dstatus = 'Pending';
								}else{
									$dstatus = 'Process Completed ';
									
								
								}
								
								 $eve24 = "select clgamid from res_clgdefapp_master where clgamid=$clgamid ";
									$re24 = mysqli_query($conn, $eve24);
								if(mysqli_num_rows($re24) > 0 or $clgstatus == 'Rejected')
								{
									$ar = $clgstatus;
								}else{
								
									$approval = ' <a href="#" data-bs-toggle="modal" data-bs-target="#view-modal12" class="btn btn-primary"  data-id="'.$clgamid.'" id="getUser12"> Approve</a>';
									$reject = " <a href='clgdefstreject.php?id=$clgamid&stiqmid=$stiqmid' class='btn btn-danger'  > Reject</a>";
									$ar = $approval." ".$reject;
								} 
								
								
								
								
								
								$eve13 = "select * from res_collegeappmanagement_detail,res_collegeappliacation_master where res_collegeappliacation_master.collegeappliacationmid = res_collegeappmanagement_detail.collegeapplicationmid and res_collegeappmanagement_detail.camdid = $camdid";
								$re13 = mysqli_query($conn, $eve13);
								$collegeappliacationname="";
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									$collegeappliacationname=$rt13['collegeappliacationname'];
								}
								
								$eve13 = "select * from res_coursename_master where cnmid in(select cnmid from res_course_master where coursemid=$coursemid)";
								$re13 = mysqli_query($conn, $eve13);
								$coursename="";
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									$coursename=$rt13['coursename'];
								}	
								
								$eve14 = "select * from res_college_master where collegemid=$collegemid";
								$re14 = mysqli_query($conn, $eve14);
								$cmname="";
								while($rt14 = mysqli_fetch_assoc($re14))
								{
									$cmname=$rt14['cmname'];
								}	
								
								$eve15 = "select * from res_country_master where countrymid=$countrymid";
								$re15 = mysqli_query($conn, $eve15);
								$countryname="";
								while($rt15 = mysqli_fetch_assoc($re15))
								{
									$countryname=$rt15['countryname'];
								}
								
								$capaddedon='';	
														$capaddedon=date("d-m-Y",strtotime($rtpay['clgmupdatedon']));
														$capaddedby=$rtpay['clgmaddedby'];

														$ufullname='';
														$utype='';
														$evea1 = "select ufullname,utype from res_user_master where umid=$capaddedby";
														$rea1 = mysqli_query($conn, $evea1);
														if(mysqli_num_rows($rea1) > 0)
														{
														while($rta1 = mysqli_fetch_assoc($rea1))
														{
															$ufullname=$rta1['ufullname'];
															$utype=$rta1['utype'];
														}
														}
														
														
									
															?>
																<tr>
																	
																	 <td>
                              <?php echo $i++;?>
                            </td>
							
																	<td><?php echo $countryname; ?></td>
                            
							<td>
                              <?php echo $cmname;?>
                            </td> 
							<td>
                              <?php echo $coursename;?>
                            </td>
							<td>
                              <?php echo $collegeappliacationname;?>
                            </td>
                           <td>
                              <?php echo $stepdetail;?>
                            </td>
                            <td>
                              <?php echo $dstatus;?>
                            </td>
                           <td>
                              <?php echo $ar;?>
                            </td>
                           
                           
							<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $capaddedon; ?></td>
							<?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                           
							<?php }} ?>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Payment-->
											
					<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2> Application Fees</h2>
													</div>
													
												</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"> Purpose</th>
																	<th class="min-w-175px">Fees </th>
																	<th class="min-w-175px">Offer Discount </th>
																	<th class="min-w-175px">Final fees </th>
																	<th class="min-w-175px">Recevied Amount </th>
																	<th class="min-w-175px">Pending Amount </th><th class="min-w-175px">Transcation Detail </th>
																	<th class="min-w-100px">Addedby</th>
									<th class="min-w-100px">Addedon</th>
							 
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
															$i=1;
								$totalfinalrate=0;	
								$totalreceviedamt=0;	
								$totalpendingamount=0;	
							$eve1 = "select * from res_inquiryservice_detail where stiqmid=".$_GET['id'];
							$re1 = mysqli_query($conn, $eve1);
							while($rt1 = mysqli_fetch_assoc($re1))
							{
								
								
								$isdid=$rt1['isdid'];									
								$ptype=$rt1['ptype'];
$packagename='';
								if($ptype == 'Branch' || $ptype == 'Country')
								{
									$packagemid=$rt1['packagemid'];
									 $evea3 = "select packagename from res_package_master where packagemid=$packagemid";
									$rea3 = mysqli_query($conn, $evea3);
									if(mysqli_num_rows($rea3) > 0)
									{
									while($rta3 = mysqli_fetch_assoc($rea3))
									{
										$packagename=$rta3['packagename'];
										
									}
									}
								}else if($ptype == 'Application'){
									$clgappmid=$rt1['linkmid'];
									$eve23 = "select * from res_course_master,res_collegeapp_master where res_collegeapp_master.coursemid = res_course_master.coursemid  and  res_collegeapp_master.imid=$imid and  res_collegeapp_master.clgappmid=$clgappmid";

									$re23 = mysqli_query($conn, $eve23);

									while($rt23 = mysqli_fetch_assoc($re23))

									{

									$collegemid=$rt23['collegemid'];
									$collegemid=$rt23['collegemid'];
									$cnmid=$rt23['cnmid'];
									$clgappmid=$rt23['clgappmid'];
									$coursename="";
					$eve55= "select * from   res_coursename_master where cnmid=$cnmid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$coursename=$rt55['coursename'];
						
					}
						$eve55= "select * from   res_college_master where collegemid=$collegemid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$cmname=$rt55['cmname'];
						
					}
									

								}
								$packagename = $cmname."-".$coursename." application";
								}else if($ptype == 'Book Lost'){
									$bookmid=$rt1['linkmid'];
									$eve78 = "select bookname,bookprice from res_book_master where  bookmid=$bookmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$bookname=$rt78['bookname'];
											
											
										}
									}
									$packagename = $bookname." Lost";
								}else if($ptype == 'College Admission'){
									$admid=$rt1['linkmid'];
										$eve23 = "select * from res_course_master,res_admission_master where res_admission_master.coursemid = res_course_master.coursemid  and  res_admission_master.imid=$imid and  res_admission_master.admid=$admid";

									$re23 = mysqli_query($conn, $eve23);

									while($rt23 = mysqli_fetch_assoc($re23))

									{

									$collegemid=$rt23['collegemid'];
									$collegemid=$rt23['collegemid'];
									$cnmid=$rt23['cnmid'];
									$admid=$rt23['admid'];
									$coursename="";
					$eve55= "select * from   res_coursename_master where cnmid=$cnmid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$coursename=$rt55['coursename'];
						
					}
						$eve55= "select * from   res_college_master where collegemid=$collegemid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$cmname=$rt55['cmname'];
						
					}
									

								}
								$packagename = $cmname."-".$coursename." Admission";
								}
								$packagefees=$rt1['packagefees'];									
								$serviceoffer=$rt1['serviceoffer'];									
								$servicefinalrate=$rt1['servicefinalrate'];	
								$totalfinalrate = $totalfinalrate + $servicefinalrate;
								
								
								$stiqmid=$rt1['stiqmid'];
								$ispurpose=$rt1['ispurpose'];
								$isreceviedamt=$rt1['isreceviedamt'];
								$totalreceviedamt = $totalreceviedamt + $isreceviedamt;
								$ispendingamount=$rt1['ispendingamount'];
								$ispendingamount = number_format($ispendingamount, "2");
								$totalpendingamount = (float)$totalpendingamount + (float)$ispendingamount;
								$totalpendingamount = number_format($totalpendingamount, "2");
									$isaddedon=date("d-m-Y",strtotime($rt1['isaddedon']));
$isaddedby=$rt1['isaddedby'];

$ufullname='';
$utype='';
 


$evea2 = "select ufullname,utype from res_user_master where umid=$isaddedby";
$rea2 = mysqli_query($conn, $evea2);
if(mysqli_num_rows($rea2) > 0)
{
	while($rta2 = mysqli_fetch_assoc($rea2))
	{
		$ufullname=$rta2['ufullname'];
		$utype=$rta2['utype'];
	}
}
									
									
									$siprefferservice='';
									$inquirydate='';
									$eve78 = "select siprefferservice,inquirydate from res_studentinquiry_detail where imid=$imid and stiqmid=$stiqmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$siprefferservice=$rt78['siprefferservice'];
											$inquirydate=date("d-m-Y",strtotime($rt78['inquirydate']));
										}
									}
									
									
									$transcationdetail = '<a href="#" data-bs-toggle="modal" data-bs-target="#view-modal5" "  data-id="'.$rt1['isdid'].'" id="getUser5" class="fa fa-eye"></a>';
															?>
																<tr>
																	
																	<td><?php echo $packagename; ?></td>
																	
																	<td><?php echo $packagefees; ?></td>
																	<td><?php echo $serviceoffer; ?></td>
																	<td><?php echo $servicefinalrate; ?></td>
																	<td><?php echo $isreceviedamt; ?></td>
																	<td><?php echo $ispendingamount; ?></td>
																	<td><?php echo $transcationdetail; ?></td>
																	<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $isaddedon; ?></td>
																	
																	
																	
																</tr>
															<?php } ?>
															<tr>
															
															<td></td>
															<td></td>
															<th>Total:</th>
															<td><?php echo $totalfinalrate; ?></td>
															<td><?php echo $totalreceviedamt; ?></td>
															<td><?php echo $totalpendingamount; ?></td>
															<td></td>
															<td></td>
															<td></td>
															</tr>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::Payment-->
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2>College Admission</h2>
													</div>
													<!--begin::Add user-->
													<?php
													 $eve34="SELECT * FROM res_admission_master where stiqmid=".$_GET['id'] ;
													$re34 = mysqli_query($conn, $eve34);

													if(mysqli_num_rows($re34) > 0)
													{
														/* while($rt34 = mysqli_fetch_assoc($re34))
														{
															$campusmid=$rt34['campusmid'];
															$admid=$rt34['admid'];
															
															$eve123 = "select count(*) as cc1 from res_admissionintake_detail where admid=$admid";
															$re123 = mysqli_query($conn, $eve123);
															if(mysqli_num_rows($re123) > 0)
													{
														while($rt123 = mysqli_fetch_assoc($re123))
														{
															$intakecount = $rt123['cc1'];
														}
													}
													$termsclaimable=0;
													$eve123 = "select termsclaimable from res_commission_master where campusmid=$campusmid";
															$re123 = mysqli_query($conn, $eve123);
															if(mysqli_num_rows($re123) > 0)
													{
														while($rt123 = mysqli_fetch_assoc($re123))
														{
															$termsclaimable = $rt123['termsclaimable'];
														}
													}
													
													if($intakecount  <= $termsclaimable)
													{ */
													
														?>
														
											<?php
													/* }
													} */
													}else{
													
													?>
											<a href="#" data-bs-toggle="modal" data-bs-target="#student_add_admission_process" 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>
													<?php
													}
													?>
										
											<!--end::Add user-->
												</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>Sr No.
                          
                            </th>
							<th>Student Id
                            </th>
							<th>Country
                            </th>
							
							<th>College
                            </th>
							<th>Program
                            </th>
                            <th>Remark
                            </th>
                            <th>Program Fees
                            </th>
                            <th>Status
                            </th>
							
                            <th>Intake Details
                            </th>
                            <th>Admission Date
                            </th>
							<th class="min-w-100px">Addedby</th>
<th class="min-w-100px">Addedon</th>
							 <?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                            <th>Operation
                            </th>
							 <?php }} ?>
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
															$i=1;
															$tt1=0;
															$evepay = "select * from res_admission_master where stiqmid=".$_GET['id'];
															$repay = mysqli_query($conn, $evepay);
															$i=1;
															while($rtpay = mysqli_fetch_assoc($repay))
															{
															$admid=$rtpay['admid'];
															$imid=$rtpay['imid'];
															$astudentid=$rtpay['astudentid'];
															$intaketerm=$rtpay['intaketerm'];
															$coursefees=$rtpay['ccoursefees'];
								$statusmid=$rtpay['statusmid'];
								$stiqmid=$rtpay['stiqmid'];
								$siprefferservice='';
									$inquirydate='';
									$eve78 = "select siprefferservice,inquirydate from res_studentinquiry_detail where imid=$imid and stiqmid=$stiqmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$siprefferservice=$rt78['siprefferservice'];
											$inquirydate=date("d-m-Y",strtotime($rt78['inquirydate']));
										}
									}
								$coursemid=$rtpay['coursemid'];
								$statusmid=$rtpay['statusmid'];
								$statusname='';
								$eve_main = "select * from res_status_master where statusmid = $statusmid";
						$re_main = mysqli_query($conn, $eve_main);
						if(mysqli_num_rows($re_main) > 0)
						{
						while($rt_main = mysqli_fetch_assoc($re_main))
						{

							
							$statusname=$rt_main['statusname'];
						}
						}
							
								$status2 = ' <a href="#" data-bs-toggle="modal" data-bs-target="#view-modal11" class="fa fa-edit"  data-id="'.$admid.'" id="getUser11">
												</a>';
								$capstatus=$statusname." ".$status2;			
								$collegemid=$rtpay['collegemid'];
								$countrymid=$rtpay['countrymid'];
								$coremarks=$rtpay['ccoremarks'];
								$intekmonth=$rtpay['intekmonth'];
								$intekyear=$rtpay['intekyear'];
								$intake = $intekmonth.",".$intekyear;
								$doapplication=date("d-m-Y", strtotime($rtpay['adoapplication']));
								
								
								
								
								$eve13 = "select * from res_coursename_master where cnmid in(select cnmid from res_course_master where coursemid=$coursemid)";
								$re13 = mysqli_query($conn, $eve13);
								$coursename="";
								while($rt13 = mysqli_fetch_assoc($re13))
								{
									$coursename=$rt13['coursename'];
								}	
								
								$eve14 = "select * from res_college_master where collegemid=$collegemid";
								$re14 = mysqli_query($conn, $eve14);
								$cmname="";
								while($rt14 = mysqli_fetch_assoc($re14))
								{
									$cmname=$rt14['cmname'];
								}	
								
								$eve15 = "select * from res_country_master where countrymid=$countrymid";
								$re15 = mysqli_query($conn, $eve15);
								$countryname="";
								while($rt15 = mysqli_fetch_assoc($re15))
								{
									$countryname=$rt15['countryname'];
								}
								
								$capaddedon='';	
														$capaddedon=date("d-m-Y",strtotime($rtpay['amaddedon']));
														$capaddedby=$rtpay['amaddedby'];

														$ufullname='';
														$utype='';
														$evea1 = "select ufullname,utype from res_user_master where umid=$capaddedby";
														$rea1 = mysqli_query($conn, $evea1);
														if(mysqli_num_rows($rea1) > 0)
														{
														while($rta1 = mysqli_fetch_assoc($rea1))
														{
															$ufullname=$rta1['ufullname'];
															$utype=$rta1['utype'];
														}
														}
														
														
															$termdetail = '<a href="#" data-bs-toggle="modal" data-bs-target="#view-modal8" "  data-id="'.$rtpay['admid'].'" id="getUser8" class="fa fa-eye"></a>';
															?>
																<tr>
																	
																	 <td>
                              <?php echo $i++;?>
                            </td>
							
                            
							<td>
                              <?php echo $astudentid;?>
                            </td><td>
                              <?php echo $countryname;?>
                            </td> <td>
                              <?php echo $cmname;?>
                            </td> 
							<td>
                              <?php echo $coursename;?>
                            </td>
							<td>
                              <?php echo $coremarks;?>
                            </td>
                            <td>
                              <?php echo $coursefees;?>
                            </td>
                            <td>
                              <?php echo $capstatus;?>
                            </td>
                           
                             <td>
                              <?php echo $termdetail;?>
                            </td>
                            <td>
                              <?php echo $doapplication;?>
                            </td>
                           
							<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $capaddedon; ?></td>
							<?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                            <td>
                              <a  href="clgapplicationdelete.php?id=<?php echo $rtpay['admid']; ?>&&p3=<?php echo $_GET['id'];?>" onclick='return confirm(&#39;Are you sure you want to delete ?&#39;);' data-toggle='tooltip' data-placement='top' title='Delete' class='fa fa-trash-o fa-lg'>  
                              </a>
                            </td>
							<?php }} ?>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
					
					<?php } ?>
											<!--begin::GIC Process-->
											<?php
													$eve23 = "select * from res_inquirymoduleallocation_detail where countrymid = $siprefferedcountry and subservicemid=$siprefferedsubservice and blockname='Guaranteed Investment Certificate Process'";
											$re23 = mysqli_query($conn, $eve23);
	
				if(mysqli_num_rows($re23)>0 )
					{
						?>
											<div class="card card-flush py-4 flex-row-fluid">
												<!--begin::Card header-->
												<div class="card-header">
													<div class="card-title text-uppercase">
														<h2>Guaranteed Investment Certificate Process</h2>
													</div>
													<!--begin::Add user-->
											<?php
														if( $_SESSION['utype']=='counseller' || $_SESSION['utype'] == 'admin' || $_SESSION['utype']=='branchmanager' || $_SESSION['utype'] == 'applicationmanager')
										{
											?>		
											<a href="#" data-bs-toggle="modal" data-bs-target="#student_add_gic_process" 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>
										<?php } ?>
											<!--end::Add user-->
												</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>Sr No.
                            </th>
                           
							<th>Bank Name
                            </th>
							
							<th>Create Date
                            </th>
							<th>Wire Transfer
                            </th>
                            <th>Payment Value
                            </th>
                            <th>Certificate Status
                            </th>
                           
							<th class="min-w-100px">Addedby</th>
<th class="min-w-100px">Addedon</th><th class="min-w-100px">Refund</th>
							 <?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                            <th>Operation
                            </th>
							 <?php }} ?>
																	
																	
																</tr>
															</thead>
															<!--end::Table head-->
															<!--begin::Table body-->
															<tbody class="fw-semibold text-gray-600">
															<?php
															$i=1;
															$tt1=0;
															$evepay = "select * from res_gicprocess_master where stiqmid=".$_GET['id'];
															$repay = mysqli_query($conn, $evepay);
															$i=1;
															while($rtpay = mysqli_fetch_assoc($repay))
															{
															$gicmid=$rtpay['gicmid'];
															$gicbankname=$rtpay['gicbankname'];
								$gwiretransfer=$rtpay['gwiretransfer'];
								$gpaymentvalue=$rtpay['gpaymentvalue'];
								$gcertificatestatus=$rtpay['gcertificatestatus'];
								$stiqmid=$rtpay['stiqmid'];
								$siprefferservice='';
									$inquirydate='';
									$eve78 = "select siprefferservice,inquirydate from res_studentinquiry_detail where imid=$imid and stiqmid=$stiqmid";
									$re78 = mysqli_query($conn, $eve78);
									if(mysqli_num_rows($re78) > 0)
									{
										while($rt78 = mysqli_fetch_assoc($re78))
										{
											$siprefferservice=$rt78['siprefferservice'];
											$inquirydate=date("d-m-Y",strtotime($rt78['inquirydate']));
										}
									}
								
								$evee = "select gicmid from res_gicrefund_detail where gicmid=$gicmid";
								$ree = mysqli_query($conn, $evee);
									if(mysqli_num_rows($ree) > 0)
									{
										$refund = 'Refunded';
									}else{
								
								$refund = ' <a href="#" data-bs-toggle="modal" data-bs-target="#view-modal9"   data-id="'.$gicmid.'" id="getUser9">
												Refund</a>';
									}
									
								
								
								$capaddedon='';	
														$capaddedon=date("d-m-Y",strtotime($rtpay['gaddedon']));
														$gcreatedate=date("d-m-Y",strtotime($rtpay['gcreatedate']));
														$capaddedby=$rtpay['gaddedby'];

														$ufullname='';
														$utype='';
														$evea1 = "select ufullname,utype from res_user_master where umid=$capaddedby";
														$rea1 = mysqli_query($conn, $evea1);
														if(mysqli_num_rows($rea1) > 0)
														{
														while($rta1 = mysqli_fetch_assoc($rea1))
														{
															$ufullname=$rta1['ufullname'];
															$utype=$rta1['utype'];
														}
														}
															?>
																<tr>
																	
																	 <td>
                              <?php echo $i++;?>
                            </td>
							
																	
                            
							<td>
                              <?php echo $gicbankname;?>
                            </td> 
							<td>
                              <?php echo $gcreatedate;?>
                            </td>
							<td>
                              <?php echo $gwiretransfer;?>
                            </td>
                            <td>
                              <?php echo $gpaymentvalue;?>
                            </td>
                            <td>
                              <?php echo $gcertificatestatus;?>
                            </td>
                          
                           
							<td><?php echo $ufullname." (".$utype.")"; ?></td>
<td><?php echo $capaddedon; ?></td><td><?php echo $refund; ?></td>
							<?php if($_SESSION['utype']!='agent'){
							if($_SESSION['utype']!='receptionist'){?>
                            <td>
                              <a  href="clgapplicationdelete.php?id=<?php echo $rtpay['gicmid']; ?>&&p3=<?php echo $_GET['id'];?>" onclick='return confirm(&#39;Are you sure you want to delete ?&#39;);' data-toggle='tooltip' data-placement='top' title='Delete' class='fa fa-trash-o fa-lg'>  
                              </a>
                            </td>
							<?php }} ?>
																	
																</tr>
															<?php } ?>
																</tbody>
															<!--end::Table head-->
														</table>
														<!--end::Table-->
													</div>
												</div>
												<!--end::Card body-->
											</div>
											<!--end::GIC Process-->
					<?php } ?>
											<!--begin::Medical Appointment-->
											
											
											</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-->
					<!--end::Modal - Student Course-->
						<!--begin::Modal - Student College Application-->
							<div class="modal fade" id="student_add_college_application" 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 College Application</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="clgapplication.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--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"> Course</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="coursemid" id="coursemid1">
																	<option value="0">Select</option>
													<?php 
																			 $eve_main = "select * from res_counselling_detail where coursemid not in (select coursemid from res_collegeapp_master where  stiqmid = ".$_GET['id'].") and   stiqmid = ".$_GET['id'];
										$re_main = mysqli_query($conn, $eve_main);
										while($rt_main = mysqli_fetch_assoc($re_main))
										{

											$coursemid=$rt_main['coursemid'];
											$eve22 = "select countryname,cmname,coursename from res_course_master,res_college_master,res_country_master,res_coursename_master where res_course_master.coursemid=$coursemid and  res_college_master.collegemid = res_course_master.collegemid and  res_country_master.countrymid = res_course_master.countrymid and  res_coursename_master.cnmid = res_course_master.cnmid";
											$re22 = mysqli_query($conn, $eve22);
											while($rt22 = mysqli_fetch_assoc($re22))
										{
											$countryname = $rt22['countryname'];
											$cmname = $rt22['cmname'];
											$coursename = $rt22['coursename'];
										}
												echo "<option value='$coursemid' >$countryname - $cmname - $coursename </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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2">Remarks </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<input type="text" name="coremarks" id="coremarks"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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="required fw-semibold fs-6 mb-2">Course Fees </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="coursefees" id="cgrosstutionfess2"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" required>
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Status </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid fw-bold" data-control="select2"   name="capstatus" id="status12">
																	<option value="0">Select</option>
																	<?php
						$eve_main = "select * from res_status_master where statustype = 'College Application'";
						$re_main = mysqli_query($conn, $eve_main);
						while($rt_main = mysqli_fetch_assoc($re_main))
						{

							$statusmid=$rt_main['statusmid'];
							$statusname=$rt_main['statusname'];
							
								echo "<option value='$statusname' >$statusname</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="required fw-semibold fs-6 mb-2">Inquiry Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="doapplication" id="kt_daterangepicker_11"/>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div>
												<!--end::Row-->
												<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2">
											<!--begin::Col-->
													<div class="col">
														<!--begin::Input group-->
														<div class="fv-row mb-7">
															<!--begin::Label-->
															<label class="fs-6 fw-semibold form-label mt-3">
																<span class="required">Intake Month </span>
																
															</label>
															<!--end::Label-->
															<!--begin::Input-->
															
															<select class="form-select form-select-solid fw-bold" data-control="select2"  name="cintakemonth" id="citdid">
														<option value="0">Select<option>
														</select>
												
															<!--end::Input-->
														</div>
														<!--end::Input group-->
													</div>
													<!--end::Col-->
													<!--begin::Col-->
													<div class="col">
														<!--begin::Input group-->
														<div class="fv-row mb-7">
															<!--begin::Label-->
															<label class="fs-6 fw-semibold form-label mt-3">
																<span class="required">Intake Year </span>
																
															</label>
															<!--end::Label-->
															<!--begin::Input-->
															
															<select class="form-select form-select-solid fw-bold" data-control="select2"   name="cintakeyear">
														<?php
														for($i= 2022;$i<2040; $i++)
														{
															echo "<option value='$i' >$i </option>";
														}
														?>
														</select>
												
															<!--end::Input-->
														</div>
														<!--end::Input group-->
													</div>
													<!--end::Col-->
													
													
												</div>
												<!--end::Row-->
												<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Application Number </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="cappnumber" id="cappnumber"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" required>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
											
																			
															<!--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 College Application-->
						<!--begin::Modal - Student College Application-->
							<div class="modal fade" id="student_add_intake" 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>Next Term Intake</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="clgadmissionintake.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
											
													<div class="col">
														<!--begin::Input group-->
														<div class="fv-row mb-7">
															<!--begin::Label-->
															<label class="fs-6 fw-semibold form-label mt-3">
																<span class="required">Intake Term </span>
																
															</label>
															<!--end::Label-->
															<!--begin::Input-->
															
															<select class="form-select form-select-solid fw-bold" data-kt-select2="true" data-placeholder="Select option" data-allow-clear="true" data-kt-user-table-filter="role"  name="citdid" id="citdid2">
														<option value="0">Select<option>
														<?php
														 $eve99="SELECT * FROM res_courseintaketerm_detail where  coursemid in (select coursemid from res_admission_master where stiqmid =" .$_GET['id'].")	 ";
	$re99 = mysqli_query($conn, $eve99);

	{
		echo '<option value="0">Select</option>';
		
		
        while($rt99 = mysqli_fetch_assoc($re99))
		{
			/* $coursemid=$rt['coursemid'];
			$_SESSION['selectedcourse']=$coursemid; */
			$ctermmonth=$rt99['ctermmonth'];
			
			$ctermyear=$rt99['ctermyear'];
			
			$citdid =$rt99['citdid'];
			if(isset($_SESSION['citdid']) && $_SESSION['citdid']== $citdid )
			{
			
            echo '<option value="'.$citdid.'" selected>'.$ctermmonth.','.$ctermyear.'</option>';
			}else{
				 echo '<option value="'.$citdid.'" >'.$ctermmonth.','.$ctermyear.'</option>';
			}
        }
    }
	?>
														</select>
												
															<!--end::Input-->
														</div>
														<!--end::Input group-->
													</div>
													<!--end::Col-->
													
													
												</div>
												<!--end::Row-->
											
																			
														
													
												<!--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 College Application--><!--begin::Modal - Student College Application-->
							<div class="modal fade" id="student_add_admission_process" 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>Admission Process</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_form12" class="form" action="clgadmission.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--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"> College Application</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2" data-dropdown-parent="#kt_modal_add_user_form12"   name="coursemid" id="coursemid3">
																	<option value="0">Select</option>
													<?php 
																			 $eve_main = "select * from res_collegeapp_master where ( clgappmid in (select linkmid from res_inquiryservice_detail where ispendingamount < 1 and ptype='Application' or servicepayamount < 1 and stiqmid = ".$_GET['id'].") or coursefees=0)and capstatus in ('Conditional Offer Received','Unconditional Offer Received')  and stiqmid = ".$_GET['id'];
										$re_main = mysqli_query($conn, $eve_main);
										while($rt_main = mysqli_fetch_assoc($re_main))
										{

											$coursemid=$rt_main['coursemid'];
											 $eve22 = "select countryname,cmname,coursename from res_course_master,res_college_master,res_country_master,res_coursename_master where res_course_master.coursemid=$coursemid and  res_college_master.collegemid = res_course_master.collegemid and  res_country_master.countrymid = res_course_master.countrymid and  res_coursename_master.cnmid = res_course_master.cnmid";
											$re22 = mysqli_query($conn, $eve22);
											while($rt22 = mysqli_fetch_assoc($re22))
										{
											$countryname = $rt22['countryname'];
											$cmname = $rt22['cmname'];
											$coursename = $rt22['coursename'];
										}
												echo "<option value='$coursemid' >$countryname - $cmname - $coursename </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="required fw-semibold fs-6 mb-2">Currency </label>
									<!--end::Label-->
									<!--begin::Input-->
									<input class="form-control form-control-solid fw-bold pe-5" id="pcurrency" name="pcurrency" readonly>
									<!--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">Remarks </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<input type="text" name="ccoremarks" id="ccoremarks"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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="required fw-semibold fs-6 mb-2">Program Fees </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="ccoursefees" id="cgrosstutionfess1"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" required>
																	<!--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="required fw-semibold fs-6 mb-2">Program Fees in INR</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="ccoursefeesinr" id="cgrosstutionfess1inr"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" required>
																	<!--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="required fw-semibold fs-6 mb-2">Status </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2" data-dropdown-parent="#kt_modal_add_user_form12"   name="statusmid" id="status12">
																	<option value="0">Select</option>
																	<?php
						$eve_main = "select * from res_status_master where statustype = 'Admission Process'";
						$re_main = mysqli_query($conn, $eve_main);
						while($rt_main = mysqli_fetch_assoc($re_main))
						{

							$statusmid=$rt_main['statusmid'];
							$statusname=$rt_main['statusname'];
							if($statusmid1==$statusmid)
							{
								echo "<option value='$statusmid' selected>$statusname</option>";
							}
							else
							{
								echo "<option value='$statusmid'>$statusname</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="required fw-semibold fs-6 mb-2">Admission Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="adoapplication" id="kt_daterangepicker_5"/>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Start Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="aprogramstartdate" id="kt_daterangepicker_3"/>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">End Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="aprogramenddate" id="kt_daterangepicker_4"/>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													
													
													
													<div class="col">
														<!--begin::Input group-->
														<div class="fv-row mb-7">
															<!--begin::Label-->
															<label class="fs-6 fw-semibold form-label mt-3">
																<span class="required">Semester </span>
																
															</label>
															<!--end::Label-->
															<!--begin::Input-->
															
															
															<select class="form-select form-select-solid" data-control="select2"  name="asemester" data-dropdown-parent="#kt_modal_add_user_form12"  id="asemester">
															<?php 
															for($i=0;$i<=10;$i++){echo "<option value='$i'>$i</option>";}?>
															<select>
												
															<!--end::Input-->
														</div>
														<!--end::Input group-->
													</div>
													<!--end::Col-->
													</div>
													<!--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" >
														<!--begin::Input group-->
														<div class="fv-row mb-7" >
													<table id="items1" border="0" style="width:100%;">
											<tr>
												<th>Term Start Month </th>
												<th>Term Start Year </th>
												<th>Term fees </th>
												
												</tr>
												<tbody id="term" style="width:100%;"></tbody>
												<input type="hidden" id="mycounter" name="mycounter" value="0">
										</table>
										
												</div>
														<!--end::Input group--->
													</div>
													<!--end::Col-->
													</div>
												
																			
														
											
											
																			
															<!--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 College Application-->
						<!--begin::Modal - Student College Application Fees-->
							<div class="modal fade" id="student_add_college_application_fees" 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 College Application Fees</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_form32" class="form" action="clgapplicationfees.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!--begin::Row-->
									<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2">

									
									
									

									
									<!--end::Col-->
									<!--begin::Col-->
									<div class="col-md-6 fv-row" id="application">
									<!--begin::Input group-->
									<div class="fv-row mb-7">
									<!--begin::Label-->
									<label class="required fw-semibold fs-6 mb-2">College Application </label>
									<!--end::Label-->
									<!--begin::Input-->
									<select class="form-select form-select-solid" data-control="select2" data-dropdown-parent="#kt_modal_add_user_form32"  name="clgappmid" id="clgappmid">
									<option value="0">select</option>
									<?php
									$eve23 = "select * from res_course_master,res_collegeapp_master where res_collegeapp_master.coursemid = res_course_master.coursemid  and  res_collegeapp_master.stiqmid= $stiqmid and  res_collegeapp_master.clgappmid not in (select linkmid from res_inquiryservice_detail where ptype='Application' )";

									$re23 = mysqli_query($conn, $eve23);

									while($rt23 = mysqli_fetch_assoc($re23))

									{

									$collegemid=$rt23['collegemid'];
									$collegemid=$rt23['collegemid'];
									$cnmid=$rt23['cnmid'];
									$clgappmid=$rt23['clgappmid'];
									$coursename="";
					$eve55= "select * from   res_coursename_master where cnmid=$cnmid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$coursename=$rt55['coursename'];
						
					}
						$eve55= "select * from   res_college_master where collegemid=$collegemid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$cmname=$rt55['cmname'];
						
					}
									

									echo "<option value='$clgappmid'>$cmname - $coursename</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="required fw-semibold fs-6 mb-2">Currency </label>
									<!--end::Label-->
									<!--begin::Input-->
									<input class="form-control form-control-solid fw-bold pe-5" id="pcurrency22" name="pcurrency" readonly>
									<!--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-md-6 fv-row">
									<!--begin::Input group-->
									<div class="fv-row mb-7">
									<!--begin::Label-->
									<label class="required fw-semibold fs-6 mb-2">Fees in Currency  </label>
									<!--end::Label-->
									<!--begin::Input-->
									<input class="form-control form-control-solid fw-bold pe-5" id="pcurrencyrate" name="pcurrencyrate" readonly>
									<!--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="required fw-semibold fs-6 mb-2">Fees (INR) </label>
									<!--end::Label-->
									<!--begin::Input-->
									<input class="form-control form-control-solid fw-bold pe-5" id="pcurrencyinr" name="packagefees"  readonly>
									<!--end::Input-->
									</div>
									<!--end::Input group-->
									</div>
									<!--end::Col-->
									</div>
													<!--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="required fw-semibold fs-6 mb-2">Payment Currency</label>
									<!--end::Label-->
									<!--begin::Input-->
									<select class="form-select form-select-solid" data-dropdown-parent="#kt_modal_add_user_form32"  data-control="select2"   name="paycurrency" id="paycurrency" >
									<option value="">Select</option>
													<?php 
																			$eve = "select * from res_currencytoinr_master";

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

																			{											
																				
																				$currencyname=$rt['currencyname'];
																				
																				
																				echo "<option value='$currencyname'>$currencyname </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="required fw-semibold fs-6 mb-2">Payment Amount in Selected Currency</label>
									<!--end::Label-->
									<!--begin::Input-->
									<input class="form-control form-control-solid fw-bold pe-5"  name="paycurrencyvalue" id="paycurrencyvalue22" />
									<!--end::Input-->
									</div>
									<!--end::Input group-->
									</div>
									<!--end::Col-->
									
									</div>
									<!--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="required fw-semibold fs-6 mb-2">Remarks </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<textarea class="form-control form-control-solid fw-bold pe-5"  name="isremark" required></textarea>
																	<!--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 College Application Fees-->
						<!--begin::Modal - GIC Process-->
							<div class="modal fade" id="student_add_gic_process" 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 GIC Process</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="gicprocessadd.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-1 rol-cols-md-1 row-cols-lg-1">
													
													<!--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"> Bank Name</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gicbankname" id="gicbankname"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Username </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gusername" id="gusername"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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="required fw-semibold fs-6 mb-2">Password </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gpassword" id="gpassword"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
										
									
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class=" fw-semibold fs-6 mb-2">Create Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="gcreatedate" id="kt_daterangepicker_14"/>
																	<!--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="required fw-semibold fs-6 mb-2">Wire transfer details</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="gwiretransfer" id="gwiretransfer">
																	<option value="0">Select</option>
																	<option value="Recevied">Recevied</option>
																	<option value="Pending">Pending</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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Wire Trnasfer recevied Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input class="form-control form-control-solid fw-bold pe-5" placeholder="Select date" name="gwiretransferrecevieddate" id="kt_daterangepicker_15"/>
																	<!--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="required fw-semibold fs-6 mb-2">Wire Transfer Document </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="file" name="gwiretransferdocument" id="gwiretransferdocument"  class="form-control form-control-solid fw-bold pe-5"  />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Mode of Payment </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<select class="form-select form-select-solid" data-control="select2"   name="gmodeofpayment" id="gmodeofpayment">
																	<option value="0">Select</option>
																	<option value="Wire Transfer">Wire Transfer</option>
																	<option value="RTGC">RTGC</option>
																	<option value="NEFT">NEFT</option>
																	<option value="Cheque">Cheque</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="required fw-semibold fs-6 mb-2">Amount </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gpaymentvalue" id="gpaymentvalue"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Currency </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<select class="form-select form-select-solid" data-control="select2"   name="gcurrency" id="gcurrency">
																	<option value="0">Select</option>
																	<?php
																	$eve_p = "select * from res_country_master";
																		$re_p = mysqli_query($conn, $eve_p);
																		while($rt_p = mysqli_fetch_assoc($re_p))
																		{
																		echo "<option value='$rt_p[countrycurrency]'>$rt_p[countrycurrency]</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="required fw-semibold fs-6 mb-2">Rate </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="grate" id="grate"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2"> Payment Status </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<select class="form-select form-select-solid" data-control="select2"   name="gpaystatus" id="gpaystatus">
																	<option value="0">Select</option>
																	<option value="Paid">Paid</option>
																	<option value="Pending">Pending</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="required fw-semibold fs-6 mb-2">Payment Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gpaydate" id="kt_daterangepicker_16"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2"> Certificate Status </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<select class="form-select form-select-solfid" data-control="select2"   name="gcertificatestatus" id="gcertificatestatus">
																	<option value="0">Select</option>
																	
																	<option value="Pending">Pending</option>
																	<option value="Recevied">Recevied</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="required fw-semibold fs-6 mb-2">Certificate Recevied Date </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gcertificatereceiveddate" id="kt_daterangepicker_17"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2"> Certificate Document </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	
																	<input type="file" name="gcertificatedocument" id="gcertificatedocument"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--end::Input-->
																	<!--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="required fw-semibold fs-6 mb-2">Transcation Charges </label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="gtranscationcharges" id="gtranscationcharges"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--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 - GIC Process-->
							
						<!--end::Modal - Add task-->
					<!--begin::Modal -collage application Status Update-->
							<div class="modal fade" id="view-modal6" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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="collegeappstatus2.php" method="POST" enctype="multipart/form-data">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content6"></div>
															<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="required fw-semibold fs-6 mb-2">Status</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="capstatus" id="capstatus" >
													<?php
						$eve_main = "select * from res_status_master where statustype = 'College Application'";
						$re_main = mysqli_query($conn, $eve_main);
						while($rt_main = mysqli_fetch_assoc($re_main))
						{

							$statusmid=$rt_main['statusmid'];
							$statusname=$rt_main['statusname'];
							if($statusmid1==$statusmid)
							{
								echo "<option value='$statusname' selected>$statusname</option>";
							}
							else
							{
								echo "<option value='$statusname'>$statusname</option>";
							}

						}
					?>
					</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													<!--begin::Col-->
													</div>
												<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2" id="offer">
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Offer Letter</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="file" name="cofferdocument" id="cofferdocument"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																		<!--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="required fw-semibold fs-6 mb-2">Student Id</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="text" name="cstudentid" id="cstudentid"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																		<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													<!--begin::Col-->
													</div>
													<!--end::Col-->
												

														<!--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 -collage application Status Update-->
						<!--begin::Modal -collage application Status Update-->
							<div class="modal fade" id="view-modal11" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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="collegeadmissionstatus2.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content11"></div>
															<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="required fw-semibold fs-6 mb-2">Status</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"   name="statusmid" >
													<?php
						$eve_main = "select * from res_status_master where statustype = 'Admission Process'";
						$re_main = mysqli_query($conn, $eve_main);
						while($rt_main = mysqli_fetch_assoc($re_main))
						{

							$statusmid=$rt_main['statusmid'];
							$statusname=$rt_main['statusname'];
							if($statusmid1==$statusmid)
							{
								echo "<option value='$statusmid' selected>$statusname</option>";
							}
							else
							{
								echo "<option value='$statusmid'>$statusname</option>";
							}

						}
					?>
					</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													<!--begin::Col-->
													</div>
													<!--end::Col-->
												

														<!--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 -collage application Status Update-->
							<!--begin::Modal - Stage Update-->
							<div class="modal fade" id="view-modal9" role="dialog" aria-labelledby="myModalLabel" 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 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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="gicrefund2.php" method="POST" enctype="multipart/form-data">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content9"></div>
														<!--end::Scroll-->
																				<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-2 rol-cols-md-1 row-cols-lg-2">
													<div class="col">
														<!--begin::Input group-->
														<div class="fv-row mb-7">
															<!--begin::Label-->
															<label class="fs-6 fw-semibold form-label mt-3">
																<span>Reason Of Refund</span>
																
															</label>
															<!--end::Label-->
															<!--begin::Input-->
													<select class="form-select form-select-solid" data-control="select2" name="grreason" id="grreason">
													<option value="0">select</option>
													<option value="Visa refusal">Visa refusal</option>
													<option value="Personal Reason">Personal Reason</option>
													</select>
													<!--end::Input-->
														</div>
														<!--end::Input group-->
													</div>
													
													<!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Refund Status</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2" name="grefundstatus" id="grefundstatus">
													<option value="0">select</option>
													<option value="Refund applied">Refund applied</option>
													<option value="Pending">Pending</option>
													<option value="In Process">In Process</option>
													</select>
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													</div><!--begin::Col-->
													<div class="col-md-6 fv-row">
																<!--begin::Input group-->
																<div class="fv-row mb-7">
																	<!--begin::Label-->
																	<label class="required fw-semibold fs-6 mb-2">Refund Document</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<input type="file" name="vreceiptno" id="vreceiptno"  class="form-control form-control-solid fw-bold pe-5" aria-required="true" aria-invalid="false" aria-describedby="name-error" />
																	<!--end::Input-->
																</div>
																<!--end::Input group-->
																</div>
													<!--end::Col-->
													
											
															<!--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 - Stage Update-->
							<!--begin::Modal - Payment Transcation-->
							<div class="modal fade" id="view-modal5" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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-->
														
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content5"></div>
														<!--end::Scroll-->
													
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Payment Transcation-->
							<!--begin::Modal - Payment Transcation-->
							<div class="modal fade" id="view-modal8" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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-->
														
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content8"></div>
														<!--end::Scroll-->
													
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--begin::Modal - Payment Transcation-->
							<div class="modal fade" id="view-modal3" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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_form31" class="form" action="appstepdetail2.php" method="POST" enctype="multipart/form-data">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content3"></div>
														<!--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-->
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Payment Transcation-->
							<!--begin::Modal - Payment Transcation-->
							<div class="modal fade" id="view-modal12" role="dialog" aria-labelledby="myModalLabel" 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-0 border-0 justify-content-end">
											<!--begin::Close-->
											<div class="btn btn-sm btn-icon btn-active-color-primary" 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_form41" class="form" action="deffcollegeapplication.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--begin::Scroll-->
															<!-- content will be load here -->
															<div id="dynamic-content12"></div>
													
														
														<!--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-->
															<!--end::Actions-->
														</form>
														<!--end::Form-->
													</div>
										<!--end::Modal body-->
									</div>
									<!--end::Modal content-->
								</div>
								<!--end::Modal dialog-->
							</div>
							<!--end::Modal - Payment Transcation-->
							<!--begin::Modal - Student College Application-->
							<div class="modal fade" id="application_defferal" 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>Application Management</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_form56" class="form" action="clgapplicationman.php" method="POST">
														<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
															<!--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"> College Application</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2" data-dropdown-parent="#kt_modal_add_user_form56"  name="clgappmid" id="clgappmid1">
																	<option value="0">Select</option>
													<?php
									$eve23 = "select * from res_course_master,res_collegeapp_master where res_collegeapp_master.coursemid = res_course_master.coursemid  and  res_collegeapp_master.imid= $imid ";

									$re23 = mysqli_query($conn, $eve23);

									while($rt23 = mysqli_fetch_assoc($re23))

									{

									$collegemid=$rt23['collegemid'];
									$collegemid=$rt23['collegemid'];
									$cnmid=$rt23['cnmid'];
									$clgappmid=$rt23['clgappmid'];
									$coursename="";
					$eve55= "select * from   res_coursename_master where cnmid=$cnmid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$coursename=$rt55['coursename'];
						
					}
						$eve55= "select * from   res_college_master where collegemid=$collegemid";
					$re55 = mysqli_query($conn, $eve55);
					 while($rt55 = mysqli_fetch_assoc($re55))
					{
			
						
						$cmname=$rt55['cmname'];
						
					}
									

									echo "<option value='$clgappmid'>$cmname - $coursename</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"> Application Type</label>
																	<!--end::Label-->
																	<!--begin::Input-->
																	<select class="form-select form-select-solid" data-control="select2"  data-dropdown-parent="#kt_modal_add_user_form56" name="camdid" id="camdid">
													<option value="0">Select</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">
												<!--begin::Input group-->
												<div class="fv-row mb-7">
													<!--begin::Label-->
													<label class="fs-6 fw-semibold form-label mt-3">
														<span class="">Start Date</span>
														
													</label>
													<!--end::Label-->
													<!--begin::Input-->
													<input type="text" class="form-control form-control-solid" name="camstartdate" value="" id="camstartdate" readonly>
													<!--end::Input-->
												</div>
												<!--end::Input group-->
												</div>
												
												<!--begin::Col-->
													<div class="col">
													
												<!--begin::Input group-->
												<div class="fv-row mb-7">
													<!--begin::Label-->
													<label class="fs-6 fw-semibold form-label mt-3">
														<span class="">End Date</span>
														
													</label>
													<!--end::Label-->
													<!--begin::Input-->
													<input type="text" class="form-control form-control-solid" name="camdeadline" value="" id="camdeadline" readonly>
													<!--end::Input-->
												</div>
												<!--end::Input group-->
												</div>
												</div>
													<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-1 rol-cols-md-1 row-cols-lg-1">
													<!--begin::Col-->
												<!--begin::Col-->
													<div class="col">
												<!--begin::Input group-->
												<div class="fv-row mb-7">
													<!--begin::Label-->
													<label class="fs-6 fw-semibold form-label mt-3">
														<span class="">Specific Condition </span>
														
													</label>
													<!--end::Label-->
													<!--begin::Input-->
													<textarea type="text" class="form-control form-control-solid" name="camcondition" id="camcondition" value="" readonly></textarea>
													<!--end::Input-->
												</div>
												<!--end::Input group-->
												</div>
												<!--begin::Col-->
													<div class="col">
												<!--begin::Input group-->
												<div class="fv-row mb-7">
													<!--begin::Label-->
													<label class="fs-6 fw-semibold form-label mt-3">
														<span class="">Process Detail</span>
														
													</label>
													<!--end::Label-->
													<!--begin::Input-->
													<textarea type="text" class="form-control form-control-solid" name="camprocessdetail" id="camprocessdetail" value="" readonly></textarea>
													<!--end::Input-->
												</div>
												<!--end::Input group-->
												</div>
												
												</div>
															
														<!--begin::Row-->
												<div class="row row-cols-1 row-cols-sm-1 rol-cols-md-1 row-cols-lg-1" id="steps">
													<!--begin::Col-->
												
												</div>
															
															<!--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 College Application-->
						
						<!--begin::Chat drawer-->
		<div id="kt_drawer_chat" class="bg-body <?php if(isset($_GET['chat'])){ echo 'drawer-on'; }?>" data-kt-drawer="true" data-kt-drawer-name="chat" data-kt-drawer-activate="true" data-kt-drawer-overlay="true" data-kt-drawer-width="{default:'300px', 'md': '500px'}" data-kt-drawer-direction="end" data-kt-drawer-toggle="#kt_drawer_chat_toggle" data-kt-drawer-close="#kt_drawer_chat_close">
			<!--begin::Messenger-->
			<div class="card w-100 rounded-0 border-0" id="kt_drawer_chat_messenger">
				<!--begin::Card header-->
				<div class="card-header pe-5" id="kt_drawer_chat_messenger_header">
					<!--begin::Title-->
					<div class="card-title">
						<!--begin::User-->
						<div class="d-flex justify-content-center flex-column me-3">
							<a href="#" class="fs-4 fw-bold text-gray-900 text-hover-primary me-1 mb-2 lh-1"><?php echo $ipname; ?></a>
							<!--begin::Info-->
							<div class="mb-0 lh-1">
								<span class="badge badge-success badge-circle w-10px h-10px me-1"></span>
								<span class="fs-7 fw-semibold text-muted">Active</span>
							</div>
							<!--end::Info-->
						</div>
						<!--end::User-->
					</div>
					<!--end::Title-->
					<!--begin::Card toolbar-->
					<div class="card-toolbar">
						<!--begin::Close-->
						<div class="btn btn-sm btn-icon btn-active-light-primary" id="kt_drawer_chat_close">
							<!--begin::Svg Icon | path: icons/duotune/arrows/arr061.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">
									<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>
					<!--end::Card toolbar-->
				
					</div>
				<!--end::Card header-->
				<!--begin::Card body-->
				<div class="card-body" id="kt_drawer_chat_messenger_body">
					<!--begin::Messages-->
					<div class="scroll-y me-n5 pe-5" data-kt-element="messages" data-kt-scroll="true" data-kt-scroll-activate="true" data-kt-scroll-height="auto" data-kt-scroll-dependencies="#kt_drawer_chat_messenger_header, #kt_drawer_chat_messenger_footer" data-kt-scroll-wrappers="#kt_drawer_chat_messenger_body" data-kt-scroll-offset="0px">
					
					<?php 
						$eve98 = "select * from res_chat_detail where imid=$imid ";
						$re98 = mysqli_query($conn, $eve98);
						if(mysqli_num_rows($re98) > 0)
						{
			while($rt98 = mysqli_fetch_assoc($re98))
			{
				$cdmsg = $rt98['cdmsg'];
				$caddedon = date("d-m H:i",strtotime($rt98['caddedon']));
				$ctype = $rt98['ctype'];
				$cdaddedby = $rt98['cdaddedby'];
				$imid = $rt98['imid'];
				$uimage='';
				$chatname='';
				if($ctype == 'Staff')
				{
				$eveag = "select ufullname,utype,uimage from res_user_master where umid=$cdaddedby";
				$reag = mysqli_query($conn, $eveag);
				if(mysqli_num_rows($reag) > 0)
				{
					while($rtag = mysqli_fetch_assoc($reag))
					{
						$chatname=$rtag['ufullname'];
						$utype=$rtag['utype'];
						$uimage=$rtag['uimage'];
						
						if(strlen($uimage)>3)
				{
					$uimage="<img src='docs/$uimage' width='80px' height='80px'>";
				}
					}
				}
				}else{
					$eveag = "select ipname from res_inquiry_master where imid=$cdaddedby";
				$reag = mysqli_query($conn, $eveag);
				if(mysqli_num_rows($reag) > 0)
				{
					while($rtag = mysqli_fetch_assoc($reag))
					{
						$chatname=$rtag['ipname'];
						
					}
				}
				}
				
					?>
						<!--begin::Message(in)-->
						<div class="d-flex justify-content-<?php if($ctype == 'Staff')
				{ echo 'end'; }else{ echo 'start'; } ?> mb-10">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-<?php if($ctype == 'Staff')
				{ echo 'end'; }else{ echo 'start'; } ?>">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<?php echo $uimage; ?>
									</div>
									<!--end::Avatar-->
									<!--begin::Details-->
									<div class="ms-3">
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary me-1"><?php echo $chatname; ?></a>
										<span class="text-muted fs-7 mb-1"><?php echo $caddedon; ?></span>
									</div>
									<!--end::Details-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-<?php if($ctype == 'Staff')
				{ echo 'primary'; }else{ echo 'info'; } ?> text-dark fw-semibold mw-lg-400px text-<?php if($ctype == 'Staff')
				{ echo 'end'; }else{ echo 'start'; } ?>" data-kt-element="message-text"><?php echo $cdmsg; ?></div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(in)-->
						<?php } } ?>
						<!--begin::Message(template for out)-->
						<div class="d-flex justify-content-end mb-10 d-none" data-kt-element="template-out">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-end">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Details-->
									<div class="me-3">
										<span class="text-muted fs-7 mb-1">Just now</span>
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary ms-1">You</a>
									</div>
									<!--end::Details-->
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<img alt="Pic" src="assets/media/avatars/300-1.jpg" />
									</div>
									<!--end::Avatar-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-primary text-dark fw-semibold mw-lg-400px text-end" data-kt-element="message-text"></div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(template for out)-->
						<!--begin::Message(template for in)-->
						<div class="d-flex justify-content-start mb-10 d-none" data-kt-element="template-in">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-start">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<img alt="Pic" src="assets/media/avatars/300-25.jpg" />
									</div>
									<!--end::Avatar-->
									<!--begin::Details-->
									<div class="ms-3">
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary me-1">Brian Cox</a>
										<span class="text-muted fs-7 mb-1">Just now</span>
									</div>
									<!--end::Details-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-info text-dark fw-semibold mw-lg-400px text-start" data-kt-element="message-text">Right before vacation season we have the next Big Deal for you.</div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(template for in)-->
					</div>
					<!--end::Messages-->
				</div>
				<!--end::Card body-->
				<!--begin::Card footer-->
				<div class="card-footer pt-4" id="kt_drawer_chat_messenger_footer">
				<form id="kt_modal_add_user_form123" class="form" action="chatadd2.php" method="POST">
				<input type="hidden" name="imid1" value="<?php echo $imid; ?>">
				<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
					<!--begin::Input-->
					<textarea class="form-control form-control-flush mb-3" rows="1" name="cdmsg" placeholder="Type a message"></textarea>
					<!--end::Input-->
					<!--begin:Toolbar-->
					<div class="d-flex flex-stack">
						
						<!--begin::Send-->
						<button class="btn btn-primary" type="submit" data-kt-users-modal-action="submit">Send</button>
						<!--end::Send-->
					</div>
					<!--end::Toolbar-->
					</form>
				</div>
				<!--end::Card footer-->
			</div>
			<!--end::Messenger-->
		</div>
		<!--end::Chat drawer-->
		<!--begin::Chat drawer-->
		<div id="kt_drawer_chat1" class="bg-body <?php if(isset($_GET['chat1'])){ echo 'drawer-on'; }?>" data-kt-drawer="true" data-kt-drawer-name="chat" data-kt-drawer-activate="true" data-kt-drawer-overlay="true" data-kt-drawer-width="{default:'300px', 'md': '500px'}" data-kt-drawer-direction="end" data-kt-drawer-toggle="#kt_drawer_chat_toggle1" data-kt-drawer-close="#kt_drawer_chat_close1">
			<!--begin::Messenger-->
			<div class="card w-100 rounded-0 border-0" id="kt_drawer_chat_messenger">
				<!--begin::Card header-->
				<div class="card-header pe-5" id="kt_drawer_chat_messenger_header1">
					<!--begin::Title-->
					<div class="card-title">
						<!--begin::User-->
						<div class="d-flex justify-content-center flex-column me-3">
							<a href="#" class="fs-4 fw-bold text-gray-900 text-hover-primary me-1 mb-2 lh-1">Internal Chat</a>
							
						</div>
						<!--end::User-->
					</div>
					<!--end::Title-->
					<!--begin::Card toolbar-->
					<div class="card-toolbar">
						<!--begin::Close-->
						<div class="btn btn-sm btn-icon btn-active-light-primary" id="kt_drawer_chat_close1">
							<!--begin::Svg Icon | path: icons/duotune/arrows/arr061.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">
									<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>
					<!--end::Card toolbar-->
				
					</div>
				<!--end::Card header-->
				<!--begin::Card body-->
				<div class="card-body" id="kt_drawer_chat_messenger_body1">
					<!--begin::Messages-->
					<div class="scroll-y me-n5 pe-5" data-kt-element="messages" data-kt-scroll="true" data-kt-scroll-activate="true" data-kt-scroll-height="auto" data-kt-scroll-dependencies="#kt_drawer_chat_messenger_header1, #kt_drawer_chat_messenger_footer1" data-kt-scroll-wrappers="#kt_drawer_chat_messenger_body1" data-kt-scroll-offset="0px">
					
					<?php 
						$eve98 = "select * from res_internalchat_detail where imid=$imid ";
						$re98 = mysqli_query($conn, $eve98);
						if(mysqli_num_rows($re98) > 0)
						{
			while($rt98 = mysqli_fetch_assoc($re98))
			{
				$icdmsg = $rt98['icdmsg'];
				$icaddedon = date("d-m H:i",strtotime($rt98['icaddedon']));
				
				$icdaddedby = $rt98['icdaddedby'];
				$imid = $rt98['imid'];
				$uimage='';
				$chatname='';
				
				$eveag = "select ufullname,utype,uimage from res_user_master where umid=$icdaddedby";
				$reag = mysqli_query($conn, $eveag);
				if(mysqli_num_rows($reag) > 0)
				{
					while($rtag = mysqli_fetch_assoc($reag))
					{
						$chatname=$rtag['ufullname'];
						$utype=$rtag['utype'];
						$uimage=$rtag['uimage'];
						
						if(strlen($uimage)>3)
				{
					$uimage="<img src='docs/$uimage' width='80px' height='80px'>";
				}
					}
				}
				
				
					?>
						<!--begin::Message(in)-->
						<div class="d-flex justify-content-<?php if($_SESSION['umid'] == $icdaddedby)
				{ echo 'end'; }else{ echo 'start'; } ?> mb-10">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-<?php if($_SESSION['umid'] == $icdaddedby)
				{ echo 'end'; }else{ echo 'start'; } ?>">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<?php echo $uimage; ?>
									</div>
									<!--end::Avatar-->
									<!--begin::Details-->
									<div class="ms-3">
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary me-1"><?php echo $chatname; ?></a>
										<span class="text-muted fs-7 mb-1"><?php echo $icaddedon; ?></span>
									</div>
									<!--end::Details-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-<?php if($_SESSION['umid'] == $icdaddedby)
				{ echo 'primary'; }else{ echo 'info'; } ?> text-dark fw-semibold mw-lg-400px text-<?php if($_SESSION['umid'] == $icdaddedby)
				{ echo 'end'; }else{ echo 'start'; } ?>" data-kt-element="message-text"><?php echo $icdmsg; ?></div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(in)-->
						<?php } } ?>
						<!--begin::Message(template for out)-->
						<div class="d-flex justify-content-end mb-10 d-none" data-kt-element="template-out">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-end">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Details-->
									<div class="me-3">
										<span class="text-muted fs-7 mb-1">Just now</span>
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary ms-1">You</a>
									</div>
									<!--end::Details-->
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<img alt="Pic" src="assets/media/avatars/300-1.jpg" />
									</div>
									<!--end::Avatar-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-primary text-dark fw-semibold mw-lg-400px text-end" data-kt-element="message-text"></div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(template for out)-->
						<!--begin::Message(template for in)-->
						<div class="d-flex justify-content-start mb-10 d-none" data-kt-element="template-in">
							<!--begin::Wrapper-->
							<div class="d-flex flex-column align-items-start">
								<!--begin::User-->
								<div class="d-flex align-items-center mb-2">
									<!--begin::Avatar-->
									<div class="symbol symbol-35px symbol-circle">
										<img alt="Pic" src="assets/media/avatars/300-25.jpg" />
									</div>
									<!--end::Avatar-->
									<!--begin::Details-->
									<div class="ms-3">
										<a href="#" class="fs-5 fw-bold text-gray-900 text-hover-primary me-1">Brian Cox</a>
										<span class="text-muted fs-7 mb-1">Just now</span>
									</div>
									<!--end::Details-->
								</div>
								<!--end::User-->
								<!--begin::Text-->
								<div class="p-5 rounded bg-light-info text-dark fw-semibold mw-lg-400px text-start" data-kt-element="message-text">Right before vacation season we have the next Big Deal for you.</div>
								<!--end::Text-->
							</div>
							<!--end::Wrapper-->
						</div>
						<!--end::Message(template for in)-->
					</div>
					<!--end::Messages-->
				</div>
				<!--end::Card body-->
				<!--begin::Card footer-->
				<div class="card-footer pt-4" id="kt_drawer_chat_messenger_footer1">
				<form id="kt_modal_add_user_form123" class="form" action="internalchatadd2.php" method="POST">
				<input type="hidden" name="imid1" value="<?php echo $imid; ?>">
				<input type="hidden" name="stiqmid" value="<?php echo $stiqmid; ?>">
					<!--begin::Input-->
					<textarea class="form-control form-control-flush mb-3" rows="1" name="icdmsg" placeholder="Type a message"></textarea>
					<!--end::Input-->
					<!--begin:Toolbar-->
					<div class="d-flex flex-stack">
						
						<!--begin::Send-->
						<button class="btn btn-primary" type="submit" data-kt-users-modal-action="submit">Send</button>
						<!--end::Send-->
					</div>
					<!--end::Toolbar-->
					</form>
				</div>
				<!--end::Card footer-->
			</div>
			<!--end::Messenger-->
		</div>
		<!--end::Chat drawer-->
		
									
		<!--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(){
			
			
 $("#kt_daterangepicker_1").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    }
   
);
		});
		</script>
		
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_2").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_3").flatpickr({
       dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_4").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_5").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_6").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_7").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_8").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_9").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_10").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_11").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_12").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_13").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_14").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_15").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_16").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_17").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_18").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script><script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_19").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		
	
		
		
	
	<script type="text/javascript">
      $(document).ready(function(){
        $("#offer").hide();
        
        $("#capstatus").change(function () {
          if ($(this).val() == "Conditional Offer Received" || $(this).val() == "Unconditional Offer Received") {
            $("#offer").show();
            }
          else {
            $("#offer").hide();
            }
        }
                             );
      }
                       );
    </script> 



		
		
		<script>
		$('#isdid').on('change',function()
		{
			$.get("paymenttotalamt.php", { isdid : $(this).val() }, function(response) 
			{
				$('#paytotalamount1').val( $.trim(response) );

			});
			$.get("paymentreceivedamt.php", { isdid : $(this).val() }, function(response) 
			{
				$('#payrecivedamt1').val( $.trim(response) );

			});
			$.get("paymentpendingamt.php", { isdid : $(this).val() }, function(response) 
			{
				$('#paypendingamt1').val( $.trim(response) );

			});
		});
		</script>
		<script>
		
			$.get("paymenttotalamt.php", { isdid : $('#isdid').val() }, function(response) 
			{
				$('#paytotalamount1').val( $.trim(response) );

			});
			$.get("paymentreceivedamt.php", { isdid : $('#isdid').val() }, function(response) 
			{
				$('#payrecivedamt1').val( $.trim(response) );

			});
			$.get("paymentpendingamt.php", { isdid : $('#isdid').val() }, function(response) 
			{
				$('#paypendingamt1').val( $.trim(response) );

			});
		
		</script>
		
		
		
		
		
		
		<?php

if(isset($_SESSION['msg']))
{
	$tt = $_SESSION['msg'];
	echo "<input type=\"hidden\" id=\"mymsg\" value=\"$tt\"/>";
	unset($_SESSION['msg']);
	
	
?>	
								
		<script lang="javascript">

var a = [
    function () {
	

		var mymsg = document.getElementById("mymsg").value;
		toastr.success(mymsg, "Operation Completed")
		
    },
    function () {
        $('span').show();
    },
    function () {
        $('p').fadeIn(100);
    }
];		
					

a[0]();
</script>


		
	
<?php
}

if(isset($_SESSION['msg1']))
{
	$tt1 = $_SESSION['msg1'];
	echo "<input type=\"hidden\" id=\"mymsg1\" value=\"$tt1\"/>";
	unset($_SESSION['msg1']);
	
	
	?>	
								
		<script lang="javascript">

var a = [
    function () {
	

		var mymsg = document.getElementById("mymsg1").value;
		toastr.warning(mymsg, "Error")
		
    },
    function () {
        $('span').show();
    },
    function () {
        $('p').fadeIn(100);
    }
];		
					

a[0]();
</script>
	
<?php

}
?>	

	
	<script>
		$(document).ready(function(){

		$(document).on('click', '#getUser6', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			

			$('#dynamic-content6').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'collegeappstatus.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content6').html('');
				$('#dynamic-content6').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content6').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script>	
<script>
		$(document).ready(function(){

		$(document).on('click', '#getUser11', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			

			$('#dynamic-content11').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'collegeadmissionstatus.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content11').html('');
				$('#dynamic-content11').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content11').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script>	



    


	
	<script type="text/javascript">
			$(document).ready(function(){
				$('#countrymid2').on('change',function(){
					var countrymid = $(this).val();
					//alert(countrymid);
					if(countrymid){
						$.ajax({
							type:'POST',
							url:'countrytocollegedata.php',
							data:'countrymid='+countrymid,
							success:function(html){
								$('#collegemid2').html(html);
							}
						});
					}else{
						$('#collegemid2').html('<option value=""></option>');
					}
				});
			});
	</script>
	
	 <script type="text/javascript">
	$(function()
	{
		$('#myForm').submit(function(e)
		{
			if($('#coursemid1').val() == '0')
			{
				alert('Select Course!');
				e.preventDefault();
			}

		});
	});
	</script>
    


		
	<script type="text/javascript">
			$(document).ready(function(){
				$('#collegemid2').on('change',function(){
					var collegemid = $(this).val();
					if(collegemid){
						$.ajax({
							type:'POST',
							url:'collegecampus.php',
							data:'collegemid='+collegemid,
							success:function(html){
								$('#ccampusmid').html(html);
							}
						});
					}else{
						$('#ccampusmid').html('<option value=""></option>');
					}
				});
			});
	</script>
	
	

	
<script>
$('#coursemid1').on('change',function()
{
	
	
	
	$.get("coursefees.php", { coursemid : $(this).val() }, function(response) 
	{
		$('#cgrosstutionfess2').val( $.trim(response) );

	});
});
</script>
<script type="text/javascript">
			$(document).ready(function(){
				
					
					var coursemid = $('#coursemid3').val();
					//alert(collegemid);
					if(coursemid){
						$.ajax({
							type:'POST',
							url:'courseintake.php',
							data:'coursemid='+coursemid,
							success:function(html){
								$('#citdid1').html(html);
							}
						});
					}else{
						$('#citdid1').html('<option value=""></option>');
					}
				
			});
	</script><script type="text/javascript">
			$(document).ready(function(){
				$('#coursemid3').on('change',function(){
					
					var coursemid = $(this).val();
					
					if(coursemid){
						//alert(coursemid);
						$.ajax({
							type:'POST',
							url:'courseintake.php',
							data:'coursemid='+coursemid,
							success:function(html){
								$('#citdid1').html(html);
							}
						});
					}else{
						$('#citdid1').html('<option value=""></option>');
					}
				});
			});
	</script><script>
$('#coursemid3').on('change',function()
{
	
	
	
	$.get("coursefees.php", { coursemid : $(this).val() }, function(response) 
	{
		$('#cgrosstutionfess1').val( $.trim(response) );

	});
	
	$.get("coursecurrency1.php", { coursemid : $(this).val() }, function(response) {

//alert(response);

$('#pcurrency').val( $.trim(response) );

});

$.get("coursefeesinr1.php", { coursemid : $(this).val() }, function(response) {

//alert(response);

$('#cgrosstutionfess1inr').val( $.trim(response) );

});
});
</script>

	

	
	
		<script>

 $('#clgappmid').on('change',function(){



$.get("coursetofees.php", { clgappmid : $(this).val() }, function(response) {

//alert(response);

$('#pcurrencyrate').val( $.trim(response) );


});

$.get("coursecurrency.php", { clgappmid : $(this).val() }, function(response) {

//alert(response);

$('#pcurrency22').val( $.trim(response) );

});
$.get("coursefeesinr.php", { clgappmid : $(this).val() }, function(response) {

//alert(response);

$('#pcurrencyinr').val( $.trim(response) );

});
});

</script>
		

<script>
		$(document).ready(function(){

		$(document).on('click', '#getUser5', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			//alert(uid);

			$('#dynamic-content5').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'paymenttranscation.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content5').html('');
				$('#dynamic-content5').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content5').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script>	

<script>
		$(document).ready(function(){

		$(document).on('click', '#getUser8', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			//alert(uid);

			$('#dynamic-content8').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'admissionintake.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content8').html('');
				$('#dynamic-content8').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content8').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script><script>
		$(document).ready(function(){

		$(document).on('click', '#getUser12', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			//alert(uid);

			$('#dynamic-content12').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'defclgapplication1.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content12').html('');
				$('#dynamic-content12').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content12').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script>	
<script>
		$(document).ready(function(){

		$(document).on('click', '#getUser3', function(e){

			e.preventDefault();

			var uid = $(this).data('id');   // it will get id of clicked row
			
			//alert(uid);

			$('#dynamic-content3').html(''); // leave it blank before ajax call
			      // load ajax loader

			$.ajax({
				url: 'appstepdetail.php',
				type: 'POST',
				data: 'id='+uid,
				dataType: 'html'
			})
			.done(function(data){
				console.log(data);
				$('#dynamic-content3').html('');
				$('#dynamic-content3').html(data); // load response
						  // hide ajax loader
			})
			.fail(function(){
				$('#dynamic-content3').html('<i class="glyphicon glyphicon-info-sign"></i> Something went wrong, Please try again...');
				
			});

		});
	});

	

</script>	

		<script>
		 
		  $('#paycurrency').on('change',function(){

				$.get("paycurrencyvalue.php", { servicefinalrate : $('#pcurrencyinr').val() , paycurrency : $(this).val() }, function(response) {

				//alert(response);
				
				$('#paycurrencyvalue22').val( $.trim(response) );
				});
				
				
				
			});
		</script>
		<script>
		 
		 /*  $('#paycurrency1').on('change',function(){

				$.get("paycurrencyvalue.php", { servicefinalrate : $('#cgrosstutionfess1inr').val() , paycurrency : $(this).val() }, function(response) {

				//alert(response);
				
				$('#paycurrencyvalue1').val( $.trim(response) );
				});
				
				
				
				
			}); */
		</script>
		<script>
		 
		  $('#pcurrencyinr').on('keyup',function(){

				$.get("paycurrencyvalue.php", { servicefinalrate : $('#pcurrencyinr').val() , paycurrency : $('#paycurrency').val() }, function(response) {

				//alert(response);
				
				$('#paycurrencyvalue').val( $.trim(response) );
				});
				
				
				
			});
		</script>
	<script>
		 
		  

				$.get("paycurrencyvalue.php", { servicefinalrate : $('#pcurrencyinr').val() , paycurrency : $('#paycurrency').val() }, function(response) {

				//alert(response);
				
				$('#paycurrencyvalue').val( $.trim(response) );
				
				
				
				
			});
		</script>
		<script type="text/javascript">

$('#asemester').on('change',function(){
var asemester = $(this).val();

$('#term').empty();
	for(var j=1;j<=asemester; j++)
{
	

		$("#term").append(" <tr><td valign=\"top\">  <select  class=\"form-select form-select-solid\" data-control=\"select2\" id=\"pname" + $('#mycounter').val()  + "\" name=\"asemstartmonth[]\"><option value=\"January\">January</option><option value=\"February\">February</option><option value=\"March\">March</option><option value=\"April\">April</option><option value=\"May\">May</option><option value=\"June\">June</option><option value=\"July\">July</option><option value=\"August\">August</option><option value=\"September\">September</option><option value=\"October\">October</option><option value=\"November\">November</option><option value=\"December\">December</option></select> </td><td> <select class=\"form-select form-select-solid\" data-control=\"select2\"   name=\"asemstartyear[]\" ><?php for($i=2020;$i<=2040;$i++){echo "<option value=\'$i\'>$i</option>";}?></select></td><td valign=\"top\"> <input type=\"text\" class=\"form-control form-control-solid\" id=\"asemfees" + $('#mycounter').val()  + "\" name=\"asemfees[]\"> </td></tr>.");

		$('#mycounter').val( parseInt($('#mycounter').val()) + 1);

}
	



});



</script>

	<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_20").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_21").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_22").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_23").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
		<script type="text/javascript">
			$(document).ready(function(){
				$('#clgappmid1').on('change',function(){
					
					var clgappmid = $(this).val();
					
					if(clgappmid){
						
						$.ajax({
							type:'POST',
							url:'collegeapplicationmanage.php',
							data:'clgappmid='+clgappmid,
							success:function(html){
								$('#camdid').html(html);
							}
						});
					}else{
						$('#camdid').html('<option value=""></option>');
					}
				});
			});
	</script><script type="text/javascript">
			$(document).ready(function(){
				$('#camdid').on('change',function(){
					
					var camdid = $(this).val();
					
					if(camdid){
						
						$.ajax({
							type:'POST',
							url:'applicationsteps.php',
							data:'camdid='+camdid,
							success:function(html){
								$('#steps').html(html);
							}
						});
					}else{
						$('#steps').html('<option value=""></option>');
					}
				});
			});
	</script>
	
<script>
$('#camdid').on('change',function()
{
	
	
	
	$.get("camstartdate.php", { camdid : $(this).val() }, function(response) 
	{
		$('#camstartdate').val( $.trim(response) );

	});
	
	$.get("camdeadline.php", { camdid : $(this).val() }, function(response) 
	{
		$('#camdeadline').val( $.trim(response) );

	});
	
	$.get("camcondition.php", { camdid : $(this).val() }, function(response) 
	{
		$('#camcondition').val( $.trim(response) );

	});
	$.get("camprocessdetail.php", { camdid : $(this).val() }, function(response) 
	{
		$('#camprocessdetail').val( $.trim(response) );

	});
});
</script>
<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_11").flatpickr({
        enableTime:!1,dateFormat:"d-m-Y"
    });
		});
		</script>
															<script type="text/javascript">
			$(document).ready(function(){
				$('#coursemid22').on('change',function(){
					var coursemid = $(this).val();
					
					if(coursemid){
						
						$.ajax({
							type:'POST',
							url:'courseintake.php',
							data:'coursemid='+coursemid,
							success:function(html){
								$('#citdid').html(html);
							}
						});
					}else{
						$('#citdid').html('<option value="">333</option>');
					}
				});
			});
	</script>
	<script type="text/javascript">
			$(document).ready(function(){
				$('#ccampusmid').on('change',function(){
					var ccampusmid = $(this).val();
					//alert(ccampusmid);
					if(ccampusmid){
						$.ajax({
							type:'POST',
							url:'coursecampusdata.php',
							data:'ccampusmid='+ccampusmid,
							success:function(html){
								$('#coursemid22').html(html);
							}
						});
					}else{
						$('#coursemid22').html('<option value=""></option>');
					}
				});
			});
	</script>
	<script type="text/javascript">
			$(document).ready(function(){
				
					var ccampusmid = $('#ccampusmid').val();
					if(ccampusmid){
						$.ajax({
							type:'POST',
							url:'coursecampusdata.php',
							data:'ccampusmid='+ccampusmid,
							success:function(html){
								$('#coursemid22').html(html);
							}
						});
					}else{
						$('#coursemid22').html('<option value=""></option>');
					}
				});
			
	</script>

<script>
$('#coursemid22').on('change',function()
{
	
	
	
	$.get("coursefees.php", { coursemid : $(this).val() }, function(response) 
	{
		$('#cgrosstutionfess2').val( $.trim(response) );

	});
});
</script>	
		<!--end::Javascript-->
	</body>
	<!--end::Body-->
</html>