View | Details | Raw Unified | Return to bug 8117
Collapse All | Expand All

(-)a/admin/aqbudgetperiods.pl (-21 / +52 lines)
Lines 72-78 my $budget_period_hashref= $input->Vars; Link Here
72
#my $sort1_authcat = $input->param('sort1_authcat');
72
#my $sort1_authcat = $input->param('sort1_authcat');
73
#my $sort2_authcat = $input->param('sort2_authcat');
73
#my $sort2_authcat = $input->param('sort2_authcat');
74
74
75
my $pagesize    = 20;
75
my $activepagesize = 20;
76
my $inactivepagesize = 20;
76
$searchfield =~ s/\,//g;
77
$searchfield =~ s/\,//g;
77
78
78
my ($template, $borrowernumber, $cookie, $staff_flags ) = get_template_and_user(
79
my ($template, $borrowernumber, $cookie, $staff_flags ) = get_template_and_user(
Lines 245-271 elsif ( $op eq 'duplicate_budget' ){ Link Here
245
# DEFAULT - DISPLAY AQPERIODS TABLE
246
# DEFAULT - DISPLAY AQPERIODS TABLE
246
# -------------------------------------------------------------------
247
# -------------------------------------------------------------------
247
# display the list of budget periods
248
# display the list of budget periods
248
    my $results = GetBudgetPeriods();
249
	$template->param( period_button_only => 1 ) unless (@$results) ;
250
    my $page = $input->param('page') || 1;
251
    my $first = ( $page - 1 ) * $pagesize;
252
    # if we are on the last page, the number of the last word to display
253
    # must not exceed the length of the results array
254
    my $last = min( $first + $pagesize - 1, scalar @{$results} - 1, );
255
    my $toggle = 0;
256
    my @period_loop;
257
    foreach my $result ( @{$results}[ $first .. $last ] ) {
258
        my $budgetperiod = $result;
259
		FormatData($budgetperiod);
260
        $budgetperiod->{'budget_period_total'}     = $num->format_price( $budgetperiod->{'budget_period_total'} );
261
        $budgetperiod->{budget_active} = 1;
262
        push( @period_loop, $budgetperiod );
263
    }
264
249
265
    $template->param(
250
my $activepage = $input->param('apage') || 1;
266
        period_loop           => \@period_loop,
251
my $inactivepage = $input->param('ipage') || 1;
267
		pagination_bar		  => pagination_bar("aqbudgetperiods.pl",getnbpages(scalar(@$results),$pagesize),$page),
252
# Get active budget periods
268
    );
253
my $results = GetBudgetPeriods(
254
    {budget_period_active => 1},
255
    [{budget_period_description => 0}]
256
);
257
my $first = ( $activepage - 1 ) * $activepagesize;
258
my $last = min( $first + $activepagesize - 1, scalar @{$results} - 1, );
259
my @period_active_loop;
260
261
foreach my $result ( @{$results}[ $first .. $last ] ) {
262
    my $budgetperiod = $result;
263
    FormatData($budgetperiod);
264
    $budgetperiod->{'budget_period_total'}     = $num->format_price( $budgetperiod->{'budget_period_total'} );
265
    $budgetperiod->{budget_active} = 1;
266
    push( @period_active_loop, $budgetperiod );
267
}
268
my $url = "aqbudgetperiods.pl";
269
$url .=  "?ipage=$inactivepage" if($inactivepage != 1);
270
my $active_pagination_bar = pagination_bar ($url, getnbpages( scalar(@$results), $activepagesize), $activepage, "apage");
271
272
# Get inactive budget periods
273
$results = GetBudgetPeriods(
274
    {budget_period_active => 0},
275
    [{budget_period_enddate => 1}]
276
);
277
my $first = ( $inactivepage - 1 ) * $inactivepagesize;
278
my $last = min( $first + $inactivepagesize - 1, scalar @{$results} - 1, );
279
my @period_inactive_loop;
280
foreach my $result ( @{$results}[ $first .. $last ] ) {
281
    my $budgetperiod = $result;
282
    FormatData($budgetperiod);
283
    $budgetperiod->{'budget_period_total'} = $num->format_price( $budgetperiod->{'budget_period_total'} );
284
    $budgetperiod->{budget_active} = 1;
285
    push( @period_inactive_loop, $budgetperiod );
286
}
287
$url = "aqbudgetperiods.pl?tab=2";
288
$url .= "&apage=$activepage" if($activepage != 1);
289
my $inactive_pagination_bar = pagination_bar ($url, getnbpages( scalar(@$results), $inactivepagesize), $inactivepage, "ipage");
290
291
my $tab = $input->param('tab') ? $input->param('tab') - 1 : 0;
292
$template->param(
293
    period_active_loop      => \@period_active_loop,
294
    period_inactive_loop    => \@period_inactive_loop,
295
    active_pagination_bar   => $active_pagination_bar,
296
    inactive_pagination_bar => $inactive_pagination_bar,
297
    tab                     => $tab,
298
    dateformat              => C4::Context->preference('dateformat'),
299
);
269
300
270
$template->param($op=>1);
301
$template->param($op=>1);
271
output_html_with_http_headers $input, $cookie, $template->output;
302
output_html_with_http_headers $input, $cookie, $template->output;
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/aqbudgetperiods.tt (-52 / +120 lines)
Lines 1-9 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
2
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
5
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.min.js"></script>
6
[% INCLUDE 'datatables-strings.inc' %]
7
<script type="text/javascript" src="[% themelang %]/js/datatables.js"></script>
5
<script type="text/javascript" src="[% themelang %]/js/acq.js"></script>
8
<script type="text/javascript" src="[% themelang %]/js/acq.js"></script>
6
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.tablesorter.min.js"></script>
7
<script type="text/javascript">
9
<script type="text/javascript">
8
// #################################################################################
10
// #################################################################################
9
// Javascript
11
// Javascript
Lines 70-82 Link Here
70
                    alert(alertString2);
72
                    alert(alertString2);
71
            }
73
            }
72
    }
