<?php include("sass/icon_for_datepicker_and_datatable.php");?>
              
        <div class="wrapper row-offcanvas row-offcanvas-left">
            <!-- Left side column. contains the logo and sidebar -->
            <?php include("sass/sidebar.php");?>

            <!-- Right side column. Contains the navbar and content of the page -->
               <aside class="right-side">
                <!-- Content Header (Page header) -->
                <section class="content-header">
                    <h1>
                       <?php echo $company_name ; ?>
                        <small>Control panel</small>
                    </h1>
                    <ol class="breadcrumb">
                        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
                        <li class="active">Dashboard</li>
                    </ol>
                </section>
                 <section class="content">
                  <?php 
				 
				 $result_for_unit_type = mysqli_query($connection,"SELECT SUM(cash) as total FROM cash WHERE branch_id  = '$branch_id_for_header_user'");
		$test_for_unit_type = mysqli_fetch_array($result_for_unit_type);
				
				$total_cash=$test_for_unit_type['total'];
				
				$result_for_bank = mysqli_query($connection,"SELECT SUM(balance) as total_bank FROM bank_name");
		$test_for_bank = mysqli_fetch_array($result_for_bank);
				
				$total_bank=$test_for_bank['total_bank'];
				 
				 ?>
                 	 <div class="row">
                        <div class="col-md-6 col-md-offset-3">
                 <!---Main Content--->
                
                 <div class="alert alert-info" style="margin-bottom: 0!important;">
                        <i class="fa fa-money" style="font-size:20px; font-weight:200;"></i>
                        <h3> Your present cash ammount is <?php echo ($total_cash) ; ?> Taka </h3>
                    </div>
                 			
                 
                 		</div>
                    </div>
                    
                    <br />

                    <div class="row">
                        <div class="col-md-6 col-md-offset-3">
                 <!---Main Content--->
                
                 <div class="alert alert-info" style="margin-bottom: 0!important;">
                        <i class="fa fa-usd" style="font-size:20px; font-weight:200;"></i>
                        <h3> Your present bank balance is <?php echo ($total_bank) ; ?> Taka </h3>
                    </div><br> <br> <table border="1">
                 		<?php 
						
						$query = "SELECT * FROM bank_name";
														
                                                $result = mysqli_query($connection,$query);
                                                
                                                
												  $i=0;
                                                while($row=mysqli_fetch_array($result))
                                                {
						
						$bank_name = $row['bank_name'];
						$balance = $row['balance'];
						
						echo "<tr><td>$bank_name</td>
						<td>$balance</td></tr>";
						
						
						}
						
						?>	
                 </table>
                 		</div>
                    </div>
                 
                 
                 </section>
                </aside>
                <!-- /.right-side -->
        </div><!-- ./wrapper -->

        <!-- add new calendar event modal -->


        <!-- jQuery 2.0.2 -->
         <?php include("sass/footer_for_datepicker_and_datatable.php");?>

    </body>
</html>