AJAX
10 months ago
Admin_Page
11 months ago
Click_Tracking
1 year ago
Custom_WordPress_Columns
1 year ago
Data_Pruning
1 year ago
Date_Picker
1 year ago
Date_Range
11 months ago
Ecommerce
1 year ago
Email_Reports
11 months ago
Examiner
11 months ago
Filter_Lists
1 year ago
Form_Submissions
11 months ago
Integrations
1 year ago
Interval
1 year ago
Menu_Bar_Stats
1 year ago
Migrations
1 year ago
Models
10 months ago
Overview
11 months ago
Public_API
1 year ago
Rows
10 months ago
Statistics
11 months ago
Tables
11 months ago
Utils
11 months ago
Appearance.php
1 year ago
Campaign_Builder.php
1 year ago
Capability_Manager.php
1 year ago
Chart.php
1 year ago
Chart_Data.php
1 year ago
Click_Tracking.php
1 year ago
Cron_Job.php
1 year ago
Cron_Manager.php
1 year ago
Current_Traffic_Finder.php
1 year ago
Dashboard_Options.php
11 months ago
Dashboard_Widget.php
2 years ago
Database.php
1 year ago
Database_Manager.php
11 months ago
Empty_Report_Option.php
2 years ago
Env.php
1 year ago
Examiner_Config.php
11 months ago
Filters.php
1 year ago
Geo_Database_Background_Job.php
1 year ago
Geo_Database_Manager.php
11 months ago
Geoposition.php
1 year ago
Icon_Directory.php
2 years ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
10 months ago
Independent_Analytics.php
11 months ago
Interrupt.php
1 year ago
Known_Referrers.php
11 months ago
MainWP.php
1 year ago
Map.php
1 year ago
Map_Data.php
1 year ago
Migration_Fixer_Job.php
1 year ago
Patch.php
1 year ago
Payload_Validator.php
1 year ago
Plugin_Conflict_Detector.php
11 months ago
Plugin_Group.php
1 year ago
Plugin_Group_Option.php
2 years ago
Query.php
1 year ago
Query_Taps.php
11 months ago
Quick_Stats.php
11 months ago
REST_API.php
11 months ago
Real_Time.php
1 year ago
Report.php
1 year ago
Report_Finder.php
1 year ago
Report_Options_Parser.php
1 year ago
Resource_Identifier.php
1 year ago
Settings.php
11 months ago
Sort_Configuration.php
1 year ago
Tables.php
1 year ago
Track_Resource_Changes.php
1 year ago
View.php
11 months ago
View_Counter.php
1 year ago
Views_Over_Time_Finder.php
1 year ago
WP_Option_Cache_Bust.php
2 years ago
Query_Taps.php
79 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP; |
| 4 | |
| 5 | use IAWPSCOPED\Illuminate\Database\Query\Builder; |
| 6 | use IAWPSCOPED\Illuminate\Database\Query\JoinClause; |
| 7 | /** @internal */ |
| 8 | class Query_Taps |
| 9 | { |
| 10 | public static function tap_authored_content_check($should_join_resources = \true) |
| 11 | { |
| 12 | return function (Builder $query) use($should_join_resources) { |
| 13 | if (!\is_user_logged_in() || \IAWP\Capability_Manager::can_view_all_analytics()) { |
| 14 | return; |
| 15 | } |
| 16 | if ($should_join_resources) { |
| 17 | $resources_table = \IAWP\Query::get_table_name(\IAWP\Query::RESOURCES); |
| 18 | $query->leftJoin($query->raw($resources_table . ' AS resources'), function (JoinClause $join) { |
| 19 | $join->on('views.resource_id', '=', 'resources.id'); |
| 20 | }); |
| 21 | } |
| 22 | $query->where('resources.cached_author_id', '=', \get_current_user_id()); |
| 23 | }; |
| 24 | } |
| 25 | public static function tap_authored_content_for_clicks() |
| 26 | { |
| 27 | return function (Builder $query) { |
| 28 | if (!\is_user_logged_in() || \IAWP\Capability_Manager::can_view_all_analytics()) { |
| 29 | return; |
| 30 | } |
| 31 | $resources_table = \IAWP\Query::get_table_name(\IAWP\Query::RESOURCES); |
| 32 | $query->leftJoin($query->raw($resources_table . ' AS resources'), function (JoinClause $join) { |
| 33 | $join->on('views.resource_id', '=', 'resources.id'); |
| 34 | }); |
| 35 | $query->where('resources.cached_author_id', '=', \get_current_user_id()); |
| 36 | }; |
| 37 | } |
| 38 | public static function tap_related_to_examined_record(?\IAWP\Examiner_Config $config) |
| 39 | { |
| 40 | return function (Builder $query) use($config) { |
| 41 | if (!$config) { |
| 42 | return; |
| 43 | } |
| 44 | $column = self::examiner_type_to_column($config->group()); |
| 45 | if (!$column) { |
| 46 | return; |
| 47 | } |
| 48 | $query->where($column, '=', $config->id()); |
| 49 | }; |
| 50 | } |
| 51 | private static function examiner_type_to_column(string $group) : ?string |
| 52 | { |
| 53 | switch ($group) { |
| 54 | case 'page': |
| 55 | return 'views.resource_id'; |
| 56 | case 'referrer': |
| 57 | return 'sessions.referrer_id'; |
| 58 | case 'country': |
| 59 | return 'sessions.country_id'; |
| 60 | case 'city': |
| 61 | return 'sessions.city_id'; |
| 62 | case 'device_type': |
| 63 | return 'sessions.device_type_id'; |
| 64 | case 'os': |
| 65 | return 'sessions.device_os_id'; |
| 66 | case 'browser': |
| 67 | return 'sessions.device_browser_id'; |
| 68 | case 'campaign': |
| 69 | return 'sessions.campaign_id'; |
| 70 | case 'link': |
| 71 | return 'clicks.click_target_id'; |
| 72 | case 'link_pattern': |
| 73 | return 'clicked_links.link_rule_id'; |
| 74 | default: |
| 75 | return null; |
| 76 | } |
| 77 | } |
| 78 | } |
| 79 |