https://erpwi-staging.vertuoz.fr/symfony/public/dossier/4595/edit_document_generator_dossier/5137

Method
GET
HTTP Status
302
IP
155.2.128.240
Profiled on
Token
6bfce1

Log Messages

Info. & Errors 31

Informational and error log messages generated during the execution of the application.

Level Channel Message
INFO request Matched route "dossier_edit_segment_document_dossier".
Show context 
[
  "route" => "dossier_edit_segment_document_dossier"
  "route_parameters" => [
    "_route" => "dossier_edit_segment_document_dossier"
    "_controller" => "App\Controller\DossierController::edit_itineraire"
    "id" => "4595"
    "documentId" => "5137"
  ]
  "request_uri" => "https://erpwi-staging.vertuoz.fr/symfony/public/dossier/4595/edit_document_generator_dossier/5137"
  "method" => "GET"
]
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"
INFO http_client Request: "POST https://api-free.deepl.com/v2/translate"
INFO http_client Response: "200 https://api-free.deepl.com/v2/translate"

Deprecations 7

Log messages generated by using features marked as deprecated.

Time Channel Message
php User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead.
Show context    Show trace 
[
  "exception" => ErrorException {#43
    #message: "User Deprecated: Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead."
    #code: 0
    #file: "/var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/web-server-bundle/WebServerBundle.php"
    #line: 23
    #severity: E_USER_DEPRECATED
    trace: {
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/web-server-bundle/WebServerBundle.php:23 {
        Symfony\Bundle\WebServerBundle\WebServerBundle->boot() …
        › {
        ›     @trigger_error('Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead.', \E_USER_DEPRECATED);
        › }
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:140 {
        Symfony\Component\HttpKernel\Kernel->boot() …
        ›     $bundle->setContainer($this->container);
        ›     $bundle->boot();
        › }
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:196 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
        › {
        ›     $this->boot();
        ›     ++$this->requestStackSize;
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/public/index.php:24 {
        › $request = Request::createFromGlobals();
        › $response = $kernel->handle($request);
        › $response->send();
      }
    }
  }
]
{
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/web-server-bundle/WebServerBundle.php:23 {
    Symfony\Bundle\WebServerBundle\WebServerBundle->boot() …
    › {
    ›     @trigger_error('Using the WebserverBundle is deprecated since Symfony 4.4. The new Symfony local server has more features, you can use it instead.', \E_USER_DEPRECATED);
    › }
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:140 {
    Symfony\Component\HttpKernel\Kernel->boot() …
    ›     $bundle->setContainer($this->container);
    ›     $bundle->boot();
    › }
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:196 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
    › {
    ›     $this->boot();
    ›     ++$this->requestStackSize;
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/public/index.php:24 {
    › $request = Request::createFromGlobals();
    › $response = $kernel->handle($request);
    › $response->send();
  }
}
php (5 times) User Deprecated: The "Doctrine\Common\Inflector\Inflector::classify" method is deprecated and will be dropped in doctrine/inflector 2.0. Please update to the new Inflector API.
Show context    Show trace 
[
  "exception" => ErrorException {#2569
    #message: "User Deprecated: The "Doctrine\Common\Inflector\Inflector::classify" method is deprecated and will be dropped in doctrine/inflector 2.0. Please update to the new Inflector API."
    #code: 0
    #file: "/var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php"
    #line: 90
    #severity: E_USER_DEPRECATED
    trace: {
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php:90 {
        Doctrine\Common\Inflector\Inflector::classify(string $word): string …
        › {
        ›     @trigger_error(sprintf('The "%s" method is deprecated and will be dropped in doctrine/inflector 2.0. Please update to the new Inflector API.', __METHOD__), E_USER_DEPRECATED);
        › 
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:305 {
        Doctrine\ORM\EntityRepository->resolveMagicCall($method, $by, array $arguments) …
        › 
        › $fieldName = lcfirst(Inflector::classify($by));
        › 
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:228 {
        Doctrine\ORM\EntityRepository->__call($method, $arguments) …
        › if (0 === strpos($method, 'findOneBy')) {
        ›     return $this->resolveMagicCall('findOneBy', substr($method, 9), $arguments);
        › }
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/src/Controller/DossierController.php:1948 {
        App\Controller\DossierController->edit_itineraire($save = false, Request $request, EntityManagerInterface $em, Dossier $dossier, CompanyService $companyService, DossierSegmentService $segmentService, TranslatorInterface $translator, EditorialService $editorialService, $documentId, PatternService $patternService, DocumentGeneratorService $documentGeneratorService, TraductionService $traductionService, DossierSegmentServiceService $segmentServiceService): Response …
        › } else {
        ›     $document = $em->getRepository(DocumentGenerator::class)->findOneById($documentId);
        ›     $segment  = $em->getRepository(DossierSegment::class)->find($document->getEntiteId());
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/HttpKernel.php:169 {
        Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MASTER_REQUEST): Response …
        › // call controller
        › $response = $controller(...$arguments);
        › 
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/HttpKernel.php:81 {
        Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
        › try {
        ›     return $this->handleRaw($request, $type);
        › } catch (\Exception $e) {
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:201 {
        Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
        › try {
        ›     return $this->getHttpKernel()->handle($request, $type, $catch);
        › } finally {
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/public/index.php:24 {
        › $request = Request::createFromGlobals();
        › $response = $kernel->handle($request);
        › $response->send();
      }
    }
  }
]
{
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php:90 {
    Doctrine\Common\Inflector\Inflector::classify(string $word): string …
    › {
    ›     @trigger_error(sprintf('The "%s" method is deprecated and will be dropped in doctrine/inflector 2.0. Please update to the new Inflector API.', __METHOD__), E_USER_DEPRECATED);
    › 
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:305 {
    Doctrine\ORM\EntityRepository->resolveMagicCall($method, $by, array $arguments) …
    › 
    › $fieldName = lcfirst(Inflector::classify($by));
    › 
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:228 {
    Doctrine\ORM\EntityRepository->__call($method, $arguments) …
    › if (0 === strpos($method, 'findOneBy')) {
    ›     return $this->resolveMagicCall('findOneBy', substr($method, 9), $arguments);
    › }
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/src/Controller/DossierController.php:1948 {
    App\Controller\DossierController->edit_itineraire($save = false, Request $request, EntityManagerInterface $em, Dossier $dossier, CompanyService $companyService, DossierSegmentService $segmentService, TranslatorInterface $translator, EditorialService $editorialService, $documentId, PatternService $patternService, DocumentGeneratorService $documentGeneratorService, TraductionService $traductionService, DossierSegmentServiceService $segmentServiceService): Response …
    › } else {
    ›     $document = $em->getRepository(DocumentGenerator::class)->findOneById($documentId);
    ›     $segment  = $em->getRepository(DossierSegment::class)->find($document->getEntiteId());
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/HttpKernel.php:169 {
    Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MASTER_REQUEST): Response …
    › // call controller
    › $response = $controller(...$arguments);
    › 
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/HttpKernel.php:81 {
    Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
    › try {
    ›     return $this->handleRaw($request, $type);
    › } catch (\Exception $e) {
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/http-kernel/Kernel.php:201 {
    Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) …
    › try {
    ›     return $this->getHttpKernel()->handle($request, $type, $catch);
    › } finally {
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/public/index.php:24 {
    › $request = Request::createFromGlobals();
    › $response = $kernel->handle($request);
    › $response->send();
  }
}
n/a The "Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand" class is deprecated since Symfony 4.2, use "Symfony\Component\Console\Command\Command" with dependency injection instead.
Show context    Show trace 
[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#13443
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/framework-bundle/Command/ContainerAwareCommand.php:18 {
        include …
        › 
        › @trigger_error(sprintf('The "%s" class is deprecated since Symfony 4.2, use "%s" with dependency injection instead.', ContainerAwareCommand::class, Command::class), \E_USER_DEPRECATED);
        › 
      }
      /var/www/erpwalkinn-staging/htdocs/symfony/vendor/composer/ClassLoader.php:444 {
        › {
        ›     include $file;
        › }
        arguments: {
          "/var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/framework-bundle/Command/ContainerAwareCommand.php"
        }
      }
    }
  }
]
{
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/framework-bundle/Command/ContainerAwareCommand.php:18 {
    include …
    › 
    › @trigger_error(sprintf('The "%s" class is deprecated since Symfony 4.2, use "%s" with dependency injection instead.', ContainerAwareCommand::class, Command::class), \E_USER_DEPRECATED);
    › 
  }
  /var/www/erpwalkinn-staging/htdocs/symfony/vendor/composer/ClassLoader.php:444 {
    › {
    ›     include $file;
    › }
    arguments: {
      "/var/www/erpwalkinn-staging/htdocs/symfony/vendor/symfony/framework-bundle/Command/ContainerAwareCommand.php"
    }
  }
}

Debug 317

Unimportant log messages generated during the execution of the application.

Time Channel Message
doctrine SELECT param FROM doli_extrafields WHERE name = "sous_destination" AND elementtype = "societe"
security Read existing security token from the session.
Show context 
[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]
doctrine SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.is_active AS is_active_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.cellphone AS cellphone_9, t0.address AS address_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.avatar AS avatar_13, t0.uid AS uid_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.role_id AS role_id_17, t0.langue_id AS langue_id_18 FROM ba_user t0 WHERE t0.id = ?
Show context 
[
  26
]
security User was reloaded from a user provider.
Show context 
[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "isabelle_walkinn"
]
event Notified event "debug.security.authorization.vote" to listener "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote".
Show context 
[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]
event Notified event "debug.security.authorization.vote" to listener "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote".
Show context 
[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]
event Notified event "kernel.request" to listener "Symfony\Bridge\Monolog\Processor\WebProcessor::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Monolog\Processor\WebProcessor::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::resolveControllerName".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\FrameworkBundle\EventListener\ResolveControllerNameSubscriber::resolveControllerName"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]
event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]
event Notified event "kernel.request" to listener "App\EventSubscriber\KernelSubscriber::onKernelRequest".
Show context 
[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\KernelSubscriber::onKernelRequest"
]
event Notified event "kernel.request" to listener "Symfony\Bridge\Monolog\Processor\RouteProcessor::addRouteData".
Show context 
[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Monolog\Processor\RouteProcessor::addRouteData"
]
doctrine SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = ? AND b0_.vue = 0 AND b0_.date_publication >= 2025 - 07 - 01 ORDER BY b0_.date_publication DESC
Show context 
[
  26
]
doctrine SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = ? AND b0_.vue = 1 AND b0_.date_publication >= 2025 - 07 - 01 ORDER BY b0_.date_publication DESC
Show context 
[
  26
]
doctrine SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.password AS password_2, b0_.email AS email_3, b0_.is_active AS is_active_4, b0_.firstname AS firstname_5, b0_.lastname AS lastname_6, b0_.phone AS phone_7, b0_.cellphone AS cellphone_8, b0_.address AS address_9, b0_.city AS city_10, b0_.zipcode AS zipcode_11, b0_.avatar AS avatar_12, b0_.uid AS uid_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b1_.id AS id_16, b1_.url AS url_17, b1_.query AS query_18, b1_.request AS request_19, b1_.user_actif AS user_actif_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, b0_.role_id AS role_id_23, b0_.langue_id AS langue_id_24, b1_.user_id AS user_id_25, b1_.created_by AS created_by_26, b1_.updated_by AS updated_by_27 FROM ba_user b0_ LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id WHERE b1_.url = ? AND b1_.updated_at >= ? ORDER BY b1_.id ASC
Show context 
[
  "/dossier/4595/edit_documen [...]"
  DateTime @1751376360 {#3675
    date: 2025-07-01 15:26:00.061138 Europe/Paris (+02:00)
  }
]
doctrine "START TRANSACTION"
doctrine INSERT INTO ba_historique_page (url, query, request, user_actif, created_at, updated_at, user_id, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Show context 
[
  1 => "/dossier/4595/edit_documen [...]"
  2 => "[]"
  3 => "[]"
  4 => true
  5 => DateTime @1751376420 {#4805
    date: 2025-07-01 15:27:00.062194 Europe/Paris (+02:00)
  }
  6 => DateTime @1751376420 {#3674
    date: 2025-07-01 15:27:00.062092 Europe/Paris (+02:00)
  }
  7 => 26
  8 => 26
  9 => null
]
doctrine "COMMIT"
doctrine SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.password AS password_2, b0_.email AS email_3, b0_.is_active AS is_active_4, b0_.firstname AS firstname_5, b0_.lastname AS lastname_6, b0_.phone AS phone_7, b0_.cellphone AS cellphone_8, b0_.address AS address_9, b0_.city AS city_10, b0_.zipcode AS zipcode_11, b0_.avatar AS avatar_12, b0_.uid AS uid_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b1_.id AS id_16, b1_.url AS url_17, b1_.query AS query_18, b1_.request AS request_19, b1_.user_actif AS user_actif_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, b0_.role_id AS role_id_23, b0_.langue_id AS langue_id_24, b1_.user_id AS user_id_25, b1_.created_by AS created_by_26, b1_.updated_by AS updated_by_27 FROM ba_user b0_ LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id WHERE b1_.user_id <> ? AND b1_.url = ? AND b1_.updated_at >= ? ORDER BY b1_.id ASC
Show context 
[
  26
  "/dossier/4595/edit_documen [...]"
  DateTime @1751376300 {#3679
    date: 2025-07-01 15:25:00.066706 Europe/Paris (+02:00)
  }
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.reference_resa_client AS reference_resa_client_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.is_valide AS is_valide_12, t0.annee AS annee_13, t0.date_confirmation AS date_confirmation_14, t0.code_client AS code_client_15, t0.docs AS docs_16, t0.envoi_docs AS envoi_docs_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.dossier_type_id AS dossier_type_id_20, t0.dossier_etat_id AS dossier_etat_id_21, t0.destination_id AS destination_id_22, t0.charge_dossier_id AS charge_dossier_id_23, t24.id AS id_25, t24.html AS html_26, t24.dossier_id AS dossier_id_27, t0.charge_dossier2_id AS charge_dossier2_id_28, t0.theme_id AS theme_id_29, t0.categorie_id AS categorie_id_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32 FROM walkinn_dossier t0 LEFT JOIN walkinn_dossier_guide t24 ON t24.dossier_id = t0.id WHERE t0.id = ?
Show context 
[
  "4595"
]
event Notified event "kernel.controller" to listener "App\EventSubscriber\KernelSubscriber::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\KernelSubscriber::onKernelController"
]
event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]
event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]
event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]
event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]
event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]
event Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
Show context 
[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]
event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
Show context 
[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]
event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments".
Show context 
[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]
event Notified event "kernel.controller_arguments" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments".
Show context 
[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]
doctrine SELECT code, label FROM doli_c_country WHERE favorite=1 AND code != ''
doctrine SELECT t0.id AS id_1, t0.entite AS entite_2, t0.langue AS langue_3, t0.entite_id AS entite_id_4, t0.segment_pax_id AS segment_pax_id_5, t0.entity_ids AS entity_ids_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.actif AS actif_9, t0.is_deleted AS is_deleted_10, t0.modele_id AS modele_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM walkinn_document_generator t0 WHERE t0.id = ? LIMIT 1
Show context 
[
  "5137"
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.id = ?
Show context 
[
  10792
]
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.content AS content_3, t0.langue AS langue_4, t0.thumbnail AS thumbnail_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.actif AS actif_8, t0.is_deleted AS is_deleted_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM walkinn_document_generator_page_template t0 WHERE t0.actif = ? AND t0.langue = ?
Show context 
[
  1
  "FR"
]
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.icon AS icon_3, t0.color AS color_4, t0.config AS config_5, t0.entite AS entite_6, t0.langue AS langue_7, t0.format AS format_8, t0.orientation AS orientation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.actif AS actif_12, t0.is_deleted AS is_deleted_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM walkinn_document_generator_modele t0 WHERE t0.entite = ? AND t0.actif = ? AND t0.langue = ?
Show context 
[
  "dossier"
  1
  "FR"
]
doctrine SELECT soc.rowid , soc.nom AS nom , soc.nom AS four_nom , soc.name_alias , soc.code_fournisseur , soc.email , soc.phone , soc.logo , IFNULL(soc.default_lang, "en_GB") AS default_lang , soc.multicurrency_code , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_PAX" LIMIT 1) AS is_pax , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_TO" LIMIT 1) AS is_to , dest.libelle AS destination_libelle , dest.code AS destination_code , socext.frais_fonctionnement AS frais_fonctionnement FROM doli_societe soc LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid LEFT JOIN walkinn_destination dest ON dest.id = socext.destination WHERE soc.rowid = 11
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.dossier_id = ? AND t0.actif = ? ORDER BY t0.date_depart ASC
Show context 
[
  4595
  true
]
doctrine SELECT e.id as editorialId , c.id as contentId , c.id as "id" , c.libelle as `libelle` , c.libelle as `text` , c.contenu as html , t.libelle as `type` , ( SELECT GROUP_CONCAT(d.path) FROM walkinn_document d WHERE d.entite = 'editorial' AND d.entite_id = e.id AND d.actif = 1 ) AS images FROM walkinn_editorial e INNER JOIN walkinn_editorial_contenu c ON c.editorial_id = e.id AND c.langue = "FR" INNER JOIN walkinn_editorial_type t ON t.id = e.type_id WHERE e.type_id = 3 AND ( c.contexte_id = 1 ) AND ( e.categorie_id = 3 ) AND e.actif = 1 AND e.statut_id = 1 AND c.actif = 1 ORDER BY c.libelle ASC
doctrine CALL erpwiStaging.GET( 'erpwiStaging', 'walkinn_dossier_segment', '10792', '(SELECT \" \" AS blank) AS "custom1",(SELECT \"<div class=\\\"page-break\\\"></div>\") AS "custom2",c_voyage_id.libelle AS "voyage_id.libelle",c_voyage_id.libelle_long AS "voyage_id.libelle_long",(SELECT c.code_walkinn AS code_voyage) AS "custom3",(SELECT DATE_FORMAT(c.date_depart , \"%d/%m/%Y\")) AS "custom4",(SELECT COUNT(*) FROM walkinn_dossier_segment_pax WHERE actif=1 AND segment_id=c.id) AS "custom5",(SELECT DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY), \"%d/%m/%Y\")) AS "custom6",c.code AS "code",c.code_interne AS "code_interne",c.libelle AS "libelle",c_dossier_id.libelle AS "dossier_id.libelle",(SELECT CONCAT(\"du \", DATE_FORMAT(c.date_depart , \"%d/%m/%Y\"), IF(c.nb_jours > 1, CONCAT(\" au \", DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY) , \"%d/%m/%Y\")), \"\")) AS \"dates\") AS "custom7",(SELECT ext_soc.nom FROM doli_societe ext_soc WHERE ext_soc.rowid = c.client_id) AS "custom8",c_destination_id.libelle AS "destination_id.libelle",c_voyage_type_id.libelle AS "voyage_type_id.libelle",c_voyage_categorie_id.libelle AS "voyage_categorie_id.libelle",c_voyage_theme_id.libelle AS "voyage_theme_id.libelle",c.nb_jours AS "nb_jours",c.min_pax AS "min_pax",c.max_pax AS "max_pax",c.prix_vente AS "prix_vente",c.sup_single_vente AS "sup_single_vente"', '', '', '', '', 1, 1 )
doctrine SELECT CONCAT("documents/societe/", soc.rowid, "/logos/", soc.logo) as "image" , "max-width: 150px; margin: 0;" AS style FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT CONCAT("documents/societe/", soc.rowid, "/logos/", soc.logo) as "image" , "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0;" AS style FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT "/symfony/public/icon/logo.jpg" AS "image", "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0; float: right;" AS style
doctrine SELECT IFNULL(dot.transvalue, v.libelle) as title FROM walkinn_dossier_segment s LEFT JOIN walkinn_voyage v ON v.id = s.voyage_id LEFT JOIN doli_overwrite_trans dot ON dot.transkey COLLATE utf8mb4_general_ci = v.libelle COLLATE utf8mb4_general_ci AND dot.lang LIKE :Langue WHERE s.id = :entiteId
Show context 
[
  "entiteId" => 10792
  "Langue" => "%FR%"
]
doctrine SELECT IFNULL(dot.transvalue, v.libelle_long) as title FROM walkinn_dossier_segment s LEFT JOIN walkinn_voyage v ON v.id = s.voyage_id LEFT JOIN doli_overwrite_trans dot ON dot.transkey COLLATE utf8mb4_general_ci = v.libelle_long COLLATE utf8mb4_general_ci AND dot.lang LIKE :Langue WHERE s.id = :entiteId
Show context 
[
  "entiteId" => 10792
  "Langue" => "%FR%"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart , CONCAT(DATE_FORMAT(seg.date_depart , "%d/%m/%Y"), IF(seg.nb_jours > 1, CONCAT(" au ", DATE_FORMAT(DATE_ADD(seg.date_depart, INTERVAL (seg.nb_jours -1) DAY) , "%d/%m/%Y")), ""), " (", seg.nb_jours," jour", IF(seg.nb_jours > 1, "s", ""), ")") AS "dates" , seg.nb_jours, seg.code_walkinn , soc.nom , desti.libelle AS destination FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Contact"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Pour"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Tèl"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Référence"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Email"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Dates"
  "locale" => "fr_FR"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart, CONCAT(DATE_FORMAT(seg.date_depart , "%d/%m/%Y"), IF(seg.nb_jours > 1, CONCAT(" au ", DATE_FORMAT(DATE_ADD(seg.date_depart, INTERVAL (seg.nb_jours -1) DAY) , "%d/%m/%Y")), ""), " (", seg.nb_jours," jour", IF(seg.nb_jours > 1, "s", ""), ")") AS "dates" FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Proposition de séjour"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Chers voyageurs"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Lorem ipsum dolor sit amet"
  "locale" => "fr_FR"
]
doctrine SELECT cat, libelle, j, datef FROM (SELECT subfourn.nom COLLATE utf8mb4_general_ci AS libelle, "H" as cat, IF( ( SELECT MIN(YEAR(s.date_depart)) FROM walkinn_dossier_segment s WHERE s.dossier_id = ( SELECT seg2.dossier_id FROM walkinn_dossier_segment seg2 WHERE seg2.id=:entiteId ) ) <> YEAR(wds.date_depart + INTERVAL (wdssd.jour-1) DAY), DATE_FORMAT(wds.date_depart + INTERVAL (wdssd.jour-1) DAY , "%j")+365 , DATE_FORMAT(wds.date_depart + INTERVAL (wdssd.jour-1) DAY , "%j") ) as "j", DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdssd.jour -1) DAY) , "%d/%m/%Y") as datef FROM walkinn_dossier_segment_service subservice INNER JOIN walkinn_service subserv ON subserv.id = subservice.service_id INNER JOIN doli_societe subfourn ON subfourn.rowid = subserv.prestataire_id INNER JOIN walkinn_dossier_segment_service_day wdssd ON wdssd.dossier_segment_service_id = subservice.id INNER JOIN walkinn_dossier_segment wds ON wds.id = subservice.segment_id WHERE subservice.segment_id IN (10792) AND subserv.type_id = 4 AND subservice.actif = 1 ORDER BY j ASC ) AS tmp UNION SELECT cat, libelle, j, datef FROM (SELECT subcontenu.libelle AS libelle, "A" AS cat, IF( ( SELECT MIN(YEAR(s.date_depart)) FROM walkinn_dossier_segment s WHERE s.dossier_id = ( SELECT seg2.dossier_id FROM walkinn_dossier_segment seg2 WHERE seg2.id=:entiteId ) ) <> YEAR(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY), DATE_FORMAT(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY , "%j")+365 , DATE_FORMAT(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY , "%j") ) as "j", DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdsaed.jour -1) DAY) , "%d/%m/%Y") as datef FROM walkinn_dossier_segment_activite_edito subactivite INNER JOIN walkinn_editorial edi ON edi.id = subactivite.editorial_wrapper_id INNER JOIN walkinn_editorial_contenu subcontenu ON subcontenu.editorial_id = edi.id AND subcontenu.langue LIKE :Langue INNER JOIN walkinn_dossier_segment_activite_edito_day wdsaed ON wdsaed.dossier_segment_activite_edito_id = subactivite.id INNER JOIN walkinn_dossier_segment wds ON wds.id = subactivite.dossier_segment_id WHERE subactivite.dossier_segment_id IN (10792) AND subactivite.actif = 1 AND subcontenu.actif = 1 ORDER BY j ASC ) AS tmp2 ORDER BY j ASC
Show context 
[
  "entiteId" => 10792
  "Langue" => "%FR%"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Aperçu de votre séjour"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Date"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Etape / Activité(s)"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Hébergement"
  "locale" => "fr_FR"
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.id = ? LIMIT 1
Show context 
[
  10792
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.dossier_id = ?
Show context 
[
  4595
]
doctrine SELECT * FROM (SELECT service_id , service_parent_id , service_libelle , type_id , type as cat , fournisseur_nom , fournisseur_address , fournisseur_zip , fournisseur_town , fournisseur_phone , j , datef , jour , code , color , ordre , horaire , jour_absolute , note FROM ( SELECT subfourn.nom COLLATE utf8mb4_general_ci AS fournisseur_nom , subfourn.address COLLATE utf8mb4_general_ci AS fournisseur_address , subfourn.zip COLLATE utf8mb4_general_ci AS fournisseur_zip , subfourn.town COLLATE utf8mb4_general_ci AS fournisseur_town , subfourn.phone COLLATE utf8mb4_general_ci AS fournisseur_phone , subservt.id as type_id , subservt.libelle as type , subserv.id AS service_id , subserv.parent_id AS service_parent_id , DATEDIFF((DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdssd.jour -1) DAY) , "%Y-%m-%d") ),(SELECT MIN(wds2.date_depart) FROM walkinn_dossier_segment wds2 WHERE wds2.dossier_id = wds.dossier_id AND IFNULL(wds2.is_prestation_seche, 0) = 0) )+1 AS jour_absolute , IF( ( SELECT MIN(YEAR(s.date_depart)) FROM walkinn_dossier_segment s WHERE s.dossier_id = ( SELECT seg2.dossier_id FROM walkinn_dossier_segment seg2 WHERE seg2.id=:entiteId ) ) <> YEAR(wds.date_depart + INTERVAL (wdssd.jour-1) DAY), DATE_FORMAT(wds.date_depart + INTERVAL (wdssd.jour-1) DAY , "%j")+365 , DATE_FORMAT(wds.date_depart + INTERVAL (wdssd.jour-1) DAY , "%j") ) as "j", DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdssd.jour -1) DAY) , "%Y-%m-%d") as datef, wdssd.jour , subserv.libelle AS service_libelle, subservice.note, subservice.ordre, subservice.ranking as horaire, "S" AS code, subservt.color FROM walkinn_dossier_segment_service subservice INNER JOIN walkinn_service subserv ON subserv.id = subservice.service_id INNER JOIN walkinn_service_type subservt ON subservt.id = subserv.type_id INNER JOIN doli_societe subfourn ON subfourn.rowid = subserv.prestataire_id INNER JOIN walkinn_dossier_segment_service_day wdssd ON wdssd.dossier_segment_service_id = subservice.id INNER JOIN walkinn_dossier_segment wds ON wds.id = subservice.segment_id WHERE subservice.segment_id IN (10792) AND subservice.actif = 1 AND subservice.is_vue_guide = 1 ORDER BY j ASC, subservice.ordre ASC ) AS tmp UNION SELECT service_id , service_parent_id , service_libelle , type_id , type AS cat , fournisseur_nom , fournisseur_address , fournisseur_zip , fournisseur_town , fournisseur_phone , j , datef , jour , code , color , ordre , horaire , jour_absolute , note FROM ( SELECT subcontenu.libelle AS service_libelle, "" AS fournisseur_nom , "" AS fournisseur_address , "" AS fournisseur_zip , "" AS fournisseur_town , "" AS fournisseur_phone , edic.id+1000 AS type_id , edic.libelle AS type , null AS service_id , null AS service_parent_id , DATEDIFF((DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdsaed.jour -1) DAY) , "%Y-%m-%d") ),(SELECT MIN(wds2.date_depart) FROM walkinn_dossier_segment wds2 WHERE wds2.dossier_id = wds.dossier_id AND IFNULL(wds2.is_prestation_seche, 0) = 0) )+1 AS jour_absolute , IF( ( SELECT MIN(YEAR(s.date_depart)) FROM walkinn_dossier_segment s WHERE s.dossier_id = ( SELECT seg2.dossier_id FROM walkinn_dossier_segment seg2 WHERE seg2.id=:entiteId ) ) <> YEAR(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY), DATE_FORMAT(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY , "%j")+365 , DATE_FORMAT(wds.date_depart + INTERVAL (wdsaed.jour-1) DAY , "%j") ) as "j", DATE_FORMAT(DATE_ADD(wds.date_depart, INTERVAL (wdsaed.jour -1) DAY) , "%Y-%m-%d") as datef, wdsaed.jour , subactivite.note, subactivite.ordre, subactivite.ranking as horaire, "A" AS code, IF(edic.id = 9, "#0b6cb2", "#70ad47") AS color FROM walkinn_dossier_segment_activite_edito subactivite LEFT JOIN walkinn_editorial edi ON edi.id = subactivite.editorial_wrapper_id LEFT JOIN walkinn_editorial_categorie edic ON edic.id = edi.categorie_id INNER JOIN walkinn_editorial_contenu subcontenu ON subcontenu.editorial_id = edi.id AND subcontenu.langue LIKE :Langue INNER JOIN walkinn_dossier_segment_activite_edito_day wdsaed ON wdsaed.dossier_segment_activite_edito_id = subactivite.id INNER JOIN walkinn_dossier_segment wds ON wds.id = subactivite.dossier_segment_id WHERE subactivite.dossier_segment_id IN (10792) AND subactivite.actif = 1 AND subcontenu.actif = 1 AND subactivite.is_vue_guide = 1 ORDER BY j ASC, subactivite.ordre ASC ) AS tmp2) AS tmp3 ORDER BY jour ASC, ordre ASC
Show context 
[
  "entiteId" => 10792
  "Langue" => "%FR%"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " STANDARD ROOM W/ BALCONY  [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT  FUNCHAL / SAO L [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " TRANSFERT  SAO LOURENCO / [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " STANDARD ROOM W/ BALCONY  [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT SANTANA / PORTELA"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT RIBEIRO FRIO / SANTANA"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "DINNER"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM BB *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM BB *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => ""
  "locale" => "fr_FR"
]
doctrine SELECT DISTINCT(GROUP_CONCAT((DATE_FORMAT(segment.date_depart + INTERVAL (jour.jour-1) DAY, "%d/%m/%Y"))," au ",(DATE_FORMAT(segment.date_depart + INTERVAL jour.jour DAY, "%d/%m/%Y")) SEPARATOR "<br>")) AS "date", COUNT(soc.nom) AS nuits, jour.jour, soc.nom, soc.code_fournisseur, soc.address, soc.zip, soc.town, soc.phone, soc.url, soc.email , ( SELECT edco.contenu FROM walkinn_editorial_contenu edco LEFT JOIN walkinn_editorial ed ON ed.id = edco.editorial_id WHERE edco.contexte_id = 1 AND ed.societe_id = soc.rowid AND EXISTS ( SELECT id FROM walkinn_editorial_societe WHERE editorial_id = ed.id AND (societe_id = (SELECT client_id FROM walkinn_voyage WHERE id = :entiteId) OR societe_id =337) ) LIMIT 1 ) as note_public FROM walkinn_dossier_segment_service ds LEFT JOIN walkinn_dossier_segment_service_day jour ON jour.dossier_segment_service_id = ds.id INNER JOIN walkinn_dossier_segment segment ON segment.id = ds.segment_id INNER JOIN walkinn_service service ON service.id = ds.service_id INNER JOIN doli_societe soc ON soc.rowid = service.prestataire_id WHERE segment.id = :entiteId AND ds.actif = 1 AND service.type_id = 4 GROUP BY soc.nom, ds.id ORDER BY jour.jour
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Liste des hébergements"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart, seg.prix_vente , seg.nb_jours, seg.code_walkinn FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Prix par personne"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "pers."
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Prix nets"
  "locale" => "fr_FR"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart , seg.nb_jours, seg.code_walkinn FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Le séjour comprend:"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "nuits"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "le transport des bagages d [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "les taxes de séjour"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "l'assistance téléphonique 7/7"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Le séjour ne comprend pas"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Le forfait ne comprend pas"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "le transport A/R jusqu'au  [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "les boissons"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "les déjeuners et dîners qu [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "les visites de sites qui n [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "les assurances (disponible [...]"
  "locale" => "fr_FR"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart , soc.nom FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Prêt à partir ?"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Nous restons à votre dispo [...]"
  "locale" => "fr_FR"
]
doctrine SELECT DATE_FORMAT(seg.date_depart, "%d/%m/%Y") AS date_depart , desti.libelle AS destination FROM walkinn_dossier_segment seg LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id LEFT JOIN walkinn_destination desti ON desti.id = seg.destination_id WHERE seg.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT DISTINCT(u.rowid), CONCAT(u.firstname, " ", u.lastname) as pax FROM walkinn_dossier_segment_pax r INNER JOIN doli_socpeople u ON u.rowid = r.contact_id WHERE r.segment_id = :entiteId GROUP BY u.rowid, u.lastname, u.firstname ORDER BY u.lastname ASC
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Participants"
  "locale" => "fr_FR"
]
doctrine SELECT DISTINCT(u.rowid), u.firstname as pax FROM walkinn_dossier_segment_pax r INNER JOIN doli_socpeople u ON u.rowid = r.contact_id WHERE r.segment_id = :entiteId AND r.actif = 1 GROUP BY u.rowid, u.lastname, u.firstname ORDER BY u.lastname ASC
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT u.email, u.firstname, u.lastname, u.phone FROM walkinn_dossier_segment ds INNER JOIN walkinn_dossier d ON ds.dossier_id = d.id INNER JOIN ba_user u ON u.id = d.charge_dossier_id WHERE ds.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT DISTINCT(u.rowid), CONCAT(u.firstname, " ", u.lastname) as pax, u.civility FROM walkinn_dossier_segment_pax r INNER JOIN doli_socpeople u ON u.rowid = r.contact_id WHERE r.segment_id = :entiteId GROUP BY u.rowid, u.lastname, u.firstname ORDER BY u.lastname ASC
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "voyageurs"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Mme"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Mme"
  "locale" => "fr_FR"
]
doctrine SELECT COUNT(soc.nom) nuits, jour.jour, soc.nom, soc.code_fournisseur, soc.address, soc.zip, soc.town, soc.phone, soc.url, soc.email, type.libelle AS categorie, type.id AS categorie_id, service.libelle AS "service", DATE_FORMAT(segment.date_depart + INTERVAL (jour.jour-1) DAY, "%d/%m/%Y") AS "date_debut", DATE_FORMAT(segment.date_depart + INTERVAL jour.jour DAY, "%d/%m/%Y") AS "date_fin", segment.date_depart + INTERVAL (jour.jour-1) DAY AS "date_raw", -- DATE_FORMAT(segment.date_depart + INTERVAL (jour.jour-1) DAY , "%j") AS "j", IF( ( SELECT MIN(YEAR(s.date_depart)) FROM walkinn_dossier_segment s WHERE s.dossier_id = ( SELECT seg2.dossier_id FROM walkinn_dossier_segment seg2 WHERE seg2.id=:entiteId) ) <> YEAR(segment.date_depart + INTERVAL (jour.jour-1) DAY), DATE_FORMAT(segment.date_depart + INTERVAL (jour.jour-1) DAY , "%j")+365 , DATE_FORMAT(segment.date_depart + INTERVAL (jour.jour-1) DAY , "%j") ) AS "j", ds.note AS note_public, -- ds.id AS id, ds.service_id AS id, ds.is_vue_guide FROM walkinn_dossier_segment_service AS ds LEFT JOIN walkinn_dossier_segment_service_day jour ON jour.dossier_segment_service_id = ds.id INNER JOIN walkinn_dossier_segment segment ON segment.id = ds.segment_id INNER JOIN walkinn_service service ON service.id = ds.service_id INNER JOIN walkinn_service_type type ON type.id = service.type_id INNER JOIN doli_societe soc ON soc.rowid = service.prestataire_id WHERE segment.dossier_id = ( SELECT seg.dossier_id FROM walkinn_dossier_segment seg WHERE seg.id=:entiteId ) AND ds.actif = 1 AND ds.is_vue_guide = 1 GROUP BY soc.nom, ds.id, jour.id ORDER BY jour.jour
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "40707"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "40707"
  "serviceId" => "9796"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " STANDARD ROOM W/ BALCONY  [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
]
doctrine SELECT rowid FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
]
doctrine INSERT INTO doli_overwrite_trans (`transkey`, lang, transvalue, toModerate) VALUES (:key, :locale, :translation, :valide)
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
  "translation" => "TARIF / J"
  "valide" => 1
]
doctrine SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.locale AS locale_3, t0.translated_text AS translated_text_4, t0.is_validated AS is_validated_5, t0.redirect_url AS redirect_url_6, t0.sub_redirect_url AS sub_redirect_url_7 FROM translation t0 WHERE t0.key_name = ? AND t0.locale = ? LIMIT 1
Show context 
[
  "TARIF / J"
  "fr_FR"
]
doctrine "START TRANSACTION"
doctrine INSERT INTO translation (key_name, locale, translated_text, is_validated, redirect_url, sub_redirect_url) VALUES (?, ?, ?, ?, ?, ?)
Show context 
[
  1 => "TARIF / J"
  2 => "fr_FR"
  3 => "TARIF / J"
  4 => false
  5 => "/symfony/public/dossier/45 [...]"
  6 => "/symfony/public/dossier/45 [...]"
]
doctrine "COMMIT"
doctrine "START TRANSACTION"
doctrine INSERT INTO ba_log_journal (libelle, info1, info2, user, referer, ip, browser, created_at, updated_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Show context 
[
  1 => "New - App\Entity\Translati [...]"
  2 => "object = {}"
  3 => null
  4 => "8"
  5 => "https://erpwi-staging.vert [...]"
  6 => "155.2.128.240"
  7 => "Mozilla/5.0 (Windows NT 10 [...]"
  8 => DateTime @1751376420 {#9330
    date: 2025-07-01 15:27:00.849518 Europe/Paris (+02:00)
  }
  9 => DateTime @1751376420 {#9244
    date: 2025-07-01 15:27:00.849444 Europe/Paris (+02:00)
  }
  10 => 26
  11 => null
]
doctrine "COMMIT"
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "8264"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "8264"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "8264"
  "serviceId" => "9747"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "8264"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "8264"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT  FUNCHAL / SAO L [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "MENU DINNER E+P+D /  PAX"
  "locale" => "fr_FR"
]
doctrine SELECT rowid FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale
Show context 
[
  "key" => "MENU DINNER E+P+D /  PAX"
  "locale" => "fr_FR"
]
doctrine INSERT INTO doli_overwrite_trans (`transkey`, lang, transvalue, toModerate) VALUES (:key, :locale, :translation, :valide)
Show context 
[
  "key" => "MENU DINNER E+P+D /  PAX"
  "locale" => "fr_FR"
  "translation" => "MENU DÎNER E+P+D / PAX"
  "valide" => 1
]
doctrine SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.locale AS locale_3, t0.translated_text AS translated_text_4, t0.is_validated AS is_validated_5, t0.redirect_url AS redirect_url_6, t0.sub_redirect_url AS sub_redirect_url_7 FROM translation t0 WHERE t0.key_name = ? AND t0.locale = ? LIMIT 1
Show context 
[
  "MENU DINNER E+P+D /  PAX"
  "fr_FR"
]
doctrine "START TRANSACTION"
doctrine INSERT INTO translation (key_name, locale, translated_text, is_validated, redirect_url, sub_redirect_url) VALUES (?, ?, ?, ?, ?, ?)
Show context 
[
  1 => "MENU DINNER E+P+D /  PAX"
  2 => "fr_FR"
  3 => "MENU DÎNER E+P+D / PAX"
  4 => false
  5 => "/symfony/public/dossier/45 [...]"
  6 => "/symfony/public/dossier/45 [...]"
]
doctrine "COMMIT"
doctrine "START TRANSACTION"
doctrine INSERT INTO ba_log_journal (libelle, info1, info2, user, referer, ip, browser, created_at, updated_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Show context 
[
  1 => "New - App\Entity\Translati [...]"
  2 => "object = {}"
  3 => null
  4 => "8"
  5 => "https://erpwi-staging.vert [...]"
  6 => "155.2.128.240"
  7 => "Mozilla/5.0 (Windows NT 10 [...]"
  8 => DateTime @1751376421 {#9374
    date: 2025-07-01 15:27:01.038754 Europe/Paris (+02:00)
  }
  9 => DateTime @1751376421 {#9331
    date: 2025-07-01 15:27:01.038650 Europe/Paris (+02:00)
  }
  10 => 26
  11 => null
]
doctrine "COMMIT"
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "29558"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "29558"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "29558"
  "serviceId" => "458"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "29558"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "29558"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " TRANSFERT  SAO LOURENCO / [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "VTC HYBRID"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "40707"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "40707"
  "serviceId" => "9796"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "40707"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => " STANDARD ROOM W/ BALCONY  [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
]
doctrine SELECT rowid FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
]
doctrine UPDATE doli_overwrite_trans SET transvalue=:translation, toModerate=:valide WHERE `transkey`=:key AND lang=:locale
Show context 
[
  "key" => "TARIF / J"
  "locale" => "fr_FR"
  "translation" => "TARIF / J"
  "valide" => "1"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "41424"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "41424"
  "serviceId" => "27133"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "PICNIC / PAX"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "41424"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "41424"
  "serviceId" => "27133"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "PICNIC / PAX"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "27335"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "27335"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "27335"
  "serviceId" => "16223"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "27335"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "27335"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT SANTANA / PORTELA"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "DOUBLE BB"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "2074"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "2074"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "2074"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "2074"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT RIBEIRO FRIO / SANTANA"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "41424"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT pax.id AS pax_id , pax.note AS pax_note_publique , pax.libelle AS pax_libelle , pax.is_sup_single AS pax_is_sup_single , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , room.id AS rooming_id , room.libelle AS rooming_libelle , IFNULL(room.numero_chambre, "-") AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , IFNULL(roomt.code, "ND") AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , contactex.nationalite AS contact_nationalite , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , contactex.poids AS contact_poids , contactex.taille AS contact_taille , pays.label AS contact_pays , contactex.informations AS contact_informations , sepax.id AS service_pax_id , sepax.actif AS service_pax_actif , serv.id AS service_id , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , seg.id AS segment_id , seg.code_walkinn AS segment_code_walkinn , sepax.dossier_segment_service_id AS test FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_dossier_segment_service sserv ON sserv.id = sepax.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment seg ON seg.id = sserv.segment_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN walkinn_dossier_segment_pax pax ON pax.id = sepax.dossier_segment_pax_id AND pax.segment_id = seg.id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND assoc.actif = 1 AND pax.actif = 1 AND sepax.actif = 1 AND sserv.id = :segmentServiceId AND assoc.service_id = :serviceId AND assoc.numero = :numero ORDER BY room.numero_chambre ASC;
Show context 
[
  "segmentServiceId" => "41424"
  "serviceId" => "27133"
  "numero" => "0"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "41424"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM HALFBOARD *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "PICNIC / PAX"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "32987"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "32987"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "32987"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "32987"
]
doctrine SELECT liaison.id , liaison.day , liaison.groupement , liaison.segment_id , segment_service.id AS segment_service_lie_id , segment_service.inclus AS segment_service_lie_inclus , segment_service.payant_pour_guide AS segment_service_lie_payant_pour_guide , segment_service.compter_le_guide AS segment_service_lie_compter_le_guide , segment_service.compter_le_groupe AS segment_service_lie_compter_le_groupe , segment_service.ordre AS segment_service_lie_ordre , segment_service.tarif_jour AS segment_service_lie_tarif_jour , IFNULL(segment_service.prix_achat_fixe, 0) AS segment_service_lie_prix_achat_fixe , IFNULL(segment_service.prix_achat_fixe_devises, 0) AS segment_service_lie_prix_achat_fixe_devises , CONCAT(DATE_FORMAT(IF(walkinn_dossier_segment_service_day.jour > 0, DATE_ADD(vs.date_depart, INTERVAL (walkinn_dossier_segment_service_day.jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (walkinn_dossier_segment_service_day.jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN segment_service.ordre) > 0, CONCAT(" (", segment_service.ordre, ")"), "") ) AS segment_service_lie_date , segment_service.service_id AS segment_service_lie_service_id , serv.libelle AS segment_service_lie_service_libelle , serv.type_id AS segment_service_lie_service_type_id , servt.libelle AS segment_service_lie_service_type_libelle , IFNULL(servt.color, "999999") AS segment_service_lie_service_type_color , four.nom AS four_nom , four.name_alias AS four_name_alias , four.code_fournisseur AS four_code_fournisseur , four.email AS four_email , four.phone AS four_phone , four.address AS four_address , four.zip AS four_zip , four.town AS four_town , segment_service.note AS four_note_public , ( SELECT GROUP_CONCAT(DISTINCT(serv.libelle) ORDER BY assoc.numero ASC SEPARATOR ", ") FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = segment_service.id ) AS segment_service_lie_enfants FROM walkinn_dossier_segment_service_groupement liaison LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison.service_id LEFT JOIN walkinn_dossier_segment_service_day walkinn_dossier_segment_service_day ON walkinn_dossier_segment_service_day.dossier_segment_service_id = segment_service.id AND walkinn_dossier_segment_service_day.jour = liaison.day LEFT JOIN walkinn_dossier_segment vs ON vs.id = segment_service.segment_id LEFT JOIN walkinn_service serv ON serv.id = segment_service.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id WHERE 1 = 1 AND liaison.service_id != :segmentServiceId AND liaison.groupement = :groupement AND liaison.segment_id = :segmentId AND :day = :day ORDER BY segment_service_lie_date, segment_service_lie_ordre ASC;
Show context 
[
  "segmentServiceId" => "32987"
  "groupement" => "9"
  "segmentId" => "2022"
  "day" => "8"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "DINNER"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "40517"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM BB *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT v.id , v.inclus , v.payant_pour_guide , v.compter_le_guide , v.compter_le_groupe , v.ordre , v.tarif_jour , v.paye_walkinn , IFNULL(v.prix_achat_fixe, 0) AS prix_achat_fixe , IFNULL(v.prix_achat_fixe_devises, 0) AS prix_achat_fixe_devises , four.multicurrency_code , four.fk_multicurrency , cp.taux , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates , ( SELECT IF( COUNT(jour) = 1 AND service.type_id != :hebergementTypeId , CONCAT( DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , IF(COUNT(jour) = (1 + DATEDIFF(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))))) AND service.type_id = :hebergementTypeId , CONCAT( "IN: " , DATE_FORMAT(MIN(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY))), "%d/%m/%Y") , " - " , "OUT: " , DATE_FORMAT(MAX(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour - (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour + (IF(service.type_id = :hebergementTypeId, 0, 1))) DAY))), "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ) , GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m/%Y") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) ) ) AS jour_label FROM walkinn_dossier_segment_service_day segment_service_day LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = segment_service_day.dossier_segment_service_id LEFT JOIN walkinn_service service ON service.id = segment_service.service_id WHERE dossier_segment_service_id = :segmentServiceId AND segment_service.actif = 1 AND segment_service.inclus = 1 ORDER BY jour ASC ) AS dates_emmanuel , ( SELECT GROUP_CONCAT( DATE_FORMAT(IF(jour > 0, DATE_ADD(vs.date_depart, INTERVAL (jour -1) DAY), DATE_SUB(vs.date_depart, INTERVAL (jour +1) DAY)) , "%d/%m") , IF(POSITION("h" IN v.ranking) > 0, CONCAT(" - ", v.ranking), "") ORDER BY jour ASC SEPARATOR "<br>" ) AS jour_label FROM walkinn_dossier_segment_service_day WHERE dossier_segment_service_id = :segmentServiceId ) AS dates_custom , v.service_id , v.note , serv.libelle AS service_libelle , serv.prestataire_id AS service_fournisseur_id , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , vs.id AS segment_id , vs.code_walkinn AS segment_code_walkinn , client.nom AS segment_client FROM walkinn_dossier_segment_service v LEFT JOIN walkinn_dossier_segment vs ON vs.id = v.segment_id LEFT JOIN walkinn_service serv ON serv.id = v.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_societe four ON four.rowid = serv.prestataire_id LEFT JOIN doli_societe client ON client.rowid = vs.client_id LEFT JOIN walkinn_change_periode cp ON ( cp.date_debut <= vs.date_depart AND cp.date_fin >= vs.date_depart AND cp.devise_cible_id = four.fk_multicurrency AND cp.devise_base_id = 1 AND cp.actif = 1 ) WHERE v.id = :segmentServiceId
