AJAX
2 years ago
Date_Range
2 years ago
Interval
3 years ago
Menu_Bar_Stats
2 years ago
Migrations
2 years ago
Models
2 years ago
Public_API
2 years ago
Rows
2 years ago
Statistics
2 years ago
Tables
2 years ago
Utils
2 years ago
Campaign_Builder.php
2 years ago
Capability_Manager.php
3 years ago
Chart.php
2 years ago
Chart_Geo.php
2 years ago
Cron_Manager.php
2 years ago
Current_Traffic_Finder.php
2 years ago
Dashboard_Options.php
2 years ago
Dashboard_Widget.php
2 years ago
Database_Manager.php
2 years ago
Email_Chart.php
2 years ago
Email_Reports.php
2 years ago
Empty_Report_Option.php
2 years ago
Env.php
2 years ago
Filters.php
3 years ago
Geo_Database_Background_Job.php
2 years ago
Geo_Database_Manager.php
2 years ago
Geoposition.php
2 years ago
Icon_Directory.php
2 years ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
2 years ago
Independent_Analytics.php
2 years ago
Interrupt.php
2 years ago
Known_Referrers.php
2 years ago
Plugin_Conflict_Detector.php
2 years ago
Query.php
2 years ago
Quick_Stats.php
2 years ago
REST_API.php
2 years ago
Real_Time.php
2 years ago
Report.php
2 years ago
Report_Finder.php
2 years ago
Report_Options_Parser.php
2 years ago
Resource_Identifier.php
3 years ago
Settings.php
2 years ago
Sort_Configuration.php
2 years ago
Track_Resource_Changes.php
2 years ago
View.php
2 years ago
View_Counter.php
2 years ago
Visitors_Over_Time_Finder.php
2 years ago
WP_Option_Cache_Bust.php
2 years ago
WooCommerce_Order.php
2 years ago
WooCommerce_Referrer_Meta_Box.php
2 years ago
Query.php
163 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP_SCOPED\IAWP; |
| 4 | |
| 5 | class Query |
| 6 | { |
| 7 | public const CAMPAIGN_URLS = 'campaign_urls'; |
| 8 | public const CAMPAIGNS = 'campaigns'; |
| 9 | public const REFERRER_GROUPS = 'referrer_groups'; |
| 10 | public const REFERRERS = 'referrers'; |
| 11 | public const RESOURCES = 'resources'; |
| 12 | public const VIEWS = 'views'; |
| 13 | public const VISITORS = 'visitors'; |
| 14 | public const VISITORS_TMP = 'visitors_tmp'; |
| 15 | // Used in DB v7 migration |
| 16 | public const VISITORS_1_16_ARCHIVE = 'visitors_1_16_archive'; |
| 17 | // Used in DB v7 migration |
| 18 | public const SESSIONS = 'sessions'; |
| 19 | public const WC_ORDERS = 'wc_orders'; |
| 20 | public const CITIES = 'cities'; |
| 21 | public const COUNTRIES = 'countries'; |
| 22 | public const DEVICES = 'devices'; |
| 23 | public const DEVICE_TYPES = 'device_types'; |
| 24 | public const DEVICE_OSS = 'device_oss'; |
| 25 | public const DEVICE_BROWSERS = 'device_browsers'; |
| 26 | public const REPORTS = 'reports'; |
| 27 | private $query; |
| 28 | private $parameters; |
| 29 | private $pdo; |
| 30 | private $rows = []; |
| 31 | private $last_inserted_id = 0; |
| 32 | private $external_tables = ['wc_order_stats', 'comments']; |
| 33 | public function __construct(string $query_name, ?array $parameters = []) |
| 34 | { |
| 35 | $this->query = $this->get_query($query_name); |
| 36 | $this->parameters = $parameters; |
| 37 | } |
| 38 | public function last_inserted_id() : ?int |
| 39 | { |
| 40 | return $this->last_inserted_id; |
| 41 | } |
| 42 | public function rows() : array |
| 43 | { |
| 44 | return $this->rows; |
| 45 | } |
| 46 | public function row() : ?\stdClass |
| 47 | { |
| 48 | if (isset($this->rows[0])) { |
| 49 | return $this->rows[0]; |
| 50 | } else { |
| 51 | return null; |
| 52 | } |
| 53 | } |
| 54 | public function run() : self |
| 55 | { |
| 56 | $this->open_connection(); |
| 57 | $statement = $this->pdo->prepare($this->query); |
| 58 | foreach ($this->parameters as $key => $value) { |
| 59 | $statement->bindValue($key, $value); |
| 60 | } |
| 61 | $statement->execute(); |
| 62 | $rows = $statement->fetchAll(); |
| 63 | $this->rows = \array_map(function ($row) { |
| 64 | return (object) $row; |
| 65 | }, $rows); |
| 66 | $this->last_inserted_id = $this->pdo->lastInsertId(); |
| 67 | $this->close_connection(); |
| 68 | return $this; |
| 69 | } |
| 70 | /** |
| 71 | * Responsible for fetching the SQL from the correct query file. Query files are stored as text |
| 72 | * files with the txt extension to prevent being filtered out during backups and migrations by |
| 73 | * various hosts. |
| 74 | * |
| 75 | * @param string $query_name |
| 76 | * |
| 77 | * @return string |
| 78 | */ |
| 79 | private function get_query(string $query_name) : string |
| 80 | { |
| 81 | global $wpdb; |
| 82 | $wordpress_table_prefix = $wpdb->prefix; |
| 83 | $file_path = \IAWP_SCOPED\iawp_path_to("sql/{$query_name}.txt"); |
| 84 | $file_contents = \file_get_contents($file_path); |
| 85 | $reflection = new \ReflectionClass(static::class); |
| 86 | $constants = $reflection->getConstants(); |
| 87 | foreach ($constants as $table_partial) { |
| 88 | $hard_coded_table = 'wp_independent_analytics_' . $table_partial; |
| 89 | $actual_table = $wordpress_table_prefix . 'independent_analytics_' . $table_partial; |
| 90 | if ($actual_table !== $hard_coded_table) { |
| 91 | $file_contents = \str_replace($hard_coded_table, $actual_table, $file_contents); |
| 92 | } |
| 93 | } |
| 94 | foreach ($this->external_tables as $table_partial) { |
| 95 | $hard_coded_table = 'wp_' . $table_partial; |
| 96 | $actual_table = $wordpress_table_prefix . $table_partial; |
| 97 | if ($actual_table !== $hard_coded_table) { |
| 98 | $file_contents = \str_replace($hard_coded_table, $actual_table, $file_contents); |
| 99 | } |
| 100 | } |
| 101 | return $file_contents; |
| 102 | } |
| 103 | private function open_connection() |
| 104 | { |
| 105 | global $wpdb; |
| 106 | $raw_host = $wpdb->dbhost; |
| 107 | $name = $wpdb->dbname; |
| 108 | $charset = $wpdb->dbcharset ?? 'utf8'; |
| 109 | $user = $wpdb->dbuser; |
| 110 | $password = $wpdb->dbpassword; |
| 111 | if ($host_data = $wpdb->parse_db_host($raw_host)) { |
| 112 | list($host, $port, $socket, $is_ipv6) = $host_data; |
| 113 | } else { |
| 114 | \error_log('IAWP: Parsing DB host failed. Host = ' . $raw_host); |
| 115 | return; |
| 116 | } |
| 117 | if ($is_ipv6 && \extension_loaded('mysqlnd')) { |
| 118 | $host = "[{$host}]"; |
| 119 | } |
| 120 | $charset_collate = $wpdb->determine_charset($charset, ''); |
| 121 | $charset = $charset_collate['charset']; |
| 122 | if (isset($socket)) { |
| 123 | $data_source_name = 'mysql:unix_socket=' . $socket . ';dbname=' . $name . ';charset=' . $charset; |
| 124 | } else { |
| 125 | $data_source_name = 'mysql:host=' . $host . ';dbname=' . $name . ';charset=' . $charset; |
| 126 | if (isset($port)) { |
| 127 | $data_source_name .= ';port=' . $port; |
| 128 | } |
| 129 | } |
| 130 | $this->pdo = new \PDO($data_source_name, $user, $password); |
| 131 | $this->pdo->query("SET SESSION group_concat_max_len = 20000;"); |
| 132 | } |
| 133 | private function close_connection() |
| 134 | { |
| 135 | $this->pdo = null; |
| 136 | } |
| 137 | public static function query(string $query_name, ?array $parameters = []) : self |
| 138 | { |
| 139 | $db = new self($query_name, $parameters); |
| 140 | $db->run(); |
| 141 | return $db; |
| 142 | } |
| 143 | /** |
| 144 | * Safe way to get the name of a table |
| 145 | * |
| 146 | * @param string $name |
| 147 | * |
| 148 | * @return string|null |
| 149 | */ |
| 150 | public static function get_table_name(string $name) : ?string |
| 151 | { |
| 152 | global $wpdb; |
| 153 | $prefix = $wpdb->prefix; |
| 154 | $reflection = new \ReflectionClass(static::class); |
| 155 | $constants = $reflection->getConstants(); |
| 156 | if (\in_array($name, $constants)) { |
| 157 | return $prefix . 'independent_analytics_' . $name; |
| 158 | } else { |
| 159 | return null; |
| 160 | } |
| 161 | } |
| 162 | } |
| 163 |