@extends('layouts.reportSaleForm')
@section('report')
@if($result)
  <table class="table" id="printTable" border="1">
    <caption style="text-align:left;">12.Sale Detail Report By Item วันที่ {{$sdate}} - {{$edate}}</caption>
    <caption style="text-align:left;">Item : {{$sitem}} -  {{$eitem}}</caption>
    <caption style="text-align:left;">วันที่เวลาพิมพ์ {{now()}}</caption>
    <thead class="thead-dark">
      <tr>
        <th scope="col" style="font-size:12px;text-align:center;">Item</th>
        <th scope="col" style="font-size:12px;text-align:center;">Invoice no.</th>
        <th scope="col" style="font-size:12px;text-align:center;">Date</th>
        <th scope="col" style="font-size:12px;text-align:center;">Cus Name</th>
        <th scope="col" style="font-size:12px;text-align:center;">Qty.</th>
        <th scope="col" style="font-size:12px;text-align:center;">Amount</th>
      </tr>
    </thead>
    <tbody>
            @foreach($result as $row)
            <tr>
        <th scope="row" style="font-size:12px;text-align:center;" >{{$row->item_itmcd}}</th>
        <th scope="row" style="font-size:12px;text-align:center;" colspan="3">{{$row->item_name}}</th>
        <th scope="row" style="font-size:12px;text-align:center;">{{number_format($row->sum_amount)}}</th>
        <th scope="row" style="font-size:12px;text-align:center;">{{number_format($row->sum_price)}}</th>
      </tr>
          @foreach($result_detail as $row_detail)
            @if($row_detail->item_itmcd == $row->item_itmcd)
              <tr>
                <th></th>
                <th scope="row" style="font-size:10px;text-align:center;">{{$row_detail->order_id}}</th>
                <th scope="row" style="font-size:10px;text-align:center;">{{$row_detail->date}}</th>
                <th scope="row" style="font-size:10px;text-align:center;">{{$row_detail->fname}}  {{$row_detail->lname}}</th>
                <th scope="row" style="font-size:10px;text-align:center;">{{number_format($row_detail->item_amount)}}</th>
                <th scope="row" style="font-size:10px;text-align:center;">{{number_format($row_detail->sum_amount_bill)}}</th>
              </tr>
            @endif
          @endforeach
      @endforeach
    </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