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

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt (-1 / +5 lines)
Lines 245-251 Link Here
245
        <legend>Cell value</legend>
245
        <legend>Cell value</legend>
246
        <ol>
246
        <ol>
247
            <li>
247
            <li>
248
                <label for="cellvalue_items">Count total items</label>
248
                <label for="cellvalue_items">Count not deleted items</label>
249
                <input type="radio" name="Cellvalue" value="items" id="cellvalue_items" checked="checked" />
249
                <input type="radio" name="Cellvalue" value="items" id="cellvalue_items" checked="checked" />
250
            </li>
250
            </li>
251
            <li>
251
            <li>
Lines 256-261 Link Here
256
                <label for="cellvalue_deleteditems">Count deleted items</label>
256
                <label for="cellvalue_deleteditems">Count deleted items</label>
257
                <input type="radio" name="Cellvalue" value="deleteditems" id="cellvalue_deleteditems" />
257
                <input type="radio" name="Cellvalue" value="deleteditems" id="cellvalue_deleteditems" />
258
            </li>
258
            </li>
259
            <li>
260
                <label for="cellvalue_allitems">Count all items (deleted and not deleted)</label>
261
                <input type="radio" name="Cellvalue" value="allitems" id="cellvalue_allitems" />
262
            </li>
259
        </ol>
263
        </ol>
260
    </fieldset>
264
    </fieldset>
261
	
265
	
(-)a/reports/catalogue_stats.pl (-3 / +2 lines)
Lines 46-52 my $fullreportname = "reports/catalogue_stats.tt"; Link Here
46
my $do_it       = $input->param('do_it');
46
my $do_it       = $input->param('do_it');
47
my $line        = $input->param("Line");
47
my $line        = $input->param("Line");
48
my $column      = $input->param("Column");
48
my $column      = $input->param("Column");
49
my $cellvalue   = $input->param("Cellvalue"); # one of 'items', 'biblios'
49
my $cellvalue   = $input->param("Cellvalue"); # one of 'items', 'biblios', 'deleteditems', 'allitems'
50
my @filters     = $input->multi_param("Filter");
50
my @filters     = $input->multi_param("Filter");
51
my $cotedigits  = $input->param("cotedigits");
51
my $cotedigits  = $input->param("cotedigits");
52
my $output      = $input->param("output");
52
my $output      = $input->param("output");
Lines 175-181 sub calculate { Link Here
175
    my $itemstable = 'items';
175
    my $itemstable = 'items';
176
    my $deleted_where = "items.deleted_on IS NULL";
176
    my $deleted_where = "items.deleted_on IS NULL";
177
    $deleted_where = "1" if $cellvalue eq 'allitems';
177
    $deleted_where = "1" if $cellvalue eq 'allitems';
178
    $deleted_where = "items.deleted_on IS NOT NULL" if $cellvalue eq 'items';
178
    $deleted_where = "items.deleted_on IS NOT NULL" if $cellvalue eq 'deleteditems';
179
179
180
    my $dbh = C4::Context->dbh;
180
    my $dbh = C4::Context->dbh;
181
181
182
- 

Return to bug 20271