File Manager

✏️ Edit File: /home/coemyoza/public_html/portal/applicant/app_transaction_verify.php

<?php session_start();
$title = "Applicant transaction";?>
<script src="../jquery.min.js"></script>
<title><?php echo $title;?></title>
<?php include('../data/db.php');?>
<?php
$msg="Oops! Payment failed...";
$good=0;

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
	$datain = file_get_contents("php://input");
	$result = json_decode($datain, true);
	$txid = $result["InvoiceNumber"];
	$ref = $result["RequestReference"];

$tran_query = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `refno`=? and `txid`=?") ;
	  $tran_query->execute([$ref,$txid]);
	  $tran_row = $tran_query->fetch();
	  $total_tran_row = $tran_query->rowCount();
	  //$pay_id = $tran_row['pay_id'];
	  //$matno=$tran_row['matno'];
	  
	  $fees_id=$tran_row['matno'];
	  
	  $ttype = $tran_row["type"];
	  if( $ttype =="Acceptance fee")
	  {
		$dbtbl_field ="acceptance_fee";
	  }
	  if( $ttype =="Application fee")
	  {
		$dbtbl_field ="application_fee";
	  }
	  if( $ttype =="School Fees")
	  {
		$dbtbl_field ="school_fee";
	  }

if ($total_tran_row > 0) 
	{
    	$qry1=$pdo->prepare("update `stu_payloader` set `status`=?, `gateway`=? where `txid`=? and `refno`=?");
        $qry1->execute(['paid','Bank3D',$txid,$ref]);
    
    	$qryap=$pdo->prepare("update `applicant` set `$dbtbl_field`=? where `application_no`=?");
    	$qryap->execute(['paid',$fees_id]);
    
        $checkq = $pdo->prepare("SELECT * FROM `applicant` WHERE `application_no` = ?");
        $checkq->execute([$fees_id]);
        $checked = $checkq->fetch();
        $serial_no = date("Ydmis");
        if($dbtbl_field == "school_fee")
        {
        	if($checked["school_fee"] == "paid")
        	{
        		$gpr = $pdo->prepare("SELECT * FROM `programmes` WHERE `prog_id`=? OR `programme`=?");
        		$gpr->execute([$checked['prog_id'],$checked['programme']]);
        		$gprg = $gpr->fetch();
        
        		$year = $checked["year"];
        		$pgr_abv = $gprg["abv"];
        		$deyear = $school_app_year;
        		$yr = substr($deyear, -2);
        		
                $study_center = 1;
        		$college_id = 1;
        		
        		retn:
        		$count = $pdo->prepare("SELECT * FROM `matno_counter` WHERE `class` = ?");
        		$count->execute([$pgr_abv]);
            	
            	$thecount = $count->fetch();
        		$no = $thecount["count"];
        		$newno = $thecount["count"] + 1;
        		$nos = substr(str_repeat(0, 4).$no, - 4);
        		$matno = $pgr_abv."/".$yr."/".$nos;
        		
        		//check if matno exist 
                $findmatno = $pdo->query("SELECT matno FROM `applicant` WHERE `matno`='$matno'");
                if($findmatno->rowcount() > 0)
                { 
                    $qrymtc = $pdo->prepare("UPDATE `matno_counter` SET `count` = (`count` + 1) WHERE `class`=?");
        			$qrymtc->execute([$pgr_abv]);
        			GOTO retn;
                }
                
        		$sessions = $deyear."/".($deyear+1);
        		$level = 100;
        		if($checked['matno'] == "" OR $checked['matno'] == NULL)
        		{
        			$uqryapp=$pdo->prepare("update `applicant` set `matno`=? where `application_no`=?");
        			$uqryapp->execute([$matno,$fees_id]);
        			
        			$qryst = $pdo->prepare("INSERT INTO `students`(`applicationno`, `utme`,`matno`, 
        			`password`, `names`, `sex`, `dob`, `tribe`, `country`, `states`, `lga`, `address`, 
        			`email`, `contact`, `programme`, `department`, `year`, `entry_session`, `session`, `stat`, 
        			`college_id`, `school_id`,`prog_id`, studycenter_id, `level`, `semester`, `images`) VALUES
        			(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        			");
        			
        			$qryst->execute([$checked["application_no"],$checked["utme"],$matno,'Easy123',
        			$checked["names"],$checked['gender'],$checked['dob'],$checked['tribe'],
        			$checked['country'],$checked['state'],$checked['lga'],$checked['pgaddress'],
        			$checked['email'],$checked['gsm'],$checked['programme'],$gprg['dept_id'],$checked['year'],
        			$sessions,$sessions,1,$college_id,$gprg['school_id'],$gprg['prog_id'],
        			1,$level, 1,$checked['passport']]);
        			
        			$qrymtc = $pdo->prepare("UPDATE `matno_counter` SET `count` = ? WHERE `class`=?");
        			$qrymtc->execute([$newno,$pgr_abv]);
        		
        			if($qrymtc)
        			{
        			    
        				$nqry2=$pdo->prepare("update `stu_payloader` set `matno`='$matno' where `matno`=? and `txid`=? AND `type` = 'School Fees'");
        				$nqry2->execute([$fees_id,$txid]);
        				
        				echo '<div class="alert alert-success">Loading Applicant Account.....</div><script>setTimeout(function(){location.href="dashboard?appno='.encryptor('encrypt',$fees_id).'&start'.'"},1)</script>';
        			}
        		}// else if matno does not exist  do something
        		else		
        		{
        			echo '<div class="alert alert-success">Loading Applicant Account.....</div><script>setTimeout(function(){location.href="dashboard?appno='.encryptor('encrypt',$fees_id).'&start'.'"},10)</script>';
        		}
        	}// else if school fee is nto paid do something
        }
        if($qryap)
        {
        	if($checked["app_status"] == 'completed'){
        		echo '<div class="alert alert-success">Loading Application Dashboard.....</div><script>setTimeout(function(){location.href="dashboard?appno='.encryptor('encrypt',$fees_id).'&start'.'"},10)</script>';
        	}else{
        		echo '<div class="alert alert-success">Loading Application Form.....</div><script>setTimeout(function(){location.href="appform?appno='.encryptor('encrypt',$fees_id).'&start'.'"},10)</script>';
        	}
        		
        }else		
        {		
        	echo'<script>window.close();</script>';
        }
    }
}
?>

