<?php
/**
 * @package WPBDP/includes/Admin/Admin listings
 */

/**
 * Class WPBDP_Admin_Listings
 */
class WPBDP_Admin_Listings {

	public $listing_owner = false;

	public function __construct() {
		add_action( 'admin_init', array( $this, 'add_metaboxes' ) );
		add_action( 'wpbdp_admin_notices', array( $this, 'no_plan_edit_notice' ) );

		add_action( 'manage_' . WPBDP_POST_TYPE . '_posts_columns', array( &$this, 'modify_columns' ) );
		add_action( 'manage_' . WPBDP_POST_TYPE . '_posts_custom_column', array( &$this, 'listing_column' ), 10, 2 );
		add_filter( 'manage_edit-' . WPBDP_POST_TYPE . '_sortable_columns', array( &$this, 'sortable_columns' ) );

		add_filter( 'views_edit-' . WPBDP_POST_TYPE, array( &$this, 'listing_views' ) );
		add_filter( 'posts_clauses', array( &$this, 'listings_admin_filters' ) );

		add_filter( 'post_row_actions', array( &$this, 'row_actions' ), 10, 2 );

		add_action( 'admin_footer', array( $this, '_add_bulk_actions' ) );
		add_action( 'admin_footer', array( $this, '_fix_new_links' ) );

		add_action( 'wpbdp_save_listing', array( $this, 'maybe_save_fields' ) );
		add_action( 'wpbdp_save_listing', array( $this, 'maybe_restore_listing_slug' ) );
		add_action( 'wpbdp_save_listing', array( $this, 'maybe_update_plan' ) );

		// Filter by category.
		add_action( 'restrict_manage_posts', array( &$this, '_add_category_filter' ) );
		add_action( 'parse_query', array( &$this, '_apply_category_filter' ) );

		add_action( 'restrict_manage_posts', array( &$this, '_add_category_filter' ) );

		// Augment search with username search.
		add_filter( 'posts_search', array( $this, 'username_and_user_email_search_support' ), 10, 2 );

		add_action( 'wp_ajax_wpbdp-clear-payment-history', array( &$this, 'ajax_clear_payment_history' ) );

		add_action( 'wp_ajax_wpbdp-assign-plan-to-listing', array( &$this, 'ajax_assign_plan_to_listing' ) );

		add_filter( 'tag_cloud_sort', array( $this, '_add_tag_cloud' ) );

		$this->listing_owner = new WPBDP__Admin__Listing_Owner();
	}

	// Category filter. {{
	function _add_category_filter() {
		global $typenow;
		global $wp_query;

		if ( WPBDP_POST_TYPE !== $typenow ) {
			return;
		}

		wp_dropdown_categories(
			array(
				'show_option_all' => _x( 'All categories', 'admin category filter', 'business-directory-plugin' ),
				'taxonomy'        => WPBDP_CATEGORY_TAX,
				'name'            => WPBDP_CATEGORY_TAX,
				'orderby'         => 'name',
				'selected'        => ( ! empty( $wp_query->query[ WPBDP_CATEGORY_TAX ] ) ? $wp_query->query[ WPBDP_CATEGORY_TAX ] : 0 ),
				'hierarchical'    => true,
				'hide_empty'      => false,
				'depth'           => 4,
			)
		);
	}

	public function _apply_category_filter( $query ) {
		if ( ! is_admin() ) {
			return;
		}

		if ( ! function_exists( 'get_current_screen' ) ) {
			return;
		}

		$screen = get_current_screen();

		if ( ! $screen ) {
			return;
		}

		if ( 'edit' != $screen->base || WPBDP_POST_TYPE != $screen->post_type ) {
			return;
		}

		if ( empty( $query->query_vars[ WPBDP_CATEGORY_TAX ] ) || ! is_numeric( $query->query_vars[ WPBDP_CATEGORY_TAX ] ) ) {
			return;
		}

		$term = get_term_by( 'id', $query->query_vars[ WPBDP_CATEGORY_TAX ], WPBDP_CATEGORY_TAX );

		if ( ! $term ) {
			return;
		}

		$query->query_vars[ WPBDP_CATEGORY_TAX ] = $term->slug;
	}

