EXCELIA_DBARR/custom/financialreport/class/financialreportformhelper.class.php

<?php
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Style\Alignment;

require_once DOL_DOCUMENT_ROOT . '/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php';
require_once DOL_DOCUMENT_ROOT . '/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/class/usernaplo.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/class/hotel.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/bbus/class/commissionhandler.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/financialreport/class/helper.class.php';


class FinancialreportFormHelper extends HelperUserInvoice
{
    public $db;
    public $colspan;

    public function __construct(DoliDB $db)
    {
        $this->db = $db;
        $this->colspan = 2;
    }

    public function summary($id, $fullCommissionHUF)
    {
        if ($fullCommissionHUF > 0) {
            global $langs;
            $summaryString = '';
            $summaryString .= '
                <tr>
                    <td colspan=' . $this->colspan . ' style="text-align: center;">
                        <div class="box">
                            <div class="center summary"> Summary </div>
                            <div style="height: 10%; color: rgb(163,0,51); margin-left: 40px; float: left;"> Currency </div>
                            <div style="height: 10%; color: rgb(10, 20, 100); text-align: right; padding-right: 40px;">' . $langs->trans('Commission') . '</div>
                            <div style="height: 15%; color: rgb(163,0,51); font-size: 30px; margin-left: 40px; float: left;">HUF</div>
                            <div style="height: 15%; color: rgb(163,0,51); font-size: 30px; text-align: right; padding-right: 40px;">' . $this->correctNumber($fullCommissionHUF) . '<sup style="font-size: 10px;"> HUF</sup></div>
                            <div>&nbsp;</div>';
                            /*<div>'  . $this->getFirstDateFromUserNaplo($id) . ' - ' . date('Y-m-d H:i:s') . '</div>*/
                            $summaryString .= '<div>&nbsp;</div>
                            
                        </div>
                    </td>
                </tr>
            ';
            print $summaryString;
        }
    }

}