<?php
session_start();
error_reporting(0);
include("../config/theconfig.php");

include("header.php");

if(!($_SESSION["adminid"]))
{
		header("Location: login.php");
}
$loan=mysql_query("select * from loan ");
?>
<!-- Site Content Wrapper -->

              <!-- Site Content Wrapper -->
            <div class="dt-content-wrapper">

                <!-- Site Content -->
                <div class="dt-content">

                    <!-- Page Header -->
                    <div class="dt-page__header">
                        <h1 class="dt-page__title">My Loan</h1>
                    </div>
                    <!-- /page header -->

                    <!-- Grid -->
                    <div class="row">
                    <?
                    if(isset($_POST["approve"]))
{
$sqq="UPDATE loan SET status =1 WHERE loanid='".$_POST[payto]."'";
echo "<script>swal('Succesful!', 'Loan Application Has Been Approved!', 'success')</script>";
 
   if ((!mysql_query($sqq)))
  {
  die('Error: ' . mysql_error());
  print_r($sqq);
  }
  if(mysql_affected_rows() == 1)
  {
	$successresult = "Transaction successfull";
  }
  else
  {
	  $successresult = "Failed to transfer";
  }
   }
  ?>
  
  <?
                    if(isset($_POST["disburse"]))
{
$sqq="UPDATE loan SET status =2, balance='".$_POST[bal]."' WHERE loanid='".$_POST[payto]."'";
echo "<script>swal('Succesful!', 'Fund Has Been Disbursed And Loan Is Active And Running Now', 'success')</script>";
 
   if ((!mysql_query($sqq)))
  {
  die('Error: ' . mysql_error());
  print_r($sqq);
  }
  if(mysql_affected_rows() == 1)
  {
	$successresult = "Transaction successfull";
  }
  else
  {
	  $successresult = "Failed to transfer";
  }
   }
  ?>
                    

                        <!-- Grid Item -->
                        <div class="col-xl-12">

                            <!-- Entry Header -->
                            <div class="dt-entry__header">

                                <!-- Entry Heading -->
                                <div class="dt-entry__heading">
                                    <h3 class="dt-entry__title">View Loan</h3>
                                </div>
                                <!-- /entry heading -->

                            </div>
                            <!-- /entry header -->

                            <!-- Card -->
                            <div class="dt-card">

                                <!-- Card Body -->
                                <div class="dt-card__body">

                                    <!-- Tables -->
                                    <div class="table-responsive">

                                        <table id="data-table" class="table table-striped table-bordered table-hover">
                                                  <thead>
                                            <tr>
                                                <th>Loan Type</th>
                                                <th>Loan Account</th>
                                                <th>Loan Amount</th>
                                                <th>Loan Interest</th>
                                                <th>Application Date</th>
                                                <th>Action</th>
                                                <th>Status</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                           </tr>
 <?php
				  $i=1;
			  while($arrvar = mysql_fetch_array($loan))
                          {
        	           echo " <tr>
                                <td>$arrvar[loantype]</td>
				<td>$arrvar[loannumber]</td>
				<td>$cur $arrvar[loanamt]</td>
                                <td>$arrvar[interest] %</td>
				<td>$arrvar[startdate]</td>
				
<td>
 <form method='post' action='viewloanapp.php' >
 <input hidden value='$arrvar[loanid]' name='payto'>
 <input hidden value='$arrvar[customerid]' name='custid'>
<input type='submit' class='btn btn-secondary' name='pay'  value='View' />
</form>
</td>";?>
<td>
<span class="badge badge-pill badge-danger mb-1 mr-1"><? if ($arrvar[status]=='0') print "Pending Approval";?></span>
<span class="badge badge-pill badge-success mb-1 mr-1"><? if ($arrvar[status]=='1') print "Approved";?></span>
<span class="badge badge-pill badge-info mb-1 mr-1"><? if ($arrvar[status]=='2') print "Fund Disbursed";?></span></td>
				

      	      </tr><?
				$i++;
			  }
			  ?>                                     </tbody>
                                            <tfoot>
                                            <tr>
                                                <th>Loan Type</th>
                                                <th>Loan Account</th>
                                                <th>Loan Amount</th>
                                                <th>Loan Interest</th>
                                                <th>Application Date</th>
                                               <th>Action</th>
                                                <th>Status</th>
                                            </tr>
                                            </tfoot>
                                           
                                        </table>
                                    </div>
                                    <!-- /tables -->

                                </div>
                                <!-- /card body -->

                            </div>
                            <!-- /card -->

                        </div>
                        <!-- /grid item -->

                    </div>
                    <!-- /grid -->

                </div>
                <!-- /site content -->



<?php include'footer.php' ?>
    
<script src="../assets/node_modules/datatables.net/js/jquery.dataTables.js"></script>
<script src="../assets/node_modules/datatables.net-bs4/js/dataTables.bootstrap4.js"></script>
<script src="../assets/js/custom/data-table.js"></script>
