EXCELIA_DBARR/custom/financialreport/excelexportindex.php

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

/* Copyright (C) 2001-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2004-2015 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2012 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2015      Jean-François Ferry	<jfefe@aternatik.fr>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */

/**
 *	\file       settlements/settlementsindex.php
 *	\ingroup    settlements
 *	\brief      Home page of settlements top menu
 */


// Load Dolibarr environment

$res = 0;
// Try main.inc.php into web root known defined into CONTEXT_DOCUMENT_ROOT (not always defined)
if (!$res && !empty($_SERVER["CONTEXT_DOCUMENT_ROOT"])) {
    $res = @include $_SERVER["CONTEXT_DOCUMENT_ROOT"] . "/main.inc.php";
}
// Try main.inc.php into web root detected using web root calculated from SCRIPT_FILENAME
$tmp = empty($_SERVER['SCRIPT_FILENAME']) ? '' : $_SERVER['SCRIPT_FILENAME'];
$tmp2 = realpath(__FILE__);
$i = strlen($tmp) - 1;
$j = strlen($tmp2) - 1;
while ($i > 0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
    $i--;
    $j--;
}
if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1)) . "/main.inc.php")) {
    $res = @include substr($tmp, 0, ($i + 1)) . "/main.inc.php";
}
if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1))) . "/main.inc.php")) {
    $res = @include dirname(substr($tmp, 0, ($i + 1))) . "/main.inc.php";
}
// Try main.inc.php using relative path
if (!$res && file_exists("../main.inc.php")) {
    $res = @include "../main.inc.php";
}
if (!$res && file_exists("../../main.inc.php")) {
    $res = @include "../../main.inc.php";
}
if (!$res && file_exists("../../../main.inc.php")) {
    $res = @include "../../../main.inc.php";
}
if (!$res) {
    die("Include of main fails");
}
require_once DOL_DOCUMENT_ROOT . '/core/class/html.formfile.class.php';
require_once DOL_DOCUMENT_ROOT . '/user/class/usergroup.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/class/groupusers.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/financialreport/class/helper.class.php';


$helper = new HelperUserInvoice($db);

// Load translation files required by the page
$langs->loadLangs(array("financialreport@financialreport"));

$action = GETPOST('action', 'aZ09');
$id = GETPOST('id', 'int');
$idmenu = GETPOST('idmenu', 'int');
$daterange = GETPOST('daterange', 'alpha');
$datepicker = GETPOST('datepicker', 'alpha');
$interval = GETPOST('interval', 'alpha');

$year = GETPOST('year', 'int');
$months = GETPOST('months', 'array');


if ($interval == 'on') {
    $_SESSION['interval'] = $interval;
}

// Security check
// if (! $user->rights->settlements->myobject->read) {
// 	accessforbidden();
// }
$socid = GETPOST('socid', 'int');
if (isset($user->socid) && $user->socid > 0) {
    $action = '';
    $socid = $user->socid;
}

$form = new Form($db);
$formfile = new FormFile($db);

if (empty($id)) {
} else {
    $daterange = isset($_SESSION['daterange']) ? $_SESSION['daterange'] : '';
    $datepicker = isset($_SESSION['datepicker']) ? $_SESSION['datepicker'] : '';
}


$bigRedDiv = '';
$sumsHUFArray = [];
$sumsEURArray = [];
$dateforHiddenField = $datepicker != '' ? $datepicker : $daterange;
$honapok = $helper->getMonths();

if (isset($year) && !empty($months)) {
    //$bigRedDiv = '<div style="width:100%; color: white; font-weight:bold ;background-color: #fa8072; height:30px; text-align: center; padding-top: 15px; border-radius: 10px;">' . $langs->trans('onedayfilter') . ' ' . $selectedmonths . '<br></div>';
    // (C) GET WORKSHEET
    $helper->createExcel($year, $months, $honapok);
} else {
    unset($_SESSION['interval']);
}

