1#@!#!123s

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

require '../functions.php';
	checkLogin();
	$db_link = connect(); 
 
	//Make array for exporting data
	$rep_year = date("Y",time());
	$rep_month = date("m",time());
	$_SESSION['rep_export'] = array();
	$_SESSION['rep_exp_title'] = $rep_year.'-'.$rep_month.'_cust-active';

	//Select inactive customers from CUSTOMER
	$query_custinact = getCustInact($db_link);

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


    $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: Inactive Customer</td>
       <td>Branch: '.$branch_row['branch_name'].'</td>
       <td>Address: Dhaka</td>
       <td>Date: '.date("d.m.y").'</td>
     </tr>
   </table>
   <!-- Header End -->
    
    <!-- TABLE: Active Customers -->
		<div class="table-responsive">
		<table id="tb_table">
			<colgroup>
				<col width="8%" />
				<col width="14%" />
				<col width="8%" />
				<!-- <col width="8%" /> -->
				<col width="12%" />
				<col width="12%" />
				<col width="12%" />
				<col width="8%" />
				<col width="10%" />
				<col width="8%" />
			</colgroup>

			<tr>
			
			</tr>
			<tr>
            <th>Cust. No.</th>
            <th>Name</th>
            <th>Gender</th>
            <th>DoB</th>
            <th>Occupation</th>
            <th>Address</th>
            <th>Phone No.</th>
            <th>Memb. since</th>
			</tr>';

			$count = 0; 
			
			while ($row_custinact = mysqli_fetch_assoc($query_custinact)){

                $loan_balances = getLoanBalance($db_link, $row_custinact['loan_id']);
                
							$html.='<tr>
                            <td>
                            <a>'.$row_custinact['cust_no'].'</a>
                        </td>
                        <td>'.$row_custinact['cust_name'].'</td>
                        <td>'.$row_custinact['custsex_name'].'</td>
                        <td>'.date("d.m.Y",$row_custinact['cust_dob']).'</td>
                        <td>'.$row_custinact['cust_occup'].'</td>
                        <td>'.$row_custinact['cust_address'].'</td>
                        <td>'.$row_custinact['cust_phone'].'</td>
                        <td>'.date("d.m.Y",$row_custinact['cust_since']).'</td>
							</tr>';
                            $count++;
                        } 


			$html.='<tr class="balance">
				<td colspan="10">'.

				$count.' Inactive customer';
				if ($count != 1) echo 's';

				$html.='</td>
			</tr>
		</table>
        
	</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_customer.pdf';

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


?>