Djourdain

   SELECT TRIM(cdpdtcofp) AS code_lot,
               TRIM(cdpdtcoff) AS code_unitaire,
               qte AS quantite_par_lot
        FROM resadec.public.coffret
        WHERE hd_dtheure >= :dateDernierTraitement

Djourdain

WITH FOURNISSURS_SAUVE AS (
    SELECT cdfour, MAX(cdmaj) AS cdmaj, MAX(dtsave)
    FROM ever_fournisseur_sauve
    WHERE dtsave >= :dateDernierTraitement
    GROUP BY cdfour
),
     FOURNISSEURS AS (SELECT DISTINCT efs.cdfour,
                                      f.nomfour,
                                      f.gencodfour,
                                      de.cddevisefdn,

Djourdain

WITH PRODUITS_SAUVE AS (
    SELECT cdpdt, MAX(cdmaj) AS cdmaj, MAX(dtsave)
    FROM ever_produit_sauve
    WHERE dtsave >= :dateDernierTraitement
    GROUP BY cdpdt
)
SELECT DISTINCT
    p.cdpdt as "gencode_produit",
    COALESCE(pap.cdappelprix,'') as "code_court",
    p.cdcollecserie as "code_seriel",

Djourdain

0650414100119 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 conversion error from string ""
 0650414696223 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 conversion error from string ""
 0727542484319 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 arithmetic exception, numeric overflow, or string truncation
 3045050507151 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 arithmetic exception, numeric overflow, or string truncation
 3045670009004 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 conversion error from string ""
 3045670044852 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 conversion error from string ""
 3045670044982 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error code = -303 conversion error from string ""
 3045670045187 : SQLSTATE[HY000]: General error: -303 Dynamic SQL Error SQL error cod

Djourdain

{
    "reasons": [
        {
            "code": "37",
            "is_shop_right": false,
            "label": "J’ai retourné ma commande en Magasin Auchan.",
            "type": "INCIDENT_OPEN"
        },
        {
            "code": "38",

Djourdain

<?php

namespace Types;

use Doctrine\DBAL\Types\Type;
use Doctrine\DBAL\Platforms\AbstractPlatform;

class Int4Range extends Type
{
    const INT_4_RANGE = "int4range";

Djourdain

create OR REPLACE function req_usr_pro_pdt_en_cours_de_num_tl() returns TABLE("Ean" character varying, "Titre" character varying, "Type" character varying, "Prix ttc" numeric, "Diffuseur" character varying, "Fournisseur" character varying, "Editeur" character varying, "Grande Image" character varying, "Petite Image" character varying, "Résumé" character varying, "Sommaire" character varying, "Biographie" character varying, "Réceptionné le" character varying, "A " character varying, "Site" character varying, "Enrichi le " character varying, "A" character varying, "Vérrouille commande" boolean)
	language sql
as $$
WITH PDT_A_NUM AS ( SELECT code_produit,
                           date_envoi_numerisation,
                           verouille_commande_client,
                           site_commande,
                           date_enrichissement
                    FROM produit_a_numeriser
                    WHERE date_reintegration IS NULL

Djourdain

create OR REPLACE function req_usr_pro_pdt_en_cours_de_num_tl() returns TABLE("Ean" character varying, "Titre" character varying, "Type" character varying, "Prix ttc" numeric, "Diffuseur" character varying, "Fournisseur" character varying, "Editeur" character varying, "Grande Image" character varying, "Petite Image" character varying, "Résumé" character varying, "Sommaire" character varying, "Biographie" character varying, "Réceptionné le" character varying, "A " character varying, "Site" character varying, "Enrichi le " character varying, "A" character varying, "Vérrouille commande" boolean)
	language sql
as $$
WITH PDT_A_NUM AS ( SELECT code_produit,
                           date_envoi_numerisation,
                           verouille_commande_client,
                           site_commande,
                           date_enrichissement
                    FROM produit_a_numeriser
                    WHERE date_reintegration IS NULL