<?php

class AWPCP_Listings_Table extends WP_List_Table {

    private $params;
    private $selected_category_id;
    private $items_per_page;
    private $total_items;

    private $page;

    /**
     * @var Facebook Integration.
     */
    private $facebook_integration;

    public function __construct( $page, $params = array() ) {
        parent::__construct( array_merge( array( 'plural' => 'awpcp-listings' ), $params ) );
        $this->page = $page;
    }

    /**
     * @since 3.9.0
     */
    public function set_facebook_integration( $facebook_integration ) {
        $this->facebook_integration = $facebook_integration;
    }

    public function prepare_items() {
        $search_params = $this->get_listing_search_params();

        $this->load_items_from_query( $search_params['query'], $search_params['filters'] );

        if ( isset( $search_params['query']['category_id'] ) && $search_params['query']['category_id'] ) {
            $category = AWPCP_Category::find_by_id( $search_params['query']['category_id'] );
            if (!is_null($category)) {
                awpcp_flash(sprintf(__('Showing Ads from %s category.', 'another-wordpress-classifieds-plugin'), "<strong>{$category->name}</strong>"));
            }
        }

        $this->_column_headers = array($this->get_columns(), array(), $this->get_sortable_columns());
    }

    private function get_listing_search_params() {
        $user = wp_get_current_user();

        $items_per_page = (int) get_user_meta($user->ID, 'listings-items-per-page', true);
        $this->items_per_page = awpcp_request_param('items-per-page', $items_per_page === 0 ? 10 : $items_per_page);
        $this->items_per_page = apply_filters( 'awpcp_listings_table_items_per_page', $this->items_per_page, $user );
        update_user_meta($user->ID, 'listings-items-per-page', $this->items_per_page);

        $default_category = absint( get_user_meta( $user->ID, 'listings-category', true ) );
        $this->selected_category_id = isset( $_POST['category'] ) ? awpcp_request_param( 'category' ) : $default_category;
        update_user_meta( $user->ID, 'listings-category', $this->selected_category_id );

        $params = $this->params = shortcode_atts(array(
            's' => '',
            'filterby' => '',
            'search-by' => '',
            'orderby' => '',
            'order' => 'desc',
            'paged' => 1,
        ), $_REQUEST);

        $query = array();

        if ( ! awpcp_current_user_is_moderator() ) {
            $query['user_id'] = wp_get_current_user()->ID;
        }

        try {
            $conditions = awpcp_listings_table_search_by_condition_parser()->parse( $params['search-by'], $params['s']);
            $query = array_merge( $query, (array) $conditions );
        } catch (Exception $e) {
            // ignore
        }

        if ( ! empty( $this->selected_category_id ) ) {
            $query['category_id'] = $this->selected_category_id;
            $query['include_listings_in_children_categories'] = true;
        }

        $show_incomplete = false;
        $show_non_verified = false;
        $show_expired = false;
        $show_awaiting_approval = false;

        switch ($params['filterby']) {
            case 'is-featured':
                $query['featured'] = true;
                break;

            case 'flagged':
                $query['flagged'] = true;
                break;

            case 'incomplete':
                $query['payment_status'] = 'Unpaid';
                $show_incomplete = true;
                break;

            case 'non-verified':
                $query['verified'] = false;
                $show_non_verified = true;
                break;

            case 'awaiting-approval':
                $show_awaiting_approval = true;
                break;

            case 'images-awaiting-approval':
                $query['have_media_awaiting_approval'] = true;
                break;

            case 'new':
                $query['reviewed'] = false;
                break;

            case 'expired':
                $show_expired = true;
                break;

            case 'completed':
            default:
                break;
        }

        switch($params['orderby']) {
            case 'title':
            case 'start-date':
            case 'end-date':
            case 'renewed-date':
            case 'status':
            case 'payment-term':
            case 'payment-status':
            case 'featured-ad':
            case 'owner':
                $query['orderby'] = $params['orderby'];
                break;

            default:
                $query['orderby'] = 'renewed-date';
                break;
        }

        $query['order'] = $params['order'];
        $query['offset'] = $this->items_per_page * ( $params['paged'] - 1 );
        $query['limit'] = $this->items_per_page;

        return array(
            'query' => $query,
            'filters' => compact( 'show_incomplete', 'show_expired', 'show_non_verified', 'show_awaiting_approval' ),
        );
    }