	// }}
	function username_and_user_email_search_support( $search, $query ) {
		global $wpdb;

		if ( ! function_exists( 'get_current_screen' ) || ! is_admin() ) {
			return $search;
		}

		$screen = get_current_screen();

		if ( ! $screen || 'edit' != $screen->base || WPBDP_POST_TYPE != $screen->post_type ) {
			return $search;
		}

		if ( ! isset( $_GET['s'] ) || ! $query->is_search ) {
			return $search;
		}

		$search_term = wpbdp_get_var( array( 'param' => 's' ) );
		$search_term = '%' . $wpdb->esc_like( $search_term ) . '%';

		$sql  = 'SELECT ID FROM ' . $wpdb->users . ' ';
		$sql .= 'LEFT JOIN ' . $wpdb->usermeta . " AS first_name ON ( first_name.user_id = ID AND first_name.meta_key = 'first_name' ) ";
		$sql .= 'LEFT JOIN ' . $wpdb->usermeta . " AS last_name ON ( last_name.user_id = ID AND last_name.meta_key = 'last_name' ) ";
		$sql .= 'WHERE user_nicename LIKE %s OR user_email LIKE %s OR display_name LIKE %s OR first_name.meta_value LIKE %s OR last_name.meta_value LIKE %s';

		$sql = $wpdb->prepare(
			$sql,
			$search_term,
			$search_term,
			$search_term,
			$search_term,
			$search_term
		);

		$user_ids = $wpdb->get_col( $sql );

		if ( ! $user_ids ) {
			return $search;
		}

		$author_condition = sprintf( 'post_author IN (%s)', esc_sql( implode( ', ', $user_ids ) ) );
		$search           = preg_replace( '/\(\(\((.*)\)\)\)/', '((' . $author_condition . ' OR (\1)))', $search );

		return $search;
	}

	function no_plan_edit_notice() {
		if ( ! function_exists( 'get_current_screen' ) ) {
			return;
		}

		$screen = get_current_screen();

		if ( ! $screen || WPBDP_POST_TYPE != $screen->id || 'add' == $screen->action ) {
			return;
		}

		global $post;

		if ( ! $post ) {
			return;
		}

		$listing = WPBDP_Listing::get( $post->ID );

		if ( ! $listing ) {
			return;
		}

		if ( ! $listing->has_fee_plan() ) {
			wpbdp_admin_message( _x( 'This listing doesn\'t have a plan assigned. This is required in order to determine the features available to this listing, as well as handling renewals.', 'admin listings', 'business-directory-plugin' ), 'error' );
		}
	}

	function add_metaboxes() {

		remove_meta_box( 'authordiv', WPBDP_POST_TYPE, 'normal' );

		add_meta_box(
			'wpbdp-listing-plan',
			__( 'Listing Information', 'business-directory-plugin' ),
			array( $this, '_metabox_listing_info' ),
			WPBDP_POST_TYPE,
			'side',
			'core'
		);
		add_meta_box(
			'wpbdp-listing-timeline',
			__( 'Listing Timeline', 'business-directory-plugin' ),
			array( $this, '_metabox_listing_timeline' ),
			WPBDP_POST_TYPE,
			'side',
			'core'
		);
		add_meta_box(
			'wpbdp-listing-fields',
			_x( 'Directory Listing Fields / Images', 'admin', 'business-directory-plugin' ),
			array( 'WPBDP_Admin_Listing_Fields_Metabox', 'metabox_callback' ),
			WPBDP_POST_TYPE,
			'normal',
			'core'
		);

		if ( wpbdp_get_option( 'enable-listing-flagging' ) ) {
			add_meta_box(
				'wpbdp-listing-flagging',
				__( 'Listing Reports', 'business-directory-plugin' ),
				array( $this, '_metabox_listing_flagging' ),
				WPBDP_POST_TYPE,
				'normal',
				'core'
			);
		}

		add_meta_box(
			'wpbdp-listing-owner',
			__( 'Listing Owner', 'business-directory-plugin' ),
			array( $this, '_metabox_listing_owner' ),
			WPBDP_POST_TYPE,
			'normal',
			'core'
		);
	}

