<?php echo $__env->make('admin::layouts.header', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php
use App\Models\Categories;
use App\Models\Supliers;
use App\Models\Brands;
use App\Models\GRNProducts;
use App\Models\Orders;
?>
<main id="main-container">
        <!-- Hero -->
        <div class="bg-body-light">
          <div class="content content-full">
            <div class="d-flex flex-column flex-sm-row justify-content-sm-between align-items-sm-center">
              <h1 class="flex-grow-1 fs-3 fw-semibold my-2 my-sm-3">Financial Reports</h1>
              <nav class="flex-shrink-0 my-2 my-sm-0 ms-sm-3" aria-label="breadcrumb">
                <ol class="breadcrumb">
                  <li class="breadcrumb-item">Dashboard</li>
                  <li class="breadcrumb-item">Report</li>
                  <li class="breadcrumb-item active" aria-current="page">Financial Reports</li>
                </ol>
              </nav>
            </div>
          </div>
        </div>
        <!-- END Hero -->

        <!-- Page Content -->
        <div class="content">
          <!-- Your Block -->
          <div class="block block-rounded">
            <div class="block-header block-header-default">
              <h3 class="block-title">Financial Reports</h3>
            </div>
            <div class="block-content">
            <?php if(Session::has('success')): ?> <div class="alert alert-success mt-2 mb-2"><?php echo e(Session::get('success')); ?></div><?php endif; ?>
            <?php if(Session::has('fail')): ?> <div class="alert alert-danger mt-2 mb-2"><?php echo e(Session::get('fail')); ?></div><?php endif; ?>
            <table class="table table-bordered table-striped table-vcenter js-dataTable-buttons">
                <thead>
                  <tr>
                  <th>Total Assets</th>
                  <th>Total Liabilities</th>
                  <th>Revenue</th>
                  <th>Expenses</th>
                   <th>Gross Profit</th>
                  <th>Net Profit</th>
                  
                  </tr>
                </thead>
                <tbody>
                <?php 
                $totalAssets = 0;
                $totalLiabilities = 0; 
                $totalRevenue = 0;
                $totalExpenses = 0;
                $grossProfit = 0;
                $netProfit = 0;
                foreach($products as $product) {
                    $grn_product = GRNProducts::where('product', $product->id)->first();
                    $totalAssets = $totalAssets+(($grn_product->quantity ?? 0) * ($grn_product->wholesale_purchase_price ?? 0));
                    $orders=Orders::get();
                    foreach($orders as $order){
                         $totalRevenue = $totalRevenue + $order->total;
                    }
                   
                }
                ?>
                  
               <tr>
                    <td class="fw-semibold">
                    LKR <?php echo e(number_format($totalAssets)); ?>

                    </td>
                      <td class="fw-semibold">
                    LKR <?php echo e(number_format($totalLiabilities)); ?>

                    </td>
                    <td class="fw-semibold">
                    LKR <?php echo e(number_format($totalRevenue)); ?>

                    </td>
                     <td class="fw-semibold">
                      LKR <?php echo e(number_format($totalExpenses)); ?>

                     </td>
                      <td class="fw-semibold">
                      LKR <?php echo e(number_format($totalRevenue - $totalExpenses)); ?>

                    </td>
                      <td class="fw-semibold">
                      LKR <?php echo e(number_format($totalRevenue - $totalExpenses)); ?>

                    </td>
                  </tr>
                </tbody>
              </table>
            </div>
          </div>
          <!-- END Your Block -->
        </div>
        <!-- END Page Content -->
</main>
<!-- END Main Container -->
<?php echo $__env->make('admin::layouts.footer', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php /**PATH /home/dilsnoon/orionuxerp.store/Modules/Admin/resources/views/report/financial_reports.blade.php ENDPATH**/ ?>