@php
$filename = $quotation->jobcode."_Job_confirm";
header("Content-Type: application/x-msexcel; charset=UTF-8");
header("Content-Disposition: attachment; filename=$filename.xls");
header("Pragma: no-cache");
header("Expires: 0");
@endphp
<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />

<table width="100%" border="0" align="center">
  <tr>
    <td width="13%"  align="right"><strong>Job Tpye : </strong></td>
    <td width="22%" > {{trans('custom.quotation.type.'.$quotation->job_type)}} </td>
    <td width="9%"  align="right"><strong>Status : </strong></td>
    <td width="21%" >
        @if ($quotation->jobstatus == 0)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 1)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 2)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 3)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 4)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 20)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 21)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 22)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 23)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 98)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @elseif($quotation->jobstatus == 99)
        {{trans('custom.job.status.'.$quotation->jobstatus)}}
        @endif
    </td>
    <td width="13%"  align="right"><strong>Created At :</strong></td>
    <td width="22%" >{{$quotation->jobcreatedat }}</td>
  </tr>
  <tr>
    <td align="right"><strong>Quotation / Job Code :</strong></td>
    <td>{{$quotation->job_code}} / {{$quotation->jobcode}}</td>
    <td align="right"><strong>Total Quantity :</strong></td>
    <td>@convertnodecimal($quotation->real_quantity)</td>
    <td align="right"><strong>Created By :</strong></td>
    <td>{{$quotation->jobcreatedname}}</td>
  </tr>
  <tr>
    <td align="right"><strong>Job Name : </strong></td>
    <td>{{$quotation->jobname}}</td>
    <td align="right"><strong>Print Type :</strong></td>
    <td>{{trans('custom.job.printtype.'.$quotation->print_type)}}</td>
    <td align="right"><strong>Job SLA Date :</strong></td>
    <td>{{$quotation->job_finish_date}}</td>
  </tr>
  <tr>

    <td align="right">
      <strong>
          @if ($quotation->job_type == 1)
           Billing Cycle :
          @endif
      </strong>
    </td>
    <td>
      @if ($quotation->job_type == 1)
      {{$statement->bill_cycle}}
      @endif
      </td>
    <td align="right"><strong>
      @if ($quotation->job_type == 1)
      Seal :
      @endif
    </strong></td>
    <td>
        @if ($quotation->job_type == 1)
        @convertnodecimal($statement->seal_quantity)
        @endif
    </td>
    <td align="right"><strong>Job SLA Time :</strong></td>
    <td>{{$quotation->job_finish_time}}</td>
  </tr>
  <tr>
    <td align="right"><strong>Frequency deliver job :</strong></td>
    <td>{{$quotation->frequency_quantity}} / {{$quotation->frequency_unit}}</td>
    <td align="right"><strong>
      @if ($quotation->job_type == 1)
      Wrapping :
      @endif
    </strong></td>
    <td>
        @if ($quotation->job_type == 1)
        @convertnodecimal($statement->warpping_quantity)
        @endif
    </td>
    <td align="right"><strong>Shipping Date :</strong></td>
    <td>{{$quotation->shipping_date}}</td>
  </tr>
  <tr>
    <td align="right"><strong>Owner Name :</strong></td>
    <td>{{$quotation->owner_name}}</td>
    <td align="right"><strong>
      @if ($quotation->job_type == 1)
      Envelops :
      @endif
    </strong></td>
    <td>
      @if ($quotation->job_type == 1)
        @convertnodecimal($statement->envelops_quantity)
        @endif
      </td>
    <td align="right"><strong>Shipping Time :</strong></td>
    <td>{{$quotation->shipping_time}}</td>
  </tr>
  <tr>
    <td align="right"><strong>Department : </strong></td>
    <td>{{$quotation->department}}</td>
    <td align="right"><strong>
      @if ($quotation->job_type == 1)
      Mail Group :
      @endif
    </strong></td>
    <td>@if ($quotation->job_type == 1)
        @convertnodecimal($statement->mailgroup_quantity)
        @endif</td>
    <td align="right"><strong>Job_Note : </strong></td>
    <td>{{$quotation->jobnote}}</td>
  </tr>
  <tr>
    <td align="right"><strong>Cost Center / Network :</strong></td>
    <td>{{$quotation->cost_center}} / {{$quotation->network}}</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="right"><strong>Shipping Method :</strong></td>
    <td>{{trans('custom.quotation.shipping.'.$quotation->shipping_method)}}</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="100%" border="1">
  <tr align="center" bgcolor="#CCCCCC">
    <td>Process Name</td>
    <td>Process Detail</td>
    <td>Machine Detail</td>
    <td>Capacity per hour</td>
    <td>Hour per day</td>
    <td>Capacity per day</td>
    @if ($quotation->job_type == 2  && isset($quantity))
          <td>
              Quantity
          </td>
    @endif
  </tr>
  {{$check = null}}
  @foreach ($process as $item)


  <tr>
       <td>
           @if ($check != $item->process_name)
           {{$item->process_name}}
           @endif
           <input type="hidden" name="processid[]" id="processid" value="{{$item->id}}">
       </td>
       <td> {{$item->process_detail}} </td>
       <td>
               {{$item->machine_detail}}
       </td>

       <td>

               @convertnodecimal($item->capacity_per_hour)
       </td>
       <td>

                   {{$item->hour_per_day}}
       </td>
       <td>

               @convertnodecimal($item->capacity_per_day)

       </td>


      @if ($quotation->job_type == 2  && isset($quantity))
      @foreach ($quantity as $itemz)
          @if ($itemz->process_id == $item->id)
          <td>
              {{$itemz->quantity}}
          </td>
          @endif
      @endforeach
      @endif

</tr>

@php
$check = $item->process_name
@endphp
@endforeach
</table>
<table><tr><td></td></tr></table>
<table width="100%" border="1">
  <tr align="center" bgcolor="#CCCCCC">
      <td>No.</td>
      <td>Material Code</td>
      <td>Material Name</th>
  </tr>
  @foreach ($material as $item)
  <tr>
          <td>{{$loop->iteration}}</td>
          <td> @if (substr($item->material_code, 0, 1) === '0')
              '{{$item->material_code}}
               @else
               {{$item->material_code}}
              @endif </td>
          <td> {{$item->material_name}} </td>
  </tr>
@endforeach
</table>