@extends('master') @section('content') @if(session('success')) @endif @if(session('error')) @endif @if(session('verification_alert'))
| Last Usage | Item Code | Item Description | UOM | Master | Micro | CPO | CI | Total Stock | View | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| @php $sublabUpdates = [ 'Mikro' => $item['last_usage_mikro'], 'CPO' => $item['last_usage_cpo'], 'CI' => $item['last_usage_ci'] ]; $latestSublab = null; $latestUpdatedAt = null; foreach ($sublabUpdates as $sublab => $date) { if ($date && (!$latestUpdatedAt || $date > $latestUpdatedAt)) { $latestUpdatedAt = $date; $latestSublab = $sublab; } } @endphp {!! $latestUpdatedAt ? \Carbon\Carbon::parse($latestUpdatedAt)->format('d-m-Y H:i') . ' (' . $latestSublab . ')' : 'Not Yet Usage' !!} | {{ $item['item_code'] }} | {{ $item['item_description'] }} | {{ $item['uom'] }} | @if($item['total_master'] > 0) @if(in_array($item['item_code'], ['LMLEYE07', 'LMLEYE06'])) {{ $item['total_master'] }} ({{ $item['total_master'] * 2 }}) @else {{ $item['total_master'] }} @endif @else {{ $item['total_master'] }} @endif | @if($item['total_mikro'] > 0) @if(in_array($item['item_code'], ['LMLEYE07', 'LMLEYE06'])) {{ $item['total_mikro'] }} ({{ $item['total_mikro'] * 2 }}) @else {{ $item['total_mikro'] }} @endif @else {{ $item['total_mikro'] }} @endif | @if($item['total_cpo'] > 0){{ $item['total_cpo'] }}@else{{ $item['total_cpo'] }}@endif | @if($item['total_ci'] > 0){{ $item['total_ci'] }}@else{{ $item['total_ci'] }}@endif |
|
@php
$hasVsm = false;
$minMaxMikro = \App\Models\MinMaxMikroModels::where('item_code', $item['item_code'])->first();
$minMaxCPO = \App\Models\MinMaxCPOModels::where('item_code', $item['item_code'])->first();
$minMaxCI = \App\Models\MinMaxCIModels::where('item_code', $item['item_code'])->first();
if (($minMaxMikro && $minMaxMikro->vsm === 'yes') ||
($minMaxCPO && $minMaxCPO->vsm === 'yes') ||
($minMaxCI && $minMaxCI->vsm === 'yes')) {
$hasVsm = true;
}
@endphp
@if($hasVsm)
VSM
@endif
@php
$hasExpiringSoon = false;
// Check master items
foreach($item['master_items']->where('quantity', '>', 0) as $master) {
if(\Carbon\Carbon::parse($master->exp_date)->diffInDays(\Carbon\Carbon::now()) < 60 ||
\Carbon\Carbon::parse($master->exp_date)->isPast()) {
$hasExpiringSoon = true;
break;
}
}
// Check mikro items
foreach($item['mikro_items']->where('quantity', '>', 0) as $mikro) {
if(\Carbon\Carbon::parse($mikro->exp_date)->diffInDays(\Carbon\Carbon::now()) < 60 ||
\Carbon\Carbon::parse($mikro->exp_date)->isPast()) {
$hasExpiringSoon = true;
break;
}
}
// Check CPO items
foreach($item['cpo_items']->where('quantity', '>', 0) as $cpo) {
if(\Carbon\Carbon::parse($cpo->exp_date)->diffInDays(\Carbon\Carbon::now()) < 60 ||
\Carbon\Carbon::parse($cpo->exp_date)->isPast()) {
$hasExpiringSoon = true;
break;
}
}
// Check CI items
foreach($item['ci_items']->where('quantity', '>', 0) as $ci) {
if(\Carbon\Carbon::parse($ci->exp_date)->diffInDays(\Carbon\Carbon::now()) < 60 ||
\Carbon\Carbon::parse($ci->exp_date)->isPast()) {
$hasExpiringSoon = true;
break;
}
}
@endphp
@if($hasExpiringSoon)
emergency
@endif
|
|||||||||||||||||||||||||||||||||||||||||||||||||
|
@if($item['total_master'] > 0)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Tidak ada data tersedia | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||