<?php

/*
 * LMS version 1.11-git
 *
 *  (C) Copyright 2001-2022 LMS Developers
 *
 *  Please, see the doc/AUTHORS for more information about authors!
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License Version 2 as
 *  published by the Free Software Foundation.
 *
 *  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, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
 *  USA.
 *
 *  $Id$
 */

if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.reports')) {
    access_denied();
}

$report_type = ConfigHelper::getConfig('phpui.report_type');
if (empty($report_type)) {
    $report_type = '';
}

$type = $_GET['type'] ?? '';

switch ($type) {
    case 'customerbalance':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $from = $_POST['from'];
        $to = $_POST['to'];

        // date format 'yyyy/mm/dd'
        if ($from && preg_match('/^[0-9]{4}\/[0-9]{2}\/[0-9]{2}$/', $from)) {
            [$year, $month, $day] = explode('/', $from);
            $date['from'] = mktime(0, 0, 0, (int)$month, (int)$day, (int)$year);
        } else {
            $date['from'] = 0;
        }

        if ($to && preg_match('/^[0-9]{4}\/[0-9]{2}\/[0-9]{2}$/', $to)) {
            [$year, $month, $day] = explode('/', $to);
            $date['to'] = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = date('Y/m/d', time());
            $date['to'] = mktime(23, 59, 59); //koniec dnia dzisiejszego
        }

        $id = intval($_POST['customer']);

        $aggregate_documents = !empty($_POST['aggregate_documents']);

        $layout['pagetitle'] = trans('Customer $a Balance Sheet ($b to $c)', $LMS->GetCustomerName($id), ($from ?: ''), $to);

        $list['balance'] = 0;
        $list['income'] = 0;
        $list['expense'] = 0;
        $list['liability'] = 0;
        $list['summary'] = 0;
        $list['customerid'] = $id;

        if ($tslist = $DB->GetAll('SELECT c.id AS id, time, c.type, c.value AS value,
                    c.currency, c.currencyvalue,
				    taxes.label AS taxlabel, c.customerid, c.comment, vusers.name AS username,
				    c.docid, d.number, d.fullnumber, d.cdate, d.type AS doctype, numberplans.template
				    FROM cash c
				    LEFT JOIN documents d ON d.id = c.docid
				    LEFT JOIN numberplans ON numberplans.id = d.numberplanid
				    LEFT JOIN taxes ON (c.taxid = taxes.id)
				    LEFT JOIN vusers ON (vusers.id = c.userid)
				    WHERE c.customerid = ?
					    AND NOT EXISTS (
				                    SELECT 1 FROM vcustomerassignments a
					            JOIN excludedgroups e ON (a.customergroupid = e.customergroupid)
					            WHERE e.userid = lms_current_user() AND a.customerid = ?)
				    ORDER BY time', array($id, $id))
        ) {
            if ($aggregate_documents) {
                $tslist = $LMS->AggregateDocuments(array('customerid' => $id, 'list' => $tslist));
                $tslist = $tslist['list'];
            }

            foreach ($tslist as $row) {
                foreach ($row as $column => $value) {
                    $saldolist[$column][] = $value;
                }
            }

            $saldolist['balance'] = 0;

            foreach ($saldolist['id'] as $i => $v) {
                $saldolist['after'][$i] = $saldolist['balance'] + $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];
                $saldolist['balance'] += $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];
                $saldolist['date'][$i] = date('Y/m/d H:i', $saldolist['time'][$i]);

                if ($saldolist['time'][$i]>=$date['from'] && $saldolist['time'][$i]<=$date['to']) {
                    $list['id'][] = $saldolist['id'][$i];
                    $list['type'][] = $saldolist['type'][$i];
                    $list['after'][] = $saldolist['after'][$i];
                    $list['before'][] = $saldolist['balance'];
                    $list['value'][] = $saldolist['value'][$i];
                    $list['taxlabel'][] = $saldolist['taxlabel'][$i];
                    $list['date'][] = date('Y/m/d H:i', $saldolist['time'][$i]);
                    $list['fullnumber'][] = $saldolist['fullnumber'][$i];
                    $list['username'][] = $saldolist['username'][$i];
                    $list['comment'][] = $saldolist['comment'][$i];
                    $list['currency'][] = $saldolist['currency'][$i];
                    $list['summary'] += $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];

                    if ($saldolist['type'][$i]) {
                        if ($saldolist['value'][$i] > 0) {
                                //income
                                $list['income'] += $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];
                        } else { //expense
                                $list['expense'] -= $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];
                        }
                    } else {
                        $list['liability'] -= $saldolist['value'][$i] * $saldolist['currencyvalue'][$i];
                    }
                }
            }

            $list['total'] = count($list['id']);
        }

        $SMARTY->assign('balancelist', $list);
        if (strtolower($report_type) == 'pdf') {
            $output = $SMARTY->fetch('print/printcustomerbalance.html');
            Utils::html2pdf(array(
                'content' => $output,
                'subject' => trans('Reports'),
                'title' => $layout['pagetitle'],
            ));
        } else {
            $SMARTY->display('print/printcustomerbalance.html');
        }
        break;

    case 'balancelist':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $from = $_POST['balancefrom'];
        $to = $_POST['balanceto'];
        $net = intval($_POST['network']);
        if (!empty($_POST['customergroup'])) {
            $group = $_POST['customergroup'];
            if (!is_array($group)) {
                $group = array($group);
            }
            $group = Utils::filterIntegers($group);
        } else {
            $group = array();
        }
        $division = intval($_POST['division']);
        $source = intval($_POST['source']);
        $types = isset($_POST['types']) ? Utils::filterIntegers($_POST['types']) : array();
        $docs = $_POST['docs'];

        $hideid = isset($_POST['printcustomerhideid']);
        $hidessnten = isset($_POST['printcustomerhidessnten']);
        $hideaddress = isset($_POST['printcustomerhideaddress']);

        // date format 'yyyy/mm/dd'
        if ($from) {
            [$year, $month, $day] = explode('/', $from);
            $date['from'] = mktime(0, 0, 0, (int)$month, (int)$day, (int)$year);
        }

        if ($to) {
            [$year, $month, $day] = explode('/', $to);
            $date['to'] = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = date('Y/m/d', time());
            $date['to'] = mktime(23, 59, 59); //koniec dnia dzisiejszego
        }

        if ($net) {
                $net = $LMS->GetNetworkParams($net);
        }

        if ($user = $_POST['user']) {
            $layout['pagetitle'] = trans('Balance Sheet of User: $a ($b to $c)', $LMS->GetUserName($user), ($from ?: ''), $to);
        } else {
            $layout['pagetitle'] = trans('Balance Sheet ($a to $b)', ($from ?: ''), $to);
        }

        $typetxt = array();
        if (!empty($types)) {
            foreach ($types as $tt) {
                switch ($tt) {
                    case 1:
                        $typewhere[] = 'c.type = 0';
                        $typetxt[] = trans('Liability');
                        break;
                    case 2:
                        $typewhere[] = '(c.type = 1 AND c.value > 0)';
                        $typetxt[] = trans('Income');
                        break;
                    case 3: // expense
                        $typewhere[] = '(c.type = 1 AND c.value < 0)';
                        $typetxt[] = trans('Expense');
                        break;
                }
            }

            $typewhere = ' AND (' . implode(' OR ', $typewhere) . ')';
        }

        $customerslist = $DB->GetAllByKey('SELECT id, ' . $DB->Concat('UPPER(lastname)', "' '", 'name') . ' AS customername FROM customers', 'id');

        if (isset($date['from'])) {
            $lastafter = $DB->GetOne(
                'SELECT
                    SUM(CASE WHEN c.customerid IS NOT NULL AND c.type = 0 THEN 0 ELSE c.value * c.currencyvalue END)
                FROM cash c
                JOIN customerview ON customerview.id = c.customerid
                WHERE c.time < ?'
                . (empty($group) ? '' : ' AND EXISTS (SELECT 1 FROM vcustomerassignments a WHERE a.customerid = c.customerid AND a.customergroupid IN (' . implode(',', $group) . '))')
                . ($docs ? ($docs == 'documented' ? ' AND c.docid IS NOT NULL' : ' AND c.docid IS NULL') : '')
                . ($source ? ' AND c.sourceid = ' . intval($source) : '')
                . ($net ? ' AND EXISTS (SELECT 1 FROM vnodes WHERE c.customerid = ownerid AND ((ipaddr > ' . $net['address'] . ' AND ipaddr < ' . $net['broadcast'] . ') OR (ipaddr_pub > ' . $net['address'] . ' AND ipaddr_pub < ' . $net['broadcast'] . ')))' : '')
                . ($division ? ' AND customerview.divisionid = ' . $division : '')
                . (empty($types) ? '' : $typewhere),
                array(
                    $date['from'],
                )
            );
        } else {
            $lastafter = 0;
        }

        if ($balancelist = $DB->GetAll(
            'SELECT
                c.id AS id,
                c.time,
                c.userid,
                customerview.type AS ctype,
                COALESCE(d.ssn, customerview.ssn) AS ssn,
                COALESCE(d.ten, customerview.ten) AS ten,
                COALESCE(d.address, customerview.address) AS address,
                COALESCE(d.zip, customerview.zip) AS zip,
                COALESCE(d.city, customerview.city) AS city,
                c.value AS value,
                c.currency,
                c.currencyvalue,
                taxes.label AS taxlabel,
                c.customerid,
                c.comment,
                c.type AS type,
                cs.name AS sourcename
            FROM cash c
            JOIN customerview ON customerview.id = c.customerid
            LEFT JOIN documents d ON d.id = c.docid
            LEFT JOIN cashsources cs ON cs.id = c.sourceid
            LEFT JOIN taxes ON taxid = taxes.id
            WHERE time <= ?'
            . (empty($group) ? '' : ' AND EXISTS (SELECT 1 FROM vcustomerassignments a WHERE a.customerid = c.customerid AND a.customergroupid IN (' . implode(',', $group) . '))')
            . ($docs ? ($docs == 'documented' ? ' AND c.docid IS NOT NULL' : ' AND c.docid IS NULL') : '')
            . ($source ? ($source == -1 ? ' AND c.sourceid IS NULL' : ' AND c.sourceid = ' . intval($source)) : '')
            . (isset($date['from']) ? ' AND c.time >= ' . $date['from'] : '')
            . ($net ? ' AND EXISTS (SELECT 1 FROM vnodes WHERE c.customerid = ownerid AND ((ipaddr > ' . $net['address'] . ' AND ipaddr < ' . $net['broadcast'] . ') OR (ipaddr_pub > ' . $net['address'] . ' AND ipaddr_pub < ' . $net['broadcast'] . ')))' : '')
            . ($division ? ' AND customerview.divisionid = ' . $division : '')
            . (empty($types) ? '' : $typewhere)
            . ' ORDER BY c.time ASC, d.number',
            array(
                $date['to'],
            )
        )) {
            $listdata['income'] = 0;
            $listdata['expense'] = 0;
            $listdata['liability'] = 0;
            $x = 0;

            foreach ($balancelist as $idx => $row) {
                if ($user) {
                    if ($row['userid'] != $user) {
                        if ($row['value'] > 0 || !$row['customerid']) {  // skip cust. covenants
                            $lastafter += $row['value'];
                        }
                        unset($balancelist[$idx]);
                        continue;
                    }
                }

                $list[$x] = $row;
                $list[$x]['customername'] = empty($row['customerid']) ? '' : $customerslist[$row['customerid']]['customername'];

                if (!empty($row['customerid']) && empty($row['type'])) {
                    // customer covenant
                    $list[$x]['after'] = $lastafter;
                    $list[$x]['covenant'] = true;
                    $listdata['liability'] -= $row['value'] * $row['currencyvalue'];
                } else {
                    //customer payment
                    $list[$x]['after'] = $lastafter + $list[$x]['value'] * $row['currencyvalue'];

                    if ($row['value'] > 0) {
                        //income
                        $listdata['income'] += $list[$x]['value'] * $row['currencyvalue'];
                    } else {
                        //expense
                        $listdata['expense'] -= $list[$x]['value'] * $row['currencyvalue'];
                    }
                }

                $lastafter = $list[$x]['after'];
                $x++;
                unset($balancelist[$idx]);
            }

            $listdata['total'] = $listdata['income'] - $listdata['expense'];

            $SMARTY->assign('listdata', $listdata);
            $SMARTY->assign('balancelist', $list);
        }

        if ($net) {
            $SMARTY->assign('net', $net['name']);
        }

        $SMARTY->assign('types', array_flip(empty($types) ? array(1, 2, 3) : $types));
        $SMARTY->assign('typetxt', implode(', ', $typetxt));

        if (!empty($group)) {
            $SMARTY->assign('groups', $DB->GetCol('SELECT name FROM customergroups WHERE id IN ? ORDER BY name', array($group)));
        }
        if ($division) {
            $SMARTY->assign('division', $DB->GetOne('SELECT name FROM divisions WHERE id = ?', array($division)));
        }
        if ($source) {
            $SMARTY->assign('source', $DB->GetOne('SELECT name FROM cashsources WHERE id = ?', array($source)));
        }

        $SMARTY->assign(compact('hideid', 'hidessnten', 'hideaddress'));

        if (strtolower($report_type) == 'pdf') {
            $output = $SMARTY->fetch('print/printbalancelist.html');
            Utils::html2pdf(array(
                'content' => $output,
                'subject' => trans('Reports'),
                'title' => $layout['pagetitle'],
            ));
        } else {
            if (isset($_POST['disposition']) && $_POST['disposition'] == 'csv') {
                $filename = 'history-' . date('YmdHis') . '.csv';
                header('Content-Type: text/plain; charset=utf-8');
                header('Content-Disposition: attachment; filename=' . $filename);
                header('Pragma: public');
                $SMARTY->display('print/printbalancelist-csv.html');
            } else {
                $SMARTY->display('print/printbalancelist.html');
            }
        }
        break;

    case 'incomereport':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $from = $_POST['from'];
        $to = $_POST['to'];

        // date format 'yyyy/mm/dd'
        [$year, $month, $day] = explode('/', $from);
        $date['from'] = mktime(0, 0, 0, (int)$month, (int)$day, (int)$year);

        if ($to) {
            [$year, $month, $day] = explode('/', $to);
            $date['to'] = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = date("Y/m/d", time());
            $date['to'] = mktime(23, 59, 59); // end of today
        }

        $layout['pagetitle'] = trans('Total Invoiceless Income ($a to $b)', ($from ?: ''), $to);

        $incomelist = $DB->GetAll(
            'SELECT floor(time/86400)*86400 AS date, SUM(value * currencyvalue) AS value
			FROM cash c
			WHERE value>0 AND time>=? AND time<=? AND docid IS NULL
				AND NOT EXISTS (
			        	SELECT 1 FROM vcustomerassignments a
					JOIN excludedgroups e ON (a.customergroupid = e.customergroupid)
					WHERE e.userid = lms_current_user() AND a.customerid = c.customerid)
			GROUP BY date ORDER BY date ASC',
            array($date['from'], $date['to'])
        );

        $SMARTY->assign('incomelist', $incomelist);
        if (strtolower($report_type) == 'pdf') {
            $output = $SMARTY->fetch('print/printincomereport.html');
            Utils::html2pdf(array(
                'content' => $output,
                'subject' => trans('Reports'),
                'title' => $layout['pagetitle'],
            ));
        } else {
            $SMARTY->display('print/printincomereport.html');
        }
        break;

    case 'importlist':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $from = $_POST['importfrom'];
        $to = $_POST['importto'];
        $source = $_POST['source'];

        // date format 'yyyy/mm/dd'
        if ($from) {
            [$year, $month, $day] = explode('/', $from);
            $date['from'] = mktime(0, 0, 0, (int)$month, (int)$day, (int)$year);
        } else {
            $date['from'] = 0;
        }

        if ($to) {
            [$year, $month, $day] = explode('/', $to);
            $date['to'] = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = date("Y/m/d", time());
            $date['to'] = mktime(23, 59, 59); // end of today
        }

        $layout['pagetitle'] = trans('Cash Import History ($a to $b)', $from, $to);

        $importlist = $DB->GetAll('SELECT c.time, c.value, c.customerid, '
            .$DB->Concat('upper(v.lastname)', "' '", 'v.name').' AS customername
			FROM cash c
			JOIN customerview v ON (v.id = c.customerid)
			WHERE c.time >= ? AND c.time <= ?'
            .($source ? ' AND c.sourceid = '.intval($source) : '')
            .' AND c.importid IS NOT NULL
			ORDER BY time', array($date['from'], $date['to']));

        if ($source) {
            $SMARTY->assign('source', $DB->GetOne('SELECT name FROM cashsources WHERE id = ?', array($source)));
        }
        $SMARTY->assign('importlist', $importlist);
        if (strtolower($report_type) == 'pdf') {
            $output = $SMARTY->fetch('print/printimportlist.html');
            Utils::html2pdf(array(
                'content' => $output,
                'subject' => trans('Reports'),
                'title' => $layout['pagetitle'],
            ));
        } else {
            $SMARTY->display('print/printimportlist.html');
        }
        break;

    case 'invoices':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $from = $_POST['invoicefrom'];
        $to = $_POST['invoiceto'];

        // date format 'yyyy/mm/dd'
        if ($to) {
            [$year, $month, $day] = explode('/', $to);
            $date['to'] = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = date('Y/m/d', time());
            $date['to'] = mktime(23, 59, 59); //koniec dnia dzisiejszego
        }

        if ($from) {
            [$year, $month, $day] = explode('/', $from);
            $date['from'] = mktime(0, 0, 0, $month, $day, $year);
        } else {
            $from = date('Y/m/d', time());
            $date['from'] = mktime(0, 0, 0); //początek dnia dzisiejszego
        }

        $type = '';
        $type .= isset($_POST['invoiceorg']) ? '&original=1' : '';
        $type .= isset($_POST['invoicecopy']) ? '&copy=1' : '';
        $type .= isset($_POST['invoicedup']) ? '&duplicate=1' : '';
        if (!$type) {
            $type = '&oryginal=1';
        }

        if (isset($_POST['ksef-submit']) && strlen($_POST['ksef-submit'])) {
            $ksefSubmit = $_POST['ksef-submit'] == 'yes' ? 1 : 0;
        } else {
            $ksefSubmit = null;
        }

        $layout['pagetitle'] = trans('Invoices');

        header(
            'Location: ?m=invoice&fetchallinvoices=1' . (isset($_GET['jpk']) ? '&jpk=' . $_GET['jpk'] : '')
                . (isset($_GET['jpk_format']) ? '&jpk_format=' . $_GET['jpk_format'] : '')
                .$type
                .'&from='.$date['from']
                .'&to='.$date['to']
                .(!empty($_POST['einvoice']) ? '&einvoice=' . intval($_POST['einvoice']) : '')
                .(!empty($_POST['division']) ? (is_array($_POST['division']) ? '&divisionid[]=' . implode('&divisionid[]=', Utils::filterIntegers($_POST['division'])) : '&divisionid=' . intval($_POST['division'])) : '')
                .(!empty($_POST['customer']) ? '&customerid='.intval($_POST['customer']) : '')
                .(!empty($_POST['group']) && is_array($_POST['group']) ? '&groupid[]='
                    . implode('&groupid[]=', Utils::filterIntegers($_POST['group'])) : '')
                . (isset($_POST['customer_type']) ? '&customertype=' . intval($_POST['customer_type']) : '')
                .(!empty($_POST['numberplan']) && is_array($_POST['numberplan']) ? '&numberplanid[]='
                    . implode('&numberplanid[]=', Utils::filterIntegers($_POST['numberplan'])) : '')
                .(!empty($_POST['groupexclude']) ? '&groupexclude=1' : '')
                .(!empty($_POST['autoissued']) ? '&autoissued=1' : '')
                .(!empty($_POST['manualissued']) ? '&manualissued=1' : '')
                . (isset($_POST['related-documents']) ? '&related-documents=1' : '')
                . (!isset($_POST['transfer-forms']) || !empty($_POST['transfer-forms']) ? '&transfer-forms=1' : '')
                . (!empty($_POST['purchase-invoices']) ? '&purchase-invoices=1' : '')
                . (isset($ksefSubmit) ? '&ksef-submit=' . $ksefSubmit : '')
        );
        break;

    case 'transferforms':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        $kind = isset($_GET['kind']) ? intval($_GET['kind']) : 2;

        switch ($kind) {
            case 1:
                $from = $_POST['invoicefrom'];
                $to = $_POST['invoiceto'];

                if ($to) {
                    [$year, $month, $day] = explode('/', $to);
                    $date['to'] = mktime(23, 59, 59, $month, $day, $year);
                } else {
                    $to = date('Y/m/d', time());
                    $date['to'] = mktime(23, 59, 59); //koniec dnia dzisiejszego
                }

                if ($from) {
                    [$year, $month, $day] = explode('/', $from);
                    $date['from'] = mktime(0, 0, 0, $month, $day, $year);
                } else {
                    $from = date('Y/m/d', time());
                    $date['from'] = mktime(0, 0, 0); //początek dnia dzisiejszego
                }

                $_GET['from'] = $date['from'];
                $_GET['to'] = $date['to'];
                $_GET['customerid'] = $_POST['customer'];
                $_GET['groupid'] = $_POST['group'];
                $_GET['numberplan'] = $_POST['numberplan'];
                $_GET['groupexclude'] = !empty($_POST['groupexclude']) ? 1 : 0;
                $which = '';

                break;
            case 2:
                $balance = isset($_POST['balance']) && strlen($_POST['balance']) ? floatval($_POST['balance']) : null;
                $customer = isset($_POST['customer']) ? intval($_POST['customer']) : 0;
                $group = isset($_POST['customergroup']) ? intval($_POST['customergroup']) : 0;
                $exclgroup = isset($_POST['groupexclude']) ? 1 : 0;

                break;
        }
        require_once(MODULES_DIR . DIRECTORY_SEPARATOR . 'transferforms.php');
        break;

    case 'liabilityreport':
        /********************************************/

        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.finances_management')) {
            access_denied();
        }

        if (isset($_POST['day']) && $_POST['day']) {
            [$year, $month, $day] = explode('/', $_POST['day']);
            $reportday = mktime(0, 0, 0, $month, $day, $year);
            $today = $reportday;
        } else {
            $reportday = time();
            $today = mktime(0, 0, 0);
        }

        if (isset($_POST['period']) && $_POST['period'] != '') {
            $period = intval($_POST['period']);
        }

        $layout['pagetitle'] = trans('Liability Report on $a', date('Y/m/d', $reportday));

        $order = $_POST['order'];
        $direction = $_POST['direction'];
        $divisionid = (isset($_POST['division']) ? intval($_POST['division']) : 0);
        $customerid = (isset($_POST['customer']) ? intval($_POST['customer']) : 0);

        $year = date('Y', $reportday);
        $yearday = date('z', $reportday) + 1;
        $month = date('n', $reportday);
        $monthday = date('j', $reportday);
        $weekday = date('w', $reportday);

        switch ($month) {
            case 1:
            case 4:
            case 7:
            case 10:
                $quarterday = $monthday;
                break;
            case 2:
            case 5:
            case 8:
            case 11:
                $quarterday = $monthday + 100;
                break;
            default:
                $quarterday = $monthday + 200;
                break;
        }

        if ($month > 6) {
            $halfyear = $monthday + ($month - 7) * 100;
        } else {
            $halfyear = $monthday + ($month - 1) * 100;
        }

        if (is_leap_year($year) && $yearday > 31 + 28) {
            $yearday -= 1;
        }

        $suspension_percentage = ConfigHelper::getConfig('payments.suspension_percentage', ConfigHelper::getConfig('finances.suspension_percentage', 0));

        $reportlist = array();
        if ($taxes = $LMS->GetTaxes($reportday, $reportday)) {
            $total = array();

            foreach ($taxes as $taxidx => $tax) {
                $list1 = $DB->GetAllByKey(
                    'SELECT a.customerid AS id, '.$DB->Concat('UPPER(lastname)', "' '", 'c.name').' AS customername, '
                    .$DB->Concat('city', "' '", 'address').' AS address, ten,
					SUM((((((100 - a.pdiscount) * t.value) / 100) - a.vdiscount) *
						((CASE WHEN a.suspended = 0 AND allsuspended.suspended IS NULL THEN 100.0 ELSE '.$suspension_percentage.' END) / 100))
					* (CASE a.period
						WHEN '.YEARLY.' THEN 12
						WHEN '.HALFYEARLY.' THEN 6
						WHEN '.QUARTERLY.' THEN 3
						WHEN '.WEEKLY.' THEN 1.0/4
						WHEN '.DAILY.' THEN 1.0/30
						ELSE 1 END)
					* (CASE t.period
						WHEN '.YEARLY.' THEN 1.0/12
						WHEN '.HALFYEARLY.' THEN 1.0/6
						WHEN '.QUARTERLY.' THEN 1.0/3
						ELSE 1 END)
					) AS value, t.currency
                    FROM assignments a
                    LEFT JOIN tariffs t ON t.id = a.tariffid
                    LEFT JOIN customerview c ON c.id = a.customerid
                    LEFT JOIN (
                        SELECT COUNT(id) AS suspended, customerid FROM assignments
                        WHERE tariffid IS NULL AND liabilityid IS NULL
                            AND datefrom <= ? AND (dateto >= ? OR dateto = 0)
                        GROUP BY customerid
                    ) allsuspended ON allsuspended.customerid = a.customerid
                    WHERE c.status = ?
                        AND t.taxid=?
                        AND c.deleted=0
                        AND a.datefrom <= ? AND (a.dateto >= ? OR a.dateto = 0)
                        ' . (isset($period) ? ' AND a.period = ' . $period : '') . '
                        AND ((a.period='.DISPOSABLE.' AND a.at=?)
                            OR (a.period='.WEEKLY.'. AND a.at=?)
                            OR (a.period='.MONTHLY.' AND a.at=?)
                            OR (a.period='.QUARTERLY.' AND a.at=?)
                            OR (a.period='.HALFYEARLY.' AND a.at=?)
                            OR (a.period='.YEARLY.' AND a.at=?)) '
                        . ($customerid ? ' AND a.customerid=' . $customerid : '')
                        . ($divisionid ? ' AND c.divisionid=' . $divisionid : '')
                    . ' GROUP BY a.customerid, lastname, c.name, city, address, ten, t.currency',
                    'id',
                    array($reportday, $reportday, CSTATUS_CONNECTED, $tax['id'], $reportday, $reportday, $today, $weekday, $monthday, $quarterday, $halfyear, $yearday)
                );

                $list2 = $DB->GetAllByKey(
                    'SELECT a.customerid AS id, '.$DB->Concat('UPPER(lastname)', "' '", 'c.name').' AS customername, '
                    .$DB->Concat('city', "' '", 'address').' AS address, ten,
					SUM(((((100 - a.pdiscount) * l.value) / 100) - a.vdiscount) *
						((CASE WHEN a.suspended = 0 AND allsuspended.customerid IS NULL THEN 100.0 ELSE '.$suspension_percentage.' END) / 100)) AS value,
						l.currency
                    FROM assignments a
                    LEFT JOIN liabilities l ON l.id = a.liabilityid
                    LEFT JOIN customerview c ON c.id = a.customerid
                    LEFT JOIN (
                        SELECT COUNT(id) AS suspended, customerid FROM assignments
                        WHERE tariffid IS NULL AND liabilityid IS NULL
                            AND datefrom <= ? AND (dateto >= ? OR dateto = 0)
                        GROUP BY customerid
                    ) allsuspended ON allsuspended.customerid = a.customerid
                    WHERE c.status = ?
                        AND l.taxid=?
                        AND c.deleted=0
                        AND a.datefrom <= ? AND (a.dateto>=? OR a.dateto=0)
                        ' . (isset($period) ? ' AND a.period = ' . $period : '') . '
                        AND ((a.period='.DISPOSABLE.' AND a.at=?)
                            OR (a.period='.WEEKLY.'. AND a.at=?)
                            OR (a.period='.MONTHLY.' AND a.at=?)
                            OR (a.period='.QUARTERLY.' AND a.at=?)
                            OR (a.period='.HALFYEARLY.' AND a.at=?)
                            OR (a.period='.YEARLY.' AND a.at=?)) '
                        .($customerid ? 'AND a.customerid='.$customerid : '').
                    ' GROUP BY a.customerid, lastname, c.name, city, address, ten, l.currency',
                    'id',
                    array($reportday, $reportday, CSTATUS_CONNECTED, $tax['id'], $reportday, $reportday, $today, $weekday, $monthday, $quarterday, $halfyear, $yearday)
                );

                if (empty($list1) && empty($list2)) {
                    unset($taxes[$taxidx]);
                }

                $list = array_merge((array) $list1, (array) $list2);

                if ($list) {
                    foreach ($list as $row) {
                        $idx = $row['id'];
                        if (!isset($reportlist[$idx])) {
                            $reportlist[$idx]['id'] = $row['id'];
                            $reportlist[$idx]['customername'] = $row['customername'];
                            $reportlist[$idx]['address'] = $row['address'];
                            $reportlist[$idx]['ten'] = $row['ten'];
                            $reportlist[$idx]['values'] = array();
                        }
                        if (!isset($reportlist[$idx]['values'][$row['currency']])) {
                            $reportlist[$idx]['values'][$row['currency']] = array(
                                'value' => 0,
                                'taxsum' => 0,
                            );
                        }
                        $reportlist[$idx]['values'][$row['currency']]['value'] += $row['value'];
                        $reportlist[$idx]['values'][$row['currency']][$tax['id']]['netto'] =
                            round($row['value']/($tax['value']+100)*100, 2);
                        $reportlist[$idx]['values'][$row['currency']][$tax['id']]['tax'] =
                            $row['value'] - $reportlist[$idx]['values'][$row['currency']][$tax['id']]['netto'];
                        $reportlist[$idx]['values'][$row['currency']]['taxsum'] +=
                            $reportlist[$idx]['values'][$row['currency']][$tax['id']]['tax'];
                        if (!isset($total['netto'][$row['currency']][$tax['id']])) {
                            $total['netto'][$row['currency']][$tax['id']] = 0;
                            $total['tax'][$row['currency']][$tax['id']] = 0;
                        }
                        $total['netto'][$row['currency']][$tax['id']] +=
                            $reportlist[$idx]['values'][$row['currency']][$tax['id']]['netto'];
                        $total['tax'][$row['currency']][$tax['id']] +=
                            $reportlist[$idx]['values'][$row['currency']][$tax['id']]['tax'];
                    }
                }
            }

            switch ($order) {
                case 'customername':
                    $table = array();
                    foreach ($reportlist as $idx => $row) {
                        $table['idx'][] = $idx;
                        $table['customername'][] = $row['customername'];
                    }
                    if (!empty($table)) {
                        array_multisort($table['customername'], ($direction == 'desc' ? SORT_DESC : SORT_ASC), $table['idx']);
                        foreach ($table['idx'] as $idx) {
                            $tmplist[] = $reportlist[$idx];
                        }
                    }
                    $reportlist = empty($tmplist) ? array() : $tmplist;
                    break;
                default:
                    foreach ($reportlist as $idx => $row) {
                        $table['idx'][] = $idx;
                        $table['value'][] = $row['value'];
                    }
                    if (is_array($table)) {
                        array_multisort($table['value'], ($direction == 'desc' ? SORT_DESC : SORT_ASC), $table['idx']);
                        foreach ($table['idx'] as $idx) {
                            $tmplist[] = $reportlist[$idx];
                        }
                    }
                    $reportlist = $tmplist;
                    break;
            }

            $SMARTY->assign('reportlist', $reportlist);
            $SMARTY->assign('total', $total);
            $SMARTY->assign('taxes', $taxes);
            $SMARTY->assign('taxescount', count($taxes));
        }

        if (strtolower($report_type) == 'pdf') {
            $output = $SMARTY->fetch('print/printliabilityreport.html');
            Utils::html2pdf(array(
                'content' => $output,
                'subject' => trans('Reports'),
                'title' => $layout['pagetitle'],
            ));
        } else {
            $SMARTY->display('print/printliabilityreport.html');
        }
        break;

    case 'receiptlist':
        if (!ConfigHelper::checkConfig('privileges.superuser') && !ConfigHelper::checkConfig('privileges.cash_operations')) {
            access_denied();
        }

        if (!empty($_POST['from'])) {
            [$year, $month, $day] = explode('/', $_POST['from']);
            $from = mktime(0, 0, 0, $month, $day, $year);
        } else {
            $from = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
        }

        if (!empty($_POST['to'])) {
            [$year, $month, $day] = explode('/', $_POST['to']);
            $to = mktime(23, 59, 59, $month, $day, $year);
        } else {
            $to = mktime(23, 59, 59, date('m'), date('d'), date('Y'));
        }

        $registry = isset($_POST['registry']) ? intval($_POST['registry']) : 0;
        $user = isset($_POST['user']) ? intval($_POST['user']) : 0;
        $group = isset($_POST['group']) ? intval($_POST['group']) : 0;
        $sorttype = $_POST['sorttype'] ?? null;
        $where = '';

        if ($registry) {
            $where .= ' AND regid = '.$registry;
        }
        if ($from) {
            $where .= ' AND cdate >= '.$from;
        }
        if ($to) {
            $where .= ' AND cdate <= '.$to;
        }
        if ($user) {
            $where .= ' AND userid = '.$user;
        }
        if ($group) {
                $groupwhere = ' AND '.(isset($_POST['groupexclude']) ? 'NOT' : '').'
			            EXISTS (SELECT 1 FROM vcustomerassignments a
				            WHERE a.customergroupid = '.$group.'
					    AND a.customerid = d.customerid)';
            $where .= $groupwhere;
        }

        if ($from > 0) {
            $listdata['startbalance'] = $DB->GetOne(
                'SELECT SUM(value * d.currencyvalue) FROM receiptcontents
						LEFT JOIN documents d ON (docid = d.id AND type = ?)
						WHERE cdate < ?'
                        .($registry ? ' AND regid='.$registry : '')
                        .($user ? ' AND userid='.$user : '')
                        .($group ? $groupwhere : '')
                        .' AND NOT EXISTS (
						        SELECT 1 FROM vcustomerassignments a
							JOIN excludedgroups e ON (a.customergroupid = e.customergroupid)
							WHERE e.userid = lms_current_user() AND a.customerid = d.customerid)',
                array(DOC_RECEIPT, $from)
            );
        }

        // Sorting
        switch ($sorttype) {
            case 'number':
                $sortcol = 'd.number';
                break;
            case 'cdate':
            default:
                $sortcol = 'd.cdate';
        }

        $listdata['totalincome'] = 0;
        $listdata['totalexpense'] = 0;
        $listdata['advances'] = 0;

        if ($list = $DB->GetAll(
            'SELECT d.id AS id, SUM(value) AS value, d.currency, d.currencyvalue, number, cdate, customerid,
				d.name, address, zip, city, numberplans.template, extnumber, closed,
				MIN(description) AS title, COUNT(*) AS posnumber
			FROM documents d
			LEFT JOIN numberplans ON (numberplanid = numberplans.id)
			LEFT JOIN receiptcontents ON (d.id = docid)
			WHERE d.type = ?'
            .$where.'
				AND NOT EXISTS (
					SELECT 1 FROM vcustomerassignments a
					JOIN excludedgroups e ON (a.customergroupid = e.customergroupid)
					WHERE e.userid = lms_current_user() AND a.customerid = d.customerid)
			GROUP BY d.id, number, cdate, customerid, d.name, address, zip, city, numberplans.template, extnumber, closed
			ORDER BY ' . $sortcol . ', d.id',
            array(DOC_RECEIPT)
        )) {
            foreach ($list as $idx => &$row) {
                $row['number'] = docnumber(array(
                    'number' => $row['number'],
                    'template' => $row['template'],
                    'cdate' => $row['cdate'],
                    'ext_num' => $row['extnumber'],
                ));
                $row['customer'] = $row['name'] . ' ' . $row['address'] . ' ' . $row['zip'] . ' ' . $row['city'];

                if ($row['posnumber'] > 1) {
                    $row['title'] = $DB->GetCol('SELECT description FROM receiptcontents WHERE docid = ? ORDER BY itemid', array($row['id']));
                }

                // summary
                if ($row['value'] > 0) {
                    $listdata['totalincome'] += $row['value'] * $row['currencyvalue'];
                } else {
                    $listdata['totalexpense'] += -$row['value'] * $row['currencyvalue'];
                }

                if (empty($idx)) {
                    $row['after'] = $listdata['startbalance'] + $row['value'] * $row['currencyvalue'];
                } else {
                    $row['after'] = $list[$idx - 1]['after'] + $row['value'] * $row['currencyvalue'];
                }

                if (!$row['closed']) {
                    $listdata['advances'] -= $row['value'] * $row['currencyvalue'];
                }
            }
            unset($row);
        }

        $listdata['endbalance'] = $listdata['startbalance'] + $listdata['totalincome'] - $listdata['totalexpense'];

        $from = date('Y/m/d', $from);
        $to = date('Y/m/d', $to);

        if ($from == $to) {
            $period = $from;
        } else {
            $period = $from.' - '.$to;
        }

        $layout['pagetitle'] = trans('Cash Report').' '.$period;

        if ($registry) {
            $layout['registry'] = trans('Registry: $a', ($registry ? $DB->GetOne('SELECT name FROM cashregs WHERE id=?', array($registry)) : trans('all')));
        }
        if ($user) {
            $layout['username'] = trans('Cashier: $a', $DB->GetOne('SELECT name FROM vusers WHERE id=?', array($user)));
        }
        if ($group) {
            $groupname = $DB->GetOne('SELECT name FROM customergroups WHERE id=?', array($group));

            if (isset($_POST['groupexclude'])) {
                $layout['group'] = trans('Group: all excluding $a', $groupname);
            } else {
                $layout['group'] = trans('Group: $a', $groupname);
            }
        }
        $SMARTY->assign('receiptlist', $list);
        $SMARTY->assign('listdata', $listdata);

        $csv = !empty($_POST['csv']);

        if ($csv) {
            $filename = 'receipts-' . date('YmdHis') . '.csv';
            header('Content-Type: text/csv; charset=utf-8');
            header('Content-Disposition: attachment; filename=' . $filename);
            header('Pragma: public');

            $SMARTY->display('print/printreceiptlist-csv.html');

            $SESSION->close();
            die;
        }

        if (isset($_POST['extended'])) {
                $pages = array();
            $totals = array();

            // hidden option: max records count for one page of printout
            // I think 20 records is fine, but someone needs 19.
            $rows = ConfigHelper::getConfig('phpui.printout_pagelimit', 20);

            // create a new array and do some calculations
            // (summaries and page size calculations)
            $maxrows = $rows * 2;   // dwie linie na rekord
            $counter = $maxrows;
            $rows = 0;      // rzeczywista liczba rekordów na stronie
            $i = 1;
            $x = 1;

            foreach ($list as $row) {
                // tutaj musimy trochę pokombinować, bo liczba
                // rekordów na stronie będzie zmienna
                $tmp = is_array($row['title']) ? count($row['title']) : 2;
                $counter -= max($tmp, 2);
                if ($counter<0) {
                    $x++;
                    $rows = 0;
                    $counter = $maxrows;
                }

                $rows++;
                $page = $x;

                if ($row['value'] > 0) {
                    if (!isset($totals[$page]['income'])) {
                        $totals[$page]['income'] = 0;
                    }
                    $totals[$page]['income'] += $row['value'] * $row['currencyvalue'];
                } else {
                    if (!isset($totals[$page]['expense'])) {
                        $totals[$page]['expense'] = 0;
                    }
                    $totals[$page]['expense'] += -$row['value'] * $row['currencyvalue'];
                }

                $totals[$page]['rows'] = $rows;
            }

            foreach ($totals as $page => $t) {
                $pages[] = $page;

                $totals[$page]['totalincome'] = ($totals[$page - 1]['totalincome'] ?? 0) + $t['income'];
                $totals[$page]['totalexpense'] = ($totals[$page - 1]['totalexpense'] ?? 0)
                    + ($t['expense'] ?? 0);
                $totals[$page]['rowstart'] = isset($totals[$page - 1]) ? $totals[$page - 1]['rowstart'] + $totals[$page - 1]['rows'] : 0;
            }

            $SMARTY->assign('pages', $pages);
            $SMARTY->assign('totals', $totals);
            $SMARTY->assign('pagescount', count($pages));
            $SMARTY->assign('reccount', empty($list) ? 0 : count($list));
            if (strtolower($report_type) == 'pdf') {
                $output = $SMARTY->fetch('print/printreceiptlist-ext.html');
                Utils::html2pdf(array(
                    'content' => $output,
                    'subject' => trans('Reports'),
                    'title' => $layout['pagetitle'],
                ));
            } else {
                $SMARTY->display('print/printreceiptlist-ext.html');
            }
        } else {
            if (strtolower($report_type) == 'pdf') {
                $output = $SMARTY->fetch('print/printreceiptlist.html');
                Utils::html2pdf(array(
                    'content' => $output,
                    'subject' => trans('Reports'),
                    'title' => $layout['pagetitle'],
                ));
            } else {
                $SMARTY->display('print/printreceiptlist.html');
            }
        }
        break;

    default:
        /*******************************************************/

        $layout['pagetitle'] = trans('Reports');

        if (!ConfigHelper::checkConfig('phpui.big_networks')) {
            $SMARTY->assign('customers', $LMS->GetCustomerNames());
        }
        $SMARTY->assign('users', $LMS->GetUserNames());
        $SMARTY->assign('networks', $LMS->GetNetworks());
        $SMARTY->assign('customergroups', $LMS->CustomergroupGetAll());
        $SMARTY->assign('numberplans', $LMS->GetNumberPlans(array(
            'doctype' => array(DOC_INVOICE, DOC_CNOTE),
        )));
        $SMARTY->assign('cashreglist', $DB->GetAllByKey('SELECT id, name FROM cashregs ORDER BY name', 'id'));
        $SMARTY->assign('divisions', $LMS->GetDivisions());
        $SMARTY->assign('sourcelist', $LMS->getCashSources());
        $SMARTY->assign('printmenu', 'finances');

        $SMARTY->assign('invprojects', $LMS->GetProjects());

        $SMARTY->assign('promotions', $LMS->GetPromotions());

        $SMARTY->display('print/printindex.html');

        break;
}
