    <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;];
}

if ($_GET) {
    if (isset($_GET[&quot;cr_name&quot;])) {
        $id = $_GET[&quot;cr_name&quot;];

        // Use prepared statements to prevent SQL injection
        $stmt = $connection-&gt;prepare(&quot;DELETE FROM credit_note WHERE cr_name = ? AND user_name = ? AND user_role = ? AND outlet_name = ? AND outlet_address = ?&quot;);
        $stmt-&gt;bind_param(&quot;sssss&quot;, $id, $userName, $userRole, $outlet_name, $outlet_address);

        if ($stmt-&gt;execute()) {
            echo &#039;&lt;script type=&quot;text/javascript&quot;&gt;window.location.href=&quot;view_creditor.php&quot;;&lt;/script&gt;&#039;;
           // header(&quot;Location: credits.php&quot;);
            exit();
        } else {
            echo &quot;Error: &quot; . $stmt-&gt;error;
        }
        
        $stmt-&gt;close();
    }
}

if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot; &amp;&amp; isset($_POST[&quot;creditor&quot;])) {
    $date_time32 = date(&quot;Y-m-d&quot;);
    $cr_name = $_POST[&quot;cr_name&quot;];
    $cr_nickname = $_POST[&quot;cr_nickname&quot;];
    $cr_address = $_POST[&quot;cr_address&quot;];
    $phone_number = $_POST[&quot;phone_number&quot;];
    $cr_id = $_POST[&quot;cr_id&quot;];

    // Use prepared statements to prevent SQL injection
    $stmt = $connection-&gt;prepare(&quot;INSERT INTO credit_note (cr_name, cr_nickname, cr_address, phone_number, cr_id, user_name, user_role, outlet_name, outlet_address, date_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;);
    $stmt-&gt;bind_param(&quot;ssssssssss&quot;, $cr_name, $cr_nickname, $cr_address, $phone_number, $cr_id, $userName, $userRole, $outlet_name, $outlet_address, $date_time32);

    if ($stmt-&gt;execute()) {
         echo &#039;&lt;script type=&quot;text/javascript&quot;&gt;window.location.href=&quot;credits.php&quot;;&lt;/script&gt;&#039;;
    } else {
        echo &quot;Error: &quot; . $stmt-&gt;error;
    }

    $stmt-&gt;close();
}
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;Customer Ledger&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;
		}
		
 /* 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%);
    }
    tr{
       font-weight:700; 
    }
    #table-container{
        max-height:700px;
        overflow-y:auto;
    }
  &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;?php
     $remain = mysqli_query($connection,&quot;select SUM(remain_balance) AS total_remain FROM creditor_closing &quot;);
	$fetch_remain = mysqli_fetch_array($remain);
	$remain_sum = $fetch_remain[&quot;total_remain&quot;];
	
	?&gt;    
&lt;div class=&quot;container&quot;&gt;
            &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-sm-9&quot;&gt;
                    &lt;h3 style=&quot;color:#212529; font-weight:700;&quot;&gt;
                        Customer Ledger&lt;/h3&gt;
                   
                        &lt;div class=&quot;search-container&quot;&gt;
                        &lt;input type=&quot;text&quot; id=&quot;searchInput&quot; class=&quot;form-control&quot; placeholder=&quot;Search...&quot; style=&quot;width:305px;&quot;&gt;
                            
                            &lt;div class=&quot;search-icon&quot;&gt;
                                &lt;i class=&quot;fas fa-search&quot;&gt;&lt;/i&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        
                &lt;/div&gt;
                &lt;div class=&quot;col-sm-3&quot; style=&quot;background:#0A4657;color:#fff; padding:10px; border-radius:7px;&quot;&gt;
 &lt;center&gt;&lt;p style=&quot;font-weight:600px; font-size:18px;&quot;&gt;Total Receivable &lt;br&gt;Rs &lt;?php  echo number_format(round(@$remain_sum, 2), 2);  ?&gt;&lt;/p&gt;&lt;/center&gt;
                &lt;/div&gt;
            &lt;/div&gt;
   
        &lt;/div&gt;
   
        &lt;div class=&quot;container-fluid&quot;&gt;
            &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-sm-1&quot;&gt;&lt;/div&gt;
                &lt;div class=&quot;col-sm-10&quot; style=&quot;&quot; id=&quot;table-container&quot;&gt;
                    &lt;div class=&quot;row text-center&quot;&gt;
                        
                        
                        &lt;table class=&quot;table table-hover table-stripped table-sm bg-white&quot;&gt;
                            &lt;thead&gt;
                        &lt;tr class=&quot;bg-dark text-white text-center&quot;&gt;
                        &lt;td&gt;Sr&lt;/td&gt;
                        &lt;td&gt;ID&lt;/td&gt;
                        &lt;td&gt;Name&lt;/td&gt;
                        &lt;td&gt;Cell&lt;/td&gt;
                        &lt;td&gt;Closing Balance(Rs)&lt;/td&gt;
                        &lt;td&gt;Detail&lt;/td&gt;
                        &lt;td&gt;Edit&lt;/td&gt;
                        &lt;td&gt;Delete&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;/thead&gt;
                        &lt;tbody id=&quot;supplierTableBody&quot;&gt;
&lt;?php 
ob_start();

// Join the credit_note table with the creditor_closing table and retrieve necessary fields
$rec = mysqli_query($connection, 
    &quot;SELECT credit_note.cr_id, credit_note.cr_name, credit_note.phone_number, creditor_closing.remain_balance, creditor_closing.creditor_name 
     FROM credit_note
     LEFT JOIN creditor_closing ON credit_note.cr_name = creditor_closing.creditor_name
     GROUP BY credit_note.cr_name&quot;
);

if (!$rec) {
    die(&quot;Error: &quot; . mysqli_error($connection));
}
$sr_no = 1;
while($row = mysqli_fetch_array($rec)) {
    $customerName = $row[&quot;cr_name&quot;];
?&gt;
    &lt;tr style=&quot; color:#000;&quot;&gt;
    &lt;td&gt;&lt;?php echo $sr_no++; ?&gt;&lt;/td&gt;
        &lt;td style=&quot;font-weight:700; color:#300;&quot;&gt;&lt;?php echo $row[&quot;cr_id&quot;]; ?&gt;&lt;/td&gt;
        &lt;td class=&quot;text-capitalize&quot; style=&quot;font-weight:600;&quot;&gt;&lt;?php echo $customerName; ?&gt;&lt;/td&gt;
        &lt;td&gt;&lt;?php echo $row[&quot;phone_number&quot;]; ?&gt;&lt;/td&gt;
        &lt;td style=&quot;font-weight:500;&quot;&gt;&lt;?php echo number_format(round((int)$row[&quot;remain_balance&quot;], 2), 2); ?&gt;&lt;/td&gt;
        &lt;td&gt;&lt;a href=&quot;creditor_detail.php?customer_name=&lt;?php echo $customerName; ?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-dark btn-sm&quot;&gt;&lt;i class=&quot;fas fa-clipboard fa-1x&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt;&lt;a href=&quot;credits_edit.php?cr_name=&lt;?php echo $customerName; ?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-dark btn-sm&quot;&gt;
        Edit&lt;/button&gt;&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt;&lt;a href=&quot;view_creditor.php?cr_name=&lt;?php echo $customerName; ?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-danger btn-sm&quot;&gt;x&lt;/button&gt;&lt;/a&gt;&lt;/td&gt;
    &lt;/tr&gt;
&lt;?php 
} 
ob_end_flush();
?&gt;
&lt;/tbody&gt;
  &lt;/table&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-sm-1&quot;&gt;&lt;/div&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&gt;
    document.addEventListener(&quot;DOMContentLoaded&quot;, function() {
    var searchInput = document.getElementById(&#039;searchInput&#039;);
    var rows = document.querySelectorAll(&quot;#supplierTableBody tr&quot;);

    searchInput.addEventListener(&quot;keyup&quot;, function(event) {
        var term = event.target.value.toLowerCase();
        rows.forEach(function(row) {
            var cells = row.getElementsByTagName(&quot;td&quot;);
            var found = false;
            Array.from(cells).forEach(function(cell) {
                if (cell.textContent.toLowerCase().indexOf(term) &gt; -1) {
                    found = true;
                }
            });
            if (found) {
                row.style.display = &quot;&quot;;
            } else {
                row.style.display = &quot;none&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>