1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 

<?php

namespace WPGMZA;

require_once(plugin_dir_path(__FILE__) . 'class.custom-fields.php');
require_once(plugin_dir_path(__FILE__) . 'class.custom-marker-fields.php');

// TODO: Extend factory
class CustomFieldFilter
{
    private $field_id;
    private $map_id;
    private $values;
    private $field_data;
    
    private static $cached_widget_types_by_filter_id;
    
    public function __construct($field_id, $map_id)
    {
        global $wpdb;
        global $WPGMZA_TABLE_NAME_MAPS_HAS_CUSTOM_FIELDS_FILTERS;
        global $WPGMZA_TABLE_NAME_MARKERS_HAS_CUSTOM_FIELDS;
        global $WPGMZA_TABLE_NAME_CUSTOM_FIELDS;
        
        if(!is_numeric($field_id))
            throw new \Exception('Invalid field ID');
        
        $this->field_id = $field_id;
        $this->map_id = $map_id;
        
        $results = $wpdb->get_results("SELECT * FROM $WPGMZA_TABLE_NAME_CUSTOM_FIELDS WHERE id = " . (int)$field_id);
        if(!empty($results))
            $this->field_data = $results[0];
        
        $qstr = "SELECT value 
            FROM $WPGMZA_TABLE_NAME_MARKERS_HAS_CUSTOM_FIELDS 
            WHERE object_id IN (
                SELECT id FROM {$wpdb->prefix}wpgmza WHERE map_id = %d
            ) AND field_id = %d
            GROUP BY value";
        
        $stmt = $wpdb->prepare($qstr, array($map_id, $field_id));
        $this->values = $wpdb->get_col($stmt);
    }
    
    public static function setEnabledFilters($map_id, $field_ids)
    {
        global $wpdb;
        global $WPGMZA_TABLE_NAME_MAPS_HAS_CUSTOM_FIELDS_FILTERS;
        
        $qstr = "DELETE FROM $WPGMZA_TABLE_NAME_MAPS_HAS_CUSTOM_FIELDS_FILTERS WHERE map_id=%d";
        $params = array($map_id);
        
        // Remove redundant rows
        if(!empty($field_ids))
        {
            $field_ids = array_map('intval', $field_ids);
            $imploded = implode(',', $field_ids);
            
            $qstr .= " AND field_id NOT IN ($imploded)";
        }
        
        $stmt = $wpdb->prepare($qstr, $params);
        
        $wpdb->query($stmt);
        
        // Insert the new ones
        $qstr = "INSERT INTO $WPGMZA_TABLE_NAME_MAPS_HAS_CUSTOM_FIELDS_FILTERS 
            (map_id, field_id) 
            VALUES 
            (%d, %d) 
            ON DUPLICATE KEY UPDATE field_id=%d";
            
        foreach($field_ids as $field_id)
        {
            $stmt = $wpdb->prepare($qstr, array(
                $map_id,
                $field_id,
                $field_id
            ));
            
            $wpdb->query($stmt);
        }
    }
    
    public static function getWidgetType($field_id)
    {
        global $wpdb;
        global $WPGMZA_TABLE_NAME_CUSTOM_FIELDS;
        
        if(CustomFieldFilter::$cached_widget_types_by_filter_id)
            return CustomFieldFilter::$cached_widget_types_by_filter_id[$field_id];
        
        CustomFieldFilter::$cached_widget_types_by_filter_id = array();
        
        $results = $wpdb->get_results("SELECT id, widget_type FROM $WPGMZA_TABLE_NAME_CUSTOM_FIELDS");
        
        foreach($results as $obj)
            CustomFieldFilter::$cached_widget_types_by_filter_id[$obj->id] = $obj->widget_type;
        
        return CustomFieldFilter::$cached_widget_types_by_filter_id[$field_id];
    }
    
    public function getMapID()
    {
        return $this->map_id;
    }
    
    public function getFieldID()
    {
        return $this->field_id;
    }
    
    public function getFieldValues()
    {
        return $this->values;
    }
    
    public function getFieldData()
    {
        return $this->field_data;
    }
    
    public function getFilteringSQL($value)
    {
        global $wpdb;
        global $WPGMZA_TABLE_NAME_MARKERS_HAS_CUSTOM_FIELDS;
        
        $qstr = "SELECT object_id AS id FROM $WPGMZA_TABLE_NAME_MARKERS_HAS_CUSTOM_FIELDS 
            WHERE field_id = %d";
            
        $params = array(
            $this->field_id
        );
        
        if(is_array($value))
        {
            $parts = array();
            
            foreach($value as $el)
            {
                $parts[] = 'value LIKE %s';
                $params[] = $el;
            }
            
            $qstr .= ' AND (' . implode(' OR ', $parts) . ')';
        }
        else
        {
            $qstr .= ' AND value LIKE %s';
            $params[] = '%' . $value . '%';
        }
        
        $qstr .= " AND object_id IN (
                SELECT id FROM {$wpdb->prefix}wpgmza WHERE map_id=%d
            )";
        $params[] = $this->map_id;
        
        $stmt = $wpdb->prepare($qstr, $params);
        
        return $stmt;
    }
}

add_filter('wpgmza_get_custom_field_filter', 'WPGMZA\\get_custom_field_filter', 100, 2);

function get_custom_field_filter($field_id, $map_id)
{
    if($field_id instanceof CustomFieldFilter)
        return $field_id;
    
    return new CustomFieldFilter($field_id, $map_id);
}