'id', 'type' => 'type', 'default' => 'id' ); $orderby = isset($_GET['orderby']) && isset($columns[$_GET['orderby']]) ? $columns[$_GET['orderby']] : $columns['default']; $order = isset($_GET['order']) && $_GET['order'] == 'desc' ? 'DESC' : 'ASC'; global $wpdb; if ( isset( $_GET['delete'] ) ) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}bwsurvey_notifications WHERE id = %d;", $_GET['delete'])); } $per_page = 25; if (isset($_GET['survey'])) { $item_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM {$wpdb->prefix}bwsurvey_notifications WHERE survey_id = %d;", $_GET['survey'])); $page_count = ceil($item_count / $per_page); $paged = isset($_GET['paged']) ? min($page_count, max(1, $paged)) : 1; $survey_title = $wpdb->get_var($wpdb->prepare("SELECT title FROM {$wpdb->prefix}bwsurvey_surveys WHERE id = %d;", $_GET['survey'])); $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}bwsurvey_notifications WHERE survey_id = %d ORDER BY {$orderby} {$order} LIMIT %d OFFSET %d", $_GET['survey'], $per_page, $per_page * ($paged - 1) )); } else { $item_count = $wpdb->get_var("SELECT COUNT(id) FROM {$wpdb->prefix}bwsurvey_notifications;"); $page_count = ceil($item_count / $per_page); $paged = isset($_GET['paged']) ? min($page_count, max(1, $paged)) : 1; $results = $wpdb->get_results($wpdb->prepare("SELECT notification.*, survey.title as survey FROM {$wpdb->prefix}bwsurvey_notifications as notification INNER JOIN {$wpdb->prefix}bwsurvey_surveys as survey ON notification.survey_id = survey.id ORDER BY {$orderby} {$order} LIMIT %d OFFSET %d", $per_page, $per_page * ($paged - 1) )); } ?>

Notifications

Create Notification
1): ?> of

Survey Pages list

survey)) $survey_title = $result->survey; $data = unserialize($result->data); $length = empty($data) ? 0 : count($data); ?>
Name Type Survey To
Edit | Delete
type; ?> $to"; ?>
Name Type Survey To
1): ?> of