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

Djourdain

<?php

namespace Types;

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

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

Djourdain

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

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

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

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

   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 FAMILLE_SAUVE AS(
        SELECT cdfam, MAX(cdmaj) AS cdmaj, MAX(dtsave)
            FROM ever_famille_sauve
            WHERE dtsave >= :dateDernierTraitement
            GROUP BY cdfam
        )
        SELECT efs.cdfam as code_famille,
               f.libfam as libelle_famille,
               m.id_centre_profit AS centre_profit,
               efs.cdmaj = 'S' AS a_supprimer

Djourdain

WITH EDITEUR_SAUVE AS
         (
             SELECT cdeditr, MAX(dtsave), max(cdmaj) AS cdmaj FROM ever_editeur_sauve
             WHERE nummarqueeditoriale IS NULL
               AND dtsave >= :dateDernierTraitement
             GROUP BY cdeditr
         ),
CATEGORIE_EDITEUR AS (
    SELECT string_agg( DISTINCT code_produit_fdn,',') AS categorie, es.cdeditr
    FROM  EDITEUR_SAUVE es