@php
	$week = $release_customer->week;
	$ajustes =  json_decode($release_customer->ajuste);
	$bom = $product->boms;
@endphp	

<div id="accordion" style="width:100%">
<div class="card">
	<div class="card-header" id="headingOne">
		<h5 class="mb-0">
			<button class="btn btn-link" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne" style="color:black">
				Producto PT MRP
			</button>
		</h5>
	</div>

	<div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordion">
		<div class="table-responsive">
			<table  class="table table-bordered" id="pt_mrp">
				<thead>
					<tr>
						<th>
							BL
						</th> 
					@for($i = $week; $i < 53; $i++)
						<th>
							CW{{ $i }}
						</th>    
					@endfor
					</tr>
				</thead> 
			<tbody>
					<tr>
						<td>
							{{ $BL['MRP'][0] }} 
						</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
					</tr>		
			</tbody>
			</table>
		</div>
	</div>
</div>
<div class="card">
	<div class="card-header" id="headingTwo">
	<h5 class="mb-0">
		<button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo" style="color:black">
		Producto PT MRP CAL
		</button>
	</h5>
	</div>
	<div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordion">
	<div class="table-responsive">
		<table  class="table table-bordered" id="pt_mrp">
			<thead>
				<tr>
					<th>
						{{ $product->no_part }}
					</th> 
					<th>BL</th>
					@for($i = $week; $i < 53; $i++)
						<th>
							CW{{ $i }}
						</th>    
					@endfor
				</tr>
			</thead> 
			<tbody>
				<tr>
					<th>
						Inicial
					</th>
					<td>
						{{ number_format($BL['inicial'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('inicial' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Consumo
					</th>
					<td>
						{{ number_format($BL['consumo'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('consumo' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						SS
					</th>
					<td>
						{{ number_format($BL['SS'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('SS' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Sta. Pack
					</th>
					<td>
						{{ number_format($BL['Sta. Pack'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('Sta. Pack' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Safety time
					</th>
					<td>
						{{ $BL['Safety time'][0] }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('Safety time' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ $value[$i] }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP 0
					</th>
					<td>
						{{ number_format($BL['MRP 0'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP 0' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP 1
					</th>
					<td>
						{{ number_format($BL['MRP 1'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP 1' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP 2
					</th>
					<td>
						{{ number_format($BL['MRP 2'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP 2' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Número
					</th>
					<td>
						{{ $BL['Número'][0] }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('Número' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ $value[$i] }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP 3
					</th>
					<td>
						{{ number_format($BL['MRP 3'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP 3' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP 4
					</th>
					<td>
						{{ number_format($BL['MRP 4'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP 4' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Ajuste
					</th>
					<td>
						{{ number_format($BL['Ajuste'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('Ajuste' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						MRP
					</th>
					<td>
						{{ number_format($BL['MRP'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('MRP' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
				<tr>
					<th>
						Final
					</th>
					<td>
						{{ number_format($BL['Final'][0]) }} 
					</td>
					@foreach($BL as  $key =>  $value)
						@if ('Final' == $key)
							@for ($i=$week; $i < 53; $i++)
								<td>{{ number_format($value[$i]) }}</td>
							@endfor
						@endif
					@endforeach
				</tr>
			</tbody>
		</table>
	</div>
	</div>
</div>

	<div class="card">
		<div class="card-header" id="headingThree">
			<h5 class="mb-0">
				<button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseThree" aria-expanded="false" aria-controls="collapseThree" style="color:black">
					Actualizar Ajuste MRP
				</button>
			</h5>
		</div>
		<div id="collapseThree" class="collapse" aria-labelledby="headingThree" data-parent="#accordion">
			
		<div class="table-responsive">
			<table  class="table table-bordered" id="editable">
				<thead>
					<tr>
						<tr>
							<td></td>
							@for($i = $week - 1; $i < 52; $i++)
								<th>
									CW{{ $i + 1 }}
								</th>    
							@endfor
						</tr>  
					</tr>
				</thead> 
				<tbody>
					<tr>
						<td>Ajuste</td>
						@if ($ajustes != null && $ajustes != 1) 
							@for($i = $week - 1; $i < 52; $i++)
								<td id="{{ $i }}"> {{ $ajustes[$i]->valor }} </td>
							@endfor
						@else
							@for($i= $week - 1 ; $i < 52; $i++)
								<td id="{{ $i }}"> 0 </td>
							@endfor
						@endif
					</tr>		
				</tbody>
			</table>
		</div>
		<div class="form-group col-sm-2">
			<a href="#" class="btn btn-primary" onClick="aplicarAjusteDirecto()">Aplicar ajuste</a>
		</div>
		</div>
	</div>

	<div class="card">
		<div class="card-header" id="headingFour">
			<h5 class="mb-0">
				<button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseFour" aria-expanded="false" aria-controls="collapseFour" style="color:black">
					Producto MP Exposion
				</button>
			</h5>
		</div>
	
		<div id="collapseFour" class="collapse" aria-labelledby="headingFour" data-parent="#accordion">
			<div class="table-responsive">
				<table  class="table table-bordered" id="pt_mrp">
					<thead>
						<tr>
							<th>
								POS
							</th> 
							<th>
								No. Parte
							</th> 
							<th>
								Descripción
							</th>
							<th>
								Material
							</th> 
							<th>
								Peso
							</th> 
							<th>
								Pieza por ensamble
							</th> 
							<th>
								BL
							</th>  
						@for($i = $week; $i < 53; $i++)
							<th>
								CW{{ $i }}
							</th>    
						@endfor
						</tr>
					</thead> 
				<tbody>
					<tr>
						@foreach($BL_Exposion as  $key =>  $value)
							<tr>
								@foreach($value as $key2 => $value2)
									@if($key2 < 6 || $key2 > 31)
										@if($key2 != 2)
											<td> {{number_format(floatval($value2))}} </td>
										@else
											<td> {{ $value2 }} </td>
										@endif
									@endif
								@endforeach
							</tr>
						@endforeach
						<br>
					<tr>	
				</tbody>
				</table>
			</div>
		</div>
	</div>
</div>

{{-- <h1>PT MRP</h1>
<div class="table-responsive">
	<table  class="table table-bordered" id="pt_mrp">
		<thead>
			<tr>
				<th>
					BL
				</th> 
				@for($i = $semana - 1; $i < 52; $i++)
					<th>
						CW{{ $i + 1 }}
					</th>    
				@endfor
			</tr>
		</thead> 
		<tbody>
			<tr>
				<td>
					{{ $BL[12] }} 
				</td>
				@foreach($semanas as  $key =>  $value)
					@if($key >= $semana)
						<td>
							{{ $value[12] }}
						</td>
					@endif
				@endforeach
			</tr>		
		</tbody>
	</table>
</div> --}}

{{-- <h1> PT MRP Cal</h1>
<div class="table-responsive">
<table  class="table table-bordered" id="pt_mrp_cal">
	<thead>
		<tr>
			<th>NP</th>
			<th>{{ $product->no_part }}	</th>
			<th>BL</th>
			@for($i = $semana - 1; $i < 52; $i++)
				<th>
					CW{{ $i + 1 }}
				</th>    
			@endfor
		</tr>
	</thead> 
	<tbody>
		@foreach($labels as  $key =>  $label)
			
				<tr>
					<td></td>
					<td>
						{{ $label }} 
					</td>
					<td>
						{{ $BL[$key]}} 
					</td>
					@foreach($semanas as $key2 =>  $value)
						@if($key2 >= $semana)
							<td>
								{{ $value[$key] }}
							</td>
						@endif	
					@endforeach
				</tr>	
			
		@endforeach
	</tbody>
</table>
</div> --}}

{{-- <h1>Actualizar Ajuste</h1>
<div class="table-responsive">
<table  class="table table-bordered" id="editable">
	<thead>
		<tr>
			<tr>
				<td></td>
				@for($i = $semana - 1; $i < 52; $i++)
					<th>
						CW{{ $i + 1 }}
					</th>    
				@endfor
			</tr>  
		</tr>
	</thead> 
	<tbody>
		<tr>
			<td>Ajuste</td>
			@if ($ajustes != null && $ajustes != 1) 
				@for($i = $semana - 1; $i < 52; $i++)
					<td id="{{ $i }}"> {{ $ajustes[$i]->valor }} </td>
				@endfor
			@else
				@for($i= $semana - 1 ; $i < 52; $i++)
					<td id="{{ $i }}"> 0 </td>
				@endfor
			@endif
		</tr>		
	</tbody>
</table>
</div> --}}

{{-- <div class="form-group col-sm-2">
    <a href="#" class="btn btn-primary" onClick="aplicarAjusteDirecto()">Aplicar ajuste</a>
</div>
<br>
<h1>MP Exposion</h1>
<div class="table-responsive">
<table  class="table table-bordered" id="mp_exposion">
	<thead>
		<tr>
			<th>Pos.</th>
			<th>No. parte</th>
			<th>Descripcion</th>
			<th>Material</th>
			<th>Dim.</th>
			<th>Peso Kg</th>
			<th>x ens</th>
			<th>BL</th>
			@for($i =  $semana - 1 ; $i < 52; $i++)
				<th>
					CW{{ $i + 1 }}
				</th>    
			@endfor
		</tr>
	</thead> 
	<tbody>
		@foreach($pos as  $key =>  $value1)
			<tr>
				<td>{{ $value1 }}</td>
				<td>
					{{ $no_parte[$key] }} 
				</td>
				<td>
					{{ $descripcion[$key] }} 
				</td>
				<td>
					{{ $material[$key] }} 
				</td>
				<td>
					{{ $dim[$key] }} 
				</td>
				<td>
					{{ $peso[$key] }} 
				</td>
				<td>
					{{ $x_ens[$key] }} 
				</td>
				<td>
					{{ $BL_Exposion[$key] }} 
				</td>

				@foreach($semanas_exposion as $key2 => $valuel2)
					@if($key2 >= $semana)
						<td>
							{{ $valuel2[$key] }}
						</td>
					@endif
				@endforeach
			</tr>		
		@endforeach	
	</tbody>
</table>

</div> --}}