[2025-01-03 08:30:34] local.ERROR: ErrorException: Trying to get property 'kode' of non-object in /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php:355
Stack trace:
#0 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php(355): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, 'Trying to get p...', '/var/www/apps/h...', 355, Array)
#1 /var/www/apps/hris/app/Modules/Api/Http/Controllers/AbsenController.php(76): Modules\Api\Entities\Mdl_absen->cuti('M.23.006', '2025')
#2 [internal function]: Modules\Api\Http\Controllers\AbsenController->cuti(Object(Illuminate\Http\Request), 'M.23.006', '2025')
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('cuti', Array)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Api\Http\Controllers\AbsenController), 'cuti')
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#9 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#25 {main}  
[2025-01-03 09:57:26] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to a member function format() on boolean in /var/www/apps/hris/app/Http/Helpers/Helper.php:83
Stack trace:
#0 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/CetakAbsenController.php(68): format_date('Y-m-d', '1', 'd-m-Y')
#1 [internal function]: Modules\Satgas\Http\Controllers\CetakAbsenController->cari(Object(Illuminate\Http\Request))
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('cari', Array)
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\CetakAbsenController), 'cari')
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#8 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.cetak.in...')
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#11 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#51 {main}  
[2025-01-03 09:57:27] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to a member function format() on boolean in /var/www/apps/hris/app/Http/Helpers/Helper.php:83
Stack trace:
#0 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/CetakAbsenController.php(68): format_date('Y-m-d', '1', 'd-m-Y')
#1 [internal function]: Modules\Satgas\Http\Controllers\CetakAbsenController->cari(Object(Illuminate\Http\Request))
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('cari', Array)
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\CetakAbsenController), 'cari')
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#8 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.cetak.in...')
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#11 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#51 {main}  
[2025-01-03 14:01:47] local.ERROR: InvalidArgumentException: Malformed UTF-8 characters, possibly incorrectly encoded in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Http/JsonResponse.php:71
Stack trace:
#0 /var/www/apps/hris/vendor/symfony/http-foundation/JsonResponse.php(50): Illuminate\Http\JsonResponse->setData(Array)
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Http/JsonResponse.php(27): Symfony\Component\HttpFoundation\JsonResponse->__construct(Array, 200, Array)
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ResponseFactory.php(83): Illuminate\Http\JsonResponse->__construct(Array, 200, Array, 0)
#3 /var/www/apps/hris/app/Modules/Kepegawaian/Http/Controllers/KeluargaController.php(35): Illuminate\Routing\ResponseFactory->json(Array)
#4 [internal function]: Modules\Kepegawaian\Http\Controllers\KeluargaController->data_autocomplete(Object(Illuminate\Http\Request))
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_autocomple...', Array)
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Kepegawaian\Http\Controllers\KeluargaController), 'data_autocomple...')
#8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#11 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'kepegawaian.kel...')
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#17 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#54 {main}  
[2025-01-03 14:26:45] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%]
 in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute()
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array)
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#12 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#13 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#63 {main}

Next Illuminate\Database\QueryException: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%,%2%]
 (SQL: select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = 2024 and (LOWER(s.no_sppd) LIKE %2%  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE %2%  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE %2%  or LOWER(s.status) LIKE %2%  or LOWER("SPPD" s."UBAH_STATUS") LIKE %2% or LOWER("SPPD" s."OPEN_DATA") LIKE %2% or LOWER("SPPD" s."AKSI") LIKE %2% or LOWER("SPPD" s."CETAK") LIKE %2% or LOWER(ke.kota) LIKE %2%  or LOWER(s.maksud) LIKE %2%  or LOWER("SPPD" s."ID") LIKE %2% or LOWER("SPPD" s."CETAK_RINCI") LIKE %2% or LOWER("SPPD" s."CETAK_KWITANSI") LIKE %2%) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#10 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#11 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#61 {main}  
[2025-01-03 14:26:46] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%]
 in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute()
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array)
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#12 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#13 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#63 {main}

Next Illuminate\Database\QueryException: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%]
 (SQL: select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = 2024 and (LOWER(s.no_sppd) LIKE %202%  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE %202%  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE %202%  or LOWER(s.status) LIKE %202%  or LOWER("SPPD" s."UBAH_STATUS") LIKE %202% or LOWER("SPPD" s."OPEN_DATA") LIKE %202% or LOWER("SPPD" s."AKSI") LIKE %202% or LOWER("SPPD" s."CETAK") LIKE %202% or LOWER(ke.kota) LIKE %202%  or LOWER(s.maksud) LIKE %202%  or LOWER("SPPD" s."ID") LIKE %202% or LOWER("SPPD" s."CETAK_RINCI") LIKE %202% or LOWER("SPPD" s."CETAK_KWITANSI") LIKE %202%) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#10 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#11 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#61 {main}  
[2025-01-03 14:26:51] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%]
 in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute()
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array)
#2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#12 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#13 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#63 {main}

