Lines 62-67
my @debit_types =
Link Here
|
62 |
Koha::Account::DebitTypes->search()->as_list; |
62 |
Koha::Account::DebitTypes->search()->as_list; |
63 |
my @credit_types = |
63 |
my @credit_types = |
64 |
Koha::Account::CreditTypes->search()->as_list; |
64 |
Koha::Account::CreditTypes->search()->as_list; |
|
|
65 |
my $registerid; |
65 |
|
66 |
|
66 |
if ($do_it) { |
67 |
if ($do_it) { |
67 |
|
68 |
|
Lines 95-100
if ($do_it) {
Link Here
|
95 |
push @extra_params, $manager_branchcode; |
96 |
push @extra_params, $manager_branchcode; |
96 |
} |
97 |
} |
97 |
|
98 |
|
|
|
99 |
my $whereRegister = q{}; |
100 |
$registerid = $input->param("registerid"); |
101 |
if ($registerid) { |
102 |
$whereRegister = q{ AND al.register_id = ?}; |
103 |
push @extra_params, $registerid; |
104 |
} |
98 |
|
105 |
|
99 |
my $query = " |
106 |
my $query = " |
100 |
SELECT round(amount,2) AS amount, description, |
107 |
SELECT round(amount,2) AS amount, description, |
Lines 111-116
if ($do_it) {
Link Here
|
111 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
118 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
112 |
$whereTType |
119 |
$whereTType |
113 |
$whereBranchCode |
120 |
$whereBranchCode |
|
|
121 |
$whereRegister |
114 |
ORDER BY al.date |
122 |
ORDER BY al.date |
115 |
"; |
123 |
"; |
116 |
my $sth_stats = $dbh->prepare($query) or die "Unable to prepare query " . $dbh->errstr; |
124 |
my $sth_stats = $dbh->prepare($query) or die "Unable to prepare query " . $dbh->errstr; |
Lines 192-197
$template->param(
Link Here
|
192 |
branchloop => Koha::Libraries->search({}, { order_by => ['branchname'] })->unblessed, |
200 |
branchloop => Koha::Libraries->search({}, { order_by => ['branchname'] })->unblessed, |
193 |
debit_types => \@debit_types, |
201 |
debit_types => \@debit_types, |
194 |
credit_types => \@credit_types, |
202 |
credit_types => \@credit_types, |
|
|
203 |
registerid => $registerid, |
195 |
CGIsepChoice => GetDelimiterChoices, |
204 |
CGIsepChoice => GetDelimiterChoices, |
196 |
); |
205 |
); |
197 |
|
206 |
|
198 |
- |
|
|