Show context 
[
  "segmentServiceId" => "40517"
  "hebergementTypeId" => 4
]
doctrine SELECT assoc.service_id AS service_id , assoc.numero , serv.libelle AS service_libelle , serv.type_id AS service_type_id , servt.libelle AS service_type_libelle , IFNULL(servt.color, "999999") AS service_type_color , prex.fk_object AS product_id FROM walkinn_dossier_segment_service_pax_association assoc LEFT JOIN walkinn_dossier_segment_service_pax sepax ON sepax.id = assoc.dossier_segment_service_pax_id LEFT JOIN walkinn_service serv ON serv.id = assoc.service_id LEFT JOIN walkinn_service_type servt ON servt.id = serv.type_id LEFT JOIN doli_product_extrafields prex ON prex.service_id = assoc.service_id WHERE 1 = 1 AND assoc.actif = 1 AND sepax.actif = 1 AND sepax.dossier_segment_service_id = :segmentServiceId GROUP BY assoc.service_id, assoc.numero ORDER BY assoc.numero ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT liaison_aerien.id AS liaison_id , DATE_FORMAT(transfert.debut_vol, "%d/%m/%Y %H:%i") AS debut_vol , DATE_FORMAT(transfert.fin_vol, "%d/%m/%Y %H:%i") AS fin_vol , transfert.code_origine , transfert.code_destination , transfert.reference_vol , transfert.transferts , transfert.informations , walkinn_dossier_segment_transfert_aerien.plan_de_vol_id AS plan_id , walkinn_dossier_segment_plan_de_vol.id AS plan_relation_id -- , walkinn_dossier_segment_pax.libelle AS pax , plan.libelle AS plan FROM walkinn_dossier_segment_transfert_aerien_service liaison_aerien LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = liaison_aerien.dossier_segment_service_id LEFT JOIN walkinn_dossier_segment_transfert_aerien ON liaison_aerien.transfert_aerien_id = walkinn_dossier_segment_transfert_aerien.id LEFT JOIN walkinn_transfert_aerien transfert ON transfert.id = walkinn_dossier_segment_transfert_aerien.transfert_aerien_id -- LEFT JOIN walkinn_dossier_segment_transfert_aerien_pax pax ON walkinn_dossier_segment_transfert_aerien.plan_de_vol_id = pax.plan_de_vol_id -- LEFT JOIN walkinn_dossier_segment_pax ON walkinn_dossier_segment_pax.id = pax.segment_pax_id LEFT JOIN walkinn_dossier_segment_plan_de_vol ON walkinn_dossier_segment_plan_de_vol.id = walkinn_dossier_segment_transfert_aerien.plan_de_vol_id LEFT JOIN walkinn_plan_de_vol plan ON plan.id = walkinn_dossier_segment_plan_de_vol.id WHERE 1 = 1 AND liaison_aerien.dossier_segment_service_id = :segmentServiceId AND transfert.actif = 1 -- AND plan.actif = 1 ORDER BY debut_vol ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT groupement.groupement , groupement.segment_id , groupement.day , CONCAT(groupement.groupement, "-", groupement.day) AS test FROM walkinn_dossier_segment_service_groupement groupement LEFT JOIN walkinn_dossier_segment_service segment_service ON segment_service.id = groupement.service_id WHERE 1 = 1 AND groupement.service_id = :segmentServiceId ORDER BY day ASC;
Show context 
[
  "segmentServiceId" => "40517"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "STANDARD ROOM BB *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.id = ? LIMIT 1
Show context 
[
  10792
]
doctrine SELECT wec.libelle, wec.libelle, wds.date_depart + INTERVAL (wdsaed.jour-1) day AS date_raw, DATE_FORMAT(wds.date_depart + INTERVAL (wdsaed.jour-1) day, '%d/%m/%Y') AS date_debut, wdsae.note AS note_public, wdsae.is_vue_guide FROM walkinn_dossier_segment_activite_edito wdsae INNER JOIN walkinn_dossier_segment wds ON wds.id = wdsae.dossier_segment_id INNER JOIN walkinn_dossier wd ON wd.id = wds.dossier_id INNER JOIN walkinn_editorial we ON we.id = wdsae.editorial_wrapper_id INNER JOIN walkinn_editorial_contenu wec ON wec.editorial_id = we.id INNER JOIN walkinn_dossier_segment_activite_edito_day wdsaed ON wdsaed.dossier_segment_activite_edito_id = wdsae.id WHERE wd.id = :dossierId
Show context 
[
  "dossierId" => 4595
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Check in – Check out"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Qté"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "fournisseur"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "service"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "note"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "CHAMBRE STANDARD AVEC BALC [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT FUNCHAL / SAO LOURENCO"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT SAO LOURENCO / FUNCHAL"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "CHAMBRE STANDARD DEMI-PENS [...]"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT RIBEIRO FRIO / SANTANA"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "TRANSFERT SANTANA / PORTELA"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "CHAMBRE STANDARD BB *2025*"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Téléphone"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "DINER"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Informations complémentaires"
  "locale" => "fr_FR"
]
doctrine SELECT r.dossier_id FROM walkinn_dossier_segment r WHERE r.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.reference_resa_client AS reference_resa_client_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.is_valide AS is_valide_12, t0.annee AS annee_13, t0.date_confirmation AS date_confirmation_14, t0.code_client AS code_client_15, t0.docs AS docs_16, t0.envoi_docs AS envoi_docs_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.dossier_type_id AS dossier_type_id_20, t0.dossier_etat_id AS dossier_etat_id_21, t0.destination_id AS destination_id_22, t0.charge_dossier_id AS charge_dossier_id_23, t24.id AS id_25, t24.html AS html_26, t24.dossier_id AS dossier_id_27, t0.charge_dossier2_id AS charge_dossier2_id_28, t0.theme_id AS theme_id_29, t0.categorie_id AS categorie_id_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32 FROM walkinn_dossier t0 LEFT JOIN walkinn_dossier_guide t24 ON t24.dossier_id = t0.id WHERE t0.id = ? LIMIT 1
Show context 
[
  "4595"
]
doctrine SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.dossier_id = ? ORDER BY t0.date_depart ASC
Show context 
[
  4595
]
doctrine SELECT soc.rowid , soc.nom AS nom , soc.nom AS four_nom , soc.name_alias , soc.code_fournisseur , soc.email , soc.phone , soc.logo , IFNULL(soc.default_lang, "en_GB") AS default_lang , soc.multicurrency_code , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_PAX" LIMIT 1) AS is_pax , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_TO" LIMIT 1) AS is_to , dest.libelle AS destination_libelle , dest.code AS destination_code , socext.frais_fonctionnement AS frais_fonctionnement FROM doli_societe soc LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid LEFT JOIN walkinn_destination dest ON dest.id = socext.destination WHERE soc.rowid = 11
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.value AS value_4, t0.color AS color_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM walkinn_pax_rooming t0 WHERE t0.actif = ? ORDER BY t0.value ASC
Show context 
[
  true
]
doctrine SELECT pax.id , pax.note , pax.prestations , pax.libelle , pax.is_sup_single , IFNULL((IFNULL(pax.taux_remise, 0) * 100), 0) AS taux_remise , IFNULL(pax.montant_remise, 0) AS montant_remise , IFNULL(pax.taux_remise, 0) AS taux_remise_reel , (pax.frais_annulation * 100) AS frais_annulation , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , etat.color AS etat_color , room.id AS rooming_id , room.libelle AS rooming_libelle , room.numero_chambre AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , roomt.code AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , paxt.is_remise_en_euros AS pax_type_is_remise_en_euros , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contactex.nationalite AS contact_nationalite , pays.label AS contact_pays , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , DATE_FORMAT(contactex.passeport_date_validite, "%d/%m/%Y") AS contact_passeport_date_validite_formatted , DATEDIFF(contactex.passeport_date_validite, NOW()) AS contact_passeport_date_diff , ROUND(contactex.poids, 2) AS contact_poids , ROUND(contactex.poids, 2) AS location_poids , ROUND(contactex.taille, 2) AS contact_taille , ROUND(contactex.taille, 2) AS location_taille , contactex.informations AS contact_informations -- Champ non mappés en base , " " AS location_materiel FROM walkinn_dossier_segment_pax pax LEFT JOIN walkinn_dossier_segment seg ON seg.id = pax.segment_id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND pax.segment_id = :segmentId AND pax.actif = 1 ORDER BY CAST(room.numero_chambre AS DECIMAL) ASC, room.numero_chambre ASC
Show context 
[
  "segmentId" => 10792
]
doctrine SELECT vpc.id , vpc.periode_id , vpc.cotation_id AS config_id , vpc.prix_achat_tooltip , vpc.prix_vente , vpc.regulation_manuelle , vpc.ordre , vpc.prix_cession , vp.voyage_id , vp.libelle , vp.date_debut , vp.date_fin , vp.sup_single_achat , vp.sup_single_achat_tooltip , vp.sup_single_vente , vp.reduction_enfant , vp.reduction_lead , vp.date_reference , vp.parent_id , vp.vente_difference , vp.calcul , vp.is_sup_single , vc.nb_pax AS config_nbPax , vc.nb_sg AS config_nbSg , vc.nb_db AS config_nbDb , vc.nb_trp AS config_nbTrp , vc.nb_qd AS config_nbQd , vc.nb_qt AS config_nbQt , vc.nb_guide AS config_nbGuide , vc.nb_lead AS config_nbLead , vc.dont_enfant AS config_dontEnfant , vc.voyage_cotation_groupe_id FROM walkinn_voyage_periode_cotation vpc LEFT JOIN walkinn_voyage_periode vp ON vp.id = vpc.periode_id LEFT JOIN walkinn_voyage_cotation vc ON vc.id = vpc.cotation_id WHERE vp.voyage_id = :voyageId AND vp.actif = 1 AND vc.nb_pax = 2 AND ( (:date >= vp.date_debut AND :date <= vp.date_fin) OR EXISTS ( SELECT id FROM walkinn_voyage_periode_plage WHERE periode_id = vp.id AND :date >= date_debut AND :date <= date_fin ) )
Show context 
[
  "voyageId" => 11228
  "date" => "2025/04/26"
]
doctrine SELECT SUM(v.prix_achat_fixe) AS total FROM walkinn_dossier_segment_service v WHERE v.segment_id = 10792 AND v.actif = 1 AND v.service_id IS NOT NULL
doctrine SELECT t0.id AS id_1, t0.contact_id AS contact_id_2, t0.note AS note_3, t0.prestations AS prestations_4, t0.libelle AS libelle_5, t0.actif AS actif_6, t0.is_sup_single AS is_sup_single_7, t0.frais_annulation AS frais_annulation_8, t0.taux_remise AS taux_remise_9, t0.montant_remise AS montant_remise_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.segment_id AS segment_id_13, t0.dossier_segment_pax_etat_id AS dossier_segment_pax_etat_id_14, t0.pax_type_id AS pax_type_id_15, t0.rooming_id AS rooming_id_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM walkinn_dossier_segment_pax t0 WHERE t0.segment_id = ?
Show context 
[
  10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "Montant total en euros"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "pu"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "qt."
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "total"
  "locale" => "fr_FR"
]
doctrine SELECT r.dossier_id FROM walkinn_dossier_segment r WHERE r.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT pax.id , pax.note , pax.prestations , pax.libelle , pax.is_sup_single , IFNULL((IFNULL(pax.taux_remise, 0) * 100), 0) AS taux_remise , IFNULL(pax.montant_remise, 0) AS montant_remise , IFNULL(pax.taux_remise, 0) AS taux_remise_reel , (pax.frais_annulation * 100) AS frais_annulation , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , etat.color AS etat_color , room.id AS rooming_id , room.libelle AS rooming_libelle , room.numero_chambre AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , roomt.code AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , paxt.is_remise_en_euros AS pax_type_is_remise_en_euros , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, paxtparent.libelle, paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contactex.nationalite AS contact_nationalite , pays.label AS contact_pays , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , ROUND(contactex.poids, 2) AS contact_poids , ROUND(contactex.taille, 2) AS contact_taille , contactex.informations AS contact_informations FROM walkinn_dossier_segment_pax pax LEFT JOIN walkinn_dossier_segment seg ON seg.id = pax.segment_id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND pax.segment_id = :segmentId AND pax.actif = 1 AND etat.id != 3 ORDER BY CAST(room.numero_chambre AS DECIMAL) ASC, room.numero_chambre ASC;
Show context 
[
  "segmentId" => "10792"
]
doctrine SELECT soc.rowid , soc.nom AS nom , soc.nom AS four_nom , soc.name_alias , soc.code_fournisseur , soc.email , soc.phone , soc.logo , IFNULL(soc.default_lang, "en_GB") AS default_lang , soc.multicurrency_code , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_PAX" LIMIT 1) AS is_pax , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_TO" LIMIT 1) AS is_to , dest.libelle AS destination_libelle , dest.code AS destination_code , socext.frais_fonctionnement AS frais_fonctionnement FROM doli_societe soc LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid LEFT JOIN walkinn_destination dest ON dest.id = socext.destination WHERE soc.rowid = 11
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.value AS value_4, t0.color AS color_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM walkinn_pax_rooming t0 WHERE t0.actif = ? ORDER BY t0.value ASC
Show context 
[
  true
]
doctrine SELECT pax.id , pax.note , pax.prestations , pax.libelle , pax.is_sup_single , IFNULL((IFNULL(pax.taux_remise, 0) * 100), 0) AS taux_remise , IFNULL(pax.montant_remise, 0) AS montant_remise , IFNULL(pax.taux_remise, 0) AS taux_remise_reel , (pax.frais_annulation * 100) AS frais_annulation , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , etat.color AS etat_color , room.id AS rooming_id , room.libelle AS rooming_libelle , room.numero_chambre AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , roomt.code AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , paxt.is_remise_en_euros AS pax_type_is_remise_en_euros , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contactex.nationalite AS contact_nationalite , pays.label AS contact_pays , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , DATE_FORMAT(contactex.passeport_date_validite, "%d/%m/%Y") AS contact_passeport_date_validite_formatted , DATEDIFF(contactex.passeport_date_validite, NOW()) AS contact_passeport_date_diff , ROUND(contactex.poids, 2) AS contact_poids , ROUND(contactex.poids, 2) AS location_poids , ROUND(contactex.taille, 2) AS contact_taille , ROUND(contactex.taille, 2) AS location_taille , contactex.informations AS contact_informations -- Champ non mappés en base , " " AS location_materiel FROM walkinn_dossier_segment_pax pax LEFT JOIN walkinn_dossier_segment seg ON seg.id = pax.segment_id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND pax.segment_id = :segmentId AND pax.actif = 1 ORDER BY CAST(room.numero_chambre AS DECIMAL) ASC, room.numero_chambre ASC
Show context 
[
  "segmentId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "rooming"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "double"
  "locale" => "fr_FR"
]
doctrine SELECT r.dossier_id FROM walkinn_dossier_segment r WHERE r.id = :entiteId
Show context 
[
  "entiteId" => 10792
]
doctrine SELECT pax.id , pax.note , pax.prestations , pax.libelle , pax.is_sup_single , IFNULL((IFNULL(pax.taux_remise, 0) * 100), 0) AS taux_remise , IFNULL(pax.montant_remise, 0) AS montant_remise , IFNULL(pax.taux_remise, 0) AS taux_remise_reel , (pax.frais_annulation * 100) AS frais_annulation , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , etat.color AS etat_color , room.id AS rooming_id , room.libelle AS rooming_libelle , room.numero_chambre AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , roomt.code AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , paxt.is_remise_en_euros AS pax_type_is_remise_en_euros , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, paxtparent.libelle, paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contactex.nationalite AS contact_nationalite , pays.label AS contact_pays , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , ROUND(contactex.poids, 2) AS contact_poids , ROUND(contactex.taille, 2) AS contact_taille , contactex.informations AS contact_informations FROM walkinn_dossier_segment_pax pax LEFT JOIN walkinn_dossier_segment seg ON seg.id = pax.segment_id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND pax.segment_id = :segmentId AND pax.actif = 1 AND etat.id != 3 ORDER BY CAST(room.numero_chambre AS DECIMAL) ASC, room.numero_chambre ASC;
Show context 
[
  "segmentId" => "10792"
]
doctrine SELECT soc.rowid , soc.nom AS nom , soc.nom AS four_nom , soc.name_alias , soc.code_fournisseur , soc.email , soc.phone , soc.logo , IFNULL(soc.default_lang, "en_GB") AS default_lang , soc.multicurrency_code , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_PAX" LIMIT 1) AS is_pax , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_TO" LIMIT 1) AS is_to , dest.libelle AS destination_libelle , dest.code AS destination_code , socext.frais_fonctionnement AS frais_fonctionnement FROM doli_societe soc LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid LEFT JOIN walkinn_destination dest ON dest.id = socext.destination WHERE soc.rowid = 11
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.value AS value_4, t0.color AS color_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM walkinn_pax_rooming t0 WHERE t0.actif = ? ORDER BY t0.value ASC
Show context 
[
  true
]
doctrine SELECT pax.id , pax.note , pax.prestations , pax.libelle , pax.is_sup_single , IFNULL((IFNULL(pax.taux_remise, 0) * 100), 0) AS taux_remise , IFNULL(pax.montant_remise, 0) AS montant_remise , IFNULL(pax.taux_remise, 0) AS taux_remise_reel , (pax.frais_annulation * 100) AS frais_annulation , etat.id = 3 AS annulation , etat.id AS etat_id , etat.libelle AS etat_libelle , etat.color AS etat_color , room.id AS rooming_id , room.libelle AS rooming_libelle , room.numero_chambre AS rooming_numero_chambre , roomt.id AS rooming_type_id , roomt.libelle AS rooming_type_libelle , roomt.code AS rooming_type_code , roomt.color AS rooming_type_color , paxt.id AS pax_type_real_id , paxt.is_remise_en_euros AS pax_type_is_remise_en_euros , IF(paxtparent.id IS NOT NULL, paxtparent.id, paxt.id) AS pax_type_id , IF(paxtparent.id IS NOT NULL, CONCAT(paxtparent.libelle, "<br><br>", paxt.libelle), paxt.libelle) AS pax_type_libelle , IF(paxtparent.id IS NOT NULL, paxtparent.icone, paxt.icone) AS pax_type_icone , client.rowid AS tiers_id , client.code_client AS tiers_code , client.nom AS tiers_nom , contact.rowid AS contact_id , CONCAT(LEFT(contact.lastname, 1), LEFT(contact.firstname, 1)) AS contact_pax , CONCAT(contact.lastname, " ", LEFT(contact.firstname, 1), ".") AS contact_pax_full , contact.civility AS contact_civility , contact.firstname AS contact_prenom , contact.lastname AS contact_nom , contact.note_public AS note_public , contact.note_private AS note_private , DATE_FORMAT(contactex.date_naissance, "%d/%m/%Y") AS contact_date_naissance , FLOOR(DATEDIFF(seg.date_depart, contactex.date_naissance)/365) AS contact_age , contactex.assurance_nom AS contact_assurance_nom , contactex.assurance_numero AS contact_assurance_numero , contactex.assurance_infos AS contact_assurance_infos , IF(contact.phone_mobile IS NOT NULL AND LENGTH(contact.phone_mobile ) > 0, contact.phone_mobile , contact.phone_perso) AS contact_phone_mobile , contactex.nationalite AS contact_nationalite , pays.label AS contact_pays , contactex.passeport_numero AS contact_passeport_numero , contactex.passeport_date_validite AS contact_passeport_date_validite , DATE_FORMAT(contactex.passeport_date_validite, "%d/%m/%Y") AS contact_passeport_date_validite_formatted , DATEDIFF(contactex.passeport_date_validite, NOW()) AS contact_passeport_date_diff , ROUND(contactex.poids, 2) AS contact_poids , ROUND(contactex.poids, 2) AS location_poids , ROUND(contactex.taille, 2) AS contact_taille , ROUND(contactex.taille, 2) AS location_taille , contactex.informations AS contact_informations -- Champ non mappés en base , " " AS location_materiel FROM walkinn_dossier_segment_pax pax LEFT JOIN walkinn_dossier_segment seg ON seg.id = pax.segment_id LEFT JOIN walkinn_pax_type paxt ON paxt.id = pax.pax_type_id LEFT JOIN walkinn_pax_type paxtparent ON paxtparent.id = paxt.parent_id LEFT JOIN walkinn_dossier_segment_pax_rooming room ON room.id = pax.rooming_id LEFT JOIN walkinn_pax_rooming roomt ON roomt.id = room.pax_rooming_id LEFT JOIN walkinn_dossier_segment_pax_etat etat ON etat.id = pax.dossier_segment_pax_etat_id LEFT JOIN doli_socpeople contact ON contact.rowid = pax.contact_id LEFT JOIN doli_c_country pays ON pays.rowid = contact.fk_pays LEFT JOIN doli_socpeople_extrafields contactex ON contactex.fk_object = contact.rowid LEFT JOIN doli_societe client ON client.rowid = contact.fk_soc LEFT JOIN doli_societe_extrafields clientex ON clientex.fk_object = client.rowid WHERE 1 = 1 AND pax.segment_id = :segmentId AND pax.actif = 1 ORDER BY CAST(room.numero_chambre AS DECIMAL) ASC, room.numero_chambre ASC
Show context 
[
  "segmentId" => 10792
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "double"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "dateFormat"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "du"
  "locale" => "fr_FR"
]
doctrine SELECT transvalue, toModerate FROM doli_overwrite_trans WHERE `transkey` = :key AND lang = :locale LIMIT 1
Show context 
[
  "key" => "au"
  "locale" => "fr_FR"
]
doctrine SELECT t0.id AS id_1, t0.position AS position_2, t0.libelle AS libelle_3, t0.html AS html_4, t0.type AS type_5, t0.numero_page AS numero_page_6, t0.date_jour AS date_jour_7, t0.entity_ids AS entity_ids_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.actif AS actif_11, t0.is_deleted AS is_deleted_12, t0.template_id AS template_id_13, t0.document_generator_id AS document_generator_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16 FROM walkinn_document_generator_page t0 WHERE t0.document_generator_id = ? ORDER BY t0.position ASC
Show context 
[
  5137
]
doctrine SELECT t0.id AS id_1, t0.icone AS icone_2, t0.libelle AS libelle_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM ba_notification_type t0 WHERE t0.id = ?
Show context 
[
  2
]
doctrine SELECT t0.id AS id_1, t0.icone AS icone_2, t0.libelle AS libelle_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM ba_notification_type t0 WHERE t0.id = ?
Show context 
[
  1
]
doctrine SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.icon AS icon_3, t0.color AS color_4, t0.config AS config_5, t0.entite AS entite_6, t0.langue AS langue_7, t0.format AS format_8, t0.orientation AS orientation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.actif AS actif_12, t0.is_deleted AS is_deleted_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM walkinn_document_generator_modele t0 WHERE t0.id = ?
Show context 
[
  15
]
doctrine SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.locale AS locale_3, t0.translated_text AS translated_text_4, t0.is_validated AS is_validated_5, t0.redirect_url AS redirect_url_6, t0.sub_redirect_url AS sub_redirect_url_7 FROM translation t0 WHERE t0.redirect_url = ?
Show context 
[
  "/symfony/public/dossier/45 [...]"
]
security Stored the security token in the session.
Show context 
[
  "key" => "_security_main"
]
event Notified event "kernel.response" to listener "App\EventListener\TranslationModerationListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "App\EventListener\TranslationModerationListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]
event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse".
Show context 
[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]
event Notified event "kernel.finish_request" to listener "Symfony\Bridge\Monolog\Processor\RouteProcessor::removeRouteData".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bridge\Monolog\Processor\RouteProcessor::removeRouteData"
]
event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]
event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]
event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]
event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]
event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest".
Show context 
[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

PHP Notices 0

Log messages generated by PHP notices silenced with the @ operator.

There are no log messages of this level.

Container 0

Log messages generated during the compilation of the service container.

There are no compiler log messages.