Fossil SCM

Added new /reports page: byweekday. Most tags and commits happen on Thursdays. Most tickets on Wednesdays.

stephan 2014-04-11 21:30 trunk
Commit 2cf6304bc375a0c0c0dc7375c8200a4e2de93166
Parent b7ff537dca97208…
2 files changed +73 +1
~ src/timeline.c ~ www/changes.wiki
M src/timeline.c
+73
--- src/timeline.c
+++ src/timeline.c
@@ -2371,10 +2371,79 @@
23712371
 @ </tbody></table>
23722372
 db_finalize(&query);
23732373
 output_table_sorting_javascript("statsTable","tnx");
23742374
 }
23752375
2376
+/*
2377
+** Implements the "byweekday" view for /reports.
2378
+*/
2379
+static void stats_report_day_of_week(){
2380
+ Stmt query = empty_Stmt;
2381
+ int nRowNumber = 0; /* current TR number */
2382
+ int nEventTotal = 0; /* Total event count */
2383
+ int rowClass = 0; /* counter for alternating
2384
+ row colors */
2385
+ Blob sql = empty_blob; /* SQL */
2386
+ int nMaxEvents = 1; /* max number of events for
2387
+ all rows. */
2388
+ static char const * daysOfWeek[] = {
2389
+ "Monday", "Tuesday", "Wednesday", "Thursday",
2390
+ "Friday", "Saturday", "Sunday"
2391
+ };
2392
+
2393
+ stats_report_init_view();
2394
+ stats_report_event_types_menu("byweekday", NULL);
2395
+ blob_append(&sql,
2396
+ "SELECT cast(mtime %% 7 AS INTEGER) dow, "
2397
+ "COUNT(*) AS eventCount "
2398
+ "FROM v_reports "
2399
+ "GROUP BY dow ORDER BY dow",
2400
+ -1);
2401
+ db_prepare(&query, blob_str(&sql));
2402
+ blob_reset(&sql);
2403
+ @ <h1>Timeline Events
2404
+ @ (%s(stats_report_label_for_type())) by Day of the Week</h1>
2405
+ @ <table class='statistics-report-table-events' border='0'
2406
+ @ cellpadding='2' cellspacing='0' id='statsTable'>
2407
+ @ <thead><tr>
2408
+ @ <th>DoW</th>
2409
+ @ <th>Day</th>
2410
+ @ <th>Events</th>
2411
+ @ <th width='90%%'><!-- relative commits graph --></th>
2412
+ @ </tr></thead><tbody>
2413
+ while( SQLITE_ROW == db_step(&query) ){
2414
+ const int nCount = db_column_int(&query, 1);
2415
+ if(nCount>nMaxEvents){
2416
+ nMaxEvents = nCount;
2417
+ }
2418
+ }
2419
+ db_reset(&query);
2420
+ while( SQLITE_ROW == db_step(&query) ){
2421
+ int const dayNum =db_column_int(&query, 0);
2422
+ const int nCount = db_column_int(&query, 1);
2423
+ int nSize = nCount
2424
+ ? (int)(100 * nCount / nMaxEvents)
2425
+ : 0;
2426
+ if(!nCount) continue /* arguable! Possible? */;
2427
+ else if(!nSize) nSize = 1;
2428
+ rowClass = ++nRowNumber % 2;
2429
+ nEventTotal += nCount;
2430
+ @<tr class='row%d(rowClass)'>
2431
+ @ <td>%d(dayNum)</td>
2432
+ @ <td>%s(daysOfWeek[dayNum])</td>
2433
+ @ <td>%d(nCount)</td>
2434
+ @ <td>
2435
+ @ <div class='statistics-report-graph-line'
2436
+ @ style='width:%d(nSize)%%;'>&nbsp;</div>
2437
+ @ </td>
2438
+ @</tr>
2439
+ }
2440
+ @ </tbody></table>
2441
+ db_finalize(&query);
2442
+ output_table_sorting_javascript("statsTable","ntnx");
2443
+}
2444
+
23762445
23772446
 /*
23782447
 ** Helper for stats_report_by_month_year(), which generates a list of
23792448
 ** week numbers. zTimeframe should be either a timeframe in the form YYYY
23802449
 ** or YYYY-MM.
@@ -2541,10 +2610,11 @@
25412610
 timeline_submenu(&url, "(Remove User Flag)", "view", zView, "user");
25422611
 }
25432612
 timeline_submenu(&url, "By Year", "view", "byyear", 0);
25442613
 timeline_submenu(&url, "By Month", "view", "bymonth", 0);
25452614
 timeline_submenu(&url, "By Week", "view", "byweek", 0);
2615
+ timeline_submenu(&url, "By Weekday", "view", "byweekday", 0);
25462616
 timeline_submenu(&url, "By User", "view", "byuser", "user");
25472617
 url_reset(&url);
25482618
 style_header("Activity Reports");
25492619
 if(0==fossil_strcmp(zView,"byyear")){
25502620
 stats_report_by_month_year(0, 0, zUserName);
@@ -2552,17 +2622,20 @@
25522622
 stats_report_by_month_year(1, 0, zUserName);
25532623
 }else if(0==fossil_strcmp(zView,"byweek")){
25542624
 stats_report_year_weeks(zUserName);
25552625
 }else if(0==fossil_strcmp(zView,"byuser")){
25562626
 stats_report_by_user();
2627
+ }else if(0==fossil_strcmp(zView,"byweekday")){
2628
+ stats_report_day_of_week();
25572629
 }else{
25582630
 @ <h1>Select a report to show:</h1>
25592631
 @ <ul>
25602632
 @ <li><a href='?view=byyear'>Events by year</a></li>
25612633
 @ <li><a href='?view=bymonth'>Events by month</a></li>
25622634
 @ <li><a href='?view=byweek'>Events by calendar week</a></li>
2635
+ @ <li><a href='?view=byweekday'>Events by day of the week</a></li>
25632636
 @ <li><a href='?view=byuser'>Events by user</a></li>
25642637
 @ </ul>
25652638
 }
25662639
25672640
 style_footer();
25682641
 }
25692642
--- src/timeline.c
+++ src/timeline.c
@@ -2371,10 +2371,79 @@
2371 @ </tbody></table>
2372 db_finalize(&query);
2373 output_table_sorting_javascript("statsTable","tnx");
2374 }
2375
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2376
2377 /*
2378 ** Helper for stats_report_by_month_year(), which generates a list of
2379 ** week numbers. zTimeframe should be either a timeframe in the form YYYY
2380 ** or YYYY-MM.
@@ -2541,10 +2610,11 @@
2541 timeline_submenu(&url, "(Remove User Flag)", "view", zView, "user");
2542 }
2543 timeline_submenu(&url, "By Year", "view", "byyear", 0);
2544 timeline_submenu(&url, "By Month", "view", "bymonth", 0);
2545 timeline_submenu(&url, "By Week", "view", "byweek", 0);
 
2546 timeline_submenu(&url, "By User", "view", "byuser", "user");
2547 url_reset(&url);
2548 style_header("Activity Reports");
2549 if(0==fossil_strcmp(zView,"byyear")){
2550 stats_report_by_month_year(0, 0, zUserName);
@@ -2552,17 +2622,20 @@
2552 stats_report_by_month_year(1, 0, zUserName);
2553 }else if(0==fossil_strcmp(zView,"byweek")){
2554 stats_report_year_weeks(zUserName);
2555 }else if(0==fossil_strcmp(zView,"byuser")){
2556 stats_report_by_user();
 
 
2557 }else{
2558 @ <h1>Select a report to show:</h1>
2559 @ <ul>
2560 @ <li><a href='?view=byyear'>Events by year</a></li>
2561 @ <li><a href='?view=bymonth'>Events by month</a></li>
2562 @ <li><a href='?view=byweek'>Events by calendar week</a></li>
 
2563 @ <li><a href='?view=byuser'>Events by user</a></li>
2564 @ </ul>
2565 }
2566
2567 style_footer();
2568 }
2569
--- src/timeline.c
+++ src/timeline.c
@@ -2371,10 +2371,79 @@
2371 @ </tbody></table>
2372 db_finalize(&query);
2373 output_table_sorting_javascript("statsTable","tnx");
2374 }
2375
2376 /*
2377 ** Implements the "byweekday" view for /reports.
2378 */
2379 static void stats_report_day_of_week(){
2380 Stmt query = empty_Stmt;
2381 int nRowNumber = 0; /* current TR number */
2382 int nEventTotal = 0; /* Total event count */
2383 int rowClass = 0; /* counter for alternating
2384 row colors */
2385 Blob sql = empty_blob; /* SQL */
2386 int nMaxEvents = 1; /* max number of events for
2387 all rows. */
2388 static char const * daysOfWeek[] = {
2389 "Monday", "Tuesday", "Wednesday", "Thursday",
2390 "Friday", "Saturday", "Sunday"
2391 };
2392
2393 stats_report_init_view();
2394 stats_report_event_types_menu("byweekday", NULL);
2395 blob_append(&sql,
2396 "SELECT cast(mtime %% 7 AS INTEGER) dow, "
2397 "COUNT(*) AS eventCount "
2398 "FROM v_reports "
2399 "GROUP BY dow ORDER BY dow",
2400 -1);
2401 db_prepare(&query, blob_str(&sql));
2402 blob_reset(&sql);
2403 @ <h1>Timeline Events
2404 @ (%s(stats_report_label_for_type())) by Day of the Week</h1>
2405 @ <table class='statistics-report-table-events' border='0'
2406 @ cellpadding='2' cellspacing='0' id='statsTable'>
2407 @ <thead><tr>
2408 @ <th>DoW</th>
2409 @ <th>Day</th>
2410 @ <th>Events</th>
2411 @ <th width='90%%'><!-- relative commits graph --></th>
2412 @ </tr></thead><tbody>
2413 while( SQLITE_ROW == db_step(&query) ){
2414 const int nCount = db_column_int(&query, 1);
2415 if(nCount>nMaxEvents){
2416 nMaxEvents = nCount;
2417 }
2418 }
2419 db_reset(&query);
2420 while( SQLITE_ROW == db_step(&query) ){
2421 int const dayNum =db_column_int(&query, 0);
2422 const int nCount = db_column_int(&query, 1);
2423 int nSize = nCount
2424 ? (int)(100 * nCount / nMaxEvents)
2425 : 0;
2426 if(!nCount) continue /* arguable! Possible? */;
2427 else if(!nSize) nSize = 1;
2428 rowClass = ++nRowNumber % 2;
2429 nEventTotal += nCount;
2430 @<tr class='row%d(rowClass)'>
2431 @ <td>%d(dayNum)</td>
2432 @ <td>%s(daysOfWeek[dayNum])</td>
2433 @ <td>%d(nCount)</td>
2434 @ <td>
2435 @ <div class='statistics-report-graph-line'
2436 @ style='width:%d(nSize)%%;'>&nbsp;</div>
2437 @ </td>
2438 @</tr>
2439 }
2440 @ </tbody></table>
2441 db_finalize(&query);
2442 output_table_sorting_javascript("statsTable","ntnx");
2443 }
2444
2445
2446 /*
2447 ** Helper for stats_report_by_month_year(), which generates a list of
2448 ** week numbers. zTimeframe should be either a timeframe in the form YYYY
2449 ** or YYYY-MM.
@@ -2541,10 +2610,11 @@
2610 timeline_submenu(&url, "(Remove User Flag)", "view", zView, "user");
2611 }
2612 timeline_submenu(&url, "By Year", "view", "byyear", 0);
2613 timeline_submenu(&url, "By Month", "view", "bymonth", 0);
2614 timeline_submenu(&url, "By Week", "view", "byweek", 0);
2615 timeline_submenu(&url, "By Weekday", "view", "byweekday", 0);
2616 timeline_submenu(&url, "By User", "view", "byuser", "user");
2617 url_reset(&url);
2618 style_header("Activity Reports");
2619 if(0==fossil_strcmp(zView,"byyear")){
2620 stats_report_by_month_year(0, 0, zUserName);
@@ -2552,17 +2622,20 @@
2622 stats_report_by_month_year(1, 0, zUserName);
2623 }else if(0==fossil_strcmp(zView,"byweek")){
2624 stats_report_year_weeks(zUserName);
2625 }else if(0==fossil_strcmp(zView,"byuser")){
2626 stats_report_by_user();
2627 }else if(0==fossil_strcmp(zView,"byweekday")){
2628 stats_report_day_of_week();
2629 }else{
2630 @ <h1>Select a report to show:</h1>
2631 @ <ul>
2632 @ <li><a href='?view=byyear'>Events by year</a></li>
2633 @ <li><a href='?view=bymonth'>Events by month</a></li>
2634 @ <li><a href='?view=byweek'>Events by calendar week</a></li>
2635 @ <li><a href='?view=byweekday'>Events by day of the week</a></li>
2636 @ <li><a href='?view=byuser'>Events by user</a></li>
2637 @ </ul>
2638 }
2639
2640 style_footer();
2641 }
2642
M www/changes.wiki
+1
--- www/changes.wiki
+++ www/changes.wiki
@@ -18,10 +18,11 @@
1818
 [/help?cmd=diff|fossil (g)diff], [/help?cmd=stash|fossil stash diff].
1919
 * Add --strip-trailing-cr option to [/help?cmd=diff|fossil (g)diff] and
2020
 [/help?cmd=stash|fossil stash diff].
2121
 * Add button "Ignore Whitespace" to /annotate, /blame, /ci, /fdiff
2222
 and /vdiff UI pages.
23
+ * Enhanced [/reports?view=byweekday|/reports] with a "byweekday" view.
2324
2425
 <h2>Changes For Version 1.28 (2014-01-27)</h2>
2526
 * Enhance [/help?cmd=/reports | /reports] to support event type filtering.
2627
 * When cloning a repository, the user name passed via the URL (if any)
2728
 is now used as the default local admin user's name.
2829
--- www/changes.wiki
+++ www/changes.wiki
@@ -18,10 +18,11 @@
18 [/help?cmd=diff|fossil (g)diff], [/help?cmd=stash|fossil stash diff].
19 * Add --strip-trailing-cr option to [/help?cmd=diff|fossil (g)diff] and
20 [/help?cmd=stash|fossil stash diff].
21 * Add button "Ignore Whitespace" to /annotate, /blame, /ci, /fdiff
22 and /vdiff UI pages.
 
23
24 <h2>Changes For Version 1.28 (2014-01-27)</h2>
25 * Enhance [/help?cmd=/reports | /reports] to support event type filtering.
26 * When cloning a repository, the user name passed via the URL (if any)
27 is now used as the default local admin user's name.
28
--- www/changes.wiki
+++ www/changes.wiki
@@ -18,10 +18,11 @@
18 [/help?cmd=diff|fossil (g)diff], [/help?cmd=stash|fossil stash diff].
19 * Add --strip-trailing-cr option to [/help?cmd=diff|fossil (g)diff] and
20 [/help?cmd=stash|fossil stash diff].
21 * Add button "Ignore Whitespace" to /annotate, /blame, /ci, /fdiff
22 and /vdiff UI pages.
23 * Enhanced [/reports?view=byweekday|/reports] with a "byweekday" view.
24
25 <h2>Changes For Version 1.28 (2014-01-27)</h2>
26 * Enhance [/help?cmd=/reports | /reports] to support event type filtering.
27 * When cloning a repository, the user name passed via the URL (if any)
28 is now used as the default local admin user's name.
29

Keyboard Shortcuts

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