How to insert static value into each row?

[allenthehusband]

I have added a new column to our Pledge Summary report which will be used when we export to CSV.  We need each row of that column to be the same text value.  I added the new column header in the "function postProcess()" with the below example code:

Code: [Select]

$this->_columnHeaders['xyz'] = array(
'title' => 'X, Y & Z',
);
How would I then add a set text value to each row of that column? 

I could add a custom field to our pledges, fill that custom field with the same default value then add the custom field to our report, but I figured adding another field to our database wasn't the way to go if the value could be provided on just the exported report.
 
Thanks for the help!

[Erik Hommel]

There are several ways in which you can do this. What I generally do is copy the buildRows function from the parent class (CRM/Report/Form) and there add my values. The buildRows will be:

Code: [Select]

  function buildRows($sql, &$rows) {
    $dao = CRM_Core_DAO::executeQuery($sql);
    if (!is_array($rows)) {
      $rows = array();
    }

    // use this method to modify $this->_columnHeaders
    $this->modifyColumnHeaders();

    $unselectedSectionColumns = $this->unselectedSectionColumns();

    while ($dao->fetch()) {
      $row = array();
      foreach ($this->_columnHeaders as $key => $value) {
        if (property_exists($dao, $key)) {
          $row[$key] = $dao->$key;
        }
      }

      // section headers not selected for display need to be added to row
      foreach ($unselectedSectionColumns as $key => $values) {
        if (property_exists($dao, $key)) {
          $row[$key] = $dao->$key;
        }
      }

      $rows[] = $row;
    }
  }
so you could add you specific bit of code after the foreach loop, something like this:

Code: [Select]

$row['xyz'] = 'XYZ';
Does that help?

Alternative is to add your own function inside the postProcess function that is probably already in your report Class, just after the buildRows function has been executed.
[/code]

[allenthehusband]

Erik, this is a huge help.  I'm still piecing together for myself how exactly the reports work; your explanation goes a long way in helping me understand!  Thank you!