use Koha::AuthorisedValue;
use Koha::MarcSubfieldStructures;
+use Koha::Cache::Memory::Lite;
use base qw(Koha::Objects);
my $frameworkcode = $params->{frameworkcode} || '';
my $kohafield = $params->{kohafield};
my $category = $params->{category};
- my $authorised_value = $params->{authorised_value};
return unless $kohafield;
{ 'marc_subfield_structures.frameworkcode' => $frameworkcode,
'marc_subfield_structures.kohafield' => $kohafield,
( defined $category ? ( category_name => $category ) : () ),
- ( $authorised_value ? ( authorised_value => $authorised_value ) : () ),
},
{ join => { category => 'marc_subfield_structures' },
distinct => 1,
);
}
+sub find_by_koha_field {
+ my ( $self, $params ) = @_;
+ my $frameworkcode = $params->{frameworkcode} || '';
+ my $kohafield = $params->{kohafield};
+ my $authorised_value = $params->{authorised_value};
+
+ my $av = $self->SUPER::search(
+ { 'marc_subfield_structures.frameworkcode' => $frameworkcode,
+ 'marc_subfield_structures.kohafield' => $kohafield,
+ 'me.authorised_value' => $authorised_value,
+ },
+ { join => { category => 'marc_subfield_structures' },
+ distinct => 1,
+ }
+ );
+ return $av->count ? $av->next : undef;
+}
+
+sub get_description_by_koha_field {
+ my ( $self, $params ) = @_;
+ my $frameworkcode = $params->{frameworkcode} || '';
+ my $kohafield = $params->{kohafield};
+ my $authorised_value = $params->{authorised_value};
+
+ return {} unless defined $authorised_value;
+
+ my $memory_cache = Koha::Cache::Memory::Lite->get_instance;
+ my $cache_key = "AV_descriptions:$frameworkcode:$kohafield:$authorised_value";
+ my $cached = $memory_cache->get_from_cache($cache_key);
+ return $cached if $cached;
+
+ my $av = $self->find_by_koha_field($params);
+ return {} unless defined $av;
+ my $descriptions = { lib => $av->lib, opac_description => $av->opac_description };
+ $memory_cache->set_in_cache( $cache_key, $descriptions );
+ return $descriptions;
+}
+
+sub get_descriptions_by_koha_field {
+ my ( $self, $params ) = @_;
+ my $frameworkcode = $params->{frameworkcode} || '';
+ my $kohafield = $params->{kohafield};
+
+ my $memory_cache = Koha::Cache::Memory::Lite->get_instance;
+ my $cache_key = "AV_descriptions:$frameworkcode:$kohafield";
+ my $cached = $memory_cache->get_from_cache($cache_key);
+ return @$cached if $cached;
+
+ my @avs = $self->search_by_koha_field($params);
+ my @descriptions = map {
+ {
+ authorised_value => $_->authorised_value,
+ lib => $_->lib,
+ opac_description => $_->opac_description
+ }
+ } @avs;
+ $memory_cache->set_in_cache( $cache_key, \@descriptions );
+ return @descriptions;
+}
+
sub categories {
my ( $self ) = @_;
my $rs = $self->_resultset->search(