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

(-)a/C4/Items.pm (-1 / +1 lines)
Lines 997-1003 sub GetLostItems { Link Here
997
997
998
    my $query   = "
998
    my $query   = "
999
        SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch,
999
        SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch,
1000
               itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber
1000
               itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber, itemcallnumber
1001
        FROM   items
1001
        FROM   items
1002
            LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber)
1002
            LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber)
1003
            LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber)
1003
            LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber)
(-)a/admin/columns_settings.yml (+31 lines)
Lines 21-23 modules: Link Here
21
          columnname: active
21
          columnname: active
22
        -
22
        -
23
          columnname: actions
23
          columnname: actions
24
  reports:
25
    lostitems:
26
      lostitems-table:
27
        -
28
          columnname: title
29
          cannot_be_toggled: 1
30
          cannot_be_modified: 1
31
        -
32
          columnname: author
33
        -
34
          columnname: lostcode
35
        -
36
          columnname: barcode
37
        -
38
          columnname: callnumber
39
        -
40
          columnname: datelastseen
41
        -
42
          columnname: price
43
        -
44
          columnname: replacementprice
45
        -
46
          columnname: library
47
        -
48
          columnname: itemtype
49
        -
50
          columnname: current_location
51
        -
52
          columnname: location
53
        -
54
          columnname: notes
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/columns_settings.tt (+7 lines)
Lines 143-148 Link Here
143
            <h4>Circulation tables</h4>
143
            <h4>Circulation tables</h4>
144
            [% PROCESS pagelist module=modules.circ modulename="circ" %]
144
            [% PROCESS pagelist module=modules.circ modulename="circ" %]
145
          </div>
145
          </div>
146
147
          <h3><a href="#reports">Reports</a></h3>
148
          <div id="reports">
149
            <h4>Reports tables</h4>
150
            [% PROCESS pagelist module=modules.reports modulename="reports" %]
151
          </div>
152
146
        </div>
153
        </div>
147
      </div>
154
      </div>
148
    </div>
155
    </div>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/itemslost.tt (-41 / +66 lines)
Lines 1-6 Link Here
1
[% USE Branches %]
2
[% USE ColumnsSettings %]
1
[% INCLUDE 'doc-head-open.inc' %]
3
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Lost items</title>
4
<title>Koha &rsaquo; Reports &rsaquo; Lost items</title>
3
[% INCLUDE 'doc-head-close.inc' %]
5
[% INCLUDE 'doc-head-close.inc' %]
6
<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
7
[% INCLUDE 'datatables.inc' %]
8
[% INCLUDE 'columns_settings.inc' %]
9
<script type='text/javascript'>
10
//<![CDATA[
11
    $(document).ready(function() {
12
        var columns_settings = [% ColumnsSettings.GetColumns( 'reports', 'lostitems', 'lostitems-table', 'json' ) %];
13
        var lostitems_table = KohaTable("#lostitems-table", {
14
            "sDom": 'C<"clearfix">t',
15
            "aaSorting": [],
16
            "aoColumnDefs": [
17
                { "aTargets": [ -1 ], "bSortable": false, "bSearchable": false },
18
                { "sType": "title-string", "aTargets" : [ "title-string" ] }
19
            ],
20
            "bPaginate": false,
21
        }, columns_settings);
22
23
    });
24
//]]>
25
</script>
26
4
</head>
27
</head>
5
<body id="rep_itemslost" class="rep">
28
<body id="rep_itemslost" class="rep">
6
[% INCLUDE 'header.inc' %]
29
[% INCLUDE 'header.inc' %]
Lines 26-72 Link Here
26
    [% END %]
49
    [% END %]
27
</div>
50
</div>
28
51
29
    [% IF ( itemsloop ) %]<table>
52
    [% IF itemsloop %]
30
    <tr>
53
        <table id="lostitems-table">
31
        <th>Title</th>
54
            <thead>
32
        <th>Author</th>
