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


?>
<!DOCTYPE html>
<!--
Author: Keenthemes
Product Name: Metronic - Bootstrap 5 HTML, VueJS, React, Angular. Laravel, Asp.Net Core, Ruby on Rails, Spring Boot, Blazor, Django, Express Node.js & Flask Admin Dashboard Theme
Purchase: https://1.envato.market/EA4JP
Website: http://www.keenthemes.com
Contact: support@keenthemes.com
Follow: www.twitter.com/keenthemes
Dribbble: www.dribbble.com/keenthemes
Like: www.facebook.com/keenthemes
License: For each use you must have a valid license purchased only from above link in order to legally use the theme for your project.
-->
<html lang="en">
	<!--begin::Head-->
	<head>
		<title>Contact 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">Contact 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">Contact Managemnet</li>
										
										<li class="breadcrumb-item text-muted">Contact Details</li>
									</ul>
									<!--end::Breadcrumb-->
								</div>
								<!--end::Page title=-->
							</div>
							<!--begin::Wrapper-->
							<?php include('header.php'); ?>
							<!--end::Wrapper-->
						</div>
						<!--end::Container-->
					</div>
					<!--end::Header-->
					<?php
					
	
	include("connect.php");
	
	$eve = "select * from res_contact_master where contactmid=".$_GET['id'];
			$re = mysqli_query($conn, $eve);
			while($rt = mysqli_fetch_assoc($re))
			{
				$contactmid=$rt['contactmid'];
				
				$contactname=$rt['contactname'];
				$contactnumber=$rt['contactnumber'];
				$cmobilenumber=$rt['cmobilenumber'];
				$contactemail=$rt['contactemail'];
				$contactdepartmnet=$rt['contactdepartmnet'];
				$clinktype=$rt['clinktype'];
				$cposition=$rt['cposition'];
				$cmiddlename=$rt['cmiddlename'];
				$csurname=$rt['csurname'];
				$caltenateemail=$rt['caltenateemail'];
				$caddress1=$rt['caddress1'];
				$caddress2=$rt['caddress2'];
				$ccountry=$rt['ccountry'];
				$cstate=$rt['cstate'];
				$ccity=$rt['ccity'];
				$carea=$rt['carea'];
				$cpostalcode=$rt['cpostalcode'];
				$cremarks=$rt['cremarks'];
				$cmsgappname=$rt['cmsgappname'];
				$cmsgappid=$rt['cmsgappid'];
				$cvideoappname=$rt['cvideoappname'];
				$cvideoappid=$rt['cvideoappid'];
				$ccompanyname=$rt['ccompanyname'];
				
				
				$cname='';
				
				$eve2 = "select * from res_country_master where countrymid ='$ccountry'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$cname=$rt2['countryname'];
					}
				}
				
				
				$sname='';
				
				$eve2 = "select * from res_state_master where statemid ='$cstate'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$sname=$rt2['statename'];
					}
				}
				
				
				$ciname='';
				
				$eve2 = "select * from res_city_master where citymid ='$ccity'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$ciname=$rt2['cityname'];
					}
				}
				
				
				
				$areaname='';
				
				$eve2 = "select * from res_area_master where areamid ='$carea'";
				
				$re2 = mysqli_query($conn, $eve2);
				
				if(mysqli_num_rows($re2) > 0)
				{
					
					while($rt2 = mysqli_fetch_assoc($re2))
					{
							$areaname=$rt2['areaname'];
					}
				}
			    
				
				
				
				
				
				

				
