HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
File: /var/www/selfanalyse/self-strength-test/upgrade-student-for-center-lab.php
<?php
    /*
     * Purpose:     all student list
     * @package     Student Management / Whitelabel Dashboard
     * @author      Abhishek kumar <abhishek.kumar@sarkaripariksha.com>
     * @since       18/05/2020
     * @version     Current Plugin Version 4.69
     * @category    Controllers
     * @copyright   Copyright (C) 2005 - 2017 Graposs Edutech Ltd. All rights reserved.
     * @license     Graposs Edutech Ltd.
    */

    include('header.php');
    include('sidebar.php');

    /*ini_set('display_errors', 1);
	ini_set('display_startup_errors', 1);
	error_reporting(E_ALL);*/

    $TT_MEDIUM_TABLE = $wpdb->prefix . TT_MEDIUM_TABLE;
	$TT_PAYMENT_PLAN_TABLE = $wpdb->prefix . TT_PAYMENT_PLAN_TABLE;
	$TT_USERS_TABLE = $wpdb->prefix . TT_USERS_TABLE;
	$TT_EXAM_CATEGORIES_TABLE = $wpdb->prefix . TT_EXAM_CATEGORIES_TABLE;
	$WHITELABEL_LABEL_REGISTRATIONS=$wpdb->prefix .WHITELABEL_LABEL_REGISTRATIONS;
	$TT_PAYMENT_PLAN_WHITELABEL_TABLE = $wpdb->prefix . TT_PAYMENT_PLAN_WHITELABEL_TABLE;
	$TT_CATEGORIES_TABLE= $wpdb->prefix .TT_CATEGORIES_TABLE;
	$TT_WHITELABEL_CENTER_LAB_USER_REGISTRATION = $wpdb->prefix . TT_WHITELABEL_CENTER_LAB_USER_REGISTRATION;
	$TT_WHITELABEL_CENTER_LAB = $wpdb->prefix . TT_WHITELABEL_CENTER_LAB;
	$TT_WHITELABEL_CENTER_LAB_WALLET = $wpdb->prefix . TT_WHITELABEL_CENTER_LAB_WALLET;
	$TT_WHITELABEL_CENTER_LAB_WALLET_DEDUCTION = $wpdb->prefix . TT_WHITELABEL_CENTER_LAB_WALLET_DEDUCTION;
	$TT_WHITELABEL_REGISTRATIONS = $wpdb->prefix . TT_WHITELABEL_REGISTRATIONS;
	$TT_WHT_PLAN_HISTORY  = $wpdb->prefix . TT_WHT_PLAN_HISTORY;
	$TT_CENTER_LAB_TOTAL_ID = $wpdb->prefix . TT_CENTER_LAB_TOTAL_ID;
	$TT_WHT_PLAN_SUBSCRIPTION_ORDER = $wpdb->prefix . TT_WHT_PLAN_SUBSCRIPTION_ORDER;

	$getDetails=$wpdb->get_row( "SELECT institute_name,domain_name,email FROM $TT_WHITELABEL_REGISTRATIONS WHERE whitelabel_id = ".WHITELABEL_ID );
	$Site_institute_name = $getDetails->institute_name;
	$Site_domain_name = $getDetails->domain_name;
	$Site_email = $getDetails->email;

	$allCategories = $wpdb->get_results("SELECT category_id, category_name FROM $TT_CATEGORIES_TABLE WHERE status='1'");

	$success=FALSE;
	date_default_timezone_set('Asia/Calcutta');
	$curDate = date('Y-m-d H:i:s'); // add 5 hrs 30 min in curr time 
	$center_id=$_SESSION['USER_ID'];
	$blog_id=WBLOG_ID;
	$whtid=WHITELABEL_ID;
    include WP_TT_ABSPATH .'vendorapi/tt_whitelabel_common_api.php';
?>

