/**
* generates HTML table of signatures for a single petition
*
* @param int $id the ID petition for which we are displaying signatures
* @param int $start the first signature to be retrieved
* @param int $limit number of signatures to be retrieved
* @param string $context either 'shortcode' or 'ajax' to distinguish between calls from the initia page load (shortcode) and calls from pagination buttons (ajax)
* @param string $dateformat PHP date format provided by shortcode attribute - also relayed in ajax requests
* @param string $nextbuttontext provided by shortcode attribute
* @param string $prevtbuttontext provided by shortcode attribute
*
* @return string HTML table containing signatures (or just the table rows if context is ajax)
*/
public static function table($id, $start, $limit, $context = 'shortcode', $dateformat = 'M d, Y', $nextbuttontext = '>', $prevbuttontext = '<')
{
include_once 'class.signature.php';
$the_signatures = new dk_speakout_Signature();
$options = get_option('dk_speakout_options');
// get list of columns to display - as defined in settings
$columns = unserialize($options['signaturelist_columns']);
// get the signatures
$signatures = $the_signatures->all($id, $start, $limit, 'signaturelist');
$total = $the_signatures->count($id, 'signaturelist');
$current_signature_number = $total - $start;
$signatures_list = '';
// only show signature lists if there are signatures
if ($total > 0) {
// determine which columns to display
$display_city = in_array('sig_city', $columns) ? 1 : 0;
$display_state = in_array('sig_state', $columns) ? 1 : 0;
$display_postcode = in_array('sig_postcode', $columns) ? 1 : 0;
$display_country = in_array('sig_country', $columns) ? 1 : 0;
$display_custom = in_array('sig_custom', $columns) ? 1 : 0;
$display_date = in_array('sig_date', $columns) ? 1 : 0;
if ($context !== 'ajax') {
// only include on initial page load (not when paging)
$signatures_list = '
<!-- signaturelist -->
<table class="dk-speakout-signaturelist dk-speakout-signaturelist-' . $id . '">
<caption>' . $options['signaturelist_header'] . '</caption>';
}
$row_count = 0;
foreach ($signatures as $signature) {
if ($row_count % 2) {
$signatures_list .= '<tr class="dk-speakout-even">';
} else {
$signatures_list .= '<tr class="dk-speakout-odd">';
}
$signatures_list .= '<td class="dk-speakout-signaturelist-count">' . number_format($current_signature_number, 0, '.', ',') . '</td>';
$display_lastname = $signature->last_name;
// if we have enabled privacy, only show forst letter of surname
if ($options['signaturelist_privacy'] == 'enabled') {
$display_lastname = substr($signature->last_name, 0, 1) . ".";
}
$signatures_list .= '<td class="dk-speakout-signaturelist-name">' . stripslashes($signature->first_name . ' ' . $display_lastname) . '</td>';
// if we display both city and state, combine them into one column
$city = $display_city ? $signature->city : '';
$state = $display_state ? $signature->state : '';
if ($display_city && $display_state) {
// should we separate with a comma?
$delimiter = $city != '' && $state != '' ? ', ' : '';
$signatures_list .= '<td class="dk-speakout-signaturelist-city">' . stripslashes($city . $delimiter . $state) . '</td>';
} else {
if ($display_city) {
$signatures_list .= '<td class="dk-speakout-signaturelist-city">' . stripslashes($city) . '</td>';
}
if ($display_state) {
$signatures_list .= '<td class="dk-speakout-signaturelist-state">' . stripslashes($state) . '</td>';
}
}
if ($display_postcode) {
$signatures_list .= '<td class="dk-speakout-signaturelist-postcode">' . stripslashes($signature->postcode) . '</td>';
}
if ($display_country) {
$signatures_list .= '<td class="dk-speakout-signaturelist-country">' . stripslashes($signature->country) . '</td>';
}
if ($display_custom) {
$signatures_list .= '<td class="dk-speakout-signaturelist-custom">' . stripslashes($signature->custom_field) . '</td>';
}
if ($display_date) {
$signatures_list .= '<td class="dk-speakout-signaturelist-date">' . date_i18n($dateformat, strtotime($signature->date)) . '</td>';
}
$signatures_list .= '</tr>';
$current_signature_number--;
$row_count++;
}
if ($context !== 'ajax') {
// only include on initial page load
if ($limit != 0 && $start + $limit < $total) {
$colspan = count($columns) + 2;
$signatures_list .= '
<tr class="dk-speakout-signaturelist-pagelinks">
<td colspan="' . $colspan . '">
<a class="dk-speakout-signaturelist-prev dk-speakout-signaturelist-disabled" rel="' . $id . ',' . $total . ',' . $limit . ',' . $total . ',0">' . $prevbuttontext . '</a>
<a class="dk-speakout-signaturelist-next" rel="' . $id . ',' . ($start + $limit) . ',' . $limit . ',' . $total . ',1">' . $nextbuttontext . '</a>
</td>
</tr>
';
}
$signatures_list .= '</table>';
}
}
return $signatures_list;
}