    private function load_items_from_query( $query, $filters ) {
        $listings = awpcp_listings_collection();

        if ( isset( $filters['show_expired'] ) && $filters['show_expired'] ) {
            $this->total_items = $listings->count_expired_listings_with_query( $query );
            $this->items = $listings->find_expired_listings_with_query( $query );
        } else if ( isset( $filters['show_awaiting_approval'] ) && $filters['show_awaiting_approval'] ) {
            $this->total_items = $listings->count_listings_awaiting_approval_with_query( $query );
            $this->items = $listings->find_listings_awaiting_approval_with_query( $query );
        } else if ( $filters['show_non_verified'] ) {
            $this->total_items = $listings->count_successfully_paid_listings_with_query( $query );
            $this->items = $listings->find_successfully_paid_listings_with_query( $query );
        } else if ( $filters['show_incomplete'] ) {
            $this->total_items = $listings->count_listings_with_query( $query );
            $this->items = $listings->find_listings_with_query( $query );
        } else {
            $this->total_items = $listings->count_valid_listings_with_query( $query );
            $this->items = $listings->find_valid_listings_with_query( $query );
        }

        $this->set_pagination_args( array( 'total_items' => $this->total_items, 'per_page' => $this->items_per_page ) );
    }

    public function has_items() {
        return count($this->items) > 0;
    }

    public function get_columns() {
        $columns = array();

        $columns['cb'] = '<input type="checkbox" />';
        $columns['title'] = __( 'Title', 'another-wordpress-classifieds-plugin' );

        if ( awpcp_current_user_is_admin() ) {
            $columns['access_key'] = __( 'Access Key', 'another-wordpress-classifieds-plugin' );
        }

        $columns['start_date'] = __('Start Date', 'another-wordpress-classifieds-plugin');
        $columns['end_date'] = __('End Date', 'another-wordpress-classifieds-plugin');
        $columns['renewed_date'] = __('Renewed Date', 'another-wordpress-classifieds-plugin');
        $columns['status'] = __('Status', 'another-wordpress-classifieds-plugin');
        $columns['payment_term'] = __('Payment Term', 'another-wordpress-classifieds-plugin');
        $columns['payment_status'] = __('Payment Status', 'another-wordpress-classifieds-plugin');

        if ( defined( 'AWPCP_FEATURED_ADS_MODULE' ) ) {
            $columns['featured'] = __( 'Featured', 'another-wordpress-classifieds-plugin' );
        }

        if ( awpcp_current_user_is_moderator() ) {
            $columns['owner'] = __('Owner', 'another-wordpress-classifieds-plugin');
        }

        return $columns;
    }

    public function get_sortable_columns() {
        return array(
            'title' => array('title', true),
            'start_date' => array('start-date', true),
            'end_date' => array('end-date', true),
            'renewed_date' => array('renewed-date', true),
            'status' => array('status', true),
            'payment_term' => array('payment-term', true),
            'payment_status' => array('payment-status', true),
            'featured_ad' => array('featured-ad', true),
            'owner' => array('owner', true)
        );
    }

    public function get_bulk_actions() {
        $actions = array();
        if ( awpcp_current_user_is_admin() ) {
            $actions = array(
                'bulk-enable' => __( 'Enable', 'another-wordpress-classifieds-plugin' ),
                'bulk-disable' => __( 'Disable', 'another-wordpress-classifieds-plugin' ),
                'bulk-renew' => __( 'Renew', 'another-wordpress-classifieds-plugin' ),
                'bulk-spam' => __( 'Mark as SPAM', 'another-wordpress-classifieds-plugin' )
            );

            if ( function_exists( 'awpcp_featured_ads' ) ) {
                $actions['bulk-make-featured'] = __( 'Make Featured', 'another-wordpress-classifieds-plugin' );
                $actions['bulk-remove-featured'] = __( 'Make Non Featured', 'another-wordpress-classifieds-plugin' );
            }

            if ( $this->facebook_integration->is_facebook_page_integration_configured() || $this->facebook_integration->is_facebook_group_integration_configured() ) {
                $actions['bulk-send-to-facebook'] = __( 'Send to Facebook', 'another-wordpress-classifieds-plugin' );
            }
        }

        $actions['bulk-delete'] = __( 'Delete', 'another-wordpress-classifieds-plugin' );

        return $actions;
    }

