@php 
		$new = [];
		$thSub = $data['size_sub'] + 2;
		$thSubSub = $data['size_sub_sub'] + 3;
		foreach($data['material_number'] as $values){
			$countSub = count($values->sub_char) == $data['size_sub'];
			if(!$countSub){
				$sisa = $data['size_sub'] - count($values->sub_char);
				for($i = 0; $i < $sisa; $i++){
					array_push($values->sub_char,'  ');
				}
			}

			$countSubSub = count($values->sub_sub_char) == $data['size_sub_sub'];
			if(!$countSubSub){
				$sisa = $data['size_sub_sub'] - count($values->sub_sub_char);
				for($i = 0; $i < $sisa; $i++){
					array_push($values->sub_sub_char,'  ');
				}
			}
			array_push($new, $values);
		}
@endphp
<table style="width:150%;table-layout:fixed;">
	<tr>
		<th colspan="7" style="background-color:#80ED99;color:white;text-align:center;border:0.5px solid white;">
			OLD MATERIAL DESCRIPTION
		</th>
		<th colspan="2" style="background-color:#8D2828;color:white;text-transfrom:uppercase;text-align:center;border:0.5px solid white;">
			Mapping for Material Number Digit 1-2
		</th>
		<th colspan="" style="background-color:#8D2828;color:white;text-transfrom:uppercase;text-align:center;border:0.5px solid white;">
			Mapping for Material Number Digit 3-4
		</th>
		<th colspan="" style="background-color:#8D2828;color:white;text-transfrom:uppercase;text-align:center;border:0.5px solid white;">
			Mapping for Material Number Digit 4-6
		</th>
		<th colspan="9" style="background-color:#8D2828;color:white;text-transfrom:uppercase;text-align:center;border:0.5px solid white;">
			Mapping for Material Number Digit 7-9
		</th>
	</tr>
	<tr>
		<th style="background-color:#80ED99;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold;">MATERIAL NUMBER</th>
		<th style="background-color:#80ED99;color:white;width:40px;text-align:center;border:0.5px solid white;font-weight:bold;">MATERIAL GROUP</th>
		<th style="background-color:#80ED99;color:white;width:18px;text-align:center;border:0.5px solid white;font-weight:bold;">UOM</th>
		<th style="background-color:#80ED99;color:white;width:18px;text-align:center;border:0.5px solid white;font-weight:bold;">PLANT</th>
		<th style="background-color:#80ED99;color:white;width:18px;text-align:center;border:0.5px solid white;font-weight:bold;">SITE</th>
		<th style="background-color:#80ED99;color:white;width:70px;text-align:center;border:0.5px solid white;font-weight:bold;">SHORT DESCRIPTION</th>
		<th style="background-color:#80ED99;color:white;width:210px;text-align:center;border:0.5px solid white;font-weight:bold;">LONG DESCRIPTION</th>
		<th style="background-color:#D54C4C;color:white;width:15px;text-align:center;border:0.5px solid white;font-weight:bold;">MAIN CODE</th>
		<th style="background-color:#D54C4C;color:white;width:50px;text-align:center;border:0.5px solid white;font-weight:bold;">MAIN DESCRIPTION</th>
		<th style="background-color:#D54C4C;color:white;width:10px;text-align:center;border:0.5px solid white;font-weight:bold;">SUB CODE</th>
		<th style="background-color:#D54C4C;color:white;width:40px;text-align:center;border:0.5px solid white;font-weight:bold;">SUB DESCRIPTION</th>
		@for($i = 0; $i < $data['size_sub']; $i++)
			<th style="background-color:#D54C4C;color:white;width:30px;text-align:center;border:0.5px solid white;font-weight:bold;">IRISH CHARACTERISTIC {{ $i+1}}</th>
		@endfor
		<th style="background-color:#D54C4C;color:white;width:15px;text-align:center;border:0.5px solid white;font-weight:bold;">SUB SUB CODE</th>
		<th style="background-color:#D54C4C;color:white;width:40px;text-align:center;border:0.5px solid white;font-weight:bold;">SUB SUB DESCRIPTION</th>
		@for($i = 0; $i < $data['size_sub_sub']; $i++)
			<th style="background-color:#D54C4C;color:white;width:30px;text-align:center;border:0.5px solid white;font-weight:bold;">IRISH CHARACTERISTIC {{ $i+1 }}</th>
		@endfor
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">MESC</th>
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">	DIGIT 7-9</th>
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">CODE</th>
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">DESCRIPTION</th>
		<th style="background-color:#D54C4C;color:white;width:25px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">MESC MATERIAL NUMBER</th>
		<th style="background-color:#D54C4C;color:white;width:70px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">IRISH MATERIAL DESCRIPTION(Short)</th>
		<th style="background-color:#D54C4C;color:white;width:210px;text-align:center;border:0.5px solid white;font-weight:bold;text-transform: uppercase">IRISH MATERIAL DESCRIPTION(Long)</th>
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">MATERIAL GROUP</th>
		<th style="background-color:#D54C4C;color:white;width:20px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">UoM</th>
		<th style="background-color:#D54C4C;color:white;width:30px;text-align:center;border:0.5px solid white;font-weight:bold; text-transform: uppercase">MANUFACTRURER PART NUMBERr</th>
	</tr>
	@foreach($new as $values)
	<tr>
		<td style="word-wrap:break-word;text-align:left">{{ $values->material_number }}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->material_group_source }}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->uom_source }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->plant }}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->site }}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->short_description_source }}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->long_description_source }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->main_code }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->main_description }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->sub_code }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->sub_description }}</td>
		@foreach($values->sub_char as $sub)
			<td>{{ $sub }}</td>
		@endforeach
        <td style="word-wrap:break-word;text-align:left">{{ $values->sub_sub_code }}</td>
        <td style="word-wrap:break-word;text-align:left">{{ $values->sub_sub_description }}</td>
		@foreach($values->sub_sub_char as $sub_sub)
			<td style="word-wrap:break-word;text-align:left">{{ $sub_sub}}</td>
		@endforeach
        <td style="word-wrap:break-word;text-align:left">{{$values->main_code}}{{$values->sub_code}}{{$values->sub_sub_code}}</td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->short_description_new}}</td>
		<td style="word-wrap:break-word;text-align:left">{{ $values->long_description_new}}</td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left"></td>
		<td style="word-wrap:break-word;text-align:left">
			@if($values->manref != null)
				@foreach($values->manref as $mn)
						{{ $mn }} <br>
				@endforeach
			@endif
		</td>
	</tr>
@endforeach
</table>