if ($datepicker != '') {
    $_SESSION['datepicker'] = $datepicker;
    unset($_SESSION['daterange']);
    $helper->createExcelInterval($datepicker);
} else {
    unset($_SESSION['interval']);
}

if ($daterange != '') {
    $_SESSION['daterange'] = $daterange;
    unset($_SESSION['datepicker']);
    $helper->createExcelInterval($daterange);
} else {
    unset($_SESSION['interval']);
}


$title = '';
$help_url = '';
$morejs = '';
$morecss = '';
llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'classforhorizontalscrolloftabs');

/* print_r($_REQUEST);
print_r($_POST);
print_r($_GET); */
$SESSIONintervall = isset($_SESSION['interval']) ? $_SESSION['interval'] : null;


$url = $_SERVER["PHP_SELF"] . '?idmenu=' . $idmenu . '&mainmenu=financialreport&leftmenu=';
print '<form method="POST" id="statementlists" action="' . $url . '">' . "\n";
print '<input type="hidden" name="token" value="' . newToken() . '">';
print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
print '<input type="hidden" name="action" value="list">';
//print '<input type="hidden" name="sortfield" value="' . $sortfield . '">';
//print '<input type="hidden" name="sortorder" value="' . $sortorder . '">';
//print '<input type="hidden" name="page" value="' . $page . '">';
//print '<input type="hidden" name="contextpage" value="' . $contextpage . '">';
print '<input type="hidden" name="datepickerdata" value="' . $dateforHiddenField . '">';
print '<input type="hidden" name="intervalchk" value="' . $SESSIONintervall . '">';
print load_fiche_titre($langs->trans("FinancialreportRangeArea"), '', 'financialreport.png@financialreport');

print $bigRedDiv;

print '<div style="width:47%; height: 60px; background-color:lightgray; border-radius: 10px; padding-left: 20px; padding-top: 20px; padding-bottom: 20px; float: left;">';
print '<input id="chkbdatepicker" class="flat checkforselect" type="checkbox" name="interval" onchange="checkStatus()">' . $langs->trans('intervall') . '';
print '<div id="datepickerdiv" style="display:block;">';
print '<input type="text" name="datepicker" id="datepicker" value="" />';
print '<button style="width:70px; height: 30px; margin-left: 20px;" type="submit">' . $langs->trans('select') . '</button>';
print '</div>';
print '<div id="daterangediv" style="display:none;">';
print '<input type="text" name="daterange" id="daterange" value="" />';
print '<button style="width:70px; height: 30px; margin-left: 20px;" type="submit">' . $langs->trans('select') . '</button>';
print '</div>';
print '</div>';

################### hónapválasztó
print '<div style="width:47%; height: 60px; background-color:lightgray; padding: 35px 0 5px 20px;  border-radius: 10px;  float: right;">';
print '<label for="year">' . $langs->trans("Year") . ':</label>
    <select id="year" name="year" style="width:80px;">';
$currentYear = date("Y");
for ($i = $currentYear; $i >= 2000; $i--) {
    print '<option value=' . $i . '>' . $i . '</option>';
}
print '</select>
    <label for="month">' . $langs->trans('Month(s)') . ':</label>
    <select class="js-example-basic-multiple" style="width:450px;" name="months[]" multiple="multiple">';
foreach ($honapok as $honapSzam => $honapNev) {
    print '<option value=' . $honapSzam . '>' . $honapNev . '</option>';
}
print '</select>';
print '<button style="width:70px; height: 30px; margin-left: 20px;" type="submit">' . $langs->trans('select') . '</button>';
print '</div>';

################### hónapválasztó vége

print '<div class="clearboth">';
if ($daterange != '' || $datepicker != '') {



} else {
    print '<div style="color: red;">' . $langs->trans('selectdate') . '</div>';
}
print '</div></div>';
print '</form>' . "\n";