Batal

⬅ Naik ke portal 35 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁assets	dir	—	2024-07-21 13:45	📂 Buka
📁images	dir	—	2024-07-21 13:45	📂 Buka
🐘-dashboard.php	php	11.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-payable.php	php	11.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄.DS_Store	ds_store	8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_invoice copy.php	php	18.6 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_invoice.php	php	15.5 KB	2025-09-25 10:44	✏️ Edit 👁️ View
🐘app_invoice_cpy.php	php	14.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_invoice_redir.php	php	1.6 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_invoiceold.php	php	18.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_print.php	php	22 KB	2024-08-26 21:31	✏️ Edit 👁️ View
🐘app_reciept.php	php	8 KB	2025-03-07 20:31	✏️ Edit 👁️ View
🐘app_transaction_verify.php	php	5.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_transaction_verify_cpy.php	php	5.5 KB	2025-04-25 11:03	✏️ Edit 👁️ View
🐘app_transaction_verifyold.php	php	6.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘appdata_edit.php	php	15.5 KB	2024-11-22 06:44	✏️ Edit 👁️ View
🐘appform.php	php	50.3 KB	2024-08-26 20:31	✏️ Edit 👁️ View
🐘appform_adm.php	php	30.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘appform_prog.php	php	15.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘appform_updt.php	php	13.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘application_print.php	php	20.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘dashboard.php	php	14.2 KB	2025-01-23 12:46	✏️ Edit 👁️ View
📄error_log	file	11.5 MB	2026-04-21 14:27	✏️ Edit 👁️ View
🐘fetcher.php	php	387 B	2024-08-26 12:22	✏️ Edit 👁️ View
🐘footer.php	php	1.6 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘header.php	php	6.6 KB	2025-01-22 10:37	✏️ Edit 👁️ View
📜htmlcanva.js	js	2.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘index.php	php	3.9 KB	2025-04-07 10:10	✏️ Edit 👁️ View
🐘login.php	php	7.4 KB	2025-04-07 10:11	✏️ Edit 👁️ View
🐘notification_letter.php	php	7.8 KB	2025-01-19 22:29	✏️ Edit 👁️ View
🐘offer_letter.php	php	8.9 KB	2026-03-07 08:34	✏️ Edit 👁️ View
📕payable.pdf	pdf	127.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️reg_sign.png	png	19.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘register.php	php	12 KB	2025-09-25 10:39	✏️ Edit 👁️ View
🐘sidebar.php	php	1.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View