Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Improvements to the "Last Change" report. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
1dc93b704f3d1b35da7c4e751df55dff |
| User & Date: | drh 2017-07-01 18:09:59.546 |
Context
|
2017-07-01
| ||
| 19:36 | Update the change log to mention recent enhancements. ... (check-in: 8fe2f97ea1 user: drh tags: trunk) | |
| 18:09 | Improvements to the "Last Change" report. ... (check-in: 1dc93b704f user: drh tags: trunk) | |
| 17:54 | Add the "Last Change" activity report. ... (check-in: b629647e82 user: drh tags: trunk) | |
Changes
Changes to src/statrep.c.
| ︙ | ︙ | |||
645 646 647 648 649 650 651 652 653 |
/*
** Generate a report that shows the most recent change for each user.
*/
static void stats_report_last_change(void){
Stmt s;
double rNow;
stats_report_init_view();
| > > > > | < | > | | | 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 |
/*
** Generate a report that shows the most recent change for each user.
*/
static void stats_report_last_change(void){
Stmt s;
double rNow;
char *zBaseUrl;
stats_report_init_view();
@ <h1>Event Summary
@ (%s(stats_report_label_for_type())) by User</h1>
@ <table border=1 class='statistics-report-table-events'
@ cellpadding=2 cellspacing=0 id='lastchng'>
@ <thead><tr>
@ <th>User<th>Total Changes<th>Last Change</tr></thead>
@ <tbody>
zBaseUrl = mprintf("%R/timeline?y=%t&u=", PD("type","ci"));
db_prepare(&s,
"SELECT coalesce(euser,user),"
" count(*),"
" max(mtime)"
" FROM v_reports"
" GROUP BY 1"
" ORDER BY 3 DESC"
);
rNow = db_double(0.0, "SELECT julianday('now');");
while( db_step(&s)==SQLITE_ROW ){
const char *zUser = db_column_text(&s, 0);
int cnt = db_column_int(&s, 1);
double rMTime = db_column_double(&s,2);
char *zAge = human_readable_age(rNow - rMTime);
@ <tr>
@ <td><a href='%s(zBaseUrl)%t(zUser)'>%h(zUser)</a>
@ <td>%d(cnt)
@ <td data-sortkey='%f(rMTime)' style='white-space:nowrap'>%s(zAge?zAge:"")
@ </tr>
fossil_free(zAge);
}
@ </tbody></table>
db_finalize(&s);
output_table_sorting_javascript("lastchng","tNK",3);
}
/* Report types
*/
#define RPT_BYFILE 1
#define RPT_BYMONTH 2
|
| ︙ | ︙ |