← All changes | WPDataAccess/WPDA_Navi/WPDA_Navi.php +96 -175 5.5.41 → 5.5.85 View file →

		@@ -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	?>
		@@ -103,11 +109,11 @@
103	109	<div id="wpda-legacy-tool-settings-panel">
104	110	<table>
105	111	<thead>
106	112	<tr>
107		- <th>LEGACY TOOL USAGE</th>
	113	+ <th class="label">LEGACY TOOL</th>
108	114	<th class="items">ACTIVE ITEMS</th>
109		- <th>STATUS</th>
	115	+ <th class="status">STATUS</th>
110	116	</tr>
111	117	</thead>
112	118	<tbody>
113	119	<tr>
		@@ -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	/>
		@@ -182,12 +188,12 @@
182	188	</span>
183	189	<h3>App Builder</h3>
184	190	<div class="wpda-navi-container-content-item-title-help">
185	191	<a
186		- href="https://wpdataaccess.com/docs/app-builder/whats-the-app-builder/"
	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>
		@@ -194,12 +200,12 @@
194	200	</div>
195	201
196	202	<div class="wpda-navi-container-content-item-slogan" style="display: flex; justify-content: space-between; align-items: center;">
197	203	<span>
198		- A data-driven Rapid Application Development tool
	204	+ A data-driven Rapid Application Development tool.
199	205	</span>
200	206
201		- <a href="https://wpdataaccess.com/docs/app-builder/road-map/" target="_blank" class="roadmap">ROAD MAP</a>
	207	+ <span></span>
202	208	</div>
203	209
204	210	<div class="wpda-navi-container-content-item-content">
205	211	<ul class="wpda-navi-container-content-item-content-grid switch-grid">
		@@ -211,17 +217,18 @@
211	217	</li>
212	218	</ul>
213	219	</div>
214	220
215		- <div class="wpda-navi-container-content-item-facts">
216		- <ul>
217		- <li>Intuitive Table Builder for creating data tables with ease</li>
218		- <li>Highly customizable Form Builder for designing data entry forms</li>
219		- <li>Integrated Theme Builder to personalize app styling</li>
220		- <li>Interactive Chart Builder for real-time data analysis <span class="wpda-new"><i>NEW</i></span></li>
221		- <li>Visualize location data from SQL queries with the Map Builder <span class="wpda-new"><i>NEW</i></span></li>
222		- </ul>
223		- </div>
	221	+ <div class="wpda-navi-container-content-item-facts">
	222	+ <ul>
	223	+ <li><strong>Table Builder</strong> – Create powerful data tables.</li>
	224	+ <li><strong>Form Builder</strong> – Design data entry forms.</li>
	225	+ <li><strong>Chart Builder</strong> – Visualize data.</li>
	226	+ <li><strong>Map Builder</strong> – Plot location data.</li>
	227	+ <li><strong>Dashboard Builder</strong> – Centralize and monitor insights.</li>
	228	+ <li><strong>Theme Builder</strong> – Personalize app appearance.</li>
	229	+ </ul>
	230	+ </div>
224	231	</div>
225	232
226	233	<div class="wpda-navi-container-content-item">
227	234	<div class="wpda-navi-container-content-item-title">
		@@ -228,12 +235,12 @@
228	235	<span class="fa-solid fa-database wpda-icon"></span>
229	236	<h3>Explorer</h3>
230	237	<div class="wpda-navi-container-content-item-title-help">
231	238	<a
232		- href="https://wpdataaccess.com/docs/data-explorer/data-explorer-getting-started/"
	239	+ href="https://docs.explorer.wpdataaccess.com/"
233	240	target="_blank"
234	241	class="wpda_tooltip"
235		- title="View online documentation"
	242	+ title="View online Data Explorer documentation"
236	243	>
237	244	<i class="fa-solid fa-question-circle wpda-icon-help"></i>
238	245	</a>
239	246	</div>
		@@ -239,9 +246,9 @@
239	246	</div>
240	247	</div>
241	248
242	249	<div class="wpda-navi-container-content-item-slogan">
243		- Perform data and database related tasks
	250	+ Perform data and database related tasks.
244	251	</div>
245	252
246	253	<div class="wpda-navi-container-content-item-content">
247	254	<ul class="wpda-navi-container-content-item-content-grid">
		@@ -261,10 +268,12 @@
