@extends('layouts.reportSaleForm')
@section('report')
@if($mhis_fil->count()>0)
  <table class="table" id="printTable" border="0">
    <caption style="text-align:left;">05 Rebate summary report Month {{$pmth}} Year {{$pyear}}</caption>
    <caption style="text-align:left;">วันที่เวลาพิมพ์ {{now()}}</caption>
    <thead class="thead-dark">
      <tr>
        <th scope="col" style="font-size:12px;text-align:center;">Member Name</th>
        <th scope="col" style="font-size:12px;text-align:center;">Member Code</th>
        <th scope="col" style="font-size:12px;text-align:center;">Bank</th>
        <th scope="col" style="font-size:12px;text-align:center;">A/C No.</th>
        <th scope="col" style="font-size:12px;text-align:center;">Post</th>
        <th scope="col" style="font-size:12px;text-align:center;">Rate</th>
        <th scope="col" style="font-size:12px;text-align:center;">Agent</th>
        <th scope="col" style="font-size:12px;text-align:center;">Dealer</th>

<th scope="col" style="font-size:12px;text-align:center;">Unity_1</th>
<th scope="col" style="font-size:12px;text-align:center;">unity_2</th>

        <th scope="col" style="font-size:12px;text-align:center;">Fund</th>
        <th scope="col" style="font-size:12px;text-align:center;">Total Rebate</th>
        <th scope="col" style="font-size:12px;text-align:center;">Net Rebate</th>
      </tr>
    </thead>
    <tbody>
            @foreach($mhis_fil as $row)
            <tr>
        <th scope="row" style="font-size:10px;text-align:left;">{{$row->name}}  {{$row->lastname}}</th>
        <th scope="row" style="font-size:10px;text-align:center;">{{$row->mcode}}</th>
        <th scope="row" style="font-size:10px;text-align:left;">{{$row->bnkcd}}</th>
        <th scope="row" style="font-size:10px;text-align:center;;">{{$row->bnkac}}</th>
        <th scope="row" style="font-size:10px;text-align:center;;">{{$row->mrank}}</th>
        <th scope="row" style="font-size:10px;text-align:center;;">{{$row->mrate}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;;">{{number_format($row->agent_bonus,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;;">{{number_format($row->dealer_bonus,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;;">{{number_format($row->unity_team1,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;;">{{number_format($row->unity_team2,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;;">{{number_format($row->fund_bonus,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;">{{number_format($row->fund_bonus + $row->agent_bonus + $row->dealer_bonus + $row->unity_team1 + $row->unity_team2,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;;">{{number_format($row->agent_bonus + $row->dealer_bonus + $row->unity_team1 + $row->unity_team2 ,2)}}</th>
      </tr>
      @endforeach
      <tr>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_fund,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_agent,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_dealer,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_u1,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_u2,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_total,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sump_net,2)}}</th>
      </tr>
    </tbody>
  </table>
  {{ $mhis_fil->appends(request()->query())->links() }}
</div>
@else
    <div class="alert alert-danger my-2">
          <p>ไม่มีข้อมูล Rebate ในระบบ</p>
    </div>
@endif
<script type="text/javascript">

$(function(){
  $("#datestart").datepicker({
    dateFormat: 'yy-mm-dd',
    numberOfMonths: 1,
  });

  $("#dateend").datepicker({
    dateFormat: 'yy-mm-dd',
    numberOfMonths: 1,
  });

});

function printData()
{
   var divToPrint=document.getElementById("printTable");
   newWin= window.open("");
   newWin.document.write(divToPrint.outerHTML);
   newWin.print();
   newWin.close();
}

$(document).ready(function () {
  $('#select_report').val("5");
  $("#div_preriod").show();
  $("#div_date").hide();
})


</script>
@endsection