06 02 2025 10:07:27 El Archivo 2025-02-06 - log_error.txt se ha creado ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1A0MDM5NDk1NSIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg4NTQ0NzMsImlhdCI6MTczODg1NDQyM30.0I-oLQsiNIFSe0Kl96sm4BFMpFf0gbAhhZVmLS26tMs -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 06 Feb 2025 15:07:22 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: syntax%20error%2C%20unexpected%20variable%20%22%24res_vendedor%22 X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fsrc%2FController%2FPtatController.php:391 Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 216958
$sqlVen = "SELECT ltrim(t.login,'CV') as cedula, (p.nombres || ' ' || p.apellido1) as nombres FROM CONTRATOSVENTA t, personas p,vinculado v,
(SELECT LOGIN,max(FECHAINICIO) max_fecha FROM CONTRATOSVENTA GROUP BY LOGIN) maximo
where maximo.LOGIN=t.LOGIN and maximo.max_fecha=t.FECHAINICIO and FECHAFINAL is null and p.DOCUMENTO = ltrim(t.login,'CV') and TRIM(v.VINCEDULA) = ltrim(t.login,'CV') and v.VINACTIVO ='1' $filtro";
$this->log->logs("")
$res_vendedor = $this->cnn->query('5', $sqlVen);
foreach ($res_vendedor as $row) array_push($vendedor, array("cedula" => $row['CEDULA'], "nombres" => $row['NOMBRES']));
return $vendedor;
}
*/
public function loadClass($class)
{
if ($file = $this->findFile($class)) {
$includeFile = self::$includeFile;
$includeFile($file);
return true;
}
return null;
return;
} elseif (false === include $file) {
return;
}
} else {
($this->classLoader)($class);
$file = '';
}
} finally {
error_reporting($e);
}
}
$autoloadedClass = self::$autoloadedClass;
self::$autoloadedClass = ltrim($this->resource, '\\');
try {
$exists[0] = class_exists($this->resource) || interface_exists($this->resource, false) || trait_exists($this->resource, false);
} catch (\Exception $e) {
$exists[1] = $e->getMessage();
try {
self::throwOnRequiredClass($this->resource, $e);
try {
if (isset($this->classReflectors[$class])) {
$classReflector = $this->classReflectors[$class];
} elseif (class_exists(ClassExistenceResource::class)) {
$resource = new ClassExistenceResource($class, false);
$classReflector = $resource->isFresh(0) ? false : new \ReflectionClass($class);
} else {
$classReflector = class_exists($class) ? new \ReflectionClass($class) : false;
}
} catch (\ReflectionException $e) {
if ($throw) {
if (!preg_match('/^[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*+(?:\\\\[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*+)*+$/', $class)) {
continue;
}
try {
$r = $this->container->getReflectionClass($class);
} catch (\ReflectionException $e) {
$classes[$class] = $e->getMessage();
continue;
}
// check to make sure the expected class exists
}
$source = \func_num_args() > 4 ? func_get_arg(4) : null;
$autoconfigureAttributes = new RegisterAutoconfigureAttributesPass();
$autoconfigureAttributes = $autoconfigureAttributes->accept($prototype) ? $autoconfigureAttributes : null;
$classes = $this->findClasses($namespace, $resource, (array) $exclude, $autoconfigureAttributes, $source);
// prepare for deep cloning
$serializedPrototype = serialize($prototype);
foreach ($classes as $class => $errorMessage) {
if (null === $errorMessage && $autoconfigureAttributes && $this->env) {
if (!\is_string($service['resource'])) {
throw new InvalidArgumentException(sprintf('A "resource" attribute must be of type string for service "%s" in "%s". Check your YAML syntax.', $id, $file));
}
$exclude = $service['exclude'] ?? null;
$namespace = $service['namespace'] ?? $id;
$this->registerClasses($definition, $namespace, $service['resource'], $exclude, $file);
} else {
$this->setDefinition($id, $definition);
}
}
}
$this->isLoadingInstanceof = false;
$defaults = $this->parseDefaults($content, $file);
foreach ($content['services'] as $id => $service) {
$this->parseDefinition($id, $service, $file, $defaults, false, $trackBindings);
}
}
/**
* @throws InvalidArgumentException
// services
$this->anonymousServicesCount = 0;
$this->anonymousServicesSuffix = '~'.ContainerBuilder::hash($path);
$this->setCurrentDir(\dirname($path));
try {
$this->parseDefinitions($content, $path);
} finally {
$this->instanceof = [];
$this->registerAliasesForSinglyImplementedInterfaces();
}
}
// empty file
if (null === $content) {
return null;
}
$this->loadContent($content, $path);
// per-env configuration
if ($this->env && isset($content['when@'.$this->env])) {
if (!\is_array($content['when@'.$this->env])) {
throw new InvalidArgumentException(sprintf('The "when@%s" key should contain an array in "%s". Check your YAML syntax.', $this->env, $path));
}
}
self::$loading[$resource] = true;
try {
$ret = $loader->load($resource, $type);
} finally {
unset(self::$loading[$resource]);
}
return $ret;
if ($isSubpath) {
return isset($ret[1]) ? $ret : ($ret[0] ?? null);
}
}
return $this->doImport($resource, $type, $ignoreErrors, $sourceResource);
}
/**
* @internal
*/
} elseif (!\is_bool($ignoreErrors)) {
throw new \TypeError(sprintf('Invalid argument $ignoreErrors provided to "%s::import()": boolean or "not_found" expected, "%s" given.', static::class, get_debug_type($ignoreErrors)));
}
try {
return parent::import(...$args);
} catch (LoaderLoadException $e) {
if (!$ignoreNotFound || !($prev = $e->getPrevious()) instanceof FileLocatorFileNotFoundException) {
throw $e;
}
}
final public function import(string $resource, string $type = null, bool|string $ignoreErrors = false)
{
$this->loader->setCurrentDir(\dirname($this->path));
$this->loader->import($resource, $type, $ignoreErrors, $this->file);
}
final public function parameters(): ParametersConfigurator
{
return new ParametersConfigurator($this->container);
$container->import($configDir.'/{packages}/*.{php,yaml}');
$container->import($configDir.'/{packages}/'.$this->environment.'/*.{php,yaml}');
if (is_file($configDir.'/services.yaml')) {
$container->import($configDir.'/services.yaml');
$container->import($configDir.'/{services}_'.$this->environment.'.yaml');
} else {
$container->import($configDir.'/{services}.php');
}
}
AbstractConfigurator::$valuePreProcessor = function ($value) {
return $this === $value ? new Reference('kernel') : $value;
};
try {
$configureContainer->getClosure($this)(new ContainerConfigurator($container, $kernelLoader, $instanceof, $file, $file, $this->getEnvironment()), $loader, $container);
} finally {
$instanceof = [];
$kernelLoader->registerAliasesForSinglyImplementedInterfaces();
AbstractConfigurator::$valuePreProcessor = $valuePreProcessor;
}
parent::__construct($env);
}
public function load(mixed $resource, string $type = null): mixed
{
return $resource($this->container, $this->env);
}
public function supports(mixed $resource, string $type = null): bool
{
return $resource instanceof \Closure;
{
if (false === $loader = $this->resolver->resolve($resource, $type)) {
throw new LoaderLoadException($resource, null, 0, null, $type);
}
return $loader->load($resource, $type);
}
public function supports(mixed $resource, string $type = null): bool
{
return false !== $this->resolver->resolve($resource, $type);
$kernelLoader->registerAliasesForSinglyImplementedInterfaces();
AbstractConfigurator::$valuePreProcessor = $valuePreProcessor;
}
$container->setAlias($kernelClass, 'kernel')->setPublic(true);
});
}
/**
* @internal
*/
}
$container = $this->getContainerBuilder();
$container->addObjectResource($this);
$this->prepareContainer($container);
$this->registerContainerConfiguration($this->getContainerLoader($container));
$container->addCompilerPass(new AddAnnotatedClassesToCachePass($this));
return $container;
}
});
}
try {
$container = null;
$container = $this->buildContainer();
$container->compile();
} finally {
if ($collectDeprecations) {
restore_error_handler();
$_ENV['SHELL_VERBOSITY'] = 3;
$_SERVER['SHELL_VERBOSITY'] = 3;
}
$this->initializeBundles();
$this->initializeContainer();
$container = $this->container;
if ($container->hasParameter('kernel.trusted_hosts') && $trustedHosts = $container->getParameter('kernel.trusted_hosts')) {
Request::setTrustedHosts($trustedHosts);
}
public function handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response
{
if (!$this->booted) {
$container = $this->container ?? $this->preBoot();
if ($container->has('http_cache')) {
return $container->get('http_cache')->handle($request, $type, $catch);
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
ParseError
|
---|
ParseError: syntax error, unexpected variable "$res_vendedor" at /var/www/php81/serversoap/recaudos/src/Controller/PtatController.php:391 at Composer\Autoload\{closure}() (/var/www/php81/serversoap/recaudos/vendor/composer/ClassLoader.php:427) at Composer\Autoload\ClassLoader->loadClass() (/var/www/php81/serversoap/recaudos/vendor/symfony/error-handler/DebugClassLoader.php:300) at Symfony\Component\ErrorHandler\DebugClassLoader->loadClass() at class_exists() (/var/www/php81/serversoap/recaudos/vendor/symfony/config/Resource/ClassExistenceResource.php:76) at Symfony\Component\Config\Resource\ClassExistenceResource->isFresh() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/ContainerBuilder.php:347) at Symfony\Component\DependencyInjection\ContainerBuilder->getReflectionClass() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:222) at Symfony\Component\DependencyInjection\Loader\FileLoader->findClasses() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:113) at Symfony\Component\DependencyInjection\Loader\FileLoader->registerClasses() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:677) at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->parseDefinition() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:250) at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->parseDefinitions() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:173) at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->loadContent() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:129) at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->load() (/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/FileLoader.php:163) at Symfony\Component\Config\Loader\FileLoader->doImport() (/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/FileLoader.php:94) at Symfony\Component\Config\Loader\FileLoader->import() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:64) at Symfony\Component\DependencyInjection\Loader\FileLoader->import() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/Configurator/ContainerConfigurator.php:64) at Symfony\Component\DependencyInjection\Loader\Configurator\ContainerConfigurator->import() (/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:57) at App\Kernel->configureContainer() (/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:179) at App\Kernel->Symfony\Bundle\FrameworkBundle\Kernel\{closure}() (/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/ClosureLoader.php:36) at Symfony\Component\DependencyInjection\Loader\ClosureLoader->load() (/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/DelegatingLoader.php:37) at Symfony\Component\Config\Loader\DelegatingLoader->load() (/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:187) at App\Kernel->registerContainerConfiguration() (/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:585) at Symfony\Component\HttpKernel\Kernel->buildContainer() (/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:486) at Symfony\Component\HttpKernel\Kernel->initializeContainer() (/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:709) at Symfony\Component\HttpKernel\Kernel->preBoot() (/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:172) at Symfony\Component\HttpKernel\Kernel->handle() (/var/www/php81/serversoap/recaudos/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (/var/www/php81/serversoap/recaudos/public/index.php:16) |
case '42703':
return new InvalidFieldNameException($exception, $query);
case '42P01':
return new TableNotFoundException($exception, $query);
case '42P07':
return new TableExistsException($exception, $query);
case '08006':
private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}
Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}
if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*
} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
(SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres,
savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs
JOIN personas p ON p.documento::text = savrs.usuario_respuesta
WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
$res_solicitudes = $this->cnn->query('0', $sql_solicitudes);
foreach ($res_solicitudes as $res)
{
$ccostos_ordenado = $res['ccostos'];
$ccostos_desordenado = $res['ccostos_nombres'];
$ccostos_reordenado_str = null;
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}
$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*
} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
(SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres,
savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs
JOIN personas p ON p.documento::text = savrs.usuario_respuesta
WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
$res_solicitudes = $this->cnn->query('0', $sql_solicitudes);
foreach ($res_solicitudes as $res)
{
$ccostos_ordenado = $res['ccostos'];
$ccostos_desordenado = $res['ccostos_nombres'];
$ccostos_reordenado_str = null;
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
$logger->startQuery($this->sql, $this->params, $this->types);
}
try {
return new Result(
$this->stmt->execute($params),
$this->conn,
);
} catch (Driver\Exception $ex) {
throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
} finally {
if ($params === []) {
$params = null; // Workaround as long execute() exists and used internally.
}
return $this->execute($params);
}
/**
* Executes the statement with the currently bound parameters and return affected rows.
*
} */
// $resultSet = $stmt->executeQuery();//execute();
/* try { */
// $resultSet_aux = $stmt->executeQuery();//execute();
// $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
$resultSet = $stmt->executeQuery()->fetchAllAssociative();
$this->cnn->close();
/* } catch (\Throwable $th)
{
} */
// $this->log->logs("respuestaaa ",array($resultSet));
case 24:
case 25:
return $this->consulta_socket($con,$sql);
break;
default:
return $this->query_normal($con,$sql);
break;
}
}
}
CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
(SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres,
savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs
JOIN personas p ON p.documento::text = savrs.usuario_respuesta
WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
$res_solicitudes = $this->cnn->query('0', $sql_solicitudes);
foreach ($res_solicitudes as $res)
{
$ccostos_ordenado = $res['ccostos'];
$ccostos_desordenado = $res['ccostos_nombres'];
$ccostos_reordenado_str = null;
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
try {
return $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
$this->request = $request;
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
$response->send();
if ($this->kernel instanceof TerminableInterface) {
$this->kernel->terminate($this->request, $response);
}
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$method = $_SERVER['REQUEST_METHOD'];
if($method == "OPTIONS") {
die();
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
No log messages
[3/3]
TableNotFoundException
|
---|
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen... ^ at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:71 at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1908) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1851) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Statement.php:194) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:5502) at App\Controller\PtatController->metodos() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16) |
[2/3]
Exception
|
---|
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen... ^ at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28 at Doctrine\DBAL\Driver\PDO\Exception::new() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:5502) at App\Controller\PtatController->metodos() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16) |
[1/3]
PDOException
|
---|
PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen... ^ at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134 at PDOStatement->execute() (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134) at Doctrine\DBAL\Driver\PDO\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:190) at Doctrine\DBAL\Statement->execute() (vendor/doctrine/dbal/src/Statement.php:224) at Doctrine\DBAL\Statement->executeQuery() (src/Services/Conexion.php:566) at App\Services\Conexion->query_normal() (src/Services/Conexion.php:525) at App\Services\Conexion->query() (src/Controller/PtatController.php:5502) at App\Controller\PtatController->metodos() (vendor/symfony/http-kernel/HttpKernel.php:163) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:184) at Symfony\Component\HttpKernel\Kernel->handle() (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35) at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() (vendor/autoload_runtime.php:29) at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') (public/index.php:16) |