	public function _metabox_listing_info( $post ) {
		require_once WPBDP_PATH . 'includes/admin/helpers/class-listing-information-metabox.php';
		$metabox = new WPBDP__Admin__Metaboxes__Listing_Information( $post->ID );

		// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
		echo $metabox->render();
	}

	public function _metabox_listing_timeline( $post ) {
		require_once WPBDP_PATH . 'includes/admin/helpers/class-listing-timeline.php';
		$timeline = new WPBDP__Listing_Timeline( $post->ID );

		// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
		echo $timeline->render();
	}

	public function _metabox_listing_owner( $post ) {
		$this->listing_owner->set_listing_id( $post->ID );

		// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
		echo $this->listing_owner->render_metabox();
	}

	public function _metabox_listing_flagging( $post ) {
		require_once WPBDP_PATH . 'includes/admin/helpers/class-listing-flagging-metabox.php';
		$flagging_metabox = new WPBDP__Admin__Metaboxes__Listing_Flagging( $post->ID );

		// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
		echo $flagging_metabox->render();
	}

	// {{{ Custom columns.
	function modify_columns( $columns ) {
		// Hide comments column.
		unset( $columns['comments'] );

		$new_columns = array();

		foreach ( $columns as $c_key => $c_label ) {
			// Insert category and expiration date after title.
			if ( 'title' == $c_key ) {
				$new_columns['title']           = $c_label;
				$new_columns['category']        = __( 'Categories', 'business-directory-plugin' );
				$new_columns['expiration_date'] = __( 'Expires on', 'business-directory-plugin' );
				continue;
			}

			$new_columns[ $c_key ] = $c_label;
		}

		// Attributes goes last.
		$new_columns['attributes'] = __( 'Attributes', 'business-directory-plugin' );

		$new_columns = apply_filters( 'wpbdp_admin_directory_columns', $new_columns );
		return $new_columns;
	}

	function sortable_columns( $columns ) {
		$columns['title_'] = 'title';
		return $columns;
	}

	function listing_column( $column, $post_id ) {
		if ( ! method_exists( $this, 'listing_column_' . $column ) ) {
			do_action( 'wpbdp_admin_directory_column_' . $column, $post_id );
			return;
		}

		call_user_func( array( &$this, 'listing_column_' . $column ), $post_id );
	}

	function listing_column_category( $post_id ) {
		$terms = wp_get_post_terms( $post_id, WPBDP_CATEGORY_TAX );
		foreach ( $terms as $i => $term ) {
			printf(
				'<a href="%s">%s</a>',
				esc_url( get_term_link( $term->term_id, WPBDP_CATEGORY_TAX ) ),
				esc_html( $term->name )
			);

			if ( $i + 1 != count( $terms ) ) {
				echo ', ';
			}
		}
	}

	public function listing_column_expiration_date( $post_id ) {
		$listing  = WPBDP_Listing::get( $post_id );
		$exp_date = $listing->get_expiration_date();

		if ( $exp_date ) {
			echo esc_html( date_i18n( get_option( 'date_format' ), strtotime( $exp_date ) ) );
		} else {
			esc_html_e( 'Never', 'business-directory-plugin' );
		}
	}

