1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / ppbskt.mfmsbd.com / report /
Filename : loans_pend_pdf.php
back
<?php
require_once __DIR__ . '/vendor/autoload.php';
session_start();

 
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';

// Show Branch Name
$_SESSION['branch_id'] ? $branch_id = $_SESSION['branch_id'] : $branch_id=1;
$branch_query = mysqli_query($db_link, "SELECT branch_name FROM `branch` WHERE branch_id = $branch_id");
$branch_row = mysqli_fetch_assoc($branch_query);


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);
}

 

$html.='

<!-- Header Start -->
    <table style="width:100%" >
    <tr>
       <td width="30%"><img src="logo.png" width="150px"></td>
       <td colspan="4" style="text-align: center;"><h2 style="text-align: center;">'.$_SESSION['samabay_name'].'</h2></td>
     </tr>
   
      <tr>
       <td colspan="2">Type: Pending Loans</td>
       <td>Branch: '.$branch_row['branch_name'].'</td>
       <td>Address: Dhaka</td>
       <td>Date: '.date("d.m.y").'</td>
     </tr>
   </table>
   <!-- Header 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>
           
        </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>';

        $total_loanpend = 0;
        $count = 0;
        while($row_loanpend = mysqli_fetch_assoc($query_loanpend)){
            $html.= '<tr>
                            <td><a>'.$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>';
            $count++;
        }

       $html.='<tr class="balance">
            <td colspan="7">'.
            $count.' pending loan';
            if ($count != 1) $html.= 's';

            $html.='</td>
        </tr>
    </table>
</div>
</div>';




$mpdf = new \Mpdf\Mpdf();

 
$mpdf->SetHTMLFooter('
  <p style="text-align: center">Thank you for using MFMSBD.</p> 
');

$mpdf->WriteHTML('<style>
table, td, th {  
  border: 1px solid #ddd;
  text-align: left;
  margin-bottom: 30px;
}

table {
  border-collapse: collapse;
  width: 100%;
}

th, td {
  padding: 7px;
}
</style>

'.$html);

$file = 'Inactive_loans.pdf';

$mpdf->Output($file, 'I');


?>