PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 1.7.1
Visualizer – Tables & Charts Manager with Built-in AI Generator v1.7.1
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 3.10.4 All 148 releases
← All changes | classes/Visualizer/Module/Chart.php +325 -325 3.0.81.7.1 View file →
@@ -1,5 +1,6 @@
1 1 <?php
2 +
2 3 // +----------------------------------------------------------------------+
3 4 // | Copyright 2013 Madpixels (email : visualizer@madpixels.net) |
4 5 // +----------------------------------------------------------------------+
5 6 // | This program is free software; you can redistribute it and/or modify |
@@ -45,13 +46,13 @@
45 46 *
46 47 * @since 1.0.0
47 48 *
48 49 * @access public
49 - *
50 50 * @param Visualizer_Plugin $plugin The instance of the plugin.
51 51 */
52 52 public function __construct( Visualizer_Plugin $plugin ) {
53 53 parent::__construct( $plugin );
54 +
54 55 $this->_addAjaxAction( Visualizer_Plugin::ACTION_GET_CHARTS, 'getCharts' );
55 56 $this->_addAjaxAction( Visualizer_Plugin::ACTION_DELETE_CHART, 'deleteChart' );
56 57 $this->_addAjaxAction( Visualizer_Plugin::ACTION_CREATE_CHART, 'renderChartPages' );
57 58 $this->_addAjaxAction( Visualizer_Plugin::ACTION_EDIT_CHART, 'renderChartPages' );
@@ -56,61 +57,33 @@
56 57 $this->_addAjaxAction( Visualizer_Plugin::ACTION_CREATE_CHART, 'renderChartPages' );
57 58 $this->_addAjaxAction( Visualizer_Plugin::ACTION_EDIT_CHART, 'renderChartPages' );
58 59 $this->_addAjaxAction( Visualizer_Plugin::ACTION_UPLOAD_DATA, 'uploadData' );
59 60 $this->_addAjaxAction( Visualizer_Plugin::ACTION_CLONE_CHART, 'cloneChart' );
61 +
62 + // Added by Ash/Upwork
60 63 $this->_addAjaxAction( Visualizer_Plugin::ACTION_EXPORT_DATA, 'exportData' );
64 + if ( defined( 'Visualizer_Pro' ) ) {
65 + global $Visualizer_Pro;
66 + list($action, $name, $class) = $Visualizer_Pro->_getAjaxAction( $this );
67 + $this->_addAjaxAction( $action, $name, $class );
68 + }
69 + // Added by Ash/Upwork
61 70 }
62 71
63 72 /**
64 - * Fetches charts from database.
73 + * Sends json response.
65 74 *
66 75 * @since 1.0.0
67 76 *
68 - * @access public
77 + * @access private
78 + * @param array $results The response array.
69 79 */
70 - public function getCharts() {
71 - $query_args = array(
72 - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
73 - 'posts_per_page' => 9,
74 - 'paged' => filter_input(
75 - INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
76 - 'options' => array(
77 - 'min_range' => 1,
78 - 'default' => 1,
79 - ),
80 - )
81 - ),
82 - );
83 - $filter = filter_input( INPUT_GET, 's', FILTER_SANITIZE_STRING );
84 - if ( empty( $filter ) ) {
85 - // 'filter' is from the modal from the add media button.
86 - $filter = filter_input( INPUT_GET, 'filter', FILTER_SANITIZE_STRING );
87 - }
80 + public function _sendResponse( $results ) {
81 + header( 'Content-type: application/json' );
82 + nocache_headers();
88 83
89 - if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes() ) ) {
90 - $query_args['meta_query'] = array(
91 - array(
92 - 'key' => Visualizer_Plugin::CF_CHART_TYPE,
93 - 'value' => $filter,
94 - 'compare' => '=',
95 - ),
96 - );
97 - }
98 - $query = new WP_Query( $query_args );
99 - $charts = array();
100 - while ( $query->have_posts() ) {
101 - $chart = $query->next_post();
102 - $chart_data = $this->_getChartArray( $chart );
103 - $chart_data['id'] = $chart->ID;
104 - $charts[] = $chart_data;
105 - }
106 - self::_sendResponse(
107 - array(
108 - 'success' => true,
109 - 'data' => $charts,
110 - 'total' => $query->max_num_pages,
111 - )
112 - );
84 + echo json_encode( $results );
85 + exit;
113 86 }
114 87
115 88 /**
116 89 * Returns chart data required for rendering.
@@ -117,11 +90,9 @@
117 90 *
118 91 * @since 1.0.0
119 92 *
120 93 * @access private
121 - *
122 94 * @param WP_Post $chart The chart object.
123 - *
124 95 * @return array The array of chart data.
125 96 */
126 97 private function _getChartArray( WP_Post $chart = null ) {
127 98 if ( is_null( $chart ) ) {
@@ -126,11 +97,12 @@
126 97 private function _getChartArray( WP_Post $chart = null ) {
127 98 if ( is_null( $chart ) ) {
128 99 $chart = $this->_chart;
129 100 }
130 - $type = get_post_meta( $chart->ID, Visualizer_Plugin::CF_CHART_TYPE, true );
101 +
102 + $type = get_post_meta( $chart->ID, Visualizer_Plugin::CF_CHART_TYPE, true );
131 103 $series = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_SERIES, get_post_meta( $chart->ID, Visualizer_Plugin::CF_SERIES, true ), $chart->ID, $type );
132 - $data = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, unserialize( $chart->post_content ), $chart->ID, $type );
104 + $data = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, unserialize( $chart->post_content ), $chart->ID, $type );
133 105
134 106 return array(
135 107 'type' => $type,
136 108 'series' => $series,
@@ -139,21 +111,54 @@
139 111 );
140 112 }
141 113
142 114 /**
143 - * Sends json response.
115 + * Fetches charts from database.
144 116 *
145 117 * @since 1.0.0
146 118 *
147 - * @access private
148 - *
149 - * @param array $results The response array.
119 + * @access public
150 120 */
151 - public static function _sendResponse( $results ) {
152 - header( 'Content-type: application/json' );
153 - nocache_headers();
154 - echo json_encode( $results );
155 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
121 + public function getCharts() {
122 + $query_args = array(
123 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
124 + 'posts_per_page' => 9,
125 + 'paged' => filter_input( INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
126 + 'options' => array(
127 + 'min_range' => 1,
128 + 'default' => 1,
129 + ),
130 + ) ),
131 + );
132 +
133 + $filter = filter_input( INPUT_GET, 'filter', FILTER_SANITIZE_STRING );
134 + if ( $filter && in_array( $filter, Visualizer_Plugin::getChartTypes() ) ) {
135 + $query_args['meta_query'] = array(
136 + array(
137 + 'key' => Visualizer_Plugin::CF_CHART_TYPE,
138 + 'value' => $filter,
139 + 'compare' => '=',
140 + ),
141 + );
142 + }
143 +
144 + $query = new WP_Query( $query_args );
145 +
146 + $charts = array();
147 + while ( $query->have_posts() ) {
148 + $chart = $query->next_post();
149 +
150 + $chart_data = $this->_getChartArray( $chart );
151 + $chart_data['id'] = $chart->ID;
152 +
153 + $charts[] = $chart_data;
154 + }
155 +
156 + $this->_sendResponse( array(
157 + 'success' => true,
158 + 'data' => $charts,
159 + 'total' => $query->max_num_pages,
160 + ) );
156 161 }
157 162
158 163 /**
159 164 * Deletes a chart from database.
@@ -163,36 +168,30 @@
163 168 *
164 169 * @access public
165 170 */
166 171 public function deleteChart() {
167 - $is_post = $_SERVER['REQUEST_METHOD'] == 'POST';
172 + $is_post = $_SERVER['REQUEST_METHOD'] == 'POST';
168 173 $input_method = $is_post ? INPUT_POST : INPUT_GET;
169 - $chart_id = $success = false;
170 - $nonce = wp_verify_nonce( filter_input( $input_method, 'nonce' ) );
171 - $capable = current_user_can( 'delete_posts' );
174 +
175 + $chart_id = $success = false;
176 + $nonce = wp_verify_nonce( filter_input( $input_method, 'nonce' ) );
177 + $capable = current_user_can( 'delete_posts' );
172 178 if ( $nonce && $capable ) {
173 - $chart_id = filter_input(
174 - $input_method, 'chart', FILTER_VALIDATE_INT, array(
175 - 'options' => array(
176 - 'min_range' => 1,
177 - ),
178 - )
179 - );
179 + $chart_id = filter_input( $input_method, 'chart', FILTER_VALIDATE_INT, array( 'options' => array( 'min_range' => 1 ) ) );
180 180 if ( $chart_id ) {
181 - $chart = get_post( $chart_id );
181 + $chart = get_post( $chart_id );
182 182 $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
183 183 }
184 184 }
185 +
185 186 if ( $success ) {
186 187 wp_delete_post( $chart_id, true );
187 188 }
189 +
188 190 if ( $is_post ) {
189 - self::_sendResponse(
190 - array(
191 - 'success' => $success,
192 - )
193 - );
191 + $this->_sendResponse( array( 'success' => $success ) );
194 192 }
193 +
195 194 wp_redirect( wp_get_referer() );
196 195 exit;
197 196 }
198 197
@@ -204,221 +203,228 @@
204 203 *
205 204 * @access public
206 205 */
207 206 public function renderChartPages() {
208 - defined( 'IFRAME_REQUEST' ) || define( 'IFRAME_REQUEST', 1 );
207 + define( 'IFRAME_REQUEST', 1 );
208 +
209 209 // check chart, if chart not exists, will create new one and redirects to the same page with proper chart id
210 - $chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT ) : '';
210 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT );
211 211 if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
212 - $default_type = isset( $_GET['type'] ) && ! empty( $_GET['type'] ) ? $_GET['type'] : 'line';
213 - $source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $default_type . '.csv' );
212 + $default_type = 'line';
213 +
214 + $source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $default_type . '.csv' );
214 215 $source->fetch();
215 - $chart_id = wp_insert_post(
216 - array(
217 - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
218 - 'post_title' => 'Visualization',
219 - 'post_author' => get_current_user_id(),
220 - 'post_status' => 'auto-draft',
221 - 'post_content' => $source->getData(),
222 - )
223 - );
216 +
217 + $chart_id = wp_insert_post( array(
218 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
219 + 'post_title' => 'Visualization',
220 + 'post_author' => get_current_user_id(),
221 + 'post_status' => 'auto-draft',
222 + 'post_content' => $source->getData(),
223 + ) );
224 +
224 225 if ( $chart_id && ! is_wp_error( $chart_id ) ) {
225 226 add_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, $default_type );
226 227 add_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, 1 );
227 228 add_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
228 229 add_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
229 - add_post_meta(
230 - $chart_id, Visualizer_Plugin::CF_SETTINGS, array(
231 - 'focusTarget' => 'datum',
232 - )
233 - );
234 - do_action( 'visualizer_pro_new_chart_defaults', $chart_id );
230 + add_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, array( 'focusTarget' => 'datum' ) );
235 231 }
232 +
236 233 wp_redirect( add_query_arg( 'chart', (int) $chart_id ) );
237 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
234 + exit;
238 235 }
236 +
239 237 // enqueue and register scripts and styles
240 - wp_register_script( 'visualizer-chosen', VISUALIZER_ABSURL . 'js/lib/chosen.jquery.min.js', array( 'jquery' ), Visualizer_Plugin::VERSION );
241 - wp_register_style( 'visualizer-chosen', VISUALIZER_ABSURL . 'css/lib/chosen.min.css', array(), Visualizer_Plugin::VERSION );
238 + wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array(), Visualizer_Plugin::VERSION );
242 239
243 - wp_register_style( 'visualizer-frame', VISUALIZER_ABSURL . 'css/frame.css', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION );
244 - wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'visualizer-chosen' ), Visualizer_Plugin::VERSION, true );
240 + wp_register_script( 'visualizer-frame', VISUALIZER_ABSURL . 'js/frame.js', array( 'jquery' ), Visualizer_Plugin::VERSION, true );
245 241 wp_register_script( 'google-jsapi-new', '//www.gstatic.com/charts/loader.js', array(), null, true );
246 242 wp_register_script( 'google-jsapi-old', '//www.google.com/jsapi', array( 'google-jsapi-new' ), null, true );
247 - wp_register_script(
248 - 'visualizer-render', VISUALIZER_ABSURL . 'js/render.js', array(
249 - 'google-jsapi-old',
250 - 'google-jsapi-new',
251 - 'visualizer-frame',
252 - ), Visualizer_Plugin::VERSION, true
253 - );
254 - wp_register_script(
255 - 'visualizer-preview', VISUALIZER_ABSURL . 'js/preview.js', array(
256 - 'wp-color-picker',
257 - 'visualizer-render',
258 - ), Visualizer_Plugin::VERSION, true
259 - );
243 + wp_register_script( 'visualizer-render', VISUALIZER_ABSURL . 'js/render.js', array( 'google-jsapi-old', 'google-jsapi-new', 'visualizer-frame' ), Visualizer_Plugin::VERSION, true );
244 + wp_register_script( 'visualizer-preview', VISUALIZER_ABSURL . 'js/preview.js', array( 'wp-color-picker', 'visualizer-render' ), Visualizer_Plugin::VERSION, true );
245 +
260 246 // added by Ash/Upwork
261 - if ( VISUALIZER_PRO ) {
247 + if ( defined( 'Visualizer_Pro' ) ) {
262 248 global $Visualizer_Pro;
263 249 $Visualizer_Pro->_addScriptsAndStyles();
264 250 }
251 +
265 252 // dispatch pages
266 - $this->_chart = get_post( $chart_id );
267 - $tab = isset( $_GET['tab'] ) && ! empty( $_GET['tab'] ) ? $_GET['tab'] : 'visualizer';
268 -
269 - // skip chart type pages only for existing charts.
270 - if ( VISUALIZER_SKIP_CHART_TYPE_PAGE && 'auto-draft' !== $this->_chart->post_status && ( ! empty( $_GET['tab'] ) && 'visualizer' === $_GET['tab'] ) ) {
271 - $tab = 'settings';
272 - }
273 -
274 - if ( isset( $_POST['cancel'] ) && 1 === intval( $_POST['cancel'] ) ) {
275 - // if the cancel button is clicked.
276 - $this->undoRevisions( $chart_id, true );
277 - } elseif ( isset( $_POST['save'] ) && 1 === intval( $_POST['save'] ) ) {
278 - // if the save button is clicked.
279 - $this->undoRevisions( $chart_id, false );
280 - } else {
281 - // if the edit button is clicked.
282 - $this->_chart = $this->handleExistingRevisions( $chart_id, $this->_chart );
283 - }
284 -
285 - switch ( $tab ) {
253 + $this->_chart = $chart;
254 + switch ( filter_input( INPUT_GET, 'tab' ) ) {
286 255 case 'settings':
256 + // changed by Ash/Upwork
287 257 $this->_handleDataAndSettingsPage();
288 258 break;
289 - case 'type': // fall through.
290 - case 'visualizer': // fall through.
259 + case 'type':
260 + default:
291 261 $this->_handleTypesPage();
292 262 break;
293 - default:
294 - do_action( 'visualizer_pro_handle_tab', $tab, $this->_chart );
295 - break;
296 263 }
297 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
264 +
265 + exit;
298 266 }
299 267
300 268 /**
269 + * Handles chart type selection page.
270 + *
271 + * @since 1.0.0
272 + *
273 + * @access private
274 + */
275 + private function _handleTypesPage() {
276 + // process post request
277 + if ( $_SERVER['REQUEST_METHOD'] == 'POST' && wp_verify_nonce( filter_input( INPUT_POST, 'nonce' ) ) ) {
278 + $type = filter_input( INPUT_POST, 'type' );
279 + if ( in_array( $type, Visualizer_Plugin::getChartTypes() ) ) {
280 + // save new chart type
281 + update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, $type );
282 +
283 + // if the chart has default data, update it with appropriate default data for new type
284 + if ( filter_var( get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, true ), FILTER_VALIDATE_BOOLEAN ) ) {
285 + $source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $type . '.csv' );
286 + $source->fetch();
287 +
288 + $this->_chart->post_content = $source->getData();
289 + wp_update_post( $this->_chart->to_array() );
290 +
291 + update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
292 + }
293 +
294 + // redirect to next tab
295 + // changed by Ash/Upwork
296 + wp_redirect( add_query_arg( 'tab', 'settings' ) );
297 + return;
298 + }
299 + }
300 +
301 + $render = new Visualizer_Render_Page_Types();
302 + $render->type = get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, true );
303 + $render->types = Visualizer_Plugin::getChartTypes();
304 + $render->chart = $this->_chart;
305 +
306 + wp_enqueue_style( 'visualizer-frame' );
307 + wp_enqueue_script( 'visualizer-frame' );
308 +
309 + wp_iframe( array( $render, 'render' ) );
310 + }
311 +
312 + /**
313 + * Handles chart data page.
314 + *
315 + * @since 1.0.0
316 + *
317 + * @access private
318 + */
319 + private function _handleDataPage() {
320 + $data = $this->_getChartArray();
321 +
322 + $render = new Visualizer_Render_Page_Data();
323 + $render->chart = $this->_chart;
324 + $render->type = $data['type'];
325 +
326 + unset( $data['settings']['width'], $data['settings']['height'] );
327 +
328 + wp_enqueue_style( 'visualizer-frame' );
329 + wp_enqueue_script( 'visualizer-render' );
330 + wp_localize_script( 'visualizer-render', 'visualizer', array(
331 + 'l10n' => array(
332 + 'remotecsv_prompt' => esc_html__( 'Please, enter the URL of CSV file:', 'visualizer' ),
333 + 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
334 + ),
335 + 'charts' => array(
336 + 'canvas' => $data,
337 + ),
338 + ) );
339 +
340 + // Added by Ash/Upwork
341 + if ( defined( 'Visualizer_Pro' ) ) {
342 + global $Visualizer_Pro;
343 + $Visualizer_Pro->_enqueueScriptsAndStyles( $data );
344 + }
345 + // Added by Ash/Upwork
346 + $this->_addAction( 'admin_head', 'renderFlattrScript' );
347 +
348 + wp_iframe( array( $render, 'render' ) );
349 + }
350 +
351 + /**
301 352 * Handle data and settings page
302 353 */
303 354 private function _handleDataAndSettingsPage() {
304 - if ( isset( $_POST['map_api_key'] ) ) {
305 - update_option( 'visualizer-map-api-key', $_POST['map_api_key'] );
306 - }
307 - if ( $_SERVER['REQUEST_METHOD'] == 'POST' && isset( $_GET['nonce'] ) && wp_verify_nonce( $_GET['nonce'] ) ) {
355 + if ( $_SERVER['REQUEST_METHOD'] == 'POST' && wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ) ) ) {
308 356 if ( $this->_chart->post_status == 'auto-draft' ) {
309 357 $this->_chart->post_status = 'publish';
310 358 wp_update_post( $this->_chart->to_array() );
311 359 }
360 +
312 361 update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SETTINGS, $_POST );
313 - $render = new Visualizer_Render_Page_Send();
362 +
363 + $render = new Visualizer_Render_Page_Send();
314 364 $render->text = sprintf( '[visualizer id="%d"]', $this->_chart->ID );
365 +
315 366 wp_iframe( array( $render, 'render' ) );
316 -
317 367 return;
318 368 }
319 - $data = $this->_getChartArray();
320 - $sidebar = '';
369 +
370 + $data = $this->_getChartArray();
371 +
372 + $sidebar = '';
321 373 $sidebar_class = 'Visualizer_Render_Sidebar_Type_' . ucfirst( $data['type'] );
322 374 if ( class_exists( $sidebar_class, true ) ) {
323 - $sidebar = new $sidebar_class( $data['settings'] );
375 + $sidebar = new $sidebar_class( $data['settings'] );
324 376 $sidebar->__series = $data['series'];
325 - $sidebar->__data = $data['data'];
377 + $sidebar->__data = $data['data'];
326 378 } else {
327 - $sidebar = apply_filters( 'visualizer_pro_chart_type_sidebar', '', $data );
379 + $sidebar = apply_filters( 'visualizer_pro_chart_type_sidebar', '', $data );
328 380 if ( $sidebar != '' ) {
329 381 $sidebar->__series = $data['series'];
330 - $sidebar->__data = $data['data'];
382 + $sidebar->__data = $data['data'];
331 383 }
332 384 }
385 +
333 386 unset( $data['settings']['width'], $data['settings']['height'] );
387 +
334 388 wp_enqueue_style( 'visualizer-frame' );
335 389 wp_enqueue_style( 'wp-color-picker' );
336 390 wp_enqueue_style( 'visualizer-frame' );
391 +
337 392 wp_enqueue_script( 'visualizer-preview' );
338 393 wp_enqueue_script( 'visualizer-render' );
339 - wp_localize_script(
340 - 'visualizer-render', 'visualizer', array(
341 - 'l10n' => array(
342 - 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
343 - 'loading' => esc_html__( 'Loading...', 'visualizer' ),
344 - ),
345 - 'charts' => array(
346 - 'canvas' => $data,
347 - ),
348 - 'language' => $this->get_language(),
349 - 'map_api_key' => get_option( 'visualizer-map-api-key' ),
350 - 'ajax' => array(
351 - 'url' => admin_url( 'admin-ajax.php' ),
352 - 'nonces' => array(
353 - 'permissions' => wp_create_nonce( Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA ),
354 - ),
355 - 'actions' => array(
356 - 'permissions' => Visualizer_Plugin::ACTION_FETCH_PERMISSIONS_DATA,
357 - ),
358 - ),
359 - )
360 - );
361 - $render = new Visualizer_Render_Page_Data();
362 - $render->chart = $this->_chart;
363 - $render->type = $data['type'];
394 + wp_localize_script( 'visualizer-render', 'visualizer', array(
395 + 'l10n' => array(
396 + 'remotecsv_prompt' => esc_html__( 'Please, enter the URL of CSV file:', 'visualizer' ),
397 + 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
398 + ),
399 + 'charts' => array(
400 + 'canvas' => $data,
401 + ),
402 + ) );
403 +
404 + $render = new Visualizer_Render_Page_Data();
405 + $render->chart = $this->_chart;
406 + $render->type = $data['type'];
407 +
364 408 $render->sidebar = $sidebar;
365 409 if ( filter_input( INPUT_GET, 'library', FILTER_VALIDATE_BOOLEAN ) ) {
366 410 $render->button = filter_input( INPUT_GET, 'action' ) == Visualizer_Plugin::ACTION_EDIT_CHART
367 411 ? esc_html__( 'Save Chart', 'visualizer' )
368 412 : esc_html__( 'Create Chart', 'visualizer' );
369 - if ( filter_input( INPUT_GET, 'action' ) == Visualizer_Plugin::ACTION_EDIT_CHART ) {
370 - $render->cancel_button = esc_html__( 'Cancel', 'visualizer' );
371 - }
372 413 } else {
373 414 $render->button = esc_attr__( 'Insert Chart', 'visualizer' );
374 415 }
375 - if ( VISUALIZER_PRO ) {
416 +
417 + if ( defined( 'Visualizer_Pro' ) ) {
376 418 global $Visualizer_Pro;
377 419 $Visualizer_Pro->_enqueueScriptsAndStyles( $data );
378 420 }
421 +
379 422 $this->_addAction( 'admin_head', 'renderFlattrScript' );
380 - wp_iframe( array( $render, 'render' ) );
381 - }
382 423
383 - /**
384 - * Handles chart type selection page.
385 - *
386 - * @since 1.0.0
387 - *
388 - * @access private
389 - */
390 - private function _handleTypesPage() {
391 - // process post request
392 - if ( $_SERVER['REQUEST_METHOD'] == 'POST' && wp_verify_nonce( filter_input( INPUT_POST, 'nonce' ) ) ) {
393 - $type = filter_input( INPUT_POST, 'type' );
394 - if ( in_array( $type, Visualizer_Plugin::getChartTypes() ) ) {
395 - // save new chart type
396 - update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, $type );
397 - // if the chart has default data, update it with appropriate default data for new type
398 - if ( filter_var( get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, true ), FILTER_VALIDATE_BOOLEAN ) ) {
399 - $source = new Visualizer_Source_Csv( VISUALIZER_ABSPATH . DIRECTORY_SEPARATOR . 'samples' . DIRECTORY_SEPARATOR . $type . '.csv' );
400 - $source->fetch();
401 - $this->_chart->post_content = $source->getData();
402 - wp_update_post( $this->_chart->to_array() );
403 - update_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
404 - }
405 - // redirect to next tab
406 - // changed by Ash/Upwork
407 - wp_redirect( add_query_arg( 'tab', 'settings' ) );
408 -
409 - return;
410 - }
411 - }
412 - $render = new Visualizer_Render_Page_Types();
413 - $render->type = get_post_meta( $this->_chart->ID, Visualizer_Plugin::CF_CHART_TYPE, true );
414 - $render->types = Visualizer_Module_Admin::_getChartTypesLocalized();
415 - $render->chart = $this->_chart;
416 - wp_enqueue_style( 'visualizer-frame' );
417 - wp_enqueue_script( 'visualizer-frame' );
418 424 wp_iframe( array( $render, 'render' ) );
419 425 }
420 -
426 + // changed by Ash/Upwork
421 427 /**
422 428 * Renders flattr script in the iframe <head>
423 429 *
424 430 * @since 1.4.2
@@ -428,9 +434,9 @@
428 434 */
429 435 public function renderFlattrScript() {
430 436 echo '';
431 437 }
432 - // changed by Ash/Upwork
438 +
433 439 /**
434 440 * Parses uploaded CSV file and saves new data for the chart.
435 441 *
436 442 * @since 1.0.0
@@ -437,73 +443,55 @@
437 443 *
438 444 * @access public
439 445 */
440 446 public function uploadData() {
441 - // if this is being called internally from pro and VISUALIZER_DO_NOT_DIE is set.
442 - // otherwise, assume this is a normal web request.
443 - $can_die = ! ( defined( 'VISUALIZER_DO_NOT_DIE' ) && VISUALIZER_DO_NOT_DIE );
444 -
445 447 // validate nonce
446 - if ( ! isset( $_GET['nonce'] ) || ! wp_verify_nonce( $_GET['nonce'] ) ) {
447 - if ( ! $can_die ) {
448 - return;
449 - }
448 + if ( ! wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ) ) ) {
450 449 status_header( 403 );
451 450 exit;
452 451 }
453 452
454 453 // check chart, if chart exists
455 - // do not use filter_input as it does not work for phpunit test cases, use filter_var instead
456 - $chart_id = isset( $_GET['chart'] ) ? filter_var( $_GET['chart'], FILTER_VALIDATE_INT ) : '';
454 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT );
457 455 if ( ! $chart_id || ! ( $chart = get_post( $chart_id ) ) || $chart->post_type != Visualizer_Plugin::CPT_VISUALIZER ) {
458 - if ( ! $can_die ) {
459 - return;
460 - }
461 456 status_header( 400 );
462 457 exit;
463 458 }
464 459
465 - if ( ! isset( $_POST['vz-import-time'] ) ) {
466 - apply_filters( 'visualizer_pro_remove_schedule', $chart_id );
467 - }
468 -
469 - if ( ! isset( $_POST['chart_data_src'] ) || Visualizer_Plugin::CF_SOURCE_FILTER !== $_POST['chart_data_src'] ) {
470 - // delete the filters in case this chart is being uploaded from other data sources
471 - delete_post_meta( $chart_id, 'visualizer-filter-config' );
472 - }
473 -
474 460 $source = null;
475 461 $render = new Visualizer_Render_Page_Update();
476 - if ( isset( $_POST['remote_data'] ) && filter_var( $_POST['remote_data'], FILTER_VALIDATE_URL ) ) {
462 + if ( filter_input( INPUT_POST, 'remote_data', FILTER_VALIDATE_URL ) ) {
477 463 $source = new Visualizer_Source_Csv_Remote( $_POST['remote_data'] );
478 - if ( isset( $_POST['vz-import-time'] ) ) {
479 - apply_filters( 'visualizer_pro_chart_schedule', $chart_id, $_POST['remote_data'], $_POST['vz-import-time'] );
480 - }
481 464 } elseif ( isset( $_FILES['local_data'] ) && $_FILES['local_data']['error'] == 0 ) {
482 465 $source = new Visualizer_Source_Csv( $_FILES['local_data']['tmp_name'] );
483 - } elseif ( isset( $_POST['chart_data'] ) && strlen( $_POST['chart_data'] ) > 0 ) {
484 - $source = apply_filters( 'visualizer_pro_handle_chart_data', $_POST['chart_data'], '' );
466 +
467 + // Added by Ash/Upwork
468 + } elseif ( defined( 'Visualizer_Pro' ) && isset( $_POST['chart_data'] ) && strlen( $_POST['chart_data'] ) > 0 ) {
469 + global $Visualizer_Pro;
470 + $source = $Visualizer_Pro->_handleChartData( $_POST['chart_data'] );
471 + // Added by Ash/Upwork
485 472 } else {
486 473 $render->message = esc_html__( 'CSV file with chart data was not uploaded. Please, try again.', 'visualizer' );
487 474 }
475 +
488 476 if ( $source ) {
489 477 if ( $source->fetch() ) {
490 478 $chart->post_content = $source->getData();
491 479 wp_update_post( $chart->to_array() );
480 +
492 481 update_post_meta( $chart->ID, Visualizer_Plugin::CF_SERIES, $source->getSeries() );
493 482 update_post_meta( $chart->ID, Visualizer_Plugin::CF_SOURCE, $source->getSourceName() );
494 483 update_post_meta( $chart->ID, Visualizer_Plugin::CF_DEFAULT_DATA, 0 );
495 - $render->data = json_encode( $source->getRawData() );
484 +
485 + $render->data = json_encode( $source->getRawData() );
496 486 $render->series = json_encode( $source->getSeries() );
497 487 } else {
498 488 $render->message = esc_html__( 'CSV file is broken or invalid. Please, try again.', 'visualizer' );
499 489 }
500 490 }
491 +
501 492 $render->render();
502 - if ( ! $can_die ) {
503 - return;
504 - }
505 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
493 + exit;
506 494 }
507 495
508 496 /**
509 497 * Clones the chart.
@@ -513,34 +501,28 @@
513 501 * @access public
514 502 */
515 503 public function cloneChart() {
516 504 $chart_id = $success = false;
517 - $nonce = wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ), Visualizer_Plugin::ACTION_CLONE_CHART );
518 - $capable = current_user_can( 'edit_posts' );
505 + $nonce = wp_verify_nonce( filter_input( INPUT_GET, 'nonce' ), Visualizer_Plugin::ACTION_CLONE_CHART );
506 + $capable = current_user_can( 'edit_posts' );
519 507 if ( $nonce && $capable ) {
520 - $chart_id = filter_input(
521 - INPUT_GET, 'chart', FILTER_VALIDATE_INT, array(
522 - 'options' => array(
523 - 'min_range' => 1,
524 - ),
525 - )
526 - );
508 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT, array( 'options' => array( 'min_range' => 1 ) ) );
527 509 if ( $chart_id ) {
528 - $chart = get_post( $chart_id );
510 + $chart = get_post( $chart_id );
529 511 $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
530 512 }
531 513 }
514 +
532 515 $redirect = wp_get_referer();
533 516 if ( $success ) {
534 - $new_chart_id = wp_insert_post(
535 - array(
536 - 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
537 - 'post_title' => 'Visualization',
538 - 'post_author' => get_current_user_id(),
539 - 'post_status' => $chart->post_status,
540 - 'post_content' => $chart->post_content,
541 - )
542 - );
517 + $new_chart_id = wp_insert_post( array(
518 + 'post_type' => Visualizer_Plugin::CPT_VISUALIZER,
519 + 'post_title' => 'Visualization',
520 + 'post_author' => get_current_user_id(),
521 + 'post_status' => $chart->post_status,
522 + 'post_content' => $chart->post_content,
523 + ) );
524 +
543 525 if ( $new_chart_id && ! is_wp_error( $new_chart_id ) ) {
544 526 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_CHART_TYPE, get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ) );
545 527 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
546 528 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
@@ -545,16 +527,16 @@
545 527 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, get_post_meta( $chart_id, Visualizer_Plugin::CF_DEFAULT_DATA, true ) );
546 528 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SOURCE, get_post_meta( $chart_id, Visualizer_Plugin::CF_SOURCE, true ) );
547 529 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SERIES, get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ) );
548 530 add_post_meta( $new_chart_id, Visualizer_Plugin::CF_SETTINGS, get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true ) );
549 - $redirect = add_query_arg(
550 - array(
551 - 'page' => 'visualizer',
552 - 'type' => filter_input( INPUT_GET, 'type' ),
553 - ), admin_url( 'upload.php' )
554 - );
531 +
532 + $redirect = add_query_arg( array(
533 + 'page' => 'visualizer',
534 + 'type' => filter_input( INPUT_GET, 'type' ),
535 + ), admin_url( 'upload.php' ) );
555 536 }
556 537 }
538 +
557 539 wp_redirect( $redirect );
558 540 exit;
559 541 }
560 542
@@ -566,61 +548,79 @@
566 548 * @access public
567 549 */
568 550 public function exportData() {
569 551 check_ajax_referer( Visualizer_Plugin::ACTION_EXPORT_DATA . Visualizer_Plugin::VERSION, 'security' );
570 - $capable = current_user_can( 'edit_posts' );
552 +
553 + $chart_id = $success = false;
554 + $capable = current_user_can( 'edit_posts' );
571 555 if ( $capable ) {
572 - $chart_id = isset( $_GET['chart'] ) ? filter_var(
573 - $_GET['chart'], FILTER_VALIDATE_INT, array(
574 - 'options' => array(
575 - 'min_range' => 1,
576 - ),
577 - )
578 - ) : '';
556 + $chart_id = filter_input( INPUT_GET, 'chart', FILTER_VALIDATE_INT, array( 'options' => array( 'min_range' => 1 ) ) );
579 557 if ( $chart_id ) {
580 - $data = $this->_getDataAs( $chart_id, 'csv' );
581 - if ( $data ) {
582 - echo wp_send_json_success( $data );
558 + $chart = get_post( $chart_id );
559 + $success = $chart && $chart->post_type == Visualizer_Plugin::CPT_VISUALIZER;
560 + }
561 + }
562 +
563 + if ( $success ) {
564 + $settings = get_post_meta( $chart_id, Visualizer_Plugin::CF_SETTINGS, true );
565 + $filename = $settings['title'];
566 + if ( empty( $filename ) ) {
567 + $filename = 'export.csv';
568 + } else {
569 + $filename .= '.csv';
570 + }
571 + $rows = array();
572 + $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true );
573 + $data = unserialize( $chart->post_content );
574 + if ( ! empty( $series ) ) {
575 + $row = array();
576 + foreach ( $series as $array ) {
577 + $row[] = $array['label'];
583 578 }
579 + $rows[] = $row;
580 +
581 + $row = array();
582 + foreach ( $series as $array ) {
583 + $row[] = $array['type'];
584 + }
585 + $rows[] = $row;
584 586 }
585 - }
586 587
587 - defined( 'WP_TESTS_DOMAIN' ) ? wp_die() : exit();
588 - }
588 + if ( ! empty( $data ) ) {
589 + foreach ( $data as $array ) {
590 + // ignore strings
591 + if ( ! is_array( $array ) ) { continue; }
589 592
590 - /**
591 - * Handles chart data page.
592 - *
593 - * @since 1.0.0
594 - *
595 - * @access private
596 - */
597 - private function _handleDataPage() {
598 - $data = $this->_getChartArray();
599 - $render = new Visualizer_Render_Page_Data();
600 - $render->chart = $this->_chart;
601 - $render->type = $data['type'];
602 - unset( $data['settings']['width'], $data['settings']['height'] );
603 - wp_enqueue_style( 'visualizer-frame' );
604 - wp_enqueue_script( 'visualizer-render' );
605 - wp_localize_script(
606 - 'visualizer-render', 'visualizer', array(
607 - 'l10n' => array(
608 - 'invalid_source' => esc_html__( 'You have entered invalid URL. Please, insert proper URL.', 'visualizer' ),
609 - 'loading' => esc_html__( 'Loading...', 'visualizer' ),
610 - ),
611 - 'charts' => array(
612 - 'canvas' => $data,
613 - ),
614 - )
615 - );
616 - // Added by Ash/Upwork
617 - if ( VISUALIZER_PRO ) {
618 - global $Visualizer_Pro;
619 - $Visualizer_Pro->_enqueueScriptsAndStyles( $data );
593 + // if this is an array of arrays...
594 + if ( is_array( $array[0] ) ) {
595 + foreach ( $array as $arr ) {
596 + $rows[] = $arr;
597 + }
598 + } else {
599 + // just an array
600 + $rows[] = $array;
601 + }
602 + }
603 + }
604 +
605 + $fp = tmpfile();
606 + foreach ( $rows as $row ) {
607 + fputcsv( $fp, $row );
608 + }
609 + rewind( $fp );
610 +
611 + $csv = '';
612 + while ( ($array = fgetcsv( $fp )) !== false ) {
613 + if ( strlen( $csv ) > 0 ) { $csv .= PHP_EOL; }
614 + $csv .= implode( ',', $array );
615 + }
616 + fclose( $fp );
617 +
618 + echo wp_send_json_success(array(
619 + 'csv' => $csv,
620 + 'name' => $filename,
621 + ));
620 622 }
621 - // Added by Ash/Upwork
622 - $this->_addAction( 'admin_head', 'renderFlattrScript' );
623 - wp_iframe( array( $render, 'render' ) );
623 +
624 + exit;
624 625 }
625 -
626 626 }