<?php
     $image_params   = array(
        'w'                 => 100,
    );
    $matched_image  = '';
    //get the user and drop it in for a preview
    $imageSrc       = _dw_campaigns_get_photo($thisUser,  $image_params, 'pcp-photo', $pcp->id, $matched_image);

    if(arg(2) == 'give' && arg(3) == 'general-donation') {
        echo '<div class="blurb">To make a donation to an individuals fundraising page, please return to the home page and select the location in which the individual is participating.</div>';
    }
?>
    <h2><?php echo t('Donate to @title', array('@title' => $pcp->title));?></h2>
    <img src="<?php echo $imageSrc;?>">

<?php
    $form   = drupal_get_form('dw_campaigns_users_donate_page_form', $campaign, $pcp);
    echo $form; 
?>
<div style="display:none">
	<a href="#hidden-words" id="show-words"></a>
	<div id="hidden-words">
		<span class="please-wait"><?php echo t('Please wait, we are processing your donation.'); ?></span>
		<br>
		<span class="please-wait-extra"><?php echo t('Reloading or navigating away from this page may cause multiple donations'); ?></span>
	</div>
</div>
        $params['returnFirst']      = 1;
        $params['contribution_id']  = $supporter->contribution_id;
        $contribution               = _dw_civicrm_contribution_get($params);

        $params                 = array();
        $params['contact_id']           = $supporter->contact_id;
        $params['returnFirst']  = 1;
        $contact                = _dw_civicrm_contact_get($params);

        $image_match = '';
        if($supporter->pcp_display_in_roll == 1) {
            $name   = $supporter->pcp_roll_nickname;
            $photo  = _dw_campaigns_get_photo(array(), array(), 'donation-photo', $supporter->id, $image_match);
        } else {
            $name   = 'Anonymous';
            $photo  = _dw_campaigns_get_photo(array(), array(), 'donation-photo', 0, $image_match);
        }

        $email      = $contact->email;
        $amount     = $supporter->amount;
        $location   = $contact->city . ', ' . $contact->state_province;
        $date       = substr($contribution->receive_date, 0, 10);
        
        $note       = is_object($supporter->pcp_personal_note)?'':$supporter->pcp_personal_note;
        
        
        db_query("insert into {donations_as_$num_per_page} (name, photo, email, amount, location, donationdate, note) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $name, $photo, $email, $amount, $location, $date, $note);
    }

    $sql_count = "select count(*) from donations_as_$num_per_page";
        $params                     = array();
        $params['contact_id']       = $supporter->contact_id;
        $params['returnFirst']      = 1;
        $contact                    = _dw_civicrm_contact_get($params);

        $row = array();

        $name       = $contact->display_name;

        
        if(!empty($supporter->pcp_roll_nickname)) {
            $name .= " (" . $supporter->pcp_roll_nickname . ")";
        }

        $photo      = _dw_campaigns_get_photo(array(), array(), 'donation-photo', $supporter->id, $image_match);
        $email      = $contact->email;
        $amount     = $supporter->amount;
        $location   = $contact->city . ', ' . $contact->state_province;
        //$date       = substr($contribution->receive_date, 0, 10);
        $date       = $contribution->receive_date;
        $note       = is_object($supporter->pcp_personal_note)?'':$supporter->pcp_personal_note;
        $pay_later  = $supporter->is_pay_later;
        
        db_query("insert into {donations_as} (name, photo, email, amount, location, donationdate, note, is_pay_later) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $name, $photo, $email, $amount, $location, $date, $note, $pay_later);
    }

    $sql_count = "select count(*) from donations_as";

    //$result = db_query("select * from donations_as " . tablesort_sql($headers));
    $result = pager_query("select * from donations_as " . tablesort_sql($headers), $num_per_page, 0, $sql_count);
    db_query($query);

    $position   = 0;
    $rows       = array();
    foreach($leaders as $leader) {
        $position++;
        $image_match    = '';
        $image_params   = array(
            'w'                 => 100,
            'contribution'      => true,
        );
        $fake_user      = user_load(array('uid' => $leader['drupal_id']));
        $contact        = $leader['contact'];

        $name           = $leader['name'];
        $photo          = _dw_campaigns_get_photo($fake_user, $image_params, 'user-photo', NULL, $image_match);
        $amount         = $leader['total'];
        $location       = $contact->city . ', ' . $contact->state_province;
        $donations      = $leader['donations'];
        $url            = $leader['url'];
        
        
        db_query("insert into {leader_as_$num_per_page} (name, photo, position, amount, location, donations, url) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $name, $photo, $position, $amount, $location, $donations, $url);
    }

    $sql_count = "select count(*) from leader_as_$num_per_page";

    //$result = db_query("select * from donations_as " . tablesort_sql($headers));
    $result = pager_query("select * from leader_as_$num_per_page " . tablesort_sql($headers), $num_per_page, 0, $sql_count);

    $rows = array();