<td><?php
echo $i['action']['Reference_Name'];
?>
</td>
<td><?php
echo $i['campaign'];
?>
</td>
<td><?php
echo $i['referrer'];
?>
</td>
<td><?php
if ($i['referrer_supporter_KEY']) {
echo get_supporter_name($i['referrer_supporter_KEY']);
}
?>
</td>
<td><?php
echo $i['Date_Created'];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
function action_detail($key)
{
global $db;
$sql = 'select * from action where action_KEY =' . $key;
$A = $db->CacheExecute($sql) or die($db->errorMsg());
$a = $A->FetchRow();
echo '<h2>' . $a['Reference_Name'] . '</h2>';
echo '<div class="row">';
echo '<div class="span3">';
echo 'Unique Actions Taken: ' . action_count_distinct($key) . '<br>';
echo 'Actions Taken: ' . action_count($key) . '<br>';
echo '</div>';
echo '<div class="span3">';
$options['slug'] = $a['campaign_slug'];
echo 'New Supporters: ' . action_new_supporters($key) . '<br>';
echo 'New Supporters Deliverable: ' . action_new_supporters_deliverable($key) . '<br>';
echo 'Supporter Referrals: ' . action_referrer_supporter($key, $options) . '<br>';
echo '</div>';
echo '<div class="span3">';
echo 'Actions This Week: ' . action_count($key) . '<br>';
echo 'New This Week: ' . action_new_supporters_date($key, LAST_WEEK) . '<br>';
echo 'New Deliverable This Week: ' . action_new_supporters_deliverable_date($key, LAST_WEEK) . '<br>';
echo '</div>';
echo '</div>';
$emails = action_emails($key);
$emails_count = action_emails_count($key);
$ref = action_referrer($key);
$partners = action_partners($key);
if ($emails) {
$email_blast_options = array('where' => ' and e.email_blast_KEY in (' . $emails . ') ');
include '../partials/_email_blast_list.php';
}
echo '<h3>Action Sources</h3><div class="row">';
echo '<div class="span4">';
echo '<h4>Codes</h4>';
echo '<table class="table">';
if ($ref) {
foreach ($ref as $i) {
echo '<tr>';
echo '<td>' . $i['referrer'] . '</td>';
echo '<td>' . $i['count'] . '</td>';
echo '</tr>';
}
}
echo '</table>';
echo '</div>';
echo '<div class="span4">';
echo '<h4>Emails</h4>';
echo '<table class="table">';
if ($emails_count) {
foreach ($emails_count as $i) {
echo '<tr>';
echo '<td><a href="../object.php?object=email_blast&key=' . $i['email_blast_KEY'] . '">' . get_email_blasts_name($i['email_blast_KEY']) . '</a></td>';
echo '<td>' . $i['count'] . '</td>';
echo '</tr>';
}
}
echo '</table>';
echo '</div>';
if ($partners) {
echo '<div class="span4">';
echo '<h4>Partners</h4><br>';
echo '<table class="table">';
foreach ($partners as $i) {
if ($i['partner_code']) {
echo '<tr>';
echo '<td>' . $i['partner_code'] . '</td>';
echo '<td>' . $i['count'] . '</td>';
echo '</tr>';
}
}
echo '</table>';
echo '</div>';
}
echo '</div>';
$tell_a_friend_options['where'] = ' where action_KEY = "' . $key . '" ';
include '../partials/_tell_a_friend_list.php';
$sql = 'select supporter_KEY, count(supporter_KEY) as count from supporter_action where referrer_supporter_KEY >0 and supporter_KEY != referrer_supporter_KEY and action_KEY = ' . $key . ' group by supporter_KEY order by count desc';
$Rec = $db->CacheExecute($sql) or die($db->errorMsg());
$rec = $Rec->GetArray();
echo '<h3>Recuritment</h3>';
foreach ($rec as $i) {
echo $i['count'] . ' <a href="/supporter.php?supporter_KEY=' . $i['supporter_KEY'] . '">' . get_supporter_name($i['supporter_KEY']) . '</a> ' . '<br>';
}
echo '<h3>Action Links</h3>';
action_links($a['campaign_slug']);
$sql = "select count(distinct supporter_KEY) as count from supporter_action where personal_petition=1 and action_KEY =" . $key;
$Per = $db->CacheExecute($sql) or die($db->errorMsg() . $sql);
$per = $Per->FetchRow();
$sql = "select count(distinct personal_petition_supporter_KEY) as count from supporter_action where personal_petition_supporter_KEY >0 and action_KEY =" . $key;
$Per_Ct = $db->CacheExecute($sql) or die($db->errorMsg() . $sql);
$per_ct = $Per_Ct->FetchRow();
if ($per['count'] > 0) {
echo '<h3>Personal Petitions</h3>';
echo '<strong>Petitions Started:</strong>: ' . $per['count'];
echo '<strong>Petitions Signatures Generated:</strong>: ' . $per_ct['count'];
$sql = "select distinct supporter_KEY from supporter_action where personal_petition=1 and action_KEY =" . $key;
$Pet = $db->CacheExecute($sql) or die($db->errorMsg() . $sql);
$pet = $Pet->FetchRow();
foreach ($pet as $i) {
#echo '<td><a href="'.ACTION_URL.$a['campaign_slug'].'/">'.$i['supporter_KEY'].'</a></td>';
}
}
}