<?php

class Gallery
{

    private $posts = array();

    public function __construct()
    {
        wp_register_script( 'ajax_gallery', get_template_directory_uri().'/js/gallery.min.js' );
        wp_register_script( 'blockui', get_template_directory_uri().'/js/blockui.js' );
        wp_enqueue_script('ajax_gallery');
        wp_enqueue_script('blockui');
        wp_localize_script(
            'ajax_gallery',
            'galleryAjax',
            array(
                'url'   => admin_url( 'admin-ajax.php' ),
                'sagrera' => 'actuaciones-sagrera',
                'sandreu' => 'actuaciones-sandreu',
                'videos' => 'videos'
            )
        );
        add_action('init', array(&$this, 'init_gallery'));
    }

    public function init_gallery()
    {
        add_action( 'wp_ajax_actuacions', array( &$this, 'search_actuacions' ) );
        add_action( 'wp_ajax_nopriv_actuacions', array( &$this, 'search_actuacions' ) );
        add_action( 'wp_ajax_load_gallery', array( &$this, 'reload_gallery' ) );
        add_action( 'wp_ajax_nopriv_load_gallery', array( &$this, 'reload_gallery' ) );
        add_action( 'wp_ajax_load_childrens_gallery', array( &$this, 'load_childrens_gallery' ) );
        add_action( 'wp_ajax_nopriv_load_childrens_gallery', array( &$this, 'load_childrens_gallery' ) );
    }

    public function search_actuacions()
    {
        if( isset( $_GET["type"] ) && !empty( $_GET["type"] ) )
        {
            $type = explode("-",$_GET["type"]);
            $type = sanitize_text_field($type[0]);
            $title = $_GET["title"];
            $lang = sanitize_text_field($_GET["language"]);
            new GalleryActuacionsFactory( $lang, $title, $type );
            die();
        }
    }

    public function reload_gallery()
    {
        $type = sanitize_text_field($_GET["type"]);
        $lang = sanitize_text_field($_GET["language"]) === "CA" ? "cat" : "es";

        if( $type == "videos" )
        {
            new GalleryVideoFactory( $type, $lang, null );
        }
        else
        {
            new GalleryFactory( $type, $lang, '_loadGallery', null );
        }
    }

    public function load_childrens_gallery()
    {
        $type = sanitize_text_field($_GET["type"]);
        $id = sanitize_text_field($_GET["id"]);
        $lang = sanitize_text_field($_GET["language"]) === "CA" ? "cat" : "es";

        if( $type === "videos" )
        {
            new GalleryVideoFactory( $type, $lang, $id );
        }
        else
        {
            new GalleryFactory( $type, $lang, '_loadChildrensGallery', $id );
        }

    }
}

class GalleryActuacionsFactory
{
    public function __construct( $lang, $title, $type )
    {
        global $wpdb;

        $querystr = "
            SELECT wposts.ID, wposts.post_title, wposts.post_type
            FROM $wpdb->posts wposts
            WHERE wposts.post_type = 'actuaciones-{$type}'
            AND wposts.post_title = '{$title}'
            AND wposts.post_status = 'publish'
         ";

         $post = $wpdb->get_results($querystr, OBJECT);

         $qry = "
             SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type, p.post_title, p.post_content
             FROM $wpdb->posts p
             JOIN $wpdb->postmeta pm on p.ID = pm.post_id
             WHERE p.post_status = 'publish'
             AND p.post_parent = {$post[0]->ID}
             AND (
                meta_key = 'wpcf-img-gallery'
                OR meta_key = 'wpcf-title-{$lang}-gallery'
                OR meta_key = 'wpcf-desc-{$lang}-gallery'
                OR meta_key = 'wpcf-videos-gallery'
                OR meta_key = 'wpcf-date-gallery'
             )
             ORDER BY p.post_date ASC
         ";

         $childrens = $wpdb->get_results($qry, OBJECT);

         if( $post != NULL && $childrens != NULL )
         {
             $metaChildrens = array();
             foreach( $childrens as $children )
             {
                 $key = str_replace(
                    array( "wpcf-title-{$lang}-gallery", "wpcf-desc-{$lang}-gallery", "wpcf-img-gallery", "wpcf-videos-gallery", "wpcf-date-gallery"),
                    array( "title", "desc", "img", "video", "date"),
                    $children->meta_key
                 );

                 if( count(explode("<!--:-->", $children->post_title)) > 1)
                 {
                     $title = explode("<!--:-->", $children->post_title);
                     if ( $lang === "CA" )
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[0]
                         );
                     }
                     else
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[1]
                         );
                     }
                 }

                 if( count(explode("<!--:-->", $children->post_content)) > 1)
                 {
                     $content = explode("<!--:-->", $children->post_content);
                     if ( $lang === "CA" )
                     {
                         $content = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $content[0]
                         );
                     }
                     else
                     {
                         $content = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $content[1]
                         );
                     }
                 }

                 $metaChildrens[$children->ID][$key] = array( "value" => $children->meta_value );
                 $metaChildrens[$children->ID]["post_type"] = $children->post_type;
                 $metaChildrens[$children->ID]["title"] = array( "value" => $title);
                 $metaChildrens[$children->ID]["desc"] = array( "value" => $content);
             }
             wp_send_json_success( array( "parent" => $post, "childrens" => $metaChildrens ) );
         }
         else
         {
             wp_send_json_error();
         }
         die();
    }
}

