File Manager

✏️ Edit File: /home/coemyoza/sms.coeminna.edu.ng/transcript_application/dashboard.php

<?php

$url = web_root;

// sum up the relevant information
$result_all = mysqli_query($link,"select count(*) as total_users from `transcript_application` where matid='$_SESSION[uid]'");
$result_active = mysqli_query($link,"select count(*) as total_users from `transcript_application` where matid='$_SESSION[uid]' and `status` = '1'");
$result_inactive = mysqli_query($link,"select count(*) as total_users from `transcript_application` where matid='$_SESSION[uid]' and `status` = '0'");
$result_suspend = mysqli_query($link,"select count(*) as total_users from `transcript_application` where matid='$_SESSION[uid]' and `status` = '2'");						   
list($total_users) = mysqli_fetch_row($result_all);
list($total_active) = mysqli_fetch_row($result_active);
list($total_inactive) = mysqli_fetch_row($result_inactive);
list($total_suspended) = mysqli_fetch_row($result_suspend);
?>

<section class="content-header">
      <h1>
        Transcript
        <small>Applications</small>
        </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section>

<section class="content">
      
      
       <div class="box box-info">
 <?php
	  /******************** ERROR MESSAGES*************************************************
	  This code is to show error messages 
	  **************************************************************************/
//Error message	
	if(!empty($_GET['err']) && ($_GET['err']==1))  {
	   echo "<div class=\"alert alert-danger alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-ban'></i> Error!</h4>";
	    echo "Field(s) marked asterics(*) is/are required";
	  echo "</div>";	
	   }
	   
	   elseif($_GET['err']==2) {
		    echo "<div class=\"alert alert-danger alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-ban'></i> Error!</h4>";
	    echo "Please enter valid email address";
	  echo "</div>";	
	   }
		   
//Success message	   
		if(!empty($_GET['msg']) && ($_GET['msg']==1)) {
	    echo "<div class=\"alert alert-success alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-check'></i> Success!</h4>";
			echo "Application successfully submitted.";
		echo "</div>";
	   }
	   
	   elseif($_GET['msg']==2) {
		   echo "<div class=\"alert alert-success alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-check'></i> Success!</h4>";
			echo "Payment confirmed for your application";
		echo "</div>";
	   }
	   
	   elseif($_GET['msg']==3) {
		   echo "<div class=\"alert alert-success alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-check'></i> Success!</h4>";
			echo "Application successfully Cancelled";
		echo "</div>";
	   }
	   
	     elseif($_GET['msg']==4) {
		   echo "<div class=\"alert alert-success alert-dismissible\">";
	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
                <h4><i class='icon fa fa-check'></i> Success!</h4>";
			echo 'Payment successful. kindly allow allow 24 hours for update or click  <a href="./?Account=PortalAccount&view=42020302&action=ticket">here</a> to Open Ticket with attachment of your receipt.';
		echo "</div>";
	   }
	   	
	   
//Information message	  
	 //if(!empty($info))  {
//	   echo "<div class=\"alert alert-info alert-dismissible\">";
//	  foreach ($info as $e) {
//	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
//                <h4><i class='icon fa fa-info'></i> Alert Info!</h4>";
//	    echo "$e";
//	    }
//	  echo "</div>";	
//	   }
////Warning message	  
//	 if(!empty($war))  {
//	   echo "<div class=\"alert alert-warning alert-dismissible\">";
//	  foreach ($war as $e) {
//	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
//                <h4><i class='icon fa fa-warning'></i> Warning!</h4>";
//	    echo "$e";
//	    }
//	  echo "</div>";	
//	   }
////Success message	   
//	 if(!empty($msg))  {
//	    echo "<div class=\"alert alert-success alert-dismissible\">";
//		 foreach ($msg as $e) {
//	echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>
//                <h4><i class='icon fa fa-check'></i> Done!</h4>";
//	    echo "$e";
//		 }
//		echo "</div>";
//	   }	
	  /******************************* END ********************************/	  
	  ?>
      
