1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / goldenvillage.mfmsbd.com /
Filename : branch_income_rep.php
back
<?PHP
	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($_SESSION['branch_id']){

        $branch_id = $_SESSION['branch_id'];
        $sql_branch = "SELECT * FROM branch WHERE branch_id= $branch_id";
        $query_branch = mysqli_query($db_link, $sql_branch);
        $branch_name= mysqli_fetch_assoc($query_branch);

    }else{

        //Select Branch for Drop-down-Menu
        $sql_branch = "SELECT * FROM branch";
        $query_branch = mysqli_query($db_link, $sql_branch);
    }


?>
<?php headandmenu('Branch Incomes Report', '3b'); ?>

<!--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="#">Branch Reports</a></li>
                              <li class="breadcrumb-item active" aria-current="page">Branch Incomes Report</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->

             
		<!-- MENU: Selection Bar -->

		<div id="menu_selection">
			<form action="branch_income_rep.php" method="post">
				<input type="number" min="2006" max="2206" name="rep_year" style="width:100px;" value="<?PHP if ($month == 01) echo $year-1; else echo $year; ?>" placeholder="Year" />
				<select name="rep_month">
					<option value="01" <?PHP if ($month == 2) echo 'selected="selected"' ?> >January</option>
					<option value="02" <?PHP if ($month == 3) echo 'selected="selected"' ?> >February</option>
					<option value="03" <?PHP if ($month == 4) echo 'selected="selected"' ?> >March</option>
					<option value="04" <?PHP if ($month == 5) echo 'selected="selected"' ?> >April</option>
					<option value="05" <?PHP if ($month == 6) echo 'selected="selected"' ?> >May</option>
					<option value="06" <?PHP if ($month == 7) echo 'selected="selected"' ?> >June</option>
					<option value="07" <?PHP if ($month == 8) echo 'selected="selected"' ?> >July</option>
					<option value="08" <?PHP if ($month == 9) echo 'selected="selected"' ?> >August</option>
					<option value="09" <?PHP if ($month == 10) echo 'selected="selected"' ?> >September</option>
					<option value="10" <?PHP if ($month == 11) echo 'selected="selected"' ?> >October</option>
					<option value="11" <?PHP if ($month == 12) echo 'selected="selected"' ?> >November</option>
					<option value="12" <?PHP if ($month == 1) echo 'selected="selected"' ?> >December</option>
				</select>
				<select name="rep_form" style="height:24px;">
					<option value="d" selected="selected">Detailed Rep.</option>
					<option value="a">Summarised Rep.</option>
				</select>
				<select name="branch_id" size="1" tabindex="10">
                    <?php
                            if($_SESSION['branch_id']){?>
                            <option value="<?php echo $_SESSION['branch_id']; ?>"><?php echo $branch_name['branch_name']; ?></option>
                            <?php 
                            }else{
                                    while ($row_branch = mysqli_fetch_assoc($query_branch)){
                                        echo '<option value="'.$row_branch['branch_id'].'">'.$row_branch['branch_name'].'</option>';
                                    }
                            }
                        ?>
                
				</select>
				<input type="submit" name="select" value="Select Report" />
			</form>
		</div>


		<?PHP
		if(isset($_POST['select'])){
			
			//Branch ID
			$branch_id = $_POST['branch_id'];

			//Sanitize user input
			$rep_month = sanitize($db_link, $_POST['rep_month']);
			$rep_year = sanitize($db_link, $_POST['rep_year']);

			//Calculate UNIX TIMESTAMP for first and last day of selected month
			$firstDay = mktime(0, 0, 0, $rep_month, 1, $rep_year);
			$lastDay = mktime(0, 0, 0, ($rep_month+1), 0, $rep_year);

            $sql_branch_name = "SELECT branch_name FROM branch WHERE branch_id=$branch_id";
			$query_branch_name = mysqli_query($db_link, $sql_branch_name);
			$row_branch_name = mysqli_fetch_assoc($query_branch_name);

			//Make array for exporting data
			$_SESSION['rep_export'] = array();
			$_SESSION['rep_exp_title'] = $rep_year.'-'.$rep_month.'_'.$row_branch_name['branch_name'].'_incomes_'.$_POST['rep_form'];

			/*** CASE 1: Summarised Report ***/
			if ($_POST['rep_form'] == 'a'){

				//Selection from INCOMES and INCTYPE
				$sql_incomes = "SELECT * FROM incomes WHERE incbranch_id=$branch_id AND 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);
				?>

				<!-- TABLE: Results -->
                
                <h4 class="text-center"><?php echo "Branch: ".$row_branch_name['branch_name']; ?></h4>
				<table id="tb_table" style="width:50%">
                
					<colspan>
						<col width="50%">
						<col width="50%">
					</colspan>
					<tr>
						<form class="export" action="rep_export.php" method="post">
							<th class="title" colspan="2">Summarised Incomes Report for <?PHP echo $rep_month.'/'.$rep_year; ?>
								<!-- Export Button -->
								<input type="submit" name="export_rep" value="Export" />
							</th>
						</form>
					</tr>
					<tr>
						<th>Type</th>
						<th>Amount</th>
					</tr>
					<?PHP
					//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;
					}

					//Iterate over income types and add matching incomes to $total
					$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'];
						echo '<tr>
										<td>'.$it['inctype_type'].'</td>
										<td>'.number_format($total_row).' '.$_SESSION['set_cur'].'</td>
									</tr>';
						$total_inc = $total_inc + $total_row;

						//Prepare data for export to Excel file
						array_push($_SESSION['rep_export'], array("Type" => $it['inctype_type'], "Amount" => $total_row));
					}
					echo '	<tr class="balance">
										<td>Total Incomes:</td>
										<td>'.number_format($total_inc).' '.$_SESSION['set_cur'].'</td>
									</tr>';
			}



			/* CASE 2: Detailed Report */
			else{
			
				$sql_incomes = "SELECT * FROM incomes, inctype, customer WHERE incomes.cust_id = customer.cust_id AND incbranch_id=$branch_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);
				?>

				
                <h4 class="text-center"><?php echo "Branch: ".$row_branch_name['branch_name']; ?></h4>
				<!-- TABLE: Results -->
                <div class="table-responsive">
				<table id="tb_table">
					<colspan>
						<col width="15%">
						<col width="20%">
						<col width="15%">
						<col width="25%">
						<col width="15%">
						<col width="10%">
					</colspan>
					<tr>
						<form class="export" action="rep_export.php" method="post">
							<th class="title" colspan="6">Detailed Incomes Report for <?PHP echo $rep_month.'/'.$rep_year; ?>
							<!-- Export Button -->
							<input type="submit" name="export_rep" value="Export" />
							</th>
						</form>
					</tr>
					<tr>
						<th>Date</th>
						<th>Amount</th>
						<th>Type</th>
						<th>From</th>
						<th>Receipt No.</th>
						<th>Branch</th>
					</tr>
					<?PHP
					$total_inc = 0;
					while($row_incomes = mysqli_fetch_assoc($query_incomes)){
						echo '<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>
										<td>'.$row_branch_name['branch_name'].'</td>
									</tr>';
						$total_inc = $total_inc + $row_incomes['inc_amount'];

						//Prepare data for export to Excel file
						array_push($_SESSION['rep_export'], array("Date" => date("d.m.Y",$row_incomes['inc_date']), "Amount" => $row_incomes['inc_amount'], "Type" => $row_incomes['inctype_type'], "From" => $row_incomes['cust_name'], "Receipt No" => $row_incomes['inc_receipt'], "Branch" => $row_branch_name['branch_name']));
					}
					echo '<tr class="balance">
									<td colspan="6">Total Incomes: '.number_format($total_inc).' '.$_SESSION['set_cur'].'</td>
								</tr>';
			}
		}
		?>
		</table>
    </div>

		
          </section>
      </section>
      <!--main content end-->
      
   <?php footer(); ?>