4 use Test::More tests => 16;
8 use DateTime::Duration;
15 use t::lib::TestBuilder;
17 my $schema = Koha::Database->new->schema;
18 $schema->storage->txn_begin;
19 my $dbh = C4::Context->dbh;
21 my $builder = t::lib::TestBuilder->new;
24 my $library = $builder->build( { source => 'Branch' })->{branchcode};
25 my $library2 = $builder->build( { source => 'Branch' })->{branchcode};
27 my $frameworkcode = ''; # Use Default for Koha to MARC mappings
29 DELETE FROM marc_subfield_structure
30 WHERE ( kohafield = 'items.new_status' OR kohafield = 'items.stocknumber' )
32 |, undef, $frameworkcode);
34 my $new_tagfield = 'i';
36 INSERT INTO marc_subfield_structure(tagfield, tagsubfield, kohafield, frameworkcode)
37 VALUES ( 952, ?, 'items.new_status', ? )
38 |, undef, $new_tagfield, $frameworkcode);
41 my $cache = Koha::Caches->get_instance();
42 $cache->clear_from_cache("MarcStructure-0-$frameworkcode");
43 $cache->clear_from_cache("MarcStructure-1-$frameworkcode");
44 $cache->clear_from_cache("default_value_for_mod_marc-");
45 $cache->clear_from_cache("MarcSubfieldStructure-$frameworkcode");
47 my $record = MARC::Record->new();
48 $record->append_fields(
49 MARC::Field->new('100', ' ', ' ', a => 'Moffat, Steven'),
50 MARC::Field->new('245', ' ', ' ', a => 'Silence in the library'),
51 MARC::Field->new('942', ' ', ' ', c => 'ITEMTYPE_T'),
53 my ($biblionumber, undef) = C4::Biblio::AddBiblio($record, $frameworkcode);
55 my ($item_bibnum, $item_bibitemnum, $itemnumber) = C4::Items::AddItem(
57 homebranch => $library,
58 holdingbranch => $library,
59 new_status => 'new_value',
65 my $item = Koha::Items->find( $itemnumber );
66 is ( $item->new_status, 'new_value', q|AddItem insert the 'new_status' field| );
68 my ( $tagfield, undef ) = GetMarcFromKohaField('items.itemnumber', $frameworkcode);
69 my $marc_item = C4::Items::GetMarcItem( $biblionumber, $itemnumber );
70 is( $marc_item->subfield($tagfield, $new_tagfield), 'new_value', q|Koha mapping is correct|);
72 # Update the items.new_status field if items.ccode eq 'FIC' => should be updated
77 field => 'items.ccode',
83 field => 'items.new_status',
84 value => 'updated_value',
91 C4::Items::ToggleNewStatus( { rules => \@rules } );
93 my $modified_item = Koha::Items->find( $itemnumber );
94 is( $modified_item->new_status, 'updated_value', q|ToggleNewStatus: The new_status value is updated|);
95 $marc_item = C4::Items::GetMarcItem( $biblionumber, $itemnumber );
96 is( $marc_item->subfield($tagfield, $new_tagfield), 'updated_value', q|ToggleNewStatus: The new_status value is updated| );
98 # Update the items.new_status field if items.ccode eq 'DONT_EXIST' => should not be updated
103 field => 'items.ccode',
104 value => 'DONT_EXIST',
109 field => 'items.new_status',
110 value => 'new_updated_value',
117 C4::Items::ToggleNewStatus( { rules => \@rules } );
119 $modified_item = Koha::Items->find( $itemnumber );
120 is( $modified_item->new_status, 'updated_value', q|ToggleNewStatus: The new_status value is not updated|);
121 $marc_item = C4::Items::GetMarcItem( $biblionumber, $itemnumber );
122 is( $marc_item->subfield($tagfield, $new_tagfield), 'updated_value', q|ToggleNewStatus: The new_status value is not updated| );
125 my $dt_today = dt_from_string;
126 my $days5ago = $dt_today->add_duration( DateTime::Duration->new( days => -5 ) );
128 C4::Items::ModItem( { dateaccessioned => $days5ago }, $biblionumber, $itemnumber );
134 field => 'items.ccode',
140 field => 'items.new_status',
141 value => 'new_updated_value',
147 C4::Items::ToggleNewStatus( { rules => \@rules } );
148 $modified_item = Koha::Items->find( $itemnumber );
149 is( $modified_item->new_status, 'updated_value', q|ToggleNewStatus: Age = 10 : The new_status value is not updated|);
151 $rules[0]->{age} = 5;
152 $rules[0]->{substitutions}[0]{value} = 'new_updated_value5';
153 C4::Items::ToggleNewStatus( { rules => \@rules } );
154 $modified_item = Koha::Items->find( $itemnumber );
155 is( $modified_item->new_status, 'new_updated_value5', q|ToggleNewStatus: Age = 5 : The new_status value is updated|);
157 $rules[0]->{age} = '';
158 $rules[0]->{substitutions}[0]{value} = 'new_updated_value_empty_string';
159 C4::Items::ToggleNewStatus( { rules => \@rules } );
160 $modified_item = Koha::Items->find( $itemnumber );
161 is( $modified_item->new_status, 'new_updated_value_empty_string', q|ToggleNewStatus: Age = '' : The new_status value is updated|);
163 $rules[0]->{age} = undef;
164 $rules[0]->{substitutions}[0]{value} = 'new_updated_value_undef';
165 C4::Items::ToggleNewStatus( { rules => \@rules } );
166 $modified_item = Koha::Items->find( $itemnumber );
167 is( $modified_item->new_status, 'new_updated_value_undef', q|ToggleNewStatus: Age = undef : The new_status value is updated|);
174 field => 'items.ccode',
180 field => 'items.new_status',
188 C4::Items::ToggleNewStatus( { rules => \@rules } );
190 $modified_item = Koha::Items->find( $itemnumber );
191 is( $modified_item->new_status, '', q|ToggleNewStatus: The new_status value is empty|);
192 $marc_item = C4::Items::GetMarcItem( $biblionumber, $itemnumber );
193 is( $marc_item->subfield($tagfield, $new_tagfield), undef, q|ToggleNewStatus: The new_status field is removed from the item marc| );
195 # conditions multiple
200 field => 'items.ccode',
204 field => 'items.homebranch',
210 field => 'items.new_status',
211 value => 'new_value',
218 C4::Items::ToggleNewStatus( { rules => \@rules } );
220 $modified_item = Koha::Items->find( $itemnumber );
221 is( $modified_item->new_status, 'new_value', q|ToggleNewStatus: conditions multiple: all match, the new_status value is updated|);
227 field => 'items.ccode',
231 field => 'items.homebranch',
232 value => 'DONT_EXIST',
237 field => 'items.new_status',
238 value => 'new_updated_value',
245 C4::Items::ToggleNewStatus( { rules => \@rules } );
247 $modified_item = Koha::Items->find( $itemnumber );
248 is( $modified_item->new_status, 'new_value', q|ToggleNewStatus: conditions multiple: at least 1 condition does not match, the new_status value is not updated|);
254 field => 'items.ccode',
258 field => 'items.homebranch',
259 value => "$library|$library2",
264 field => 'items.new_status',
265 value => 'new_updated_value',
272 C4::Items::ToggleNewStatus( { rules => \@rules } );
274 $modified_item = Koha::Items->find( $itemnumber );
275 is( $modified_item->new_status, 'new_updated_value', q|ToggleNewStatus: conditions multiple: the 2 conditions match, the new_status value is updated|);
281 field => 'biblioitems.itemtype',
282 value => 'ITEMTYPE_T',
287 field => 'items.new_status',
288 value => 'another_new_updated_value',
295 C4::Items::ToggleNewStatus( { rules => \@rules } );
297 $modified_item = Koha::Items->find( $itemnumber );
298 is( $modified_item->new_status, 'another_new_updated_value', q|ToggleNewStatus: conditions on biblioitems|);
301 $cache = Koha::Caches->get_instance();
302 $cache->clear_from_cache("MarcStructure-0-$frameworkcode");
303 $cache->clear_from_cache("MarcStructure-1-$frameworkcode");
304 $cache->clear_from_cache("default_value_for_mod_marc-");
305 $cache->clear_from_cache("MarcSubfieldStructure-$frameworkcode");