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

(-)a/C4/Items.pm (-1 / +1 lines)
Lines 1034-1040 sub GetItemsForInventory { Link Here
1034
    my ( @bind_params, @where_strings );
1034
    my ( @bind_params, @where_strings );
1035
1035
1036
    my $select_columns = q{
1036
    my $select_columns = q{
1037
        SELECT items.itemnumber, barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, stocknumber
1037
        SELECT items.itemnumber, barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber
1038
    };
1038
    };
1039
    my $select_count = q{SELECT COUNT(*)};
1039
    my $select_count = q{SELECT COUNT(*)};
1040
    my $query = q{
1040
    my $query = q{
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt (+4 lines)
Lines 246-251 $(document).ready(function(){ Link Here
246
            <th>Status</th>
246
            <th>Status</th>
247
            <th>Lost</th>
247
            <th>Lost</th>
248
            <th>Damaged</th>
248
            <th>Damaged</th>
249
            <th>Withdrawn</th>
249
            <th>Unseen since</th>
250
            <th>Unseen since</th>
250
            <th>Problems</th>
251
            <th>Problems</th>
251
        </tr>
252
        </tr>
Lines 278-283 $(document).ready(function(){ Link Here
278
            [% result.damaged | html %]
279
            [% result.damaged | html %]
279
            </td>
280
            </td>
280
            <td>
281
            <td>
282
            [% result.withdrawn | html %]
283
            </td>
284
            <td>
281
            [% result.datelastseen | $KohaDates | html %]
285
            [% result.datelastseen | $KohaDates | html %]
282
            </td>
286
            </td>
283
            <td>
287
            <td>
(-)a/tools/inventory.pl (-3 / +2 lines)
Lines 345-351 if (defined $input->param('CSVexport') && $input->param('CSVexport') eq 'on'){ Link Here
345
                      items.homebranch     items.location
345
                      items.homebranch     items.location
346
                      items.itemcallnumber items.notforloan
346
                      items.itemcallnumber items.notforloan
347
                      items.itemlost       items.damaged
347
                      items.itemlost       items.damaged
348
                      items.stocknumber
348
                      items.withdrawn      items.stocknumber
349
                      / ) {
349
                      / ) {
350
       push @translated_keys, $columns_def_hashref->{$key};
350
       push @translated_keys, $columns_def_hashref->{$key};
351
    }
351
    }
Lines 354-360 if (defined $input->param('CSVexport') && $input->param('CSVexport') eq 'on'){ Link Here
354
    $csv->combine(@translated_keys);
354
    $csv->combine(@translated_keys);
355
    print $csv->string, "\n";
355
    print $csv->string, "\n";
356
356
357
    my @keys = qw / title author barcode itemnumber homebranch location itemcallnumber notforloan lost damaged stocknumber /;
357
    my @keys = qw / title author barcode itemnumber homebranch location itemcallnumber notforloan lost damaged withdrawn stocknumber /;
358
    for my $item ( @results ) {
358
    for my $item ( @results ) {
359
        my @line;
359
        my @line;
360
        for my $key (@keys) {
360
        for my $key (@keys) {
361
- 

Return to bug 12909