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

(-)a/C4/Reports/Guided.pm (-10 / +19 lines)
Lines 92-109 my %table_areas = ( Link Here
92
    CAT  => [ 'items', 'biblioitems', 'biblio' ],
92
    CAT  => [ 'items', 'biblioitems', 'biblio' ],
93
    PAT  => ['borrowers'],
93
    PAT  => ['borrowers'],
94
    ACQ  => [ 'aqorders', 'biblio', 'items' ],
94
    ACQ  => [ 'aqorders', 'biblio', 'items' ],
95
    ACC  => [ 'borrowers', 'accountlines' ],
95
    ACC  => [ 'borrowers', 'account_credits', 'account_debits' ],
96
);
96
);
97
my %keys = (
97
my %keys = (
98
    CIRC => [ 'statistics.borrowernumber=borrowers.borrowernumber',
98
    CIRC => [
99
              'items.itemnumber = statistics.itemnumber',
99
        'statistics.borrowernumber=borrowers.borrowernumber',
100
              'biblioitems.biblioitemnumber = items.biblioitemnumber' ],
100
        'items.itemnumber = statistics.itemnumber',
101
    CAT  => [ 'items.biblioitemnumber=biblioitems.biblioitemnumber',
101
        'biblioitems.biblioitemnumber = items.biblioitemnumber'
102
              'biblioitems.biblionumber=biblio.biblionumber' ],
102
    ],
103
    PAT  => [],
103
    CAT => [
104
    ACQ  => [ 'aqorders.biblionumber=biblio.biblionumber',
104
        'items.biblioitemnumber=biblioitems.biblioitemnumber',
105
              'biblio.biblionumber=items.biblionumber' ],
105
        'biblioitems.biblionumber=biblio.biblionumber'
106
    ACC  => ['borrowers.borrowernumber=accountlines.borrowernumber'],
106
    ],
107
    PAT => [],
108
    ACQ => [
109
        'aqorders.biblionumber=biblio.biblionumber',
110
        'biblio.biblionumber=items.biblionumber'
111
    ],
112
    ACC => [
113
        'borrowers.borrowernumber=account_credits.borrowernumber',
114
        'borrowers.borrowernumber=account_debits.borrowernumber'
115
    ],
107
);
116
);
108
117
109
# have to do someting here to know if its dropdown, free text, date etc
118
# have to do someting here to know if its dropdown, free text, date etc
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt (-19 lines)
Lines 108-131 Link Here
108
108
109
<h3>DB table value for reports</h3>
109
<h3>DB table value for reports</h3>
110
110
111
<p><strong>Question:</strong> What do the codes in the accounttype field in the accountlines table stand for?</p>
112
113
<p><strong>Answer:</strong></p>
114
115
<ul>
116
	<li>A = Account management fee</li>
117
	<li>C = Credit</li>
118
	<li>F = Overdue fine</li>
119
	<li>FOR = Forgiven</li>
120
	<li>FU = Overdue, still acccruing</li>
121
	<li>L = Lost item</li>
122
	<li>LR = Lost item returned/refunded</li>
123
	<li>M = Sundry</li>
124
	<li>N = New card</li>
125
	<li>PAY = Payment</li>
126
	<li>W = Writeoff</li>
127
</ul>
128
129
<p><strong>Question:</strong> What are the possible codes for the type field in the statistics table?</p>
111
<p><strong>Question:</strong> What are the possible codes for the type field in the statistics table?</p>
130
112
131
<p><strong>Answer:</strong></p>
113
<p><strong>Answer:</strong></p>
132
- 

Return to bug 6427