74
    }
73
	$(document).ready(function() {
75
74
		 $("#periodsh").tablesorter({
76
75
	            widgets : ['zebra'],
77
76
	            sortList: [[0,0]],
78
    [% IF ( dateformat == 'metric' ) %]
77
	            headers:  {6:{sorter:false}}
79
        dt_add_type_uk_date();
78
	     });
80
    [% END %]
79
	});
81
    $(document).ready(function() {
82
        var tabs = $('#budgetsTabs > ul').tabs();
83
        [% IF ( tab ) %]
84
            tabs.tabs('select', [% tab %]);
85
        [% END %]
86
        $("table").dataTable($.extend(true, {}, dataTablesDefaults, {
87
            "aoColumnDefs": [
88
                {
89
                    [% IF ( dateformat == 'metric' ) %]
90
                        "aTargets": [ 1, 2 ], "sType": "uk_date",
91
                    [% END %]
92
                    "bSortable": false, 'aTargets':['_all'],
93
                },
94
            ],
95
            "sPaginationType": "four_button",
96
            "bAutoWidth": false,
97
            "bPaginate": false,
98
            "bInfo": false,
99
            "bFilter": false,
100
        } ) );
101
    });
80
</script>
102
</script>
81
103
82
<title>
104
<title>
Lines 327-374 Link Here
327
[% END %]
349
[% END %]
328
<!--  DEFAULT  display budget periods list -->
350
<!--  DEFAULT  display budget periods list -->
329
[% IF ( else ) %]
351
[% IF ( else ) %]
330
    <h2>Budgets administration</h2>
352
  <h2>Budgets administration</h2>
331
353
332
    [% INCLUDE 'budgets-active-currency.inc' %]
354
  [% INCLUDE 'budgets-active-currency.inc' %]
333
355
334
    <table id="periodsh">
356
  <div id="budgetsTabs" class="toptabs">
335
    <thead>
357
    <ul>
336
	    <tr>
358
        <li><a href="/cgi-bin/koha/admin/aqbudgetperiods.pl#active">Active Budgets</a></li>
337
            <th>Budget name</th>
359
        <li><a href="/cgi-bin/koha/admin/aqbudgetperiods.pl#inactive">Inactive Budgets</a></li>
338
            <th>Start date</th>
360
    </ul>
339
            <th>End date</th>
361
340
	        <th>Active</th>
362
    <div id="active">
341
	        <th>Locked</th>
363
      <h3>Active Budgets</h3>
342
	        <th>Total</th>
364
      <table id="activeperiodst">
343
	        <th>Actions</th>
365
        <thead>
344
	    </tr>
366
          <tr>
345
	</thead>
367
            <th>Budget Name</th>
346
	<tbody>
368
            <th>Start Date</th>
347
	    [% FOREACH period_loo IN period_loop %]
369
            <th>End Date</th>
348
	        [% IF ( loop.odd ) %]
370
            <th>Locked</th>
349
	            <tr>
371
            <th>Total</th>
350
	        [% ELSE %]
372
            <th>Actions</th>
351
	            <tr class="highlight">
373
          </tr>
352
	        [% END %]
374
        </thead>
353
	        <td><a href="/cgi-bin/koha/admin/aqbudgets.pl?budget_period_id=[% period_loo.budget_period_id %]" title="View funds for [% period_loo.budget_period_description %]">[% period_loo.budget_period_description %]</a></td>
375
        <tbody>
354
	        <td>[% period_loo.budget_period_startdate %]</td>
376
            [% FOREACH period_active IN period_active_loop %]
355
	        <td>[% period_loo.budget_period_enddate %]</td>
377
              <tr>
