← All changes | WPDataAccess/WPDA_Navi/WPDA_Navi.php +106 -166 5.5.23 → 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,147 +336,71 @@
320	336
321	337	<div class="wpda-navi-container-content-item-facts whats-new">
322	338	<ul>
323	339	<li>
324		- <strong>Save button</strong> in table header for inline updates<br/>(Table Builder > Table > Inline editing settings)
	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>
325	343	</li>
326	344	<li>
327		- Create <strong>Charts</strong> with the <strong>App Builder</strong>
	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>
328	348	</li>
	349	+ <li>
	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>
	353	+ </li>
329	354	<li>
330		- Build <strong>Registration Forms</strong> with the <strong>App Builder</strong>
	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>
331	358	</li>
332		- <li>
333		- Customize app behavior using <strong>hooks</strong>
334		- &nbsp;
335		- <a href="https://wpdataaccess.com/docs/table-hooks/getting-started-with-hooks/"
336		- target="_blank"
337		- class="wpda_tooltip"
338		- title="View online documentation"
339		- >
340		- <i class="fa-solid fa-question-circle"></i>
	359	+ <li>
	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.
341	362	</a>
342		- </li>
	363	+ </li>
343	364	</ul>
344	365	</div>
345		- </div>
346		- </div>
347		- </div>
348		- <?php
349		- }
350	366
351		- private function hot_topics() {
352		- ?>
353		- <div class="wpda-navi-container-content">
354		- <div class="wpda-navi-container-content-item wpda-hot-topics">
355		- <h2>
356		- Frequently Asked Questions
357		- </h2>
	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>
358	377
359		- <div class="wpda-navi-container-content-item-facts">
360		- <button
361		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/whats-the-app-builder/', '_blank')"
362		- >
363		- <span class="wpda-hot-title">
364		- App Builder
365		- </span>
366		- <span class="wpda-hot-topic">
367		- What is the App Builder?
368		- </span>
369		- </button>
370		-
371		- <button
372		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-builder-relationships/', '_blank')"
373		- >
374		- <span class="wpda-hot-title">
375		- Master-Detail Relationships
376		- </span>
377		- <span class="wpda-hot-topic">
378		- How do I add a master-detail relationship to my app?
379		- </span>
380		- </button>
381		-
382		- <button
383		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/computed-fields/', '_blank')"
384		- >
385		- <span class="wpda-hot-title">
386		- Computed Fields
387		- </span>
388		- <span class="wpda-hot-topic">
389		- How do I use a computed field in my app?
390		- </span>
391		- </button>
392		-
393		- <button
394		- onClick="window.open('https://wpdataaccess.com/docs/app-builder/app-lookups/', '_blank')"
395		- >
396		- <span class="wpda-hot-title">
397		- Lookups
398		- </span>
399		- <span class="wpda-hot-topic">
400		- How do I add a lookup to my app?
401		- </span>
402		- </button>
403		-
404		- <button
405		- onClick="window.open('https://wpdataaccess.com/docs/table-builder-filters/column-filters/', '_blank')"
406		- >
407		- <span class="wpda-hot-title">
408		- Column Filters
409		- </span>
410		- <span class="wpda-hot-topic">
411		- How do I enable column filters in my app?
412		- </span>
413		- </button>
414		-
415		- <button
416		- onClick="window.open('https://wpdataaccess.com/documentation/', '_blank')"
417		- >
418		- <span class="wpda-hot-title">
419		- Documentation
420		- </span>
421		- <span class="wpda-hot-topic">
422		- Where can I find the online documentation?
423		- </span>
424		- </button>
425		-
426		- <button>
427		- <span class="wpda-hot-title">
428		- Downloadable Demo Apps
429		- </span>
430		- <span class="wpda-hot-topic" style="display: inline-grid; grid-template-columns: auto auto; gap: 20px;">
431		- <a href="https://wpdataaccess.com/docs/app-demos/app-student-administration-system/" target="_blank">
432		- <i class="fa-solid fa-up-right-from-square"></i>
433		- Student Administration System
434		- </a>
435		- <a href="https://wpdataaccess.com/docs/app-demos/app-classic-models/" target="_blank">
436		- <i class="fa-solid fa-up-right-from-square"></i>
437		- Classic Models
438		- </a>
439		- </span>
440		- </button>
441		-
442		- <button
443		- onClick="window.open('https://wpdataaccess.com/docs/remote-databases/mysql-mariadb/', '_blank')"
444		- >
445		- <span class="wpda-hot-title">
446		- Remote connections
447		- </span>
448		- <span class="wpda-hot-topic">
449		- How can I establish a remote connection?
450		- </span>
451		- </button>
452		-
453		- <button
454		- onClick="window.open('https://wpdataaccess.com/docs/remote-connection-wizard/start-here/', '_blank')"
455		- >
456		- <span class="wpda-hot-title">
457		- Premium Data Services
458		- </span>
459		- <span class="wpda-hot-topic">
460		- How can I use Premium Data Services for remote connections?
461		- </span>
462		- </button>
	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>
	381	+ <li>
	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>
	385	+ </li>
	386	+ <li>
	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>
	390	+ </li>
	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>
463	403	</div>
464	404	</div>
465	405	</div>
466	406	<?php