Viewing file:  TrialBalancExport.php (5.64 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Exports;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;
use App\Models\Revenue;
use App\Models\BillProduct;
use App\Models\Customer;
use App\Models\BillAccount;
use App\Models\InvoiceProduct;
use App\Models\JournalItem;
use App\Models\Payment;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use Maatwebsite\Excel\Concerns\WithCustomStartCell;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
class TrialBalancExport implements FromArray , WithHeadings , WithStyles, WithCustomStartCell, WithColumnWidths, WithEvents
{
/**
* @return \Illuminate\Support\Collection
*/
public function __construct($data , $startDate, $endDate, $companyName)
{
$formattedData = [];
$totalDebit = 0;
$totalCredit = 0;
foreach($data as $key => $type)
{
$formattedData[] = [
'Account Name' => '',
'Account No' => '',
'Debit' => '',
'Credit' => '',
];
$formattedData[] = [
'Account Name' => $key,
'Account No' => '',
'Debit' => '',
'Credit' => '',
];
foreach($type as $account)
{
if($account['account'] == 'parent' || $account['account'] == 'parentTotal')
{
$formattedData[] = [
'Account Name' => ' '.$account['account_name'],
'Account No' => $account['account_code'],
'Debit' => $account['totalDebit'],
'Credit' => $account['totalCredit'],
];
}
else
{
$formattedData[] = [
'Account Name' => ' ' . $account['account_name'],
'Account No' => $account['account_code'],
'Debit' => $account['totalDebit'],
'Credit' => $account['totalCredit'],
];
}
if($account['account'] != 'parent' && $account['account'] != 'subAccount')
{
$totalDebit += $account['totalDebit'];
$totalCredit += $account['totalCredit'];
}
}
}
if($formattedData != [])
{
$formattedData[] = [
'Account Name' => 'Total',
'Account No' => '',
'Debit' => $totalDebit,
'Credit' => $totalCredit,
];
}
$this->data = $formattedData;
$this->startDate = $startDate;
$this->endDate = $endDate;
$this->companyName = $companyName;
}
public function startCell(): string
{
return 'A6';
}
public function columnWidths(): array
{
return [
'A' => 30,
'B' => 15,
'C' => 15,
'D' => 15,
];
}
public function styles(Worksheet $sheet)
{
$sheet->getStyle('A6')->getFont()->setBold(true);
$sheet->getStyle('B6')->getFont()->setBold(true);
$sheet->getStyle('C6')->getFont()->setBold(true);
$sheet->getStyle('D6')->getFont()->setBold(true);
}
public function array(): array
{
return $this->data;
}
public function headings(): array
{
return [
"Account Name",
"Account No",
"Debit",
"Credit",
];
}
public function registerEvents(): array
{
return [
AfterSheet::class => function (AfterSheet $event) {
$event->sheet->getDelegate()->mergeCells('A2:D2');
$event->sheet->getDelegate()->mergeCells('A3:D3');
$event->sheet->getDelegate()->mergeCells('A4:D4');
$event->sheet->getDelegate()->setCellValue('A2', 'Trial Balance - ' . $this->companyName)->getStyle('A2')->getFont()->setBold(true);
$event->sheet->getDelegate()->setCellValue('A3', 'Print Out Date : ' . date('Y-m-d H:i'));
$event->sheet->getDelegate()->setCellValue('A4', 'Date : ' . $this->startDate . ' - ' . $this->endDate);
$startRow = 2;
$lastRow = $event->sheet->getHighestRow();
$event->sheet->getStyle('A' . $lastRow . ':Z' . $lastRow)->getFont()->setBold(true);
// $event->sheet->getStyle('A' . $startRow . ':Z' . $lastRow)->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$data = $this->data;
foreach ($data as $index => $row) {
if (isset($row['Account Name']) && ($row['Account Name'] == 'Assets' || $row['Account Name'] == 'Income' || $row['Account Name'] == 'Costs of Goods Sold' || $row['Account Name'] == 'Expenses' ||
$row['Account Name'] == 'Liabilities' || $row['Account Name'] == 'Equity')) {
$rowIndex = $index + 7; // Adjust for 1-based indexing and header row
$event->sheet->getStyle('A' . $rowIndex . ':D' . $rowIndex)
->applyFromArray([
'font' => [
'bold' => true,
],
]);
}
}
},
];
}
}
|