$goalProgress += $goalExtra;
}
if($goalTotal == 0) {
drupal_set_message(t('Unable to load campaign goals'), 'error');
return;
}
// I assume we want to round 99.9 down so that we don't say 100% too soon
$goalPercent = floor($goalProgress/$goalTotal * 100);
if($goalPercent > 100) {
$goalPercent = 100;
}
$goalRemaining = dw_campaigns_force_decimal($goalTotal - $goalProgress, $currency);
$goalTotal = dw_campaigns_force_decimal($goalTotal, $currency);
$goalProgress = dw_campaigns_force_decimal($goalProgress, $currency);
if($goalRemaining < 0) {
$goalRemaining = 0;
}
$daysEnd = strtotime($campaign->field_dw_date_range[0]['value2']);
$timeNow = time();
if($timeNow>$daysEnd) {
$daysLeft = -1;
} else {
$daysLeft = ceil(($daysEnd - time()) / (3600*24));
}
//echo "Goal Progress: " . $goalProgress . "<br>";
$sql_count = "select count(*) from distance_as_$num_per_page";
$result = pager_query("select * from distance_as_$num_per_page " . tablesort_sql($headers), $num_per_page, 0, $sql_count);
$rows = array();
while ($db_row = db_fetch_object($result)) {
$our_campaign = node_load($db_row->campaign_id);
$rows[] = array(
'data' => array(
array('data' => $db_row->position, 'class' => 'position'),
array('data' => '<a href="/dw/walking/location/' . $db_row->campaign_id . '">' . $db_row->location . '</a>', 'class' => 'location'),
array('data' => floor($db_row->distance) . ' ' . $units_wd, 'class' => 'distance'),
array('data' => $db_row->walkers, 'class' => 'walkers'),
array('data' => dw_campaigns_force_decimal($db_row->amount, $campaign->field_dw_currency['0']['value'])),
)
);
}
?>
<form method="post">
<p><?php echo t('Enter a Zip code, or a City, State below'); ?></p>
<?php echo t('Searching From '); ?><input type="text" name="query" class="location-search" value="<? echo htmlentities($search_terms);?>">
<input type="submit" value="<?php echo t('Find Distance'); ?>">
</form>
<?php
echo theme('table', $headers, $rows);
echo theme('pager', NULL, $num_per_page, 0);
$goalProgress = $pcpTotal;
if($goalTotal == 0) {
return;
}
// I assume we want to round 99.9 down so that we don't say 100% too soon
$goalPercent = floor($goalProgress/$goalTotal * 100);
if($goalPercent > 100) {
$goalPercent = 100;
}
$goalRemaining = dw_campaigns_force_decimal($goalTotal - $goalProgress, $campaign->field_dw_currency['0']['value']);
$goalTotal = dw_campaigns_force_decimal($goalTotal);
$goalProgress = dw_campaigns_force_decimal($goalProgress);
if($goalRemaining < 0) {
$goalRemaining = '0.00';
}
/*
echo "Goal Progress: " . $goalProgress . "<br>";
echo "Goal Total: " . $goalTotal . "<br>";
echo "Goal Remaining: " . $goalRemaining . "<br>";
echo "Goal Percent: " . $goalPercent . "<br>";
*/
?>
<div class="left">
<span class="label"><?php echo t('Raised so far...'); ?></span>
<div class="progress-bar progress-blue"> <div class="progress-inner"><span><?php echo $goalProgress;?></span></div></div>
<ul>
<?php
if($leaders) {
$campaigns = array();
foreach($leaders as $leader)
{
if(!isset($campaigns[$leader['campaign_id']])) {
$campaigns[$leader['campaign_id']] = node_load($leader['campaign_id']);
}
$our_campaign = $campaigns[$leader['campaign_id']];
?>
<li>
<div class="left"><a style="background-image:url('<?php echo $leader['image']; ?>');" href="<?php echo $leader['url'];?>"></a></div>
<div class="right">
<a href="<?php echo $leader['url'];?>" class="dollar-label"><?php echo $leader['name'];?></a>
<a href="<?php echo $leader['url'];?>" class="dollar-amount"><?php echo dw_campaigns_force_decimal($leader['total'], $our_campaign->field_dw_currency['0']['value']);?></a>
<?php
if(arg(2)!='location') {
?>
<a href="/dw/walking/location/<?php echo $leader['campaign_id'];?>" class="location-name"><?php echo $leader['campaign_location'];?></a>
<?php
}
?>
</div>
</li>
<?php
}
} else {
echo '<li><div class="left"></div><div class="right">' . t('No Fundraisers Yet :(') . '</div></li>';
}
?>
echo t('Not Ranked Yet');
}
?>
</div>
<div class="right">
<span class="with">with</span><span class="money"><?php echo $total;?></span><span class="donations">in donations</span>
</div>
</div>
<div class="below">
<?php
if($position > 1 && $totalBehind > 0) {
?>
<?php
$mode_type = dw_campaigns_get_selected_type();
if($mode_type == 'walking') {
?>
<span class="behind"><?php echo dw_campaigns_force_decimal($totalBehind, $campaign->field_dw_currency['0']['value']); ?></span> behind <?php echo position_to_name($position - 1); ?> place<br>
<?php
} else {
?>
<span class="behind"><?php echo dw_campaigns_force_decimal($totalBehind, $campaign->field_dw_currency['0']['value']); ?></span> behind the <?php echo position_to_name($position - 1); ?> team<br>
<?php
}
?>
<a href="<?php echo $previousPosition['url']; ?>"><?php echo $previousPosition['name']; ?></a>
<?php
}
?>
</div>
</div>
db_query("insert into {leader_as_$num_per_page} (name, photo, position, amount, raw_amount, location, fundraisers, url, campaign_id) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $name, $photo, $position, $amount, $raw_amount, $location, $fundraisers, $url, $campaign->nid);
}
$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();
while ($db_row = db_fetch_object($result)) {
$our_campaign = $campaigns[$db_row->campaign_id];
$rows[] = array(
'data' => array(
array('data' => $db_row->position, 'class' => 'position'),
array('data' => '<a href="' . $db_row->url . '"> <img src="' . $db_row->photo . '" width="50"> <span class="location">' . $db_row->location . '</span></a>', 'class' => 'photo' ),
array('data' => $db_row->fundraisers, 'class' => 'fundraisers'),
array('data' => dw_campaigns_force_decimal($db_row->raw_amount, $our_campaign->field_dw_currency['0']['value']), 'class' => 'amount'),
)
);
}
echo "<h2>" . t('One Small Step Locations') . "</h2>";
echo theme('table', $headers, $rows);
echo theme('pager', NULL, $num_per_page, 0);
}
?>
$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();
while ($db_row = db_fetch_object($result)) {
$rows[] = array(
'data' => array(
array('data' => $db->position),
array('data' => '<img src="' . $db_row->photo . '" width="25"> <a href="' . $db_row->url . '">' . $db_row->name . '</a>' ),
array('data' => $db_row->location),
array('data' => $db_row->donations),
array('data' => dw_campaigns_force_decimal($db_row->amount)),
)
);
}
echo theme('dw_campaigns_derby_statistics', $campaign, TRUE);
echo theme('table', $headers, $rows);
echo theme('pager', NULL, $num_per_page, 0);
if($contact_id == $pcp->contact_id) {
?>
<td class="leader-diff">
<div class="leader-total"><?php echo $goalProgress; ?></div>
</td>
<?php
} else {
$diff = $total - $goalProgress_nofmt;
if($diff < 0) {
$diff_sentence = dw_campaigns_force_decimal(abs($diff), $campaign->field_dw_currency['0']['value']) . " behind";
} else {
$diff_sentence = dw_campaigns_force_decimal(abs($diff), $campaign->field_dw_currency['0']['value']) . " ahead";
}
?>
<td class="leader-diff">
<div class="leader-total"><?php echo dw_campaigns_force_decimal($total, $campaign->field_dw_currency['0']['value']); ?></div>
<div class="diff"><?php echo $diff_sentence; ?></div>
</td>
<?php
}
?>
</tr>
<?php
if($i==3) { break; }
}
?>
</table>
</div>
</div>
$convert_currency = TRUE;
if($type != 'walking') {
$convert_currency = FALSE;
}
while ($db_row = db_fetch_object($result)) {
$our_campaign = $campaigns[$db_row->campaign_id];
$rows[] = array(
'data' => array(
array('data' => $db_row->position, 'class' => 'position'),
array('data' => '<img src="' . $db_row->photo . '" width="25"> <a href="' . $db_row->url . '">' . $db_row->name . '</a>', 'class' => 'name' ),
array('data' => $db_row->location),
array('data' => $db_row->donations),
array('data' => dw_campaigns_force_decimal($db_row->raw_amount, $our_campaign->field_dw_currency['0']['value'], $convery_currency)),
)
);
}
$extra='';
if($type == 'walking') {
if(is_null($campaign)) {
$extra = t('(All Locations)');
} else {
$extra = '(<a href="/dw/walking/location/' . $campaign->nid . '">' . $campaign->field_dw_campaign_location[0]['value'] . '</a>)';
}
}
}
//echo theme('dw_campaigns_derby_statistics', $campaign, TRUE);
echo "<h2>" . t('Leader Board') . " $extra</h2>";
