Replies

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  April 2014

  The second parameter ( `$data` in your above example) contains the data for the whole row. So you might use `$data['myField1']` for example.
  
  Allan
• jgcaudet Posts: 82Questions: 7Answers: 0

  April 2014

  It doesn,t Works. When I saw rows of datatables this field doesn,t reflect changes I made.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  April 2014

  Can you show me the code you used please?
  
  Allan
• jgcaudet Posts: 82Questions: 7Answers: 0

  April 2014 edited April 2014

  [code]
  $editor = Editor::inst( $db, 'vista_etl' )
  ->fields(
  Field::inst( 'id' ),
  Field::inst( 'may_id' ),
  Field::inst( 'productid' )->set(false),
  Field::inst( 'etl_product_desc' )
  ->getFormatter( function($val, $data, $field) {
  global $rdo ;
  $psDescripcionDetallada = '' ;
  $piProductId = $data['productid'] ;
  if (!$piProductId || $piProductId == "") {
  //
  }
  else {
  //
  $query = "SELECT `a`.*, `b`.`name`, `c`.`headerid`, `c`.`defaultdisplayorder` as `Attributedefaultdisplayorder`, `d`.`name` as `headername`, `e`.`defaultdisplayorder` FROM `productattribute` `a`
  WHERE ... ";
  
  //
  if (bd_query($query)) {
  $psDescripcionDetallada = ' ..... ' ;
  
  $piHeaderId = 0 ;
  $i = 0;
  while($row = $rdo->fetch_assoc()) {
  if ($row['headerid'] != $piHeaderId) {
  //
  $psDescripcionDetallada = $psDescripcionDetallada . ' ....'
  
  $piHeaderId = $row['headerid'] ;
  }
  
  $psDescripcionDetallada = $psDescripcionDetallada . ' ....'
  
  $i++;
  } ;
  
  $psDescripcionDetallada = $psDescripcionDetallada . '' . '';
  
  }
  else {
  };
  
  }; // Del if (!$piProductId || .....
  
  if ($psDescripcionDetallada != "" ) { $data['tiene_desc_etl'] = 'Si' ;} // HERE I CHANGE
  return $psDescripcionDetallada ;
  
  })
  ->set(false),
  Field::inst( 'tiene_desc_etl' )->set(false)
  )
  [/code]
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  April 2014

  That's a belter of a formatter!
  
  So I understand correctly, is it this part which isn't working as you expected: `$piProductId = $data['productid'] ;` ? I'll try to create an example here that reproduces that error can get back to you.
  
  Allan
• jgcaudet Posts: 82Questions: 7Answers: 0

  April 2014

  No.
  
  I want that if this field 'etl_product_desc' which value I calculate in its getFormatter function (that I show you here) is not empty, then I change the value of 'tiene_desc_etl' with
  
  $data['tiene_desc_etl'] = 'Si' ;
  
  in this line if ($psDescripcionDetallada != "" ) { $data['tiene_desc_etl'] = 'Si' ;} // HERE I CHANGE
  
  I test directly $data['tiene_desc_etl'] = 'Si' without the "if ...." and if doesn´t work too.
  
  Thanks.
• jgcaudet Posts: 82Questions: 7Answers: 0

  April 2014

  sorry I mean "it doesn´t work too".
  The getformatter function works ok (calculate the value for 'etl_product_desc' correctly), but my datatables shows me column 'tiene_desc_etl' with all values to 'No'.
• jgcaudet Posts: 82Questions: 7Answers: 0

  April 2014

  Could you reproduce it ?