?>
					<!--begin::Content-->
					<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
						<!--begin::Container-->
						<div class="container-xxl" id="kt_content_container">
							<!--begin::Order details page-->
							<div class="d-flex flex-column gap-7 gap-lg-10">
								<!--<div class="d-flex flex-wrap flex-stack gap-5 gap-lg-10">
									
									<!--begin::Button-->
									<?php /*if($_SESSION['frompage'] == 'Inquirylistpage') {?>
									<a href="inquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php } else if ($_SESSION['frompage'] == 'planStudiesInquirylistpage') { ?>
									<a href="planstudiesinquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php } else if ($_SESSION['frompage'] == 'AgentDetail') {  ?>
									<!--<a href="agentinquiry.php?id=<?php echo $_SESSION['agentid']; ?>" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php }else{ ?>
									<a href="inquiry.php" class="btn btn-icon btn-light btn-sm ms-auto me-lg-n7">
									<?php }  */?>
										<!--begin::Svg Icon | path: icons/duotune/arrows/arr074.svg-->
										<!--<span class="svg-icon svg-icon-2">
											<svg width="24" height="24" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
												<path d="M11.2657 11.4343L15.45 7.25C15.8642 6.83579 15.8642 6.16421 15.45 5.75C15.0358 5.33579 14.3642 5.33579 13.95 5.75L8.40712 11.2929C8.01659 11.6834 8.01659 12.3166 8.40712 12.7071L13.95 18.25C14.3642 18.6642 15.0358 18.6642 15.45 18.25C15.8642 17.8358 15.8642 17.1642 15.45 16.75L11.2657 12.5657C10.9533 12.2533 10.9533 11.7467 11.2657 11.4343Z" fill="currentColor" />
											</svg>
										</span>
										<!--end::Svg Icon-->
									</a>
									<!--end::Button-->
									
								
								
								<!--begin::Tab content-->
								<div class="tab-content">
									<!--begin::Tab pane-->
									<div class="tab-pane fade show active" id="User_detail" role="tab-panel">
										<!--begin::Orders-->
										<div class="d-flex flex-column gap-7 gap-lg-10">
											<div class="d-flex flex-column flex-xl-row gap-7 gap-lg-10">
												<!--begin::Payment address-->
												<div class="card card-flush py-4 flex-row-fluid overflow-hidden">
													<!--begin::Background-->
													
													<!--end::Background-->
												<!--	<div class="d-flex justify-content-end" data-kt-user-table-toolbar="base">
													
													<!--begin::Add user-->
											<!--<a href="inquiryedit.php?id=&from=detail" class="btn 
