← All changes | WPDataAccess/WPDA_Navi/WPDA_Navi.php +101 -166 5.5.32 → 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>
		@@ -192,10 +198,14 @@
192	198	</a>
193	199	</div>
194	200	</div>
195	201
196		- <div class="wpda-navi-container-content-item-slogan">
197		- Build Apps with the new Table Builder and Form Builder
	202	+ <div class="wpda-navi-container-content-item-slogan" style="display: flex; justify-content: space-between; align-items: center;">
	203	+ <span>
	204	+ A data-driven Rapid Application Development tool.
	205	+ </span>
	206	+
	207	+ <span></span>
198	208	</div>
199	209
200	210	<div class="wpda-navi-container-content-item-content">
201	211	<ul class="wpda-navi-container-content-item-content-grid switch-grid">
		@@ -207,16 +217,18 @@
207	217	</li>
208	218	</ul>
209	219	</div>
210	220
211		- <div class="wpda-navi-container-content-item-facts">
212		- <ul>
213		- <li>Intuitive Table Builder for creating data tables with ease</li>
214		- <li>Highly customizable Form Builder for designing data entry forms</li>
215		- <li>Integrated Theme Builder to personalize app styling</li>
216		- <li>Interactive Chart Builder for real-time data analysis <span class="wpda-new"><i>NEW</i></span></li>
217		- </ul>
218		- </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>
219	231	</div>
220	232
221	233	<div class="wpda-navi-container-content-item">
222	234	<div class="wpda-navi-container-content-item-title">
		@@ -223,12 +235,12 @@
223	235	<span class="fa-solid fa-database wpda-icon"></span>
224	236	<h3>Explorer</h3>
225	237	<div class="wpda-navi-container-content-item-title-help">
226	238	<a
227		- href="https://wpdataaccess.com/docs/data-explorer/data-explorer-getting-started/"
	239	+ href="https://docs.explorer.wpdataaccess.com/"
228	240	target="_blank"
229	241	class="wpda_tooltip"
230		- title="View online documentation"
	242	+ title="View online Data Explorer documentation"
231	243	>
232	244	<i class="fa-solid fa-question-circle wpda-icon-help"></i>
233	245	</a>
234	246	</div>
		@@ -234,9 +246,9 @@
234	246	</div>
235	247	</div>
236	248
237	249	<div class="wpda-navi-container-content-item-slogan">
238		- Perform data and database related tasks
	250	+ Perform data and database related tasks.
239	251	</div>
240	252
241	253	<div class="wpda-navi-container-content-item-content">
242	254	<ul class="wpda-navi-container-content-item-content-grid">
		@@ -256,10 +268,12 @@
256	268	</div>
257	269
258	270	<div class="wpda-navi-container-content-item-facts">
259	271	<ul>
260		- <li>Explore local and remote databases</li>
261		- <li>Manage table data</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>
262	276	</ul>
263	277	</div>
264	278	</div>
265	279
		@@ -268,12 +282,12 @@
268	282	<span class="fa-solid fa-code wpda-icon"></span>
269	283	<h3>SQL</h3>
270	284	<div class="wpda-navi-container-content-item-title-help">
271	285	<a
272		- href="https://wpdataaccess.com/docs/query-builder/query-builder-getting-started/"
	286	+ href="https://docs.sql.wpdataaccess.com/"
273	287	target="_blank"
274	288	class="wpda_tooltip"
275		- title="View online documentation"
	289	+ title="View online SQL Query Builder Documentation"
276	290	>
277	291	<i class="fa-solid fa-question-circle wpda-icon-help"></i>
278	292	</a>
279	293	</div>
		@@ -279,15 +293,15 @@
279	293	</div>
280	294	</div>
281	295
282	296	<div class="wpda-navi-container-content-item-slogan">
283		- Execute any SQL command from your WordPress dashboard
	297	+ Execute any SQL command from your WordPress dashboard.
284	298	</div>
285	299
286	300	<div class="wpda-navi-container-content-item-content">
287	301	<ul>
288	302	<li>
289		- <a href="?page=wpda_query_builder">Start Query Builder</a>
	303	+ <a href="?page=wpda_query_builder">Start SQL Query Builder</a>
290	304	</li>
291	305	</ul>
292	306	</div>
293	307
		@@ -292,12 +306,14 @@
292	306	</div>
293	307
294	308	<div class="wpda-navi-container-content-item-facts">
295	309	<ul>
296		- <li>Write, store, execute and reuse SQL code</li>
297		- <li>Execute DCL, DDL and DML commands</li>
298		- <li>User must have the necessary credentials</li>
299		- </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>
300	316	</div>
301	317	</div>
302	318
303	319	<div class="wpda-navi-container-content-item wpda-featured"
		@@ -320,152 +336,71 @@
320	336
321	337	<div class="wpda-navi-container-content-item-facts whats-new">
322	338	<ul>
323	339	<li>
324		- View our progress with the App Builder:
325		- <a href="https://wpdataaccess.com/docs/app-builder/road-map/" target="_blank">ROAD MAP</a>
	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.
	342	+ </a>