class GalleryVideoFactory
{
    public function __construct( $type, $lang, $id )
    {

        if( $id !== null )
        {
            $this->_loadChildrensVideoGallery( $type, $lang, $id );
            die();
        }

        global $wpdb;

        $querystr = "
            SELECT wposts.ID, wposts.post_title, wposts.post_type
            FROM $wpdb->posts wposts
            WHERE wposts.post_type = '{$type}'
            AND wposts.post_status = 'publish'
         ";

         //obtenemos todos los resultados del sidebar que pertenecen a este custom-post-type
         $parents = $wpdb->get_results($querystr, OBJECT);

         $first = $parents[0]->ID; //obtenemos el primer id padre

         $qry = "
             SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
             FROM $wpdb->posts p
             JOIN $wpdb->postmeta pm on p.ID = pm.post_id
             WHERE p.post_status = 'publish'
             AND p.ID = {$first}
             AND (
                  meta_key = 'wpcf-video-{$lang}'
             )
             ORDER BY p.ID DESC
         ";

         $childrens = $wpdb->get_results($qry, OBJECT);

         if( $parents != NULL && $childrens != NULL )
         {
             $metaChildrens = array();
             foreach( $childrens as $children )
             {
                 if( count(explode("<!--:-->", $parents[0]->post_title)) > 1)
                 {
                     $title = explode("<!--:-->", $parents[0]->post_title);
                     if ( $lang === "CA" )
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[0]
                         );
                     }
                     else
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[1]
                         );
                     }
                 }
                 $metaChildrens[] = array( "video" => $children->meta_value, "id" => $children->ID, "title" => $title );
             }
             wp_send_json_success( array( "parents" => $parents, "childrens" => $metaChildrens ) );
         }
         else
         {
             wp_send_json_error();
         }
         die();
    }

    private function _loadChildrensVideoGallery( $type, $lang, $id )
    {
        global $wpdb;


        $querystr = "
            SELECT wposts.ID, wposts.post_title, wposts.post_type
            FROM $wpdb->posts wposts
            WHERE wposts.post_type = '{$type}'
            AND wposts.ID = {$id}
            AND wposts.post_status = 'publish'
         ";

         //obtenemos todos los resultados del sidebar que pertenecen a este custom-post-type
         $parent = $wpdb->get_results($querystr, OBJECT);

         $qry = "
             SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
             FROM $wpdb->posts p
             JOIN $wpdb->postmeta pm on p.ID = pm.post_id
             WHERE p.post_status = 'publish'
             AND p.ID = {$id}
             AND (
                  meta_key = 'wpcf-video-{$lang}'
             )
             ORDER BY p.ID DESC
         ";

         $childrens = $wpdb->get_results($qry, OBJECT);

         if( $parent != NULL && $childrens != NULL )
         {
             $metaChildrens = array();
             foreach( $childrens as $children )
             {
                 if( count(explode("<!--:-->", $parent[0]->post_title)) > 1)
                 {
                     $title = explode("<!--:-->", $parent[0]->post_title);
                     if ( $lang === "cat" )
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[0]
                         );
                     }
                     else
                     {
                         $title = str_replace(
                            array( "<!--:CA-->", "<!--:es-->"),
                            array( "", ""),
                            $title[1]
                         );
                     }
                 }
                 $metaChildrens[] = array( "video" => $children->meta_value, "id" => $children->ID, "title" => $title );
             }
             wp_send_json_success( array( "parent" => $parent, "childrens" => $metaChildrens ) );
         }
         else
         {
             wp_send_json_error();
         }
         die();
    }
}

