    <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();
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;];
}

// Initialize filter variables
$start_date = &quot;&quot;;
$end_date = &quot;&quot;;
$order = &quot;ASC&quot;; // Default sorting order
$whereClause = &quot;&quot;;

// Handle date filters
if ($_SERVER[&#039;REQUEST_METHOD&#039;] === &#039;POST&#039;) {
    $start_date = $_POST[&#039;start_date&#039;] ?? &quot;&quot;;
    $end_date = $_POST[&#039;end_date&#039;] ?? &quot;&quot;;

    // Validate dates
    if (!empty($start_date) &amp;&amp; !empty($end_date)) {
        $whereClause = &quot;WHERE date_time BETWEEN &#039;$start_date&#039; AND &#039;$end_date&#039;&quot;;
    }
}

// Handle sorting
if (isset($_GET[&#039;order&#039;]) &amp;&amp; in_array($_GET[&#039;order&#039;], [&#039;ASC&#039;, &#039;DESC&#039;])) {
    $order = $_GET[&#039;order&#039;];
}

$query = &quot;SELECT * FROM incash $whereClause ORDER BY date_time $order&quot;;
$rec = mysqli_query($connection, $query);

ob_end_flush();
?&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;TAHIR ABBAS SPARY CENTER&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;script src=&quot;https://cdn.jsdelivr.net/npm/chart.js&quot;&gt;&lt;/script&gt;
&lt;/head&gt;
&lt;style&gt;
 #table-container-wrapper {
    max-height: 660px; /* Adjust the maximum height as needed */
    overflow-y: auto; /* Enable vertical scroll when content overflows */
}
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;
		}
		
.select{
    font-weight:500;
    color:#000;
	  	
		}
		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;!-- 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;div class=&quot;container-fluid mt-5&quot;&gt;
    &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-9&quot;&gt;
               &lt;h2 style=&quot;color:#060606; font-weight:700;&quot;&gt;Expense Report&lt;/h2&gt;  
        &lt;/div&gt;
       
        &lt;div class=&quot;col-sm-3&quot;&gt;&lt;/div&gt;
    &lt;/div&gt;
    &lt;br&gt;
   
  
    &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-12&quot;&gt;
            
              &lt;form method=&quot;POST&quot; action=&quot;&quot;&gt;
                        &lt;div class=&quot;row&quot;&gt;
                            &lt;div class=&quot;form-group col-3&quot;&gt;
                                &lt;label for=&quot;start_date&quot;&gt;Start Date:&lt;/label&gt;
                                &lt;input type=&quot;date&quot; id=&quot;start_date&quot; name=&quot;start_date&quot; class=&quot;form-control select&quot; value=&quot;&lt;?php echo $start_date; ?&gt;&quot;&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;form-group col-3&quot;&gt;
                                &lt;label for=&quot;end_date&quot;&gt;End Date:&lt;/label&gt;
                                &lt;input type=&quot;date&quot; id=&quot;end_date&quot; name=&quot;end_date&quot; class=&quot;form-control select&quot; value=&quot;&lt;?php echo $end_date; ?&gt;&quot;&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;form-group col-4&quot; style=&quot;margin-top:30px;&quot;&gt;
                                &lt;button type=&quot;submit&quot; class=&quot;btn btn-dark&quot;&gt;Filter&lt;/button&gt;
                                  &lt;button type=&quot;button&quot; class=&quot;btn btn-dark&quot; id=&quot;downloadExcel&quot;&gt;Download&lt;/button&gt;
                                &lt;a href=&quot;report_exp.php&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-dark&quot;&gt;&lt;i class=&quot;fas fa-sync-alt fa-1x&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/a&gt;
                           
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/form&gt;
            
        &lt;/div&gt;
    &lt;/div&gt;
 
&lt;/div&gt;
&lt;div class=&quot;container-fluid&quot; id=&quot;table-container-wrapper&quot;&gt;
&lt;table id=&quot;patientTable&quot; class=&quot;table table-bordered table-hover text-center bg-white text-capitalize &quot;&gt;
                        &lt;tr class=&quot;bg-dark text-white&quot; style=&quot;font-weight:700;&quot;&gt;
                            &lt;td&gt;Sr#&lt;/td&gt;
                            &lt;td&gt;
                                &lt;a href=&quot;?order=&lt;?php echo $order === &#039;ASC&#039; ? &#039;DESC&#039; : &#039;ASC&#039;; ?&gt;&quot; style=&quot;color: #fff; text-decoration: none;&quot;&gt;
                                    Date &lt;i class=&quot;fas fa-sort-&lt;?php echo $order === &#039;ASC&#039; ? &#039;up&#039; : &#039;down&#039;; ?&gt;&quot;&gt;&lt;/i&gt;
                                &lt;/a&gt;
                            &lt;/td&gt;
                            &lt;td style=&quot;background:#0A4657; color:#fff;&quot;&gt;Expence&lt;/td&gt;
                            &lt;td&gt;Detail&lt;/td&gt;
                            &lt;td&gt;Amount (Rs)&lt;/td&gt;
                            &lt;td&gt;Method&lt;/td&gt;
                            &lt;td&gt;By.&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;?php
                        $sr_no = 1;
                        while ($row = mysqli_fetch_array($rec)) {
                        ?&gt;
                            &lt;tr style=&quot;color:#000;&quot;&gt;
                                &lt;td&gt;&lt;?php echo $sr_no++; ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo $row[&quot;date_time&quot;]; ?&gt;&lt;/td&gt;
                                &lt;td style=&quot;font-weight:700;color:#0A4657;&quot;&gt;&lt;?php echo $row[&quot;name_detail&quot;]; ?&gt;&lt;/td&gt;
                                &lt;td&gt;&lt;?php echo $row[&quot;desc_name&quot;]; ?&gt;&lt;/td&gt;
                                &lt;td style=&quot;font-weight:700;color:#666;&quot;&gt;&lt;?php echo $row[&quot;amount&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 $row[&quot;login_user&quot;]; ?&gt;&lt;/td&gt;
                            &lt;/tr&gt;
                        &lt;?php } ?&gt;
                    &lt;/table&gt;

&lt;/div&gt;



    
            
                &lt;!-- /.container-fluid --&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://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js&quot;&gt;&lt;/script&gt;

&lt;!-- JavaScript for exporting the table data to Excel --&gt;
&lt;script&gt;
    document.getElementById(&#039;downloadExcel&#039;).addEventListener(&#039;click&#039;, function() {
        // Get the table element
        var table = document.getElementById(&#039;patientTable&#039;);

        // Clean the table to avoid potential issues with hidden rows or formatting
        var clone = table.cloneNode(true); // Clone the table
        var rows = clone.querySelectorAll(&#039;tr&#039;);

        // Remove hidden or empty rows if necessary
        rows.forEach(function(row) {
            if (row.style.display === &#039;none&#039; || row.innerText.trim() === &#039;&#039;) {
                row.remove();
            }
        });

        // Convert the table into a worksheet using SheetJS
        var workbook = XLSX.utils.table_to_book(clone, { sheet: &quot;Patients&quot; });

        // Export the Excel file with a proper name
        try {
            XLSX.writeFile(workbook, &#039;ExpenseReport_data.xlsx&#039;);
        } catch (error) {
            console.error(&quot;Error while writing the file: &quot;, error);
            alert(&quot;Error generating Excel file. Please check if the SheetJS library is properly loaded.&quot;);
        }
    });
&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>