PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 4.0.7
Visualizer – Tables & Charts Manager with Built-in AI Generator v4.0.7
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/Gutenberg/Block.php +317 -217 3.1.34.0.7 View file →
@@ -45,9 +45,9 @@
45 45 /**
46 46 * Returns an instance of this class.
47 47 */
48 48 public static function get_instance() {
49 - if ( null == self::$instance ) {
49 + if ( null === self::$instance ) {
50 50 self::$instance = new Visualizer_Gutenberg_Block();
51 51 }
52 52 return self::$instance;
53 53 }
@@ -59,48 +59,145 @@
59 59 $this->version = Visualizer_Plugin::VERSION;
60 60 add_action( 'enqueue_block_editor_assets', array( $this, 'enqueue_gutenberg_scripts' ) );
61 61 add_action( 'init', array( $this, 'register_block_type' ) );
62 62 add_action( 'rest_api_init', array( $this, 'register_rest_endpoints' ) );
63 + add_filter( 'rest_visualizer_query', array( $this, 'add_rest_query_vars' ), 9, 2 );
63 64 }
64 65
65 66 /**
66 - * Enqueue front end and editor JavaScript and CSS
67 + * Enqueue Gutenberg block assets.
67 68 */
68 69 public function enqueue_gutenberg_scripts() {
69 - $blockPath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.js';
70 - $handsontableJS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.js';
71 - $stylePath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/block.css';
72 - $handsontableCSS = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/handsontable.css';
70 + global $pagenow;
73 71
72 + $blockPath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/index.js';
73 + $stylePath = VISUALIZER_ABSURL . 'classes/Visualizer/Gutenberg/build/style-index.css';
74 + $asset_path = VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/index.asset.php';
75 + if ( file_exists( $asset_path ) ) {
76 + // @phpstan-ignore-next-line
77 + $asset = require $asset_path;
78 + } else {
79 + $asset = array(
80 + 'dependencies' => array(),
81 + 'version' => $this->version,
82 + );
83 + }
84 +
74 85 if ( VISUALIZER_TEST_JS_CUSTOMIZATION ) {
75 - $version = filemtime( VISUALIZER_ABSPATH . 'classes/Visualizer/Gutenberg/build/block.js' );
76 - } else {
77 - $version = $this->version;
86 + $asset['version'] = filemtime( VISUALIZER_ABSPATH . '/classes/Visualizer/Gutenberg/build/index.js' );
78 87 }
79 88
80 - // Enqueue the bundled block JS file
81 - wp_enqueue_script( 'handsontable', $handsontableJS );
82 - wp_enqueue_script( 'visualizer-gutenberg-block', $blockPath, array( 'wp-api', 'handsontable' ), $version, true );
89 + if ( ! wp_script_is( 'visualizer-datatables', 'registered' ) ) {
90 + wp_register_script( 'visualizer-datatables', VISUALIZER_ABSURL . 'js/lib/datatables.min.js', array( 'jquery-ui-core' ), Visualizer_Plugin::VERSION );
91 + }
83 92
84 - $type = 'community';
93 + if ( ! wp_style_is( 'visualizer-datatables', 'registered' ) ) {
94 + wp_register_style( 'visualizer-datatables', VISUALIZER_ABSURL . 'css/lib/datatables.min.css', array(), Visualizer_Plugin::VERSION );
95 + }
85 96
86 - if ( VISUALIZER_PRO ) {
87 - $type = 'pro';
88 - if ( apply_filters( 'visualizer_is_business', false ) ) {
89 - $type = 'developer';
90 - }
97 + // Enqueue the bundled block JS file
98 + $script_deps = array(
99 + 'wp-api',
100 + 'wp-blocks',
101 + 'wp-block-editor',
102 + 'wp-components',
103 + 'wp-editor',
104 + 'wp-element',
105 + 'wp-i18n',
106 + 'lodash',
107 + 'moment',
108 + 'react',
109 + 'visualizer-datatables',
110 + );
111 + if ( isset( $asset['dependencies'] ) && is_array( $asset['dependencies'] ) ) {
112 + $script_deps = array_merge( $script_deps, $asset['dependencies'] );
91 113 }
114 + $script_deps = array_values( array_unique( $script_deps ) );
115 + wp_enqueue_script( 'visualizer-gutenberg-block', $blockPath, $script_deps, $asset['version'], true );
92 116
93 117 $translation_array = array(
94 - 'isPro' => $type,
95 - 'proTeaser' => Visualizer_Plugin::PRO_TEASER_URL,
96 - 'absurl' => VISUALIZER_ABSURL,
118 + 'adminPage' => menu_page_url( 'visualizer', false ),
119 + 'createChart' => add_query_arg( array( 'action' => 'visualizer-create-chart', 'library' => 'yes', 'type' => '', 'chart-library' => '', 'tab' => 'visualizer' ), admin_url( 'admin-ajax.php' ) ),
120 + 'chartsPerPage' => defined( 'TI_E2E_TESTING' ) ? 20 : 6,
121 + 'isFullSiteEditor' => 'site-editor.php' === $pagenow,
122 + /* translators: %1$s: opening tag, %2$s: closing tag */
123 + 'chartEditUrl' => admin_url( 'admin-ajax.php' ),
97 124 );
98 125 wp_localize_script( 'visualizer-gutenberg-block', 'visualizerLocalize', $translation_array );
99 126
127 + $d3_renderer_asset = VISUALIZER_ABSPATH . '/classes/Visualizer/D3Renderer/build/index.asset.php';
128 + if ( file_exists( $d3_renderer_asset ) && ! wp_script_is( 'visualizer-d3-renderer', 'registered' ) ) {
129 + // @phpstan-ignore-next-line
130 + $d3_asset = include $d3_renderer_asset;
131 + wp_register_script(
132 + 'visualizer-d3-renderer',
133 + VISUALIZER_ABSURL . 'classes/Visualizer/D3Renderer/build/index.js',
134 + array_merge( $d3_asset['dependencies'], array( 'jquery' ) ),
135 + $d3_asset['version'],
136 + true
137 + );
138 + }
139 + if ( wp_script_is( 'visualizer-d3-renderer', 'registered' ) ) {
140 + wp_enqueue_script( 'visualizer-d3-renderer' );
141 + wp_localize_script(
142 + 'visualizer-d3-renderer',
143 + 'vizD3Renderer',
144 + array(
145 + 'iframeJsUrl' => VISUALIZER_ABSURL . 'classes/Visualizer/D3Renderer/build/iframe.js',
146 + )
147 + );
148 + }
149 +
100 150 // Enqueue frontend and editor block styles
101 - wp_enqueue_style( 'handsontable', $handsontableCSS );
102 - wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, '', $version );
151 + wp_enqueue_style( 'visualizer-gutenberg-block', $stylePath, array( 'visualizer-datatables' ), $asset['version'] );
152 +
153 + // Enqueue ChartBuilder (AI Builder) so the D3 edit modal is available in the block editor.
154 + $chart_builder_asset = VISUALIZER_ABSPATH . '/classes/Visualizer/ChartBuilder/build/index.asset.php';
155 + if ( file_exists( $chart_builder_asset ) && ! wp_script_is( 'visualizer-chart-builder', 'enqueued' ) ) {
156 + /**
157 + * Ignore missing build asset in source checkout.
158 + *
159 + * @phpstan-ignore-next-line
160 + */
161 + $cb_asset = include $chart_builder_asset;
162 + wp_enqueue_script(
163 + 'visualizer-chart-builder',
164 + VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/index.js',
165 + $cb_asset['dependencies'],
166 + $cb_asset['version'],
167 + true
168 + );
169 + wp_enqueue_style(
170 + 'visualizer-chart-builder',
171 + VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/style-index.css',
172 + array(),
173 + $cb_asset['version']
174 + );
175 + $chart_builder_css = VISUALIZER_ABSPATH . '/classes/Visualizer/ChartBuilder/build/index.css';
176 + if ( file_exists( $chart_builder_css ) ) {
177 + wp_enqueue_style(
178 + 'visualizer-chart-builder-runtime',
179 + VISUALIZER_ABSURL . 'classes/Visualizer/ChartBuilder/build/index.css',
180 + array( 'visualizer-chart-builder' ),
181 + $cb_asset['version']
182 + );
183 + }
184 + wp_localize_script(
185 + 'visualizer-chart-builder',
186 + 'vizAIBuilder',
187 + array(
188 + 'ajaxUrl' => admin_url( 'admin-ajax.php' ),
189 + 'nonce' => wp_create_nonce( 'visualizer-ai-builder' ),
190 + 'isPro' => Visualizer_Module::is_pro(),
191 + )
192 + );
193 + // Inject the mount point the ChartBuilder React app needs.
194 + wp_add_inline_script(
195 + 'visualizer-chart-builder',
196 + 'document.body.insertAdjacentHTML("beforeend","<div id=\"viz-chart-builder-root\"></div>");',
197 + 'before'
198 + );
199 + }
103 200 }
104 201 /**
105 202 * Hook server side rendering into render callback
106 203 */
@@ -111,8 +208,11 @@
111 208 'attributes' => array(
112 209 'id' => array(
113 210 'type' => 'number',
114 211 ),
212 + 'lazy' => array(
213 + 'type' => 'string',
214 + ),
115 215 ),
116 216 )
117 217 );
118 218 }
@@ -119,16 +219,45 @@
119 219
120 220 /**
121 221 * Gutenberg Block Callback Function
122 222 */
123 - public function gutenberg_block_callback( $attr ) {
124 - if ( isset( $attr['id'] ) ) {
125 - $id = $attr['id'];
126 - if ( empty( $id ) || $id === 'none' ) {
127 - return ''; // no id = no fun
128 - }
129 - return '[visualizer id="' . $id . '"]';
223 + public function gutenberg_block_callback( $atts ) {
224 + // no id, no fun.
225 + if ( ! isset( $atts['id'] ) ) {
226 + return '';
130 227 }
228 +
229 + $atts = shortcode_atts(
230 + array(
231 + 'id' => false,
232 + 'lazy' => apply_filters( 'visualizer_lazy_by_default', false, $atts['id'] ),
233 + // we are deliberating excluding the class attribute from here
234 + // as this will be handled by the custom class in Gutenberg
235 + ),
236 + $atts
237 + );
238 +
239 + // no id, no fun.
240 + if ( ! $atts['id'] ) {
241 + return '';
242 + }
243 +
244 + if ( $atts['lazy'] === '-1' || $atts['lazy'] === false ) {
245 + $atts['lazy'] = 'no';
246 + }
247 +
248 + // we don't want the chart in the editor lazy-loading.
249 + if ( is_admin() ) {
250 + unset( $atts['lazy'] );
251 + }
252 +
253 + $shortcode = '[visualizer';
254 + foreach ( $atts as $name => $value ) {
255 + $shortcode .= sprintf( ' %s="%s"', $name, $value );
256 + }
257 + $shortcode .= ']';
258 +
259 + return $shortcode;
131 260 }
132 261
133 262 /**
134 263 * Hook server side rendering into render callback
@@ -140,50 +269,8 @@
140 269 array(
141 270 'get_callback' => array( $this, 'get_visualizer_data' ),
142 271 )
143 272 );
144 -
145 - register_rest_route(
146 - 'visualizer/v' . VISUALIZER_REST_VERSION,
147 - '/update-chart',
148 - array(
149 - 'methods' => 'POST',
150 - 'callback' => array( $this, 'update_chart_data' ),
151 - 'args' => array(
152 - 'id' => array(
153 - 'sanitize_callback' => 'absint',
154 - ),
155 - ),
156 - )
157 - );
158 -
159 - register_rest_route(
160 - 'visualizer/v' . VISUALIZER_REST_VERSION,
161 - '/upload-data',
162 - array(
163 - 'methods' => 'POST',
164 - 'callback' => array( $this, 'upload_csv_data' ),
165 - 'args' => array(
166 - 'url' => array(
167 - 'sanitize_callback' => 'esc_url_raw',
168 - ),
169 - ),
170 - )
171 - );
172 -
173 - register_rest_route(
174 - 'visualizer/v' . VISUALIZER_REST_VERSION,
175 - '/get-permission-data',
176 - array(
177 - 'methods' => 'GET',
178 - 'callback' => array( $this, 'get_permission_data' ),
179 - 'args' => array(
180 - 'type' => array(
181 - 'sanitize_callback' => 'sanitize_text_field',
182 - ),
183 - ),
184 - )
185 - );
186 273 }
187 274
188 275 /**
189 276 * Get Post Meta Fields
@@ -188,13 +275,23 @@
188 275 /**
189 276 * Get Post Meta Fields
190 277 */
191 278 public function get_visualizer_data( $post ) {
279 + if ( ! Visualizer_Module::can_edit_chart( $post['id'] ) ) {
280 + return false;
281 + }
282 +
192 283 $data = array();
193 284 $post_id = $post['id'];
194 285
195 286 $data['visualizer-chart-type'] = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_TYPE, true );
196 287
288 + $library = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_LIBRARY, true );
289 + $data['visualizer-chart-library'] = $library;
290 + if ( 'd3' === $library ) {
291 + $data['visualizer-d3-code'] = get_post_meta( $post_id, Visualizer_Module_AIBuilder::CF_D3_CODE, true );
292 + }
293 +
197 294 $data['visualizer-source'] = get_post_meta( $post_id, Visualizer_Plugin::CF_SOURCE, true );
198 295
199 296 $data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
200 297
@@ -199,9 +296,11 @@
199 296 $data['visualizer-default-data'] = get_post_meta( $post_id, Visualizer_Plugin::CF_DEFAULT_DATA, true );
200 297
201 298 // faetch and update settings
202 299 $data['visualizer-settings'] = get_post_meta( $post_id, Visualizer_Plugin::CF_SETTINGS, true );
203 -
300 + if ( empty( $data['visualizer-settings']['pagination'] ) ) {
301 + $data['visualizer-settings']['pageSize'] = '';
302 + }
204 303 // handle series filter hooks
205 304 $data['visualizer-series'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_SERIES, get_post_meta( $post_id, Visualizer_Plugin::CF_SERIES, true ), $post_id, $data['visualizer-chart-type'] );
206 305
207 306 // handle settings filter hooks
@@ -207,89 +306,136 @@
207 306 // handle settings filter hooks
208 307 $data['visualizer-settings'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_SETTINGS, $data['visualizer-settings'], $post_id, $data['visualizer-chart-type'] );
209 308
210 309 // handle data filter hooks
211 - $data['visualizer-data'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, unserialize( html_entity_decode( get_the_content( $post_id ) ) ), $post_id, $data['visualizer-chart-type'] );
310 + $data['visualizer-data'] = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, Visualizer_Module::decode_content( html_entity_decode( get_post_field( 'post_content', $post_id, 'raw' ) ) ), $post_id, $data['visualizer-chart-type'] );
212 311
213 - $import = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_URL, true );
312 + // we are going to format only for tabular charts, because we are not sure of the effect on others.
313 + // this is to solve the case where boolean data shows up as all-ticks on gutenberg.
314 + if ( in_array( $data['visualizer-chart-type'], array( 'tabular' ), true ) ) {
315 + $data['visualizer-data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
316 + }
214 317
215 - $schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_SCHEDULE, true );
318 + if ( ! isset( $data['visualizer-settings']['hAxis']['format'] ) ) {
319 + $data['visualizer-settings']['hAxis']['format'] = '';
320 + }
216 321
217 - if ( ! empty( $import ) && ! empty( $schedule ) ) {
218 - $data['visualizer-chart-url'] = $import;
219 - $data['visualizer-chart-schedule'] = $schedule;
220 - }
322 + $data['visualizer-data-exploded'] = '';
323 + // handle annotations for google charts
324 + if ( 'GoogleCharts' === $library ) {
325 + // this will contain the data of both axis.
326 + $settings = $data['visualizer-settings'];
327 + // this will contain data only of Y axis.
328 + $series = $data['visualizer-series'];
329 + $annotations = array();
330 + if ( isset( $settings['series'] ) ) {
331 + foreach ( $settings['series'] as $index => $serie ) {
332 + // skip X axis data.
333 + if ( $index === 0 ) {
334 + continue;
335 + }
336 + if ( ! empty( $serie['role'] ) ) {
337 + // this series is some kind of annotation, so let's collect its index.
338 + // the index will be +1 because the X axis value is index 0, which is being ignored.
339 + $annotations[ 'role' . ( intval( $index ) + 1 ) ] = $serie['role'];
221 340
222 - if ( VISUALIZER_PRO ) {
223 - $permissions = get_post_meta( $post_id, Visualizer_PRO::CF_PERMISSIONS, true );
341 + if ( isset( $data['visualizer-series'][ intval( $index ) + 1 ] ) ) {
342 + $data['visualizer-series'][ intval( $index ) + 1 ]['role'] = $serie['role'];
343 + }
344 + }
345 + }
346 + }
347 + if ( ! empty( $annotations ) ) {
348 + $exploded_data = array();
349 + $series_names = array();
350 + foreach ( $series as $index => $serie ) {
351 + // skip X axis data.
352 + if ( $index === 0 ) {
353 + continue;
354 + }
355 + if ( array_key_exists( 'role' . $index, $annotations ) ) {
356 + $series_names[] = (object) array( 'role' => $annotations[ 'role' . $index ], 'type' => $serie['type'] );
357 + } else {
358 + $series_names[] = $serie['label'];
359 + }
360 + }
361 + $exploded_data[] = $series_names;
224 362
225 - if ( ! empty( $permissions ) ) {
226 - $data['visualizer-permissions'] = $permissions;
363 + foreach ( $data['visualizer-data'] as $datum ) {
364 + // skip X axis data.
365 + unset( $datum[0] );
366 + $exploded_data[] = $datum;
367 + }
368 + $data['visualizer-data-exploded'] = array( $exploded_data );
227 369 }
228 370 }
229 371
230 - return $data;
231 - }
372 + $import = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_URL, true );
232 373
233 - /**
234 - * Rest Callback Method
235 - */
236 - public function update_chart_data( $data ) {
237 - if ( $data['id'] && ! is_wp_error( $data['id'] ) ) {
374 + $schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_CHART_SCHEDULE, true );
238 375
239 - update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_TYPE, $data['visualizer-chart-type'] );
240 - update_post_meta( $data['id'], Visualizer_Plugin::CF_SOURCE, $data['visualizer-source'] );
241 - update_post_meta( $data['id'], Visualizer_Plugin::CF_DEFAULT_DATA, $data['visualizer-default-data'] );
242 - update_post_meta( $data['id'], Visualizer_Plugin::CF_SERIES, $data['visualizer-series'] );
243 - update_post_meta( $data['id'], Visualizer_Plugin::CF_SETTINGS, $data['visualizer-settings'] );
376 + $db_schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_DB_SCHEDULE, true );
244 377
245 - if ( $data['visualizer-chart-url'] && $data['visualizer-chart-schedule'] ) {
246 - update_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL, $data['visualizer-chart-url'] );
247 - apply_filters( 'visualizer_pro_chart_schedule', $data['id'], $data['visualizer-chart-url'], $data['visualizer-chart-schedule'] );
248 - } else {
249 - delete_post_meta( $data['id'], Visualizer_Plugin::CF_CHART_URL );
250 - apply_filters( 'visualizer_pro_remove_schedule', $data['id'] );
251 - }
378 + $db_query = get_post_meta( $post_id, Visualizer_Plugin::CF_DB_QUERY, true );
252 379
253 - if ( VISUALIZER_PRO ) {
254 - update_post_meta( $data['id'], Visualizer_PRO::CF_PERMISSIONS, $data['visualizer-permissions'] );
255 - }
380 + $json_url = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_URL, true );
256 381
257 - if ( $data['visualizer-chart-url'] ) {
258 - $content['source'] = $data['visualizer-chart-url'];
259 - $content['data'] = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
260 - } else {
261 - $content = $this->format_chart_data( $data['visualizer-data'], $data['visualizer-series'] );
262 - }
382 + $json_headers = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_HEADERS, true );
263 383
264 - $chart = array(
265 - 'ID' => $data['id'],
266 - 'post_content' => serialize( $content ),
267 - );
384 + $json_schedule = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_SCHEDULE, true );
268 385
269 - wp_update_post( $chart );
386 + $json_root = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_ROOT, true );
270 387
271 - $revisions = wp_get_post_revisions( $data['id'], array( 'order' => 'ASC' ) );
388 + $json_paging = get_post_meta( $post_id, Visualizer_Plugin::CF_JSON_PAGING, true );
272 389
273 - if ( count( $revisions ) > 1 ) {
274 - $revision_ids = array_keys( $revisions );
390 + if ( ! empty( $import ) && $schedule >= 0 ) {
391 + $data['visualizer-chart-url'] = $import;
392 + $data['visualizer-chart-schedule'] = $schedule;
393 + }
275 394
276 - // delete all revisions.
277 - foreach ( $revision_ids as $id ) {
278 - wp_delete_post_revision( $id );
279 - }
395 + if ( ! empty( $db_schedule ) && ! empty( $db_query ) ) {
396 + $data['visualizer-db-schedule'] = $db_schedule;
397 + $data['visualizer-db-query'] = $db_query;
398 + }
399 +
400 + if ( ! empty( $json_url ) ) {
401 + $data['visualizer-json-schedule'] = $json_schedule;
402 + $data['visualizer-json-url'] = $json_url;
403 + $data['visualizer-json-headers'] = $json_headers;
404 + $data['visualizer-json-root'] = $json_root;
405 +
406 + if ( Visualizer_Module::is_pro() && ! empty( $json_paging ) ) {
407 + $data['visualizer-json-paging'] = $json_paging;
280 408 }
409 + }
281 410
282 - return new \WP_REST_Response( array( 'success' => sprintf( 'Chart updated' ) ) );
411 + if ( Visualizer_Module::is_pro() ) {
412 + $permissions = get_post_meta( $post_id, Visualizer_Pro::CF_PERMISSIONS, true );
413 +
414 + if ( empty( $permissions ) ) {
415 + $permissions = array(
416 + 'permissions' => array(
417 + 'read' => 'all',
418 + 'edit' => 'roles',
419 + 'edit-specific' => array( 'administrator' ),
420 + ),
421 + );
422 + }
423 +
424 + $data['visualizer-permissions'] = $permissions;
283 425 }
426 +
427 + return $data;
284 428 }
285 429
286 430 /**
287 431 * Format chart data.
432 + *
433 + * Note: No matter how tempted, don't use the similar method from Visualizer_Source. That works on a different structure.
288 434 */
289 435 public function format_chart_data( $data, $series ) {
290 436 foreach ( $series as $i => $row ) {
291 - // if no value exists for the seires, then add null
437 + // if no value exists for the series, then add null
292 438 if ( ! isset( $series[ $i ] ) ) {
293 439 $series[ $i ] = null;
294 440 }
295 441
@@ -296,39 +442,38 @@
296 442 if ( is_null( $series[ $i ] ) ) {
297 443 continue;
298 444 }
299 445
300 - if ( $row['type'] == 'number' ) {
301 - foreach ( $data as $o => $col ) {
302 - $data[ $o ][ $i ] = ( is_numeric( $col[ $i ] ) ) ? floatval( $col[ $i ] ) : ( is_numeric( str_replace( ',', '', $col[ $i ] ) ) ? floatval( str_replace( ',', '', $col[ $i ] ) ) : null );
303 - }
304 - }
305 -
306 - if ( $row['type'] == 'boolean' ) {
307 - foreach ( $data as $o => $col ) {
308 - $data[ $o ][ $i ] = ! empty( $col[ $i ] ) ? filter_validate( $col[ $i ], FILTER_VALIDATE_BOOLEAN ) : null;
309 - }
310 - }
311 -
312 - if ( $row['type'] == 'timeofday' ) {
313 - foreach ( $data as $o => $col ) {
314 - $date = new DateTime( '1984-03-16T' . $col[ $i ] );
315 - if ( $date ) {
316 - $data[ $o ][ $i ] = array(
317 - intval( $date->format( 'H' ) ),
318 - intval( $date->format( 'i' ) ),
319 - intval( $date->format( 's' ) ),
320 - 0,
321 - );
446 + switch ( $row['type'] ) {
447 + case 'number':
448 + foreach ( $data as $o => $col ) {
449 + $data[ $o ][ $i ] = ( is_numeric( $col[ $i ] ) ) ? floatval( $col[ $i ] ) : ( is_numeric( str_replace( ',', '', $col[ $i ] ) ) ? floatval( str_replace( ',', '', $col[ $i ] ) ) : null );
322 450 }
323 - }
451 + break;
452 + case 'boolean':
453 + foreach ( $data as $o => $col ) {
454 + $data[ $o ][ $i ] = ! empty( $col[ $i ] ) ? filter_var( $col[ $i ], FILTER_VALIDATE_BOOLEAN ) : false;
455 + }
456 + break;
457 + case 'timeofday':
458 + foreach ( $data as $o => $col ) {
459 + $date = new DateTime( '1984-03-16T' . $col[ $i ] );
460 + if ( $date ) {
461 + $data[ $o ][ $i ] = array(
462 + intval( $date->format( 'H' ) ),
463 + intval( $date->format( 'i' ) ),
464 + intval( $date->format( 's' ) ),
465 + 0,
466 + );
467 + }
468 + }
469 + break;
470 + case 'string':
471 + foreach ( $data as $o => $col ) {
472 + $data[ $o ][ $i ] = $this->toUTF8( $col[ $i ] );
473 + }
474 + break;
324 475 }
325 -
326 - if ( $row['type'] == 'string' ) {
327 - foreach ( $data as $o => $col ) {
328 - $data[ $o ][ $i ] = $this->toUTF8( $col[ $i ] );
329 - }
330 - }
331 476 }
332 477
333 478 return $data;
334 479 }
@@ -343,70 +488,25 @@
343 488 return $datum;
344 489 }
345 490
346 491 /**
347 - * Handle remote CSV data
492 + * Filter Rest Query
348 493 */
349 - public function upload_csv_data( $data ) {
350 - if ( $data['url'] && ! is_wp_error( $data['url'] ) && filter_var( $data['url'], FILTER_VALIDATE_URL ) ) {
351 - $source = new Visualizer_Source_Csv_Remote( $data['url'] );
352 - if ( $source->fetch() ) {
353 - $temp = $source->getData();
354 - if ( is_string( $temp ) && is_array( unserialize( $temp ) ) ) {
355 - $content['series'] = $source->getSeries();
356 - $content['data'] = $source->getRawData();
357 - return $content;
358 - } else {
359 - return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
360 - }
361 - } else {
362 - return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
363 - }
364 - } else {
365 - return new \WP_REST_Response( array( 'failed' => sprintf( 'Invalid CSV URL' ) ) );
494 + public function add_rest_query_vars( $args, \WP_REST_Request $request ) {
495 + if ( isset( $request['meta_key'] ) && isset( $request['meta_value'] ) ) {
496 + $args['meta_query'] = array(
497 + 'relation' => 'OR',
498 + array(
499 + 'key' => $request->get_param( 'meta_key' ),
500 + 'value' => $request->get_param( 'meta_value' ),
501 + 'compare' => '!=',
502 + ),
503 + array(
504 + 'key' => $request->get_param( 'meta_key' ),
505 + 'value' => $request->get_param( 'meta_value' ),
506 + 'compare' => 'NOT EXISTS',
507 + ),
508 + );
366 509 }
510 + return $args;
367 511 }
368 -
369 - /**
370 - * Get permission data
371 - */
372 - public function get_permission_data( $data ) {
373 - $options = array();
374 - switch ( $data['type'] ) {
375 - case 'users':
376 - $query = new WP_User_Query(
377 - array(
378 - 'number' => 1000,
379 - 'orderby' => 'display_name',
380 - 'fields' => array( 'ID', 'display_name' ),
381 - 'count_total' => false,
382 - )
383 - );
384 - $users = $query->get_results();
385 - if ( ! empty( $users ) ) {
386 - $i = 0;
387 - foreach ( $users as $user ) {
388 - $options[ $i ]['value'] = $user->ID;
389 - $options[ $i ]['label'] = $user->display_name;
390 - $i++;
391 - }
392 - }
393 - break;
394 - case 'roles':
395 - if ( ! function_exists( 'get_editable_roles' ) ) {
396 - require_once ABSPATH . 'wp-admin/includes/user.php';
397 - }
398 - $roles = get_editable_roles();
399 - if ( ! empty( $roles ) ) {
400 - $i = 0;
401 - foreach ( get_editable_roles() as $name => $info ) {
402 - $options[ $i ]['value'] = $name;
403 - $options[ $i ]['label'] = $name;
404 - $i++;
405 - }
406 - }
407 - break;
408 - }
409 - return $options;
410 - }
411 -
412 512 }