class GalleryFactory
{

    private $posts;

    public function __construct( $type, $lang, $method, $id )
    {

        $this->$method( $type, $lang, $id );

        // foreach( $parents as $parent)
        // {
        //     $qry = "
        //        SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
        //        FROM $wpdb->posts p
        //        JOIN $wpdb->postmeta pm on p.ID = pm.post_id
        //        WHERE p.post_parent = {$parent->ID}
        //        AND p.post_status = 'publish'
        //        AND (
        //             meta_key = 'wpcf-img-gallery' OR meta_key = 'wpcf-title-{$lang}-gallery' OR meta_key = 'wpcf-desc-{$lang}-gallery' OR meta_key = 'wpcf-videos-gallery'
        //        )
        //        ORDER BY p.ID DESC
        //     ";
        //
        //     $childrens = $wpdb->get_results($qry, OBJECT);
        //
        //     $metaChildrens = array();
        //     $date = "";
        //     foreach( $childrens as $children )
        //     {
        //         $key = str_replace(
        //            array( "wpcf-title-{$lang}-gallery", "wpcf-desc-{$lang}-gallery", "wpcf-img-gallery", "wpcf-videos-gallery"),
        //            array( "title", "desc", "img", "video"),
        //            $children->meta_key
        //         );
        //
        //         if( $key == "img" || $key == "video")
        //         {
        //             $id = explode(".", end(explode('/',$children->meta_value)))[0];
        //             $date = $wpdb->get_row( "SELECT date FROM multimedia WHERE ID = $id", OBJECT );
        //             add_post_meta( $children->ID, 'wpcf-date-gallery', $date->date, false );
        //         }
        //
        //         //$metaChildrens[$children->ID][$key] = array( "value" => $children->meta_value, "date" => $date );
        //     }
        // }
    }

    private function _loadGallery( $type, $lang, $id )
    {
        global $wpdb;

        $querystr = "
            SELECT wposts.ID, wposts.post_title, wposts.post_type
            FROM $wpdb->posts wposts
            WHERE wposts.post_type = '{$type}'
            AND wposts.post_status = 'publish'
         ";

         //obtenemos todos los resultados del sidebar que pertenecen a este custom-post-type
         $parents = $wpdb->get_results($querystr, OBJECT);

         $first = $parents[0]->ID; //obtenemos el primer id padre

         $qry = "
            SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
            FROM $wpdb->posts p
            JOIN $wpdb->postmeta pm on p.ID = pm.post_id
            WHERE p.post_parent = {$first}
            AND p.post_status = 'publish'
            AND (
                 meta_key = 'wpcf-img-gallery'
                 OR meta_key = 'wpcf-title-{$lang}-gallery'
                 OR meta_key = 'wpcf-desc-{$lang}-gallery'
                 OR meta_key = 'wpcf-videos-gallery'
                 OR meta_key = 'wpcf-date-gallery'
            )
            ORDER BY p.ID DESC
         ";

         $childrens = $wpdb->get_results($qry, OBJECT);

         if( $parents != NULL && $childrens != NULL )
         {
             $metaChildrens = array();
             foreach( $childrens as $children )
             {
                 $key = str_replace(
                    array( "wpcf-title-{$lang}-gallery", "wpcf-desc-{$lang}-gallery", "wpcf-img-gallery", "wpcf-videos-gallery", "wpcf-date-gallery"),
                    array( "title", "desc", "img", "video", "date"),
                    $children->meta_key
                 );
                 $metaChildrens[$children->ID][$key] = array( "value" => $children->meta_value );
             }
             wp_send_json_success( array( "parents" => $parents, "childrens" => $metaChildrens ) );
         }
         else
         {
             wp_send_json_error();
         }
         die();
    }

