| @@ -17,9 +17,8 @@ | ||
| 17 | 17 | <div class="wpda-navi-container"> |
| 18 | 18 | <?php |
| 19 | 19 | $this->header(); |
| 20 | 20 | $this->tool_guide(); |
| 21 | - $this->hot_topics(); | |
| 22 | 21 | ?> |
| 23 | 22 | </div> |
| 24 | 23 | <?php |
| 25 | 24 | } |
| @@ -41,14 +40,20 @@ | ||
| 41 | 40 | <div></div> |
| 42 | 41 | </div> |
| 43 | 42 | |
| 44 | 43 | <div class="wpda-navi-container-header-image"> |
| 45 | - <img src="<?php echo plugins_url('../../assets/images/coding-isometric-01-blauw.png', __FILE__); ?>"/> | |
| 44 | + <img src="<?php echo esc_attr( plugins_url('../../assets/images/coding-isometric-01-blauw.png', __FILE__ ) ); ?>" alt="laptop" /> | |
| 46 | 45 | </div> |
| 47 | 46 | </div> |
| 48 | 47 | <?php |
| 48 | + WPDA::load_wp_tables(); | |
| 49 | 49 | } |
| 50 | 50 | |
| 51 | + /** | |
| 52 | + * @param $tool | |
| 53 | + * | |
| 54 | + * @return string | |
| 55 | + */ | |
| 51 | 56 | private function tool_status( $tool ) { |
| 52 | 57 | ?> |
| 53 | 58 | <div onclick="setLegacyToolStatus(this)" class="tool_status_icon"> |
| 54 | 59 | <?php |
| @@ -63,8 +68,9 @@ | ||
| 63 | 68 | } |
| 64 | 69 | ?> |
| 65 | 70 | </div> |
| 66 | 71 | <?php |
| 72 | + return ''; | |
| 67 | 73 | } |
| 68 | 74 | |
| 69 | 75 | private function tool_guide() { |
| 70 | 76 | ?> |
| @@ -112,34 +118,34 @@ | ||
| 112 | 118 | <tbody> |
| 113 | 119 | <tr> |
| 114 | 120 | <td>Tables</td> |
| 115 | 121 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['tables'][1] ); ?></td> |
| 116 | - <td class="status" data-tool="tables"><?php echo $this->tool_status( $this->option_legacy_tools['tables'] ); ?></td> | |
| 122 | + <td class="status" data-tool="tables"><?php echo $this->tool_status( $this->option_legacy_tools['tables'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 117 | 123 | </tr> |
| 118 | 124 | <tr> |
| 119 | 125 | <td>Forms</td> |
| 120 | 126 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['forms'][1] ); ?></td> |
| 121 | - <td class="status" data-tool="forms"><?php echo $this->tool_status( $this->option_legacy_tools['forms'] ); ?></td> | |
| 127 | + <td class="status" data-tool="forms"><?php echo $this->tool_status( $this->option_legacy_tools['forms'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 122 | 128 | </tr> |
| 123 | 129 | <tr> |
| 124 | 130 | <td>Templates</td> |
| 125 | 131 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['templates'][1] ); ?></td> |
| 126 | - <td class="status" data-tool="templates"><?php echo $this->tool_status( $this->option_legacy_tools['templates'] ); ?></td> | |
| 132 | + <td class="status" data-tool="templates"><?php echo $this->tool_status( $this->option_legacy_tools['templates'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 127 | 133 | </tr> |
| 128 | 134 | <tr> |
| 129 | 135 | <td>Designer</td> |
| 130 | 136 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['designer'][1] ); ?></td> |
| 131 | - <td class="status" data-tool="designer"><?php echo $this->tool_status( $this->option_legacy_tools['designer'] ); ?></td> | |
| 137 | + <td class="status" data-tool="designer"><?php echo $this->tool_status( $this->option_legacy_tools['designer'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 132 | 138 | </tr> |
| 133 | 139 | <tr> |
| 134 | 140 | <td>Dashboards</td> |
| 135 | 141 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['dashboards'][1] ); ?></td> |
| 136 | - <td class="status" data-tool="dashboards"><?php echo $this->tool_status( $this->option_legacy_tools['dashboards'] ); ?></td> | |
| 142 | + <td class="status" data-tool="dashboards"><?php echo $this->tool_status( $this->option_legacy_tools['dashboards'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 137 | 143 | </tr> |
| 138 | 144 | <tr> |
| 139 | 145 | <td>Charts</td> |
| 140 | 146 | <td class="items"><?php echo esc_attr( $this->option_legacy_tools['charts'][1] ); ?></td> |
| 141 | - <td class="status" data-tool="charts"><?php echo $this->tool_status( $this->option_legacy_tools['charts'] ); ?></td> | |
| 147 | + <td class="status" data-tool="charts"><?php echo $this->tool_status( $this->option_legacy_tools['charts'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?></td> | |
| 142 | 148 | </tr> |
| 143 | 149 | </tbody> |
| 144 | 150 | </table> |
| 145 | 151 | |
| @@ -150,12 +156,12 @@ | ||
| 150 | 156 | |
| 151 | 157 | <div style="display: none"> |
| 152 | 158 | <form |
| 153 | 159 | id="wpda-legacy-tool-settings-form-data" |
| 154 | - action="<?php echo admin_url( 'admin.php' ); ?>?page=wpda_navi" | |
| 160 | + action="<?php echo esc_url( admin_url( 'admin.php' ) ); ?>?page=wpda_navi" | |
| 155 | 161 | method="POST" |
| 156 | 162 | > |
| 157 | - <input | |
| 163 | + <label for="wpda-legacy-tool-settings-legacy-tool-data"></label><input | |
| 158 | 164 | type="text" |
| 159 | 165 | name="wpda-legacy-tool-status" |
| 160 | 166 | id="wpda-legacy-tool-settings-legacy-tool-data" |
| 161 | 167 | /> |
| @@ -185,9 +191,9 @@ | ||
| 185 | 191 | <a |
| 186 | 192 | href="https://docs.rad.wpdataaccess.com/" |
| 187 | 193 | target="_blank" |
| 188 | 194 | class="wpda_tooltip" |
| 189 | - title="View online documentation" | |
| 195 | + title="View online App Builder documentation" | |
| 190 | 196 | > |
| 191 | 197 | <i class="fa-solid fa-question-circle wpda-icon-help"></i> |
| 192 | 198 | </a> |
| 193 | 199 | </div> |
| @@ -229,12 +235,12 @@ | ||
| 229 | 235 | <span class="fa-solid fa-database wpda-icon"></span> |
| 230 | 236 | <h3>Explorer</h3> |
| 231 | 237 | <div class="wpda-navi-container-content-item-title-help"> |
| 232 | 238 | <a |
| 233 | - href="https://docs.legacy.wpdataaccess.com/docs/data-explorer-getting-started/" | |
| 239 | + href="https://docs.explorer.wpdataaccess.com/" | |
| 234 | 240 | target="_blank" |
| 235 | 241 | class="wpda_tooltip" |
| 236 | - title="View online documentation" | |
| 242 | + title="View online Data Explorer documentation" | |
| 237 | 243 | > |
| 238 | 244 | <i class="fa-solid fa-question-circle wpda-icon-help"></i> |
| 239 | 245 | </a> |
| 240 | 246 | </div> |
| @@ -265,8 +271,9 @@ | ||
| 265 | 271 | <ul> |
| 266 | 272 | <li>Schedule unattended exports (new Data Explorer only).</li> |
| 267 | 273 | <li>Manage database connections, databases and table data.</li> |
| 268 | 274 | <li>Explore local and remote databases.</li> |
| 275 | + <li>Global search and replace.</li> | |
| 269 | 276 | </ul> |
| 270 | 277 | </div> |
| 271 | 278 | </div> |
| 272 | 279 | |
| @@ -278,9 +285,9 @@ | ||
| 278 | 285 | <a |
| 279 | 286 | href="https://docs.sql.wpdataaccess.com/" |
| 280 | 287 | target="_blank" |
| 281 | 288 | class="wpda_tooltip" |
| 282 | - title="View online documentation" | |
| 289 | + title="View online SQL Query Builder Documentation" | |
| 283 | 290 | > |
| 284 | 291 | <i class="fa-solid fa-question-circle wpda-icon-help"></i> |
| 285 | 292 | </a> |
| 286 | 293 | </div> |
| @@ -292,9 +299,9 @@ | ||
| 292 | 299 | |
| 293 | 300 | <div class="wpda-navi-container-content-item-content"> |
| 294 | 301 | <ul> |
| 295 | 302 | <li> |
| 296 | - <a href="?page=wpda_query_builder">Start Query Builder</a> | |
| 303 | + <a href="?page=wpda_query_builder">Start SQL Query Builder</a> | |
| 297 | 304 | </li> |
| 298 | 305 | </ul> |
| 299 | 306 | </div> |
| 300 | 307 | |
| @@ -305,9 +312,8 @@ | ||
| 305 | 312 | <li>Schedule SQL commands to run at specific intervals.</li> |
| 306 | 313 | <li>Ask AI Assistant to help writing queries and solve errors.</li> |
| 307 | 314 | <li>Build SQL queries visually with our Visual Query Builder.</li> |
| 308 | 315 | </ul> |
| 309 | - </ul> | |
| 310 | 316 | </div> |
| 311 | 317 | </div> |
| 312 | 318 | |
| 313 | 319 | <div class="wpda-navi-container-content-item wpda-featured" |
| @@ -330,165 +336,71 @@ | ||
| 330 | 336 | |
| 331 | 337 | <div class="wpda-navi-container-content-item-facts whats-new"> |
| 332 | 338 | <ul> |
| 333 | 339 | <li> |
| 334 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/column-filters.html" target="_blank" class="whatsnew"> | |
| 335 | - ⭐ Show column filters in popup (on mobile devices). | |
| 340 | + <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/columns/column-settings.html#%E2%9A%99%EF%B8%8F-pin-column-to" target="_blank" class="whatsnew"> | |
| 341 | + Added column pinning to Table Builder. | |
| 336 | 342 | </a> |
| 337 | 343 | </li> |
| 338 | 344 | <li> |
| 339 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/column-filters.html" target="_blank" class="whatsnew"> | |
| 340 | - 😎 Completely restyled UI for compact column filters. | |
| 345 | + <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/columns/column-settings.html#%F0%9F%93%8C-notes" target="_blank" class="whatsnew"> | |
| 346 | + Show hidden columns on tablets and mobiles. | |
| 341 | 347 | </a> |
| 342 | 348 | </li> |
| 343 | 349 | <li> |
| 344 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/columns/column-actions.html" target="_blank" class="whatsnew"> | |
| 345 | - 🔎︎ Added single-select search panes. | |
| 350 | + <a href="https://docs.rad.wpdataaccess.com/app-manager/running-apps/progressive-web-apps.html" target="_blank" class="whatsnew"> | |
| 351 | + Run a WP Data Access app as a Progressive Web App. ⭐⭐⭐ | |
| 346 | 352 | </a> |
| 347 | 353 | </li> |
| 354 | + <li> | |
| 355 | + <a href="https://docs.rad.wpdataaccess.com/running-apps.html#%E2%9C%8F%EF%B8%8F-using-the-gutenberg-block-editor" target="_blank" class="whatsnew"> | |
| 356 | + Gutenberg block support for [wpda_app] shortcode. | |
| 357 | + </a> | |
| 358 | + </li> | |
| 348 | 359 | <li> |
| 349 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/charts.html" target="_blank" class="whatsnew"> | |
| 350 | - 📊 Apply arithmetic functions to chart columns. | |
| 360 | + <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/column-filters.html" target="_blank" class="whatsnew"> | |
| 361 | + Show column filters in popup. | |
| 351 | 362 | </a> |
| 352 | 363 | </li> |
| 353 | - <li> | |
| 354 | - <a href="https://docs.rad.wpdataaccess.com/dashboard-builder/" target="_blank" class="whatsnew"> | |
| 355 | - 📶 Dashboards now available as app type. | |
| 356 | - </a> | |
| 364 | + </ul> | |
| 365 | + </div> | |
| 366 | + | |
| 367 | + <div class="wpda-navi-container-content-item-facts whats-new"> | |
| 368 | + <ul> | |
| 369 | + <li style="font-weight:bold"> | |
| 370 | + Old Query Builder no longer available. | |
| 357 | 371 | </li> |
| 372 | + <li style="font-weight:bold"> | |
| 373 | + Old Data Explorer no longer available. | |
| 374 | + </li> | |
| 375 | + </ul> | |
| 376 | + </div> | |
| 377 | + | |
| 378 | + <div class="wpda-navi-container-content-item-facts whats-new"> | |
| 379 | + <h4 style="margin-top:0;margin-bottom:5px;font-weight:bold;">Now available to FREE USERS</h4> | |
| 380 | + <ul> | |
| 358 | 381 | <li> |
| 359 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/detail-panel.html#%E2%9A%99%EF%B8%8F-enable-table-display-mode" target="_blank" class="whatsnew"> | |
| 360 | - 💎 Switch between Table View and Card View. | |
| 382 | + <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/css-table-editor.html" target="_blank" class="whatsnew"> | |
| 383 | + CSS Table Editor | |
| 361 | 384 | </a> |
| 362 | 385 | </li> |
| 363 | 386 | <li> |
| 364 | - <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/detail-panel.html" target="_blank" class="whatsnew"> | |
| 365 | - 😎 Even cooler interactive detail panel creation. | |
| 387 | + <a href="https://docs.rad.wpdataaccess.com/form-builder/menu/form/css-form-editor.html" target="_blank" class="whatsnew"> | |
| 388 | + CSS Form Editor | |
| 366 | 389 | </a> |
| 367 | 390 | </li> |
| 368 | 391 | <li> |
| 369 | 392 | <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/columns/computed-fields.html" target="_blank" class="whatsnew"> |
| 370 | - 🎁 Computed Text Fields for FREE USERS. | |
| 393 | + Computed Text Fields | |
| 371 | 394 | </a> |
| 372 | 395 | </li> |
| 373 | 396 | <li> |
| 374 | - 👁️ Visual Query Builder for FREE USERS (use new Query Builder). | |
| 397 | + <a href="https://docs.sql.wpdataaccess.com/visual-query-builder.html" target="_blank" class="whatsnew"> | |
| 398 | + Visual Query Builder | |
| 399 | + </a> | |
| 375 | 400 | </li> |
| 376 | - </ul> | |
| 377 | - </div> | |
| 378 | - </div> | |
| 379 | - </div> | |
| 380 | - </div> | |
| 381 | - <?php | |
| 382 | - } | |
| 383 | - | |
| 384 | - private function hot_topics() { | |
| 385 | - ?> | |
| 386 | - <div class="wpda-navi-container-content"> | |
| 387 | - <div class="wpda-navi-container-content-item wpda-hot-topics"> | |
| 388 | - <h2> | |
| 389 | - Frequently Asked Questions | |
| 390 | - </h2> | |
| 391 | - | |
| 392 | - <div class="wpda-navi-container-content-item-facts"> | |
| 393 | - <button | |
| 394 | - onClick="window.open('https://docs.rad.wpdataaccess.com/', '_blank')" | |
| 395 | - > | |
| 396 | - <span class="wpda-hot-title"> | |
| 397 | - App Builder | |
| 398 | - </span> | |
| 399 | - <span class="wpda-hot-topic"> | |
| 400 | - What is the App Builder? | |
| 401 | - </span> | |
| 402 | - </button> | |
| 403 | - | |
| 404 | - <button | |
| 405 | - onClick="window.open('https://docs.rad.wpdataaccess.com/table-builder/menu/table/relationships.html', '_blank')" | |
| 406 | - > | |
| 407 | - <span class="wpda-hot-title"> | |
| 408 | - Master-Detail Relationships | |
| 409 | - </span> | |
| 410 | - <span class="wpda-hot-topic"> | |
| 411 | - How do I add a master-detail relationship to my app? | |
| 412 | - </span> | |
| 413 | - </button> | |
| 414 | - | |
| 415 | - <button | |
| 416 | - onClick="window.open('https://docs.rad.wpdataaccess.com/table-builder/menu/columns/computed-fields.html', '_blank')" | |
| 417 | - > | |
| 418 | - <span class="wpda-hot-title"> | |
| 419 | - Computed Fields | |
| 420 | - </span> | |
| 421 | - <span class="wpda-hot-topic"> | |
| 422 | - How do I use a computed field in my app? | |
| 423 | - </span> | |
| 424 | - </button> | |
| 425 | - | |
| 426 | - <button | |
| 427 | - onClick="window.open('https://docs.rad.wpdataaccess.com/table-builder/menu/columns/column-lookups.html', '_blank')" | |
| 428 | - > | |
| 429 | - <span class="wpda-hot-title"> | |
| 430 | - Lookups | |
| 431 | - </span> | |
| 432 | - <span class="wpda-hot-topic"> | |
| 433 | - How do I add a lookup to my app? | |
| 434 | - </span> | |
| 435 | - </button> | |
| 436 | - | |
| 437 | - <button | |
| 438 | - onClick="window.open('https://docs.rad.wpdataaccess.com/table-builder/menu/columns/column-actions.html', '_blank')" | |
| 439 | - > | |
| 440 | - <span class="wpda-hot-title"> | |
| 441 | - Column Filters | |
| 442 | - </span> | |
| 443 | - <span class="wpda-hot-topic"> | |
| 444 | - How do I enable column filters in my app? | |
| 445 | - </span> | |
| 446 | - </button> | |
| 447 | - | |
| 448 | - <button | |
| 449 | - onClick="window.open('https://docs.rad.wpdataaccess.com/hooks/', '_blank')" | |
| 450 | - > | |
| 451 | - <span class="wpda-hot-title"> | |
| 452 | - App Builder Hooks | |
| 453 | - </span> | |
| 454 | - <span class="wpda-hot-topic"> | |
| 455 | - Write hook to customize app behavior. | |
| 456 | - </span> | |
| 457 | - </button> | |
| 458 | - | |
| 459 | - <button | |
| 460 | - onClick="window.open('https://docs.remote.wpdataaccess.com/mysql.html', '_blank')" | |
| 461 | - > | |
| 462 | - <span class="wpda-hot-title"> | |
| 463 | - Remote connections | |
| 464 | - </span> | |
| 465 | - <span class="wpda-hot-topic"> | |
| 466 | - How can I establish a remote connection? | |
| 467 | - </span> | |
| 468 | - </button> | |
| 469 | - | |
| 470 | - <button | |
| 471 | - onClick="window.open('https://docs.remote.wpdataaccess.com/pds/start-here.html', '_blank')" | |
| 472 | - > | |
| 473 | - <span class="wpda-hot-title"> | |
| 474 | - Premium Data Services | |
| 475 | - </span> | |
| 476 | - <span class="wpda-hot-topic"> | |
| 477 | - How can I use Premium Data Services for remote connections? | |
| 478 | - </span> | |
| 479 | - </button> | |
| 480 | - | |
| 481 | - <button | |
| 482 | - onClick="window.open('https://docs.rad.wpdataaccess.com/', '_blank')" | |
| 483 | - > | |
| 484 | - <span class="wpda-hot-title"> | |
| 485 | - Documentation | |
| 486 | - </span> | |
| 487 | - <span class="wpda-hot-topic"> | |
| 488 | - Where can I find the online documentation? | |
| 489 | - </span> | |
| 490 | - </button> | |
| 401 | + </ul> | |
| 402 | + </div> | |
| 491 | 403 | </div> |
| 492 | 404 | </div> |
| 493 | 405 | </div> |
| 494 | 406 | <?php |