<?php if(isset($_GET['action']) && ($_GET['action'] == 'add')) { ?>
            <div class="box-header with-border">
              <h3 class="box-title">Transcript Application Form [<strong><?php echo $_SESSION['username']; ?></strong>]</h3>
            </div>
            
            
            <?php //select query from database
$rs_news = mysqli_query($link,"select * from `default_users` where id = '$_SESSION[uid]'");
while ($info = mysqli_fetch_array($rs_news)) { ?>
            <form class="form-horizontal" action="<?php echo $url.'transcript_application/fps/submitApplication.fps.php'; ?>" method="post">
              <div class="box-body">
     
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Matric No.:</label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" value="<?php echo $info['username']; ?>" disabled="disabled">
                  </div>
                </div>
                
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Full Name:</label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" value="<?php echo strtoupper($info['last_name'].' '.$info['first_name'].' '.$info['other_name']); ?>" readonly="readonly">
                  </div>
                </div>
                
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Applicant's Email:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="email" class="form-control" name="email" placeholder="Enter your Email Address here" required="required">
                  </div>
                </div>
                
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Phone Number:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" name="phone" placeholder="Phone Number" required="required">
                  </div>
                </div>

<div class="form-group">
                <label for="inputType" class="col-sm-2 control-label">Programme<span class="text-red">*</span></label> 
                <div class="col-sm-10">
                <select name="prog" class="form-control select" style="width: 100%;" required>
                  <option value="" selected="selected">--- Select Programme ---</option>
                 <?php $query= "select title, id from `default_department` group by title order by title;";
								
						if ($result=mysqli_query($link,$query))
						{
							if (mysqli_num_rows($result)>0)
							{
								while ($array=mysqli_fetch_array($result))
								{
									$cid=$array['id'];
									$cname=$array['title'];
									echo "<option value='$cid'>$cname</option>";
								}
							}
						}
					?>
			      </select>	
              </div>
              		</div>
                    
                    <p class="text-green" align="center"><strong>Recipient (School/Company) Information</strong></p>
                    
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Company/School:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" name="company" placeholder="Company or School" required="required">
                  </div>
                </div>
                
                <div class="form-group">
                <label for="inputType" class="col-sm-2 control-label">Country<span class="text-red">*</span></label> 
                <div class="col-sm-10">
                <select name="country" class="form-control select" style="width: 100%;" required onChange="getState(this.value)">
                  <option value="" selected="selected">--- Select Country ---</option>
                 <?php $query= "select title, id from `default_region_countries` group by title order by title;";
								
						if ($result=mysqli_query($link,$query))
						{
							if (mysqli_num_rows($result)>0)
							{
								while ($array=mysqli_fetch_array($result))
								{
									$cid=$array['id'];
									$cname=$array['title'];
									echo "<option value='$cid'>$cname</option>";
								}
							}
						}
					?>
			      </select>	
              </div>
              		</div>
                    
                    
<div id="message" style="display: none;"></div>
<div id="waiting" style=" height:auto; display: none;">
  <img src="../images/spinner.gif" title="Loader" alt="Loader" align='absbottom' />&nbsp;&nbsp; Loading... please wait!</div>

                      <div id="statediv"></div> 
                  
                  <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Address:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" name="address" placeholder="Address" required="required">
                  </div>
                </div>

<div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Recipient’s Email:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="email" class="form-control" name="remail" placeholder="Enter Company/School Email Address here" required="required">
                  </div>
                </div>
                
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Contact Person:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" name="contact" placeholder="Contact Person" required="required">
                  </div>
                </div>

<p class="text-green" align="center"><strong>Choose mode of payment</strong></p> 
                
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Charge Fees(N):</label>
                  <div class="col-sm-10">
                    <input type="text" class="form-control" name="amount" value="100" readonly="readonly">
                  </div>
                </div>
                
                <div class="form-group">
                <label for="inputType" class="col-sm-2 control-label">Payment Type:<span class="text-red">*</span></label> 
                <div class="col-sm-10">
                <select name="pmode" class="form-control select" style="width: 100%;" required>
                  <option value="" selected="selected">--- Select Option ---</option>
                	<option value="1">Transfer</option>
                    <option value="2">Bank Teller</option>
                    <option value="3">Online Payment</option>
					
			      </select>	
              </div>
              		</div>
                    
                <div class="form-group">
                  <label for="inputEmail3" class="col-sm-2 control-label">Confirm:<span class="text-red">*</span></label>
                  <div class="col-sm-10">
                  <input name="confirm" type="checkbox" value="1" required="required" /> I attest that the information provided is correct
                  </div>
                </div>

</div>
              
              <div class="box-footer">
              <input name="uid" type="hidden" value="<?php echo $_SESSION['uid']; ?>" />
      <a href="?Account=PortalAccount&amp;view=42020301"><button type="button" class="btn btn-default">Cancel</button></a>
            <button type="submit" name="submit" class="btn btn-info pull-right"><i class="fa fa-credit-card"></i> Submit Payment</button>
      	</div>
              
            </form> 
        
<?php }

} elseif($_GET['action'] == 'in') { ?> 
        <div class="box-header with-border">
              <h3 class="box-title">How to Apply</h3>
  			</div>
          <div class="box-body">
            <ul>
              <li>Click on &quot;Apply for Transcript&quot; and Search Up your Matriculation Number</li>
            </ul>
            <ul>
              <li>Supply a Valid Email Address and Phone Number. This is important because we may need to reach you.</li>
            </ul>
            <ul>
              <li>You will then be directed to make payment. The Fee Schedule is below.</li>
            </ul>
            <ul>
              <li>After a successful payment, please take   note of your transaction reference. This will also serve as your   tracking number for your application and the only means by which you can   retrieve or track your application</li>
            </ul>
            <ul>
              <li>After a successful payment, you can now proceed to fill the transcript details by clicking on &quot;Fill Transcript Details&quot;</li>
            </ul>
            <ul>
              <li>After submission of your transcript details, an email will be sent to you on how to track your application.</li>
            </ul>
            <ul>
              <li>If you were unable to complete your   transcript application process once, and you want to continue from where   you stopped OR you need to track an already completed application, then   click on &quot;Retrieve/Track an Application&quot; </li>
            </ul>
            <hr />
            <h3><strong>Fee Schedule</strong></h3>
Transcript Application &amp; Processing ₦15,000.00 <br />
<hr />
<strong>Courier Service</strong>
<ul>
  <li>Asian countries       ₦19,800.00 (per destination)</li>
</ul>
<ul>
  <li>European countries     ₦10,250.00 (per destination)</li>
</ul>
<ul>
  <li>American countries     ₦13,300.00 (per destination)</li>
</ul>
<ul>
  <li>African countries      ₦10,250.00(per destination) </li>
</ul>
<ul>
  <li>Oyo, Osun, Kwara       ₦805.00 (per destination)</li>
</ul>
<ul>
  <li>Other South-West States       ₦2,500.00 (per destination)</li>
</ul>
<ul>
  <li>Other Nigeria Region   ₦3,600.00 (per destination)</li>
</ul>
<hr />
<p ;="">All Fees are payable via the PayStack Payment Integration Platform                                Note that a bank transaction charge of ₦300.00 per transaction apply for all transactions                               You will be redirected to Interswitch gateway during registration to make payment.                               Prepare for making your payment online by having the following information handy:</p>
<ul>
  <li>An Interswitch enabled Debit/ ATM card, specifying the &ldquo;Card Number&rdquo;, &ldquo;Expiry Date&rdquo;, &ldquo;Card PIN&rdquo; and &ldquo;CVV2 Code&rdquo; </li>
</ul>
<ul>
  <li>Ensure that you have sufficient funds in the card specified above, to cater for your fees as quoted in this section</li>
</ul>
<strong>Contact Us</strong><br />
<em><strong>Working Hours: 8am - 4pm, Work days</strong></em><br />
<em><strong>Phone number: 08033694738</strong></em><br />
<em><strong>Email Address: transcript@school.edu.ng</strong></em></div>

<?php }