    private function _loadChildrensGallery( $type, $lang, $id )
    {
        global $wpdb;

        $querystr = "
            SELECT wposts.ID, wposts.post_title, wposts.post_type
            FROM $wpdb->posts wposts
            WHERE wposts.ID = {$id}
            AND wposts.post_status = 'publish'
         ";

         //obtenemos todos los resultados del sidebar que pertenecen a este custom-post-type
         $parent = $wpdb->get_results($querystr, OBJECT);

         $qry = "
            SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
            FROM $wpdb->posts p
            JOIN $wpdb->postmeta pm on p.ID = pm.post_id
            WHERE p.post_parent = {$id}
            AND p.post_status = 'publish'
            AND (
                 meta_key = 'wpcf-img-gallery'
                 OR meta_key = 'wpcf-title-{$lang}-gallery'
                 OR meta_key = 'wpcf-desc-{$lang}-gallery'
                 OR meta_key = 'wpcf-videos-gallery'
                 OR meta_key = 'wpcf-date-gallery'
            )
            ORDER BY p.ID DESC
         ";

         $childrens = $wpdb->get_results($qry, OBJECT);

         if( $parent != NULL && $childrens != NULL )
         {
             $metaChildrens = array();
             foreach( $childrens as $children )
             {
                 $key = str_replace(
                    array( "wpcf-title-{$lang}-gallery", "wpcf-desc-{$lang}-gallery", "wpcf-img-gallery", "wpcf-videos-gallery", "wpcf-date-gallery"),
                    array( "title", "desc", "img", "video", "date"),
                    $children->meta_key
                 );
                 $metaChildrens[$children->ID][$key] = array( "value" => $children->meta_value );
             }
             wp_send_json_success( array( "parent" => $parent, "childrens" => $metaChildrens ) );
         }
         else
         {
             wp_send_json_error();
         }
         die();
    }
}

class GalleryDecorator
{
    // foreach( $parents as $parent)
    // {
    //     $qry = "
    //        SELECT p.ID, pm.meta_key, pm.meta_value, p.post_date, p.post_type
    //        FROM $wpdb->posts p
    //        JOIN $wpdb->postmeta pm on p.ID = pm.post_id
    //        WHERE p.post_parent = {$parent->ID}
    //        AND p.post_status = 'publish'
    //        AND (
    //             meta_key = 'wpcf-img-gallery' OR meta_key = 'wpcf-title-{$lang}-gallery' OR meta_key = 'wpcf-desc-{$lang}-gallery' OR meta_key = 'wpcf-videos-gallery'
    //        )
    //        ORDER BY p.ID DESC
    //     ";
    //
    //     $childrens = $wpdb->get_results($qry, OBJECT);
    //
    //     $metaChildrens = array();
    //     $date = "";
    //     foreach( $childrens as $children )
    //     {
    //         $key = str_replace(
    //            array( "wpcf-title-{$lang}-gallery", "wpcf-desc-{$lang}-gallery", "wpcf-img-gallery", "wpcf-videos-gallery"),
    //            array( "title", "desc", "img", "video"),
    //            $children->meta_key
    //         );
    //
    //         if( $key == "img" || $key == "video")
    //         {
    //             $id = explode(".", end(explode('/',$children->meta_value)))[0];
    //             $date = $wpdb->get_row( "SELECT date FROM multimedia WHERE ID = $id", OBJECT );
    //             add_post_meta( $parent->ID, 'wpcf-date-gallery', $date->date, false );
    //         }
    //
    //         //$metaChildrens[$children->ID][$key] = array( "value" => $children->meta_value, "date" => $date );
    //     }
    // }
}

new Gallery;

// function load_coords()
// {
//     $location = $_GET["location"];
//     if( $location === 1 ) //sagrera
//     {
//         echo json_encode(array(
//             array("x" =>  215, "y" => 170),
//             array("x" =>  559, "y" => 242),
//             array("x" =>  180, "y" => 141),
//             array("x" =>  435, "y" => 182),
//             array("x" =>  377, "y" => 234),
//             array("x" =>  652, "y" => 249)
//         ));
//     }
//     else if( $location === 2 ) //sant andreu
//     {
//         echo json_encode(array(
//             array("x" =>  326, "y" => 105),
//             array("x" =>  188, "y" => 147),
//             array("x" =>  440, "y" => 120),
//             array("x" =>  379, "y" => 141)
//         ));
//     }
//     die();
// }
//
// add_action( 'wp_ajax_coords', 'load_coords' );
// add_action( 'wp_ajax_nopriv_coords', 'load_coords' );