plugin_name = $plugin_name;
$this->title_length = Survey_Maker_Data::get_listtables_title_length('submissions');
parent::__construct( array(
'singular' => __( 'Submissions', "survey-maker" ), //singular name of the listed records
'plural' => __( 'Submissions', "survey-maker" ), //plural name of the listed records
'ajax' => false //does this table support ajax?
) );
add_action( 'admin_notices', array( $this, 'submissions_notices' ) );
}
/**
* Override of table nav to avoid breaking with bulk actions & according nonce field
*/
public function display_tablenav( $which ) {
?>
bulk_actions( $which ); ?>
extra_tablenav( $which );
$this->pagination( $which );
?>
prefix . SURVEY_MAKER_DB_PREFIX . "survey_categories AS s
WHERE s.status = 'published'";
$cat_titles = $wpdb->get_results($titles_sql);
$cat_id = null;
if( isset( $_GET['filterby'] )){
$cat_id = absint( sanitize_text_field( $_GET['filterby'] ) );
}
$categories_select = array();
foreach($cat_titles as $key => $cat_title){
$selected = "";
if($cat_id === intval($cat_title->id)){
$selected = "selected";
}
$categories_select[$cat_title->id]['title'] = $cat_title->title;
$categories_select[$cat_title->id]['selected'] = $selected;
$categories_select[$cat_title->id]['id'] = $cat_title->id;
}
sort($categories_select);
?>
".esc_attr($cat_title['title'])." ";
}
?>
%s %s ', $this->plugin_name."-each-submission", absint( $item['id'] ), $q, $restitle );
}
// $title = sprintf( '%s %s ', $this->plugin_name."-each-submission", absint( $item['id'] ), __('View details', "survey-maker")),
'delete' => sprintf( 'Delete ', $restitle."'s submissions", sanitize_text_field( $_REQUEST['page'] ), 'delete', absint( $item['id'] ), $delete_nonce, __( 'Delete all submissions of this survey', "survey-maker" ) )
);
return $title . $this->row_actions( $actions );
}
function column_quiz_rate( $item ) {
global $wpdb;
$sql = "SELECT AVG(`score`) AS avg_score FROM {$wpdb->prefix}aysquiz_rates WHERE quiz_id=". absint( $item['id'] );
$result = $wpdb->get_var($sql);
if($result == null){
return;
}
$res = round($result,1);
return $res;
}
function column_score($item){
global $wpdb;
$sql = "SELECT AVG(`score`) AS avg_score FROM {$wpdb->prefix}aysquiz_reports WHERE quiz_id=". absint( $item['id'] );
$result = $wpdb->get_var($sql);
if($result == null){
return;
}
$res = round($result,2)."%";
return $res;
}
function column_user_count($item) {
global $wpdb;
$sql = "SELECT COUNT(*)
FROM ".$wpdb->prefix . SURVEY_MAKER_DB_PREFIX . "submissions" . "
WHERE survey_id=". absint( $item['id'] );
$result = $wpdb->get_var($sql);
return $result;
}
function column_unreads($item) {
global $wpdb;
$sql = "SELECT COUNT(*)
FROM ".$wpdb->prefix . SURVEY_MAKER_DB_PREFIX . "submissions " . "
WHERE ( `read` = 0 OR `read` = 2 ) AND survey_id=". absint( $item['id'] );
$q = intval( $wpdb->get_var( $sql ) );
if($q != 0){
$q = "$q
%s ', 'survey-maker-survey-categories', 'edit', $value['id'], $value['title']);
}
$titles = implode( ', ', $category_location );
return $titles;
}
return '-';
}
/**
* Associative array of columns
*
* @return array
*/
function get_columns() {
$columns = array(
'cb' => '