    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php
include(&quot;db/cn.php&quot;);

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;];
}
// Handle purchase addition
if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot; &amp;&amp; isset($_POST[&quot;submit2&quot;])) {
    $product_id = $_POST[&quot;product_id&quot;]; // Use the product ID retrieved from the previous page
    $name1 = $_POST[&quot;name1&quot;];
    $price1 = $_POST[&quot;price1&quot;];
    $category1 = $_POST[&quot;category1&quot;];
    $stock_qty1 = $_POST[&quot;stock_qty1&quot;];
    $unit_pr1 = $_POST[&quot;unit_pr1&quot;];

    // Insert purchase information into the database
    $purchaseSql = &quot;INSERT INTO purchases (name, product_id, price, category, stock_qty, unit_pr, user_name, user_role, outlet_name, outlet_address, date_time)
	VALUES (&#039;$name1&#039;, &#039;$product_id&#039;, $price1, &#039;$category1&#039;, $stock_qty1, &#039;$unit_pr1&#039;,&#039;$userName&#039;,&#039;$userRole&#039;,&#039;$outlet_name&#039;,&#039;$outlet_address&#039;, NOW())&quot;;
    if ($connection-&gt;query($purchaseSql) === TRUE) {
        // Purchase added successfully
        // Update the stock_qty in the products table
        $updateSql = &quot;UPDATE products SET stock_qty = stock_qty + $stock_qty1 WHERE id = &#039;$product_id&#039;&quot;;
        if ($connection-&gt;query($updateSql) === TRUE) {
            // Stock quantity updated successfully
            header(&quot;location:addproduct.php&quot;);
        } else {
            echo &quot;Error updating stock quantity: &quot; . $updateSql . &quot;&lt;br&gt;&quot; . $connection-&gt;error;
        }
    } else {
        echo &quot;Error adding purchase: &quot; . $purchaseSql . &quot;&lt;br&gt;&quot; . $connection-&gt;error;
    }
}
if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;POST&quot; &amp;&amp; isset($_POST[&quot;submit3&quot;])) {
	$product_id1 = $_POST[&quot;product_id&quot;];
	
	$price12 = $_POST[&quot;price1&quot;];
	
	$updateSql2 = &quot;UPDATE products SET price = $price12 WHERE id = &#039;$product_id1&#039;&quot;;

	 if ($connection-&gt;query($updateSql2) === TRUE) {
            // Stock quantity updated successfully
            header(&quot;location:addproduct.php&quot;);
        } else {
            echo &quot;Error updating Price: &quot; . $updateSql2 . &quot;&lt;br&gt;&quot; . $connection-&gt;error;
        }
	
	
	
	}


?&gt;

&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;head&gt;
    &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
     &lt;meta http-equiv=&quot;refresh&quot; content=&quot;25&quot;&gt;
    &lt;title&gt;Stock and Manage&lt;/title&gt;
    &lt;!-- Latest compiled and minified CSS --&gt;
&lt;link href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot;&gt;
&lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css&quot;&gt;
&lt;link rel=&quot;stylesheet&quot; href=&quot;css/custom_css.css&quot; /&gt;
    &lt;!-- QRCode.js --&gt;
&lt;/head&gt;

