000

<table>
	<thead>
	<tr>
	    <th>SNo</th>
	    <th>Item Code</th>
	    <th>Item Description</th>
		<th>HSN Code</th>
	    <th>Product Category</th>
	    <th>Product Type</th>
	    <th>Ware House </th>
	    <th>Zone</th>
	    <th>Engg. Name </th>
	    <th>Bin</th>
	    <th>Qty</th>
	    <th>Rate</th>
	    <th>Value</th>
	    <th>UOM</th>
	    <th>LOT NO</th>
	    <th>Item Type</th>
	    <th>Transaction Type</th>
		<th>Creation Date</th>
		<th>Ageing As per Creation Date</th>
	  </tr>
	</thead>
	<tbody>
	@foreach($stocks as $key => $stock)
	<tr>
			<td>{{$key+1}}</td>
			<td>{{$stock->spare_code}}</td>
			<td>{{$stock->description}}</td>
			<td>{{$stock->hsn}}</td>
			<td>{{$stock->category}}</td>
            <td>{{$stock->product_type}}</td>
			<td>{{$stock->warehouse}}</td>
			 <td>@if($stock->zone == 'ENG') {{$stock->engineer_id}} @else {{strtoupper($stock->zone)}} @endif</td>
                  <td>@if($stock->zone == 'PT') PULL THROUGH @elseif( $stock->zone == 'TRC') REPAIRED ITEMS @elseif( $stock->zone == 'ENG') {{$stock->StaffName}}   @else {{strtoupper($stock->item_type)}} SPARES ZONE @endif</td>
				  @if(in_array($stock->warehouse, ["SERJNK","SERHMP","SERDEL","SERDel","SERPJB","SERUPE","SUPPNT","SERBHR","SERNOE","SERASM","SERWBL","SERORI","SERMPD","SERMAH","SERKTK","SERKRL","SERTMN","SERTGN","SERUPW","SERAPD","SERJHR","INDIMEBAY","INDIMENND","INDIMEBAT","INDIMEASR","INDIMEPTL","INDIMEFZP","INDIMEHSP","SERPNT", "SUPPNT", "SERHAR", "SERRAJ","TNLO&MDEL","ATCO&MDEL","TVIO&MDEL"]))
                  <td>{{strtoupper($stock->item_type)}}</td>
                  @elseif($stock->warehouse == "Scrap Zone")
                  <td>{{$stock->scrap_bin}}</td>
                  @else
                  <td></td>
                  @endif
			<td>{{$stock->qty}}</td>
			<td>{{$stock->rate}}</td>
			<td>{{$stock->qty*$stock->rate}}</td>
			<td>{{$stock->uom}}</td>
			<td>{{$stock->lot_no}}</td>
			<td>{{$stock->type}}</td>
			<td></td>
            <td>{{$stock->created_at}}</td>
            <td>
                      @php
                        $date1 = date_create(date('Y-m-d H:i:s'));
                        $date2 = date_create($stock->created_at);
                        $diff = date_diff($date1, $date2);
                        echo $diff->format("%a days");
                      @endphp
            </td>
		</tr>
	@endforeach
	</tbody>
</table>