08/12/2025 04:01:04 [ get_dg_stocks_outflow_chx.php ] #52 => concat_ch =>---
08/12/2025 04:01:04 [ get_dg_stocks_outflow_chx.php ] #209 => QUERY =>SELECT 'ridba002' AS fk_entite, 'Indiana 2' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:01:04 [ get_dg_stocks_outflow_chx.php ] #209 => QUERY =>SELECT 'ridba001' AS fk_entite, 'Indiana 1' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:01:04 [ get_dg_stocks_outflow_chx.php ] #209 => QUERY =>SELECT 'ridba003' AS fk_entite, 'INDIANA3' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:05:12 [ get_dg_stocks_outflow_chx.php ] #52 => concat_ch =>---
08/12/2025 04:05:12 [ get_dg_stocks_outflow_chx.php ] #210 => QUERY =>SELECT 'ridba002' AS fk_entite, 'Indiana 2' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY rofl0364_xpr.xpr_dg_entites.ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:05:12 [ get_dg_stocks_outflow_chx.php ] #210 => QUERY =>SELECT 'ridba001' AS fk_entite, 'Indiana 1' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY rofl0364_xpr.xpr_dg_entites.ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:05:12 [ get_dg_stocks_outflow_chx.php ] #210 => QUERY =>SELECT 'ridba003' AS fk_entite, 'INDIANA3' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY rofl0364_xpr.xpr_dg_entites.ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC
08/12/2025 04:05:46 [ get_essai.php ] #24 => num_jr=3---
08/12/2025 04:05:57 [ get_dg_stocks_outflow_chx.php ] #52 => concat_ch =>---
08/12/2025 04:05:57 [ get_dg_stocks_outflow_chx.php ] #210 => QUERY =>SELECT 'ridba002' AS fk_entite, '' AS nom_court,  
        rofl0364_xpr.xpr_dg_entites.ent_geo, rofl0364_xpr.xpr_dg_entites.ent_geo_ord,
        CONCAT(rofl0364_xpr.xpr_dg_entites.adresse1, ' - ',rofl0364_xpr.xpr_dg_entites.ville) AS adresse_ville,
        dg_stock_out_chx.id, dg_stock_out_chx.act, dg_stock_out_chx.num_bs, 
        dg_stock_out_chx.date_sortie, dg_stock_out_chx.comments, 
        dg_stock_out_chx.fk_operateur, rofl0364_xpr.du_status_lang.code_status, 
        rofl0364_xpr.du_status_lang.desc_status, dg_stock_out_chx.fk_status
        FROM rofl0364_xpr.xpr_dg_entites 
          JOIN (dg_stock_out_chx JOIN 
          rofl0364_xpr.du_status_lang 
          ON dg_stock_out_chx.fk_status = rofl0364_xpr.du_status_lang.code_status)
          ON dg_stock_out_chx.fk_ent_geo = rofl0364_xpr.xpr_dg_entites.ent_geo
        WHERE  ( dg_stock_out_chx.date_sortie 
      BETWEEN '20170101' AND '20251231' 
      AND dg_stock_out_chx.fk_status = 'REC' 
      AND DATEDIFF( '20251208' , 
        dg_stock_out_chx.date_sortie ) > '3' 
        AND rofl0364_xpr.du_status_lang.lang = 'FR'
        AND dg_stock_out_chx.fk_status NOT IN ( 'DLT' )
        AND rofl0364_xpr.xpr_dg_entites.fk_status NOT IN ( 'DLT' )
        
        HAVING 1
        
        ORDER BY rofl0364_xpr.xpr_dg_entites.ent_geo_ord, dg_stock_out_chx.fk_status, date_sortie DESC