	public function listing_column_attributes( $post_id ) {
		$listing = WPBDP_Listing::get( $post_id );
		$plan    = $listing->get_fee_plan();

		$attributes = array();

		if ( ! $plan ) {
			$attributes['no-fee-plan'] = '<span class="wpbdp-tag wpbdp-listing-attr-no-fee-plan">' . esc_html_x( 'No Plan', 'listing attribute', 'business-directory-plugin' ) . '</span>';
		}

		$listing_status = $listing->get_status();

		if ( ! in_array( $listing_status, array( 'unknown', 'legacy', 'complete' ) ) ) {
			$attributes['listing-status'] = '<span class="wpbdp-tag wpbdp-listing-status-' . esc_attr( $listing_status ) . '">' . $listing->get_status_label() . '</span>';
		}

		foreach ( $listing->get_flags() as $f ) {
			$attributes[ $f ] = '<span class="wpbdp-tag wpbdp-listing-attr-' . esc_attr( $f ) . '">' . esc_html( ucwords( str_replace( '-', ' ', $f ) ) ) . '</span>';
		}

		if ( $plan ) {
			if ( $plan->is_sticky ) {
				$attributes['featured'] = '<span class="wpbdp-tag wpbdp-listing-attr-featured">' . esc_html__( 'Featured', 'business-directory-plugin' ) . '</span>';
			}

			if ( $plan->is_recurring ) {
				$attributes['recurring'] = '<span class="wpbdp-tag wpbdp-listing-attr-recurring">' . esc_html_x( 'Recurring', 'admin listings', 'business-directory-plugin' ) . '</span>';
			}

			if ( 0.0 == $plan->fee_price ) {
				$attributes['free'] = '<span class="wpbdp-tag wpbdp-listing-attr-free">' . esc_html_x( 'Free', 'admin listings', 'business-directory-plugin' ) . '</span>';
			} elseif ( 'pending_payment' != $listing->get_status() ) {
				$latest_payment = $listing->get_latest_payment();

				$attributes['payment'] = '<span class="wpbdp-tag wpbdp-listing-attr-payment-not-found">' . esc_html_x( 'Payment Not Found', 'admin listings', 'business-directory-plugin' ) . '</span>';
				if ( $latest_payment && $latest_payment->status ) {
					$attributes['payment']  = '<span class="wpbdp-tag wpbdp-listing-attr-payment-' . esc_attr( $latest_payment->status ) . '">';
					$attributes['payment'] .= sprintf(
						esc_html__( 'Payment %s', 'business-directory-plugin' ),
						esc_html( $latest_payment->get_status_label( $latest_payment->status ) )
					);
					$attributes['payment'] .= '</span>';
				}
			}
		}

		if ( count( WPBDP__Listing_Flagging::get_flagging_meta( $listing->get_id() ) ) ) {
			$attributes['reported'] = '<span class="wpbdp-tag wpbdp-listing-attr-reported">' . esc_html_x( 'Reported', 'admin listings', 'business-directory-plugin' ) . '</span>';
		}

		$attributes = apply_filters( 'wpbdp_admin_directory_listing_attributes', $attributes, $listing );

		foreach ( $attributes as $attr ) {
			// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
			echo $attr;
		}
	}


