| @@ -48,17 +48,8 @@ | ||
| 48 | 48 | return call_user_func( array( __CLASS__, '_render' . str_replace( ' ', '', ucwords( str_replace( '-', ' ', $layout ) ) ) ), func_get_args() ); |
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | /** |
| 52 | - * Show the fake editor (just an empty div). | |
| 53 | - * | |
| 54 | - * @access public | |
| 55 | - */ | |
| 56 | - public static function _renderFauxEditor( $args ) { | |
| 57 | - echo '<div id="chart-lhs" class="visualizer-editor-lhs" style="display: none"></div>'; | |
| 58 | - } | |
| 59 | - | |
| 60 | - /** | |
| 61 | 52 | * Show the DB query box. |
| 62 | 53 | * |
| 63 | 54 | * @access public |
| 64 | 55 | */ |
| @@ -68,8 +59,10 @@ | ||
| 68 | 59 | <div id='visualizer-db-query' style="display: none"> |
| 69 | 60 | <div class="visualizer-db-query-form"> |
| 70 | 61 | <div> |
| 71 | 62 | <form id='db-query-form'> |
| 63 | + <input type="hidden" name="chart_id" value="<?php echo $args[2]; ?>"> | |
| 64 | + <?php do_action( 'visualizer_db_query_add_layout', $args ); ?> | |
| 72 | 65 | <textarea name='query' class='visualizer-db-query' placeholder="<?php _e( 'Your query goes here', 'visualizer' ); ?>"><?php echo $query; ?></textarea> |
| 73 | 66 | </form> |
| 74 | 67 | <div class='db-wizard-error'></div> |
| 75 | 68 | </div> |
| @@ -80,8 +73,9 @@ | ||
| 80 | 73 | <div class='db-wizard-hints'> |
| 81 | 74 | <ul> |
| 82 | 75 | <li><?php echo sprintf( __( 'For examples of queries and links to resources that you can use with this feature, please click %1$shere%2$s', 'visualizer' ), '<a href="' . VISUALIZER_DB_QUERY_DOC_URL . '" target="_blank">', '</a>' ); ?></li> |
| 83 | 76 | <li><?php echo sprintf( __( 'Use %1$sControl+Space%2$s for autocompleting keywords or table names.', 'visualizer' ), '<span class="visualizer-emboss">', '</span>' ); ?></li> |
| 77 | + <?php do_action( 'visualizer_db_query_add_hints', $args ); ?> | |
| 84 | 78 | </ul> |
| 85 | 79 | </div> |
| 86 | 80 | <div class='db-wizard-results'></div> |
| 87 | 81 | |
| @@ -124,6 +118,344 @@ | ||
| 124 | 118 | </tbody> |
| 125 | 119 | </table> |
| 126 | 120 | <?php |
| 127 | 121 | return ob_get_clean(); |
| 122 | + } | |
| 123 | + | |
| 124 | + /** | |
| 125 | + * Show the JSON/REST parameters boxes. | |
| 126 | + * | |
| 127 | + * @access public | |
| 128 | + */ | |
| 129 | + public static function _renderJsonScreen( $args ) { | |
| 130 | + $id = $args[1]; | |
| 131 | + $action = add_query_arg( | |
| 132 | + array( | |
| 133 | + 'action' => Visualizer_Plugin::ACTION_JSON_SET_DATA, | |
| 134 | + 'security' => wp_create_nonce( Visualizer_Plugin::ACTION_JSON_SET_DATA . Visualizer_Plugin::VERSION ), | |
| 135 | + 'chart' => $id, | |
| 136 | + ), | |
| 137 | + admin_url( 'admin-ajax.php' ) | |
| 138 | + ); | |
| 139 | + | |
| 140 | + $url = get_post_meta( $id, Visualizer_Plugin::CF_JSON_URL, true ); | |
| 141 | + $root = get_post_meta( $id, Visualizer_Plugin::CF_JSON_ROOT, true ); | |
| 142 | + $paging = get_post_meta( $id, Visualizer_Plugin::CF_JSON_PAGING, true ); | |
| 143 | + $headers = get_post_meta( $id, Visualizer_Plugin::CF_JSON_HEADERS, true ); | |
| 144 | + if ( empty( $headers['method'] ) ) { | |
| 145 | + $headers['method'] = 'get'; | |
| 146 | + } | |
| 147 | + $methods = apply_filters( 'visualizer_json_request_methods', array( 'GET', 'POST' ) ); | |
| 148 | + ?> | |
| 149 | + <div id="visualizer-json-screen" style="display: none"> | |
| 150 | + <div class="visualizer-json-form"> | |
| 151 | + <h3 class="viz-step step1"><?php _e( 'STEP 1: Specify the JSON endpoint/URL', 'visualizer' ); ?></h3> | |
| 152 | + <div> | |
| 153 | + <form id="json-endpoint-form"> | |
| 154 | + <div class="json-wizard-hints"> | |
| 155 | + <ul class="info"> | |
| 156 | + <li><?php echo sprintf( __( 'If you want to add authentication or headers to the endpoint or change the request in any way, please refer to our document %1$shere%2$s.', 'visualizer' ), '<a href="https://docs.themeisle.com/article/1043-visualizer-how-to-extend-rest-endpoints-with-json-response" target="_blank">', '</a>' ); ?></li> | |
| 157 | + </ul> | |
| 158 | + </div> | |
| 159 | + | |
| 160 | + <input | |
| 161 | + type="url" | |
| 162 | + id="vz-import-json-url" | |
| 163 | + name="url" | |
| 164 | + value="<?php echo esc_url( $url ); ?>" | |
| 165 | + placeholder="<?php esc_html_e( 'Please enter the URL', 'visualizer' ); ?>" | |
| 166 | + class="visualizer-input json-form-element"> | |
| 167 | + <button class="button button-secondary button-small" id="visualizer-json-fetch"><?php esc_html_e( 'Fetch Endpoint', 'visualizer' ); ?></button> | |
| 168 | + | |
| 169 | + <div class="visualizer-json-subform"> | |
| 170 | + <h3 class="viz-substep"><?php _e( 'Headers', 'visualizer' ); ?></h3> | |
| 171 | + <div class="json-wizard-headers"> | |
| 172 | + <div class="json-wizard-header"> | |
| 173 | + <div><?php _e( 'Request Type', 'visualizer' ); ?></div> | |
| 174 | + <div> | |
| 175 | + <select name="method" class="json-form-element"> | |
| 176 | + <?php foreach ( $methods as $method ) { ?> | |
| 177 | + <option value="<?php echo $method; ?>" <?php selected( $headers['method'], $method ); ?>><?php echo $method; ?></option> | |
| 178 | + <?php } ?> | |
| 179 | + </select> | |
| 180 | + </div> | |
| 181 | + </div> | |
| 182 | + <div class="json-wizard-header"> | |
| 183 | + <div><?php _e( 'Credentials', 'visualizer' ); ?></div> | |
| 184 | + <div> | |
| 185 | + <input | |
| 186 | + type="text" | |
| 187 | + id="vz-import-json-username" | |
| 188 | + name="username" | |
| 189 | + value="<?php echo ( array_key_exists( 'auth', $headers ) && array_key_exists( 'username', $headers['auth'] ) ? $headers['auth']['username'] : '' ); ?>" | |
| 190 | + placeholder="<?php esc_html_e( 'Username/Access Key', 'visualizer' ); ?>" | |
| 191 | + class="json-form-element"> | |
| 192 | + & | |
| 193 | + <input | |
| 194 | + type="password" | |
| 195 | + id="vz-import-json-password" | |
| 196 | + name="password" | |
| 197 | + value="<?php echo ( array_key_exists( 'auth', $headers ) && array_key_exists( 'password', $headers['auth'] ) ? $headers['auth']['password'] : '' ); ?>" | |
| 198 | + placeholder="<?php esc_html_e( 'Password/Secret Key', 'visualizer' ); ?>" | |
| 199 | + class="json-form-element"> | |
| 200 | + </div> | |
| 201 | + </div> | |
| 202 | + <div class="json-wizard-header"> | |
| 203 | + <div></div> | |
| 204 | + <div><?php esc_html_e( 'OR', 'visualizer' ); ?></div> | |
| 205 | + </div> | |
| 206 | + <div class="json-wizard-header"> | |
| 207 | + <div><?php esc_html_e( 'Authorization', 'visualizer' ); ?></div> | |
| 208 | + <div> | |
| 209 | + <input | |
| 210 | + type="text" | |
| 211 | + id="vz-import-json-auth" | |
| 212 | + name="auth" | |
| 213 | + value="<?php echo ( ! empty( $headers ) && array_key_exists( 'auth', $headers ) ? $headers['auth']['auth'] : '' ); ?>" | |
| 214 | + placeholder="<?php esc_html_e( 'e.g. SharedKey <AccountName>:<Signature>', 'visualizer' ); ?>" | |
| 215 | + class="visualizer-input json-form-element"> | |
| 216 | + </div> | |
| 217 | + </div> | |
| 218 | + </div> | |
| 219 | + </div> | |
| 220 | + </form> | |
| 221 | + </div> | |
| 222 | + <h3 class="viz-step step2 <?php echo empty( $url ) ? 'ui-state-disabled' : ''; ?> json-root-form"><?php _e( 'STEP 2: Choose the JSON root', 'visualizer' ); ?></h3> | |
| 223 | + <div> | |
| 224 | + <form id="json-root-form"> | |
| 225 | + <input type="hidden" name="chart" value="<?php echo $id; ?>"> | |
| 226 | + <select name="root" id="vz-import-json-root" class="json-form-element"> | |
| 227 | + <?php | |
| 228 | + if ( ! empty( $root ) ) { | |
| 229 | + ?> | |
| 230 | + <option value="<?php echo esc_attr( $root ); ?>"><?php echo str_replace( Visualizer_Source_Json::TAG_SEPARATOR, Visualizer_Source_Json::TAG_SEPARATOR_VIEW, $root ); ?></option> | |
| 231 | + <?php | |
| 232 | + } | |
| 233 | + ?> | |
| 234 | + </select> | |
| 235 | + <button class="button button-secondary button-small" id="visualizer-json-parse"><?php esc_html_e( 'Parse Endpoint', 'visualizer' ); ?></button> | |
| 236 | + </form> | |
| 237 | + </div> | |
| 238 | + <h3 class="viz-step step3 <?php echo empty( $root ) ? 'ui-state-disabled' : ''; ?>"><?php _e( 'STEP 3: Specify miscellaneous parameters', 'visualizer' ); ?></h3> | |
| 239 | + <div> | |
| 240 | + <form id="json-conclude-form-helper"> | |
| 241 | + <div class="<?php echo apply_filters( 'visualizer_pro_upsell_class', 'only-pro-feature' ); ?>"> | |
| 242 | + <div class="json-pagination"> | |
| 243 | + <select name="paging" id="vz-import-json-paging" class="json-form-element" data-template='<?php echo sprintf( 'Get results from the first %d pages using %s', apply_filters( 'visualizer_json_fetch_pages', 5, $url ), '?' ); ?>'> | |
| 244 | + <option value="0" class="static"><?php _e( 'Get results from the first page only', 'visualizer' ); ?></option> | |
| 245 | + <?php | |
| 246 | + if ( ! empty( $paging ) ) { | |
| 247 | + ?> | |
| 248 | + <option value="<?php echo esc_attr( $paging ); ?>"><?php echo sprintf( 'Get results from the first %d pages using %s', apply_filters( 'visualizer_json_fetch_pages', 5, $url ), str_replace( Visualizer_Source_Json::TAG_SEPARATOR, Visualizer_Source_Json::TAG_SEPARATOR_VIEW, $paging ) ); ?></option> | |
| 249 | + <?php | |
| 250 | + } | |
| 251 | + ?> | |
| 252 | + </select> | |
| 253 | + <?php | |
| 254 | + if ( ! Visualizer_Module::is_pro() ) { | |
| 255 | + ?> | |
| 256 | + <br/> | |
| 257 | + <br/> | |
| 258 | + <br/> | |
| 259 | + <br/> | |
| 260 | + <?php | |
| 261 | + } | |
| 262 | + ?> | |
| 263 | + <?php echo apply_filters( 'visualizer_pro_upsell', '' ); ?> | |
| 264 | + </div> | |
| 265 | + </div> | |
| 266 | + </form> | |
| 267 | + </div> | |
| 268 | + <h3 class="viz-step step4 ui-state-disabled"><?php _e( 'STEP 4: Select the data to display in the chart', 'visualizer' ); ?></h3> | |
| 269 | + <div> | |
| 270 | + <form id="json-conclude-form" action="<?php echo $action; ?>" method="post" target="thehole"> | |
| 271 | + <div class="json-wizard-hints html-table-editor-hints"> | |
| 272 | + <ul class="info"> | |
| 273 | + <li><?php _e( 'If you see Invalid Data in the table, you may have selected the wrong root to fetch data from. Please select an alternative from the JSON root dropdown.', 'visualizer' ); ?></li> | |
| 274 | + <li><?php _e( 'Select whether to include the data in the chart. Each column selected will form one series.', 'visualizer' ); ?></li> | |
| 275 | + <li><?php _e( 'If a column is selected to be included, specify its data type.', 'visualizer' ); ?></li> | |
| 276 | + <li><?php _e( 'You can use drag/drop to reorder the columns but this column position is not saved. So when you reload the table, you may have to reorder again.', 'visualizer' ); ?></li> | |
| 277 | + <li><?php _e( 'You can select any number of columns but the chart type selected will determine how many will display in the chart.', 'visualizer' ); ?></li> | |
| 278 | + <li><?php _e( 'Once you have made your selection, click \'Show Chart\' on the right to view the chart.', 'visualizer' ); ?></li> | |
| 279 | + </ul> | |
| 280 | + </div> | |
| 281 | + <div class="json-table"></div> | |
| 282 | + <button class="button button-primary" style="display: none" id="visualizer-json-conclude"></button> | |
| 283 | + </form> | |
| 284 | + </div> | |
| 285 | + </div> | |
| 286 | + </div> | |
| 287 | + <?php | |
| 288 | + } | |
| 289 | + | |
| 290 | + /** | |
| 291 | + * Show the simple editor(s). | |
| 292 | + * | |
| 293 | + * @access public | |
| 294 | + */ | |
| 295 | + public static function _renderSimpleEditorScreen( $args ) { | |
| 296 | + $chart_id = $args[1]; | |
| 297 | + $action = add_query_arg( | |
| 298 | + array( | |
| 299 | + 'action' => Visualizer_Plugin::ACTION_UPLOAD_DATA, | |
| 300 | + 'nonce' => wp_create_nonce(), | |
| 301 | + 'chart' => $chart_id, | |
| 302 | + ), | |
| 303 | + admin_url( 'admin-ajax.php' ) | |
| 304 | + ); | |
| 305 | + ?> | |
| 306 | + <div class="viz-simple-editor"> | |
| 307 | + <div class="viz-simple-editor-type viz-table-editor"> | |
| 308 | + <form id="table-editor-form" action="<?php echo $action; ?>" method="post" target="thehole"> | |
| 309 | + <div class="html-table-editor-hints"> | |
| 310 | + <ul class="info"> | |
| 311 | + <li><?php _e( 'Select whether to include the data in the chart. Each column selected will form one series.', 'visualizer' ); ?></li> | |
| 312 | + <li><?php _e( 'If a column is selected to be included, specify its data type.', 'visualizer' ); ?></li> | |
| 313 | + <li><?php _e( 'You can use drag/drop to reorder the columns but this column position is not saved. So when you reload the table, you may have to reorder again.', 'visualizer' ); ?></li> | |
| 314 | + <li><?php _e( 'You can select any number of columns but the chart type selected will determine how many will display in the chart.', 'visualizer' ); ?></li> | |
| 315 | + </ul> | |
| 316 | + </div> | |
| 317 | + <div class="viz-html-table"> | |
| 318 | + <?php Visualizer_Render_Layout::show( 'editor-table', null, $chart_id, 'viz-html-table', true, true ); ?> | |
| 319 | + </div> | |
| 320 | + <input type="hidden" name="table_data" value="yes"> | |
| 321 | + <input type="hidden" name="editor-type" value="table"> | |
| 322 | + </form> | |
| 323 | + </div> | |
| 324 | + | |
| 325 | + <?php Visualizer_Render_Layout::show( 'text-editor', $chart_id ); ?> | |
| 326 | + | |
| 327 | + </div> | |
| 328 | + <?php | |
| 329 | + | |
| 330 | + } | |
| 331 | + | |
| 332 | + /** | |
| 333 | + * Show the text area editor. | |
| 334 | + * | |
| 335 | + * @access public | |
| 336 | + */ | |
| 337 | + public static function _renderTextEditor( $args ) { | |
| 338 | + $chart_id = $args[1]; | |
| 339 | + $csv = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA_AS, array(), $chart_id, 'csv-display' ); | |
| 340 | + $data = ''; | |
| 341 | + if ( ! empty( $csv ) && isset( $csv['string'] ) ) { | |
| 342 | + $data = str_replace( PHP_EOL, "\n", $csv['string'] ); | |
| 343 | + } | |
| 344 | + ?> | |
| 345 | + <div class="viz-simple-editor-type viz-text-editor"> | |
| 346 | + <textarea id="edited_text"><?php echo $data; ?></textarea> | |
| 347 | + </div> | |
| 348 | + <?php | |
| 349 | + } | |
| 350 | + | |
| 351 | + /** | |
| 352 | + * Show the JSON endpoint's parsed table. | |
| 353 | + * | |
| 354 | + * @access public | |
| 355 | + */ | |
| 356 | + public static function _renderEditorTable( $args ) { | |
| 357 | + $data = $args[1]; | |
| 358 | + $chart_id = $args[2]; | |
| 359 | + $class = $args[3]; | |
| 360 | + $echo = $args[4]; | |
| 361 | + $editable_data = $args[5]; | |
| 362 | + $series = get_post_meta( $chart_id, Visualizer_Plugin::CF_SERIES, true ); | |
| 363 | + $headers = array(); | |
| 364 | + | |
| 365 | + if ( is_null( $data ) ) { | |
| 366 | + foreach ( $series as $column ) { | |
| 367 | + $headers[] = $column['label']; | |
| 368 | + } | |
| 369 | + $chart = get_post( $chart_id ); | |
| 370 | + $type = get_post_meta( $chart_id, Visualizer_Plugin::CF_CHART_TYPE, true ); | |
| 371 | + $data = apply_filters( Visualizer_Plugin::FILTER_GET_CHART_DATA, unserialize( str_replace( "'", "\'", html_entity_decode( $chart->post_content ) ) ), $type ); | |
| 372 | + } else { | |
| 373 | + $headers = array_keys( $data[0] ); | |
| 374 | + } | |
| 375 | + | |
| 376 | + $classes = implode( ' ', array( 'viz-editor-table', $class ) ); | |
| 377 | + | |
| 378 | + if ( $series ) { | |
| 379 | + $temp = $series; | |
| 380 | + $series = array(); | |
| 381 | + foreach ( $temp as $array ) { | |
| 382 | + $series[ $array['label'] ] = $array['type']; | |
| 383 | + } | |
| 384 | + } | |
| 385 | + if ( ! $echo ) { | |
| 386 | + ob_start(); | |
| 387 | + } | |
| 388 | + ?> | |
| 389 | + <table cellspacing="0" width="100%" class="results cell-border stripe <?php echo $classes; ?>"> | |
| 390 | + <thead> | |
| 391 | + <tr> | |
| 392 | + <th><?php _e( 'Label', 'visualizer' ); ?></th> | |
| 393 | + <?php | |
| 394 | + foreach ( $headers as $header ) { | |
| 395 | + if ( $editable_data ) { | |
| 396 | + echo '<th><input type="text" name="header[]" value="' . esc_attr( $header ) . '"></th>'; | |
| 397 | + } else { | |
| 398 | + echo '<th>' . $header . '</th>'; | |
| 399 | + } | |
| 400 | + } | |
| 401 | + ?> | |
| 402 | + </tr> | |
| 403 | + </thead> | |
| 404 | + <tbody> | |
| 405 | + <tr> | |
| 406 | + <th><?php _e( 'Data Type', 'visualizer' ); ?></th> | |
| 407 | + <?php | |
| 408 | + $index = 0; | |
| 409 | + foreach ( $headers as $header ) { | |
| 410 | + echo '<td>'; | |
| 411 | + if ( $editable_data ) { | |
| 412 | + echo '<select name="type[]">'; | |
| 413 | + } else { | |
| 414 | + echo '<input name="header[]" type="hidden" value="' . $header . '">'; | |
| 415 | + echo '<select name="type[' . $header . ']" class="viz-select-data-type">'; | |
| 416 | + } | |
| 417 | + echo '<option value="" title="' . __( 'Exclude from chart', 'visualizer' ) . '">' . __( 'Exclude', 'visualizer' ) . '</option>'; | |
| 418 | + echo '<option value="0" disabled title="' . __( 'Include in chart and select data type', 'visualizer' ) . '">--' . __( 'OR', 'visualizer' ) . '--</option>'; | |
| 419 | + | |
| 420 | + foreach ( Visualizer_Source::getAllowedTypes() as $type ) { | |
| 421 | + $selected = array_key_exists( $header, $series ) && $type === $series[ $header ] ? 'selected' : ''; | |
| 422 | + echo '<option value="' . $type . '" ' . $selected . '>' . $type . '</option>'; | |
| 423 | + } | |
| 424 | + | |
| 425 | + echo '</select></td>'; | |
| 426 | + } | |
| 427 | + ?> | |
| 428 | + </tr> | |
| 429 | + <?php | |
| 430 | + // for remote sources, the data exists inside 'data'. | |
| 431 | + if ( array_key_exists( 'data', $data ) ) { | |
| 432 | + $data = $data['data']; | |
| 433 | + } | |
| 434 | + | |
| 435 | + foreach ( $data as $row ) { | |
| 436 | + echo '<tr>'; | |
| 437 | + echo '<th>' . __( 'Value', 'visualizer' ) . '</th>'; | |
| 438 | + $index = 0; | |
| 439 | + if ( empty( $row ) ) { | |
| 440 | + echo '<td></td>'; | |
| 441 | + continue; | |
| 442 | + } | |
| 443 | + foreach ( array_values( $row ) as $value ) { | |
| 444 | + if ( $editable_data ) { | |
| 445 | + echo '<td><input type="text" name="data' . $index++ . '[]" value="' . esc_attr( stripslashes( $value ) ) . '"></td>'; | |
| 446 | + } else { | |
| 447 | + echo '<td>' . ( is_array( $value ) ? __( 'Invalid Data', 'visualizer' ) : $value ) . '</td>'; | |
| 448 | + } | |
| 449 | + } | |
| 450 | + | |
| 451 | + echo '</tr>'; | |
| 452 | + } | |
| 453 | + ?> | |
| 454 | + </tbody> | |
| 455 | + </table> | |
| 456 | + <?php | |
| 457 | + if ( ! $echo ) { | |
| 458 | + return ob_get_clean(); | |
| 459 | + } | |
| 128 | 460 | } |
| 129 | 461 | } |
