File Manager

✏️ Edit File: /home/coemyoza/portal.coeminna.edu.ng/applicant/app_transaction_verify_cpy.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 (isset($_GET["InvoiceNumber"])) {
	$txid = $_GET["InvoiceNumber"];
	$ref = $_GET["RequestReference"];

/*
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`=? || `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;
        		
        		    $count = $pdo->prepare("SELECT * FROM `matno_counter` WHERE `class` = ?");
        		    $count->execute([$pgr_abv]);
            	
            	$thecount = $count->fetch();
        	/*	if($count->rowCount() == 0){ $no = 0;	}else{   $no = $thecount["count"];	$newno = $thecount["count"] + 1;	}*/
        		$no = $thecount["count"];
        		$newno = $thecount["count"] + 1;
        		$nos= substr(str_repeat(0, 4).$no, - 4);
        		$matno = $pgr_abv."/".$yr."/".$nos;
                
        		$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 Form.....</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.coeminna.edu.ng 33 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁assets	dir	—	2024-01-26 05:45	📂 Buka
📁images	dir	—	2024-01-26 05:45	📂 Buka
🐘-dashboard.php	php	11.2 KB	2024-02-23 10:26	✏️ Edit 👁️ View
🐘-payable.php	php	11.8 KB	2024-01-26 18:14	✏️ Edit 👁️ View
📄.DS_Store	ds_store	8 KB	2024-01-28 21:27	✏️ Edit 👁️ View
🐘app_invoice copy.php	php	18.6 KB	2024-02-08 16:25	✏️ Edit 👁️ View
🐘app_invoice.php	php	14.1 KB	2024-04-01 16:39	✏️ Edit 👁️ View
🐘app_invoice_cpy.php	php	14.3 KB	2024-02-23 05:36	✏️ Edit 👁️ View
🐘app_invoice_redir.php	php	1.6 KB	2024-02-15 06:48	✏️ Edit 👁️ View
🐘app_invoiceold.php	php	18.8 KB	2024-02-04 21:52	✏️ Edit 👁️ View
🐘app_print.php	php	21.1 KB	2024-01-26 21:05	✏️ Edit 👁️ View
🐘app_reciept.php	php	7.3 KB	2024-03-03 04:06	✏️ Edit 👁️ View
🐘app_transaction_verify.php	php	5.7 KB	2024-03-16 05:20	✏️ Edit 👁️ View
🐘app_transaction_verify_cpy.php	php	5.5 KB	2024-02-23 04:55	✏️ Edit 👁️ View
🐘app_transaction_verifyold.php	php	6.7 KB	2024-02-04 21:57	✏️ Edit 👁️ View
🐘appdata_edit.php	php	13.6 KB	2024-04-05 04:31	✏️ Edit 👁️ View
🐘appform.php	php	29.5 KB	2024-02-20 04:52	✏️ Edit 👁️ View
🐘appform_adm.php	php	30.2 KB	2024-02-15 13:46	✏️ Edit 👁️ View
🐘appform_prog.php	php	15.8 KB	2024-03-06 13:57	✏️ Edit 👁️ View
🐘appform_updt.php	php	13.9 KB	2024-02-23 13:46	✏️ Edit 👁️ View
🐘application_print.php	php	20.8 KB	2024-01-26 18:01	✏️ Edit 👁️ View
🐘dashboard.php	php	14.1 KB	2025-12-29 13:01	✏️ Edit 👁️ View
📄error_log	file	7.5 MB	2024-07-19 11:13	✏️ Edit 👁️ View
🐘footer.php	php	1.6 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘header.php	php	5.6 KB	2024-02-15 12:28	✏️ Edit 👁️ View
📜htmlcanva.js	js	2.7 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘index.php	php	3.7 KB	2024-02-22 18:06	✏️ Edit 👁️ View
🐘login.php	php	7.3 KB	2024-02-22 18:06	✏️ Edit 👁️ View
🐘offer_letter.php	php	8.6 KB	2026-03-07 08:09	✏️ Edit 👁️ View
📕payable.pdf	pdf	127.9 KB	2024-02-23 10:23	✏️ Edit 👁️ View
🖼️reg_sign.png	png	19.5 KB	2024-02-17 20:10	✏️ Edit 👁️ View
🐘register.php	php	10.8 KB	2024-02-18 07:11	✏️ Edit 👁️ View
🐘sidebar.php	php	1.8 KB	2024-02-15 12:25	✏️ Edit 👁️ View