Answers

• allan Posts: 63,227Questions: 1Answers: 10,416 Site admin

  October 2014 Answer ✓

  Sure, use a getFormatter. Something like:

  Field::inst( 'checkcode' )
    ->getFormatter( function ( $val ) {
      return str_replace( 'whatever', 'this', $val );
    } )
  

  Allan
• Restful Web Services Posts: 202Questions: 49Answers: 2

  October 2014 edited October 2014

  Thanks Allan, that worked really well.

  As you seem to be very adept at using datatables I don't suppose you can point me in the right direction of where I can find documentation illustrating how to add a class to my rows matching that of the value found in

  Field::inst ( 'checkcode')
  

  If my checkcode value is 'error' I can create a CSS class .error which will enable me to give the row a red background color, or something like that.

  Is that possible?

  Thanks

  Chris
• Restful Web Services Posts: 202Questions: 49Answers: 2

  October 2014

  I have added a class directly in my str_replace, is this a good thing to do though or is there a better way?

  Editor::inst( $db, 'cms_module_tps_userlisting', 'list_id' )
      ->fields(
          Field::inst( 'listphone' ),
          Field::inst( 'create_date' ),
          Field::inst( 'checkcode' )
          ->getFormatter( function ( $val ) {
          $code = array('EDNP', 'ENUM', 'VALID');
          $real = array('ERROR', '<span class="yellow">INCORRECT FORMAT</span>', '<span class="green">VALID</span>');
              return str_replace( $code, $real, $val );
          }),
          Field::inst( 'user_id' )
      )
  
• allan Posts: 63,227Questions: 1Answers: 10,416 Site admin

  October 2014

  an point me in the right direction of where I can find documentation illustrating how to add a class to my rows matching that of the value found

  Use columns.createdCell, or possibly rowCallback.

  I have added a class directly in my str_replace, is this a good thing to do though or is there a better way?

  That looks fine to me, as long as your Editor can those values.

  Allan
• Restful Web Services Posts: 202Questions: 49Answers: 2

  October 2014

  Thanks, seems to work well. However, I have another str_replace issue. This doesn't seem to work and I thought it would?

          Field::inst( 'registered_with_tps' )
          ->getFormatter( function ( $val ) {
          $null = array('0000-00-00 00:00:00');
          $placeholder = array('-');
              return str_replace( $null, $placeholder, $val );
          })
          ->getFormatter( 'Format::date_sql_to_format', 'd/m/Y \a\t H:i' )
  

  I don't want to display any dates which are 'null', i.e. 0000-00-00 00:00:00, so I replace them with a - symbol. That works fine.

  I also want to change the date format which works fine.

  However, if I combine the two ->getFormatter functions, the str_replace function doesn't run.
• allan Posts: 63,227Questions: 1Answers: 10,416 Site admin

  October 2014

  You can't have two different formatter functions - you would need to combine the two operations into a single one.

  The code for the date_sql_to_format() method is available here.

  Allan
• Restful Web Services Posts: 202Questions: 49Answers: 2

  October 2014

  HI Allan,

  Thanks for your continued support. I managed to get a working solution using the following if else statement within the getFormatter function.

          Field::inst( 'registered_with_tps' )
                  ->getFormatter( function ($val, $data, $field) {
                  if ($val == '0000-00-00 00:00:00') return "-";
                  else if ($val <> '0000-00-00 00:00:00') return $val = date('d/m/Y \a\t H:i');
                  })
  

  Chris