function dk_speakup_signatures_page()
{
// check security: ensure user has authority
if (!current_user_can('publish_posts')) {
wp_die(__('Insufficient privileges: You need to be an editor to do that.', 'dk_speakup'));
}
include_once 'class.speakup.php';
include_once 'class.signature.php';
include_once 'class.petition.php';
$the_signatures = new dk_speakup_Signature();
$the_petitions = new dk_speakup_Petition();
$options = get_option('dk_speakup_options');
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
$pid = isset($_REQUEST['pid']) ? $_REQUEST['pid'] : '';
// petition id
$sid = isset($_REQUEST['sid']) ? $_REQUEST['sid'] : '';
// signature id
// set variables for paged record display and for limit values in db query
$paged = isset($_REQUEST['paged']) ? $_REQUEST['paged'] : '1';
$total_pages = isset($_REQUEST['total_pages']) ? $_REQUEST['total_pages'] : '1';
$current_page = dk_speakup_SpeakUp::current_paged($paged, $total_pages);
$query_limit = $options['signatures_rows'];
$query_start = $current_page * $query_limit - $query_limit;
switch ($action) {
case 'delete':
// security: ensure user has intention
check_admin_referer('dk_speakup-delete_signature' . $sid);
// delete signature from the database
$the_signatures->delete($sid);
// count number of signatures in database
$count = $the_signatures->count($pid);
// get all signatures for display
$signatures = $the_signatures->all($pid, $query_start, $query_limit);
// set up display strings
// set up values for the table label ie: All Signatures (36)
if ($count == 0) {
$petition = '';
} elseif ($pid != '') {
$petition = $signatures[0]->title;
} else {
$petition = __('All Signatures', 'dk_speakup');
}
$table_label = esc_html($petition) . ' <span class="count">(' . $count . ')</span>';
$base_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures&action=petition&pid=' . $pid);
$message_update = __('Signature deleted.', 'dk_speakup');
break;
case 'petition':
// count number of signatures in database
$count = $the_signatures->count($pid);
// get all signatures for display
$signatures = $the_signatures->all($pid, $query_start, $query_limit);
// TODO: Make this always show petition title (maybe use join in query)
// set up display strings
// if signatures exist, show petition title, else show petition id number
if (count($signatures) > 0) {
$table_label = esc_html($signatures[0]->title) . ' <span class="count">(' . $count . ')</span>';
} else {
$table_label = __('Petition', 'dk_speakup') . ' ' . $pid . ' <span class="count">(0)</span>';
}
$base_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures&action=petition&pid=' . $pid);
$message_update = '';
break;
case 'reconfirm':
check_admin_referer('dk_speakup-resend_confirmations' . $pid);
include_once 'class.mail.php';
$petition_to_confirm = new dk_speakup_Petition();
// get unconfirmed signatures
$unconfirmed = $the_signatures->unconfirmed($pid);
foreach ($unconfirmed as $signature) {
$unconfirmed_signature = new dk_speakup_signature();
$unconfirmed_signature->first_name = $signature->first_name;
$unconfirmed_signature->last_name = $signature->last_name;
$unconfirmed_signature->email = $signature->email;
$unconfirmed_signature->confirmation_code = $signature->confirmation_code;
dk_speakup_Mail::send_confirmation($petition_to_confirm, $unconfirmed_signature, $options);
// destroy temporary object so we can re-use the variable
unset($unconfirmed_signature);
}
// count number of signatures in database
$count = $the_signatures->count($pid);
// get all signatures for display
$signatures = $the_signatures->all($pid, $query_start, $query_limit);
// set up display strings
if (count($signatures) > 0) {
$table_label = esc_html($signatures[0]->title) . ' <span class="count">(' . $count . ')</span>';
} else {
$table_label = __('Petition', 'dk_speakup') . ' ' . $pid . ' <span class="count">(0)</span>';
}
$base_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures&action=petition&pid=' . $pid);
$message_update = __('Confirmation emails sent.', 'dk_speakup');
break;
default:
// count number of signatures in database
$count = $the_signatures->count($pid);
// get all signatures for display
$signatures = $the_signatures->all($pid, $query_start, $query_limit);
// set up display strings
$table_label = __('All Signatures', 'dk_speakup') . ' <span class="count">(' . $count . ')</span>';
$base_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures');
$message_update = '';
}
// get list of petitions to populate select box navigation
$petitions_list = $the_petitions->quicklist();
// Set up URLs for 'Download as CSV' and 'Resend confirmations' buttons
// Show buttons only when we are viewing signatures from a single petition
if (count($petitions_list) == 1 || $pid != '') {
// if $pid (petition id) wasn't sent through the URL, then create it from the query
if ($pid == '') {
$pid = $petitions_list[0]->id;
}
$csv_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures&action=petition&pid=' . $pid);
$reconfirm_url = site_url('wp-admin/admin.php?page=dk_speakup_signatures&action=reconfirm&pid=' . $pid);
}
// display the Signatures table
include_once dirname(__FILE__) . '/signatures.view.php';
}
function dk_speakup_signatures_csv()
{
// check security: ensure user has authority and intention
if (!current_user_can('publish_posts')) {
wp_die(__('Insufficient privileges: You need to be an editor to do that.', 'dk_speakup'));
}
check_admin_referer('dk_speakup-download_signatures');
include_once 'class.signature.php';
$signatures = new dk_speakup_Signature();
$petition_id = isset($_REQUEST['pid']) ? $_REQUEST['pid'] : '';
// petition id
// retrieve signatures from the database
$csv_data = $signatures->all($petition_id, 0, 0, 'csv');
// display error message if query returns no results
if (count($csv_data) < 1) {
echo '<h1>' . __("No signatures found.", "dk_speakup") . '</h1>';
die;
}
// construct CSV filename
$counter = 0;
foreach ($csv_data as $file) {
if ($counter < 1) {
$filename_title = stripslashes(str_replace(' ', '-', $file->title));
$filename_date = date('Y-m-d', strtotime(current_time('mysql', 0)));
$filename = $filename_title . '_' . $filename_date . '.csv';
}
$counter++;
}
// set up CSV file headers
header('Content-Type: text/octet-stream; charset=UTF-8');
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Pragma: public');
// supposed to make stuff work over https
// get the column headers translated
$firstname = __('First Name', 'dk_speakup');
$lastname = __('Last Name', 'dk_speakup');
$email = __('Email Address', 'dk_speakup');
$street = __('Street Address', 'dk_speakup');
$city = __('City', 'dk_speakup');
$state = __('State', 'dk_speakup');
$postcode = __('Post Code', 'dk_speakup');
$country = __('Country', 'dk_speakup');
$date = __('Date Signed', 'dk_speakup');
$confirmed = __('Confirmed', 'dk_speakup');
$petition_title = __('Petition Title', 'dk_speakup');
$petitions_id = __('Petition ID', 'dk_speakup');
$email_optin = __('Email Opt-in', 'dk_speakup');
$custom_message = __('Custom Message', 'dk_speakup');
$language = __('Language', 'dk_speakup');
// If set, use the custom field label as column header instead of "Custom Field"
$counter = 0;
foreach ($csv_data as $label) {
if ($counter < 1) {
if ($label->custom_field_label != '') {
$custom_field_label = stripslashes($label->custom_field_label);
} else {
$custom_field_label = __('Custom Field', 'dk_speakup');
}
}
$counter++;
}
// construct CSV file header row
// must use double quotes and separate with tabs
$csv = "{$firstname};{$lastname};{$email};{$street};{$city};{$state};{$postcode};{$country};{$custom_field_label};{$date};{$confirmed};{$petition_title};{$petitions_id};{$email_optin};{$custom_message};{$language}";
$csv .= "\n";
// construct CSV file data rows
foreach ($csv_data as $signature) {
// convert the 1, 0, or '' values of confirmed to readable format
$confirm = $signature->is_confirmed;
if ($confirm == 1) {
$confirm = __('confirmed', 'dk_speakup');
} elseif ($confirm == 0) {
$confirm = __('unconfirmed', 'dk_speakup');
} else {
$confirm = '...';
}
// convert the 1, 0, or '' values of optin to readable format
$optin = $signature->optin;
if ($optin == 1) {
$optin = __('yes', 'dk_speakup');
} elseif ($optin == 0) {
$optin = __('no', 'dk_speakup');
} else {
$optin = '...';
}
$csv .= stripslashes($signature->first_name . ';' . $signature->last_name . ';' . $signature->email . ';' . $signature->street_address . ';' . $signature->city . ';' . $signature->state . ';' . $signature->postcode . ';' . $signature->country . ';' . $signature->custom_field . ';' . $signature->date . ';' . $confirm . ';' . $signature->title . ';' . $signature->petitions_id . ';' . $optin . ';' . $signature->custom_message . ';' . $signature->language . '"');
$csv .= "\n";
}
// output CSV file in a UTF-8 format that Excel can understand
echo chr(255) . chr(254) . mb_convert_encoding($csv, 'UTF-16LE', 'UTF-8');
exit;
}