261	268	</div>
262	269
263	270	<div class="wpda-navi-container-content-item-facts">
264	271	<ul>
265		- <li>Manage database connections, databases and table data</li>
266		- <li>Explore local and remote databases</li>
	272	+ <li>Schedule unattended exports (new Data Explorer only).</li>
	273	+ <li>Manage database connections, databases and table data.</li>
	274	+ <li>Explore local and remote databases.</li>
	275	+ <li>Global search and replace.</li>
267	276	</ul>
268	277	</div>
269	278	</div>
270	279
		@@ -273,12 +282,12 @@
273	282	<span class="fa-solid fa-code wpda-icon"></span>
274	283	<h3>SQL</h3>
275	284	<div class="wpda-navi-container-content-item-title-help">
276	285	<a
277		- href="https://wpdataaccess.com/docs/sql-query-builder/query-builder-getting-started/"
	286	+ href="https://docs.sql.wpdataaccess.com/"
278	287	target="_blank"
279	288	class="wpda_tooltip"
280		- title="View online documentation"
	289	+ title="View online SQL Query Builder Documentation"
281	290	>
282	291	<i class="fa-solid fa-question-circle wpda-icon-help"></i>
283	292	</a>
284	293	</div>
		@@ -284,15 +293,15 @@
284	293	</div>
285	294	</div>
286	295
287	296	<div class="wpda-navi-container-content-item-slogan">
288		- Execute any SQL command from your WordPress dashboard
	297	+ Execute any SQL command from your WordPress dashboard.
289	298	</div>
290	299
291	300	<div class="wpda-navi-container-content-item-content">
292	301	<ul>
293	302	<li>
294		- <a href="?page=wpda_query_builder">Start Query Builder</a>
	303	+ <a href="?page=wpda_query_builder">Start SQL Query Builder</a>
295	304	</li>
296	305	</ul>
297	306	</div>
298	307
		@@ -297,13 +306,14 @@
297	306	</div>
298	307
299	308	<div class="wpda-navi-container-content-item-facts">
300	309	<ul>
301		- <li>Write, store, execute and reuse any SQL command</li>
302		- <li>Schedule SQL commands to run at specific intervals <span class="wpda-new"><i>NEW</i></span></li>
303		- <li>Ask AI Assistant to help writing queries and solve errors <span class="wpda-new"><i>NEW</i></span></li>
304		- <li>Store queries privately or globally <span class="wpda-new"><i>NEW</i></span></li>
305		- </ul>
	310	+ <li>Write, store, execute and reuse any SQL command.</li>
	311	+ <li>Store queries privately or globally.</li>
	312	+ <li>Schedule SQL commands to run at specific intervals.</li>
	313	+ <li>Ask AI Assistant to help writing queries and solve errors.</li>
	314	+ <li>Build SQL queries visually with our Visual Query Builder.</li>
	315	+ </ul>
306	316	</div>
307	317	</div>
308	318
309	319	<div class="wpda-navi-container-content-item wpda-featured"
		@@ -326,160 +336,71 @@
326	336
327	337	<div class="wpda-navi-container-content-item-facts whats-new">
328	338	<ul>
329	339	<li>
330		- <a href="https://wpdataaccess.com/docs/sql-query-builder/query-builder-getting-started/" target="_blank" class="whatsnew">
331		- New SQL Query Builder with AI Assistant and scheduled queries
	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.
332	342	</a>
333	343	</li>
334	344	<li>
335		- Edit date and time fields in MySQL date format <i class="fas fa-chevron-right"></i> <span class="wpda-new">Form Builder</span>
	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.
	347	+ </a>
336	348	</li>
337	349	<li>
338		- Visualize location data on
339		- <a href="https://wpdataaccess.com/docs/map-builder/map-builder-getting-started/" target="_blank" class="whatsnew">
340		- Maps
	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. ⭐⭐⭐
341	352	</a>
342		- using SQL queries
343	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>
344	359	<li>
345		- <a href="https://wpdataaccess.com/docs/hooks/getting-started-with-hooks/" target="_blank" class="whatsnew">
346		- Hooks for Tables and Forms
	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.
347	362	</a>
348	363	</li>
	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.
	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>
349	381	<li>
350		- New built-ins
351		- <a href="https://wpdataaccess.com/docs/built-ins/built-ins-overview/" target="_blank" class="whatsnew">
352		- log, alert, confirm and snackbar
	382	+ <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/css-table-editor.html" target="_blank" class="whatsnew">
	383	+ CSS Table Editor
353	384	</a>
354		- available in all hooks
355	385	</li>
356	386	<li>
357		- Lightning-Fast Filtering with
358		- <a href="https://wpdataaccess.com/docs/table-builder-performance/server-client-side-processing/" target="_blank" class="whatsnew">
359		- Client-Side Processing
	387	+ <a href="https://docs.rad.wpdataaccess.com/form-builder/menu/form/css-form-editor.html" target="_blank" class="whatsnew">
	388	+ CSS Form Editor
