1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / ppbskt.mfmsbd.com /
Filename : loans_securities.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.'_loan-securities';
	//Select loans that have securities
	if($_SESSION['branch_id']) {
        $branch_id = $_SESSION['branch_id'];

        $sql_loans = "SELECT * FROM loans LEFT JOIN loanstatus ON loans.loanstatus_id = loanstatus.loanstatus_id LEFT JOIN customer ON loans.cust_id = customer.cust_id WHERE loan_id IN (SELECT DISTINCT loan_id FROM securities WHERE sec_returned = 0) AND branch_id=$branch_id ORDER BY loan_dateout, loans.cust_id";
    $query_loans = mysqli_query($db_link, $sql_loans);
    // checkSQL($db_link, $query_loans);

    }else {

    $sql_loans = "SELECT * FROM loans LEFT JOIN loanstatus ON loans.loanstatus_id = loanstatus.loanstatus_id LEFT JOIN customer ON loans.cust_id = customer.cust_id WHERE loan_id IN (SELECT DISTINCT loan_id FROM securities WHERE sec_returned = 0) ORDER BY loan_dateout, loans.cust_id";
    $query_loans = mysqli_query($db_link, $sql_loans);
    // checkSQL($db_link, $query_loans);
    }
?>
<?php headandmenu('Loan Securities', '5l'); ?>
<!--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">Loans Securities</li>
					</ol>
				</nav>
			</div>
		</div>
		<!--breadcrumbs end -->
		<!-- CONTENT -->
		<div class="content-center">
			<div class="table-responsive">
				<table id="tb_table">
					<colgroup>
					<col width="20%">
					<col width="20%">
					<col width="20%">
					<col width="20%">
					<col width="20%">
					</colgroup>
					<tr>
						<form class="export" action="rep_export.php" method="post">
							<th class="title" colspan="5">Current Loan Securities
								<!-- Export Button -->
								<input type="submit" name="export_rep" value="Export" />
							</th>
						</form>
					</tr>
					<tr>
						<th>Loan No.</th>
						<th>Customer</th>
						<th>Loan Status</th>
						<th>Security 1</th>
						<th>Security 2</th>
					</tr>
					<?PHP
					$count = 0;
					while ($row_loans = mysqli_fetch_assoc($query_loans)){
						$securities = getLoanSecurities($db_link, $row_loans['loan_id']);
						$security1 = NULL;
						$security2 = NULL;
						foreach ($securities as $s){
							if ($s['sec_no'] == 1) $security1 = $s;
							elseif ($s['sec_no'] == 2) $security2 = $s;
						}
						echo '<tr>
											<td><a href="loan.php?lid='.$row_loans['loan_id'].'">'.$row_loans['loan_no'].'</a></td>
											<td>'.$row_loans['cust_name'].' (<a href="customer.php?cust='.$row_loans['cust_id'].'">'.$row_loans['cust_no'].')</a></td>
											<td>'.$row_loans['loanstatus_status'].'</td>
											<td><a href="security.php?security='.$security1['sec_id'].'">'.$security1['sec_name'].'</a></td>
											<td><a href="security.php?security='.$security2['sec_id'].'">'.$security2['sec_name'].'</a></td>
											';
						/*
							if ($security1['sec_path'] != "") {
								echo '<td><a href="'.$security1['sec_path'].'" target="_blank">'.$security1['sec_name'].' <i class="fa fa-eye"></i></a></td>';
							}
							else echo '<td>'.$security1['sec_name'].'</td>';
							if ($security2['sec_path'] != "") {
								echo '<td><a href="'.$security2['sec_path'].'" target="_blank">'.$security2['sec_name'].' <i class="fa fa-eye"></i></a></td>';
							}
							else echo '<td>'.$security2['sec_name'].'</td>';
							*/
						echo '</tr>';
						// Export Array
						array_push($_SESSION['rep_export'], array("Loan No." => $row_loans['loan_no'], "Customer" => $row_loans['cust_name'].' ('.$row_loans['cust_no'].')', "Status" => $row_loans['loanstatus_status'],"Security 1" => $security1['sec_name'], "Security 2" => $security2['sec_name']));
						$count++;
					}
					?>
					<tr class="balance">
						<td	colspan="5">
							<?PHP
							echo $count.' loans with securities';
							?>
						</td>
					</tr>
				</table>
			</div>
		</div>
		
	</section>
</section>
<!--main content end-->
<!-- Footer -->
<?php footer(); ?>