	// }}}
	// {{{ List views.
	function listing_views( $views ) {
		if ( ! wpbdp_user_can_edit() ) {
			if ( wpbdp_user_can_access_backend() && isset( $views['mine'] ) ) {
				return array( $views['mine'] );
			}

			return array();
		}

		$post_statuses        = get_post_statuses();
		$post_statuses        = array_keys( get_post_statuses() );
		$post_statuses_string = implode( ',', $post_statuses );

		foreach ( WPBDP_Listing::get_stati() as $status_id => $status_label ) {
			if ( in_array( $status_id, array( 'unknown', 'legacy', 'complete' ) ) ) {
				continue;
			}

			$count = absint(
				WPBDP_Listing::count_listings(
					array(
						'status'      => $status_id,
						'post_status' => $post_statuses_string,
					)
				)
			);
			if ( 0 == $count ) {
				continue;
			}

			$count = number_format_i18n( $count );

			$current_class                         = ! empty( $_GET['listing_status'] ) && $status_id == $_GET['listing_status'] ? 'current' : '';
			$views[ 'wpbdp-status-' . $status_id ] = "<a href='" . remove_query_arg(
				array( 'post_status', 'author', 'all_posts', 'wpbdmfilter' ),
				add_query_arg(
					array(
						'post_type'      => WPBDP_POST_TYPE,
						'listing_status' => $status_id,
					),
					admin_url( 'edit.php' )
				)
			) . "' class='{$current_class}'>{$status_label} <span class='count'>({$count})</span></a>";
		}

		if ( wpbdp_get_option( 'enable-listing-flagging' ) ) {
			global $wpdb;

			$post_statuses_string = "'publish', 'draft', 'pending'";
			$count                = absint( $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(p.ID) FROM {$wpdb->posts} p LEFT JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id WHERE p.post_type = %s AND p.post_status IN ({$post_statuses_string}) AND pm.meta_key = %s AND pm.meta_value = %d", WPBDP_POST_TYPE, '_wpbdp_flagged', 1 ) ) );

			if ( $count > 0 ) {
				$status            = wpbdp_get_var( array( 'param' => 'listing_status' ), 'request' );
				$views['reported'] = sprintf(
					'<a href="%s" class="%s">%s <span class="count">(%s)</span></a>',
					esc_url(
						add_query_arg(
							array(
								'post_type'      => WPBDP_POST_TYPE,
								'listing_status' => 'reported',
							),
							admin_url( 'edit.php' )
						)
					),
					$status === 'reported' ? 'current' : '',
					esc_html_x( 'Reported', 'listing status', 'business-directory-plugin' ),
					esc_html( number_format_i18n( $count ) )
				);
			}
		}

		$views = apply_filters( 'wpbdp_admin_directory_views', $views, "'" . implode( "','", $post_statuses ) . "'" );

		return $views;
	}

	function listings_admin_filters( $pieces ) {
		global $wpdb;

		if ( ! is_admin() || ( ! isset( $_REQUEST['listing_status'] ) && ! isset( $_REQUEST['wpbdmfilter'] ) ) || ! function_exists( 'get_current_screen' ) || ! get_current_screen() || 'edit-' . WPBDP_POST_TYPE != get_current_screen()->id ) {
			return $pieces;
		}

		$status_filter = wpbdp_get_var(
			array(
				'param'   => 'listing_status',
				'default' => 'all',
			),
			'request'
		);
		$other_filter  = wpbdp_get_var( array( 'param' => 'wpbdmfilter' ), 'request' );

		if ( in_array( $status_filter, array_keys( WPBDP_Listing::get_stati() ), true ) ) {
			$add = " LEFT JOIN {$wpdb->prefix}wpbdp_listings ls ON ls.listing_id = {$wpdb->posts}.ID ";
			if ( strpos( $pieces['join'], $add ) === false ) {
				$pieces['join'] .= $add;
			}
			$pieces['where'] .= $wpdb->prepare( 'AND ls.listing_status = %s', $status_filter );
		}

		if ( 'reported' == $status_filter ) {
			$pieces['join']  .= " LEFT JOIN {$wpdb->postmeta} pm ON pm.post_id = {$wpdb->posts}.ID ";
			$pieces['where'] .= $wpdb->prepare( ' AND pm.meta_key = %s AND pm.meta_value = %d', '_wpbdp_flagged', 1 );
		}

		if ( $other_filter ) {
			$pieces = apply_filters( 'wpbdp_admin_directory_filter', $pieces, $other_filter );
		}

		return $pieces;
	}

	// }}}
	public function row_actions( $actions, $post ) {
		if ( WPBDP_POST_TYPE != $post->post_type ) {
			return $actions;
		}

		if ( wpbdp_user_can_access_backend() && ! wpbdp_user_is_admin() ) {
			if ( wpbdp_user_can( 'edit', $post->ID ) ) {
				$actions['edit'] = sprintf(
					'<a href="%s">%s</a>',
					esc_url( wpbdp_url( 'edit_listing', $post->ID ) ),
					esc_html__( 'Edit Listing', 'business-directory-plugin' )
				);
			}

			if ( wpbdp_user_can( 'delete', $post->ID ) ) {
				$actions['delete'] = sprintf( '<a href="%s">%s</a>', wpbdp_url( 'delete_listing', $post->ID ), __( 'Delete Listing', 'business-directory-plugin' ) );
			}
		}

		if ( ! wpbdp_user_is_admin() ) {
			return $actions;
		}

		$listing  = wpbdp_get_listing( $post->ID );
		$payments = $listing->get_payments();
		if ( $payments->count() > 1 ) {
			$actions['view-payments'] = '<a href="' . esc_url( admin_url( 'admin.php?page=wpbdp_admin_payments&listing=' . $listing->get_id() ) ) . '">' . _x( 'View Payments', 'admin actions', 'business-directory-plugin' ) . '</a>';
		} else {
			$payment = $payments->get();

			if ( $payment ) {
				$actions['view-payments'] = '<a href="' . esc_url( $payment->get_admin_url() ) . '">' . _x( 'View Payment', 'admin actions', 'business-directory-plugin' ) . '</a>';
			}
		}

		$actions = apply_filters( 'wpbdp_admin_directory_row_actions', $actions, $listing );

		return $actions;
	}

	/**
	 * @since 5.0
	 */
	public function maybe_save_fields( $post_id ) {
		if ( ! is_admin() ) {
			return;
		}

		$nonce = wpbdp_get_var( array( 'param' => 'wpbdp-admin-listing-fields-nonce' ), 'post' );

		if ( empty( $nonce ) || ! wp_verify_nonce( $nonce, 'save listing fields' ) || empty( $_POST['listingfields'] ) ) {
			return;
		}

		$fields = wpbdp_get_form_fields( array( 'association' => 'meta' ) );
		foreach ( $fields as $field ) {
			if ( isset( $_POST['listingfields'][ $field->get_id() ] ) ) {
				$value = $field->value_from_POST();
				$field->store_value( $post_id, $value );
			} else {
				$field->store_value( $post_id, $field->convert_input( null ) );
			}
		}

		$listing = wpbdp_get_listing( $post_id );

		$_thumbnail_id = intval( wpbdp_get_var( array( 'param' => '_thumbnail_id' ), 'post' ) );
		$thumbnail_id  = intval( wpbdp_get_var( array( 'param' => 'thumbnail_id' ), 'post' ) );
		$thumbnail_id  = $_thumbnail_id > 0 ? $_thumbnail_id : $thumbnail_id;

		// Update image information.
		if ( $thumbnail_id > 0 ) {
			$listing->set_thumbnail_id( $thumbnail_id );
			$listing->set_images( array( $thumbnail_id ), true );
		}

		// Images info.
		$meta = wpbdp_get_var( array( 'param' => 'images_meta' ), 'post' );
		if ( ! empty( $meta ) ) {
			$images = array_keys( $meta );

			update_post_meta( $post_id, '_wpbdp[images]', $images );

			foreach ( $meta as $img_id => $img_meta ) {
				update_post_meta( $img_id, '_wpbdp_image_weight', absint( $img_meta['order'] ) );
				update_post_meta( $img_id, '_wpbdp_image_caption', strval( $img_meta['caption'] ) );
			}
		}
	}

	public function maybe_restore_listing_slug( $post_id ) {
		$post_name = get_post_meta( $post_id, '_wpbdp[name]', true );

		if ( $post_name === get_post_field( 'post_name', $post_id ) ) {
			return;
		}

		update_post_meta( $post_id, '_wpbdp[name]', get_post_field( 'post_name', $post_id ) );
	}

	/**
	 * @since 5.0
	 */
	public function maybe_update_plan( $post_id ) {
		if ( ! is_admin() ) {
			return;
		}

		$nonce = wpbdp_get_var( array( 'param' => 'wpbdp-admin-listing-plan-nonce' ), 'post' );

		if ( empty( $nonce ) || ! wp_verify_nonce( $nonce, 'update listing plan' ) ) {
			return;
		}

		global $wpdb;

		$listing      = wpbdp_get_listing( $post_id );
		$new_plan     = wpbdp_get_var(
			array(
				'param'   => 'listing_plan',
				'default' => array(),
			),
			'post'
		);
		$current_plan = $listing->get_fee_plan();

		if ( ! $current_plan && empty( $new_plan['fee_id'] ) ) {
			return;
		}

		if ( ! $current_plan || (int) $current_plan->fee_id != (int) $new_plan['fee_id'] ) {
			$payment = $listing->set_fee_plan_with_payment( $new_plan['fee_id'] );

			if ( $payment ) {
				$payment->process_as_admin();
			}
		}

		if ( ! $current_plan ) {
			$listing->set_flag( 'admin-posted' );
		}

		// Update plan attributes.
		$row                    = array();
		$row['expiration_date'] = '' == $new_plan['expiration_date'] ? null : $new_plan['expiration_date'];
		$row['fee_images']      = absint( $new_plan['fee_images'] );

		$wpdb->update( $wpdb->prefix . 'wpbdp_listings', $row, array( 'listing_id' => $post_id ) );

		$not_expired = false;
		if ( $row['expiration_date'] ) {
			$not_expired = strtotime( $row['expiration_date'] ) > current_time( 'timestamp' );
		}

		// Check if the status needs to be changed.
		if ( 'expired' == $listing->get_status() ) {
			if ( ! $row['expiration_date'] || $not_expired ) {
				$listing->get_status( true, true );
			}
		} elseif ( ! $not_expired && $row['expiration_date'] ) {
			$listing->set_status( 'expired' );
		}
	}

	public function _add_bulk_actions() {
		if ( ! wpbdp_user_is_admin() ) {
			return;
		}

		if ( $screen = get_current_screen() ) {
			if ( $screen->id == 'edit-' . WPBDP_POST_TYPE ) {
				if ( isset( $_GET['post_type'] ) && $_GET['post_type'] == WPBDP_POST_TYPE ) {
					$bulk_actions = array(
						'sep0'              => '–',
						'change-to-publish' => _x( 'Publish listings', 'admin actions', 'business-directory-plugin' ),
						'change-to-pending' => _x( 'Mark as "Pending Review"', 'admin actions', 'business-directory-plugin' ),
						'change-to-draft'   => _x( 'Hide from directory (mark as "Draft")', 'admin actions', 'business-directory-plugin' ),
						'sep1'              => '–',
						'renewlisting'      => _x( 'Renew listings', 'admin actions', 'business-directory-plugin' ),
						'change-to-expired' => _x( 'Set listings as "Expired"', 'admin actions', 'business-directory-plugin' ),
											/*
											Disabled as per https://github.com/drodenbaugh/BusinessDirectoryPlugin/issues/3279. */
											/*'approve-payments' => _x( 'Approve pending payments', 'admin actions', 'business-directory-plugin' ),*/
					);

					if ( wpbdp_get_option( 'enable-key-access' ) ) {
						$bulk_actions['send-access-keys'] = _x( 'Send access keys', 'admin actions', 'business-directory-plugin' );
					}

					$bulk_actions = apply_filters( 'wpbdp_admin_directory_bulk_actions', $bulk_actions );

					// the 'bulk_actions' filter doesn't really work for this until this bug is fixed: http://core.trac.wordpress.org/ticket/16031
					echo '<script>';

					foreach ( $bulk_actions as $action => $text ) {
						printf(
							'jQuery(\'select[name="%s"]\').append(\'<option value="%s" data-uri="%s">%s</option>\');',
							'action',
							'listing-' . esc_attr( $action ),
							esc_url( add_query_arg( 'wpbdmaction', $action, admin_url( 'edit.php?post_type=wpbdp_listing' ) ) ),
							esc_html( $text )
						);
						printf(
							'jQuery(\'select[name="%s"]\').append(\'<option value="%s" data-uri="%s">%s</option>\');',
							'action2',
							'listing-' . esc_attr( $action ),
							esc_url( add_query_arg( 'wpbdmaction', $action, admin_url( 'edit.php?post_type=wpbdp_listing' ) ) ),
							esc_html( $text )
						);
					}

					echo '</script>';
				}
			}
		}
	}

	/**
	 * 'contributors' should still use the frontend to add listings
	 * (editors, authors and admins are allowed to add things directly)
	 * This is kind of hacky but is the best we can do atm, there aren't hooks to change add links
	 */
	public function _fix_new_links() {
		$post_type = wpbdp_get_var( array( 'param' => 'post_type' ) );
		if ( ! wpbdp_user_can_access_backend() && $post_type === WPBDP_POST_TYPE ) {
			echo '<script>';
			printf( 'jQuery(\'a.add-new-h2\').attr(\'href\', \'%s\');', esc_url_raw( wpbdp_get_page_link( 'add-listing' ) ) );
			echo '</script>';
		}
	}

	public function ajax_clear_payment_history() {
		WPBDP_App_Helper::permission_check();
		if ( ! check_ajax_referer( 'wpbdp_ajax', 'nonce', false ) ) {
			wp_send_json_error( array( 'error' => __( 'Invalid nonce.', 'business-directory-plugin' ) ) );
		}

		$listing_id = wpbdp_get_var( array( 'param' => 'listing_id' ), 'post' );

		if ( ! $listing_id ) {
			wp_send_json_error();
		}

		$listing = wpbdp_get_listing( $listing_id );
		$res     = $listing->delete_payment_history();

		if ( is_wp_error( $res ) ) {
			wp_send_json_error( array( 'error' => $res->get_error_message() ) );
		}

		wp_send_json_success( array( 'message' => _x( 'Listing\'s payment history successfully deleted', 'admin listings', 'business-directory-plugin' ) ) );
	}

	/**
	 * Assign a plan to a listing.
	 * This assigns a plan to a listing in the admin backend.
	 *
	 * @since 5.18
	 */
	public function ajax_assign_plan_to_listing() {
		check_ajax_referer( 'wpbdp_ajax', 'nonce' );
		if ( ! wpbdp_user_can_access_backend() ) {
			wp_send_json_error();
		}

		$listing_id = wpbdp_get_var( array( 'param' => 'listing_id' ), 'post' );
		$plan_id    = wpbdp_get_var( array( 'param' => 'plan_id' ), 'post' );
		if ( ! $listing_id || ! $plan_id ) {
			wp_send_json_error();
		}

		$listing      = wpbdp_get_listing( $listing_id );
		$current_plan = $listing->get_fee_plan();

		if ( ! $current_plan || (int) $current_plan->fee_id !== (int) $plan_id ) {
			$listing->set_fee_plan( $plan_id );
		}

		$new_plan    = $listing->get_fee_plan();
		$fee         = $new_plan->fee;
		$expiration  = $fee->calculate_expiration_time();
		$date_output = $expiration ? wpbdp_date_full_format( strtotime( $expiration ) ) : __( 'Never', 'business-directory-plugin' );

		wp_send_json_success(
			array(
				'id'              => $fee->id,
				'label'           => $fee->label,
				'amount'          => $fee->amount ? wpbdp_currency_format( $fee->amount ) : '',
				'days'            => $fee->days,
				'expiration_date' => $expiration,
				'formated_date'   => $date_output,
				'images'          => $fee->images,
				'sticky'          => $fee->sticky ? __( 'Yes', 'business-directory-plugin' ) : __( 'No', 'business-directory-plugin' ),
				'recurring'       => $fee->recurring ? __( 'Yes', 'business-directory-plugin' ) : __( 'No', 'business-directory-plugin' ),
			)
		);
	}

	public function _add_tag_cloud( $tags ) {
		if ( isset( $_POST['tax'] ) && WPBDP_TAGS_TAX !== $_POST['tax'] ) {
			return $tags;
		}

		$tags = get_terms(
			array(
				'taxonomy'   => WPBDP_TAGS_TAX,
				'number'     => 45,
				'orderby'    => 'count',
				'order'      => 'DESC',
				'hide_empty' => false,
			)
		);

		return $tags;
	}

	/**
	 * @deprecated 5.11.2
	 */
	public function maybe_hide_permalinks( $return ) {
		_deprecated_function( __METHOD__, '5.11.2' );

		return $return;
	}
}
