|
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 |