[2024-03-22 12:20:29] local.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:326
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(326): PDO->prepare('select `d`.`cod...')
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select `d`.`cod...', Array)
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#8 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#9 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#10 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#11 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#19 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#21 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#23 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#25 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#29 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#31 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#33 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#35 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#37 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#43 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#44 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#45 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#46 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` inner join (select `tornaguia` as `tornaguia_duplicada`, COUNT(*) AS conteo from `seg_estampilla` group by `tornaguia` having COUNT(*) > 1) as `duplicadas` on `tornaguia` = `duplicadas`.`tornaguia_duplicada` where exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-03-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:664
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#9 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#10 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#21 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#23 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#25 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#31 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#33 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#35 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#37 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#39 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#43 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#44 {main} {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` inner join (select `tornaguia` as `tornaguia_duplicada`, COUNT(*) AS conteo from `seg_estampilla` group by `tornaguia` having COUNT(*) > 1) as `duplicadas` on `tornaguia` = `duplicadas`.`tornaguia_duplicada` where exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-03-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:664, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:326)
[stacktrace]
#0 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(333): Illuminate\\Database\\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2130): Illuminate\\Database\\Connection->select('select `d`.`cod...', Array, true)
#3 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2118): Illuminate\\Database\\Query\\Builder->runSelect()
#4 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2604): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2119): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(521): Illuminate\\Database\\Query\\Builder->get(Array)
#7 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(505): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)
#8 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Controllers\\EstampillasController.php(260): Illuminate\\Database\\Eloquent\\Builder->get()
#9 [internal function]: App\\Http\\Controllers\\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#12 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\Container.php(576): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(376): Illuminate\\Container\\Container->call(Array, Array)
#15 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(342): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(316): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(278): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(258): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#21 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Middleware\\ApiTTIMiddleware.php(18): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): App\\Http\\Middleware\\ApiTTIMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(259): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandlePreflight.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandlePreflight->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#35 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandleCors.php(58): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#36 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandleCors->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#37 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#38 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#39 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#40 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#41 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(171): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(108): Laravel\\Lumen\\Application->dispatch(NULL)
#43 C:\\TTI\\Apache24\\htdocs\\appmovil\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#44 {main}
"} 
[2024-03-22 13:46:20] local.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:326
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(326): PDO->prepare('select `d`.`cod...')
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select `d`.`cod...', Array)
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#8 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#9 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#10 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#11 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#19 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#21 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#23 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#25 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#29 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#31 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#33 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#35 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#37 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#43 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#44 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#45 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#46 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` where not exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-03-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:664
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#9 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#10 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#21 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#23 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#25 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#31 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#33 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#35 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#37 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#39 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#43 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#44 {main} {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` where not exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-03-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:664, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:326)
[stacktrace]
#0 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(333): Illuminate\\Database\\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2130): Illuminate\\Database\\Connection->select('select `d`.`cod...', Array, true)
#3 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2118): Illuminate\\Database\\Query\\Builder->runSelect()
#4 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2604): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2119): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(521): Illuminate\\Database\\Query\\Builder->get(Array)
#7 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(505): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)
#8 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Controllers\\EstampillasController.php(260): Illuminate\\Database\\Eloquent\\Builder->get()
#9 [internal function]: App\\Http\\Controllers\\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#12 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\Container.php(576): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(376): Illuminate\\Container\\Container->call(Array, Array)
#15 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(342): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(316): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(278): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(258): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#21 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Middleware\\ApiTTIMiddleware.php(18): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): App\\Http\\Middleware\\ApiTTIMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(259): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandlePreflight.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandlePreflight->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#35 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandleCors.php(58): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#36 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandleCors->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#37 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#38 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#39 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#40 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#41 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(171): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(108): Laravel\\Lumen\\Application->dispatch(NULL)
#43 C:\\TTI\\Apache24\\htdocs\\appmovil\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#44 {main}
"} 
[2024-03-22 13:46:31] local.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:326
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(326): PDO->prepare('select `d`.`cod...')
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('select `d`.`cod...', Array)
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#8 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#9 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#10 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#11 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#19 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#21 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#23 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#25 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#29 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#31 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#33 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#35 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#37 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#39 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#43 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#44 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#45 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#46 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` where not exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-01-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) in C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php:664
Stack trace:
#0 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(624): Illuminate\Database\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Connection.php(333): Illuminate\Database\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2130): Illuminate\Database\Connection->select('select `d`.`cod...', Array, true)
#3 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2118): Illuminate\Database\Query\Builder->runSelect()
#4 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Query\Builder.php(2119): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(521): Illuminate\Database\Query\Builder->get(Array)
#7 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\database\Eloquent\Builder.php(505): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 C:\TTI\Apache24\htdocs\appmovil\app\Http\Controllers\EstampillasController.php(260): Illuminate\Database\Eloquent\Builder->get()
#9 [internal function]: App\Http\Controllers\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\Lumen\Http\Request))
#10 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#12 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Laravel\Lumen\Application), Array, Object(Closure))
#13 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\container\Container.php(576): Illuminate\Container\BoundMethod::call(Object(Laravel\Lumen\Application), Array, Array, NULL)
#14 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(376): Illuminate\Container\Container->call(Array, Array)
#15 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(342): Laravel\Lumen\Application->callControllerCallable(Array, Array)
#16 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(316): Laravel\Lumen\Application->callLumenController(Object(App\Http\Controllers\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(278): Laravel\Lumen\Application->callControllerAction(Array)
#18 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(258): Laravel\Lumen\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#20 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#21 C:\TTI\Apache24\htdocs\appmovil\app\Http\Middleware\ApiTTIMiddleware.php(18): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#22 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): App\Http\Middleware\ApiTTIMiddleware->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#23 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#24 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#25 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#26 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#27 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(259): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(165): Laravel\Lumen\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}(Object(Laravel\Lumen\Http\Request))
#30 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#31 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandlePreflight.php(29): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#32 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandlePreflight->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#33 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#34 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#35 C:\TTI\Apache24\htdocs\appmovil\vendor\barryvdh\laravel-cors\src\HandleCors.php(58): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#36 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(163): Barryvdh\Cors\HandleCors->handle(Object(Laravel\Lumen\Http\Request), Object(Closure))
#37 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Laravel\Lumen\Http\Request))
#38 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Routing\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\Lumen\Http\Request))
#39 C:\TTI\Apache24\htdocs\appmovil\vendor\illuminate\pipeline\Pipeline.php(104): Laravel\Lumen\Routing\Pipeline->Laravel\Lumen\Routing\{closure}(Object(Laravel\Lumen\Http\Request))
#40 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(413): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#41 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(171): Laravel\Lumen\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\TTI\Apache24\htdocs\appmovil\vendor\laravel\lumen-framework\src\Concerns\RoutesRequests.php(108): Laravel\Lumen\Application->dispatch(NULL)
#43 C:\TTI\Apache24\htdocs\appmovil\public\index.php(28): Laravel\Lumen\Application->run()
#44 {main} {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' (SQL: select `d`.`codigo` as `valor_escaneado`, `s`.`lat`, `s`.`lon`, `s`.`fecha`, `s`.`historial_consultas_estampillas_por_operativo_id`, SUBSTRING(d.codigo, 3, 2) AS departamento from `seg_estampilla` as `s` inner join `detalle_codigos` as `d` on `d`.`serial` = `s`.`tornaguia` where not exists (select * from `historial_consultas_estampillas_por_operativo` where `seg_estampilla`.`historial_consultas_estampillas_por_operativo_id` = `historial_consultas_estampillas_por_operativo`.`id`) and date(`fecha`) >= 2024-01-01 and date(`fecha`) <= 2024-03-22 having `departamento` = 25 order by `fecha` desc) at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:664, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seg_estampilla.historial_consultas_estampillas_por_operativo_id' in 'where clause' at C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php:326)
[stacktrace]
#0 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('select `d`.`cod...', Array, Object(Closure))
#1 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Connection.php(333): Illuminate\\Database\\Connection->run('select `d`.`cod...', Array, Object(Closure))
#2 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2130): Illuminate\\Database\\Connection->select('select `d`.`cod...', Array, true)
#3 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2118): Illuminate\\Database\\Query\\Builder->runSelect()
#4 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2604): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Query\\Builder.php(2119): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure))
#6 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(521): Illuminate\\Database\\Query\\Builder->get(Array)
#7 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\database\\Eloquent\\Builder.php(505): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)
#8 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Controllers\\EstampillasController.php(260): Illuminate\\Database\\Eloquent\\Builder->get()
#9 [internal function]: App\\Http\\Controllers\\EstampillasController->obtenerLecturasEstampillas(Object(Laravel\\Lumen\\Http\\Request))
#10 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(90): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#12 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Laravel\\Lumen\\Application), Array, Object(Closure))
#13 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\container\\Container.php(576): Illuminate\\Container\\BoundMethod::call(Object(Laravel\\Lumen\\Application), Array, Array, NULL)
#14 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(376): Illuminate\\Container\\Container->call(Array, Array)
#15 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(342): Laravel\\Lumen\\Application->callControllerCallable(Array, Array)
#16 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(316): Laravel\\Lumen\\Application->callLumenController(Object(App\\Http\\Controllers\\EstampillasController), 'obtenerLecturas...', Array)
#17 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(278): Laravel\\Lumen\\Application->callControllerAction(Array)
#18 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(258): Laravel\\Lumen\\Application->callActionOnArrayBasedRoute(Array)
#19 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#20 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#21 C:\\TTI\\Apache24\\htdocs\\appmovil\\app\\Http\\Middleware\\ApiTTIMiddleware.php(18): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#22 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): App\\Http\\Middleware\\ApiTTIMiddleware->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#23 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#24 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#25 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#26 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#27 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(259): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#28 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(165): Laravel\\Lumen\\Application->handleFoundRoute(Array)
#29 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#30 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(52): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#31 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandlePreflight.php(29): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#32 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandlePreflight->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#33 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#34 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#35 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\barryvdh\\laravel-cors\\src\\HandleCors.php(58): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#36 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(163): Barryvdh\\Cors\\HandleCors->handle(Object(Laravel\\Lumen\\Http\\Request), Object(Closure))
#37 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#38 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Routing\\Pipeline.php(32): call_user_func(Object(Closure), Object(Laravel\\Lumen\\Http\\Request))
#39 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\illuminate\\pipeline\\Pipeline.php(104): Laravel\\Lumen\\Routing\\Pipeline->Laravel\\Lumen\\Routing\\{closure}(Object(Laravel\\Lumen\\Http\\Request))
#40 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(413): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#41 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(171): Laravel\\Lumen\\Application->sendThroughPipeline(Array, Object(Closure))
#42 C:\\TTI\\Apache24\\htdocs\\appmovil\\vendor\\laravel\\lumen-framework\\src\\Concerns\\RoutesRequests.php(108): Laravel\\Lumen\\Application->dispatch(NULL)
#43 C:\\TTI\\Apache24\\htdocs\\appmovil\\public\\index.php(28): Laravel\\Lumen\\Application->run()
#44 {main}
"}