<?php



include 'load.php';
$branch_id = $_SESSION['branch_id'];


?>

 

 <!DOCTYPE html>

<html lang="en">

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">

<meta name="description" content="POS - Payroll | Pos & Invetory System | Dashboard

">

<meta name="keywords" content="Payroll | Pos & Invetory System | Dashboard

">

<meta name="author" content="Payroll | Pos & Invetory System | Dashboard

">

<meta name="robots" content="noindex, nofollow">



<title>Home | Payroll | Pos & Invetory System | Dashboard

</title>



<?php

require_once 'headercss.php';

?>



</head>

<body>

<div id="global-loader">

<div class="whirly-loader"> </div>

</div>



<div class="main-wrapper">

<?php

require_once 'header.php';

?>



<?php

require_once 'navbar.php';

?>



<div class="page-wrapper">

<div class="content">

<div class="page-header">

<div class="page-title">

<h4>Cash List</h4>

<h6>Manage your Cash</h6>

</div>

<div class="page-btn">

<a href="cash-in.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" class="me-2" alt="img">Add Cash</a>

</div>

</div>



<div class="card">

<div class="card-body">

<div class="table-top">



</div>



<div class="card" id="filter_inputs">

<div class="card-body pb-0">

<div class="row">

<div class="col-lg-3 col-sm-6 col-12">

<div class="form-group">

<input type="text" placeholder="Enter Brand Name">

</div>

</div>

<div class="col-lg-3 col-sm-6 col-12">

<div class="form-group">

<input type="text" placeholder="Enter Brand Description">

</div>

</div>

<div class="col-lg-1 col-sm-6 col-12 ms-auto">

<div class="form-group">

<a class="btn btn-filters ms-auto"><img src="assets/img/icons/search-whites.svg" alt="img"></a>

</div>

</div>

</div>

</div>

</div>



<div class="table-responsive">

<table class="table" id="betable">

<thead>

<tr>



<th>ID</th>

<th>Action</th>

<th>5000</th>

<th>1000</th>

<th>500</th>

<th>100</th>

<th>50</th>

<th>20</th>

<th>Coins</th>

<th>Total</th>

<th>Sales Total</th>

<th>Sales Balance</th>

<th>Cash Total</th>

<th>Expenses Total</th>

<th>Money In Total</th>

<th>Money Out Total</th>

<th>Cash Balance</th>

<th>Date</th>

</tr>

</thead>

<tbody> 

