classes/class-scpo-engine.php from lightspeeddevelopment/lsx-health-plan

classes/class-scpo-engine.php
Summary

Maintainability

2 hrs
Test Coverage

Issues
<?php
 
namespace lsx_health_plan\classes;
 
class SCPO_Engine {
 
    /**
     * Holds class instance
     *
     * @since 1.0.0
     *
     * @var      object \lsx_health_plan\classes\SCPO_Engine()
     */
    protected static $instance = null;
 
    /**
     * Return an instance of this class.
     *
     * @since 1.0.0
     *
     * @return    object \lsx_health_plan\classes\SCPO_Engine()    A single instance of this class.
     */
    public static function get_instance() {
        // If the single instance hasn't been set, set it now.
        if ( null == self::$instance ) {
            self::$instance = new self;
        }
        return self::$instance;
    }
 
    public function __construct() {
        if ( ! get_option( 'lsx_to_scporder_install' ) ) {
            $this->lsx_to_scporder_install();
        }
 
        add_action( 'admin_init', array( $this, 'refresh' ) );
        add_action( 'admin_init', array( $this, 'load_script_css' ) );
 
        add_action( 'wp_ajax_update-menu-order', array(
            $this,
            'update_menu_order',
        ) );
        add_action( 'wp_ajax_update-menu-order-tags', array(
            $this,
            'update_menu_order_tags',
        ) );
 
        add_action( 'pre_get_posts', array(
            $this,
            'lsx_to_scporder_pre_get_posts',
        ) );
 
        add_filter( 'get_previous_post_where', array(
            $this,
            'lsx_to_scporder_previous_post_where',
        ) );
        add_filter( 'get_previous_post_sort', array(
            $this,
            'lsx_to_scporder_previous_post_sort',
        ) );
        add_filter( 'get_next_post_where', array(
            $this,
            'lsx_to_scporder_next_post_where',
        ) );
        add_filter( 'get_next_post_sort', array(
            $this,
            'lsx_to_scporder_next_post_sort',
        ) );
 
        add_filter( 'get_terms_orderby', array(
            $this,
            'lsx_to_scporder_get_terms_orderby',
        ), 10, 3 );
        add_filter( 'wp_get_object_terms', array(
            $this,
            'lsx_to_scporder_get_object_terms',
        ), 10, 4 );
        add_filter( 'get_terms', array(
            $this,
            'lsx_to_scporder_get_object_terms',
        ), 10, 4 );
    }
 
    public function lsx_to_scporder_install() {
        global $wpdb;
        $result = $wpdb->query( "DESCRIBE $wpdb->terms `lsx_to_term_order`" );
 
        if ( ! $result ) {
            $result = $wpdb->query( "ALTER TABLE $wpdb->terms ADD `lsx_to_term_order` INT(4) NULL DEFAULT '0'" );
        }
 
        update_option( 'lsx_to_scporder_install', 1 );
    }
 
    public function _check_load_script_css() {
        $active = false;
 
        $objects = $this->get_to_scporder_options_objects();
        $tags    = $this->get_to_scporder_options_tags();
 
        if ( empty( $objects ) && empty( $tags ) ) {
            return false;
        }
 
        if ( isset( $_GET['orderby'] ) || strstr( sanitize_text_field( $_SERVER['REQUEST_URI'] ), 'action=edit' ) || strstr( sanitize_text_field( $_SERVER['REQUEST_URI'] ), 'wp-admin/post-new.php' ) ) {
            return false;
        }
 
        if ( ! empty( $objects ) ) {
            if ( isset( $_GET['post_type'] ) && ! isset( $_GET['taxonomy'] ) && array_key_exists( sanitize_text_field( $_GET['post_type'] ), $objects ) ) { // if page or custom post types
                $active = true;
            }
            if ( ! isset( $_GET['post_type'] ) && strstr( sanitize_text_field( $_SERVER['REQUEST_URI'] ), 'wp-admin/edit.php' ) && array_key_exists( 'post', $objects ) ) { // if post
                $active = true;
            }
        }
 
        if ( ! empty( $tags ) ) {
            if ( isset( $_GET['taxonomy'] ) && array_key_exists( sanitize_text_field( $_GET['taxonomy'] ), $tags ) ) {
                $active = true;
            }
        }
 
        return $active;
    }
 