    public function get_views() {
        $filters = array(
            'new' => 'new',
            'expired' => 'expired',
            'awaiting-approval' => 'awaiting-approval',
            'images-awaiting-approval' => 'images-awaiting-approval',
            'is-featured' => 'featured-ads',
            'flagged' => 'flagged-ads',
            'incomplete' => 'incomplete-listings',
            'non-verified' => 'non-verified-ads',
            'completed' => 'completed',
        );

        $selected = awpcp_array_data($this->params['filterby'], 'completed', $filters);

        $views = array(
            'new' => array( __( 'New', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'new', 'filter' => true ) ) ),
            'expired' => array( __( 'Expired', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'expired', 'filter' => true ) ) ),
        );

        if ( awpcp_current_user_is_moderator() ) {
            $views['awaiting-approval'] = array(
                __( 'Ads Awaiting Approval', 'another-wordpress-classifieds-plugin' ),
                $this->page->url( array( 'filterby' => 'awaiting-approval', 'filter' => true ) )
            );
            $views['images-awaiting-approval'] = array(
                __( 'Images Awaiting Approval', 'another-wordpress-classifieds-plugin' ),
                $this->page->url( array( 'filterby' => 'images-awaiting-approval', 'filter' => true ) )
            );
        }

        $views['featured-ads'] = array( __( 'Featured', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'is-featured', 'filter' => true ) ) );
        $views['flagged-ads'] = array( __( 'Flagged', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'flagged', 'filter' => true ) ) );
        $views['incomplete-listings'] = array( __( 'Incomplete', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'incomplete', 'filter' => true ) ) );
        $views['non-verified-ads'] = array( __( 'Unverified', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'non-verified', 'filter' => true ) ) );
        $views['completed'] = array( __( 'Completed', 'another-wordpress-classifieds-plugin' ), $this->page->url( array( 'filterby' => 'completed', 'filter' => false ) ) );

        return $this->page->links($views, $selected);
    }

    public function get_search_by_box() {
        if ( empty( $_REQUEST['s'] ) && !$this->has_items() )
            return;

        $id = 'search-by';
        $label = __('Search by', 'another-wordpress-classifieds-plugin');

        $options['id'] = __('Ad ID', 'another-wordpress-classifieds-plugin');
        $options['title'] = __('Ad Title', 'another-wordpress-classifieds-plugin');
        $options['keyword'] = __('Keyword', 'another-wordpress-classifieds-plugin');
        $options['location'] = __('Location', 'another-wordpress-classifieds-plugin');
        $options['phone'] = __( 'Phone', 'another-wordpress-classifieds-plugin' );

        if ( awpcp_current_user_is_admin() ) {
            $options['payer-email'] = __('Payer Email', 'another-wordpress-classifieds-plugin');
        }

        $options['ad-contact-email'] = __( 'Ad Contact Email', 'another-wordpress-classifieds-plugin' );
        $options['user'] = __('User', 'another-wordpress-classifieds-plugin');

        $search_by = awpcp_request_param('search-by', 'title');

        $html = '<p class="search-by-box">';
        $html.= '<label>' . $label . ':</label>&nbsp;&nbsp;';
        $html.= '<select name="search-by">';

        foreach ($options as $value => $text) {
            $selected = $search_by == $value ? 'selected="selected"' : '';
            $html.= '<option id="search-by-' . $value . '" ' . $selected . ' value="' . $value . '" />';
            $html.= $text;
            $html.= '</option>';
        }

        $html.= '</select>';
        $html.= '</p>';

        echo $html;
    }

    public function extra_tablenav( $which ) {
        if ( $which == 'top' ) {
            echo $this->render_category_filter();
        }
        echo $this->render_items_per_page_selector();
    }

    /**
     * @since 3.3
     */
    private function render_category_filter() {
        $category_selector = awpcp_categories_dropdown()->render( array(
            'context' => 'search',
            'name' => 'category',
            'label' => false,
            'selected' => $this->selected_category_id,
            'required' => false,
        ) );

        $submit_button = '<input class="button" type="submit" value="%s">';
        $submit_button = sprintf( $submit_button, esc_attr( _x( 'Filter', 'admin listings table', 'another-wordpress-classifieds-plugin' ) ) );

        $template = '<div class="alignleft actions awpcp-category-filter"><category-selector><submit-button></div>';
        $template = str_replace( '<category-selector>', $category_selector, $template );
        $template = str_replace( '<submit-button>', $submit_button, $template );

        return $template;
    }

    /**
     * TODO: use a single pagination form, check create_pager function in dcfunctions.php
     */
    private function render_items_per_page_selector() {
        $template = '<option %3$s value="%1$s">%2$s</option>';
        $selected = 'selected="selected"';

        foreach ( awpcp_pagination_options( $this->items_per_page ) as $value ) {
            $attributes = $value == $this->items_per_page ? $selected : '';
            $options[] = sprintf( $template, esc_attr( $value ), esc_html( $value ), $attributes );
        }

        $output = '<div class="tablenav-pages"><select name="items-per-page"><options></select></div>';
        $output = str_replace( '<options>', implode( '', $options ), $output );

        return $output;
    }

    private function get_row_actions($item) {
        $actions = $this->page->actions($item);
        return $this->page->links($actions);
    }

    public function column_default($item, $column_name) {
        return '...';
    }

    public function column_cb($item) {
        return '<input type="checkbox" value="' . $item->ad_id . '" name="selected[]" />';
    }

    public function column_title($item) {
        $content = sprintf(
            '<a class="awpcp-admin-listings-table-listing-title" title="%3$s" href="%2$s">%1$s</a>',
            $item->get_title(),
            $this->page->url( array( 'action' => 'view', 'id' => $item->ad_id ) ),
            __( 'View Ad.', 'another-wordpress-classifieds-plugin' )
        );

        return $content . $this->row_actions( $this->get_row_actions( $item ), true );
    }

    public function column_access_key($item) {
        return $item->get_access_key();
    }

    public function column_start_date($item) {
        return $item->get_start_date();
    }

    public function column_end_date($item) {
        return $item->get_end_date();
    }

    public function column_renewed_date($item) {
        $renewed_date = $item->get_renewed_date();
        return empty( $renewed_date ) ? '--' : $renewed_date;
    }

    public function column_status($item) {
        $actions = array();

        if ( $item->verified == 0 ) {
            $url = $this->page->url( array( 'action' => 'mark-verified', 'id' => $item->ad_id ) );
            $actions['mark-verified'] = array( __( 'Mark as Verified', 'another-wordpress-classifieds-plugin' ), $url );
        }

        if ( ! empty( $actions ) ) {
            $actions = $this->row_actions( $this->page->links( $actions ), true );
        } else {
            $actions = '';
        }

        $status = $item->disabled ? __( 'Disabled', 'another-wordpress-classifieds-plugin' ) : __( 'Enabled', 'another-wordpress-classifieds-plugin' );

        return $status . $actions;
    }

    public function column_payment_term($item) {
        return $item->get_payment_term_name();
    }

    public function column_payment_status($item) {
        $actions = array();

        if ($item->payment_status == 'Unpaid') {
            $url = $this->page->url(array('action' => 'mark-paid', 'id' => $item->ad_id));
            $actions['mark-paid'] = array( __( 'Mark as Paid', 'another-wordpress-classifieds-plugin' ), $url );
        }

        if ( ! empty( $actions ) ) {
            $actions = $this->row_actions( $this->page->links( $actions ), true );
        } else {
            $actions = '';
        }

        return $item->get_payment_status() . $actions;
    }

    public function column_featured($item) {
        return $item->is_featured_ad ? __('Featured', 'another-wordpress-classifieds-plugin') : __('Not Featured', 'another-wordpress-classifieds-plugin');
    }

    public function column_owner($item) {
        $user = get_userdata($item->user_id);
        return is_object($user) ? $user->user_login : '-';
    }

    public function single_row($item) {
        static $row_class = '';
        $row_class = ( $row_class == '' ? ' class="alternate"' : '' );

        echo '<tr id="awpcp-ad-' . $item->ad_id . '" data-id="' . $item->ad_id . '"' . $row_class . '>';
        echo $this->single_row_columns( $item );
        echo '</tr>';
    }
}