CiviCRM Community Forums (archive)

if i am right dashboard.tpl should be modified.

i would add this on the top

<tr>
    <td><strong>{ts}Private Donations{/ts}</strong></td>
    <td class="label">{if NOT $monthToDate.Valid.amount}{ts}(n/a){/ts}{else}{$monthToDate.Valid.amount}{/if}</td>
    <td class="label">{$monthToDate.Valid.count}</td>
    <td><a href="{$monthToDate.Valid.url}">{ts}view details{/ts}...</a></td>
</tr>

But How do i edit the code to display the private donations of this month?

thanks
conte

A patch in this issue seems to do something similar, but for memberships. Maybe it can provide hints on what needs to be done for contributions: http://issues.civicrm.org/jira/browse/CRM-7239

Note: I'm not sure if, in your case, this is the best approach however, since then you will have to maintain a custom patch to CiviCRM that you will need to re-apply after each upgrade.

i modified dashboard.php a little more to this:

        $status      = array( 'Valid', 'Cancelled' );
        $prefixes    = array( 'start', 'month', 'year' , 'private' );
        $startDate   = null;
        $startToDate = $monthToDate = $yearToDate = $privateToDate = array( );

        //get contribution dates.
        require_once 'CRM/Contribute/BAO/Contribution.php';
        $dates = CRM_Contribute_BAO_Contribution::getContributionDates( );
        foreach ( array( 'now', 'yearDate', 'monthDate', 'privateDate' ) as $date ) {
            $$date = $dates[$date];
        }
        $yearNow = $yearDate + 10000;
        foreach ( $prefixes as $prefix ) {
            $aName = $prefix . 'ToDate';
            $dName = $prefix . 'Date';
            $type = $contribution_type_id_value = 3;

            if ( $prefix == 'year') {
                $now  = $yearNow;
            }

            foreach ( $status as $s ) {
                ${$aName}[$s]        = CRM_Contribute_BAO_Contribution::getTotalAmountAndCount( $s, $$dName, $now, $type );
                ${$aName}[$s]['url'] = CRM_Utils_System::url( 'civicrm/contribute/search',
                                                              "reset=1&force=1&status=1&start={$$dName}&end=$now&test=0");
            }

            $this->assign( $aName, $$aName );
        }

can this line: $type = $contribution_type_id_value = 3;  be right for private donations?

in dashboard.tpl this line: {$privateToDate.Valid.amount} calculates now the total amount of contributions received in every year and not only the privatedonations from the current month.

thanks
conte

up

Hi,

I copy/pasted all the changes I have made.

As I said I would like to change the tabular view of the contribution dashboard. CiviCRM shows the Monthly contributions, Total contributions of this year and overall total contributions.

I would like to add several columns for each contribution type. Therefore I would like to have seperate columns for all private, company, online contributions and memberships fees for the current month.

thanks
conte

hi

i am still looking for a way to achieve my goal. any new ideas?

thanks
conte