@extends('layouts.app')
@section('title') {{'Monthly Commission Report'}} @endsection
@section('content')

    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Monthly Commission Report
            </div>

            <div class="panel-body">
            <div class="form-group">
            <form action="" method="get" autocomplete="off">
                <div class="form-group">
                    <div class="col-md-3">
                        Search By Department
                       <select name="department_id" id="department_id" data-live-search="true" class="form-control selectpicker">
                            <option value=""> Search </option>
                            @if(isset($departments_list))
                                @foreach($departments_list as $val)
                                    <option value="{{ $val->department_id}}"  @if(isset($_GET['department_id']) && $_GET['department_id'] == $val->department_id) selected="selected" @endif>  {{ $val->department_name }}</option>
                                @endforeach
                            @endif
                        </select>
                    </div>
                    
                    <div class="col-md-2">
                        Start Date
                        <input id="start_date" type="text" class="form-control" autocomplete="off" name="start_date" value="{!! @$_GET['start_date'] !!}" required >
                    </div>
                    
                    <div class="col-md-2">
                        End Date
                        <input id="end_date" type="text" class="form-control" autocomplete="off" name="end_date" value="{!! @$_GET['end_date'] !!}" required >
                    </div>
                    <div class="col-md-2">
                        <br/> &nbsp;
                        <button type="submit" class="btn btn-success">Search</button>
                    </div>
                </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 class="form-group mt-1" style="width:100%; overflow: scroll;" >

                @if (Session::has('msg'))
                    <div class="alert alert-info">{{ Session::get('msg') }}</div>
                @endif
                {{ $product_list->withPath('?'.$link) }}
                <table id="myTablePrint" class="table table-striped table-hover mt-1">
                    <thead class="header" id="myHeader">
                    <tr>
                        <th> S.N.</th>
                        <th> ID </th>
                        <th> Name </th>
                        <th> Sales </th>
                        @if (Auth::user()->parent_id == "0")
                        <th> DP Rate </th>
                        <th> DP Taka </th>
                        @endif
                        <th> TP Rate </th>
                        <th> TP Taka </th>
                        <th> Commission </th>
                    </tr>
                    </thead>
                    <tbody>
                    @php $i=1; 

                        $TotalClosingSalesTK = 0;
                        $TotalCommission = 0;

                        $TotalClosingDpTK =0;
                        $TotalClosingTpTK =0;

                    @endphp
                    @if(isset($product_list[0]))
                        @foreach($product_list as $row)
                          @if($row->product_sales>0 && $row->commission>0)
                            @php 
                              
                              $ClosingSalesTK = $row->product_sales;
                              $Commission = $row->commission;

                              $ClosingDpTK = $ClosingSalesTK * $row->dp_price;
                              $ClosingTpTK = $ClosingSalesTK * $row->tp_price;
                              
                              $TotalClosingSalesTK += $ClosingSalesTK;
                              $TotalCommission += $Commission;

                              $TotalClosingDpTK += $ClosingDpTK;
                              $TotalClosingTpTK += $ClosingTpTK;

                            @endphp
                            

                            <tr>
                                <td>{{$i++}}</td>
                                <td>{{$row->id}}</td>
                                <td>{{$row->product_name}}</td>
                                <td>{{ number_format($ClosingSalesTK,2)}} {{ ($row->pack_type)}}</td>
                                @if (Auth::user()->parent_id == "0")
                                <td>{{ number_format($row->dp_price,2)}}</td>
                                <td>{{ number_format($ClosingDpTK,2)}}</td>
                                @endif
                                <td>{{ number_format($row->tp_price,2)}}</td>
                                <td>{{ number_format($ClosingTpTK,2)}}</td>
                                <td>{{ number_format($Commission,2)}}</td>
                            </tr>
                            @endif
                        @endforeach
                        <tr>
                            <th colspan="3"> Total Taka = </th>
                            <th>{{ number_format($TotalClosingSalesTK,2) }}</th>
                            @if (Auth::user()->parent_id == "0")
                            <th></th>
                            <th>{{ number_format($TotalClosingDpTK,2) }}</th>
                            @endif
                            <th></th>
                            <th>{{ number_format($TotalClosingTpTK,2) }}</th>
                            <th>{{ number_format($TotalCommission,2) }}</th>
                        </tr>
                    @endif
                    </tbody>
                </table>

                    {{ $product_list->withPath('?'.$link) }}

              </div>
            </div>
        </div>
    </div>
<style>
    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;
    }
</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();
              }
          }
        function valueReset() {
                location.href = "http://localhost/store/public/dailysummaryreport";
            }

            $(window).scroll(function() {
            var scroll = $(window).scrollTop();

            if (scroll >= 100) {
                $("table#myTable").addClass("fixedHeader");
            } else {
                $("table#myTable").removeClass("fixedHeader");
            }
        });
        jQuery( function($) {
            $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
            $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
        } );

        
    </script>
@endsection