    <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);
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;];
}
ob_end_flush();

$saleRevenueData = [];
$saleCostData = [];
$expensesData = [];
$profitData = [];
$labels = [];  // To store dates for labels

$startDate = &#039;&#039;;
$endDate = &#039;&#039;;

if (isset($_POST[&#039;filter&#039;])) {
    $startDate = $_POST[&#039;startDate&#039;];
    $endDate = $_POST[&#039;endDate&#039;];

    // Generate the list of dates between the start and end date
    $period = new DatePeriod(
        new DateTime($startDate),
        new DateInterval(&#039;P1D&#039;),  // Daily interval
        (new DateTime($endDate))-&gt;modify(&#039;+1 day&#039;)
    );

    foreach ($period as $date) {
        $currentDate = $date-&gt;format(&#039;Y-m-d&#039;);
        $labels[] = $currentDate; // Add the date to labels

        // Initialize daily revenue, cost, expense, and refunded values
        $dailyRevenue = 0;
        $dailyCost = 0;
        $dailyExpense = 0;
        $dailyRefundedRevenue = 0;
        $dailyRefundedCost = 0;

        // Fetch and accumulate Sale Revenue for the current date
        $query = &quot;SELECT order_id, discount_amount AS revenue 
                  FROM log_user_sales 
                  WHERE DATE(date_time) = &#039;$currentDate&#039; AND status = &#039;&#039; GROUP BY order_id&quot;;
        $result = mysqli_query($connection, $query);
        while ($row = mysqli_fetch_assoc($result)) {
            $dailyRevenue += $row[&#039;revenue&#039;];
        }

        // Fetch and accumulate Sale Cost for the current date
        $query = &quot;SELECT sale_cost AS cost 
                  FROM log_user_sales 
                  WHERE DATE(date_time) = &#039;$currentDate&#039; AND status = &#039;&#039;&quot;;
        $result = mysqli_query($connection, $query);
        while ($row = mysqli_fetch_assoc($result)) {
            $dailyCost += $row[&#039;cost&#039;];
        }

        // Fetch and accumulate Refunded Revenue for the current date
        $query = &quot;SELECT r_order_id, discount_amount AS refunded_revenue 
                  FROM log_user_sales 
                  WHERE DATE(date_time) = &#039;$currentDate&#039; AND status = &#039;refund&#039; GROUP BY r_order_id&quot;;
        $result = mysqli_query($connection, $query);
        while ($row = mysqli_fetch_assoc($result)) {
            $dailyRefundedRevenue += $row[&#039;refunded_revenue&#039;];
        }

        // Fetch and accumulate Refunded Sale Cost for the current date
        $query = &quot;SELECT sale_cost AS refunded_cost 
                  FROM log_user_sales 
                  WHERE DATE(date_time) = &#039;$currentDate&#039; AND status = &#039;refund&#039;&quot;;
        $result = mysqli_query($connection, $query);
        while ($row = mysqli_fetch_assoc($result)) {
            $dailyRefundedCost += $row[&#039;refunded_cost&#039;];
        }

        // Fetch and accumulate Expenses for the current date
        $query = &quot;SELECT amount AS expense 
                  FROM incash 
                  WHERE DATE(date_time) = &#039;$currentDate&#039;&quot;;
        $result = mysqli_query($connection, $query);
        while ($row = mysqli_fetch_assoc($result)) {
            $dailyExpense += (int)$row[&#039;expense&#039;];
        }

        // Calculate Net Revenue and Net Cost by subtracting refunds
        $netRevenue = $dailyRevenue - $dailyRefundedRevenue;
        $netCost = $dailyCost - $dailyRefundedCost;

        // Store data in respective arrays
        $saleRevenueData[] = $netRevenue;
        $saleCostData[] = $netCost;
        $expensesData[] = $dailyExpense;

        // Calculate Net Profit for the current date
        $profitData[] = $netRevenue - ($netCost + $dailyExpense);
    }
}
?&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-fluid mt-5&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
        &lt;div class=&quot;col-sm-5&quot;&gt;
     &lt;h3 style=&quot;color:#060606; font-weight:700;&quot;&gt;Profit &amp; Loss Report&lt;/h3&gt;
        &lt;/div&gt;
        &lt;div class=&quot;col-sm-4&quot;&gt;&lt;/div&gt;
        &lt;div class=&quot;col-sm-3&quot;&gt;
             
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;br&gt;
        &lt;form method=&quot;post&quot;&gt;
            &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-md-4&quot;&gt;
                    &lt;div class=&quot;form-group&quot;&gt;
                        &lt;label for=&quot;startDate&quot;&gt;Start Date:&lt;/label&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;startDate&quot; value=&quot;&lt;?php echo $startDate; ?&gt;&quot; required&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-md-4&quot;&gt;
                    &lt;div class=&quot;form-group&quot;&gt;
                        &lt;label for=&quot;endDate&quot;&gt;End Date:&lt;/label&gt;
                        &lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;endDate&quot; value=&quot;&lt;?php echo $endDate; ?&gt;&quot; required&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-md-4&quot;&gt;
                    &lt;div class=&quot;form-group&quot;&gt;
                        &lt;br&gt;
                        &lt;button type=&quot;submit&quot; class=&quot;btn btn-dark&quot; name=&quot;filter&quot;&gt;Filter&lt;/button&gt;
                         &lt;a href=&quot;report_pl.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;/div&gt;
        &lt;/form&gt;

        &lt;!-- Cards for Revenue, Cost, Expenses, and Profit --&gt;
        &lt;div class=&quot;row&quot;&gt;
            &lt;!-- Sales Revenue Card --&gt;
            &lt;div class=&quot;col-xl-3 col-md-6 mb-4&quot;&gt;
                &lt;div class=&quot;card border-left-primary shadow h-100 py-2&quot;&gt;
                    &lt;div class=&quot;card-body&quot;&gt;
                        &lt;div class=&quot;row no-gutters align-items-center&quot;&gt;
                            &lt;div class=&quot;col mr-2&quot;&gt;
                                &lt;div class=&quot;text-xs font-weight-bold text-uppercase mb-1&quot;&gt;Sales Revenue&lt;/div&gt;
                                &lt;div class=&quot;h5 mb-0 font-weight-bold text-gray-800&quot;&gt;Rs. &lt;?php echo number_format(array_sum($saleRevenueData), 2); ?&gt;&lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-auto&quot;&gt;
                                &lt;i class=&quot;fas fa-dollar-sign fa-2x text-primary&quot;&gt;&lt;/i&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;!-- Sales Cost Card --&gt;
            &lt;div class=&quot;col-xl-3 col-md-6 mb-4&quot;&gt;
                &lt;div class=&quot;card border-left-info shadow h-100 py-2&quot;&gt;
                    &lt;div class=&quot;card-body&quot;&gt;
                        &lt;div class=&quot;row no-gutters align-items-center&quot;&gt;
                            &lt;div class=&quot;col mr-2&quot;&gt;
                                &lt;div class=&quot;text-xs font-weight-bold text-uppercase mb-1&quot;&gt;Sales Cost&lt;/div&gt;
                                &lt;div class=&quot;h5 mb-0 font-weight-bold text-gray-800&quot;&gt;Rs. &lt;?php echo number_format(array_sum($saleCostData), 2); ?&gt;&lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-auto&quot;&gt;
                                &lt;i class=&quot;fas fa-dollar-sign fa-2x text-info&quot;&gt;&lt;/i&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;!-- Expenses Card --&gt;
            &lt;div class=&quot;col-xl-3 col-md-6 mb-4&quot;&gt;
                &lt;div class=&quot;card border-left-warning shadow h-100 py-2&quot;&gt;
                    &lt;div class=&quot;card-body&quot;&gt;
                        &lt;div class=&quot;row no-gutters align-items-center&quot;&gt;
                            &lt;div class=&quot;col mr-2&quot;&gt;
                                &lt;div class=&quot;text-xs font-weight-bold text-uppercase mb-1&quot;&gt;Expenses&lt;/div&gt;
                                &lt;div class=&quot;h5 mb-0 font-weight-bold text-gray-800&quot;&gt;Rs. &lt;?php echo number_format(array_sum($expensesData), 2); ?&gt;&lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-auto&quot;&gt;
                                &lt;i class=&quot;fas fa-dollar-sign fa-2x text-warning&quot;&gt;&lt;/i&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;!-- Net Profit Card --&gt;
            &lt;div class=&quot;col-xl-3 col-md-6 mb-4&quot;&gt;
                &lt;div class=&quot;card border-left-success shadow h-100 py-2&quot;&gt;
                    &lt;div class=&quot;card-body&quot;&gt;
                        &lt;div class=&quot;row no-gutters align-items-center&quot;&gt;
                            &lt;div class=&quot;col mr-2&quot;&gt;
                                &lt;div class=&quot;text-xs font-weight-bold text-uppercase mb-1&quot;&gt;Net Profit&lt;/div&gt;
                                &lt;div class=&quot;h5 mb-0 font-weight-bold text-gray-800&quot;&gt;Rs. &lt;?php echo number_format(array_sum($profitData), 2); ?&gt;&lt;/div&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-auto&quot;&gt;
                                &lt;i class=&quot;fas fa-dollar-sign fa-2x text-success&quot;&gt;&lt;/i&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;

        &lt;!-- Graph --&gt;
        &lt;canvas id=&quot;profitLossChart&quot;&gt;&lt;/canvas&gt;

        &lt;!-- Buttons for download --&gt;
        &lt;div class=&quot;mt-4&quot;&gt;
            &lt;button class=&quot;btn btn-dark&quot; onclick=&quot;downloadCSV()&quot;&gt;Download CSV Report&lt;/button&gt;
            &lt;button class=&quot;btn btn-dark&quot; onclick=&quot;downloadGraph()&quot;&gt;Download Graph as Image&lt;/button&gt;
        &lt;/div&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&gt;
    var ctx = document.getElementById(&#039;profitLossChart&#039;).getContext(&#039;2d&#039;);
    var chart = new Chart(ctx, {
        type: &#039;line&#039;,
        data: {
            labels: &lt;?php echo json_encode($labels); ?&gt;, // Dates as labels
            datasets: [
                {
                    label: &#039;Sales Revenue&#039;,
                    backgroundColor: &#039;rgba(54, 162, 235, 0.2)&#039;,
                    borderColor: &#039;rgba(54, 162, 235, 1)&#039;,
                    data: &lt;?php echo json_encode($saleRevenueData); ?&gt;,
                    fill: false,
                    tension: 0.4
                },
                {
                    label: &#039;Sales Cost&#039;,
                    backgroundColor: &#039;rgba(75, 192, 192, 0.2)&#039;,
                    borderColor: &#039;rgba(75, 192, 192, 1)&#039;,
                    data: &lt;?php echo json_encode($saleCostData); ?&gt;,
                    fill: false,
                    tension: 0.4
                },
                {
                    label: &#039;Expenses&#039;,
                    backgroundColor: &#039;rgba(255, 206, 86, 0.2)&#039;,
                    borderColor: &#039;rgba(255, 206, 86, 1)&#039;,
                    data: &lt;?php echo json_encode($expensesData); ?&gt;,
                    fill: false,
                    tension: 0.4
                },
                {
                    label: &#039;Net Profit&#039;,
                    backgroundColor: &#039;rgba(75, 192, 192, 0.2)&#039;,
                    borderColor: &#039;rgba(75, 192, 192, 1)&#039;,
                    data: &lt;?php echo json_encode($profitData); ?&gt;,
                    fill: false,
                    tension: 0.4
                }
            ]
        },
        options: {
            scales: {
                y: {
                    beginAtZero: true
                }
            }
        }
    });

    // Function to download CSV report
    function downloadCSV() {
        var csvContent = &quot;data:text/csv;charset=utf-8,&quot;;
        csvContent += &quot;Date,Sales Revenue,Sales Cost,Expenses,Net Profit\n&quot;; // Header
        var labels = &lt;?php echo json_encode($labels); ?&gt;;
        var saleRevenueData = &lt;?php echo json_encode($saleRevenueData); ?&gt;;
        var saleCostData = &lt;?php echo json_encode($saleCostData); ?&gt;;
        var expensesData = &lt;?php echo json_encode($expensesData); ?&gt;;
        var profitData = &lt;?php echo json_encode($profitData); ?&gt;;

        labels.forEach(function (label, index) {
            csvContent += label + &quot;,&quot; + saleRevenueData[index] + &quot;,&quot; + saleCostData[index] + &quot;,&quot; + expensesData[index] + &quot;,&quot; + profitData[index] + &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;sales_report.csv&quot;);
        document.body.appendChild(link); // Required for FF

        link.click();
    }

    // Function to download graph as image
    function downloadGraph() {
        var a = document.createElement(&#039;a&#039;);
        a.href = document.getElementById(&#039;profitLossChart&#039;).toDataURL(&#039;image/jpg&#039;);
        a.download = &#039;profit_loss_graph.jpg&#039;;
        a.click();
    }
&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>