function  getAllNbox($IDCOLI,$connExat){

    $arraySql = array();
    $arrayJson = array();
    $message = "";
    $code_statut = "";
    $str_STATUT = "enable";
    $intResult = 0;

        if ($IDCOLI == "" || $IDCOLI == null) {
        $IDCOLI = "%%";
    }
        $str_SECURITY_ID = $connExat->quote($_SESSION['str_SECURITY_ID']);
         $IDCOLI = $connExat -> quote($IDCOLI);

         /// COLIS 
         $sql="SELECT [Lot No_],[OF No_]
             FROM [EXAT].[dbo].[Exat\$BC Quality Control Header\$7cb84202-8053-429b-9e43-65646a6e3dae]
             WHERE [Lot No_] = $IDCOLI ";

    try{
        $stmt = $connExat-> query($sql);
    }
    catch(Exception $e){
        die("Erreur ! : " . $e->getMessage());
    }

    $result_filtre = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($result_filtre as $item_result) {


//OF
        $sqlOf="SELECT [No_] ,[Mix No_]
             FROM [EXAT].[dbo].[Exat\$Production Order\$7cb84202-8053-429b-9e43-65646a6e3dae]
             WHERE  [No_]  = '".$item_result['OF No_']."' ";
        $stmt = $connExat-> query($sqlOf);
        $resultOf = $stmt->fetchAll(PDO::FETCH_ASSOC);
        //$cpt3 = 0;
        foreach ($resultOf as $item_resultOf) {

            //MELANGER

             $sql0="SELECT [Mix No_] as nbox,[Lot No_] AS Lot, [Item Description] as NomArticle,[NB Part] AS NbPart,[Percentage Of Distribution] AS Percentage1
                    FROM [EXAT].[dbo].[Exat\$Mix lines\$7cb84202-8053-429b-9e43-65646a6e3dae]
                    WHERE  [Mix No_] = '".$item_resultOf['Mix No_']."' ";
 
                   $stmt = $connExat-> query($sql0);
                   $result0 = $stmt->fetchAll(PDO::FETCH_ASSOC);
                       //$cpt3 = 0;
                   foreach ($result0 as $item_result0) {
                  $item_result0 += array('Percentage'=>  number_format($item_result0['Percentage1'], 2,',', ' ') ); 

                   $nbFournisseur=getNbFournisseur( $connExat,$item_result0['Lot']) ;
                   $item_result0 += array('nbFournisseur'=>  $nbFournisseur ); 

            
           $code_statut = "1";
           $arraySql[] = $item_result0;
           $intResult++;
     
    }
    }
    }

    $arrayJson["results"] = $arraySql;
    $arrayJson["total"] = $intResult;
    $arrayJson["desc_statut"] = $connExat->errorInfo();
    $arrayJson["code_statut"] = $code_statut;
    echo "[" . json_encode($arrayJson) . "]";
}