Hi,

I want to do this custom process, based on $data and also on $_SESSION :

->pipe(new CalculatedColumn(array(
            "Challenge"=>function($data){	

              if ($_SESSION['Username'] !='VALIFAX' && $data["ACC"] != 'VALIFAX'){

                    if ($data["Prospect_Client"]=='client' ){
                        return  ( ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"])*1.1 ); 
                    }
                    else { 
                        return ( ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"]) ) ; 

                    }

               } 
               else {
                
                    if ($data["Prospect_Client"]=='client' ){
                        return  ( 2.5 * ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"])*1.1 ); 
                    }
                    else { 
                        return ( 2.5 * ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"]) ) ; 
                    }
               }
            }   
        )))

Tthe $_SESSION doesnt work inside the function (but it works outside). And when I try to insert in the function arg, it doesn't work either. How could I do ?

Thanks a lot

The $_SESSION is set because I use it before in my code which is. It works with filter, but strangely nothing happened. What's wrong ?

$this->src('sales')


        ->pipe(new Filter(array(
            array("Ccial","=",$_SESSION['Username']),
            'or',
            array("ACC","=",$_SESSION['Username']),
        )))

->pipe(new Map(array(
      '{value}' => function($row, $metaData) {
        if ($row['Société'] != null && trim($row['Société']) != '' && trim($row['Société']) != '-')
          return array($row);
      },
    )))


->pipe(new Filter(array(
         array("Ccial","!=",null),
            array("Société","!=",null),
 )))


->pipe(new CalculatedColumn(array(
            "PO"=>function($data){

                        return  ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"]); 
                   
            }
        )))

->pipe(new CalculatedColumn(array(
            "Challenge"=>function($data){	

              if ($_SESSION['Username'] !='VALIFAX' && $data["ACC"]!='VALIFAX' ){

                    if ($data["Prospect_Client"]=='client' ){
                        return  ( ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"])*1.1 ); 
                    }
                    else { 
                        return ( ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"]) ) ; 

                    }

               } 
               else {
                
                    if ($data["Prospect_Client"]=='client' ){
                        return  ( 2.5 * ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"])*1.1 ); 
                    }
                    else { 
                        return ( 2.5 * ($data["Marge_FAS_Déclarée"] + 12 * $data["MARGE_DELTA_REC"]) ) ; 
                    }
               }
            }   
        )))

        ->pipe(new Filter($filter_args))

        
        ->pipe($this->dataStore('commandes'));

Hi, I did some tests and the $_SESSION variable seems to doesn't work inside

->pipe(new CalculatedColumn(array(
            "Challenge"=>function($data){	
...

}