query($get_data);
if (mysqli_num_rows($result1) > 0)
{
$dbnames = array();
while($row = mysqli_fetch_assoc($result1))
{
$dbnames[$row['FUNIVCODE']] = $row['FDBNAME'];
$univname = $row['FUNIVNAME'];
}
}
$dbname = $dbnames[$funivcode];
$servername = SERVERNAME;
$username = USERNAME;
$password = PASSWORD;
$conn = new mysqli($servername, $username, $password, $dbname);
// if($funivcode =='060'){
// $query = "select a.finst from adm_studfeesum s inner join adm_studfee f on f.fappno = s.fappno
// inner join adm_lead a on f.fappno = a.fleadid
// where s.fintno = '{$appno}'";
// $result=$conn->query($query);
// $pgcred = mysqli_fetch_assoc($result);
// $degree = $pgcred['finst'];
// }
if($funivcode =='060'){
if($fheadcode == 'App'){
$cond = "f.fleadid = s.fleadid";
$cond0 = "f.fleadid = a.fleadid";
$cond1 = "a.fleadid";
}else{
$cond = "f.fappno = s.fappno";
$cond0 = "f.fappno = a.fappno";
$cond1 = "a.fappno";
}
$query = "select a.finst from adm_studfeesum s
inner join adm_studfee f on $cond
inner join adm_lead a on $cond0
where s.fintno = '{$appno}' and $cond1 = '{$fregno}'";
// $query = "select a.finst from adm_studfeesum s inner join adm_studfee f on f.fappno = s.fappno
// inner join adm_lead a on f.fappno = a.fleadid
// where s.fintno = '$appno'";
$result=$conn->query($query);
$pgcred = mysqli_fetch_assoc($result);
$fdegree = $pgcred['finst'];
}
$get_query = "select * from maspg where funivcode = '{$funivcode}'
and fbank = 'Easebuzz' and FENTTYPE = '{$fdegree}'";
$result1=$conn->query($get_query);
$pgcred = mysqli_fetch_assoc($result1);
$SALT = $pgcred['fworkingid'];
$easebuzzObj = new Easebuzz($MERCHANT_KEY = null, $SALT, $ENV = null);
$result = $easebuzzObj->easebuzzResponse( $_POST );
$data = json_decode($result);
if($data->data->status == 'success')
{
date_default_timezone_set('Asia/Kolkata');
$current_date = date("Y-m-d h:i:s");
$productinfo = $data->data->productinfo;
$txnid = $data->data->txnid;
$feasepayid = $data->data->easepayid;
$net_amount_debit = $data->data->net_amount_debit;
$query = "update pgdet set ftxnid = '{$txnid}', fstatus = 'success', fupddate = now(),
feasepayid = '{$feasepayid}'
where appno = '{$productinfo}' and forderid = '{$txnid}'";
$result=$conn->query($query);
$query = "update adm_studfeesum set FTRANID = '{$txnid}',
FPAYTYPE = 'Easebuzz',FPAYSTATUS='{$data->data->status}',FPAYDATE = now()
where fintno = '{$appno}'";
$result1 =$conn->query($query);
if($fheadcode == 'App')
$cond = "fleadid";
else
$cond = "fappno";
$query = "update adm_studfee set fpaid = '{$net_amount_debit}',fpaydate=now(),
fyear = '{$fadmyear}',FPAYSTATUS='{$data->data->status}',fbal = '0.00'
where $cond = '{$fregno}' and fheadcode = '{$fheadcode}'";
$result1 =$conn->query($query);
if($fheadcode != 'App'){
$query = "update adm_stud set famount = '{$net_amount_debit}',fpaymentdate=now(),
fpaymentid = '{$txnid}',fpaymentstatus = 'T'
where $cond = '{$fregno}' and fheadcode = '{$fheadcode}'";
$result1 =$conn->query($query);
}
echo "".$univname."
";
echo "
Thank You. Your Payment status is success
";
echo "Your Transaction ID for this transaction is ".$txnid.".
";
echo "We have received a payment of Rs. " . $net_amount_debit ."
";
echo "Go to Home and fill application
";
// $html="";
// echo $html;
$firstname = "Easebuzz";
$html = "Your payment was successful
Payment ID: {$_POST['easepayid']}
";
$paymentid = $_POST['easepayid'];
mysqli_close($conn);
}
?>