Bugzilla – Attachment 183901 Details for
Bug 35211
Make it possible to split holdings tab using library groups in intranet
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35211: Separate group holdings into individual tabs
Bug-35211-Separate-group-holdings-into-individual-.patch (text/plain), 10.36 KB, created by
Eric Garcia
on 2025-07-09 15:05:13 UTC
(
hide
)
Description:
Bug 35211: Separate group holdings into individual tabs
Filename:
MIME Type:
Creator:
Eric Garcia
Created:
2025-07-09 15:05:13 UTC
Size:
10.36 KB
patch
obsolete
>From 3b2bc8e9ac41d783d7221a0033b3e3bdbcc21010 Mon Sep 17 00:00:00 2001 >From: Eric Garcia <cubingguy714@gmail.com> >Date: Wed, 9 Jul 2025 14:50:32 +0000 >Subject: [PATCH] Bug 35211: Separate group holdings into individual tabs > >Added SeparateHoldingsByGroup system preference >Adds new tabs to Holdings table if preference is enabled >Separates by library groups >--- > catalogue/detail.pl | 40 +++++++++++++++++++ > .../bug_35211_separate_holdings_by_group.pl | 22 ++++++++++ > installer/data/mysql/mandatory/sysprefs.sql | 1 + > .../tables/items/catalogue_detail.inc | 19 +++++++++ > .../admin/preferences/cataloguing.pref | 7 +++- > .../prog/en/modules/catalogue/detail.tt | 19 ++++++++- > 6 files changed, 106 insertions(+), 2 deletions(-) > create mode 100755 installer/data/mysql/atomicupdate/bug_35211_separate_holdings_by_group.pl > >diff --git a/catalogue/detail.pl b/catalogue/detail.pl >index c6445d4a20..e85b9277e6 100755 >--- a/catalogue/detail.pl >+++ b/catalogue/detail.pl >@@ -60,6 +60,8 @@ use Koha::Reviews; > use Koha::SearchEngine::Search; > use Koha::SearchEngine::QueryBuilder; > use Koha::Serial::Items; >+use Koha::Library::Group; >+use Koha::Library::Groups; > > my $query = CGI->new(); > >@@ -335,6 +337,44 @@ if ( C4::Context->preference('SeparateHoldings') ) { > my $other_holdings_count = > $items_to_display->search( { $SeparateHoldingsBranch => { '!=' => C4::Context->userenv->{branch} } } )->count; > $template->param( other_holdings_count => $other_holdings_count ); >+ >+ if ( C4::Context->preference('SeparateHoldingsByGroup') ) { >+ my $branchcode = C4::Context->userenv->{branch}; >+ my @all_search_groups = Koha::Library::Groups->get_search_groups( { interface => 'staff' } ); >+ my @lib_groups; >+ my %branchcode_hash; >+ >+ foreach my $search_group (@all_search_groups) { >+ while ( my $group = $search_group->next ) { >+ my @all_libs = $group->all_libraries; >+ >+ # Check if library is in group >+ if ( grep { $_->branchcode eq $branchcode } @all_libs ) { >+ >+ # Get other libraries in group >+ my @other_libs = grep { $_->branchcode ne $branchcode } @all_libs; >+ my @libs_branchcodes; >+ >+ foreach my $lib (@other_libs) { >+ push @libs_branchcodes, $lib->branchcode; >+ } >+ >+ # Push logged in branchcode >+ push @libs_branchcodes, $branchcode; >+ >+ # Build group branchcode hash >+ $branchcode_hash{ $group->id } = \@libs_branchcodes; >+ >+ push @lib_groups, $group; >+ } >+ } >+ } >+ >+ $template->param( >+ lib_groups => \@lib_groups, >+ branchcodes => \%branchcode_hash, >+ ); >+ } > } > $template->param( > count => $all_items->count, # FIXME 'count' is used in catalog-strings.inc >diff --git a/installer/data/mysql/atomicupdate/bug_35211_separate_holdings_by_group.pl b/installer/data/mysql/atomicupdate/bug_35211_separate_holdings_by_group.pl >new file mode 100755 >index 0000000000..bc41cec5c1 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35211_separate_holdings_by_group.pl >@@ -0,0 +1,22 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "35211", >+ description => "", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ # Do you stuffs here >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) >+ VALUES ('SeparateHoldingsByGroup',NULL,'','Separate current branch holdings and holdings from libraries in the same group','YesNo') >+ } >+ ); >+ >+ # Other information >+ say_success( $out, "Added new system preference 'SeparateHoldingsByGroup'" ); >+ }, >+}; >diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql >index f9f419c39d..b3d0ae4ea1 100644 >--- a/installer/data/mysql/mandatory/sysprefs.sql >+++ b/installer/data/mysql/mandatory/sysprefs.sql >@@ -733,6 +733,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','free'), > ('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'), > ('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'), >+('SeparateHoldingsByGroup','0',NULL,'Separate current branch holdings and holdings from libraries in the same library groups','YesNo'), > ('SerialsDefaultEmailAddress', '', NULL, 'Default email address used as reply-to for notices sent by the serials module.', 'Free'), > ('SerialsDefaultReplyTo', '', NULL, 'Default email address that serials notices are sent from.', 'Free'), > ('SerialsSearchResultsLimit', NULL, NULL, 'Serials search results limit', 'integer'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/html_helpers/tables/items/catalogue_detail.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/html_helpers/tables/items/catalogue_detail.inc >index 67440510e6..323361d7c3 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/includes/html_helpers/tables/items/catalogue_detail.inc >+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/html_helpers/tables/items/catalogue_detail.inc >@@ -290,6 +290,17 @@ > holdings: "[% PROCESS 'build_table' tab="holdings" | collapse | $tojson %]", > otherholdings: "[% PROCESS 'build_table' tab="otherholdings" | collapse | $tojson %]", > }; >+ >+ const branchcodes = { >+ [% FOREACH key IN branchcodes.keys %] >+ "[% key | html %]": [ >+ [% FOREACH code IN branchcodes.$key %] >+ "[% code | html %]"[% UNLESS loop.last %], [% END %] >+ [% END %] >+ ][% UNLESS loop.last %], [% END %] >+ [% END %] >+ }; >+ > function build_items_table (tab_id, add_filters, dt_options, drawcallback) { > > let table_dt; >@@ -310,6 +321,14 @@ > let branch = '[% IF SeparateHoldingsBranch == 'homebranch' %]me.home_library_id[% ELSE %]me.holding_library_id[% END %]'; > if ( tab_id == 'holdings' ) { > default_filters[branch] = '[% Branches.GetLoggedInBranchcode() | html %]'; >+ } else if ( tab_id.includes('group_holdings') ) { >+ user_colvis[tab_id] = {}; >+ items_table_settings[tab_id] = [% TablesSettings.GetTableSettings('catalogue', 'detail','otherholdings_table','json') | $raw %]; >+ >+ const id = tab_id.replace("group_holdings_", ""); >+ >+ default_filters[branch] = branchcodes[id]; >+ > } else { > default_filters[branch] = { '!=': '[% Branches.GetLoggedInBranchcode() | html %]' }; > } >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref >index 9c62cae068..8965199497 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref >@@ -301,6 +301,11 @@ Cataloging: > homebranch: 'home library' > holdingbranch: 'holding library' > - "is the logged in user's library. The second tab will contain all other items." >+ - pref: SeparateHoldingsByGroup >+ choices: >+ 1: Separate >+ 0: "Don't separate" >+ - "holdings by library group in a third tab." > - > - pref: AlwaysShowHoldingsTableFilters > choices: >@@ -408,4 +413,4 @@ Cataloging: > - "<br/>" > - "All values of repeating tags and subfields will be printed with the given RIS tag." > - "<br/>" >- - "Use of TY ( record type ) as a key will <em>replace</em> the default TY with the field value of your choosing." >\ No newline at end of file >+ - "Use of TY ( record type ) as a key will <em>replace</em> the default TY with the field value of your choosing." >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >index 0fc818512a..871a3cf09d 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >@@ -332,6 +332,13 @@ > <span>Other holdings ([% other_holdings_count || 0 | html %])</span> > [% END %] > [% END %] >+ [% IF lib_groups %] >+ [% FOREACH group IN lib_groups %] >+ [% WRAPPER tab_item tabname="group_holdings_" _ group.id %] >+ <span>[% group.title | html %] - Group ()</span> >+ [% END %] >+ [% END %] >+ [% END %] > [% ELSE %] > [% WRAPPER tab_item tabname= "holdings" %] > <span>Holdings ([% items_to_display_count || 0 | html %])</span> >@@ -475,6 +482,12 @@ > [% WRAPPER tab_panel tabname="otherholdings" %] > [% PROCESS items_table tab="otherholdings" %] > [% END # /tab_panel %] >+ [% FOREACH group IN lib_groups %] >+ [% SET group_tab = "group_holdings_" _ group.id %] >+ [% WRAPPER tab_panel tabname=group_tab %] >+ [% PROCESS items_table tab=group_tab %] >+ [% END # /tab_panel %] >+ [% END %] > [% END %] > > [% IF ( MARCNOTES ) %] >@@ -1730,7 +1743,11 @@ > var bundle_lost_value = [% Koha.Preference('BundleLostValue') | html %]; > [% END %] > >- let items_tab_ids = [ 'holdings', 'otherholdings' ]; >+ let items_tab_ids = [ 'holdings', 'otherholdings' >+ [% FOREACH group IN lib_groups %] >+ , 'group_holdings_[% group.id | html %]' >+ [% END %] >+ ]; > items_tab_ids.forEach( function( tab_id, index ) { > > // Early return if the tab is not shown (ie. no table) >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 35211
:
183075
|
183099
|
183143
|
183144
|
183420
|
183615
|
183642
|
183643
|
183901
|
183945
|
183949
|
183950
|
183966
|
183967
|
183968
|
184016