    public function load_script_css() {
        if ( $this->_check_load_script_css() ) {
            wp_enqueue_script( 'scporderjs', LSX_HEALTH_PLAN_URL . '/assets/js/scporder.min.js', array( 'jquery', 'jquery-ui-sortable' ), null, true );
 
            $scporderjs_params = array(
                'ajax_url'   => admin_url( 'admin-ajax.php' ),
                'ajax_nonce' => wp_create_nonce( 'scporder' ),
            );
 
            wp_localize_script( 'scporderjs', 'scporderjs_params', $scporderjs_params );
 
            wp_enqueue_style( 'scporder', LSX_HEALTH_PLAN_URL . '/assets/css/scporder.css', array(), null );
            wp_style_add_data( 'scporder', 'rtl', 'replace' );
        }
    }
 
    public function refresh() {
        global $wpdb;
        $objects = $this->get_to_scporder_options_objects();
        $tags    = $this->get_to_scporder_options_tags();
 
        if ( ! empty( $objects ) ) {
            foreach ( $objects as $object => $object_data ) {
                $result = $wpdb->get_results( $wpdb->prepare( "
                    SELECT count(*) as cnt, max(menu_order) as max, min(menu_order) as min
                    FROM $wpdb->posts
                    WHERE post_type = '%s' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
                ", $object ) );
 
                if ( 0 == $result[0]->cnt || $result[0]->cnt == $result[0]->max ) {
                    continue;
                }
 
                $results = $wpdb->get_results( $wpdb->prepare( "
                    SELECT ID
                    FROM $wpdb->posts
                    WHERE post_type = '%s' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
                    ORDER BY menu_order ASC
                ", $object ) );
 
                foreach ( $results as $key => $result ) {
                    $wpdb->update(
                        $wpdb->posts,
                        array(
                            'menu_order' => $key + 1,
                        ),
                        array(
                            'ID' => $result->ID,
                        )
                    );
                }
            }
        }
 
        if ( ! empty( $tags ) ) {
            foreach ( $tags as $taxonomy => $taxonomy_data ) {
                $result = $wpdb->get_results( $wpdb->prepare( "
                    SELECT count(*) as cnt, max(lsx_to_term_order) as max, min(lsx_to_term_order) as min
                    FROM $wpdb->terms AS terms
                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
                    WHERE term_taxonomy.taxonomy = '%s'
                ", $taxonomy ) );
 
                if ( 0 == $result[0]->cnt || $result[0]->cnt == $result[0]->max ) {
                    continue;
                }
 
                $results = $wpdb->get_results( $wpdb->prepare( "
                    SELECT terms.term_id
                    FROM $wpdb->terms AS terms
                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
                    WHERE term_taxonomy.taxonomy = '%s'
                    ORDER BY lsx_to_term_order ASC
                ", $taxonomy ) );
 
                foreach ( $results as $key => $result ) {
                    $wpdb->update(
                        $wpdb->terms,
                        array(
                            'lsx_to_term_order' => $key + 1,
                        ),
                        array(
                            'term_id' => $result->term_id,
                        )
                    );
                }
            }
        }
    }
 
    public function update_menu_order() {
        check_ajax_referer( 'scporder', 'security' );
 
        global $wpdb;
 
        parse_str( sanitize_text_field( $_POST['order'] ), $data );
 
        if ( ! is_array( $data ) ) {
            return false;
        }
 
        /*$id_arr = array();
 
        foreach ( $data as $key => $values ) {
            foreach ( $values as $position => $id ) {
                $id_arr[] = $id;
            }
        }
 
        $menu_order_arr = array();
 
        foreach ( $id_arr as $key => $id ) {
            $results = $wpdb->get_results( "SELECT menu_order FROM $wpdb->posts WHERE ID = " . intval( $id ) );
            foreach ( $results as $result ) {
                $menu_order_arr[] = $result->menu_order;
            }
        }
 
        sort( $menu_order_arr );*/
 
        foreach ( $data as $key => $values ) {
            foreach ( $values as $position => $id ) {
                $wpdb->update(
                    $wpdb->posts,
                    array(
                        'menu_order' => $position,
                    ),
                    array(
                        'ID' => intval( $id ),
                    )
                );
            }
        }
    }
 
    public function update_menu_order_tags() {
        check_ajax_referer( 'scporder', 'security' );
 
        global $wpdb;
 
        parse_str( sanitize_text_field( $_POST['order'] ), $data );
 
        if ( ! is_array( $data ) ) {
            return false;
        }
 
        /*$current_user = wp_get_current_user();
        if ( false === $current_user || 'lightspeed' !== $current_user->data->user_login ) {
            return false;
        }*/
 
        /*$id_arr = array();
 
        foreach ( $data as $key => $values ) {
            foreach ( $values as $position => $id ) {
                $id_arr[] = $id;
            }
        }
 
        $menu_order_arr = array();
 
        foreach ( $id_arr as $key => $id ) {
            $results = $wpdb->get_results( "SELECT lsx_to_term_order FROM $wpdb->terms WHERE term_id = " . intval( $id ) );
            foreach ( $results as $result ) {
                $menu_order_arr[] = $result->lsx_to_term_order;
            }
        }
 
        sort( $menu_order_arr );*/
 
        foreach ( $data as $key => $values ) {
            $term_ids = array();
            foreach ( $values as $position => $id ) {
                $wpdb->update(
                    $wpdb->terms,
                    array(
                        'lsx_to_term_order' => $position + 1,
                    ),
                    array(
                        'term_id' => intval( $id ),
                    )
                );
                $term_ids[] = intval( $id );
            }
            clean_term_cache( $term_ids );
        }
    }
 
    public function lsx_to_scporder_previous_post_where( $where ) {
        global $post;
        $objects = $this->get_to_scporder_options_objects();
 
        if ( empty( $objects ) ) {
            return $where;
        }
 
        if ( isset( $post->post_type ) && array_key_exists( $post->post_type, $objects ) ) {
            $current_menu_order = $post->menu_order;
            $where              = "WHERE p.menu_order > '" . $current_menu_order . "' AND p.post_type = '" . $post->post_type . "' AND p.post_status = 'publish'";
        }
 
        return $where;
    }
 
    public function lsx_to_scporder_previous_post_sort( $orderby ) {
        global $post;
        $objects = $this->get_to_scporder_options_objects();
 
        if ( empty( $objects ) ) {
            return $orderby;
        }
 
        if ( isset( $post->post_type ) && array_key_exists( $post->post_type, $objects ) ) {
            $orderby = 'ORDER BY p.menu_order ASC LIMIT 1';
        }
 
        return $orderby;
    }
 
    public function lsx_to_scporder_next_post_where( $where ) {
        global $post;
        $objects = $this->get_to_scporder_options_objects();
 
        if ( empty( $objects ) ) {
            return $where;
        }
 
        if ( isset( $post->post_type ) && array_key_exists( $post->post_type, $objects ) ) {
            $current_menu_order = $post->menu_order;
            $where              = "WHERE p.menu_order < '" . $current_menu_order . "' AND p.post_type = '" . $post->post_type . "' AND p.post_status = 'publish'";
        }
 
        return $where;
    }
 
    public function lsx_to_scporder_next_post_sort( $orderby ) {
        global $post;
        $objects = $this->get_to_scporder_options_objects();
 
        if ( empty( $objects ) ) {
            return $orderby;
        }
 
        if ( isset( $post->post_type ) && array_key_exists( $post->post_type, $objects ) ) {
            $orderby = 'ORDER BY p.menu_order DESC LIMIT 1';
        }
 
        return $orderby;
    }
 
Function `lsx_to_scporder_pre_get_posts` has a Cognitive Complexity of 41 (exceeds 25 allowed). Consider refactoring.
    public function lsx_to_scporder_pre_get_posts( $wp_query ) {
        $objects = $this->get_to_scporder_options_objects();
 
        if ( empty( $objects ) ) {
            return false;
        }
 
        if ( is_array( $wp_query->query['post_type'] ) ) {
            if ( isset( $wp_query->query['post_type'][0] ) ) {
                $post_type = $wp_query->query['post_type'][0];
            } else {
                $post_type = implode( '', $wp_query->query['post_type'] );
            }
        }
 
        if ( is_admin() ) {
            if ( isset( $wp_query->query['post_type'] ) && ! isset( $_GET['orderby'] ) ) {
                if ( array_key_exists( $post_type, $objects ) ) {
                    $wp_query->set( 'orderby', 'menu_order' );
                    $wp_query->set( 'order', 'ASC' );
                }
            }
        } else {
            $active = false;
 
            if ( isset( $wp_query->query['post_type'] ) ) {
                if ( array_key_exists( $post_type, $objects ) ) {
                    $active = true;
                }
            } else {
                if ( array_key_exists( 'post', $objects ) ) {
                    $active = true;
                }
            }
 
            if ( ! $active ) {
                return false;
            }
 
            if ( isset( $wp_query->query['disabled_custom_post_order'] ) ) {
                return false;
            }
 
            if ( isset( $wp_query->query['suppress_filters'] ) ) {
                if ( $wp_query->get( 'orderby' ) == 'date' ) {
                    $wp_query->set( 'orderby', 'menu_order' );
                }
                if ( $wp_query->get( 'order' ) == 'DESC' ) {
                    $wp_query->set( 'order', 'ASC' );
                }
            } else {
                if ( ! $wp_query->get( 'orderby' ) ) {
                    $wp_query->set( 'orderby', 'menu_order' );
                }
                if ( ! $wp_query->get( 'order' ) ) {
                    $wp_query->set( 'order', 'ASC' );
                }
            }
        }
    }
 
    public function lsx_to_scporder_get_terms_orderby( $orderby, $args ) {
 
        if ( is_admin() ) {
            return $orderby;
        }
 
        if ( isset( $args['disabled_custom_post_order'] ) ) {
            return $orderby;
        }
 
        $tags = $this->get_to_scporder_options_tags();
 
        if ( ! isset( $args['taxonomy'] ) ) {
            return $orderby;
        }
 
        $taxonomy = $args['taxonomy'];
        if ( is_array( $taxonomy ) && count( $taxonomy ) == 1 ) {
            $taxonomy = $taxonomy[0];
        }
        if ( ! is_array( $taxonomy ) && ! array_key_exists( $taxonomy, $tags ) ) {
            return $orderby;
        }
 
        $orderby = 't.lsx_to_term_order';
 
        return $orderby;
    }
 
    public function lsx_to_scporder_get_object_terms( $terms, $not_used, $args_1, $args_2 = null ) {
        $tags = $this->get_to_scporder_options_tags();
 
        if ( is_admin() && isset( $_GET['orderby'] ) ) {
            return $terms;
        }
 
        $args = is_null( $args_2 ) || ! is_array( $args_2 ) ? $args_1 : $args_2;
 
        if ( isset( $args['disabled_custom_post_order'] ) ) {
            return $terms;
        }
 
        foreach ( $terms as $key => $term ) {
            if ( is_object( $term ) && isset( $term->taxonomy ) ) {
                $taxonomy = $term->taxonomy;
                if ( ! array_key_exists( $taxonomy, $tags ) ) {
                    return $terms;
                }
            } else {
                return $terms;
            }
        }
        usort( $terms, array( $this, 'taxcmp' ) );
        return $terms;
    }
 
    public function taxcmp( $a, $b ) {
        if ( $a->lsx_to_term_order == $b->lsx_to_term_order ) {
            return 0;
        }
        return ( $a->lsx_to_term_order < $b->lsx_to_term_order ) ? - 1 : 1;
    }
 
    public function get_to_scporder_options_objects() {
        $ordering = array(
            'plan' => 'plan',
        );
        return $ordering;
    }
 
    public function get_to_scporder_options_tags() {
        $ordering = array(
            'week' => 'week',
            'recipe-type' => 'recipe-type',
        );
        return $ordering;
    }
}