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 |