<link rel="stylesheet" type="text/css" href="css/toastr.min.css">
<style>
    select{
	    display: block;
	    width: 100%;
	    height: 34px;
	    padding: 6px 12px;
	    font-size: 14px;
	    line-height: 1.42857143;
	    color: #555;
	    background-color: #fff;
	    background-image: none;
	    border: 1px solid #ccc;
	    border-radius: 4px;
	    transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s;
	}
	.ui-autocomplete-loading {
	    background: white url("<?php echo get_site_url() . '/wp-content/plugins/tet-india/files/ui-anim_basic_16x16.gif'; ?>") right center no-repeat !important;
	}
	.danger{
        text-align: center;
        background-color: #bc2130c7;
        color: #ffffff;
        padding: 6px;
        font-size:1.1rem;
    }
    .success{
        text-align: center;
        background-color: #28a745d4;
        color: #ffffff;
        padding: 6px;
        font-size:1.1rem;
    }
    span{
    	color: #bc2130c7;
    }
    #ui-id-1{
        width: 43% !important;
        background: #fff !important;
        list-style: none !important;
        border: 1px solid #d2d2d2 !important;
        padding: 5px !important;
    }
</style>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<!-- <script src="<?php //echo $root_link; ?>/js/register-user-for-center-plan-jquery.js"></script> -->