<?php



										$stmt = $DB_con->prepare('SELECT * FROM cash_in_out WHERE branch_id=:branch_id ORDER BY cash_id');
										$stmt->bindParam(':branch_id', $branch_id, PDO::PARAM_INT);


										$stmt->execute();



										if($stmt->rowCount() > 0)



										{



										while($row=$stmt->fetch(PDO::FETCH_ASSOC))



										{



										extract($row);



										?>

<tr>

<td><?php echo $row['cash_id']; ?></td>

<td>

<a href="editcash.php?cash_id=<?php echo $row["cash_id"]; ?>" class="btn btn-block btn-outline-primary active btn-sm text-white"><i class="fa fa-edit" data-bs-toggle="tooltip" title="" data-bs-original-title="fa fa-edit" aria-label="fa fa-edit"></i></a>



</td>

<td>

<?php echo $row['m5000']; ?>

</td>

<td>

<?php echo $row['m1000']; ?>

</td>

<td>

<?php echo $row['m500']; ?>

</td>

<td>

<?php echo $row['m100']; ?>

</td>

<td>

<?php echo $row['m50']; ?>

</td>

<td>

<?php echo $row['m20']; ?>

</td>

<td>

<?php echo $row['coins']; ?>

</td>



<td>

	<?php 

        $sum = 0;

        $sum5000 = $row['m5000']*5000;

        $sum1000 = $row['m1000']*1000;

        $sum500 = $row['m500']*500;

        $sum100 = $row['m100']*100;

        $sum50 = $row['m50']*50;

        $sum20 = $row['m20']*20;

        $coins = $row['coins'];



        $sum =  $sum5000 + $sum1000 + $sum500 + $sum100 + $sum50 +  $sum20 + $coins;



        echo $sum;

	

	?>

</td>



<td>

    <?php 

        $today_date = $row['date'];

        $result = mysqli_fetch_array(mysqli_query($conn, "SELECT sum(amount) as amount,create_at FROM mobileorders WHERE DATE(create_at) ='$today_date' AND branch_id='$branch_id'"));

        echo $result['amount'];

    ?>

</td>

<td>

    <?php 

        $today_date = $row['date'];

        $result4 = mysqli_fetch_array(mysqli_query($conn, "SELECT sum(due_amount) as due_amount,create_at FROM mobileorders WHERE DATE(create_at) ='$today_date' AND branch_id='$branch_id'"));

        echo $result4['due_amount'];

    ?>

</td>

<td>

    <?php echo $sum + $result['amount']; ?>

</td>

<td>

    <?php 

        $today_date = $row['date'];

        $result5 = mysqli_fetch_array(mysqli_query($conn, "SELECT sum(amount) as amount,add_date FROM mobileexpense WHERE DATE(add_date) ='$today_date' AND branch_id='$branch_id'"));

        echo $result5['amount'];

    ?>

</td>

<td>

    <?php 

        $today_date = $row['date'];

        $result6 = mysqli_fetch_array(mysqli_query($conn, "SELECT sum(money) as money,added_date FROM money_in_out WHERE in_out='1' AND DATE(added_date) ='$today_date' AND branch_id='$branch_id'"));

        echo $result6['money'];

    ?>

</td>

<td>

    <?php 

        $today_date = $row['date'];

        $result7 = mysqli_fetch_array(mysqli_query($conn, "SELECT sum(money) as money,added_date FROM money_in_out WHERE in_out='0' AND DATE(added_date) ='$today_date' AND branch_id='$branch_id'"));

        echo $result7['money'];

    ?>

</td>

<td>

    <?php 
	
echo $sum + $result['amount']+$result6['money']-$result5['amount']-$result7['money']; ?>

</td>

<td>

<?php echo $row['date']; ?>

</td>

</tr>

<?php 

} 

}

?>

</table>

</div>

</div>

</div>



</div>

</div>

</div>



<script>

		function printDiv(printableArea) {



			var printContents = document.getElementById(printableArea).innerHTML;

			var originalContents = document.body.innerHTML;



			document.body.innerHTML = printContents;



			window.print();



			document.body.innerHTML = originalContents;



		}

	</script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-rc.0/js/select2.min.js"></script>



	<script>

	// Initialize Select2 plugin with typing search functionality

	$('.select2').select2();

	</script>

	

	<script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>

							

	<script src="assets/js/jquery-3.6.0.min.js"></script>



	<script src="assets/js/feather.min.js"></script>



	<script src="assets/js/jquery.slimscroll.min.js"></script>



	<script src="assets/js/jquery.dataTables.min.js"></script>

	<script src="assets/js/buttons.dataTables.js"></script>

	<script src="assets/js/dataTables.bootstrap4.min.js"></script>



	<script src="assets/js/bootstrap.bundle.min.js"></script>



	<script src="assets/js/moment.min.js"></script>

	<script src="assets/js/bootstrap-datetimepicker.min.js"></script>

	<script src="assets/js/pdfmake.min.js"></script>

	<script src="assets/plugins/select2/js/select2.min.js"></script>

	<script src="assets/js/vfs_fonts.js"></script>



	<script src="assets/plugins/sweetalert/sweetalert2.all.min.js"></script>

	<script src="assets/plugins/sweetalert/sweetalerts.min.js"></script>

	<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>

	<script src="assets/js/dataTables.buttons.min.js"></script>

	<script src="assets/js/jszip.min.js"></script>

	<script src="assets/js/buttons.html5.min.js"></script>

	<script src="assets/js/script.js"></script>

	

	<link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css" rel="stylesheet">

    <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.js"></script>



	<script>

		



		$(document).ready( function() {

			$('#betable').DataTable({

        dom: 'Bfrtip', 

        buttons: [

            'copy', 

            'csv',  

            {

                extend: 'excelHtml5', 

                customize: function(xlsx) {

                    var sheet = xlsx.xl.worksheets['sheet1.xml']; 

                    $('row c[r^="C"]', sheet).attr('s', '2'); 

                }

            },

            'pdf',  

            'print' 

        ]

    });

	} );

	</script>

	

	<style>

	#betable_filter{

		margin-bottom: 20px;

	}

	</style>

	

</body>

</html>