360	389	</a>
361	390	</li>
362		- </ul>
363		- </div>
364		- </div>
365		- </div>
366		- </div>
367		- <?php
368		- }
369		-
370		- private function hot_topics() {
371		- ?>
372		- <div class="wpda-navi-container-content">
373		- <div class="wpda-navi-container-content-item wpda-hot-topics">
374		- <h2>
375		- Frequently Asked Questions
376		- </h2>
377		-
378		- <div class="wpda-navi-container-content-item-facts">
379		- <button
380		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/whats-the-app-builder/', '_blank')"
381		- >
382		- <span class="wpda-hot-title">
383		- App Builder
384		- </span>
385		- <span class="wpda-hot-topic">
386		- What is the App Builder?
387		- </span>
388		- </button>
389		-
390		- <button
391		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-builder-relationships/', '_blank')"
392		- >
393		- <span class="wpda-hot-title">
394		- Master-Detail Relationships
395		- </span>
396		- <span class="wpda-hot-topic">
397		- How do I add a master-detail relationship to my app?
398		- </span>
399		- </button>
400		-
401		- <button
402		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/computed-fields/', '_blank')"
403		- >
404		- <span class="wpda-hot-title">
405		- Computed Fields
406		- </span>
407		- <span class="wpda-hot-topic">
408		- How do I use a computed field in my app?
409		- </span>
410		- </button>
411		-
412		- <button
413		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-lookups/', '_blank')"
414		- >
415		- <span class="wpda-hot-title">
416		- Lookups
417		- </span>
418		- <span class="wpda-hot-topic">
419		- How do I add a lookup to my app?
420		- </span>
421		- </button>
422		-
423		- <button
424		- onClick="window.open('https://wpdataaccess.com/docs/table-builder-filters/column-filters/', '_blank')"
425		- >
426		- <span class="wpda-hot-title">
427		- Column Filters
428		- </span>
429		- <span class="wpda-hot-topic">
430		- How do I enable column filters in my app?
431		- </span>
432		- </button>
433		-
434		- <button
435		- onClick="window.open('https://wpdataaccess.com/documentation/', '_blank')"
436		- >
437		- <span class="wpda-hot-title">
438		- Documentation
439		- </span>
440		- <span class="wpda-hot-topic">
441		- Where can I find the online documentation?
442		- </span>
443		- </button>
444		-
445		- <button>
446		- <span class="wpda-hot-title">
447		- Downloadable Demo Apps
448		- </span>
449		- <span class="wpda-hot-topic" style="display: inline-grid; grid-template-columns: auto auto; gap: 20px;">
450		- <a href="https://wpdataaccess.com/docs/app-demos/app-student-administration-system/" target="_blank">
451		- <i class="fa-solid fa-up-right-from-square"></i>
452		- Student Administration System
453		- </a>
454		- <a href="https://wpdataaccess.com/docs/app-demos/app-classic-models/" target="_blank">
455		- <i class="fa-solid fa-up-right-from-square"></i>
456		- Classic Models
457		- </a>
458		- </span>
459		- </button>
460		-
461		- <button
462		- onClick="window.open('https://wpdataaccess.com/docs/remote-databases/mysql-mariadb/', '_blank')"
463		- >
464		- <span class="wpda-hot-title">
465		- Remote connections
466		- </span>
467		- <span class="wpda-hot-topic">
468		- How can I establish a remote connection?
469		- </span>
470		- </button>
471		-
472		- <button
473		- onClick="window.open('https://wpdataaccess.com/docs/remote-connection-wizard/start-here/', '_blank')"
474		- >
475		- <span class="wpda-hot-title">
476		- Premium Data Services
477		- </span>
478		- <span class="wpda-hot-topic">
479		- How can I use Premium Data Services for remote connections?
480		- </span>
481		- </button>
	391	+ <li>
	392	+ <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/columns/computed-fields.html" target="_blank" class="whatsnew">
	393	+ Computed Text Fields
	394	+ </a>
	395	+ </li>
	396	+ <li>
	397	+ <a href="https://docs.sql.wpdataaccess.com/visual-query-builder.html" target="_blank" class="whatsnew">
	398	+ Visual Query Builder
	399	+ </a>
	400	+ </li>
	401	+ </ul>
	402	+ </div>
482	403	</div>
483	404	</div>
484	405	</div>
485	406	<?php