    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&quot;db/cn.php&quot;);
ini_set(&#039;display_errors&#039;, 1);
ini_set(&#039;display_startup_errors&#039;, 1);
error_reporting(E_ALL);

// Get filters from the request
$customer_name = isset($_GET[&#039;customer_name&#039;]) ? trim($_GET[&#039;customer_name&#039;]) : &#039;&#039;;
$route = isset($_GET[&#039;route&#039;]) ? trim($_GET[&#039;route&#039;]) : &#039;&#039;;
$booker = isset($_GET[&#039;booker&#039;]) ? trim($_GET[&#039;booker&#039;]) : &#039;&#039;;
$date = isset($_GET[&#039;date&#039;]) ? trim($_GET[&#039;date&#039;]) : &#039;&#039;;

$filters_applied = !empty($customer_name) || !empty($route) || !empty($booker) || !empty($date);
$customer_data = [];

if ($filters_applied) {
    // Query to get opening amount
   $sql_opening = &quot;SELECT creditor_name, route, booker, DATE(date_time) AS date_time, SUM(open_amount) AS opening_amount 
                FROM creditor_opening_amount 
                WHERE 1=1&quot;;

    if (!empty($customer_name)) $sql_opening .= &quot; AND creditor_name = &#039;&quot; . mysqli_real_escape_string($connection, $customer_name) . &quot;&#039;&quot;;
    if (!empty($route)) $sql_opening .= &quot; AND route = &#039;&quot; . mysqli_real_escape_string($connection, $route) . &quot;&#039;&quot;;
    if (!empty($booker)) $sql_opening .= &quot; AND booker = &#039;&quot; . mysqli_real_escape_string($connection, $booker) . &quot;&#039;&quot;;
    if (!empty($date)) $sql_opening .= &quot; AND DATE(date_time) = &#039;&quot; . mysqli_real_escape_string($connection, $date) . &quot;&#039;&quot;;
    $sql_opening .= &quot; GROUP BY creditor_name, route, booker&quot;;

 
    
    $result_opening = mysqli_query($connection, $sql_opening);
    while ($row = mysqli_fetch_assoc($result_opening)) {
       $customer_data[$row[&#039;creditor_name&#039;]] = [
    &#039;date_time&#039; =&gt; $row[&#039;date_time&#039;],
    &#039;route&#039; =&gt; $row[&#039;route&#039;],
    &#039;booker&#039; =&gt; $row[&#039;booker&#039;],
    &#039;opening_amount&#039; =&gt; $row[&#039;opening_amount&#039;],
    &#039;paid_amount&#039; =&gt; 0,
    &#039;discount_amount&#039; =&gt; 0,
    &#039;closing_balance&#039; =&gt; 0
];
    }

    // Query to get paid amount
    $sql_paid = &quot;SELECT cr_name, SUM(amount) AS paid_amount FROM credit_paid WHERE 1=1&quot;;
    if (!empty($customer_name)) $sql_paid .= &quot; AND cr_name = &#039;&quot; . mysqli_real_escape_string($connection, $customer_name) . &quot;&#039;&quot;;
    if (!empty($route)) $sql_paid .= &quot; AND route = &#039;&quot; . mysqli_real_escape_string($connection, $route) . &quot;&#039;&quot;;
    if (!empty($booker)) $sql_paid .= &quot; AND booker = &#039;&quot; . mysqli_real_escape_string($connection, $booker) . &quot;&#039;&quot;;
    if (!empty($date)) $sql_paid .= &quot; AND DATE(date_time) = &#039;&quot; . mysqli_real_escape_string($connection, $date) . &quot;&#039;&quot;;
    $sql_paid .= &quot; GROUP BY cr_name&quot;;

    $result_paid = mysqli_query($connection, $sql_paid);
    while ($row = mysqli_fetch_assoc($result_paid)) {
        if (isset($customer_data[$row[&#039;cr_name&#039;]])) {
            $customer_data[$row[&#039;cr_name&#039;]][&#039;paid_amount&#039;] = $row[&#039;paid_amount&#039;];
        }
    }

    // Query to get discount amount
    $sql_sales = &quot;SELECT customer_name, SUM(discount_amount) AS discount_amount FROM log_user_sales WHERE 1=1&quot;;
    if (!empty($customer_name)) $sql_sales .= &quot; AND customer_name = &#039;&quot; . mysqli_real_escape_string($connection, $customer_name) . &quot;&#039;&quot;;
    if (!empty($route)) $sql_sales .= &quot; AND customer_id = &#039;&quot; . mysqli_real_escape_string($connection, $route) . &quot;&#039;&quot;;
    if (!empty($booker)) $sql_sales .= &quot; AND customer_type = &#039;&quot; . mysqli_real_escape_string($connection, $booker) . &quot;&#039;&quot;;
    if (!empty($date)) $sql_sales .= &quot; AND DATE(date_time) = &#039;&quot; . mysqli_real_escape_string($connection, $date) . &quot;&#039;&quot;;
    $sql_sales .= &quot; GROUP BY customer_name&quot;;

    $result_sales = mysqli_query($connection, $sql_sales);
    while ($row = mysqli_fetch_assoc($result_sales)) {
        if (isset($customer_data[$row[&#039;customer_name&#039;]])) {
            $customer_data[$row[&#039;customer_name&#039;]][&#039;discount_amount&#039;] = $row[&#039;discount_amount&#039;];
        }
    }

    // Calculate closing balance
    foreach ($customer_data as $name =&gt; $data) {
        $customer_data[$name][&#039;closing_balance&#039;] = 
            $data[&#039;opening_amount&#039;] + $data[&#039;discount_amount&#039;] - $data[&#039;paid_amount&#039;] ;
    }
}
?&gt;


&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;

&lt;head&gt;

    &lt;meta charset=&quot;utf-8&quot;&gt;
    &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=edge&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1, shrink-to-fit=no&quot;&gt;
    &lt;meta name=&quot;description&quot; content=&quot;&quot;&gt;
    &lt;meta name=&quot;author&quot; content=&quot;&quot;&gt;

    &lt;title&gt;Whole Sale Retail&lt;/title&gt;

    &lt;!-- Custom fonts for this template--&gt;
    &lt;link href=&quot;../vendor/fontawesome-free/css/all.min.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;
   &lt;link href=&quot;https://fonts.googleapis.com/css2?family=Quicksand:wght@200;300;400;500;600;700&amp;display=swap&quot; rel=&quot;stylesheet&quot;&gt;

    &lt;!-- Custom styles for this template--&gt;
    &lt;link href=&quot;../css/sb-admin-2.min.css&quot; rel=&quot;stylesheet&quot;&gt;
        &lt;link href=&quot;../css/sb-admin-2.css&quot; rel=&quot;stylesheet&quot;&gt;
    
&lt;script src=&quot;https://cdn.jsdelivr.net/npm/chart.js&quot;&gt;&lt;/script&gt;
&lt;/head&gt;
&lt;style&gt;


body {
    font-family: &#039;Quicksand&#039;, sans-serif;
    
}
		    .chart-container {
      position: relative;
      background: rgba(255, 255, 255, 0.9);
      border-radius: 10px;
      padding: 15px;
      box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);
    }

    canvas {
      max-width: 100%;
      height: auto;
    }
.bg-gradient-primary{
    
	background:#0A4657;
	color:#fff;	
	
	}

.btn-primary{
	background:#0A4657;
	color:#fff;
	 border:1px #0A4657 solid;
	
	}  
.btn-primary:hover{
  
  background:#fff;
  border:1px #0A4657 solid;
	color:#0A4657;
	
	}	 
    .chart-container {
      position: relative;
      background: rgba(255, 255, 255, 0.9);
      border-radius: 10px;
      padding: 15px;
      box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);
    }

    canvas {
      max-width: 100%;
      height: auto;
    }
	
	.fa-download:hover{
		color:#953E39;
		}
		
.text-primary{
	  	
		}
  &lt;/style&gt;

&lt;body id=&quot;page-top&quot;&gt;

    &lt;!-- Page Wrapper --&gt;
    &lt;div id=&quot;wrapper&quot;&gt;

        &lt;!-- Sidebar --&gt;
        &lt;?php
        include(&quot;common/sd.php&quot;);
		?&gt;
        &lt;!-- End of Sidebar --&gt;

        &lt;!-- Content Wrapper --&gt;
        &lt;div id=&quot;content-wrapper&quot; class=&quot;d-flex flex-column&quot;&gt;

            &lt;!-- Main Content --&gt;
            &lt;div id=&quot;content&quot;&gt;

                &lt;!-- Topbar --&gt;
                &lt;nav class=&quot;navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow&quot;&gt;

                    &lt;!-- Sidebar Toggle (Topbar) --&gt;
                    &lt;button id=&quot;sidebarToggleTop&quot; class=&quot;btn btn-link d-md-none rounded-circle mr-3&quot;&gt;
                        &lt;i class=&quot;fa fa-bars&quot;&gt;&lt;/i&gt;
                    &lt;/button&gt;

                    &lt;!-- Topbar Search --&gt;
                    
  &lt;?php include(&#039;common/log.php&#039;);  ?&gt;

                    &lt;!-- Topbar Navbar --&gt;
                    
                &lt;/nav&gt;
                &lt;!-- End of Topbar --&gt;

                &lt;!-- Begin Page Content --&gt;
 
&lt;div class=&quot;container&quot;&gt;
    &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-5&quot;&gt;
            &lt;h3 style=&quot;font-weight:700;color:#000;&quot;&gt;Customer Closing Report&lt;/h3&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-7&quot;&gt;&lt;/div&gt;
    &lt;/div&gt;
    &lt;br&gt;
    &lt;?php
    $c = mysqli_query($connection,&quot;select * from credit_note GROUP BY cr_name&quot;);
    $r = mysqli_query($connection,&quot;select * from credit_note GROUP BY route&quot;);
    $b = mysqli_query($connection,&quot;select * from credit_note GROUP BY booker&quot;);
    ?&gt;
&lt;form action=&quot;report_cus.php&quot; method=&quot;GET&quot;&gt;
    &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label&gt;Select Customer&lt;/label&gt;
                &lt;select class=&quot;form-control&quot; name=&quot;customer_name&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
                    &lt;?php
                    while($cr = mysqli_fetch_array($c)){ 
                    ?&gt;
                    &lt;option value=&quot;&lt;?php echo $cr[&quot;cr_name&quot;]; ?&gt;&quot;&gt;&lt;?php echo $cr[&quot;cr_name&quot;]; ?&gt;&lt;/option&gt;
                    &lt;?php
                    }
                    ?&gt;
                &lt;/select&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label&gt;Select Route&lt;/label&gt;
                &lt;select class=&quot;form-control&quot; name=&quot;route&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;Select&lt;/option&gt; 
                    &lt;?php
                    while($rr = mysqli_fetch_array($r)){ 
                    ?&gt;
                    &lt;option value=&quot;&lt;?php echo $rr[&quot;route&quot;]; ?&gt;&quot;&gt;&lt;?php echo $rr[&quot;route&quot;]; ?&gt;&lt;/option&gt;
                    &lt;?php
                    }
                    ?&gt;
                &lt;/select&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label&gt;Select Booker&lt;/label&gt;
                &lt;select class=&quot;form-control&quot; name=&quot;booker&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
                    &lt;?php
                    while($br = mysqli_fetch_array($b)){ 
                    ?&gt;
                    &lt;option value=&quot;&lt;?php echo $br[&quot;booker&quot;]; ?&gt;&quot;&gt;&lt;?php echo $br[&quot;booker&quot;]; ?&gt;&lt;/option&gt;
                    &lt;?php
                    }
                    ?&gt;
                &lt;/select&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-4&quot;&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label&gt;Date&lt;/label&gt;
                &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;date&quot;&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-4&quot;&gt;
            &lt;button type=&quot;submit&quot; class=&quot;btn btn-dark&quot; style=&quot;margin-top:30px;&quot;&gt;Filter&lt;/button&gt;
            &lt;a href=&quot;report_cus.php&quot; class=&quot;btn btn-dark&quot; style=&quot;margin-top:30px;&quot;&gt;&lt;i class=&quot;fas fa-sync fa-1x&quot;&gt;&lt;/i&gt;&lt;/a&gt;
            &lt;button type=&quot;button&quot; class=&quot;btn btn-dark&quot; style=&quot;margin-top:30px;&quot;&gt;Download&lt;/button&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/form&gt;
    &lt;div class=&quot;row&quot;&gt;
   &lt;table class=&quot;table table-striped table-hover text-center&quot;&gt;
        &lt;thead class=&quot;bg-dark text-white&quot;&gt;
            &lt;tr&gt;
                &lt;th&gt;Date&lt;/th&gt;
                &lt;th&gt;Customer&lt;/th&gt;
                &lt;th&gt;Route&lt;/th&gt;
                &lt;th&gt;Booker&lt;/th&gt;
                &lt;th&gt;Closing Balance&lt;/th&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
            &lt;?php foreach ($customer_data as $name =&gt; $data) { ?&gt;
                &lt;tr&gt;
                    &lt;td&gt;&lt;?php echo $data[&#039;date_time&#039;]; ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo $name; ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo $data[&#039;route&#039;]; ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?php echo $data[&#039;booker&#039;]; ?&gt;&lt;/td&gt;
                 
                    &lt;td&gt;&lt;strong&gt;&lt;?php echo number_format($data[&#039;closing_balance&#039;], 2); ?&gt;&lt;/strong&gt;&lt;/td&gt;
                &lt;/tr&gt;
            &lt;?php } ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;/div&gt;

            &lt;/div&gt;
            &lt;br&gt;&lt;br&gt;
            &lt;!-- End of Main Content --&gt;

            &lt;!-- Footer --&gt;
            &lt;?php include(&quot;common/main_ft.php&quot;);  ?&gt;
            &lt;!-- End of Footer --&gt;

        &lt;/div&gt;
        &lt;!-- End of Content Wrapper --&gt;

    &lt;/div&gt;
    &lt;!-- End of Page Wrapper --&gt;

    &lt;!-- Scroll to Top Button--&gt;
    &lt;a class=&quot;scroll-to-top rounded&quot; href=&quot;#page-top&quot;&gt;
        &lt;i class=&quot;fas fa-angle-up&quot;&gt;&lt;/i&gt;
    &lt;/a&gt;

    &lt;!-- Logout Modal--&gt;
    &lt;div class=&quot;modal fade&quot; id=&quot;logoutModal&quot; tabindex=&quot;-1&quot; role=&quot;dialog&quot; aria-labelledby=&quot;exampleModalLabel&quot;
        aria-hidden=&quot;true&quot;&gt;
        &lt;div class=&quot;modal-dialog&quot; role=&quot;document&quot;&gt;
            &lt;div class=&quot;modal-content&quot;&gt;
                &lt;div class=&quot;modal-header&quot;&gt;
                    &lt;h5 class=&quot;modal-title&quot; id=&quot;exampleModalLabel&quot;&gt;Ready to Leave?&lt;/h5&gt;
                    &lt;button class=&quot;close&quot; type=&quot;button&quot; data-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;
                        &lt;span aria-hidden=&quot;true&quot;&gt;×&lt;/span&gt;
                    &lt;/button&gt;
                &lt;/div&gt;
                &lt;div class=&quot;modal-body&quot;&gt;Select &quot;Logout&quot; below if you are ready to end your current session.&lt;/div&gt;
                &lt;div class=&quot;modal-footer&quot;&gt;
                    &lt;button class=&quot;btn btn-secondary&quot; type=&quot;button&quot; data-dismiss=&quot;modal&quot;&gt;Cancel&lt;/button&gt;
                    &lt;a class=&quot;btn btn-primary&quot; href=&quot;&quot;&gt;Logout&lt;/a&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;


   &lt;script src=&quot;https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Bootstrap core JavaScript--&gt;
    &lt;script src=&quot;../vendor/jquery/jquery.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;../vendor/bootstrap/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;

    &lt;!-- Core plugin JavaScript--&gt;
    &lt;script src=&quot;../vendor/jquery-easing/jquery.easing.min.js&quot;&gt;&lt;/script&gt;

    &lt;!-- Custom scripts for all pages--&gt;
    &lt;script src=&quot;../js/sb-admin-2.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
$(document).ready(function(){
    $(&quot;#filterButton&quot;).click(function(){
        var customer_name = $(&quot;select[name=&#039;customer_name&#039;]&quot;).val();
        var route = $(&quot;select[name=&#039;route&#039;]&quot;).val();
        var booker = $(&quot;select[name=&#039;booker&#039;]&quot;).val();
        var date = $(&quot;input[name=&#039;date&#039;]&quot;).val();
        
        $.ajax({
            url: &quot;report_cus.php&quot;,
            type: &quot;GET&quot;,
            data: {customer_name: customer_name, route: route, booker: booker, date: date},
            success: function(data) {
                $(&quot;#reportTable&quot;).html($(data).find(&quot;#reportTable&quot;).html());
            }
        });
    });
});
&lt;/script&gt;

&lt;/body&gt;

&lt;/html&gt;</code></pre>        </div>
    </div>