@if($web->web_logo == '' || $web->web_logo == 'default.png')
@else
@endif
{{ $item->proyek->divisi->perusahaan->kode_perusahaan }}-ASET-BRG_ALL{{Carbon::parse($tglawal)->translatedFormat('d-m-Y')}}/{{Carbon::parse($tglakhir)->translatedFormat('d-m-Y')}}
@if($web->web_logo == '' || $web->web_logo == 'default.png')
}})
@else
@endif
{{ $item->proyek->divisi->nama_divisi }}
{{ $item->proyek->nama_proyek }}
Laporan Barang Masuk {{ $item->nama_sub_divisi }}
@if($tglawal == '')
Semua Tanggal
@else
{{-- {{Carbon::parse($tglawal)->translatedFormat('d F Y')}} - {{Carbon::parse($tglakhir)->translatedFormat('d F Y')}}
--}}
@endif
Tanggal {{Carbon::parse($tglawal)->translatedFormat('d-m-Y')}} s/d {{Carbon::parse($tglakhir)->translatedFormat('d-m-Y')}}
| NO |
KODE BARANG |
NAMA BARANG |
MEREK |
JUMLAH MASUK |
JUMLAH KELUAR |
TOTAL STOK |
@php $no=1; @endphp
@foreach($data as $d)
@php
// Barang Masuk
$jmlmasuk = Consumable_In::leftJoin('consumables', 'consumables.id', '=', 'consumable__ins.consumable_id')->whereBetween('tanggal', [$tglawal, $tglakhir])->where('consumable__ins.consumable_id', '=', $d->id)->sum('consumable__ins.jumlah');
// Barang Keluar
$jmlkeluar = Consumable_Out::leftJoin('consumables', 'consumables.id', '=', 'consumable__outs.consumable_id')->whereBetween('tanggal', [$tglawal, $tglakhir])->where('consumable__outs.consumable_id', '=', $d->id)->sum('consumable__outs.jumlah');
// Total Barang
$brgmasuk = Consumable_In::leftJoin('consumables', 'consumables.id', '=', 'consumable__ins.consumable_id')->where('consumable__ins.consumable_id', '=', $d->id)->sum('consumable__ins.jumlah');
$brgkeluar = Consumable_Out::leftJoin('consumables', 'consumables.id', '=', 'consumable__outs.consumable_id')->where('consumable__outs.consumable_id', '=', $d->id)->sum('consumable__outs.jumlah');
$jumlah = $brgmasuk - $brgkeluar
@endphp
| {{$no++}} |
{{$d->kode_barang}} |
{{$d->nama_barang}} |
{{$d->merek}} |
{{$jmlmasuk}} |
{{$jmlkeluar}} |
{{$jumlah }} |
@endforeach