Viewing file:  meTrnSuccess.php (21.7 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/**
* This Is the Kit File To Be included For Transaction Request/Response
*/
include 'AWLMEAPI.php';
//create an Object of the above included class
$obj = new AWLMEAPI();
/* This is the response Object */
$resMsgDTO = new ResMsgDTO();
/* This is the request Object */
$reqMsgDTO = new ReqMsgDTO();
//This is the Merchant Key that is used for decryption also
// $enc_key = "e1a1cf35429f651fc4ead3714b6203f5";
$enc_key = "4bdaaee26f91fee315833f5e90cb945d";
/* Get the Response from the WorldLine */
$responseMerchant = $_REQUEST['merchantResponse'];
$response = $obj->parseTrnResMsg( $responseMerchant , $enc_key );
include 'sendgrid_mail.php';
?>
<style>
body{
font-family:Verdana, sans-serif ;
font-size::12px;
}
.wrapper{
width:980px;
margin:0 auto;
}
table{
}
tr{
padding:5px
}
td{
padding:5px;
}
input{
padding:5px;
}
</style>
<!-- <form action="testTxnStatus.php" method="POST" >
<center> <H3>Transaction Status </H3></center>
<table>
<tr> --><!-- PG transaction reference number-->
<!-- <td><label for="txnRefNo">Transaction Ref No. :</label></td>
<td><?php $response->getPgMeTrnRefNo();?></td> -->
<!-- Merchant order number-->
<!-- <td><label for="orderId">Order No. :</label></td>
<td><?php $response->getOrderId();?> </td> -->
<!-- Transaction amount-->
<!-- <td><label for="amount">Amount :</label></td>
<td><?php $response->getTrnAmt();?></td>
</tr>
<tr> --><!-- Transaction status code-->
<!-- <td><label for="statusCode">Status Code :</label></td>
<td><?php $response->getStatusCode();?></td> -->
<!-- Transaction status description-->
<!-- <td><label for="statusDesc">Status Desc :</label></td>
<td><?php $response->getStatusDesc();?></td> -->
<!-- Transaction date time-->
<!-- <td><label for="txnReqDate">Transaction Request Date :</label></td>
<td><?php $response->getTrnReqDate();?></td>
</tr>
<tr> -->
<!-- Transaction response code-->
<!-- <td><label for="responseCode">Response Code :</label></td>
<td><?php $response->getResponseCode();?></td> -->
<!-- Bank reference number-->
<!-- <td><label for="statusDesc">RRN :</label></td>
<td><?php $response->getRrn();?></td> -->
<!-- Authzcode-->
<!-- <td><label for="authZStatus">AuthZCode :</label></td>
<td><?php $response->getAuthZCode();?></td>
</tr>
<tr> --> <!-- Additional fields for merchant use-->
<!-- <td><label for="addField1">Add Field 1 :</label></td>
<td><?php $response->getAddField1();?></td>
<td><label for="addField2">Add Field 2 :</label></td>
<td><?php $response->getAddField2();?></td>
<td><label for="addField3">Add Field 3 :</label></td>
<td><?php $response->getAddField3();?></td>
</tr>
<tr>
<td><label for="addField4">Add Field 4 :</label></td>
<td><?php $response->getAddField4();?></td>
<td><label for="addField5">Add Field 5 :</label></td>
<td><?php $response->getAddField5();?></td>
<td><label for="addField6">Add Field 6 :</label></td>
<td><?php $response->getAddField6();?></td>
</tr>
<tr>
<td><label for="addField7">Add Field 7 :</label></td>
<td><?php $response->getAddField7();?></td>
<td><label for="addField8">Add Field 8 :</label></td>
<td><?php $response->getAddField8();?></td>
</tr>
</table>
</form> -->
<?php
require 'connection.php';
$status=$response->getStatusCode();
$fname = $response->getAddField1();
$phone = $response->getAddField2();
$email = $response->getAddField3();
$email_new = $response->getAddField3();
$course_id = $response->getAddField4();
$message = $response->getAddField5();
$user_id=$response->getAddField6();
$amount = $response->getTrnAmt();
$txn_reference_no=$response->getPgMeTrnRefNo();
$bank_reference_no=$response->getOrderId();
$statusDesc=$response->getStatusDesc();
$txn_date=$response->getTrnReqDate();
$item_code=$response->getResponseCode();
$amount=$amount/100;
$status;
if($status=='S')
//if($status=='F')
{
$status="Success";
//show success message
//echo"success";
$course_id = $course_id;
$result = $con->query("SELECT * FROM course_details WHERE id='" . $course_id . "'");
$row = $result->fetch_assoc();
$course = $row['name'];
$pay = 'Online';
/* MAIL TO ADMIN */
//$to = "athirasurendran.sics@gmail.com";
// $to = 'srishticampusteam@srishtis.com';
//$to ="srishticampusteam@srishtis.com";
$subject = "Srishti-Enrollment Info";
/*$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: Srishti <srishticampusteam@gmail.com>' . "\r\n";*/
$output = "<div style='font-size:15px;border-style: outset;'><table style='margin-left:40px;'><tr><td><caption><h4>New Candidate Details</h4></caption></td></tr><tr><td>Name:</td><td>" . $fname . " </td></tr><tr><td>Phone:</td><td>" . $phone . "</td></tr><tr><td>Email:</td><td>" . $email . "</td></tr><tr><td>Course:</td><td>" . $course . "</td></tr><tr><td>Payment:</td><td>" . $pay . "</td></tr><tr><td>Amount:</td><td>" . $amount . "</td></tr><tr><td>Message:</td><td>" . $message . "</td></tr></table></div></br>";
/* MAIL TO ADMIN */
$sql = "insert into enrolldetails(user_id,course_id,course,amount,paymethod,message,paymentstatus,package) values('$user_id','$course_id','$course','$amount','$pay','$message','Completed','$course')";
// echo "insert into enrolldetails(user_id,course_id,course,amount,paymethod,message,paymentstatus) values('$user_id','$course_id','$course','$amount','$pay','$message','Completed')";
$result = $con->query($sql);
$lastid = $con->insert_id;
$count = $con->affected_rows;
// create new sendgrid mail
$email = new \SendGrid\Mail\Mail();
// specify the email/name of where the email is coming from
$email->setFrom( FROM_EMAIL, FROM_NAME );
// set the email subject line
$email->setSubject( $subject );
// specify the email/name we are sending the email to
$email->addTo( TO_EMAIL, TO_NAME );
// add our email body content
$email->addContent("text/html", $output);
// create new sendgrid
$sendgrid = new \SendGrid( SENDGRID_API_KEY );
try {
// try and send the email
$response = $sendgrid->send( $email );
} catch ( Exception $e ) {
// something went wrong so display the error message
echo 'Caught exception: '. $e->getMessage() ."\n";
}
if ($count > 0) {
$i=1;
/* MAIL TO USER */
$to1 = $email_new;
$subject1 = "Srishti-Enrollment Info";
$headers1 = 'MIME-Version: 1.0' . "\r\n";
$headers1 .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers1 .= 'From: Srishti <srishticampusteam@gmail.com>' . "\r\n";
$output1 = "<div style='font-size:15px;border-style: outset; padding:10px;'> Dear User,<br><br>
Thank you for choosing Srishti Campus. We have received your Course package purchase request on our portal srishticampus.com <br><br>
Request Number : SICS ".$i++."".$lastid."<br><br>
A confirmation message will be sent on completion of the registration process.<br><br>
Thank you,<br>
Srishti Campus Team
</div>";
// $sql123="insert into tb_payment_s2s(user_id,course_id,course,email,phone,txn_reference_no,bank_reference_no,txn_amount,bank_id,bank_merchand_id,txn_type,currency_name,item_code,security_type,security_id,security_password,txn_date,auth_status) values('$user_id','$course_id','$course','$email','$phone','$txn_reference_no','$bank_reference_no','$txn_amount','$bank_id','$bank_merchand_id','$txn_type','$currency_name','$item_code','$security_type','$security_id','$security_password','$txn_date','$auth_status')";
$sql123="insert into tb_paymet(user_id,course_id,course,email,phone,txn_reference_no,bank_reference_no,txn_amount,item_code,txn_date) values('$user_id','$course_id','$course','$email_new','$phone','$txn_reference_no','$bank_reference_no','$amount','$item_code','$txn_date')";
// echo "insert into tb_paymet(user_id,course_id,course,email,phone,txn_reference_no,bank_reference_no,txn_amount,item_code,txn_date) values('$user_id','$course_id','$course','$email','$phone','$txn_reference_no','$bank_reference_no','$amount','$item_code','$txn_date')";
$result123 = $con->query($sql123);
$lastid123 = $con->insert_id;
/* MAIL TO USER */
// header("Location:enroll.php?id=$course_id&s=Success&l=$lastid");
// $sent = mail($to, $subject, $output, $headers);
// create new sendgrid mail
$email = new \SendGrid\Mail\Mail();
// specify the email/name of where the email is coming from
$email->setFrom( FROM_EMAIL, FROM_NAME );
// set the email subject line
$email->setSubject( $subject1 );
// specify the email/name we are sending the email to
$email->addTo( $to1, $to1 );
// add our email body content
$email->addContent("text/html", $output1);
// create new sendgrid
$sendgrid = new \SendGrid( SENDGRID_API_KEY );
try {
// try and send the email
$response = $sendgrid->send( $email );
} catch ( Exception $e ) {
// something went wrong so display the error message
echo 'Caught exception: '. $e->getMessage() ."\n";
}
//$sent1 = mail($to1, $subject1, $output1, $headers1);
}
else {
//header("Location:enroll.php?Failed");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Srishti Innovative Education Services Pvt Ltd</title>
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.5.0/css/all.css"
integrity="sha384-B4dIYHKNBt8Bc12p+WXckhzcICo0wtJAoU8YZTY5qE0Id1GSseTk6S+L3BlXeVIU" crossorigin="anonymous">
</head>
<body style="margin:0;padding:0;font-family: system-ui;">
<?php
//include 'header.php';
require 'connection.php';
session_start();
$uname = $_SESSION['user_name']=$fname;
$u_id = $_SESSION['user_id']=$user_id;
$user_id;
$result = $con->query("SELECT * FROM course_details WHERE id='" . $course_id . "'");
$row = $result->fetch_assoc();
$course = $row['name'];
?>
<table role="presentation" style="width:100%;border-collapse:collapse;border:0;border-spacing:0;background:#ffffff;">
<tr>
<td align="center" style="padding:20px;">
<table role="presentation" style="width:950px;border-collapse:collapse;border:1px solid #cccccc;border-spacing:0;text-align:left; margin: : 20px">
<tr>
<td align="center" style="padding:20px;background:#fff; border-bottom: 31px solid #ccc;">
<div>
<div style="display: flex; justify-content: space-between; align-items: center;" >
<img style=" width: 220px;height: 100%;" src="images/sicsfullogo.png">
<div class="">
<!-- <h1 style=" margin: 0; padding:0; text-align:right; color: #ccc; margin-right: 17px;" >INVOICE</h1>-->
<!-- <span style=" color: #104eb1; font-weight: 500;margin-right: 0px 17px !important; padding:0; text-align:right;" ><i style="color: #104eb1; margin: 5px; font-size: 19px;" class="fas fa-mobile-alt"></i>9846011044</span>-->
<!-- <p style=" margin: 0; padding:0; text-align:right;" >1C 1st floor Carnival building Technopark Trivandrum</p>-->
</div>
</div>
</div>
</td>
</tr>
<tr>
<td style=" padding: 20px; display: flex;">
<table style="width: 100%;padding-right: 30px;" >
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Recepit.No</td>
<td style="text-align: right; padding-right:20px;" >#<?php echo $bank_reference_no;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Date</td>
<td style="text-align: right; padding-right:20px;" ><?php echo $txn_date;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Name of Student</td>
<td style="text-align: right; padding-right:20px;" ><?php echo $fname;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Phone</td>
<td style="text-align: right; padding-right:20px;" ><?php echo $phone;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Payment Mode</td>
<td style="text-align: right; padding-right:20px;" >Online</td>
</tr>
</table>
<table style="width: 100%;" >
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Payment Gate Way Transaction Reference no</td>
<td style="text-align: right; padding-right:20px;" ><?php echo $txn_reference_no;?></td>
</tr>
<tr style=" height: 40px;" >
<!-- <td style="font-weight:bold; color: #424242;" >Transaction Amount</td><?php $amount1=$amount/100;?>
<td style="text-align: right; padding-right:20px;" ><?php echo $amount1;?>.00</td> -->
<td style="font-weight:bold; color: #424242;" >Transaction Amount</td><?php $amount;?>
<td style="text-align: right; padding-right:20px;" ><?php echo $amount;?>.00</td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Status of Transaction</td>
<td style="text-align: right; padding-right:20px;" ><?php echo $status;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold; color: #424242;" >Purpose of Payment</td>
<td style="text-align: right; padding-right:20px;" >Payment for <?php echo $course;?></td>
</tr>
<tr style=" height: 40px;" >
<td style="font-weight:bold;color: #424242; " >Status description</td>
<td style="text-align: right; padding-right:20px;" > <?php echo $statusDesc;?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="padding:10px 30px;">
<hr>
</td>
</tr>
<tr>
<td style="padding:10px 30px;">
<table style="width: 100%;">
<thead>
<tr style="background: #464343;color: #fff;border-bottom: 0px !important; height: 40px;">
<th style="padding-left: 10px;" scope="col">Item No</th>
<th style="padding-left: 10px;" scope="col">Descriptiont</th>
<th style="padding-left: 10px;" scope="col">Amount</th>
</tr>
</thead>
<tbody>
<tr style="height: 50px;" >
<!-- <th scope="row">1</th>-->
<td style="padding-left: 10px;" >1</td>
<td style="padding-left: 10px;" >Payment for <?php echo $course;?> </td>
<?php $amount;?>
<td style="padding-left: 10px; text-align: center;" ><?php echo $amount;?>.00</td>
</tr>
<tr style="height: 50px;">
<!-- <th scope="row">2</th>-->
<td></td>
<td style="padding-left: 10px;" ><b>TOTAL</b></td><?php $amount;?>
<td style="padding-left: 10px; background: #ccc; text-align: center; color: #104eb1;" ><b><?php echo $amount;?>.00</b></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="height: 200px;">
<div style="display: flex; justify-content: flex-end;padding: 30px; align-items: center;margin-top: 55px;" >
<div style="display: flex;flex-direction: column; align-items: center;" >
<img src="images/seal.png" style=" width: 160px; margin-right: 20px;" >
<h5 style="font-size: 22px;font-weight: 500;margin: 3px 8px;" >Authorized Signatory</h5>
</div>
</div>
</td>
</tr>
<tr>
<td style="padding:15px;background:#104eb1; color: #fff; justify-content: space-between;display: flex;">
<span>Srishti Innovative Education Services Pvt Ltd</span>
<!-- <span>1C 1st floor Carnival building Technopark Trivandrum </span>-->
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="col-12">
<button onClick="window.print();return false;" style="float: right;margin-right: 104px;margin-top: 25px;margin-bottom: 20px;">Print</button>
<a href="https://www.srishticampus.com/dashboard.php"> <button style="float: right;margin-right: 104px;margin-top: 25px;margin-bottom: 20px;">Go to Dashboard</button></a>
</div>
</body>
</html>
<?php
}
else if($status=='F')
{
$status="Failed";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Srishti Innovative Education Services Pvt Ltd</title>
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.5.0/css/all.css"
integrity="sha384-B4dIYHKNBt8Bc12p+WXckhzcICo0wtJAoU8YZTY5qE0Id1GSseTk6S+L3BlXeVIU" crossorigin="anonymous">
</head>
<body style="margin:0;padding:0;font-family: system-ui;">
<?php
//include 'header.php';
require 'connection.php';
session_start();
$uname = $_SESSION['user_name']=$fname;
$u_id = $_SESSION['user_id']=$user_id;
$user_id;
$result = $con->query("SELECT * FROM course_details WHERE id='" . $course_id . "'");
$row = $result->fetch_assoc();
$course = $row['name'];
?>
<!-- <table role="presentation" style="width:100%;border-collapse:collapse;border:0;border-spacing:0;background:#ffffff;margin-top: 12%;">
<tr>
<td align="center" style="padding:20px;font-size: 20px;font-weight: 700;">
Transaction Failed!!... Please Try again Later....
</td>
</tr>
</table> -->
<div class="col-12" style="text-align: center;">
<img src="images/Transaction-Failed.png">
</div>
<div class="col-12" style="text-align: center;">
<a href="https://www.srishticampus.com/enroll.php?id=<?php echo $course_id;?>" style="border: 1px solid #105ea3;
padding: 6px 15px;
min-width: 110px;
text-align: center;
color: #ffff;
font-size: 13px;
border-radius: 60px;
display: inline-block;
margin: 6px 10px 0px 0;
background: #105ea3;
text-decoration: none;"> Go to Enroll Page </a>
<!-- <button style="float: right;margin-right: 46%;margin-top: 25px;margin-bottom: 20px; background-color: #2d48cd;
width: 10%;
height: 30px;
color: white;">Go to Enroll Page</button> -->
</div>
</body>
</html>
<?php
//show failure message....
//header("Location:enroll.php?Failed");
}
|