View | Details | Raw Unified | Return to bug 5931
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tmpl (-9 / +58 lines)
Lines 19-24 Link Here
19
<style type="text/css">
19
<style type="text/css">
20
    #sql { width: 90%; height: 9em;}
20
    #sql { width: 90%; height: 9em;}
21
</style>
21
</style>
22
<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/jquery/plugins/jquery.tablesorter.min.js"></script>
23
<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/jquery/plugins/jquery.tablesorter.pager.js"></script>
24
22
<script type="text/javascript">
25
<script type="text/javascript">
23
//<![CDATA[
26
//<![CDATA[
24
$(document).ready(function(){
27
$(document).ready(function(){
Lines 38-43 $(document).ready(function(){ Link Here
38
        }
41
        }
39
    });
42
    });
40
<!-- /TMPL_IF -->
43
<!-- /TMPL_IF -->
44
  // call the tablesorter plugin
45
  $("#table_reports").tablesorter({
46
    sortList: [[1,0]],
47
    headers: {
48
       6: { sorter: false},
49
       7: { sorter: false},
50
       8: { sorter: false},
51
       9: { sorter: false},
52
      10: { sorter: false}
53
    }
54
  }).tablesorterPager({
55
    container:     $("#pagertable_reports"),
56
    positionFixed: false,
57
    size:          50
58
  });
41
});
59
});
42
//]]>
60
//]]>
43
</script>
61
</script>
Lines 106-114 canned reports and writing custom SQL reports.</p> Link Here
106
<!-- TMPL_IF NAME="saved1" -->
124
<!-- TMPL_IF NAME="saved1" -->
107
<!-- TMPL_IF NAME="savedreports" --><h1>Saved Reports</h1>
125
<!-- TMPL_IF NAME="savedreports" --><h1>Saved Reports</h1>
108
<p>Choose the report to run from the list</p>
126
<p>Choose the report to run from the list</p>
109
<form action="/cgi-bin/koha/reports/guided_reports.pl">
127
110
<table>
128
<span id="pagertable_reports" class="pager">
111
<tr><th>ID</th><th>Report Name</th><th>Type</th><th>Notes</th><th>Author</th><th>Creation Date</th><th>Saved Results</th><th>Saved SQL</th><th colspan="3">&nbsp;</th></tr>
129
 <form class="formpager">&nbsp;<strong>page(s)</strong>&nbsp;:
130
  <img src="<!-- TMPL_VAR name="interface" -->/prog/img/first.png" class="first"/>
131
  <img src="<!-- TMPL_VAR name="interface" -->/prog/img/prev.png" class="prev"/>
132
  <input type="text" size="5" class="pagedisplay"/>
133
  <img src="<!-- TMPL_VAR name="interface" -->/prog/img/next.png" class="next"/>
134
  <img src="<!-- TMPL_VAR name="interface" -->/prog/img/last.png" class="last"/>
135
  , entries/page:
136
  <select class="pagesize">
137
   <option value="10">10</option>
138
   <option value="25" selected="selected">25</option>
139
   <option value="50">50</option>
140
   <option value="100">100</option>
141
   <option value="200">200</option>
142
  </select>
143
 </form>
144
</span>
145
146
<table id="table_reports" class="tablesorter">
147
<thead>
148
 <tr>
149
  <th>ID</th>
150
  <th>Report Name</th>
151
  <th>Type</th>
152
  <th>Notes</th>
153
  <th>Author</th>
154
  <th>Creation Date</th>
155
  <th>Saved Results</th>
156
  <th>Saved SQL</th>
157
  <th>&nbsp;</th>
158
  <th>&nbsp;</th>
159
 </tr>
160
</thead>
161
<tbody>
112
<!-- TMPL_LOOP NAME="savedreports" -->
162
<!-- TMPL_LOOP NAME="savedreports" -->
113
<!-- TMPL_UNLESS NAME="__odd__" --><tr class="highlight"><!-- TMPL_ELSE --><tr><!-- /TMPL_UNLESS -->
163
<!-- TMPL_UNLESS NAME="__odd__" --><tr class="highlight"><!-- TMPL_ELSE --><tr><!-- /TMPL_UNLESS -->
114
<td><!-- TMPL_VAR NAME="id" --></td>
164
<td><!-- TMPL_VAR NAME="id" --></td>
Lines 120-139 canned reports and writing custom SQL reports.</p> Link Here
120
<td><!-- TMPL_IF NAME="date_run" --><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="date_run" --></a><!-- /TMPL_IF -->
170
<td><!-- TMPL_IF NAME="date_run" --><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="date_run" --></a><!-- /TMPL_IF -->
121
</td>
171
</td>
122
    <td>
172
    <td>
123
        <a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Show%20SQL">Show SQL</a> 
173
        <a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Show%20SQL">Show</a> 
124
        <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
174
        <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
125
            &nbsp; <a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Edit%20SQL">Edit SQL</a>
175
            &nbsp; <a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Edit%20SQL">Edit</a>
126
        <!-- /TMPL_IF -->
176
        <!-- /TMPL_IF -->
127
    </td>
177
    </td>
128
<td><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Run%20this%20report">Run</a></td>
178
<td><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Run%20this%20report">Run</a>
129
<td><a href="/cgi-bin/koha/tools/scheduler.pl?id=<!-- TMPL_VAR NAME="id" -->">Schedule</a></td>
179
<a href="/cgi-bin/koha/tools/scheduler.pl?id=<!-- TMPL_VAR NAME="id" -->">Schedule</a></td>
130
    <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
180
    <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
131
        <td><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Delete%20Saved">Delete</a></td>
181
        <td><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&amp;phase=Delete%20Saved">Delete</a></td>
132
    <!-- /TMPL_IF -->
182
    <!-- /TMPL_IF -->
133
</tr>
183
</tr>
134
<!-- /TMPL_LOOP -->
184
<!-- /TMPL_LOOP -->
185
</tbody>
135
</table>
186
</table>
136
</form>
137
<!-- TMPL_ELSE --><h4>There are no saved reports. 
187
<!-- TMPL_ELSE --><h4>There are no saved reports. 
138
    <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
188
    <!-- TMPL_IF name="CAN_user_reports_create_reports" -->
139
        <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build new?</a>
189
        <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build new?</a>
140
- 

Return to bug 5931