Fossil SCM

Add "Yesterday" and "Tomorrow" submenu links on the /thisdayinhistory page.

drh 2019-05-13 01:47 trunk
Commit d0de24fe8679e3546793a2b72f33474f59fe57d6aa1d7545cd4c3d87453d54a3
1 file changed +5
--- src/timeline.c
+++ src/timeline.c
@@ -2802,10 +2802,11 @@
28022802
static int aYearsAgo[] = { 1, 2, 3, 4, 5, 10, 15, 20, 30, 40, 50, 75, 100 };
28032803
const char *zToday;
28042804
char *zStartOfProject;
28052805
int i;
28062806
Stmt q;
2807
+ char *z;
28072808
28082809
login_check_credentials();
28092810
if( (!g.perm.Read && !g.perm.RdTkt && !g.perm.RdWiki && !g.perm.RdForum) ){
28102811
login_needed(g.anon.Read && g.anon.RdTkt && g.anon.RdWiki);
28112812
return;
@@ -2818,10 +2819,14 @@
28182819
}
28192820
if( zToday==0 ){
28202821
zToday = db_text(0, "SELECT date('now',toLocal())");
28212822
}
28222823
@ <h1>This Day In History For %h(zToday)</h1>
2824
+ z = db_text(0, "SELECT date(%Q,'-1 day')", zToday);
2825
+ style_submenu_element("Yesterday", "%R/thisdayinhistory?today=%t", z);
2826
+ z = db_text(0, "SELECT date(%Q,'+1 day')", zToday);
2827
+ style_submenu_element("Tomorrow", "%R/thisdayinhistory?today=%t", z);
28232828
zStartOfProject = db_text(0,
28242829
"SELECT datetime(min(mtime),toLocal()) FROM event;"
28252830
);
28262831
timeline_temp_table();
28272832
db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/");
28282833
--- src/timeline.c
+++ src/timeline.c
@@ -2802,10 +2802,11 @@
2802 static int aYearsAgo[] = { 1, 2, 3, 4, 5, 10, 15, 20, 30, 40, 50, 75, 100 };
2803 const char *zToday;
2804 char *zStartOfProject;
2805 int i;
2806 Stmt q;
 
2807
2808 login_check_credentials();
2809 if( (!g.perm.Read && !g.perm.RdTkt && !g.perm.RdWiki && !g.perm.RdForum) ){
2810 login_needed(g.anon.Read && g.anon.RdTkt && g.anon.RdWiki);
2811 return;
@@ -2818,10 +2819,14 @@
2818 }
2819 if( zToday==0 ){
2820 zToday = db_text(0, "SELECT date('now',toLocal())");
2821 }
2822 @ <h1>This Day In History For %h(zToday)</h1>
 
 
 
 
2823 zStartOfProject = db_text(0,
2824 "SELECT datetime(min(mtime),toLocal()) FROM event;"
2825 );
2826 timeline_temp_table();
2827 db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/");
2828
--- src/timeline.c
+++ src/timeline.c
@@ -2802,10 +2802,11 @@
2802 static int aYearsAgo[] = { 1, 2, 3, 4, 5, 10, 15, 20, 30, 40, 50, 75, 100 };
2803 const char *zToday;
2804 char *zStartOfProject;
2805 int i;
2806 Stmt q;
2807 char *z;
2808
2809 login_check_credentials();
2810 if( (!g.perm.Read && !g.perm.RdTkt && !g.perm.RdWiki && !g.perm.RdForum) ){
2811 login_needed(g.anon.Read && g.anon.RdTkt && g.anon.RdWiki);
2812 return;
@@ -2818,10 +2819,14 @@
2819 }
2820 if( zToday==0 ){
2821 zToday = db_text(0, "SELECT date('now',toLocal())");
2822 }
2823 @ <h1>This Day In History For %h(zToday)</h1>
2824 z = db_text(0, "SELECT date(%Q,'-1 day')", zToday);
2825 style_submenu_element("Yesterday", "%R/thisdayinhistory?today=%t", z);
2826 z = db_text(0, "SELECT date(%Q,'+1 day')", zToday);
2827 style_submenu_element("Tomorrow", "%R/thisdayinhistory?today=%t", z);
2828 zStartOfProject = db_text(0,
2829 "SELECT datetime(min(mtime),toLocal()) FROM event;"
2830 );
2831 timeline_temp_table();
2832 db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/");
2833

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button