[2026-01-17 19:04:47] live.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' (SQL: select count(*) as aggregate from (select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`invoice_no`, `contacts`.`name`, `transactions`.`zatca_status`, `contacts`.`supplier_business_name`, `transactions`.`final_total`, `transactions`.`payment_status`, `bl`.`name` as `business_location`, `T1`.`invoice_no` as `parent_sale`, `T1`.`id` as `parent_sale_id`, SUM(TP.amount) as amount_paid from `transactions` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` inner join `business_locations` as `bl` on `transactions`.`location_id` = `bl`.`id` inner join `transactions` as `T1` on `transactions`.`return_parent_id` = `T1`.`id` left join `transaction_payments` as `TP` on `transactions`.`id` = `TP`.`transaction_id` where `transactions`.`business_id` = 1 and `transactions`.`type` = sell_return and `transactions`.`status` = final and `transactions`.`location_id` in (1) and `transactions`.`created_by` = 2 and date(`transactions`.`transaction_date`) >= 2025-05-01 and date(`transactions`.`transaction_date`) <= 2026-04-30 group by `transactions`.`id`) count_row_table) {"userId":2,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' (SQL: select count(*) as aggregate from (select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`invoice_no`, `contacts`.`name`, `transactions`.`zatca_status`, `contacts`.`supplier_business_name`, `transactions`.`final_total`, `transactions`.`payment_status`, `bl`.`name` as `business_location`, `T1`.`invoice_no` as `parent_sale`, `T1`.`id` as `parent_sale_id`, SUM(TP.amount) as amount_paid from `transactions` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` inner join `business_locations` as `bl` on `transactions`.`location_id` = `bl`.`id` inner join `transactions` as `T1` on `transactions`.`return_parent_id` = `T1`.`id` left join `transaction_payments` as `TP` on `transactions`.`id` = `TP`.`transaction_id` where `transactions`.`business_id` = 1 and `transactions`.`type` = sell_return and `transactions`.`status` = final and `transactions`.`location_id` in (1) and `transactions`.`created_by` = 2 and date(`transactions`.`transaction_date`) >= 2025-05-01 and date(`transactions`.`transaction_date`) <= 2026-04-30 group by `transactions`.`id`) count_row_table) at /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)
[stacktrace]
#0 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()
#2 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()
#3 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\\Database\\Query\\Builder->get()
#7 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\\Database\\Query\\Builder->aggregate()
#8 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(215): Illuminate\\Database\\Query\\Builder->count()
#9 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(190): Yajra\\DataTables\\QueryDataTable->count()
#10 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(139): Yajra\\DataTables\\QueryDataTable->totalCount()
#11 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(99): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#12 /home/opulaopw/pos.opulencehavengh.com/app/Http/Controllers/SellReturnController.php(253): Yajra\\DataTables\\QueryDataTable->make()
#13 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SellReturnController->index()
#14 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#15 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#16 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#17 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#18 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#19 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CheckUserLogin->handle()
#21 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/AdminSidebarMenu.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#23 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle()
#25 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle()
#27 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle()
#29 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle()
#31 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#33 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#35 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#39 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#41 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle()
#42 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#44 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#46 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then()
#48 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack()
#49 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute()
#50 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute()
#51 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch()
#52 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#53 /home/opulaopw/pos.opulencehavengh.com/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle()
#55 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#57 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#58 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#60 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#61 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#62 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#63 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#65 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle()
#67 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#69 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then()
#71 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#72 /home/opulaopw/pos.opulencehavengh.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle()
#73 {main}

[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' at /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414)
[stacktrace]
#0 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()
#1 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()
#4 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()
#5 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\\Database\\Query\\Builder->get()
#9 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\\Database\\Query\\Builder->aggregate()
#10 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(215): Illuminate\\Database\\Query\\Builder->count()
#11 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(190): Yajra\\DataTables\\QueryDataTable->count()
#12 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(139): Yajra\\DataTables\\QueryDataTable->totalCount()
#13 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(99): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#14 /home/opulaopw/pos.opulencehavengh.com/app/Http/Controllers/SellReturnController.php(253): Yajra\\DataTables\\QueryDataTable->make()
#15 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SellReturnController->index()
#16 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#17 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#18 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#19 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#20 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#21 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CheckUserLogin->handle()
#23 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/AdminSidebarMenu.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#25 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle()
#27 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle()
#29 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle()
#31 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle()
#33 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#35 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#37 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#39 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#41 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#43 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle()
#44 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#48 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then()
#50 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack()
#51 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute()
#52 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute()
#53 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch()
#54 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#55 /home/opulaopw/pos.opulencehavengh.com/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle()
#57 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#58 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#59 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#60 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#62 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#63 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#65 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#67 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle()
#69 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#71 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then()
#73 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#74 /home/opulaopw/pos.opulencehavengh.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle()
#75 {main}
"} 
[2026-01-17 19:04:55] live.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' (SQL: select count(*) as aggregate from (select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`invoice_no`, `contacts`.`name`, `transactions`.`zatca_status`, `contacts`.`supplier_business_name`, `transactions`.`final_total`, `transactions`.`payment_status`, `bl`.`name` as `business_location`, `T1`.`invoice_no` as `parent_sale`, `T1`.`id` as `parent_sale_id`, SUM(TP.amount) as amount_paid from `transactions` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` inner join `business_locations` as `bl` on `transactions`.`location_id` = `bl`.`id` inner join `transactions` as `T1` on `transactions`.`return_parent_id` = `T1`.`id` left join `transaction_payments` as `TP` on `transactions`.`id` = `TP`.`transaction_id` where `transactions`.`business_id` = 1 and `transactions`.`type` = sell_return and `transactions`.`status` = final and `transactions`.`location_id` in (1) and `transactions`.`created_by` = 2 and date(`transactions`.`transaction_date`) >= 2026-01-17 and date(`transactions`.`transaction_date`) <= 2026-01-17 group by `transactions`.`id`) count_row_table) {"userId":2,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' (SQL: select count(*) as aggregate from (select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`invoice_no`, `contacts`.`name`, `transactions`.`zatca_status`, `contacts`.`supplier_business_name`, `transactions`.`final_total`, `transactions`.`payment_status`, `bl`.`name` as `business_location`, `T1`.`invoice_no` as `parent_sale`, `T1`.`id` as `parent_sale_id`, SUM(TP.amount) as amount_paid from `transactions` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` inner join `business_locations` as `bl` on `transactions`.`location_id` = `bl`.`id` inner join `transactions` as `T1` on `transactions`.`return_parent_id` = `T1`.`id` left join `transaction_payments` as `TP` on `transactions`.`id` = `TP`.`transaction_id` where `transactions`.`business_id` = 1 and `transactions`.`type` = sell_return and `transactions`.`status` = final and `transactions`.`location_id` in (1) and `transactions`.`created_by` = 2 and date(`transactions`.`transaction_date`) >= 2026-01-17 and date(`transactions`.`transaction_date`) <= 2026-01-17 group by `transactions`.`id`) count_row_table) at /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)
[stacktrace]
#0 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()
#2 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()
#3 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\\Database\\Query\\Builder->get()
#7 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\\Database\\Query\\Builder->aggregate()
#8 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(215): Illuminate\\Database\\Query\\Builder->count()
#9 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(190): Yajra\\DataTables\\QueryDataTable->count()
#10 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(139): Yajra\\DataTables\\QueryDataTable->totalCount()
#11 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(99): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#12 /home/opulaopw/pos.opulencehavengh.com/app/Http/Controllers/SellReturnController.php(253): Yajra\\DataTables\\QueryDataTable->make()
#13 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SellReturnController->index()
#14 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#15 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#16 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#17 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#18 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#19 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CheckUserLogin->handle()
#21 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/AdminSidebarMenu.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#23 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle()
#25 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle()
#27 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle()
#29 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle()
#31 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#33 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#35 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#39 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#41 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle()
#42 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#44 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#46 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then()
#48 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack()
#49 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute()
#50 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute()
#51 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch()
#52 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#53 /home/opulaopw/pos.opulencehavengh.com/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle()
#55 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#57 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#58 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#60 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#61 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#62 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#63 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#65 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle()
#67 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#69 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then()
#71 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#72 /home/opulaopw/pos.opulencehavengh.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle()
#73 {main}

[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.zatca_status' in 'SELECT' at /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414)
[stacktrace]
#0 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()
#1 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\\Database\\Connection->run()
#4 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Connection->select()
#5 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3157): Illuminate\\Database\\Query\\Builder->get()
#9 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3085): Illuminate\\Database\\Query\\Builder->aggregate()
#10 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(215): Illuminate\\Database\\Query\\Builder->count()
#11 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(190): Yajra\\DataTables\\QueryDataTable->count()
#12 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(139): Yajra\\DataTables\\QueryDataTable->totalCount()
#13 /home/opulaopw/pos.opulencehavengh.com/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(99): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#14 /home/opulaopw/pos.opulencehavengh.com/app/Http/Controllers/SellReturnController.php(253): Yajra\\DataTables\\QueryDataTable->make()
#15 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SellReturnController->index()
#16 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#17 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#18 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#19 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#20 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#21 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\CheckUserLogin->handle()
#23 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/AdminSidebarMenu.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#25 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Timezone.php(30): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Timezone->handle()
#27 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Language->handle()
#29 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetSessionData->handle()
#31 /home/opulaopw/pos.opulencehavengh.com/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\IsInstalled->handle()
#33 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#35 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#37 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#39 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#41 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#43 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle()
#44 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#48 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then()
#50 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack()
#51 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute()
#52 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute()
#53 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch()
#54 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#55 /home/opulaopw/pos.opulencehavengh.com/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle()
#57 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#58 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#59 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#60 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#61 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#62 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#63 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#65 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#67 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle()
#69 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#71 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#72 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then()
#73 /home/opulaopw/pos.opulencehavengh.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#74 /home/opulaopw/pos.opulencehavengh.com/public/index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle()
#75 {main}
"}