}
}
if (in_array(trim($_GET['donation_status']), array("Expected", "Pledged", "Received"))) {
$where_clauses[] = "donation_status = '" . strtolower(trim($_GET['donation_status'])) . "'";
}
}
$where = count($where_clauses) > 0 ? " AND " . implode(" AND ", $where_clauses) : "";
$query_donations = "SELECT \r\n donation_id, \r\n donation_value, \r\n donation_status, \r\n donation_is_cash, \r\n donation_pledge_date, \r\n donation_received_date,\r\n donation_description,\r\n contacts.*,\r\n contact_company IS NULL AS isnull\r\n FROM donations \r\n LEFT JOIN contacts USING (`contact_id`) \r\n WHERE campaign_id = " . $campaign['campaign_id'] . $where . " ORDER BY isnull, contact_company, contact_first, contact_last";
$donations = mysql_query($query_donations, $contacts) or die(mysql_error());
$row_donations = mysql_fetch_assoc($donations);
$totalRows_donations = mysql_num_rows($donations);
$query_targets = "SELECT\r\n contact_id,\r\n contact_first,\r\n contact_last,\r\n contact_title,\r\n contact_company\r\n FROM targets\r\n LEFT JOIN contacts using (contact_id)\r\n WHERE campaign_id = " . $campaign['campaign_id'] . " AND\r\n (SELECT COUNT(*) \r\n FROM donations \r\n WHERE campaign_id = " . $campaign['campaign_id'] . " AND \r\n donations.contact_id = targets.contact_id\r\n ) = 0";
$targets = mysql_query($query_targets, $contacts) or die(mysql_error());
$row_targets = mysql_fetch_assoc($targets);
$totalRows_targets = mysql_num_rows($targets);
$stats = donation_stats($campaign['campaign_id'], $where);
$title_text = "Campaign - " . $campaign['campaign_name'];
$back_track = array('title' => "Campaigns", 'url' => "campaigns.php");
$display = isset($_GET['display']) ? $_GET['display'] : "html";
if (!in_array($display, array("csv", "html"))) {
$display = "html";
}
switch ($display) {
case "csv":
$out = fopen('php://output', 'w');
header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="donations.csv"');
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Date in the past
die;
}
$cwhere = "WHERE history_status = 1";
mysql_select_db($database_contacts, $contacts);
$query_notes = "SELECT * FROM notes INNER JOIN contacts ON note_contact = contact_id ORDER BY note_date DESC LIMIT 0, 20";
$notes = mysql_query($query_notes, $contacts) or die(mysql_error());
$row_notes = mysql_fetch_assoc($notes);
$totalRows_notes = mysql_num_rows($notes);
mysql_select_db($database_contacts, $contacts);
$query_contacts = "SELECT * FROM history INNER JOIN contacts ON contact_id = history_contact {$cwhere} ORDER BY history_date DESC LIMIT 0, 20";
$contacts = mysql_query($query_contacts, $contacts) or die(mysql_error());
$row_contacts = mysql_fetch_assoc($contacts);
$totalRows_contacts = mysql_num_rows($contacts);
$default_campaign = get_default_campaign();
if ($default_campaign) {
$stats = donation_stats($default_campaign['campaign_id']);
}
if ($totalRows_contacts < 1 && !isset($_GET['s'])) {
header('Location: contact.php');
}
include 'includes/header.php';
?>
<div class="container">
<div class="leftcolumn">
<?php
if ($totalRows_contacts > 0) {
?>
<h2>Contacts</h2>
<?php
$i = 1;
