',
! empty( $item['variation_id'] ) ? $item['variation_id'] : $item['product_id']
);
}
public function column_thumb( $item ) {
$product_id = $item['variation_id'] ? $item['variation_id'] : $item['product_id'];
$product = wc_get_product( $product_id );
if ( ! $product ) {
return '';
}
?>
get_image( 'thumbnail' ); // phpcs:ignore. ?>
sprintf( 'ID: %s', esc_html( $item['product_id'] ) ),
'edit' => sprintf( '%s', $product_edit_url, esc_html__( 'Edit this item', 'woodmart' ), esc_html__( 'Edit', 'woodmart' ) ),
'view_users' => sprintf(
'%s',
esc_url(
add_query_arg(
array(
'page' => 'xts-waitlist-page',
'tab' => 'users',
'product_id' => $item['product_id'],
'variation_id' => $item['variation_id'],
),
admin_url( 'edit.php?post_type=product' )
)
),
esc_html__( 'View a list with customers that have added this product to their waitlist', 'woodmart' ),
esc_html__( 'View customers', 'woodmart' )
),
'view_product' => sprintf( '%s', $product->get_permalink(), esc_html__( 'View Product', 'woodmart' ), esc_html__( 'View Product', 'woodmart' ) ),
);
if ( in_array( $product->get_type(), array( 'variation', 'subscription_variation' ), true ) ) {
$attributes = array();
foreach ( $product->get_attributes() as $taxonomy => $value ) {
$attributes[ wc_attribute_label( $taxonomy ) ] = $value;
}
}
?>
is_in_stock() ) {
$status_class = 'instock';
$status_label = esc_html__( 'In stock', 'woodmart' );
} else {
$status_class = 'outofstock';
$status_label = esc_html__( 'Out of stock', 'woodmart' );
}
ob_start();
?>
%d',
esc_url(
add_query_arg(
array(
'page' => 'xts-waitlist-page',
'tab' => 'users',
'product_id' => $item['product_id'],
'variation_id' => $item['variation_id'],
),
admin_url( 'edit.php?post_type=product' )
)
),
$column_content
);
}
/**
* Override the parent columns method. Defines the columns to use in your listing table.
*
* @return array
*/
public function get_columns() {
return array(
'cb' => '',
'thumb' => '' . esc_html__( 'Image', 'woodmart' ) . '',
'name' => esc_html__( 'Name', 'woodmart' ),
'is_in_stock' => esc_html__( 'Stock', 'woodmart' ),
'users' => esc_html__( 'Users', 'woodmart' ),
);
}
/**
* Define which columns are hidden.
*
* @return array
*/
public function get_hidden_columns() {
return array();
}
/**
* Define the sortable columns.
*
* @return array
*/
public function get_sortable_columns() {
return array(
'users' => array( 'user_count', false ),
);
}
/**
* Sets bulk actions for table.
*
* @return array Array of available actions.
*/
public function get_bulk_actions() {
return array(
'delete' => esc_html__( 'Delete', 'woodmart' ),
);
}
/**
* Delete waitlist on bulk action.
*
* @codeCoverageIgnore
*
* @return void
*/
public function process_bulk_action() {
if ( ! isset( $_REQUEST['_wpnonce'] ) || ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'bulk-' . $this->_args['plural'] ) ) { // phpcs:ignore.
return;
}
// Detect when a bulk action is being triggered...
$products_ids = isset( $_REQUEST['products_ids'] ) ? array_map( 'intval', (array) $_REQUEST['products_ids'] ) : false;
if ( 'delete' === $this->current_action() && ! empty( $products_ids ) ) {
foreach ( $products_ids as $product_id ) {
try {
$product = wc_get_product( $product_id );
$this->db_storage->unsubscribe_by_product( $product );
} catch ( Exception $e ) {
continue;
}
}
wp_safe_redirect( admin_url( '/edit.php?post_type=product&page=xts-waitlist-page' ) );
die();
}
}
/**
* Prepare the items for the table to process.
*
* @return void
*/
public function prepare_items() {
$this->db_storage = DB_Storage::get_instance();
$columns = $this->get_columns();
$hidden = $this->get_hidden_columns();
$sortable = $this->get_sortable_columns();
$user_id = get_current_user_id();
$data = $this->table_data();
usort( $data, array( $this, 'sort_data' ) );
$per_page = ! empty( get_user_meta( $user_id, 'waitlist_per_page', true ) ) ? get_user_meta( $user_id, 'waitlist_per_page', true ) : 20;
$current_page = $this->get_pagenum();
$total_items = count( $data );
$this->set_pagination_args(
array(
'total_items' => $total_items,
'per_page' => $per_page,
)
);
$data = array_slice( $data, ( ( $current_page - 1 ) * $per_page ), $per_page );
$this->_column_headers = array( $columns, $hidden, $sortable );
$this->items = $data;
$this->process_bulk_action();
}
/**
* Get the table data.
*
* @return array
*/
private function table_data() {
global $wpdb;
$where_query = array();
$search = isset( $_REQUEST['s'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ) : false; // phpcs:ignore.
$_product_id = isset( $_REQUEST['_product_id'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['_product_id'] ) ) : false; // phpcs:ignore.
$_user_id = isset( $_REQUEST['_user_id'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['_user_id'] ) ) : false; // phpcs:ignore.
if ( $search ) {
$where_query[] = $wpdb->prepare( "$wpdb->posts.`post_title` LIKE %s", '%' . $wpdb->esc_like( $search ) . '%' );
}
if ( $_product_id ) {
$where_query[] = $wpdb->prepare( "$wpdb->wd_waitlists.`product_id` = %d OR $wpdb->wd_waitlists.`variation_id` = %d", $_product_id, $_product_id );
}
if ( $_user_id ) {
$where_query[] = $wpdb->prepare( "$wpdb->wd_waitlists.user_id = %d", $_user_id );
}
$where_query_text = ! empty( $where_query ) ? ' WHERE ' . implode( ' AND ', $where_query ) : '';
if ( ! wp_cache_get( 'wd_waitlist_table_data' ) ) {
wp_cache_set(
'wd_waitlist_table_data',
$wpdb->get_results( //phpcs:ignore;
"SELECT
$wpdb->wd_waitlists.`list_id`,
$wpdb->wd_waitlists.`product_id`,
$wpdb->wd_waitlists.`variation_id`,
COUNT( $wpdb->wd_waitlists.`user_id` ) as `user_count`,
$wpdb->wd_waitlists.`created_date_gmt` as `created_date`
FROM $wpdb->wd_waitlists
INNER JOIN $wpdb->posts
ON $wpdb->posts.`ID` = $wpdb->wd_waitlists.`product_id`"
. $where_query_text .
" GROUP BY
$wpdb->wd_waitlists.`product_id`,
$wpdb->wd_waitlists.`variation_id`
;",
ARRAY_A
)
);
}
return wp_cache_get( 'wd_waitlist_table_data' );
}
/**
* Allows you to sort the data by the variables set in the $_GET.
*
* @codeCoverageIgnore
*
* @param array $a First array.
* @param array $b Next array.
* @return int
*/
private function sort_data( $a, $b ) {
// Set defaults.
$order_by = 'created_date';
$order = 'desc';
// If orderby is set, use this as the sort column.
if ( ! empty( $_GET['orderby'] ) ) { // phpcs:ignore.
$order_by = $_GET['orderby']; // phpcs:ignore.
}
// If order is set use this as the order.
if ( ! empty( $_GET['order'] ) ) { // phpcs:ignore.
$order = $_GET['order']; // phpcs:ignore.
}
if ( ! isset( $a[ $order_by ] ) || ! isset( $b[ $order_by ] ) ) {
return 0;
}
$result = strcmp( $a[ $order_by ], $b[ $order_by ] );
if ( is_numeric( $a[ $order_by ] ) && is_numeric( $b[ $order_by ] ) ) {
$result = $a[ $order_by ] - $b[ $order_by ];
}
if ( 'asc' === $order ) {
return $result;
}
return -$result;
}
/**
* Print filters for current table
*
* @codeCoverageIgnore
*
* @param string $which Top / Bottom.
*
* @return void
* @since 1.0.0
*/
protected function extra_tablenav( $which ) {
if ( 'top' !== $which ) {
return;
}
$need_reset = false;
$product_id = isset( $_REQUEST['_product_id'] ) ? intval( $_REQUEST['_product_id'] ) : false; // phpcs:ignore.
$user_id = isset( $_REQUEST['_user_id'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['_user_id'] ) ) : false; // phpcs:ignore.
if ( ! empty( $product_id ) ) {
$product = wc_get_product( $product_id );
if ( $product ) {
$selected_product = '#' . $product_id . ' – ' . $product->get_title();
}
}
if ( ! empty( $user_id ) ) {
$user = get_user_by( 'id', $user_id );
if ( $user ) {
$selected_user = $user->get( 'user_login' );
}
}
if ( $product_id || $user_id ) {
$need_reset = true;
}
wp_enqueue_style(
'xts-jquery-ui',
WOODMART_ASSETS . '/css/jquery-ui.css',
array(),
WOODMART_VERSION
);
wp_enqueue_script(
'xts-admin-waitlist',
WOODMART_ASSETS . '/js/waitlist.js',
array(
'jquery',
'jquery-ui-datepicker',
'select2',
),
WOODMART_VERSION,
true
);
?>
'post-query-submit' ) );
if ( $need_reset ) {
echo sprintf(
'%s',
esc_url(
add_query_arg(
array(
'page' => 'xts-waitlist-page',
),
admin_url( '/edit.php?post_type=product' )
)
),
esc_html__( 'Reset', 'woodmart' )
);
}
}
}