コード例 #1
0
 /**
  * Returns single instance of the class
  *
  * @return \YWRR_Blocklist
  * @since 1.0.0
  */
 public static function get_instance()
 {
     if (is_null(self::$instance)) {
         self::$instance = new self($_REQUEST);
     }
     return self::$instance;
 }
コード例 #2
0
    /**
     * Outputs the blocklist template with insert form in plugin options panel
     *
     * @since   1.0.0
     * @return  void
     * @author  Alberto Ruggiero
     */
    public static function output()
    {
        global $wpdb;
        $table = new YITH_Custom_Table(array('singular' => __('customer', 'ywrr'), 'plural' => __('customers', 'ywrr')));
        $table->options = array('select_table' => $wpdb->prefix . 'ywrr_email_blocklist a LEFT JOIN ' . $wpdb->prefix . 'usermeta b ON a.customer_id = b.user_id', 'select_columns' => array('a.id', 'a.customer_id', 'a.customer_email', 'MAX(CASE WHEN b.meta_key = "first_name" THEN b.meta_value ELSE NULL END) AS first_name', 'MAX(CASE WHEN b.meta_key = "last_name" THEN b.meta_value ELSE NULL END) AS last_name', 'MAX(CASE WHEN b.meta_key = "nickname" THEN b.meta_value ELSE NULL END) AS nickname'), 'select_where' => '', 'select_group' => 'a.customer_email', 'select_order' => 'a.customer_id', 'select_order_dir' => 'ASC', 'per_page_option' => 'user_per_page', 'count_table' => $wpdb->prefix . 'ywrr_email_blocklist', 'count_where' => '', 'key_column' => 'id', 'view_columns' => array('cb' => '<input type="checkbox" />', 'name' => __('Customer', 'ywrr'), 'customer_email' => __('E-Mail', 'ywrr')), 'hidden_columns' => array(), 'sortable_columns' => array('name' => array('name', true), 'customer_email' => array('customer_email', false)), 'custom_columns' => array('column_name' => function ($item, $me) {
            switch ($item['customer_id']) {
                case 0:
                    $customer_name = __('Unregistered User', 'ywrr');
                    break;
                default:
                    $query_args = array('user_id' => $item['customer_id']);
                    $edit_url = esc_url(add_query_arg($query_args, admin_url('user-edit.php')));
                    $customer_name = '<a href="' . $edit_url . '">' . ($item['first_name'] . ' ' . $item['last_name'] == ' ' ? $item['nickname'] : $item['first_name'] . ' ' . $item['last_name']) . '</a>';
            }
            $query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab'], 'action' => 'delete', 'id' => $item['id']);
            $delete_url = esc_url(add_query_arg($query_args, admin_url('admin.php')));
            $actions = array('delete' => '<a href="' . $delete_url . '">' . __('Delete', 'ywrr') . '</a>');
            return sprintf('%s %s', '<strong>' . $customer_name . '</strong>', $me->row_actions($actions));
        }), 'bulk_actions' => array('actions' => array('delete' => __('Delete', 'ywrr')), 'functions' => array('function_delete' => function () {
            global $wpdb;
            $ids = isset($_GET['id']) ? $_GET['id'] : array();
            if (is_array($ids)) {
                $ids = implode(',', $ids);
            }
            if (!empty($ids)) {
                $wpdb->query("DELETE FROM {$wpdb->prefix}ywrr_email_blocklist WHERE id IN ( {$ids} )");
            }
        })));
        $table->prepare_items();
        $message = '';
        $notice = '';
        $query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab']);
        $blocklist_url = esc_url(add_query_arg($query_args, admin_url('admin.php')));
        if ('delete' === $table->current_action()) {
            $message = sprintf(__('Items deleted: %d', 'ywrr'), count($_GET['id']));
        }
        if (!empty($_POST['nonce']) && wp_verify_nonce($_POST['nonce'], basename(__FILE__))) {
            $user = get_user_by('email', $_POST['email']);
            $customer_id = $user == null ? 0 : $user->ID;
            $customer_email = $_POST['email'];
            if (true == YWRR_Blocklist::check_blocklist($customer_id, $customer_email)) {
                try {
                    YWRR_Blocklist::add_to_blocklist($customer_id, $customer_email);
                    $message = sprintf(__('User %s added successfully', 'ywrr'), '<b>' . $customer_email . '</b>');
                } catch (Exception $e) {
                    $notice = __('An error has occurred', 'ywrr');
                }
            } else {
                $notice = sprintf(__('User %s already unsubscribed', 'ywrr'), '<b>' . $customer_email . '</b>');
            }
        }
        ?>
        <div class="wrap">
            <h2>
                <?php 
        _e('Blocklist', 'ywrr');
        if (empty($_GET['action']) || 'addnew' !== $_GET['action']) {
            ?>
                    <?php 
            $query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab'], 'action' => 'addnew');
            $add_form_url = esc_url(add_query_arg($query_args, admin_url('admin.php')));
            ?>
                    <a class="add-new-h2" href="<?php 
            echo $add_form_url;
            ?>
"><?php 
            _e('Add New', 'ywrr');
            ?>
</a>
                <?php 
        }
        ?>
            </h2>
        <?php 
        if (!empty($notice)) {
            ?>
            <div id="notice" class="error below-h2"><p><?php 
            echo $notice;
            ?>
</p></div>
        <?php 
        }
        if (!empty($message)) {
            ?>
            <div id="message" class="updated below-h2"><p><?php 
            echo $message;
            ?>
</p></div>
        <?php 
        }
        if (!empty($_GET['action']) && 'addnew' == $_GET['action']) {
            ?>
            <form id="form" method="POST">
                <input type="hidden" name="nonce" value="<?php 
            echo wp_create_nonce(basename(__FILE__));
            ?>
"/>
                <table class="form-table" style="width: auto">
                    <tbody>
                    <tr valign="top" class="titledesc">
                        <th scope="row">
                            <label for="email"><?php 
            _e('Add E-Mail to blocklist', 'ywrr');
            ?>
</label>
                        </th>
                        <td class="forminp forminp-email">
                            <input id="email" name="email" type="email" required>
                        </td>
                        <td>
                            <input type="submit" value="<?php 
            _e('Add E-mail', 'ywrr');
            ?>
" id="submit" class="button-primary" name="submit">
                            <a class="button-secondary" href="<?php 
            echo $blocklist_url;
            ?>
"><?php 
            _e('Return to blocklist', 'ywrr');
            ?>
</a>
                        </td>
                    </tr>
                    </tbody>
                </table>
            </form>
        <?php 
        } else {
            ?>
            <form id="custom-table" method="GET" action="<?php 
            echo $blocklist_url;
            ?>
">
                <input type="hidden" name="page" value="<?php 
            echo $_GET['page'];
            ?>
"/>
                <input type="hidden" name="tab" value="<?php 
            echo $_GET['tab'];
            ?>
"/>

                <?php 
            $table->display();
            ?>
            </form>
        <?php 
        }
        ?>
        </div>
        <?php 
    }