@extends('layouts.reportSaleForm')
@section('report')
@if($result)
  <table class="table" id="printTable" border="1">
    <caption style="text-align:left;">15.รายงานสรุปรายได้สมาชิก ประจำปี {{$year}} เดือน {{$month}} </caption>
    <caption style="text-align:left;">วันที่เวลาพิมพ์ {{now()}}</caption>
    <thead class="thead-dark">
      <tr>
        <th scope="col" style="font-size:12px;text-align:center;">ลำดับ</th>
        <th scope="col" style="font-size:12px;text-align:center;">ชื่อ-สกุล</th>
        <th scope="col" style="font-size:12px;text-align:center;">TP1</th>
        <th scope="col" style="font-size:12px;text-align:center;">TP2</th>
        <th scope="col" style="font-size:12px;text-align:center;">LI</th>
        <th scope="col" style="font-size:12px;text-align:center;">LI S</th>
        <th scope="col" style="font-size:12px;text-align:center;">Deduct</th>
        <th scope="col" style="font-size:12px;text-align:center;">Deduct Rem.</th>
        <th scope="col" style="font-size:12px;text-align:center;">Total</th>
      </tr>
    </thead>
    <tbody>
            @foreach($result as $row)
            <tr>
        <th scope="row" style="font-size:10px;text-align:left;">{{$i}}</th>
        <th scope="row" style="font-size:10px;text-align:left;">{{$row->m_name}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->t_tp1)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->t_tp2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->t_li)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->t_li_s)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->deduct)}}</th>

        @php
            $remark = App\Http\Controllers\Admin\ReportController::get_remark_deduct($row->id,$year,$month);
        @endphp

        <th scope="row" style="font-size:10px;text-align:right;">{{$remark}}</th>
                <th scope="row" style="font-size:10px;text-align:right;">{{number_format($total)}}</th>
      </tr>
      @endforeach
      <tr>
        <th scope="row" style="font-size:12px;text-align:right;"></th>
        <th scope="row" style="font-size:12px;text-align:right;"></th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_tp1)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_tp2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_li)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_li_s)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_deduct)}}</th>
        <th scope="row"></th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sum_total)}}</th>
      </tr>
    </tbody>
  </table>

</div>
@else
    <div class="alert alert-danger my-2">
          <p>ไม่มีข้อมูลในระบบ</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();
}

</script>
@endsection