1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / prothito.mfmsbd.com /
Filename : loans_pend.php
back
<?PHP
	require 'functions.php';
	checkLogin();
	$db_link = connect();

	$rep_year = date("Y",time());
	$rep_month = date("m",time());

	//Make array for exporting data
	$_SESSION['rep_export'] = array();
	$_SESSION['rep_exp_title'] = $rep_year.'-'.$rep_month.'_loans-pending';

	

    if($_SESSION['branch_id']){

    $branch_id = $_SESSION['branch_id']; 
	$sql_loanpend = "SELECT * FROM loans LEFT JOIN loanstatus ON loans.loanstatus_id = loanstatus.loanstatus_id LEFT JOIN customer ON loans.cust_id = customer.cust_id WHERE loans.loanstatus_id = 1 AND loans.branch_id=$branch_id ORDER BY loan_date, loan_no";
	$query_loanpend = mysqli_query($db_link, $sql_loanpend);
	checkSQL($db_link, $query_loanpend);

    }else{
        //Select Pending Loans from LOANS
        $sql_loanpend = "SELECT * FROM loans LEFT JOIN loanstatus ON loans.loanstatus_id = loanstatus.loanstatus_id LEFT JOIN customer ON loans.cust_id = customer.cust_id WHERE loans.loanstatus_id = 1 ORDER BY loan_date, loan_no";
        $query_loanpend = mysqli_query($db_link, $sql_loanpend);
        checkSQL($db_link, $query_loanpend);
    }

?>
<?php headandmenu('Pending Loans', '4l'); ?>

      <!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">


          		<!--breadcrumbs start -->
          	<div class="row">
                  <div class="col-lg-12 pb-4">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
                              <li class="breadcrumb-item"><a href="#">Loans</a></li>
                              <li class="breadcrumb-item active" aria-current="page">Pending Loans</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->




		<!-- CONTENT: Pending Loans -->
		<div class="content-center">
		<div class="table-responsive">
			<table id="tb_table">
				<colgroup>
					<col width="10%"/>
					<col width="30%"/>
					<col width="10%"/>
					<col width="10%"/>
					<col width="15%"/>
					<col width="15%"/>
					<col width="10%"/>
				</colgroup>
				<tr>
					<form class="export" action="rep_export.php" method="post">
						<th class="title" colspan="7">Pending Loans
						<!-- Export Button -->
						<input type="submit" name="export_rep" value="Export" />
						</th>
					</form>
				</tr>
				<tr>
					<th>Loan No.</th>
					<th>Customer</th>
					<th>Status</th>
					<th>Loan Period</th>
					<th>Principal applied</th>
					<th>Interest</th>
					<th>Applied for on</th>
				</tr>
				<?PHP
				$total_loanpend = 0;
				$count = 0;
				while($row_loanpend = mysqli_fetch_assoc($query_loanpend)){
					echo '<tr>
									<td><a href="loan.php?lid='.$row_loanpend['loan_id'].'">'.$row_loanpend['loan_no'].'</a></td>
									<td>'.$row_loanpend['cust_name'].' ('.$row_loanpend['cust_no'].')</td>
									<td>'.$row_loanpend['loanstatus_status'].'</td>
									<td>'.$row_loanpend['loan_period'].'</td>
									<td>'.number_format($row_loanpend['loan_principal']).' '.$_SESSION['set_cur'].'</td>
									<td>'.number_format(($row_loanpend['loan_repaytotal'] - $row_loanpend['loan_principal'])).' '.$_SESSION['set_cur'].'</td>
									<td>'.date("d.m.Y",$row_loanpend['loan_date']).'</td>
								</tr>';

					// Export Array
					array_push($_SESSION['rep_export'], array("Loan No." => $row_loanpend['loan_no'], "Customer" => $row_loanpend['cust_name'].' ('.$row_loanpend['cust_no'].')', "Status" => $row_loanpend['loanstatus_status'], "Loan Period" => $row_loanpend['loan_period'], "Principal" => $row_loanpend['loan_principal'], "Interest" => ($row_loanpend['loan_repaytotal'] - $row_loanpend['loan_principal']), "Repay Total" => $row_loanpend['loan_repaytotal'], "Applied for on" => date("d.m.Y",$row_loanpend['loan_date'])));

					$count++;
				}
				?>
				<tr class="balance">
					<td colspan="7">
					<?PHP
					echo $count.' pending loan';
					if ($count != 1) echo 's';
					?>
					</td>
				</tr>
			</table>
		</div>
		</div>



 </section>
      </section>
      <!--main content end-->

<!-- Footer -->
      <?php footer(); ?>