File: /var/www/grapossconnect/center-admin/shine-registration.php
<?php
include_once('header.php');
$GRP_PRODUCTS = 'grp_product';
$GRP_PRODUCT_CATEGORY = 'grp_product_category';
$TT_STATES_TABLE = 'grp_states';
$OLY_EXAMS = 'grp_oly_exams';
$SP_MEDIUM = 'grp_medium';
$AGENTS_WALLET = 'grp_agents_wallet';
/** get class **/
$classData = $wpdb->get_results("SELECT DISTINCT class_id, class_name FROM $OLY_EXAMS WHERE status='1' ORDER BY substr(class_id,7)*1");
/** get state **/
$states = $wpdb->get_results("SELECT state_id, state_name FROM $TT_STATES_TABLE ORDER BY state_name ASC ");
/** get mediums **/
$allMediums = $wpdb->get_results("SELECT medium_id,medium_name FROM $SP_MEDIUM order by medium_id asc");
/** Product Amount**/
$checkAmount = $wpdb->get_var("SELECT `product_amount` FROM $GRP_PRODUCTS WHERE `product_id`='1' AND `status`='A'");
$productAmount = ($checkAmount) ? ($checkAmount) : (300);
$checkComm = $wpdb->get_row("SELECT `comm_share_type`, `commission_agent` FROM $AGENT_COMMISSION WHERE `agent_id`='$AGENT_ID' AND `product_id`='1' AND `active` = '1'");
if ($checkComm->comm_share_type == 'P') {
$commAmount = ($checkComm->commission_agent / 100) * $productAmount;
$finalDeduct = $productAmount - $commAmount;
} else if ($checkComm->comm_share_type == 'A') {
$commAmount = $checkComm->commission_agent;
$finalDeduct = $productAmount - $commAmount;
}
//wallet
$checkWallet = $wpdb->get_var("SELECT `balance_amount` FROM $AGENTS_WALLET WHERE `agent_id`='$AGENT_ID' AND `agent_code`='$AGENT_CODE'");
?>
<link href="assets/shine.css" rel="stylesheet">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
<div class="page-inner">
<div id="main-wrapper">
<div class="page-title">
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="home">Home</a></li>
<li class="active">Shine Olympiad</li>
</ol>
</div>
<h3>Student Registration</h3>
</div>
<section class="enroll-details-page-section" style="margin-bottom: 20px;">
<div class="container">
<?php if ($finalDeduct <= $checkWallet) { ?>
<div class="row">
<form method="POST" name="registerForm" action="shine-process.php" class="ajax-form formatted-form row m-0" onSubmit="return validateForm();">
<div class="col-md-12 col-sm-12 col-xs-12">
<h4>Select Your Grade & Preferred Language To Register Student</h4>
<select name="grade_id" id="grade_id">
<option value="0">-- Select Your Grade --</option>
<?php foreach ($classData as $cl) { ?>
<option value="<?php echo $cl->class_id; ?>"><?php echo $cl->class_name; ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="ChooseLanguage-box">
<div class="ChooseLanguage-flex">
<?php foreach ($allMediums as $md) { ?>
<label>
<img src="https://shineolympiad.com/wp-content/themes/shineolympiad/images/enroll-lang/<?= $md->medium_name; ?>.png" alt="English">
<div style="display: flex; align-items: center;">
<input type="radio" name="my_medium" class="form-control my_medium" id="cmbMedium" value="<?php echo $md->medium_id ?>" <?php if ($md->medium_id == 1) echo "checked"; ?>> <?= $md->medium_name; ?>
</div>
</label>
<?php } ?>
</div>
</div>
</div>
<div id="discount-loading" style="text-align:center;"></div>
<div class="col-md-5 col-sm-6 col-xs-12">
<div class="enroll-details-page-box">
<div class="enroll-details-h3-box">
<h3>Olympiad price per subject </h3>
<h6> MRP <span> ₹<?= $productAmount; ?>/- </span> </h6>
</div>
<div id="result"> <span style="padding:23px;"> <i class='fas fa-hand-point-up fa-2x'></i> Select your Grade First</span></div>
</div>
</div>
<div class="col-md-7 col-sm-6 col-xs-12 ">
<div class="enroll-listed-page-box queryform-page">
<h5>Fill The Form</h5>
<div class="form-group">
<label for="">Student Name <span>*</span></label>
<input type="text" placeholder="Enter Student Name" id="student_name" name="student_name">
</div>
<div class="form-group">
<label for="">Father Name <span>*</span></label>
<input type="text" placeholder="Enter Your Father Name" id="father_name" name="father_name">
</div>
<div class="form-group">
<label for="">Email Id <span>*</span></label>
<input type="text" placeholder="Enter Your Email Id" id="student_email" name="student_email">
</div>
<div class="form-group">
<label for="">Mobile Number <span>*</span></label>
<input type="text" placeholder="Enter Your Mobile Number" id="student_mobile" name="student_mobile">
</div>
<div class="form-group">
<label for="">State <span>*</span></label>
<select name="cmbState" id="cmbState">
<option value="0">-- State --</option>
<?php foreach ($states as $st) { ?>
<option value="<?php echo $st->state_id; ?>"><?php echo $st->state_name; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label for="">City <span>*</span></label>
<select name="cmbCity" id="cmbCity">
<option value="0">-- City --</option>
</select>
</div>
<div class="form-group">
<label for="">Pincode <span>*</span></label>
<input type="text" name="u_pinc" id="u_pinc" placeholder="Enter Pincode">
</div>
<div class="form-group">
<label for="">Date Of Birth <span>*</span></label>
<input type="date" name="userdob" id="userdob" placeholder="Date Of Birth">
</div>
<div class="form-group" style="width: 100%;">
<label for="">School Name </label>
<input type="text" placeholder="Enter Your School Name" id="school_name" name="school_name">
</div>
<div class="row">
<hr>
<div class="col-md-7 col-sm-7 col-xs-12" style="color: red; font-weight: 600; margin-bottom: 15px;">
<div id="valueList"></div>
</div>
<div class="col-md-12 col-sm-12 col-xs-12">
<div id="error-msg"></div>
<button id="btnRegister" name="btnRegister" type="submit" class="btn btn-lg btn-danger btn-block btn-signin submit_btn">BUY NOW</button>
</div>
</div>
</div>
</div>
</form>
</div>
<?php } else { ?>
<div class="row">
<div class="alert alert-warning" role="alert">
Insufficient balance, please recharge your wallet ..! <a href="add-money" class="alert-link">Recharge Now</a>
</div>
</div>
<?php } ?>
</div>
</section>
</div>
<div class="page-footer">
<p class="no-s">grapossconnect.com</p>
</div>
</div>
<script>
jQuery(document).ready(function($) {
var checkArray = [];
$("#grade_id").change(function() {
$("#discount-loading").addClass("loading_image");
var grade = $(this).val();
var myMedium = $("input[name='my_medium']:checked").val();
$("#examID").val("");
checkArray = [];
if (grade == '0') {
toastr.error("Select Grade", {
"timeOut": "0",
"extendedTImeout": "0"
});
jQuery('#grade_id').focus();
} else if (myMedium == '' || myMedium == undefined) {
toastr.info("Select Medium", {
"timeOut": "0",
"extendedTImeout": "0"
});
} else {
$("#gradeId").val(grade);
grade = grade.replace(/ /g, '%20');
$("#result").load("https://shineolympiad.com/wp-content/plugins/tet-india/vendorapi/tt_choose_subjects.php?eclass_id=" + grade + "&emedium=" + myMedium);
$("#discount-loading").removeClass("loading_image");
}
});
$(".my_medium").change(function() {
var grade = $("#grade_id").val();
var myMedium = $("input[name='my_medium']:checked").val();
if (grade == '0') {
return false;
} else {
$("#gradeId").val(grade);
grade = grade.replace(/ /g, '%20');
$("#result").load("https://shineolympiad.com/wp-content/plugins/tet-india/vendorapi/tt_choose_subjects.php?eclass_id=" + grade + "&emedium=" + myMedium);
}
});
$(document).on('click', '.select_exams', function() {
jQuery("#tt_discount_code_msg").hide();
jQuery("#tt_discount_code").show()
var checkboxes = $('input:checkbox:checked').length;
$("#tt_discount_reply").css("display", "none");
$("#se_discCode").val("");
var amount = <?= $productAmount; ?>;
var note = '';
var total_amount = checkboxes * amount;
$("#show_amount").html(": ₹ " + total_amount);
$("#pcost").val(total_amount);
jQuery('#valueList').html('<div class="plan-amt-bill-box">Total Plan Amount to Pay: <span>₹ ' + total_amount + '/-</span></div><input type="hidden" name="total_pay" value="' + total_amount + '">');
if (jQuery.inArray(this.value, checkArray) == -1) {
checkArray.push(this.value);
} else {
checkArray.indexOf(this.value) !== -1 && checkArray.splice(checkArray.indexOf(this.value), 1);
}
var result = checkArray.join(", ");
$("#examID").val(result);
});
});
//cities
$("#cmbState").change(function() {
var state = $(this).val();
if (state == '0') {
toastr.error("Select state", {
"timeOut": "0",
"extendedTImeout": "0"
});
jQuery('#cmbState').focus();
return false;
} else {
state = state.replace(/ /g, '%20');
$("#cmbCity").load("api/get_city.php?state=" + state);
}
});
//validate form
jQuery(document).on('click', '#btnRegister', function (e) {
validateForm();
});
function validateEmail($email) {
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
if (!emailReg.test($email)) {
return false;
} else {
return true;
}
}
function validateMobile($mobile) {
var mobilePat = /^\d{10}$/;
if (!mobilePat.test($mobile)) {
return false;
} else {
return true;
}
}
function validatePincode($pincode) {
var pinPat = /^\d{6}$/;
if (!pinPat.test($pincode)) {
return false;
} else {
return true;
}
}
function validateForm() {
if (jQuery('#grade_id').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select grade id.</div>');
jQuery('#grade_id').focus();
return false;
} else if (jQuery('#grade_id').val() == "0") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Grade id should not be empty.</div>');
jQuery('#grade_id').focus();
return false;
} else if (jQuery('#cmbMedium').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select Medium.</div>');
jQuery('#cmbDOBYear').focus();
return false;
} else if ($('input[name="examID[]"]:checked').length == 0){
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select Exam Name.</div>');
// jQuery('#examID').focus();
return false;
} else if (jQuery('#student_name').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Name should not be empty.</div>');
jQuery('#student_name').focus();
return false;
}
if (jQuery('#father_name').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Father Name should not be empty.</div>');
jQuery('#father_name').focus();
return false;
} else if (jQuery('#student_email').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Email should not be empty.</div>');
jQuery('#student_email').focus();
return false;
} else if (!validateEmail(jQuery('#student_email').val())) {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please enter a valid email.</div>');
jQuery('#student_email').focus();
return false;
} else if (jQuery('#student_mobile').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please enter your phone number.</div>');
jQuery('#student_mobile').focus();
return false;
} else if (!validateMobile(jQuery('#student_mobile').val())) {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please enter a valid mobile no of 10 digit only</div>');
jQuery('#student_mobile').focus();
return false;
} else if (jQuery('#cmbState').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select State.</div>');
jQuery('#cmbState').focus();
return false;
} else if (jQuery('#cmbState').val() == "0") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">State should not be empty.</div>');
jQuery('#cmbState').focus();
return false;
} else if (jQuery('#cmbCity').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select City.</div>');
jQuery('#cmbCity').focus();
return false;
} else if (jQuery('#cmbCity').val() == "0") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">City should not be empty.</div>');
jQuery('#cmbCity').focus();
return false;
} else
if (jQuery('#u_pinc').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please enter pincode.</div>');
jQuery('#u_pinc').focus();
return false;
}
else if (!validatePincode(jQuery('#u_pinc').val())) {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please enter a valid pincode of 6 digit only</div>');
jQuery('#u_pinc').focus();
valid = false;
return false;
} else if (jQuery('#userdob').val() == "") {
$("#error-msg").html('<div class="alert alert-danger" role="alert">Please select Date Of Birth.</div>');
jQuery('#userdob').focus();
return false;
}
return true;
}
</script>
<?php
include_once('footer.php');
?>