|
Lines 111-117
$dbh->do(q|
Link Here
|
| 111 |
INSERT INTO overduerules |
111 |
INSERT INTO overduerules |
| 112 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
112 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
| 113 |
VALUES |
113 |
VALUES |
| 114 |
( '', '', 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
114 |
( NULL, NULL, 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
| 115 |
|); |
115 |
|); |
| 116 |
|
116 |
|
| 117 |
my @branchcodes = map { $_->branchcode } Koha::Libraries->search->as_list; |
117 |
my @branchcodes = map { $_->branchcode } Koha::Libraries->search->as_list; |
|
Lines 123-129
$dbh->do(q|
Link Here
|
| 123 |
INSERT INTO overduerules |
123 |
INSERT INTO overduerules |
| 124 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
124 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
| 125 |
VALUES |
125 |
VALUES |
| 126 |
( 'CPL', '', 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
126 |
( 'CPL', NULL, 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
| 127 |
|); |
127 |
|); |
| 128 |
|
128 |
|
| 129 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
129 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
|
Lines 134-140
$dbh->do(q|
Link Here
|
| 134 |
INSERT INTO overduerules |
134 |
INSERT INTO overduerules |
| 135 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
135 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
| 136 |
VALUES |
136 |
VALUES |
| 137 |
( 'CPL', '', 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
137 |
( 'CPL', NULL, 1, 'LETTER_CODE1', 1, 5, 'LETTER_CODE2', 1, 10, 'LETTER_CODE3', 1 ) |
| 138 |
|); |
138 |
|); |
| 139 |
|
139 |
|
| 140 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
140 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
|
Lines 145-152
$dbh->do(q|
Link Here
|
| 145 |
INSERT INTO overduerules |
145 |
INSERT INTO overduerules |
| 146 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
146 |
( branchcode,categorycode, delay1,letter1,debarred1, delay2,letter2,debarred2, delay3,letter3,debarred3 ) |
| 147 |
VALUES |
147 |
VALUES |
| 148 |
( 'CPL', '', 1, 'LETTER_CODE1_CPL', 1, 5, 'LETTER_CODE2_CPL', 1, 10, 'LETTER_CODE3_CPL', 1 ), |
148 |
( 'CPL', NULL, 1, 'LETTER_CODE1_CPL', 1, 5, 'LETTER_CODE2_CPL', 1, 10, 'LETTER_CODE3_CPL', 1 ), |
| 149 |
( 'MPL', '', 1, 'LETTER_CODE1_MPL', 1, 5, 'LETTER_CODE2_MPL', 1, 10, 'LETTER_CODE3_MPL', 1 ) |
149 |
( 'MPL', NULL, 1, 'LETTER_CODE1_MPL', 1, 5, 'LETTER_CODE2_MPL', 1, 10, 'LETTER_CODE3_MPL', 1 ) |
| 150 |
|); |
150 |
|); |
| 151 |
|
151 |
|
| 152 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
152 |
@overdue_branches = C4::Overdues::GetBranchcodesWithOverdueRules(); |
| 153 |
- |
|
|