55
                <tr>
33
        <th>Lost code</th>
56
                    <th>Title</th>
34
        <th>Barcode</th>
57
                    <th>Author</th>
35
        <th>Date last seen</th>
58
                    <th>Lost code</th>
36
        <th>Price</th>
59
                    <th>Barcode</th>
37
        <th>Rep.price</th>
60
                    <th>Call number</th>
38
        <th>Library</th>
61
                    <th>Date last seen</th>
39
        <th>Item type</th>
62
                    <th>Price</th>
40
        <th>Current location</th>
63
                    <th>Rep.price</th>
41
        <th>Location</th>
64
                    <th>Library</th>
42
        <th>Notes</th>
65
                    <th>Item type</th>
43
    </tr>
66
                    <th>Current location</th>
44
     [% FOREACH itemsloo IN itemsloop %]
67
                    <th>Location</th>
45
        [% UNLESS ( loop.odd ) %]
68
                    <th>Notes</th>
46
        <tr class="highlight">
69
                </tr>
47
        [% ELSE %]
70
            </thead>
48
        <tr>
71
            <tbody>
49
        [% END %]
72
                [% FOREACH itemsloo IN itemsloop %]
50
            <td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% itemsloo.biblionumber %]" title="[% itemsloo.itemnotes %]">
73
                    <tr>
51
						  [% itemsloo.title |html %]
74
                        <td>
52
					 </a></td>
75
                            <a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% itemsloo.biblionumber %]" title="[% itemsloo.itemnotes %]">[% itemsloo.title |html %]</a>
53
            <td>[% itemsloo.author %]</td>
76
                        </td>
54
            <td>[% itemsloo.lib %]</td>
77
                        <td>[% itemsloo.author %]</td>
55
            <td><a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% itemsloo.biblionumber %]" title="[% itemsloo.itemnotes %]">
78
                        <td>[% itemsloo.lib %]</td>
56
                    [% itemsloo.barcode %]
79
                        <td>
57
                </a></td>
80
                            <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% itemsloo.biblionumber %]" title="[% itemsloo.itemnotes %]">[% itemsloo.barcode %]</a>
58
            <td>[% itemsloo.datelastseen %]</td>
81
                        </td>
59
            <td>[% itemsloo.price %]</td>
82
                        <td>[% itemsloo.itemcallnumber %]</td>
60
            <td>[% itemsloo.replacementprice %]</td>
83
                        <td>[% itemsloo.datelastseen %]</td>
61
            <td>[% itemsloo.homebranch %]</td>
84
                        <td>[% itemsloo.price %]</td>
62
            <td>[% IF ( itemsloo.itype_level ) %][% itemsloo.itype %][% ELSE %][% itemsloo.itemtype %][% END %]</td>
85
                        <td>[% itemsloo.replacementprice %]</td>
63
            <td>[% itemsloo.holdingbranch %]</td>
86
                        <td>[% Branches.GetName(itemsloo.homebranch) %]</td>
64
            <td>[% itemsloo.location %]</td>
87
                        <td>[% IF ( itemsloo.itype_level ) %][% itemsloo.itype %][% ELSE %][% itemsloo.itemtype %][% END %]</td>
65
            <td>[% itemsloo.itemnotes %]</td>
88
                        <td>[% Branches.GetName(itemsloo.holdingbranch) %]</td>
66
        </tr>
89
                        <td>[% itemsloo.location %]</td>
90
                        <td>[% itemsloo.itemnotes %]</td>
91
                    </tr>
92
                [% END %]
93
            </tbody>
94
        </table>
67
    [% END %]
95
    [% END %]
68
    </table>
69
	[% END %] 
70
	[% ELSE %]
96
	[% ELSE %]
71
	
97
	
72
	<form name="f" action="/cgi-bin/koha/reports/itemslost.pl" method="post">
98
	<form name="f" action="/cgi-bin/koha/reports/itemslost.pl" method="post">
73
- 

Return to bug 13372