AJAX
3 years ago
Date_Range
3 years ago
Interval
3 years ago
Menu_Bar_Stats
3 years ago
Migrations
3 years ago
Models
3 years ago
Queries
3 years ago
Statistics
3 years ago
Tables
3 years ago
Utils
3 years ago
Campaign_Builder.php
3 years ago
Capability_Manager.php
3 years ago
Chart.php
3 years ago
Chart_Geo.php
3 years ago
Chart_SVG.php
3 years ago
Dashboard_Options.php
3 years ago
Dashboard_Widget.php
3 years ago
Email_Reports.php
3 years ago
Filters.php
3 years ago
Geo_Database.php
3 years ago
Geo_Database_Download_Job.php
3 years ago
Health_Check.php
3 years ago
Illuminate_Builder.php
3 years ago
Independent_Analytics.php
3 years ago
Known_Referrers.php
3 years ago
PDF.php
3 years ago
Query.php
3 years ago
Quick_Stats.php
3 years ago
REST_API.php
3 years ago
Real_Time.php
3 years ago
Reset_Database.php
3 years ago
Resource_Identifier.php
3 years ago
Settings.php
3 years ago
Track_Resource_Changes.php
3 years ago
View.php
3 years ago
View_Counter.php
3 years ago
WP_Option_Cache_Bust.php
3 years ago
WooCommerce_Order.php
3 years ago
Filters.php
388 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP_SCOPED\IAWP; |
| 4 | |
| 5 | use IAWP_SCOPED\IAWP\Utils\WordPress_Site_Date_Format_Pattern; |
| 6 | use IAWP_SCOPED\IAWP\Utils\Security; |
| 7 | class Filters |
| 8 | { |
| 9 | public function output_filters(array $columns) |
| 10 | { |
| 11 | $opts = new Dashboard_Options(); |
| 12 | ?> |
| 13 | <div class="modal-parent" |
| 14 | data-controller="filters" |
| 15 | data-filters-filters-value="<?php |
| 16 | \esc_html_e(\json_encode($opts->filters())); |
| 17 | ?>" |
| 18 | > |
| 19 | <button id="filters-button" class="iawp-button ghost-white toolbar-button" |
| 20 | data-action="filters#toggleModal" |
| 21 | data-filters-target="modalButton" |
| 22 | > |
| 23 | <span class="dashicons dashicons-filter"></span> |
| 24 | <span class="iawp-label"><?php |
| 25 | echo ' ' . \esc_html__('Filter Rows', 'independent-analytics') . ' '; |
| 26 | ?></span> |
| 27 | <span class="count" data-filters-target="filterCount"></span> |
| 28 | </button> |
| 29 | <div class="modal large" |
| 30 | data-filters-target="modal" |
| 31 | > |
| 32 | <div class="modal-inner"> |
| 33 | <div class="title-small"><?php |
| 34 | \esc_html_e('Filters', 'independent-analytics'); |
| 35 | ?></div> |
| 36 | <div id="filters" data-filters-target="filters" class="filters" data-filters="[]"> |
| 37 | </div> |
| 38 | <template data-filters-target="blueprint"> |
| 39 | <?php |
| 40 | self::get_condition_html($columns); |
| 41 | ?> |
| 42 | </template> |
| 43 | <div> |
| 44 | <button id="add-condition" class="iawp-button text" |
| 45 | data-action="filters#addCondition" |
| 46 | > |
| 47 | <?php |
| 48 | \esc_html_e('+ Add another condition', 'independent-analytics'); |
| 49 | ?> |
| 50 | </button> |
| 51 | </div> |
| 52 | <div class="actions"> |
| 53 | <button id="filters-apply" class="iawp-button purple" |
| 54 | data-action="filters#apply" |
| 55 | > |
| 56 | <?php |
| 57 | \esc_html_e('Apply', 'independent-analytics'); |
| 58 | ?> |
| 59 | </button> |
| 60 | <button id="filters-reset" class="iawp-button ghost-purple" |
| 61 | data-action="filters#reset" |
| 62 | data-filters-target="reset" |
| 63 | disabled |
| 64 | > |
| 65 | <?php |
| 66 | \esc_html_e('Reset', 'independent-analytics'); |
| 67 | ?> |
| 68 | </button> |
| 69 | </div> |
| 70 | </div> |
| 71 | </div> |
| 72 | </div><?php |
| 73 | } |
| 74 | private function get_condition_html(array $columns) |
| 75 | { |
| 76 | ?> |
| 77 | <div class="condition" data-filters-target="condition"> |
| 78 | <div class="input-group"> |
| 79 | <div> |
| 80 | <?php |
| 81 | echo self::get_inclusion_selects(); |
| 82 | ?> |
| 83 | </div> |
| 84 | <div> |
| 85 | <?php |
| 86 | echo self::get_column_select($columns); |
| 87 | ?> |
| 88 | </div> |
| 89 | <div class="operator-select-container"> |
| 90 | <?php |
| 91 | echo self::get_all_operator_selects(); |
| 92 | ?> |
| 93 | </div> |
| 94 | <div class="operand-field-container"> |
| 95 | <?php |
| 96 | echo self::get_all_operand_fields($columns); |
| 97 | ?> |
| 98 | </div> |
| 99 | </div> |
| 100 | <button class="delete-button" data-action="filters#removeCondition"> |
| 101 | <span class="dashicons dashicons-no"></span></button> |
| 102 | </div> |
| 103 | <?php |
| 104 | } |
| 105 | private function get_inclusion_selects() |
| 106 | { |
| 107 | $html = '<select class="filters-include" data-filters-target="inclusion">'; |
| 108 | $html .= '<option value="include">' . \esc_html__('Include', 'independent-analytics') . '</option>'; |
| 109 | $html .= '<option value="exclude">' . \esc_html__('Exclude', 'independent-analytics') . '</option>'; |
| 110 | $html .= '</select>'; |
| 111 | return $html; |
| 112 | } |
| 113 | private function get_column_select(array $columns) |
| 114 | { |
| 115 | ?> |
| 116 | <select class="filters-column" data-filters-target="column" |
| 117 | data-action="filters#columnSelect" |
| 118 | > |
| 119 | <option value=""> |
| 120 | <?php |
| 121 | \esc_html_e('Choose a column', 'independent-analytics'); |
| 122 | ?> |
| 123 | </option> |
| 124 | <?php |
| 125 | foreach ($columns as $column) { |
| 126 | ?> |
| 127 | <?php |
| 128 | if ($column->requires_woocommerce() && !\IAWP_SCOPED\iawp_using_woocommerce()) { |
| 129 | continue; |
| 130 | } |
| 131 | ?> |
| 132 | <option value="<?php |
| 133 | \esc_attr_e($column->id()); |
| 134 | ?>" |
| 135 | data-type="<?php |
| 136 | \esc_attr_e(self::get_column_data_type($column->id())); |
| 137 | ?>" |
| 138 | > |
| 139 | <?php |
| 140 | \esc_html_e($column->label()); |
| 141 | ?> |
| 142 | </option> |
| 143 | <?php |
| 144 | } |
| 145 | ?> |
| 146 | </select> |
| 147 | <?php |
| 148 | } |
| 149 | private function get_all_operator_selects() |
| 150 | { |
| 151 | $html = ''; |
| 152 | foreach (self::get_data_types() as $data_type) { |
| 153 | $html .= '<select data-filters-target="operator" data-type="' . \esc_attr($data_type) . '">'; |
| 154 | foreach (self::get_operators($data_type) as $key => $value) { |
| 155 | $html .= '<option value="' . \esc_attr($key) . '">' . \esc_html($value) . '</option>'; |
| 156 | } |
| 157 | $html .= '</select>'; |
| 158 | } |
| 159 | return $html; |
| 160 | } |
| 161 | private function get_all_operand_fields($columns) |
| 162 | { |
| 163 | $html = ''; |
| 164 | foreach ($columns as $column) { |
| 165 | $id = $column->id(); |
| 166 | if ($id == 'title') { |
| 167 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="title" type="text" />'; |
| 168 | } elseif ($id == 'referrer') { |
| 169 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="referrer" type="text" />'; |
| 170 | } elseif ($id == 'continent') { |
| 171 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="continent" type="text" />'; |
| 172 | } elseif ($id == 'country') { |
| 173 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="country" type="text" />'; |
| 174 | } elseif ($id == 'subdivision') { |
| 175 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="subdivision" type="text" />'; |
| 176 | } elseif ($id == 'city') { |
| 177 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="city" type="text" />'; |
| 178 | } elseif ($id == 'utm_source') { |
| 179 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="utm_source" type="text" />'; |
| 180 | } elseif ($id == 'utm_medium') { |
| 181 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="utm_medium" type="text" />'; |
| 182 | } elseif ($id == 'utm_campaign') { |
| 183 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="utm_campaign" type="text" />'; |
| 184 | } elseif ($id == 'utm_term') { |
| 185 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="utm_term" type="text" />'; |
| 186 | } elseif ($id == 'utm_content') { |
| 187 | $html .= '<input data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="utm_content" type="text" />'; |
| 188 | } elseif ($id == 'referrer_type') { |
| 189 | $html .= '<select data-filters-target="operand" data-column="referrer_type">'; |
| 190 | $html .= '<option value="Search">' . \esc_html__('Search', 'independent-analytics') . '</option>'; |
| 191 | $html .= '<option value="Social">' . \esc_html__('Social', 'independent-analytics') . '</option>'; |
| 192 | $html .= '<option value="Referrer">' . \esc_html__('Referrer', 'independent-analytics') . '</option>'; |
| 193 | $html .= '<option value="Direct">' . \esc_html__('Direct', 'independent-analytics') . '</option>'; |
| 194 | $html .= '</select>'; |
| 195 | } elseif ($id == 'url') { |
| 196 | $html .= '<input type="text" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="url"/>'; |
| 197 | } elseif ($id == 'views') { |
| 198 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="views"/>'; |
| 199 | } elseif ($id == 'views_growth') { |
| 200 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="views_growth"/>'; |
| 201 | } elseif ($id == 'visitors') { |
| 202 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="visitors"/>'; |
| 203 | } elseif ($id == 'visitors_growth') { |
| 204 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="visitors_growth"/>'; |
| 205 | } elseif ($id == 'sessions') { |
| 206 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="sessions"/>'; |
| 207 | } elseif ($id == 'bounce_rate') { |
| 208 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="bounce_rate"/>'; |
| 209 | } elseif ($id == 'average_session_duration') { |
| 210 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="average_session_duration"/>'; |
| 211 | } elseif ($id == 'average_view_duration') { |
| 212 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="average_view_duration"/>'; |
| 213 | } elseif ($id == 'comments') { |
| 214 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="comments"/>'; |
| 215 | } elseif (\in_array($id, ['wc_orders', 'wc_gross_sales', 'wc_refunds', 'wc_refunded_amount', 'wc_net_sales', 'woocommerce_conversion_rate', 'woocommerce_earnings_per_visitor', 'woocommerce_average_order_volume'])) { |
| 216 | $html .= '<input type="number" data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="' . \esc_attr($id) . '"/>'; |
| 217 | } elseif ($id == 'author') { |
| 218 | $html .= '<select data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="author">'; |
| 219 | foreach (\IAWP_SCOPED\iawp()->get_users_can_write() as $author) { |
| 220 | $html .= '<option value="' . \esc_attr($author->ID) . '">' . \esc_html($author->display_name) . '</option>'; |
| 221 | } |
| 222 | $html .= '</select>'; |
| 223 | } elseif ($id == 'type') { |
| 224 | $html .= '<select data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="type">'; |
| 225 | $html .= '<option value="post">' . \esc_html__('Post', 'independent-analytics') . '</option>'; |
| 226 | $html .= '<option value="page">' . \esc_html__('Page', 'independent-analytics') . '</option>'; |
| 227 | $html .= '<option value="attachment">' . \esc_html__('Attachment', 'independent-analytics') . '</option>'; |
| 228 | foreach (\IAWP_SCOPED\iawp()->get_custom_types() as $cpt) { |
| 229 | $html .= '<option value="' . \esc_attr($cpt) . '">' . \esc_html(\get_post_type_object($cpt)->labels->singular_name) . '</option>'; |
| 230 | } |
| 231 | $html .= '<option value="category">' . \esc_html__('Category', 'independent-analytics') . '</option>'; |
| 232 | $html .= '<option value="post_tag">' . \esc_html__('Tag', 'independent-analytics') . '</option>'; |
| 233 | foreach (\IAWP_SCOPED\iawp()->get_custom_types(\true) as $tax) { |
| 234 | $html .= '<option value="' . \esc_attr($tax) . '">' . \esc_html(\get_taxonomy_labels(\get_taxonomy($tax))->singular_name) . '</option>'; |
| 235 | } |
| 236 | $html .= '<option value="blog-archive">' . \esc_html__('Blog Home', 'independent-analytics') . '</option>'; |
| 237 | $html .= '<option value="author-archive">' . \esc_html__('Author Archive', 'independent-analytics') . '</option>'; |
| 238 | $html .= '<option value="date-archive">' . \esc_html__('Date Archive', 'independent-analytics') . '</option>'; |
| 239 | $html .= '<option value="search-archive">' . \esc_html__('Search Results', 'independent-analytics') . '</option>'; |
| 240 | $html .= '<option value="not-found">' . \esc_html__('404', 'independent-analytics') . '</option>'; |
| 241 | $html .= '</select>'; |
| 242 | } elseif ($id == 'date') { |
| 243 | $html .= '<input type="text" |
| 244 | data-filters-target="operand" |
| 245 | data-action="keydown->filters#operandKeyDown filters#operandChange" |
| 246 | data-column="date" |
| 247 | data-controller="easepick" |
| 248 | data-css="' . \esc_url(\IAWP_SCOPED\iawp_url_to('dist/styles/easepick/datepicker.css')) . '" data-dow="' . \absint(\IAWP_SCOPED\iawp()->get_option('iawp_dow', 1)) . '" |
| 249 | data-format="' . \esc_attr(WordPress_Site_Date_Format_Pattern::for_javascript()) . '" />'; |
| 250 | } elseif ($id == 'category') { |
| 251 | $html .= '<select data-filters-target="operand" data-action="keydown->filters#operandKeyDown filters#operandChange" data-column="category">'; |
| 252 | foreach (\get_categories() as $category) { |
| 253 | $html .= '<option value="' . \esc_attr($category->term_id) . '">' . \esc_html($category->name) . '</option>'; |
| 254 | } |
| 255 | $html .= '</select>'; |
| 256 | } |
| 257 | } |
| 258 | return $html; |
| 259 | } |
| 260 | private function get_data_types() |
| 261 | { |
| 262 | return ['string', 'int', 'date', 'bool']; |
| 263 | } |
| 264 | private function get_operators(string $data_type) |
| 265 | { |
| 266 | if ($data_type == 'string') { |
| 267 | return ['contains' => \esc_html__('Contains', 'independent-analytics'), 'exact' => \esc_html__('Exactly matches', 'independent-analytics')]; |
| 268 | } elseif ($data_type == 'int') { |
| 269 | return ['greater' => \esc_html__('Greater than', 'independent-analytics'), 'lesser' => \esc_html__('Less than', 'independent-analytics'), 'equal' => \esc_html__('Equal to', 'independent-analytics')]; |
| 270 | } elseif ($data_type == 'bool') { |
| 271 | return ['is' => \esc_html__('Is', 'independent-analytics'), 'isnt' => \esc_html__('Isn\'t', 'independent-analytics')]; |
| 272 | } elseif ($data_type == 'date') { |
| 273 | return ['before' => \esc_html__('Before', 'independent-analytics'), 'after' => \esc_html__('After', 'independent-analytics'), 'on' => \esc_html__('On', 'independent-analytics')]; |
| 274 | } else { |
| 275 | return null; |
| 276 | } |
| 277 | } |
| 278 | private function get_column_data_type(string $column) |
| 279 | { |
| 280 | $columns = ['title' => 'string', 'url' => 'string', 'referrer' => 'string', 'continent' => 'string', 'country' => 'string', 'subdivision' => 'string', 'city' => 'string', 'utm_source' => 'string', 'utm_medium' => 'string', 'utm_campaign' => 'string', 'utm_term' => 'string', 'utm_content' => 'string', 'author' => 'bool', 'type' => 'bool', 'referrer_type' => 'bool', 'category' => 'bool', 'views' => 'int', 'views_growth' => 'int', 'visitors' => 'int', 'visitors_growth' => 'int', 'sessions' => 'int', 'bounce_rate' => 'int', 'average_session_duration' => 'int', 'average_view_duration' => 'int', 'comments' => 'int', 'date' => 'date', 'wc_orders' => 'int', 'wc_gross_sales' => 'int', 'wc_refunds' => 'int', 'wc_refunded_amount' => 'int', 'wc_net_sales' => 'int', 'woocommerce_conversion_rate' => 'int', 'woocommerce_earnings_per_visitor' => 'int', 'woocommerce_average_order_volume' => 'int']; |
| 281 | if (\array_key_exists($column, $columns)) { |
| 282 | return $columns[$column]; |
| 283 | } else { |
| 284 | return null; |
| 285 | } |
| 286 | } |
| 287 | public function fitler_rows(array $rows, array $filters) |
| 288 | { |
| 289 | if ($filters == '') { |
| 290 | return $rows; |
| 291 | } |
| 292 | $filtered_rows = []; |
| 293 | foreach ($rows as $row) { |
| 294 | $match_count = 0; |
| 295 | foreach ($filters as $filter) { |
| 296 | if (self::include_row($row, $filter)) { |
| 297 | $match_count++; |
| 298 | } |
| 299 | } |
| 300 | if ($match_count == \count($filters)) { |
| 301 | $filtered_rows[] = $row; |
| 302 | } |
| 303 | } |
| 304 | return $filtered_rows; |
| 305 | } |
| 306 | public function include_row($row, $filter) |
| 307 | { |
| 308 | $inclusion = $filter['inclusion']; |
| 309 | $column = $filter['column']; |
| 310 | $operator = $filter['operator']; |
| 311 | $operand = \strtolower($filter['operand']); |
| 312 | $column_data_type = $this->get_column_data_type($column); |
| 313 | $match = \false; |
| 314 | if ($column_data_type === 'int') { |
| 315 | if ($operator === 'greater') { |
| 316 | if ($row->{$column}() > $operand) { |
| 317 | $match = \true; |
| 318 | } |
| 319 | } elseif ($operator === 'lesser') { |
| 320 | if ($row->{$column}() < $operand && !\is_null($row->{$column}())) { |
| 321 | $match = \true; |
| 322 | } |
| 323 | } elseif ($operator === 'equal') { |
| 324 | if ($row->{$column}() == $operand) { |
| 325 | $match = \true; |
| 326 | } |
| 327 | } |
| 328 | } elseif ($column_data_type === 'string') { |
| 329 | $value = \strtolower($row->{$column}()); |
| 330 | if ($operator == 'contains') { |
| 331 | if (\strpos($value, $operand) !== \false) { |
| 332 | $match = \true; |
| 333 | } |
| 334 | } elseif ($operator == 'exact') { |
| 335 | if ($value == $operand) { |
| 336 | $match = \true; |
| 337 | } |
| 338 | } |
| 339 | } elseif ($filter['column'] == 'referrer_type') { |
| 340 | $referrer_type = \strtolower($row->referrer_type()); |
| 341 | if ($filter['operator'] == 'is' && $referrer_type == $operand) { |
| 342 | $match = \true; |
| 343 | } elseif ($filter['operator'] == 'isnt' && $referrer_type != $operand) { |
| 344 | $match = \true; |
| 345 | } |
| 346 | } elseif ($filter['column'] == 'author') { |
| 347 | if ($filter['operator'] == 'is' && $row->author_id() == $operand) { |
| 348 | $match = \true; |
| 349 | } elseif ($filter['operator'] == 'isnt' && $row->author_id() != $operand) { |
| 350 | $match = \true; |
| 351 | } |
| 352 | } elseif ($filter['column'] == 'type') { |
| 353 | if ($filter['operator'] == 'is' && $row->type(\true) == $operand) { |
| 354 | $match = \true; |
| 355 | } elseif ($filter['operator'] == 'isnt' && $row->type(\true) != $operand) { |
| 356 | $match = \true; |
| 357 | } |
| 358 | } elseif ($filter['column'] == 'date') { |
| 359 | // Don't "continue" or row won't be included when excluding |
| 360 | if ($row->date() != null) { |
| 361 | $date = new \DateTime($operand); |
| 362 | if ($filter['operator'] == 'before' && $row->date() < $date->format('U')) { |
| 363 | $match = \true; |
| 364 | } elseif ($filter['operator'] == 'after' && $row->date() > $date->format('U')) { |
| 365 | $match = \true; |
| 366 | } elseif ($filter['operator'] == 'on') { |
| 367 | $formatted_date = \DateTime::createFromFormat('U', $row->date()); |
| 368 | $formatted_date = $formatted_date->format('Y-m-d'); |
| 369 | if ($date->format('Y-m-d') == $formatted_date) { |
| 370 | $match = \true; |
| 371 | } |
| 372 | } |
| 373 | } |
| 374 | } elseif ($filter['column'] == 'category') { |
| 375 | if ($filter['operator'] == 'is' && \in_array($operand, $row->category(\false) ?? [])) { |
| 376 | $match = \true; |
| 377 | } elseif ($filter['operator'] == 'isnt' && !\in_array($operand, $row->category(\false) ?? [])) { |
| 378 | $match = \true; |
| 379 | } |
| 380 | } |
| 381 | if ($filter['inclusion'] == 'include' && $match || $filter['inclusion'] == 'exclude' && !$match) { |
| 382 | return \true; |
| 383 | } else { |
| 384 | return \false; |
| 385 | } |
| 386 | } |
| 387 | } |
| 388 |