File: /var/www/grapossconnect/center-admin/shine-response.php
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include_once('header.php');
include_once('shine_config.php');
$AGENTS_WALLET = 'grp_agents_wallet';
if ($_REQUEST) {
$curDate = date('Y-m-d H:i:s');
$sclassId = $_REQUEST['class_id'];
$ssubjectId = $_REQUEST['subject_id'];
$user_name = $_REQUEST['name'];
$user_email = $_REQUEST['email'];
$u_phone = $_REQUEST['mobile'];
$user_state = $_REQUEST['state_id'];
$user_city = $_REQUEST['city_id'];
$school_name = $_REQUEST['school_name'];
$guardian = $_REQUEST['guardian'];
$dbirth = $_REQUEST['dob'];
$gender = $_REQUEST['gender'];
$finalDeduct = $_REQUEST['finalDeduct'];
$txn_amount = $_REQUEST['txn_amount'];
$product_id = $_REQUEST['product_id'];
$productAmount = $_REQUEST['productAmount'];
$temp_id = $_REQUEST['temp_id'];
//check if exist
$existTemp = $wpdb->get_row("SELECT status from grp_agents_form_data where id='$temp_id'");
if ($existTemp->status == 0) {
$checkWalletBalance = $wpdb->get_var("SELECT balance_amount from grp_agents_wallet where agent_id='$AGENT_ID'");
//gst
//GST//
if ($user_state == '36') {
$amount = $finalDeduct;
$total_amount = round(($amount / 118 * 100), 2);
$igst_amount = 0;
$cgst_amount = round(($total_amount * 9 / 100), 2);
$sgst_amount = round(($total_amount * 9 / 100), 2);
$grand_amount = round((($amount / 118 * 100) + ($total_amount * 9 / 100) + ($total_amount * 9 / 100)), 2);
} else {
$cgst_amount = 0;
$sgst_amount = 0;
$amount = $finalDeduct;
$total_amount = round(($amount / 118 * 100), 2);
$igst_amount = round(($total_amount * 18 / 100), 2);
$grand_amount = round((($amount / 118 * 100) + ($total_amount * 18 / 100)), 2);
}
$amount_to_gp = $txn_amount - $finalDeduct;
//GST//
//echo "Wallet " . $checkWalletBalance;
//echo "Dedeuct " . $finalDeduct;
if ($checkWalletBalance >= $finalDeduct) {
$userData = array(
"sclassId" => $_REQUEST['class_id'],
"subject_id" => $_REQUEST['subject_id'],
"name" => $_REQUEST['name'],
"email" => $_REQUEST['email'],
"mobile" => $_REQUEST['mobile'],
"state_id" => $_REQUEST['state_id'],
"city_id" => $_REQUEST['city_id'],
"school_name" => $_REQUEST['school_name'],
"guardian" => $_REQUEST['guardian'],
"dob" => $_REQUEST['dob'],
"agent_id" => $AGENT_ID
);
$data = json_encode($userData);
//create user
include_once 'wallet_function.php';
$userResp = createUser($data);
if ($userResp->status == 1) {
$user_id = $userResp->shineid;
$username = $userResp->shine_user_name;
//makeWalletTxn
$makeWalletTxn = makeWalletTxn($AGENT_ID, $AGENT_CODE, $product_id, $txn_amount, $finalDeduct, $user_id);
if ($makeWalletTxn['status'] == 1) {
$pgST = 1;
$txn_id = $makeWalletTxn['txn_id'];
$updateTemp = $wpdb->query("UPDATE grp_agents_form_data set user_id='$user_id',status='1' where id='$temp_id'");
unset($_SESSION['temp']);
//insert data in shine plan subscription with its config
$subject_id = explode(",", $ssubjectId);
foreach ($subject_id as $exam_id) {
$insertPlansubs = "INSERT into wp_shine_tt_plan_subscription set user_id='$user_id', type='GEPL', exam_category_id='$exam_id', amount='$productAmount', active_status='1', active_date='$curDate',mock_test='Y', no_of_mock_test='5', grade='$sclassId', state='$user_state', school_name='$school_name', source= 'GEPL-CEN', source_id='$AGENT_ID'";
$conn->query($insertPlansubs);
}
$user_password = date("dmY", strtotime($dbirth));
//subject
$getMailsubjects = $conn->query("SELECT GROUP_CONCAT(category_name) as subjects FROM wp_shine_tt_exam_categories where exam_category_id IN($ssubjectId) order by exam_category_id");
$rowsubjects = $getMailsubjects->fetch_array();
$subjects = $rowsubjects['subjects'];
//subject
include_once '../include/mail-functions.php';
sendSubscriptionmail($user_name, $username, $user_password, $subjects, $sclassId, $txn_id, $user_email);
}
}
}
$msg = "Transaction success done";
} else {
$pgST = 0;
$msg = "Transaction already done";
}
}
?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
<div class="page-inner">
<div id="main-wrapper">
<section class="enroll-details-page-section">
<div class="container">
<?php if($pgST == 1){ ?>
<div class="row"><button type="button" class="btn btn-primary" onclick="printDiv('printinvoice')">Print Invoice</button></div>
<div class="row" style="margin: 10px;" id="printinvoice">
<?php
function convertToIndianCurrency($number)
{
$no = round($number);
$decimal = round($number - ($no = floor($number)), 2) * 100;
$digits_length = strlen($no);
$i = 0;
$str = array();
$words = array(
0 => '',
1 => 'One',
2 => 'Two',
3 => 'Three',
4 => 'Four',
5 => 'Five',
6 => 'Six',
7 => 'Seven',
8 => 'Eight',
9 => 'Nine',
10 => 'Ten',
11 => 'Eleven',
12 => 'Twelve',
13 => 'Thirteen',
14 => 'Fourteen',
15 => 'Fifteen',
16 => 'Sixteen',
17 => 'Seventeen',
18 => 'Eighteen',
19 => 'Nineteen',
20 => 'Twenty',
30 => 'Thirty',
40 => 'Forty',
50 => 'Fifty',
60 => 'Sixty',
70 => 'Seventy',
80 => 'Eighty',
90 => 'Ninety'
);
$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
while ($i < $digits_length) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += $divider == 10 ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$str[] = ($number < 21) ? $words[$number] . ' ' . $digits[$counter] . $plural : $words[floor($number / 10) * 10] . ' ' . $words[$number % 10] . ' ' . $digits[$counter] . $plural;
} else {
$str[] = null;
}
}
$Rupees = implode(' ', array_reverse($str));
$paise = ($decimal) ? "And Paise " . ($words[$decimal - $decimal % 10]) . " " . ($words[$decimal % 10]) : '';
return ($Rupees ? 'Rupees ' . $Rupees : '') . $paise . " Only";
}
?>
<table style="width: 100%;margin-bottom: 15px;">
<tr>
<th colspan="2" style="border: 1px solid #b8b8b8;text-align: center;padding: 5px;color: #000;font-weight: 900;"> INVOICE CUM-RECEIPT </th>
</tr>
<tr>
<td style="border: 1px solid #b8b8b8;padding: 10px;text-align: center;">
<span style="display: block;font-weight: 800;color: #000;font-size: 18px;">Graposs Edutech Private Limited</span>
<span style="display: block;font-weight: 600;color: #000;padding: 4px 0;">(CIN: U80301DL2011PTC226155)</span>
<span style="display: block;font-weight: 600;color: #000;font-size: 12px;">71/22, 2nd Floor, Asaf Ali Road, New Delhi-110002</span>
<div style="display: flex;justify-content: space-between;margin: 10px 0;">
<span style="font-size: 12px;font-weight: 700;">GSTIN: 07AAECG4440M1ZH</span>
<span style="font-size: 12px;font-weight: 700;">PAN: AAECG4440M</span>
</div>
<table style="width: 100%;">
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Receipt No: <?php echo $txn_id; ?></td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Date: <?php echo date("d/m/Y", strtotime($curDate)); ?></td>
</tr>
<tr>
<td colspan="2" p[] style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Beneficiary Id: <?php echo $user_id; ?></td>
</tr>
<tr>
<td colspan="2" p[] style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Beneficiary Name: <?php echo $user_name; ?></td>
</tr>
<tr>
<td colspan="2" p[] style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Mobile No: <?php echo $u_phone; ?></td>
</tr>
<tr>
<td colspan="2" p[] style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Service Name: Shine Olympiad</td>
</tr>
<tr>
<td colspan="2" p[] style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Center Code: <?php echo $AGENT_CODE; ?></td>
</tr>
</table>
</td>
<td style="border: 1px solid #b8b8b8;padding: 10px;text-align: center;">
<img style="display: block;margin: 0 auto;width: 70%;margin-bottom: 15px;" src="https://grapossconnect.com/images/graposs-logo.png" alt="">
<table style="width: 100%;">
<tr>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: left;">Description of Service</th>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: left;">SAC</th>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: right;">Taxable Value (Rs.)</th>
</tr>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Shine Olympiad (<?php echo $sclassId; ?>) </td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">9992</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;text-align:right;">₹ <?php echo number_format($total_amount, 2); ?></td>
</tr>
<?php if ($user_state == '36') { ?>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Add - CGST @9%</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;"></td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;text-align:right;">₹ <?php echo number_format($cgst_amount, 2); ?></td>
</tr>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Add - SGST @9%</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;"></td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;text-align:right;">₹ <?php echo number_format($sgst_amount, 2); ?></td>
</tr>
<?php } else { ?>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Add - IGST @18%</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;"></td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;text-align:right;">₹ <?php echo number_format($igst_amount, 2); ?></td>
</tr>
<?php } ?>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 900;">Total</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;"></td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;text-align:right;">₹ <?php echo number_format($grand_amount, 2); ?></td>
</tr>
<tr>
<td colspan="3" style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;"><span style="font-weight: 900;">Total:</span> <?php echo convertToIndianCurrency($grand_amount); ?></td>
</tr>
<tr>
<td colspan="3" style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;">Tax is payable on Reverse Charges Basis (N)</td>
</tr>
<tr>
<td colspan="3" style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;">This is a computer-generated receipt, signature is not required</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" style="font-size: 12px; border: 1px solid #b8b8b8;text-align: center;padding: 5px;color: #000;font-weight: 900;">
---------- End of the Fee Receipt ---------- </td>
</tr>
</table>
<h4 style="text-align: center;font-size: 14px;font-weight: 700;color: #000;margin-bottom: 10px;">For enquiry and other details, Beneficiary may contact on info@grapossconnect.com or +91-844 855 3963</h4>
<table style="width: 100%;">
<tr>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: left;">Shine Olympiad</th>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: left;">Consolidated Service Charges Summary (Rs.)</th>
</tr>
<tr>
<td style="border: 1px solid #b8b8b8;text-align: center;padding: 10px;color: #000;font-weight: 900;">
<img style="width: 200px;" src="https://shineolympiad.com/wp-content/themes/shineolympiad/images/logo-shine.png" alt="">
</td>
<td style="border: 1px solid #b8b8b8;text-align: center;padding: 10px;color: #000;font-weight: 900;">
<table style="width: 100%;">
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Center share for Facilitation inclusive all (Retained by the Center itself) *</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: right;font-weight: 600;">₹ <?php echo number_format($amount_to_gp, 2); ?></td>
</tr>
<tr>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">Graposs Edutech Private Limited Share</td>
<td style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: right;font-weight: 600;">₹ <?php echo number_format($finalDeduct, 2); ?></td>
</tr>
<tr>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: left;">Total Amount payable by Beneficiary (in Rs.)</th>
<th style="border: 1px solid #000000;padding: 6px 10px;background: #cbcbcb;font-size: 12px;color: #000;text-align: right;">₹ <?php echo number_format($txn_amount, 2); ?></th>
</tr>
<tr>
<td colspan="2" style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">
Beneficiary shall be liable for making full payment of Services ₹ <?php echo number_format($txn_amount, 2); ?> at Registeration Center on behalf of Center & Graposs Edutech Private Limited to confirm the Enrollment for Services.
</td>
</tr>
<tr>
<td colspan="2" style="border: 1px solid #000000;padding: 6px 10px;font-size: 12px;color: #000;text-align: left;font-weight: 600;">
* For Center share, Beneficiary may obtain a separate Fee Receipt / Bill of Supply from the Center.
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<?php } else { ?>
<div class="row">
<div class="text-center"> Insufficient balance, please recharge your wallet</div>
<div class="text-center"><a href="home" class="btn btn-primary">Back To Home</a></div>
</div>
<?php } ?>
</div>
</section>
</div>
</div>
<script>
function printDiv(divName) {
var printContents = document.getElementById(divName).innerHTML;
var originalContents = document.body.innerHTML;
document.body.innerHTML = printContents;
window.print();
document.body.innerHTML = originalContents;
}
</script>
<?php
include_once('footer.php');
?>