$fields = array("NAME", "HOSTSEQUENCE", "DATESTART", "DATEEND", "OPENCASH", "CLOSECASH", "EXPECTEDCASH", "TICKETS", "SALES", "SALESVAT");
$mergeFields = array("MONEY");
$headers = array(\i18n("CashRegister.label"), \i18n("Session"), \i18n("Session.openDate"), \i18n("Session.closeDate"), \i18n("Session.openCash"), \i18n("Session.closeCash"), \i18n("Session.expectedCash"), \i18n("Tickets", PLUGIN_NAME), \i18n("Sales", PLUGIN_NAME), \i18n("Sales with VAT", PLUGIN_NAME));
$report = new \Pasteque\MergedReport(PLUGIN_NAME, "ztickets", \i18n("Z tickets", PLUGIN_NAME), $sqls, $headers, $fields, $mergeFields);
$report->addInput("start", \i18n("Start date"), \Pasteque\DB::DATE);
$report->setDefaultInput("start", time() - time() % 86400 - 7 * 86400);
$report->addInput("stop", \i18n("Stop date"), \Pasteque\DB::DATE);
$report->setDefaultinput("stop", time() - time() % 86400 + 86400);
function cashMatch($val, $values)
{
    if ($val != $values['CLOSECASH']) {
        return "<span style=\"color:#b00;\">" . \i18nCurr($val) . "</span>";
    }
    return $val;
}
$report->addFilter("DATESTART", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATESTART", "\\i18nDatetime");
$report->addFilter("DATEEND", "\\Pasteque\\stdtimefstr");
$report->addFilter("DATEEND", "\\i18nDatetime");
$report->setVisualFilter("OPENCASH", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("OPENCASH", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("CLOSECASH", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("CLOSECASH", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("EXPECTEDCASH", "\\BaseCashes\\cashMatch", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("EXPECTEDCASH", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("SALES", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("SALES", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setVisualFilter("SALESVAT", "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setVisualFilter("SALESVAT", "\\i18nFlt", \Pasteque\Report::DISP_CSV);
$report->setMergedVisualFilter(0, "\\i18nCurr", \Pasteque\Report::DISP_USER);
$report->setMergedVisualFilter(0, "\\i18nFlt", \Pasteque\Report::DISP_CSV);