1#@!#!123s

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

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

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

	//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 ***/
			if ($rep_cate == 'a'){
				$sql_expendit = "SELECT * FROM expenses WHERE exp_date BETWEEN $firstDay AND $lastDay ORDER BY exp_date";
				$query_expendit = mysqli_query($db_link, $sql_expendit);
				checkSQL($db_link, $query_expendit);

				$sql_exptype = "SELECT * FROM exptype";
				$query_exptype = mysqli_query($db_link, $sql_exptype);
				checkSQL($db_link, $query_exptype);


	$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: Expenses Report</td>
       <td>Branch: Main</td>
       <td>Address: '.$_SESSION['samabay_name'].'</td>
       <td>Date: '.date("d.m.y").'</td>
     </tr>
   </table>
   <!-- Header End -->

    			<!-- TABLE: Results -->
				<table id="tb_table" style="width:100%">
					<colspan>
						<col width="50%">
						<col width="50%">
					</colspan>
					<tr>
						<form class="export" action="rep_export.php" method="post">
							<th class="title" colspan="2">Summarised Expenses for '.$rep_month.'/'.$rep_year.'
							</th>
						</form>
					</tr>
					<tr>
						<th>Type</th>
						<th>Amount</th>
					</tr>'.

					$exptype = array();
					while($row_exptype = mysqli_fetch_assoc($query_exptype)){
						$exptype[] = $row_exptype;
					}

					$expendit = array();
					while($row_expendit = mysqli_fetch_assoc($query_expendit)){
						$expendit[] = $row_expendit;
					}

					$total_exp = 0;
					foreach ($exptype as $et){
						$total_row = 0;
						foreach ($expendit as $ex) if ($ex['exptype_id'] == $et['exptype_id']) $total_row = $total_row + $ex['exp_amount'];
						$html.= '<tr>
										<td>'.$et['exptype_type'].'</td>
										<td>'.number_format($total_row).' '.$_SESSION['set_cur'].'</td>
									</tr>';
						$total_exp = $total_exp + $total_row;

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

			/*** CASE 2: Detailed Report ***/
			else{
				$sql_expendit = "SELECT * FROM expenses, exptype WHERE expenses.exptype_id = exptype.exptype_id AND exp_date BETWEEN $firstDay AND $lastDay ORDER BY exp_date";
				$query_expendit = mysqli_query($db_link, $sql_expendit);
				checkSQL($db_link, $query_expendit);

                $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: Expenses 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="10%">
						<col width="15%">
						<col width="20%">
						<col width="20%">
						<col width="10%">
						<col width="10%">
						<col width="15%">
					</colspan>
					<tr>
						<form class="export" action="rep_export.php" method="post">
							<th class="title" colspan="7">Detailed Expenses for '.$rep_month.'/'.$rep_year.'
							</th>
						</form>
					</tr>
					<tr>
						<th>Date</th>
						<th>Type</th>
						<th>Recipient</th>
						<th>Details</th>
						<th>Receipt No.</th>
						<th>Voucher No.</th>
						<th>Amount</th>
					</tr>'.

					$total_exp = 0;
					while($row_expendit = mysqli_fetch_assoc($query_expendit)){
						$html.= '<tr>
										<td>'.date("d.m.Y",$row_expendit['exp_date']).'</td>
										<td>'.$row_expendit['exptype_type'].'</td>
										<td>'.$row_expendit['exp_recipient'].'</td>
										<td>'.$row_expendit['exp_text'].'</td>
										<td>'.$row_expendit['exp_receipt'].'</td>
										<td>'.$row_expendit['exp_voucher'].'</td>
										<td>'.number_format($row_expendit['exp_amount']).' '.$_SESSION['set_cur'].'</td>
									</tr>';
						$total_exp = $total_exp + $row_expendit['exp_amount'];
					}
					$html.= '<tr class="balance">
									<th colspan="7">Total expenses: '.number_format($total_exp).' '.$_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 = 'Expenses_report.pdf';

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