<?php
	if (isset($_POST['btn-upgrade']))
	{
		$email = sanitizeDataT($_REQUEST['txtEmail'], 'xss_clean');
		$cmbPlans = sanitizeDataT($_REQUEST['cmbPlans'], 'xss_clean');
		$cmbMedium = sanitizeDataT($_REQUEST['cmbMedium'], 'xss_clean');
		$cmbCategory = sanitizeDataT($_REQUEST['cmbCategory'], 'xss_clean');
		$cmbExams = sanitizeDataT($_REQUEST['cmbExams'], 'xss_clean');
		$discount = sanitizeDataT($_REQUEST['discount'], 'xss_clean');
		$monthly_fee = sanitizeDataT($_REQUEST['monthly_fee'], 'xss_clean');

		$userID = $wpdb->get_var("SELECT u.ID FROM $TT_USERS_TABLE AS u INNER JOIN $WHITELABEL_LABEL_REGISTRATIONS AS r ON r.ID = u.ID WHERE u.user_login='".$email."' AND r.blog_id = ".WBLOG_ID );
						
		if($userID!='' || $userID!=0)
		{
			// select plan amount 
			$plan_detail = $wpdb->get_row("SELECT plan_name, plan_validity, test, no_of_test, subject_mock_test, no_of_anyone_subject_test, cost, tutorial FROM $TT_PAYMENT_PLAN_TABLE WHERE payment_plan_id='$cmbPlans'");
			$plan_name = $plan_detail->plan_name;
			$cost = $plan_detail->cost;
	
			$walletBalanceDetail= $wpdb->get_row("SELECT total_amount,used_amount FROM $TT_WHITELABEL_CENTER_LAB_WALLET WHERE center_lab_id=$center_id AND whitelabel_id=".WHITELABEL_ID);
			
			$checkPlanID = $wpdb->get_var("select count(*) from $TT_WHT_PLAN_SUBSCRIPTION_ORDER where whitelabel_id=".$whitelabel_id);
			$planQuery= $wpdb->get_row("select datediff(expiry_date,'$curDate') AS totalDay from $TT_WHT_PLAN_SUBSCRIPTION_ORDER where whitelabel_id=".$whitelabel_id);
			$totalDay = $planQuery->totalDay;
			if($checkPlanID > 0) 
			{
				if((int)$totalDay > 0) 
				{
				  $checkCenterWallet = $wpdb->get_row("SELECT total_id, used_id, (total_id - used_id) AS planCount FROM $TT_CENTER_LAB_TOTAL_ID WHERE center_lab_id=$center_id AND whitelabel_id=".WHITELABEL_ID);
				  $planCount = $checkCenterWallet->planCount;	
				  $total_id = $checkCenterWallet->total_id;
				  if ($planCount <= $total_id && $planCount != 0 ) 
				  {
					$success=TRUE;
					$txn_type='SU';
					$remarks='Student upgrade';
					$operator_id=0;
					$plan_amount = 0;
					$whtstatus = 1;
				
					$payment_status='A';
					$active_status=1;
					$active_date =$curDate;
					$mock_test =$plan_detail->test; 
					$no_of_mock_test=$plan_detail->no_of_test; 
					$subject_test = $plan_detail->subject_mock_test;  
					$no_of_subject_test =$plan_detail->no_of_anyone_subject_test; 
					$tutorial =$plan_detail->tutorial; 
					$source ="whitelabel"; 
					$source_id= WHITELABEL_ID; 
				
					$order_id = insertWhtStudentPlanSubscription($userID, $cmbExams, $cmbPlans, $payment_status, $payment_type_id, $cost, $curDate, $active_status, $active_date, $mock_test, $no_of_mock_test, $subject_test, $no_of_subject_test, $tutorial, $source, $source_id);
					
					$type=$_SESSION['U_TYPE'];				   
					
					$insert_user_upgrade = $wpdb->query("INSERT INTO $TT_WHITELABEL_CENTER_LAB_USER_REGISTRATION SET type='$type',center_lab_id='".$_SESSION['USER_ID']."', whitelabel_id='".WHITELABEL_ID."', commission='$commission',user_id='$userID', plan_subscription_id='$order_id', payment_plan_id='$cmbPlans', plan_amount='$cost', wallet_deduction_amount='$plan_amount', discount='$discount', monthly_fee='$monthly_fee', total_payable_amount='$total_payable_amount',reg_date='$curDate',txn_type='SU'");
					
					$update_center_wallet = $wpdb->query("UPDATE $TT_CENTER_LAB_TOTAL_ID SET used_id=used_id + 1, last_used_date='$curDate' where center_lab_id=$center_id AND whitelabel_id=".WHITELABEL_ID);
					
					$insertintowalletDeduction = $wpdb->query("INSERT INTO $TT_WHITELABEL_CENTER_LAB_WALLET_DEDUCTION SET whitelabel_id='".WHITELABEL_ID."', center_lab_id='".$_SESSION['USER_ID']."', type='$type', actual_amount='$plan_amount', commission='$commission', commission_amount='$plan_amount', txn_type='SU', reference_id='$order_id', txn_date='$curDate'");


					//insert admin debit history
					updateWhtWallet($whtid, $txn_type, $order_id, $plan_amount, $remarks, $whtstatus); 
					
					//insert in wht plan ID history
					$insertPlanHistoryQuery = "INSERT INTO $TT_WHT_PLAN_HISTORY SET whitelabel_id='$whtid', user_id='$userID', plan_subscription_id='$order_id', payment_plan_id='$cmbPlans', date='$curDate'";
					$wpdb->query($insertPlanHistoryQuery);
						
					$message = "<div class='success' >Successfully upgrade a user. </div>";      
					/**************Deduct comissoion amount From admin wallet ************************/	
			
				  } else { 
				  	$message = "<div class='danger' >Insufficient Center Balance ! </div>"; 
				  }
				} else {
					$message = "<div class='danger' >Insufficient Center Balance ! </div>";	
				}
			} else if(sizeof($walletBalanceDetail)>0){
			
				$walletBalance=$walletBalanceDetail->total_amount - $walletBalanceDetail->used_amount;
				$payment_type_id=3;
									
				$center_lab_details = $wpdb->get_row("SELECT * FROM $TT_WHITELABEL_CENTER_LAB where id='$center_id' ");
				$commission=$center_lab_details->commission;				   
									
				if($commission > 0){
					$commission_amount = $cost*$commission/100;	
					$plan_amount = $cost - ($cost*$commission/100);
				} else {
					$commission_amount = 0;
					$plan_amount = $cost;
				}

				$total_payable_amount= ( $cost - $discount ) + $monthly_fee;
									
				if($walletBalance>=$plan_amount)
				{
					$success=TRUE;
					
					$payment_status='A';
					$active_status=1;
					$active_date =$curDate;
					$mock_test =$plan_detail->test; 
					$no_of_mock_test=$plan_detail->no_of_test; 
					$subject_test = $plan_detail->subject_mock_test;  
					$no_of_subject_test =$plan_detail->no_of_anyone_subject_test; 
					$tutorial =$plan_detail->tutorial; 
					$source ="whitelabel"; 
					$source_id= WHITELABEL_ID; 

					$order_id = insertWhtStudentPlanSubscription($userID, $cmbExams, $cmbPlans, $payment_status, $payment_type_id, $cost, $curDate, $active_status, $active_date, $mock_test, $no_of_mock_test, $subject_test, $no_of_subject_test, $tutorial, $source, $source_id);
				   
					$type=$_SESSION['U_TYPE'];				   
					
					$insert_user_upgrade = $wpdb->query("INSERT INTO $TT_WHITELABEL_CENTER_LAB_USER_REGISTRATION SET
					   type='$type',center_lab_id='".$_SESSION['USER_ID']."', whitelabel_id='".WHITELABEL_ID."',
					   commission='$commission',user_id='$userID', plan_subscription_id='$order_id', payment_plan_id='$cmbPlans', plan_amount='$cost',
					   wallet_deduction_amount='$plan_amount',discount='$discount',monthly_fee='$monthly_fee', 
					   total_payable_amount='$total_payable_amount',reg_date='$curDate',txn_type='SU'");
					
					$txn_type='SU';
					$remarks='Student upgrade';
					$operator_id=0;
					$whtstatus = 0; 
					
					$update_center_wallet = $wpdb->query("UPDATE $TT_WHITELABEL_CENTER_LAB_WALLET SET used_amount=used_amount + $plan_amount, last_used_amount = $plan_amount, last_used_date='$curDate' where center_lab_id=$center_id AND whitelabel_id=".WHITELABEL_ID);
					
					$insertintowalletDeduction = $wpdb->query("INSERT INTO $TT_WHITELABEL_CENTER_LAB_WALLET_DEDUCTION SET whitelabel_id='".WHITELABEL_ID."', center_lab_id='".$_SESSION['USER_ID']."', type='$type', actual_amount='$cost', commission='$commission', commission_amount='$commission_amount', txn_type='SU', reference_id='$order_id', txn_date='$curDate'");

					//insert admin debit history
					updateWhtWallet($whtid, $txn_type, $order_id, $commission_amount, $remarks, $whtstatus); 
					
					$message = "<div class='success' >Successfully upgrade a user. </div>";      
					/**************Deduct comissoion amount From admin wallet ************************/	
				
				} else {		
					$message = "<div class='danger' >Insufficient Balance ! </div>";	
				}
			} else {// end if to check center has balance
				$message = "<div class='danger' >Insufficient Balance ! </div>";
			}
		} // end if to check user id exist
		else
		{
			$message = "<div class='danger' >Sorry this user is not registered , please enter correct email ! </div>";
		}	
	}
?>

<div class="page-inner">
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-sm-6">
                        <h1 class="m-0 text-dark">Upgrade Student </h1>
                    </div><!-- /.col -->
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <!-- <li class="breadcrumb-item"><a href="#">Home</a></li>
                            <li class="breadcrumb-item active">Approve Students List </li> -->
                        </ol>
                    </div><!-- /.col -->
                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-sm-12" id="formRegister">
                        <div class="card card-secondary">
                            <div class="card-header">
                                <h3 class="card-title"> <i class="fa fa-user"></i>&nbsp; Please fill below form to Upgrade student</h3>
                            </div>
                            <?php if(isset($message)){ echo $message; } ?>

                    		<?php if(!$success) {  ?>
                    			<form action="" method="post" name="upgradeUser" id="upgradeUser" class="form-horizontal" onsubmit="return UpgradeUserForm()">
                    				<input type="hidden" id="whtID" name="whtID" value="<?php echo WHITELABEL_ID; ?>" />
                    				<div class="card-body">
										<div class="form-group row m-0">
											<!-- नाम या ईमेल द्वारा खोजें /  -->
			                                <label for="input-Default" class="col-sm-12 control-label">Search By Name or Email</label>
			                                <div class="col-sm-12">	   
												<input class="frmField txtEmail form-control" type="text" id="txtEmail" name="txtEmail" maxlength="60" />
												<!-- <span class="msg" id="txtEmailMsg">किसी भी यूजर को खोजने के लिए नाम या ईमेल टाइप करें</span> -->
											</div>
			                            </div>
										<div class="form-group row m-0">
											<!-- माध्यम /   -->
			                                <label for="input-Default" class="col-sm-2 control-label">Medium <span class="mandatory">*</span> : </label>
			                                <div class="col-sm-8">
												<select  name="cmbMedium" id="cmbMedium"  class=" form-control" >
													<?php
														$qryMedium = $wpdb->get_results("SELECT medium_id, medium_name FROM $TT_MEDIUM_TABLE");
														foreach ($qryMedium as $qryMediumValues) {
															$selected = "";
															echo "<option " . $selected . " value='" . $qryMediumValues->medium_id . "'>" . $qryMediumValues->medium_name . "</option>";
														}
													?>
												</select>
											</div>
			                            </div>
                            			<div class="form-group row m-0">
                            				<!-- प्लान /   -->
                            				<label for="input-Default" class="col-sm-2 control-label">Plan <span class="mandatory">*</span> : </label>
                            				<div class="col-sm-8">	
                                    			<?php 
													$allPlanQuery = "SELECT pw.* FROM $TT_PAYMENT_PLAN_WHITELABEL_TABLE AS pw INNER JOIN $TT_PAYMENT_PLAN_TABLE AS p ON p.payment_plan_id = pw.payment_plan_id WHERE pw.show_to_admin='1' and pw.blog_id='".WBLOG_ID."' ORDER BY p.display_order ASC";
													$qryPlans=$wpdb->get_results($allPlanQuery);
												?>
                                        		<select name="cmbPlans" id="cmbPlans" class="form-control">
                                            		<option value="0">Select Plan</option>
                                            		<?php
                                						foreach ($qryPlans as $qryPlansValues) {
                                        					echo "<option value='" . $qryPlansValues->payment_plan_id . "'>" . $qryPlansValues->plan_name . " [Rs. " . $qryPlansValues->cost . "]</option>";
                            							}
                                					?>
                                        		</select>
                                        		<span id="planPrice"></span>
			                                </div>
			                            </div>
			                            <div class="form-group row m-0" id="cmd_cat">
			                            	<!-- परीक्षा श्रेणी / -->
			                                <label for="input-Default" class="col-sm-2 control-label">Exam Category <span class="mandatory">*</span> : </label>
			                                     <div class="col-sm-8">			
			                                	<select name="cmbCategory" id="cmbCategory" class=" form-control">
			                                        <option value="0">Select</option>
			                                        <?php
			                                        foreach ($allCategories as $cat) {
			                                            echo "<option value='" . $cat->category_id . "'>" . $cat->category_name . "</option>";
			                                        }
			                                        ?>
			                                    </select> 
			                               </div>
			                            </div>
										<div class="form-group row m-0" id="cmd_exam">
											<!-- परीक्षाएं / -->
		                                  	<label for="input-Default" class="col-sm-2 control-label">Exams <span class="mandatory">*</span> : </label>
		                                    <div class="col-sm-8">
												<div id="cmb_exam">
													<select name="cmbExams" id="cmbExams"  class=" form-control">
														<option value="0">Select Exam</option>
													</select>
												</div>
											</div>
										</div> 
										<div class="form-group row m-0" id="cmd_sub" style="display:none;" >
			                            	<label for="input-Default" class="col-sm-2 control-label">Subject</label>
			                                <div class="col-sm-8">
			                                	<span id="cmb_subject">
			                                        <select  id="cmbSubject" name="cmbSubject" >
			                                            <option value="0">Select Subject</option>
			                                        </select>
			                                    </span>
			                                </div>
			                            </div>
										<div class="form-group row m-0">
											<label for="input-Default" class="col-sm-2 control-label">Monthly Fee :</label>
											<div class="col-sm-8">
												<input class="frmField txtFee form-control" type="text" id="monthly_fee" name="monthly_fee" maxlength="60" /> 
											</div>
										</div>
										<div class="form-group row m-0">
											<label for="input-Default" class="col-sm-2 control-label"> Discount:</label>
											<div class="col-sm-8">
												<input class="frmField txtFee form-control" type="text" id="discount" name="discount" maxlength="60" /> 
											</div>
										</div>
			                            <div class="form-group row m-0">
											<label for="input-Default" class="col-sm-2 control-label"></label>
											<div class="col-sm-8">
												<input type="submit" id="btn-upgrade" name="btn-upgrade" value="Upgrade Student" class="btn btn-primary" >
			                                    <input value="<?php echo WBLOG_ID; ?>"  type="hidden" name="blogID" id="blogID"/>
			                                    <input value="A"  type="hidden" name="wplace" id="wplace"/>
			                                    <input value="<?php echo ROOT_LINK; ?>"  type="hidden" name="url" id="url"/>
			                                    <input type="hidden" name="exam_type" id="exam_type" value=""/> 
											</div>
										</div>
									</div>
			                    </form>
			                <?php } ?>
		                    <?php 
								$exam_name=$wpdb->get_var("SELECT category_name FROM $TT_EXAM_CATEGORIES_TABLE WHERE exam_category_id=$cmbExams");
								$getPlanDetail = $wpdb->get_row("SELECT plan_name, cost, plan_validity FROM $TT_PAYMENT_PLAN_TABLE WHERE payment_plan_id='$cmbPlans' ");

								if($order_id !=''){
							?>
								<div class="card-body">
									<div class="form-group row m-0">
                            			<div class="col-md-12">
		                                	<div class="row" id="ereceipt">
		                                		<div class="invoice-box">
				                                    <div class="text-center">
				                                        <h1>Order No. # <?php echo $order_id; ?></h1>
				                                        <address class="successfully-registered">You have successfully Upgrade a user.</address>
				                                    </div>
				                                    <table class="table table-hover">
					                                    <tbody>
					                                        <tr>
					                                            <td><em>Exam Name </em></h4></td>
					                                            <td><?php echo $exam_name; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Plan Name </em></h4></td>
					                                            <td><?php echo $getPlanDetail->plan_name; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Validity </em></h4></td>
					                                            <td><?php echo $getPlanDetail->plan_validity; ?> months</td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Student Email Id </em></h4></td>
					                                            <td><?php echo $email; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Transaction Date</em></h4></td>
					                                            <td><?php echo $curDate; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Discount</em></h4></td>
					                                            <td>Rs. <?php echo $discount; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td><em>Monthly Fee</em></h4></td>
					                                            <td>Rs. <?php echo $monthly_fee; ?></td>
					                                        </tr>
					                                        <tr>
					                                            <td class="text-right"><h4><strong>Amount Paid :</strong></h4></td>
					                                            <td class="text-center text-danger"><h4><strong>Rs. <?php echo ($getPlanDetail->cost - $discount + $monthly_fee ); ?></strong></h4></td>
					                                        </tr>
				                                        </tbody>
				                                    </table>
			                                     	<address> 
			                                     		Login to <a target="_blank" href="<?php echo $Site_domain_name; ?>"><?php echo $Site_domain_name; ?></a> to take the test. </br>
			                                     		Best of Luck for your examination. </br>
			                                     		For any other query please mail 
			                                    		<a target="_top" href="mailto:<?php echo $Site_email; ?>"><?php echo $Site_email; ?></a>
			                                		</address>
			                                	</div>
                                			</div>
                                			<div class="row" style="text-align:center;">
                                    			<a style="color:#fff !important;" href="#" class="btn btn-primary no-print" name="print" onclick="UpgradePrintReport('ereceipt')">Print Receipt</a>
                                			</div>
                                			<script type="text/javascript">
                                				function UpgradePrintReport(divName1) {
					                                var printContents = document.getElementById(divName1).innerHTML;
					                                document.title = "\u00A0";
					                    
					                                var disp_setting="toolbar=no,location=no,directories=no,menubar=no,";
					                                disp_setting+="scrollbars=no,left=0,top=0,resizable=yes,width=900, height=650,";
					                                var docprint=window.open("","",disp_setting);
					                                docprint.document.open();
					                                docprint.document.write('<html dir="<%=_direction %>"><head><title></title>');
					                                //For Adding the proper StyleSheet
					                                docprint.document.write('</head><body>');
					                                docprint.document.write(printContents);
					                                docprint.document.write("</b"+"ody></html>");
					                                docprint.print();
					                                docprint.close();
					                                window.close();
				                                }
                                			</script>   
                            			</div>
                        			</div>
                    			</div>
                    		<?php } ?>
            			</div>
        			</div>
    			</div><!-- Row -->
			</div><!-- Main Wrapper -->		
		</section>
	</div>
</div>

<?php include_once 'footer.php'; ?>

<script>
	jQuery(function($) {
		$( ".txtEmail" ).keydown(function(event) {
		  	$( "#"+event.target.id ).autocomplete({
			   source: '<?php echo $root_link . '/backend/lab-search-user.php?blog_id='.$blog_id.''; ?>',
			  minLength: 2,
			});
		});
  	});
</script>

<script type="text/javascript">
	function UpgradeUserForm() {
	    var txtEmail = document.forms["upgradeUser"]["txtEmail"].value;
	    var cmbPlans = document.forms["upgradeUser"]["cmbPlans"].value;
	    var cmbCategory = document.forms["upgradeUser"]["cmbCategory"].value;
	    var cmbExams = document.forms["upgradeUser"]["cmbExams"].value;
		var exam_type = document.forms["upgradeUser"]["exam_type"].value;

	    if (jQuery('#txtEmail').val() == "") {
	        toastr.error("Please enter login Name.");
	        jQuery('#txtEmail').focus();
	        return false;
	    }

		if (jQuery('#cmbPlans').val() == "0") {
	        toastr.error("Please select Plan");
	        jQuery('#cmbPlans').focus();
	        return false;
	    }

		if (jQuery('#exam_type').val() != "AE"){
		    if (jQuery('#cmbCategory').val() == "0") {
	            toastr.error("Please select Exam Category");
	            jQuery('#cmbCategory').focus();
	            return false;
	        }
		
		   	if (jQuery('#cmbExams').val() == "0") {
	            toastr.error("Please select Exam ");
	            jQuery('#cmbExams').focus();
	            return false;
	        }
		}
	}
    // category change to get exams
    jQuery(document).on('change', '#cmbCategory', function(){
    	updateExam();  
    });

    function updateExam(){
        var categoryId = jQuery('#cmbCategory').val();
        var medium = jQuery('#cmbMedium').val();
    	var plan_id = jQuery('#cmbPlans').val();
        var url = jQuery('#url').val();
    	var type = "wht";

        var siteUrl = url + "/wp-content/plugins/tet-india/vendorapi/tt_get_exams_wht.php?categoryId=" + categoryId + "&mediumId=" + medium + "&type=" + type+ "&pID=" + plan_id ;
    	
        // alert(siteUrl);
        jQuery.ajax({
            type: "GET",
            url: siteUrl,
            cache: false,
            dataType: "jsonp",
            jsonpCallback: 'successCallback',
            success: function(data)
            {
                jQuery('#cmb_exam').empty();
                jQuery.each(data, function(i, row)
                {
                    //  alert('succ'+row.strMessage);
                    jQuery('#cmb_exam').append(row.strMessage);
                    //updateSubject(); // line no. 210
                });
            },
            error: function onError(jqXHR, errorThrown) {
                //  alert('Network error has occurred please try again! ');
            }
        });   
    }

</script>

<script src="js/toastr.min.js"></script>
<script type="text/javascript" language="javascript">
    toastr.options = {
        "closeButton": true,
        "debug": false,
        "positionClass": "toast-top-full-width",
        "onclick": null,
        "showDuration": "300",
        "hideDuration": "1000",
        "timeOut": "2000",
        "extendedTimeOut": "1000",
        "showEasing": "swing",
        "hideEasing": "linear",
        "showMethod": "slideDown",
        "hideMethod": "hide"
    };
</script>