[2024-02-28 13:27:12] local.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tx_salidac.ctipdocu IN ('01', '03', 'NV') AND tx_salidac.cverif' at line 36 (SQL: SELECT t1.ccodalma, t1.idpersonal, t1.vendedor, SUM(totalComision) AS totalComision, SUM(cantidadVendida) AS cantidadVendida, SUM(cantidadDinero) AS cantidadDinero FROM ( SELECT gx_personal.ccodalma, gx_personal.idpersonal, CONCAT(gx_personal.cnombres, ' ', gx_personal.cpaterno, ' ', gx_personal.cmaterno) AS vendedor, SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS cantidadVendida, tx_salidad.cuniprod, tx_salidad.npreunit, tx_salidad.npreunit * SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS cantidadDinero, IF (tx_salidad.cuniprod = 'UNIDAD', IF(tx_salidad.ncanvent * tx_salidad.ncanprod > 5, IF(gx_modelo.comision_mayor IS NULL, 0, gx_modelo.comision_mayor), IF(gx_modelo.comision_unidad IS NULL, 0, gx_modelo.comision_unidad)), IF(gx_modelo.comision_mayor IS NULL, 0, gx_modelo.comision_mayor)) * SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS totalComision FROM tx_salidac, tx_salidad, gx_producto, gx_modelo, gx_personal WHERE tx_salidac.ccodinte = tx_salidad.ccodinte AND tx_salidad.ccodprod = gx_producto.ccodprod AND gx_producto.ccodmodelo = gx_modelo.ccodmodelo AND gx_personal.idpersonal = tx_salidac.ccodvend AND tx_salidac.ffecemis BETWEEN '2023-12-01' AND '2023-12-31' AND tx_salidac.nforpago IN (1, 2) AND tx_salidac.tipoVenta <> 'C' AND gx_personal.cactivo = 'S' AND gx_personal.idpersonal not in (87, 41) AND tx_salidac.canudocu <> 'S' AND tx_salidac.ccodalma in () AND tx_salidac.ctipdocu IN ('01', '03', 'NV') AND tx_salidac.cverif <> 'C' AND tx_salidad.ctipregi = 'P' GROUP BY tx_salidad.ccodprod, tx_salidad.cuniprod, tx_salidad.npreunit, tx_salidad.cdetdocu, tx_salidac.ccodvend, tx_salidad.ncanvent, tx_salidad.ncanprod, gx_modelo.comision_mayor, gx_modelo.comision_unidad ORDER BY gx_personal.idpersonal, gx_producto.ccodmodelo, tx_salidad.ccodprod ) AS t1 GROUP BY t1.idpersonal ORDER BY SUM(cantidadDinero) DESC) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tx_salidac.ctipdocu IN ('01', '03', 'NV') AND tx_salidac.cverif' at line 36 (SQL: SELECT t1.ccodalma, t1.idpersonal, t1.vendedor, SUM(totalComision) AS totalComision, SUM(cantidadVendida) AS cantidadVendida, SUM(cantidadDinero) AS cantidadDinero FROM ( SELECT gx_personal.ccodalma, gx_personal.idpersonal, CONCAT(gx_personal.cnombres, ' ', gx_personal.cpaterno, ' ', gx_personal.cmaterno) AS vendedor, SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS cantidadVendida, tx_salidad.cuniprod, tx_salidad.npreunit, tx_salidad.npreunit * SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS cantidadDinero, IF (tx_salidad.cuniprod = 'UNIDAD', IF(tx_salidad.ncanvent * tx_salidad.ncanprod > 5, IF(gx_modelo.comision_mayor IS NULL, 0, gx_modelo.comision_mayor), IF(gx_modelo.comision_unidad IS NULL, 0, gx_modelo.comision_unidad)), IF(gx_modelo.comision_mayor IS NULL, 0, gx_modelo.comision_mayor)) * SUM(tx_salidad.ncanvent * tx_salidad.ncanprod) AS totalComision FROM tx_salidac, tx_salidad, gx_producto, gx_modelo, gx_personal WHERE tx_salidac.ccodinte = tx_salidad.ccodinte AND tx_salidad.ccodprod = gx_producto.ccodprod AND gx_producto.ccodmodelo = gx_modelo.ccodmodelo AND gx_personal.idpersonal = tx_salidac.ccodvend AND tx_salidac.ffecemis BETWEEN '2023-12-01' AND '2023-12-31' AND tx_salidac.nforpago IN (1, 2) AND tx_salidac.tipoVenta <> 'C' AND gx_personal.cactivo = 'S' AND gx_personal.idpersonal not in (87, 41) AND tx_salidac.canudocu <> 'S' AND tx_salidac.ccodalma in () AND tx_salidac.ctipdocu IN ('01', '03', 'NV') AND tx_salidac.cverif <> 'C' AND tx_salidad.ctipregi = 'P' GROUP BY tx_salidad.ccodprod, tx_salidad.cuniprod, tx_salidad.npreunit, tx_salidad.cdetdocu, tx_salidac.ccodvend, tx_salidad.ncanvent, tx_salidad.ncanprod, gx_modelo.comision_mayor, gx_modelo.comision_unidad ORDER BY gx_personal.idpersonal, gx_producto.ccodmodelo, tx_salidad.ccodprod ) AS t1 GROUP BY t1.idpersonal ORDER BY SUM(cantidadDinero) DESC) at /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tx_salidac.ctipdocu IN ('01', '03', 'NV') AND tx_salidac.cverif' at line 36 at /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326) [stacktrace] #0 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback() #1 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\\Database\\Connection->run() #2 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(349): Illuminate\\Database\\Connection->select() #3 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(239): Illuminate\\Database\\DatabaseManager->__call() #4 /opt/bitnami/apache/htdocs/roggers-api/app/Http/Controllers/v3/IncentivoController.php(143): Illuminate\\Support\\Facades\\Facade::__callStatic() #5 [internal function]: App\\Http\\Controllers\\v3\\IncentivoController->getIncentivos() #6 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array() #7 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction() #8 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch() #9 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #10 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(680): Illuminate\\Routing\\Route->run() #11 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}() #12 /opt/bitnami/apache/htdocs/roggers-api/app/Http/Middleware/JwtMiddleware.php(34): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #13 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): App\\Http\\Middleware\\JwtMiddleware->handle() #14 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #15 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #16 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle() #17 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #18 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(58): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #19 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle() #20 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #21 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #22 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Pipeline\\Pipeline->then() #23 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(657): Illuminate\\Routing\\Router->runRouteWithinStack() #24 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(623): Illuminate\\Routing\\Router->runRoute() #25 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Router.php(612): Illuminate\\Routing\\Router->dispatchToRoute() #26 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch() #27 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}() #28 /opt/bitnami/apache/htdocs/roggers-api/vendor/barryvdh/laravel-cors/src/HandleCors.php(58): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #29 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Barryvdh\\Cors\\HandleCors->handle() #30 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #31 /opt/bitnami/apache/htdocs/roggers-api/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #32 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle() #33 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #34 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #35 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle() #36 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #37 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #38 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle() #39 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #40 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #41 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle() #42 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}() #43 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}() #44 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then() #45 /opt/bitnami/apache/htdocs/roggers-api/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter() #46 /opt/bitnami/apache/htdocs/roggers-api/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle() #47 {main} "}