Fossil SCM
Show the last contact time in the administrator view of the subscriber information page.
Commit
11b7c7699f89b8ac47cf76c60ad6d840fba2cae271533448ecca5b6002f4d0fa
Parent
b4bba2ef605cf2a…
1 file changed
+8
-1
+8
-1
| --- src/alerts.c | ||
| +++ src/alerts.c | ||
| @@ -1820,11 +1820,13 @@ | ||
| 1820 | 1820 | " ssub," /* 4 */ |
| 1821 | 1821 | " smip," /* 5 */ |
| 1822 | 1822 | " suname," /* 6 */ |
| 1823 | 1823 | " datetime(mtime,'unixepoch')," /* 7 */ |
| 1824 | 1824 | " datetime(sctime,'unixepoch')," /* 8 */ |
| 1825 | - " hex(subscriberCode)" /* 9 */ | |
| 1825 | + " hex(subscriberCode)," /* 9 */ | |
| 1826 | + " date(coalesce(lastContact*86400,mtime),'unixepoch')," /* 10 */ | |
| 1827 | + " now()/86400 - coalesce(lastContact,mtime/86400)" /* 11 */ | |
| 1826 | 1828 | " FROM subscriber WHERE subscriberId=%d", sid); |
| 1827 | 1829 | if( db_step(&q)!=SQLITE_ROW ){ |
| 1828 | 1830 | db_finalize(&q); |
| 1829 | 1831 | db_commit_transaction(); |
| 1830 | 1832 | cgi_redirect("subscribe"); |
| @@ -1919,10 +1921,15 @@ | ||
| 1919 | 1921 | @ </tr> |
| 1920 | 1922 | @ <tr> |
| 1921 | 1923 | @ <td class='form_label'>Subscriber Code:</td> |
| 1922 | 1924 | @ <td>%h(db_column_text(&q,9))</td> |
| 1923 | 1925 | @ <tr> |
| 1926 | + @ <tr> | |
| 1927 | + @ <td class='form_label'>Last Contact:</td> | |
| 1928 | + @ <td>%h(db_column_text(&q,10)) ← \ | |
| 1929 | + @ %,d(db_column_int(&q,11)) days ago</td> | |
| 1930 | + @ </tr> | |
| 1924 | 1931 | @ <td class="form_label">User:</td> |
| 1925 | 1932 | @ <td><input type="text" name="suname" value="%h(suname?suname:"")" \ |
| 1926 | 1933 | @ size="30">\ |
| 1927 | 1934 | uid = db_int(0, "SELECT uid FROM user WHERE login=%Q", suname); |
| 1928 | 1935 | if( uid ){ |
| 1929 | 1936 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -1820,11 +1820,13 @@ | |
| 1820 | " ssub," /* 4 */ |
| 1821 | " smip," /* 5 */ |
| 1822 | " suname," /* 6 */ |
| 1823 | " datetime(mtime,'unixepoch')," /* 7 */ |
| 1824 | " datetime(sctime,'unixepoch')," /* 8 */ |
| 1825 | " hex(subscriberCode)" /* 9 */ |
| 1826 | " FROM subscriber WHERE subscriberId=%d", sid); |
| 1827 | if( db_step(&q)!=SQLITE_ROW ){ |
| 1828 | db_finalize(&q); |
| 1829 | db_commit_transaction(); |
| 1830 | cgi_redirect("subscribe"); |
| @@ -1919,10 +1921,15 @@ | |
| 1919 | @ </tr> |
| 1920 | @ <tr> |
| 1921 | @ <td class='form_label'>Subscriber Code:</td> |
| 1922 | @ <td>%h(db_column_text(&q,9))</td> |
| 1923 | @ <tr> |
| 1924 | @ <td class="form_label">User:</td> |
| 1925 | @ <td><input type="text" name="suname" value="%h(suname?suname:"")" \ |
| 1926 | @ size="30">\ |
| 1927 | uid = db_int(0, "SELECT uid FROM user WHERE login=%Q", suname); |
| 1928 | if( uid ){ |
| 1929 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -1820,11 +1820,13 @@ | |
| 1820 | " ssub," /* 4 */ |
| 1821 | " smip," /* 5 */ |
| 1822 | " suname," /* 6 */ |
| 1823 | " datetime(mtime,'unixepoch')," /* 7 */ |
| 1824 | " datetime(sctime,'unixepoch')," /* 8 */ |
| 1825 | " hex(subscriberCode)," /* 9 */ |
| 1826 | " date(coalesce(lastContact*86400,mtime),'unixepoch')," /* 10 */ |
| 1827 | " now()/86400 - coalesce(lastContact,mtime/86400)" /* 11 */ |
| 1828 | " FROM subscriber WHERE subscriberId=%d", sid); |
| 1829 | if( db_step(&q)!=SQLITE_ROW ){ |
| 1830 | db_finalize(&q); |
| 1831 | db_commit_transaction(); |
| 1832 | cgi_redirect("subscribe"); |
| @@ -1919,10 +1921,15 @@ | |
| 1921 | @ </tr> |
| 1922 | @ <tr> |
| 1923 | @ <td class='form_label'>Subscriber Code:</td> |
| 1924 | @ <td>%h(db_column_text(&q,9))</td> |
| 1925 | @ <tr> |
| 1926 | @ <tr> |
| 1927 | @ <td class='form_label'>Last Contact:</td> |
| 1928 | @ <td>%h(db_column_text(&q,10)) ← \ |
| 1929 | @ %,d(db_column_int(&q,11)) days ago</td> |
| 1930 | @ </tr> |
| 1931 | @ <td class="form_label">User:</td> |
| 1932 | @ <td><input type="text" name="suname" value="%h(suname?suname:"")" \ |
| 1933 | @ size="30">\ |
| 1934 | uid = db_int(0, "SELECT uid FROM user WHERE login=%Q", suname); |
| 1935 | if( uid ){ |
| 1936 |