1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / mbcsl.mfmsbd.com /
Filename : branch_report.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)OR DIE("Query Faild");
        checkSQL($db_link, $query_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);
        checkSQL($db_link, $query_branch);
    }  
?>


<?php headandmenu('Customer of Branch', '2b'); ?>

<!--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">Customer of Branch</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->


		<!-- MENU: Selection Bar -->
		<div id="menu_selection">  

			<form action="branch_report.php" method="get">
			
				Select Branch: <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="bcust_search" value="Search Customers" />
			</form>
		</div>
<?php 

if (isset($_GET['bcust_search'])) {

$branch_id = $_GET['branch_id'];

// $sql_branch = "SELECT * FROM customer WHERE custbranch_id = '$branch_id'";

$sql_custact_branch = "SELECT * FROM customer LEFT JOIN custsex ON custsex.custsex_id = customer.custsex_id LEFT JOIN branch ON branch.branch_id=customer.custbranch_id WHERE cust_active = 1 AND custbranch_id = '$branch_id' ORDER BY cust_id";

$query_custact_branch = mysqli_query($db_link, $sql_custact_branch);

?>

<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>
				
					<th class="title" colspan="10">Active Customers</th>

			</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>
				<th>Branch</th>
				<th>Actions</th>
			</tr>
			<?php
			$count = 0;
			 while ($row_custact = mysqli_fetch_assoc($query_custact_branch)) 
			 	{?>
							<tr>
								<td>
									<a href="customer.php?cust=<?php echo $row_custact['cust_id']; ?>"><?php echo $row_custact['cust_no']; ?></a>
								</td>
								<td><?php echo $row_custact['cust_name']?></td>
								<td><?php echo $row_custact['custsex_name']?></td>
								<td><?php echo date("d.m.Y",$row_custact['cust_dob'])?></td>
								<td><?php echo $row_custact['cust_occup']?></td>
								<td><?php echo $row_custact['cust_address']?></td>
								<td><?php echo $row_custact['cust_phone']?></td>
								<td><?php echo date("d.m.Y",$row_custact['cust_since'])?></td>
								<td><?php echo $row_custact['branch_name']; ?></td>
								<td>
									<a class="btn btn-info btn-sm text-light" href="customer.php?cust=<?php echo $row_custact['cust_id']?>"><i class="fa-solid fa-pen-to-square"></i></a>
									<!-- <a onclick="return confirm('Are you sure to delete?')" class="btn btn-sm btn-danger text-light" href="delete_cust.php?id=<?php echo $row_custact['cust_id']?>"><i class="bi bi-trash"></i></a> -->
								</td>
							</tr>

						<?php

				
				$count++;
			}
			?>

			<tr class="balance">
				<td colspan="10">
				<?PHP
				echo $count.' active customer';
				if ($count != 1) echo 's';
				?>
				</td>
			</tr>
		</table>
</div>

<?php } ?>

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