326	343	</li>
327	344	<li>
328		- Open form in modal window
	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>
329	348	</li>
330	349	<li>
331		- Client-side processing
	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. ⭐⭐⭐
	352	+ </a>
332	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>
333	359	<li>
334		- Sticky header and footer
	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.
	362	+ </a>
335	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>
336	381	<li>
337		- Hide table header and footer
	382	+ <a href="https://docs.rad.wpdataaccess.com/table-builder/menu/table/css-table-editor.html" target="_blank" class="whatsnew">
	383	+ CSS Table Editor
	384	+ </a>
338	385	</li>
339	386	<li>
340		- Interactively change table column visibility and order
	387	+ <a href="https://docs.rad.wpdataaccess.com/form-builder/menu/form/css-form-editor.html" target="_blank" class="whatsnew">
	388	+ CSS Form Editor
	389	+ </a>
341	390	</li>
342	391	<li>
343		- Limit input size textarea
	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>
344	395	</li>
345	396	<li>
346		- Redirect user after completing registration
	397	+ <a href="https://docs.sql.wpdataaccess.com/visual-query-builder.html" target="_blank" class="whatsnew">
	398	+ Visual Query Builder
	399	+ </a>
347	400	</li>
348		- </ul>
349		- </div>
350		- </div>
351		- </div>
352		- </div>
353		- <?php
354		- }
355		-
356		- private function hot_topics() {
357		- ?>
358		- <div class="wpda-navi-container-content">
359		- <div class="wpda-navi-container-content-item wpda-hot-topics">
360		- <h2>
361		- Frequently Asked Questions
362		- </h2>
363		-
364		- <div class="wpda-navi-container-content-item-facts">
365		- <button
366		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/whats-the-app-builder/', '_blank')"
367		- >
368		- <span class="wpda-hot-title">
369		- App Builder
370		- </span>
371		- <span class="wpda-hot-topic">
372		- What is the App Builder?
373		- </span>
374		- </button>
375		-
376		- <button
377		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-builder-relationships/', '_blank')"
378		- >
379		- <span class="wpda-hot-title">
380		- Master-Detail Relationships
381		- </span>
382		- <span class="wpda-hot-topic">
383		- How do I add a master-detail relationship to my app?
384		- </span>
385		- </button>
386		-
387		- <button
388		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/computed-fields/', '_blank')"
389		- >
390		- <span class="wpda-hot-title">
391		- Computed Fields
392		- </span>
393		- <span class="wpda-hot-topic">
394		- How do I use a computed field in my app?
395		- </span>
396		- </button>
397		-
398		- <button
399		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-lookups/', '_blank')"
400		- >
401		- <span class="wpda-hot-title">
402		- Lookups
403		- </span>
404		- <span class="wpda-hot-topic">
405		- How do I add a lookup to my app?
406		- </span>
407		- </button>
408		-
409		- <button
410		- onClick="window.open('https://wpdataaccess.com/docs/table-builder-filters/column-filters/', '_blank')"
411		- >
412		- <span class="wpda-hot-title">
413		- Column Filters
414		- </span>
415		- <span class="wpda-hot-topic">
416		- How do I enable column filters in my app?
417		- </span>
418		- </button>
419		-
420		- <button
421		- onClick="window.open('https://wpdataaccess.com/documentation/', '_blank')"
422		- >
423		- <span class="wpda-hot-title">
424		- Documentation
425		- </span>
426		- <span class="wpda-hot-topic">
427		- Where can I find the online documentation?
428		- </span>
429		- </button>
430		-
431		- <button>
432		- <span class="wpda-hot-title">
433		- Downloadable Demo Apps
434		- </span>
435		- <span class="wpda-hot-topic" style="display: inline-grid; grid-template-columns: auto auto; gap: 20px;">
436		- <a href="https://wpdataaccess.com/docs/app-demos/app-student-administration-system/" target="_blank">
437		- <i class="fa-solid fa-up-right-from-square"></i>
438		- Student Administration System
439		- </a>
440		- <a href="https://wpdataaccess.com/docs/app-demos/app-classic-models/" target="_blank">
441		- <i class="fa-solid fa-up-right-from-square"></i>
442		- Classic Models
443		- </a>
444		- </span>
445		- </button>
446		-
447		- <button
448		- onClick="window.open('https://wpdataaccess.com/docs/remote-databases/mysql-mariadb/', '_blank')"
449		- >
450		- <span class="wpda-hot-title">
451		- Remote connections
452		- </span>
453		- <span class="wpda-hot-topic">
454		- How can I establish a remote connection?
455		- </span>
456		- </button>
457		-
458		- <button
459		- onClick="window.open('https://wpdataaccess.com/docs/remote-connection-wizard/start-here/', '_blank')"
460		- >
461		- <span class="wpda-hot-title">
462		- Premium Data Services
463		- </span>
464		- <span class="wpda-hot-topic">
465		- How can I use Premium Data Services for remote connections?
466		- </span>
467		- </button>
	401	+ </ul>
	402	+ </div>
468	403	</div>
469	404	</div>
470	405	</div>
471	406	<?php