An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.

0 downloads

Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-admin.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-admin.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-admin.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add automatic TSV discovery and admin handlers 5e2fd8f 1 year, 1 month ago History
index.html · 11.7 KB · 261 lines
1<!DOCTYPE html>
2<html lang="en">
3<head>
4 <meta charset="UTF-8">
5 <meta name="viewport" content="width=device-width, initial-scale=1.0">
6 <title>DBBASIC Studio</title>
7 <link rel="stylesheet" href="static/css/admin.css">
8</head>
9<body>
10 <div class="studio-container">
11 <!-- Top Bar -->
12 <header class="studio-header">
13 <div class="logo">
14 <span class="logo-icon">⚡</span>
15 <span class="logo-text">DBBASIC Studio</span>
16 </div>
17 <div class="header-actions">
18 <span class="project-name">myblog/</span>
19 <button class="btn-icon" title="Deploy">🚀</button>
20 <button class="btn-icon" title="Settings">⚙️</button>
21 </div>
22 </header>
23
24 <!-- Main Layout -->
25 <div class="studio-layout">
26 <!-- Sidebar Navigation -->
27 <nav class="sidebar" id="admin-sidebar">
28 <!-- Navigation items loaded dynamically -->
29 <div class="nav-loading">Loading...</div>
30 </nav>
31
32 <!-- Main Content Area -->
33 <main class="main-content">
34 <div class="content-header">
35 <h1>Dashboard</h1>
36 <div class="breadcrumb">Home / Dashboard</div>
37 </div>
38
39 <div class="dashboard-grid">
40 <!-- Stats Cards -->
41 <div class="card stat-card">
42 <div class="stat-icon">📝</div>
43 <div class="stat-content">
44 <div class="stat-label">Total Posts</div>
45 <div class="stat-value">145</div>
46 <div class="stat-change">+12 this week</div>
47 </div>
48 </div>
49
50 <div class="card stat-card">
51 <div class="stat-icon">👥</div>
52 <div class="stat-content">
53 <div class="stat-label">Users</div>
54 <div class="stat-value">23</div>
55 <div class="stat-change">+3 this week</div>
56 </div>
57 </div>
58
59 <div class="card stat-card">
60 <div class="stat-icon">💬</div>
61 <div class="stat-content">
62 <div class="stat-label">Comments</div>
63 <div class="stat-value">892</div>
64 <div class="stat-change">+45 this week</div>
65 </div>
66 </div>
67
68 <div class="card stat-card">
69 <div class="stat-icon">📊</div>
70 <div class="stat-content">
71 <div class="stat-label">Page Views</div>
72 <div class="stat-value">12.4K</div>
73 <div class="stat-change">+8% this week</div>
74 </div>
75 </div>
76
77 <!-- Quick Actions -->
78 <div class="card quick-actions">
79 <h2>Quick Actions</h2>
80 <div class="action-grid">
81 <a href="templates/admin/posts/new.html" class="action-btn">
82 <span class="action-icon">➕</span>
83 <span>New Post</span>
84 </a>
85 <a href="templates/admin/code.html" class="action-btn">
86 <span class="action-icon">💻</span>
87 <span>View Code</span>
88 </a>
89 <a href="templates/admin/database.html" class="action-btn">
90 <span class="action-icon">🗄️</span>
91 <span>View Data</span>
92 </a>
93 <a href="templates/admin/settings.html" class="action-btn">
94 <span class="action-icon">⚙️</span>
95 <span>Settings</span>
96 </a>
97 <a href="templates/admin/deploy.html" class="action-btn">
98 <span class="action-icon">🚀</span>
99 <span>Deploy</span>
100 </a>
101 <a href="templates/admin/ai.html" class="action-btn">
102 <span class="action-icon">🤖</span>
103 <span>Ask AI</span>
104 </a>
105 </div>
106 </div>
107
108 <!-- Recent Activity -->
109 <div class="card recent-activity">
110 <h2>Recent Activity</h2>
111 <div class="activity-list">
112 <div class="activity-item">
113 <span class="activity-icon">📝</span>
114 <div class="activity-content">
115 <div class="activity-title">New post created</div>
116 <div class="activity-meta">"Getting Started with DBBASIC" • 2 hours ago</div>
117 </div>
118 </div>
119 <div class="activity-item">
120 <span class="activity-icon">👤</span>
121 <div class="activity-content">
122 <div class="activity-title">New user registered</div>
123 <div class="activity-meta">alice@example.com • 4 hours ago</div>
124 </div>
125 </div>
126 <div class="activity-item">
127 <span class="activity-icon">🚀</span>
128 <div class="activity-content">
129 <div class="activity-title">Deployed to production</div>
130 <div class="activity-meta">v1.2.3 • 1 day ago</div>
131 </div>
132 </div>
133 </div>
134 </div>
135
136 <!-- System Info -->
137 <div class="card system-info">
138 <h2>System Info</h2>
139 <div class="info-list">
140 <div class="info-row">
141 <span class="info-label">Database</span>
142 <span class="info-value">TSV (3 tables)</span>
143 </div>
144 <div class="info-row">
145 <span class="info-label">Storage</span>
146 <span class="info-value">142 MB / 10 GB</span>
147 </div>
148 <div class="info-row">
149 <span class="info-label">Uptime</span>
150 <span class="info-value">14 days</span>
151 </div>
152 <div class="info-row">
153 <span class="info-label">Version</span>
154 <span class="info-value">DBBASIC 0.1.0</span>
155 </div>
156 </div>
157 </div>
158 </div>
159 </main>
160
161 <!-- AI Assistant Sidebar -->
162 <aside class="ai-assistant">
163 <div class="ai-header">
164 <span class="ai-icon">🤖</span>
165 <span class="ai-title">AI Assistant</span>
166 <button class="ai-toggle">−</button>
167 </div>
168
169 <div class="ai-content">
170 <div class="ai-messages">
171 <div class="ai-message ai-message-assistant">
172 <div class="message-content">
173 Hi! I can help you build features, modify your database, or deploy your app. What would you like to do?
174 </div>
175 </div>
176 </div>
177
178 <div class="ai-suggestions">
179 <div class="suggestion-title">Try asking:</div>
180 <button class="suggestion-btn">"Add image uploads to posts"</button>
181 <button class="suggestion-btn">"Create a comments table"</button>
182 <button class="suggestion-btn">"Deploy to production"</button>
183 </div>
184
185 <div class="ai-input">
186 <textarea placeholder="Ask AI to modify your app..." rows="3"></textarea>
187 <button class="btn-primary">Send</button>
188 </div>
189 </div>
190 </aside>
191 </div>
192 </div>
193
194 <script>
195 // Load navigation dynamically from API
196 async function loadNavigation() {
197 try {
198 const response = await fetch('/admin/api/nav');
199 const navItems = await response.json();
200 const sidebar = document.getElementById('admin-sidebar');
201
202 // Clear loading message
203 sidebar.innerHTML = '';
204
205 // Get current path for active state
206 const currentPath = window.location.pathname;
207
208 // Build nav HTML
209 let lastOrder = -1;
210 navItems.forEach(item => {
211 // Add divider if order jumps significantly (e.g., between content and system sections)
212 if (lastOrder >= 0 && item.order - lastOrder > 15) {
213 const divider = document.createElement('div');
214 divider.className = 'nav-divider';
215 sidebar.appendChild(divider);
216 }
217
218 // Create nav item
219 const navItem = document.createElement('a');
220 navItem.href = item.href;
221 navItem.className = 'nav-item';
222
223 // Mark as active if current page
224 if (currentPath === item.href || currentPath.endsWith(item.href)) {
225 navItem.classList.add('active');
226 }
227
228 // Icon
229 const icon = document.createElement('span');
230 icon.className = 'nav-icon';
231 icon.textContent = item.icon || '•';
232 navItem.appendChild(icon);
233
234 // Label
235 const label = document.createElement('span');
236 label.className = 'nav-label';
237 label.textContent = item.label;
238 navItem.appendChild(label);
239
240 // Badge (if present)
241 if (item.badge) {
242 const badge = document.createElement('span');
243 badge.className = 'nav-badge';
244 badge.textContent = item.badge;
245 navItem.appendChild(badge);
246 }
247
248 sidebar.appendChild(navItem);
249 lastOrder = item.order;
250 });
251 } catch (error) {
252 console.error('Failed to load navigation:', error);
253 document.getElementById('admin-sidebar').innerHTML = '<div class="nav-error">Failed to load navigation</div>';
254 }
255 }
256
257 // Load navigation on page load
258 document.addEventListener('DOMContentLoaded', loadNavigation);
259 </script>
260</body>
261</html>