Fossil SCM
Correction to the /thisdayinhistory page so that it shows the first day of the project on the anniversary of the project.
Commit
018db17c5442635a1b1e53e7498e9f1cdd5af7fedf9fd22acc732c8210181192
Parent
f6a99292c975824…
1 file changed
+1
-1
+1
-1
| --- src/timeline.c | ||
| +++ src/timeline.c | ||
| @@ -3024,11 +3024,11 @@ | ||
| 3024 | 3024 | z = db_text(0, "SELECT date(%Q,'-1 day')", zToday); |
| 3025 | 3025 | style_submenu_element("Yesterday", "%R/thisdayinhistory?today=%t", z); |
| 3026 | 3026 | z = db_text(0, "SELECT date(%Q,'+1 day')", zToday); |
| 3027 | 3027 | style_submenu_element("Tomorrow", "%R/thisdayinhistory?today=%t", z); |
| 3028 | 3028 | zStartOfProject = db_text(0, |
| 3029 | - "SELECT datetime(min(mtime),toLocal()) FROM event;" | |
| 3029 | + "SELECT datetime(min(mtime),toLocal(),'startofday') FROM event;" | |
| 3030 | 3030 | ); |
| 3031 | 3031 | timeline_temp_table(); |
| 3032 | 3032 | db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/"); |
| 3033 | 3033 | for(i=0; i<sizeof(aYearsAgo)/sizeof(aYearsAgo[0]); i++){ |
| 3034 | 3034 | int iAgo = aYearsAgo[i]; |
| 3035 | 3035 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -3024,11 +3024,11 @@ | |
| 3024 | z = db_text(0, "SELECT date(%Q,'-1 day')", zToday); |
| 3025 | style_submenu_element("Yesterday", "%R/thisdayinhistory?today=%t", z); |
| 3026 | z = db_text(0, "SELECT date(%Q,'+1 day')", zToday); |
| 3027 | style_submenu_element("Tomorrow", "%R/thisdayinhistory?today=%t", z); |
| 3028 | zStartOfProject = db_text(0, |
| 3029 | "SELECT datetime(min(mtime),toLocal()) FROM event;" |
| 3030 | ); |
| 3031 | timeline_temp_table(); |
| 3032 | db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/"); |
| 3033 | for(i=0; i<sizeof(aYearsAgo)/sizeof(aYearsAgo[0]); i++){ |
| 3034 | int iAgo = aYearsAgo[i]; |
| 3035 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -3024,11 +3024,11 @@ | |
| 3024 | z = db_text(0, "SELECT date(%Q,'-1 day')", zToday); |
| 3025 | style_submenu_element("Yesterday", "%R/thisdayinhistory?today=%t", z); |
| 3026 | z = db_text(0, "SELECT date(%Q,'+1 day')", zToday); |
| 3027 | style_submenu_element("Tomorrow", "%R/thisdayinhistory?today=%t", z); |
| 3028 | zStartOfProject = db_text(0, |
| 3029 | "SELECT datetime(min(mtime),toLocal(),'startofday') FROM event;" |
| 3030 | ); |
| 3031 | timeline_temp_table(); |
| 3032 | db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/"); |
| 3033 | for(i=0; i<sizeof(aYearsAgo)/sizeof(aYearsAgo[0]); i++){ |
| 3034 | int iAgo = aYearsAgo[i]; |
| 3035 |