@extends('layouts.reportSaleForm')
@section('report')
@if($result->count()>0)
  <table class="table" id="printTable" border="1">
    <caption style="text-align:left;">16.Sale summary report By Item cost profit  ระหว่างวันที่ {{$sdate}} ถึง {{$edate}}</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;">ชื่อสินค้า</th>
        <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;">ต้นทุน/ชิ้น</th>
        <th scope="col" style="font-size:12px;text-align:center;">รวมทุน</th>
        <th scope="col" style="font-size:12px;text-align:center;">กำไร</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:center;">{{$row->item_itmcd}}</th>
        <th scope="row" style="font-size:10px;text-align:left;">{{$row->item_name}}</th>
        <th scope="row" style="font-size:10px;text-align:center;">{{$row->qty}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->totam,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($row->cost,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($totalcost,2)}}</th>
        <th scope="row" style="font-size:10px;text-align:right;">{{number_format($profit,2)}}</th>
      </tr>
      @endforeach
      <tr>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row"></th>
        <th scope="row" style="font-size:12px;text-align:right;"></th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sumtotam,2)}}</th>
        <th scope="row"></th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sumcost,2)}}</th>
        <th scope="row" style="font-size:12px;text-align:right;">{{number_format($sumprofit,2)}}</th>
      </tr>
    </tbody>
  </table>
  {{ $result->appends(request()->query())->links() }}
</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