Fossil

Check-in [6069602aba]
Login

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

Overview
Comment:If a ticket query begins with an underscore then: # Do not include a link to execute the query directly # Do not show to those users that do not have ticket report access This allows you to create ticket report queries that are for form submissions only, not direct access.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6069602aba14bf74b8f48bd94f7b7e033ca752da
User & Date: jeremy_c 2010-01-09 13:11:18.000
Context
2010-01-09
18:32
Added a user configurable TH1 template for the ticket report list. ... (check-in: 14253e9b33 user: jeremy_c tags: trunk)
13:11
If a ticket query begins with an underscore then: # Do not include a link to execute the query directly # Do not show to those users that do not have ticket report access This allows you to create ticket report queries that are for form submissions only, not direct access. ... (check-in: 6069602aba user: jeremy_c tags: trunk)
12:35
Added the cgi() SQL function implemented by Brain Theado. ... (check-in: 19f552795b user: jeremy_c tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/report.c.
59
60
61
62
63
64
65



66
67
68




69


70
71
72
73
74
75
76
  }else{
    db_prepare(&q, "SELECT rn, title, owner FROM reportfmt ORDER BY title");
    @ <p>Choose a report format from the following list:</p>
    @ <ol>
    while( db_step(&q)==SQLITE_ROW ){
      const char *zTitle = db_column_text(&q, 1);
      const char *zOwner = db_column_text(&q, 2);



      rn = db_column_int(&q, 0);
      cnt++;
      @ <li value="%d(cnt)"><a href="rptview?rn=%d(rn)"




      @        rel="nofollow">%h(zTitle)</a>&nbsp;&nbsp;&nbsp;


      if( g.okWrite && zOwner && zOwner[0] ){
        @ (by <i>%h(zOwner)</i>)
      }
      if( g.okTktFmt ){
        @ [<a href="rptedit?rn=%d(rn)&amp;copy=1" rel="nofollow">copy</a>]
      }
      if( g.okAdmin || (g.okWrTkt && zOwner && strcmp(g.zLogin,zOwner)==0) ){







>
>
>


|
>
>
>
>
|
>
>







59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
  }else{
    db_prepare(&q, "SELECT rn, title, owner FROM reportfmt ORDER BY title");
    @ <p>Choose a report format from the following list:</p>
    @ <ol>
    while( db_step(&q)==SQLITE_ROW ){
      const char *zTitle = db_column_text(&q, 1);
      const char *zOwner = db_column_text(&q, 2);
      if( zTitle[0] =='_' && !g.okTktFmt ){
        continue;
      }
      rn = db_column_int(&q, 0);
      cnt++;
      @ <li value="%d(cnt)">
      if( zTitle[0] == '_' ){
        @%h(zTitle)
      } else {
        @<a href="rptview?rn=%d(rn)"
        @        rel="nofollow">%h(zTitle)</a>        
      }
      @&nbsp;&nbsp;&nbsp;
      if( g.okWrite && zOwner && zOwner[0] ){
        @ (by <i>%h(zOwner)</i>)
      }
      if( g.okTktFmt ){
        @ [<a href="rptedit?rn=%d(rn)&amp;copy=1" rel="nofollow">copy</a>]
      }
      if( g.okAdmin || (g.okWrTkt && zOwner && strcmp(g.zLogin,zOwner)==0) ){