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
jobs.html · 24.6 KB · 611 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>Jobs - DBBASIC Studio</title>
7 <link rel="stylesheet" href="../../static/css/admin.css">
8</head>
9<body>
10 <div class="studio-container">
11 <header class="studio-header">
12 <div class="logo">
13 <span class="logo-icon">⚡</span>
14 <span class="logo-text">DBBASIC Studio</span>
15 </div>
16 <div class="header-actions">
17 <span class="project-name">myblog/</span>
18 <button class="btn-icon" title="Deploy">🚀</button>
19 <button class="btn-icon" title="Settings">⚙️</button>
20 </div>
21 </header>
22
23 <div class="studio-layout">
24 <nav class="sidebar">
25 <a href="../../index.html" class="nav-item">
26 <span class="nav-icon">📊</span>
27 <span class="nav-label">Dashboard</span>
28 </a>
29 <a href="database.html" class="nav-item">
30 <span class="nav-icon">🗄️</span>
31 <span class="nav-label">Database</span>
32 </a>
33 <a href="posts/list.html" class="nav-item">
34 <span class="nav-icon">📝</span>
35 <span class="nav-label">Posts</span>
36 </a>
37 <a href="users/list.html" class="nav-item">
38 <span class="nav-icon">👥</span>
39 <span class="nav-label">Users</span>
40 </a>
41 <div class="nav-divider"></div>
42 <a href="jobs.html" class="nav-item active">
43 <span class="nav-icon">⏰</span>
44 <span class="nav-label">Jobs</span>
45 </a>
46 <a href="logs.html" class="nav-item">
47 <span class="nav-icon">📋</span>
48 <span class="nav-label">Logs</span>
49 </a>
50 <a href="deploy.html" class="nav-item">
51 <span class="nav-icon">🚀</span>
52 <span class="nav-label">Deploy</span>
53 </a>
54 </nav>
55
56 <main class="main-content">
57 <div class="content-header">
58 <div>
59 <h1>Background Jobs</h1>
60 <div class="breadcrumb">Home / Jobs</div>
61 </div>
62 <div class="header-actions">
63 <button class="btn-primary">+ New Job</button>
64 </div>
65 </div>
66
67 <!-- Job Queue Status -->
68 <div class="card">
69 <h2>Queue Status</h2>
70 <div class="queue-stats">
71 <div class="queue-stat">
72 <div class="queue-stat-icon">⏳</div>
73 <div class="queue-stat-content">
74 <div class="queue-stat-value">3</div>
75 <div class="queue-stat-label">Pending</div>
76 </div>
77 </div>
78 <div class="queue-stat">
79 <div class="queue-stat-icon">⚡</div>
80 <div class="queue-stat-content">
81 <div class="queue-stat-value">2</div>
82 <div class="queue-stat-label">Running</div>
83 </div>
84 </div>
85 <div class="queue-stat">
86 <div class="queue-stat-icon">✅</div>
87 <div class="queue-stat-content">
88 <div class="queue-stat-value">1,234</div>
89 <div class="queue-stat-label">Completed</div>
90 </div>
91 </div>
92 <div class="queue-stat">
93 <div class="queue-stat-icon">❌</div>
94 <div class="queue-stat-content">
95 <div class="queue-stat-value">12</div>
96 <div class="queue-stat-label">Failed</div>
97 </div>
98 </div>
99 </div>
100 </div>
101
102 <!-- Active Jobs -->
103 <div class="card">
104 <div class="table-header">
105 <h2>Active Jobs</h2>
106 <button class="btn-secondary-small">⟳ Refresh</button>
107 </div>
108
109 <div class="jobs-list">
110 <div class="job-item job-running">
111 <div class="job-status">
112 <div class="job-status-icon">⚡</div>
113 <div class="job-status-text">Running</div>
114 </div>
115 <div class="job-info">
116 <div class="job-name">resize_images</div>
117 <div class="job-meta">Processing uploads • Started 2m ago</div>
118 <div class="job-progress">
119 <div class="progress-bar">
120 <div class="progress-fill" style="width: 65%"></div>
121 </div>
122 <div class="progress-text">13 of 20 images processed (65%)</div>
123 </div>
124 </div>
125 <div class="job-actions">
126 <button class="btn-secondary-small">View Logs</button>
127 <button class="btn-danger-outline-small">Cancel</button>
128 </div>
129 </div>
130
131 <div class="job-item job-running">
132 <div class="job-status">
133 <div class="job-status-icon">⚡</div>
134 <div class="job-status-text">Running</div>
135 </div>
136 <div class="job-info">
137 <div class="job-name">send_newsletter</div>
138 <div class="job-meta">Email batch processing • Started 5m ago</div>
139 <div class="job-progress">
140 <div class="progress-bar">
141 <div class="progress-fill" style="width: 30%"></div>
142 </div>
143 <div class="progress-text">30 of 100 emails sent (30%)</div>
144 </div>
145 </div>
146 <div class="job-actions">
147 <button class="btn-secondary-small">View Logs</button>
148 <button class="btn-danger-outline-small">Cancel</button>
149 </div>
150 </div>
151 </div>
152 </div>
153
154 <!-- Pending Jobs -->
155 <div class="card">
156 <div class="table-header">
157 <h2>Pending Jobs (3)</h2>
158 </div>
159
160 <div class="table-container">
161 <table class="data-table">
162 <thead>
163 <tr>
164 <th>Job</th>
165 <th>Priority</th>
166 <th>Scheduled For</th>
167 <th>Created</th>
168 <th>Actions</th>
169 </tr>
170 </thead>
171 <tbody>
172 <tr>
173 <td>
174 <div class="job-cell">
175 <strong>cleanup_old_logs</strong>
176 <div class="job-cell-meta">Remove logs older than 30 days</div>
177 </div>
178 </td>
179 <td><span class="badge badge-yellow">Medium</span></td>
180 <td>In 5 minutes</td>
181 <td>2m ago</td>
182 <td>
183 <div class="action-buttons">
184 <button class="btn-icon" title="Run Now">▶️</button>
185 <button class="btn-icon" title="Cancel">❌</button>
186 </div>
187 </td>
188 </tr>
189 <tr>
190 <td>
191 <div class="job-cell">
192 <strong>backup_database</strong>
193 <div class="job-cell-meta">Daily database backup</div>
194 </div>
195 </td>
196 <td><span class="badge badge-green">Low</span></td>
197 <td>Tomorrow at 2:00 AM</td>
198 <td>1h ago</td>
199 <td>
200 <div class="action-buttons">
201 <button class="btn-icon" title="Run Now">▶️</button>
202 <button class="btn-icon" title="Cancel">❌</button>
203 </div>
204 </td>
205 </tr>
206 <tr>
207 <td>
208 <div class="job-cell">
209 <strong>regenerate_thumbnails</strong>
210 <div class="job-cell-meta">Rebuild all image thumbnails</div>
211 </div>
212 </td>
213 <td><span class="badge badge-yellow">Medium</span></td>
214 <td>In 30 minutes</td>
215 <td>10m ago</td>
216 <td>
217 <div class="action-buttons">
218 <button class="btn-icon" title="Run Now">▶️</button>
219 <button class="btn-icon" title="Cancel">❌</button>
220 </div>
221 </td>
222 </tr>
223 </tbody>
224 </table>
225 </div>
226 </div>
227
228 <!-- Recent Jobs -->
229 <div class="card">
230 <div class="table-header">
231 <h2>Recent Jobs</h2>
232 <button class="btn-secondary-small">View All</button>
233 </div>
234
235 <div class="table-container">
236 <table class="data-table">
237 <thead>
238 <tr>
239 <th>Job</th>
240 <th>Status</th>
241 <th>Duration</th>
242 <th>Completed</th>
243 <th>Actions</th>
244 </tr>
245 </thead>
246 <tbody>
247 <tr>
248 <td>
249 <div class="job-cell">
250 <strong>process_uploads</strong>
251 <div class="job-cell-meta">Processed 45 files</div>
252 </div>
253 </td>
254 <td><span class="badge badge-green">✓ Success</span></td>
255 <td>2m 34s</td>
256 <td>10m ago</td>
257 <td>
258 <button class="btn-icon" title="View Logs">📋</button>
259 </td>
260 </tr>
261 <tr>
262 <td>
263 <div class="job-cell">
264 <strong>send_welcome_email</strong>
265 <div class="job-cell-meta">Email to alice@example.com</div>
266 </div>
267 </td>
268 <td><span class="badge badge-green">✓ Success</span></td>
269 <td>1.2s</td>
270 <td>4h ago</td>
271 <td>
272 <button class="btn-icon" title="View Logs">📋</button>
273 </td>
274 </tr>
275 <tr>
276 <td>
277 <div class="job-cell">
278 <strong>export_analytics</strong>
279 <div class="job-cell-meta">Export to CSV failed</div>
280 </div>
281 </td>
282 <td><span class="badge badge-red">✗ Failed</span></td>
283 <td>0.5s</td>
284 <td>1d ago</td>
285 <td>
286 <button class="btn-icon" title="View Logs">📋</button>
287 <button class="btn-icon" title="Retry">⟳</button>
288 </td>
289 </tr>
290 </tbody>
291 </table>
292 </div>
293 </div>
294
295 <!-- Scheduled Jobs (Cron) -->
296 <div class="card">
297 <h2>Scheduled Jobs</h2>
298 <div class="scheduled-jobs">
299 <div class="scheduled-job">
300 <div class="scheduled-job-icon">⏰</div>
301 <div class="scheduled-job-info">
302 <div class="scheduled-job-name">backup_database</div>
303 <div class="scheduled-job-schedule">Every day at 2:00 AM</div>
304 <div class="scheduled-job-meta">Last run: 1 day ago • Next run: In 10 hours</div>
305 </div>
306 <div class="scheduled-job-actions">
307 <button class="btn-secondary-small">Edit</button>
308 <button class="btn-secondary-small">Run Now</button>
309 </div>
310 </div>
311
312 <div class="scheduled-job">
313 <div class="scheduled-job-icon">⏰</div>
314 <div class="scheduled-job-info">
315 <div class="scheduled-job-name">cleanup_sessions</div>
316 <div class="scheduled-job-schedule">Every hour</div>
317 <div class="scheduled-job-meta">Last run: 45 minutes ago • Next run: In 15 minutes</div>
318 </div>
319 <div class="scheduled-job-actions">
320 <button class="btn-secondary-small">Edit</button>
321 <button class="btn-secondary-small">Run Now</button>
322 </div>
323 </div>
324
325 <div class="scheduled-job">
326 <div class="scheduled-job-icon">⏰</div>
327 <div class="scheduled-job-info">
328 <div class="scheduled-job-name">send_digest</div>
329 <div class="scheduled-job-schedule">Every Monday at 9:00 AM</div>
330 <div class="scheduled-job-meta">Last run: 6 days ago • Next run: In 1 day</div>
331 </div>
332 <div class="scheduled-job-actions">
333 <button class="btn-secondary-small">Edit</button>
334 <button class="btn-secondary-small">Run Now</button>
335 </div>
336 </div>
337 </div>
338 </div>
339
340 <!-- Job Files -->
341 <div class="card">
342 <h2>Job Data (TSV Files)</h2>
343 <div class="file-list">
344 <div class="file-item">
345 <div class="file-icon">📄</div>
346 <div class="file-info">
347 <div class="file-name">data/jobs/queue.tsv</div>
348 <div class="file-meta">Job queue • 5 entries</div>
349 </div>
350 <button class="btn-secondary-small">View</button>
351 </div>
352
353 <div class="file-item">
354 <div class="file-icon">📄</div>
355 <div class="file-info">
356 <div class="file-name">data/jobs/history.tsv</div>
357 <div class="file-meta">Completed jobs • 1,246 entries</div>
358 </div>
359 <button class="btn-secondary-small">View</button>
360 </div>
361
362 <div class="file-item">
363 <div class="file-icon">📄</div>
364 <div class="file-info">
365 <div class="file-name">data/jobs/scheduled.tsv</div>
366 <div class="file-meta">Cron schedule • 3 entries</div>
367 </div>
368 <button class="btn-secondary-small">View</button>
369 </div>
370 </div>
371 </div>
372 </main>
373
374 <aside class="ai-assistant">
375 <div class="ai-header">
376 <span class="ai-icon">🤖</span>
377 <span class="ai-title">AI Assistant</span>
378 <button class="ai-toggle">−</button>
379 </div>
380
381 <div class="ai-content">
382 <div class="ai-messages">
383 <div class="ai-message ai-message-assistant">
384 <div class="message-content">
385 I can help you create background jobs, schedule tasks, or debug failures. What would you like to do?
386 </div>
387 </div>
388 </div>
389
390 <div class="ai-suggestions">
391 <div class="suggestion-title">Try asking:</div>
392 <button class="suggestion-btn">"Create a daily backup job"</button>
393 <button class="suggestion-btn">"Send email after post publish"</button>
394 <button class="suggestion-btn">"Why did export job fail?"</button>
395 </div>
396
397 <div class="ai-input">
398 <textarea placeholder="Ask AI about jobs..." rows="3"></textarea>
399 <button class="btn-primary">Send</button>
400 </div>
401 </div>
402 </aside>
403 </div>
404 </div>
405
406 <style>
407 .queue-stats {
408 display: grid;
409 grid-template-columns: repeat(4, 1fr);
410 gap: 1.5rem;
411 }
412
413 .queue-stat {
414 display: flex;
415 align-items: center;
416 gap: 1rem;
417 padding: 1rem;
418 background: var(--color-bg);
419 border-radius: 0.5rem;
420 }
421
422 .queue-stat-icon {
423 font-size: 2rem;
424 }
425
426 .queue-stat-value {
427 font-size: 1.875rem;
428 font-weight: 700;
429 }
430
431 .queue-stat-label {
432 font-size: 0.875rem;
433 color: var(--color-text-muted);
434 }
435
436 .jobs-list {
437 display: flex;
438 flex-direction: column;
439 gap: 1rem;
440 }
441
442 .job-item {
443 display: flex;
444 gap: 1.5rem;
445 padding: 1.5rem;
446 background: var(--color-bg);
447 border-radius: 0.5rem;
448 border-left: 3px solid transparent;
449 }
450
451 .job-item.job-running {
452 border-left-color: var(--color-primary);
453 }
454
455 .job-status {
456 display: flex;
457 flex-direction: column;
458 align-items: center;
459 gap: 0.5rem;
460 }
461
462 .job-status-icon {
463 font-size: 1.5rem;
464 }
465
466 .job-status-text {
467 font-size: 0.75rem;
468 font-weight: 600;
469 color: var(--color-text-muted);
470 }
471
472 .job-info {
473 flex: 1;
474 }
475
476 .job-name {
477 font-weight: 600;
478 font-size: 1rem;
479 margin-bottom: 0.25rem;
480 font-family: monospace;
481 }
482
483 .job-meta {
484 font-size: 0.875rem;
485 color: var(--color-text-muted);
486 margin-bottom: 0.75rem;
487 }
488
489 .job-progress {
490 margin-top: 0.75rem;
491 }
492
493 .progress-bar {
494 height: 0.5rem;
495 background: var(--color-border);
496 border-radius: 0.25rem;
497 overflow: hidden;
498 margin-bottom: 0.5rem;
499 }
500
501 .progress-fill {
502 height: 100%;
503 background: var(--color-primary);
504 transition: width 0.3s ease;
505 }
506
507 .progress-text {
508 font-size: 0.75rem;
509 color: var(--color-text-muted);
510 }
511
512 .job-actions {
513 display: flex;
514 flex-direction: column;
515 gap: 0.5rem;
516 }
517
518 .job-cell {
519 display: flex;
520 flex-direction: column;
521 gap: 0.25rem;
522 }
523
524 .job-cell-meta {
525 font-size: 0.75rem;
526 color: var(--color-text-muted);
527 }
528
529 .scheduled-jobs {
530 display: flex;
531 flex-direction: column;
532 gap: 1rem;
533 }
534
535 .scheduled-job {
536 display: flex;
537 gap: 1rem;
538 padding: 1rem;
539 background: var(--color-bg);
540 border-radius: 0.5rem;
541 }
542
543 .scheduled-job-icon {
544 font-size: 1.5rem;
545 }
546
547 .scheduled-job-info {
548 flex: 1;
549 }
550
551 .scheduled-job-name {
552 font-weight: 600;
553 font-family: monospace;
554 margin-bottom: 0.25rem;
555 }
556
557 .scheduled-job-schedule {
558 font-size: 0.875rem;
559 color: var(--color-primary);
560 margin-bottom: 0.25rem;
561 }
562
563 .scheduled-job-meta {
564 font-size: 0.75rem;
565 color: var(--color-text-muted);
566 }
567
568 .scheduled-job-actions {
569 display: flex;
570 gap: 0.5rem;
571 align-items: center;
572 }
573
574 .file-list {
575 display: flex;
576 flex-direction: column;
577 gap: 0.75rem;
578 }
579
580 .file-item {
581 display: flex;
582 align-items: center;
583 gap: 1rem;
584 padding: 1rem;
585 background: var(--color-bg);
586 border: 1px solid var(--color-border);
587 border-radius: 0.5rem;
588 }
589
590 .file-icon {
591 font-size: 1.5rem;
592 }
593
594 .file-info {
595 flex: 1;
596 }
597
598 .file-name {
599 font-weight: 500;
600 font-family: monospace;
601 font-size: 0.875rem;
602 }
603
604 .file-meta {
605 font-size: 0.75rem;
606 color: var(--color-text-muted);
607 margin-top: 0.25rem;
608 }
609 </style>
610</body>
611</html>