@extends('layouts.report') @section('title', '発注書') @section('content') @php $RECORDS_PER_PAGE = 16; $suppliers = [ 'L' => ['basePapers' => [], 'dateStart' => null, 'dateEnd' => null, 'totalPrice' => 0, 'name' => 'リンテック',], '紙' => ['basePapers' => [], 'dateStart' => null, 'dateEnd' => null, 'totalPrice' => 0, 'name' => '紙弘',], '丸' => ['basePapers' => [], 'dateStart' => null, 'dateEnd' => null, 'totalPrice' => 0, 'name' => '丸昌化学',], 'マ' => ['basePapers' => [], 'dateStart' => null, 'dateEnd' => null, 'totalPrice' => 0, 'name' => 'マルウ接着',], '日' => ['basePapers' => [], 'dateStart' => null, 'dateEnd' => null, 'totalPrice' => 0, 'name' => '日榮新化',], ]; $page = [ 'L' => [], '紙' => [], '丸' => [], 'マ' => [], '日' => [], ]; foreach($viewdata['basePapers'] as $basePaper) { $supplierCode = $basePaper['attributes']['supplier']; if (isset($suppliers[$supplierCode])) { if($basePaper['attributes']['Type'] == 'Treatment') { $basePaper['price'] = $basePaper['attributes']['size_unit_price']; } else { $basePaper['price'] = floor(($basePaper['attributes']['size_w'] * $basePaper['attributes']['size_l'] * $basePaper['attributes']['size_unit_price']) / 1000); } $page[$supplierCode][] = $basePaper; $suppliers[$supplierCode]['totalPrice'] += $basePaper['price']; // 発注日の範囲を調べる if ($basePaper['purchase_date'] != null) { $purchaseDate = date('Y-m-d', strtotime($basePaper['purchase_date'])); $basePaper['purchase_date_d'] = $purchaseDate; if ($purchaseDate < $suppliers[$supplierCode]['dateStart'] || $suppliers[$supplierCode]['dateStart'] == null) { $suppliers[$supplierCode]['dateStart'] = $purchaseDate; } if ($suppliers[$supplierCode]['dateEnd'] < $purchaseDate || $suppliers[$supplierCode]['dateEnd'] == null) { $suppliers[$supplierCode]['dateEnd'] = $purchaseDate; } } else { $basePaper['purchase_date_d'] = '-'; } if (count($page[$supplierCode]) >= $RECORDS_PER_PAGE) { $suppliers[$supplierCode]['basePapers'][] = $page[$supplierCode]; $page[$supplierCode] = []; } } } foreach($suppliers as $supplierCode => $supplier) { if (count($page[$supplierCode]) > 0) { $suppliers[$supplierCode]['basePapers'][] = $page[$supplierCode]; $page[$supplierCode] = []; } } @endphp @foreach($suppliers as $supplier) @include('purchase/report01-01',[ 'SupplierPurchase'=>$supplier, ]) @endforeach @endsection