bulk_actions( $which ); ?>
extra_tablenav( $which );
$this->pagination( $which );
?>
ays_category_filter_content();
}
public function get_report_by_id( $id ) {
global $wpdb;
$report_id = absint(sanitize_text_field($id));
$report_table = esc_sql($wpdb->prefix."ayspoll_reports");
$sql = "SELECT * FROM ".$report_table." WHERE id=%d";
$result = $wpdb->get_row(
$wpdb->prepare( $sql, $report_id),
'ARRAY_A'
);
return $result;
}
public static function get_answer_by_id( $id ) {
global $wpdb;
$answ_id = absint(sanitize_text_field($id));
$answ_table = esc_sql($wpdb->prefix."ayspoll_answers");
$sql = "SELECT * FROM ".$answ_table." WHERE id=%d";
$result = $wpdb->get_row(
$wpdb->prepare( $sql, $answ_id),
'ARRAY_A'
);
return $result;
}
public function get_polls() {
global $wpdb;
$poll_table = esc_sql($wpdb->prefix."ayspoll_polls");
$sql = "SELECT * FROM ".$poll_table;
$result = $wpdb->get_results($sql, 'ARRAY_A');
return $result;
}
/**
* Delete a customer record.
*
* @param int $id customer ID
*/
public static function delete_reports( $id ) {
global $wpdb;
$wpdb->update(
"{$wpdb->prefix}ayspoll_answers",
array(
"votes" => 0
),
array(
'poll_id' => $id
)
);
if (isset($_SERVER['HTTP_HOST']) && sanitize_text_field($_SERVER['HTTP_HOST']) == "playground.wordpress.net") {
$sql = "DELETE FROM {$wpdb->prefix}ayspoll_reports
WHERE answer_id IN (
SELECT id FROM {$wpdb->prefix}ayspoll_answers
WHERE poll_id = $id
)";
} else {
$sql = "DELETE r FROM {$wpdb->prefix}ayspoll_reports as r
JOIN {$wpdb->prefix}ayspoll_answers ON {$wpdb->prefix}ayspoll_answers.id = r.answer_id
WHERE {$wpdb->prefix}ayspoll_answers.poll_id = $id";
}
$res = $wpdb->query($sql);
return $res > 0;
}
/**
* Returns the count of records in the database.
*
* @return null|string
*/
public static function record_count() {
global $wpdb;
$sql = "SELECT COUNT(*) FROM {$wpdb->prefix}ayspoll_polls";
return $wpdb->get_var($sql);
}
/** Text displayed when no customer data is available */
public function no_items() {
_e('There are no results yet.', "poll-maker");
}
/**
* Render a column when no column specific method exist.
*
* @param array $item
* @param string $column_name
*
* @return mixed
*/
public function column_default( $item, $column_name ) {
switch ( $column_name ) {
case 'poll_title':
case 'voted':
case 'unread':
case 'id':
return $item[$column_name];
break;
default:
return print_r($item, true); //Show the whole array for troubleshooting purposes
}
}
/**
* Render the bulk edit checkbox
*
* @param array $item
*
* @return string
*/
function column_cb( $item ) {
return sprintf(
'