&lt;style&gt;
/* Custom styles for sidebar */
    .sidebar {
    width: 100px;
    background-color: #8A1218;
    position: fixed;
    bottom: 0;
	top:60px;
    transition: transform 0.3s ease-in-out;
    transform: translateX(0);
    z-index: 1;
    height: 100%;
    border-radius: 0px;
}
    .sidebar.hide {
      transform: translateX(-100px); /* Move sidebar out of the viewport when it is hidden */
    }
      .sidebar .nav-item {
    padding: 10px 0 ;
    text-align: center;
    position: relative;
	font-size:12px;
}
    .sidebar .nav-link {
      color: #fff;
      position: relative; /* Ensure icon and text are positioned relative to the nav link */
      z-index: 2; /* Ensure the text and icon are above the hover background */
    }
    .sidebar .nav-link i {
      margin-bottom: 5px; /* Adjust the margin of the icon */
    }
    /* Custom styles for hover effect */
    .sidebar .nav-item:hover:after {
      background-color: #fff;
      content: &#039;&#039;;
      position: absolute;
      left: 0;
      bottom: 0;
      width: 100%;
      height: 100%;
      z-index: 1; /* Ensure the hover background is below the text and icon */
    }
    .sidebar .nav-item:hover .nav-link {
      color: #8A1218;
    }
    /* Custom styles for divider */
    .sidebar .nav-item:after {
      content: &quot;&quot;;
      position: absolute;
      left: 0;
      bottom: 0;
      width: 100%;
      height: 1px;
      background-color: #fff;
      transition: height 0.3s ease-in-out; /* Transition effect for smooth animation */
    }
    /* Custom styles for header */
    .header {
      background-color: #8A1218;
      color: #fff;
      padding: 10px;
      position: fixed;
      top: 0;
      width: 100%;
      z-index: 2;
	  height:69px;
	  box-shadow:#FFF 2px 0px 0px 0px; /* Ensure header appears above sidebar */
    }
    .header .navbar-toggler {
      color: #fff;
    }
    .header .navbar-toggler-icon {
      color: #fff; /* Set the color of the toggle button to white */
    }
    .header .navbar-toggler.white {
      color: #fff !important; /* Ensure the toggle button is white */
    }
    .header .navbar-brand {
      color: #fff; /* Set navbar brand text color to white */
    }
    .header .nav-item .nav-link {
      color: #fff; /* Set nav link text color to white */
    }
    .main-content {
      margin-top: 50px; /* Height of fixed header + padding */
      margin-left: 100px; /* Width of sidebar */
      padding-top: 30px; /* Height of fixed header */
    }
	/* Custom styles for search bar */
    .search-container {
      display: flex;
      align-items: center;
      width: 300px;
      margin: 2px auto;
    }
    .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%);
    }
.btn-dark
         {
			 background:#8A1218;
			 color:#fff;
			 border-radius:
                 	}
		.btn-dark:hover{
			background:#fff;
			 color:#8A1218;
			 border:1px solid #8A1218;
			}	
			.bg-dark2{
			background:#8A1218;
			color:#fff;	
				}	
	
	 .modal-content {
            animation: modal-animation 0.5s;
        }

        @keyframes modal-animation {
            from {
                opacity: 0;
                transform: scale(0.8);
            }
            to {
                opacity: 1;
                transform: scale(1);
            }
        }


 /* Basic styling */
    .tab {
        display: none;
        padding: 20px;
    }
    .active {
        display: block;
    }
    .tab-buttons {
        display: flex;
    }
    .tab-button {
        cursor: pointer;
        padding: 10px 20px;
        background-color: #ffff;
        border: 1px solid #881218;
        border-radius: 5px 5px 0 0;
        margin-right: 5px;
		color:#881218;
    }
    .tab-button.active {
        background-color: #881218;
		color:#fff;
    }

    /* Background colors for tab content */
    #tab1 {
        background-color: #EFEEEE;
		color:#881218;
    }
    #tab2 {
        color:#881218;
		background-color: #EFEEEE;
    }
    #tab3 {
		color:#881218;
        background-color: #EFEEEE;
    }
&lt;/style&gt;

&lt;body&gt;

&lt;?php
if(isset($msg)){
	
	echo $msg;
	}
?&gt;
&lt;?php include(&quot;common/hd.php&quot;); ?&gt;
&lt;!-- Sidebar --&gt;
&lt;?php include(&quot;common/sd.php&quot;); ?&gt;

