Fossil

Changes On Branch enhance-reports
Login

Changes On Branch enhance-reports

Patch Side-by-Side Diff

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Changes In Branch enhance-reports Excluding Merge-Ins

This is equivalent to a diff from 6b292eaa78 to 7c1568e3a0

2015-12-23
21:35
Restore original definitions of the 'LOOK_*' flags. ... (check-in: 3161968463 user: mistachkin tags: trunk)
11:41
Change piechart table to view since tables have undefined order ... (Closed-Leaf check-in: 7c1568e3a0 user: baruch tags: enhance-reports)
11:10
Improvements to handling of localtime. The 'utc' and 'localtime' query parameters now work on all web pages. Timestamps can be expressed with a timezone modifier and that works correctly. ... (check-in: ea63a2d1f4 user: drh tags: trunk)
01:37
Enhancements to the lookslike functions. ... (check-in: 6b292eaa78 user: drh tags: trunk)
01:36
Improvements to activity reports. ... (check-in: c94dc804c4 user: drh tags: trunk)
2015-12-21
08:49
merge trunk ... (check-in: 255327f053 user: jan.nijtmans tags: pending-review)

Changes to src/statrep.c.
︙
332
333
334
335
336
337
338
339
340


341
342
343
344
345
346
347

332
333
334
335
336
337
338


339
340
341
342
343
344
345
346
347








-
-
+
+








                                        row colors */
  int nMaxEvents = 1;                /* max number of events for
                                        all rows. */
  stats_report_init_view();
  @ <h1>Timeline Events
  @ (%s(stats_report_label_for_type())) by User</h1>
  db_multi_exec(
    "CREATE TEMP TABLE piechart(amt,label);"
    "INSERT INTO piechart SELECT count(*), ifnull(euser,user) FROM v_reports"
    "CREATE TEMP VIEW piechart(amt,label) AS"
    " SELECT count(*), ifnull(euser,user) FROM v_reports"
                         " GROUP BY ifnull(euser,user) ORDER BY count(*) DESC;"
  );
  if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){
    @ <center><svg width=700 height=400>
    piechart_render(700, 400, PIE_OTHER|PIE_PERCENT);
    @ </svg></centre><hr/>
  }
︙
480
481
482
483
484
485
486
487

488
489

490
491
492
493
494
495
496
497
498
499
500














501
502
503
504
505
506
507

480
481
482
483
484
485
486

487


488











489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509








-
+
-
-
+
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+








               " GROUP BY dow ORDER BY dow", zUserName);
  @ <h1>Timeline Events (%h(stats_report_label_for_type())) by Day of the Week
  if( zUserName ){
    @ for user %h(zUserName)
  }
  @ </h1>
  db_multi_exec(
    "CREATE TEMP TABLE piechart(amt,label);"
    "CREATE TEMP VIEW piechart(amt,label) AS"
    "INSERT INTO piechart"
    " SELECT count(*), cast(strftime('%%w', mtime) AS INT) FROM v_reports"
    " SELECT count(*),"
     " WHERE ifnull(coalesce(euser,user,'')=%Q,1)"
     " GROUP BY 2 ORDER BY 2;"
    "UPDATE piechart SET label = CASE label"
    "  WHEN 0 THEN 'Sunday'"
    "  WHEN 1 THEN 'Monday'"
    "  WHEN 2 THEN 'Tuesday'"
    "  WHEN 3 THEN 'Wednesday'"
    "  WHEN 4 THEN 'Thursday'"
    "  WHEN 5 THEN 'Friday'"
    "  WHEN 6 THEN 'Saturday'"
    "  ELSE 'ERROR' END;", zUserName
    "   CASE cast(strftime('%%w', mtime) AS INT)"
    "    WHEN 0 THEN 'Sunday'"
    "    WHEN 1 THEN 'Monday'"
    "    WHEN 2 THEN 'Tuesday'"
    "    WHEN 3 THEN 'Wednesday'"
    "    WHEN 4 THEN 'Thursday'"
    "    WHEN 5 THEN 'Friday'"
    "    WHEN 6 THEN 'Saturday'"
    "    ELSE 'ERROR'"
    "   END"
    "  FROM v_reports"
    "  WHERE ifnull(coalesce(euser,user,'')=%Q,1)"
    "  GROUP BY 2 ORDER BY 2;"
    , zUserName
  );
  if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){
    @ <center><svg width=700 height=400>
    piechart_render(700, 400, PIE_OTHER|PIE_PERCENT);
    @ </svg></centre><hr/>
  }
  @ <table class='statistics-report-table-events' border='0'
︙