:-(
Przepraszamy, wystąpił błąd...
Komunikat: Undefined index: saldo
Plik: /modules/ModMKCharges/php/ModMKCharges.php L:575
Trace:
:#0 ErrorHandler->shutdownHandler(Array ([type] => 8,[message] => Undefined index: saldo,[file] => /modules/ModMKCharges/php/ModMKCharges.php,[line] => 575,[backtrace] => Array ([0] => Array ([file] => /classes/ErrorHandler.class.php,[line] => 47,[function] => shutdownHandler,[class] => ErrorHandler,[object] => ErrorHandler Object ([template] => debug.php,[mode] => page,[ * message] => ,[ Exception string] => ,[ * code] => 0,[ * file] => /classes/ErrorHandler.class.php,[ * line] => 33,[ Exception trace] => Array ([0] => Array ([file] => /index.php,[line] => 63,[function] => get,[class] => ErrorHandler,[type] => ::,[args] => Array ())),[ Exception previous] => ,[ * severity] => 1),[type] => ->,[args] => Array ([0] => Array ([type] => 8,[message] => Undefined index: saldo,[file] => /modules/ModMKCharges/php/ModMKCharges.php,[line] => 575))),[1] => Array ([file] => /modules/ModMKCharges/php/ModMKCharges.php,[line] => 575,[function] => errorHandler,[class] => ErrorHandler,[object] => ErrorHandler Object ([template] => debug.php,[mode] => page,[ * message] => ,[ Exception string] => ,[ * code] => 0,[ * file] => /classes/ErrorHandler.class.php,[ * line] => 33,[ Exception trace] => Array ([0] => Array ([file] => /index.php,[line] => 63,[function] => get,[class] => ErrorHandler,[type] => ::,[args] => Array ())),[ Exception previous] => ,[ * severity] => 1),[type] => ->,[args] => Array ([0] => 8,[1] => Undefined index: saldo,[2] => /modules/ModMKCharges/php/ModMKCharges.php,[3] => 575,[4] => Array ([dataOd] => 2000-01-01,[dataDo] => 2024-04-26,[ajax] => 0,[userId] => ,[sql] => SELECT ((SELECTIFNULL(SUM(obrot), 0) as saldoFROMform_users_oplaty fuoLEFT OUTER JOIN form_przesylka p on fuo.przesylka_id = p.idWHEREfuo.user_id = u.id AND((p.dic_status_id IS NULL) ORp.dic_status_id not in (select id from form_dictionary fd where fd.type = 'status' and fd.string_value in ('anulowana'))) ANDfuo.faktura_id IS NULL ANDfuo.adt >= '2000-01-01 00:00:00' AND fuo.adt <= '2024-04-26 23:59:59') + (SELECTIFNULL(SUM(obrot), 0) as saldoFROMform_users_oplaty fuoJOIN form_faktury f ON fuo.faktura_id = f.idWHEREfuo.user_id = u.id AND((f.dic_fakturastatus_id != 310 AND f.uwagi like '%Opłaty za okres%') OR f.id IS NULL) ANDfuo.user_id = u.id ANDf.data_wystawienia >= '2000-01-01 00:00:00' AND f.data_wystawienia <= '2024-04-26 23:59:59')) as saldoFROMusers uWHEREu.id = :user_id,[db] => DB Object ([ DB pdo] => PDO Object (),[ * transactionCounter] => 0,[ DB errors] => ,[ DB errorMessage] => ,[ DB errorCode] => ,[ DB errorInfo] => ),[row] => Array ()))),[2] => Array ([file] => /modules/ModMKCharges/php/ModMKCharges.php,[line] => 221,[function] => getTotalCharges,[class] => ModMKCharges,[type] => ::,[args] => Array ()),[3] => Array ([file] => /modules/ModMKCharges/php/ModMKCharges.php,[line] => 59,[function] => prepareTemplateData,[class] => ModMKCharges,[object] => ModMKCharges Object ([ ModMKCharges db] => DB Object ([ DB pdo] => PDO Object (),[ * transactionCounter] => 0,[ DB errors] => ,[ DB errorMessage] => ,[ DB errorCode] => ,[ DB errorInfo] => ),[ Module name] => Saldo i płatności,[privilege] => Array ([0] => SUPERADMIN),[showInMenu] => ,[ Module description] => ,[ Module workMode] => e,[ * tpl] => Template Object ([loader] => Twig\Loader\FilesystemLoader Object ([ * paths] => Array ([__main__] => Array ([0] => //modules/ModMKCharges/tpl)),[ * cache] => Array (),[ * errorCache] => Array (),[ Twig\Loader\FilesystemLoader rootPath] => //),[environment] => Twig\Environment Object ([ Twig\Environment charset] => UTF-8,[ Twig\Environment loader] => Twig\Loader\FilesystemLoader Object ([ * paths] => Array ([__main__] => Array ([0] => //modules/ModMKCharges/tpl)),[ * cache] => Array (),[ * errorCache] => Array (),[ Twig\Loader\FilesystemLoader rootPath] => //),[ Twig\Environment debug] => 1,[ Twig\Environment autoReload] => 1,[ Twig\Environment cache] => Twig\Cache\FilesystemCache Object ([ Twig\Cache\FilesystemCache directory] => //cache/,[ Twig\Cache\FilesystemCache options] => 0),[ Twig\Environment lexer] => ,[ Twig\Environment parser] => ,[ Twig\Environment compiler] => ,[ Twig\Environment baseTemplateClass] => \Twig\Template,[ Twig\Environment globals] => Array (),[ Twig\Environment resolvedGlobals] => ,[ Twig\Environment loadedTemplates] => ,[ Twig\Environment strictVariables] => 1,[ Twig\Environment templateClassPrefix] => __TwigTemplate_,[ Twig\Environment originalCache] => //cache,[ Twig\Environment extensionSet] => Twig\ExtensionSet Object ([ Twig\ExtensionSet extensions] => Array ([Twig\Extension\CoreExtension] => Twig\Extension\CoreExtension Object ([ Twig\Extension\CoreExtension dateFormats] => Array ([0] => F j, Y H:i,[1] => %d days),[ Twig\Extension\CoreExtension numberFormat] => Array ([0] => 0,[1] => .,[2] => ,),[ Twig\Extension\CoreExtension timezone] => ,[ Twig\Extension\CoreExtension escapers] => Array ()),[Twig\Extension\EscaperExtension] => Twig\Extension\EscaperExtension Object ([ Twig\Extension\EscaperExtension defaultStrategy] => html,[ Twig\Extension\EscaperExtension escapers] => Array (),[safeClasses] => Array (),[safeLookup] => Array ()),[Twig\Extension\OptimizerExtension] => Twig\Extension\OptimizerExtension Object ([ Twig\Extension\OptimizerExtension optimizers] => -1)),[ Twig\ExtensionSet initialized] => ,[ Twig\ExtensionSet runtimeInitialized] => ,[ Twig\ExtensionSet staging] => Twig\Extension\StagingExtension Object ([ Twig\Extension\StagingExtension functions] => Array ([L] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => L,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[vsprintf] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => vsprintf,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[create_url] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => create_url,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[create_template_url] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => create_template_url,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[abspath] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => abspath,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[helpbox] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => helpbox,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[minimod] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => minimod,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[generate_post_token] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => generate_post_token,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[generate_get_token] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => generate_get_token,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ())),[ Twig\Extension\StagingExtension filters] => Array (),[ Twig\Extension\StagingExtension visitors] => Array (),[ Twig\Extension\StagingExtension tokenParsers] => Array (),[ Twig\Extension\StagingExtension tests] => Array ()),[ Twig\ExtensionSet parsers] => ,[ Twig\ExtensionSet visitors] => ,[ Twig\ExtensionSet filters] => ,[ Twig\ExtensionSet tests] => ,[ Twig\ExtensionSet functions] => ,[ Twig\ExtensionSet unaryOperators] => ,[ Twig\ExtensionSet binaryOperators] => ,[ Twig\ExtensionSet globals] => ,[ Twig\ExtensionSet functionCallbacks] => Array (),[ Twig\ExtensionSet filterCallbacks] => Array (),[ Twig\ExtensionSet lastModified] => 0),[ Twig\Environment runtimeLoaders] => Array (),[ Twig\Environment runtimes] => Array (),[ Twig\Environment optionsHash] => ["Twig\\Extension\\CoreExtension","Twig\\Extension\\EscaperExtension","Twig\\Extension\\OptimizerExtension"]:7:4:2.14.11:1:\Twig\Template:1)),[ * logger] => ,[ * flash] => ),[type] => ->,[args] => Array ()),[4] => Array ([file] => /classes/Skeleton.class.php,[line] => 900,[function] => createForm,[class] => ModMKCharges,[object] => ModMKCharges Object ([ ModMKCharges db] => DB Object ([ DB pdo] => PDO Object (),[ * transactionCounter] => 0,[ DB errors] => ,[ DB errorMessage] => ,[ DB errorCode] => ,[ DB errorInfo] => ),[ Module name] => Saldo i płatności,[privilege] => Array ([0] => SUPERADMIN),[showInMenu] => ,[ Module description] => ,[ Module workMode] => e,[ * tpl] => Template Object ([loader] => Twig\Loader\FilesystemLoader Object ([ * paths] => Array ([__main__] => Array ([0] => //modules/ModMKCharges/tpl)),[ * cache] => Array (),[ * errorCache] => Array (),[ Twig\Loader\FilesystemLoader rootPath] => //),[environment] => Twig\Environment Object ([ Twig\Environment charset] => UTF-8,[ Twig\Environment loader] => Twig\Loader\FilesystemLoader Object ([ * paths] => Array ([__main__] => Array ([0] => //modules/ModMKCharges/tpl)),[ * cache] => Array (),[ * errorCache] => Array (),[ Twig\Loader\FilesystemLoader rootPath] => //),[ Twig\Environment debug] => 1,[ Twig\Environment autoReload] => 1,[ Twig\Environment cache] => Twig\Cache\FilesystemCache Object ([ Twig\Cache\FilesystemCache directory] => //cache/,[ Twig\Cache\FilesystemCache options] => 0),[ Twig\Environment lexer] => ,[ Twig\Environment parser] => ,[ Twig\Environment compiler] => ,[ Twig\Environment baseTemplateClass] => \Twig\Template,[ Twig\Environment globals] => Array (),[ Twig\Environment resolvedGlobals] => ,[ Twig\Environment loadedTemplates] => ,[ Twig\Environment strictVariables] => 1,[ Twig\Environment templateClassPrefix] => __TwigTemplate_,[ Twig\Environment originalCache] => //cache,[ Twig\Environment extensionSet] => Twig\ExtensionSet Object ([ Twig\ExtensionSet extensions] => Array ([Twig\Extension\CoreExtension] => Twig\Extension\CoreExtension Object ([ Twig\Extension\CoreExtension dateFormats] => Array ([0] => F j, Y H:i,[1] => %d days),[ Twig\Extension\CoreExtension numberFormat] => Array ([0] => 0,[1] => .,[2] => ,),[ Twig\Extension\CoreExtension timezone] => ,[ Twig\Extension\CoreExtension escapers] => Array ()),[Twig\Extension\EscaperExtension] => Twig\Extension\EscaperExtension Object ([ Twig\Extension\EscaperExtension defaultStrategy] => html,[ Twig\Extension\EscaperExtension escapers] => Array (),[safeClasses] => Array (),[safeLookup] => Array ()),[Twig\Extension\OptimizerExtension] => Twig\Extension\OptimizerExtension Object ([ Twig\Extension\OptimizerExtension optimizers] => -1)),[ Twig\ExtensionSet initialized] => ,[ Twig\ExtensionSet runtimeInitialized] => ,[ Twig\ExtensionSet staging] => Twig\Extension\StagingExtension Object ([ Twig\Extension\StagingExtension functions] => Array ([L] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => L,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[vsprintf] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => vsprintf,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[create_url] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => create_url,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[create_template_url] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => create_template_url,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[abspath] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => abspath,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[helpbox] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => helpbox,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[minimod] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => minimod,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[generate_post_token] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => generate_post_token,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ()),[generate_get_token] => Twig\TwigFunction Object ([ Twig\TwigFunction name] => generate_get_token,[ Twig\TwigFunction callable] => Closure Object (),[ Twig\TwigFunction options] => Array ([needs_environment] => ,[needs_context] => ,[is_variadic] => ,[is_safe] => ,[is_safe_callback] => ,[node_class] => Twig\Node\Expression\FunctionExpression,[deprecated] => ,[alternative] => ),[ Twig\TwigFunction arguments] => Array ())),[ Twig\Extension\StagingExtension filters] => Array (),[ Twig\Extension\StagingExtension visitors] => Array (),[ Twig\Extension\StagingExtension tokenParsers] => Array (),[ Twig\Extension\StagingExtension tests] => Array ()),[ Twig\ExtensionSet parsers] => ,[ Twig\ExtensionSet visitors] => ,[ Twig\ExtensionSet filters] => ,[ Twig\ExtensionSet tests] => ,[ Twig\ExtensionSet functions] => ,[ Twig\ExtensionSet unaryOperators] => ,[ Twig\ExtensionSet binaryOperators] => ,[ Twig\ExtensionSet globals] => ,[ Twig\ExtensionSet functionCallbacks] => Array (),[ Twig\ExtensionSet filterCallbacks] => Array (),[ Twig\ExtensionSet lastModified] => 0),[ Twig\Environment runtimeLoaders] => Array (),[ Twig\Environment runtimes] => Array (),[ Twig\Environment optionsHash] => ["Twig\\Extension\\CoreExtension","Twig\\Extension\\EscaperExtension","Twig\\Extension\\OptimizerExtension"]:7:4:2.14.11:1:\Twig\Template:1)),[ * logger] => ,[ * flash] => ),[type] => ->,[args] => Array ()),[5] => Array ([file] => /classes/Skeleton.class.php,[line] => 186,[function] => runModule,[class] => Skeleton,[type] => ::,[args] => Array ([0] => 1)),[6] => Array ([file] => /index.php,[line] => 75,[function] => __construct,[class] => Skeleton,[object] => Skeleton Object (),[type] => ->,[args] => Array ([0] => true))))) called at [/classes/ErrorHandler.class.php:47]#1 ErrorHandler->errorHandler(8, Undefined index: saldo, /modules/ModMKCharges/php/ModMKCharges.php, 575, Array ([dataOd] => 2000-01-01,[dataDo] => 2024-04-26,[ajax] => 0,[userId] => ,[sql] => SELECT ((SELECTIFNULL(SUM(obrot), 0) as saldoFROMform_users_oplaty fuoLEFT OUTER JOIN form_przesylka p on fuo.przesylka_id = p.idWHEREfuo.user_id = u.id AND((p.dic_status_id IS NULL) ORp.dic_status_id not in (select id from form_dictionary fd where fd.type = 'status' and fd.string_value in ('anulowana'))) ANDfuo.faktura_id IS NULL ANDfuo.adt >= '2000-01-01 00:00:00' AND fuo.adt <= '2024-04-26 23:59:59') + (SELECTIFNULL(SUM(obrot), 0) as saldoFROMform_users_oplaty fuoJOIN form_faktury f ON fuo.faktura_id = f.idWHEREfuo.user_id = u.id AND((f.dic_fakturastatus_id != 310 AND f.uwagi like '%Opłaty za okres%') OR f.id IS NULL) ANDfuo.user_id = u.id ANDf.data_wystawienia >= '2000-01-01 00:00:00' AND f.data_wystawienia <= '2024-04-26 23:59:59')) as saldoFROMusers uWHEREu.id = :user_id,[db] => DB Object ([ DB pdo] => PDO Object (),[ * transactionCounter] => 0,[ DB errors] => ,[ DB errorMessage] => ,[ DB errorCode] => ,[ DB errorInfo] => ),[row] => Array ())) called at [/modules/ModMKCharges/php/ModMKCharges.php:575]#2 ModMKCharges::getTotalCharges() called at [/modules/ModMKCharges/php/ModMKCharges.php:221]#3 ModMKCharges->prepareTemplateData() called at [/modules/ModMKCharges/php/ModMKCharges.php:59]#4 ModMKCharges->createForm() called at [/classes/Skeleton.class.php:900]#5 Skeleton::runModule(1) called at [/classes/Skeleton.class.php:186]#6 Skeleton->__construct(true) called at [/index.php:75]