EXCELIA_DBARR/custom/financialreport/checkoutclosureindex.php

<?php
/* 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 . '/custom/bbus/class/facturestat.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/bbus/class/facturestorno.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/financialreport/class/checkoutclosure_helper.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/financialreport/class/checkoutclosure.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/core/tpl/printPDF_szisz.php';

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

$action = GETPOST('action', 'aZ09');
$id = GETPOST('id', 'int');
$idmenu = GETPOST('idmenu', 'int');
$entityClosing = GETPOST('entityClosing', 'alpha');
$datastring = GETPOST('datastring', 'alpha');

$form = new Form($db);
$formfile = new FormFile($db);
$factureStat = new FactureStat();
$factureStorno = new FactureStorno();
$helper = new CheckoutclosureHelper();

include DOL_DOCUMENT_ROOT . '/custom/financialreport/core/actions_addupdatedelete.inc.php';
if ($entityClosing) {
    $string = $idmenu . '_' . $entityClosing;
    $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"] . '?datastring=' . $string, $langs->trans('CheckoutClosureConfirm'), $langs->trans('CheckoutCloseurConfirmObject', $userString), 'confirm_checkoutclosure_settlement', '', 0, 1);
}

$allEntities = $helper->getAllEntities();

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

$url = $_SERVER["PHP_SELF"] . '?idmenu=' . $idmenu . '&mainmenu=financialreport&leftmenu=';

if ($entityClosing) {
    print $formconfirm;
}

print '<form method="POST" id="checkoutclosurehufForm" 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 load_fiche_titre($langs->trans("checkoutclosurehuf"), '', 'financialreport.png@financialreport');

print '<div class="container">';
foreach ($allEntities as $key => $value) {
    $from = $helper->getLastAccountDailyClosing($key);
    $amounts = $helper->getEntitiesIncome($key, $from, date("Y-m-d H:i:s", dol_now()));
    print '<div id="column_' . $key . '" class="column">
        <div class="titleDivForEntity">' . $value . '</div>
        <div class="dateDiv">
            <div class="row">' . $langs->trans('PreviousDate') . ':</div>
            <div class="row"><b>' . $from . '</b></div>
        </div>
        <div class="divstring row">' . $langs->trans('CashHUFGross') . '</div>
        <div class="divAmount row">' . $helper->correctNumber(intval($amounts['HUFCash'])) . ' HUF</div>
        <div class="divstring row">' . $langs->trans('CashEURGross') . '</div>
        <div class="divAmount row">' . $helper->correctNumber(intval($amounts['EURCash'])) . ' EUR</div>
        <div>&nbsp;</div>
        <div class="buttonMore" onclick="openMore(' . $key . ')"><span id="moreSpan1_' . $key . '" class="fa fa-chevron-down"></span>&nbsp; ' . $langs->trans('ReadMore') . ' &nbsp;<span id="moreSpan2_' . $key . '" class="fa fa-chevron-down"></span> </div>
        <div>&nbsp;</div>
        <div><button class="entitybutton" type="submit" name="entityClosing" value="' . $key . '_' . $from . '">' . $langs->trans('Close') .'</button></div>
    </div>';
}
foreach ($allEntities as $key => $value) {
    $from = $helper->getLastAccountDailyClosing($key);
    $arraySumSale = $helper->getSumSaleArray($from, $key);
    $arraySumCash = $helper->getsumCashArray($from, $key);
    $arraySumCard = $helper->getsumCardArray($from, $key);
    $arraystornoSumCash = $helper->getfacturesToBeStornoCashArray($from, $key);
    $arraystornoSumCard = $helper->getfacturesToBeStornoCardArray($from, $key);

    $title = [$langs->trans('TotalSalesByVAT'), $langs->trans('TotalSalesCash'), $langs->trans('TotalSalesCard'), $langs->trans('MarkedAccountsCash'), $langs->trans('MarkedAccountsCard')];

    print '<div id="hidden_' . $key . '" class="hiddenDiv" style="display:none; width:100%;">
    <table style="width:100%">
        <tr class="dropdownTitle"><td colspan="7">' . $value . '</td></tr>';
        $helper->fullHeaderTable();
        if(!empty($arraySumSale)){    
            $helper->sumSaleBlock($arraySumSale, $title);
        }else{
            print $helper->noDataTR($title[0]);
        }
        print '<tr><td colspan="7">&nbsp;</td></tr>';
        print $helper->bruttoTable();
        $helper->generateRow($arraySumCash, $title[1]);
        $helper->generateRow($arraySumCard, $title[2]);
        print '<tr><td colspan="7">&nbsp;</td></tr>';
        $helper->bruttoTable();
        $helper->generateRow($arraystornoSumCash, $title[3]);
        $helper->generateRow($arraystornoSumCard, $title[4]);
        print '
    </table>
    </div>';
}
print '</div>';
print '</form>' . "\n";
llxFooter();
$db->close();
?>

<style>
    .tdTitle{
        width:20%; 
        text-align:right;
    }

    .b{
        font-weight: bold;
        background-color: lightgray;
    }

    .buttonMore {
        cursor: pointer;
    }

    .dateDiv {
        margin-top: -10px;
        padding-top: 5px;
        padding-bottom: 10px;
        background-color: lightgray;
    }

    .container {
        width: 100%;
        display: block;
        text-align: center;
    }

    .column {
        text-align: center;
        margin-left: 5px;
        margin-right: 5px;
        width: 19%;
        float: left;
    }

    .columnSelected {
        background-color: lightgray;
    }

    .row {
        margin-top: 10px;
        height: 20px;
    }

    .titleDivForEntity {
        font-weight: bold;
        height: 40px;
        background-color: rgb(163, 0, 51);
        display: block;
        text-align: center;
        color: white;
        padding-top: 15px;
        border-top-right-radius: 10px;
        border-top-left-radius: 10px;
    }

    .dropdownTitle {
        height:30px;
        background-color:rgb(163, 0, 51);
        color: white;
    }

    .divstring {
        text-align: center;
    }

    .divAmount {
        text-align: center;
        color: green;
        font-weight: bold;
    }

    .entitybutton {
        width: 100%;
        height: 30px;
        background-color: rgb(163, 0, 51);
        color: white;
        border-radius: 20px;
        border: none;
        cursor: pointer;
        margin-bottom : 40px;
    }
</style>
<script>
    function openMore(entity) {
        var x = document.getElementById("hidden_" + entity);
        var column = document.getElementById("column_" + entity);
        var arrow1 = document.getElementById("moreSpan1_" + entity);
        var arrow2 = document.getElementById("moreSpan2_" + entity);
        var display = x.style.display;
        if (display == 'none') {
            $('.hiddenDiv').css('display', 'none');
            $('.column').removeClass('columnSelected');
            $('.fa').removeClass('fa-chevron-up');
            $('.fa').addClass('fa-chevron-down');
            x.style.display = "block";
            arrow1.classList.remove("fa-chevron-down");
            arrow1.classList.add("fa-chevron-up");
            arrow2.classList.remove("fa-chevron-down");
            arrow2.classList.add("fa-chevron-up");
            column.classList.add("columnSelected");
        } else {
            x.style.display = "none";
            arrow1.classList.remove("fa-chevron-up");
            arrow1.classList.add("fa-chevron-down");
            arrow2.classList.remove("fa-chevron-up");
            arrow2.classList.add("fa-chevron-down");
            column.classList.remove("columnSelected");
        }
    }

</script>