Fossil

Check-in [6069602a]
Login

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

Overview
Comment:If a ticket query begins with an underscore then:
  1. Do not include a link to execute the query directly
  2. 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 | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:6069602aba14bf74b8f48bd94f7b7e033ca752da
User & Date: jeremy_c 2010-01-09 13:11:18
Context
2010-01-09
18:32
Added a user configurable TH1 template for the ticket report list. check-in: 14253e9b user: jeremy_c tags: trunk
13:11
If a ticket query begins with an underscore then:
  1. Do not include a link to execute the query directly
  2. 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: 6069602a user: jeremy_c tags: trunk

12:35
Added the cgi() SQL function implemented by Brain Theado. check-in: 19f55279 user: jeremy_c tags: trunk
Changes
Hide Diffs Unified Diffs 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) ){