1#@!#!123s

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

require '../functions.php';
	checkLogin();
	checkPermissionReport();
	$db_link = connect();

	//Variables $year and $month provide the pre-set values for input fields
	$year = date("Y",time());
	$month = date("m",time());
  
if(isset($_POST['export_rep'])){

    //Sanitize user input
    $rep_month = $_POST['rep_month'];
    $rep_year =  $_POST['rep_year'];
    $firstDay =  $_POST['firstDay'];
    $lastDay =  $_POST['lastDay'];
    $rep_cate =  $_POST['rep_cate'];


    /*** CASE 1: Summarised Report ***/

        //Selection from INCOMES and INCTYPE
        $sql_incomes = "SELECT * FROM incomes WHERE inc_date BETWEEN $firstDay AND $lastDay";
        $query_incomes = mysqli_query($db_link, $sql_incomes);
        checkSQL($db_link, $query_incomes);

        $sql_inctype = "SELECT * FROM inctype";
        $query_inctype = mysqli_query($db_link, $sql_inctype);
        checkSQL($db_link, $query_inctype);


        if ($rep_cate == 'a'){

            //Selection from INCOMES and INCTYPE
            $sql_incomes = "SELECT * FROM incomes WHERE inc_date BETWEEN $firstDay AND $lastDay";
            $query_incomes = mysqli_query($db_link, $sql_incomes);
            checkSQL($db_link, $query_incomes);

            $sql_inctype = "SELECT * FROM inctype";
            $query_inctype = mysqli_query($db_link, $sql_inctype);
            checkSQL($db_link, $query_inctype);


            $html = '<!-- Header Start -->
            <table style="width:100%;" border="0">
            <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">Report Type: Incomes Report</td>
               <td>Branch: Main</td>
               <td>Address: Dhaka</td>
               <td>Date: '.date("d.m.y").'</td>
             </tr>
           </table>
           <!-- Header End -->
            
            <table id="tb_table" style="width:100%">
        <colspan>
            <col width="50%">
            <col width="50%">
        </colspan>
        <tr>
           
                <th colspan="2">Summarised Incomes Report for '.$rep_month.'/'.$rep_year.'
                </th>
        </tr>
        <tr>
            <th>Type</th>
            <th>Amount</th>
        </tr>';


        //Make array for income types
        $inctype = array();
        while($row_inctype = mysqli_fetch_assoc($query_inctype)){
            $inctype[] = $row_inctype;
        }

        //Make array for all incomes for selected month
        $incomes = array();
        while($row_incomes = mysqli_fetch_assoc($query_incomes)){
            $incomes[] = $row_incomes;
        }


                $total_inc = 0;
					foreach ($inctype as $it){
						$total_row = 0;
						foreach ($incomes as $ic) if ($ic['inctype_id'] == $it['inctype_id']) $total_row = $total_row + $ic['inc_amount'];
						$html.= '<tr>
										<td>'.$it['inctype_type'].'</td>
										<td>'.number_format($total_row).' '.$_SESSION['set_cur'].'</td>
									</tr>';
						$total_inc = $total_inc + $total_row;

					}
					$html.= '<tr>
										<th>Total Incomes:</th>
										<th>'.number_format($total_inc).' '.$_SESSION['set_cur'].'</th>
									</tr></table>';
                                    
        }

        /* CASE 2: Detailed Report */
			else{
				$sql_incomes = "SELECT * FROM incomes, inctype, customer WHERE incomes.cust_id = customer.cust_id AND incomes.inctype_id = inctype.inctype_id AND inc_date BETWEEN $firstDay AND $lastDay ORDER BY inc_date, inc_receipt";
				$query_incomes = mysqli_query($db_link, $sql_incomes);
				checkSQL($db_link, $query_incomes);

			$html='<!-- Header Start -->
      <table style="width:100%;" border="0">
      <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">Report Type: Incomes Report</td>
         <td>Branch: Main</td>
         <td>Address: Dhaka</td>
         <td>Date: '.date("d.m.y").'</td>
       </tr>
     </table>
     <!-- Header End -->

				<!-- TABLE: Results -->    
				<table id="tb_table">
					<colspan>
						<col width="15%">
						<col width="20%">
						<col width="20%">
						<col width="30%">
						<col width="15%">
					</colspan>
					<tr>
							<th colspan="5">Detailed Incomes Report for '.$rep_month.'/'.$rep_year.'</th>

					</tr>
					<tr>
						<th>Date</th>
						<th>Amount</th>
						<th>Type</th>
						<th>From</th>
						<th>Receipt No.</th>
					</tr>';


                    $total_inc = 0;
					while($row_incomes = mysqli_fetch_assoc($query_incomes)){
						$html.= '<tr>
										<td>'.date("d.m.Y",$row_incomes['inc_date']).'</td>
										<td>'.number_format($row_incomes['inc_amount']).' '.$_SESSION['set_cur'].'</td>
										<td>'.$row_incomes['inctype_type'].'</td>
										<td>'.$row_incomes['cust_name'].'</td>
										<td>'.$row_incomes['inc_receipt'].'</td>
									</tr>';
						$total_inc = $total_inc + $row_incomes['inc_amount'];

					}
					$html.= '<tr class="balance">
									<th colspan="5">Total Incomes: '.number_format($total_inc).' '.$_SESSION['set_cur'].'</th>
								</tr></table>';

            }


}

    
              

$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 = 'Incomes_report.pdf';

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