[2026-07-15 09:18:55] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:18:58] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:49:08] live.INFO: AccountingReports: Running all migrations... [2026-07-15 08:49:11] live.INFO: AccountingReports: Migration completed. Output: INFO Running migrations. 2024_01_01_000001_create_chart_of_accounts_table ................ 176ms DONE 2024_01_01_000002_create_journal_entry_headers_table ............ 152ms DONE 2024_01_01_000003_create_journal_entry_lines_table .............. 192ms DONE 2024_01_01_000004_create_ledger_rollups_table .................... 63ms DONE 2024_01_01_000005_create_fifo_layers_table ...................... 152ms DONE 2024_01_01_000006_create_account_receivables_payables_table ..... 140ms DONE 2024_01_01_000007_create_period_locks_table ...................... 63ms DONE 2024_01_01_000008_create_bank_reconciliation_table .............. 120ms DONE 2024_01_01_000009_create_audit_log_table ......................... 55ms DONE 2024_01_01_000010_create_ratio_snapshots_table ................... 35ms DONE 2024_01_01_000011_create_direct_expenses_table .................. 105ms DONE 2024_01_01_000012_create_direct_expense_names_table .............. 57ms DONE 2024_01_01_000013_create_direct_income_names_table ............... 83ms DONE 2024_01_01_000014_create_direct_incomes_table ................... 176ms DONE 2024_01_01_000015_create_cheque_book_entries_table .............. 179ms DONE 2024_01_01_000016_create_cheque_books_table ..................... 136ms DONE 2024_01_01_000017_create_loans_table ............................ 119ms DONE 2024_01_01_000018_create_loan_transactions_table ................ 119ms DONE 2024_01_01_000019_create_fixed_assets_table ...................... 47ms DONE 2024_01_01_000020_add_fields_to_fixed_assets_table ................ 8ms DONE 2024_01_01_000021_add_revaluation_fields_to_fixed_assets_table ... 19ms DONE 2024_01_01_000022_create_fixed_asset_revaluations_table .......... 73ms DONE 2024_01_01_000023_create_capital_accounts_table .................. 54ms DONE 2024_01_01_000024_create_investments_table ....................... 65ms DONE 2024_01_01_000025_create_bank_accounts_table .................... 105ms DONE 2024_01_01_000026_add_opening_balance_transaction_to_bank_accounts 44ms DONE 2025_01_15_000001_add_account_transaction_id_to_bank_reconciliation 55ms DONE 2025_01_15_000002_add_bank_account_id_to_cheque_book_entries .... 126ms DONE 2025_01_15_000003_create_budgets_table ........................... 32ms DONE 2025_01_16_000001_add_available_status_to_cheque_book_entries .... 37ms DONE 2025_11_03_030547_add_category_id_to_direct_expenses_table ........ 0ms DONE 2025_12_16_005428_add_source_cheque_id_to_cheque_book_entries_table 75ms DONE 2025_12_16_010056_add_contact_and_deposit_account_to_cheque_book_entries_table 109ms DONE 2025_12_16_012618_make_journal_entry_line_id_nullable_in_bank_reconciliation_table 22ms DONE 2026_04_28_000001_create_cheque_print_templates_table ............ 41ms DONE 2026_04_28_000002_create_cheque_print_audit_log_table ............ 43ms DONE 2026_06_16_000001_seed_cheque_print_templates_for_all_bank_accounts 1ms DONE [2026-07-15 08:49:11] live.INFO: AccountingReports: All key tables verified successfully [2026-07-15 08:49:11] live.INFO: AccountingReports: Module installed successfully - Version 2.0.2 [2026-07-15 09:19:11] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:16] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:17] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:20] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:20] live.ERROR: There is no active transaction {"userId":1,"exception":"[object] (PDOException(code: 0): There is no active transaction at /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php:194) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(194): PDO->commit() #1 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\\Database\\Connection->commit() #2 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\\Database\\DatabaseManager->__call() #3 /home/payzrgld/cwm.payzync.online/Modules/Essentials/Http/Controllers/InstallController.php(152): Illuminate\\Support\\Facades\\Facade::__callStatic() #4 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\\Essentials\\Http\\Controllers\\InstallController->update() #5 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #6 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch() #7 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #8 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #9 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->{closure:Illuminate\\Routing\\Router::runRouteWithinStack():797}() #10 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/AdminSidebarMenu.php(1480): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #11 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle() #12 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #13 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle() #14 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #15 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle() #16 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #17 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle() #18 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #19 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle() #20 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #21 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #22 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #23 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle() #24 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #25 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #26 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #27 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #28 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #29 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #30 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #31 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #32 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #33 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #34 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #35 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #36 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(797): Illuminate\\Pipeline\\Pipeline->then() #37 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #38 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #39 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #40 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #41 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->{closure:Illuminate\\Foundation\\Http\\Kernel::dispatchToRouter():187}() #42 /home/payzrgld/cwm.payzync.online/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #43 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle() #44 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #45 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #46 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #47 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #48 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #49 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #50 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #51 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #52 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #53 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #54 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #55 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #56 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #57 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #58 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #59 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #60 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #61 /home/payzrgld/cwm.payzync.online/public/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle() #62 {main} "} [2026-07-15 09:19:25] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:35] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:39] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:40] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:43] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:44] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:47] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:48] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:58] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:19:59] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:20:04] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:20:04] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:20:53] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:21:58] live.INFO: MigrationManager: runPath ["database\/migrations\/2026_05_15_195106_add_is_advance_refund_to_transaction_payments_table.php","database\/migrations\/2026_05_25_223000_add_location_id_to_contacts_table.php","database\/migrations\/2026_05_26_224500_create_contact_locations_table.php","database\/migrations\/2026_06_08_074500_add_customer_permitted_locations_only_permission.php","database\/migrations\/2026_07_04_124600_add_is_free_promo_item_to_transaction_sell_lines_table.php"] by user #1 [2026-07-15 09:22:00] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:22:16] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:22:27] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:22:50] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:23:24] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:53:24] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:53:47] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:53:48] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:54:01] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:54:01] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:54:37] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:57:40] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:57:41] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:57:55] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:57:58] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:08] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:38] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:38] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:52] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:52] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:58:58] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:59:00] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:59:09] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 08:59:09] live.WARNING: ModuleUtil::getModuleData error in module Cms: Action Modules\Cms\Http\Controllers\CmsPageController@index not defined. [2026-07-15 09:00:22] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:00:23] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:00:53] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:00:55] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:01:24] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:01:25] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:02:02] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:02:04] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:03:27] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:03:29] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:04:26] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:04:29] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:05:33] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:05:37] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:11:30] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:11:31] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:11:31] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:11:31] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:11:31] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:11:32] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:11:32] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:11:32] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:28:04] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:28:04] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:28:04] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:28:04] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:28:05] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:28:05] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 09:28:05] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:28:05] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 09:32:03] live.WARNING: No transactions found in system for business_id: 1 [2026-07-15 09:32:03] live.INFO: Original end_date from request: 15/07/2026 [2026-07-15 09:32:03] live.INFO: Date converted manually from DD/MM/YYYY to: 2026-07-15 [2026-07-15 09:32:03] live.INFO: Final parameters - Date: 2026-07-15, Location: null, Business: 1 [2026-07-15 09:32:03] live.INFO: === SALES BREAKDOWN METHOD START === [2026-07-15 09:32:03] live.INFO: Parameters - Business ID: 1, Date: 2026-07-15, Location: null [2026-07-15 09:32:03] live.INFO: Base query built for business 1, date 2026-07-15 [2026-07-15 09:32:03] live.INFO: Final SQL query: select * from `transactions` where `business_id` = ? and `type` = ? and `status` = ? and date(`transaction_date`) = ? [2026-07-15 09:32:03] live.INFO: Query bindings: ["1","sell","final","2026-07-15"] [2026-07-15 09:32:03] live.INFO: Total transactions found: 0 [2026-07-15 09:32:03] live.WARNING: NO TRANSACTIONS FOUND! [2026-07-15 09:32:03] live.INFO: Total transactions in business: 0 [2026-07-15 09:32:03] live.INFO: Transactions for date 2026-07-15 (no filters): 0 [2026-07-15 09:32:03] live.INFO: Sell transactions for date 2026-07-15: 0 [2026-07-15 09:32:03] live.INFO: Final sell transactions for date 2026-07-15: 0 [2026-07-15 09:32:03] live.INFO: Raw SQL result: {"count":"0","subtotal":null,"tax":null,"discount":null,"total":null,"paid_amount":null,"due_amount":null,"partial_amount":null} [2026-07-15 09:32:03] live.INFO: Final processed result: {"count":0,"subtotal":0,"tax":0,"discount":0,"total":0,"paid_amount":0,"due_amount":0,"partial_amount":0} [2026-07-15 09:32:03] live.INFO: === SALES BREAKDOWN METHOD END === [2026-07-15 09:32:03] live.INFO: === GETTING MONTHLY CASH BREAKDOWN UP TO DATE: 2026-07-15 === [2026-07-15 09:32:03] live.INFO: Monthly cash breakdown calculated: [2026-07-15 09:35:05] live.ERROR: Division by zero {"userId":1,"exception":"[object] (DivisionByZeroError(code: 0): Division by zero at /home/payzrgld/cwm.payzync.online/Modules/AdvancedReports/Http/Controllers/TaxComplianceController.php:369) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/Modules/AdvancedReports/Http/Controllers/TaxComplianceController.php(108): Modules\\AdvancedReports\\Http\\Controllers\\TaxComplianceController->getTaxOptimizationInsights() #1 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\\AdvancedReports\\Http\\Controllers\\TaxComplianceController->getSummary() #2 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #3 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch() #4 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #5 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #6 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->{closure:Illuminate\\Routing\\Router::runRouteWithinStack():797}() #7 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/AdminSidebarMenu.php(21): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #8 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle() #9 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #10 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle() #11 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #12 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle() #13 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #14 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle() #15 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #16 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle() #17 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #18 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #19 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #20 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle() #21 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #22 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #23 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #24 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #25 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #26 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #27 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #28 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #29 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #30 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #31 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #32 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #33 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(797): Illuminate\\Pipeline\\Pipeline->then() #34 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #35 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #36 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #37 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #38 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->{closure:Illuminate\\Foundation\\Http\\Kernel::dispatchToRouter():187}() #39 /home/payzrgld/cwm.payzync.online/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #40 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle() #41 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #42 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #43 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #44 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #45 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #46 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #47 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #48 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #49 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #50 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #51 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #52 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #53 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #54 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #55 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #56 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #57 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #58 /home/payzrgld/cwm.payzync.online/public/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle() #59 {main} "} [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"category","name":"category","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"products_count","name":"products_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"contribution","name":"contribution","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"category","_":"1784088331873"} [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"brand","name":"brand","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"products_count","name":"products_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"market_share","name":"market_share","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"brand","_":"1784088331874"} [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"location","name":"location","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"transactions_count","name":"transactions_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"performance","name":"performance","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"location","_":"1784088331876"} [2026-07-15 09:35:33] live.INFO: Analysis type: category, Business ID: 1 [2026-07-15 09:35:33] live.INFO: Analysis type: location, Business ID: 1 [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"product","name":"product","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"quantity","name":"quantity","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"product","_":"1784088331872"} [2026-07-15 09:35:33] live.INFO: Analysis type: brand, Business ID: 1 [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"customer","name":"customer","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"orders_count","name":"orders_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"avg_order_value","name":"avg_order_value","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"customer","_":"1784088331875"} [2026-07-15 09:35:33] live.INFO: Analysis type: product, Business ID: 1 [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"staff","name":"staff","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"sales_count","name":"sales_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"commission","name":"commission","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"staff","_":"1784088331877"} [2026-07-15 09:35:33] live.INFO: Analysis type: staff, Business ID: 1 [2026-07-15 09:35:33] live.INFO: Analysis type: customer, Business ID: 1 [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"2","columns":[{"data":"product","name":"product","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"quantity","name":"quantity","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"start_date":"2026-07-01","end_date":"2026-07-31","location_id":null,"customer_id":null,"type":"product","_":"1784088331879"} [2026-07-15 09:35:33] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"invoice_no","name":"invoice_no","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"transaction_date","name":"transaction_date","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"customer_name","name":"customer_name","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"location_name","name":"location_name","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"payment_status","name":"payment_status","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"1","dir":"desc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"invoice","_":"1784088331878"} [2026-07-15 09:35:33] live.INFO: Analysis type: invoice, Business ID: 1 [2026-07-15 09:35:33] live.INFO: Analysis type: product, Business ID: 1 [2026-07-15 09:50:42] live.EMERGENCY: File:/home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Database/Connection.phpLine:760Message:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_warehouse_id' in 'SET' (SQL: update `business` set `default_warehouse_id` = 3, `business`.`updated_at` = 2026-07-15 09:50:42 where `id` = 1) [2026-07-15 09:50:50] live.EMERGENCY: File:/home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Database/Connection.phpLine:760Message:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default_warehouse_id' in 'SET' (SQL: update `business` set `default_warehouse_id` = 4, `business`.`updated_at` = 2026-07-15 09:50:50 where `id` = 1) [2026-07-15 09:53:10] live.ERROR: Error getting stock details: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale.deleted_at' in 'WHERE' (SQL: select COALESCE(c.name, 'No Category') as category_name, COALESCE(p.name, 'Unnamed Product') as product_name, COALESCE(SUM((purchase_lines.quantity - COALESCE(purchase_lines.quantity_returned, 0) - COALESCE(purchase_lines.quantity_adjusted, 0) - (SELECT COALESCE(SUM(COALESCE(tspl.quantity, 0) - COALESCE(tspl.qty_returned, 0)), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-01-01' AND sale.deleted_at IS NULL) ) * (COALESCE(purchase_lines.purchase_price, 0) + COALESCE(purchase_lines.item_tax, 0)) ), 0) as stock_value from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` left join `categories` as `c` on `c`.`id` = `p`.`category_id` where `purchase`.`business_id` = 1 and `purchase`.`type` != purchase_order and `purchase`.`deleted_at` is null and `purchase_lines`.`deleted_at` is null and (date(transaction_date) <= 2025-12-31 or date(transaction_date) = 2026-01-02 AND purchase.type='opening_stock') group by `c`.`id`, `c`.`name`, `p`.`id`, `p`.`name` having ABS(stock_value) > 0.01) [2026-07-15 09:53:10] live.ERROR: Error getting stock details: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale.deleted_at' in 'WHERE' (SQL: select COALESCE(c.name, 'No Category') as category_name, COALESCE(p.name, 'Unnamed Product') as product_name, COALESCE(SUM((purchase_lines.quantity - COALESCE(purchase_lines.quantity_returned, 0) - COALESCE(purchase_lines.quantity_adjusted, 0) - (SELECT COALESCE(SUM(COALESCE(tspl.quantity, 0) - COALESCE(tspl.qty_returned, 0)), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31' AND sale.deleted_at IS NULL) ) * (COALESCE(purchase_lines.purchase_price, 0) + COALESCE(purchase_lines.item_tax, 0)) ), 0) as stock_value from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` left join `categories` as `c` on `c`.`id` = `p`.`category_id` where `purchase`.`business_id` = 1 and `purchase`.`type` != purchase_order and `purchase`.`deleted_at` is null and `purchase_lines`.`deleted_at` is null and date(transaction_date) <= 2026-12-31 group by `c`.`id`, `c`.`name`, `p`.`id`, `p`.`name` having ABS(stock_value) > 0.01) [2026-07-15 09:53:10] live.INFO: Gross Profit Calculation: {"sales_gross":0.0,"sales_discount":0.0,"sales_net":0.0,"direct_income_total":0.0,"closing_stock":0.0,"opening_stock":0.0,"purchases":0.0,"direct_exp":0.0,"trading_credit_side":0.0,"trading_debit_side":0.0,"gross_profit_c_o":0.0} [2026-07-15 09:53:10] live.ERROR: Error getting expense transactions: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_for' in 'SELECT' (SQL: select COALESCE(NULLIF(transaction_for, ''), 'Other Expenses') as expense_name, COALESCE(SUM(total_before_tax), 0) as total from `transactions` where `business_id` = 1 and `type` = expense and `deleted_at` is null and `transaction_date` between 2026-01-01 and 2026-12-31 group by `transaction_for`) [2026-07-15 09:57:46] live.INFO: AccountingReports: Auto-posted expense journal entry for expense #3115 - Journal #1 [2026-07-15 11:10:20] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 11:12:35] live.ERROR: Call to a member function shipping_address() on null {"exception":"[object] (Error(code: 0): Call to a member function shipping_address() on null at /home/payzrgld/cwm.payzync.online/app/Utils/TransactionUtil.php:1249) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/test.php(9): App\\Utils\\TransactionUtil->getReceiptDetails() #1 {main} "} [2026-07-15 11:13:05] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 11:16:54] live.ERROR: Call to a member function toArray() on null {"exception":"[object] (Error(code: 0): Call to a member function toArray() on null at /home/payzrgld/cwm.payzync.online/test_receipt.php:8) [stacktrace] #0 {main} "} [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"product","name":"product","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"quantity","name":"quantity","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"product","_":"1784114471859"} [2026-07-15 16:55:31] live.INFO: Analysis type: product, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"category","name":"category","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"products_count","name":"products_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"contribution","name":"contribution","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"category","_":"1784114471860"} [2026-07-15 16:55:31] live.INFO: Analysis type: category, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"brand","name":"brand","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"products_count","name":"products_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"market_share","name":"market_share","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"brand","_":"1784114471861"} [2026-07-15 16:55:31] live.INFO: Analysis type: brand, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"customer","name":"customer","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"orders_count","name":"orders_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"avg_order_value","name":"avg_order_value","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"customer","_":"1784114471862"} [2026-07-15 16:55:31] live.INFO: Analysis type: customer, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"staff","name":"staff","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"sales_count","name":"sales_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"commission","name":"commission","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"staff","_":"1784114471864"} [2026-07-15 16:55:31] live.INFO: Analysis type: staff, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"location","name":"location","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"transactions_count","name":"transactions_count","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"performance","name":"performance","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"location","_":"1784114471863"} [2026-07-15 16:55:31] live.INFO: Analysis type: location, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"1","columns":[{"data":"invoice_no","name":"invoice_no","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"transaction_date","name":"transaction_date","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"customer_name","name":"customer_name","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"location_name","name":"location_name","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"payment_status","name":"payment_status","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"1","dir":"desc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"type":"invoice","_":"1784114471865"} [2026-07-15 16:55:31] live.INFO: Analysis type: invoice, Business ID: 1 [2026-07-15 16:55:31] live.INFO: getProfitAnalysis called with params: {"draw":"2","columns":[{"data":"product","name":"product","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"quantity","name":"quantity","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"revenue","name":"revenue","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"cost","name":"cost","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"profit","name":"profit","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"margin","name":"margin","searchable":"true","orderable":"true","search":{"value":null,"regex":"false"}},{"data":"action","name":"action","searchable":"false","orderable":"false","search":{"value":null,"regex":"false"}}],"order":[{"column":"0","dir":"asc"}],"start":"0","length":"25","search":{"value":null,"regex":"false"},"start_date":"2026-07-01","end_date":"2026-07-31","location_id":null,"customer_id":null,"type":"product","_":"1784114471866"} [2026-07-15 16:55:31] live.INFO: Analysis type: product, Business ID: 1 [2026-07-15 16:57:21] live.INFO: Today's sales for date 2026-07-15: 0 [2026-07-15 16:57:21] live.INFO: Today's purchases for date 2026-07-15: 12.0000 [2026-07-15 16:57:21] live.INFO: Today's expenses for date 2026-07-15: 15000.0000 [2026-07-15 16:57:21] live.INFO: === CALCULATING CASH IN HAND FOR DATE: 2026-07-15 === [2026-07-15 16:57:21] live.INFO: Cash in hand calculated for 2026-07-15: -1500.0000 [2026-07-15 16:57:21] live.INFO: === CALCULATING BANK BALANCE FOR DATE: 2026-07-15 === [2026-07-15 16:57:21] live.INFO: Bank balance calculated for 2026-07-15: 0 [2026-07-15 16:57:21] live.INFO: Today's collections for date 2026-07-15: 1500.0000 [2026-07-15 16:57:21] live.INFO: Calculating opening balance for date 2026-07-15, using previous date: 2026-07-14 [2026-07-15 16:57:21] live.INFO: === CALCULATING CASH IN HAND FOR DATE: 2026-07-14 === [2026-07-15 16:57:21] live.INFO: Cash in hand calculated for 2026-07-14: 0 [2026-07-15 16:57:21] live.INFO: === CALCULATING BANK BALANCE FOR DATE: 2026-07-14 === [2026-07-15 16:57:21] live.INFO: Bank balance calculated for 2026-07-14: 0 [2026-07-15 16:57:21] live.INFO: === DAILY REPORT DEBUG END === [2026-07-15 16:57:21] live.INFO: Original end_date from request: 15/07/2026 [2026-07-15 16:57:21] live.INFO: Date converted manually from DD/MM/YYYY to: 2026-07-15 [2026-07-15 16:57:21] live.INFO: Final parameters - Date: 2026-07-15, Location: null, Business: 1 [2026-07-15 16:57:21] live.INFO: === SALES BREAKDOWN METHOD START === [2026-07-15 16:57:21] live.INFO: Parameters - Business ID: 1, Date: 2026-07-15, Location: null [2026-07-15 16:57:21] live.INFO: Base query built for business 1, date 2026-07-15 [2026-07-15 16:57:21] live.INFO: Final SQL query: select * from `transactions` where `business_id` = ? and `type` = ? and `status` = ? and date(`transaction_date`) = ? [2026-07-15 16:57:21] live.INFO: Query bindings: ["1","sell","final","2026-07-15"] [2026-07-15 16:57:21] live.INFO: Total transactions found: 0 [2026-07-15 16:57:21] live.WARNING: NO TRANSACTIONS FOUND! [2026-07-15 16:57:21] live.INFO: Total transactions in business: 5 [2026-07-15 16:57:21] live.INFO: Transactions for date 2026-07-15 (no filters): 5 [2026-07-15 16:57:21] live.INFO: Sell transactions for date 2026-07-15: 1 [2026-07-15 16:57:21] live.INFO: Final sell transactions for date 2026-07-15: 0 [2026-07-15 16:57:21] live.INFO: Raw SQL result: {"count":"0","subtotal":null,"tax":null,"discount":null,"total":null,"paid_amount":null,"due_amount":null,"partial_amount":null} [2026-07-15 16:57:21] live.INFO: Final processed result: {"count":0,"subtotal":0,"tax":0,"discount":0,"total":0,"paid_amount":0,"due_amount":0,"partial_amount":0} [2026-07-15 16:57:21] live.INFO: === SALES BREAKDOWN METHOD END === [2026-07-15 16:57:21] live.INFO: === GETTING MONTHLY CASH BREAKDOWN UP TO DATE: 2026-07-15 === [2026-07-15 16:57:21] live.INFO: Monthly cash breakdown calculated: [{"month":"2026-07","month_name":"July 2026","transaction_count":1,"net_cash_flow":-1500.0,"running_total":-1500.0}] [2026-07-15 16:59:11] live.INFO: Product Category Analytics Request {"business_id":"1","start_date":"2026-06-16","end_date":"2026-07-15","location_ids":[],"category_ids":[]} [2026-07-15 16:59:11] live.INFO: Category contribution data {"categories_count":0,"summary":{"total_categories":0,"total_sales":0,"total_profit":0,"avg_margin":0},"raw_data":{"categories":{"Illuminate\\Support\\Collection":[]},"summary":{"total_categories":0,"total_sales":0,"total_profit":0,"avg_margin":0}}} [2026-07-15 16:59:11] live.INFO: Seasonal patterns monthly data count: 0 [2026-07-15 16:59:11] live.INFO: Seasonal patterns monthly sample: [] [2026-07-15 16:59:11] live.INFO: Processed monthly patterns: [] [2026-07-15 17:05:34] live.ERROR: Call to undefined method Modules\AccountingReports\Exports\TrialBalanceExport::download() {"userId":1,"exception":"[object] (Error(code: 0): Call to undefined method Modules\\AccountingReports\\Exports\\TrialBalanceExport::download() at /home/payzrgld/cwm.payzync.online/Modules/AccountingReports/Http/Controllers/TrialBalanceController.php:119) [stacktrace] #0 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Modules\\AccountingReports\\Http\\Controllers\\TrialBalanceController->export() #1 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction() #2 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch() #3 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController() #4 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run() #5 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->{closure:Illuminate\\Routing\\Router::runRouteWithinStack():797}() #6 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/AdminSidebarMenu.php(1480): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #7 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle() #8 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #9 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle() #10 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #11 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle() #12 /home/payzrgld/cwm.payzync.online/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #13 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle() #14 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #15 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #16 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #17 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle() #18 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #19 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle() #20 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #21 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle() #22 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #23 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest() #24 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle() #25 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #26 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle() #27 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #28 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle() #29 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #30 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(797): Illuminate\\Pipeline\\Pipeline->then() #31 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack() #32 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute() #33 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute() #34 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch() #35 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->{closure:Illuminate\\Foundation\\Http\\Kernel::dispatchToRouter():187}() #36 /home/payzrgld/cwm.payzync.online/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->{closure:Illuminate\\Pipeline\\Pipeline::prepareDestination():139}() #37 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle() #38 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #39 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #40 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle() #41 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #42 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #43 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle() #44 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #45 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #46 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #47 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle() #48 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #49 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle() #50 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #51 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle() #52 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->{closure:{closure:Illuminate\\Pipeline\\Pipeline::carry():155}:156}() #53 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then() #54 /home/payzrgld/cwm.payzync.online/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #55 /home/payzrgld/cwm.payzync.online/public/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle() #56 {main} "}