@extends('layouts.app')
@section('title') {{'Day Summary Report'}} @endsection
@section('content')

    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Day Summary Report 
            </div>
            @if (Session::has('msg'))
                <div class="alert alert-info">{{ Session::get('msg') }}</div>
            @endif
            <div class="panel-body">
              <div class="form-group"> 
              <form action="" method="get" autocomplete="off">
                
                    <div class="col-md-2">
                        Start Date
                        <input id="start_date" type="text" class="form-control" name="start_date" value="2026-06-04" autocomplete="off" required>
                    </div>
                    <div class="col-md-2">
                        End Date
                        <input id="end_date" type="text" class="form-control" name="end_date" value="2026-06-04" autocomplete="off" required>
                    </div>
                    <div class="col-md-2">
                        <br/> &nbsp;
                        <button type="submit" class="btn btn-success">Search</button>
                    </div>
                
              </form>
            </div>
            <div class="clearfix">
                <p class="pull-right">
                    <span title="Print" class="btn btn-primary" onclick="printData('myTablePrint')"> <i class="glyphicon glyphicon-print"> </i> </span>
                    <span title="Download" class="btn btn-success" onclick="exportTableToExcel('myTablePrint')" > <i class="glyphicon glyphicon-download-alt"></i> </span>
                </p>
            </div>

              <div id="myTablePrint" class="form-group mt-1" style="width:100%; overflow: scroll;" >

                
                <table id="myTable" class="table table-striped table-hover mt-1">
                    <thead class="header" id="myHeader">
                                              <h4 style="text-align: center;">Day Summary Report</h4>
                        <h5 style="text-align: center;">{!! date('d-F-Y', strtotime($start_date)) !!} to {!! date('d-F-Y', strtotime($end_date)) !!} </h5>
                        <br>
                        <tr>
                            <th colspan="4">Incoming (Tk.)</th>
                            <th colspan="3">Outgoing (Tk.)</th>
                        </tr>
                        <tr>
                            <th>S.L.</th>
                            <th colspan="2">Details</th>
                            <th>Amount</th>
                            <th>S.L.</th>
                            <th>Details</th>
                            <th>Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                      @php 
                          
                          $total = 0; 

                          $product_received = $summary_info->product_received;
                          $product_sales = $summary_info->product_sales;
                          $product_in = $summary_info->product_in;
                          $product_out = $summary_info->product_out;

                          $opening_stock = $product_received + $product_in - $product_sales - $product_out;

                          $total_received = $summary_info->today_received;
                          $dp_total_sales = $summary_info->dp_today_sales;
                          $tp_total_sales = $summary_info->tp_today_sales;
                          $today_in = $summary_info->today_in;
                          $today_out = $summary_info->today_out;

                          $closing_stock = $opening_stock + $total_received - $tp_total_sales + $today_in - $today_out;

                          
                          $Direct_Incomes = $tp_total_sales - $dp_total_sales;

                          $Credit_total = $tp_total_sales + $closing_stock + $Direct_Incomes;

                          $Gross_Profit = $Credit_total - $opening_stock;
                          $Debit_total = $opening_stock + $Gross_Profit;

                          $Purchase_Accounts = $summary_info->purchase_accounts;
                          $Direct_Expenses = $summary_info->direct_expenses;
                          $Indirect_Expenses = $summary_info->indirect_expenses;
                          $Indirect_Incomes = $summary_info->indirect_incomes;

                          $Nett_Profit = $Gross_Profit + $Indirect_Incomes - $Indirect_Expenses;

                          $G_Debit_total = $Indirect_Expenses + $Nett_Profit;

                          $G_Credit_total = $Gross_Profit + $Indirect_Incomes;



                      @endphp
                      <tr>
                          <td>1</td>
                          <td colspan="2">Opening Balance</td>
                          <td class="rightside">{{ number_format($opening_stock,2) }}</td>

                          <td>1</td>
                          <td>Due</td>
                          <td class="rightside">{{ number_format($tp_total_sales,2) }}</td>
                      </tr>
                      <tr>
                          <td>2</td>
                          <td>Opening Stock</td>
                          <td class="rightside">{{ number_format($opening_stock,2) }}</td>
                          <td class="rightside">0</td>

                          <td>2</td>
                          <td>Commission</td>
                          <td class="rightside">{{ number_format($Direct_Incomes,2) }}</td>
                      </tr>
                      <tr>
                          <td>3</td>
                          <td>Products Received</td>
                          <td class="rightside">{{ number_format($total_received,2) }}</td>
                          <td class="rightside">0</td>

                          <td>3</td>
                          <td>Display Cost</td>
                          <td class="rightside">{{ number_format($tp_total_sales,2) }}</td>
                      </tr>
                      <tr>
                          <td>4</td>
                          <td>Closing Stock</td>
                          <td class="rightside">{{ number_format($closing_stock,2) }}</td>
                          <td class="rightside">0</td>

                          <td>4</td>
                          <td>Damage Return</td>
                          <td class="rightside">{{ number_format($Direct_Incomes,2) }}</td>
                      </tr>
                      <tr>
                          <td>5</td>
                          <td colspan="2">Today Products Sales</td>
                          <td class="rightside">{{ number_format($tp_total_sales,2) }}</td>

                          <td>5</td>
                          <td>Party Payment</td>
                          <td class="rightside">{{ number_format($closing_stock,2) }}</td>
                      </tr>
                      <tr>
                          <td>6</td>
                          <td colspan="2">Loan</td>
                          <td class="rightside">{{ number_format($closing_stock,2) }}</td>

                          <td>6</td>
                          <td>Cash Balance</td>
                          <td class="rightside">{{ number_format($total,2) }}</td>
                      </tr>
                      
                      <tr>
                          <td>7</td>
                          <td colspan="2">**</td>
                          <td class="rightside">{{ number_format($Indirect_Expenses,2) }}</td>

                          <td>7</td>
                          <td>**</td>
                          <td class="rightside">{{ number_format($Gross_Profit,2) }}</td>
                      </tr>
                      <tr>
                          <td>8</td>
                          <td colspan="2">**</td>
                          <td class="rightside">{{ number_format($Nett_Profit,2) }}</td>

                          <td>8</td>
                          <td>**</td>
                          <td class="rightside">{{ number_format($Indirect_Incomes,2) }}</td>
                      </tr>
                      <tr>
                          <th colspan="3">Total =</th>
                          <th class="rightside">{{ number_format($G_Debit_total,2) }}</th>
                          <th colspan="2">Total =</th>
                          <th class="rightside">{{ number_format($G_Credit_total,2) }}</th>
                      </tr>
                      
                  </tbody>
                </table>


              </div>
            </div>
        </div>
    </div>
