[2024-12-31 15:41:34] local.ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sales_return" does not exist LINE 1: select * from "sales_return" where "store_id" <> '22' and ex... ^ (SQL: select * from "sales_return" where "store_id" <> 22 and exists (select * from "sale_return_info" where "sales_return"."id" = "sale_return_info"."sale_return_id" and "status_sync" = 0) order by "document_date" desc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"sales_return\" does not exist LINE 1: select * from \"sales_return\" where \"store_id\" <> '22' and ex... ^ (SQL: select * from \"sales_return\" where \"store_id\" <> 22 and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = 0) order by \"document_date\" desc) at C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:677) [stacktrace] #0 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(635): Illuminate\\Database\\Connection->runQueryCallback('select * from \"...', Array, Object(Closure)) #1 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(339): Illuminate\\Database\\Connection->run('select * from \"...', Array, Object(Closure)) #2 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2159): Illuminate\\Database\\Connection->select('select * from \"...', Array, true) #3 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect() #4 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(546): Illuminate\\Database\\Query\\Builder->get(Array) #7 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(530): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #8 C:\\wamp64\\www\\projects\\POS\\app\\Http\\Controllers\\PosTransactionsController.php(51): Illuminate\\Database\\Eloquent\\Builder->get() #9 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\PosTransactionsController->syncSalesReturn(NULL) #10 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('syncSalesReturn', Array) #11 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\PosTransactionsController), 'syncSalesReturn') #12 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(176): Illuminate\\Routing\\Route->runController() #13 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(681): Illuminate\\Routing\\Route->run() #14 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #15 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #16 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 60, '1') #19 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(683): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #21 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #22 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(624): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #23 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #24 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(170): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #25 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #26 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #28 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #30 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #31 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #32 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #34 C:\\wamp64\\www\\projects\\POS\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #38 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #39 C:\\wamp64\\www\\projects\\POS\\public\\index.php(58): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #40 {main} [previous exception] [object] (PDOException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"sales_return\" does not exist LINE 1: select * from \"sales_return\" where \"store_id\" <> '22' and ex... ^ at C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:336) [stacktrace] #0 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(336): PDOStatement->execute() #1 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(670): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from \"...', Array) #2 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(635): Illuminate\\Database\\Connection->runQueryCallback('select * from \"...', Array, Object(Closure)) #3 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(339): Illuminate\\Database\\Connection->run('select * from \"...', Array, Object(Closure)) #4 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2159): Illuminate\\Database\\Connection->select('select * from \"...', Array, true) #5 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2147): Illuminate\\Database\\Query\\Builder->runSelect() #6 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2619): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2148): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(546): Illuminate\\Database\\Query\\Builder->get(Array) #9 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Eloquent\\Builder.php(530): Illuminate\\Database\\Eloquent\\Builder->getModels(Array) #10 C:\\wamp64\\www\\projects\\POS\\app\\Http\\Controllers\\PosTransactionsController.php(51): Illuminate\\Database\\Eloquent\\Builder->get() #11 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\PosTransactionsController->syncSalesReturn(NULL) #12 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('syncSalesReturn', Array) #13 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\PosTransactionsController), 'syncSalesReturn') #14 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(176): Illuminate\\Routing\\Route->runController() #15 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(681): Illuminate\\Routing\\Route->run() #16 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #17 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(41): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #19 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #20 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 60, '1') #21 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #22 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(683): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #23 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(658): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #24 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(624): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #25 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(613): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #26 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(170): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #27 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(130): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #28 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #29 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #30 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #31 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #32 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #33 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #34 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 C:\\wamp64\\www\\projects\\POS\\vendor\\fideloper\\proxy\\src\\TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(171): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(105): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #39 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(145): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #40 C:\\wamp64\\www\\projects\\POS\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #41 C:\\wamp64\\www\\projects\\POS\\public\\index.php(58): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #42 {main} "}