// End of page
llxFooter();
$db->close();
?>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css">
<script src="https://cdn.jsdelivr.net/npm/moment"></script>
<script src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>

<script>
    $(document).ready(function () {
        $('.js-example-basic-multiple').select2();
    });

    var datepickerdata = document.querySelector('input[type="hidden"][name="datepickerdata"]');
    var interval = document.querySelector('input[type="hidden"][name="intervalchk"]');
    var checkbox = document.querySelector('input[type="checkbox"][name="interval"]');
    var datepickerinput = document.querySelector('input[type="text"][name="datepicker"]');
    var daterangeinput = document.querySelector('input[type="text"][name="daterange"]');
    if (interval.value == 'on') {
        checkbox.checked = true;
        checkStatus();
        daterangeinput.value = datepickerdata.value;
    }
    datepickerinput.value = datepickerdata.value;

    function checkStatus() {
        var checkbox = document.getElementById("chkbdatepicker");
        var isChecked = checkbox.checked;
        if (isChecked) {
            var datepickerdiv = document.getElementById("datepickerdiv");
            var daterangediv = document.getElementById("daterangediv");
            datepickerdiv.style.display = "none";
            daterangediv.style.display = "block";
            datepickerinput.value = '';
            daterangeinput.value = '';
        } else {
            datepickerinput.value = '';
            daterangeinput.value = '';
            var datepickerdiv = document.getElementById("datepickerdiv");
            var daterangediv = document.getElementById("daterangediv");
            datepickerdiv.style.display = "block";
            daterangediv.style.display = "none";
        }
    }
    var datepicker =
        $(function () {
            $('#daterange').daterangepicker({
                "showDropdowns": true,
                "autoUpdateInput": false,
                locale: {
                    format: 'YYYY-MM-DD',
                    cancelLabel: 'Mégse',
                    applyLabel: 'OK',
                    moLabel: 'OK',
                    firstDay: 1,
                    "daysOfWeek": [
                        "Vas",
                        "Hé",
                        "Ke",
                        "Sze",
                        "Csü",
                        "Pé",
                        "Szo"
                    ],
                    "monthNames": [
                        "Január",
                        "Február",
                        "Március",
                        "Április",
                        "Május",
                        "Június",
                        "Július",
                        "Augsztus",
                        "Szeptember",
                        "Október",
                        "November",
                        "December"
                    ],

                },
            });
        });
    $(function () {
        $('#datepicker').daterangepicker({
            "singleDatePicker": true,
            "showDropdowns": true,
            "autoUpdateInput": false,
            locale: {
                format: 'YYYY-MM-DD',
                cancelLabel: 'Mégse',
                applyLabel: 'OK',
                moLabel: 'OK',
                firstDay: 1,
                "daysOfWeek": [
                    "Vas",
                    "Hé",
                    "Ke",
                    "Sze",
                    "Csü",
                    "Pé",
                    "Szo"
                ],
                "monthNames": [
                    "Január",
                    "Február",
                    "Március",
                    "Április",
                    "Május",
                    "Június",
                    "Július",
                    "Augsztus",
                    "Szeptember",
                    "Október",
                    "November",
                    "December"
                ],

            },
        });
    });
    $('input[name="datepicker"]').on('apply.daterangepicker', function (ev, picker) {
        $(this).val(picker.startDate.format('YYYY-MM-DD') + ' - ' + picker.endDate.format('YYYY-MM-DD'));
    });

    $('input[name="datepicker"]').on('cancel.daterangepicker', function (ev, picker) {
        $(this).val('');
    });
    $('input[name="daterange"]').on('apply.daterangepicker', function (ev, picker) {
        $(this).val(picker.startDate.format('YYYY-MM-DD') + ' - ' + picker.endDate.format('YYYY-MM-DD'));
    });

    $('input[name="daterange"]').on('cancel.daterangepicker', function (ev, picker) {
        $(this).val('');
    });
</script>