elseif($_GET['action'] == 'app') { ?>  
          <div class="box-header with-border">
              <h3 class="box-title">Completed Applications</h3>
            </div>
            
<?php //select query from database
$rs_settings = mysqli_query($link,"select * from transcript_application where matid = '$_SESSION[uid]' order by id desc"); ?>
<div class="box-body table-responsive no-padding">
          <table id="example1" class="table table-bordered table-striped">     
            <thead>
              <tr>							
                <th>SN</th>
                <th>TranscriptID</th>
                <th>TransactionID</th>
                
                <th>School/Company</th>
                <th>Recipient's Email</th>
                <th>Contact Person</th>
                <th>Address</th>
                <th>Applicant's Email</th>
                <th>Phone</th>
                <th>Country</th>
                <th>State</th>
                <th>Date</th>
              </tr>
            </thead>
            <tbody>
            
            <?php $i=1;
			while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>
                <td><?php echo $i++; ?></td>
                <td><?php echo $info['transcriptid']; ?></td>

<?php } 
		 elseif($_GET['action'] == 'his') { ?>
			     <div class="box-header with-border">
              <h3 class="box-title">Payment History Logs</h3>
            </div>
            
<?php //select query from database
$rs_settings = mysqli_query($link,"select * from payment_history where matid = '$_SESSION[uid]' and request_type= '1' order by id desc"); ?>
<div class="box-body table-responsive">
          <table id="example1" class="table table-bordered table-striped">     
            <thead>
              <tr>
                <th>SN</th>
                <th>TransactionID</th>
                 
                <th>Description</th>
                <th>Amount(N)</th>
                <th>Payment</th>
                <th>PaymentType</th>
                <th>Date</th>
                <th>Actions</th>
              </tr>
            </thead>
            <tbody>
            
            <?php $i=1;
			while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>
                <td><?php echo $i++; ?></td>
                <td><?php echo $info['transid']; ?></td>

<?php //$rs_mem = mysqli_query($link,"select * from `default_users` where id = '$info[matid]'"); 
				//while ($rec = mysqli_fetch_array($rs_mem)) { $matno = $rec['username']; $fname = $rec['first_name']; $lname = $rec['last_name']; } ?>
          		
                
                 
                 <td><?php echo $info['description']; ?></td>
                <td><?php echo number_format($info['amount'],2); ?></td>
                 
                <td><?php if($info['status'] == 1) { echo '<span class="label label-success">Successful</span>'; } 
				elseif($info['status'] == 0) { echo '<span class="label label-danger">Pending</span>'; } ?></td>
                
                <td><?php if($info['payment_type'] == 1) { echo 'Transfer'; }
				 elseif($info['payment_type'] == 2) { echo 'Bank Teller'; } 
				 else { echo 'Online'; } ?></td>
                 
                <td><?php echo $info['date_applied']; ?></td>
                 
 <td><?php if($info['status'] == 0) { ?>
  <a href="./?Account=PortalAccount&view=42020302&action=ticket&status=pending&id=<?php echo $info['id']; ?>"><span class="label label-warning"><i class="fa fa-envelope"></i> Open Ticket</span></a>

<?php } elseif($info['status'] == 1) { ?>
 <a href="<?php echo $url."admins/downloads/TranscriptPayment.pdf"; ?>" onClick="return confirm('WARNING: Do you really want to DOWNLOAD receipt for this application?');" target="_blank"><span class="label label-primary"><i class="fa fa-download"></i> Download Receipt</span></a> 
 <?php } else { echo '<span class="label label-default"> Cancelled</span>'; } ?> 
</td>
              </tr>
     	 <?php } ?>
            </tbody>
          </table>
          </div>
          
          
