<?
/**
 * Plugin Name: Ajax поиск
 * Author URI:  https://t.me/devnullik
 * Author:      under water
 * Version:     1.0
 *
 * Requires at least: 2.5
 * Requires PHP: 7.2
 *
 * License:     GPL2
 * License URI: https://www.gnu.org/licenses/gpl-2.0.html
**/


class AjaxSearch
{
    public function __construct()
    {
        add_action('init', [$this, 'init']);
        add_action('add_meta_boxes', array($this, 'addMetaBox'));
        add_action('save_post', array($this, 'savePost'), 10, 3);
        add_action('wp_enqueue_scripts', array($this, 'enqueueScripts'));

        add_shortcode('edit-currencies', [$this, 'editCurrencies']);
        add_shortcode('ajax-search-variations', [$this, 'ajaxSearchVariations']);
        add_shortcode('ajax-search-variation-active', [$this, 'ajaxSearchVariationActive']);
	}


    public function init()
    {
        register_post_type('search-variations', [
            'label'  => null,
            'labels' => [
                'name'               => 'Вариации поиска',
                'singular_name'      => 'Вариации поиска',
                'add_new'            => 'Добавить',
                'add_new_item'       => 'Добавить',
                'edit_item'          => 'Редактировать',
                'new_item'           => 'Вариации поиска',
                'view_item'          => 'Просмотреть',
                'search_items'       => 'Поиск',
                'not_found'          => 'Не найдено',
                'not_found_in_trash' => 'Не найдено',
                'parent_item_colon'  => '',
                'menu_name'          => 'Вариации поиска',
            ],
            'description'         => '',
            'menu_icon'           => 'dashicons-media-document',
            'publicly_queryable'  => false,
            'public'              => true,
            'exclude_from_search' => null,
            'show_ui'             => true,
            'show_in_nav_menus'   => false,
            'show_in_menu'        => true,
            'rest_base'           => null,
            'menu_position'       => 49,
            'hierarchical'        => true,
            'supports'            => ['title'],
            'show_in_rest'        => true,
            'taxonomies'          => [],
            'has_archive'         => true,
            'rewrite'             => true,
            'query_var'           => true
        ]);
        
        register_post_type('currencies', [
            'label'  => null,
            'labels' => [
                'name'               => 'Валюты',
                'singular_name'      => 'Валюты',
                'add_new'            => 'Добавить',
                'add_new_item'       => 'Добавить',
                'edit_item'          => 'Редактировать',
                'new_item'           => 'Валюты',
                'view_item'          => 'Просмотреть',
                'search_items'       => 'Поиск',
                'not_found'          => 'Не найдено',
                'not_found_in_trash' => 'Не найдено',
                'parent_item_colon'  => '',
                'menu_name'          => 'Валюты',
            ],
            'description'         => '',
            'menu_icon'           => 'dashicons-money-alt',
            'publicly_queryable'  => false,
            'public'              => true,
            'exclude_from_search' => null,
            'show_ui'             => true,
            'show_in_nav_menus'   => false,
            'show_in_menu'        => true,
            'rest_base'           => null,
            'menu_position'       => 49,
            'hierarchical'        => true,
            'supports'            => ['title'],
            'show_in_rest'        => true,
            'taxonomies'          => [],
            'has_archive'         => true,
            'rewrite'             => true,
            'query_var'           => true
        ]);
    }

    public function enqueueScripts()
    {
        $directory = plugins_url().'/ajax-search/';

        wp_enqueue_style("AjaxSearch-style", "{$directory}assets/style.css");
        wp_enqueue_script("AjaxSearch-cookie", "{$directory}assets/cookie.js", ['jquery'], null, true);
        wp_enqueue_script("AjaxSearch-script", "{$directory}assets/script.js", ['AjaxSearch-cookie'], null, true);


        global $wpdb;

        $ress = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}postmeta WHERE meta_key = 'estate-price-object' AND meta_value != ''");
        $curs = $arr = [];

        $currencies = get_posts([
            'numberposts' => -1,
            'post_status' => 'publish',
            'post_type'   => 'currencies'
        ]);

        foreach( $currencies as $cur ){
            $curs[$cur->ID] = get_post_meta($cur->ID, '_currencies_course', true)*1;
        }

        foreach( $ress as $res ){
            $prc = $res->meta_value*1;
            $arr[$res->post_id] = [0 => $prc];

            foreach( $curs as $id => $cur ){
                $arr[$res->post_id][$id] = $cur * $prc;
            }
        }

