    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&quot;../db/cn.php&quot;);
ob_start();

// Ensure session variables exist
if(isset($_SESSION[&#039;user_name&#039;]) &amp;&amp; isset($_SESSION[&#039;user_role&#039;]) &amp;&amp; isset($_SESSION[&#039;outlet_name&#039;]) &amp;&amp; isset($_SESSION[&#039;outlet_address&#039;])) {
    $userName = $_SESSION[&#039;user_name&#039;];
    $userRole = $_SESSION[&#039;user_role&#039;];
    $outlet_address = $_SESSION[&#039;outlet_address&#039;];
    $outlet_name = $_SESSION[&#039;outlet_name&#039;];
}

// Fetch filter values
$expHead = isset($_GET[&quot;exp_head&quot;]) ? trim($_GET[&quot;exp_head&quot;]) : &quot;&quot;;
$startDate = isset($_GET[&quot;start_date&quot;]) ? trim($_GET[&quot;start_date&quot;]) : &quot;&quot;;
$endDate = isset($_GET[&quot;end_date&quot;]) ? trim($_GET[&quot;end_date&quot;]) : &quot;&quot;;

// Construct SQL query with optional filters
$sql = &quot;SELECT * FROM incash WHERE 1=1&quot;; 

if (!empty($expHead)) {
    $sql .= &quot; AND name_detail = &#039;&quot; . mysqli_real_escape_string($connection, $expHead) . &quot;&#039;&quot;;
}

if (!empty($startDate)) {
    $sql .= &quot; AND date_time &gt;= &#039;&quot; . mysqli_real_escape_string($connection, $startDate) . &quot;&#039;&quot;;
}

if (!empty($endDate)) {
    $sql .= &quot; AND date_time &lt;= &#039;&quot; . mysqli_real_escape_string($connection, $endDate) . &quot;&#039;&quot;;
}

$hasFilter = !empty($expHead) || !empty($startDate) || !empty($endDate);


$sql .= &quot; ORDER BY date_time DESC&quot;;

if ($hasFilter) {
    $rec = mysqli_query($connection, $sql);
}

?&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; Expense Management&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;
		}
		
	/* Basic styling */
    .tab {
        display: none;
        padding: 20px;
    }
    .active {
        display: block;
    }
    .tab-buttons {
        display: flex;
    }
    .tab-button {
        cursor: pointer;
        padding: 10px 10px;
        background-color: #ffff;
        border: 1px solid #0A5064;
        border-radius: 5px 5px 0 0;
        margin-right: 5px;
		color:#212529;
    }
    .tab-button.active {
        background-color: #212529;
		color:#fff;
    }

    /* Background colors for tab content */
    #tab1 {
        background-color: #fff;
		color:#212529;
		padding:20px;
    }
    #tab2 {
        color:#212529;
		background-color: ;
    }
    #tab3 {
		color:#212529;
        background-color: ;
    }
    
    /* Custom styles for search bar */
    .search-container {
        display: flex;
        align-items: center;
       width:100%;
        margin: 2px auto;

        float:left;
	}

/* Updated hide class to apply to the overlay */
.sidebar.hide, .overlay.hide {
    transform: translateX(-100%);
}

    .search-input {
        width: 100%;
        padding: 10px 30px 10px 10px;
        /* Adjust padding to accommodate the icon */
        border: 1px solid #ccc;
        border-radius: 20px;
        font-size: 16px;
    }

    .search-icon {
        position: relative;
        left: -25px;
        /* Adjust the position of the icon */
        color: #aaa;
    }

    .search-icon i {
        position: absolute;
        top: 50%;
        transform: translateY(-50%);
    }
    label{
        font-weight:700;
        color:#000;
    }
  &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;nav class=&quot;navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow&quot;&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;?php include(&#039;common/log.php&#039;); 
                    $exp = mysqli_query($connection,&quot;select * from exp_head&quot;); 
                     ?&gt;
                &lt;/nav&gt;
&lt;br /&gt;

&lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-sm-12&quot;&gt;
                &lt;h3 style=&quot;color:#212529; font-weight:700;&quot;&gt;Expense By Ledger Report &lt;/h3&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;br&gt;
        &lt;form method=&quot;GET&quot; action=&quot;report_exp.php&quot;&gt;
                        &lt;div class=&quot;row&quot;&gt;
                            &lt;div class=&quot;col-3&quot;&gt;
                                &lt;div class=&quot;form-group&quot;&gt;
                                    &lt;label&gt;Select Expense Head&lt;/label&gt;
                                    &lt;select name=&quot;exp_head&quot; class=&quot;form-control&quot;&gt;
                                        &lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
                                        &lt;?php
                                        $exp = mysqli_query($connection,&quot;SELECT DISTINCT exp_head FROM exp_head&quot;);
                                        while($er = mysqli_fetch_array($exp)){
                                            echo &#039;&lt;option value=&quot;&#039;.$er[&quot;exp_head&quot;].&#039;&quot; &#039;.($expHead == $er[&quot;exp_head&quot;] ? &quot;selected&quot; : &quot;&quot;).&#039;&gt;&#039;.$er[&quot;exp_head&quot;].&#039;&lt;/option&gt;&#039;;
                                        }
                                        ?&gt;
                                    &lt;/select&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-3&quot;&gt;
                                &lt;div class=&quot;form-group&quot;&gt;
                                    &lt;label&gt;Start Date&lt;/label&gt;
                                    &lt;input type=&quot;date&quot; name=&quot;start_date&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $startDate; ?&gt;&quot;&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-3&quot;&gt;
                                &lt;div class=&quot;form-group&quot;&gt;
                                    &lt;label&gt;End Date&lt;/label&gt;
                                    &lt;input type=&quot;date&quot; name=&quot;end_date&quot; class=&quot;form-control&quot; value=&quot;&lt;?php echo $endDate; ?&gt;&quot;&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-3&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_exp.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;/div&gt;
                        &lt;/div&gt;
                    &lt;/form&gt;
    &lt;/div&gt;
  
&lt;?php if ($hasFilter): ?&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
           &lt;div class=&quot;col-sm-12&quot;&gt;
               &lt;table class=&quot;table table-striped table-hover text-center text-capitalize&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;Expense Head&lt;/th&gt;
                           &lt;th&gt;Paid By&lt;/th&gt;
                           &lt;th&gt;Amount (Rs)&lt;/th&gt;
                           &lt;th&gt;Recorded By&lt;/th&gt;
                       &lt;/tr&gt;
                   &lt;/thead&gt;
                   &lt;tbody&gt;
                       &lt;?php while($row = mysqli_fetch_array($rec)) { ?&gt;
                           &lt;tr&gt;
                               &lt;td&gt;&lt;?php echo $row[&quot;date_time&quot;]; ?&gt;&lt;/td&gt;
                               &lt;td&gt;&lt;?php echo $row[&quot;name_detail&quot;]; ?&gt;&lt;/td&gt;
                               &lt;td&gt;&lt;?php echo $row[&quot;paid_by&quot;]; ?&gt;&lt;/td&gt;
                               &lt;td&gt;&lt;?php echo number_format($row[&quot;amount&quot;], 2); ?&gt;&lt;/td&gt;
                               &lt;td&gt;&lt;?php echo $row[&quot;login_user&quot;]; ?&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;?php else: ?&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-sm-12 text-center&quot;&gt;
                &lt;h5 class=&quot;text-white text-bold&quot; style=&quot;background:#95ADB4;padding:20px; &quot;&gt;Please apply filters to generate the report.&lt;/h5&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;?php endif; ?&gt;


            &lt;/div&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;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&gt;
    $(document).ready(function(){
        $(&quot;#searchInput&quot;).on(&quot;keyup&quot;, function() {
            var value = $(this).val().toLowerCase();
            $(&quot;table tr&quot;).filter(function() {
                // Exclude header row from filtering
                if (!$(this).hasClass(&#039;header-row&#039;)) {
                    $(this).toggle($(this).text().toLowerCase().indexOf(value) &gt; -1);
                }
            });
        });
    });
    &lt;/script&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;/body&gt;

&lt;/html&gt;</code></pre>        </div>
    </div>