<?php } 
		 elseif($_GET['action'] == 'ticket') { ?>
        <div class="box-header">
          <h3 class="box-title">Tickets</h3>
          <a href="./?Account=PortalAccount&view=42020302&action=ticket" class="btn btn-sm btn-info btn-flat pull-right">Open New</a>
        </div>
        
<?php //select query from database
$rs_settings = mysqli_query($link,"select * from default_tickets where matid = '$_SESSION[uid]' and ticket_type = '1' order by id desc"); ?>
<div class="box-body">
          <table id="example1" class="table table-bordered table-striped">     
            <thead>
              <tr>
                <th>ReferenceID</th>
                <th>Status</th>
                <th>Category</th>
                <th>Attachment</th>
                 
                <th>AssignedTo</th>
                <th>CreatedDate</th>
              </tr>
            </thead>
            <tbody>
            
            <?php $i=1;
			while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>
                <td><a href="./?Account=PortalAccount&view=42020302&action=view&action=ticket&status=reply&id=<?php echo $info['id']; ?>" title="Click here to view or reply to this ticket"><?php echo $info['refid']; ?></a></td>
				<td><?php if($info['status'] == 1) { echo '<span class="label label-success">Closed</span>'; } 
				elseif($info['status'] == 0) { echo '<span class="label label-danger">Open</span>'; } ?></td>
                <td><?php echo $info['cat']; ?></td>
                <td><?php if(!empty($info['file_name'])) { ?>
                 <a href="<?php echo $url."transcript_application/uploads/$info[file_name]"; ?>" onClick="return confirm('WARNING: Do you really want to DOWNLOAD this attachment?');" target="_blank"><span class="label label-warning"><i class="fa fa-download"></i> Download</span></a> 
				<?php } ?> </td>
            

          		
        <?php $rs_mem = mysqli_query($link,"select * from `default_users` where id = '$info[assigned_to]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { $dname = $rec['display_name']; $uname = $rec['username']; } ?> 
 <td><?php if(!empty($info['assigned_to'])) { echo $dname.' ('.$uname.')'; } else { echo '<span class="label label-info">Processing</span>'; } ?></td>

<?php }

else { ?>
    		
    
      <div class="row">
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-aqua">
            <div class="inner">
              <h3><?php echo $total_users; ?></h3>

<p>Applications</p>
            </div>
            <div class="icon">
              <i class="fa fa-shopping-cart"></i>
            </div>
            <a href="#" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-green">
            <div class="inner">
              <h3><?php echo $total_active; ?></h3>

<p>Successful/Dispatched</p>

</div>
            <div class="icon">
              <i class="ion ion-stats-bars"></i>
            </div>
            <a href="#" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-red">
            <div class="inner">
              <h3><?php echo $total_inactive; ?></h3>

<p>Unsuccessful</p>
            </div>
            <div class="icon">
              <i class="ion ion-person-add"></i>
            </div>
            <a href="#" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>
        
        <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-yellow">
            <div class="inner">
              <h3><?php if(empty($total_suspended)) { echo '0'; } else { echo $total_suspended; } ?></h3>

<p>Cancelled</p>
            </div>
            <div class="icon">
              <i class="ion ion-pie-graph"></i>
            </div>
            <a href="#" class="small-box-footer">
              More info <i class="fa fa-arrow-circle-right"></i>
            </a>
          </div>
        </div>
        
      </div>
      
    
<?php //select query from database
$rs_news = mysqli_query($link,"select * from `default_users` where id = '$_SESSION[uid]'");
while ($araf = mysqli_fetch_array($rs_news)) { ?>
		<div class="callout callout-info">
       <h4>Welcome! <?php echo strtoupper($araf['last_name']). " " .ucwords($araf['first_name']); ?></h4>
       <p>Matric No.: <?php echo $araf['username']; ?> </p>
       <p>Last Logged on Date: <?php $vdate = date_create($araf['last_login']); //create date to be formated
				echo strtoupper (date_format($vdate,"d/m/Y")); //output date formated ?></p>
       </div>
<?php } ?>

<div class="box box-success">
        <div class="box-header">
          <h3 class="box-title">Status Request</h3>
        
        </div>

<?php $rs_settings = mysqli_query($link,"select * from transcript_application where matid = '$_SESSION[uid]' order by id desc"); ?>
        
<div class="box-body table-responsive">
          <table class="table table-hover">     
            <thead>
              <tr>							
                <th>SN</th>
                
                 <th>Email</th>
                <th>Phone</th>
                <th>Program</th>
                <th>Country</th>
                <th>State</th>
                <th>TransactionID</th>
                <th>PaymentStatus</th>
                <th>Date</th>
                <th>Actions/Status</th>
                <th>TrackingNo</th>
                <th>CourierName</th>
              </tr>
            </thead>
            <tbody>
            
            <?php $i=1;
			while ($info = mysqli_fetch_array($rs_settings)) { ?>
              <tr>
                <td><?php echo $i++; ?></td>
       
<?php //$rs_mem = mysqli_query($link,"select * from `default_users` where id = '$info[matid]'"); 
//while ($rec = mysqli_fetch_array($rs_mem)) { $username=$rec['username']; $lname=$rec['last_name']; $fname=$rec['first_name'];} ?>
               
                
                <td><?php echo $info['email']; ?></td>
                <td><?php echo $info['phone']; ?></td>
                
                <td><?php $rs_mem = mysqli_query($link,"select * from `default_department` where id = '$info[programme]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td>
                 
                <td><?php $rs_mem = mysqli_query($link,"select * from `default_region_countries` where id = '$info[countryid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td> 
                
  <td><?php $rs_mem = mysqli_query($link,"select * from `default_region_states` where id = '$info[stateid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['title']; } ?></td>

<td><?php $rs_mem = mysqli_query($link,"select * from `payment_history` where id = '$info[paymentid]'"); 
				while ($rec = mysqli_fetch_array($rs_mem)) { echo $rec['transid']; $pstatus = $rec['status']; } ?></td>
                
                <td><?php if($pstatus == 1) { echo '<span class="label label-success"> Successful</span>'; } 
				elseif($pstatus == 0) { echo '<span class="label label-danger"> Pending</span>'; } 
				elseif($info['status'] == 2) { echo '<span class="label label-warning"> Cancelled</span>'; } 
                //elseif($info['status'] == -1) { echo '<span class="label label-success">Completed</span>'; } ?></td>

<td><?php echo $info['date_applied']; ?></td>
                 
 <td><?php if($info['status'] == 0) { ?>
  <a href="https://paystack.com/pay/nh1yey1iin" onClick="return confirm('Do you really want to PROCEED with this payment? \n\nKindly take note of your TransactionID because you will need it during payment');" title="Kindly take note of your TransactionID"><span class="label label-success">Pay Online</span></a>
  <a href="<?php echo $url."transcript_application/fps/cancelApplication.fps.php?action=cancel&id=$info[paymentid]"; ?>" onClick="return confirm('WARNING: Do you really want to CANCEL this application?');"><span class="label label-warning">Cancel</span></a>
  <?php } elseif($info['status'] == 1) { echo '<span class="label label-info">Processing</span>'; }
  			elseif($info['status'] == 2) { echo '<span class="label label-primary">App. Cancelled</span>'; } 
          elseif($info['status'] == -1) { echo '<span class="label label-success">Completed/Dispatched</span>'; } ?>
</td>
		<td><?php if(!empty($info['track_no'])) { echo $info['track_no']; } 
					else {  echo ''; } //echo '<span class="label label-primary">Not Available</span>'; } ?></td>
         <td><?php if(!empty($info['courier_name'])) { echo $info['courier_name']; } 
					else {  echo ''; } //echo '<span class="label label-primary">Not Available</span>'; } ?></td>
              </tr>
     	 <?php } ?>
            </tbody>
          </table>
          
           
        </div>
        
      </div>
      
 <?php } ?>	
    </section>
    


<script src="plugins/jQuery/jquery-3.1.1.min.js"></script>

<script src="bootstrap/js/bootstrap.min.js"></script>

<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>

<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>

<script src="plugins/fastclick/fastclick.js"></script>

<script src="dist/js/adminlte.min.js"></script>

<script src="dist/js/demo.js"></script>


<script src="plugins/datepicker/bootstrap-datepicker.js"></script>

<script>
  $(function () {
    $("#example1").DataTable();
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false
    });
	
	//Date picker
    $('#datepicker').datepicker({
      autoclose: true
    });
	$('#datepicker2').datepicker({
      autoclose: true
    });
	
  });
  </script>

Batal

⬅ Naik ke sms.coeminna.edu.ng 13 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁bootstrap	dir	—	2024-08-05 08:37	📂 Buka
📁dist	dir	—	2024-08-05 08:37	📂 Buka
📁fps	dir	—	2024-08-05 08:36	📂 Buka
📁inc	dir	—	2024-08-05 08:36	📂 Buka
📁plugins	dir	—	2024-08-05 08:42	📂 Buka
📁uploads	dir	—	2024-08-05 08:36	📂 Buka
🐘change_pass.php	php	6 KB	2024-08-05 08:36	✏️ Edit 👁️ View
🐘dashboard.php	php	33.5 KB	2024-08-05 08:36	✏️ Edit 👁️ View
🐘error_page.php	php	399 B	2024-08-05 08:36	✏️ Edit 👁️ View
🐘findCat.php	php	521 B	2024-08-05 08:36	✏️ Edit 👁️ View
🐘findType.php	php	1.3 KB	2024-08-05 08:36	✏️ Edit 👁️ View
🐘index.php	php	2.5 KB	2024-08-05 08:36	✏️ Edit 👁️ View
🐘support.php	php	19.8 KB	2024-08-05 08:36	✏️ Edit 👁️ View