#
# COPYRIGHT:
#
-# This software is Copyright (c) 1996-2011 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2018 Best Practical Solutions, LLC
# <sales@bestpractical.com>
#
# (Except where explicitly superseded by other copyright notices)
#
# END BPS TAGGED BLOCK }}}
-# Autogenerated by DBIx::SearchBuilder factory (by <jesse@bestpractical.com>)
-# WARNING: THIS FILE IS AUTOGENERATED. ALL CHANGES TO THIS FILE WILL BE LOST.
-#
-# !! DO NOT EDIT THIS FILE !!
-#
+package RT::ObjectCustomFieldValues;
use strict;
+use warnings;
+use 5.010;
+use base 'RT::SearchBuilder';
-=head1 NAME
-
- RT::ObjectCustomFieldValues -- Class Description
-
-=head1 SYNOPSIS
-
- use RT::ObjectCustomFieldValues
+use RT::ObjectCustomFieldValue;
-=head1 DESCRIPTION
+# Set up the OCFV cache for faster comparison on add/update
+our $_OCFV_CACHE;
+ClearOCFVCache();
+sub Table { 'ObjectCustomFieldValues'}
-=head1 METHODS
+sub _Init {
+ my $self = shift;
-=cut
+ # By default, order by SortOrder
+ $self->OrderByCols(
+ { ALIAS => 'main',
+ FIELD => 'SortOrder',
+ ORDER => 'ASC' },
+ { ALIAS => 'main',
+ FIELD => 'id',
+ ORDER => 'ASC' },
+ );
-package RT::ObjectCustomFieldValues;
+ return ( $self->SUPER::_Init(@_) );
+}
-use RT::SearchBuilder;
-use RT::ObjectCustomFieldValue;
+=head2 ClearOCFVCache
-use vars qw( @ISA );
-@ISA= qw(RT::SearchBuilder);
+Cleans out and reinitializes the OCFV cache
+=cut
-sub _Init {
- my $self = shift;
- $self->{'table'} = 'ObjectCustomFieldValues';
- $self->{'primary_key'} = 'id';
+sub ClearOCFVCache {
+ $_OCFV_CACHE = {}
+}
+# {{{ sub LimitToCustomField
+=head2 LimitToCustomField FIELD
- # By default, order by SortOrder
- $self->OrderByCols(
- { ALIAS => 'main',
- FIELD => 'SortOrder',
- ORDER => 'ASC' },
- { ALIAS => 'main',
- FIELD => 'id',
- ORDER => 'ASC' },
- );
+Limits the returned set to values for the custom field with Id FIELD
- return ( $self->SUPER::_Init(@_) );
+=cut
+
+sub LimitToCustomField {
+ my $self = shift;
+ my $cf = shift;
+ return $self->Limit(
+ FIELD => 'CustomField',
+ VALUE => $cf,
+ );
}
-=head2 NewItem
-Returns an empty new RT::ObjectCustomFieldValue item
+=head2 LimitToObject OBJECT
+
+Limits the returned set to values for the given OBJECT
=cut
-sub NewItem {
+sub LimitToObject {
my $self = shift;
- return(RT::ObjectCustomFieldValue->new($self->CurrentUser));
+ my $object = shift;
+ $self->Limit(
+ FIELD => 'ObjectType',
+ VALUE => ref($object),
+ );
+ return $self->Limit(
+ FIELD => 'ObjectId',
+ VALUE => $object->Id,
+ );
+
}
-RT::Base->_ImportOverlays();
-=head1 SEE ALSO
-This class allows "overlay" methods to be placed
-into the following files _Overlay is for a System overlay by the original author,
-_Vendor is for 3rd-party vendor add-ons, while _Local is for site-local customizations.
+=head2 HasEntry CONTENT LARGE_CONTENT
+
+If this collection has an entry with content that eq CONTENT and large content
+that eq LARGE_CONTENT then returns the entry, otherwise returns undef.
+
+=cut
-These overlay files can contain new subs or subs to replace existing subs in this module.
-Each of these files should begin with the line
+sub HasEntry {
+ my $self = shift;
+ my $value = shift;
+ my $large_content = shift;
+ return undef unless defined $value && length $value;
+
+ my $first = $self->First;
+ return undef unless $first; # No entries to check
+
+ # Key should be the same for all values of the same ocfv
+ my $ocfv_key = $first->GetOCFVCacheKey;
+
+ # This cache relieves performance issues when adding large numbers of values
+ # to a CF since each add compares against the full list each time.
+
+ unless ( $_OCFV_CACHE->{$ocfv_key} ) {
+ # Load the cache with existing values
+ foreach my $item ( @{$self->ItemsArrayRef} ) {
+ push @{$_OCFV_CACHE->{$ocfv_key}}, {
+ 'ObjectId' => $item->Id,
+ 'CustomFieldObj' => $item->CustomFieldObj,
+ 'Content' => $item->_Value('Content'),
+ 'LargeContent' => $item->LargeContent };
+ }
+ }
+
+ my %canon_value;
+ my $item_id;
+ foreach my $item ( @{$_OCFV_CACHE->{$ocfv_key}} ) {
+ my $cf = $item->{'CustomFieldObj'};
+ my $args = $canon_value{ $cf->Type };
+ if ( !$args ) {
+ $args = { Content => $value, LargeContent => $large_content };
+ my ($ok, $msg) = $cf->_CanonicalizeValue( $args );
+ next unless $ok;
+ $canon_value{ $cf->Type } = $args;
+ }
+
+ if ( $cf->Type eq 'Select' ) {
+ # select is case insensitive
+ $item_id = $item->{'ObjectId'} if lc $item->{'Content'} eq lc $args->{Content};
+ }
+ else {
+ if ( ($item->{'Content'} // '') eq $args->{Content} ) {
+ if ( defined $item->{'LargeContent'} ) {
+ $item_id = $item->{'ObjectId'}
+ if defined $args->{LargeContent}
+ && $item->{'LargeContent'} eq $args->{LargeContent};
+ }
+ else {
+ $item_id = $item->{'ObjectId'} unless defined $args->{LargeContent};
+ }
+ } elsif ( $item->{'LargeContent'} && $args->{Content} ) {
+ $item_id = $item->{'ObjectId'} if ($item->{'LargeContent'} eq $args->{Content});
+ }
+ }
+ last if $item_id;
+ }
+
+ if ( $item_id ) {
+ my $ocfv = RT::ObjectCustomFieldValue->new( $self->CurrentUser );
+ my ($ret, $msg) = $ocfv->Load($item_id);
+ RT::Logger->error("Unable to load object custom field value from id: $item_id $msg")
+ unless $ret;
+ return $ocfv;
+ }
+ else {
+ return undef;
+ }
+}
- no warnings qw(redefine);
+sub _DoSearch {
+ my $self = shift;
+
+ # unless we really want to find disabled rows,
+ # make sure we're only finding enabled ones.
+ unless ( $self->{'find_expired_rows'} ) {
+ $self->LimitToEnabled();
+ }
+
+ return $self->SUPER::_DoSearch(@_);
+}
-so that perl does not kick and scream when you redefine a subroutine or variable in your overlay.
+sub _DoCount {
+ my $self = shift;
+
+ # unless we really want to find disabled rows,
+ # make sure we're only finding enabled ones.
+ unless ( $self->{'find_expired_rows'} ) {
+ $self->LimitToEnabled();
+ }
+
+ return $self->SUPER::_DoCount(@_);
+}
-RT::ObjectCustomFieldValues_Overlay, RT::ObjectCustomFieldValues_Vendor, RT::ObjectCustomFieldValues_Local
+RT::Base->_ImportOverlays();
-=cut
+# Clear the OCVF cache on exit to release connected RT::Ticket objects.
+#
+# Without this, there could be warnings generated like "Too late to safely run
+# transaction-batch scrips...". You can test this by commenting it out and running
+# some cf tests, e.g. perl -Ilib t/customfields/enter_one.t
+END { ClearOCFVCache(); }
1;