        wp_localize_script("AjaxSearch-script", 'currencies', $arr);
    }

    public function addMetaBox()
    {
        add_meta_box("AjaxSearch-box", 'AjaxSearch', [$this, 'metaBox'], 'search-variations', 'normal', 'high');
        add_meta_box("AjaxSearch-box", 'AjaxSearch', [$this, 'metaBoxСurrencies'], 'currencies', 'normal', 'high');
    }

    public function savePost( $ID = null, $post = null, $update = null )
    {
        if( isset($_POST['AjaxSearch']) && is_array($_POST['AjaxSearch']) && $post ){
            foreach( $_POST['AjaxSearch'] as $key => $val ){
                update_post_meta($post->ID, $key, $val);
            }
        }
    }


    public function metaBox()
    {
        $postID = $_GET['post'];

        include __DIR__ . '/meta-box.php';
    }

    public function metaBoxСurrencies()
    {
        $postID = $_GET['post'];

        include __DIR__ . '/currencies.php';
    }


    public function ajaxSearchVariations()
    {
        echo '
            <div class="ajax-search-variations">
                <input type="text" name="ajax-search-variations" placeholder="Поиск">
                '.static::getVariations().'
            </div>
        ';
    }

    public function ajaxSearchVariationActive()
    {
        echo '<div class="ajax-search-variation-active"></div>';
    }

    public function editCurrencies()
    {
        $ul = '';
        $posts = get_posts([
            'numberposts' => -1,
            'post_status' => 'publish',
            'post_type'   => 'currencies'
        ]);

        foreach( $posts as $post ){
            $ul .= '
                <li>
                    <input name="currencies" type="radio" value="'.$post->ID.'" data-course="'.get_post_meta($post->ID, '_currencies_course', true).'" data-sign="'.get_post_meta($post->ID, '_currencies_sign', true).'" data-text="'.get_post_meta($post->ID, '_currencies_title', true).' / '.get_post_meta($post->ID, '_currencies_sign', true).'">
                    <span>'.$post->post_title.'</span>
                </li>
            ';
        }

        echo '
            <div id="editCurrencies">
                <p>
                    <span>USD / $</span>
                    <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"><path fill="none" stroke="black" stroke-linecap="round" stroke-linejoin="round" d="m7 10l5 5l5-5"/></svg>
                </p>
                <ul>
                    <li>
                        <input name="currencies" type="radio" value="0" data-sign="$" data-course="1" data-text="USD / $">
                        <span>Доллар</span>
                    </li>
                    '.$ul.'
                </ul>
            </div>
        ';
    }


    static function getVariations()
    {
        require_once __DIR__ . '/vendor/phpExcelReader/Excel/reader.php';  

        $variations = [];
        $html = '';

        $upload = wp_upload_dir();
        $posts = get_posts([
            'numberposts' => -1,
            'post_status' => 'publish',
            'post_type'   => 'search-variations'
        ]);

        if( is_array($posts) ){
            foreach( $posts as $post ){
                $variations[$post->ID] = [
                    'name'  => get_post_meta($post->ID, '_variation_meta', true),
                    'icon'  => get_post_meta($post->ID, '_variation_svg', true),
                    'title' => $post->post_title,
                    'vars'  => []
                ];

                $sht = get_post_meta($post->ID, '_variation_sht', true);
                $fileID = get_post_meta($post->ID, '_variation_file', true);
                $attached = get_post_meta($fileID, '_wp_attached_file', true);
            
                $_key = get_post_meta($post->ID, '_variation_key', true);
                $_val = get_post_meta($post->ID, '_variation_val', true);

                if( is_readable($upload['basedir'].'/'.$attached) && isset($sht) && $sht*1 > -1 && isset($fileID) && $fileID*1 > -1 ){
                    $data = new Spreadsheet_Excel_Reader();
                    $data->setOutputEncoding('UTF-8');
            
                    $data->read($upload['basedir'].'/'.$attached);
                    $sheet = $data->sheets[$sht]['cells'];
                    $key = 0;
            
                    foreach( $sheet as $cols ){
                        if( $key > 0 ){
                            $variations[$post->ID]['vars'][$cols[$_key]][] = $cols[$_val];
                        }
            
                        $key++;
                    }
                }
            }
        }

        foreach( $variations as $item ){
            $ul = "<p data-name=\"{$item['name']}\">{$item['icon']}<span>{$item['title']}</span></p>";

            if( count($item['vars']) > 0 ){
                $i = 0;

                foreach( $item['vars'] as $val => $vars ){
                    $vars[] = $val;
                    $ul .= "<li data-id=\"$i\" data-search=\"".mb_strtolower(implode(' | ', $vars))."\">$val</li>";
                    $i++;
                }
            }

            $html .= "<ul>$ul</ul>";
        }

        return "<div><span>$html</span></div>";
    }

    static function getSelectUl( $acfID )
    {
        global $wpdb;

        $postID = $wpdb->get_var("SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_key = '_variation_acf' AND meta_value = '$acfID'");
        $post = get_post($postID);
        $html = $active = '';

        if( $postID && !empty($postID) && $post ){
            require_once __DIR__ . '/vendor/phpExcelReader/Excel/reader.php';  
    
            $vars = [];
            $upload = wp_upload_dir();

            $sht = get_post_meta($post->ID, '_variation_sht', true);
            $_key = get_post_meta($post->ID, '_variation_key', true);
            $_val = get_post_meta($post->ID, '_variation_val', true);
            $name = get_post_meta($post->ID, '_variation_meta', true);
            $fileID = get_post_meta($post->ID, '_variation_file', true);
            $attached = get_post_meta($fileID, '_wp_attached_file', true);

            if( is_readable($upload['basedir'].'/'.$attached) && isset($sht) && $sht*1 > -1 && isset($fileID) && $fileID*1 > -1 ){
                $data = new Spreadsheet_Excel_Reader();
                $data->setOutputEncoding('UTF-8');
        
                $data->read($upload['basedir'].'/'.$attached);
                $sheet = $data->sheets[$sht]['cells'];
                $key = 0;
        
                foreach( $sheet as $cols ){
                    if( $key > 0 ){
                        $vars[$cols[$_key]][] = $cols[$_val];
                    }
        
                    $key++;
                }

                if( count($vars) > 0 ){
                    $k = 0;

                    foreach( $vars as $val => $arr ){
                        $arr[] = $val;
                        $check = '';

                        if( $k == 0 ){
                            $check = ' checked';
                            $active = $val;
                        }

                        $html .= '<li data-search="'.mb_strtolower(implode(' | ', $arr)).'"><input type="radio" name="_variation_'.$name.'_'.$post->ID.'" class="'.$name.'-input"'.$check.' value="'.$val.'"><span>'.$val.'</span></li>';
                        $k++;
                    }
                }
            }
        }

        if( !empty($html) ){
            $html = '
                <div class="formControlSelect">
                    <p class="form-control">
                        <span>'.$active.'</span>
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
                            <path fill="none" stroke="black" stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="m7 10l5 5l5-5"/>
                        </svg>
                    </p>
                    <ul><input type="text" placeholder="Поиск..">'.$html.'</ul>
                </div>
                <style>
                    .formControlSelect ul > input {
                        width: 100%;
                        font-size: 16px;
                        transition: .35s;
                        padding: 13px 22px;
                        padding-right: 10px;
                        border: 0!important;
                        margin-bottom: 10px;
                        outline: none!important;
                        font-family: "Manrope", Sans-serif;
                        background-color: rgb(221 221 221 / 75%)!important;
                        box-shadow: 0 0 4px rgba(0, 0, 0, .07)!important;
                    }
                    
                    .formControlSelect ul > input:focus {
                        border: 0!important;
                        outline: none!important;
                        background-color: #ced4da!important;
                        box-shadow: 0 0 4px rgba(0, 0, 0, .07)!important;
                    }

                    .formControlSelect .form-control {
                        display: flex;
                        cursor: pointer;
                        align-items: center;
                        justify-content: space-between;
                    }
                    
                    .formControlSelect .form-control svg {
                        transition: .35s;
                    }
                    
                    .formControlSelect.active .form-control svg {
                        transform: rotate(180deg);
                    }
                    
                    .formControlSelect .form-control *[stroke="black"] {
                        stroke: #495057;
                    }
                    
                    .formControlSelect .form-control *[fill="black"] {
                        fill: #495057;
                    }
                    
                    .formControlSelect {
                        position: relative;
                    }
                    
                    .formControlSelect ul {
                        margin: 0;
                        top: 100%;
                        left: 0px;
                        right: 0px;
                        opacity: 0;
                        z-index: 99;
                        overflow: hidden;
                        list-style: none;
                        transition: .35s;
                        margin-top: 10px;
                        background: #fff;
                        overflow-y: auto;
                        max-height: 262px;
                        position: absolute;
                        visibility: hidden;
                        border-radius: 10px;
                        padding-bottom: 9px;
                        padding-bottom: 10px;
                        border: 1px solid #f3f3f3;
                        box-shadow: 0 6px 16px rgba(0, 0, 0, .07);
                    }
                    
                    .formControlSelect.active ul {
                        opacity: 1;
                        visibility: visible;
                    }

                    .formControlSelect ul::-webkit-scrollbar {
                        width: 3px;
                    }
                    
                    .formControlSelect ul::-webkit-scrollbar-track {
                        background: #fff;
                    }
                    
                    .formControlSelect ul::-webkit-scrollbar-thumb {
                        border-radius: 20px;
                        background-color: #ddd;
                    }
                    
                    .formControlSelect li {
                        display: flex;
                        cursor: pointer;
                        font-size: 15px;
                        min-height: 40px;
                        transition: .35s;
                        padding: 8px 20px;
                        position: relative;
                        align-items: center;
                        letter-spacing: .5px;
                    }
                    
                    .formControlSelect li input {
                        top: 0;
                        left: 0;
                        opacity: 0;
                        width: 100%;
                        height: 100%;
                        cursor: pointer;
                        position: absolute;
                    }
                    
                    .formControlSelect li input:checked ~ span {
                        color: #61ce70;
                    }
                    
                    .formControlSelect li:hover {
                        background: #f3f3f3;
                    }
                </style>
                <script>
                    jQuery(function( $ ){
                        $(document).on(\'input\', \'.formControlSelect > ul > input\', function(){
                            var vl = $(this).val().toLowerCase(),
                                div = $(this).closest(\'.formControlSelect\');

                            if( vl.trimStart() != \'\' ){
                                div.addClass(\'active\');

                                div.find(\'li\').hide();
                                div.find(`li[data-search*="${vl}"]`).show();
                            } else {
                                div.removeClass(\'active\');
                            }
                        });

                        $(document).on(\'click\', \'.formControlSelect .form-control\', function(){
                            $(this).parent().addClass(\'active\');
                        });

                        $(document).on(\'change\', \'.formControlSelect > ul input[type="radio"]\', function(){
                            $(this).closest(\'.formControlSelect\').removeClass(\'active\');
                            $(this).closest(\'.formControlSelect\').children(\'p\').find(\'span\').text($(this).parent().text());
                        });

                        $(document).mouseup(function( e ){
                            if( !$(\'.formControlSelect > input\').is(e.target) && $(\'.formControlSelect > input\').has(e.target).length === 0 && !$(\'.formControlSelect > ul\').is(e.target) && $(\'.formControlSelect > ul\').has(e.target).length === 0 ){
                                $(\'.formControlSelect\').removeClass(\'active\');
                            }
                        });
                    });
                </script>
            ';
        }

        return $html;
    }
}

new AjaxSearch();<?xml version="1.0"?>
<oembed><version>1.0</version><provider_name>MEGARIELTOR</provider_name><provider_url>https://megarieltor.com</provider_url><author_name>admin</author_name><author_url>https://megarieltor.com/author/admin/</author_url><title>&#x413;&#x43B;&#x430;&#x432;&#x43D;&#x430;&#x44F;</title><type>rich</type><width>600</width><height>338</height><html>&lt;blockquote class="wp-embedded-content" data-secret="CfsLQMvMhl"&gt;&lt;a href="https://megarieltor.com/"&gt;&#x413;&#x43B;&#x430;&#x432;&#x43D;&#x430;&#x44F;&lt;/a&gt;&lt;/blockquote&gt;&lt;iframe sandbox="allow-scripts" security="restricted" src="https://megarieltor.com/embed/#?secret=CfsLQMvMhl" width="600" height="338" title="&#xAB;&#x413;&#x43B;&#x430;&#x432;&#x43D;&#x430;&#x44F;&#xBB; &#x2014; MEGARIELTOR" data-secret="CfsLQMvMhl" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"&gt;&lt;/iframe&gt;&lt;script&gt;
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&amp;&amp;d.addEventListener&amp;&amp;"undefined"!=typeof URL&amp;&amp;(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&amp;&amp;!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i&lt;o.length;i++)o[i].style.display="none";for(i=0;i&lt;a.length;i++)s=a[i],e.source===s.contentWindow&amp;&amp;(s.removeAttribute("style"),"height"===t.message?(1e3&lt;(r=parseInt(t.value,10))?r=1e3:~~r&lt;200&amp;&amp;(r=200),s.height=r):"link"===t.message&amp;&amp;(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&amp;&amp;n.host===r.host&amp;&amp;l.activeElement===s&amp;&amp;(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r&lt;s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
&lt;/script&gt;
</html></oembed>