&lt;?php
	  $name = $_GET[&quot;name&quot;]; 
	  $current_date = date(&#039;Y-m-d&#039;);
      $closing = mysqli_query($connection,&quot;select * from daily_closing where date_time =&#039;$current_date&#039; &amp;&amp; name = &#039;$name&#039; &quot;);
	   $close = mysqli_fetch_array($closing);
	  ?&gt;
      
&lt;div class=&quot;main-content&quot;&gt;
&lt;br /&gt;
&lt;div class=&quot;container&quot;&gt;
&lt;div class=&quot;row&quot;&gt;
&lt;div class=&quot;col-sm-9 text-capitalize&quot;&gt;
&lt;h3 style=&quot;color:#881218;&quot;&gt;Stock &amp; Product Management (&lt;?php echo $name;?&gt;)&lt;/h3&gt;
&lt;/div&gt;
&lt;div class=&quot;col-sm-3&quot;&gt;

      
&lt;a href=&quot;addproduct.php&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;btn btn-dark&quot;&gt;&lt;i class=&quot;fa fa-arrow-left&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/a&gt;

&lt;/div&gt;
&lt;/div&gt;

&lt;/div&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-stripped text-center&quot;&gt;
      &lt;tr style=&quot;background:#881218;color:#fff;&quot;&gt;
          &lt;td&gt;Date&lt;/td&gt;
          &lt;td style=&quot;text-transform:capitalize;&quot;&gt;Name&lt;/td&gt;
          &lt;td&gt;Opening Qty&lt;/td&gt;
          &lt;td&gt;In-Store Qty&lt;/td&gt;
          &lt;td&gt;Sales Qty&lt;/td&gt;
          &lt;td&gt;Closing Qty&lt;/td&gt;
      &lt;/tr&gt;
      
      &lt;tr class=&quot;text-capitalize&quot;&gt;
      
      
      
      
         &lt;td&gt;&lt;?php  echo $close[&#039;date_time&#039;];  ?&gt;&lt;/td&gt;
         &lt;td&gt;&lt;?php  echo $close[&#039;name&#039;];  ?&gt;&lt;/td&gt; 
         &lt;td&gt;&lt;?php  echo $close[&#039;open_qty&#039;];  ?&gt;&lt;/td&gt; 
         &lt;td&gt;&lt;?php  echo $close[&#039;instore&#039;];  ?&gt;&lt;/td&gt;
         &lt;td&gt;&lt;?php  echo $close[&#039;sales&#039;];  ?&gt;&lt;/td&gt;
         &lt;td&gt;&lt;?php  echo $close[&#039;closing_qty&#039;];  ?&gt;&lt;/td&gt;    
     &lt;/tr&gt;
      
      &lt;/table&gt;
     &lt;/div&gt;
     
      
 &lt;/div&gt;
&lt;/div&gt;

&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;container&quot;&gt;
&lt;div class=&quot;tab-buttons&quot;&gt;
    &lt;div class=&quot;tab-button active&quot; onclick=&quot;openTab(event, &#039;tab1&#039;)&quot;&gt;Overview&lt;/div&gt;
    &lt;div class=&quot;tab-button&quot; onclick=&quot;openTab(event, &#039;tab2&#039;)&quot;&gt;IN-Store&lt;/div&gt;
    &lt;div class=&quot;tab-button&quot; onclick=&quot;openTab(event, &#039;tab3&#039;)&quot;&gt;Sales&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;tab-container&quot;&gt;
    &lt;div id=&quot;tab1&quot; class=&quot;tab active&quot;&gt;
    &lt;h2&gt;Overview&lt;/h2&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-sm-7&quot;&gt;&lt;/div&gt;
            
            &lt;div class=&quot;col-sm-4&quot;&gt;
             
    
            &lt;br /&gt;
            &lt;/div&gt;
            &lt;div class=&quot;col-sm-1&quot;&gt;&lt;button class=&quot;btn btn-dark&quot; id=&quot;downloadButton&quot;&gt;&lt;i class=&quot;fa fa-download&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/div&gt;
            &lt;br /&gt;
           
                &lt;!--&lt;table class=&quot;table table-striped &quot; id=&quot;overviewTable&quot; style=&quot;margin-top:12px;&quot;&gt;
                    &lt;tr style=&quot;background:#881218;text-transform:capitalize; text-align:center;&quot;&gt;
                    
                        &lt;td class=&quot;text-white&quot;&gt;Date&lt;/td&gt;
                        &lt;td class=&quot;text-white&quot;&gt;Opening Qty&lt;/td&gt;
                        &lt;td class=&quot;text-white&quot;&gt;In-store Qty&lt;/td&gt;
                        &lt;td class=&quot;text-white&quot;&gt;Sales Qty&lt;/td&gt;
                       
                        &lt;td class=&quot;text-white&quot;&gt;Closing Qty&lt;/td&gt;
                    &lt;/tr&gt;--&gt;
&lt;?php 
/*  
// Start date of the month
$start_date = date(&#039;Y-m-01&#039;);
// End date of the month
$end_date = date(&#039;Y-m-t&#039;);

// Initialize opening quantity for the first day of the month
$opening_qty = 0;

// Loop through each day of the month
$current_date = $start_date;
while (strtotime($current_date) &lt;= strtotime($end_date)) {
    // Fetch in-store quantity for this date
    $product_id = $_GET[&quot;id&quot;]; // Assuming you&#039;re receiving product ID via GET method
    $instore_query = mysqli_query($connection, &quot;SELECT SUM(stock_qty) AS total_instore FROM purchases WHERE DATE(date_time) = &#039;$current_date&#039; &amp;&amp;  product_id = &#039;$product_id&#039;&quot;);
    $instore_data = mysqli_fetch_assoc($instore_query);
    $instore_qty = $instore_data[&#039;total_instore&#039;] ?? 0;

    // Fetch sales quantity for this date
    $sales_query = mysqli_query($connection, &quot;SELECT SUM(product_quantity) AS total_sales FROM log_user_sales WHERE DATE(date_time) = &#039;$current_date&#039; &amp;&amp;  product_id = &#039;$product_id&#039;&quot;);
    $sales_data = mysqli_fetch_assoc($sales_query);
    $sales_qty = $sales_data[&#039;total_sales&#039;] ?? 0;

    // Calculate closing quantity
    $closing_qty = $opening_qty + $instore_qty - $sales_qty;

    // Display the data in the table
    echo &quot;&lt;tr class=&#039;text-center&#039;&gt;&quot;;
    echo &quot;&lt;td&gt;$current_date&lt;/td&gt;&quot;;
    echo &quot;&lt;td&gt;$opening_qty&lt;/td&gt;&quot;;
    echo &quot;&lt;td&gt;$instore_qty&lt;/td&gt;&quot;;
    echo &quot;&lt;td&gt;$sales_qty&lt;/td&gt;&quot;;
    
    echo &quot;&lt;td&gt;$closing_qty&lt;/td&gt;&quot;;
    echo &quot;&lt;/tr&gt;&quot;;
// Check if data for this date already exists in the daily_closing table
    $existing_data_query = mysqli_query($connection, &quot;SELECT * FROM daily_closing WHERE date_time = &#039;$current_date&#039; AND product_id = &#039;$product_id&#039;&quot;);
    $existing_data = mysqli_fetch_assoc($existing_data_query);

    if ($existing_data) {
    // Update existing record
    mysqli_query($connection, &quot;UPDATE daily_closing 
                                SET closing_qty = $closing_qty,
                                    instore = $instore_qty,
                                    sales = $sales_qty,
									open_qty = $opening_qty 
                                WHERE date_time = &#039;$current_date&#039; 
                                AND product_id = &#039;$product_id&#039;&quot;);
} else {
    // Insert the closing quantity into the database for the current day
    mysqli_query($connection, &quot;INSERT INTO daily_closing (date_time, product_id, name, open_qty, instore, sales, closing_qty,user_name,user_role,outlet_name,outlet_address)
	VALUES (&#039;$current_date&#039;, &#039;$product_id&#039;, &#039;$name&#039;, $opening_qty, $instore_qty, $sales_qty, $closing_qty, $user_name, $user_role, $outlet_name, $outlet_address)&quot;);
}
    // Move to the next day
    $current_date = date(&#039;Y-m-d&#039;, strtotime($current_date . &#039; +1 day&#039;));

    // Set opening quantity for the next day as the current day&#039;s closing quantity
    $opening_qty = $closing_qty;
}
*/
?&gt;




                &lt;!--&lt;/table&gt;--&gt;
                
                
                
                
             &lt;div class=&quot;container &quot;&gt;
        &lt;div class=&quot;row&quot; style=&quot;padding:20px;background:#fff; box-shadow: 0px 0px 5px 2px #CCC; border-radius:10px;&quot;&gt;
            &lt;div class=&quot;col-sm-12&quot; style=&quot;padding:20px;&quot;&gt;
            &lt;table class=&quot;table table-hover&quot;  &gt;
            &lt;tr style=&quot;color:#8A1218;padding:20px;&quot;&gt;
            &lt;td style=&quot;font-weight:600;&quot;&gt;Opening Cash&lt;/td&gt;
            &lt;td style=&quot;text-align:right; font-size:19px; font-weight:600;&quot;&gt;&lt;?php echo isset($open_cash) ? &quot;Rs &quot;.$open_cash.&quot;.00&quot; : &quot;&quot;; ?&gt;&lt;/td&gt;
            &lt;/tr&gt;
            &lt;tr&gt;
            &lt;td style=&quot;font-weight:600;&quot;&gt;Cash Sales&lt;/td&gt;
            &lt;td style=&quot;text-align:right; font-size:19px; font-weight:600;&quot;&gt;&lt;?php echo isset($total_sales) ? &quot;Rs &quot;.$total_sales.&quot;.00&quot; : &quot;&quot;; ?&gt;&lt;/td&gt;
            &lt;/tr&gt;
            &lt;tr&gt;
            &lt;td style=&quot;font-weight:600;&quot;&gt;Cash Out&lt;/td&gt;
            &lt;td style=&quot;text-align:right; font-size:19px; font-weight:600;&quot;&gt;&lt;?php echo isset($totalAmount) ? &quot;Rs &quot;.$totalAmount.&quot;.00&quot; : &quot;&quot;; ?&gt;&lt;/td&gt;
            &lt;/tr&gt; 
            &lt;tr&gt;
            &lt;td style=&quot;font-weight:600;&quot;&gt;Closing Cash&lt;/td&gt;
            &lt;td style=&quot;text-align:right; font-size:19px; font-weight:600;&quot;&gt;&lt;?php echo isset($close_amount) ? &quot;Rs &quot;.$close_amount.&quot;.00&quot; : &quot;&quot;; ?&gt;&lt;/td&gt;
            &lt;/tr&gt;
            &lt;td style=&quot;font-weight:600;&quot;&gt;Cash Drawer Amount&lt;/td&gt;
            &lt;td style=&quot;text-align:right; font-size:19px; font-weight:600;&quot;&gt;&lt;input type=&quot;text&quot; name=&quot;drawer_amount&quot; 
            placeholder=&quot;Rs&quot; style=&quot;width:220px; height:35px; border:1px solid #999;box-shadow: 0px 0px 4px 1px #CCC; border-radius:5px;&quot;&gt;&lt;/td&gt;
            &lt;/tr&gt;           
            &lt;/table&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;textarea placeholder=&quot;&#039;Remarks:&#039;&quot;  name=&quot;remarks&quot;  class=&quot;form-control&quot; style=&quot;height:150px;&quot;&gt;&lt;/textarea&gt;
         &lt;br /&gt;
         &lt;button class=&quot;btn btn-dark&quot; type=&quot;submit&quot; name=&quot;closedrawer&quot;&gt; &lt;i class=&quot;fa fa-cash-register&quot;&gt;&lt;/i&gt;&amp;nbsp;Close Cash Drawer
         &lt;/button&gt;
        
         &lt;/div&gt;
         
        &lt;/div&gt;
        
    &lt;/div&gt;
                
                
           
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;p&gt;&lt;/p&gt;
&lt;/div&gt;






    &lt;div id=&quot;tab2&quot; class=&quot;tab&quot;&gt;
        &lt;h2&gt;IN-Store&lt;/h2&gt;
        &lt;div class=&quot;container&quot;&gt;
           &lt;div class=&quot;row&quot;&gt;
            
      &lt;div class=&quot;col-sm-7&quot;&gt;&lt;/div&gt;
            
            &lt;div class=&quot;col-sm-4&quot;&gt;
             
    
            &lt;br /&gt;
            &lt;/div&gt;
            &lt;div class=&quot;col-sm-1&quot;&gt;&lt;button class=&quot;btn btn-dark&quot; id=&quot;downloadButton2&quot;&gt;&lt;i class=&quot;fa fa-download&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/div&gt;
            &lt;/div&gt;
           
           &lt;br /&gt;
             &lt;div class=&quot;col-sm-12&quot;&gt;
               &lt;table class=&quot;table table-stripped text-center&quot; id=&quot;instoreviewTable&quot;&gt;
                &lt;tr style=&quot;background:#881218; color:#fff;&quot;&gt;
                &lt;td&gt;Date&lt;/td&gt;
                &lt;td&gt;ID&lt;/td&gt;
                &lt;th&gt;Name&lt;/th&gt;
                &lt;td&gt;Unit&lt;/td&gt;
                &lt;td&gt;Qty`&lt;/td&gt;
                &lt;td&gt;Amount&lt;/td&gt;
                &lt;/tr&gt;
               
               
               &lt;?php
			   $name = $_GET[&quot;name&quot;];
               $rec = mysqli_query($connection,&quot;select * from purchases where name = &#039;&quot;.$name.&quot;&#039;&quot;);
			   
			   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;product_id&quot;];  ?&gt;&lt;/td&gt;
               &lt;td class=&quot;text-capitalize&quot;&gt;&lt;?php echo $row[&quot;name&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row[&quot;unit_pr&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row[&quot;stock_qty&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row[&quot;price&quot;];  ?&gt;&lt;/td&gt;
               &lt;/tr&gt;
               &lt;?php 
			   }
			   ?&gt;
               
               &lt;/table&gt;
             &lt;/div&gt;
           &lt;/div&gt;
          &lt;/div&gt;
    &lt;/div&gt;
    &lt;div id=&quot;tab3&quot; class=&quot;tab&quot;&gt;
        &lt;h2&gt;Sales&lt;/h2&gt;
        &lt;div class=&quot;container&quot;&gt;
           &lt;div class=&quot;row&quot;&gt;
            
            &lt;div class=&quot;col-sm-7&quot;&gt;&lt;/div&gt;
            
            &lt;div class=&quot;col-sm-4&quot;&gt;
             
    
            &lt;br /&gt;
            &lt;/div&gt;
            &lt;div class=&quot;col-sm-1&quot;&gt;&lt;button class=&quot;btn btn-dark&quot; id=&quot;downloadButton3&quot;&gt;&lt;i class=&quot;fa fa-download&quot;&gt;&lt;/i&gt;&lt;/button&gt;&lt;/div&gt;
           &lt;/div&gt;
           &lt;br /&gt;
             &lt;div class=&quot;col-sm-12&quot;&gt;
               &lt;table class=&quot;table table-stripped text-center&quot; id=&quot;salesviewTable&quot;&gt;
                &lt;tr style=&quot;background:#881218; color:#fff;&quot;&gt;
                &lt;td&gt;Order ID&lt;/td&gt;
                &lt;td&gt;Date&lt;/td&gt;
                &lt;td&gt;ID&lt;/td&gt;
                &lt;td&gt;Name&lt;/td&gt;
                &lt;td&gt;Price&lt;/td&gt;
                &lt;td&gt;Qty`&lt;/td&gt;
                &lt;td&gt;Amount&lt;/td&gt;
                &lt;td&gt;Tax&lt;/td&gt;
                &lt;td&gt;Total Amount&lt;/td&gt;
                &lt;/tr&gt;
               
              &lt;?php
			  $id = $_GET[&quot;id&quot;];
               $rec2 = mysqli_query($connection,&quot;select * from sales  where product_id = &#039;&quot;.$id.&quot;&#039;&quot;);
			   
			   while($row2 = mysqli_fetch_array($rec2)){
			   ?&gt;
               &lt;tr&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;order_id&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;date_time&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;product_id&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;product_name&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;product_price&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;product_quantity&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;product_total&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;tax_amount&quot;];  ?&gt;&lt;/td&gt;
               &lt;td&gt;&lt;?php echo $row2[&quot;total_amount&quot;];  ?&gt;&lt;/td&gt;
               &lt;/tr&gt;
               &lt;?php } ?&gt;
               &lt;/table&gt;
             &lt;/div&gt;
           &lt;/div&gt;
          &lt;/div&gt;
    &lt;/div&gt;
    
    &lt;/div&gt;
    
    
    
&lt;/div&gt;
  
  
  
  
 
    
    
&lt;/div&gt;    
&lt;/body&gt;
&lt;!-- JavaScript libraries --&gt;
&lt;!-- jQuery library --&gt;
&lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js&quot;&gt;&lt;/script&gt;
&lt;!-- Latest compiled and minified Bootstrap JavaScript --&gt;
&lt;script src=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;
&lt;!-- Popper JS --&gt;
&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js&quot;&gt;&lt;/script&gt;
&lt;!-- FileSaver.js --&gt;
&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.0/FileSaver.min.js&quot;&gt;&lt;/script&gt;
&lt;!-- TableExport.js --&gt;
&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/TableExport/5.2.0/js/tableexport.min.js&quot;&gt;&lt;/script&gt;

&lt;script&gt;
        function toggleSidebar() {
      document.getElementById(&quot;sidebar&quot;).classList.toggle(&quot;hide&quot;);
    }
	
document.getElementById(&quot;downloadButton&quot;).addEventListener(&quot;click&quot;, function () {
        exportTableToCSV();
    });
	
	document.getElementById(&quot;downloadButton2&quot;).addEventListener(&quot;click&quot;, function () {
        exportTableToCSV2();
    });
	
	document.getElementById(&quot;downloadButton3&quot;).addEventListener(&quot;click&quot;, function () {
        exportTableToCSV3();
    });

    function exportTableToCSV() {
        var csv = [];
        var rows = document.querySelectorAll(&quot;#overviewTable tr&quot;);

        for (var i = 0; i &lt; rows.length; i++) {
            var row = [], cols = rows[i].querySelectorAll(&quot;td, th&quot;);

            for (var j = 0; j &lt; cols.length; j++) 
                row.push(cols[j].innerText);

            csv.push(row.join(&quot;,&quot;));
        }

        var csvContent = &quot;data:text/csv;charset=utf-8,&quot; + csv.join(&quot;\n&quot;);
        var encodedUri = encodeURI(csvContent);
        var link = document.createElement(&quot;a&quot;);
        link.setAttribute(&quot;href&quot;, encodedUri);
        link.setAttribute(&quot;download&quot;, &quot;table_data.csv&quot;);
        document.body.appendChild(link);
        link.click();
    }
	    function exportTableToCSV2() {
        var csv = [];
        var rows = document.querySelectorAll(&quot;#instoreviewTable tr&quot;);

        for (var i = 0; i &lt; rows.length; i++) {
            var row = [], cols = rows[i].querySelectorAll(&quot;td, th&quot;);

            for (var j = 0; j &lt; cols.length; j++) 
                row.push(cols[j].innerText);

            csv.push(row.join(&quot;,&quot;));
        }

        var csvContent = &quot;data:text/csv;charset=utf-8,&quot; + csv.join(&quot;\n&quot;);
        var encodedUri = encodeURI(csvContent);
        var link = document.createElement(&quot;a&quot;);
        link.setAttribute(&quot;href&quot;, encodedUri);
        link.setAttribute(&quot;download&quot;, &quot;table_data.csv&quot;);
        document.body.appendChild(link);
        link.click();
    }
	    function exportTableToCSV3() {
        var csv = [];
        var rows = document.querySelectorAll(&quot;#salesviewTable tr&quot;);

        for (var i = 0; i &lt; rows.length; i++) {
            var row = [], cols = rows[i].querySelectorAll(&quot;td, th&quot;);

            for (var j = 0; j &lt; cols.length; j++) 
                row.push(cols[j].innerText);

            csv.push(row.join(&quot;,&quot;));
        }

        var csvContent = &quot;data:text/csv;charset=utf-8,&quot; + csv.join(&quot;\n&quot;);
        var encodedUri = encodeURI(csvContent);
        var link = document.createElement(&quot;a&quot;);
        link.setAttribute(&quot;href&quot;, encodedUri);
        link.setAttribute(&quot;download&quot;, &quot;table_data.csv&quot;);
        document.body.appendChild(link);
        link.click();
    }

// Live search functionality
document.getElementById(&#039;searchInput&#039;).addEventListener(&#039;input&#039;, function() {
    var filter, table, tr, td, i, txtValue;
    filter = this.value.toUpperCase();
    table = document.getElementById(&quot;overviewTable&quot;);
    tr = table.getElementsByTagName(&quot;tr&quot;);
    for (i = 0; i &lt; tr.length; i++) {
        td = tr[i].getElementsByTagName(&quot;td&quot;)[0]; // Change index based on column position
        if (td) {
            txtValue = td.textContent || td.innerText;
            if (txtValue.toUpperCase().indexOf(filter) &gt; -1) {
                tr[i].style.display = &quot;&quot;;
            } else {
                tr[i].style.display = &quot;none&quot;;
            }
        }
    }
});
    // Function to switch between tabs
    function openTab(evt, tabName) {
        // Get all elements with class=&quot;tab&quot; and hide them
        var tabs = document.getElementsByClassName(&quot;tab&quot;);
        for (var i = 0; i &lt; tabs.length; i++) {
            tabs[i].style.display = &quot;none&quot;;
        }

        // Get all elements with class=&quot;tab-button&quot; and remove the class &quot;active&quot;
        var tabButtons = document.getElementsByClassName(&quot;tab-button&quot;);
        for (var i = 0; i &lt; tabButtons.length; i++) {
            tabButtons[i].classList.remove(&quot;active&quot;);
        }

        // Show the current tab, and add an &quot;active&quot; class to the button that opened the tab
        document.getElementById(tabName).style.display = &quot;block&quot;;
        evt.currentTarget.classList.add(&quot;active&quot;);
    }
&lt;/script&gt;


&lt;/html&gt;</code></pre>        </div>
    </div>