<style>
    table#myTable thead#myHeader { background: #D9E5D8; color: #006C32; }
    div#myTablePrint table#myTable tbody tr td {  border: 1px solid; border-collapse: collapse;  height: 28px; font-size: 15px;}
    div#myTablePrint table#myTable .rightside {text-align: right; }
    div#myTablePrint table#myTable thead#myHeader tr th {border-collapse: collapse; border: 1px solid #000000!important;}
    div#myTablePrint table#myTable tbody tr th{border-collapse: collapse; border: 1px solid #000000!important; }
    thead th {border-collapse: collapse; border-right: 1px solid #000000 !important; }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr th {
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }

    table#myTablePrint thead#myHeader{
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr:last-child th{
        top: 32px;
    }
    thead#myHeader tr th { text-align: center;}
</style>

    <script>
        
         function printData()
            {
               var print_ = document.getElementById("myTablePrint");
               win = window.open("");
               win.document.write(print_.outerHTML);
               win.document.write('<style type="text/css"> ');
               win.document.write('.col-sm-12.text-center h2, h4, h5 {text-align: center; margin: 0;}');
               win.document.write('table {border-collapse: collapse;}');
               win.document.write('</style>');

               win.print();
               win.close();
            }


        function exportTableToExcel(tableID, filename = '',report_header='')
          {
              var downloadLink;
              var dataType = 'application/vnd.ms-excel';
              var tableSelect = document.getElementById(tableID);
              var tableHTML = '';

              if(report_header!='')
              {
                  tableHTML = $("#"+report_header).html();
              } else {
                  tableHTML = '';
              }

              tableHTML = tableHTML + tableSelect.outerHTML.replace(/ /g, '%20');

              // Specify file name
              filename = filename?filename+'.xls':'excel_data.xls';

              // Create download link element
              downloadLink = document.createElement("a");

              document.body.appendChild(downloadLink);

              if(navigator.msSaveOrOpenBlob){
                  var blob = new Blob(['\ufeff', tableHTML], {
                      type: dataType
                  });
                  navigator.msSaveOrOpenBlob( blob, filename);
              }else{
                  // Create a link to the file
                  downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

                  // Setting the file name
                  downloadLink.download = filename;

                  //triggering the function
                  downloadLink.click();
              }
          }
        
        jQuery( function($) {
            $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
            $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
        } );

        
    </script>
@endsection