Answers

• allan Posts: 64,230Questions: 1Answers: 10,599 Site admin

  March 26

  I've got to confess, I didn't think of this scenario! You could probably just comment out this part in your local copy, and, although I haven't tried it, I expect that it should work.

  Allan
• rf1234 Posts: 3,079Questions: 89Answers: 427

  March 26 edited March 26

  There is also another way to do this like this. That shouldn't cause any problems with "leftJoin". I am using this all the time.

  // Field::inst( 'getLastDataDate(id)', 'lastDataPoint')->set( false ),
  Field::inst('bedrijf.id AS lastDataPoint')->set( false )
      ->getFormatter( function($val, $data, $opts) {
         return getLastDataDate($val);
      }),     
  
  
• Maikel Posts: 82Questions: 21Answers: 1

  March 27

  in this last example is getLastDataDate en sql function?
• rf1234 Posts: 3,079Questions: 89Answers: 427

  March 27

  Don't know Maikel.

  But you could easily pass the db handler to the function like this

  Field::inst('bedrijf.id AS lastDataPoint')->set( false )
      ->getFormatter( function($val, $data, $opts) use ($db){
         return getLastDataDate($val, $db);
      }),    
  

  Here is an example from my own coding using Editor's db handler and Editor's "raw" method:

  Field::inst( 'ctr_govdept.id AS ctr_govdept.has_contracts' )->set( false )
      ->getFormatter( function($val, $data, $opts) use ($db){
          $result = $db->raw()
              ->bind( ':fk', $val )  
              ->exec( 'SELECT COUNT(*) AS ctrCount 
                         FROM ctr_has_ctr_govdept  
                        WHERE ctr_govdept_id = :fk' );
          $row = $result->fetch(PDO::FETCH_ASSOC);
          if ( (bool)$row["ctrCount"] ) {
              return 1;
          }
          return 0;
      }),