3 #script to administer the aqbudget table
5 # Copyright 2008-2009 BibLibre SARL
7 # This file is part of Koha.
9 # Koha is free software; you can redistribute it and/or modify it under the
10 # terms of the GNU General Public License as published by the Free Software
11 # Foundation; either version 2 of the License, or (at your option) any later
14 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License along with
19 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
20 # Suite 330, Boston, MA 02111-1307 USA
24 use List::Util qw/min/;
25 use Number::Format qw(format_price);
27 use C4::Auth qw/get_user_subpermissions/;
28 use C4::Branch; # GetBranches
29 use C4::Dates qw/format_date format_date_in_iso/;
33 use C4::Members; # calls GetSortDetails()
38 #use POSIX qw(locale_h);
41 my $dbh = C4::Context->dbh;
43 my ($template, $borrowernumber, $cookie, $staffflags ) = get_template_and_user(
44 { template_name => "admin/aqbudgets.tmpl",
48 flagsrequired => { acquisition => 'budget_manage' },
53 my $op = $input->param('op');
55 # see if the user want to see all budgets or only owned ones
56 my $show_mine = 1; #SHOW BY DEFAULT
57 my $show = $input->param('show'); # SET TO 1, BY A FORM SUMBIT
58 $show_mine = $input->param('show_mine') if $show == 1;
60 # IF USER DOESNT HAVE PERM FOR AN 'ADD', THEN REDIRECT TO THE DEFAULT VIEW...
61 if ( not defined $template->{param_map}->{'CAN_user_acquisition_budget_add_del'} && $op == 'add_form' ) {
65 my $cur = GetCurrency;
66 my $cur_format = C4::Context->preference("CurrencyFormat");
69 if ( $cur_format eq 'FR' ) {
70 $num = new Number::Format(
71 'decimal_fill' => '2',
72 'decimal_point' => ',',
73 'int_curr_symbol' => '',
74 'mon_thousands_sep' => ' ',
75 'thousands_sep' => ' ',
76 'mon_decimal_point' => ','
78 } else { # US by default..
79 $num = new Number::Format(
80 'int_curr_symbol' => '',
81 'mon_thousands_sep' => ',',
82 'mon_decimal_point' => '.'
86 my $script_name = "/cgi-bin/koha/admin/aqbudgets.pl";
87 my $budget_id = $input->param('budget_id');
88 my $budget_code = $input->param('budget_code');
89 my $budget_name = $input->param('budget_name');
90 my $budget_amount = $input->param('budget_amount');
91 my $budget_amount_sublevel = $input->param('budget_amount_sublevel');
92 my $budget_encumb = $input->param('budget_encumb');
93 my $budget_expend = $input->param('budget_expend');
94 my $budget_notes = $input->param('budget_notes');
95 my $sort1_authcat = $input->param('sort1_authcat');
96 my $sort2_authcat = $input->param('sort2_authcat');
97 my $budget_description = $input->param('budget_description');
98 my $budget_branchcode = $input->param('budget_branchcode');
99 my $budget_owner_id = $input->param('budget_owner_id');
100 my $budget_parent_id = $input->param('budget_parent_id');
101 my $budget_permission = $input->param('budget_permission');
102 my $budget_period_dropbox = $input->param('budget_period_dropbox');
103 my $filter_budgetname = $input->param('filter_budgetname');
104 my $filter_budgetbranch = $input->param('filter_budgetbranch');
106 # ' ------- get periods stuff ------------------'
107 # IF PERIODID IS DEFINED, GET THE PERIOD - ELSE JUST GET THE ACTIVE PERIOD BY DEFAULT
108 my $budget_period_id = $input->param('budget_period_id');
109 my $period = GetBudgetPeriod($budget_period_id);
110 my $budget_period_id = $period->{'budget_period_id'};
111 my $budget_period_locked = $period->{'budget_period_locked'};
112 my $budget_period_description = $period->{'budget_period_description'};
113 my $budget_period_total = $period->{'budget_period_total'};
116 budget_period_id => $budget_period_id,
117 budget_period_locked => $budget_period_locked,
118 budget_period_description => $budget_period_description,
120 # ------- get periods stuff ------------------
122 # USED FOR PERMISSION COMPARISON LATER
123 my $borrower_id = $template->{param_map}->{'USER_INFO'}[0]->{'borrowernumber'};
124 my $user = GetMemberDetails($borrower_id);
125 my $user_branchcode = $user->{'branchcode'};
128 action => $script_name,
129 script_name => $script_name,
130 show_mine => $show_mine,
136 my ( $budget, $period, $query, $sth );
138 my $branches = GetBranches;
140 foreach my $thisbranch (keys %$branches) {
142 value => $thisbranch,
143 branchname => $branches->{$thisbranch}->{'branchname'},
145 $row{selected} = 1 if $thisbranch eq $filter_budgetbranch;
146 push @branchloop2, \%row;
149 # Used to create form to add or modify a record
150 if ($op eq 'add_form') {
151 #### ------------------- ADD_FORM -------------------------
153 # if no buget_id is passed then its an add
154 # pass the period_id to build the dropbox - because we only want to show budgets from this period
155 my $dropbox_disabled;
156 if ( defined $budget_id ) { ### MOD
157 $budget = GetBudget($budget_id);
158 $dropbox_disabled = BudgetHasChildren($budget_id);
159 my $borrower = &GetMember( $budget->{budget_owner_id} );
160 $budget->{budget_owner_name} = $borrower->{'firstname'} . ' ' . $borrower->{'surname'};
163 # build budget hierarchy
166 my $hier = GetBudgetHierarchy($budget_period_id);
167 foreach my $r (@$hier) {
168 $r->{budget_code_indent} =~ s/ /\~/g; #
169 $labels{"$r->{budget_id}"} = $r->{budget_code_indent};
170 push @values, $r->{budget_id};
173 # if no buget_id is passed then its an add
174 my $budget_parent_dropbox;
175 my $budget_parent_id = $budget->{'budget_parent_id'} if $budget;
176 $budget_parent_dropbox = CGI::scrolling_list(
177 -name => 'budget_parent_id',
179 -default => $budget_parent_id ? $budget_parent_id : undef,
181 -style => "min-width:100px;",
185 # build branches select
186 my $branches = GetBranches;
187 my @branchloop_select;
188 foreach my $thisbranch ( keys %$branches ) {
190 value => $thisbranch,
191 branchname => $branches->{$thisbranch}->{'branchname'},
193 $row{selected} = 1 if $thisbranch eq $budget->{'budget_branchcode'};
194 push @branchloop_select, \%row;
197 # populates the YUI planning button
198 my $categories = GetAuthorisedValueCategories();
199 my @auth_cats_loop1 = ();
200 foreach my $category (@$categories) {
201 my $entry = { category => $category,
202 selected => $budget->{sort1_authcat} eq $category ?1:0,
204 push @auth_cats_loop1, $entry;
206 my @auth_cats_loop2 = ();
207 foreach my $category (@$categories) {
208 my $entry = { category => $category,
209 selected => $budget->{sort2_authcat} eq $category ?1:0,
211 push @auth_cats_loop2, $entry;
213 $template->param(authorised_value_categories1 => \@auth_cats_loop1);
214 $template->param(authorised_value_categories2 => \@auth_cats_loop2);
216 my $budget_perm_dropbox =
217 GetBudgetPermDropbox($budget->{'budget_permission'});
219 # if no buget_id is passed then its an add
222 dateformat => C4::Dates->new()->visual(),
223 budget_id => $budget->{'budget_id'},
224 budget_parent_id => $budget->{'budget_parent_id'},
225 budget_dropbox => $budget_dropbox,
226 budget_perm_dropbox => $budget_perm_dropbox,
227 budget_code => $budget->{'budget_code'},
228 budget_code_indent => $budget->{'budget_code_indent'},
229 budget_name => $budget->{'budget_name'},
230 budget_branchcode => $budget->{'budget_branchcode'},
231 budget_amount => sprintf("%.2f", $budget->{'budget_amount'}),
232 budget_amount_sublevel => sprintf("%.2f", $budget->{'budget_amount_sublevel'}),
233 budget_encumb => $budget->{'budget_encumb'},
234 budget_expend => $budget->{'budget_expend'},
235 budget_notes => $budget->{'budget_notes'},
236 budget_description => $budget->{'budget_description'},
237 budget_owner_id => $budget->{'budget_owner_id'},
238 budget_owner_name => $budget->{'budget_owner_name'},
239 budget_permission => $budget->{'budget_permission'},
240 budget_period_id => $budget_period_id,
241 budget_period_description => $budget_period_description,
242 branchloop_select => \@branchloop_select,
244 # END $OP eq ADD_FORM
245 #---------------------- DEFAULT DISPLAY BELOW ---------------------
247 # called by default form, used to confirm deletion of data in DB
248 } elsif ($op eq 'delete_confirm') {
250 my $budget = GetBudget($budget_id);
252 budget_id => $budget->{'budget_id'},
253 budget_code => $budget->{'budget_code'},
254 budget_name => $budget->{'budget_name'},
255 budget_amount => $num->format_price( $budget->{'budget_amount'} ),
257 # END $OP eq DELETE_CONFIRM
258 # called by delete_confirm, used to effectively confirm deletion of data in DB
260 if ( $op eq 'delete_confirmed' ) {
261 my $rc = DelBudget($budget_id);
263 if ( $op eq 'add_validate' ) {
265 budget_id => $budget_id,
266 budget_parent_id => $budget_parent_id,
267 budget_period_id => $budget_period_id,
268 budget_code => $budget_code,
269 budget_name => $budget_name,
270 budget_branchcode => $budget_branchcode,
271 budget_amount => $budget_amount,
272 budget_amount_sublevel => $budget_amount_sublevel,
273 budget_encumb => $budget_encumb,
274 budget_expend => $budget_expend,
275 budget_notes => $budget_notes,
276 sort1_authcat => $sort1_authcat,
277 sort2_authcat => $sort2_authcat,
278 budget_description => $budget_description,
279 budget_owner_id => $budget_owner_id,
280 budget_permission => $budget_permission,
282 if ( defined $budget_id ) {
283 ModBudget( \%budget_hash );
285 AddBudget( \%budget_hash );
288 my $branches = GetBranches();
289 my $budget_period_dropbox = GetBudgetPeriodsDropbox($budget_period_id );
291 budget_period_dropbox => $budget_period_dropbox,
292 budget_id => $budget_id,
293 budget_period_startdate => $period->{'budget_period_startdate'},
294 budget_period_enddate => $period->{'budget_period_enddate'},
296 my $moo = GetBudgetHierarchy($budget_period_id, $template->{param_map}->{'USER_INFO'}[0]->{'branchcode'}, $show_mine?$borrower_id:'');
297 my @budgets = @$moo; #FIXME
301 my $period_total = 0;
302 my ( $period_alloc_total, $base_alloc_total, $sub_alloc_total, $base_spent_total, $base_remaining_total );
304 foreach my $budget (@budgets) {
307 unless($staffflags->{'superlibrarian'} == 1 ) {
308 #IF NO PERMS, THEN DISABLE EDIT/DELETE
309 unless ( $template->{param_map}->{'CAN_user_acquisition_budget_modify'} ) {
310 $budget->{'budget_lock'} = 1;
312 # check budget permission
313 if ( $budget_period_locked == 1 ) {
314 $budget->{'budget_lock'} = 1;
316 } elsif ( $budget->{budget_permission} == 1 ) {
318 if ( $borrower_id != $budget->{'budget_owner_id'} ) {
319 $budget->{'budget_lock'} = 1;
321 # check parent perms too
322 my $parents_perm = 0;
323 if ( $budget->{depth} > 0 ) {
324 $parents_perm = CheckBudgetParentPerm( $budget, $borrower_id );
325 delete $budget->{'budget_lock'} if $parents_perm == '1';
327 } elsif ( $budget->{budget_permission} == 2 ) {
329 $budget->{'budget_lock'} = 1 if $user_branchcode ne $budget->{budget_branchcode};
333 # if a budget search doesnt match, next
334 if ($filter_budgetname ) {
335 next unless $budget->{budget_code} =~ m/$filter_budgetname/ ||
336 $budget->{name} =~ m/$filter_budgetname/ ;
338 if ($filter_budgetbranch ) {
339 next unless $budget->{budget_branchcode} =~ m/$filter_budgetbranch/;
343 # adds to total - only if budget is a 'top-level' budget
344 $period_alloc_total += $budget->{'budget_amount_total'} if $budget->{'depth'} == 0;
345 $base_alloc_total += $budget->{'budget_amount'};
346 $sub_alloc_total += $budget->{'budget_amount_sublevel'};
347 $base_spent_total += $budget->{'budget_spent'};
348 $budget->{'budget_remaining'} = $budget->{'budget_amount'} - $budget->{'budget_spent'};
349 $base_remaining_total += $budget->{'budget_remaining'};
351 # if amount == 0 dont display...
352 delete $budget->{'budget_unalloc_sublevel'} if $budget->{'budget_unalloc_sublevel'} == 0 ;
353 delete $budget->{'budget_amount_sublevel'} if $budget->{'budget_amount_sublevel'} == 0 ;
355 $budget->{'remaining_pos'} = 1 if $budget->{'budget_remaining'} > 0;
356 $budget->{'remaining_neg'} = 1 if $budget->{'budget_remaining'} < 0;
357 $budget->{'budget_amount'} = $num->format_price( $budget->{'budget_amount'} );
358 $budget->{'budget_spent'} = $num->format_price( $budget->{'budget_spent'} );
359 $budget->{'budget_remaining'} = $num->format_price( $budget->{'budget_remaining'} );
360 $budget->{'budget_amount_total'} = $num->format_price( $budget->{'budget_amount_total'} );
361 $budget->{'budget_amount_sublevel'} = $num->format_price( $budget->{'budget_amount_sublevel'} ) if defined $budget->{'budget_amount_sublevel'};
362 $budget->{'budget_unalloc_sublevel'} = $num->format_price( $budget->{'budget_unalloc_sublevel'} ) if defined $budget->{'budget_unalloc_sublevel'};
364 my $borrower = &GetMember( $budget->{budget_owner_id} );
365 $budget->{budget_owner_name} = $borrower->{'firstname'} . ' ' . $borrower->{'surname'};
366 $budget->{budget_borrowernumber} = $borrower->{'borrowernumber'};
368 push( @loop, { %{$budget},
369 toggle => $toggle++%2,
370 branchname => $branches->{ $budget->{branchcode} }->{branchname},
371 startdate => format_date($budget->{startdate}),
372 enddate => format_date($budget->{enddate}),
380 budget_period_total => $num->format_price($budget_period_total),
381 period_alloc_total => $num->format_price($period_alloc_total),
382 base_alloc_total => $num->format_price($base_alloc_total),
383 sub_alloc_total => $num->format_price($sub_alloc_total),
384 base_spent_total => $num->format_price($base_spent_total),
385 base_remaining_total => $num->format_price($base_remaining_total),
386 period_remaining_total => $num->format_price( $period_alloc_total - $base_alloc_total ),
387 branchloop => \@branchloop2,
388 cur => $cur->{symbol},
389 cur_format => $cur_format,
392 } #---- END $OP eq DEFAULT
394 output_html_with_http_headers $input, $cookie, $template->output;