Your Transaction ID for this transaction is : ".$txnid.".
";
echo "
We have received a payment of Rs. : " . $payment['TXNAMOUNT'] ."
";
$html="
";
echo $html;
$html ="";
$query = "update pgdet set ftxnid = '{$txnid}', fstatus = '{$payment->status}', fupddate = now()
where appno = '{$productinfo}' and forderid = '{$orderid}'";
$update = "update adm_studfeesum set forderid = '{$orderid}', fpaytype='Online', FPAYREMARKS='{$txnid}',
FPAYSTATUS='success',FPAYDATE=now(),FTRANID='{$txnid}'
where fintno='{$productinfo}'";
$result = $conn->query($update);
$qry1 = "select fappno, ifnull(famount, 0)as fpaid from adm_studfeesum where fintno='{$productinfo}'";
$res1 = $conn->query($qry1);
$row1 = mysqli_fetch_assoc($res1);
$regno = $row1['fappno'];
$amt = $row1['fpaid'];
if($fheadcode == 'App'){
$cond = 'adm_lead';
$cond1 = ",fappfeestatus = 'T'";
$cond2 = 'fleadid';
}else{
$cond = 'adm_stud';
$cond1 = ",fpaymentstatus = 'T'";
$cond2 = 'FAPPNO';
}
$qry = "select concat(a.fdegree, ' - ', fdescpn)as fdegree, ifnull(famount, 0)as famount, ifnull(fname, '')as fname,
ifnull(fgender, '')as fgender, ifnull(a.fadmyear, '')as fadmyear,
ifnull(ffatname, '')as ffatname
from $cond a inner join degree d on d.fdegree = a.fdegree
where fappno='{$regno}'
group by a.fdegree";
$resQry = $conn->query($qry);
$rowQry = mysqli_fetch_assoc($resQry);
$stud_Amt = floatval($amt) + floatval($rowQry['famount']);
$fname = $rowQry['fname'];
$fgender = $rowQry['fgender'];
$fadmyear = $rowQry['fadmyear'];
$ffatname = $rowQry['ffatname'];
$course = $rowQry['fdegree'];
if($fheadcode == 'App'){
$studFeeUpd = "update adm_lead set fapppayid='{$txnid}',
fapppaydate=now(), fappfeestatus = 'T' where fleadid ='{$regno}'";
}else{
$studFeeUpd = "update adm_stud set fpaymentid='{$txnid}',
fpaymentdate=now(), fpaymentstatus = 'T' where FAPPNO ='{$regno}'";
}
$res = $conn->query($studFeeUpd);
$qry2 = "select ifnull(famount, 0) as paid from adm_studfeesum where fappno = '{$regno}'
and ifnull(FPAYSTATUS,'') = 'success'
and fintno='{$productinfo}'";
$res2 = $conn->query($qry2);
$row2 = mysqli_fetch_assoc($res2);
$amount = $row2['paid'];
$qry3 = "select fdegree, fappno, fheadcode, ffee, fbal, ifnull(fpaid, 0)as fpaid from adm_studfee where fappno = '{$regno}'
and ifnull(fbal,0) >0 order by fheadcode";
$res3 = $conn->query($qry3);
$colldet = "select ifnull(FUNIVNAME,'') as FUNIVNAME, concat(ifnull(FUNIVADD1,'') ,',', ifnull(FUNIVADD2,'')) as FUNIVADD,
ifnull(FTOWN,'') as FTOWN, ifnull(funivemail,'') as funivemail,
ifnull(funivmobile,'') as funivmobile,ifnull(fadmlink,'') as fadmlink,
ifnull(fadmname, '') as fadmname,ifnull(fadmemail,'') as fadmemail
from control";
$re = $conn->query($colldet);
$collres = mysqli_fetch_assoc($re);
$fcollname = $collres['FUNIVNAME'];
$fadmlink = $collres['fadmlink'];
$fadmname = $collres['fadmname'];
$fadmemail = $collres['fadmemail'];
$studemail = $_SESSION['MOBILE'];
$fadmltr = explode('/',$fadmlink);
$link = $fadmltr[2]."/app.php?&a=admFeeReport&univcode={$funivcode}&app_no={$appno}";
if($fgender == 'F'){
$cnd = " Miss ".strtoupper($fname)." ";
$cnd1 = " D/o ".strtoupper($ffatname)." ";
}else{
$cnd = " Mr. ".strtoupper($fname)." ";
$cnd1 = " S/o ".strtoupper($ffatname)." ";
}
$admAdd = intval($fadmyear) + 1;
$admyear = $fadmyear ." - ". $admAdd;
// $link = "https://admissions.harshainstitutions.com/app.php?&a=admFeeReport&univcode={$funivcode}&app_no={$appno}";
$message = "";
$logo = "https://universitysolutions.in/admission/img/".$funivcode."_logo.jpg";
$message="";
$message.="";
$message.="";
$message.="
";
$message.="
Date: ".date("d/m/Y")."
";
// $message.="
PROVISIONAL ADMISSION CONFIRMATION
";
// $message.="
This is to certify that".$cnd.$cnd1."has been provisionally admitted in our institution for study in " .$course. " course for the academic year ". $admyear ." through merit basis and final confirmation of the admission is subjected to the payment of full fee, submission of original documents and approval of admission from the university concerned.