btn-primary ">
											<!--begin::Svg Icon | path: icons/duotune/arrows/arr075.svg-->
											
											<!--end::Svg Icon--><!--Edit <i class="fa fa-edit"> </i></a>
											<!--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" colspan="2"> Name
                  </th>
                  <td>
                    <?php echo $contactname;?>
                  </td>
                  
                </tr>
				
				<tr>
                  <th class="fw-bold">Contact Number
                  </th>
                  <td>
                    <?php echo $contactnumber;?>
                  </td>
				  <th class="fw-bold">Mobile Number
                  </th>
                  <td>
                    <?php echo $cmobilenumber;?>
                  </td>
                </tr>	
				
                <tr>
                  <th class="fw-bold">Email
                  </th>
                  <td >
                    <?php echo $contactemail;?>
                  </td>								
                  <th class="fw-bold">Alternate Email
                  </th>
                  <td >
                    <?php echo $caltenateemail;?>
                  </td>
                </tr>
				
                <tr>
                  <th class="fw-bold">Address
                  </th>
                  <td >
                    <?php echo $caddress1;?>
                  </td>
				  
                </tr>
                
				
				 <tr>
                  <th class="fw-bold"> Country
                  </th>
                  <td>
                    <?php echo $agentcontry;?>
                  </td>
                  <th class="fw-bold"> State
                  </th>
                  <td>
                    <?php echo $agentstate;?>
                  </td>
                </tr>
				
				 <tr>
                  <th class="fw-bold"> City
                  </th>
                  <td>
                    <?php echo $agentcity;?>
                  </td>
				  
				   <th class="fw-bold"> Area
                  </th>
                  <td>
                    <?php echo $agentarea;?>
                  </td>
				  </tr>
				  
				  <tr>
                  <th class="fw-bold">Postalcode
                  <td>
                    <?php echo $agentpostal;?>
                  </td>
					 <th class="fw-bold">Owner Aadhar Number
                  </th>
                  <td>
                    <?php echo $uoqneraadharnumber;?>
                  </td>
				  </tr>
				
				 <tr>
                  <th class="fw-bold">Messaging App
                  </th>
                  <td>
                    <?php echo $umessageapp;?>
                  </td>
                  <th class="fw-bold">Messaging ID
                  </th>
                  <td>
                    <?php echo $umessageid;?>
                  </td>
                </tr>
				
				 <tr>
                  <th class="fw-bold">Videocall App
                  </th>
                  <td>
                    <?php echo $uvideocallapp;?>
                  </td>
                  <th class="fw-bold">Videocall ID
                  </th>
                  <td>
                    <?php echo $uvideocallid;?>
                  </td>
                </tr>
				
				 <tr>
                  <th class="fw-bold">Staff Number
                  </th>
                  <td>
                    <?php echo $ustaffnumber;?>
                  </td>
                  <th class="fw-bold">Staff Email
                  </th>
                  <td>
                    <?php echo $ustafffemail;?>
                  </td>
                </tr>
				
				 
			   <tr>
                  <th class="fw-bold">Company Name
                  </th>
                  <td >
                    <?php echo $ubusinessname;?>
                  </td>
                
                  <th class="fw-bold">Company Register Address
                  </th>
                  <td >
                    <?php echo $ubusinessaddress;?>
                  </td>
				</tr>
				<tr>
                  <th class="fw-bold">Company Establish Year
                  </th>
                  <td>
                    <?php echo $ubussinessyear;?>
                  </td>
                
                  <th class="fw-bold">Company Registration Number
                  </th>
                  <td >
                    <?php echo $ubussinessregistrationnum;?>
                  </td>
				  </tr>
				  
				  <tr>
                  <th class="fw-bold">Company Country
                  </th>
                  <td>
                    <?php echo $cname;?>
                  </td>
                
                  <th class="fw-bold">Company State
                  </th>
                  <td >
                    <?php echo $sname;?>
                  </td>
				  </tr>
				  
				  <tr>
                  <th class="fw-bold">Company City
                  </th>
                  <td>
                    <?php echo $ciname;?>
                  </td>
					
					<th class="fw-bold">Company Area
                  </th>
                  <td>
                    <?php echo $areaname;?>
                  </td>
				  </tr>
				  
				  <tr>
                  <th class="fw-bold">Company Postal Code
                  </th>
                  <td >
                    <?php echo $upostalcode;?>
                  </td>
				   <th class="fw-bold">GST
                  </th>
                  <td >
                    <?php echo $ugst;?>
                  </td>
				   </tr>
				 
				  <tr>
				  <th class="fw-bold">PAN Number
                  </th>
                  <td >
                    <?php echo $upannumber;?>
                  </td>
                
                  <th class="fw-bold">Agreement Number
                  </th>
                  <td >
                    <?php echo $uagreementnumber;?>
                  </td>
				  </tr>
				  
				   <tr>
				  <th class="fw-bold">Date of Start Agreement
                  </th>
                  <td >
                    <?php echo $uagreementstartdate;?>
                  </td>
                
                  <th class="fw-bold">Date of End Agreement
                  </th>
                  <td >
                    <?php echo $uagreementenddate;?>
                  </td>
				  </tr>
				  
				  
				  
				<tr>
				  <th class="fw-bold">Account Type
                  </th>
                  <td >
                    <?php echo $ucommissiontype;?>
                  </td>
				 
                  <th class="fw-bold">Commission Amount
                  </th>
                  <td>
                    <?php echo $ucommissionamount;?>
                  </td>
                </tr>
				 <tr>
                  <th class="fw-bold">Total Commission Amount
                  </th>
                  <td >
                    <?php echo $utotalcommission;?>
                  </td>
				 
				  <th class="fw-bold">Paid Amount
                  </th>
                  <td >
                    <?php echo $upaidamount;?>
                  </td>
                </tr>
				
				<tr>
                  <th class="fw-bold">Outstanding Amount
                  </th>
                  <td >
                    <?php echo $uoutstandingamount;?>
                  </td>
				  <th class="fw-bold">Bank Name
                  </th>
                  <td >
                    <?php echo $ubank;?>
                  </td>
				 </tr>
				 
				 <tr>
                  <th class="fw-bold">Branch Name
                  </th>
                  <td >
                    <?php echo $ubranch;?>
                  </td>
				  <th class="fw-bold">Customer ID
                  </th>
                  <td >
                    <?php echo $customermid;?>
                  </td>
				 </tr>
				 
				 <tr>
                  <th class="fw-bold">Account Number
                  </th>
                  <td >
                    <?php echo $uaccountnumber;?>
                  </td>
				  <th class="fw-bold">IFSC Code
                  </th>
                  <td >
                    <?php echo $uifsccode;?>
                  </td>
				 </tr>
				 
				<tr>
				
				<th class="fw-bold">MICR Code
                  </th>
                  <td >
                    <?php echo $umicrcode;?>
                  </td>
				
				  <th class="fw-bold">Account Details
                  </th>
                  <td >
                    <?php echo $uaccountdetails;?>
                  </td>
				  
                </tr>
				
              </table>
			  </div>
			  </div>
           
													<!--end::Card header-->
													<!--begin::Card body-->
													
													<!--end::Card body-->
												</div>
												<!--end::Payment address-->
												</div>
											
											</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::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").daterangepicker({
        singleDatePicker: true,
        showDropdowns: true,
        minYear: 1901,
        maxYear: parseInt(moment().format("yyyy"),12),
		locale: {
        format: "DD-M-Y"
    }
    }
);
		});
		</script>
		<script type="text/javascript">
		$(document).ready(function(){
			$("#kt_daterangepicker_2").daterangepicker({
        singleDatePicker: true,
        showDropdowns: true,
        minYear: 1901,
        maxYear: parseInt(moment().format("yyyy"),12),
		locale: {
        format: "DD-M-Y"
    }
    }
);
		});
		</script>
		<!--end::Javascript-->
	</body>
	<!--end::Body-->
</html>