/**
* 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
}
/**
* Outputs the exclusions table template with insert form in plugin options panel
*
* @since 1.0.0
* @author Alberto Ruggiero
* @return string
*/
public static function output()
{
global $wpdb;
$table = new YITH_Custom_Table(array('singular' => __('product', 'ywctm'), 'plural' => __('products', 'ywctm')));
$table->options = array('select_table' => $wpdb->prefix . 'posts a INNER JOIN ' . $wpdb->prefix . 'postmeta b ON a.ID = b.post_id', 'select_columns' => array('a.ID', 'a.post_title', 'MAX(CASE WHEN b.meta_key = "_ywctm_exclude_catalog_mode" THEN b.meta_value ELSE NULL END) AS add_to_cart', 'MAX(CASE WHEN b.meta_key = "_ywctm_exclude_hide_price" THEN b.meta_value ELSE NULL END) AS price'), 'select_where' => 'a.post_type = "product" AND ( b.meta_key = "_ywctm_exclude_catalog_mode" OR b.meta_key = "_ywctm_exclude_hide_price" ) AND b.meta_value = "yes"', 'select_group' => 'a.ID', 'select_order' => 'a.post_title', 'select_order_dir' => 'ASC', 'per_page_option' => 'items_per_page', 'count_table' => '( SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts a INNER JOIN ' . $wpdb->prefix . 'postmeta b ON a.ID = b.post_id WHERE a.post_type = "product" AND (b.meta_key = "_ywctm_exclude_catalog_mode" OR b.meta_key = "_ywctm_exclude_hide_price") AND b.meta_value="yes" GROUP BY a.ID ) AS count_table', 'count_where' => '', 'key_column' => 'ID', 'view_columns' => array('cb' => '<input type="checkbox" />', 'product' => __('Product', 'ywctm'), 'add_to_cart' => __('Show "Add to cart"', 'ywctm'), 'price' => __('Show price', 'ywctm')), 'hidden_columns' => array(), 'sortable_columns' => array('product' => array('post_title', true)), 'custom_columns' => array('column_product' => function ($item, $me) {
$edit_query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab'], 'action' => 'edit', 'id' => $item['ID']);
$edit_url = esc_url(add_query_arg($edit_query_args, admin_url('admin.php')));
$delete_query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab'], 'action' => 'delete', 'id' => $item['ID']);
$delete_url = esc_url(add_query_arg($delete_query_args, admin_url('admin.php')));
$product_query_args = array('post' => $item['ID'], 'action' => 'edit');
$product_url = esc_url(add_query_arg($product_query_args, admin_url('post.php')));
$actions = array('edit' => '<a href="' . $edit_url . '">' . __('Edit exclusions', 'ywctm') . '</a>', 'delete' => '<a href="' . $delete_url . '">' . __('Remove from exclusions', 'ywctm') . '</a>');
return sprintf('<strong><a class="tips" target="_blank" href="%s" data-tip="%s">#%d %s </a></strong> %s', $product_url, __('Edit product', 'ywctm'), $item['ID'], $item['post_title'], $me->row_actions($actions));
}, 'column_add_to_cart' => function ($item, $me) {
if ($item['add_to_cart'] == 'yes') {
$class = 'show';
$tip = __('Yes', 'ywctm');
} else {
$class = 'hide';
$tip = __('No', 'ywctm');
}
return sprintf('<mark class="%s tips" data-tip="%s">%s</mark>', $class, $tip, $tip);
}, 'column_price' => function ($item, $me) {
if ($item['price'] == 'yes') {
$class = 'show';
$tip = __('Yes', 'ywctm');
} else {
$class = 'hide';
$tip = __('No', 'ywctm');
}
return sprintf('<mark class="%s tips" data-tip="%s">%s</mark>', $class, $tip, $tip);
}), 'bulk_actions' => array('actions' => array('delete' => __('Remove from list', 'ywctm')), '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("UPDATE {$wpdb->prefix}postmeta\r\n SET meta_value='no'\r\n WHERE ( meta_key = '_ywctm_exclude_catalog_mode' OR meta_key = '_ywctm_exclude_hide_price' ) AND post_id IN ( {$ids} )");
}
})));
$table->prepare_items();
$message = '';
$notice = '';
$default = array('ID' => 0, 'post_title' => '', 'add_to_cart' => '', 'price' => '');
$list_query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab']);
$list_url = esc_url(add_query_arg($list_query_args, admin_url('admin.php')));
if ('delete' === $table->current_action()) {
$message = sprintf(_n('%s product removed successfully', '%s products removed successfully', count($_GET['id']), 'ywctm'), count($_GET['id']));
}
if (!empty($_POST['nonce']) && wp_verify_nonce($_POST['nonce'], basename(__FILE__))) {
$item_valid = self::validate_fields($_POST);
if ($item_valid !== true) {
$notice = $item_valid;
} else {
$show_cart = isset($_POST['show-cart']) ? 'yes' : 'no';
$show_price = isset($_POST['show-price']) ? 'yes' : 'no';
foreach ($_POST['products'] as $product_id) {
update_post_meta($product_id, '_ywctm_exclude_catalog_mode', $show_cart);
update_post_meta($product_id, '_ywctm_exclude_hide_price', $show_price);
}
if (!empty($_POST['insert'])) {
$message = sprintf(_n('%s product added successfully', '%s products added successfully', count($_POST['products']), 'ywctm'), count($_POST['products']));
} elseif (!empty($_POST['update'])) {
$message = __('Product updated successfully', 'ywctm');
}
}
}
$item = $default;
if (isset($_GET['id'])) {
$select_table = $table->options['select_table'];
$select_columns = implode(',', $table->options['select_columns']);
$item = $wpdb->get_row($wpdb->prepare("SELECT {$select_columns} FROM {$select_table} WHERE a.id = %d", $_GET['id']), ARRAY_A);
}
?>
<div class="wrap">
<div class="icon32 icon32-posts-post" id="icon-edit"><br/></div>
<h2><?php
_e('Exclusion list', 'ywctm');
if (empty($_GET['action']) || 'insert' !== $_GET['action'] && 'edit' !== $_GET['action']) {
?>
<?php
$query_args = array('page' => $_GET['page'], 'tab' => $_GET['tab'], 'action' => 'insert');
$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 Products', 'ywctm');
?>
</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']) && ('insert' == $_GET['action'] || 'edit' == $_GET['action'])) {
?>
<form id="form" method="POST">
<input type="hidden" name="nonce" value="<?php
echo wp_create_nonce(basename(__FILE__));
?>
"/>
<table class="form-table">
<tbody>
<tr valign="top" class="titledesc">
<th scope="row">
<label for="product"><?php
_e('Products to exclude', 'ywctm');
?>
</label>
</th>
<td class="forminp yith-choosen">
<?php
if ('insert' == $_GET['action']) {
?>
<select id="product" name="products[]" class="ajax_chosen_select_product" style="width: 50%" multiple="multiple" placeholder="Search for product"></select>
<?php
} else {
?>
<input id="product" name="products[]" type="hidden" value="<?php
echo esc_attr($item['ID']);
?>
"/>
<?php
printf('<b>#%d %s</b>', esc_attr($item['ID']), esc_attr($item['post_title']));
?>
<?php
}
?>
</td>
</tr>
<tr valign="top" class="titledesc">
<th scope="row">
<label for="show-cart"><?php
_e('Show "Add to cart" button', 'ywctm');
?>
</label>
</th>
<td class="forminp forminp-email">
<input id="show-cart" name="show-cart" type="checkbox" <?php
echo esc_attr($item['add_to_cart']) == 'yes' ? 'checked="checked"' : '';
?>
/>
</td>
</tr>
<tr valign="top" class="titledesc">
<th scope="row">
<label for="show-price"><?php
_e('Show product price', 'ywctm');
?>
</label>
</th>
<td class="forminp forminp-checkbox">
<input id="show-price" name="show-price" type="checkbox" <?php
echo esc_attr($item['price']) == 'yes' ? 'checked="checked"' : '';
?>
/>
</td>
</tr>
</tbody>
</table>
<?php
if ('insert' == $_GET['action']) {
?>
<input type="submit" value="<?php
_e('Add product exclusion', 'ywctm');
?>
" id="insert" class="button-primary" name="insert">
<?php
} else {
?>
<input type="submit" value="<?php
_e('Update product exclusion', 'ywctm');
?>
" id="update" class="button-primary" name="update">
<?php
}
?>
<a class="button-secondary" href="<?php
echo $list_url;
?>
"><?php
_e('Return to exclusion list', 'ywctm');
?>
</a>
</form>
<?php
} else {
?>
<form id="custom-table" method="GET" action="<?php
echo $list_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
wp_enqueue_script('ajax-chosen');
$inline_js = "\r\n jQuery( 'select.ajax_chosen_select_product' ).ajaxChosen({\r\n method: 'GET',\r\n url: '" . admin_url('admin-ajax.php') . "',\r\n dataType: 'json',\r\n afterTypeDelay: 100,\r\n minTermLength: 1,\r\n data: {\r\n action: 'woocommerce_json_search_products',\r\n security: '" . wp_create_nonce("search-products") . "',\r\n default: ''\r\n }\r\n }, function ( data ) {\r\n\r\n var terms = {};\r\n\r\n \$.each( data, function ( i, val ) {\r\n terms[i] = val;\r\n });\r\n\r\n return terms;\r\n });\r\n ";
wc_enqueue_js($inline_js);
}