Next Illuminate\Database\QueryException: Error Code    : 907
Error Message : ORA-00907: missing right parenthesis
Position      : 910
Statement     : select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = :p0 and (LOWER(s.no_sppd) LIKE :p1  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE :p2  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE :p3  or LOWER(s.status) LIKE :p4  or LOWER("SPPD" s."UBAH_STATUS") LIKE :p5 or LOWER("SPPD" s."OPEN_DATA") LIKE :p6 or LOWER("SPPD" s."AKSI") LIKE :p7 or LOWER("SPPD" s."CETAK") LIKE :p8 or LOWER(ke.kota) LIKE :p9  or LOWER(s.maksud) LIKE :p10  or LOWER("SPPD" s."ID") LIKE :p11 or LOWER("SPPD" s."CETAK_RINCI") LIKE :p12 or LOWER("SPPD" s."CETAK_KWITANSI") LIKE :p13) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table
Bindings      : [2024,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%,%202%]
 (SQL: select count(*) as aggregate from (select "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "S"."TANGGAL_SPPD", wm_concat(concat(coalesce(dr.kota,st.dari_ln), concat(' - ', coalesce(ke.kota,st.ke_ln)))) as tujuan, "SA"."APPROVED", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI" from "SPPD" s left join "SPPD_TUJUAN" st on "ST"."SPPD_ID" = "S"."ID" left join "DATA_KOTA" dr on "DR"."ID" = "ST"."DARI" left join "DATA_KOTA" ke on "KE"."ID" = "ST"."KE" left join (select sppd_id, listagg(case when bypass = 1 then bypass else approved end, ',') within group (ORDER BY sppd_id) as approved from sppd_approval group by sppd_id) sa on "SA"."SPPD_ID" = "S"."ID" left join (select sppd_id, open_data from sppd_laporan group by sppd_id, open_data) lap on "LAP"."SPPD_ID" = "S"."ID" where "S"."PERIODE" = 2024 and (LOWER(s.no_sppd) LIKE %202%  or TO_CHAR(s.berangkat,'DD-MM-YYYY') LIKE %202%  or TO_CHAR(s.kembali,'DD-MM-YYYY') LIKE %202%  or LOWER(s.status) LIKE %202%  or LOWER("SPPD" s."UBAH_STATUS") LIKE %202% or LOWER("SPPD" s."OPEN_DATA") LIKE %202% or LOWER("SPPD" s."AKSI") LIKE %202% or LOWER("SPPD" s."CETAK") LIKE %202% or LOWER(ke.kota) LIKE %202%  or LOWER(s.maksud) LIKE %202%  or LOWER("SPPD" s."ID") LIKE %202% or LOWER("SPPD" s."CETAK_RINCI") LIKE %202% or LOWER("SPPD" s."CETAK_KWITANSI") LIKE %202%) group by "S"."ID", "S"."NO_SPPD", "S"."MAKSUD", "S"."BERANGKAT", "S"."KEMBALI", "S"."KENDARAAN", "S"."STATUS", "SA"."APPROVED", "S"."TANGGAL_SPPD", "S"."CETAK_RINCI", "S"."CETAK_KWITANSI", "LAP"."OPEN_DATA", "S"."KETERANGAN_REVISI") count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647
Stack trace:
#0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true)
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect()
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array)
#6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count()
#7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count()
#8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords()
#9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false)
#10 /var/www/apps/hris/app/Modules/Sppd/Http/Controllers/PembuatanController.php(603): Yajra\Datatables\Engines\QueryBuilderEngine->make(true)
#11 [internal function]: Modules\Sppd\Http\Controllers\PembuatanController->data_sppd(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_sppd', Array)
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Sppd\Http\Controllers\PembuatanController), 'data_sppd')
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'sppd.pembuatan....')
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#61 {main}  
[2025-01-03 18:16:03] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Parse error: syntax error, unexpected 'public' (T_PUBLIC) in /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/ShiftController.php:350
Stack trace:
#0 /var/www/apps/hris/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile('/var/www/apps/h...')
#1 [internal function]: Composer\Autoload\ClassLoader->loadClass('Modules\\Satgas\\...')
#2 [internal function]: spl_autoload_call('Modules\\Satgas\\...')
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/Container.php(681): ReflectionClass->__construct('Modules\\Satgas\\...')
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/Container.php(565): Illuminate\Container\Container->build('Modules\\Satgas\\...')
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(702): Illuminate\Container\Container->make('Modules\\Satgas\\...')
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(217): Illuminate\Foundation\Application->make('Modules\\Satgas\\...')
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(726): Illuminate\Routing\Route->getController()
#8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(687): Illuminate\Routing\Route->controllerMiddleware()
#9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->gatherMiddleware()
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(552): Illuminate\Routing\Router->gatherRouteMiddleware(Object(Illuminate\Routing\Route))
#11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#22 {main}  
[2025-01-03 19:28:53] local.ERROR: ErrorException: Trying to get property 'kode' of non-object in /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php:355
Stack trace:
#0 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php(355): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, 'Trying to get p...', '/var/www/apps/h...', 355, Array)
#1 /var/www/apps/hris/app/Modules/Api/Http/Controllers/AbsenController.php(76): Modules\Api\Entities\Mdl_absen->cuti('M.23.006', '2025')
#2 [internal function]: Modules\Api\Http\Controllers\AbsenController->cuti(Object(Illuminate\Http\Request), 'M.23.006', '2025')
#3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('cuti', Array)
#5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Api\Http\Controllers\AbsenController), 'cuti')
#6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#9 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure))
#11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#24 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#25 {main}