356
	        <td>[% IF ( period_loo.budget_period_active ) %]<span style="color:green;">Active</span>&nbsp;[% ELSE %][% END %] </td>
378
              <td><a href="/cgi-bin/koha/admin/aqbudgets.pl?budget_period_id=[% period_active.budget_period_id %]" title="View funds for [% period_active.budget_period_description %]">[% period_active.budget_period_description %]</a></td>
357
	        <td> [% IF ( period_loo.budget_period_locked ) %]<span style="color:green;">Locked</span>&nbsp;[% ELSE %][% END %] </td>
379
              <td>[% period_active.budget_period_startdate %]</td>
358
	        <td align='right'>[% period_loo.budget_period_total %]</td>
380
              <td>[% period_active.budget_period_enddate %]</td>
359
	        <td>
381
              <td>
360
	            <a href="[% period_loo.script_name %]?op=add_form&amp;budget_period_id=[% period_loo.budget_period_id |html %]">Edit</a>
382
                [% IF ( period_active.budget_period_locked ) %]
361
	            <a href="[% period_loo.script_name %]?op=delete_confirm&amp;budget_period_id=[% period_loo.budget_period_id %]">Delete</a>
383
                  <span style="color:green;">Locked</span>&nbsp;
362
            <a href="/cgi-bin/koha/admin/aqbudgets.pl?op=add_form&amp;budget_period_id=[% period_loo.budget_period_id %]">Add fund</a>
384
                [% END %]
363
	        </td>
385
              </td>
364
	        </tr>
386
              <td align='right'>[% period_active.budget_period_total %]</td>
365
	    [% END %]
387
              <td>
366
	    [% UNLESS ( period_loop ) %]
388
                <a href="[% script_name %]?op=add_form&amp;budget_period_id=[% period_active.budget_period_id |html %]">Edit</a>
367
    	<tr><td colspan="7">No budget</td></tr>
389
                <a href="[% script_name %]?op=delete_confirm&amp;budget_period_id=[% period_active.budget_period_id %]">Delete</a>
368
    	[% END %]
390
                <a href="/cgi-bin/koha/admin/aqbudgets.pl?op=add_form&amp;budget_period_id=[% period_active.budget_period_id %]">Add Fund</a>
369
    </tbody>
391
              </td>
370
    </table>
392
              </tr>
371
    <div class="pages">[% pagination_bar %]</div>
393
            [% END %]
394
            [% UNLESS ( period_active_loop ) %]
395
              <tr><td colspan="7">No budget</td></tr>
396
            [% END %]
397
        </tbody>
398
      </table>
399
      <div class="paginationBar">[% active_pagination_bar %]</div>
400
    </div>
401
    <div id="inactive">
402
      <h3>Inactive Budgets</h3>
403
      <table id="inactiveperiodst">
404
        <thead>
405
            <tr>
406
                <th>Budget name</th>
407
                <th>Start date</th>
408
                <th>End date</th>
409
                <th>Locked</th>
410
                <th>Total</th>
411
                <th>Actions</th>
412
            </tr>
413
        </thead>
414
        <tbody>
415
            [% FOREACH period_loo IN period_inactive_loop %]
416
                [% IF ( loop.odd ) %]
417
                    <tr>
418
                [% ELSE %]
419
                    <tr class="highlight">
420
                [% END %]
421
                <td><a href="/cgi-bin/koha/admin/aqbudgets.pl?budget_period_id=[% period_loo.budget_period_id %]" title="View funds for [% period_loo.budget_period_description %]">[% period_loo.budget_period_description %]</a></td>
422
                <td>[% period_loo.budget_period_startdate %]</td>
423
                <td>[% period_loo.budget_period_enddate %]</td>
424
                <td> [% IF ( period_loo.budget_period_locked ) %]<span style="color:green;">Locked</span>&nbsp;[% ELSE %][% END %] </td>
425
                <td align='right'>[% period_loo.budget_period_total %]</td>
426
                <td>
427
                    <a href="[% period_loo.script_name %]?op=add_form&amp;budget_period_id=[% period_loo.budget_period_id |html %]">Edit</a>
428
                    <a href="[% period_loo.script_name %]?op=delete_confirm&amp;budget_period_id=[% period_loo.budget_period_id %]">Delete</a>
429
                <a href="/cgi-bin/koha/admin/aqbudgets.pl?op=add_form&amp;budget_period_id=[% period_loo.budget_period_id %]">Add fund</a>
430
                </td>
431
                </tr>
432
            [% END %]
433
            [% UNLESS ( period_inactive_loop ) %]
434
            <tr><td colspan="7">No budget</td></tr>
435
            [% END %]
436
        </tbody>
437
      </table>
438
      <div class="pages">[% inactive_pagination_bar %]</div>
439
    </div>
440
  </div>
372
[% END %]
441
[% END %]
373
442
374
443
375
- 

Return to bug 8117