/** * Displays the Email Petitions table page */ function dk_speakup_petitions_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.'); } include_once 'class.speakup.php'; include_once 'class.petition.php'; include_once 'class.wpml.php'; $the_petitions = new dk_speakup_Petition(); $wpml = new dk_speakup_WPML(); $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : ''; $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : ''; $options = get_option('dk_speakup_options'); // set variables for paged record display and limit values in db query // request values may be submitted either by html links (pagination.php) or by javascript (admin.js) $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['petitions_rows']; $query_start = $current_page * $query_limit - $query_limit; // link URL for "Add New" button in header $addnew_url = esc_url(site_url() . '/wp-admin/admin.php?page=dk_speakup_addnew'); switch ($action) { case 'delete': // security: ensure user has intention check_admin_referer('dk_speakup-delete_petition' . $id); // delete the petition and its signatures $the_petitions->delete($id); $wpml->unregister_petition($id); // get petitions $petitions = $the_petitions->all($query_start, $query_limit); // set up page display variables $page_title = __('Email Petitions', 'dk_speakup'); $count = $the_petitions->count(); $message_update = __('Petition deleted.', 'dk_speakup'); break; default: // get petitions $petitions = $the_petitions->all($query_start, $query_limit); // set up page display variables $page_title = __('Email Petitions', 'dk_speakup'); $count = $the_petitions->count(); $message_update = ''; } // display the Petitions table include_once 'petitions.view.php'; }
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'; }