| 1234567891011121314151617181920212223242526272829 |
- <?php
- namespace App\Exports;
- use Maatwebsite\Excel\Concerns\WithMultipleSheets;
- class ProjectDepreciationMultipleSheetExport implements WithMultipleSheets
- {
- protected $data; // 格式:[ '2025-RD01' => [ 'project_name' => '...', 'months' => [ 1 => [...数据...], 2 => [...] ] ] ]
- public function __construct(array $data)
- {
- $this->data = $data;
- }
- public function sheets(): array
- {
- $sheets = [];
- foreach ($this->data as $groupKey => $payload) {
- // $groupKey 比如 "2025-RD01"
- $sheets[] = new ProjectDepreciationSheetExport(
- $groupKey,
- $payload['project_name'],
- $payload['months']
- );
- }
- return $sheets;
- }
- }
|