Voucher Stock List

@if(is_array($voucher_gramasi_stocks) || is_object($voucher_gramasi_stocks)) @foreach($voucher_gramasi_stocks as $list) @endforeach @endif @if(is_array($voucher_nominal_stocks) || is_object($voucher_nominal_stocks)) @foreach($voucher_nominal_stocks as $list) @endforeach @endif

ID	Amount	Type	Qty	Belum Terpakai	Terpakai
{{ $list->id }}	{{ number_format($list->gramasi_amount,4) }} gram	{{ $list->type }}	{{ $list->qty }} @php $havent_used_grams_voucher = DB::table('voucher_sales_order_invoice_item') ->join('campaign_voucher_barcode', 'voucher_sales_order_invoice_item.id_campaign_voucher_barcode', '=', 'campaign_voucher_barcode.id') ->join('campaign_voucher', 'campaign_voucher.id', '=', 'campaign_voucher_barcode.id_campaign_voucher') ->where('voucher_sales_order_invoice_item.deleted_at', '=', null) ->where('campaign_voucher_barcode.location', '>=', 0) ->where('campaign_voucher.gram', '=', $list->gramasi_amount) ->where('campaign_voucher_barcode.type', '=', $list->type) ->where('campaign_voucher.status', '=', 0) ->count(); $used_grams_voucher = DB::table('voucher_sales_order_invoice_item') ->join('campaign_voucher_barcode', 'voucher_sales_order_invoice_item.id_campaign_voucher_barcode', '=', 'campaign_voucher_barcode.id') ->join('campaign_voucher', 'campaign_voucher.id', '=', 'campaign_voucher_barcode.id_campaign_voucher') ->where('voucher_sales_order_invoice_item.deleted_at', '=', null) ->where('campaign_voucher_barcode.location', '>=', 0) ->where('campaign_voucher.gram', '=', $list->gramasi_amount) ->where('campaign_voucher_barcode.type', '=', $list->type) ->where('campaign_voucher.status', '=', 1) ->count(); @endphp	{{ $havent_used_grams_voucher }}	{{ $used_grams_voucher }}
{{ $list->id }}	Rp. {{ number_format($list->nominal_amount,2 ) }}	{{ $list->type }}	{{ $list->qty }} @php $havent_used_nominal_voucher = DB::table('voucher_sales_order_invoice_item') ->join('campaign_voucher_barcode', 'voucher_sales_order_invoice_item.id_campaign_voucher_barcode', '=', 'campaign_voucher_barcode.id') ->join('campaign_voucher', 'campaign_voucher.id', '=', 'campaign_voucher_barcode.id_campaign_voucher') ->where('voucher_sales_order_invoice_item.deleted_at', '=', null) ->where('campaign_voucher_barcode.location', '>=', 0) ->where('campaign_voucher.nominal', '=', $list->nominal_amount) ->where('campaign_voucher_barcode.type', '=', $list->type) ->where('campaign_voucher.status', '=', 0) ->count(); $used_nominal_voucher = DB::table('voucher_sales_order_invoice_item') ->join('campaign_voucher_barcode', 'voucher_sales_order_invoice_item.id_campaign_voucher_barcode', '=', 'campaign_voucher_barcode.id') ->join('campaign_voucher', 'campaign_voucher.id', '=', 'campaign_voucher_barcode.id_campaign_voucher') ->where('voucher_sales_order_invoice_item.deleted_at', '=', null) ->where('campaign_voucher_barcode.location', '>=', 0) ->where('campaign_voucher.nominal', '=', $list->nominal_amount) ->where('campaign_voucher_barcode.type', '=', $list->type) ->where('campaign_voucher.status', '=', 1) ->count(); @endphp	{{ $havent_used_nominal_voucher }}	{{ $used_nominal_voucher }}

{{--

@if($voucher_stocks) {{ $voucher_stocks->appends($_GET)->links("pagination::bootstrap-4") }} @endif

--}}