PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 3.4.2
Visualizer – Tables & Charts Manager with Built-in AI Generator v3.4.2
4.0.8 4.0.7 4.0.6 4.0.5 4.0.4 4.0.3 3.0.5 3.0.6 3.0.7 3.0.8 3.0.9 3.1.0 3.1.1 3.1.2 3.1.3 3.10.0 3.10.1 3.10.10 3.10.11 3.10.12 3.10.13 3.10.14 3.10.15 3.10.2 3.10.3 All 149 releases
← All changes | classes/Visualizer/Module/Setup.php +139 -27 3.1.23.4.2 View file →
@@ -44,15 +44,18 @@
44 44
45 45 register_activation_hook( VISUALIZER_BASEFILE, array( $this, 'activate' ) );
46 46 register_deactivation_hook( VISUALIZER_BASEFILE, array( $this, 'deactivate' ) );
47 47 $this->_addAction( 'visualizer_schedule_refresh_db', 'refreshDbChart' );
48 - $this->_addFilter( 'visualizer_schedule_refresh_chart', 'refresh_db_for_chart', null, 10, 3 );
48 + $this->_addFilter( 'visualizer_schedule_refresh_chart', 'refresh_db_for_chart', 10, 3 );
49 49
50 + $this->_addAction( 'activated_plugin', 'onActivation' );
50 51 $this->_addAction( 'init', 'setupCustomPostTypes' );
51 52 $this->_addAction( 'plugins_loaded', 'loadTextDomain' );
52 53 $this->_addFilter( 'visualizer_logger_data', 'getLoggerData' );
53 - $this->_addFilter( 'visualizer_get_chart_counts', 'getChartCountsByTypeAndMeta' );
54 + $this->_addFilter( 'visualizer_get_chart_counts', 'getUsage', 10, 2 );
54 55
56 + // only for testing
57 + // $this->_addAction( 'admin_init', 'getUsage' );
55 58 }
56 59 /**
57 60 * Fetches the SDK logger data.
58 61 *
@@ -60,36 +63,82 @@
60 63 *
61 64 * @access public
62 65 */
63 66 public function getLoggerData( $data ) {
64 - return $this->getChartCountsByTypeAndMeta();
67 + return $this->getUsage( $data );
65 68 }
66 69
67 70 /**
68 - * Fetches the types of charts created and their counts.
71 + * Fetches the usage of charts.
69 72 *
73 + * @param array $data The default data that needs to be sent.
70 74 * @param array $meta_keys An array of name vs. meta keys - to return how many charts have these keys.
71 - * @access private
75 + *
76 + * @access public
72 77 */
73 - public function getChartCountsByTypeAndMeta( $meta_keys = array() ) {
74 - $charts = array();
75 - $charts['chart_types'] = array();
76 - // the initial query arguments to fetch charts
78 + public function getUsage( $data, $meta_keys = array() ) {
79 + $charts = array( 'types' => array(), 'sources' => array(), 'library' => array(), 'permissions' => 0, 'manual_config' => 0, 'scheduled' => 0 );
77 80 $query_args = array(
78 81 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
79 82 'posts_per_page' => 300,
83 + 'post_status' => 'publish',
80 84 'fields' => 'ids',
81 85 'no_rows_found' => false,
82 86 'update_post_meta_cache' => false,
83 87 'update_post_term_cache' => false,
88 + );
84 89
90 + // default permissions.
91 + $default_perms = array(
92 + 'read' => 'all',
93 + 'read-specific' => null,
94 + 'edit' => 'roles',
95 + 'edit-specific' => array( 'administrator' ),
85 96 );
86 97
98 + // collect all schedules chart ids.
99 + $scheduled = array_merge(
100 + array_keys( get_option( Visualizer_Plugin::CF_CHART_SCHEDULE, array() ) ),
101 + array_keys( get_option( Visualizer_Plugin::CF_DB_SCHEDULE, array() ) )
102 + );
87 103 $query = new WP_Query( $query_args );
88 104 while ( $query->have_posts() ) {
89 105 $chart_id = $query->next_post();
90 106 $type = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true );
91 - $charts['chart_types'][ $type ] = isset( $charts['chart_types'][ $type ] ) ? $charts['chart_types'][ $type ] + 1 : 1;
107 + $charts['types'][ $type ] = isset( $charts['types'][ $type ] ) ? $charts['types'][ $type ] + 1 : 1;
108 + $source = get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true );
109 + $charts['sources'][ $source ] = isset( $charts['sources'][ $source ] ) ? $charts['sources'][ $source ] + 1 : 1;
110 + $lib = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
111 + $charts['library'][ $lib ] = isset( $charts['library'][ $lib ] ) ? $charts['library'][ $lib ] + 1 : 1;
112 + $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
113 + if ( array_key_exists( 'manual', $settings ) && ! empty( $settings['manual'] ) ) {
114 + $charts['manual_config'] = $charts['manual_config'] + 1;
115 + }
116 +
117 + // phpcs:ignore WordPress.PHP.StrictInArray.FoundNonStrictFalse
118 + if ( in_array( $chart_id, $scheduled, false ) ) {
119 + $charts['scheduled'] = $charts['scheduled'] + 1;
120 + }
121 +
122 + if ( Visualizer_Module::is_pro() ) {
123 + $permissions = get_post_meta( $chart_id, Visualizer_PRO::CF_PERMISSIONS, true );
124 + if ( empty( $permissions ) ) {
125 + continue;
126 + }
127 + $permissions = $permissions['permissions'];
128 + $customized = false;
129 + foreach ( $default_perms as $key => $val ) {
130 + if ( ! is_array( $val ) && ! is_null( $val ) && isset( $permissions[ $key ] ) && $permissions[ $key ] !== $val ) {
131 + $customized = true;
132 + } elseif ( is_array( $val ) && ! is_null( $val ) && isset( $permissions[ $key ] ) && count( $permissions[ $key ] ) !== count( $val ) ) {
133 + $customized = true;
134 + }
135 + }
136 + if ( $customized ) {
137 + $charts['permissions'] = $charts['permissions'] + 1;
138 + }
139 + }
140 +
92 141 if ( ! empty( $meta_keys ) ) {
93 142 foreach ( $meta_keys as $name => $key ) {
94 143 $data = get_post_meta( $chart_id, $key, true );
95 144 if ( ! empty( $data ) ) {
@@ -99,8 +148,9 @@
99 148 }
100 149 }
101 150 }
102 151 }
152 +
103 153 return $charts;
104 154 }
105 155
106 156 /**
@@ -145,8 +195,27 @@
145 195 wp_schedule_event( strtotime( 'midnight' ) - get_option( 'gmt_offset' ) * HOUR_IN_SECONDS, 'hourly', 'visualizer_schedule_refresh_db' );
146 196 }
147 197
148 198 /**
199 + * On activation of the plugin
200 + */
201 + public function onActivation( $plugin ) {
202 + if ( defined( 'TI_UNIT_TESTING' ) ) {
203 + return;
204 + }
205 +
206 + if ( $plugin === VISUALIZER_BASENAME ) {
207 + if ( Visualizer_Module::numberOfCharts() > 0 ) {
208 + wp_redirect( admin_url( 'admin.php?page=' . Visualizer_Plugin::NAME ) );
209 + } else {
210 + wp_redirect( admin_url( 'admin.php?page=viz-support' ) );
211 + }
212 + exit();
213 + }
214 + }
215 +
216 +
217 + /**
149 218 * Deactivate the plugin
150 219 */
151 220 public function deactivate() {
152 221 wp_clear_scheduled_hook( 'visualizer_schedule_refresh_db' );
@@ -152,14 +221,13 @@
152 221 wp_clear_scheduled_hook( 'visualizer_schedule_refresh_db' );
153 222 }
154 223
155 224 /**
156 - * Refresh the specific chart from the db. This is mostly for charts that have 0 refresh time i.e. live data.
225 + * Refresh the specific chart from the db.
157 226 *
158 227 * @param WP_Post $chart The chart object.
159 228 * @param int $chart_id The chart id.
160 - * @param bool $force If this is true, then the chart data will be refreshed no matter if the chart requests live data or cached data.
161 - * If false, data will be refreshed only if the chart requests live data.
229 + * @param bool $force If this is true, then the chart data will be force refreshed. If false, data will be refreshed only if the chart requests live data.
162 230 *
163 231 * @access public
164 232 */
165 233 public function refresh_db_for_chart( $chart, $chart_id, $force = false ) {
@@ -170,29 +238,69 @@
170 238 if ( ! $chart ) {
171 239 $chart = get_post( $chart_id );
172 240 }
173 241
174 - // check if its a live-data chart or a cached-data chart.
175 - if ( ! $force ) {
176 - $hours = get_post_meta( $chart_id, Visualizer_Plugin::CF_DB_SCHEDULE, true );
177 - if ( ! empty( $hours ) ) {
178 - // cached, bail!
179 - return $chart;
180 - }
242 + if ( ! $chart ) {
243 + return $chart;
181 244 }
182 245
183 246 // check if the source is correct.
184 247 $source = get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true );
185 - if ( $source !== 'Visualizer_Source_Query_Params' ) {
186 - return $chart;
248 + $load_series = false;
249 + switch ( $source ) {
250 + case 'Visualizer_Source_Query':
251 + // check if its a live-data chart or a cached-data chart.
252 + if ( ! $force ) {
253 + $hours = get_post_meta( $chart_id, Visualizer_Plugin::CF_DB_SCHEDULE, true );
254 + if ( ! empty( $hours ) ) {
255 + // cached, bail!
256 + return $chart;
257 + }
258 + }
259 +
260 + $params = get_post_meta( $chart_id, Visualizer_Plugin::CF_DB_QUERY, true );
261 + $source = new Visualizer_Source_Query( $params, $chart_id );
262 + $source->fetch( false );
263 + $load_series = true;
264 + break;
265 + case 'Visualizer_Source_Json':
266 + // check if its a live-data chart or a cached-data chart.
267 + if ( ! $force ) {
268 + $hours = get_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_SCHEDULE, true );
269 + if ( ! empty( $hours ) ) {
270 + // cached, bail!
271 + return $chart;
272 + }
273 + }
274 +
275 + $url = get_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_URL, true );
276 + $root = get_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_ROOT, true );
277 + $paging = get_post_meta( $chart_id, Visualizer_Plugin::CF_JSON_PAGING, true );
278 + $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
279 + $source = new Visualizer_Source_Json( array( 'url' => $url, 'root' => $root, 'paging' => $paging ) );
280 + $source->refresh( $series );
281 + break;
282 + case 'Visualizer_Source_Csv_Remote':
283 + // check if its a live-data chart or a cached-data chart.
284 + if ( ! $force ) {
285 + $hours = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_SCHEDULE, true );
286 + if ( ! empty( $hours ) ) {
287 + // cached, bail!
288 + return $chart;
289 + }
290 + }
291 + do_action( 'visualizer_schedule_import' );
292 + return get_post( $chart_id );
293 + default:
294 + return $chart;
187 295 }
188 296
189 - $params = get_post_meta( $chart_id, Visualizer_Plugin::CF_DB_QUERY, true );
190 - $source = new Visualizer_Source_Query( $params );
191 - $source->fetch( false );
192 297 $error = $source->get_error();
193 298 if ( empty( $error ) ) {
194 - update_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
299 + add_filter( 'wp_revisions_to_keep', '__return_false' );
300 + if ( $load_series ) {
301 + update_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
302 + }
195 303
196 304 wp_update_post(
197 305 array(
198 306 'ID' => $chart_id,
@@ -200,8 +308,11 @@
200 308 )
201 309 );
202 310
203 311 $chart = get_post( $chart_id );
312 + delete_post_meta( $chart_id, Visualizer_Plugin::CF_ERROR );
313 + } else {
314 + update_post_meta( $chart_id, Visualizer_Plugin::CF_ERROR, sprintf( 'Error while updating chart: %s', $error ) );
204 315 }
205 316
206 317 return $chart;
207 318 }
@@ -229,9 +340,10 @@
229 340 if ( $time > $now ) {
230 341 continue;
231 342 }
232 343
233 - $this->refresh_db_for_chart( null, $chart_id, false );
344 + // if the time is nigh, we force an update.
345 + $this->refresh_db_for_chart( null, $chart_id, true );
234 346 $hours = get_post_meta( $chart_id, Visualizer_Plugin::CF_DB_SCHEDULE, true );
235 347 $new_schedules[ $chart_id ] = time() + $hours * HOUR_IN_SECONDS;
236 348 }
237 349 update_option( Visualizer_Plugin::CF_DB_SCHEDULE, $new_schedules );